Github Discord Change this page

item_properties

This table contains most of the items information.

Structure

Field	Type	Default	Comment
entry	mediumint(8)	unsigned NOT NULL DEFAULT ‘0’	key
build	smallint(6)	12340	key
class	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
subclass	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
field4	int(11)	NOT NULL DEFAULT ‘-1’
name1	varchar(255)	NOT NULL DEFAULT
displayid	mediumint(8)	unsigned NOT NULL DEFAULT ‘0’
quality	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
flags	int(11)	unsigned NOT NULL DEFAULT ‘0’
flags2	int(11)	unsigned NOT NULL DEFAULT ‘0’
buyprice	int(10)	unsigned NOT NULL DEFAULT ‘0’
sellprice	int(10)	unsigned NOT NULL DEFAULT ‘0’
inventorytype	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
allowableclass	int(11)	NOT NULL DEFAULT ‘-1’
allowablerace	int(11)	NOT NULL DEFAULT ‘-1’
itemlevel	smallint(5)	unsigned NOT NULL DEFAULT ‘0’
requiredlevel	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
RequiredSkill	smallint(5)	unsigned NOT NULL DEFAULT ‘0’
RequiredSkillRank	smallint(5)	unsigned NOT NULL DEFAULT ‘0’
RequiredSpell	mediumint(8)	unsigned NOT NULL DEFAULT ‘0’
RequiredPlayerRank1	mediumint(8)	unsigned NOT NULL DEFAULT ‘0’
RequiredPlayerRank2	mediumint(8)	unsigned NOT NULL DEFAULT ‘0’
RequiredFaction	smallint(5)	unsigned NOT NULL DEFAULT ‘0’
RequiredFactionStanding	smallint(5)	unsigned NOT NULL DEFAULT ‘0’
Unique	int(11)	NOT NULL DEFAULT ‘1’
maxcount	int(11)	NOT NULL DEFAULT ‘0’
ContainerSlots	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
itemstatscount	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
stat_type1	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
stat_value1	smallint(6)	NOT NULL DEFAULT ‘0’
stat_type2	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
stat_value2	smallint(6)	NOT NULL DEFAULT ‘0’
stat_type3	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
stat_value3	smallint(6)	NOT NULL DEFAULT ‘0’
stat_type4	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
stat_value4	smallint(6)	NOT NULL DEFAULT ‘0’
stat_type5	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
stat_value5	smallint(6)	NOT NULL DEFAULT ‘0’
stat_type6	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
stat_value6	smallint(6)	NOT NULL DEFAULT ‘0’
stat_type7	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
stat_value7	smallint(6)	NOT NULL DEFAULT ‘0’
stat_type8	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
stat_value8	smallint(6)	NOT NULL DEFAULT ‘0’
stat_type9	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
stat_value9	smallint(6)	NOT NULL DEFAULT ‘0’
stat_type10	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
stat_value10	smallint(6)	NOT NULL DEFAULT ‘0’
ScaledStatsDistributionId	smallint(6)	NOT NULL DEFAULT ‘0’
ScaledStatsDistributionFlags	int(6)	unsigned NOT NULL DEFAULT ‘0’
dmg_min1	float	NOT NULL DEFAULT ‘0’
dmg_max1	float	NOT NULL DEFAULT ‘0’
dmg_type1	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
dmg_min2	float	NOT NULL DEFAULT ‘0’
dmg_max2	float	NOT NULL DEFAULT ‘0’
dmg_type2	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
armor	smallint(5)	unsigned NOT NULL DEFAULT ‘0’
holy_res	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
fire_res	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
nature_res	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
frost_res	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
shadow_res	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
arcane_res	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
delay	smallint(5)	unsigned NOT NULL DEFAULT ‘1000’
ammo_type	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
range	float	NOT NULL DEFAULT ‘0’
spellid_1	mediumint(8)	NOT NULL DEFAULT ‘0’
spelltrigger_1	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
spellcharges_1	smallint(4)	NOT NULL DEFAULT ‘0’
spellcooldown_1	int(11)	NOT NULL DEFAULT ‘-1’
spellcategory_1	smallint(5)	unsigned NOT NULL DEFAULT ‘0’
spellcategorycooldown_1	int(11)	NOT NULL DEFAULT ‘-1’
spellid_2	mediumint(8)	NOT NULL DEFAULT ‘0’
spelltrigger_2	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
spellcharges_2	smallint(4)	NOT NULL DEFAULT ‘0’
spellcooldown_2	int(11)	NOT NULL DEFAULT ‘-1’
spellcategory_2	smallint(5)	unsigned NOT NULL DEFAULT ‘0’
spellcategorycooldown_2	int(11)	NOT NULL DEFAULT ‘-1’
spellid_3	mediumint(8)	NOT NULL DEFAULT ‘0’
spelltrigger_3	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
spellcharges_3	smallint(4)	NOT NULL DEFAULT ‘0’
spellcooldown_3	int(11)	NOT NULL DEFAULT ‘-1’
spellcategory_3	smallint(5)	unsigned NOT NULL DEFAULT ‘0’
spellcategorycooldown_3	int(11)	NOT NULL DEFAULT ‘-1’
spellid_4	mediumint(8)	NOT NULL DEFAULT ‘0’
spelltrigger_4	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
spellcharges_4	smallint(4)	NOT NULL DEFAULT ‘0’
spellcooldown_4	int(11)	NOT NULL DEFAULT ‘-1’
spellcategory_4	smallint(5)	unsigned NOT NULL DEFAULT ‘0’
spellcategorycooldown_4	int(11)	NOT NULL DEFAULT ‘-1’
spellid_5	mediumint(8)	NOT NULL DEFAULT ‘0’
spelltrigger_5	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
spellcharges_5	smallint(4)	NOT NULL DEFAULT ‘0’
spellcooldown_5	int(11)	NOT NULL DEFAULT ‘-1’
spellcategory_5	smallint(5)	unsigned NOT NULL DEFAULT ‘0’
spellcategorycooldown_5	int(11)	NOT NULL DEFAULT ‘-1’
bonding	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
description	varchar(255)	NOT NULL DEFAULT
page_id	mediumint(8)	unsigned NOT NULL DEFAULT ‘0’
page_language	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
page_material	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
quest_id	mediumint(8)	unsigned NOT NULL DEFAULT ‘0’
lock_id	mediumint(8)	unsigned NOT NULL DEFAULT ‘0’
lock_material	tinyint(4)	NOT NULL DEFAULT ‘0’
sheathID	tinyint(3)	unsigned NOT NULL DEFAULT ‘0’
randomprop	mediumint(8)	NOT NULL DEFAULT ‘0’
randomsuffix	mediumint(8)	unsigned NOT NULL DEFAULT ‘0’
block	mediumint(8)	unsigned NOT NULL DEFAULT ‘0’
itemset	mediumint(8)	unsigned NOT NULL DEFAULT ‘0’
MaxDurability	smallint(5)	unsigned NOT NULL DEFAULT ‘0’
ZoneNameID	mediumint(8)	unsigned NOT NULL DEFAULT ‘0’
mapid	smallint(6)	NOT NULL DEFAULT ‘0’
bagfamily	mediumint(9)	NOT NULL DEFAULT ‘0’
TotemCategory	mediumint(9)	NOT NULL DEFAULT ‘0’
socket_color_1	tinyint(4)	NOT NULL DEFAULT ‘0’
unk201_3	mediumint(9)	NOT NULL DEFAULT ‘0’
socket_color_2	tinyint(4)	NOT NULL DEFAULT ‘0’
unk201_5	mediumint(9)	NOT NULL DEFAULT ‘0’
socket_color_3	tinyint(4)	NOT NULL DEFAULT ‘0’
unk201_7	mediumint(9)	NOT NULL DEFAULT ‘0’
socket_bonus	mediumint(9)	NOT NULL DEFAULT ‘0’
GemProperties	mediumint(9)	NOT NULL DEFAULT ‘0’
ReqDisenchantSkill	smallint(6)	NOT NULL DEFAULT ‘-1’
ArmorDamageModifier	float	NOT NULL DEFAULT ‘0’
existingduration	int(11)	NOT NULL DEFAULT ‘0’
ItemLimitCategoryId	smallint(6)	NOT NULL DEFAULT ‘0’
HolidayId	int(11)	unsigned NOT NULL DEFAULT ‘0’
food_type	smallint(1)	unsigned NOT NULL DEFAULT ‘0’

