item_template

Back-to:World

Table Structure

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

entry

mediumint(8)

unsigned

PRI

NO

0


class

tinyint(3)

unsigned


NO

0


subclass

tinyint(3)

unsigned


NO

0


SoundOverrideSubclass

tinyint(3)

signed


NO

-1


name

varchar(255)

signed


NO

NULL


displayid

mediumint(8)

unsigned


NO

0


Quality

tinyint(3)

unsigned


NO

0


Flags

bigint(20)

signed


NO

0


iFlagsExtra

int(10)

unsigned


NO

0


BuyCount

tinyint(3)

unsigned


NO

1


BuyPrice

bigint(20)

signed


NO

0


SellPrice

int(10)

unsigned


NO

0


InventoryType

tinyint(3)

unsigned


NO

0


AllowableClass

int(11)

signed


NO

-1


AllowableRace

int(11)

signed


NO

-1


ItemLevel

smallint(5)

unsigned


NO

0


RequiredLevel

tinyint(3)

unsigned


NO

0


RequiredSkill

smallint(5)

unsigned


NO

0


RequiredSkillRank

smallint(5)

unsigned


NO

0


requiredspell

mediumint(8)

unsigned


NO

0


requiredhonorrank

mediumint(8)

unsigned


NO

0


RequiredCityRank

mediumint(8)

unsigned


NO

0


RequiredReputationFaction

smallint(5)

unsigned


NO

0


RequiredReputationRank

smallint(5)

unsigned


NO

0


maxcount

int(11)

signed


NO

0


stackable

int(11)

signed


NO

1


ContainerSlots

smallint(5)

unsigned


NO

0


StatsCount

tinyint(3)

unsigned


NO

0


stat_type1

tinyint(3)

unsigned


NO

0


stat_value1

smallint(6)

signed


NO

0


stat_type2

tinyint(3)

unsigned


NO

0


stat_value2

smallint(6)

signed


NO

0


stat_type3

tinyint(3)

unsigned


NO

0


stat_value3

smallint(6)

signed


NO

0


stat_type4

tinyint(3)

unsigned


NO

0


stat_value4

smallint(6)

signed


NO

0


stat_type5

tinyint(3)

unsigned


NO

0


stat_value5

smallint(6)

signed


NO

0


stat_type6

tinyint(3)

unsigned


NO

0


stat_value6

smallint(6)

signed


NO

0


stat_type7

tinyint(3)

unsigned


NO

0


stat_value7

smallint(6)

signed


NO

0


stat_type8

tinyint(3)

unsigned


NO

0


stat_value8

smallint(6)

signed


NO

0


stat_type9

tinyint(3)

unsigned


NO

0


stat_value9

smallint(6)

signed


NO

0


stat_type10

tinyint(3)

unsigned


NO

0


stat_value10

smallint(6)

signed


NO

0


ScalingStatDistribution

smallint(6)

signed


NO

0


ScalingStatValue

int(6)

unsigned


NO

0


dmg_min1

float

signed


NO

0


dmg_max1

float

signed


NO

0


dmg_type1

tinyint(3)

unsigned


NO

0


dmg_min2

float

signed


NO

0


dmg_max2

float

signed


NO

0


dmg_type2

tinyint(3)

unsigned


NO

0


armor

smallint(5)

unsigned


NO

0


holy_res

tinyint(3)

unsigned


NO

0


fire_res

tinyint(3)

unsigned


NO

0


nature_res

tinyint(3)

unsigned


NO

0


frost_res

tinyint(3)

unsigned


NO

0


shadow_res

tinyint(3)

unsigned


NO

0


arcane_res

tinyint(3)

unsigned


NO

0


delay

smallint(5)

unsigned


NO

1000


ammo_type

tinyint(3)

unsigned


NO

0


RangedModRange

float

signed


NO

0


spellid_1

mediumint(8)

signed


NO

0


spelltrigger_1

tinyint(3)

unsigned


NO

0


spellcharges_1

smallint(6)

signed


NO

0


spellppmRate_1

float

signed


NO

0


spellcooldown_1

int(11)

signed


NO

-1


spellcategory_1

smallint(5)

unsigned


NO

0


spellcategorycooldown_1

int(11)

signed


NO

-1


spellid_2

mediumint(8)

signed


NO

0


spelltrigger_2

tinyint(3)

unsigned


NO

0


spellcharges_2

smallint(6)

signed


NO

0


spellppmRate_2

float

signed


NO

0


spellcooldown_2

int(11)

signed


NO

-1



spellcategory_2

smallint(5)

unsigned


NO

0


spellcategorycooldown_2

int(11)

signed


NO

-1


spellid_3

mediumint(8)

signed


NO

0


spelltrigger_3

tinyint(3)

unsigned


NO

0


spellcharges_3

smallint(6)

signed


NO

0


spellppmRate_3

float

signed


NO

0


spellcooldown_3

int(11)

signed


NO

-1


spellcategory_3

smallint(5)

unsigned


NO

0


spellcategorycooldown_3

int(11)

signed


NO

-1


spellid_4

mediumint(8)

signed


NO

0


spelltrigger_4

tinyint(3)

unsigned


NO

0


spellcharges_4

smallint(6)

signed


NO

0


spellppmRate_4

float

signed


NO

0


spellcooldown_4

int(11)

signed


NO

-1


spellcategory_4

smallint(5)

unsigned


NO

0


spellcategorycooldown_4

int(11)

signed


NO

-1


spellid_5

mediumint(8)

signed


NO

0


spelltrigger_5

tinyint(3)

unsigned


NO

0


spellcharges_5

smallint(6)

signed


NO

0


