Point system

[ConAn Edujawa]

i have point system but when player get lvl 250 don't add point in site why ??
but points add in mysql accounts

local t, storage = {
  -- level -- amount points (delete this line)..
    {250, 30}

}, 259

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_WARNING, 'Congratulations! You have advanced to level ' .. v[1] .. ' and you have earned '.. v[2] ..' Premium Points!')
        end
    end
    return true
    end

im use 0.4

 

[Imfreezing]

local t, storage = {
  -- level -- amount points (delete this line)..
    {250, 30}

}, 259

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.Query('UPDATE accounts SET premium_points=premium_points+'.. v[2] ..' WHERE id=' .. getPlayerAccountId(cid))
            doCreatureSetStorage(cid, storage, i)
            doPlayerSendTextMessage(cid, MESSAGE_STATUS_WARNING, 'Congratulations! You have advanced to level ' .. v[1] .. ' and you have earned '.. v[2] ..' Premium Points!')
        end
    end
    return true
    end

 

[ConAn Edujawa]

not work :S im use znote

 

[Critico]

local t, storage = {
[250] = 30,
[300] = 50
},4001201
function onAdvance(cid, skill, oldLevel, newLevel)
    if skill ~= SKILL__LEVEL then return true end
        if t[newLevel] and getPlayerStorageValue(cid, storage) < newLevel then
            db.executeQuery('UPDATE accounts SET premium_points=premium_points+'.. t[newLevel] ..' WHERE id=' .. getPlayerAccountId(cid))
            setPlayerStorageValue(cid, storage, newLevel)
            doPlayerSendTextMessage(cid, MESSAGE_STATUS_WARNING, 'Congratulations! You have advanced to level ' .. newLevel .. ' and you have earned '.. t[newLevel] ..' Premium Points!')
        end
    return true
    end

 

[ConAn Edujawa]

no work

 

[Critico]

register event in the player...

<event type="advance" name="SendPoints" event="script" value="script name.lua" />

login.lua add

registerCreatureEvent(cid, "SendPoints")

 

[ConAn Edujawa]

i know but still no work :S no error in consol and point add in mysql but don't add in website :S
im use znote

 

[Critico]

change 'db.executeQuery' to 'db.query'

 

[Limos]

db.executeQuery("UPDATE `znote_accounts` SET `points` = `points` + ".. v[2] .." WHERE `id` = "..getPlayerAccount(cid))

 

[ConAn Edujawa]

limos i need script give premium points but it give points 1 time for each account i need this script add 30 point in lvl 250 but for account not char if account have 3-4 char point add one time only

 

[ConAn Edujawa]

anyone can help me in this?

 

[ConAn Edujawa]

pumb

 

[ConAn Edujawa]

@Limos please help me point system wont work :S and player leave oto :S point don't add accounts in site and in phpadmin

 

[ConAn Edujawa]

f5

 

[Himii]

https://otland.net/threads/hasaccountstorage-cid-key-value.148522/
This will probaby help you