Show user ranking in profile

I think the Advanced Profile Kit does that automatically: http://drupal.org/project/advanced_profile

No, the advanced profile does not provide ranking. I just looked at the code, and it only displays the user's points.

To do ranking, you need some custom code.

You can already do things like Top 5 users like so:

// If using categories
$sql = 'SELECT p.uid, u.name, p.points
  FROM {userpoints} p
  INNER JOIN {users} u USING (uid)
  WHERE p.tid = 0 OR p.tid IS NULL ORDER BY p.points DESC';
$result = db_query_range($sql, 0, 5);

// Or to be minimalistic, assuming you already have the name of the user
$sql = 'SELECT p.uid, p.points
  FROM {userpoints} p
  WHERE p.tid = 0 OR p.tid IS NULL ORDER BY p.points DESC';
$result = db_query_range($sql, 0, 5);

// If you are not using categories
$sql = 'SELECT p.uid, u.name, p.points
  FROM {userpoints} p
  INNER JOIN {users} u USING (uid)
  WHERE p.tid = %d ORDER BY p.points DESC';
$result = db_query_range($sql, $tid, 0, 5);

// Or to be minimalistic, assuming you already have the name of the user
$sql = 'SELECT p.uid, p.points
  FROM {userpoints} p
  WHERE p.tid = %d ORDER BY p.points DESC';
$result = db_query_range($sql, $tid, 0, 5);

You can expand that to getting rank for each users. You need to cache this somewhere, since running the query too often can be expensive.

There is all the top_contributers module over in userpoints_contributed modules that does something similar. Maybe it would be close enough so you wouldn't have to dive into the code? don't know..

For caching, what you need to do is something like this:

$rank = 0;
while ($row = db_fetch_object($result)) {
  $rank++;
  $rank_data = $rank . ':' . $row->points; // Rank and number of points
  $data = serialize($rank_data); 
  cache_set('userpoints_rank:' . $row->uid, 'cache', $data);
}

This stores the number of points and the rank in the cache.

To retrieve this, you do something like this:

  // Check the cache, to see if the stuff is stored there

  if ($data = cache_get('userpoints_rank:' . $uid, 'cache')) {
    $rank_data = unserialize($data);
    list($rank, $points) = explode(':', $rank_data);
  }
  else {
    // do the db queries
  }
}

This way, you don't have to do the entire ranking every time to you want to show it and it can stay in the cache for sometime.

Check http://api.drupal.org/api/function/cache_set/5 for more info on how long you can keep stuff in the cache, and such.

You can even do that in cron, so it is calculated every hour or every day.

This is not final working code.

It is just the parts that you need to put in a module to get the functionality you want. It needs to be fleshed out.

If you are not a developer, then please ignore the code I posted. Someone else who may be interested can write the module.

That is not ranking. Ranking means the user gets a number from 1 to N, based on how many points they have.
If you said so from the start, we would have given you a proper answer sooner.

What you want is something similar to User badges http://drupal.org/project/user_badges or User titles http://drupal.org/project/user_titles

You can see which one is best for your case, then integrate it with userpoints.

For some starting code, check the userpoints_role in the userpoints_contrib project. Just change it to assign a badge/title instead of a role.

Are you sure that the top contributors module doesn't do what you want?
http://drupal.org/project/userpoints_top_contributors

if not if you could you explain why it doesn't do what you want maybe we can help you along.

Isn't a list of user's by their user points a ranking?

What I'm getting at is the top contributors module gives you what you want in a different way. You want to know if Joe is number #8 or number #10 in regards to his numbers of points relative to all other users on the site.

I downloaded and took a look at the top contributors module and the DB looks like this.

     uid INT(10),
     rank INT(10),
     period_points FLOAT(10,1),
     current_points FLOAT(10,1),
     lifetime_points FLOAT(10,1),

It also provides information on the profile page about the user but doesn't provide the user's rank. From a 5 second look at the code it seems like it something like

  global $user; 
  $sql = "SELECT rank FROM {userpoints_top_contributors} where uid = %d":
  $rank  = db_result(db_query($sql, $user->uid));

When displaying the user's profile page would add in the information you want.

So again I'm highly suggesting you take a look at this module.

they are both the same.

Sorry for spamming the participants in this issue. Due to the release of Drupal 7 and the lack of time from the maintainers, I'm closing all remaining 5.x issues for Userpoints.

Feel free to re-open this issue or create a new one for 6.x or even better 7.x if this bug is still open or feature is missing for these versions.