spellppmRate_5

float

signed


NO

0


spellcooldown_5

int(11)

signed


NO

-1


spellcategory_5

smallint(5)

unsigned


NO

0


spellcategorycooldown_5

int(11)

signed


NO

-1


bonding

tinyint(3)

unsigned


NO

0


description

varchar(255)

signed


NO

NULL


PageText

mediumint(8)

unsigned


NO

0


LanguageID

tinyint(3)

unsigned


NO

0


PageMaterial

tinyint(3)

unsigned


NO

0


startquest

mediumint(8)

unsigned


NO

0


lockid

mediumint(8)

unsigned


NO

0


Material

tinyint(4)

signed


NO

0


sheath

tinyint(3)

unsigned


NO

0


RandomProperty

mediumint(8)

signed


NO

0


RandomSuffix

mediumint(8)

unsigned


NO

0


block

mediumint(8)

unsigned


NO

0


itemset

mediumint(8)

unsigned


NO

0


MaxDurability

smallint(5)

unsigned


NO

0


area

mediumint(8)

unsigned


NO

0


Map

smallint(6)

signed


NO

0


BagFamily

mediumint(9)

signed


NO

0


TotemCategory

mediumint(9)

signed


NO

0


socketColor_1

tinyint(4)

signed


NO

0


socketContent_1

mediumint(9)

signed


NO

0


socketColor_2

tinyint(4)

signed


NO

0


socketContent_2

mediumint(9)

signed


NO

0


socketColor_3

tinyint(4)

signed


NO

0


socketContent_3

mediumint(9)

signed


NO

0


socketBonus

mediumint(9)

signed


NO

0


GemProperties

mediumint(9)

signed


NO

0


RequiredDisenchantSkill

smallint(6)

signed


NO

-1


ArmorDamageModifier

float

signed


NO

0


duration

int(10)

unsigned


NO

0

Duration in seconds

ItemLimitCategory

smallint(6)

signed


NO

0


HolidayId

int(11)

unsigned


NO

0


ScriptName

varchar(64)

signed


NO

NULL


DisenchantID

mediumint(8)

unsigned


NO

0


FoodType

tinyint(3)

unsigned


NO

0


minMoneyLoot

int(10)

unsigned


NO

0


maxMoneyLoot

int(10)

unsigned


NO

0


flagsCustom

int(10)

unsigned


NO

0


VerifiedBuild (WDBVerified)

smallint(5)

signed


YES

1


Field Descriptions

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

Mail


4

4

Plate


4

5

Buckler(OBSOLETE)


4

6

Shield


4

7

Libram


4

8

Idol


4

9

Totem


4

10

Sigil

5

0

Reagent


6

0

Wand(OBSOLETE)


6

1

Bolt(OBSOLETE)


6

2

Arrow


6

3

Bullet


6

4

Thrown(OBSOLETE)


7

0

Trade Goods


7

1

Parts


7

2

Explosives


7

3

Devices


7

4

Jewelcrafting


7

5

Cloth


7

6

Leather


7

7

Metal & Stone


7

8

Meat


7

9

Herb


7

10

Elemental


7

11

Other


7

12

Enchanting


7

13

Materials

7

14

Armor Enchantment

7

15

Weapon Enchantment

8

0

Generic(OBSOLETE)


9

0

Book


9

1

Leatherworking


9

2

Tailoring


9

3

Engineering


9

4

Blacksmithing


9

5

Cooking


9

6

Alchemy


9

7

First Aid


9

8

Enchanting


9

9

Fishing


9

10

Jewelcrafting


10

0

Money(OBSOLETE)


11

0

Quiver(OBSOLETE)


11

1

Quiver(OBSOLETE)


11

2

Quiver

Can hold arrows

11

3

Ammo Pouch

Can hold bullets

12

0

Quest


13

0

Key


13

1

Lockpick


14

0

Permanent


15

0

Junk


15

1

Reagent


15

2

Pet


15

3

Holiday


15

4

Other


15

5

Mount

16

1

Warrior

16

2

Paladin

16

3

Hunter

16

4

Rogue

16

5

Priest

16

6

Death Knight

16

7

Shaman

16

8

Mage

16

9

Warlock

16

11

Druid

SoundOverrideSubclass

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

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

name

The 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

0x040ITEM_FLAG_PLAYERCAST
1280x080No default 30 seconds cooldown when equipped
2560x0100ITEM_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)

163840x04000ITEM_FLAG_HAS_TEXT // comment in code : Only readable items have this (but not all)

32768

0x08000

ITEM_FLAG_NO_DISENCHANT

655360x010000ITEM_FLAG_REAL_DURATION
1310720x020000ITEM_FLAG_NO_CREATOR
2621440x040000

Item can be prospected

524288

0x080000

Unique equipped (player can only have one equipped at the same time)

10485760x0100000ITEM_FLAG_IGNORE_FOR_AURAS
20971520x0200000Item can be used during arena match

4194304

0x0400000

ITEM_FLAG_NO_DURABILITY_LOSS

8388608

0x0800000

Item can be used in shapeshift forms

167772160x01000000 ITEM_FLAG_HAS_QUEST_GLOW
335544320x02000000 Profession recipes: can only be looted if you meet requirements and don't already know it
671088640x04000000 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

10737418240x040000000 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


0x0100Makes need roll for this item disabled

512

0x0200

NEED_ROLL_DISABLED

163840x04000HAS_NORMAL_PRICE
1310720x020000BNET_ACCOUNT_BOUND
20971520x0200000CANNOT_BE_TRANSMOG
41943040x0400000CANNOT_TRANSMOG
83886080x0800000CAN_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.