[Request] /addpremium command

[Rodo]

I need it but give premium ever, doesn't matter if player is online or no, it is possible?

 

[Andrespro]

-- Script By Shawak
-- Edited a little By AndresPro

  function onSay(cid, words, param)
        local t = string.explode(param, ",")
        if t[1] ~= nil and t[2] ~= nil then
                local result = db.getResult("SELECT `account_id` FROM `players` WHERE `name` = '"..t[1].."';")
                db.executeQuery("UPDATE `accounts` SET `premdays` = `premdays` + "..t[2].." WHERE `id` = '" ..result:getDataString("account_id").. "';")
                doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, ""..t[1].." has received "..t[2].." premium days.")
                result:free()
        else
                doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Command Requires Two Params.")
        end
        return TRUE
end

Just say /addpremium NAME, DAYS to add DAYS premium days to NAME's account

 

[Rodo]

Thanks ^^, someone close the thread please.

 

[Shawak]

-- Script By Rizz
-- Edited a little By AndresPro

  function onSay(cid, words, param)
        local t = string.explode(param, ",")
        if t[1] ~= nil and t[2] ~= nil then
                local result = db.getResult("SELECT `account_id` FROM `players` WHERE `name` = '"..t[1].."';")
                db.executeQuery("UPDATE `accounts` SET `premdays` = `premdays` + "..t[2].." WHERE `id` = '" ..result:getDataString("account_id").. "';")
                doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, ""..t[1].." has received "..t[2].." premium days.")
                result:free()
        else
                doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Command Requires Two Params.")
        end
        return TRUE
end

Just say /addpremium NAME, DAYS to add DAYS premium days to NAME's account

-- Script By Rizz

He only made this:

...`id` = '" ..result:getDataString("account_id").. "';")

Why no credits to me?

 

[Andrespro]

Sorry, EDITED , because it was edited 5 times on a thread o.o