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:
- Create or edit user.profile.tpl.php file in your theme
-
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;?>