TalkAction !deathlist worked

[Caarolina]

add in talkaction.xml:

<talkaction words="!deathlist" hide="yes" event="script" value="deathlist.lua"/>

create a file called deathlist.lua in talkaction/scripts:

local config = {displayLimit = 10}

function onSay(cid, words, param, channel)
local target = db.getResult("SELECT `name`, `id` FROM `players` WHERE `name` = " .. db.escapeString(param) .. ";")
if(target:getID() == -1) then
doPlayerSendCancel(cid, "A player with that name does not exist.")
return TRUE
end

local targetName = target:getDataString("name")
local targetGUID = target:getDataInt("id")
target:free()

local str = ""
local deaths = db.getResult("SELECT `time`, `level`, `killed_by`, `altkilled_by` FROM `player_deaths` WHERE `player_id` = " .. targetGUID .. " ORDER BY `time` DESC;")
if(deaths:getID() ~= -1) then
local n = 0
local breakline = ""
repeat
n = n + 1
if(str ~= "") then
breakline = "\n"
end

local time = os.date("%d %B %Y %X ", deaths:getDataInt("time"))
local level = deaths:getDataInt("level")
local lastHitKiller = deaths:getDataString("killed_by")
local mostDamageKiller = deaths:getDataString("altkilled_by")

local killed = ""
if(tonumber(lastHitKiller)) then
killed = getPlayerNameByGUID(tonumber(lastHitKiller))
else
killed = getArticle(lastHitKiller) .. " " .. string.lower(lastHitKiller)
end

if(mostDamageKiller ~= "") then
if(tonumber(mostDamageKiller)) then
killed = killed .. " and by " .. getPlayerNameByGUID(tonumber(mostDamageKiller))
else
killed = killed .. " and by " .. getArticle(mostDamageKiller) .. " " .. string.lower(mostDamageKiller)
end
end

str = str .. breakline .. " " .. time .. " Died at Level " .. level .. " by " .. killed .. "."
until not(deaths:next()) or n > config.displayLimit
deaths:free()
else
str = "No deaths recorded."
end

doPlayerPopupFYI(cid, "Deathlist for player: " .. targetName .. ".\n\n" .. str)
return TRUE
end

tested server: cryingdamson0.3.6pl1

credits: GT Thionix

Enjoy =)

 

[sorcerers king]

Yes, good job.

 

[JuanC]

Is for personal deaths or kills to other players?

 

[3li Xiber]

[16/01/2015 09:59:45] Error during getDataInt(time).
[16/01/2015 09:59:45] Error during getDataString(killed_by).
[16/01/2015 09:59:45] Error during getDataString(altkilled_by).
[16/01/2015 09:59:45] Error during getDataInt(time).
[16/01/2015 09:59:45] Error during getDataString(killed_by).
[16/01/2015 09:59:45] Error during getDataString(altkilled_by).
[16/01/2015 09:59:45] Error during getDataInt(time).
[16/01/2015 09:59:45] Error during getDataString(killed_by).
[16/01/2015 09:59:45] Error during getDataString(altkilled_by).
[16/01/2015 09:59:45] Error during getDataInt(time).
[16/01/2015 09:59:45] Error during getDataString(killed_by).
[16/01/2015 09:59:45] Error during getDataString(altkilled_by).