Jump to content

Question

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.

Share this post


Link to post
Share on other sites

3 answers to this question

Recommended Posts

  • 0

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 .

Share this post


Link to post
Share on other sites
  • 0

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

Share this post


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

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.