A challenge for pro scripters

[Conficker]

Like /deathlist NAME, is there some way to see their kills list?
Like on real tibia, when you log in and search your character, it shows a list of people you killed.
I need a script to do that like /deathlist instead its /killslist

 

[Pitufo™]

USE SEARCH this script has been released already!

 

[Conficker]

USE SEARCH this script has been released already!

I've used search, I'm not stupid, and there's nothing close to what I need.

 

[slaw]

Yeah I also never saw it here.

But its, simple deathlist.lua edit, I'll post you 1 part, maybe you can finish it?

Change:
local deaths = db.getResult("SELECT `time`, `level`, `killed_by`, `altkilled_by` FROM `player_deaths` WHERE `player_id` = " .. targetGUID .. " ORDER BY `time` DESC;")

To:
local deaths = db.getResult("SELECT `player_id`, `time`, `level` FROM `player_deaths` WHERE `killed_by` = " .. targetGUID .. " or `altkilledby` = " .. targetGUID .. " ORDER BY `time` DESC;")

 

[Conficker]

Hrm, I'm not an elite scripter, but if you can help me with a little bit more clues, I may be able to figure out the rest.

 

[twinnightmare]

Well its pretty straight forward from what slawken is saying. make the new command /killlist or wahtever and make the lua file and copy deathlist from it then take and replace:
This

local deaths = db.getResult("SELECT `time`, `level`, `killed_by`, `altkilled_by` FROM `player_deaths` WHERE `player_id` = " .. targetGUID .. " ORDER BY `time` DESC;")

With:

local deaths = db.getResult("SELECT `player_id`, `time`, `level` FROM `player_deaths` WHERE 'killed_by` = " .. targetGUID .. " or `altkilledby` = " .. targetGUID .. " ORDER BY `time` DESC;")

edited
change

local lastHitKiller = deaths:getDataString("killed_by")

to

local lastHitKiller = deaths:getDataString("player_id")

remove

local mostDamageKiller = deaths:getDataString("altkilled_by")

and

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

change:

				str = str .. breakline .. " " .. time .. "  Died at Level " .. level .. " by " .. killed .. "."
				if not(deaths:next()) then
					break
				end
			end
			deaths:free()
		else
			str = "No deaths recorded."
		end
		doPlayerPopupFYI(cid, "Deathlist for player: " .. targetName .. ".\n\n" .. str)

to

				str = str .. breakline .. " " .. time .. " Killed " .. killed .." at Level " .. level .. "."
				if not(deaths:next()) then
					break
				end
			end
			deaths:free()
		else
			str = "No kills recorded."
		end
		doPlayerPopupFYI(cid, "Killlist for player: " .. targetName .. ".\n\n" .. str)

That is pretty much step for step hehehe. and all rep would def go to slawkens.
also this should be everything except for editing txt.

 

[Conficker]

Well its pretty straight forward from what slawken is saying. make the new command /killlist or wahtever and make the lua file and copy deathlist from it then take and replace:
This

local deaths = db.getResult("SELECT `time`, `level`, `killed_by`, `altkilled_by` FROM `player_deaths` WHERE `player_id` = " .. targetGUID .. " ORDER BY `time` DESC;")

With:

local deaths = db.getResult("SELECT `time`, `level`, `killed_by`, `altkilled_by` FROM `player_deaths` WHERE 'killed_by` = " .. targetGUID .. " or `altkilledby` = " .. targetGUID .. " ORDER BY `time` DESC;")

That is pretty much step for step hehehe. and all rep would def go to slawkens.

Uhm, he said there's more than just that to change.

 

[Zonet]

Yeah, maybe make so something pops up etc?

 

[twinnightmare]

Ok sry I was tired last night i edit my post and put a little bit more in to it.