Alterando pontos MAX

[' Ashe 243]

Faça uma JOB

 

 

1º Abra SQL Server Enterprise Manager -> Console Root -> Microsoft MSSQL Servers -> (local) -> Management -> Sql Server Agent -> Jobs

 

2º Clique com o botão direito e aperte New Job

 

// Em name coloque um nome para o JOB

// Nao mecha em + nada.

 

3º Clique na aba Steps, logo em seguida clique em New.

 

// Em name coloque um nome para o Step

// Em database Selecione MuOnline

// Em Command coloque o seguinte codigo:

 

"32767k

 

UPDATE Character

SET Character.LevelUpPoint = Character.Strength - 32767,Character.Strength = ('32767')

WHERE Character.Strength > 32767

 

UPDATE Character

SET Character.LevelUpPoint = Character.Vitality - 32767, Character.Vitality = ('32767')

WHERE Character.Vitality > 32767

 

UPDATE Character

SET Character.LevelUpPoint = Character.Dexterity - 32767, Character.Dexterity = ('32767')

WHERE Character.Dexterity > 32767

 

UPDATE Character

SET Character.LevelUpPoint = Character.Energy - 32767, Character.Energy = ('32767')

WHERE Character.Energy > 32767"

 

 

" 32k

 

UPDATE Character

SET Character.LevelUpPoint = Character.Strength - 32000,Character.Strength = ('32000)

WHERE Character.Strength > 32000

 

UPDATE Character

SET Character.LevelUpPoint = Character.Vitality - 32000, Character.Vitality = ('32000')

WHERE Character.Vitality > 32000

 

UPDATE Character

SET Character.LevelUpPoint = Character.Dexterity - 32000, Character.Dexterity = ('32000')

WHERE Character.Dexterity > 32000

 

UPDATE Character

SET Character.LevelUpPoint = Character.Energy - 32000, Character.Energy = ('32000')

WHERE Character.Energy > 32000"

 

"65k < Para os Servers 1.02i e seus mix , e o 1.03N + Season2

 

UPDATE Character

SET Character.LevelUpPoint = Character.Strength - 65000,Character.Strength = ('65000')

WHERE Character.Strength > 65000

 

UPDATE Character

SET Character.LevelUpPoint = Character.Vitality - 65000, Character.Vitality = ('65000')

WHERE Character.Vitality > 65000

 

UPDATE Character

SET Character.LevelUpPoint = Character.Dexterity - 65000, Character.Dexterity = ('65000')

WHERE Character.Dexterity > 65000

 

UPDATE Character

SET Character.LevelUpPoint = Character.Energy - 65000, Character.Energy = ('65000')

WHERE Character.Energy > 65000 "

 

 

4º De ok e clique na aba Schedules e em New Schedule, coloque um nome para o Schedule, Selecione Recurring e clique em change

 

// Em occours selecione dailly

// Em Dailly coloque 1 no campo Day

// Em Dayle frequency Selecione Occours every ** ** **

// Em Occours every Digite 1 e Minute(s)

 

5º De Ok em todas as janelas e ative o SQL Agent.. clicando com o botao direito em cima e start

 

 

 

créditos : ViciadosMU