Code:
function doRemovePoints(cid, points)
local Info = db.getResult("SELECT `premium_points` FROM `accounts` WHERE `id` = " .. getPlayerAccountId(cid) .. " LIMIT 1")
if Info:getID() ~= LUA_ERROR then
db.executeQuery("UPDATE accounts SET premium_points = " .. points .. " WHERE id=" .. getPlayerAccountId(cid) .. ";")
Info:free()
return 1
end
end
That code is suposeed to remove you points from DB but when I use it with 1 prem points with a balance of 200 prem points I just get that my prem point balance is 1 prem points..
any help?:w00t: