function onSay(cid, words, param)
local param,max,t = string.lower(param),20,{
["sorcerer"] = 1,
["druid"] = 2,
["paladin"] = 3,
["knight"] = 4
}
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].." 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
!comando knight
!comando druid
tal