• Bem vindo à nossa comunidade - Quer se juntar ao resto dos nossos membros? Registre-se*Registros aprovados pela adminitração

CodeMu

ChiuHuma

Honrado XPZ
"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 "
 

jubileujuliana

Usuário XPZ
tipo esse tutorial aqui é CTRL c+CTRL V

Mais concerteza vai ajudar!

Tutorial de como mudar os pontos máximo do seu mu.

Para isso basta vc fazer 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"

Creditos: MuzeirosOnline

    Eu(não sei se mereço xD)

OBS: ESSA É SO PRA 32767. OUTRAS QUERYS VC ENCONTRA POR AI '-'
 

faahemohcx

Usuário XPZ
Para mudar pra 65k, eh so ir em:

Enterprise Manager

Va na DB MuOnline

Tables

Procure Character

Botao direito, design table - Procure por Strenght, Agility, Energy, Vitality, Leadership ( esse é o ' comando ' de DL ) ... troque smallint para int e salve... Pronto agora ja funfa os 65k.
 
Topo Bottom