[Tutorial] Jobs todos os tipos!

Auto Reset para Player Vip,Player nao,Vip, GM e ADM

Primeiro Abra Microsoft SQL Servers > SQL Server Group > (local) (Windows NT) > MuOnline > Tables > Character

>Clica com o direito em Desing Table e la na ultima coluna e ponha assim:

Column Name : Resets
Data Type : int
Allow Nulls : Desmarque
Default Value : 0

De Ok

Depois Va em - Microsoft SQL Servers > SQL Server Group > (local) (Windows NT) > MuOnline > Tables > MENB_INFO

>Clica com o direito em Desing Table e la na ultima coluna e ponha assim:

Column Name : Vip
Data Type : int
Allow Nulls : Desmarque
Default Value : 0

De Ok

Depois Vá no SQL
Abra Microsoft SQL Servers > SQL Server Group > (local) (Windows NT) > Management >Clica com o direito em SQL Server Agent > Start

Abra SQL Server Agent e clique em Jobs
Clique com o direito e de New Job
Ponha o nome de AutoReset

Vá para Steps, clique em New Job
Coloque o nome AutoReset
database : muonline
Em command, você põe esse codigo:

Player Nao Vip:

UPDATE Character
SET clevel=('1') , experience=('0') , LevelUpPoint=350+350*Resets , Resets=Resets+1 ,Inventory=NULL,
MagicList=NULL, Strength=('20') , Dexterity=('20') , Vitality=('20') , Energy=('20')
FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id COLLATE Latin1_General_CS_AS
JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS
WHERE clevel>399 and MEMB_INFO.vip=0 and MEMB_STAT.ConnectStat=0 and Money>('6000000')

Player Vip:

UPDATE Character
SET clevel=('1') , experience=('0') , LevelUpPoint=800+800*Resets , Resets=Resets+1 , Strength=('40') , Dexterity=('40') , Vitality=('40') , Energy=('40')
FROM Character JOIN Memb_Stat on Character.Accountid = Memb_Stat.memb___id COLLATE Latin1_General_CS_AS
JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS
WHERE clevel>299 and MEMB_INFO.vip=1 and MEMB_STAT.ConnectStat = 0

GM:

UPDATE Character
SET clevel=('1') , experience=('0') , LevelUpPoint=365000+65000*Resets , Resets=Resets+1 , Strength=('32000') , Dexterity=('32000') , Vitality=('32000') , Energy=('32000')
FROM Character JOIN Memb_Stat on Character.Accountid = Memb_Stat.memb___id COLLATE Latin1_General_CS_AS
JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS
WHERE clevel>999 and MEMB_INFO.vip=8 and MEMB_STAT.ConnectStat = 0

ADM:

UPDATE Character
SET clevel=('1') , experience=('0') , LevelUpPoint=65000+65000*Resets , Resets=Resets+1 , Strength=('32000') , Dexterity=('16000') , Vitality=('32000') , Energy=('32000')
FROM Character JOIN Memb_Stat on Character.Accountid = Memb_Stat.memb___id COLLATE Latin1_General_CS_AS
JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS
WHERE clevel>999 and MEMB_INFO.vip=24 and MEMB_STAT.ConnectStat = 0

Clique em parse,clique em apply e depois em ok

Agora você vai em Schedule e de New Schedule
Nome : AutoReset

Ai você segue essa sequencia:
Reccurting > Change
Occurs : Daily,every 1 days
Daily frequerency : occurs every : 1 minute

Ai vc da ok, ok, aplicar e ok....

Sua job vai aparecer ai vc clica com o direito nela e da start.


Colocar Box em Bau de GMs automaticamente

Primeiro Abra Microsoft SQL Servers > SQL Server Group > (local) (Windows NT) > MuOnline > Tables > warehouse

>Clica com o direito em Desing Table e la na ultima coluna e ponha assim:

Column Name : isGm
Data Type : int
Allow Nulls : Desmarque
Default Value : 0

Depois Vá no SQL
Abra Microsoft SQL Servers > SQL Server Group > (local) (Windows NT) > Management >Clica com o direito em SQL Server Agent > Start

Abra SQL Server Agent e clique em Jobs
Clique com o direito e de New Job
Ponha o nome de isGm

Vá para Steps, clique em New Job
Coloque o nome isGm
database : muonline
Em command, você põe esse codigo:

UPDATE dbo.warehouse SET
money=2000000,items=CONVERT(varbinary(1920),0xCB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60F
F000000008
06355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF0
0000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF000000008063
55CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF000000
00806355CB6
0FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF0000000080
6355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF000
00000806355
CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000
806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF0000
0000806
355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60F
F0000000080635
5CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000
806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000
000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF0
0000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF
00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355C
B60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF000000008
06355CB60
FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF000000008063
55CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000
000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF
00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355C
B60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806
355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF0000000
0806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF000
00000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB6
0FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF0000000080
6355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355CB60FF00000000806355)
WHERE isGm = '1'

Clique em parse,clique em apply e depois em ok

Agora você vai em Schedule e de New Schedule
Nome : isGm

Ai você segue essa sequencia:
Reccurting > Change
Occurs : Daily,every 1 days
Daily frequerency : occurs every : 1 minute

Ai vc da ok, ok, aplicar e ok....

Sua job vai aparecer ai vc clica com o direito nela e da start.


Vip Sai Sozinho

Primeiro Abra Microsoft SQL Servers > SQL Server Group > (local) (Windows NT) > MuOnline > Tables > MENB_INFO
>Clica com o direito em Desing Table e la na ultima coluna e ponha assim:

Column Name : creditos
Data Type : int
Allow Nulls : Desmarque
Default Value : 0

Depois Vá no SQL
Abra Microsoft SQL Servers > SQL Server Group > (local) (Windows NT) > Management >Clica com o direito em SQL Server Agent > Start

Abra SQL Server Agent e clique em Jobs
Clique com o direito e de New Job
Ponha o nome de creditos

Vá para Steps, clique em New Job
Nome : Money
database : muonline
Em command, você põe esse codigo:

Update MEMB_INFO
Set creditos=creditos -1
WHERE creditos>0

Clique em parse,clique em apply e depois em ok

Agora você vai em Schedule e de New Schedule
Nome : creditos
Ai você segue essa sequencia:
Reccurting > Change
Occurs : Daily,every 1 days
Daily frequerency : occurs every : ponha 24 Hours.

Ai vc da ok, ok, aplicar e ok....

Sua job vai aparecer ai vc clica com o direito nela e da start.

Job (evitando zen do bug)

Abra Microsoft SQL Servers > SQL Server Group > (local) (Windows NT) > Management >Clica com o direito em SQL Server Agent > Start

Abra SQL Server Agent e clique em Jobs
Clique com o direito e de New Job
Ponha o nome de Money

Vá para Steps, clique em New Job
Nome : Money
database : muonline
Em command, você põe esse codigo:

UPDATE Character
Set Money=('2000000000')
WHERE Money>2000000000

Clique em parse,clique em apply e depois em ok

Agora você vai em Schedule e de New Schedule
Nome : Money
Ai você segue essa sequencia:
Reccurting > Change
Occurs : Daily,every 1 days
Daily frequerency : occurs every : 1 minute

Ai vc da ok, ok, aplicar e ok....

Sua job vai aparecer ai vc clica com o direito nela e da start.


Forum Ant Cheats