function onSay(cid, words, param)
-- max players on the highscore
local players = 10 -- The amount of players that is shown in the list
-- don't touch --
local str = ""
local value = ""
local name = ""
local player_id = 0
local result = nil
if param == "level" or param == "exp" or param == "lvl" then
str = "# [Level] - Name\n"
value = "level"
name = "name"
result = db.getResult("SELECT `level`, `name` FROM `players` ORDER BY `level` DESC, `name` ASC LIMIT 0, ".. players ..";")
elseif param == "magiclevel" or param == "magic" or param == "mlevel" or param == "ml" then
str = "# [Magic Level] - Name\n"
value = "maglevel"
name = "name"
result = db.getResult("SELECT `name`, `maglevel` FROM `players` ORDER BY `maglevel` DESC, `name` ASC LIMIT 0, ".. players ..";")
elseif param == "fist" then
str = "# [Fist] - Name\n"
value = "value"
player_id = "player_id"
result = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 0 ORDER BY `value` DESC, `player_id` ASC LIMIT 0, ".. players ..";")
elseif param == "club" then
str = "# [Club] - Name\n"
value = "value"
player_id = "player_id"
result = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 1 ORDER BY `value` DESC, `player_id` ASC LIMIT 0, ".. players ..";")
elseif param == "sword" then
str = "# [Sword] - Name\n"
value = "value"
player_id = "player_id"
result = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 2 ORDER BY `value` DESC, `player_id` ASC LIMIT 0, ".. players ..";")
elseif param == "axe" then
str = "# [Axe] - Name\n"
value = "value"
player_id = "player_id"
result = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 3 ORDER BY `value` DESC, `player_id` ASC LIMIT 0, ".. players ..";")
elseif param == "dist" or param == "distance" then
str = "# [Distance] - Name\n"
value = "value"
player_id = "player_id"
result = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 4 ORDER BY `value` DESC, `player_id` ASC LIMIT 0, ".. players ..";")
elseif param == "shield" or param == "shielding" then
str = "# [Shield] - Name\n"
value = "value"
player_id = "player_id"
result = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 5 ORDER BY `value` DESC, `player_id` ASC LIMIT 0, ".. players ..";")
elseif param == "fish" or param == "fishing" then
str = "# [Fishing] - Name\n"
value = "value"
player_id = "player_id"
result = db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = 6 ORDER BY `value` DESC, `player_id` ASC LIMIT 0, ".. players ..";")
else
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Unknown skill: '" .. param .. "'")
return TRUE
end
if (result:getID() ~= -1) then
local i = 0
while TRUE do
str = str .. "\n " .. i+1 .. ". [" .. result:getDataInt(value) .. "] - " .. (name ~= "" and result:getDataString("name") or getPlayerNameByGUID(result:getDataInt(player_id)))
i = i+1
if not(result:next()) or i >= players then
break
end
end
result:free()
end
if str ~= "" then
doPlayerPopupFYI(cid, str)
end
return TRUE
end