Como colocar o comando !rankfrags ?

[ravely13 1]

La no meu server tem o fraglook que quando da look no player ver a quantidade de frags , mais infelizmente nao tem o !rankfrags como fasso para colocar esse comando e ter um rank de frags no meu ot?

Quote

--Script By Theax ""

function getPlayerFrags(cid)

local time = os.time()

local times = {today = (time - 86400), week = (time - (7 * 86400))}

local contents, result = {day = {}, week = {}, month = {}}, db.getResult("SELECT `pd`.`date`, `pd`.`level`, `p`.`name` FROM `player_killers` pk LEFT JOIN `killers` k ON `pk`.`kill_id` = `k`.`id` LEFT JOIN `player_deaths` pd ON `k`.`death_id` = `pd`.`id` LEFT JOIN `players` p ON `pd`.`player_id` = `p`.`id` WHERE `pk`.`player_id` = " .. getPlayerGUID(cid) .. " AND `k`.`unjustified` = 1 AND `pd`.`date` >= " .. (time - (30 * 86400)) .. " ORDER BY `pd`.`date` DESC")

if(result:getID() ~= -1) then

repeat

local content = {date = result:getDataInt("date")}

if(content.date > times.today) then

table.insert(contents.day, content)

elseif(content.date > times.week) then

table.insert(contents.week, content)

else

table.insert(contents.month, content)

end

until not result:next()

result:free()

end

local size = {

day = table.maxn(contents.day),

week = table.maxn(contents.week),

month = table.maxn(contents.month)

}

return size.day + size.week + size.month

end

function onLogin(cid)

registerCreatureEvent(cid, "fraglook")

return true

end

function onLook(cid, thing, position, lookDistance)

if isPlayer(thing.uid) and thing.uid ~= cid then

doPlayerSetSpecialDescription(thing.uid,'[Frags: '..getPlayerFrags(thing.uid)..']')

return true

elseif thing.uid == cid then

doPlayerSetSpecialDescription(cid,'[Frags: '..getPlayerFrags(cid)..']')

local string = 'You see yourself.'

if getPlayerFlagValue(cid, PLAYERFLAG_SHOWGROUPINSTEADOFVOCATION) then

string = string..' You are '.. getPlayerGroupName(cid) ..'.'

elseif getPlayerVocation(cid) ~= 0 then

string = string..' You are '.. getPlayerVocationName(cid) ..'.'

else

string = string..' You have no vocation.'

end

string = string..getPlayerSpecialDescription(cid)..''

if getPlayerNameByGUID(getPlayerPartner(cid), false, false) ~= nil then

string = string..' You are '.. (getPlayerSex(cid) == 0 and 'wife' or 'husband') ..' of '.. getPlayerNameByGUID(getPlayerPartner(cid)) ..'.'

end

if getPlayerGuildId(cid) > 0 then

string = string..' You are ' .. (getPlayerGuildRank(cid) == '' and 'a member' or getPlayerGuildRank(cid)) ..' of the '.. getPlayerGuildName(cid)

string = getPlayerGuildNick(cid) ~= '' and string..' ('.. getPlayerGuildNick(cid) ..').' or string..'.'

end

if getPlayerFlagValue(cid, PLAYERCUSTOMFLAG_CANSEECREATUREDETAILS) then

string = string..'nHealth: ['.. getCreatureHealth(cid) ..' / '.. getCreatureMaxHealth(cid) ..'], Mana: ['.. getCreatureMana(cid) ..' / '.. getCreatureMaxMana(cid) ..'].'

string = string..'nIP: '.. doConvertIntegerToIp(getPlayerIp(cid)) ..'.'

end

if getPlayerFlagValue(cid, PLAYERCUSTOMFLAG_CANSEEPOSITION) then

string = string..'nPosition: [X:'.. position.x..'] [Y:'.. position.y..'] [Z:'.. position.z..'].'

end

doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, string)

return false

end

return true

end

[jNo 104]

Usa esse do Vodkart

Antes de mais nada execute essa query na sua db:

ALTER TABLE `players` ADD `frags` INT NOT NULL DEFAULT '0'

data/talkactions/ranks.lua

