NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. |
Description of the 'item_template' table for MaNGOSThree
Holds information on every item that exists in the game. All items are created from their template stored in this table.
Table Notes
This table uses the 'MyISAM' DB Engine
The Field definitions follow:
Field Name | Field Type | Nullable | Key | Default Value | Attributes | Notes |
---|---|---|---|---|---|---|
entry | mediumint(8) unsigned | NO | PRI | '0' | Item prototype ID. | |
class | tinyint(3) unsigned | NO | MUL | '0' | Class of the item. | |
subclass | tinyint(3) unsigned | NO | '0' | The subclass of the item template. | ||
unk0 | int(11) | NO | '-1' | |||
name | varchar(255) | NO | {Blank String} | Item name. | ||
displayid | mediumint(8) unsigned | NO | '0' | A display model identifier for the Item. | ||
Quality | tinyint(3) unsigned | NO | '0' | Quality of item. | ||
Flags | int(10) unsigned | NO | '0' | Item prototype flags. | ||
Flags2 | int(10) unsigned | NO | '0' | |||
Unknown | float | NO | NULL | |||
Unknown1 | float | NO | NULL | |||
Unknown2 | int(10) | NO | NULL | |||
BuyCount | tinyint(3) unsigned | NO | '1' | Stack size by vendors. | ||
BuyPrice | int(10) unsigned | NO | '0' | Item buying price (coppers). | ||
SellPrice | int(10) unsigned | NO | '0' | Item selling price (coppers). | ||
InventoryType | tinyint(3) unsigned | NO | '0' | Inventory type. | ||
AllowableClass | mediumint(9) | NO | '-1' | Mask of allowed classes. | ||
AllowableRace | mediumint(9) | NO | '-1' | Mask of allowed races. | ||
ItemLevel | smallint(5) unsigned | NO | '0' | Level of item. | ||
RequiredLevel | tinyint(3) unsigned | NO | '0' | Required level. | ||
RequiredSkill | smallint(5) unsigned | NO | '0' | Required skill type. | ||
RequiredSkillRank | smallint(5) unsigned | NO | '0' | Required skill value. | ||
requiredspell | mediumint(8) unsigned | NO | '0' | Required spell [See Spell.dbc]. | ||
requiredhonorrank | mediumint(8) unsigned | NO | '0' | Required honor rank. | ||
RequiredCityRank | mediumint(8) unsigned | NO | '0' | DEPRECATED: the city rank required. City ranks did not make it into WoW. | ||
RequiredReputationFaction | smallint(5) unsigned | NO | '0' | Required faction for reputation check [See Faction.dbc]. | ||
RequiredReputationRank | smallint(5) unsigned | NO | '0' | Required minimal reputation rank. | ||
maxcount | smallint(5) | NO | '-1' | The maximum amount of copies of the item that a character may have. | ||
stackable | smallint(5) | NO | '1' | Maximum stack size. | ||
ContainerSlots | tinyint(3) unsigned | NO | '0' | Defines the amount of slots for items of type container or ammunition container. | ||
stat_type1 | tinyint(3) unsigned | NO | '0' | An item modifier to apply for this item. | ||
stat_value1 | smallint(6) | NO | '0' | The value to add for the matching modifier. | ||
stat_unk1_1 | int(10) | NO | '0' | |||
stat_unk2_1 | int(10) | NO | '0' | |||
stat_type2 | tinyint(3) unsigned | NO | '0' | An item modifier to apply for this item. | ||
stat_value2 | smallint(6) | NO | '0' | The value to add for the matching modifier. | ||
stat_unk1_2 | int(10) | NO | '0' | |||
stat_unk2_2 | int(10) | NO | '0' | |||
stat_type3 | tinyint(3) unsigned | NO | '0' | An item modifier to apply for this item. | ||
stat_value3 | smallint(6) | NO | '0' | The value to add for the matching modifier. | ||
stat_unk1_3 | int(10) | NO | '0' | |||
stat_unk2_3 | int(10) | NO | '0' | |||
stat_type4 | tinyint(3) unsigned | NO | '0' | An item modifier to apply for this item. | ||
stat_value4 | smallint(6) | NO | '0' | The value to add for the matching modifier. | ||
stat_unk1_4 | int(10) | NO | '0' | |||
stat_unk2_4 | int(10) | NO | '0' | |||
stat_type5 | tinyint(3) unsigned | NO | '0' | An item modifier to apply for this item. | ||
stat_value5 | smallint(6) | NO | '0' | The value to add for the matching modifier. | ||
stat_unk1_5 | int(10) | NO | '0' | |||
stat_unk2_5 | int(10) | NO | '0' | |||
stat_type6 | tinyint(3) unsigned | NO | '0' | An item modifier to apply for this item. | ||
stat_value6 | smallint(6) | NO | '0' | The value to add for the matching modifier. | ||
stat_unk1_6 | int(10) | NO | '0' | |||
stat_unk2_6 | int(10) | NO | '0' | |||
stat_type7 | tinyint(3) unsigned | NO | '0' | An item modifier to apply for this item. | ||
stat_value7 | smallint(6) | NO | '0' | The value to add for the matching modifier. | ||
stat_unk1_7 | int(10) | NO | '0' | |||
stat_unk2_7 | int(10) | NO | '0' | |||
stat_type8 | tinyint(3) unsigned | NO | '0' | An item modifier to apply for this item. | ||
stat_value8 | smallint(6) | NO | '0' | The value to add for the matching modifier. | ||
stat_unk1_8 | int(10) | NO | '0' | |||
stat_unk2_8 | int(10) | NO | '0' | |||
stat_type9 | tinyint(3) unsigned | NO | '0' | An item modifier to apply for this item. | ||
stat_value9 | smallint(6) | NO | '0' | The value to add for the matching modifier. | ||
stat_unk1_9 | int(10) | NO | '0' | |||
stat_unk2_9 | int(10) | NO | '0' | |||
stat_type10 | tinyint(3) unsigned | NO | '0' | An item modifier to apply for this item. | ||
stat_value10 | smallint(6) | NO | '0' | The value to add for the matching modifier. | ||
stat_unk1_10 | int(10) | NO | '0' | |||
stat_unk2_10 | int(10) | NO | '0' | |||
ScalingStatDistribution | smallint(6) | NO | '0' | |||
DamageType | tinyint(3) unsigned | NO | '0' | |||
delay | int(10) | NO | NULL | The delay in milliseconds between successive hits for the item. | ||
RangedModRange | float | NO | '0' | |||
spellid_1 | mediumint(8) unsigned | NO | '0' | If the item can cast or trigger a spell, this is the reference. | ||
spelltrigger_1 | tinyint(3) unsigned | NO | '0' | The type of trigger for the matching spellid entry. | ||
spellcharges_1 | smallint(5) | NO | '0' | The amount of charges for the spell referenced in the matching spellid entry. | ||
spellppmRate_1 | float | NO | '0' | This controls the proc per minute rate for a spell. | ||
spellcooldown_1 | int(11) | NO | '-1' | The cooldown in milliseconds for the matching spell. | ||
spellcategory_1 | smallint(5) unsigned | NO | '0' | A spell category identifier. | ||
spellcategorycooldown_1 | int(11) | NO | '-1' | The cooldown in milliseconds for the matching spell category. | ||
spellid_2 | mediumint(8) unsigned | NO | '0' | If the item can cast or trigger a spell, this is the references. | ||
spelltrigger_2 | tinyint(3) unsigned | NO | '0' | The type of trigger for the matching spellid entry. | ||
spellcharges_2 | smallint(5) | NO | '0' | The amount of charges for the spell referenced in the matching spellid entry. | ||
spellppmRate_2 | float | NO | '0' | This controls the proc per minute rate for a spell. | ||
spellcooldown_2 | int(11) | NO | '-1' | The cooldown in milliseconds for the matching spell. | ||
spellcategory_2 | smallint(5) unsigned | NO | '0' | A spell category identifier. | ||
spellcategorycooldown_2 | int(11) | NO | '-1' | The cooldown in milliseconds for the matching spell category. | ||
spellid_3 | mediumint(8) unsigned | NO | '0' | If the item can cast or trigger a spell, this is the references. | ||
spelltrigger_3 | tinyint(3) unsigned | NO | '0' | The type of trigger for the matching spellid entry. | ||
spellcharges_3 | smallint(5) | NO | '0' | The amount of charges for the spell referenced in the matching spellid entry. | ||
spellppmRate_3 | float | NO | '0' | This controls the proc per minute rate for a spell. | ||
spellcooldown_3 | int(11) | NO | '-1' | The cooldown in milliseconds for the matching spell. | ||
spellcategory_3 | smallint(5) unsigned | NO | '0' | A spell category identifier. | ||
spellcategorycooldown_3 | int(11) | NO | '-1' | The cooldown in milliseconds for the matching spell category. | ||
spellid_4 | mediumint(8) unsigned | NO | '0' | If the item can cast or trigger a spell, this is the references. | ||
spelltrigger_4 | tinyint(3) unsigned | NO | '0' | The type of trigger for the matching spellid entry. | ||
spellcharges_4 | smallint(5) | NO | '0' | The amount of charges for the spell referenced in the matching spellid entry. | ||
spellppmRate_4 | float | NO | '0' | This controls the proc per minute rate for a spell. | ||
spellcooldown_4 | int(11) | NO | '-1' | The cooldown in milliseconds for the matching spell. | ||
spellcategory_4 | smallint(5) unsigned | NO | '0' | A spell category identifier. | ||
spellcategorycooldown_4 | int(11) | NO | '-1' | The cooldown in milliseconds for the matching spell category. | ||
spellid_5 | mediumint(8) unsigned | NO | '0' | If the item can cast or trigger a spell, this is the references. | ||
spelltrigger_5 | tinyint(3) unsigned | NO | '0' | The type of trigger for the matching spellid entry. | ||
spellcharges_5 | smallint(5) | NO | '0' | The amount of charges for the spell referenced in the matching spellid entry. | ||
spellppmRate_5 | float | NO | '0' | This controls the proc per minute rate for a spell. | ||
spellcooldown_5 | int(11) | NO | '-1' | The cooldown in milliseconds for the matching spell. | ||
spellcategory_5 | smallint(5) unsigned | NO | '0' | A spell category identifier. | ||
spellcategorycooldown_5 | int(11) | NO | '-1' | The cooldown in milliseconds for the matching spell category. | ||
bonding | tinyint(3) unsigned | NO | '0' | Defines if and how and item will be bound to a character. | ||
description | varchar(255) | NO | {Blank String} | A short - usually one sentence - description of the item. Mostly flavor texts. | ||
PageText | mediumint(8) unsigned | NO | '0' | If the item should be readable, e.g. for letters. | ||
LanguageID | tinyint(3) unsigned | NO | '0' | The material to be used as background for items with page texts set. | ||
PageMaterial | tinyint(3) unsigned | NO | '0' | The material to be used as background for items with page texts set. | ||
startquest | mediumint(8) unsigned | NO | '0' | Quest ID [See quest_template.entry]. | ||
lockid | mediumint(8) unsigned | NO | '0' | Lock ID [See Lock.dbc]. | ||
Material | tinyint(4) | NO | '0' | Material type. | ||
sheath | tinyint(3) unsigned | NO | '0' | The value of this field controls how characters will show or hide items worn, e. | ||
RandomProperty | mediumint(8) unsigned | NO | '0' | Random property type [See item_enchantment_template.entry]. | ||
RandomSuffix | mediumint(8) unsigned | NO | '0' | |||
itemset | mediumint(8) unsigned | NO | '0' | If an item is part of an item set, this references the item set's identifier. | ||
MaxDurability | smallint(5) unsigned | NO | '0' | The maximum durability for an item. | ||
area | mediumint(8) unsigned | NO | '0' | If an item is only usable on a specific map, this is the reference. | ||
Map | smallint(6) | NO | '0' | If an item is only usable on a specific map, this is the reference. | ||
BagFamily | mediumint(9) | NO | '0' | If an item is a bag, this holds a bit-mask corresponding to bag families to whic | ||
TotemCategory | mediumint(9) | NO | '0' | |||
socketColor_1 | tinyint(4) | NO | '0' | |||
socketContent_1 | mediumint(9) | NO | '0' | |||
socketColor_2 | tinyint(4) | NO | '0' | |||
socketContent_2 | mediumint(9) | NO | '0' | |||
socketColor_3 | tinyint(4) | NO | '0' | |||
socketContent_3 | mediumint(9) | NO | '0' | |||
socketBonus | mediumint(9) | NO | '0' | |||
GemProperties | mediumint(9) | NO | '0' | |||
RequiredDisenchantSkill | smallint(6) | NO | '-1' | |||
ArmorDamageModifier | float | NO | '0' | |||
Duration | int(11) unsigned | NO | '0' | Items may have a duration set until the get removed from a character's inventory | ||
ItemLimitCategory | smallint(6) | NO | '0' | |||
HolidayId | int(11) unsigned | NO | '0' | |||
DisenchantID | mediumint(8) unsigned | NO | '0' | Disenchant template [See disenchant_loot_template.entry]. | ||
FoodType | tinyint(3) unsigned | NO | '0' | If an item is usable as pet food, this table is the reference. | ||
StatScalingFactor | float | NO | NULL | |||
Unknown400_1 | int(10) unsigned | NO | '0' | |||
Unknown400_2 | int(10) unsigned | NO | '0' | |||
minMoneyLoot | int(10) unsigned | NO | '0' | This field specifies the minimum amount in a container holding money. | ||
maxMoneyLoot | int(10) unsigned | NO | '0' | This field specifies the maximum amount in a container holding money. | ||
ExtraFlags | tinyint(1) unsigned | NO | '0' | With these flags it is possible to set rare conditions on an item. |
Description of the fields
entry mediumint(8) unsigned
Item prototype ID. Note: do not mix it with the item GUID, which numbers concrete item instances.
class tinyint(3) unsigned
Class of the item is it very general description.
ID | Name |
---|---|
0 | Consumable |
1 | Container |
2 | Weapon |
4 | Armor |
5 | Reagent |
6 | Projectile |
7 | Trade Goods |
9 | Recipe |
11 | Quiver |
12 | Quest |
13 | Key |
15 | Miscellaneous |
Note:
The table only contains active classes, obsolete classes have been stripped.
subclass tinyint(3) unsigned
The subclass of the item template.
Class ID | Subclass ID | Subclass |
---|---|---|
0 | 0 | Consumable |
1 | 0 | Container, Bag |
1 | 1 | Container, Soul bag |
1 | 2 | Container, Herb bag |
1 | 3 | Container, Enchanting bag |
1 | 4 | Container, Engineering bag |
2 | 0 | Weapon, Axe 1H |
2 | 1 | Weapon, Axe 2H |
2 | 2 | Weapon, Bow |
2 | 3 | Weapon, Gun |
2 | 4 | Weapon, Mace 1H |
2 | 5 | Weapon, Mace 2H |
2 | 6 | Weapon, Polearm |
2 | 7 | Weapon, Sword 1H |
2 | 8 | Weapon, Sword 2H |
2 | 10 | Weapon, Staff |
2 | 13 | Weapon, Fist weapon |
2 | 14 | Weapon, Miscellaneous |
2 | 15 | Weapon, Dagger |
2 | 16 | Weapon, Thrown |
2 | 17 | Weapon, Spear |
2 | 18 | Weapon, Crossbow |
2 | 19 | Weapon, Wand |
2 | 20 | Weapon, Fishing pole |
4 | 0 | Armor, Miscellaneous |
4 | 1 | Armor, Cloth |
4 | 2 | Armor, Leather |
4 | 3 | Armor, Mail |
4 | 4 | Armor, Plate |
4 | 6 | Armor, Shield |
4 | 7 | Armor, Libram |
4 | 8 | Armor, Idol |
4 | 9 | Armor, Totem |
5 | 0 | Reagent |
6 | 2 | Projectile, Arrow |
6 | 3 | Projectile, Bullet |
7 | 0 | Trade goods, Trade goods |
7 | 1 | Trade goods, Parts |
7 | 2 | Trade goods, Explosives |
7 | 3 | Trade goods, Devices |
9 | 0 | Recipe, Book |
9 | 1 | Recipe, Leatherworking |
9 | 2 | Recipe, Tailoring |
9 | 3 | Recipe, Engineering |
9 | 4 | Recipe, Blacksmithing |
9 | 5 | Recipe, Cooking |
9 | 6 | Recipe, Alchemy |
9 | 7 | Recipe, First aid |
9 | 8 | Recipe, Enchanting |
9 | 9 | Recipe, Fishing |
11 | 2 | Quiver |
11 | 3 | Ammo pouch |
12 | 0 | Quest |
13 | 0 | Key |
13 | 1 | Lockpick |
15 | 0 | Miscellaneous, Junk |
Note:
The table only contains active subclasses, obsolete classes have been stripped.
unk0 int(11)
name varchar(255)
Name of item displayed to the players. See locales_item table for localized versions of this.
displayid mediumint(8) unsigned
A display model identifier for the Item. This references an DisplayInfo entry [See itemDisplayInfo.dbc].
Quality tinyint(3) unsigned
The quality of the item.
ID | Color | Quality |
---|---|---|
0 | Grey | Poor |
1 | White | Common |
2 | Green | Uncommon |
3 | Blue | Rare |
4 | Purple | Epic |
5 | Orange | Legendary |
6 | Red | Artifact |
Flags int(10) unsigned
Item prototype flags, see enum ItemPrototypeFlags in ItemPrototype.h.
Name | Value (hex) | Meaning |
---|---|---|
ITEM_FLAG_RESERVED_0 | 0x00000001 | Reserved for later usage |
ITEM_FLAG_CONJURED | 0x00000002 | items created by spells with SPELL_EFFECT_CREATE_ITEM |
ITEM_FLAG_LOOTABLE | 0x00000004 | affect only non container items that can be "open" for loot. It or lockid set enable for client show "Right click to open". See also ITEM_DYNFLAG_UNLOCKED |
ITEM_FLAG_WRAPPED | 0x00000008 | not used in pre-3.x |
ITEM_FLAG_DEPRECATED | 0x00000010 | items is deprecated and no longer equipable |
ITEM_FLAG_INDESTRUCTIBLE | 0x00000020 | used for totem. Item can not be destroyed, except by using spell (item can be reagent for spell and then allowed) |
ITEM_FLAG_USABLE | 0x00000040 | items that can be used via right-click |
ITEM_FLAG_NO_EQUIP_COOLDOWN | 0x00000080 | items without an equip cooldown (and usually a _USABLE flag) |
ITEM_FLAG_RESERVED_1 | 0x00000100 | reserved for later usage |
ITEM_FLAG_WRAPPER | 0x00000200 | used or not used wrapper |
ITEM_FLAG_STACKABLE | 0x00000400 | items which can be stacked |
ITEM_FLAG_PARTY_LOOT | 0x00000800 | items which can be looted by all party members |
ITEM_FLAG_RESEVERD_2 | 0x00001000 | reserved for later usage |
ITEM_FLAG_CHARTER | 0x00002000 | guild charter |
ITEM_FLAG_LETTER | 0x00004000 | readable letter items |
ITEM_FLAG_PVP_REWARD | 0x00008000 | items rewarded for PvP ranks and/or honor standing |
ITEM_FLAG_UNK16 | 0x00010000 | a lot of items have this |
ITEM_FLAG_UNK17 | 0x00020000 | last used flag in 1.12.1 |
Flags2 int(10) unsigned
Unknown float
Unknown1 float
Unknown2 int(10)
BuyCount tinyint(3) unsigned
If an item is sold in stacks, the holds the number of items in a stack
Note:
If an item has limited supplies, the item is refresh to this count.
BuyPrice int(10) unsigned
Price in coppers for players to buy the item.
SellPrice int(10) unsigned
Price in coppers for players to sell the item.
InventoryType tinyint(3) unsigned
Type of inventory defining the way of wearing the item.
Value | Slot name |
---|---|
0 | Not equipable |
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 | 2H weapon |
18 | Bag |
19 | Tabard |
20 | Robe |
21 | Weapon, main hand |
22 | Weapon, offhand |
23 | Holdable |
24 | Ammo |
25 | Thrown |
26 | Ranged, right |
27 | Quiver |
28 | Relic |
AllowableClass mediumint(9)
A bit-mask corresponding to class that should be able to use the item. The value has to match with classes defined in ChrClasses.dbc.
Class | Value (hex) | Value (dec) |
---|---|---|
CLASS_WARRIOR | 0x1 | 1 |
CLASS_PALADIN | 0x2 | 2 |
CLASS_HUNTER | 0x4 | 4 |
CLASS_ROGUE | 0x8 | 8 |
CLASS_PRIEST | 0x10 | 16 |
CLASS_DEATHKNIGHT | 0x20 | 32 |
CLASS_SHAMAN | 0x40 | 64 |
CLASS_MAGE | 0x80 | 128 |
CLASS_WARLOCK | 0x100 | 256 |
CLASS_DRUID | 0x400 | 1024 |
Note:
Set to -1 to allow usage by all classes.
AllowableRace mediumint(9)
A bit-mask corresponding to races that should be able to use the item. The value has to match with races defined in ChrRaces.dbc.
Race | Mask Value (hex) | Mask Value (dec) |
---|---|---|
Human | 0x1 | 1 |
Orc | 0x2 | 2 |
Dwarf | 0x4 | 4 |
Night Elf | 0x8 | 8 |
Undead | 0x10 | 16 |
Tauren | 0x20 | 32 |
Gnome | 0x40 | 64 |
Troll | 0x80 | 128 |
Goblin | 0x100 | 256 |
Blood Elf | 0x200 | 512 |
Dranei | 0x400 | 1024 |
Note:
Set to -1 to allow usage by all races.
ItemLevel smallint(5) unsigned
Level of item. Used by addons in calculating Gear Level.
RequiredLevel tinyint(3) unsigned
Minimum level required to use the item.
RequiredSkill smallint(5) unsigned
Skill type required to use the item, see SpellLine.dbc and enum SkillType in SharedDefines.h.
Skill name | Value |
---|---|
SKILL_FROST | 6 |
SKILL_FIRE | 8 |
SKILL_ARMS | 26 |
SKILL_COMBAT | 38 |
SKILL_SUBTLETY | 39 |
SKILL_POISONS | 40 |
SKILL_SWORDS | 43 |
SKILL_AXES | 44 |
SKILL_BOWS | 45 |
SKILL_GUNS | 46 |
SKILL_BEAST_MASTERY | 50 |
SKILL_SURVIVAL | 51 |
SKILL_MACES | 54 |
SKILL_2H_SWORDS | 55 |
SKILL_HOLY | 56 |
SKILL_SHADOW | 78 |
SKILL_DEFENSE | 95 |
SKILL_LANG_COMMON | 98 |
SKILL_RACIAL_DWARVEN | 101 |
SKILL_LANG_ORCISH | 109 |
SKILL_LANG_DWARVEN | 111 |
SKILL_LANG_DARNASSIAN | 113 |
SKILL_LANG_TAURAHE | 115 |
SKILL_DUAL_WIELD | 118 |
SKILL_RACIAL_TAUREN | 124 |
SKILL_ORC_RACIAL | 125 |
SKILL_RACIAL_NIGHT_ELF | 126 |
SKILL_FIRST_AID | 129 |
SKILL_FERAL_COMBAT | 134 |
SKILL_STAVES | 136 |
SKILL_LANG_THALASSIAN | 137 |
SKILL_LANG_DRACONIC | 138 |
SKILL_LANG_DEMON_TONGUE | 139 |
SKILL_LANG_TITAN | 140 |
SKILL_LANG_OLD_TONGUE | 141 |
SKILL_SURVIVAL2 | 142 |
SKILL_RIDING_HORSE | 148 |
SKILL_RIDING_WOLF | 149 |
SKILL_RIDING_TIGER | 150 |
SKILL_RIDING_RAM | 152 |
SKILL_SWIMING | 155 |
SKILL_2H_MACES | 160 |
SKILL_UNARMED | 162 |
SKILL_MARKSMANSHIP | 163 |
SKILL_BLACKSMITHING | 164 |
SKILL_LEATHERWORKING | 165 |
SKILL_ALCHEMY | 171 |
SKILL_2H_AXES | 172 |
SKILL_DAGGERS | 173 |
SKILL_THROWN | 176 |
SKILL_HERBALISM | 182 |
SKILL_GENERIC_DND | 183 |
SKILL_RETRIBUTION | 184 |
SKILL_COOKING | 185 |
SKILL_MINING | 186 |
SKILL_PET_IMP | 188 |
SKILL_PET_FELHUNTER | 189 |
SKILL_TAILORING | 197 |
SKILL_ENGINEERING | 202 |
SKILL_PET_SPIDER | 203 |
SKILL_PET_VOIDWALKER | 204 |
SKILL_PET_SUCCUBUS | 205 |
SKILL_PET_INFERNAL | 206 |
SKILL_PET_DOOMGUARD | 207 |
SKILL_PET_WOLF | 208 |
SKILL_PET_CAT | 209 |
SKILL_PET_BEAR | 210 |
SKILL_PET_BOAR | 211 |
SKILL_PET_CROCILISK | 212 |
SKILL_PET_CARRION_BIRD | 213 |
SKILL_PET_CRAB | 214 |
SKILL_PET_GORILLA | 215 |
SKILL_PET_RAPTOR | 217 |
SKILL_PET_TALLSTRIDER | 218 |
SKILL_RACIAL_UNDED | 220 |
SKILL_CROSSBOWS | 226 |
SKILL_WANDS | 228 |
SKILL_POLEARMS | 229 |
SKILL_PET_SCORPID | 236 |
SKILL_ARCANE | 237 |
SKILL_PET_TURTLE | 251 |
SKILL_ASSASSINATION | 253 |
SKILL_FURY | 256 |
SKILL_PROTECTION | 257 |
SKILL_BEAST_TRAINING | 261 |
SKILL_PROTECTION2 | 267 |
SKILL_PET_TALENTS | 270 |
SKILL_PLATE_MAIL | 293 |
SKILL_LANG_GNOMISH | 313 |
SKILL_LANG_TROLL | 315 |
SKILL_ENCHANTING | 333 |
SKILL_DEMONOLOGY | 354 |
SKILL_AFFLICTION | 355 |
SKILL_FISHING | 356 |
SKILL_ENHANCEMENT | 373 |
SKILL_RESTORATION | 374 |
SKILL_ELEMENTAL_COMBAT | 375 |
SKILL_SKINNING | 393 |
SKILL_MAIL | 413 |
SKILL_LEATHER | 414 |
SKILL_CLOTH | 415 |
SKILL_SHIELD | 433 |
SKILL_FIST_WEAPONS | 473 |
SKILL_RIDING_RAPTOR | 533 |
SKILL_RIDING_MECHANOSTRIDER | 553 |
SKILL_RIDING_UNDEAD_HORSE | 554 |
SKILL_RESTORATION2 | 573 |
SKILL_BALANCE | 574 |
SKILL_DESTRUCTION | 593 |
SKILL_HOLY2 | 594 |
SKILL_DISCIPLINE | 613 |
SKILL_LOCKPICKING | 633 |
SKILL_PET_BAT | 653 |
SKILL_PET_HYENA | 654 |
SKILL_PET_OWL | 655 |
SKILL_PET_WIND_SERPENT | 656 |
SKILL_LANG_GUTTERSPEAK | 673 |
SKILL_RIDING_KODO | 713 |
SKILL_RACIAL_TROLL | 733 |
SKILL_RACIAL_GNOME | 753 |
SKILL_RACIAL_HUMAN | 754 |
SKILL_PET_EVENT_RC | 758 |
SKILL_RIDING | 762 |
RequiredSkillRank smallint(5) unsigned
Value of the skill required to use the item.
Value | Required rank | Horde rank | Officer rank |
---|---|---|---|
0 | Unranked | Unranked | No |
5 | Private | Scout | No |
6 | Corporal | Grunt | No |
7 | Sergeant | Sergeant | No |
8 | Master Sergeant | Senior Sergeant | No |
9 | Sergeant Major | First Sergeant | No |
10 | Knight | Stone Guard | Yes |
11 | Knight-Lieutenant | Blood Guard | Yes |
12 | Knight-Captain | Legionnaire | Yes |
13 | Knight-Champion | Centurion | Yes |
14 | Lieutenant-Commander | Champion | Yes |
15 | Commander | Lieutenant General | Yes |
16 | Marshal | General | Yes |
17 | Field Marshal | Warlord | Yes |
18 | Grand Marshal | High Warlord | Yes |
requiredspell mediumint(8) unsigned
The spell ID the character is required to know before using the item.
requiredhonorrank mediumint(8) unsigned
Required honor rank.
Value | Required rank | Horde rank | Officer rank |
---|---|---|---|
0 | Unranked | Unranked | No |
5 | Private | Scout | No |
6 | Corporal | Grunt | No |
7 | Sergeant | Sergeant | No |
8 | Master Sergeant | Senior Sergeant | No |
9 | Sergeant Major | First Sergeant | No |
10 | Knight | Stone Guard | Yes |
11 | Knight-Lieutenant | Blood Guard | Yes |
12 | Knight-Captain | Legionnaire | Yes |
13 | Knight-Champion | Centurion | Yes |
14 | Lieutenant-Commander | Champion | Yes |
15 | Commander | Lieutenant General | Yes |
16 | Marshal | General | Yes |
17 | Field Marshal | Warlord | Yes |
18 | Grand Marshal | High Warlord | Yes |
RequiredCityRank mediumint(8) unsigned
DEPRECATED: the city rank required. City ranks did not make it into WoW.
RequiredReputationFaction smallint(5) unsigned
The faction [See faction,dbc], reputation to which will be checked before using the item.
RequiredReputationRank smallint(5) unsigned
The minimal reputation rank required to use the item.
Name | Value |
---|---|
REP_HATED | 0 |
REP_HOSTILE | 1 |
REP_UNFRIENDLY | 2 |
REP_NEUTRAL | 3 |
REP_FRIENDLY | 4 |
REP_HONORED | 5 |
REP_REVERED | 6 |
REP_EXALTED | 7 |
maxcount smallint(5)
The maximum amount of copies of the item that a character may have. Setting this to 0 will allow an infinite amount.
stackable smallint(5)
Maximum number of items in the single stack.
ContainerSlots tinyint(3) unsigned
Defines the amount of slots for items of type container or ammunition container.
stat_type1 tinyint(3) unsigned
An item modifier to apply for this item.
Value | Description |
---|---|
0 | No stats |
1 | Health |
3 | Agility |
4 | Strength |
5 | Intellect |
6 | Spirit |
7 | Stamina |
stat_value1 smallint(6)
The value to add for the matching modifier.
stat_unk1_1 int(10)
stat_unk2_1 int(10)
stat_type2 tinyint(3) unsigned
An item modifier to apply for this item.
Value | Description |
---|---|
0 | No stats |
1 | Health |
3 | Agility |
4 | Strength |
5 | Intellect |
6 | Spirit |
7 | Stamina |
stat_value2 smallint(6)
The value to add for the matching modifier.
stat_unk1_2 int(10)
stat_unk2_2 int(10)
stat_type3 tinyint(3) unsigned
An item modifier to apply for this item.
Value | Description |
---|---|
0 | No stats |
1 | Health |
3 | Agility |
4 | Strength |
5 | Intellect |
6 | Spirit |
7 | Stamina |
stat_value3 smallint(6)
The value to add for the matching modifier.
stat_unk1_3 int(10)
stat_unk2_3 int(10)
stat_type4 tinyint(3) unsigned
An item modifier to apply for this item.
Value | Description |
---|---|
0 | No stats |
1 | Health |
3 | Agility |
4 | Strength |
5 | Intellect |
6 | Spirit |
7 | Stamina |
stat_value4 smallint(6)
The value to add for the matching modifier.
stat_unk1_4 int(10)
stat_unk2_4 int(10)
stat_type5 tinyint(3) unsigned
An item modifier to apply for this item.
Value | Description |
---|---|
0 | No stats |
1 | Health |
3 | Agility |
4 | Strength |
5 | Intellect |
6 | Spirit |
7 | Stamina |
stat_value5 smallint(6)
The value to add for the matching modifier.
stat_unk1_5 int(10)
stat_unk2_5 int(10)
stat_type6 tinyint(3) unsigned
An item modifier to apply for this item.
Value | Description |
---|---|
0 | No stats |
1 | Health |
3 | Agility |
4 | Strength |
5 | Intellect |
6 | Spirit |
7 | Stamina |
stat_value6 smallint(6)
The value to add for the matching modifier.
stat_unk1_6 int(10)
stat_unk2_6 int(10)
stat_type7 tinyint(3) unsigned
An item modifier to apply for this item.
Value | Description |
---|---|
0 | No stats |
1 | Health |
3 | Agility |
4 | Strength |
5 | Intellect |
6 | Spirit |
7 | Stamina |
stat_value7 smallint(6)
The value to add for the matching modifier.
stat_unk1_7 int(10)
stat_unk2_7 int(10)
stat_type8 tinyint(3) unsigned
An item modifier to apply for this item.
Value | Description |
---|---|
0 | No stats |
1 | Health |
3 | Agility |
4 | Strength |
5 | Intellect |
6 | Spirit |
7 | Stamina |
stat_value8 smallint(6)
The value to add for the matching modifier.
stat_unk1_8 int(10)
stat_unk2_8 int(10)
stat_type9 tinyint(3) unsigned
An item modifier to apply for this item.
Value | Description |
---|---|
0 | No stats |
1 | Health |
3 | Agility |
4 | Strength |
5 | Intellect |
6 | Spirit |
7 | Stamina |
stat_value9 smallint(6)
The value to add for the matching modifier.
stat_unk1_9 int(10)
stat_unk2_9 int(10)
stat_type10 tinyint(3) unsigned
An item modifier to apply for this item.
Value | Description |
---|---|
0 | No stats |
1 | Health |
3 | Agility |
4 | Strength |
5 | Intellect |
6 | Spirit |
7 | Stamina |
stat_value10 smallint(6)
The value to add for the matching modifier.
stat_unk1_10 int(10)
stat_unk2_10 int(10)
ScalingStatDistribution smallint(6)
DamageType tinyint(3) unsigned
delay int(10)
The delay in milliseconds between successive hits for the item.
RangedModRange float
spellid_1 mediumint(8) unsigned
If the item can cast or trigger a spell, this references the spell's entry in Spell.dbc.
spelltrigger_1 tinyint(3) unsigned
The type of trigger for the matching spellid entry.
Value | Description |
---|---|
0 | On use |
1 | On equip |
2 | Chance on hit |
4 | Soulstone |
5 | On use without delay |
spellcharges_1 smallint(5)
The amount of charges for the spell referenced in the matching spellid entry.
spellppmRate_1 float
If the matching spelltrigger field is of type 2, this controls the proc per minute rate for a spell.
spellcooldown_1 int(11)
The cooldown in milliseconds for the matching spell. If set to -1, the default cooldown from the Spell.dbc table will be used.
spellcategory_1 smallint(5) unsigned
A spell category identifier. The value has to match with a category identifier defined in SpellCategory.dbc.
spellcategorycooldown_1 int(11)
The cooldown in milliseconds for the matching spell category. If set to -1, the default cooldown from the Spell.dbc table will be used.
spellid_2 mediumint(8) unsigned
If the item can cast or trigger a spell, this references the spell's entry in Spell.dbc.
spelltrigger_2 tinyint(3) unsigned
The type of trigger for the matching spellid entry.
spellcharges_2 smallint(5)
The amount of charges for the spell referenced in the matching spellid entry.
spellppmRate_2 float
If the matching spelltrigger field is of type 2, this controls the proc per minute rate for a spell.
spellcooldown_2 int(11)
The cooldown in milliseconds for the matching spell. If set to -1, the default cooldown from the Spell.dbc table will be used.
spellcategory_2 smallint(5) unsigned
A spell category identifier. The value has to match with a category identifier defined in SpellCategory.dbc.
spellcategorycooldown_2 int(11)
The cooldown in milliseconds for the matching spell category. If set to -1, the default cooldown from the Spell.dbc table will be used.
spellid_3 mediumint(8) unsigned
If the item can cast or trigger a spell, this references the spell's entry in Spell.dbc.
spelltrigger_3 tinyint(3) unsigned
The type of trigger for the matching spellid entry.
spellcharges_3 smallint(5)
The amount of charges for the spell referenced in the matching spellid entry.
spellppmRate_3 float
If the matching spelltrigger field is of type 2, this controls the proc per minute rate for a spell.
spellcooldown_3 int(11)
The cooldown in milliseconds for the matching spell. If set to -1, the default cooldown from the Spell.dbc table will be used.
spellcategory_3 smallint(5) unsigned
A spell category identifier. The value has to match with a category identifier defined in SpellCategory.dbc.
spellcategorycooldown_3 int(11)
The cooldown in milliseconds for the matching spell category. If set to -1, the default cooldown from the Spell.dbc table will be used.
spellid_4 mediumint(8) unsigned
If the item can cast or trigger a spell, this references the spell's entry in Spell.dbc.
spelltrigger_4 tinyint(3) unsigned
The type of trigger for the matching spellid entry.
spellcharges_4 smallint(5)
The amount of charges for the spell referenced in the matching spellid entry.
spellppmRate_4 float
If the matching spelltrigger field is of type 2, this controls the proc per minute rate for a spell.
spellcooldown_4 int(11)
The cooldown in milliseconds for the matching spell. If set to -1, the default cooldown from the Spell.dbc table will be used.
spellcategory_4 smallint(5) unsigned
A spell category identifier. The value has to match with a category identifier defined in SpellCategory.dbc.
spellcategorycooldown_4 int(11)
The cooldown in milliseconds for the matching spell category. If set to -1, the default cooldown from the Spell.dbc table will be used.
spellid_5 mediumint(8) unsigned
If the item can cast or trigger a spell, this references the spell's entry in Spell.dbc.
spelltrigger_5 tinyint(3) unsigned
The type of trigger for the matching spellid entry.
spellcharges_5 smallint(5)
The amount of charges for the spell referenced in the matching spellid entry.
spellppmRate_5 float
If the matching spelltrigger field is of type 2, this controls the proc per minute rate for a spell.
spellcooldown_5 int(11)
The cooldown in milliseconds for the matching spell. If set to -1, the default cooldown from the Spell.dbc table will be used.
spellcategory_5 smallint(5) unsigned
A spell category identifier. The value has to match with a category identifier defined in SpellCategory.dbc.
spellcategorycooldown_5 int(11)
The cooldown in milliseconds for the matching spell category. If set to -1, the default cooldown from the Spell.dbc table will be used.
bonding tinyint(3) unsigned
Defines if and how and item will be bound to a character.
Value | Description |
---|---|
0 | No binding |
1 | Bind on pickup |
2 | Bind on equip |
3 | Bind on use |
4 | Quest item |
description varchar(255)
A short - usually one sentence - description of the item. Mostly flavor texts.
PageText mediumint(8) unsigned
If the item should be readable, e.g. for letters, this references a page text identifier in the "page_text" table table.
LanguageID tinyint(3) unsigned
The material to be used as background for items with page texts set. This references a page text material identifier from PageTextMaterial.dbc.
PageMaterial tinyint(3) unsigned
The material to be used as background for items with page texts set. This references a page text material identifier from PageTextMaterial.dbc.
startquest mediumint(8) unsigned
ID of the quest [See quest_template.entry] the item can start.
lockid mediumint(8) unsigned
ID of the lock [See Lock.dbc] for locked items.
Material tinyint(4)
Material type. Used for sound selection when moving item.
Value | Material |
---|---|
1 | Metal |
2 | Wood |
3 | Liquid |
4 | Jewelry |
5 | Chain |
6 | Plate |
7 | Cloth |
8 | Leather |
sheath tinyint(3) unsigned
The value of this field controls how characters will show or hide items worn, e.g. for weapons.
Value | Type | Description |
---|---|---|
0 | None | No sheathing |
1 | Main hand | On the back, pointing down |
2 | Off hand | On the back, pointing up |
3 | Large weapon left | |
4 | Large weapon right | |
5 | Hip weapon left | To the side |
6 | Hip weapon right | To the side |
7 | Shield | On the back, in the middle |
RandomProperty mediumint(8) unsigned
Type of the random property [See item_enchantment_template.entry]. For items with either a random property or a random suffix.
Actual property of each item instance, taken from the item_enchantment_template list, is stored in item_instance table of the "characters" database.
RandomSuffix mediumint(8) unsigned
itemset mediumint(8) unsigned
If an item is part of an item set, this references the item set's identifier in the ItemSet.dbc table.
MaxDurability smallint(5) unsigned
The maximum durability for an item.
area mediumint(8) unsigned
If an item is only usable on a specific map, this reference a map identifier in the Map.dbc table.
Map smallint(6)
If an item is only usable on a specific map, this reference a map identifier in the Map.dbc table.
BagFamily mediumint(9)
If an item is a bag, this holds a bit-mask corresponding to bag families to which the bag belongs. The value has to match with bag families defined in ItemBagFamily.dbc
Note:
Multiple bag families may be combined.
TotemCategory mediumint(9)
socketColor_1 tinyint(4)
socketContent_1 mediumint(9)
socketColor_2 tinyint(4)
socketContent_2 mediumint(9)
socketColor_3 tinyint(4)
socketContent_3 mediumint(9)
socketBonus mediumint(9)
GemProperties mediumint(9)
RequiredDisenchantSkill smallint(6)
ArmorDamageModifier float
Duration int(11) unsigned
Items may have a duration set until the get removed from a character's inventory
Note:
Items set to be deleted in real time, require ExtraFlags set accordingly.
ItemLimitCategory smallint(6)
HolidayId int(11) unsigned
DisenchantID mediumint(8) unsigned
Disenchant template [See disenchant_loot_template.entry] if any.
FoodType tinyint(3) unsigned
If an item is usable as pet food, this table references an entry in the ItemPetFood.dbc table.
StatScalingFactor float
Unknown400_1 int(10) unsigned
Unknown400_2 int(10) unsigned
minMoneyLoot int(10) unsigned
If an item is a container holding money, this field specifies the minimum amount of money in copper possibly looted.
maxMoneyLoot int(10) unsigned
If an item is a container holding money, this field specifies the maximum amount of money in copper possibly looted.
ExtraFlags tinyint(1) unsigned
With these flags it is possible to set rare conditions on an item.
Value | Description |
---|---|
0 | Nothing special |
1 | Item is not consumable |
2 | Item will be deleted in real time, when Duration is set |
auto-generated by the getMaNGOS.eu MAGNET dbdocs module
Edited by Antz
Recommended Comments
There are no comments to display.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now