Quando uso esse script em sqlite, funciona normalmente, porem quando mudo para mysql acontece o error.
Script:
function getRankStorage(cid, value, max, RankName) -- by vodka
local str =""
str = "--[".. (RankName == nil and "RANK STORAGE" or ""..RankName.."") .."]--\n"
local query = db.getResult("SELECT `player_id`, `value` FROM `player_storage` WHERE `key` = "..value.." ORDER BY cast(value as INTEGER) DESC;")
if (query:getID() ~= 1) then k = 1 repeat if k > max then break end
str = str .. "\n " .. k .. ". "..getPlayerNameByGUID(query:getDataString("player_id")).." - [" .. query:getDataInt("value") + 1 .. "]"
k = k + 1 until not query:next() end return doShowTextDialog(cid, 7701, str)
end
function onUse(cid, item)
local storage,name = 123781, "Rank ganhadores Torneio PvP"
return getRankStorage(cid, storage, 20, name)
end
Error quando usa em mysql:
[Error - Action Interface]
data/actions/scripts/rank torneio pvp.lua:onUse
Description:
data/lib/004-database.lua:76: [Result:getDataString] Result not set!
stack traceback:
[C]: in function 'error'
data/lib/004-database.lua:76: in function 'getDataString'
data/actions/scripts/rank torneio pvp.lua:6: in function <data/actions/scripts/rank torneio pvp.lua:1>
(tail call): ?
info
Grupo: Conde
Registrado: 18/07/08
Posts: 545
Reputação: +21
Char no Tibia: Nem eu sei
Quando uso esse script em sqlite, funciona normalmente, porem quando mudo para mysql acontece o error.
Script:
function getRankStorage(cid, value, max, RankName) -- by vodka local str ="" str = "--[".. (RankName == nil and "RANK STORAGE" or ""..RankName.."") .."]--\n" local query = db.getResult("SELECT `player_id`, `value` FROM `player_storage` WHERE `key` = "..value.." ORDER BY cast(value as INTEGER) DESC;") if (query:getID() ~= 1) then k = 1 repeat if k > max then break end str = str .. "\n " .. k .. ". "..getPlayerNameByGUID(query:getDataString("player_id")).." - [" .. query:getDataInt("value") + 1 .. "]" k = k + 1 until not query:next() end return doShowTextDialog(cid, 7701, str) end function onUse(cid, item) local storage,name = 123781, "Rank ganhadores Torneio PvP" return getRankStorage(cid, storage, 20, name) endError quando usa em mysql:
[Error - Action Interface] data/actions/scripts/rank torneio pvp.lua:onUse Description: data/lib/004-database.lua:76: [Result:getDataString] Result not set! stack traceback: [C]: in function 'error' data/lib/004-database.lua:76: in function 'getDataString' data/actions/scripts/rank torneio pvp.lua:6: in function <data/actions/scripts/rank torneio pvp.lua:1> (tail call): ?