How can I reset all the Stats of players using SQL?

[Yummy]

Its urgent.

[KaitoKid]

On your ragnarok database find the "char" table in there you find all the details related to the character.

[Emistry]

@kaito

erm...i think the topic starter already know which sql table to edit...just dunno how to write the SQL script to run.

@Remix..

try this

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

status_point .. edit this value to what value of status point they should have upon reset...

anyway...you still can remove it as it might give wrong status point to certain player with low level and etc...

and make sure you run this while your server is offline

[KaitoKid]

Sorry. My bad didn't understand the topic