Stat Type IDs for Items

[orangefire]

Hello!

Sorry this isn't really a guide per se. There wasn't a "potentially helpful information" subform anywhere that I could find so this seemed like the closest match.

I did a bit of testing and put together a list of stats corresponding to their stat values. These are the numbers placed in stat_type1, stat_type2, etc fields in the item_template section of the database, which determine stats given by items. For example, if you a stat_type1 of 7 and a stat_value1 of 10, an item will give +10 Stamina. I didn't see a list like this elsewhere, so I figured I'd share it. These were tested in 4.3.4 so there may be some variance in other versions.

0 - Mana
1 - Health
2 - No Visible Effect
3 - Agility
4 - Strength
5 - Intellect
6 - Spirit
7 - Stamina
8 - No Visible Effect
9 - No Visible Effect
10 - No Visible Effect
11 - No Visible Effect*
12 - Defense Rating
13 - Dodge
14 - Parry Rating
15 - Shield Block Rating
16 - Melee Hit Rating
17 - Ranged Hit Rating
18 - Spell Hit Rating
19 - Melee Critical Strike
20 - Ranged Critical Strike
21 - Spell Critical Strike
22 - Melee Hit Avoidance
23 - Ranged Hit Avoidance
24 - Spell Hit Avoidance
25 - Melee Critical Avoidance
26 - Spell Critical Avoidance
27 - Melee Haste Rating
28 - Ranged Haste Rating
29 - Spell Haste Rating
30 - Hit Avoidance Rating
31 - Hit Rating
32 - Critical Strike
33 - Hit Avoidance Rating
34 - Critical Avoidance Rating
35 - Resilience
36 - Haste
37 - Expertise
38 - Attack Power
39 - Ranged Attack Power
40 - No Visible Effect
41 - Healing Done By Magical Spells and Effects up to value
42 - Damage Done By Magical Spells and Effects up to value
43 - Mana Regeneration (Ticks every 5 seconds)
44 - Armor Penetration Rating
45 - Spell Power
46 - Health Regeneration (Ticks every 5 seconds)
47 - Spell Penetration
48 - Block Value of Shield
49 - Mastery
50 - Armor
51 - Fire Resist
52 - Frost Resist
54 - Shadow Resist
55 - Nature Resist
56 - Arcane Resist

*The names of the two test items in the database which use stat 11 suggest that this is supposed to be sword skill. It's possible this is its effect in older versions of the game where weapon skills still existed.

I tested a few numbers past 56 but none of them had any visible effect. Combined with the fact that stat 56 is the highest number used in the game, I decided there probably were no functional stats past this point.

 

[celoabdi]

That helped me alto man, thx

 

[Suzakiro]

Hello!

Sorry this isn't really a guide per se. There wasn't a "potentially helpful information" subform anywhere that I could find so this seemed like the closest match.

I did a bit of testing and put together a list of stats corresponding to their stat values. These are the numbers placed in stat_type1, stat_type2, etc fields in the item_template section of the database, which determine stats given by items. For example, if you a stat_type1 of 7 and a stat_value1 of 10, an item will give +10 Stamina. I didn't see a list like this elsewhere, so I figured I'd share it. These were tested in 4.3.4 so there may be some variance in other versions.

0 - Mana
1 - Health
2 - No Visible Effect
3 - Agility
4 - Strength
5 - Intellect
6 - Spirit
7 - Stamina
8 - No Visible Effect
9 - No Visible Effect
10 - No Visible Effect
11 - No Visible Effect*
12 - Defense Rating
13 - Dodge
14 - Parry Rating
15 - Shield Block Rating
16 - Melee Hit Rating
17 - Ranged Hit Rating
18 - Spell Hit Rating
19 - Melee Critical Strike
20 - Ranged Critical Strike
21 - Spell Critical Strike
22 - Melee Hit Avoidance
23 - Ranged Hit Avoidance
24 - Spell Hit Avoidance
25 - Melee Critical Avoidance
26 - Spell Critical Avoidance
27 - Melee Haste Rating
28 - Ranged Haste Rating
29 - Spell Haste Rating
30 - Hit Avoidance Rating
31 - Hit Rating
32 - Critical Strike
33 - Hit Avoidance Rating
34 - Critical Avoidance Rating
35 - Resilience
36 - Haste
37 - Expertise
38 - Attack Power
39 - Ranged Attack Power
40 - No Visible Effect
41 - Healing Done By Magical Spells and Effects up to value
42 - Damage Done By Magical Spells and Effects up to value
43 - Mana Regeneration (Ticks every 5 seconds)
44 - Armor Penetration Rating
45 - Spell Power
46 - Health Regeneration (Ticks every 5 seconds)
47 - Spell Penetration
48 - Block Value of Shield
49 - Mastery
50 - Armor
51 - Fire Resist
52 - Frost Resist
54 - Shadow Resist
55 - Nature Resist
56 - Arcane Resist

*The names of the two test items in the database which use stat 11 suggest that this is supposed to be sword skill. It's possible this is its effect in older versions of the game where weapon skills still existed.

I tested a few numbers past 56 but none of them had any visible effect. Combined with the fact that stat 56 is the highest number used in the game, I decided there probably were no functional stats past this point.

Nice Help !

 

[mihai]

number 50 - Armor doesnt do anything for me on mop 5.4.8(VIP)
previously i know from 3.3.5 that armor had its own separate column, but cannot find in the new db. type. doesnt anyone know how to mod the armor?

thank you.

 

[orangefire]

number 50 - Armor doesnt do anything for me on mop 5.4.8(VIP)
previously i know from 3.3.5 that armor had its own separate column, but cannot find in the new db. type. doesnt anyone know how to mod the armor?

thank you.

These were tested in 4.3.4 so I can't guarantee everything will work in MoP, yeah. It's possible they changed armor to not be a stat anymore there.

Armor in Cata is typically automatically calculated based on item level, item type, and rarity. (Rarity is only factored in for earlier stuff, Cata-level items typically have the same armor for all rarities and are only effected by the other two factors.) The armor stat I posted is mostly used for putting armor on items that wouldn't typically have it, though can also be used to add additional armor to an item beyond what it would usually have. If you're looking into doing either of those on MoP, I would take a look at this item as a starting point. https://mop-twinhead.twinstar.cz/?item=27895 It's a ring with an armor stat so it has to have that set somewhere.