[Guide] Good Script for AutoFix stats

[Masteru]

I m whant present my sript for fix 32767 max stats, when someone try more 32767 stats he backup to 32767, and when character takes all str,vit,ene,agi stats max delete freee points, include dl max too.

UPDATE Character
SET LevelUpPoint = LevelUpPoint + 32767 + Dexterity, Dexterity = 32767
FROM 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 Character
SET LevelUpPoint = LevelUpPoint + 32767 + Vitality, Vitality = 32767
FROM 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 Character
SET LevelUpPoint = LevelUpPoint + 32767 + Strength, Strength = 32767
FROM 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 Character
SET LevelUpPoint = LevelUpPoint + 32767 + Energy, Energy = 32767
FROM 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 Character
SET LevelUpPoint = LevelUpPoint + 32767 + Leadership, Leadership = 32767
FROM 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 Character
SET LevelUpPoint='0
WHERE Strength+Dexterity+Vitality+Energy='131068' OR Strength+Dexterity+Vitality+Energy+Leadership='163835'

[MentaL]

[mcmarilag]

I m whant present my sript for fix 32767 max stats, when someone try more 32767 stats he backup to 32767, and when character takes all str,vit,ene,agi stats max delete freee points, include dl max too.

UPDATE Character
SET LevelUpPoint = LevelUpPoint + 32767 + Dexterity, Dexterity = 32767
FROM 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 Character
SET LevelUpPoint = LevelUpPoint + 32767 + Vitality, Vitality = 32767
FROM 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 Character
SET LevelUpPoint = LevelUpPoint + 32767 + Strength, Strength = 32767
FROM 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 Character
SET LevelUpPoint = LevelUpPoint + 32767 + Energy, Energy = 32767
FROM 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 Character
SET LevelUpPoint = LevelUpPoint + 32767 + Leadership, Leadership = 32767
FROM 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 Character
SET LevelUpPoint='0
WHERE Strength+Dexterity+Vitality+Energy='131068' OR Strength+Dexterity+Vitality+Energy+Leadership='163835'

thanks but why not use [code] tag?

[Th3AnG3L]

good script for autofix stats protocol.cpp best solution

[145812]

Do you know how to limit the addpoints limit? for example 20,000 stats to divide on STR,AGI,ENE.

[Th3AnG3L]

Do you know how to limit the addpoints limit? for example 20,000 stats to divide on STR,AGI,ENE.

2 ways:
1- Protocol Check
2- Hook Check