DB/Item

From wowdev
Revision as of 22:02, 2 February 2018 by Schlumpf (talk | contribs)
Jump to navigation Jump to search

≥ BC

Structure

Column Field Type Notes
0 itemID Integer
1 ItemClass iRefID
2 ItemSubClass iRefID
3 sound_override_subclassid Integer -1 - 20, mostly -1, same as ItemCache.wdb column5
4 MaterialID iRefID -1 - 8
5 ItemDisplayInfo iRefID
6 InventorySlotID Integer These inventory slot ID's are used to determine how an item may be equipped, see Inventory_Slots
7 SheathID Integer 0 -4, mostly 0

Pre 3.*

Column Field Type Notes
0 itemID Integer
1 ItemDisplayInfo iRefID
2 InventorySlotID Integer These inventory slot ID's are used to determine how an item may be equipped, see below
3 ItemClass iRefID

Item.db2

new in cataclysm

https://github.com/Shauren/AdbToSqlConverter/blob/master/Formats/Item.cs

≥ Legion

Structure

Column Field Type Notes
0 itemID Integer
1 FileDataID iRefID Contain Icons Path Refer to FileData
2 ItemClass iRefID
3 ItemSubClass iRefID
4 sound_override_subclassid Integer -1 - 20, mostly -1, same as ItemCache.wdb column5
5 MaterialID iRefID -1 - 8
6 InventorySlotID Integer These inventory slot ID's are used to determine how an item may be equipped, see Inventory_Slots
7 SheathID Integer 0 -4, mostly 0
8 GrouSoundsID Integer Moved from ItemDisplayInfo
  • Note : Item DisplayID You may refer to ItemAppearance.db2 & ItemModifiedAppearance.db2 however for some they remain unfound.

8.0.1.25902

struct ItemRec {
  // uint32_t m_ID;
  uint32_t m_iconFileDataId;
  uint8_t m_classID;
  uint8_t m_subclassID;
  uint8_t m_sound_override_subclassid;
  uint8_t m_material;
  uint8_t m_inventoryType;
  uint8_t m_sheatheType;
  uint8_t m_groupSoundID;
};