Rank Frags

[Maenilse 9]

olá, estou tendo um problema com meu rank frags, ele funciona tudo normalmente, de boas mostra o rank, so q mesmo mostrando o rank tudo correto, fica aparecendo esse erro cada vez q o script é executado.

 

[11/07/2014 15:02:10] [Error - TalkAction Interface]
[11/07/2014 15:02:10] data/talkactions/scripts/ranks.lua:onSay
[11/07/2014 15:02:10] Description:
[11/07/2014 15:02:10] (luaGetPlayerNameByGUID) Player not found
[11/07/2014 15:02:10] Error during getDataString(name).
[11/07/2014 15:02:10] Error during getDataInt(value).
[11/07/2014 15:02:10] Error during getDataString(player_id).

[11/07/2014 15:02:10] [Error - TalkAction Interface]
[11/07/2014 15:02:10] data/talkactions/scripts/ranks.lua:onSay
[11/07/2014 15:02:10] Description:
[11/07/2014 15:02:10] (luaGetPlayerNameByGUID) Player not found
[11/07/2014 15:02:10] Error during getDataString(name).
[11/07/2014 15:02:10] Error during getDataInt(value).
[11/07/2014 15:02:10] Error during getDataString(player_id).

[11/07/2014 15:02:10] [Error - TalkAction Interface]
[11/07/2014 15:02:10] data/talkactions/scripts/ranks.lua:onSay
[11/07/2014 15:02:10] Description:
[11/07/2014 15:02:10] (luaGetPlayerNameByGUID) Player not found
[11/07/2014 15:02:11] Error during getDataString(name).
[11/07/2014 15:02:11] Error during getDataInt(value).

 

eu faço uso de MySQL, e gostaria q alguem resolve-se pra mim, vlw, script é esse.

local config = {
MaxPlayer = 10,
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"
},
vocations = {
['sorcerer'] = {1,5},
['druid'] = {2,6},
['paladin'] = {3,7},
['knight'] = {4,8}
},
storages = {
['frags'] = 824544
}
}
function onSay(cid, words, param)
local store,exausted = 156201,5
local param,str = string.lower(param),""
if not config.fight_skills[param] and not config.other_skills[param] and not config.vocations[param] and not config.storages[param] then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "this ranking does not exists.") return true
elseif getPlayerStorageValue(cid, store) >= os.time() then
doPlayerSendTextMessage(cid, 4, "Aguarde " .. getPlayerStorageValue(cid, store) - os.time() .. " segundos para usar o comando novamente.") 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 config.storages[param] and db.getResult("SELECT `player_id`, `value` FROM `player_storage` WHERE `key` = "..config.storages[param].." ORDER BY cast(value as SIGNED) DESC;") 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 config.storages[param] and getPlayerNameByGUID(query:getDataString("player_id")) or query:getDataString("name")).." - [" .. query:getDataInt((config.fight_skills[param] and "value" or config.storages[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)
setPlayerStorageValue(cid, store, os.time()+exausted)
return true
end

[slyton 51]

HUmm fas assim O Meu Brother.




Data/talkactions/scripts/crie o arquivo chamado Rankfrag.lua

function onSay(cid, words, param)
local max = 20
local letters_to_next = 20
local name_now
local name = "Top Frags\n"
local rkn = 0

name = name.."\n"
name = name.."Rank Killers - Nome do Jogador\n"
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;")
repeat
if v:getID() == -1 then
break
end
rkn = rkn+1
name_now, l = v:getDataString("name"), string.len(v:getDataString("name"))
name = name..rkn..". ["..v:getDataInt("frags").."] - "..name_now.." ".." ".."".."\n"
until v:next() == false
if name ~= "" then
doShowTextDialog(cid,1903, name)
end
return TRUE
end

Deopis vá em Data/talkactions/talkactions.xml e adicione isto.

<talkaction words="!topfrags" script="Rankfrag.lua.lua"/>

Ajudei? Rep ++

Editado Julho 11, 2014 por slyton (veja o histórico de edições)

[Maenilse 9]

mas esse ai é so o rank frags? tenso cara, pq aquele script que eu passei era todos os ranks inclusive o frags, mas irei testar.