Double Exp

[JoyRo 5]

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 88]

@@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 5]

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

On 12/7/2015 at 5:13 AM, JoyRo said:

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

Edited July 4, 2020 by ippo20