TrinityCore Wiki

Appearance

item_sparse

Structure ​

FieldTypeAttributesKeyNullDefaultExtraComment
IDintunsignedPRINO0
AllowableRacebigintsignedNO0
DescriptiontextYESNULL
Display3textYESNULL
Display2textYESNULL
Display1textYESNULL
DisplaytextYESNULL
ExpansionIDintsignedNO0
DmgVariancefloatNO0
LimitCategoryintsignedNO0
DurationInInventoryintunsignedNO0
QualityModifierfloatNO0
BagFamilyintunsignedNO0
StartQuestIDintsignedNO0
LanguageIDintsignedNO0
ItemRangefloatNO0
StatPercentageOfSocket1floatNO0
StatPercentageOfSocket2floatNO0
StatPercentageOfSocket3floatNO0
StatPercentageOfSocket4floatNO0
StatPercentageOfSocket5floatNO0
StatPercentageOfSocket6floatNO0
StatPercentageOfSocket7floatNO0
StatPercentageOfSocket8floatNO0
StatPercentageOfSocket9floatNO0
StatPercentageOfSocket10floatNO0
StatPercentEditor1intsignedNO0
StatPercentEditor2intsignedNO0
StatPercentEditor3intsignedNO0
StatPercentEditor4intsignedNO0
StatPercentEditor5intsignedNO0
StatPercentEditor6intsignedNO0
StatPercentEditor7intsignedNO0
StatPercentEditor8intsignedNO0
StatPercentEditor9intsignedNO0
StatPercentEditor10intsignedNO0
StatModifierBonusStat1intsignedNO0
StatModifierBonusStat2intsignedNO0
StatModifierBonusStat3intsignedNO0
StatModifierBonusStat4intsignedNO0
StatModifierBonusStat5intsignedNO0
StatModifierBonusStat6intsignedNO0
StatModifierBonusStat7intsignedNO0
StatModifierBonusStat8intsignedNO0
StatModifierBonusStat9intsignedNO0
StatModifierBonusStat10intsignedNO0
StackableintsignedNO0
MaxCountintsignedNO0
MinReputationintsignedNO0
RequiredAbilityintunsignedNO0
SellPriceintunsignedNO0
BuyPriceintunsignedNO0
VendorStackCountintunsignedNO0
PriceVariancefloatNO0
PriceRandomValuefloatNO0
Flags1intsignedNO0
Flags2intsignedNO0
Flags3intsignedNO0
Flags4intsignedNO0
Flags5intsignedNO0
FactionRelatedintsignedNO0
ModifiedCraftingReagentItemIDintsignedNO0
ContentTuningIDintsignedNO0
PlayerLevelToItemLevelCurveIDintsignedNO0
ItemNameDescriptionIDsmallintunsignedNO0
RequiredTransmogHolidaysmallintunsignedNO0
RequiredHolidaysmallintunsignedNO0
GemPropertiessmallintunsignedNO0
SocketMatchEnchantmentIdsmallintunsignedNO0
TotemCategoryIDsmallintunsignedNO0
InstanceBoundsmallintunsignedNO0
ZoneBound1smallintunsignedNO0
ZoneBound2smallintunsignedNO0
ItemSetsmallintunsignedNO0
LockIDsmallintunsignedNO0
PageIDsmallintunsignedNO0
ItemDelaysmallintunsignedNO0
MinFactionIDsmallintunsignedNO0
RequiredSkillRanksmallintunsignedNO0
RequiredSkillsmallintunsignedNO0
ItemLevelsmallintunsignedNO0
AllowableClasssmallintsignedNO0
ArtifactIDtinyintunsignedNO0
SpellWeighttinyintunsignedNO0
SpellWeightCategorytinyintunsignedNO0
SocketType1tinyintunsignedNO0
SocketType2tinyintunsignedNO0
SocketType3tinyintunsignedNO0
SheatheTypetinyintunsignedNO0
MaterialtinyintunsignedNO0
PageMaterialIDtinyintunsignedNO0
BondingtinyintunsignedNO0
DamageDamageTypetinyintunsignedNO0
ContainerSlotstinyintunsignedNO0
RequiredPVPMedaltinyintunsignedNO0
RequiredPVPRanktinyintunsignedNO0
RequiredLeveltinyintsignedNO0
InventoryTypetinyintsignedNO0
OverallQualityIDtinyintsignedNO0
VerifiedBuildintsignedPRINO0
 

Description of fields ​

ID ​

- no description -  

AllowableRace ​

- no description -  

Description ​

