How get player name from position of anything
#1

Hi,

What query i need procced that i could get name of player for exampe which XP TOP is 400 of 1000 registered players.
Reply
#2

Do you have an Enum of TOP XP Players?
Reply
#3

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.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)