From a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 Mon Sep 17 00:00:00 2001 From: FrancescoBorzi Date: Mon, 25 Feb 2019 19:24:20 +0100 Subject: Import DB wiki from TC 335 --- docs/item_template.md | 3857 +++++++++++++++++++++++++++++++++++++++++++++++-- 1 file changed, 3714 insertions(+), 143 deletions(-) (limited to 'docs/item_template.md') diff --git a/docs/item_template.md b/docs/item_template.md index 73304b4..b9fcf73 100644 --- a/docs/item_template.md +++ b/docs/item_template.md @@ -1,143 +1,3714 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [item_template](item_template) - -Column | Type | Description ---- | --- | --- -Entry | mediumint(8) unsigned | -Class | tinyint(3) unsigned | -Subclass | tinyint(3) unsigned | -SoundOverrideSubclass | tinyint(3) | -Name | varchar(255) | -Displayid | mediumint(8) unsigned | -Quality | tinyint(3) unsigned | -Flags | int(10) unsigned | -FlagsExtra | int(10) unsigned | -BuyCount | tinyint(3) unsigned | -BuyPrice | bigint(20) | -SellPrice | int(10) unsigned | -InventoryType | tinyint(3) unsigned | -AllowableClass | int(11) | -AllowableRace | int(11) | -ItemLevel | smallint(5) unsigned | -RequiredLevel | tinyint(3) unsigned | -RequiredSkill | smallint(5) unsigned | -RequiredSkillRank | smallint(5) unsigned | -Requiredspell | mediumint(8) unsigned | -Requiredhonorrank | mediumint(8) unsigned | -RequiredCityRank | mediumint(8) unsigned | -RequiredReputationFaction | smallint(5) unsigned | -RequiredReputationRank | smallint(5) unsigned | -Maxcount | int(11) | -Stackable | int(11) | -ContainerSlots | tinyint(3) unsigned | -StatsCount | tinyint(3) unsigned | -Stat_type1 | tinyint(3) unsigned | -Stat_value1 | smallint(6) | -Stat_type2 | tinyint(3) unsigned | -Stat_value2 | smallint(6) | -Stat_type3 | tinyint(3) unsigned | -Stat_value3 | smallint(6) | -Stat_type4 | tinyint(3) unsigned | -Stat_value4 | smallint(6) | -Stat_type5 | tinyint(3) unsigned | -Stat_value5 | smallint(6) | -Stat_type6 | tinyint(3) unsigned | -Stat_value6 | smallint(6) | -Stat_type7 | tinyint(3) unsigned | -Stat_value7 | smallint(6) | -Stat_type8 | tinyint(3) unsigned | -Stat_value8 | smallint(6) | -Stat_type9 | tinyint(3) unsigned | -Stat_value9 | smallint(6) | -Stat_type10 | tinyint(3) unsigned | -Stat_value10 | smallint(6) | -ScalingStatDistribution | smallint(6) | -ScalingStatValue | int(10) unsigned | -Dmg_min1 | float | -Dmg_max1 | float | -Dmg_type1 | tinyint(3) unsigned | -Dmg_min2 | float | -Dmg_max2 | float | -Dmg_type2 | tinyint(3) unsigned | -Armor | smallint(5) unsigned | -Holy_res | tinyint(3) unsigned | -Fire_res | tinyint(3) unsigned | -Nature_res | tinyint(3) unsigned | -Frost_res | tinyint(3) unsigned | -Shadow_res | tinyint(3) unsigned | -Arcane_res | tinyint(3) unsigned | -Delay | smallint(5) unsigned | -Ammo_type | tinyint(3) unsigned | -RangedModRange | float | -Spellid_1 | mediumint(8) | -Spelltrigger_1 | tinyint(3) unsigned | -Spellcharges_1 | smallint(6) | -SpellppmRate_1 | float | -Spellcooldown_1 | int(11) | -Spellcategory_1 | smallint(5) unsigned | -Spellcategorycooldown_1 | int(11) | -Spellid_2 | mediumint(8) | -Spelltrigger_2 | tinyint(3) unsigned | -Spellcharges_2 | smallint(6) | -SpellppmRate_2 | float | -Spellcooldown_2 | int(11) | -Spellcategory_2 | smallint(5) unsigned | -Spellcategorycooldown_2 | int(11) | -Spellid_3 | mediumint(8) | -Spelltrigger_3 | tinyint(3) unsigned | -Spellcharges_3 | smallint(6) | -SpellppmRate_3 | float | -Spellcooldown_3 | int(11) | -Spellcategory_3 | smallint(5) unsigned | -Spellcategorycooldown_3 | int(11) | -Spellid_4 | mediumint(8) | -Spelltrigger_4 | tinyint(3) unsigned | -Spellcharges_4 | smallint(6) | -SpellppmRate_4 | float | -Spellcooldown_4 | int(11) | -Spellcategory_4 | smallint(5) unsigned | -Spellcategorycooldown_4 | int(11) | -Spellid_5 | mediumint(8) | -Spelltrigger_5 | tinyint(3) unsigned | -Spellcharges_5 | smallint(6) | -SpellppmRate_5 | float | -Spellcooldown_5 | int(11) | -Spellcategory_5 | smallint(5) unsigned | -Spellcategorycooldown_5 | int(11) | -Bonding | tinyint(3) unsigned | -Description | varchar(255) | -PageText | mediumint(8) unsigned | -LanguageID | tinyint(3) unsigned | -PageMaterial | tinyint(3) unsigned | -Startquest | mediumint(8) unsigned | -Lockid | mediumint(8) unsigned | -Material | tinyint(4) | -Sheath | tinyint(3) unsigned | -RandomProperty | mediumint(8) | -RandomSuffix | mediumint(8) unsigned | -Block | mediumint(8) unsigned | -Itemset | mediumint(8) unsigned | -MaxDurability | smallint(5) unsigned | -Area | mediumint(8) unsigned | -Map | smallint(6) | -BagFamily | mediumint(8) | -TotemCategory | mediumint(8) | -SocketColor_1 | tinyint(4) | -SocketContent_1 | mediumint(8) | -SocketColor_2 | tinyint(4) | -SocketContent_2 | mediumint(8) | -SocketColor_3 | tinyint(4) | -SocketContent_3 | mediumint(8) | -SocketBonus | mediumint(8) | -GemProperties | mediumint(8) | -RequiredDisenchantSkill | smallint(6) | -ArmorDamageModifier | float | -Duration | int(10) unsigned | -ItemLimitCategory | smallint(6) | -HolidayId | int(11) unsigned | -ScriptName | varchar(64) | -DisenchantID | mediumint(8) unsigned | -FoodType | tinyint(3) unsigned | -MinMoneyLoot | int(10) unsigned | -MaxMoneyLoot | int(10) unsigned | -FlagsCustom | int(10) unsigned | -VerifiedBuild | smallint(6) | +# 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

 

