Player deaths not working in 2.5

[mikeware]

Hey, i guess the table player_deaths not working, or the script.. player died in my server but nothing changed into the table, somebody know what's wrong?

thanks

 

[Jonern]

I tested it now, and it worked for me.

Check creaturescripts.xml and check that the script is correct (maybe try do replace it with the one in the SVN).

Also check that maxPlayerDeaths > 0 in config.lua.

 

[mikeware]

everything is all right, maybe the script is wrong... there's a new in the SVN ?

edit: I checked in the SVN sources and the newest playerdeath.lua is the one im using that simply it's not working, I die in the server and first the message "you are dead" don't appear, it was supposely to appear as I can see in the script, only the message you downgraded to lv x to y and nothing changes in the table player_deaths too =/

 

[Jonern]

Did you check creaturescripts.xml?

 

[mikeware]

Did you check creaturescripts.xml?

Yes, it's all right, at least i guess.

<?xml version="1.0" encoding="UTF-8"?>
<creaturescripts>
	<event type="login" name="PlayerLogin" script="login.lua"/>
	<event type="logout" name="PlayerLogout" script="logout.lua"/>
	<event type="death" name="PlayerDeath" script="playerdeath.lua"/>
</creaturescripts>

here's the playerdeath script:

function onDeath(cid, corpse, killer)
	doPlayerSendTextMessage(cid, MESSAGE_EVENT_ADVANCE, "You are dead.")
	dofile("./config.lua")
	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
	query = assert(con:execute("INSERT INTO `player_deaths` (`player_id`, `time`, `level`, `killed_by`, `is_player`) VALUES (" .. getPlayerGUIDByName(getCreatureName(cid)) .. ", " .. os.time() .. ", " .. getPlayerLevel(cid) .. ", '" .. getCreatureName(killer) .. "', " .. isPlayer(killer) .. ");"))
	local cursor = assert(con:execute("SELECT `player_id` FROM `player_deaths` WHERE `player_id` = " .. getPlayerGUIDByName(getCreatureName(cid)) .. ";"))
	local deathRecords = cursor:numrows()
	while deathRecords > maxDeathRecords do
		delete = assert(con:execute("DELETE FROM `player_deaths` WHERE `player_id` = " .. getPlayerGUIDByName(getCreatureName(cid)) .. " ORDER BY `time` LIMIT 1;"))
		deathRecords = deathRecords - 1
	end
	con:close()
	env:close()
end

 

[Pedro B.]

Show also the login.lua script, it might be an error when registering the event.

registerCreatureEvent(cid, "PlayerDeath")

 

[mikeware]

Well but in the login.lua script that comes with 2.5 dont have this thing into the script, its a revised version of login.lua?

 

[Jonern]

Make sure you got this in login.lua:

function onLogin(cid)
    registerCreatureEvent(cid, "PlayerDeath")
    return TRUE
end

 

[mikeware]

Make sure you got this in login.lua:

function onLogin(cid)
    registerCreatureEvent(cid, "PlayerDeath")
    return TRUE
end

ok i will try thanks, yesterday the svn database of TFS was off =/

 

[dekar]

since I cause that the bodies of the monsters disappear

 

[mikeware]

It's working now, close topic

thanks