How can i Reset all characters Stats

[Sparks]

how can i reset all character stats on my server without wiping out there accounts ?

 

is it possible to do that ?

[Whathell]

It is possible. You just wanna reset the stats or roll em all back to level 1? Rolling them back will be easier so stat calculation would not be necessary once you change your sql table.

[Winz]

Open your mysql database and use the "ragnarok" db, execute this code:

 

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

 

NOTE: This code will set every stat of ALL PLAYERS (listed inside the `char` table) to 1, but will not give the players statpoints.

Edited November 7, 2013 by Winz