AutoReset Script SQL

[HurryPoker]

This is a Auto-reset with points!

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!

 

[HurryPoker]

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

 

[slash8888]

Re: [Guide] AutoReset Script SQL

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

 

[HurryPoker]

Re: [Guide] AutoReset Script SQL

tnx!