budabeads Posted July 7, 2012 Group: Members Topic Count: 16 Topics Per Day: 0.00 Content Count: 42 Reputation: 1 Joined: 02/16/12 Last Seen: August 8, 2012 Share Posted July 7, 2012 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.... Quote Link to comment Share on other sites More sharing options...
en_dev Posted July 7, 2012 Group: Members Topic Count: 7 Topics Per Day: 0.00 Content Count: 113 Reputation: 5 Joined: 06/06/12 Last Seen: December 25, 2013 Share Posted July 7, 2012 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. Quote Link to comment Share on other sites More sharing options...
Rikimaru Posted July 8, 2012 Group: Members Topic Count: 16 Topics Per Day: 0.00 Content Count: 658 Reputation: 57 Joined: 11/20/11 Last Seen: July 1, 2017 Share Posted July 8, 2012 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. Quote Link to comment Share on other sites More sharing options...
Question
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....
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.