TFS 1.X+ Premium poins scroll problem

[janes123]

Hello i use this script:

local points = 30 -- amount of premium points
function onUse(cid, item, fromPosition, itemEx, toPosition)
    if isPlayer(cid) == TRUE  then
local Sql = "UPDATE `accounts` SET `premium_points` = `premium_points` + "..points.." where id="..getPlayerAccountId(cid)
                 db.executeQuery(Sql)
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE,"You Have Received 30 Premium Point")
    doRemoveItem(item.uid)
    end
        return true
end

Error:

Lua Script Error: [Action Interface]
data/actions/scripts/premiumscroll.lua:onUse
data/actions/scripts/premiumscroll.lua:3: attempt to call global 'getPlayerAccountId' (a nil value)
stack traceback:
        [C]: in function 'getPlayerAccountId'
        data/actions/scripts/premiumscroll.lua:3: in function <data/actions/scripts/premiumscroll.lua:1>

 

[Webtimize]

You might be using an old/deprecated function. What TFS version are you rocking?

 

[jestem pro]

Your line(look at the end):

local Sql = "UPDATE `accounts` SET `premium_points` = `premium_points` + "..points.." where id="..getPlayerAccountId(cid)

How it should be:

local Sql = "UPDATE `accounts` SET `premium_points` = `premium_points` + "..points.." WHERE `id`= "..getPlayerAccountId(cid)..";"

 

[Infernum]

local points = 30 -- amount of premium points

function onUse(player, item, fromPosition, target, toPosition, isHotkey)
    db.query("UPDATE `accounts` SET `premium_points` = `premium_points` + ".. points .." where id=".. player:getAccountId()
    player:sendTextMessage(MESSAGE_STATUS_CONSOLE_BLUE,"You Have Received ".. points .." Premium Point".. (points > 1 and "s" or ""))
    item:remove(1)
    return true
end

 

[janes123]

You might be using an old/deprecated function. What TFS version are you rocking?

1.3

Your line(look at the end):

local Sql = "UPDATE `accounts` SET `premium_points` = `premium_points` + "..points.." where id="..getPlayerAccountId(cid)

How it should be:

local Sql = "UPDATE `accounts` SET `premium_points` = `premium_points` + "..points.." WHERE `id`= "..getPlayerAccountId(cid)..";"

Lua Script Error: [Action Interface]
data/actions/scripts/premiumscroll.lua:onUse
data/actions/scripts/premiumscroll.lua:3: attempt to call global 'getPlayerAccountId' (a nil value)
stack traceback:
        [C]: in function 'getPlayerAccountId'
        data/actions/scripts/premiumscroll.lua:3: in function <data/actions/scripts/premiumscroll.lua:1>

local points = 30 -- amount of premium points

function onUse(player, item, fromPosition, target, toPosition, isHotkey)
    db.query("UPDATE `accounts` SET `premium_points` = `premium_points` + ".. points .." where id=".. player:getAccountId()
    player:sendTextMessage(MESSAGE_STATUS_CONSOLE_BLUE,"You Have Received ".. points .." Premium Point".. (points > 1 and "s" or ""))
    item:remove(1)
    return true
end

Same error

 

[Bogart]

Static's post missed a ) at the end of line 4, try adding it.

 

[janes123]

Static's post missed a ) at the end of line 4, try adding it.

works but

[C]: in function 'getPlayerAccountId'
        data/actions/scripts/premiumscroll.lua:3: in function <data/actions/scripts/premiumscroll.lua:1>
[Error - mysql_real_query] Query: UPDATE `accounts` SET `premium_points` = `premium_points` + 30 where id=2
Message: Unknown column 'premium_points' in 'field list'

 

[Bogart]

Can't be possible, there's no "getPlayerAccountId" in his code.

 

[janes123]

Can't be possible, there's no "getPlayerAccountId" in his code.

Sorry

[Error - mysql_real_query] Query: UPDATE `accounts` SET `premium_points` = `premium_points` + 30 where id=2
Message: Unknown column 'premium_points' in 'field list'

 

[Nekiro]

Sorry

[Error - mysql_real_query] Query: UPDATE `accounts` SET `premium_points` = `premium_points` + 30 where id=2
Message: Unknown column 'premium_points' in 'field list'

Look into your accounts table, "premium_points" column (does not exist) is not where you store the premium points if you even store any there.

 

[janes123]

Look into your accounts table, "premium_points" column (does not exist) is not where you store the premium points if you even store any there.

how to add this column?

 

[Webtimize]

how to add this column?

ALTER TABLE `accounts` ADD `premium_points` INT NOT NULL;