Auto reset from SQL

nightx · Admin Data inscrierii: 17/Aug/2007 Mesaje: 159

This Guide will show you how to make an AutoReset Script using SQL Server Agent.To produse a new job go to: Start>All Programmes>Microsoft SQL Server>Enterprise Manager...Then Find "Management" Double Click there and then double click to SQL Server Agent.Then Right Click on "Jobs" and select "New Job..." , Name It "AutoReset" , Category: [Uncategorized (Local)] and Owner "sa" and Description: "AutoResetSciprt".Then Click in "Steps" and press "New..." ,Then put as Step Name: "AutoReset" and Type: "Transact-SQL Script (TSQL) and Database: "MuOnline".Then as Command you have to put the Codes given below.After that you have inserted the Code press "Apply" and "Ok".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)" and then select "Occurs every" and change "1 Hour(s) to 1 Minute(s)" 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.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 = 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>= 350) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset <50>= 350) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset <50>= 350) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset <50>= 350) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 50);