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

Login problem

Pagalve

New Member
Joined
Nov 25, 2008
Messages
6
Reaction score
0
Hey ya,
I just get error with login.
Somebody can help me?

Console:
Code:
 Account Manager has logged in.
 mysql_real_query(): SELECT `auction_balance` FROM `players` WHERE `id` = 1; - MYSQL ERROR: Unknown column 'auction_balance' in 'field list' (1054)

 Lua Script Error: [CreatureScript Interface] 
data/creaturescripts/scripts/login.lua:onLogin

 data/lib/database.lua:60: [Result:getDataInt] Result not set!
 stack traceback:
	[C]: in function 'error'
	data/lib/database.lua:60: in function 'getDataInt'
	data/creaturescripts/scripts/login.lua:53: in function <data/creaturescripts/scripts/login.lua:5>
 Account Manager has logged out.

And login.lua

Code:
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, "PlayerDeath")
	registerCreatureEvent(cid, "GuildMotd")
	registerCreatureEvent(cid, "Idle")
	registerCreatureEvent(cid, "SkullCheck")
	registerCreatureEvent(cid, "ReportBug")
        registerCreatureEvent(cid, "reward")  
        registerCreatureEvent(cid, "level")
        registerCreatureEvent(cid, "frag")
        registerCreatureEvent(cid, "demonOakLogout")
        registerCreatureEvent(cid, "demonOakDeath") 
        registerCreatureEvent(cid, "BountyHunter")
        registerCreatureEvent(cid, "WarAttack")
        registerCreatureEvent(cid, "WarKill")
        registerCreatureEvent(cid, "levelUp")
        registerCreatureEvent(cid, "monsterPortals")
		 registerCreatureEvent(cid, "ArenaKill")
	local auction = db.getResult("SELECT `auction_balance` FROM `players` WHERE `id` = " .. getPlayerGUID(cid) .. ";")
        if(auction:getDataInt("auction_balance") > 0) then
                doPlayerAddMoney(cid, auction:getDataInt("auction_balance"))
                doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "You sold item on auction, you get " .. auction:getDataInt("auction_balance") .. " gps.")
                db.executeQuery("UPDATE `players` SET `auction_balance` = 0 WHERE `id` = " .. getPlayerGUID(cid) .. ";")
                auction:free()
        end
		-- if he did not make full arena 1 he must start from zero
    if getPlayerStorageValue(cid, 42309) < 1 then
        for i = 42300, 42309 do
            setPlayerStorageValue(cid, i, 0)
        end
    end
    -- if he did not make full arena 2 he must start from zero
    if getPlayerStorageValue(cid, 42319) < 1 then
        for i = 42310, 42319 do
            setPlayerStorageValue(cid, i, 0)
        end
    end
    -- if he did not make full arena 3 he must start from zero
    if getPlayerStorageValue(cid, 42329) < 1 then
        for i = 42320, 42329 do
            setPlayerStorageValue(cid, i, 0)
        end
    end
    if getPlayerStorageValue(cid, 42355) == -1 then
        setPlayerStorageValue(cid, 42355, 0) -- did not arena level
    end
    setPlayerStorageValue(cid, 42350, 0) -- time to kick 0
    setPlayerStorageValue(cid, 42352, 0) -- is not in arena
	return true
end
 
Back
Top