Table: item_template

Holds information on every item that exists in the game. All items are created from their template stored in this table.

(See additional information in the ItemPrototype.h file.)

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
entry	mediumint(8)	unsigned	PRI	NO	0
class	tinyint(3)	unsigned		NO	0
subclass	tinyint(3)	unsigned		NO	0
SoundOverrideSubclass	tinyint(3)	signed		NO	-1
name	varchar(255)	signed		NO	NULL
displayid	mediumint(8)	unsigned		NO	0
Quality	tinyint(3)	unsigned		NO	0
Flags	bigint(20)	signed		NO	0
FlagsExtra	int(10)	unsigned		NO	0
BuyCount	tinyint(3)	unsigned		NO	1
BuyPrice	bigint(20)	signed		NO	0
SellPrice	int(10)	unsigned		NO	0
InventoryType	tinyint(3)	unsigned		NO	0
AllowableClass	int(11)	signed		NO	-1
AllowableRace	int(11)	signed		NO	-1
ItemLevel	smallint(5)	unsigned		NO	0
RequiredLevel	tinyint(3)	unsigned		NO	0
RequiredSkill	smallint(5)	unsigned		NO	0
RequiredSkillRank	smallint(5)	unsigned		NO	0
requiredspell	mediumint(8)	unsigned		NO	0
requiredhonorrank	mediumint(8)	unsigned		NO	0
RequiredCityRank	mediumint(8)	unsigned		NO	0
RequiredReputationFaction	smallint(5)	unsigned		NO	0
RequiredReputationRank	smallint(5)	unsigned		NO	0
maxcount	int(11)	signed		NO	0
stackable	int(11)	signed		NO	1
ContainerSlots	smallint(5)	unsigned		NO	0
StatsCount	tinyint(3)	unsigned		NO	0
stat_type1	tinyint(3)	unsigned		NO	0
stat_value1	smallint(6)	signed		NO	0
stat_type2	tinyint(3)	unsigned		NO	0
stat_value2	smallint(6)	signed		NO	0
stat_type3	tinyint(3)	unsigned		NO	0
stat_value3	smallint(6)	signed		NO	0
stat_type4	tinyint(3)	unsigned		NO	0
stat_value4	smallint(6)	signed		NO	0
stat_type5	tinyint(3)	unsigned		NO	0
stat_value5	smallint(6)	signed		NO	0
stat_type6	tinyint(3)	unsigned		NO	0
stat_value6	smallint(6)	signed		NO	0
stat_type7	tinyint(3)	unsigned		NO	0
stat_value7	smallint(6)	signed		NO	0
stat_type8	tinyint(3)	unsigned		NO	0
stat_value8	smallint(6)	signed		NO	0
stat_type9	tinyint(3)	unsigned		NO	0
stat_value9	smallint(6)	signed		NO	0
stat_type10	tinyint(3)	unsigned		NO	0
stat_value10	smallint(6)	signed		NO	0
ScalingStatDistribution	smallint(6)	signed		NO	0
ScalingStatValue	int(6)	unsigned		NO	0
dmg_min1	float	signed		NO	0
dmg_max1	float	signed		NO	0
dmg_type1	tinyint(3)	unsigned		NO	0
dmg_min2	float	signed		NO	0
dmg_max2	float	signed		NO	0
dmg_type2	tinyint(3)	unsigned		NO	0
armor	smallint(5)	unsigned		NO	0
holy_res	tinyint(3)	unsigned		NO	0
fire_res	tinyint(3)	unsigned		NO	0
nature_res	tinyint(3)	unsigned		NO	0
frost_res	tinyint(3)	unsigned		NO	0
shadow_res	tinyint(3)	unsigned		NO	0
arcane_res	tinyint(3)	unsigned		NO	0
delay	smallint(5)	unsigned		NO	1000
ammo_type	tinyint(3)	unsigned		NO	0
RangedModRange	float	signed		NO	0
spellid_1	mediumint(8)	signed		NO	0
spelltrigger_1	tinyint(3)	unsigned		NO	0
spellcharges_1	smallint(6)	signed		NO	0
spellppmRate_1	float	signed		NO	0
spellcooldown_1	int(11)	signed		NO	-1
spellcategory_1	smallint(5)	unsigned		NO	0
spellcategorycooldown_1	int(11)	signed		NO	-1
spellid_2	mediumint(8)	signed		NO	0
spelltrigger_2	tinyint(3)	unsigned		NO	0
spellcharges_2	smallint(6)	signed		NO	0
spellppmRate_2	float	signed		NO	0
spellcooldown_2	int(11)	signed		NO	-1
spellcategory_2	smallint(5)	unsigned		NO	0
spellcategorycooldown_2	int(11)	signed		NO	-1
spellid_3	mediumint(8)	signed		NO	0
spelltrigger_3	tinyint(3)	unsigned		NO	0
spellcharges_3	smallint(6)	signed		NO	0
spellppmRate_3	float	signed		NO	0
spellcooldown_3	int(11)	signed		NO	-1
spellcategory_3	smallint(5)	unsigned		NO	0
spellcategorycooldown_3	int(11)	signed		NO	-1
spellid_4	mediumint(8)	signed		NO	0
spelltrigger_4	tinyint(3)	unsigned		NO	0
spellcharges_4	smallint(6)	signed		NO	0
spellppmRate_4	float	signed		NO	0
spellcooldown_4	int(11)	signed		NO	-1
spellcategory_4	smallint(5)	unsigned		NO	0
spellcategorycooldown_4	int(11)	signed		NO	-1
spellid_5	mediumint(8)	signed		NO	0
spelltrigger_5	tinyint(3)	unsigned		NO	0
spellcharges_5	smallint(6)	signed		NO	0
spellppmRate_5	float	signed		NO	0
spellcooldown_5	int(11)	signed		NO	-1
spellcategory_5	smallint(5)	unsigned		NO	0
spellcategorycooldown_5	int(11)	signed		NO	-1
bonding	tinyint(3)	unsigned		NO	0
description	varchar(255)	signed		NO	NULL
PageText	mediumint(8)	unsigned		NO	0
LanguageID	tinyint(3)	unsigned		NO	0
PageMaterial	tinyint(3)	unsigned		NO	0
startquest	mediumint(8)	unsigned		NO	0
lockid	mediumint(8)	unsigned		NO	0
Material	tinyint(4)	signed		NO	0
sheath	tinyint(3)	unsigned		NO	0
RandomProperty	mediumint(8)	signed		NO	0
RandomSuffix	mediumint(8)	unsigned		NO	0
block	mediumint(8)	unsigned		NO	0
itemset	mediumint(8)	unsigned		NO	0
MaxDurability	smallint(5)	unsigned		NO	0
area	mediumint(8)	unsigned		NO	0
Map	smallint(6)	signed		NO	0
BagFamily	mediumint(9)	signed		NO	0
TotemCategory	mediumint(9)	signed		NO	0
socketColor_1	tinyint(4)	signed		NO	0
socketContent_1	mediumint(9)	signed		NO	0
socketColor_2	tinyint(4)	signed		NO	0
socketContent_2	mediumint(9)	signed		NO	0
socketColor_3	tinyint(4)	signed		NO	0
socketContent_3	mediumint(9)	signed		NO	0
socketBonus	mediumint(9)	signed		NO	0
GemProperties	mediumint(9)	signed		NO	0
RequiredDisenchantSkill	smallint(6)	signed		NO	-1
ArmorDamageModifier	float	signed		NO	0
duration	int(10)	unsigned		NO	0		Duration in seconds
ItemLimitCategory	smallint(6)	signed		NO	0
HolidayId	int(11)	unsigned		NO	0
ScriptName	varchar(64)	signed		NO	NULL
DisenchantID	mediumint(8)	unsigned		NO	0
FoodType	tinyint(3)	unsigned		NO	0
minMoneyLoot	int(10)	unsigned		NO	0
maxMoneyLoot	int(10)	unsigned		NO	0
flagsCustom	int(10)	unsigned		NO	0
VerifiedBuild (WDBVerified)	smallint(5)	signed		YES	1

