Raised This Month: $ Target: $400
 0% 

Another question with MySQL: Get rank based XP


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Author Message
Marcoux
Junior Member
Join Date: Oct 2009
Old 10-10-2009 , 14:51   Another question with MySQL: Get rank based XP
Reply With Quote #1

Well, let's suppose we have a table like this:

SteamID-----------XP

With around 5000 rows.

I want to get the rank of certain SteamID, I know how to do the "top", where with just a ORDER BY I can get it. But not get the rank number of someone.

The diference is that, with just an ORDER BY I can get who are the ten players who have the highest XP, but if I want to know the rank of certain player, I cant.

Keep in mind that I think to show this in a HUD, so It shouldn't burn the CPU. I don't ask for queriyng every second, but maybe every round.

Last edited by Marcoux; 10-10-2009 at 19:16.
Marcoux is offline
 



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 22:43.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode