Add X Vip days To players

[MxSoft]

Hi i want to know i way to add to all my ot players 6 Vip days.
I use this Vip Script

local days = 30
local levelToBeVIP = 1

function onUse(cid, item, fromPosition, itemEx, toPosition)
        if getPlayerLevel(cid) >= levelToBeVIP then
                if isPlayerVip(cid) == FALSE then
                        doCreatureSay(cid, "CONGRATULATIONS! You are now a VIP for "..days.." days! You can now enter the VIP-area and use unique features!. ", TALKTYPE_ORANGE_1)
                end
                doSendAnimatedText(getPlayerPosition(cid), "Welcome!", TEXTCOLOR_RED) 
                doPlayerAddVipDays(cid, days)
                doRemoveItem(item.uid, 1)
                doSendAnimatedText(getCreaturePosition(cid), "+"..days.." days", 30)
        else
                doPlayerSendCancel(cid, "You need level "..levelToBeVIP.." to be a VIP player.")
        end     
        return TRUE
end

- <!--  VIP 
  --> 
  <action actionid="5786" script="vipdoor.lua" /> 
  <action itemid="5785" script="vip.lua" />

And a query to add 3 Shop poitns to everyone
Greetings

 

[5mok3]

It's simple..

local days = 30

Replace that 30 with the amount of days you want..
Also.. i dont know where your vipdays table is at if it is in the account table then:

UPDATE accounts SET vipdays = vipdays + 3

Else:

UPDATE players SET vipdays = vipdays + 3

Replace vipdays with the name of the table you use

 

[MxSoft]

Ty rep

 

[MxSoft]

It's simple..


Replace that 30 with the amount of days you want..
Also.. i dont know where your vipdays table is at if it is in the account table then:

Else:

Replace vipdays with the name of the table you use

And if i want to add vips days only to players that have already vip days?

 

[Cykotitan]

add [HIGHLIGHT] WHERE vipdays != 0[/HIGHLIGHT] at the end of the query