• 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!

Help with some normal buggs !

J

jo31_99

Senior Member
Joined
Jul 23, 2011
Messages
56
Reaction score
1
Location
Sweden
FIRST ..
MY CONSOLE BUGGS WHEN PEOPLE LOG IN / OUT
[10/07/2013 00:45:17] Power has logged out.
[10/07/2013 00:45:17] mysql_real_query(): DELETE FROM `player_depotitems` WHERE `player_id` = 13 - MYSQL ERROR: Unknown column 'player_id' in 'where clause' (1054)
[10/07/2013 00:45:17] mysql_real_query(): DELETE FROM `player_depotitems` WHERE `player_id` = 13 - MYSQL ERROR: Unknown column 'player_id' in 'where clause' (1054)
[10/07/2013 00:45:18] mysql_real_query(): DELETE FROM `player_depotitems` WHERE `player_id` = 13 - MYSQL ERROR: Unknown column 'player_id' in 'where clause' (1054)
[10/07/2013 00:45:18] Error while saving player: Power.
[10/07/2013 00:45:32] mysql_real_query(): SELECT `id`, `value`, `param`, `expires` FROM `bans` WHERE `type` = 1 AND `active` = 1 - MYSQL ERROR: Unknown column 'id' in 'field list' (1054)
[10/07/2013 00:45:32] mysql_real_query(): SELECT * FROM `bans` WHERE `value` = 6 AND `type` = 3 AND `active` = 1 AND (`expires` > 1373409932 OR `expires` <= 0) LIMIT 1 - MYSQL ERROR: Unknown column 'value' in 'where clause' (1054)
[10/07/2013 00:45:34] mysql_real_query(): SELECT `id`, `value`, `param`, `expires` FROM `bans` WHERE `type` = 1 AND `active` = 1 - MYSQL ERROR: Unknown column 'id' in 'field list' (1054)
[10/07/2013 00:45:34] mysql_real_query(): SELECT * FROM `bans` WHERE `value` = 6 AND `type` = 3 AND `active` = 1 AND (`expires` > 1373409934 OR `expires` <= 0) LIMIT 1 - MYSQL ERROR: Unknown column 'value' in 'where clause' (1054)
[10/07/2013 00:45:34] mysql_real_query(): SELECT * FROM `bans` WHERE `value` = 268440513 AND `param` = 3 AND `type` = 2 AND `active` = 1 AND (`expires` > 1373409934 OR `expires` <= 0) LIMIT 1 - MYSQL ERROR: Unknown column 'value' in 'where clause' (1054)
[10/07/2013 00:45:34] mysql_real_query(): SELECT `id` FROM `bans` WHERE `type` = 2 AND `value` = 15 AND `param` = 2 AND `active` = 1 LIMIT 1 - MYSQL ERROR: Unknown column 'id' in 'field list' (1054)
[10/07/2013 00:45:34] mysql_real_query(): SELECT `pid`, `sid`, `itemtype`, `count`, `attributes` FROM `player_depotitems` WHERE `player_id` = 15 ORDER BY `sid` DESC - MYSQL ERROR: Unknown column 'pid' in 'field list' (1054)
[10/07/2013 00:45:34] Plepet has logged in.



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
AND THIS
mysql_real_query(): SELECT * FROM `bans` WHERE `value` = 2 AND `type` = 3 AND `active` = 1 AND (`expires` > 1373310621 OR `expires` <= 0) LIMIT 1 - MYSQL ERROR: Unknown column 'value' in 'where clause' (1054)
AND IT GOES ON AND ON EVERY TIME SOMEONE LOGS IN



__________________________________________________________________________________________________________________________________________________________
AND THIS POPUPS WHEN I CLOSE SERVER
Server Saved...

mysql_real_query(): SELECT `listid`, `list` FROM `house_lists` WHERE `house_id` = 6 AND `world_id` = 0 - MYSQL ERROR: Unknown column 'listid' in 'field list' (1054)
mysql_real_query(): SELECT `listid`, `list` FROM `house_lists` WHERE `house_id` = 7 AND `world_id` = 0 - MYSQL ERROR: Unknown column 'listid' in 'field list' (1054)
mysql_real_query(): SELECT `listid`, `list` FROM `house_lists` WHERE `house_id` = 8 AND `world_id` = 0 - MYSQL ERROR: Unknown column 'listid' in 'field list' (1054)
blabla...
and it goes like this untill house 80+
here is a pic


<a href="https://imgur.com/U31Owfs"><img src="https://i.imgur.com/U31Owfs.png" title="Hosted by imgur.com" /></a>

SECOND

WHEN PEOPLE RELOGG INGAME..
THEY COME TO WHERE THEY LAST "SAVED"
SO EXAMPLE.

Example One : Logging in on x1000 y1000 z7 then moving to x1002 y1005 z7 and re-logs.
He come to x1000 y1000 z7 again..

SAME WITH ALL POSITIONS.


THIRD
Zombies Wont Spawn in Zombie Event !!

Data/lib/zombie_event
Code: 
-- CONFIG
ZE_DEFAULT_NUMBER_OF_PLAYERS = 5
ZE_ACCESS_TO_IGNORE_ARENA = 6
-- POSITIONS
ZE_blockEnterItemPosition = {x= 1638, y=1531, z=7}
ZE_enterPosition = {x = 1630, y = 1575, z = 7}
ZE_kickPosition = {x=1000, y=1000, z=7}
ZE_spawnFromPosition = {x = 1608, y = 1553, z = 7}
ZE_spawnToPosition = {x = 1648, y = 1580, z = 7}
-- ITEM IDS
ZE_blockEnterItemID = 2700
-- STORAGES
-- - player
ZE_isOnZombieArea = 34370
-- - global
ZE_STATUS = 0 -- =< 0 - off, 1 - waiting for players, 2 - is running
ZE_PLAYERS_NUMBER = 34371
ZE_ZOMBIES_TO_SPAWN = 100
ZE_ZOMBIES_SPAWNED = 0
 
-- FUNCTION
 
function setZombiesEventPlayersLimit(value)
	doSetStorage(ZE_PLAYERS_NUMBER, value)
end
 
function getZombiesEventPlayersLimit()
	return getStorage(ZE_PLAYERS_NUMBER)
end
 
function addPlayerToZombiesArea(cid)
	doSendMagicEffect(getThingPosition(cid), CONST_ME_TELEPORT)
	doTeleportThing(cid, ZE_enterPosition, true)
	doSendMagicEffect(getThingPosition(cid), CONST_ME_TELEPORT)
	if(getPlayerAccess(cid) < ZE_ACCESS_TO_IGNORE_ARENA) then
		setPlayerZombiesEventStatus(cid, os.time())
	end
end
 
function kickPlayerFromZombiesArea(cid)
	doSendMagicEffect(getThingPosition(cid), CONST_ME_TELEPORT)
	doTeleportThing(cid, ZE_kickPosition, true)
	doSendMagicEffect(getThingPosition(cid), CONST_ME_TELEPORT)
	setPlayerZombiesEventStatus(cid, 0)
end
 
function getPlayerZombiesEventStatus(cid)
	return getCreatureStorage(cid, ZE_isOnZombieArea)
end
 
function setPlayerZombiesEventStatus(cid, value)
	doCreatureSetStorage(cid, ZE_isOnZombieArea, value)
end
 
function getZombiesEventPlayers()
	local players = {}
	for i, cid in pairs(getPlayersOnline()) do
		if(getPlayerZombiesEventStatus(cid) > 0) then
			table.insert(players, cid)
		end
	end
	return players
end
 
function getZombiesCount()
	return getStorage(ZE_ZOMBIES_SPAWNED)
end
 
function addZombiesCount()
	doSetStorage(ZE_ZOMBIES_SPAWNED, getStorage(ZE_ZOMBIES_SPAWNED)+1)
end
 
function resetZombiesCount()
	doSetStorage(ZE_ZOMBIES_SPAWNED, 0)
end
 
