Multi useri baga accidental peste 32767 statusurile Cum fiecare SvR foloseste MicrosoftSql introduceti urmatorul script pentru a repara automat statusurile mai mari de 32767.
Se creaza cate un job in enterprise manager >sql server agent> jobs....din mssql..pentru fiecare query:
Quote UPDATE Character SET Character.LevelUpPoint = Character.Strength - 32767,Character.Strength = ('32767') WHERE Character.Strength > 32767
Quote UPDATE Character SET Character.LevelUpPoint = Character.Vitality - 32767, Character.Vitality = ('32767') WHERE Character.Vitality > 32767
Quote UPDATE Character SET Character.LevelUpPoint = Character.Dexterity - 32767, Character.Dexterity = ('32767') WHERE Character.Dexterity > 32767
Quote UPDATE Character SET Character.LevelUpPoint = Character.Energy - 32767, Character.Energy = ('32767') WHERE Character.Energy > 32767
Utilizand acest script 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. bounce
LvL points Script – poza de Vipera, in ^Tutoriale^ · 10.2KB