Improve admin's published nodes interface: list of all scheduled nodes

Hello!

Today is the last day I go to my phpmyadmin to look sceduler table when my ~ 100 scheduled nodes will publish. :) I wrote some code to view them alltogether in slicky html table, with dates to publish/unpublish and so on. Screenshot. Well, I think, it would be great to embed this table to the Shedule admin interface (admin/settings/scheduler), may be, display link to this table as tab.

At the moment, I simply create a block, select the "PHP" format filter, an copy-paste the following code to block, and tune it to display only in the admin area. I am not patching the module.

and here is the code:

<?php
$output = '';

$sql = "SELECT s.nid AS nid, n.title AS title, s.publish_on AS publish_on, s.unpublish_on AS unpublish_on, s.timezone AS timezone FROM  {scheduler} AS s, {node} AS n WHERE s.nid = n.nid";
//ORDER BY s.publish_on ASC ";

//prepare the table header
$header = array(
  array('data' => 'nid', 'field' => 'nid'),
  array('data' => t('Title'), 'field' => 'title'),
  array('data' => t('Publish on'), 'field' => 'publish_on', 'sort' => 'asc'),
  array('data' => t('Unpublish on'), 'field' => 'unpublish_on'),
  array('data' => t('Timezone'), 'field' => 'timezone'),
);

//execute table query
$sql .= tablesort_sql($header);
$res = pager_query($sql, 50, 0, NULL, $keys);

//get the total keywords count
global $pager_total_items;
$output .= t('<strong>Total scheduled nodes count: %c</strong><br />', array('%c'=>$pager_total_items[0]));

//prepare the table rows
$rows = array();
$destination = drupal_get_destination();
while ($row = db_fetch_object($res)) {
  $row = array(
    check_plain($row->nid),
    $row->title,
    $row->publish_on ? format_date($row->publish_on) : t('No'),
    $row->unpublish_on ? format_date($row->unpublish_on) : t('No'),
    $row->timezone,
  );
  $rows[] = $row;
}

if (empty($rows)) {
  $empty_message = $keys ? t('No published nodes found.') : t('No published nodes available.') ;
  $rows[] = array(array('data' => $empty_message, 'colspan' => (2)));
}

$output .= theme('table', $header, $rows);
$output .= theme('pager', NULL, 50, 0);

echo $output;
?>

Have a nice day! ;)