[LUA] MySQL request

[Szafi]

Hello, can you show me example script to mysql request in lua?
Thanks for help.

 

[Karain]

local resultValue = db.storeQuery("SELECT `value` FROM `player_storage` WHERE `player_id` = `1`")
if resultValue ~= false then
    local dbvalue1 = result.getNumber(resultValue, "value") --getNumber to get INT fields
    local dbvalue2 = result.getString(resultValue, "value") --getNumber to get STRING fields
    result.free(resultValue)
    return dbvalue1, dbvalue2
else
    return false
end