From 9075de0ff5cf803b10a1c461d97ec2ef61e9ec61 Mon Sep 17 00:00:00 2001 From: Walter Pagani Date: Wed, 6 Jan 2021 06:20:05 -0300 Subject: docs: converting from HTML to Markdown part #2 (#330) --- docs/TotemCategory.md | 244 ++---- docs/character_inventory.md | 216 +----- docs/character_reputation.md | 143 +--- docs/disables.md | 144 +--- docs/item_sparse.md | 1508 ++++++++---------------------------- docs/npc_spellclick_spells.md | 111 +-- docs/playercreateinfo_action.md | 123 +-- docs/quest_poi_points.md | 163 +--- docs/vehicle_accessory.md | 177 +---- docs/vehicle_template_accessory.md | 177 +---- 10 files changed, 552 insertions(+), 2454 deletions(-) diff --git a/docs/TotemCategory.md b/docs/TotemCategory.md index cd83966..c2412db 100644 --- a/docs/TotemCategory.md +++ b/docs/TotemCategory.md @@ -1,207 +1,63 @@ # TotemCategory -<noinclude>| `Back-to:DBC` -<big>**TotemCategory.dbc**</big> - +**TotemCategory.dbc** **Version is : 3.3.5a** ## Structure - ------ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column
Field
Type
Notes
1
ID
Integer
 
2-18
sRefName
String + Loc
Includes all kinds of component things.. not just totems
19
Category
Integer
Which category the tool belongs to (1 = totems, 3 = enchanting rods etc)
20
CategoryBits
BitMask
Which tools in the category the tool can be used as. For instance for totems:
-
    -
  • bit 0 = earth
    • -
  • bit 1 = air
    • -
  • bit 2 = fire
    • -
  • bit 3 = water
    • -
  • "Master Totem" has the bitmask 1111b, meaning it can be used instead of all four normal totems.
    • -
+| Column | Field | Type | Notes | +|--------|--------------|--------------|--------------------------------------------------------------------------| +| 1 | ID | Integer | | +| 2-18 | sRefName | String + Loc | Includes all kinds of component things.. not just totems | +| 19 | Category | Integer | Which category the tool belongs to (1 = totems, 3 = enchanting rods etc) | +| 20 | CategoryBits | BitMask | Which tools in the category the tool can be used as. | -## **Content** +### For instance for totems: -</noinclude> +| Bit | Description | +|-----|-------------| +| 0 | earth | +| 1 | air | +| 2 | fire | +| 3 | water | - ---- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

ID

Name

1

Skinning Knife (OLD)

2

Earth Totem

3

Air Totem

4

Fire Totem

5

Water Totem

6

Runed Copper Rod

7

Runed Silver Rod

8

Runed Golden Rod

9

Runed Truesilver Rod

10

Runed Arcanite Rod

11

Mining Pick (OLD)

12

Philosopher's Stone

13

Blacksmith Hammer (OLD)

14

Arclight Spanner

15

Gyromatic Micro-Adjustor

21

Master Totem

41

Runed Fel Iron Rod

62

Runed Adamantite Rod

63

Runed Eternium Rod

81

Hollow Quill

101

Runed Azurite Rod

121

Virtuoso Inking Set

141

Drums

161

Gnomish Army Knife

162

Blacksmith Hammer

165

Mining Pick

166

Skinning Knife

167

Hammer Pick

168

Bladed Pickaxe

169

Flint and Tinder

189

Runed Cobalt Rod

190

Runed Titanium Rod

+Master Totem has the bitmask 1111b, meaning it can be used instead of all four normal totems. +## **Content** +| ID | Name | +|-----|--------------------------| +| 1 | Skinning Knife (OLD) | +| 2 | Earth Totem | +| 3 | Air Totem | +| 4 | Fire Totem | +| 5 | Water Totem | +| 6 | Runed Copper Rod | +| 7 | Runed Silver Rod | +| 8 | Runed Golden Rod | +| 9 | Runed Truesilver Rod | +| 10 | Runed Arcanite Rod | +| 11 | Mining Pick (OLD) | +| 12 | Philosopher's Stone | +| 13 | Blacksmith Hammer (OLD) | +| 14 | Arclight Spanner | +| 15 | Gyromatic Micro-Adjustor | +| 21 | Master Totem | +| 41 | Runed Fel Iron Rod | +| 62 | Runed Adamantite Rod | +| 63 | Runed Eternium Rod | +| 81 | Hollow Quill | +| 101 | Runed Azurite Rod | +| 121 | Virtuoso Inking Set | +| 141 | Drums | +| 161 | Gnomish Army Knife | +| 162 | Blacksmith Hammer | +| 165 | Mining Pick | +| 166 | Skinning Knife | +| 167 | Hammer Pick | +| 168 | Bladed Pickaxe | +| 169 | Flint and Tinder | +| 189 | Runed Cobalt Rod | +| 190 | Runed Titanium Rod | diff --git a/docs/character_inventory.md b/docs/character_inventory.md index 1636e62..8c901cf 100644 --- a/docs/character_inventory.md +++ b/docs/character_inventory.md @@ -8,70 +8,17 @@ Contains all the character inventory data, including the bank data. **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