local config = {

MaxPlayer = 20,

fight_skills = {

	    ['fist'] = 0,

	    ['club'] = 1,

	    ['sword'] = 2,

	    ['axe'] = 3,

	    ['distance'] = 4,

	    ['shielding'] = 5,

	    ['fishing'] = 6,

	    ['dist'] = 4,

	    ['shield'] = 5,

	    ['fish'] = 6,

},

other_skills = {

[''] = "level",

['level'] = "level",

['magic'] = "maglevel",

['health'] = "healthmax",

['mana'] = "manamax",

['frags'] = "frags"

},

vocations = {

['sorcerer'] = {1,5},

['druid'] = {2,6},

['paladin'] = {3,7},

['knight'] = {4,8}

}

}

function onSay(cid, words, param)

local param,str = string.lower(param),""

if not config.fight_skills[param] and not config.other_skills[param] and not config.vocations[param] then

doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "este rank não existe.") return true

end

str = "--[ RANK "..(param == "" and "LEVEL" or string.upper(param)).." ]--\n\n"

query = config.fight_skills[param] and db.getResult("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid` = "..config.fight_skills[param].." ORDER BY `value` DESC;") or config.other_skills[param] and db.getResult("SELECT `name`, `"..config.other_skills[param].."` FROM `players` WHERE `id` > 6 AND `group_id` < 2 ORDER BY `"..config.other_skills[param].."` DESC, `name` ASC;") or db.getResult("SELECT `name`, `level` FROM `players` WHERE `group_id` <= 2 AND `vocation` = "..config.vocations[param][1].." or `vocation` = "..config.vocations[param][2].." ORDER BY `level` DESC;")

if (query:getID() ~= -1) then

k = 1

while true do

str = str .. "\n " .. k .. ". "..(config.fight_skills[param] and getPlayerNameByGUID(query:getDataString("player_id")) or query:getDataString("name")).." - [" .. query:getDataInt(config.fight_skills[param] and "value" or config.vocations[param] and "level" or config.other_skills[param]) .. "]"

k = k + 1

if not(query:next()) or k > config.MaxPlayer then

break

end

end

query:free()

end

doShowTextDialog(cid,6500, str)

return true

end

na pasta mods

<?xml version="1.0" encoding="UTF-8"?> 

<mod name="other ranks" version="1.0" author="Vodkart" contact="#####.com" enabled="yes"> 

<config name="rankf_func"><![CDATA[

function getPlayerFrags(cid)

	    local time = os.time()

	    local times = {today = (time - 86400), week = (time - (7 * 86400))}

	    local contents, result = {day = {}, week = {}, month = {}}, db.getResult("SELECT `pd`.`date`, `pd`.`level`, `p`.`name` FROM `player_killers` pk LEFT JOIN `killers` k ON `pk`.`kill_id` = `k`.`id` LEFT JOIN `player_deaths` pd ON `k`.`death_id` = `pd`.`id` LEFT JOIN `players` p ON `pd`.`player_id` = `p`.`id` WHERE `pk`.`player_id` = " .. getPlayerGUID(cid) .. " AND `k`.`unjustified` = 1 AND `pd`.`date` >= " .. (time - (30 * 86400)) .. " ORDER BY `pd`.`date` DESC")

	    if(result:getID() ~= -1) then

			    repeat

					    local content = {date = result:getDataInt("date")}

					    if(content.date > times.today) then

							    table.insert(contents.day, content)

					    elseif(content.date > times.week) then

							    table.insert(contents.week, content)

					    else

							    table.insert(contents.month, content)

					    end

			    until not result:next()

			    result:free()

	    end

	    local size = {day = table.maxn(contents.day),week = table.maxn(contents.week),month = table.maxn(contents.month)}

	    return size.day + size.week + size.month

end

function setFrags(cid)

return db.executeQuery("UPDATE `players` SET `frags` = "..getPlayerFrags(cid).." WHERE `id` = "..getPlayerGUID(cid))

end

]]></config>

<event type="login" name="RankfLogin" event="script"><![CDATA[

function onLogin(cid)

registerCreatureEvent(cid, "RankfKill")

registerCreatureEvent(cid, "RankfLogin")

setFrags(cid)

return true

end]]></event>   

<event type="kill" name="RankfKill" event="script"><![CDATA[

domodlib('rankf_func')

function onKill(cid, target, lastHit)

if isPlayer(cid) and isPlayer(target) then

addEvent(setFrags, 50, cid)

end

return true

end]]></event>

</mod>

[ravely13 1]

é bom esse script funciona mais infelizmente meu serv ja esta online , e a galera ja tem frag , esse script iria contar do 0