Unknown column 'acesstime' in 'field list'

[1268995]

Help!

 

[RosOT]

like this.. remove the % signs
[IMG%]http://i60.tinypic.com/1fu0j5.jpg[/IMG%]

 

[1268995]

Thanks RosOT! That's my problem!

bump.

 

[whitevo]

show us login.lua script and isnt acess written "access" ?

 

[narko]

It seems like you are missing a column called acesstime in guild's table.

Run this query

ALTER TABLE `guilds` ADD `acesstime` INT NOT NULL DEFAULT 0;

 

[1268995]

@narko , thanks, worked !!!
love youuuuu

 

[1268995]

@narko I need more help!
Now i got this problem:

 

[1268995]

OK, i found the problem:

ALTER TABLE `guilds` ADD `frags` INT(11) NOT NULL DEFAULT 0;

 

[1268995]

Dammit, new problem: @narko @Limos

stamina.lua =

function onUse(cid, item, frompos, item2, topos)
    doPlayerAddStamina(cid, 2520)
    doSendMagicEffect(frompos, 1)
    doRemoveItem(item.uid, 1)
return 1
end

edit: bump:

 

[narko]

function onUse(cid, item, fromPosition, itemEx, toPosition)
local cfg = {}
cfg.refuel = 42 * 60 * 1000
if(getPlayerStamina(cid) >= cfg.refuel) then
doPlayerSendCancel(cid, "Your stamina is already full.")
elseif(not isPremium(cid)) then
doPlayerSendCancel(cid, "You must have a premium account.")
else
doPlayerSetStamina(cid, cfg.refuel)
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Your stamina has been refilled.")
doRemoveItem(item.uid)
end
return true
end

 

[1268995]

Worked @narko ... When i use the stamina refiler item, i need to log out to stamina go full, stamina do not go full imediatly when i use the item, but
thats okay! thank you!! <im br, sorry crap english>

Player @Danger II also maded a script... this:

function onUse(cid, item, frompos, item2, topos)
doPlayerSetStamina(cid, getPlayerStamina(cid) + 2520)
doSendMagicEffect(frompos, 1)
doRemoveItem(item.uid, 1)
return 1
end

and happened the same thing: need to log out to stamina go full, stamina do not go full imediatly when i use the item.

Thanks to both!

 

[WibbenZ]

doPlayerSave(cid) or w/e the function is called.