entry

The entry ID of the item.

build

Build number to determine if the data is for our current compiled version.

class

0  = Consumables
1  = Bags
2  = Weapons
3  = Gems
4  = Armor
5  = Reagent
6  = Projectiles
7  = Trade goods
8  = GENERIC
9  = Recipes, Patterns, Plans
10 = Marks of honor, badges, etc.
11 = Quiver and ammo pounches
12 = Questitems
13 = Keys
14 = Mount (PERMANENT)
15 = Miscellaneous
16 = Glyphs

subclass

Class = 0 => Consumables

0 = Consumable
1 = Potions
2 = Elixirs
3 = Flasks
4 = Scrolls
5 = Food & Drinks
6 = Item Enhancements
7 = Bandages
8 = Other

Class = 1 => Bags

1 = Soul Bag
2 = Herb Bag
3 = Enchanting Bag
4 = Engineering Bag
5 = Gem Bag
6 = Mining Bag
7 = Leatherworking Bag
8 = Inscription Bag

Class = 2 => Weapons

0 = Axe (1-handed)
1 = Axe (2-handed)
2 = Bow
3 = Gun
4 = Mace (1-handed)
5 = Mace (2-handed)
6 = Polearm
7 = Sword (1-handed)
8 = Sword (2-handed)
9 = UNKNOWN - not used
10 = Staff
11 = UNKNOWN - not used
12 = UNKNOWN - not used
13 = Fist Weapon
14 = Misc Weapon
15 = Dagger
16 = Thrown
17 = UNKNOWN Spear (Used only for Argent Tournament Lances) - not used
18 = Crossbow
19 = Wand
20 = Fishing Pole

