Status Point Reset [Server Wide]

[Boom]

Hi, I just want to ask how to reset the status points of all players on the server with automatic reapplication of the all the status points that are "left" just like what the Build Manager NPC does.

 

Because I tried to use this SQL Query

 

UPDATE `char` SET `str` = '0',`agi` = '0',`vit` = '0',`int` = '0',`dex` = '0',`luk` = '0';

 

Well, it updated all the character's status to 0, but the problem is, what about the characters who are currently at their max levels and must have retained the total status points they've aqcuired through leveling.

 

Thank you!

[Boom]

There should be a status point formula. I've been googling all over... But I haven't found the status point formula.

[Boom]

Got it. Here's for pre-renewal. It's the SQL query for resetting status points globally while retaining their status points depending on their base levels.

 

UPDATE `char` SET `str` = '5',`agi` = '5',`vit` = '5',`int` = '5',`dex` = '5',`luk` = '5', `status_point`=((((5+base_level/5)*base_level/5)/2)*5 + (base_level/5+3)*(base_level%5)) - 3;

[icabit]

i did this to my old server before when a bugged happened then some players were over stat

so here's the script to fix that issue easily

 

since all of the players needs to login i created this script

1st kick all the players now they are all forced to login and do the check

 

 

-    script    statreseter    -1,{
OnPCLoginEvent:
if(resetstat!=1) // check if they already been reset
{
ResetStatus;
//remove "//" before ResetSkill if you wanna reset skills too
//ResetSkill;
set resetstat,1; // sets a variable to the player if hes stats were already reset
}
}

if you wanna do a reset again

kick all the players

then do a query on your database

delete * from `global_reg_value` where str ='resetstat'

hope it helps

Edited April 8, 2013 by icabit