megazx
Graphic designer
i use this script to add free points to players at levels
and this in login
but i have error in consol say that i dont have premium_point table in data base mysql
PHP:
<event type="advance" name="points" event="script" value="points.lua"/>
and this in login
PHP:
registerCreatureEvent(cid,'points')
registerCreatureEvent(cid, "ReportBug")
PHP:
local t, storage = {
{200, 5}
}, 256
function onAdvance(cid, skill, oldLevel, newLevel)
if skill ~= SKILL__LEVEL then
return true
end
for i = 1, #t do
local v = t[i]
if newLevel >= v[1] and getCreatureStorage(cid, storage) < i then
db.executeQuery('UPDATE accounts SET premium_points=premium_points+'.. v[2] ..' WHERE id=' .. getPlayerAccountId(cid))
doCreatureSetStorage(cid, storage, i)
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, 'Congratulations! You have advanced to level ' .. v[1] .. ' and you have recived '.. v[2] ..' Premium Points!')
doBroadcastMessage('Congratulations! ' .. getCreatureName(cid) .. ' Advenced To LeveL ' .. v[1] .. ' And Got ' .. v[2] .. ' Premium Points.')
end
end
return true
end
but i have error in consol say that i dont have premium_point table in data base mysql