local BlockedName = {"Druid Sample", "Paladin Sample", "Knight Sample", "Rook Sample", "Soldier Sample"} function onSay(player, words, param) local split = param:splitTrimmed(" ") if _DEBUG_MODE then local _TYPE = { ["00"] = 'Rank Level', ["01"] = 'Rank Skill', } local skillType = { ["01"] = "Metralhadora", ["02"] = "Rifle", ["03"] = "Pistola", ["04"] = "Espingarda", } if _TYPE[split[01]] then print("[TALK - RANK] " ..player:getName().. " - " .._TYPE[split[01]]) else print("[TALK - RANK] " ..player:getName().. " - " ..split[01].. " | Skill: " ..skillType[split[02]]) end end if split[01] == "00" then -- RANK LEVEL local RankLevel = db.storeQuery('SELECT name, level FROM `players` WHERE group_id < 2 ORDER BY level DESC LIMIT 50;') if RankLevel then local i = 1 repeat if not isInArray(BlockedName, result.getDataString(RankLevel, "name")) then player:sendCancelMessage("@RankLevel#" ..i.. "#" ..result.getDataString(RankLevel, "name").. "#" ..result.getDataInt(RankLevel, "level")) i = i + 1 end until not result.next(RankLevel) result.free() end end if split[01] == "01" then -- RANK SKILLS local SkillType = split[02] local RankSkills = "" if SkillType == "01" then -- METRALHADORA RankSkills = db.storeQuery('SELECT name, skill_club FROM `players` WHERE group_id < 2 ORDER BY skill_club DESC LIMIT 50;') elseif SkillType == "02" then -- RIFLE RankSkills = db.storeQuery('SELECT name, skill_sword FROM `players` WHERE group_id < 2 ORDER BY skill_sword DESC LIMIT 50;') elseif SkillType == "03" then -- PISTOLA RankSkills = db.storeQuery('SELECT name, skill_axe FROM `players` WHERE group_id < 2 ORDER BY skill_axe DESC LIMIT 50;') elseif SkillType == "04" then -- ESPINGARDA RankSkills = db.storeQuery('SELECT name, skill_fist FROM `players` WHERE group_id < 2 ORDER BY skill_fist DESC LIMIT 50;') end if RankSkills then local i = 1 repeat if not isInArray(BlockedName, result.getDataString(RankSkills, "name")) then if SkillType == "01" then -- METRALHADORA player:sendCancelMessage("@RankSkills#" ..i.. "#" ..result.getDataString(RankSkills, "name").. "#" ..result.getDataInt(RankSkills, "skill_club")) elseif SkillType == "02" then -- RIFLE player:sendCancelMessage("@RankSkills#" ..i.. "#" ..result.getDataString(RankSkills, "name").. "#" ..result.getDataInt(RankSkills, "skill_sword")) elseif SkillType == "03" then -- PISTOLA player:sendCancelMessage("@RankSkills#" ..i.. "#" ..result.getDataString(RankSkills, "name").. "#" ..result.getDataInt(RankSkills, "skill_axe")) elseif SkillType == "04" then -- ESPINGARDA player:sendCancelMessage("@RankSkills#" ..i.. "#" ..result.getDataString(RankSkills, "name").. "#" ..result.getDataInt(RankSkills, "skill_fist")) end i = i + 1 end until not result.next(RankSkills) result.free() end end return false end