Critico
Sexy
- Joined
- Mar 25, 2010
- Messages
- 370
- Reaction score
- 176
talk:
Lua:
function onSay(cid, words, param)
local param,max,t = string.lower(param),20,{
["sorcerer"] = {1,5},
["druid"] = {2,6},
["paladin"] = {3,7},
["knight"] = {4,8}
}
if param == "" or not t[param] then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE,"this vocation does exist.") return true
end
str = "--[RANK "..string.upper(param).."]--\n\n"
local query = db.getResult("SELECT `name`, `level` FROM `players` WHERE `group_id` <= 2 AND `vocation` = "..t[param][1].." or `vocation` = "..t[param][2].." ORDER BY `level` DESC;")
if (query:getID() ~= -1) then
k = 1
repeat
if k > max then
break
end
str = str .. "\n " .. k .. ". "..query:getDataString("name").." - [" .. query:getDataInt("level") .. "]"
k = k + 1
until not query:next()
end
doShowTextDialog(cid, 2529, str)
return true
end