DB/Item: Difference between revisions

From wowdev
Jump to navigation Jump to search
mNo edit summary
No edit summary
Line 1: Line 1:
{{Template:Sandbox/VersionRange|min_expansionlevel=2}}
==Structure==
==Structure==



Revision as of 02:38, 20 July 2016

≥ 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