Guide to remove 32767 stats cap for TrinityCore

[Tok124]

within the "item_template" table u need to edit the "Stat_value"s Datatypes from "TINYINT to BIGINT" etc :

It should be INT not BIGINT. in the source you change GetInt16 to GetInt32, Getint16(smallint) has a cap of 32767 and GetInt32(INT) has a cap of 2147m if you change in database to BIGINT then the value in database can go above 2147m but the source is capped at 2147m and that will cause problems. Thats why you should change to INT. And no you cannot change to GetInt64 in the source...

[chyssler]

It should be INT not BIGINT. in the source you change GetInt16 to GetInt32, Getint16(smallint) has a cap of 32767 and GetInt32(INT) has a cap of 2147m if you change in database to BIGINT then the value in database can go above 2147m but the source is capped at 2147m and that will cause problems. Thats why you should change to INT. And no you cannot change to GetInt64 in the source...

eh doesnt really matters, works either way in the game (by having BIGINT) even tho limits is 2147.

[Tok124]

eh doesnt really matters, works either way in the game (by having BIGINT) even tho limits is 2147.

Sure it does work just fine. But if you give yourself 3000m attackpower you will see the problem that will occur. But sure, Aslong as you keep all stats below 2147m it works just fine

[chyssler]

Sure it does work just fine. But if you give yourself 3000m attackpower you will see the problem that will occur. But sure, Aslong as you keep all stats below 2147m it works just fine

yes exactly