Add a "Recent posts" block to the tracker module

Used the query (unmodified) from the tracker module and added the hook_block function to it. It can be inserted in the tracker.module.

/**
 * Implementation of hook_block().
 */
function tracker_block($op = 'list', $delta = 0) {
  global $user;
  
  if ($op == 'list') {
    $blocks[0]['info'] = t('Recent posts');
    
    return $blocks;
  }
  else if ($op == 'view') {
    $sql = 'SELECT DISTINCT
        (n.nid), 
        n.title, 
        n.type, 
        n.changed, 
        n.uid, 
        u.name, 
        l.last_comment_timestamp as last_post, 
        l.comment_count 
      FROM 
        {node} n 
        INNER JOIN {users} u on n.uid = u.uid 
        INNER JOIN {node_comment_statistics} l on n.nid = l.nid 
      WHERE 
        n.status = 1 
      ORDER BY 
        last_post desc
      LIMIT 0, 16';
      
    $sql = db_rewrite_sql($sql);
    $result = db_query($sql);
  
    $rows = array();
    while ($node = db_fetch_object($result)) {
      $rows[] = l($node->title, "node/$node->nid");
    }
  
    $block['content'] = theme_item_list($rows);
    $block['subject'] = t('Recent posts');
    
    return $block;
  }
}

This query works fine for me:

    $sql = 'SELECT DISTINCT
        nid, 
        title, 
        changed
      FROM 
        {node} n 
      WHERE 
        status = 1 
      ORDER BY 
        changed desc
      LIMIT 0, 16';