Class = 3 => Gems

0 = Red
1 = Blue
2 = Yellow
3 = Purple
4 = Green
5 = Orange
6 = Meta
7 = Simple
8 = Prismatic

Class = 4 => Armor

 0 = Miscellaneous
 1 = Cloth
 2 = Leather
 3 = Mail
 4 = Plate
 5 = UNKNOWN
 6 = Shields
 7 = Librams
 8 = Idols
 9 = Totems
10 = Sigils

Class = 6 => Projectiles

    2 = Arrows
    3 = Bullets

Class = 7 => Trade goods

0 = Normal trade goods
1 = Projectile parts
2 = Projectile explosives
3 = Projectile devices

Class = 9 => Recipes, Patterns, Plans

0 = Recipe Book
1 = Leatherworking
2 = Tailoring
3 = Engineering
4 = Balacksmithing
5 = Cooking
6 = Alchemy
7 = First Aid
8 = Enchanting
9 = Fishing

Class = 11 => Quiver and ammo pounches

2 = Quiver
3 = Quiver Ammo Pounch

Class = 15 => Miscellaneous

0 = Junk
1 = Reagents        - not used
2 = non-combat pets - not used
3 = Holiday items   - not used
4 = Other           - not used
5 = Mounts          - not used

field4

Not used…

name1

The name of the item.

displayid

The display ID of the item.

quality

 0 = Poor
 1 = Common
 2 = Uncommon
 3 = Rare
 4 = Epic
 5 = Legendary
 6 = Artifact
 7 = Heirloom

flags

