hotfixes_item

The `item` table

This table contains some of the data regarding item hotfixes. Together with item_appearance, item_modified_appearance and item_sparse they present the means to hotfix an item.

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
ID	int(10)	unsigned	PRI	NO	0
Class	int(10)	unsigned		NO	0
Subclass	int(10)	unsigned		NO	0
SoundOverrideSubclass	int(11)	signed		NO	0
Material	int(11)	signed		NO	0
InventoryType	int(10)	unsigned		NO	0
Sheath	int(10)	unsigned		NO	0
FileDataID	int(10)	unsigned		NO	0
GroupSoundsID	int(10)	unsigned		NO	0
VerifiedBuild	smallint(6)	signed		NO	0

Description of the fields

ID

This is the unique ID for the item that has received a hotfix.
This value links to hotfix_data.RecordID with the proper TableHash accompanied and item_modified_appearance.ItemID.

Class

ID	Name

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

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