- no description -  

Display3 ​

- no description -  

Display2 ​

- no description -  

Display1 ​

- no description -  

Display ​

- no description -  

ExpansionID ​

- no description -  

DmgVariance ​

- no description -  

LimitCategory ​

- no description -  

DurationInInventory ​

- no description -  

QualityModifier ​

- no description -  

BagFamily ​

- no description -  

StartQuestID ​

- no description -  

LanguageID ​

- no description -  

ItemRange ​

- no description -  

StatPercentageOfSocket1 ​

- no description -  

StatPercentageOfSocket2 ​

- no description -  

StatPercentageOfSocket3 ​

- no description -  

StatPercentageOfSocket4 ​

- no description -  

StatPercentageOfSocket5 ​

- no description -  

StatPercentageOfSocket6 ​

- no description -  

StatPercentageOfSocket7 ​

- no description -  

StatPercentageOfSocket8 ​

- no description -  

StatPercentageOfSocket9 ​

- no description -  

StatPercentageOfSocket10 ​

- no description -  

StatPercentEditor1 ​

- no description -  

StatPercentEditor2 ​

- no description -  

StatPercentEditor3 ​

- no description -  

StatPercentEditor4 ​

- no description -  

StatPercentEditor5 ​

- no description -  

StatPercentEditor6 ​

- no description -  

StatPercentEditor7 ​

- no description -  

StatPercentEditor8 ​

- no description -  

StatPercentEditor9 ​

- no description -  

StatPercentEditor10 ​

- no description -  

StatModifierBonusStat1 ​

- no description -  

StatModifierBonusStat2 ​

- no description -  

StatModifierBonusStat3 ​

- no description -  

StatModifierBonusStat4 ​

- no description -  

StatModifierBonusStat5 ​

- no description -  

StatModifierBonusStat6 ​

- no description -  

StatModifierBonusStat7 ​

- no description -  

StatModifierBonusStat8 ​

- no description -  

StatModifierBonusStat9 ​

- no description -  

StatModifierBonusStat10 ​

- no description -  

Stackable ​

- no description -  

MaxCount ​

- no description -  

MinReputation ​

- no description -  

RequiredAbility ​

- no description -  

SellPrice ​

- no description -  

BuyPrice ​

- no description -  

VendorStackCount ​

- no description -  

PriceVariance ​

- no description -  

PriceRandomValue ​

- no description -  

Flags1 ​

- no description -  

Flags2 ​

- no description -  

Flags3 ​

- no description -  

Flags4 ​

- no description -  

Flags5 ​

- no description -  

FactionRelated ​

- no description -  

ModifiedCraftingReagentItemID ​

- no description -  

ContentTuningID ​

- no description -  

PlayerLevelToItemLevelCurveID ​

- no description -  

ItemNameDescriptionID ​

- no description -  

RequiredTransmogHoliday ​

- no description -  

RequiredHoliday ​

- no description -  

GemProperties ​

- no description -  

SocketMatchEnchantmentId ​

- no description -  

TotemCategoryID ​

- no description -  

InstanceBound ​

- no description -  

ZoneBound1 ​

- no description -  

ZoneBound2 ​

- no description -  

ItemSet ​

- no description -  

LockID ​

- no description -  

PageID ​

- no description -  

ItemDelay ​

- no description -  

MinFactionID ​

- no description -  

RequiredSkillRank ​

- no description -  

RequiredSkill ​

- no description -  

ItemLevel ​

- no description -  

AllowableClass ​

- no description -  

ArtifactID ​

- no description -  

SpellWeight ​

- no description -  

SpellWeightCategory ​

- no description -  

SocketType1 ​

- no description -  

SocketType2 ​

- no description -  

SocketType3 ​

- no description -  

SheatheType ​

- no description -  

Material ​

- no description -  

PageMaterialID ​

- no description -  

Bonding ​

- no description -  

DamageDamageType ​

- no description -  

ContainerSlots ​

- no description -  

RequiredPVPMedal ​

- no description -  

RequiredPVPRank ​

- no description -  

RequiredLevel ​

- no description -  

InventoryType ​

- no description -  

OverallQualityID ​

- no description -  

VerifiedBuild ​

This field is used by the TrinityDB Team to determine whether a template has been verified from WDB files.

If value is 0 then it has not been parsed yet.

If value is above 0 then it has been parsed with WDB files from that specific client build.

If value is -1 then it is just a place holder until proper data are found on WDBs.

If value is -Client Build then it was parsed with WDB files from that specific client build and manually edited later for some special necessity.