1          =    ITEM_FLAG_SOULBOUND        = 0x1,      // not used in proto
2          =    ITEM_FLAG_CONJURED         = 0x2,
4          =    ITEM_FLAG_LOOTABLE         = 0x4,
8          =    ITEM_FLAG_WRAPPED          = 0x8,      // not used in proto
16         =    ITEM_FLAG_BROKEN           = 0x10,     // many equipable items and bags
32         =    ITEM_FLAG_INDESTRUCTIBLE   = 0x20,     // can't destruct this item
64         =    ITEM_FLAG_UNKNOWN_07       = 0x40,     // many consumables
128        =    ITEM_FLAG_UNKNOWN_08       = 0x80,     // only 1 wand uses this
256        =    ITEM_FLAG_UNKNOWN_09       = 0x100,    // some wands & relics
512        =    ITEM_FLAG_WRAP_GIFT        = 0x200,
1024       =    ITEM_FLAG_CREATE_ITEM      = 0x400,    // probably worng
2048       =    ITEM_FLAG_FREE_FOR_ALL     = 0x800,    // can be looted ffa
4096       =    ITEM_FLAG_REFUNDABLE       = 0x1000,
8192       =    ITEM_FLAG_SIGNABLE         = 0x2000,   // charts
16384      =    ITEM_FLAG_READABLE         = 0x4000,   // may be worng
32768      =    ITEM_FLAG_UNKNOWN_16       = 0x8000,
65536      =    ITEM_FLAG_EVENT_REQ        = 0x10000,  // may be wrong
131072     =    ITEM_FLAG_UNKNOWN_18       = 0x20000,
262144     =    ITEM_FLAG_PROSPECTABLE     = 0x40000,
524288     =    ITEM_FLAG_UNIQUE_EQUIP     = 0x80000,
1048576    =    ITEM_FLAG_UNKNOWN_21       = 0x100000, // not used in proto
2097152    =    ITEM_FLAG_USEABLE_IN_ARENA = 0x200000, // useable in arenas
4194304    =    ITEM_FLAG_THROWN           = 0x400000,
8388608    =    ITEM_FLAG_SHAPESHIFT_OK    = 0x800000,
16777216   =    ITEM_FLAG_UNKNOWN_25       = 0x1000000,
33554432   =    ITEM_FLAG_UNKNOWN_26       = 0x2000000,
67108864   =    ITEM_FLAG_UNKNOWN_27       = 0x4000000,
134217728  =    ITEM_FLAG_ACCOUNTBOUND     = 0x8000000,
268435456  =    ITEM_FLAG_UNKNOWN_29       = 0x10000000,
536870912  =    ITEM_FLAG_MILLABLE         = 0x20000000,
1073741824 =    ITEM_FLAG_UNKNOWN_31       = 0x40000000,
2147483648 =    ITEM_FLAG_UNKNOWN_32       = 0x80000000

flags2

1   = Horde only
2   = Alliance only
4   = Ext. cost requires gold
256 = Need roll disabled

buyprice

The cost (in copper) if a character bought this item from a vendor.

sellprice

The money (in copper) a character get by selling it to a vendor.

inventorytype

0  = Non-Equip
1  = Head
2  = Neck
3  = Shoulders
4  = Body
5  = Chest
6  = Waist
7  = Legs
8  = Feet
9  = Wrists
10 = Hands
11 = Finger
12 = Trinket
13 = Weapon
14 = Shield
15 = Ranged
16 = Cloak
17 = Two-Hand Weapon
18 = Bag
19 = Tabard
20 = Robe
21 = Weapon-Main Hand
22 = Weapon-Off Hand
23 = Holdable
24 = Ammo
25 = Thrown
26 = Ranged(right)
27 = Quiver
28 = Relic

allowableclass

  -1 = Any Class
   1 = Warrior
   2 = Paladin
   4 = Hunter
   8 = Rogue
  16 = Priest
  32 = Deathknight
  64 = Shaman
 128 = Mage
 256 = Warlock
1024 = Druid

