Jump to content
  • 0
hadiesyafiq

how to make expired script for VIP ?

Question

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;
}
 

 

viptime.png

Share this post


Link to post
Share on other sites

3 answers to this question

Recommended Posts

  • 0
-   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

Share this post


Link to post
Share on other sites
  • 0
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 by hadiesyafiq

Share this post


Link to post
Share on other sites
  • 0
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. 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.