• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Death error

Grehy

Grehy

Killroy
Joined
Nov 21, 2008
Messages
2,631
Reaction score
33
Location
United States
I get this every time someone dies;

[15/05/2009 23:21:31] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 122 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)


What can I do to fix it? Aol's are not dissapearing when people die, either
 
Sort by date Sort by votes
in file data/creaturescripts/playerdeath.lua
under


Code: 
function onDeath(cid, corpse, lastHitKiller, mostDamageKiller)

add

PHP: 
if getPlayerSlotItem(cid, 2).itemid == 2173 then
                doPlayerRemoveItem(cid, 2173, 1)
end


Regards,
Leiken.
 
Upvote 0 Downvote
Bump, I'm getting it CONSTANTLY

[16/05/2009 17:19:47] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 185 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:19:47] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 185 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:19:48] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 185 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:19:48] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 185 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:19:49] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 185 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:19:49] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 185 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:19:50] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 185 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:19:50] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 185 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:19:50] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 185 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:19:51] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 185 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:19:51] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 185 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:19:52] Saxer Druid has logged out.
[16/05/2009 17:19:53] Saxer Druid has logged in.
[16/05/2009 17:20:41] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 149 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:20:42] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 149 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:20:42] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 149 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:20:42] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 149 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:20:43] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 149 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:20:43] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 149 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:20:44] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 149 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:20:44] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 149 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:20:45] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 149 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:20:45] Mage Sorcer has logged out.
[16/05/2009 17:21:21] Mage Sorcer has logged in.
[16/05/2009 17:21:47] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 185 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:21:48] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 185 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:21:48] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 185 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:21:49] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 185 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:21:49] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 185 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:21:50] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 185 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:21:50] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 185 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:21:50] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 185 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:21:51] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 185 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:21:51] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 185 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:21:52] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 185 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:21:52] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 185 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:21:52] Saxer Druid has logged out.
[16/05/2009 17:21:54] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 158 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:21:55] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 158 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:21:55] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 158 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:21:55] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 158 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:21:56] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 158 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:21:56] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 158 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:21:57] mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 158 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
[16/05/2009 17:21:57] Under Dog has logged out.
[16/05/2009 17:21:58] Saxer Druid has logged in.
Click to expand...

I need this fixed, PLEASE! When ever someone dies, it freezes for about 3 seconds
 
Upvote 0 Downvote
Paste this to data/creaturescripts/scripts/playerdeath.lua
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
 
Upvote 0 Downvote
dzanar2 said:
paste this to data/creaturescripts/scripts/playerdeath.lua
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
Click to expand...


i fucking love you
 
Upvote 0 Downvote

Similar threads

WikiArk21
  • Question
Error MySql
Replies
0
Views
221
WikiArk21
WikiArk21
F
  • Question
TFS 1.X+ [tfs 1.4/1.5] edit database multiworld system
Replies
3
Views
601
lursky
L
J
  • Question
Myacc tfs 1.5 problem
Replies
8
Views
378
jareczekjsp
J
J
  • Question
Guild War tfs 1.5 problem
Replies
0
Views
173
jareczekjsp
J
E
  • Solved
TFS 1.X+ [Error - mysql_store_result] Query: SELECT 'QuestPoints' FROM 'players' WHERE 'id' =8
Replies
2
Views
274
Erna
E
ShadowProwl
  • Question
TFS 1.X+ MySQL errors
Replies
2
Views
268
ShadowProwl
ShadowProwl
tibera
  • Question
Lua playerdeath.lua
Replies
0
Views
189
tibera
tibera
Back
Top