Unique

NO

0

 

Global Unique Identifier

bag

int(10)

unsigned

Unique

NO

0

 

 

slot

tinyint(3)

unsigned

Unique

NO

0

 

 

item

int(10)

unsigned

PRI

NO

0

 

Item Global Unique Identifier

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-----------|------------|------------|--------|------|---------|-------|-------------------------------| +| [guid][1] | int(10) | unsigned | Unique | NO | 0 | | Global Unique Identifier | +| [bag][2] | int(10) | unsigned | Unique | NO | 0 | | | +| [slot][3] | tinyint(3) | unsigned | Unique | NO | 0 | | | +| [item][4] | int(10) | unsigned | PRI | NO | 0 | | Item Global Unique Identifier | + +[1]: #guid +[2]: #bag +[3]: #slot +[4]: #item **Description of the fields** @@ -89,120 +36,33 @@ If the bag field is non-zero, then the slot is the slot in the bag where the ite If the bag field is zero, then the slot has a range of 0 to 130 and the value stands for the following: - ---- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Slot #

Value

0

Head

1

Neck

2

Shoulders

3

Body

4

Chest

5

Waist

6

Legs

7

Feet

8

Wrists

9

Hands

10

Finger 1

11

Finger 2

12

Trinket 1

13

Trinket 2

14

Back

15

Main Hand

16

Off Hand

17

Ranged

18

Tabard

19-22

Equipped Bags

23-38

Main Backpack

39-66

Main Bank

67-73

Bank Bags

86-117

Keys in Keyring

118-135

Currencies (Emblems,badges,marks etc.)

+| Slot | Value | +|---------|----------------------------------------| +| 0 | Head | +| 1 | Neck | +| 2 | Shoulders | +| 3 | Body | +| 4 | Chest | +| 5 | Waist | +| 6 | Legs | +| 7 | Feet | +| 8 | Wrists | +| 9 | Hands | +| 10 | Finger 1 | +| 11 | Finger 2 | +| 12 | Trinket 1 | +| 13 | Trinket 2 | +| 14 | Back | +| 15 | Main Hand | +| 16 | Off Hand | +| 17 | Ranged | +| 18 | Tabard | +| 19-22 | Equipped Bags | +| 23-38 | Main Backpack | +| 39-66 | Main Bank | +| 67-73 | Bank Bags | +| 86-117 | Keys in Keyring | +| 118-135 | Currencies (Emblems,badges,marks etc.) | ### item diff --git a/docs/character_reputation.md b/docs/character_reputation.md index a111da5..b049de4 100644 --- a/docs/character_reputation.md +++ b/docs/character_reputation.md @@ -8,70 +8,17 @@ This table holds the reputation information for each character. **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

PRI

NO

0

 

Global Unique Identifier

faction

smallint(5)

unsigned

PRI

NO

0

 

 

standing

int(11)

signed

 

NO

0

 

 

flags

smallint(5)

unsigned

 

NO

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|---------------|-------------|------------|-----|------|---------|-------|--------------------------| +| [guid][1] | int(10) | unsigned | PRI | NO | 0 | | Global Unique Identifier | +| [faction][2] | smallint(5) | unsigned | PRI | NO | 0 | | | +| [standing][3] | int(11) | signed | | NO | 0 | | | +| [flags][4] | smallint(5) | unsigned | | NO | 0 | | | + +[1]: #guid +[2]: #faction +[3]: #standing +[4]: #flags **Description of the fields** @@ -91,61 +38,13 @@ The current reputation value that the character has. This field is a bitmask containing flags that apply to the faction and how it's displayed to the character. Just like any flag field, you can combine flags by adding them together. If this field is 0, then it is not shown in the reputation list in-game. - ----- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Flag

Name

Comments

1

FACTION_FLAG_VISIBLE

Displayed in the reputation tab

2

FACTION_FLAG_AT_WAR

Active when the player sets the at war checkbox

4

FACTION_FLAG_HIDDEN

Hidden faction from reputation pane in client

8

FACTION_FLAG_INVISIBLE_FORCED

Always overwrites FACTION_FLAG_VISIBLE and hide faction in rep.list

16

FACTION_FLAG_PEACE_FORCED

Always overwrites FACTION_FLAG_AT_WAR

32

FACTION_FLAG_INACTIVE

 

64

FACTION_FLAG_RIVAL

Flag for the two competing outland factions

128

FACTION_FLAG_SPECIAL

Horde and alliance home cities and their northrend allies have this flag

