llamavani
Trinitium Rubidia Style!
Help community... when i have running my client with sql all was ok but now i run it with mysql and have an error and dont know why look
it is my script and it is supposed that when you type !rango muertes then show a list of the TOP with the storage value but in mysql mark this error:
WHY?
- - - Updated - - -
BUMP
- - - Updated - - -
BUMP
Code:
-----------------------By Vodka--------------------------
function getRankStorage(cid, value, max, RankName)
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") .. " Pts]"
k = k + 1 until not query:next() end return doPlayerPopupFYI(cid, str)
end
-----------------------By Trinitium--------------------------
local table = {
["focas"] = {storage = 33008, name= "TOP PUNTUAJE FOCAS"},
["monos nieve"] = {storage = 33007, name= "TOP PUNTUAJE MONOS DE NIEVE"},
["mamuths"] = {storage = 33010, name= "TOP PUNTUAJE LEVANTAR MAMUTHS"},
["osos"] = {storage = 33011, name= "TOP PUNTUAJE DESPERTAR OSOS"},
["caña loca"] = {storage = 33013, name= "TOP PESCA CAÑA LOCA"},
["excavar"] = {storage = 33014, name= "TOP EXCAVAR EN LA ARENA"},
["pk"] = {storage = 33015, name= "TOP [PK's] MUERTES INJUSTIFICADAS"},
["muerte"] = {storage = 33016, name= "TOP MAS MUERTES(DEBILIDAD)"},
["simon"] = {storage = 33017, name= "TOP SIMON DICE"},
["forjeo puntos"] = {storage = 33018, name= "TOP PUNTOS DE FORJEO"},
["forjeo nivel"] = {storage = 33019, name= "TOP NIVEL DE FORJEO"}
}
function onSay(cid, words, param)
if(param == "") then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Incluye alguno de los siguientes rangos en tu comando para checar el mismo: [nivel, magia, pesca, escudo, distancia, espada, hacha, mazo, golpe, pk, muerte, excavar, caña loca, monos nieve, focas, mamuths, osos, simon, forjeo puntos, forjeo nivel].")
elseif(param == "exp") or (param == "nivel") then
doPlayerPopupFYI(cid, getHighscoreString(8))
elseif(param == "magia") or (param == "ml") then
doPlayerPopupFYI(cid, getHighscoreString(7))
elseif(param == "pesca") or (param == "fish") then
doPlayerPopupFYI(cid, getHighscoreString(6))
elseif(param == "escudo") or (param == "shield") then
doPlayerPopupFYI(cid, getHighscoreString(5))
elseif(param == "distancia") or (param == "dist") then
doPlayerPopupFYI(cid, getHighscoreString(4))
elseif(param == "espada") then
doPlayerPopupFYI(cid, getHighscoreString(2))
elseif(param == "hacha") then
doPlayerPopupFYI(cid, getHighscoreString(3))
elseif(param == "mazo") then
doPlayerPopupFYI(cid, getHighscoreString(1))
elseif(param == "golpe") then
doPlayerPopupFYI(cid, getHighscoreString(0))
elseif(param == "focas") then
local param = string.lower(param)
getRankStorage(cid, table[param].storage, 15, "RANGO: "..table[param].name)
elseif(param == "monos nieve") then
local param = string.lower(param)
getRankStorage(cid, table[param].storage, 15, "RANGO: "..table[param].name)
elseif(param == "mamuths") then
local param = string.lower(param)
getRankStorage(cid, table[param].storage, 15, "RANGO: "..table[param].name)
elseif(param == "osos") then
local param = string.lower(param)
getRankStorage(cid, table[param].storage, 15, "RANGO: "..table[param].name)
elseif(param == "caña loca") then
local param = string.lower(param)
getRankStorage(cid, table[param].storage, 15, "RANGO: "..table[param].name)
elseif(param == "excavar") then
local param = string.lower(param)
getRankStorage(cid, table[param].storage, 15, "RANGO: "..table[param].name)
elseif(param == "pk") then
local param = string.lower(param)
getRankStorage(cid, table[param].storage, 15, "RANGO: "..table[param].name)
elseif(param == "muerte") then
local param = string.lower(param)
getRankStorage(cid, table[param].storage, 20, "RANGO: "..table[param].name)
elseif(param == "simon") then
local param = string.lower(param)
getRankStorage(cid, table[param].storage, 15, "RANGO: "..table[param].name)
elseif(param == "forjeo puntos") then
local param = string.lower(param)
getRankStorage(cid, table[param].storage, 10, "RANGO: "..table[param].name)
elseif(param == "forjeo nivel") then
local param = string.lower(param)
getRankStorage(cid, table[param].storage, 10, "RANGO: "..table[param].name)
else
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Ese rango no existe, porfavor ingresa un rango valido.")
end
return TRUE
end
it is my script and it is supposed that when you type !rango muertes then show a list of the TOP with the storage value but in mysql mark this error:
Code:
[25/07/2012 06:22:10] mysql_real_query(): SELECT `player_id`, `value` FROM `player_storage` WHERE `key` = 33017 ORDER BY cast(value as INTEGER) DESC; - MYSQL ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTEGER) DESC' at line 1 (1064)
WHY?
- - - Updated - - -
BUMP
- - - Updated - - -
BUMP