Guest Alex Posted March 3, 2012 Share Posted March 3, 2012 Sunt prezenţi vreau sript mea pentru fix 32767 max statistici, atunci când cineva încearcă statistici mai 32767 la 32767 de rezervă el, şi atunci când caracterul ia toate str., VIT, ENE, AGI statistici maxim şterge puncte Gratuite, include dl max prea. UPDATE CharacterSET LevelUpPoint = LevelUpPoint + 32767 + Dexterity, Dexterity = 32767FROM Character JOIN MEMB_STAT ON (MEMB_STAT.memb___id COLLATE Chinese_PRC_CS_AI = Character.AccountID COLLATE Chinese_PRC_CS_AI)WHERE (Dexterity < 0) AND (ConnectStat = 0)UPDATE CharacterSET LevelUpPoint = LevelUpPoint + 32767 + Vitality, Vitality = 32767FROM Character JOIN MEMB_STAT ON (MEMB_STAT.memb___id COLLATE Chinese_PRC_CS_AI = Character.AccountID COLLATE Chinese_PRC_CS_AI)WHERE (Vitality < 0) AND (ConnectStat = 0)UPDATE CharacterSET LevelUpPoint = LevelUpPoint + 32767 + Strength, Strength = 32767FROM Character JOIN MEMB_STAT ON (MEMB_STAT.memb___id COLLATE Chinese_PRC_CS_AI = Character.AccountID COLLATE Chinese_PRC_CS_AI)WHERE (Strength < 0) AND (ConnectStat = 0)UPDATE CharacterSET LevelUpPoint = LevelUpPoint + 32767 + Energy, Energy = 32767FROM Character JOIN MEMB_STAT ON (MEMB_STAT.memb___id COLLATE Chinese_PRC_CS_AI = Character.AccountID COLLATE Chinese_PRC_CS_AI)WHERE (Energy < 0) AND (ConnectStat = 0)UPDATE CharacterSET LevelUpPoint = LevelUpPoint + 32767 + Leadership, Leadership = 32767FROM Character JOIN MEMB_STAT ON (MEMB_STAT.memb___id COLLATE Chinese_PRC_CS_AI = Character.AccountID COLLATE Chinese_PRC_CS_AI)WHERE (Leadership < 0) AND (ConnectStat = 0)UPDATE CharacterSET LevelUpPoint='0WHERE Strength+Dexterity+Vitality+Energy='131068' OR Strength+Dexterity+Vitality+Energy+Leadership='163835'[/CODE] Link to comment Share on other sites More sharing options...
Recommended Posts