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
info
Group: Campones
Joined: 17/09/12
Posts: 32
Reputation: +6
Gender: Masculino
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:
-- 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
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: