How to reset to B/Jlvl all payers?

[Eivohr]

Hi, My server is now 255/120 max lvl. So the players are now that lvl. They request to make it 99/70 only. so I request if there are any posibility to reset all they lvl to level 1/1 or 99/70 without wipe out? Thanks in advance

[Mootie]

Edit it on your sql to easy to do it get notepad++ 255 replace it into 99

[yakuu]

UPDATE `char` SET `base_level` = '1', `job_level` = '1';

Edited February 19, 2013 by yakuu

[Eivohr]

@Mootie and @yakuu, Thank you very much. I try it. ^^

[Euphy]

You should probably reset some other things, too...

UPDATE `char` SET `base_level` = 1, `job_level` = 1, `base_exp` = 0, `job_exp` = 0, `str` = 5, `agi` = 5, `vit` = 5, `int` = 5, `dex` = 5, `luk` = 5, `status_point` = 0;