Wesquel

Private rank

Jan 13th, 2017
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. function onSay(cid, words, param)
  2. local max = 20
  3. local letters_to_next = 20
  4. local name_now
  5. local name = "Top Frags\n"
  6. local rkn = 0
  7.  
  8. name = name.."\n"
  9. name = name.."Rank Frags - Nome do Jogador\n"
  10. local v = db.getResult("SELECT `p`.`name` AS `name`, COUNT(`p`.`name`) as `frags` FROM `killers` k LEFT JOIN `player_killers` pk ON `k`.`id` = `pk`.`kill_id` LEFT JOIN `players` p ON `pk`.`player_id` = `p`.`id` WHERE `k`.`unjustified` = 1 GROUP BY `name` ORDER BY `frags` DESC;")
  11. repeat
  12. if v:getID() == -1 then
  13. break
  14. end
  15. rkn = rkn+1
  16. name_now, l = v:getDataString("name"), string.len(v:getDataString("name"))
  17. name = name..rkn..". ["..v:getDataInt("frags").."] - "..name_now.." ".." ".."".."\n"
  18. until v:next() == false
  19. if name ~= "" then
  20. doShowTextDialog(cid,1903, name)
  21. end
  22. return TRUE
  23. end
Add Comment
Please, Sign In to add comment