| Subiectul anterior :: Subiectul urmator |
| Autor |
Mesaj |
diabolik
Membru
Data inscrierii: 13/Feb/2009
Mesaje: 70
Localitate: Motru
|
 Trimis: 20/02/2009 21:59 Titlul subiectului: Script pt lvl points |
 |
|
Cum orice server de mu online foloseste microsoft sql server pentru a rula ...propun punerea in functiune a urmatorului script care repara statusurile automat mai mari de 32767
Se creaza cate un job in enterprise manager >sql server agent> jobs....din mssql..pentru fiecare query:
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
Astfel daca un jucator va avea peste 32767 la strenght / energy / vitality / dexiterity...cand va iesi din joc..la un interval de timp programat de schedule din job...statusul cu problema ii va reveni la 32767 si va primi inapoi cate level up points a bagat in plus la acel stats.
 Sper sa va fie de folos 
_________________
To hack is a dream , To be hacked it's a nightmare ^_^
This is 10 % luck, 20 % skill
15 % concentrated power of will
5 % pleasure, 50 % pain
And 100 % reason to remember the name |
|
| Sus |
|
 |
Demon
Admin
Data inscrierii: 07/Feb/2009
Mesaje: 656
|
| Trimis: 20/02/2009 22:01 Titlul subiectului: |
|
|
gg misto :D
_________________
 |
|
| Sus |
|
|
Inferno
Amator
Data inscrierii: 18/Feb/2009
Mesaje: 224
|
| Trimis: 20/02/2009 22:02 Titlul subiectului: |
|
|
| ms pt script :D |
|
| Sus |
|
|
|
