DB/Item: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
Callmephil (talk | contribs) No edit summary |
||
| Line 49: | Line 49: | ||
https://github.com/Shauren/AdbToSqlConverter/blob/master/Formats/Item.cs | https://github.com/Shauren/AdbToSqlConverter/blob/master/Formats/Item.cs | ||
{{Template:Sandbox/VersionRange|min_expansionlevel=7}} | |||
==Structure== | |||
{| style="background:#FCFCFC; color:black" | |||
|- | |||
! width="80" | Column | |||
! width="180 " | Field | |||
! width="80" | Type | |||
! width="600" | Notes | |||
|- | |||
|0 || itemID || Integer || | |||
|- | |||
|1 || FileDataID || Integer || Contain Icons Path Refer to FileData | |||
|- | |||
|2 || [[ItemClass.dbc|ItemClass]] ||iRefID|| | |||
|- | |||
|3 || [[ItemSubClass.dbc|ItemSubClass]] || iRefID|| | |||
|- | |||
|4 || sound_override_subclassid || Integer || -1 - 20, mostly -1, same as [[ItemCache.wdb]] column5 | |||
|- | |||
|5 || [[Material.dbc|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 | |||
|} | |||
[[Category:DBC]] | [[Category:DBC]] | ||
Revision as of 16:48, 7 December 2017
≥ 
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
≥ 
Structure
| Column | Field | Type | Notes |
|---|---|---|---|
| 0 | itemID | Integer | |
| 1 | FileDataID | Integer | 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 |