TFS 1.X+ Function to get all players who have the higer value of storage 16200

[roriscrave]

Hello! I'm using tfs 1.2 and need a function to check the 5 players who have the highest value of the storage (16200), and they will receive a storage of value 16201.
Everything happens when turn on the server.
Could anyone help?

 

[Apollos]

Hello! I'm using tfs 1.2 and need a function to check the 5 players who have the highest value of the storage (16200), and they will receive a storage of value 16201.
Everything happens when turn on the server.
Could anyone help?

Imo best way to do this is to store all five players in global array for use during session instead of changing another storage to identify who is in top 5.

-- global.lua
top_five = {}

-- startup.lua
local resultId = db.storeQuery("SELECT `player_id` FROM `player_storage` WHERE `key` = 16200 ORDER BY `value` DESC LIMIT 5")
if resultId ~= false then
    repeat
        top_five[#top_five + 1] = result.getDataInt(resultId, "player_id")
    until not result.next(resultId)
    result.free(resultId)
end