Drupal: Latest Comments Block in User Profile.

In Drupal 5, if you want the User Profile page (e.g. http://example.com/user/stevejobs) to display latest comments by that user, you can apply a quick hack:

1. Create or edit user.profile.tpl.php file in your theme
2. Add the following code anywhere (wherever you want latest comments to appear) in the file:
   

   <?php
   $output = ""; $nlimit = 7;
   $userid=$user->uid;
   
   // ATTENTION: status=0 - approved, status=1 in queue.
   $query= "SELECT c.cid, c.nid, c.name, c.subject 
   FROM {comments} c WHERE c.uid = %d AND c.status = 0 
   ORDER BY c.timestamp DESC";
   
   $result = db_query_range($query,$userid,0,$nlimit);
   $output .= "<div class=\"item-list\"><ul>\n";
   
   $no_comments = mysql_affected_rows ();
   
   if ( $no_comments > 0 ) {
   
   
           while ($obj = db_fetch_object($result)) {
                   $link = url("node/$obj->nid");
                   $link = $link."#comment-".$obj->cid;
                   $output .= "<li><a href=\"$link\">$obj->subject</a></li>";
           }
   
   } else {
           $output .=  'No Comments left so far.';
   }
   
   $output .= "</ul></div>";
   print $output;
   ?>