stolo.myforum.ro ~ Auto rr din SQL - Vizualizare subiect 95 pe stolo.myforum.ro

Mesaj Auto rr din SQL Raspunde cu citat (quote)
In acest ghid , invatati cum sa puneti autoreset din SQL.

Ok! sa incepem prin a face un nou job:
1)Start>All Programmes>Microsoft SQL Server>Enterprise Manager.
2)Cautati "Management" si datu dublu click.
3)Si dublu click iar pe SQL Server Agent.
4)Apoi Click dreapta pe "Jobs" si selectati "New Job...".
5)Puneti numele : "AutoReset" , categoria: [Uncategorized (Local)] si Owner "sa" iar Description: "AutoResetSciprt".
6)Apoi dati click pe "Steps" si apasati "New..." , apoi puneti ca Step Nume: "AutoReset" and Tipul: "Transact-SQL Script (TSQL) iar Database: "MuOnline".
7)La command va necesită sa puneti codurile de mai jos.
8)Dupa ce ati inserat codul , apasati pe "Apply" si "Ok"
9)Mergeti la Schedules si dati click pe "New Schedule..." ,la nume puneti: "AutoReset" si apasati pe "Change" apoi schimbati: "Daily" every "1 Day(s)",
10)Selectati "Occurs every" si schimbati in "1 Hour(s) la 1 Minute(s)"
11)Dupaia dati click pe "Start Date" si selectati data cu o zi in urma celeia care e acolo. De exemplu daca e 12/02/2006, selectati 11/02/2006.
12)La sfarsit lasati "No End Date" si dati click pe "Ok" de 2 ori apoi apasati pe "Apply" si "Ok" iar. Si gata , ati terminat!
*Faceti acest proces pentru fiecare cod din cele 4 de mai jos*

Codurile:

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)
If you don`t want to give Level up points at reset , feel free to modify the script

ATENTIE!>AutoReset va fi perfect cu numele coloanei= 'Reset' in 'Character' Table cu valoare principala= '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 (Versiunile 99+)

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);