Checking for an offline players storage value

[Cadyan]

Does anyone know how to do this? I want "totalPlayers" to check ALL players in database for storage.

totalPlayers = ????
for i = 1, #totalPlayers do
    if getPlayerStorageValue(totalPlayers[i], 10000) >= getPlayerStorageValue(totalPlayers[i], 10000) then
        setGlobalStorageValue(10000, getPlayerStorageValue(totalPlayers[i]))
    else
        setGlobalStorageValue(10000, 0)
    end
end

 

[WibbenZ]

Game.getPlayers() or getOnlinePlayers() depending on tfs version.

 

[Cadyan]

"ALL players in database for storage."

 

[Cadyan]

bump

 

[Cadyan]

bump

 

[Cadyan]

bump

 

[Ninja]

What are you trying to accomplish?

 

[Gsp]

yeah just tell them what you are trying to do

 

[Cadyan]

What are you trying to accomplish?

My script says it all. I am trying to compare the storage value "10000" of all players in the database against each other, and the highest value will be set as the global storage.

 

[Evil Hero]

this is a way how to get the highest value of the table, however idk if it could be done easier I'm a noob in mysql

local q1 = db.storeQuery("SELECT Max(`value`) AS `value` FROM `player_storage` WHERE `key`= 10000")
local value = result.getDataInt(q1, "value")
local q2 = db.storeQuery("SELECT * FROM `player_storage` WHERE `value` = ".. value .."")
local player_id = result.getDataInt(q2, "player_id")
local key = result.getDataInt(q2, "key")
result.free(q1)
result.free(q2)

 

[Cadyan]

this is a way how to get the highest value of the table, however idk if it could be done easier I'm a noob in mysql

local q1 = db.storeQuery("SELECT Max(`value`) AS `value` FROM `player_storage` WHERE `key`= 10000")
local value = result.getDataInt(q1, "value")
local q2 = db.storeQuery("SELECT * FROM `player_storage` WHERE `value` = ".. value .."")
local player_id = result.getDataInt(q2, "player_id")
local key = result.getDataInt(q2, "key")
result.free(q1)
result.free(q2)

ill attempt something

 

[Evil Hero]

local value = 0
local q1 = db.storeQuery("SELECT Max(`value`) AS `value` FROM `player_storage` WHERE `key`= 10000")
if q1 ~= false then
    local value = result.getDataInt(q1, "value")
    local q2 = db.storeQuery("SELECT * FROM `player_storage` WHERE `value` = ".. value .."")
    local player_id = result.getDataInt(q2, "player_id")
    local key = result.getDataInt(q2, "key")
    result.free(q1)
    result.free(q2)
end
setGlobalStorageValue(10000, value)

 

[Ninja]

I don't think you need two queries for this xd

local value = 0
local resultId = db.storeQuery("SELECT MAX(`value`) AS `value` FROM `player_storage` WHERE `key` = 10000")
if resultId ~= false then
    value = result.getDataInt(resultId, "value")
    result.free(resultId)
end

 

[Evil Hero]

well I didn't know if he maybe needed the playerId for later usage, so I just parsed all data

 

[Cadyan]

thanks guys