[DabuDos]

Hi all,
I'm currently trying stuff out with KVs and such (only single-server ranking). I couldn't find a proper working Snippet for SQLite or such, so I used KV.

And now I come to the point where I have no clue: How do I make a Top list (Top10)?

I tried it with going through every Entry getting the points and look if the points are higher or not but then I would only get the current leader.

Anyone an idea how I could this?

[Drixevel]

Could probably use more info here.

Few ideas off the small amount of info:

SELECT * FROM table ORDER BY column ASCENDING LIMIT 0,10;

...or make a menu with 10 menu items?

...or use strcat/format and add to a string and print?

...or make a site and just have an MOTD open?

[Neuro Toxin]

Avoid KV for your purpose.

1. It's slow with large datasets
2. It's not threaded and your server will hang during iteration
3. As above you don't get power of sql's order by instruction

[ThatOneGuy]

as mentioned, SQL is the way to go. Use the query mentioned above, or one similar. If you MUST use KV, you could push it all to an array and use the appropriate SM array sorting functions. There are different functions depending on if it is an ADT array or not, and if you want ascending, descending, or you can make your own custom sort. But again, you really should be using SQL for that.

You mentioned there not being SQLite examples...I've seen them all over in here. Alternately, look at another plugin that uses sqlite, and just base your code off that. If you still dont get it, one of us can whip you up an example, but use the search key, cuz how to use sqlite has been asked several times before.

[Potato Uno]

Keyvalue is total shit, avoid it like cancer if you can. (Neuro Toxin stole my reasons.)

One acceptable case of keyvalues are for config files for plugins, and that's all I can think of.

You ideally want to haul as much of the work to SQL as possible since that is ran on a separate worker thread; that way the main game thread can do less work.

[DabuDos]

Thanks for all the reasons why KVs are shit, that's ok how it is.
I'm gonna try to use the Array sorting function for that.
SQLite comes later.

[KissLick]

KeyValues are not shit... They are just not meant to be used that way...

[SoulSharD]

Use KeyValues for storing key values.

[Potato Uno]

If keyvalues are not shit, then other than config files, I would like someone to give TWO cases where keyvalues > SQL.

I avoid keyvalues like cancer if I can help it, especially since I managed to always find a satisfactory alternative to keyvalues with sqlite.

The API is also somewhat painful to use compared to sqlite.

[DabuDos]

Originally Posted by Potato Uno If keyvalues are not shit, then other than config files, I would like someone to give TWO cases where keyvalues > SQL. I avoid keyvalues like cancer if I can help it, especially since I managed to always find a satisfactory alternative to keyvalues with sqlite. The API is also somewhat painful to use compared to sqlite.

My problem is I never used SQLite or SQL before in general and KVs are simple to read and store.
And (at the moment) KVs are easier to understand for me. Gonna search for good SQLite snippets/Tutorials/Plugins to learn from, maybe I can understand it better then, since someone said that the tutorial in the wiki wouldn't work properly.