Team BlueWater Game Online Tutorial's
Bine ati venit la Team-BlueWater!!Tutorial's 4 all Games!

Script [MuOnline] (Repara Statusurile Tecute de 32767)

View previous topic View next topic Go down

Script [MuOnline] (Repara Statusurile Tecute de 32767)

Post  m4s4cru on Tue Aug 02, 2011 10:46 am

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:

Code:
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.
avatar
m4s4cru
Admin
Admin

Mesaje : 172
Data de inscriere : 2011-07-29
Varsta : 26

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum