ItemCache.wdb: Difference between revisions
Jump to navigation
Jump to search
(New page: The ItemCache.wdb holds most of the information for items you have seen in game. Signature: WIDB (reversed) ==Structure== '''Column Field Type Notes''' 1 itemID Integer ...) |
Barncastle (talk | contribs) mNo edit summary |
||
(12 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
The ItemCache.wdb holds most of the information for items you have seen in game. | The ItemCache.wdb holds most of the information for items you have seen in game. | ||
*Signature: WIDB | |||
Signature: WIDB | |||
==Structure== | ==Structure== | ||
Line 16: | Line 15: | ||
10 itemdisplayID Integer [[ItemDisplayInfo.dbc]] | 10 itemdisplayID Integer [[ItemDisplayInfo.dbc]] | ||
11 qualityID Integer Quality Types | 11 qualityID Integer Quality Types | ||
12 typeBinFlag BitMask Item Types | 12 typeBinFlag BitMask [[Item Types]] | ||
13 buyPrice Integer Value is in Copper | 13 buyPrice Integer Value is in Copper | ||
14 sellPrice Integer Value is in Copper | 14 sellPrice Integer Value is in Copper | ||
15 inventorySlotID Integer Inventory Slots | 15 inventorySlotID Integer Inventory Slots | ||
16 classBinFlag BitMask ChrClasses.dbc - Class Types | 16 classBinFlag BitMask [[ChrClasses.dbc]] - Class Types | ||
17 raceBinFlag BitMask ChrRaces.dbc - Race Types | 17 raceBinFlag BitMask [[ChrRaces.dbc]] - Race Types | ||
18 itemLevel Integer The actual base level of an item | 18 itemLevel Integer The actual base level of an item | ||
19 requiredLevel Integer Player's required level to use | 19 requiredLevel Integer Player's required level to use | ||
Line 31: | Line 30: | ||
25 requiredFactionID Integer Required Faction Group to use | 25 requiredFactionID Integer Required Faction Group to use | ||
26 requiredFactionLevel Integer Level of Faction required | 26 requiredFactionLevel Integer Level of Faction required | ||
27 | 27 stackUnique Integer Maximum number of items total in your inventory | ||
28 stackAmount Integer Maximum number of items in a stack | 28 stackAmount Integer Maximum number of items in a stack | ||
29 containerSlots Integer Number of slots for container | 29 containerSlots Integer Number of slots for container | ||
30 stat1ID Integer Stat Types | 30 stat1ID Integer [[Stat_Types|Stat Types]] | ||
31 stat1Value Integer | 31 stat1Value Integer | ||
32 stat2ID Integer Stat Types | 32 stat2ID Integer [[Stat_Types|Stat Types]] | ||
33 stat2Value Integer | 33 stat2Value Integer | ||
34 stat3ID Integer Stat Types | 34 stat3ID Integer [[Stat_Types|Stat Types]] | ||
35 stat3Value Integer | 35 stat3Value Integer | ||
36 stat4ID Integer Stat Types | 36 stat4ID Integer [[Stat_Types|Stat Types]] | ||
37 stat4Value Integer | 37 stat4Value Integer | ||
38 stat5ID Integer Stat Types | 38 stat5ID Integer [[Stat_Types|Stat Types]] | ||
39 stat5Value Integer | 39 stat5Value Integer | ||
40 stat6ID Integer Stat Types | 40 stat6ID Integer [[Stat_Types|Stat Types]] | ||
41 stat6Value Integer | 41 stat6Value Integer | ||
42 stat7ID Integer Stat Types | 42 stat7ID Integer [[Stat_Types|Stat Types]] | ||
43 stat7Value Integer | 43 stat7Value Integer | ||
44 stat8ID Integer Stat Types | 44 stat8ID Integer [[Stat_Types|Stat Types]] | ||
45 stat8Value Integer | 45 stat8Value Integer | ||
46 stat9ID Integer Stat Types | 46 stat9ID Integer [[Stat_Types|Stat Types]] | ||
47 stat9Value Integer | 47 stat9Value Integer | ||
48 stat10ID Integer Stat Types | 48 stat10ID Integer [[Stat_Types|Stat Types]] | ||
49 stat10Value Integer | 49 stat10Value Integer | ||
50 damage1Min Float | 50 damage1Min Float | ||
51 damage1Max Float | 51 damage1Max Float | ||
52 damage1TypeID Integer | 52 damage1TypeID Integer [[Resistances.dbc|Damage Types]] | ||
53 damage2Min Float | 53 damage2Min Float | ||
54 damage2Max Float | 54 damage2Max Float | ||
55 damage2TypeID Integer | 55 damage2TypeID Integer [[Resistances.dbc|Damage Types]] | ||
56 damage3Min Float | 56 damage3Min Float | ||
57 damage3Max Float | 57 damage3Max Float | ||
58 damage3TypeID Integer | 58 damage3TypeID Integer [[Resistances.dbc|Damage Types]] | ||
59 damage4Min Float | 59 damage4Min Float | ||
60 damage4Max Float | 60 damage4Max Float | ||
61 damage4TypeID Integer | 61 damage4TypeID Integer [[Resistances.dbc|Damage Types]] | ||
62 damage5Min Float | 62 damage5Min Float | ||
63 damage5Max Float | 63 damage5Max Float | ||
64 damage5TypeID Integer | 64 damage5TypeID Integer [[Resistances.dbc|Damage Types]] | ||
65 resistPhysical Integer This is your Physical Armor | 65 resistPhysical Integer This is your Physical Armor | ||
66 resistHoly Integer | 66 resistHoly Integer | ||
Line 125: | Line 124: | ||
119 itemAreaID Integer [[AreaTable.dbc]] | 119 itemAreaID Integer [[AreaTable.dbc]] | ||
120 itemMapID Integer [[Map.dbc]] | 120 itemMapID Integer [[Map.dbc]] | ||
121 bagFamily Integer Special Bag Types | 121 bagFamily Integer Special Bag Types *bitmask* itembagfamily.dbc | ||
122 iRefID_TotemCategory Integer Reference to which tools this item acts as | 122 iRefID_TotemCategory Integer Reference to which tools this item acts as | ||
123 socketColor_1 Integer Color of socket 1 | 123 socketColor_1 Integer Color of socket 1 | ||
Line 133: | Line 132: | ||
127 socketColor_3 Integer Color of socket 3 | 127 socketColor_3 Integer Color of socket 3 | ||
128 Unknown Integer | 128 Unknown Integer | ||
129 iRefID_[[SpellItemEnchantment.dbc|SpellItemEnchantment]] Integer | 129 iRefID_[[SpellItemEnchantment.dbc|SpellItemEnchantment]] Integer Socket Bonus | ||
130 iRefID_[[GemProperties.dbc|GemProperties]] Integer Properties of the gem | 130 iRefID_[[GemProperties.dbc|GemProperties]] Integer Properties of the gem | ||
131 iRefID_[[ItemExtendedCost.dbc|ItemExtendedCost]] Integer Arena "honor" cost | 131 iRefID_[[ItemExtendedCost.dbc|ItemExtendedCost]] Integer Arena "honor" cost | ||
132 disenchantSkillLevel Integer Required enchanting level, to disenchant the item | 132 iRefID_[[ItemCondExtCosts.dbc|ItemCondExtCosts]] Integer Reference to [[ItemCondExtCosts.dbc|ItemCondExtCosts]]'s second column | ||
133 disenchantSkillLevel Integer Required enchanting level, to disenchant the item | |||
134 armorDamageModifier Float Shows the added armor (item class 4) or weapon damage (item class 2) for which item points are spend. Can also be negative as seen for caster weapons (damage subtracted, to gain points to spend on caster stats). | |||
Armor pieces with a non-zero value, will list the armor value in a green color on the ingame tooltip. | Armor pieces with a non-zero value, will list the armor value in a green color on the ingame tooltip. | ||
For {{Template:Sandbox/PrettyVersion|expansionlevel=0|build=0.5.3.3368}} client version | |||
'''Column Field Type | |||
1 Class Integer | |||
2 Subclass Integer | |||
3 DisplayName String[4] | |||
4 DisplayInfoID Integer | |||
5 OverallQualityID Integer | |||
6 Flags Integer | |||
7 BuyPrice Integer | |||
8 SellPrice Integer | |||
9 InventoryType Integer | |||
10 AllowableClass Integer | |||
11 AllowableRace Integer | |||
12 ItemLevel Integer | |||
13 RequiredLevel Integer | |||
14 RequiredSkill Integer | |||
15 RequiredSkillRank Integer | |||
16 MaxCount Integer | |||
17 Stackable Integer | |||
18 ContainerSlots Integer | |||
19 BonusStat Integer[10] | |||
20 BonusAmount Integer[10] | |||
21 MinDamage Integer[5] | |||
22 MaxDamage Integer[5] | |||
23 DamageType Integer[5] | |||
24 Resistances Integer[6] | |||
25 Delay Integer | |||
26 AmmunitionType Integer | |||
27 MaxDurability Integer | |||
28 SpellID Integer[5] | |||
29 SpellTrigger Integer[5] | |||
30 SpellCharges Integer[5] | |||
31 SpellCooldown Integer[5] | |||
32 SpellCategory Integer[5] | |||
33 SpellCategoryCooldown Integer[5] | |||
34 Bonding Integer | |||
35 Description String | |||
36 PageText Integer | |||
37 LanguageID Integer | |||
38 PageMaterial Integer | |||
39 StartQuestID Integer | |||
40 LockID Integer | |||
41 Material Integer | |||
42 SheatheType Integer | |||
[[Category:WDB]] |
Latest revision as of 16:23, 31 August 2017
The ItemCache.wdb holds most of the information for items you have seen in game.
- Signature: WIDB
Structure
Column Field Type Notes 1 itemID Integer 2 entryLength Integer WDB Files 3 itemClassID Integer ItemClass.dbc 4 itemSubClassID Integer ItemSubClass.dbc 5 Unknown Unknown Added build 6022, 4-bytes 6 name String 7 name String 8 name String 9 name String 10 itemdisplayID Integer ItemDisplayInfo.dbc 11 qualityID Integer Quality Types 12 typeBinFlag BitMask Item Types 13 buyPrice Integer Value is in Copper 14 sellPrice Integer Value is in Copper 15 inventorySlotID Integer Inventory Slots 16 classBinFlag BitMask ChrClasses.dbc - Class Types 17 raceBinFlag BitMask ChrRaces.dbc - Race Types 18 itemLevel Integer The actual base level of an item 19 requiredLevel Integer Player's required level to use 20 requiredSkillID Integer SkillLine.dbc - Required Skill to use 21 requiredSkillLevel Integer Level of Skill required 22 requiredSpellID Integer Spell.dbc - Spell required to use the item 23 requiredRankID Integer Required PvP Rank to use 24 requiredUnknownRank Integer Unknown PvP Ranks 25 requiredFactionID Integer Required Faction Group to use 26 requiredFactionLevel Integer Level of Faction required 27 stackUnique Integer Maximum number of items total in your inventory 28 stackAmount Integer Maximum number of items in a stack 29 containerSlots Integer Number of slots for container 30 stat1ID Integer Stat Types 31 stat1Value Integer 32 stat2ID Integer Stat Types 33 stat2Value Integer 34 stat3ID Integer Stat Types 35 stat3Value Integer 36 stat4ID Integer Stat Types 37 stat4Value Integer 38 stat5ID Integer Stat Types 39 stat5Value Integer 40 stat6ID Integer Stat Types 41 stat6Value Integer 42 stat7ID Integer Stat Types 43 stat7Value Integer 44 stat8ID Integer Stat Types 45 stat8Value Integer 46 stat9ID Integer Stat Types 47 stat9Value Integer 48 stat10ID Integer Stat Types 49 stat10Value Integer 50 damage1Min Float 51 damage1Max Float 52 damage1TypeID Integer Damage Types 53 damage2Min Float 54 damage2Max Float 55 damage2TypeID Integer Damage Types 56 damage3Min Float 57 damage3Max Float 58 damage3TypeID Integer Damage Types 59 damage4Min Float 60 damage4Max Float 61 damage4TypeID Integer Damage Types 62 damage5Min Float 63 damage5Max Float 64 damage5TypeID Integer Damage Types 65 resistPhysical Integer This is your Physical Armor 66 resistHoly Integer 67 resistFire Integer 68 resistNature Integer 69 resistFrost Integer 70 resistShadow Integer 71 resistArcane Integer 72 weaponDelay Integer Weapon Speed in MS 73 ammoType Integer Ammo Types 74 rangeModifier Float This float value seems to indicate the base value for range of ranged weapons. Ranged Weapons = 100.0, Fishing Poles = 3.0 75 spell1ID Integer Spell.dbc 76 spell1TriggerID Integer Spell Trigger Types 77 spell1Charges Integer 78 spell1Cooldown Integer 79 spell1CategoryID Integer SpellCategory.dbc 80 spell1CategoryCooldown Integer 81 spell2ID Integer Spell.dbc 82 spell2TriggerID Integer Spell Trigger Types 83 spell2Charges Integer 84 spell2Cooldown Integer 85 spell2CategoryID Integer SpellCategory.dbc 86 spell2CategoryCooldown Integer 87 spell3ID Integer Spell.dbc 88 spell3TriggerID Integer Spell Trigger Types 89 spell3Charges Integer 90 spell3Cooldown Integer 91 spell3CategoryID Integer SpellCategory.dbc 92 spell3CategoryCooldown Integer 93 spell4ID Integer Spell.dbc 94 spell4TriggerID Integer Spell Trigger Types 95 spell4Charges Integer 96 spell4Cooldown Integer 97 spell4CategoryID Integer SpellCategory.dbc 98 spell4CategoryCooldown Integer 99 spell5ID Integer Spell.dbc 100 spell5TriggerID Integer Spell Trigger Types 101 spell5Charges Integer 102 spell5Cooldown Integer 103 spell5CategoryID Integer SpellCategory.dbc 104 spell5CategoryCooldown Integer 105 bondID Integer Bond Types 106 description String 107 bookTextID Integer ID of book text, found in PageTextCache.wdb 108 bookPages Integer This appears to be the number of pages in said book 109 bookStationaryID Integer PageTextMaterial.dbc 110 beginQuestID Integer QuestCache.wdb - The quest this item begins 111 lockPickTalent Integer For locked items, this is the skill needed to pick it. 112 materialID Integer Material.dbc 113 sheathID Integer Sheath Types The sheath position of the weapon on the character. 114 randompropertyID Integer value appears only on items with randomproperties, but it's unknown how to use it 115 randompropertyID2? Integer This is a complete guess, but it might have something to do with extra properties 116 blockValue Integer The Block this item yields, for shields 117 itemSetID Integer ItemSet.dbc 118 durabilityValue Integer Item Max Durability 119 itemAreaID Integer AreaTable.dbc 120 itemMapID Integer Map.dbc 121 bagFamily Integer Special Bag Types *bitmask* itembagfamily.dbc 122 iRefID_TotemCategory Integer Reference to which tools this item acts as 123 socketColor_1 Integer Color of socket 1 124 Unknown Integer 125 socketColor_2 Integer Color of socket 2 126 Unknown Integer 127 socketColor_3 Integer Color of socket 3 128 Unknown Integer 129 iRefID_SpellItemEnchantment Integer Socket Bonus 130 iRefID_GemProperties Integer Properties of the gem 131 iRefID_ItemExtendedCost Integer Arena "honor" cost 132 iRefID_ItemCondExtCosts Integer Reference to ItemCondExtCosts's second column 133 disenchantSkillLevel Integer Required enchanting level, to disenchant the item 134 armorDamageModifier Float Shows the added armor (item class 4) or weapon damage (item class 2) for which item points are spend. Can also be negative as seen for caster weapons (damage subtracted, to gain points to spend on caster stats).
Armor pieces with a non-zero value, will list the armor value in a green color on the ingame tooltip.
For (0.5.3.3368) client version
Column Field Type 1 Class Integer 2 Subclass Integer 3 DisplayName String[4] 4 DisplayInfoID Integer 5 OverallQualityID Integer 6 Flags Integer 7 BuyPrice Integer 8 SellPrice Integer 9 InventoryType Integer 10 AllowableClass Integer 11 AllowableRace Integer 12 ItemLevel Integer 13 RequiredLevel Integer 14 RequiredSkill Integer 15 RequiredSkillRank Integer 16 MaxCount Integer 17 Stackable Integer 18 ContainerSlots Integer 19 BonusStat Integer[10] 20 BonusAmount Integer[10] 21 MinDamage Integer[5] 22 MaxDamage Integer[5] 23 DamageType Integer[5] 24 Resistances Integer[6] 25 Delay Integer 26 AmmunitionType Integer 27 MaxDurability Integer 28 SpellID Integer[5] 29 SpellTrigger Integer[5] 30 SpellCharges Integer[5] 31 SpellCooldown Integer[5] 32 SpellCategory Integer[5] 33 SpellCategoryCooldown Integer[5] 34 Bonding Integer 35 Description String 36 PageText Integer 37 LanguageID Integer 38 PageMaterial Integer 39 StartQuestID Integer 40 LockID Integer 41 Material Integer 42 SheatheType Integer