When some die ? :O

[Teddy]

When some die this error/s come

[18/08/2009 17:41:04] mysql_real_query(): INSERT INTO `player_deaths` (`player_id`, `time`, `level`, `killed_by`, `altkilled_by`) VALUES (16, 1250642464, 51, '', ''); - MYSQL ERROR: Unknown column 'time' in 'field list' (1054)
[18/08/2009 17:41:04] mysql_real_query(): DELETE FROM `player_deaths` WHERE `player_id` = 16 ORDER BY `time` LIMIT 1; - MYSQL ERROR: Unknown column 'time' in 'order clause' (1054)

what do it do + how do i fix it ? :S

rep ofc!

 

[Sync]

Add the Query

ALTER TABLE player_deaths ADD time varchar(255) NOT NULL

 

[Teddy]

Reep+ i use 3.5.0p1
but i have this error to.

[18/08/2009 17:59:26] Lua Script Error: [CreatureScript Interface] 
[18/08/2009 17:59:26] data/creaturescripts/scripts/playerdeath.lua:onDeath

[18/08/2009 17:59:26] luaGetCreatureName(). Creature not found

[18/08/2009 17:59:26] Lua Script Error: [CreatureScript Interface] 
[18/08/2009 17:59:26] data/creaturescripts/scripts/playerdeath.lua:onDeath

[18/08/2009 17:59:26] luaGetCreatureName(). Creature not found

[18/08/2009 17:59:26] Lua Script Error: [CreatureScript Interface] 
[18/08/2009 17:59:26] data/creaturescripts/scripts/playerdeath.lua:onDeath

[18/08/2009 17:59:26] luaGetCreatureName(). Creature not found

.

 

[Sync]

Paste your playerDeath

 

[Teddy]

wups
here you go (rep 2)

local config = {
	deathListEnabled = getBooleanFromString(getConfigInfo('deathListEnabled')),
	sqlType = getConfigInfo('sqlType'),
	maxDeathRecords = getConfigInfo('maxDeathRecords')
}

config.sqlType = config.sqlType == "sqlite" and DATABASE_ENGINE_SQLITE or DATABASE_ENGINE_MYSQL

function onDeath(cid, corpse, lastHitKiller, mostDamageKiller)
	if(config.deathListEnabled ~= TRUE) then
		return
	end

	local hitKillerName = "field item"
	local damageKillerName = ""
	if(lastHitKiller ~= FALSE) then
		if(isPlayer(lastHitKiller) == TRUE) then
			hitKillerName = getPlayerGUID(lastHitKiller)
		else
			hitKillerName = getCreatureName(lastHitKiller)
		end

		if(mostDamageKiller ~= FALSE and mostDamageKiller ~= lastHitKiller and getCreatureName(mostDamageKiller) ~= getCreatureName(lastHitKiller)) then
			if(isPlayer(mostDamageKiller) == TRUE) then
				damageKillerName = getPlayerGUID(mostDamageKiller)
			else
				damageKillerName = getCreatureName(mostDamageKiller)
			end
		end
	end

	db.executeQuery("INSERT INTO `player_deaths` (`player_id`, `time`, `level`, `killed_by`, `altkilled_by`) VALUES (" .. getPlayerGUID(cid) .. ", " .. os.time() .. ", " .. getPlayerLevel(cid) .. ", " .. db.escapeString(hitKillerName) .. ", " .. db.escapeString(damageKillerName) .. ");")
	local rows = db.getResult("SELECT `player_id` FROM `player_deaths` WHERE `player_id` = " .. getPlayerGUID(cid) .. ";")
	if(rows:getID() ~= -1) then
		local amount = rows:getRows(true) - config.maxDeathRecords
		if(amount > 0) then
			if(config.sqlType == DATABASE_ENGINE_SQLITE) then
				for i = 1, amount do
					db.executeQuery("DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = " .. getPlayerGUID(cid) .. " ORDER BY `time` LIMIT 1);")
				end
			else
				db.executeQuery("DELETE FROM `player_deaths` WHERE `player_id` = " .. getPlayerGUID(cid) .. " ORDER BY `time` LIMIT " .. amount .. ";")
			end
		end
	end
end

 

[Sync]

Why do you even have a Player Death? 0.3.5 pl1 comes with no player death as it is built in.. 0.O? just remeberd that

 

[Teddy]

remove it from creaturescripts ?

 

[Sync]

yes

 

[Teddy]

yes

server crash then .. cant i fix the script ?
playerdeath

 

[Sync]

Are you sure your using 0.3.5 pl1? >.>

 

[Teddy]

Are you sure your using 0.3.5 pl1? >.>

yes but i havent replace all script's .. so its like 0.3.4/0.3.5p1 :O
cant i fix the death script work ?

 

[Sync]

Well, officially it is working. The error doesnt really do anything as far as i know.

 

[Teddy]

but how do i remove it .. ?
dont like errors XD

 

[Teddy]

Bumpy Bumpy

 

[Donio]

use some one elses playerdeath,,,

 

[Teddy]

use some one elses playerdeath,,,

i have .. can i fix this error ?
..
its not do something but i dont wanna have a console spam error every time when 1 player die..

 

[richux]

@up

Just update your tfs correctly.

 

[Teddy]

@up

Just update your tfs correctly.

how do i update so it not use playerdeath file? :S

 

[NilssoN]

how do i update so it not use playerdeath file? :S

<event type="login" name="PlayerLogin" event="script" value="login.lua"/>

local config = {
	loginMessage = getConfigValue('loginMessage')
}

function onLogin(cid)
	local loss = getConfigValue('deathLostPercent')
	if(loss ~= nil) then
		doPlayerSetLossPercent(cid, PLAYERLOSS_EXPERIENCE, loss * 10)
	end

	local accountManager = getPlayerAccountManager(cid)
	if(accountManager == MANAGER_NONE) then
		local lastLogin, str = getPlayerLastLoginSaved(cid), config.loginMessage
		if(lastLogin > 0) then
			doPlayerSendTextMessage(cid, MESSAGE_STATUS_DEFAULT, str)
			str = "Your last visit was on " .. os.date("%a %b %d %X %Y", lastLogin) .. "."
		else
			str = str .. " Please choose your outfit."
			doPlayerSendOutfitWindow(cid)
		end

		doPlayerSendTextMessage(cid, MESSAGE_STATUS_DEFAULT, str)
	elseif(accountManager == MANAGER_NAMELOCK) then
		doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Hello, it appears that your character has been namelocked, what would you like as your new name?")
	elseif(accountManager == MANAGER_ACCOUNT) then
		doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Hello, type 'account' to manage your account and if you want to start over then type 'cancel'.")
	else
		doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Hello, type 'account' to create an account or type 'recover' to recover an account.")
	end

	if(not isPlayerGhost(cid)) then
		doSendMagicEffect(getCreaturePosition(cid), CONST_ME_TELEPORT)
	end

	registerCreatureEvent(cid, "Mail")
	registerCreatureEvent(cid, "GuildMotd")
	registerCreatureEvent(cid, "Idle")
	registerCreatureEvent(cid, "SkullCheck")
	registerCreatureEvent(cid, "ReportBug")
	return true
end

There ya go ;p

 

[Zerak456]

btw 0.3.5 isnt to change the .exe

its files on another folder etc..