talkaction [9.8]Simple personal rank

[swordie123 6]

This is simple presonal rank command! (!myrank). It shows your position [level sorted by exp] in server. This is my second script so please don't insult me ; p

In talkactions\scripts\simplerank.lua:

PHP Code:

-- simple personal ranking
-- Created by Layflette/Fec/3dzio

function onSay(cid, words, param)
local best_list = db.getResult("SELECT `level`,`name` FROM `players` WHERE `group_id` < '2' AND `account_id` > '1' ORDER BY `experience` DESC;")
local player_name = getPlayerName(cid)
local count = 1
if best_list:getID() ~= -1 then
while true do
local currName = best_list:getDataString('name')
if currName == player_name then
doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, 'You are in the ' .. count .. ' place !')
else
count = count + 1
end
if not best_list:next() then break end
end
end
best_list:free()
return TRUE
end

In talkactions.xml add

PHP Code:

<talkaction words="!myrank" script="simplerank.lua"/>

Tested on tfs 0.2.15.r102 mystic spirit.

 

 

 

GOOD OT-SERVER = MUCH PLAYERS!

GET DEDICATED SERVER WITH DDOS PROTECTION UP TO 10 GB/S HERE:

from http://otland.net