AutoReset Script[SQL] + Full Details

Joined
May 18, 2006
Messages
56
Reaction score
0
This Guide will show you how to make an AutoReset Script using SQL Server Agent.
Let's Start! Go And Create a new Job:
1)Start>All Programmes>Microsoft SQL Server>Enterprise Manager.
2)Then Find "Management" Double Click There.
3)And then double click to SQL Server Agent.
4)Then Right Click on "Jobs" and select "New Job...".
5)Name It "AutoReset" , Category: [Uncategorized (Local)] and Owner "sa" and Description: "AutoResetSciprt".
6)Then Click in "Steps" and press "New..." ,Then put as Step Name: "AutoReset" and Type: "Transact-SQL Script (TSQL) and Database: "MuOnline".
7)Then as Command you have to put the Codes given below.
8)After that you have inserted the Code press "Apply" and "Ok".
9)Then go to Schedules and Click "New Schedule..." ,as name put "AutoReset" and press "Change" then change it to occurs: "Daily" every "1 Day(s)",
10)And then select "Occurs every" and change "1 Hour(s) to 1 Minute(s)" 11)Then click on "Start Date" and select the Day Before the one that is there.For example if it 12/02/2006 you selest 11/02/2006.
12)And final leave the "No End Date" and Click "Ok" 2 times and then "Apply" and "Ok" again.And you are DONE!
*Do this for both 4 Codes that are given below*


Notes:

AutoReset Lvl=350
Additional Points(Per Reset)=350
Reset Cost=50Millions (Each Reset)
Reset Limit=50Resets
Stats=Goes Back To Normal
Character:AutoWarp to Lorencia/Noria
Character MagicSpellList=Will Be Cleared
Character Inventory=Will Be Cleared
+Additional Pk Clear (Each Character)


WARNING!>AutoReset Will Be Correct With Column Name= 'Reset' In 'Character' Table With Default Value= '0'


1)DarkWizard/SoulMaster Code:

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 350 * (Reset + 1), 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 = Reset + 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 (clevel >= 350) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 50);


2)DarkKnight/BladeKnight Code:

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 350 * (Reset + 1), 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 = Reset + 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 (clevel >= 350) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 50);


3)Elf/MuseElf Code:

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 350 * (Reset + 1), 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 = Reset + 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 (clevel >= 350) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 50);


4)MG Code:

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 350 * (Reset + 1), 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 = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE (class = 48) AND (clevel >= 350) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 50);


DarkLord (99+ Versions)

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 350 * (Reset + 1), 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 = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE (class = 64) AND (clevel >= 350) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 50);


Any Questions/Problems you may have please feel free to ask me. :laugh:

This Guide Is Made By Me.
(C) Credits LifeStealer
 
Last edited:
Zagzagel said:
When i create a char the reset column is set to <NULL>.... and then the reset puts <NULL> points on LevelUpPoint :( how do i solve this?

Check This Line:

*** WARNING!>AutoReset Will Be Correct With Column Name= 'Reset' In 'Character' Table With Default Value= '0' ***
 
Help with this

I wanna know if someone can make this autoreset Script.

Reset MagicList
Null Inventory
No keep Points
200 Per Reset

1 > 100 resets = 1 jewel of creation
101 > 150 resets = 2 jewel of creation
151 > 200 resets = 3 jewel of creation
201 > 250 resets = 4 jewel of creation
251 > 300 resets = 5 jewel of creation
301 > 350 resets = 6 jewel of creation
351 > 400 resets = 7 jewel of creation

would be better if u can make this script for Mutoolz 2.2 i really aprecciate and pay for.
Just add me [email protected]

someone can help me with this?
 
Little offtopic regarding NULL SQL values

Zagzagel:

You can add a new step (prior to the Autoreset itself) in the Autoreset Job in order to convert NULL values to zeroes. This is the TSQL:
Code:
UPDATE Character
SET Reset=(0)
WHERE Reset IS NULL
(Remember to point it to the MuOnline database)

---- Story of my post, A.K.A. the non-important part that doesn't need to be read ----
I needed something like this:
Code:
UPDATE Character
SET CtlCode=(0)
WHERE CtlCode IS NULL
in my autoreset scripts in order to work properly.

When a column value is 'NULL', it seems to be excluded from >, <, <> and = operator conditions. For example, in my AutoReset:
Code:
UPDATE Character
SET clevel=('1'), Experience=('0'), Money=Money-('50000000'), MapNumber=('0'), MapPosX=('125'), MapPosY=('123'), PkLevel=('0'), Resets=Resets+('1')
FROM Character JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE CtlCode <> ('8') and clevel>('369') and Money>('50000000') AND (ConnectStat = 0);
note that my CtlCode condition is NOT EQUAL to 8, so it should exclude all GMs from reset. Well, it happened that when CtlCode was NULL, that char was also excluded from reset, so there had to be a way to 'Kill the NULLs'.

Through this simple step (the first TSQL CODE), you can convert your NULLs to any value. Just check where to seek them. Enjoy!
 
Em.....how I make the script for Autorreset without any item in the inventoy? I explain it..... caracters must be reset without any item, but, I want that.....if any players forgive put out any item from his inventory...I want that autorreset will be don't work.

And...one more thing..... ^^ for the script...how can I make that when one carcater will be reset....apears in his inventory, for example a Kumdum+5..or another item excelent. This will be a prize for the player.


:3dflagsdo
 
Um yeah i did all that. There are 4 different jobs:
-AutoResetBK
-AutoResetSM
-AutoResetME
-AutoResetMG
I used the reset generator to configure what i want for each res and i copyed 1 code in each job. And i Scheduled it and did everything u said LifeStealer and then what? It still doesnt work... what shall i do pls help me? :) 10x in advance :peace:
 
Can u explain what we must do after we do all that stuff? Please... Bcuz i did it all and i still can't get it to work... and i have the feeling that my mistake is after that...
 
yer great guide but how do i change it so it doesnt reset your stats or any reset :S
 
This is a Great guide but how doi change it soit dont reset stats just your level
 
Back