Description of the fields

entry

The ID of the item. This ID is unique between all templates.

class

The class of the item:

ID	Name
0	Consumable
1	Container
2	Weapon
3	Gem
4	Armor
5	Reagent
6	Projectile
7	Trade Goods
8	Generic(OBSOLETE)
9	Recipe
10	Money(OBSOLETE)
11	Quiver
12	Quest
13	Key
14	Permanent(OBSOLETE)
15	Miscellaneous
16	Glyph

subclass

The subclass of the item. The following table lists all available subclass and class combinations and the subclass name.

Class ID	Subclass ID	Subclass Name	Comments
0	0	Consumable	Usability in combat is decided by the spell assigned.
0	1	Potion
0	2	Elixir
0	3	Flask
0	4	Scroll
0	5	Food & Drink
0	6	Item Enhancement
0	7	Bandage
0	8	Other
1	0	Bag
1	1	Soul Bag
1	2	Herb Bag
1	3	Enchanting Bag
1	4	Engineering Bag
1	5	Gem Bag
1	6	Mining Bag
1	7	Leatherworking Bag
1	8	Inscription Bag
2	0	Axe	One handed
2	1	Axe	Two handed
2	2	Bow
2	3	Gun
2	4	Mace	One handed
2	5	Mace	Two handed
2	6	Polearm
2	7	Sword	One handed
2	8	Sword	Two handed
2	9	Obsolete
2	10	Staff
2	11	Exotic
2	12	Exotic
2	13	Fist Weapon
2	14	Miscellaneous	(Blacksmith Hammer, Mining Pick, etc.)
2	15	Dagger
2	16	Thrown
2	17	Spear
2	18	Crossbow
2	19	Wand
2	20	Fishing Pole
3	0	Red
3	1	Blue
3	2	Yellow
3	3	Purple
3	4	Green
3	5	Orange
3	6	Meta
3	7	Simple
3	8	Prismatic
4	0	Miscellaneous
4	1	Cloth
4	2	Leather
4	3	Mail
4	4	Plate
4	5	Buckler(OBSOLETE)
4	6	Shield
4	7	Libram
4	8	Idol
4	9	Totem
4	10	Sigil
5	0	Reagent
6	0	Wand(OBSOLETE)
6	1	Bolt(OBSOLETE)
6	2	Arrow
6	3	Bullet
6	4	Thrown(OBSOLETE)
7	0	Trade Goods
7	1	Parts
7	2	Explosives
7	3	Devices
7	4	Jewelcrafting
7	5	Cloth
7	6	Leather
7	7	Metal & Stone
7	8	Meat
7	9	Herb
7	10	Elemental
7	11	Other
7	12	Enchanting
7	13	Materials
7	14	Armor Enchantment
7	15	Weapon Enchantment
8	0	Generic(OBSOLETE)
9	0	Book
9	1	Leatherworking
9	2	Tailoring
9	3	Engineering
9	4	Blacksmithing
9	5	Cooking
9	6	Alchemy
9	7	First Aid
9	8	Enchanting
9	9	Fishing
9	10	Jewelcrafting
10	0	Money(OBSOLETE)
11	0	Quiver(OBSOLETE)
11	1	Quiver(OBSOLETE)
11	2	Quiver	Can hold arrows
11	3	Ammo Pouch	Can hold bullets
12	0	Quest
13	0	Key
13	1	Lockpick
14	0	Permanent
15	0	Junk
15	1	Reagent
15	2	Pet
15	3	Holiday
15	4	Other
15	5	Mount
16	1	Warrior
16	2	Paladin
16	3	Hunter
16	4	Rogue
16	5	Priest
16	6	Death Knight
16	7	Shaman
16	8	Mage
16	9	Warlock
16	11	Druid

