[LUA] Convert Small Script

[DiegoRulez]

I would like this script to be converted so I can use it in my TFS 1.3 with Znote AAC.

Table: znote_accounts
Column: points

local function doPlayerAddPremiumPoints(cid, count)
        db.query('UPDATE accounts SET znote_accounts = znote_accounts+'.. count ..' WHERE id = ' .. getAccountNumberByPlayerName(getCreatureName(cid)))
end
function onUse(cid, item, fromPosition, itemEx, toPosition)
    doPlayerAddPremiumPoints(cid, 1)
    doSendMagicEffect(getCreaturePosition(cid), 2)
    doRemoveItem(item.uid,1)
    return true
end

Thanks to whom to help

 

[Himii]

db.query("UPDATE `znote_accounts` SET `points` = `points` + " .. count .. " WHERE `id` = " .. player:getAccountId())

Im not shure but it might work

 

[Infernum]

What are "premium points"?
That's a custom function that has no translation/conversion to 1.3 unless you show us its implementation.