AutoReset Script[SQL] + Full Details

Ok Very Very nice guide only just looked but how do i set it to non reset stats just level
 
Help Auto Reset

How must make JOB in SQL , to make reset pay 1reset- 25KK, 2reset- 50kk, 3.reset- 75kk

HELPO ME PLZZ write me AUTO RESET Script plz!
 
???
Very nice guide :) but I don't understand this:
Originally posted by LifeStealer said:
*Do this for both 4 Codes that are given below*
So do I need to create more than 1 job?
And if yes, how? (because I only can use every name once(AutoReset))
 
Really need your help!

Hi lifestealer
I have had these problem for very long time! pls help me! I want to play Mu with my brothers, and I have downloaded frienzMu server and client patch! but when I run the server ( I have change ip from 1270.0.1 to local ip 192.168.100.222), it show that "skills files not found". And I don't know how to configure the client in order to connect to server. And pls tell me how to create account( also gm account).

I really need your help! pls pls pls help me!

Thanks in advance!
 
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?

Your reset column should be int with (0) as default value.
 
AutoReset (level 350-380) Script [SQL]

AutoReset (level 350-380) Script [SQL]

added reset level limit from LifeStealer guide: http://forum.ragezone.com/guides/guide-autoreset-script-sql-full-details-137262.html

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!

Notes:

AutoReset Lvl=350 to 380 (level 381 to 400 AutoReset is disabled, intended for maxed stats Characters)
Additional Points(Per Reset)= 2094 (=6 points x 349 levels for DK,BK,DW,SM,ELF,ME), 2443 (=7 points x 349 levels for MG,DL)
Reset Cost=100Millions (Each Reset)
Reset Limit=100Resets
Stats=Goes Back To Normal
Character=AutoWarp to Lorencia/Noria
Character MagicSpellList=Stays (no need to buy scrolls again)
Character Inventory=Items Stays (no need to remove items on your inventory)
Additional Pk Clear (Each Character) is removed (Pk reset manually on the web)

Class 16 is Dark Kight
Class 17 is Blade Knight
Class 0 is Dark Wizard
Class 1 is Soul Master
Class 32 is Elf
Class 33 is Muse Elf
Class 48 is Magic Gladiator
Class 64 is Dark Lord



UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 2094 * (Resets + 1), Strength = 18, Dexterity = 18, Vitality = 15, Energy = 30, Money = Money - (100000000), MapNumber = 0, MapPosX = 130, MapPosY = 130, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id COLLATE Chinese_PRC_CI_AS
WHERE ((class = 0) OR (class = 1)) AND (clevel >= 350) AND (clevel <= 380) AND (Money >= (100000000)) AND (ConnectStat = 0) AND (Resets < 100);

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 2094 * (Resets + 1), Strength = 28, Dexterity = 20, Vitality = 25, Energy = 10, Money = Money - (100000000), MapNumber = 0, MapPosX = 130, MapPosY = 130, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Chinese_PRC_CI_AS
WHERE ((class = 16) OR (class = 17)) AND (clevel >= 350) AND (clevel <= 380) AND (Money >= (100000000)) AND (ConnectStat = 0) AND (Resets < 100);

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 2094 * (Resets + 1), Strength = 22, Dexterity = 25, Vitality = 20, Energy = 15, Money = Money - (100000000), MapNumber = 0, MapPosX = 130, MapPosY = 130, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Chinese_PRC_CI_AS
WHERE ((class = 32) OR (class = 33)) AND (clevel >= 350) AND (clevel <= 380) AND (Money >= (100000000)) AND (ConnectStat = 0) AND (Resets < 100);

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 2443 * (Resets + 1), Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, Money = Money - (100000000), MapNumber = 0, MapPosX = 130, MapPosY = 130, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Chinese_PRC_CI_AS
WHERE (class = 48) AND (clevel >= 350) AND (clevel <= 380) AND (Money >= (100000000)) AND (ConnectStat = 0) AND (Resets < 100);

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 2443 * (Resets + 1), Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, Leadership = 26, Money = Money - (100000000), MapNumber = 0, MapPosX = 130, MapPosY = 130, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Chinese_PRC_CI_AS
WHERE (class = 64) AND (clevel >= 350) AND (clevel <= 380) AND (Money >= (100000000)) AND (ConnectStat = 0) AND (Resets < 100);
 
my server version 1.01e+ its frienzmu files in my server dark-lord can not reset!!

the code for for all other character but dark lord dont work
 
Re: [Guide] AutoReset Script[SQL] + Full Details

10x man good guide
 
Back