Double Exp

[JoyRo]

Hello,

On my server i am using a coin that gives players VIP Status ( Super Player )
IS it also posible that people that have that Rank get double exp?
Or is there a script that gives vip status with double exp.

 

[KirieZ]

@@JoyRo If I remember well you can run a query on account_data table and set base_exp to 2 for an account id, it will have double exp (maybe instead of 2 you may have to put the new rate)

So you've to add/set to a higher value when vip starts, and set back to 1 when vip ends

 

[JoyRo]

You know if there is any script code that it wil auto update.
Like setting a lvl 2 gm is   

 query_sql "update `login` set `group_id` = 2 where `account_id` = "+ getcharid(3);
 close;

I would like it for setting that account 200% exp it is indeed account_data

Fixed it myself,

query_sql "insert into `account_data` (`account_id`, `base_exp`, `base_drop`) values ("+getcharid(3)+", x, x) ON DUPLICATE KEY UPDATE base_exp=VALUES(base_exp), base_drop=VALUES(base_drop);";

Change X to the amount you like .

 

[ippo20]

You know if there is any script code that it wil auto update.
Like setting a lvl 2 gm is   

 query_sql "update `login` set `group_id` = 2 where `account_id` = "+ getcharid(3);
 close;

I would like it for setting that account 200% exp it is indeed account_data

Fixed it myself,

query_sql "insert into `account_data` (`account_id`, `base_exp`, `base_drop`) values ("+getcharid(3)+", x, x) ON DUPLICATE KEY UPDATE base_exp=VALUES(base_exp), base_drop=VALUES(base_drop);";

Change X to the amount you like .

I am using this method for premium/vip players. But the base_exp does not take effect unless they do character select. Any tips?

EDIT: didnt know you could do ModExp... to make the effect instant.. no documentation about this in scripts.. only on constants.md