[Archive] Stat Type IDs for Items
[Archive] Stat Type IDs for Items
Original source
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.
rektbyfaith
11-04-2025, 05:04 PM #1Archived author: orangefire • Posted: 2025-11-04T18:04:23.210346
Original source
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.
Original source
That helped me alto man, thx
rektbyfaith
11-04-2025, 05:04 PM #2Archived author: orangefire • Posted: 2025-11-04T18:04:23.210346
Original source
That helped me alto man, thx
Original source
Quote:orangefire said:Nice Help !
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.
Click to expand...
rektbyfaith
11-04-2025, 05:04 PM #3Archived author: orangefire • Posted: 2025-11-04T18:04:23.210346
Original source
Quote:orangefire said:Nice Help !
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.
Click to expand...
Original source
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.
rektbyfaith
11-04-2025, 05:04 PM #4Archived author: orangefire • Posted: 2025-11-04T18:04:23.210346
Original source
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.
Original source
Quote:mihai said: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.
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.
Click to expand...
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.
rektbyfaith
11-04-2025, 05:04 PM #5Archived author: orangefire • Posted: 2025-11-04T18:04:23.210346
Original source
Quote:mihai said: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.
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.
Click to expand...
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.
Original source
Quote:orangefire said:thank you for your reply , i apreciate your effort,it only took me 2.5 years to see it(i just got back into MoP) ...
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.
Click to expand...
i have tried what you suggested already... and i had no luck .
the specific stat value for armor would be 50 , which has no effect on my character, and i mean not even items already existing in the db.
i tried it on multiple chars both on alliance and horde. nothing.
all other stats seem to work for me.
did anybody have any success in "taming" the armor stat?
thank you!
rektbyfaith
11-04-2025, 05:04 PM #6Archived author: orangefire • Posted: 2025-11-04T18:04:23.210346
Original source
Quote:orangefire said:thank you for your reply , i apreciate your effort,it only took me 2.5 years to see it(i just got back into MoP) ...
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.
Click to expand...
i have tried what you suggested already... and i had no luck .
the specific stat value for armor would be 50 , which has no effect on my character, and i mean not even items already existing in the db.
i tried it on multiple chars both on alliance and horde. nothing.
all other stats seem to work for me.
did anybody have any success in "taming" the armor stat?
thank you!
1 Guest(s)
1 Guest(s)