B?edy z logowaniem na serwer.

[Stogie]

Ot?? problem tyczy si? tego ,?e :

[03/03/2010 18:20:48] Tester has logged in.
[03/03/2010 18:20:48] mysql_real_query(): SELECT `auction_balance` FROM `players` WHERE `id` = 1; - MYSQL ERROR: Unknown column 'auction_balance' in 'field list' (1054)

[03/03/2010 18:20:48] [Error - CreatureScript Interface]
[03/03/2010 18:20:48] data/creaturescripts/scripts/login.luanLogin
[03/03/2010 18:20:48] Description:
[03/03/2010 18:20:48] data/lib/004-database.lua:60: [Result:getDataInt] Result not set!
[03/03/2010 18:20:48] stack traceback:
[03/03/2010 18:20:48] [C]: in function 'error'
[03/03/2010 18:20:48] data/lib/004-database.lua:60: in function 'getDataInt'
[03/03/2010 18:20:48] data/creaturescripts/scripts/login.lua:23: in function <data/creaturescripts/scripts/login.lua:12>
[03/03/2010 18:20:48] Tester has logged out.
[03/03/2010 18:20:48] > Broadcasted message: "New record: 1 players are logged in.".
[03/03/2010 18:21:04] mysql_real_query(): UPDATE `players` SET `onlinetime7`=players.onlinetime6, `onlinetime6`=players.onlinetime5, `onlinetime5`=players.onlinetime4, `onlinetime4`=players.onlinetime3, `onlinetime3`=players.onlinetime2, `onlinetime2`=players.onlinetime1, `onlinetime1`=players.onlinetimetoday, `onlinetimetoday`=0; - MYSQL ERROR: Unknown column 'onlinetime7' in 'field list' (1054)
[03/03/2010 18:21:04] mysql_real_query(): UPDATE `players` SET `exphist7`=players.exphist6, `exphist6`=players.exphist5, `exphist5`=players.exphist4, `exphist4`=players.exphist3, `exphist3`=players.exphist2, `exphist2`=players.exphist1, `exphist1`=players.experience-players.exphist_lastexp, `exphist_lastexp`=players.experience; - MYSQL ERROR: Unknown column 'exphist7' in 'field list' (1054)
[03/03/2010 18:21:04] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list' (1054)

Jak usun?? powy?sze b??dy ,chodzi tu oto ,?e gdy chc? si? zalogowa? wyskakuje error w consoli oraz bugi innego roadzaju.

Z tego ,co mi wiadomo mog? ju? dawa? repa wi?c nagrodz? +

 

[patrol114]

Odp: B?edy z logowaniem na serwer.

Masz zjeban? baze danych.

 

[Sebaso]

Odp: B?edy z logowaniem na serwer.

@up

lOl ?? jak sie nie znasz to po co piszesz takie komentarze...


Stogie Wymien login.lua na tego :

local config = {

	loginMessage = getConfigValue('loginMessage')

}



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, "Idle")

	registerCreatureEvent(cid, "SkullCheck")
registerCreatureEvent(cid, "PlayerDeath")
registerCreatureEvent(cid, "PlayerKill") 

	registerCreatureEvent(cid, "ReportBug")

	return true

end

2. Errror

Otworz data/globalevents/globalevents.xml

znajdz :

<globalevent name="history" interval="60" script="history.lua"/>

i usun cala linijke.