Alencar123

 

Tentei e da o este erro:

 

Lua Script Error: [Action Interface]
data/actions/scripts/aatua/points.lua:onUse
data/actions/scripts/aatua/points.lua:3: attempt to call field 'executeQuery' (a
 nil value)
stack traceback:
        [C]: in function 'executeQuery'
        data/actions/scripts/aatua/points.lua:3: in function <data/actions/scrip
ts/aatua/points.lua:1>

function onUse(cid, item, fromPosition, itemEx, toPosition)

local addpoints = 10 -- Numero de pontos a ser adicionado

db.query("UPDATE `accounts` SET `premium_points` = `premium_points` + "..addpoints.." WHERE `name` = '' ..getPlayerAccount(cid).. '';")

doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, ""..addpoints.." premium points have been added to your account.")

doRemoveItem(item.uid, 1)

return true

end

 

Amigo tive um progresso, o item sumiu apareceu a mensagem parecia ate que tinha funcionado, mais o ponto não foi pro site e apareceu esse erro:

 

 

[Error - mysql_real_query] Query: UPDATE `accounts` SET `premium_points` = `prem
ium_points` + 1 WHERE `name` = '' ..getPlayerAccount(cid).. '';
Message: You have an error in your SQL syntax; check the manual that corresponds
 to your MySQL server version for the right syntax to use near '..getPlayerAccou
nt(cid).. ''' at line 1

Não sei uma maneira de resolver isso.Tu tento usar esse:                                                       www.tibiaking.com/forum/topic/39332-pedido-item-que-gera-pontos-no-site/

local function doPlayerAddPremiumPoints(cid, ppoints)

db.query('UPDATE accounts SET premium_points=points+'.. ppoints ..' WHERE account_id=' .. getAccountNumberByPlayerName(getCreatureName(cid)))
end 


function onUse(cid, item, fromPosition, itemEx, toPosition) 
doPlayerAddPremiumPoints(cid, 30)
doPlayerSendTextMessage(cid, MESSAGE_EVENT_ADVANCE, "You have recived 30 shop points to your account.")
doSendMagicEffect(getCreaturePosition(cid), 28)
doRemoveItem(item.uid,1)
return true
end

Com esse novo código da esse novo erro:

 

 

[Error - mysql_real_query] Query: UPDATE accounts SET premium_points=points+1 WH
ERE account_id=449
Message: Unknown column 'account_id' in 'where clause'