Mudar Pontos Maximos

Colocando os Pontos 32k , 32767k e 65k

Fassa um 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

Gostou??? Então Copie esse post para seu Blog: Colocando os Pontos 32k , 32767k e 65k <br /><br />Fassa um JOB<br /><br />1º Abra SQL Server Enterprise Manager -> Console Root -> Microsoft MSSQL Servers -> (local) -> Management -> Sql Server Agent -> Jobs<br /><br />2º Clique com o botão direito e aperte New Job<br /><br />// Em name coloque um nome para o JOB<br />// Nao mecha em + nada.<br /><br />3º Clique na aba Steps, logo em seguida clique em New.<br /><br />// Em name coloque um nome para o Step<br />// Em database Selecione MuOnline<br />// Em Command coloque o seguinte codigo:<br /><br />"32767k<br /><br />UPDATE Character<br />SET Character.LevelUpPoint = Character.Strength - 32767,Character.Strength = ('32767')<br />WHERE Character.Strength > 32767<br /><br />UPDATE Character<br />SET Character.LevelUpPoint = Character.Vitality - 32767, Character.Vitality = ('32767')<br />WHERE Character.Vitality > 32767<br /><br />UPDATE Character<br />SET Character.LevelUpPoint = Character.Dexterity - 32767, Character.Dexterity = ('32767')<br />WHERE Character.Dexterity > 32767<br /><br />UPDATE Character<br />SET Character.LevelUpPoint = Character.Energy - 32767, Character.Energy = ('32767')<br />WHERE Character.Energy > 32767"<br /><br /><br />" 32k<br /><br />UPDATE Character<br />SET Character.LevelUpPoint = Character.Strength - 32000,Character.Strength = ('32000)<br />WHERE Character.Strength > 32000<br /><br />UPDATE Character<br />SET Character.LevelUpPoint = Character.Vitality - 32000, Character.Vitality = ('32000')<br />WHERE Character.Vitality > 32000<br /><br />UPDATE Character<br />SET Character.LevelUpPoint = Character.Dexterity - 32000, Character.Dexterity = ('32000')<br />WHERE Character.Dexterity > 32000<br /><br />UPDATE Character<br />SET Character.LevelUpPoint = Character.Energy - 32000, Character.Energy = ('32000')<br />WHERE Character.Energy > 32000"<br /><br />"65k < Para os Servers 1.02i e seus mix , e o 1.03N + Season2<br /><br />UPDATE Character<br />SET Character.LevelUpPoint = Character.Strength - 65000,Character.Strength = ('65000')<br />WHERE Character.Strength > 65000<br /><br />UPDATE Character<br />SET Character.LevelUpPoint = Character.Vitality - 65000, Character.Vitality = ('65000')<br />WHERE Character.Vitality > 65000<br /><br />UPDATE Character<br />SET Character.LevelUpPoint = Character.Dexterity - 65000, Character.Dexterity = ('65000')<br />WHERE Character.Dexterity > 65000<br /><br />UPDATE Character<br />SET Character.LevelUpPoint = Character.Energy - 65000, Character.Energy = ('65000')<br />WHERE Character.Energy > 65000 "<br /><br /><br />4º De ok e clique na aba Schedules e em New Schedule, coloque um nome para o Schedule, Selecione Recurring e clique em change<br /><br />// Em occours selecione dailly<br />// Em Dailly coloque 1 no campo Day<br />// Em Dayle frequency Selecione Occours every ** ** **<br />// Em Occours every Digite 1 e Minute(s)<br /><br />5º De Ok em todas as janelas e ative o SQL Agent.. clicando com o botao direito em cima e start