Lua Playerdeath

[Zool]

[Error - CreatureScript Interface]
data/creaturescripts/scripts/playerdeath.luanDeath

its my playerdeath.lua \/

local config = {

	deathListEnabled = getBooleanFromString(getConfigInfo('deathListEnabled')),

	sqlType = getConfigInfo('sqlType'),

	maxDeathRecords = getConfigInfo('maxDeathRecords')

}



function onDeath(cid, corpse, lastHitKiller, mostDamageKiller)

	if(config.deathListEnabled == TRUE) then

		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:numRows(true) - config.maxDeathRecords)

			if(amount > 0) then

				if(config.sqlType == "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

end

 

[Strasxni]

Do you use sqlite?

 

[Zool]

i use mysql -.-

 

[Strasxni]

Then try this:

local config = {

	deathListEnabled = getBooleanFromString(getConfigInfo('deathListEnabled')),

	sqlType = getConfigInfo('sqlType'),

	maxDeathRecords = getConfigInfo('maxDeathRecords')

}



function onDeath(cid, corpse, lastHitKiller, mostDamageKiller)

	if(config.deathListEnabled == TRUE) then

		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:numRows(true) - config.maxDeathRecords)

			if(amount > 0) then

				if(config.sqlType == "mysql") 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

end

 

[Zool]

Dont work !! help me !!!!!