Members who have posted the most comments

I agree that programing this wouldn't be to complex. You would just need to pull the 'uid' feild of the 'comments' table in the database, sort them, and then do a count to see who had the most. Then just sort them again to get the list. Does this help?

1. Go to http://yoursite.com/admin/block/add
2. The Block Title is "Top 20 Users".
3. The Block Description is "Top 20 Users".
4. The Input Filter is "PHP Code".
5. And the block body is below.

$users = db_query("SELECT COUNT(cid) AS count, {users}.uid, {users}.name FROM {comments} LEFT JOIN {users} ON {comments}.uid = {users}.uid WHERE {comments}.uid != 0 GROUP BY uid ORDER BY count DESC LIMIT 20");

print "<ul>"; while ($user = db_fetch_object($users)) {
  print "<li>$user->name ($user->count)</li>";
} print "</ul>";

Save your block and enable it as usual. This is a VERY VERY basic block, just to show you as an example. It doesn't link to the user's profile, and it writes raw HTML as opposed to using the Drupal template builtins. Adding those features are an exercise for the reader.

http://disobey.com/
http://gamegrene.com/

Maybe this is something you and others can use? It's based on some of the example code here but are a module and use Drupal funktions for item list etc.

/**
 * @file
 * top_users.module 4.5.0v1, Fredrik Jonsson, 2005-02-17
 * Enables admins to display a block with the top users, 
 * the ones that has posted most comments.
 */

/**
 * Implementation of hook_help().
 */
function top_users_help($section = "admin/help#top_users") {
  switch ($section) {
    case 'admin/modules#description':
      $output = t("Block that display the top users, the ones that has posted most comments.");
      break;
  }
  return $output;
}

/**
 * Implementation of hook_block().
 *
 * Generates a block with the comments approval queue and
 * the node moderation queue.
 * $nlimit sets the number of comments and nodes to display
 */

function top_users_block($op = 'list', $delta = 0) {
  if ($op == 'list') {
    $blocks[0]['info'] = t('Top Users');
    return $blocks;
  }
  else if (user_access('access content')) {
    $nlimit = 10;

    $users = db_query_range('SELECT COUNT(c.cid) AS count, u.uid, u.name 
      FROM {comments} c 
      LEFT JOIN {users} u ON c.uid = u.uid 
      WHERE c.uid != 0 
      GROUP BY uid 
      ORDER BY count DESC', 0, $nlimit);
    $items = array();
    while ($user = db_fetch_object($users)) {
      $items[] = l($user->name,'user/'. $user->uid) .' ('. l($user->count,'tracker/'. $user->uid) .')';
    }

    $block['subject'] = t('Top Users');
    $block['content'] = theme('item_list', $items);
    return $block;
  }
}