Windows My SQL bugg + Gesior Bugg Installation + Login Bugg

[jo31_99]

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)


THIS POPUPS IN MY CONSOLE ALL THE TIME !!


SELECT *
FROM `bans`
LIMIT 0 , 300


[THIS IS HOW MY BANS IN PHPMYADMIN LOOKS LIKE.]...



And to my Second thing ..

When im installing gesior like in the installation guide ..
it looks like this ..
IF NOT INSTALLED:
0. Informations
1. Set server path
2. Check DataBase connection
3. Add tables and columns to DB
4. Add samples to DB
5. Set Admin Account
FOR ADMINS:
6. Load Monsters from OTS
7. Load Spells from OTS


I HAVE DONE ALL..
but when I go to Swev.sytes.net (without additional /install.php blabla shit,,)
It doesn't exist.




WHEN I RELOGG IN MY CHARACTER ..
IT COMES TO A PLACE WHERE IT FIRST LOGINPLACE.
EXAMPLE : new player log in to x1000 y1000 z7

then when I go to x1200 y1200 z7 and RELOGG .. I come to x1000 y1000 z7 again..


I hate those buggs ..
AND MY ZOMBIES IN MY ZOMBIEEVENT WONT SPAWN !!!!







When my friends make account it says : Invalid Token.





THIS WAS ALL BUGGS OF THE SERVER !!!!





REP ++++++
TO THE ONE WHO HELP ME ~~ PLEASE HELP !!! SWEV.SYTES.NET

 

[tetra20]

1-i can't read anything
2-don't use bold and fucking big text
3-i won't help you until you change it

 

[jo31_99]

ok.

- - - Updated - - -

Done

 

[tetra20]

look in your login.lua for any teleport..for the invalid town id try to set your town id correctly in remere and config.. for zombie event which tfs are you using

 

[gelendizer]

for the zombie event check that you have put the correct map place in your data/lib/zombie_event.lua

 

[jo31_99]

im using 0.3.6
I have 0.4.0 but I don't want to change all my scripts and shit..



local config = {
loginMessage = getConfigValue('loginMessage'),
useFragHandler = getBooleanFromString(getConfigValue('useFragHandler'))
}

function onLogin(cid)
local loss = getConfigValue('deathLostPercent')
if(loss ~= nil) then
doPlayerSetLossPercent(cid, PLAYERLOSS_EXPERIENCE, loss * 10)
end

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, "Mail")
registerCreatureEvent(cid, "GuildMotd")
registerCreatureEvent(cid, "demonOakLogout")
registerCreatureEvent(cid, "demonOakDeath")
registerCreatureEvent(cid, "DeathBroadcast")
registerCreatureEvent(cid, "MonsterPortal")

registerCreatureEvent(cid, "Idle")
if(config.useFragHandler) then
registerCreatureEvent(cid, "SkullCheck")
end

registerCreatureEvent(cid, "ReportBug")
registerCreatureEvent(cid, "AdvanceSave")
return true
end





AND MY TOWN IDS ARE ALL THE SAME.

- - - Updated - - -

BUMP !

- - - Updated - - -

Bump