function getZombiesToSpawnCount()
	return getStorage(ZE_ZOMBIES_TO_SPAWN)
end
 
function setZombiesToSpawnCount(count)
	doSetStorage(ZE_ZOMBIES_TO_SPAWN, count)
end
 
function addZombiesEventBlockEnterPosition()
	if(getTileItemById(ZE_blockEnterItemPosition, ZE_blockEnterItemID).uid == 0) then
		doCreateItem(ZE_blockEnterItemID, 1, ZE_blockEnterItemPosition)
	end
end
 
function removeZombiesEventBlockEnterPosition()
	local item = getTileItemById(ZE_blockEnterItemPosition, ZE_blockEnterItemID)
	if(item.uid ~= 0) then
		doRemoveItem(item.uid)
	end
end
 
function spawnNewZombie()
	local posx = {}
	local posy = {}
	local posz = {}
	local pir = {}
	for i=1, 5 do
		local posx = math.random(ZE_spawnFromPosition.x ,ZE_spawnToPosition.x)
		local posy = math.random(ZE_spawnFromPosition.y ,ZE_spawnToPosition.y)
		local posz = math.random(ZE_spawnFromPosition.z ,ZE_spawnToPosition.z)
		local pir = 0
		local spec = getSpectators({x=posx_tmp, y=posy_tmp, z=posz_tmp}, 3, 3, false)
		if(spec and #spec > 0) then
			for z, pid in pairs(spec) do
				if(isPlayer(pid)) then
					pir_tmp = pir_tmp + 1
				end
			end
		end
		posx[i] = posx_tmp
		posy[i] = posy_tmp
		posz[i] = posz_tmp
		pir[i] = pir_tmp
	end
	local lowest_i = 1
	for i=2, 5 do
		if(pir[i] < pir[lowest_i]) then
			lowest_i = i
		end
	end
	local ret = (type(doCreateMonster("Zombie Event", {x=posx[lowest_i], y=posy[lowest_i], z=posz[lowest_i]}, true)) == 'number')
	if(ret) then
		addZombiesCount()
	end
	return ret
end

FOURTH
Some of my Tables in my Website wont work.
I downloaded a layout and NEW MODERN AAC [NO Edits Exept Config and index and shit]
Swev , New Start By Ricco.
 
Last edited:
Sort by date Sort by votes
1- your sql is missing some squery sorry i can't help you with that ask Znote
2-look in your creaturescript folder in login and paste it here
3-paste the error and i will herlp you
 
Upvote 0 Downvote
3- ??
post what error ?
Code: 
 local config = {
 loginMessage = getConfigValue('loginMessage'),
 useFragHandler = getBooleanFromString(getConfigValue('useFragHandler'))
}

function onLogin(cid)
 

 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, "ZombieAttack")
 registerCreatureEvent(cid, "Mail")
 registerCreatureEvent(cid, "GuildMotd")

 registerCreatureEvent(cid, "Idle")
 if(config.useFragHandler) then
  registerCreatureEvent(cid, "SkullCheck")
 end
 registerCreatureEvent(cid, "playerd")
 registerCreatureEvent(cid, "logoout")
 registerCreatureEvent(cid, "BlessLogin")
 registerCreatureEvent(cid, "ReportBug")
 registerCreatureEvent(cid, "AdvanceSave")
 return true
end

- - - Updated - - -

