EDIT: This issue has been solved, and I've since made a tutorial about how to enable this. Please check here for a step-by-step on how I did it:
viewtopic.php?f=61&t=3939
ORIGINAL MESSAGE:
Alright, so, I've run into an interesting problem, and I'm hoping someone here might have an idea as to what's causing it. I'm still searching for answers myself, so on the off chance I find anything I'll self-reply and let everyone know.
First. Basic information:
Using Trinity Core.
Custome worldserver.conf, no core mods.
Using Trinity's basic DBs with a few minor edits and mods (just added things to them, mostly GOs),
For the project I'm working on, stats are being rebalanced to different levels across different races and classes.
The upshot of this is that I needed to alter the 'player_levelstats' Database.
These are the stats I was attempting to enter:
Field 0 - Field Type: tinyint(3) - Race: Night Elf (Race 4)
Field 1 - Field Type: tinyint(3) - Class: Priest (Class 5)
Field 2 - Field Type: tinyint(3) - Level: All levels (1-80)
Field 3 - Field Type: tinyint(3) - Strength: 984
Field 4 - Field Type: tinyint(3) - Agility: 1148
Field 5 - Field Type: tinyint(3) - Stamina: 613
Field 6 - Field Type: tinyint(3) - Intellect: 767
Field 7 - Field Type: tinyint(3) - Spirit: 1488
The first speedbump I ran into was that the data-type for fields 3-7 was tinyint(3) . (I noticed this when I logged in and all stats were 255) So, I ended up changing the fields to smallint(5) types. When next I logged in to my Nelf Priest I found that my stats looked like this:
Field 3 - Field Type: smallint(5) - Strength: 216
Field 4 - Field Type: smallint(5) - Agility: 124
Field 5 - Field Type: smallint(5) - Stamina: 101
Field 6 - Field Type: smallint(5) - Intellect: 255
Field 7 - Field Type: smallint(5) - Spirit: 208
After poking around in the DBs some, I noticed that all other primary stats in all other DBs were stored as smallint(6). Ah-ha!, I thought, I've found the problem! ...Of course, I hadn't, and after making the change this happened:
Field 3 - Field Type: smallint(6) - Strength: 216
Field 4 - Field Type: smallint(6) - Agility: 124
Field 5 - Field Type: smallint(6) - Stamina: 101
Field 6 - Field Type: smallint(6) - Intellect: 255
Field 7 - Field Type: smallint(6) - Spirit: 208
The stats remained exactly the same. So, I'm wondering if anyone on here even knows why, or perhaps has an inclining of where these numbers are processed through so that that can be altered. If anyone needs any additional information I'll try to supply it. I halfway suspect it's something tiny and simple that I'm overlooking. I'm good for that. :roll:
Thanks to anyone who answers!
-Rimewynd