Posts: 534
Threads: 265
Joined: Jul 2014
Hi,
What query i need procced that i could get name of player for exampe which XP TOP is 400 of 1000 registered players.
Posts: 561
Threads: 27
Joined: Sep 2012
Do you have an Enum of TOP XP Players?
Posts: 4,878
Threads: 85
Joined: Jun 2007
Reputation:
0
This totally depends on how you store your stuff.
If its mysql/sqlite, with playernames and xp in a single table, then something like this would do it
SELECT your_name_field FROM your_player_table ORDER BY your_xp_field DESC LIMIT 400, 1
(sort players by xp descending, fetch 1 line at offset 400)
If youre using files for the data then its a lot more complicated.
