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.)
Field | Type | Attributes | Key | Null | Default | Comment |
mediumint(8) | unsigned | PRI | NO | 0 | ||
tinyint(3) | unsigned | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
tinyint(3) | signed | NO | -1 | |||
varchar(255) | signed | NO | NULL | |||
mediumint(8) | unsigned | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
bigint(20) | signed | NO | 0 | |||
int(10) | unsigned | NO | 0 | |||
tinyint(3) | unsigned | NO | 1 | |||
bigint(20) | signed | NO | 0 | |||
int(10) | unsigned | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
int(11) | signed | NO | -1 | |||
int(11) | signed | NO | -1 | |||
smallint(5) | unsigned | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
smallint(5) | unsigned | NO | 0 | |||
smallint(5) | unsigned | NO | 0 | |||
mediumint(8) | unsigned | NO | 0 | |||
mediumint(8) | unsigned | NO | 0 | |||
mediumint(8) | unsigned | NO | 0 | |||
smallint(5) | unsigned | NO | 0 | |||
smallint(5) | unsigned | NO | 0 | |||
int(11) | signed | NO | 0 | |||
int(11) | signed | NO | 1 | |||
smallint(5) | unsigned | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
smallint(6) | signed | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
smallint(6) | signed | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
smallint(6) | signed | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
smallint(6) | signed | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
smallint(6) | signed | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
smallint(6) | signed | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
smallint(6) | signed | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
smallint(6) | signed | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
smallint(6) | signed | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
smallint(6) | signed | NO | 0 | |||
smallint(6) | signed | NO | 0 | |||
int(6) | unsigned | NO | 0 | |||
float | signed | NO | 0 | |||
float | signed | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
float | signed | NO | 0 | |||
float | signed | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
smallint(5) | unsigned | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
smallint(5) | unsigned | NO | 1000 | |||
tinyint(3) | unsigned | NO | 0 | |||
float | signed | NO | 0 | |||
mediumint(8) | signed | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
smallint(6) | signed | NO | 0 | |||
float | signed | NO | 0 | |||
int(11) | signed | NO | -1 | |||
smallint(5) | unsigned | NO | 0 | |||
int(11) | signed | NO | -1 | |||
mediumint(8) | signed | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
smallint(6) | signed | NO | 0 | |||
float | signed | NO | 0 | |||
int(11) | signed | NO | -1 | |||
smallint(5) | unsigned | NO | 0 | |||
int(11) | signed | NO | -1 | |||
mediumint(8) | signed | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
smallint(6) | signed | NO | 0 | |||
float | signed | NO | 0 | |||
int(11) | signed | NO | -1 | |||
smallint(5) | unsigned | NO | 0 | |||
int(11) | signed | NO | -1 | |||
mediumint(8) | signed | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
smallint(6) | signed | NO | 0 | |||
float | signed | NO | 0 | |||
int(11) | signed | NO | -1 | |||
smallint(5) | unsigned | NO | 0 | |||
int(11) | signed | NO | -1 | |||
mediumint(8) | signed | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
smallint(6) | signed | NO | 0 | |||
float | signed | NO | 0 | |||
int(11) | signed | NO | -1 | |||
smallint(5) | unsigned | NO | 0 | |||
int(11) | signed | NO | -1 | |||
tinyint(3) | unsigned | NO | 0 | |||
varchar(255) | signed | NO | NULL | |||
mediumint(8) | unsigned | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
mediumint(8) | unsigned | NO | 0 | |||
mediumint(8) | unsigned | NO | 0 | |||
tinyint(4) | signed | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
mediumint(8) | signed | NO | 0 | |||
mediumint(8) | unsigned | NO | 0 | |||
mediumint(8) | unsigned | NO | 0 | |||
mediumint(8) | unsigned | NO | 0 | |||
smallint(5) | unsigned | NO | 0 | |||
mediumint(8) | unsigned | NO | 0 | |||
smallint(6) | signed | NO | 0 | |||
mediumint(9) | signed | NO | 0 | |||
mediumint(9) | signed | NO | 0 | |||
tinyint(4) | signed | NO | 0 | |||
mediumint(9) | signed | NO | 0 | |||
tinyint(4) | signed | NO | 0 | |||
mediumint(9) | signed | NO | 0 | |||
tinyint(4) | signed | NO | 0 | |||
mediumint(9) | signed | NO | 0 | |||
mediumint(9) | signed | NO | 0 | |||
mediumint(9) | signed | NO | 0 | |||
smallint(6) | signed | NO | -1 | |||
float | signed | NO | 0 | |||
int(10) | unsigned | NO | 0 | Duration in seconds | ||
smallint(6) | signed | NO | 0 | |||
int(11) | unsigned | NO | 0 | |||
varchar(64) | signed | NO | NULL | |||
mediumint(8) | unsigned | NO | 0 | |||
tinyint(3) | unsigned | NO | 0 | |||
int(10) | unsigned | NO | 0 | |||
int(10) | unsigned | NO | 0 | |||
int(10) | unsigned | NO | 0 | |||
smallint(5) | signed | YES | 1 |
entry
The unique ID of the item.
class
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 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 | ||
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 name of the item.
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. To use the Bind to Account quality, the item must have its flags set to 134221824.
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 | ITEM_FLAG_NO_PICKUP |
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: Cannot equip or use |
32 | 0x020 | Item can not be destroyed, except by using spell (item can be reagent for spell) |
64 | 0x040 | ITEM_FLAG_PLAYERCAST |
128 | 0x080 | No default 30 seconds cooldown when equipped |
256 | 0x0100 | ITEM_FLAG_MULTI_LOOT_QUEST |
512 | 0x0200 | Wrapper : Item can wrap other items |
1024 | 0x0400 | ITEM_FLAG_USES_RESOURCES |
2048 | 0x0800 | Item is party loot and can be looted by all - Looting this item does not remove it from available loot |
4096 | 0x01000 | Item is refundable - Item can be returned to vendor for its original cost (extended cost) |
8192 | 0x02000 | ITEM_FLAG_PETITION Charter (Arena or Guild) |
16384 | 0x04000 | ITEM_FLAG_HAS_TEXT // comment in code : Only readable items have this (but not all) |
32768 | 0x08000 | ITEM_FLAG_NO_DISENCHANT |
65536 | 0x010000 | ITEM_FLAG_REAL_DURATION |
131072 | 0x020000 | ITEM_FLAG_NO_CREATOR |
262144 | 0x040000 | Item can be prospected |
524288 | 0x080000 | Unique equipped (player can only have one equipped at the same time) |
1048576 | 0x0100000 | ITEM_FLAG_IGNORE_FOR_AURAS |
2097152 | 0x0200000 | Item can be used during arena match |
4194304 | 0x0400000 | ITEM_FLAG_NO_DURABILITY_LOSS |
8388608 | 0x0800000 | Item can be used in shapeshift forms |
16777216 | 0x01000000 | ITEM_FLAG_HAS_QUEST_GLOW |
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 ignoring reagents |
536870912 | 0x020000000 | Item can be milled |
1073741824 | 0x040000000 | ITEM_FLAG_REPORT_TO_GUILD_CHAT |
2147483648 | 0x080000000 | Bind on Pickup tradable ITEM_FLAG_NO_PROGRESSIVE_LOOT |
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.
See the ChrClasses DBC file for the IDs of the classes.
AllowableRace
Bitmask controlling which races can use this item. Add ids together to combine race possibilities. Use -1 for all races.
See the ChrRaces DBC file for the IDs of the races.
ItemLevel
Base item level.
RequiredLevel
The level that a player must be to equip the item.
RequiredSkill
The skill required to use this item. See the SkillLine DBC file for IDs which can be used here.
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 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.
See the Faction DBC file for the IDs of all of the factions.
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. See the SpellCategory.dbc file
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.
See the Languages DBC file for the IDs of all of the languages.
PageMaterial
The background texture that appears in the page text window.
See the PageTextMaterial DBC file for the IDs of all of the material types.
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 the Lock DBC file.
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 | Comment |
---|---|---|
-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. Press the 'Z' hotkey to sheath and unsheathe your weapons.
ID | Type | Position |
---|---|---|
1 | Two Handed Weapon | Diagonally across the back pointing downwards. |
2 | Staff | Diagonally across the back pointing upwards. |
3 | One Handed | On the left-hand side of the character's waist. |
4 | Shield | On the middle of the character's back. |
5 | Enchanter's Rod | |
6 | Off hand | On the right-hand side of the character's waist. |
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 the ItemSet DBC file.
MaxDurability
The maximum durability of this item.
area
The ID of the zone in which this item can be used.
Map
The ID of the map in which this item can be used.
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 the TotemCategory DBC file.
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
Amount 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 the Holidays DBC file for the IDs of all of the holidays.
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.