TrinityCore Wiki

Appearance

spell_dbc

Structurally similar to the Spell.dbc file, this table holds supplemental data on spells referenced by, but missing from the Spell.dbc file.

Structure ​

FieldTypeAttributesKeyNullDefaultExtraComment
IdintunsignedPRINO
DispelintunsignedNO0
MechanicintunsignedNO0
AttributesintunsignedNO0
AttributesExintunsignedNO0
AttributesEx2intunsignedNO0
AttributesEx3intunsignedNO0
AttributesEx4intunsignedNO0
AttributesEx5intunsignedNO0
AttributesEx6intunsignedNO0
AttributesEx7intunsignedNO0
StancesintunsignedNO0
StancesNotintunsignedNO0
TargetsintunsignedNO0
CastingTimeIndexintunsignedNO1
AuraInterruptFlagsintunsignedNO0
ProcFlagsintunsignedNO0
ProcChanceintunsignedNO0
ProcChargesintunsignedNO0
MaxLevelintunsignedNO0
BaseLevelintunsignedNO0
SpellLevelintunsignedNO0
DurationIndexintunsignedNO0
RangeIndexintunsignedNO1
StackAmountintunsignedNO0
EquippedItemClassintsignedNO-1
EquippedItemSubClassMaskintsignedNO0
EquippedItemInventoryTypeMaskintsignedNO0
Effect1intunsignedNO0
Effect2intunsignedNO0
Effect3intunsignedNO0
EffectDieSides1intsignedNO0
EffectDieSides2intsignedNO0
EffectDieSides3intsignedNO0
EffectRealPointsPerLevel1floatNO0
EffectRealPointsPerLevel2floatNO0
EffectRealPointsPerLevel3floatNO0
EffectBasePoints1intsignedNO0
EffectBasePoints2intsignedNO0
EffectBasePoints3intsignedNO0
EffectMechanic1intunsignedNO0
EffectMechanic2intunsignedNO0
EffectMechanic3intunsignedNO0
EffectImplicitTargetA1intunsignedNO0
EffectImplicitTargetA2intunsignedNO0
EffectImplicitTargetA3intunsignedNO0
EffectImplicitTargetB1intunsignedNO0
EffectImplicitTargetB2intunsignedNO0
EffectImplicitTargetB3intunsignedNO0
EffectRadiusIndex1intunsignedNO0
EffectRadiusIndex2intunsignedNO0
EffectRadiusIndex3intunsignedNO0
EffectApplyAuraName1intunsignedNO0
EffectApplyAuraName2intunsignedNO0
EffectApplyAuraName3intunsignedNO0
EffectAmplitude1intsignedNO0
EffectAmplitude2intsignedNO0
EffectAmplitude3intsignedNO0
EffectMultipleValue1floatNO0
EffectMultipleValue2floatNO0
EffectMultipleValue3floatNO0
EffectItemType1intunsignedNO0
EffectItemType2intunsignedNO0
EffectItemType3intunsignedNO0
EffectMiscValue1intsignedNO0
EffectMiscValue2intsignedNO0
EffectMiscValue3intsignedNO0
EffectMiscValueB1intsignedNO0
EffectMiscValueB2intsignedNO0
EffectMiscValueB3intsignedNO0
EffectTriggerSpell1intunsignedNO0
EffectTriggerSpell2intunsignedNO0
EffectTriggerSpell3intunsignedNO0
EffectSpellClassMaskA1intunsignedNO0
EffectSpellClassMaskA2intunsignedNO0
EffectSpellClassMaskA3intunsignedNO0
EffectSpellClassMaskB1intunsignedNO0
EffectSpellClassMaskB2intunsignedNO0
EffectSpellClassMaskB3intunsignedNO0
EffectSpellClassMaskC1intunsignedNO0
EffectSpellClassMaskC2intunsignedNO0
EffectSpellClassMaskC3intunsignedNO0
SpellNamevarchar(100)YESNULL
MaxTargetLevelintunsignedNO0
SpellFamilyNameintunsignedNO0
SpellFamilyFlags1intunsignedNO0
SpellFamilyFlags2intunsignedNO0
SpellFamilyFlags3intunsignedNO0
MaxAffectedTargetsintunsignedNO0
DmgClassintunsignedNO0
PreventionTypeintunsignedNO0
DmgMultiplier1floatNO0
DmgMultiplier2floatNO0
DmgMultiplier3floatNO0
AreaGroupIdintsignedNO0
SchoolMaskintunsignedNO0
 

