how to make expired script for VIP ?

[hadiesyafiq 7]

hi all this is vip script to make account be group id 2 for 3 days...but after 3 days the accounte stil vip status..how to change?

After 5 days it wil be -2days

 

Quote

function    script    F_TicketAddVip_3    {
    query_sql "DELETE FROM `viptable` WHERE `vipacc_id` = '"+getcharid(3)+"' AND DATEDIFF(DATE_ADD(`insert_on`, INTERVAL `days` DAY), NOW()) < 0"; // remove expired VIP status before reapplying
    query_sql "SELECT `days` FROM `viptable` WHERE `vipacc_id` = '"+getcharid(3)+"'", .@checkDays;
    if (.@checkDays > 0) {
        set .@setDays, (.@checkDays + 3);
        query_sql "UPDATE `viptable` SET `days`='"+.@setDays+"' WHERE `vipacc_id`='"+getcharid(3)+"'";
        query_sql "SELECT `group_id` FROM `login` WHERE `account_id`='"+getcharid(3)+"'", .@userLevel;
        if (.@userLevel < 1) 
            query_sql "UPDATE `login` SET `group_id`='1' WHERE `account_id`='"+getcharid(3)+"'";
    }
    else {
        query_sql "UPDATE `login` SET `group_id`='1' WHERE `account_id`='"+getcharid(3)+"'";
        query_sql "SELECT `userid` FROM `login` WHERE `account_id`='"+getcharid(3)+"'", .@userID$;
        query_sql "SELECT `email` FROM `login` WHERE `account_id`='"+getcharid(3)+"'", .@userEmail$;
        query_sql "INSERT INTO `viptable` (`vipacc_id`,`vip_id`,`days`,`email`) VALUES ('"+getcharid(3)+"','"+.@userID$+"','3','"+.@accEmail$+"')";
    }
    mes "[ ^990099Geovani^000000 ]";
    mes "You received 3 days of VIP Account!";
    mes "Please relog to see the changes in your account.";
    close;
return;
}
 

 

[Dastgir 1246]

-   script  VIP script  FAKE_NPC,{

OnPCLoginEvent:
    if (#AccountVIP >= gettimetick(2)) {
        ModExp = 100;
        ModDrop = 100;
    } else if (getgroupid() == 2)  {
        ModExp = 150;
        ModDrop = 150;
    }
    end;


}

function    script    F_TicketAddVip_3    {
    #AccountVIP = gettimetick(2) + (60*60*24*3);
    ModExp = 150;
    ModDrop = 150;
    mes "[ ^990099Geovani^000000 ]";
    mes "You received 3 days of VIP Account!";
    close;
}

Try this

[hadiesyafiq 7]

1 hour ago, Dastgir said:

- script VIP script FAKE_NPC,{ OnPCLoginEvent: if (#AccountVIP >= gettimetick(2)) { ModExp = 100; ModDrop = 100; } else if (getgroupid() == 2) { ModExp = 150; ModDrop = 150; } end; } function script F_TicketAddVip_3 { #AccountVIP = gettimetick(2) + (60*60*24*3); ModExp = 150; ModDrop = 150; mes "[ ^990099Geovani^000000 ]"; mes "You received 3 days of VIP Account!"; close; }

-   script  VIP script  FAKE_NPC,{

OnPCLoginEvent:
    if (#AccountVIP >= gettimetick(2)) {
        ModExp = 100;
        ModDrop = 100;
    } else if (getgroupid() == 2)  {
        ModExp = 150;
        ModDrop = 150;
    }
    end;


}

function    script    F_TicketAddVip_3    {
    #AccountVIP = gettimetick(2) + (60*60*24*3);
    ModExp = 150;
    ModDrop = 150;
    mes "[ ^990099Geovani^000000 ]";
    mes "You received 3 days of VIP Account!";
    close;
}

Try this

thank you sir @Dastgir but without SQL how can i use vip status script?

here the script 

Quote

-    script    VIP_STATUS    FAKE_NPC,{
OnPCLoginEvent:
    if (getgroupid() >= 1) {
        query_sql "SELECT DATE(DATE_ADD(`insert_on`, INTERVAL `days` DAY)), DATEDIFF(DATE_ADD(`insert_on`, INTERVAL `days` DAY), NOW()) FROM `viptable` WHERE `vipacc_id` = '"+getcharid(3)+"'", .@expire_date$, .@days_left;
            dispbottom "You're currently a VIP Member.";
            dispbottom "============================================";
            dispbottom "Account Status : EXP & DROP Increase 50%.";
            dispbottom "VIP rates are: Base EXP - 150% | Base DROP - 150%.";
            dispbottom "Expire Date : " + .@expire_date$;
            dispbottom "Days left : "+ .@days_left;
            dispbottom "============================================";
        end;
    }
}

thanks again sir

Edited January 24, 2020 by hadiesyafiq

[Dastgir 1246]

6 hours ago, hadiesyafiq said:

thank you sir @Dastgir but without SQL how can i use vip status script?

here the script 

thanks again sir

Hercules does support basic vip.

Modifying ModDrop and ModExp will change the experience gained and drop rate for that specific account.