| Autor |
Mesaj |
Luky
Administrator


Data inscrierii: 27/Aug/2008 Mesaje: 41 Localitate: Salonta |
|
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.
|
|
| 05/03/2009 00:36 |
|
 |
|
|
Nu puteti crea un subiect nou in acest forum Nu puteti raspunde in subiectele acestui forum Nu puteti modifica mesajele proprii din acest forum Nu puteti sterge mesajele proprii din acest forum Nu puteti vota in chestionarele din acest forum
|
Powered by phpBB © 2001, 2005 phpBB Group Fa-ti si tu propriul forum GRATUIT, pe www.myforum.ro
|
|