BaNKaI ComMunITI
ComMunITaTe De SeRVaRe !
Nou pe simpatie:
sayler_moon_19 pe Simpatie
Femeie
25 ani
Bacau
cauta Barbat
26 - 46 ani
BaNKaI ComMunITIInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
BaNKaI ComMunITI / _.·••»Mu Online«••·._ / [MuOnline] Repara Statusurile Trecute de 32767 Pagini: 1  
#1
Kenz0
Administrator
Postari: 109
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

[muonline] repara trecute 32767 cum orice server online foloseste microsoft sql server pentru rula

11.6KB


_______________________________________
http://www.bannersnack.com/banner-maker ... lor=141414

 
   
Pagini: 1  
Mergi la