Pagina de start a forumului IAD GAMES ROMANIA
  Acum este: 19/11/2026 01:48   

Pagina de start a forumului IAD GAMES ROMANIA -> ~[MU]~

Auto rr din SQL la Mu Online..

  Autor    Thread Creaza un subiect nou Raspunde la subiect
Pilifo
Administrator
Administrator
Pilifo

Data inscrierii: 18/Dec/2006
Mesaje: 344
Localitate: BUCURESTI
Auto rr din SQL la Mu Online..

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

Mesaj 14/02/2007 17:10 
 Vezi profilul utilizatorului Trimite mesaj privat Trimite un mesaj  Raspunde cu citat (quote)  
  Afiseaza mesajele pentru a le previzualiza:      
Creaza un subiect nou Raspunde la subiect

Mergi direct la:  


<  Last Thread | Next Thread  >

Forum Rules:
Nu puteti crea un subiect nou in acest forum
Nu puteti raspunde in subiectele acestui forum
Nu puteti modifica mesajele proprii din acest forum
Nu puteti sterge mesajele proprii din acest forum
Nu puteti vota in chestionarele din acest forum

 

Powered by phpBB © 2001 phpBB GroupFa-ti si tu propriul forum GRATUIT, pe www.myforum.ro

phpBB Template by Vereor.