actions/script

local pontos = 1

function onUse(cid, item, frompos, topos)
  doPlayerSendTextMessage(cid, 22,"voce ganhou "..pontos.." de pontos ")
  doRemoveItem(item.uid,1)
  doPlayerAddVipPoints(cid,pontos)
  return true
end

Depois vai em function.lua (lib)

function getPlayerVipPoints(cid)
    local Info = db.getResult("SELECT premium_points FROM accounts WHERE id = " .. getPlayerAccountId(cid) .. "")
        if Info:getID() ~= LUA_ERROR then
        local Points= Info:getDataInt("premium_points")
        Info:free()
        return Points
    end
     return LUA_ERROR
end

function doPlayerAddVipPoints(cid, points)
    local dif = getPlayerVipPoints(cid) + points
    if dif >= 0 then
        db.executeQuery("UPDATE accounts SET premium_points = premium_points + " .. points .. " WHERE id = " .. getPlayerAccountId(cid) .. ";")
        return TRUE
    end
    return FALSE
end

function doPlayerRemoveVipPoints(cid, points)
    local dif = getPlayerVipPoints(cid) - points
    if dif >= 0 then
        db.executeQuery("UPDATE accounts SET premium_points = premium_points - " .. points .. " WHERE id = " .. getPlayerAccountId(cid) .. ";")
        return TRUE
    end
    return FALSE
end

AJUDEI REP+