zerghel
Tsuni
- Joined
- Jul 1, 2008
- Messages
- 299
- Reaction score
- 9
im using this premium point by action
but the thing is that the premium points table is NULL by default i guess, so the points never adds, there's anyway to modify the query to set the table NOT NULL?
Code:
local points = 1
function onUse(cid, item, frompos, item2, topos)
db.executeQuery("UPDATE `accounts` SET `premium_points` = `premium_points` + " .. points .. " WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
doRemoveItem(item.uid, 1)
doCreatureSay(cid, 'You have received 1 premium point!', TALKTYPE_ORANGE_1)
end
but the thing is that the premium points table is NULL by default i guess, so the points never adds, there's anyway to modify the query to set the table NOT NULL?