Show a list of all new posts

Exisiting Blocks or similar things only show active topics, or recent posts. Nothing useful for a forum.

I build something to show me a list of topics, where new comments are included, with a link to jump directly there (to be precise, it's the last page)

1. The view (can be imported on the views section)

$view = new stdClass();
  $view->name = 'forumTracker';
  $view->description = 'Shows all new Forumposts';
  $view->access = array (
  0 => '2',
);
  $view->view_args_php = '';
  $view->page = TRUE;
  $view->page_title = 'Forum - New Posts';
  $view->page_header = 'To mark everything as read, use the "mark as read"-link on <a href="forum">Forums</a>!';
  $view->page_header_format = '1';
  $view->page_footer = '';
  $view->page_footer_format = '1';
  $view->page_empty = '';
  $view->page_empty_format = '1';
  $view->page_type = 'table';
  $view->url = 'forum/forumTracker';
  $view->use_pager = TRUE;
  $view->nodes_per_page = '25';
  $view->menu = TRUE;
  $view->menu_title = 'New Posts';
  $view->menu_tab = FALSE;
  $view->menu_tab_weight = '0';
  $view->menu_tab_default = FALSE;
  $view->menu_tab_default_parent = NULL;
  $view->menu_tab_default_parent_type = 'tab';
  $view->menu_parent_tab_weight = '0';
  $view->menu_parent_title = '';
  $view->sort = array (
    array (
      'tablename' => 'node_comment_statistics',
      'field' => 'last_comment_timestamp',
      'sortorder' => 'DESC',
      'options' => 'normal',
    ),
  );
  $view->argument = array (
  );
  $view->field = array (
    array (
      'tablename' => 'node',
      'field' => 'title',
      'label' => 'Title',
      'handler' => 'views_handler_field_nodelink_with_mark',
      'sortable' => '1',
      'options' => 'link',
    ),
    array (
      'tablename' => 'users',
      'field' => 'name',
      'label' => 'Author',
      'sortable' => '1',
    ),
    array (
      'tablename' => 'node_comment_statistics',
      'field' => 'comment_count',
      'label' => 'Answers',
      'handler' => 'views_handler_comments_with_new',
    ),
    array (
      'tablename' => 'node_comment_statistics',
      'field' => 'last_comment_timestamp',
      'label' => 'Last Post',
      'handler' => 'views_handler_field_since',
      'sortable' => '1',
      'defaultsort' => 'ASC',
    ),
  );
  $view->filter = array (
    array (
      'tablename' => 'node',
      'field' => 'status',
      'operator' => '=',
      'options' => '',
      'value' => '1',
    ),
    array (
      'tablename' => 'node',
      'field' => 'type',
      'operator' => 'OR',
      'options' => '',
      'value' => array (
  0 => 'forum',
),
    ),
    array (
      'tablename' => 'history',
      'field' => 'timestamp',
      'operator' => '0',
      'options' => '',
      'value' => array (
  0 => '0',
),
    ),
  );
  $view->exposed_filter = array (
  );
  $view->requires = array(node_comment_statistics, node, users, history);
  $views[$view->name] = $view;

2. Modify the template.php from your theme to get the "new"-Link jumping to the last page instead of the first one:
(from http://drupal.org/node/154084 )
therefore we modify the link to fit our needs.

function phptemplate_views_view_table_forumTracker($view, $nodes, $type) {
  $fields = _views_get_fields();
  $comments_per_page = _comment_get_display_setting('comments_per_page');

  foreach ($nodes as $node) {
    $row = array();
    foreach ($view->field as $field) {
      if ($fields[$field['id']]['visible'] !== FALSE) {
		if($field['field'] == 'comment_count')
		{
  		    $count = db_result(db_query('SELECT COUNT(c.cid) FROM {comments} c WHERE c.nid=%d', $node->nid));
		    // Find the ending point. The pager URL is always 1 less than
		    // the number being displayed because the first page is 0.
	            $last_display_page = ceil($count / $comments_per_page);
	            $last_pager_page = $last_display_page - 1;

		    $cell['data'] = $node->node_comment_statistics_comment_count.'<br>'.l('new', 'node/'.$node->nid, array(), 'page='.$last_pager_page.'#new');
        	    $cell['class'] = "view-field ". views_css_safe('view-field-'. $field['queryname']);
        	    $row[] = $cell;
		}
		else
		{
			$cell['data'] = views_theme_field('views_handle_field', $field['queryname'], $fields, $field, $node, $view);
    	                $cell['class'] = "view-field ". views_css_safe('view-field-'. $field['queryname']);
        	        $row[] = $cell;
		}
      }
    }
    $rows[] = $row;
  }
  return theme('table', $view->table_header, $rows, array('cellspacing'=>'40', 'border'=>'1'));
}

That's it.
Any improvements or hints are welcome! :)