SoundOverrideSubclass

Weapons have special sounds on impact. This column is used to override these sounds by specifying another subclass.

For example an item with misc subclass can sound like a stave on impact by overriding the subclass here.

name

The item's name that will be displayed.

displayid

The model ID of the item. Each model has its own icon assigned so this field controls both the model appearance and the icon.

Quality

The quality of the item: (NOTE: Must also have flags = 134221824 set when using Bind To Account)

ID	Color	Quality
0	Grey	Poor
1	White	Common
2	Green	Uncommon
3	Blue	Rare
4	Purple	Epic
5	Orange	Legendary
6	Red	Artifact
7	Gold	Bind to Account

Flags

Bitmask field that contains flags that the item has on it. As all other such fields, just add the flags together to combine them. Possible flags are listed below.

Flag		Comments
1	0x01	UNK1
2	0x02	Conjured item
4	0x04	Openable (can be opened by right-click)
8	0x08	Makes green "Heroic" text appear on item
16	0x010	Deprecated Item
32	0x020	Item can not be destroyed, except by using spell (item can be reagent for spell)
64	0x040	UNK2
128	0x080	No default 30 seconds cooldown when equipped
256	0x0100	UNK3
512	0x0200	Wrapper : Item can wrap other items
1024	0x0400	UNK4
2048	0x0800	Item is party loot and can be looted by all
4096	0x01000	Item is refundable
8192	0x02000	Charter (Arena or Guild)
16384	0x04000	UNK5 // comment in code : Only readable items have this (but not all)
32768	0x08000	UNK6
65536	0x010000	UNK7
131072	0x020000	UNK8
262144	0x040000	Item can be prospected
524288	0x080000	Unique equipped (player can only have one equipped at the same time)
1048576	0x0100000	UNK9
2097152	0x0200000	Item can be used during arena match
4194304	0x0400000	Throwable (for tooltip ingame)
8388608	0x0800000	Item can be used in shapeshift forms
16777216	0x01000000	UNK10
33554432	0x02000000	Profession recipes: can only be looted if you meet requirements and don't already know it
67108864	0x04000000	Item cannot be used in arena
134217728	0x08000000	Bind to Account (Also needs Quality = 7 set)
268435456	0x010000000	Spell is cast with triggered flag
536870912	0x020000000	Millable
1073741824	0x040000000	UNK11
2147483648	0x080000000	Bind on Pickup tradeable

