How can i reset all the stats of all the characters in the servers?

[budabeads]

How can i reset all the stats of all the characters in the servers?

or how can i change then all into novice 1/1?

because there seems to be a bug , so i want to change back all the players into novice 1/1

thanks master scripters....

[en_dev]

on your php mysql admin, click your database, then do sql query, enter this info

UPDATE `ragnarok`.`char` SET `base_level`=1 and `job_level`=1 and `base_exp`=0 and `job_exp`=0 and `str`=0 and `agi`=0 and `vit`=0 and `dex`=0 and `luk`=0;

above query will reset all your characters to lvl 1/1 , base and job exp to 0, and all stats to 0, you can also add point to 0, i just forgot the right field name.

[Rikimaru]

Okay,so you want to reset all stats to 1 and all Jobs to Novice level 1/1,then I'll explain how you do that.

1. You have to open your MySQL Server or phpmyadmin.

2. You open the function to run a SQL Script.

3. You have to run this Script :

UPDATE `char` set `Class`=0,`base_level`=1,`job_level`=1,`base_exp`=0,`job_exp`=0;
UPDATE `char` set `str`=1,`agi`=1,`vit`=1,`int`=1,`dex`=1,`luk`=1;
UPDATE `char` set `status_point` = (45+(base_level*160)) where `base_level`>5;
UPDATE `char` set `status_point` = (status_point+52) where class >= 4001 and class <= 4022;

This SQL Script is going to turn all your Characters into Novices level 1/1 with no exp and it is going to reset all stats to 1.