Solved [TFS 1.0] Premiumscroll error (supposed to give 30 points)

[Napes]

Using TFS 1.0 & Znote AAC.

Error:

Code:

function onUse(cid, item, fromPosition, itemEx, toPosition)
local player = Player(cid)
local accountId = player:getAccountId()
db.query("UPDATE `znote_accounts` SET `points` = `points` + 30 WHERE `account_id` = " .. accountId)
player:sendTextMessage(MESSAGE_EVENT_ADVANCE, "You have been granted 30 shop credit to your account.")
player:getPosition():sendMagicEffect(CONST_ME_FIREWORK_BLUE)
Item(item.uid):remove()
return true
end

Solved - correct code ^

 

[clouf]

Yeah and change accounts to znote_accounts

 

[Ninja]

function onUse(cid, item, fromPosition, itemEx, toPosition)
    local player = Player(cid)
    local accountId = player:getAccountId()
    db.query("UPDATE `znote_accounts` SET `points` = `points` + 30 WHERE `account_id` = " .. accountId)
    player:sendTextMessage(MESSAGE_EVENT_ADVANCE, "You have been granted 30 shop credit to your account.")
    player:getPosition():sendMagicEffect(CONST_ME_FIREWORK_BLUE)
    Item(item.uid):remove()
    return true
end

 

[Napes]

Yeah and change accounts to znote_accounts

Lol, I thought I did that

function onUse(cid, item, fromPosition, itemEx, toPosition)
    local player = Player(cid)
    local accountId = player:getAccountId()
    db.query("UPDATE `znote_accounts` SET `points` = `points` + 30 WHERE `account_id` = " .. accountId)
    player:sendTextMessage(MESSAGE_EVENT_ADVANCE, "You have been granted 30 shop credit to your account.")
    player:getPosition():sendMagicEffect(CONST_ME_FIREWORK_BLUE)
    Item(item.uid):remove()
    return true
end

Thanks @Ninja, works perfectly