FlagsExtra

Flag		Comments
1	0x01	Horde Only
2	0x02	Alliance Only
4	0x04	When item uses ExtendedCost in npc_vendor, gold is also required
256	0x0100	Makes need roll for this item disabled
512	0x0200	NEED_ROLL_DISABLED
16384	0x04000	HAS_NORMAL_PRICE
131072	0x020000	BNET_ACCOUNT_BOUND
2097152	0x0200000	CANNOT_BE_TRANSMOG
4194304	0x0400000	CANNOT_TRANSMOG
8388608	0x0800000	CAN_TRANSMOG

BuyCount

The size of the item stack when sold by vendors. Also if a vendor has limited copies of this item available, everytime the vendor list is refreshed (See npc_vendor.incrtime), the number of copies increases by this number.

BuyPrice

The price required to pay to buy this item from a vendor, in copper.

SellPrice

The price that the vendor will pay you for the item when you sell it and if it is possible to be sold, in copper. Put in 0 if the item cannot be sold to a vendor.

InventoryType

In what slot the item can be equipped.

ID	Slot Name	ID	Slot Name
0	Non equipable	15	Ranged (Bows)
1	Head	16	Back
2	Neck	17	Two-Hand
3	Shoulder	18	Bag
4	Shirt	19	Tabard
5	Chest	20	Robe
6	Waist	21	Main hand
7	Legs	22	Off hand
8	Feet	23	Holdable (Tome)
9	Wrists	24	Ammo
10	Hands	25	Thrown
11	Finger	26	Ranged right (Wands, Guns)
12	Trinket	27	Quiver
13	Weapon	28	Relic
14	Shield

AllowableClass

Bitmask controlling which classes can use this item. Add ids together to combine class possibilities. Use -1 if all classes can use it. ChrClasses.dbc

AllowableRace

Bitmask controlling which races can use this item. Add ids together to combine race possibilities. Use -1 for all races. ChrRaces.dbc

ItemLevel

