By gercheq on

I want to sort the users by popularity (users with the most bookmarks(another drupal module) will be listed at the top). I am using the bookmarks module and created the user list view as explained in http://views-help.doc.logrus.com/help/views/example-users-by-role

I just started learning drupal so any help will be appreciated.

Thanks,

⋅ Categories: Drupal 6.x

Comments

gercheq’s picture

gercheq commented

this helped http://drupal.org/node/509532

$users = db_query("SELECT COUNT(n.nid) count, u.name, u.uid, u.picture FROM {users} u LEFT JOIN {node} n ON u.uid = n.uid WHERE u.uid != 0 AND u.uid != 1 AND n.uid = u.uid AND u.status = 1 AND n.status = 1 GROUP BY n.uid ORDER BY count DESC LIMIT 10");
 

$output = "<ul>";
while ($user = db_fetch_object($users)) {

    //check user has a picture & it exists if not show default image
    if ($user->picture && file_exists($user->picture)) {
      $picture = $user->picture;
    }
    else  {
      $picture = "default.png";  
    }  
  $output .= "<li><div class='user-thumb'><img src='/" . $picture ."' /></div><div class='user-name'>" . l($user->name, drupal_get_path_alias("user/{$user->uid}")). " ($user->count)</div></li>";


}
$ouput .= "</ul>";
echo $output;