Auto Grand Reset Script SQL ( XP | 97+99 -1.02)

[malemees]

Auto Grand Reset Script SQL

It's ment for 99+97 mey be works for newer too

Let's start

1. Go Start-> All Programs -> Enterprise Manager -> Management -> SQL Server Agent -> Jobs ->

1.1 DW or SM
1.1.1 Right click -> New Job… ->
1.1.2 General Tab:

Name: DW or SM Grand Reset

Description: DW or SM Grand Reset

1.1.3 Steps Tab:

1.1.3.1 New…

1.1.3.2 Step name: DW or SM (can name yourself)

1.1.3.3 Command:

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = XXX, Money = Money - (50000000),Strength = 18, Dexterity = 18, Vitality = 15, Energy = 30, Inventory = NULL, MagicList = NULL, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = 0, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 0) OR (class = 1)) AND (ConnectStat = 0) AND (Reset = XXX);

Apply -> OK

1.1.4 Schedules Tab:

1.1.4.1 New Schedules...

1.1.4.2 Name: DW or SM (can name yourself)

1.1.4.3 Press "Change..."

1.1.4.4

Occurs = Daily
Daily frequency = hour(s) to minute(s)
Start date = yesterday

OK->OK->Apply and OK

DW or SM Done
NB! red XXX places means that you can choose your own points or reset mount

1.2 DK or DK
1.2.1 Right click -> New Job… ->
1.2.2 General Tab:

Name: DK or BK Grand Reset

Description: DK or BK Grand Reset

1.2.3 Steps Tab:

1.2.3.1 New…

1.2.3.2 Step name: DK or BK (can name yourself)

1.2.3.3 Command:

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = XXX, Money = Money - (50000000),Strength = 28, Dexterity = 20, Vitality = 25, Energy = 10, Inventory = NULL, MagicList = NULL, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = 0, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 16) OR (class = 17)) AND (ConnectStat = 0) AND (Reset = XXX);


Apply -> OK

1.2.4 Schedules Tab:

1.2.4.1 New Schedules...

1.2.4.2 Name: DK or BK (can name yourself)

1.2.4.3 Press "Change..."

1.2.4.4

Occurs = Daily
Daily frequency = hour(s) to minute(s)
Start date = yesterday

OK->OK->Apply and OK

DK or BK Done
NB! red XXX places means that you can choose your own points or reset mount

1.3 Elf or ME
1.3.1 Right click -> New Job… ->
1.3.2 General Tab:

Name: Elf or ME Grand Reset

Description: Elf or ME Grand Reset

1.3.3 Steps Tab:

1.3.3.1 New…

1.3.3.2 Step name: Elf or ME (can name yourself)

1.3.3.3 Command:

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = XXX, Money = Money - (50000000),Strength = 22, Dexterity = 25, Vitality = 20, Energy = 15, Inventory = NULL, MagicList = NULL, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = 0, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 32) OR (class = 33)) AND (ConnectStat = 0) AND (Reset = XXX);


Apply -> OK

1.3.4 Schedules Tab:

1.3.4.1 New Schedules...

1.3.4.2 Name: Elf or ME (can name yourself)

1.3.4.3 Press "Change..."

1.3.4.4

Occurs = Daily
Daily frequency = hour(s) to minute(s)
Start date = yesterday

OK->OK->Apply and OK

Elf or ME Done
NB! red XXX places means that you can choose your own points or reset mount

1.4 MG
1.4.1 Right click -> New Job… ->
1.4.2 General Tab:

Name: MG Grand Reset

Description: MG Grand Reset

1.4.3 Steps Tab:

1.4.3.1 New…

1.4.3.2 Step name: MG (can name yourself)

1.4.3.3 Command:

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = XXX, Money = Money - (50000000),Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, Inventory = NULL, MagicList = NULL, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = 0, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE (class = 48) AND (ConnectStat = 0) AND (Reset = XXX);



Apply -> OK

1.4.4 Schedules Tab:

1.4.4.1 New Schedules...

1.4.4.2 Name: MG (can name yourself)

1.4.4.3 Press "Change..."

1.4.4.4

Occurs = Daily
Daily frequency = hour(s) to minute(s)
Start date = yesterday

OK->OK->Apply and OK

MG Done
NB! red XXX places means that you can choose your own points or reset mount

Well that was for 97+99 server... for 99-1.02(where is DL)
If you have DL too then add one job more:

1.5 DL
1.5.1 Right click -> New Job… ->
1.5.2 General Tab:

Name: DL Grand Reset

Description: DL Grand Reset

1.5.3 Steps Tab:

1.5.3.1 New…

1.5.3.2 Step name: DL (can name yourself)

1.5.3.3 Command:

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = XXX, Money = Money - (50000000),Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, Inventory = NULL, MagicList = NULL, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = 0, Resets = Resets +1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE (class = 64) AND (ConnectStat = 0) AND (Reset = XXX);



Apply -> OK

1.4.4 Schedules Tab:

1.4.4.1 New Schedules...

1.4.4.2 Name: DL (can name yourself)

1.4.4.3 Press "Change..."

1.4.4.4

Occurs = Daily
Daily frequency = hour(s) to minute(s)
Start date = yesterday

OK->OK->Apply and OK

MG Done
NB! red XXX places means that you can choose your own points or reset mount

NB! If you don't have in Character table Reset and Resets columns then follow next steps:

1.6 Making Reset and Resets column in Character table
1.6.1 Go SQL Server Enterprise Manager
1.6.2 Go Database -> MuOnline -> Tables
1.6.3 Right click on Character -> Design Table
1.6.4 Find clean raw after the last column:

1.6.4.1 Column Name = Reset
1.6.4.2 Data Type = smallint
1.6.4.3 Uncheck Allow Nulls
1.6.4.4 In the Default Value (in the box below) make it 0

Now just make same raw just rename to Resets

NB! Be sure that your site uses Reset column !

[MentaL]