Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

AutoReset Script SQL

HOT z
Joined
Sep 9, 2005
Messages
316
Reaction score
8
This is a Auto-reset with points!

Code:
UPDATE Character
SET clevel=('1'), Experience=('0'),Money=Money-('25000000'),
LevelUpPoint=500+500*resets, resets=resets+1,
Strength=('18'), Dexterity=('18'), Vitality=('15'),
Energy=('30')
FROM Character join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
collate Latin1_general_CI_AS
WHERE clevel>349 and Money>('25000000') AND Memb_Stat.ConnectStat = 0 AND resets<201


I use this code in 97d..97...97z version! Were NO DarkLord or SUmmoner caracter!


LevelUpPoint=500+500 you can change this :"> how many points you whant for reset!
 
HOT z
Joined
Sep 9, 2005
Messages
316
Reaction score
8
Re: [GUIDE] AutoReset Script SQL

If you have column error


- Open your Enterprises manager
- Open your MuOnline database
- Click on tables
- Right click on the "Character" table
- Click on "Design Table"
- Scroll down to the last column (yes, scroll DOWN to the collumn, pay attention! You will understand as you see it ^^ trust me!)
- Add a "Resets" column after the last one
- In "Data type", make it "smallint"
- uncheck allow nulls (if you don't do it you will have some probs later on!)
- In the Default Value (in the box below) make it 0 or 1... it depends on which reset script you are gonna use
 
Newbie Spellweaver
Joined
Apr 29, 2008
Messages
92
Reaction score
0
Re: [Guide] AutoReset Script SQL

thx
Ur guide is useful with those PPLs want to have a big RR and FS
 
Back
Top