How to add premium points to acc, with no using accmaker.

[yanger]

Hey, i dont have this option on Accmaker(Addpoints), how can i add points premium manually to some acc? i need it fast, thanks repp+

 

[Cykotitan]

Edit premium_points in table accounts ;/

 

[Kekox]

talkactions/scripts/addpoints.lua

--- Script by Kekox.
function onSay(cid, words, param, channel)
        if(param == '') then
                doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Command requires param.")
                return true
        end

        local t = string.explode(param, ",")
        t[1] = tonumber(t[1])
        if(not t[1]) then
                doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Command requires numeric param.")
                return true
        end

        local pid = cid
        if(t[2]) then
                pid = getPlayerByNameWildcard(t[2])
                if(not pid) then
                        doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Player " .. t[2] .. " not found.")
                        return true
                end
        end

       sender = getPlayerByNameWildcard(cid)
       
       doAddPremiumPoints(pid, t[1])
       doPlayerSendTextMessage(cid, "You have added ".. t[1] .." premium points to ".. t[2])
       doPlayerSendTextMessage(pid, sender .." just gave you ".. t[1] .." premium points.")    
        return true
end

Talkactions.xml

<talkaction log="yes" words="/addpoints" access="5" event="script" value="addpoints.lua"/>

lib/functions.lua add this lines:

function doAddPremiumPoints(cid, points)
    db.executeQuery("UPDATE `accounts` SET `premium_points` = `premium_points` + " .. points .. " WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
end

It work like a command.. /addpoints 50, Kekox.

 

[yanger]

@cek~

don't get it :/

 

[Kekox]

Just do what I told you.

 

[Cykotitan]

@cek~

don't get it :/

accounts -> Find the account and press edit -> Change premium_points

or

UPDATE `accounts` SET `premium_points` = X WHERE `name` = 'accname'

 

[yanger]

Cyko~

you are best... :* xDD ty.


@KEKOX
I gave to u repp cuz u wanted to help

 

[Amiroslo]

LOL Kekox

 

[yanger]

And how to "ADD", not "SET" ;>

i tried something like this:
UPDATE `accounts` ADD `premium_points` = 10 WHERE `name` = '1668430'

But it's fail.

 

[Cykotitan]

UPDATE accounts SET premium_points = premium_points + 10 WHERE name = '1668430'

 

[yanger]

Heh, i was trying something like this before, but it was:

UPDATE accounts SET premium_points = premium_points +10 WHERE name = 'xx'

And i think it wasn't working. Thanks Cyko~
again repp+ for u