Base item level.

RequiredLevel

Required level the player has to be to use this item.

RequiredSkill

The skill required to use this item. See SkillLine.dbc

RequiredSkillRank

The required skill rank the player needs to have to use this item.

requiredspell

The required spell that the player needs to have to use this item.

requiredhonorrank

The honor rank the player needs to have to use this item.

RequiredCityRank

field-no-description|22

RequiredReputationFaction

The faction template ID (from Faction.dbc) of the faction that the player has to have a certain ranking with. If this value is 0, the faction of the seller of the item is used.

RequiredReputationRank

The rank the player has to have with the faction from RequiredReputationFaction.

ID	Rank
0	Hated
1	Hostile
2	Unfriendly
3	Neutral
4	Friendly
5	Honored
6	Revered
7	Exalted

maxcount

Maximum number of copies of this item a player can have. Use 0 for infinite.

stackable

The number of copies of this item that can be stacked in the same slot.

ContainerSlots

If the item is a bag, this field controls the number of slots the bag has.

StatsCount

When an item has entries in stat_type, this must be updated to display those entries
(Unknown how this works)

stat_type

The type of stat to modify.

ID	Stat Type
0	ITEM_MOD_MANA
1	ITEM_MOD_HEALTH
3	ITEM_MOD_AGILITY
4	ITEM_MOD_STRENGTH
5	ITEM_MOD_INTELLECT
6	ITEM_MOD_SPIRIT
7	ITEM_MOD_STAMINA
12	ITEM_MOD_DEFENSE_SKILL_RATING
13	ITEM_MOD_DODGE_RATING
14	ITEM_MOD_PARRY_RATING
15	ITEM_MOD_BLOCK_RATING
16	ITEM_MOD_HIT_MELEE_RATING
17	ITEM_MOD_HIT_RANGED_RATING
18	ITEM_MOD_HIT_SPELL_RATING
19	ITEM_MOD_CRIT_MELEE_RATING
20	ITEM_MOD_CRIT_RANGED_RATING
21	ITEM_MOD_CRIT_SPELL_RATING
22	ITEM_MOD_HIT_TAKEN_MELEE_RATING
23	ITEM_MOD_HIT_TAKEN_RANGED_RATING
24	ITEM_MOD_HIT_TAKEN_SPELL_RATING
25	ITEM_MOD_CRIT_TAKEN_MELEE_RATING
26	ITEM_MOD_CRIT_TAKEN_RANGED_RATING
27	ITEM_MOD_CRIT_TAKEN_SPELL_RATING
28	ITEM_MOD_HASTE_MELEE_RATING
29	ITEM_MOD_HASTE_RANGED_RATING
30	ITEM_MOD_HASTE_SPELL_RATING
31	ITEM_MOD_HIT_RATING
32	ITEM_MOD_CRIT_RATING
33	ITEM_MOD_HIT_TAKEN_RATING
34	ITEM_MOD_CRIT_TAKEN_RATING
35	ITEM_MOD_RESILIENCE_RATING
36	ITEM_MOD_HASTE_RATING
37	ITEM_MOD_EXPERTISE_RATING
38	ITEM_MOD_ATTACK_POWER
39	ITEM_MOD_RANGED_ATTACK_POWER
40	ITEM_MOD_FERAL_ATTACK_POWER (not used as of 3.3)
41	ITEM_MOD_SPELL_HEALING_DONE
42	ITEM_MOD_SPELL_DAMAGE_DONE
43	ITEM_MOD_MANA_REGENERATION
44	ITEM_MOD_ARMOR_PENETRATION_RATING
45	ITEM_MOD_SPELL_POWER
46	ITEM_MOD_ HEALTH_REGEN
47	ITEM_MOD_SPELL_PENETRATION
48	ITEM_MOD_BLOCK_VALUE

stat_value

The value to change the stat type to.

ScalingStatDistribution

Similar to Static Stats these are the Stats that grow along with the users level (mainly heirloom leveling gear)
use like static stats

ScalingStatValue

Final (level 80) value of the scaling-stat

dmg_min

The minimum damage of the item.

