[Broadcast] When Player Gets Killed

[justin234]

Thanks - Close Please

 

[EvulMastah]

dofile("./config.lua")

function onDeath(cid, corpse, killer)
	doPlayerSendTextMessage(cid, MESSAGE_EVENT_ADVANCE, "You are dead.")
	if deathListEnabled == "yes" then
		if sqlType == "mysql" then
			env = assert(luasql.mysql())
			con = assert(env:connect(mysqlDatabase, mysqlUser, mysqlPass, mysqlHost, mysqlPort))
		else -- sqlite
			env = assert(luasql.sqlite3())
			con = assert(env:connect(sqliteDatabase))
		end
		local byPlayer = FALSE
		if killer == FALSE then
			killerName = "field item"
		else
			if isPlayer(killer) == TRUE then
				byPlayer = TRUE
			end
			killerName = getCreatureName(killer)
			if byPlayer == TRUE then
				broadcastMessage(getCreatureName(cid).." was killed at level "..getPlayerLevel(cid).." by "..killerName, MESSAGE_STATUS_WARNING)
			else
				broadcastMessage(getCreatureName(cid).." was killed at level "..getPlayerLevel(cid).." by a "..killerName, MESSAGE_STATUS_WARNING)
			end
		end
		assert(con:execute("INSERT INTO `player_deaths` (`player_id`, `time`, `level`, `killed_by`, `is_player`) VALUES (" .. getPlayerGUID(cid) .. ", " .. os.time() .. ", " .. getPlayerLevel(cid) .. ", '" .. escapeString(killerName) .. "', " .. byPlayer .. ");"))
		local cursor = assert(con:execute("SELECT `player_id` FROM `player_deaths` WHERE `player_id` = " .. getPlayerGUID(cid) .. ";"))
		local deathRecords = numRows(cursor)
		if sqlType == "mysql" then
			while deathRecords > maxDeathRecords do
				delete = assert(con:execute("DELETE FROM `player_deaths` WHERE `player_id` = " .. getPlayerGUID(cid) .. " ORDER BY `time` LIMIT 1;"))
				deathRecords = deathRecords - 1
			end
		else
			while deathRecords > maxDeathRecords do
				delete = assert(con:execute("DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = " .. getPlayerGUID(cid) .. " ORDER BY `time` LIMIT 1);"))
				deathRecords = deathRecords - 1
			end
		end
		con:close()
		env:close()
	end
end

Try this one.

 

[justin234]

onDeath doesnt work with the latest tfs.

 

[EvulMastah]

O rly?

case CREATURE_EVENT_DEATH:
			return "onDeath";
			break;

Tfs 0.2 Patch 16.

 

[Shawak]

where i must add the code?

 

[EvulMastah]

data/creaturescripts/scripts/playerdeath.lua
Just replace it.

Note: It is only for TFS 0.2

 

[Zonet]

Marcinek can't you do if only players get killed by a player then broadcast ?

 

[pierroth]

mine its not working, no I'm not using this script but the one that comes with TFS 0.3 and the player the got the frag won't appear. It shows a number instead of the name.

 

[Zonet]

if isPlayer(cid) == TRUE then

 

[Kaorus]

Thx