Death Level Loss (0.3 beta 2) bug

Limannen · Jan 7, 2009

It seems to be a problem,
whenever I die by a monster/pk I don't loose any level.

Don't say:
*Change your loss % in config.lua
Cause that doesn't work !

Anyone know a solution?

/Limannen

christiandb · Jan 7, 2009

check ur database loss_experience

if i helped u rep++

Limannen · Jan 7, 2009

it's not that shit, but I would rep if you would have right

christiandb · Jan 7, 2009

what do u mean then? there is no death loss experience in beta 2

EvulMastah · Jan 7, 2009

What he said is right.

PHP:

UPDATE players SET loss_experience = 10 WHERE vocation < 5;
UPDATE players SET loss_experience = 7 WHERE vocation > 4;

Don Daniello · Jan 7, 2009

onkill creaturescripts, check console ?

Limannen · Jan 7, 2009

Ah...but, you know the issue or not?
Cuz I cant ! It's boring with high lvls on your server that wars,
and don't loose any levels at all.

Playerdeath in creature scripts:

Code:

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

EvulMastah · Jan 7, 2009

and return TRUE after last end, maybe this will help

Limannen · Jan 7, 2009

Where?

I suck at those scripts, just copy it and do it

I don't know where xD

/Limannen

EvulMastah · Jan 7, 2009

PHP:

    return TRUE
end -- last end = bottom of the file

Limannen · Jan 7, 2009

Playerdeath in creature scripts:

Code:

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
return TRUE

So that's the right script then?

EvulMastah · Jan 7, 2009

omigosh...

here, enjoy:

Code:

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
    return TRUE
end

Limannen · Jan 7, 2009

FUCK ! This didn't work.

This is totally wierd...I mean, does all of the players has this problem then?
Cuz then 'erpot' got some really bugs on his ot

Gangsta-jr · Jan 7, 2009

Every thought of executing

Code:

UPDATE `otserv`.`players` SET `loss_experience` = '10', `loss_mana` = '10', `loss_skills` = '10', `loss_items` = '10';

in phpmyadmin->database->SQL?

@Edit this worked for me

Limannen · Jan 7, 2009

Didn't work.

:S

Raliuga · Jan 8, 2009

Gangsta-jr said:
Every thought of executing

Code:

UPDATE `otserv`.`players` SET `loss_experience` = '10', `loss_mana` = '10', `loss_skills` = '10', `loss_items` = '10';

in phpmyadmin->database->SQL?

@Edit this worked for me

this one worked for me =)

Limannen · Jan 8, 2009

HEY, I noticed that

UPDATE players SET loss_experience = 10 WHERE vocation < 5;
UPDATE players SET loss_experience = 7 WHERE vocation > 4;

That this worked, but how do I add so every loss thing is 10% ?

Cuz the mana/skills are 0 !

Gangsta-jr · Jan 8, 2009

Try like this ^^

If that aint working I can't help ya out

Code:

UPDATE players SET loss_mana = 10 WHERE vocation < 5;
UPDATE players SET loss_mana = 10 WHERE vocation > 4;

Code:

UPDATE players SET loss_skills = 10 WHERE vocation < 5;
UPDATE players SET loss_skills = 10 WHERE vocation > 4;

Code:

UPDATE players SET loss_items = 10 WHERE vocation < 5;
UPDATE players SET loss_items = 10 WHERE vocation > 4;

axxon · Jan 11, 2009

Well, it worked for me, but lvl 150+ dont work ^^

Death Level Loss (0.3 beta 2) bug

Limannen

Member

christiandb

Member

Limannen

Member

christiandb

Member

EvulMastah

๏̯͡๏﴿

Don Daniello

/root

Limannen

Member

EvulMastah

๏̯͡๏﴿

Limannen

Member

EvulMastah

๏̯͡๏﴿

Limannen

Member

EvulMastah

๏̯͡๏﴿

Limannen

Member

Gangsta-jr

You are an elite knight

Limannen

Member

Raliuga

OTFusion founder

Limannen

Member

Gangsta-jr

You are an elite knight

axxon

http://otservlist.org/ots

Similar threads