dmg_max

The maximum damage of the item.

dmg_type

The damage type that the item uses.

ID	Damage Type
0	Physical
1	Holy
2	Fire
3	Nature
4	Frost
5	Shadow
6	Arcane

armor

The armor value of the item.

holy_res

Holy resistance.

fire_res

Fire resistance.

nature_res

Nature resistance.

frost_res

Frost resistance.

shadow_res

Shadow resistance.

arcane_res

Arcane resistance.

delay

The time in milliseconds between successive hits.

ammo_type

The type of ammunition the item uses. Arrows = 2; Bullets = 3

RangedModRange

Range Modifier for bows/guns/crossbows:

Default range is somewhere between 0.3 and 0.4 yards,

all blizzard ranged weapons have RangedModRange100

spellid

The spell ID of the spell that the item can cast or trigger.

spelltrigger

The type of trigger for the spell.

ID	Trigger Type
0	Use
1	On Equip
2	Chance on Hit
4	Soulstone
5	Use with no delay
6	Learn Spell ID

spellcharges

The number of times that the item can cast the spell. If 0, then infinite charges are possible. If negative, then after the number of charges is depleted, the item is deleted as well. If positive, then the item is not deleted after all the charges are spent.

spellppmRate

The proc per minute rate controlling how often the spell is triggered (if #spelltrigger == 2).

spellcooldown

The cooldown in milliseconds for the specific spell controlling how often the spell can be used. Use -1 to use the default spell cooldown. Note: this is not the "internal cooldown" of procs commonly found on items such as trinkets with "Chance on hit" effects.

spellcategory

The category that the spell is in.

spellcategorycooldown

The cooldown time in milliseconds that is applied to all other spells in the category that the triggered spell is also in. Use -1 to use the default spell cooldown.

bonding

The bonding for the item.

ID	Bonding Type
0	No bounds
1	Binds when picked up
2	Binds when equipped
3	Binds when used
4	Quest item
5	Quest Item1

description

The description that appears in orange letters at the bottom of the item tooltip.

PageText

The ID referring to the text that the item will show (if it is a book or a letter, etc). The item will have a magnifying glass cursor in the game and will show the text when right-clicked. See page_text.entry

LanguageID

The language that the item text is written in. Languages.dbc

PageMaterial

The background texture that appears in the page text window. PageTextMaterial.dbc

startquest

The ID of the quest that this item will start if right-clicked. See quest_template.id

lockid

The lock entry ID that this item (which serves as a key) is tied to. This field is used in key-door mechanics. See Lock.dbc

Material

The material that the item is made of. The value here affects the sound that the item makes when moved. Use -1 for consumable items like food, reagents, etc.

ID	Material
-1	Consumables Food, Reagents etc..
0	Not Defined
1	Metal
2	Wood
3	Liquid
4	Jewelry
5	Chain
6	Plate
7	Cloth
8	Leather

sheath

Controls how the item is put away on the character (pressing the 'Z' hotkey).

ID	Type	Position
1	Two Handed Weapon	Diagonally accross the back pointing down
2	Staff	Diagonally accross the back poiting up
3	One Handed	To the side
4	Shield	On the back in the middle
5	Enchanter's Rod
6	Off hand	On the other side of One Handed

RandomProperty

The number in this field points to item_enchantment_template.entry and ties in an item's chance at having a random property attached to it when it shows up for the first time. This field and the RandomSuffix field CANNOT both have non-zero values. Either one is filled, or the other. Also, the primary source for the number in this field are WDBs.

RandomSuffix

The number in this field points to item_enchantment_template.entry and ties in an item's chance at having a random suffix attached to it when it shows up for the first time. This field and the RandomProperty field CANNOT both have non-zero values. Either one is filled, or the other. Also, the primary source for the number in this field are WDBs.

block

If the item is a shield, the block chance of the shield.

itemset

The ID of the item set that this item belongs to. To save you some time, you CAN NOT make up new item sets. Item sets are defined in ItemSet.dbc

MaxDurability

The maximum durability of this item.

area

The zone ID that this item can be used in.

Map

The map ID that this item can be used in.

BagFamily

If the item is a bag, this field is a bitmask controlling what types of items can be put in this bag. You can combine different types by adding up the bit numbers.

ID	Bag Family Mask
0	None
1	Arrows
2	Bullets
4	Soul Shards
8	Leatherworking Supplies
16	Inscription Supplies
32	Herbs
64	Enchanting Supplies
128	Engineering Supplies
256	Keys
512	Gems
1024	Mining Supplies
2048	Soulbound Equipment
4096	Vanity Pets
8192	Currency Tokens
16384	Quest Items

TotemCategory

Corresponds to the ID in TotemCategory.dbc.

ID	Name
1	Skinning Knife (OLD)
2	Earth Totem
3	Air Totem
4	Fire Totem
5	Water Totem
6	Runed Copper Rod
7	Runed Silver Rod
8	Runed Golden Rod
9	Runed Truesilver Rod
10	Runed Arcanite Rod
11	Mining Pick (OLD)
12	Philosopher's Stone
13	Blacksmith Hammer (OLD)
14	Arclight Spanner
15	Gyromatic Micro-Adjustor
21	Master Totem
41	Runed Fel Iron Rod
62	Runed Adamantite Rod
63	Runed Eternium Rod
81	Hollow Quill
101	Runed Azurite Rod
121	Virtuoso Inking Set
141	Drums
161	Gnomish Army Knife
162	Blacksmith Hammer
165	Mining Pick
166	Skinning Knife
167	Hammer Pick
168	Bladed Pickaxe
169	Flint and Tinder
189	Runed Cobalt Rod
190	Runed Titanium Rod

socketColor

The color of the socket that can be placed in this item.

ID	Color
1	Meta
2	Red
4	Yellow
8	Blue

socketContent

Ammount of Gems of SocketColor1

socketBonus

commonly used socket bonus IDs

ID	Effect
3312	+8 Strength
3313	+8 Agility
3305	+12 Stamina
3353	+8 Intellect
2872	+9 Healing
3753	+9 Spell Power
3877	+16 Attack Power

GemProperties

The value here corresponds to the ID in GemProperties.dbc.

RequiredDisenchantSkill

The required proficiency in disenchanting that the player needs to have to be able to disenchant this item.

ArmorDamageModifier

field-no-description|76

duration

The duration of the item in seconds ingame time.
Set ITEM_FLAGS_CU_DURATION_REAL_TIME in flagsCustom for real time. In that case the item duration will tick even if player is offline.

ItemLimitCategory

field-no-description|78

HolidayId

See Holiday.dbc

ScriptName

The name of the script that the item should use. There is no 'internalitemhandler' or 'internalitemhanler' script so trinity will ignore any such values in this field.

DisenchantID

The disenchant loot template ID. See disenchant_loot_template.entry

FoodType

If this item is a food type item, this field defines what type of food it is for hunters who want to feed their pets. It controls in what diet this food item falls in.

NOTE: Raw meat and fish is not the same as regular meat and fish. It seems that the last two types of diets include grey "poor" types of food that players have no use for but some pets seem to be able to eat. Also, those food types appeared in TBC so most likely only TBC pets will have those types of diets.

ID	Type
1	Meat
2	Fish
3	Cheese
4	Bread
5	Fungus
6	Fruit
7	Raw Meat
8	Raw Fish

minMoneyLoot

If the item is a container that can contain money, then this field defines the minimum coinage held in this container, in copper.

maxMoneyLoot

If the item is a container that can contain money, then this field defines the maximum coinage held in this container, in copper.

flagsCustom

Flag	Name	Comment
1	ITEM_FLAGS_CU_DURATION_REAL_TIME	Item duration will tick even if player is offline
2	ITEM_FLAGS_CU_IGNORE_QUEST_STATUS	No quest status will be checked when this item drops
4	ITEM_FLAGS_CU_FOLLOW_LOOT_RULES	Item will always follow group/master/need before greed looting rules

VerifiedBuild

(WDBVerified) Set by TrinityCore developers.

TrinityCore : item_template