[PATCH]Fix Stat-Hacks

01/10/2011 03:14 Zektor#1
This will fix any stat hacks, exploits, or glitches to people's stats.

This will also fix GM's extremely high stats to what it's supposed to be

Requirements :
The Anti-GM script / A stored procedure that runs consecutively

In the anti-gm stored procedure add this

Code:
UPDATE character.dbo.user_character set wCon = 7, wStr = 7, wDex = 7, wSpr = 7, wStatPoint = ((wLevel - 1) * 7) where (wStr + wCon + wDex + wSpr + wStatPoint) != (28 + (wLevel - 1) * 7)
Put this before any IF statements in that script

Also, change the 7 to the amount of stat points rewarded each level, and change the 28 to YOURSTATPOINT * 4

So if a user is rewarded 5 every level, it would be 20.

For server sthat reward 5 stat points every level the script would look like this:
Code:
UPDATE character.dbo.user_character set wCon = 5, wStr = 5, wDex = 5, wSpr = 5, wStatPoint = ((wLevel - 1) * 5) where (wStr + wCon + wDex + wSpr + wStatPoint) != (20 + (wLevel - 1) * 5)
Just adapt to this script and it'll work for all levels.