Description of fields ​

Id ​

- no description -  

Dispel ​

- no description -  

Mechanic ​

- no description -  

Attributes ​

- no description -  

AttributesEx ​

- no description -  

AttributesEx2 ​

- no description -  

AttributesEx3 ​

- no description -  

AttributesEx4 ​

- no description -  

AttributesEx5 ​

- no description -  

AttributesEx6 ​

- no description -  

AttributesEx7 ​

- no description -  

Stances ​

- no description -  

StancesNot ​

- no description -  

Targets ​

- no description -  

CastingTimeIndex ​

- no description -  

AuraInterruptFlags ​

- no description -  

ProcFlags ​

- no description -  

ProcChance ​

- no description -  

ProcCharges ​

- no description -  

MaxLevel ​

- no description -  

BaseLevel ​

- no description -  

SpellLevel ​

- no description -  

DurationIndex ​

- no description -  

RangeIndex ​

- no description -  

StackAmount ​

- no description -  

EquippedItemClass ​

- no description -  

EquippedItemSubClassMask ​

- no description -  

EquippedItemInventoryTypeMask ​

- no description -  

Effect1 ​

- no description -  

Effect2 ​

- no description -  

Effect3 ​

- no description -  

EffectDieSides1 ​

- no description -  

EffectDieSides2 ​

- no description -  

EffectDieSides3 ​

- no description -  

EffectRealPointsPerLevel1 ​

- no description -  

EffectRealPointsPerLevel2 ​

- no description -  

EffectRealPointsPerLevel3 ​

- no description -  

EffectBasePoints1 ​

- no description -  

EffectBasePoints2 ​

- no description -  

EffectBasePoints3 ​

- no description -  

EffectMechanic1 ​

- no description -  

EffectMechanic2 ​

- no description -  

EffectMechanic3 ​

- no description -  

EffectImplicitTargetA1 ​

- no description -  

EffectImplicitTargetA2 ​

- no description -  

EffectImplicitTargetA3 ​

- no description -  

EffectImplicitTargetB1 ​

- no description -  

EffectImplicitTargetB2 ​

- no description -  

EffectImplicitTargetB3 ​

- no description -  

EffectRadiusIndex1 ​

- no description -  

EffectRadiusIndex2 ​

- no description -  

EffectRadiusIndex3 ​

- no description -  

EffectApplyAuraName1 ​

- no description -  

EffectApplyAuraName2 ​

- no description -  

EffectApplyAuraName3 ​

- no description -  

EffectAmplitude1 ​

- no description -  

EffectAmplitude2 ​

- no description -  

EffectAmplitude3 ​

- no description -  

EffectMultipleValue1 ​

- no description -  

EffectMultipleValue2 ​

- no description -  

EffectMultipleValue3 ​

- no description -  

EffectItemType1 ​

- no description -  

EffectItemType2 ​

- no description -  

EffectItemType3 ​

- no description -  

EffectMiscValue1 ​

- no description -  

EffectMiscValue2 ​

- no description -  

EffectMiscValue3 ​

- no description -  

EffectMiscValueB1 ​

- no description -  

EffectMiscValueB2 ​

- no description -  

EffectMiscValueB3 ​

- no description -  

EffectTriggerSpell1 ​

- no description -  

EffectTriggerSpell2 ​

- no description -  

EffectTriggerSpell3 ​

- no description -  

EffectSpellClassMaskA1 ​

- no description -  

EffectSpellClassMaskA2 ​

- no description -  

EffectSpellClassMaskA3 ​

- no description -  

EffectSpellClassMaskB1 ​

- no description -  

EffectSpellClassMaskB2 ​

- no description -  

EffectSpellClassMaskB3 ​

- no description -  

EffectSpellClassMaskC1 ​

- no description -  

EffectSpellClassMaskC2 ​

- no description -  

EffectSpellClassMaskC3 ​

- no description -  

SpellName ​

- no description -  

MaxTargetLevel ​

- no description -  

SpellFamilyName ​

- no description -  

SpellFamilyFlags1 ​

- no description -  

SpellFamilyFlags2 ​

- no description -  

SpellFamilyFlags3 ​

- no description -  

MaxAffectedTargets ​

- no description -  

DmgClass ​

- no description -  

PreventionType ​

- no description -  

DmgMultiplier1 ​

- no description -  

DmgMultiplier2 ​

- no description -  

DmgMultiplier3 ​

- no description -  

AreaGroupId ​

- no description -  

SchoolMask ​

- no description -