You'd need three queries.
1,) Find the minimum score
2,) Add the score
3,) Delete old score
I guess it's what you want to store.
I just find it easier because when you want to display the top20 scores, in SQL is does all the work for you and faster than getting all the results and then do some type of sorting function.
Did you use another solution? I am curious on how you did it.
Using SQL when you have a small fixed number of rows that you're not even performing real queries on doesn't make any sense.
If all you want is a list of the top 25 players, store them in an array in a DB NPC flag. There are built-in (fast) functions for sorting arrays, and performance is not an issue here anyway (but I'd be willing to bet this is faster than constantly shuffling things in/out of SQLite, anyway).
The only way I see the code being simpler is if you store all players in a table, and use a query (SELECT .. ORDER BY .. LIMIT 25), which is how I would recommend doing it.
12-12-2014, 05:13 PM
Linear Mode
