Jump to content
  • We are looking for staff for the Wiki area!
    If interested please
    click here and select "Documentation Team"

  • item_template


    antz
     Share

     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 MaNGOSZero

    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.
    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.
    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 tinyint(3) 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) unsigned NO '0'   The maximum amount of copies of the item that a character may have.
    stackable smallint(5) unsigned 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_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_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_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_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_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_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_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_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_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.
    dmg_min1 float NO '0'   The minimum damage caused by the item.
    dmg_max1 float NO '0'   The maximum damage caused by the item.
    dmg_type1 tinyint(3) unsigned NO '0'   The type of damage the matching dmg_min/dmg_max fields cause.
    dmg_min2 float NO '0'   The minimum damage caused by the item.
    dmg_max2 float NO '0'   The maximum damage caused by the item.
    dmg_type2 tinyint(3) unsigned NO '0'   The type of damage the matching dmg_min/dmg_max fields cause.
    dmg_min3 float NO '0'   The minimum damage caused by the item.
    dmg_max3 float NO '0'   The maximum damage caused by the item.
    dmg_type3 tinyint(3) unsigned NO '0'   The type of damage the matching dmg_min/dmg_max fields cause.
    dmg_min4 float NO '0'   The minimum damage caused by the item.
    dmg_max4 float NO '0'   The maximum damage caused by the item.
    dmg_type4 tinyint(3) unsigned NO '0'   The type of damage the matching dmg_min/dmg_max fields cause.
    dmg_min5 float NO '0'   The minimum damage caused by the item.
    dmg_max5 float NO '0'   The maximum damage caused by the item.
    dmg_type5 tinyint(3) unsigned NO '0'   The type of damage the matching dmg_min/dmg_max fields cause.
    armor smallint(5) unsigned NO '0'   The armor value of the item.
    holy_res tinyint(3) unsigned NO '0'   Holy resistance.
    fire_res tinyint(3) unsigned NO '0'   Fire resistance.
    nature_res tinyint(3) unsigned NO '0'   Nature resistance.
    frost_res tinyint(3) unsigned NO '0'   Frost resistance.
    shadow_res tinyint(3) unsigned NO '0'   Shadow resistance.
    arcane_res tinyint(3) unsigned NO '0'   Arcane resistance.
    delay smallint(5) unsigned NO '1000'   The delay in milliseconds between successive hits for the item.
    ammo_type tinyint(3) unsigned NO '0'   The type of ammunition the item uses. Arrows = 2; Bullets = 3
    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 tinyint(4) 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 tinyint(4) 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 tinyint(4) 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 tinyint(4) 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 tinyint(4) 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].
    block mediumint(8) unsigned NO '0'   If an item is a shield, this field holds the block chance.
    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
    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.
    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.
    Duration int(11) unsigned NO '0'   Items may have a duration set until the get removed from a character's inventory
    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.

    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

    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 tinyint(3) 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) unsigned

    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) unsigned

    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_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_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_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_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_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_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_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_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_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.

    dmg_min1 float

    The minimum damage caused by the item.

    dmg_max1 float

    The maximum damage caused by the item.

    dmg_type1 tinyint(3) unsigned

    The type of damage the matching dmg_min/dmg_max fields cause.

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

    dmg_min2 float

    The minimum damage caused by the item.

    dmg_max2 float

    The maximum damage caused by the item.

    dmg_type2 tinyint(3) unsigned

    The type of damage the matching dmg_min/dmg_max fields cause.

    dmg_min3 float

    The minimum damage caused by the item.

    dmg_max3 float

    The maximum damage caused by the item.

    dmg_type3 tinyint(3) unsigned

    The type of damage the matching dmg_min/dmg_max fields cause.

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

    dmg_min4 float

    The minimum damage caused by the item.

    dmg_max4 float

    The maximum damage caused by the item.

    dmg_type4 tinyint(3) unsigned

    The type of damage the matching dmg_min/dmg_max fields cause.

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

    dmg_min5 float

    The minimum damage caused by the item.

    dmg_max5 float

    The maximum damage caused by the item.

    dmg_type5 tinyint(3) unsigned

    The type of damage the matching dmg_min/dmg_max fields cause.

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

    armor smallint(5) unsigned

    The armor value of the item.

    holy_res tinyint(3) unsigned

    Holy resistance.

    fire_res tinyint(3) unsigned

    Fire resistance.

    nature_res tinyint(3) unsigned

    Nature resistance.

    frost_res tinyint(3) unsigned

    Frost resistance.

    shadow_res tinyint(3) unsigned

    Shadow resistance.

    arcane_res tinyint(3) unsigned

    Arcane resistance.

    delay smallint(5) unsigned

    The delay in milliseconds between successive hits for the item.

    ammo_type tinyint(3) unsigned

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

    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 tinyint(4)

    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 tinyint(4)

    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 tinyint(4)

    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 tinyint(4)

    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 tinyint(4)

    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.

    block mediumint(8) unsigned

    If an item is a shield, this field holds the block chance.

    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.

    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.

    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.

    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.

    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

     Share


    User Feedback

    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 account

    Sign in

    Already have an account? Sign in here.

    Sign In Now

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use