- - +| Flag | Name | Comments | +|------|-------------------------------|--------------------------------------------------------------------------| +| 1 | FACTION_FLAG_VISIBLE | Displayed in the reputation tab | +| 2 | FACTION_FLAG_AT_WAR | Active when the player sets the at war checkbox | +| 4 | FACTION_FLAG_HIDDEN | Hidden faction from reputation pane in client | +| 8 | FACTION_FLAG_INVISIBLE_FORCED | Always overwrites FACTION_FLAG_VISIBLE and hide faction in rep.list | +| 16 | FACTION_FLAG_PEACE_FORCED | Always overwrites FACTION_FLAG_AT_WAR | +| 32 | FACTION_FLAG_INACTIVE | | +| 64 | FACTION_FLAG_RIVAL | Flag for the two competing outland factions | +| 128 | FACTION_FLAG_SPECIAL | Horde and alliance home cities and their northrend allies have this flag | diff --git a/docs/disables.md b/docs/disables.md index 3c1b0ae..ca0fd81 100644 --- a/docs/disables.md +++ b/docs/disables.md @@ -8,99 +8,21 @@ This table is used to disable dungeons/bgs/spells/etc. **Structure** - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

sourceType

int(10)

unsigned

PRI

NO

NULL


-


-

entry

int(10)

unsigned

PRI

NO

NULL


-


-

flags

tinyint(3)

unsigned


-

NO

0


-


-

params_0

varchar(255)


-


-

NO

"


-


-

params_1

varchar(255)


-


-

NO

"


-


-

comment

varchar(255)


-


-

NO

"


-


-

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-----------------|--------------|------------|-----|------|---------|-------|---------| +| [sourceType][1] | int(10) | unsigned | PRI | NO | NULL | | | +| [entry][2] | int(10) | unsigned | PRI | NO | NULL | | | +| [flags][3] | tinyint(3) | unsigned | | NO | 0 | | | +| [params_0][4] | varchar(255) | | | NO | | | | +| [params_1][5] | varchar(255) | | | NO | | | | +| [comment][6] | varchar(255) | | | NO | | | | + +[1]: #sourcetype +[2]: #entry +[3]: #flags +[4]: #params_0 +[5]: #params_1 +[6]: #comment **Description of the fields** @@ -145,36 +67,12 @@ This will disable spell Moonfire (8921) for players in maps 571,1 and area 1519. Specifies what type of map is disabled (5man/10man/heroic/etc). - ---- - - - - - - - - - - - - - - - - - - - - - - - - -

Value

Type

1

DUNGEON_STATUSFLAG_NORMAL OR RAID_STATUSFLAG_10MAN_NORMAL

2

DUNGEON_STATUSFLAG_HEROIC OR RAID_STATUSFLAG_25MAN_NORMAL

4

RAID_STATUSFLAG_10MAN_HEROIC

8

RAID_STATUSFLAG_25MAN_HEROIC

