olá galera, eu peguei um script aqui do xtibia "Overlord" o autor do script, so que ele so esta ajustado para sqlite. eu tentei usar a funçao "db.Query inves de db.executeQuery", porem o erro ainda persiste.
function onSay(cid, words, param, channel)
local p = string.explode(param, ',')
if(param == "") then
doPlayerSendCancel(cid, "Command requires param.")
return true
end
if(words == "/del") then
if(db.getResult("DELETE FROM `X`.`players` WHERE `players`.`name` = " .. db.escapeString(p[1]) .. ";"):getID() == -1) then
return doPlayerSendCancel(cid, "You Have Deleted [" .. p[1] .. "] .")
end
return db.Query("UPDATE `players`" .. p[1] .. "' WHERE players = '" .. p[1] .. "';") and doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "You have Deleted " .. p[1] .. "'s name")
end
end
o error que aparece na distro é o seguinte.
mysql_real_query(): DELETE FROM `X`.`players` WHERE `players`.`name` = 'Vini'; - MYSQL ERROR: Table 'x.players' doesn't exist (1146)
eu uso TFS 0.4 r3884 versao 8.6.
Database: MYSQL