[10/07/2013 00:45:17] Power has logged out.
[10/07/2013 00:45:17] mysql_real_query(): DELETE FROM `player_depotitems` WHERE `player_id` = 13 - MYSQL ERROR: Unknown column 'player_id' in 'where clause' (1054)
[10/07/2013 00:45:17] mysql_real_query(): DELETE FROM `player_depotitems` WHERE `player_id` = 13 - MYSQL ERROR: Unknown column 'player_id' in 'where clause' (1054)
[10/07/2013 00:45:18] mysql_real_query(): DELETE FROM `player_depotitems` WHERE `player_id` = 13 - MYSQL ERROR: Unknown column 'player_id' in 'where clause' (1054)
[10/07/2013 00:45:18] Error while saving player: Power.
[10/07/2013 00:45:32] mysql_real_query(): SELECT `id`, `value`, `param`, `expires` FROM `bans` WHERE `type` = 1 AND `active` = 1 - MYSQL ERROR: Unknown column 'id' in 'field list' (1054)
[10/07/2013 00:45:32] mysql_real_query(): SELECT * FROM `bans` WHERE `value` = 6 AND `type` = 3 AND `active` = 1 AND (`expires` > 1373409932 OR `expires` <= 0) LIMIT 1 - MYSQL ERROR: Unknown column 'value' in 'where clause' (1054)
[10/07/2013 00:45:34] mysql_real_query(): SELECT `id`, `value`, `param`, `expires` FROM `bans` WHERE `type` = 1 AND `active` = 1 - MYSQL ERROR: Unknown column 'id' in 'field list' (1054)
[10/07/2013 00:45:34] mysql_real_query(): SELECT * FROM `bans` WHERE `value` = 6 AND `type` = 3 AND `active` = 1 AND (`expires` > 1373409934 OR `expires` <= 0) LIMIT 1 - MYSQL ERROR: Unknown column 'value' in 'where clause' (1054)
[10/07/2013 00:45:34] mysql_real_query(): SELECT * FROM `bans` WHERE `value` = 268440513 AND `param` = 3 AND `type` = 2 AND `active` = 1 AND (`expires` > 1373409934 OR `expires` <= 0) LIMIT 1 - MYSQL ERROR: Unknown column 'value' in 'where clause' (1054)
[10/07/2013 00:45:34] mysql_real_query(): SELECT `id` FROM `bans` WHERE `type` = 2 AND `value` = 15 AND `param` = 2 AND `active` = 1 LIMIT 1 - MYSQL ERROR: Unknown column 'id' in 'field list' (1054)
[10/07/2013 00:45:34] mysql_real_query(): SELECT `pid`, `sid`, `itemtype`, `count`, `attributes` FROM `player_depotitems` WHERE `player_id` = 15 ORDER BY `sid` DESC - MYSQL ERROR: Unknown column 'pid' in 'field list' (1054)
[10/07/2013 00:45:34] Plepet has logged in.

- - - Updated - - -

AHA , Zombie event error..
Nothing is error , just it don't spawn zombies and if I start event..
it is on forever.
 
Upvote 0 Downvote
As far as your MySQL issue comes, id just download a new mysql.sql db table and put it in ur schemas folder and run that instead, And what Release (Distro) are you guys using
 
Upvote 0 Downvote
okey , can you link the new MQL folder ?
xd

- - - Updated - - -

0.3.6 : 3426 TFS

- - - Updated - - -

BUMP

- - - Updated - - -

HERE IS MY MUGGS
U31Owfs.png
 
Last edited:
Upvote 0 Downvote
Try "house_list" not `house_list`
example ... WHERE `name` = "Urban"
(When you have String you need write in " ")
 
Upvote 0 Downvote

Similar threads

WikiArk21
  • Question
Error MySql
Replies
0
Views
242
WikiArk21
WikiArk21
F
  • Question
TFS 1.X+ [tfs 1.4/1.5] edit database multiworld system
Replies
3
Views
650
lursky
L
J
  • Question
Guild War tfs 1.5 problem
Replies
0
Views
197
jareczekjsp
J
OTcreator
  • Question
TFS 0.X MySQL [2013] - guild ranks
Replies
1
Views
373
tobi132
T
ShadowProwl
  • Question
TFS 1.X+ MySQL errors
Replies
6
Views
432
Codinablack
Codinablack
johnsamir
  • Question
how to solve these errors that has appeared in my database
Replies
2
Views
649
johnsamir
johnsamir
J
  • Question
Auto Blessing problem
Replies
3
Views
527
jareczekjsp
J
potinho
  • Question
Lua [TFS 0.X] Svarground Arena - Bug sometimes
Replies
0
Views
300
potinho
potinho
Back
Top