If you allow only two or three classes to use this item, simply add up the values.

allowablerace

  -1 = All races
   1 = Human
   2 = Orc
   3 = Dwarf
   4 = Nightelf
   5 = Undead
   6 = Tauren
   7 = Gnome
   8 = Troll
  10 = Bloodelf
  11 = Dranei 
 690 = All Horde races
1101 = All Alliance races

itemlevel

The value of the item level.

requiredlevel

The required level to use this item.

RequiredSkill

The required skill to use this item.

RequiredSkillRank

The required rank of the skill (defined in “RequiredSkill”) to use this item.

RequiredSpell

The required Spell ID to use this item.

RequiredPlayerRank1

…

RequiredPlayerRank2

…

RequiredFaction

The faction ID which is required.

RequiredFactionStanding

The required faction standing for the defined “RequiredFaction” ID.

For more information, take a look at playerreputations table. (Rows “factions” and “standing”)

Unique

0 = Normal (not unique, standard)
1 = Unique

maxcount

This defines the maximum stack count of this item in one slot.

ContainerSlots

Defines how many container slots the item (bag) brings with it. (Currently there are maximum 16 slots reserved for containers.)

itemstatscount

…

stat_type1_10

The type of stat of the item.

 0 = Power
 1 = Health
 2 = UNKNOWN - not used
 3 = Agility
 4 = Strength
 5 = Intellect
 6 = Spirit
 7 = Stamina
11 = Weapon skill rating
12 = Defense rating
13 = Dodge rating
14 = Parry rating
15 = Shield block rating
16 = Melee hit rating
17 = Ranged hit rating
18 = Spell hit rating
19 = Melee critical strike rating
20 = Ranged critical strike rating
21 = Spell critical strike rating
22 = Melee hit avoidance rating
23 = Ranged hit avoidance rating
24 = Spell hit avoidance rating
25 = Melee critical avoidance rating
26 = Ranged critical avoidance rating
27 = Spell critical avoidance rating
28 = Melee haste rating
29 = Ranged haste rating
30 = Spell haste rating
31 = Hit rating
32 = Critical strike rating
33 = Hit avoidance rating
34 = Critical avoidance rating
35 = Resilence rating
36 = Haste rating
37 = Expertise rating
38 = Attackpower
39 = Ranged attackpower
40 = Feral attackpower
41 = Spell healing done
42 = Spell damage done
43 = Mana regeneration
44 = Armor penetration rating
45 = Spell power
46 = Health regent
47 = Spell penetration 
48 = Block value

stat_value1_10

The value for the stat type.

(These values affect the characters stats by wearing this item).

ScaledStatsDistributionId

The scaling stat distribution ID (from .dbc).

ScaledStatsDistributionFlag

0 = Scaling stat stat? what?         - not used
1 = Scaling stat armor               - not used
2 = Scaling stat damage              - not used
3 = Scaling stat spell power         - not used

dmg_min_max_1_2

The minimum/maximum damage of a weapon.

dmg_type1_2

0 = Physical
1 = Holy
2 = Fire
3 = Nature
4 = Frost
5 = Shadow
6 = Arcane

armor

The armor value of the item.

holy-arcane_res

The resistance value against the attacking damage types.

delay

The time in milliseconds between the weapon hit a enemy (again).

ammo_type

The type ammunition the item use:

0 = no ammunition
1 = wand (shots)
2 = arrows (bows)
3 = bullets (pistoles)

range

The range in feets for a ranged weapon.

spellid_1_5

The spell ID on the item.

spelltrigger_1_5

The type how the spell triggers:

0 = On use
1 = On equip
2 = Chance on hit
4 = Soulstone
5 = No delay - not used
6 = Learn spell ID

spellcharges_1_5

The number of times the item can cast the spell.

0 = infinite charges

If the number of charges is a negative value, the item deletes itself.

spellcooldown_1_5

The cooldown for the spell in milliseconds. (If this value = -1, the normal cooldown of this spell is used)