FlagsExtra

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

UNK1

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

32

0x020

Item can not be destroyed, except by using spell (item can be reagent for spell)

64

0x040

UNK2

1280x080No default 30 seconds cooldown when equipped
2560x0100UNK3

512

0x0200

Wrapper : Item can wrap other items

1024

0x0400

UNK4

2048

0x0800

Item is party loot and can be looted by all

4096

0x01000

Item is refundable

8192

0x02000

Charter (Arena or Guild)

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

32768

0x08000

UNK6

655360x010000UNK7
1310720x020000UNK8
2621440x040000

Item can be prospected

524288

0x080000

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

10485760x0100000UNK9
20971520x0200000Item can be used during arena match

4194304

0x0400000

Throwable (for tooltip ingame)

8388608

0x0800000

Item can be used in shapeshift forms

167772160x01000000 UNK10
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 with triggered flag

536870912

0x020000000

Millable

10737418240x040000000 UNK11

2147483648

0x080000000

Bind on Pickup tradeable

+ +### 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](npc_vendor_2130245.html#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](http://collab.kpsn.org/display/tc/ChrClasses) 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](http://collab.kpsn.org/display/tc/ChrRaces) 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](http://collab.kpsn.org/display/tc/SkillLine) 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](http://collab.kpsn.org/display/tc/Faction) for the IDs of all of the factions. + +### RequiredReputationRank + +The rank the player has to have with the faction from [RequiredReputationFaction](#item_template-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](#item_template-stat_type), this must be updated to display those entries +(Unknown how this works) + +### stat\_type + +The type of stat to modify. + + ++++ + +