• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Help error in mysql

llamavani

Trinitium Rubidia Style!
Joined
Sep 17, 2009
Messages
173
Reaction score
3
Location
Guadalajara, Mexico
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

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
 
Back
Top