spellcategory_1_5

The spellcategory of the spell.

spellcategorycooldown_(1-5)

The cooldown for the spellcategory in milliseconds. (If this value = -1, the normal cooldown of this spellcategory is used)

bonding

This field defines, how the item is bind to the character.

0 = None
1 = On pickup
2 = On equip
3 = On use
4 = Quest bound
5 = Quest bound (Is handled like type 4)

description

The item description at the bottom of tooltip.

page_id

The page ID from item_pages (Used for books etc.)

page_language

The page text language:

 0 = Universal (everybody can read)
 1 = Orcish
 2 = Darnassian
 3 = Taurahe
 6 = Dwarvish
 7 = Common
 8 = Demonic
 9 = Titan
10 = Thelassian
11 = Draconic
12 = Kalimag
13 = Gnomish
14 = Troll
33 = Gutterspeak
35 = Dranei

page_material

The material of the page:

1 = Parchment
2 = Stone
3 = Marble
4 = Silver
5 = Bronze
6 = Valentine
7 = Illidan

quest_id

The quest entry ID from quest_properties table to start the quest.

lock_id

The lock ID this item match (key to open a door) to field “Sound1” in gameobject_properties table.

lock_material

The type of material (controles the sound by moving this item)

-1 = Consumabels
 0 = Undefined
 1 = Metal
 2 = Wood
 3 = Liquid
 4 = Jewelry
 5 = Chain
 6 = Plate
 7 = Cloth
 8 = Leather

sheathID

The sheath type to controle the action by using “Z” hotkey:

1 = Weapon (two handed)
2 = Staff
3 = Weapon (one handed)
4 = Shield
5 = Enchanter's rod
6 = Weapon (off hand)

randomprop

This field defines the random property “group”. This field gets filles with the entry ID from item_randomprop_groups table.

NOTE!: It exists no item with a randomprop and randomsuffix value. Make shure that only one of these values links to an other table!

randomsuffix

This field defines the random suffix “group”. This field gets filles with the entry ID from item_randomsuffix_groups table.

NOTE!: It exists no item with a randomprop and randomsuffix value. Make shure that only one of these values links to an other table!

block

The value for the block (for shields…)

itemset

The ID of the itemset. Items can be grouped by this ID (They are added all by using “.add itemset "

> 0 A normal set
= 0 no set
< 0 is linked to an positive itemset.

itemset (Added in table itemset_linked_itemsetbonus to an positive itemsetid).

MaxDurability

Maximum durability on item (for equippable items)

ZoneNameID

The name ID of the Zone the item can be used in.

mapid

The map ID where the item can be used on.

bagfamily

    1 = Arrows (Quivers)
    2 = Bullets (Ammo pouches)
    4 = Soul Shards (Soul bags)
    8 = Leatherworking Supplies (Leatherworking supply bags)
   16 = Inscription supplies (Inscriber supply bags)
   32 = Herbalism supplies (Herbalism bags)
   64 = Enchanting Supplies (Enchanting bags)
  128 = Engineering Supplies (Tngineering toolboxes)
  256 = Keys (Keyring)
  512 = Jewelcrafting supplies (JC toolboxes)
 1024 = Mining Supplies (Mining toolboxes)
 2048 = Soulbound Equipment - not used
 4096 = Vanity Pets - not used
 8192 = Currency
16384 = Quest items

TotemCategory

  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

socket_color_1_3

1 = Meta socket
2 = Red socket
4 = Yellow socket
8 = Blue socket

unk201_3

Amount of Gems in Meta socket

unk201_5

…

unk201_7

…

socket_bonus

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 gem properties ID from .dbc.

ReqDisenchantSkill

The required disenchanting skill level…

ArmorDamageModifier

…

existingduration

Item duration in seconds.

ItemLimitCategoryId

The item limit category ID from .dbc. defines the maximum amount of this item category.

HollidayId

The holliday name ID (points to HolidayNames.dbc)

food_type

The food type itself.

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