DB/Item: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
mNo edit summary |
||
| Line 20: | Line 20: | ||
|5 || [[ItemDisplayInfo.dbc|ItemDisplayInfo]] || iRefID|| | |5 || [[ItemDisplayInfo.dbc|ItemDisplayInfo]] || iRefID|| | ||
|- | |- | ||
|6 || InventorySlotID || Integer || These inventory slot ID's are used to determine how an item may be equipped, see | |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 | |7 || SheathID || Integer || 0 -4, mostly 0 | ||
|} | |} | ||
Revision as of 00:11, 22 February 2016
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