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
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.
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: