open.mp forum
[Pawn] How does one make a top5 ranking? - Printable Version

+ open.mp forum (https://forum.open.mp)
-- Forum: SA-MP (https://forum.open.mp/forumdisplay.php?fid=3)
--- Forum: Pawn Scripting (https://forum.open.mp/forumdisplay.php?fid=10)
--- Thread: [Pawn] How does one make a top5 ranking? (/showthread.php?tid=1950)



How does one make a top5 ranking? - Z3fRaN - 2021-04-26

I don't have the idea of how to make a top 5 ranking, like top 5 killers of the server, what do I need to do in order to script something like that?


RE: How does one make a top5 ranking? - Snow - 2021-04-27

If you're using sql, You can use SELECT and ORDER BY clauses to fetch the results from database. For example,
Code:
SELECT username, kills FROM `users` ORDER BY kills DESC LIMIT 5



RE: How does one make a top5 ranking? - Awide - 2021-04-27

I recommend you to save into a database, so you can find anytime what you're seeking just how Snow explained.