Modcraft - The community dedicated to quality WoW modding!
Wrath of the Lich King Modding => Serverside Modding => Topic started by: Koradorel on September 06, 2014, 10:57:03 pm
-
Hey guys, i was just wondering if I could get some help...
Trinitycore
---------------
for all items, customs, and normal items, they don't give stat bonuses properly.. I've tried messing with all configs, and releasing the database maximum.. however it always gets stuck at 16960 ingame.
I can put 1,000,000 stamina in the DB, and only 16,960 will show ingame, and if i go above 1,000,000 it just gives -31616...
It makes no sense, so any help would be GREATLY appretiated
[attachment=3:39hf7ql3]2.png[/attachment:39hf7ql3]
[attachment=1:39hf7ql3]1.png[/attachment:39hf7ql3]
[attachment=0:39hf7ql3]3.png[/attachment:39hf7ql3]
-
Why.......
-
What's the point of having that high of stats?
-
The stats_value is a smallint, which has a range of -2^15 (-32,768) to 2^15-1 (32,767). Anything outside of that range causes odd behavior. That's the cause of your issue and it makes complete sense.
MySQL shouldn't even let you go above that value unless you changed the value type to something like mediumint. However, I suspect the value size of smallint is coded into the client because you can't just change the value type in your database to get higher values (AFAIK - at least it's not that simple).
It's the same reason the level cap is 255. Level is a tinyint, which has a value of 0 to 255. You can't just change it in the database to go higher. It's coded into the client.
-
This odd behavior is also called stack overflow in this situation, but else what Kojak said - you can set stats higher iirc (Did some tests), but behavior may still differ