Premium points on Use

[Hokku]

Hello, i was looking for a action script, on use x item, give x premium points, i tried this one but not working, also i tried to modifiy it but nthing!
Im using TFS 1.1
https://otland.net/threads/onuse-item-add-x-points.170538/

 

[president vankk]

local function doPlayerAddPremiumPoints(cid, count)
   db.query('UPDATE accounts SET premium_points = premium_points+'.. count ..' WHERE id = ' .. getAccountNumberByPlayerName(getCreatureName(cid)))
end

function onUse(cid, item, fromPosition, itemEx, toPosition)
   local player = Player(cid)
   doPlayerAddPremiumPoints(cid, 30)
   player:sendTextMessage(MESSAGE_EVENT_ADVANCE, "You have recived 30 shop points to your account.")
   player:getPosition():sendMagicEffect(28)
   item:remove(1)
   return true
end

 

[Hokku]

local function doPlayerAddPremiumPoints(cid, count)
   db.query('UPDATE accounts SET premium_points = premium_points+'.. count ..' WHERE id = ' .. getAccountNumberByPlayerName(getCreatureName(cid)))
end

function onUse(cid, item, fromPosition, itemEx, toPosition)
   local player = Player(cid)
   doPlayerAddPremiumPoints(cid, 30)
   player:sendTextMessage(MESSAGE_EVENT_ADVANCE, "You have recived 30 shop points to your account.")
   player:getPosition():sendMagicEffect(28)
   item:remove(1)
   return true
end

worked ty!