+| Value | Type | +|-------|-------------------------------------------------------------| +| 1 | DUNGEON_STATUS_FLAG_NORMAL OR RAID_STATUS_FLAG_10MAN_NORMAL | +| 2 | DUNGEON_STATUS_FLAG_HEROIC OR RAID_STATUS_FLAG_25MAN_NORMAL | +| 4 | RAID_STATUS_FLAG_10MAN_HEROIC | +| 8 | RAID_STATUS_FLAG_25MAN_HEROIC | The value is a bitmask of VALID modes for the specific map, 15 is as such NOT a valid mask on certain maps, only those actually found possible for the respective map. diff --git a/docs/item_sparse.md b/docs/item_sparse.md index e3814e0..25c648d 100644 --- a/docs/item_sparse.md +++ b/docs/item_sparse.md @@ -6,73 +6,70 @@ This table holds information on every applied item hotfix and can overwrite existing items within the game. Together with item, item\_modified\_appearance and item\_modified\_appearance they present the means to hotfix an item. -  - **Structure** -| | | | | | | | | -|---------------------------------------------------------------------------|-------------|----------------|---------|----------|-------------|-----------|--------------------------| -| **Field** | **Type** | **Attributes** | **Key** | **Null** | **Default** | **Extra** | **Comment** | -| [ID](#item_sparse-ID) | int(10) | unsigned | PRI | NO | 0 |   |   | -| [Quality](#item_sparse-Quality) | int(10) | unsigned |   | NO | 0 |   |   | -| [Flags](#item_sparse-Flags) | int(10) | unsigned |   | NO | 0 |   |   | -| [Unk1](#item_sparse-Unk1) | float | signed |   | NO | 0 |   |   | -| [Unk2](#item_sparse-Unk2) | float | signed |   | NO | 0 |   |   | -| [BuyCount](#item_sparse-BuyCount) | int(10) | unsigned |   | NO | 0 |   |   | -| [BuyPrice](#item_sparse-BuyPrice) | int(10) | unsigned |   | NO | 0 |   |   | -| [SellPrice](#item_sparse-SellPrice) | int(10) | unsigned |   | NO | 0 |   |   | -| [InventoryType](#item_sparse-InventoryType) | int(10) | unsigned |   | NO | 0 |   |   | -| [AllowableClass](#item_sparse-AllowableClass) | int(11) | signed |   | NO | 0 |   |   | -| [AllowableRace](#item_sparse-AllowableRace) | int(11) | signed |   | NO | 0 |   |   | -| [ItemLevel](#item_sparse-ItemLevel) | int(10) | unsigned |   | NO | 0 |   |   | -| [RequiredLevel](#item_sparse-RequiredLevel) | int(10) | signed |   | NO | 0 |   |   | -| [RequiredSkill](#item_sparse-RequiredSkill) | int(10) | unsigned |   | NO | 0 |   |   | -| [RequiredSkillRank](#item_sparse-RequiredSkillRank) | int(10) | unsigned |   | NO | 0 |   |   | -| [RequiredSpell](#item_sparse-RequiredSpell) | int(10) | unsigned |   | NO | 0 |   |   | -| [RequiredHonorRank](#item_sparse-RequiredHonorRank) | int(10) | unsigned |   | NO | 0 |   |   | -| [RequiredCityRank](#item_sparse-RequiredCityRank) | int(10) | unsigned |   | NO | 0 |   |   | -| [RequiredReputationFaction](#item_sparse-RequiredReputationFaction) | int(10) | unsigned |   | NO | 0 |   |   | -| [RequiredReputationRank](#item_sparse-RequiredReputationRank) | int(10) | unsigned |   | NO | 0 |   |   | -| [MaxCount](#item_sparse-MaxCount) | int(10) | unsigned |   | NO | 0 |   |   | -| [Stackable](#item_sparse-Stackable) | int(10) | unsigned |   | NO | 0 |   |   | -| [ContainerSlots](#item_sparse-ContainerSlots) | int(10) | unsigned |   | NO | 0 |   |   | -| [ItemStatType](#item_sparse-ItemStatType) | int(11) | signed |   | NO | 0 |   |   | -| [ItemStatValue](#item_sparse-ItemStatValue) | int(11) | signed |   | NO | 0 |   |   | -| [ItemStatAllocation](#item_sparse-ItemStatAllocation) | int(11) | signed |   | NO | 0 |   |   | -| [ItemStatSocketCostMultiplier](#item_sparse-ItemStatSocketCostMultiplier) | float | signed |   | NO | 0 |   |   | -| [ScalingStatDistribution](#item_sparse-ScalingStatDistribution) | int(10) | unsigned |   | NO | 0 |   |   | -| [DamageType](#item_sparse-DamageType) | int(10) | unsigned |   | NO | 0 |   |   | -| [Delay](#item_sparse-Delay) | int(10) | unsigned |   | NO | 0 |   |   | -| [RangedModRange](#item_sparse-RangedModRange) | float | signed |   | NO | 0 |   |   | -| [Bonding](#item_sparse-Bonding) | int(10) | unsigned |   | NO | 0 |   |   | -| [Name](#item_sparse-Name) | TEXT |   |   | YES |   |   |   | -| [Description](#item_sparse-Description) | TEXT |   |   | YES |   |   |   | -| [PageText](#item_sparse-PageText) | int(10) | unsigned |   | NO | 0 |   |   | -| [LanguageID](#item_sparse-LanguageID) | int(10) | unsigned |   | NO | 0 |   |   | -| [PageMaterial](#item_sparse-PageMaterial) | int(10) | unsigned |   | NO | 0 |   |   | -| [StartQuest](#item_sparse-StartQuest) | int(10) | unsigned |   | NO | 0 |   |   | -| [LockID](#item_sparse-LockID) | int(10) | unsigned |   | NO | 0 |   |   | -| [Material](#item_sparse-Material) | int(11) | signed |   | NO | 0 |   |   | -| [Sheath](#item_sparse-Sheath) | int(10) | unsigned |   | NO | 0 |   |   | -| [RandomProperty](#item_sparse-RandomProperty) | int(10) | unsigned |   | NO | 0 |   |   | -| [RandomSuffix](#item_sparse-RandomSuffix) | int(10) | unsigned |   | NO | 0 |   |   | -| [ItemSet](#item_sparse-ItemSet) | int(10) | unsigned |   | NO | 0 |   |   | -| [Area](#item_sparse-Area) | int(10) | unsigned |   | NO | 0 |   |   | -| [Map](#item_sparse-Map) | int(10) | unsigned |   | NO | 0 |   |   | -| [BagFamily](#item_sparse-BagFamily) | int(10) | unsigned |   | NO | 0 |   |   | -| [TotemCategory](#item_sparse-TotemCategory) | int(10) | unsigned |   | NO | 0 |   |   | -| [SocketColor](item_sparse) | int(10) | unsigned |   | NO | 0 |   | SocketColor1 can be NULL | -| [SocketBonus](#item_sparse-SocketBonus) | int(10) | unsigned |   | NO | 0 |   |   | -| [GemProperties](#item_sparse-GemProperties) | int(10) | unsigned |   | NO | 0 |   |   | -| [ArmorDamageModifier](#item_sparse-ArmorDamageModifier) | float | signed |   | NO | 0 |   |   | -| [Duration](#item_sparse-Duration) | int(10) | unsigned |   | NO | 0 |   |   | -| [ItemLimitCategory](#item_sparse-ItemLimitCategory) | int(10) | unsigned |   | NO | 0 |   |   | -| [HolidayID](#item_sparse-HolidayID) | int(10) | unsigned |   | NO | 0 |   |   | -| [StatScalingFactor](#item_sparse-StatScalingFactor) | float | signed |   | NO | 0 |   |   | -| [CurrencySubstitutionID](#item_sparse-CurrencySubstitutionID) | int(10) | unsigned |   | NO | 0 |   |   | -| [CurrencySubstitutionCount](#item_sparse-CurrencySubstitutionCount) | int(10) | unsigned |   | NO | 0 |   |   | -| [ItemNameDescriptionID](#item_sparse-ItemNameDescriptionID) | int(10) | unsigned |   | NO | 0 |   |   | -| [VerifiedBuild](#item_sparse-VerifiedBuild) | smallint(6) | signed |   | NO | 0 |   |   | +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|---------------------------------------------------------------------------|-------------|------------|-----|------|---------|-------|--------------------------| +| [ID](#item_sparse-ID) | int(10) | unsigned | PRI | NO | 0 | | | +| [Quality](#item_sparse-Quality) | int(10) | unsigned | | NO | 0 | | | +| [Flags](#item_sparse-Flags) | int(10) | unsigned | | NO | 0 | | | +| [Unk1](#item_sparse-Unk1) | float | signed | | NO | 0 | | | +| [Unk2](#item_sparse-Unk2) | float | signed | | NO | 0 | | | +| [BuyCount](#item_sparse-BuyCount) | int(10) | unsigned | | NO | 0 | | | +| [BuyPrice](#item_sparse-BuyPrice) | int(10) | unsigned | | NO | 0 | | | +| [SellPrice](#item_sparse-SellPrice) | int(10) | unsigned | | NO | 0 | | | +| [InventoryType](#item_sparse-InventoryType) | int(10) | unsigned | | NO | 0 | | | +| [AllowableClass](#item_sparse-AllowableClass) | int(11) | signed | | NO | 0 | | | +| [AllowableRace](#item_sparse-AllowableRace) | int(11) | signed | | NO | 0 | | | +| [ItemLevel](#item_sparse-ItemLevel) | int(10) | unsigned | | NO | 0 | | | +| [RequiredLevel](#item_sparse-RequiredLevel) | int(10) | signed | | NO | 0 | | | +| [RequiredSkill](#item_sparse-RequiredSkill) | int(10) | unsigned | | NO | 0 | | | +| [RequiredSkillRank](#item_sparse-RequiredSkillRank) | int(10) | unsigned | | NO | 0 | | | +| [RequiredSpell](#item_sparse-RequiredSpell) | int(10) | unsigned | | NO | 0 | | | +| [RequiredHonorRank](#item_sparse-RequiredHonorRank) | int(10) | unsigned | | NO | 0 | | | +| [RequiredCityRank](#item_sparse-RequiredCityRank) | int(10) | unsigned | | NO | 0 | | | +| [RequiredReputationFaction](#item_sparse-RequiredReputationFaction) | int(10) | unsigned | | NO | 0 | | | +| [RequiredReputationRank](#item_sparse-RequiredReputationRank) | int(10) | unsigned | | NO | 0 | | | +| [MaxCount](#item_sparse-MaxCount) | int(10) | unsigned | | NO | 0 | | | +| [Stackable](#item_sparse-Stackable) | int(10) | unsigned | | NO | 0 | | | +| [ContainerSlots](#item_sparse-ContainerSlots) | int(10) | unsigned | | NO | 0 | | | +| [ItemStatType](#item_sparse-ItemStatType) | int(11) | signed | | NO | 0 | | | +| [ItemStatValue](#item_sparse-ItemStatValue) | int(11) | signed | | NO | 0 | | | +| [ItemStatAllocation](#item_sparse-ItemStatAllocation) | int(11) | signed | | NO | 0 | | | +| [ItemStatSocketCostMultiplier](#item_sparse-ItemStatSocketCostMultiplier) | float | signed | | NO | 0 | | | +| [ScalingStatDistribution](#item_sparse-ScalingStatDistribution) | int(10) | unsigned | | NO | 0 | | | +| [DamageType](#item_sparse-DamageType) | int(10) | unsigned | | NO | 0 | | | +| [Delay](#item_sparse-Delay) | int(10) | unsigned | | NO | 0 | | | +| [RangedModRange](#item_sparse-RangedModRange) | float | signed | | NO | 0 | | | +| [Bonding](#item_sparse-Bonding) | int(10) | unsigned | | NO | 0 | | | +| [Name](#item_sparse-Name) | TEXT | | | YES | | | | +| [Description](#item_sparse-Description) | TEXT | | | YES | | | | +| [PageText](#item_sparse-PageText) | int(10) | unsigned | | NO | 0 | | | +| [LanguageID](#item_sparse-LanguageID) | int(10) | unsigned | | NO | 0 | | | +| [PageMaterial](#item_sparse-PageMaterial) | int(10) | unsigned | | NO | 0 | | | +| [StartQuest](#item_sparse-StartQuest) | int(10) | unsigned | | NO | 0 | | | +| [LockID](#item_sparse-LockID) | int(10) | unsigned | | NO | 0 | | | +| [Material](#item_sparse-Material) | int(11) | signed | | NO | 0 | | | +| [Sheath](#item_sparse-Sheath) | int(10) | unsigned | | NO | 0 | | | +| [RandomProperty](#item_sparse-RandomProperty) | int(10) | unsigned | | NO | 0 | | | +| [RandomSuffix](#item_sparse-RandomSuffix) | int(10) | unsigned | | NO | 0 | | | +| [ItemSet](#item_sparse-ItemSet) | int(10) | unsigned | | NO | 0 | | | +| [Area](#item_sparse-Area) | int(10) | unsigned | | NO | 0 | | | +| [Map](#item_sparse-Map) | int(10) | unsigned | | NO | 0 | | | +| [BagFamily](#item_sparse-BagFamily) | int(10) | unsigned | | NO | 0 | | | +| [TotemCategory](#item_sparse-TotemCategory) | int(10) | unsigned | | NO | 0 | | | +| [SocketColor](item_sparse) | int(10) | unsigned | | NO | 0 | | SocketColor1 can be NULL | +| [SocketBonus](#item_sparse-SocketBonus) | int(10) | unsigned | | NO | 0 | | | +| [GemProperties](#item_sparse-GemProperties) | int(10) | unsigned | | NO | 0 | | | +| [ArmorDamageModifier](#item_sparse-ArmorDamageModifier) | float | signed | | NO | 0 | | | +| [Duration](#item_sparse-Duration) | int(10) | unsigned | | NO | 0 | | | +| [ItemLimitCategory](#item_sparse-ItemLimitCategory) | int(10) | unsigned | | NO | 0 | | | +| [HolidayID](#item_sparse-HolidayID) | int(10) | unsigned | | NO | 0 | | | +| [StatScalingFactor](#item_sparse-StatScalingFactor) | float | signed | | NO | 0 | | | +| [CurrencySubstitutionID](#item_sparse-CurrencySubstitutionID) | int(10) | unsigned | | NO | 0 | | | +| [CurrencySubstitutionCount](#item_sparse-CurrencySubstitutionCount) | int(10) | unsigned | | NO | 0 | | | +| [ItemNameDescriptionID](#item_sparse-ItemNameDescriptionID) | int(10) | unsigned | | NO | 0 | | | +| [VerifiedBuild](#item_sparse-VerifiedBuild) | smallint(6) | signed | | NO | 0 | | | **Description of the fields** @@ -84,67 +81,17 @@ The unique ID of the item.Choosing an existing item ID will overwrite that item The quality of the item. To use the Bind to Battle.net account quality, the item must have its flags set to 134221824. - ----- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

ID

Color

Quality

0

Grey

Poor

1

White

Common

2

Green

Uncommon

3

Blue

Rare

4

Purple

Epic

5

Orange

Legendary

6

Red

Artifact

7

Gold

Heirloom / Bind to Battle.net account

8AquaWoW Token
+| ID | Color | Quality | +|----|--------|---------------------------------------| +| 0 | Grey | Poor | +| 1 | White | Common | +| 2 | Green | Uncommon | +| 3 | Blue | Rare | +| 4 | Purple | Epic | +| 5 | Orange | Legendary | +| 6 | Red | Artifact | +| 7 | Gold | Heirloom / Bind to Battle.net account | +| 8 | Aqua | WoW Token | ### Flags @@ -152,182 +99,40 @@ Flags1 to Flags3 are bitmask fields that contains flags that the item has on it.  **Note:** The item system for 6xx  gives more than one flag bitmask field and each of these can be populated individually. - ----- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Flag

 

Comments

1

0x01

UNK1

2

0x02

Conjured item

4

0x04

Openable (can be opened by right-click)

8

0x08

Makes green "Heroic" text appear on item

16

0x010

Deprecated Item

32

0x020

Item can not be destroyed, except by using spell (item can be reagent for spell)

64

0x040

UNK2

1280x080No default 30 seconds cooldown when equipped
2560x0100UNK3

512

0x0200

Wrapper : Item can wrap other items

1024

0x0400

UNK4

2048

0x0800

Item is party loot and can be looted by all

4096

0x01000

Item is refundable

8192

0x02000

Charter (Arena or Guild)

163840x04000UNK5 // comment in code : Only readable items have this (but not all)

32768

0x08000

UNK6

655360x010000UNK7
1310720x020000UNK8
2621440x040000

Item can be prospected

524288

0x080000

Unique equipped (player can only have one equipped at the same time)

10485760x0100000UNK9
20971520x0200000Item can be used during arena match

4194304

0x0400000

Throwable (for tooltip ingame)

8388608

0x0800000

Item can be used in shapeshift forms

167772160x01000000 UNK10
544320x02000000 Profession recipes: can only be looted if you meet requirements and don't already know it
671088640x04000000 Item cannot be used in arena

134217728

0x08000000

Bind to Account (Also needs Quality = 7 set)

268435456

0x010000000

Spell is cast with triggered flag

536870912

0x020000000

Millable

10737418240x040000000 UNK11

2147483648

0x080000000

Bind on Pickup tradeable8192

+| Flag | | Comments | +|------------|-------------|--------------------------------------------------------------------------------------------| +| 1 | 0x01 | UNK1 | +| 2 | 0x02 | Conjured item | +| 4 | 0x04 | Openable (can be opened by right-click) | +| 8 | 0x08 | Makes green "Heroic" text appear on item | +| 16 | 0x010 | Deprecated Item | +| 32 | 0x020 | Item can not be destroyed, except by using spell (item can be reagent for spell) | +| 64 | 0x040 | UNK2 | +| 128 | 0x080 | No default 30 seconds cooldown when equipped | +| 256 | 0x0100 | UNK3 | +| 512 | 0x0200 | Wrapper : Item can wrap other items | +| 1024 | 0x0400 | UNK4 | +| 2048 | 0x0800 | Item is party loot and can be looted by all | +| 4096 | 0x01000 | Item is refundable | +| 8192 | 0x02000 | Charter (Arena or Guild) | +| 16384 | 0x04000 | UNK5 // comment in code : Only readable items have this (but not all) | +| 32768 | 0x08000 | UNK6 | +| 65536 | 0x010000 | UNK7 | +| 131072 | 0x020000 | UNK8 | +| 262144 | 0x040000 | Item can be prospected | +| 524288 | 0x080000 | Unique equipped (player can only have one equipped at the same time) | +| 1048576 | 0x0100000 | UNK9 | +| 2097152 | 0x0200000 | Item can be used during arena match | +| 4194304 | 0x0400000 | Throwable (for tooltip ingame) | +| 8388608 | 0x0800000 | Item can be used in shapeshift forms | +| 16777216 | 0x01000000 | UNK10 | +| 54432 | 0x02000000 | Profession recipes: can only be looted if you meet requirements and don't already know it | +| 67108864 | 0x04000000 | Item cannot be used in arena | +| 134217728 | 0x08000000 | Bind to Account (Also needs Quality = 7 set) | +| 268435456 | 0x010000000 | Spell is cast with triggered flag | +| 536870912 | 0x020000000 | Millable | +| 1073741824 | 0x040000000 | UNK11 | +| 2147483648 | 0x080000000 | Bind on Pickup tradeable8192 | ### Unk1 @@ -353,114 +158,23 @@ The price that the vendor will pay you for the item when you sell it and if it i In what slot the item can be equipped. - ------ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

ID

Slot Name

ID

Slot Name

0

Non equipable

15

Ranged (Bows)

1

Head

16

Back

2

Neck

17

Two-Hand

3

Shoulder

18

Bag

4

Shirt

19

Tabard

5

Chest

20

Robe

6

Waist

21

Main hand

7

Legs

22

Off hand

8

Feet

23

Holdable (Tome)

9

Wrists

24

Ammo

10

Hands

25

Thrown

11

Finger

26

Ranged right (Wands, Guns)

12

Trinket

27

Quiver

13

Weapon

28

Relic

14

Shield

 

 

+| ID | Slot Name | ID | Slot Name | +|----|---------------|----|----------------------------| +| 0 | Non equipable | 15 | Ranged (Bows) | +| 1 | Head | 16 | Back | +| 2 | Neck | 17 | Two-Hand | +| 3 | Shoulder | 18 | Bag | +| 4 | Shirt | 19 | Tabard | +| 5 | Chest | 20 | Robe | +| 6 | Waist | 21 | Main hand | +| 7 | Legs | 22 | Off hand | +| 8 | Feet | 23 | Holdable (Tome) | +| 9 | Wrists | 24 | Ammo | +| 10 | Hands | 25 | Thrown | +| 11 | Finger | 26 | Ranged right (Wands, Guns) | +| 12 | Trinket | 27 | Quiver | +| 13 | Weapon | 28 | Relic | +| 14 | Shield | | | ### AllowableClass @@ -512,52 +226,16 @@ See the [Faction DBC file](Faction6x) for the IDs of all of the factions. The rank the player has to have with the faction from [RequiredReputationFaction](#item_sparse-RequiredReputationFaction). - ---- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

ID

Rank

0

Hated

1

Hostile

2

Unfriendly

3

Neutral

4

Friendly

5

Honored

6

Revered

7

Exalted

+| ID | Rank | +|----|------------| +| 0 | Hated | +| 1 | Hostile | +| 2 | Unfriendly | +| 3 | Neutral | +| 4 | Friendly | +| 5 | Honored | +| 6 | Revered | +| 7 | Exalted | ### MaxCount @@ -575,300 +253,78 @@ If the item is a bag, this field controls the number of slots the bag has. The type of stat to modify. A maximum of 10 stats can be set as seen by the column count. - ---- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

ID

Stat Type

0ITEM_MOD_MANA
1ITEM_MOD_HEALTH
3ITEM_MOD_AGILITY
4ITEM_MOD_STRENGTH
5ITEM_MOD_INTELLECT
6ITEM_MOD_SPIRIT
7ITEM_MOD_STAMINA
12ITEM_MOD_DEFENSE_SKILL_RATING
13ITEM_MOD_DODGE_RATING
14ITEM_MOD_PARRY_RATING
15ITEM_MOD_BLOCK_RATING
16ITEM_MOD_HIT_MELEE_RATING
17ITEM_MOD_HIT_RANGED_RATING
18ITEM_MOD_HIT_SPELL_RATING
19ITEM_MOD_CRIT_MELEE_RATING
20ITEM_MOD_CRIT_RANGED_RATING
21ITEM_MOD_CRIT_SPELL_RATING
22ITEM_MOD_HIT_TAKEN_MELEE_RATING
23ITEM_MOD_HIT_TAKEN_RANGED_RATING
24ITEM_MOD_HIT_TAKEN_SPELL_RATING
25ITEM_MOD_CRIT_TAKEN_MELEE_RATING
26ITEM_MOD_CRIT_TAKEN_RANGED_RATING
27ITEM_MOD_CRIT_TAKEN_SPELL_RATING
28ITEM_MOD_HASTE_MELEE_RATING
29ITEM_MOD_HASTE_RANGED_RATING
30ITEM_MOD_HASTE_SPELL_RATING
31ITEM_MOD_HIT_RATING
32ITEM_MOD_CRIT_RATING
33ITEM_MOD_HIT_TAKEN_RATING
34ITEM_MOD_CRIT_TAKEN_RATING
35ITEM_MOD_RESILIENCE_RATING
36ITEM_MOD_HASTE_RATING
37ITEM_MOD_EXPERTISE_RATING
38ITEM_MOD_ATTACK_POWER
39ITEM_MOD_RANGED_ATTACK_POWER
40ITEM_MOD_VERSATILITY
41ITEM_MOD_SPELL_HEALING_DONE
42ITEM_MOD_SPELL_DAMAGE_DONE
43ITEM_MOD_MANA_REGENERATION
44ITEM_MOD_ARMOR_PENETRATION_RATING
45ITEM_MOD_SPELL_POWER
46ITEM_MOD_HEALTH_REGEN
47ITEM_MOD_SPELL_PENETRATION
48ITEM_MOD_BLOCK_VALUE
49ITEM_MOD_MASTERY_RATING
50ITEM_MOD_EXTRA_ARMOR
51ITEM_MOD_FIRE_RESISTANCE
52ITEM_MOD_FROST_RESISTANCE
53ITEM_MOD_HOLY_RESISTANCE
54ITEM_MOD_SHADOW_RESISTANCE
55ITEM_MOD_NATURE_RESISTANCE
56ITEM_MOD_ARCANE_RESISTANCE
57ITEM_MOD_PVP_POWER
58ITEM_MOD_CR_AMPLIFY
59ITEM_MOD_CR_MULTISTRIKE
60ITEM_MOD_CR_READINESS
61ITEM_MOD_CR_SPEED
62ITEM_MOD_CR_LIFESTEAL
63ITEM_MOD_CR_AVOIDANCE
64ITEM_MOD_CR_STURDINESS
65ITEM_MOD_CR_UNUSED_7
66ITEM_MOD_CR_CLEAVE
67ITEM_M