Simple sql to make all char level 99

[mrlongshen 22]

Based on topic I want to reset all player base level to 99 and job level 99. Someone please share ? 

Edited December 7, 2015 by mrlongshen

[Kuya Jeo 119]

@@mrlongshen you want to reset all players into level 99? what is your max level?

[mrlongshen 22]

@@mrlongshen you want to reset all players into level 99? what is your max level?

Yup. I want to reset base level and job level. My server level 99 and job is 70. Pre-renewal.

 

If can, can you reset all char to get stats point for level 99.

 

Before this my server is 255. Now I want to remake to 99 only..

[simhr 0]

@@mrlongshen

 

This SQL query should work for you; But i guess you have to adjust the stats as well.

UPDATE `char` SET char.base_level = 99, char.job_level = 70;

Maybe you only want to set a characters level to 99 if it already is above 99. If so use this query:

UPDATE `char` SET char.base_level = 99 WHERE char.base_level > 99;UPDATE `char` SET char.job_level = 70 WHERE char.job_level > 70;

Best regards,

-simh

Edited February 7, 2016 by simh