Lua get storage MySQL query

Ramon Bernardo said:

Try

SQL:

SELECT `player_id`
FROM `player_storage`
WHERE `key`= '7777'
ORDER BY `value` DESC
LIMIT 1;

I also recommend getting storage from players who are online and compare with the db.

Click to expand...

            local orderQuery = db.storeQuery("SELECT `player_id` FROM `player_storage` WHERE `key`= '17010' ORDER BY `value` DESC LIMIT 1;")
            print(orderQuery)

Kahras said:

How do I get the player_id value now?

Lua:

            local orderQuery = db.storeQuery("SELECT `player_id` FROM `player_storage` WHERE `key`= '17010' ORDER BY `value` DESC LIMIT 1;")
            print(orderQuery)

returns me the value 1

Click to expand...

Roddet said:

Lua:

local queryResult = db.storeQuery("SELECT * FROM `player_storage` s INNER JOIN players p ON `s`.`player_id` = `p`.`id` WHERE `key`= '7777' ORDER BY `value` DESC LIMIT 1;")
if queryResult then
    local name = result.getString(queryResult, "name")
    local level = result.getNumber(queryResult, "level")
    local value = result.getNumber(queryResult, "value")

    print(name, value, level)
    result.free(queryResult)
end

You can index all rows from players and player_storage tables
If you only need the name, just change * to `p`.`name` and remove level var

Click to expand...

local function checkNameSurvivalHigscores()
    local queryResult = db.storeQuery("SELECT * FROM `player_storage` s INNER JOIN players p ON `s`.`player_id` = `p`.`id` WHERE `key`= '7777' ORDER BY `value` DESC LIMIT 1;")
    if queryResult then
        local name = result.getString(queryResult, "name")
        result.free(queryResult)
        return name
    end
end

Lua Script Error: [CreatureScript Interface]
data/creaturescripts/scripts/survival/player_death.luanPrepareDeath
data/creaturescripts/scripts/survival/player_death.lua:34: attempt to concatenate global 'value' (a nil value)
stack traceback:
[C]: in function '__concat'
data/creaturescripts/scripts/survival/player_death.lua:34: in function <data/creaturescripts/scripts/survival/player_death.lua:12>

Click to expand...