Simple sql to make all char level 99

[mrlongshen]

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

 

[Kuya Jeo]

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

 

[mrlongshen]

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

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