account begins with three days vip

[fera holy kina]

anyone have any script that begins with three days in each VIP account using the query vipdays

or you can create one for me?

I think it's the script that creates that creaturescripts

#yes and a VIP trial so very much wanted a script

 

[GodSebbe]

that would be nice to see, or 3 hours of vip trial , but nice idea, i'll hope someone will make it.

 

[fera holy kina]

B
u
m
p

 

[Gabriel Tibiano]

just put 3 days in vip column on your Samples in database

 

[valivan601]

creaturescripts/scripts vipdays.xml

function onLogin(cid) 
 
local days = 3
local id = 10070
local config = { 
msg = "Você acaba de ganhar 3 dias de VIP!", 
}  
if (getPlayerStorageValue(cid, id == 1)) then
	return true
else  
	doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_RED, config.msg) 
	doAddVipDays(cid, days)
	doPlayerSetStorageValue(cid, id, 1) 
end
end

on login.lua add this

registerCreatureEvent(cid, "VipDays")

on creaturescripts.xml add this

<event type="login" name="VipDays" script="vipdays.lua"/>

remember check if u has the function on 050-function.lua on lib folder

function doAddVipDays(cid, days)
    db.query("UPDATE `accounts` SET `vip_time` = `vip_time` + " .. days .. " WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
end

see if you has vip_time or vipdays on table accounts

 

[fera holy kina]

valivan601

what I need and this same error but gave no more strange did not work
use rev3777

 

[fera holy kina]

Thank! you discovered a simpler way

instead of
ALTER TABLE `accounts` ADD `vipdays` int(11) NOT NULL DEFAULT 0;
this place that has the "3" instead of "0"
ALTER TABLE `accounts` ADD `vipdays` int(11) NOT NULL DEFAULT 3;

so more work to care for the first time "I think"

 

[miikro]

Where to add that? How to add that? Can anyone explain me?
Thank you

 

[Zalroxx]

in config.php (if use gesior) there is a

newplayer_premdays

write how many vip days u want and use this SQL command

UPDATE accounts SET premdays = 1000;

or how many prem days you want