spell_dbc

<-Back-to:World

The `spell_dbc` table

This table has the same columns as Spell.dbc. The core loads it after the DBC file: a row adds a spell that is not in Spell.dbc, for example a serverside spell, or replaces the spell with the same ID.

The core reads every column in order, so a row must have a value for all of them, even the columns the core does not use. An empty text column keeps the text from the DBC file.

Table Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
ID	INT		PRI	NO	0
Category	INT	UNSIGNED		NO	0
DispelType	INT	UNSIGNED		NO	0
Mechanic	INT	UNSIGNED		NO	0
Attributes	INT	UNSIGNED		NO	0
AttributesEx	INT	UNSIGNED		NO	0
AttributesEx2	INT	UNSIGNED		NO	0
AttributesEx3	INT	UNSIGNED		NO	0
AttributesEx4	INT	UNSIGNED		NO	0
AttributesEx5	INT	UNSIGNED		NO	0
AttributesEx6	INT	UNSIGNED		NO	0
AttributesEx7	INT	UNSIGNED		NO	0
ShapeshiftMask	BIGINT	UNSIGNED		NO	0
unk_320_2	INT			NO	0
ShapeshiftExclude	BIGINT	UNSIGNED		NO	0
unk_320_3	INT			NO	0
Targets	INT	UNSIGNED		NO	0
TargetCreatureType	INT	UNSIGNED		NO	0
RequiresSpellFocus	INT	UNSIGNED		NO	0
FacingCasterFlags	INT	UNSIGNED		NO	0
CasterAuraState	INT	UNSIGNED		NO	0
TargetAuraState	INT	UNSIGNED		NO	0
ExcludeCasterAuraState	INT	UNSIGNED		NO	0
ExcludeTargetAuraState	INT	UNSIGNED		NO	0
CasterAuraSpell	INT	UNSIGNED		NO	0
TargetAuraSpell	INT	UNSIGNED		NO	0
ExcludeCasterAuraSpell	INT	UNSIGNED		NO	0
ExcludeTargetAuraSpell	INT	UNSIGNED		NO	0
CastingTimeIndex	INT	UNSIGNED		NO	0
RecoveryTime	INT	UNSIGNED		NO	0
CategoryRecoveryTime	INT	UNSIGNED		NO	0
InterruptFlags	INT	UNSIGNED		NO	0
AuraInterruptFlags	INT	UNSIGNED		NO	0
ChannelInterruptFlags	INT	UNSIGNED		NO	0
ProcTypeMask	INT	UNSIGNED		NO	0
ProcChance	INT	UNSIGNED		NO	0
ProcCharges	INT	UNSIGNED		NO	0
MaxLevel	INT	UNSIGNED		NO	0
BaseLevel	INT	UNSIGNED		NO	0
SpellLevel	INT	UNSIGNED		NO	0
DurationIndex	INT	UNSIGNED		NO	0
PowerType	INT			NO	0
ManaCost	INT	UNSIGNED		NO	0
ManaCostPerLevel	INT	UNSIGNED		NO	0
ManaPerSecond	INT	UNSIGNED		NO	0
ManaPerSecondPerLevel	INT	UNSIGNED		NO	0
RangeIndex	INT	UNSIGNED		NO	0
Speed	FLOAT			NO	0
ModalNextSpell	INT	UNSIGNED		NO	0
CumulativeAura	INT	UNSIGNED		NO	0
Totem_1	INT	UNSIGNED		NO	0
Totem_2	INT	UNSIGNED		NO	0
Reagent_1	INT			NO	0
Reagent_2	INT			NO	0
Reagent_3	INT			NO	0
Reagent_4	INT			NO	0
Reagent_5	INT			NO	0
Reagent_6	INT			NO	0
Reagent_7	INT			NO	0
Reagent_8	INT			NO	0
ReagentCount_1	INT			NO	0
ReagentCount_2	INT			NO	0
ReagentCount_3	INT			NO	0
ReagentCount_4	INT			NO	0
ReagentCount_5	INT			NO	0
ReagentCount_6	INT			NO	0
ReagentCount_7	INT			NO	0
ReagentCount_8	INT			NO	0
EquippedItemClass	INT			NO	0
EquippedItemSubclass	INT			NO	0
EquippedItemInvTypes	INT			NO	0
Effect_1	INT	UNSIGNED		NO	0
Effect_2	INT	UNSIGNED		NO	0
Effect_3	INT	UNSIGNED		NO	0
EffectDieSides_1	INT			NO	0
EffectDieSides_2	INT			NO	0
EffectDieSides_3	INT			NO	0
EffectRealPointsPerLevel_1	FLOAT			NO	0
EffectRealPointsPerLevel_2	FLOAT			NO	0
EffectRealPointsPerLevel_3	FLOAT			NO	0
EffectBasePoints_1	INT			NO	0
EffectBasePoints_2	INT			NO	0
EffectBasePoints_3	INT			NO	0
EffectMechanic_1	INT	UNSIGNED		NO	0
EffectMechanic_2	INT	UNSIGNED		NO	0
EffectMechanic_3	INT	UNSIGNED		NO	0
ImplicitTargetA_1	INT	UNSIGNED		NO	0
ImplicitTargetA_2	INT	UNSIGNED		NO	0
ImplicitTargetA_3	INT	UNSIGNED		NO	0
ImplicitTargetB_1	INT	UNSIGNED		NO	0
ImplicitTargetB_2	INT	UNSIGNED		NO	0
ImplicitTargetB_3	INT	UNSIGNED		NO	0
EffectRadiusIndex_1	INT	UNSIGNED		NO	0
EffectRadiusIndex_2	INT	UNSIGNED		NO	0
EffectRadiusIndex_3	INT	UNSIGNED		NO	0
EffectAura_1	INT	UNSIGNED		NO	0
EffectAura_2	INT	UNSIGNED		NO	0
EffectAura_3	INT	UNSIGNED		NO	0
EffectAuraPeriod_1	INT	UNSIGNED		NO	0
EffectAuraPeriod_2	INT	UNSIGNED		NO	0
EffectAuraPeriod_3	INT	UNSIGNED		NO	0
EffectMultipleValue_1	FLOAT			NO	0
EffectMultipleValue_2	FLOAT			NO	0
EffectMultipleValue_3	FLOAT			NO	0
EffectChainTargets_1	INT	UNSIGNED		NO	0
EffectChainTargets_2	INT	UNSIGNED		NO	0
EffectChainTargets_3	INT	UNSIGNED		NO	0
EffectItemType_1	INT	UNSIGNED		NO	0
EffectItemType_2	INT	UNSIGNED		NO	0
EffectItemType_3	INT	UNSIGNED		NO	0
EffectMiscValue_1	INT			NO	0
EffectMiscValue_2	INT			NO	0
EffectMiscValue_3	INT			NO	0
EffectMiscValueB_1	INT			NO	0
EffectMiscValueB_2	INT			NO	0
EffectMiscValueB_3	INT			NO	0
EffectTriggerSpell_1	INT	UNSIGNED		NO	0
EffectTriggerSpell_2	INT	UNSIGNED		NO	0
EffectTriggerSpell_3	INT	UNSIGNED		NO	0
EffectPointsPerCombo_1	FLOAT			NO	0
EffectPointsPerCombo_2	FLOAT			NO	0
EffectPointsPerCombo_3	FLOAT			NO	0
EffectSpellClassMaskA_1	INT	UNSIGNED		NO	0
EffectSpellClassMaskA_2	INT	UNSIGNED		NO	0
EffectSpellClassMaskA_3	INT	UNSIGNED		NO	0
EffectSpellClassMaskB_1	INT	UNSIGNED		NO	0
EffectSpellClassMaskB_2	INT	UNSIGNED		NO	0
EffectSpellClassMaskB_3	INT	UNSIGNED		NO	0
EffectSpellClassMaskC_1	INT	UNSIGNED		NO	0
EffectSpellClassMaskC_2	INT	UNSIGNED		NO	0
EffectSpellClassMaskC_3	INT	UNSIGNED		NO	0
SpellVisualID_1	INT	UNSIGNED		NO	0
SpellVisualID_2	INT	UNSIGNED		NO	0
SpellIconID	INT	UNSIGNED		NO	0
ActiveIconID	INT	UNSIGNED		NO	0
SpellPriority	INT	UNSIGNED		NO	0
Name_Lang_enUS	VARCHAR(100)			YES	NULL
Name_Lang_enGB	VARCHAR(100)			YES	NULL
Name_Lang_koKR	VARCHAR(100)			YES	NULL
Name_Lang_frFR	VARCHAR(100)			YES	NULL
Name_Lang_deDE	VARCHAR(100)			YES	NULL
Name_Lang_enCN	VARCHAR(100)			YES	NULL
Name_Lang_zhCN	VARCHAR(100)			YES	NULL
Name_Lang_enTW	VARCHAR(100)			YES	NULL
Name_Lang_zhTW	VARCHAR(100)			YES	NULL
Name_Lang_esES	VARCHAR(100)			YES	NULL
Name_Lang_esMX	VARCHAR(100)			YES	NULL
Name_Lang_ruRU	VARCHAR(100)			YES	NULL
Name_Lang_ptPT	VARCHAR(100)			YES	NULL
Name_Lang_ptBR	VARCHAR(100)			YES	NULL
Name_Lang_itIT	VARCHAR(100)			YES	NULL
Name_Lang_Unk	VARCHAR(100)			YES	NULL
Name_Lang_Mask	INT	UNSIGNED		NO	0
NameSubtext_Lang_enUS	VARCHAR(100)			YES	NULL
NameSubtext_Lang_enGB	VARCHAR(100)			YES	NULL
NameSubtext_Lang_koKR	VARCHAR(100)			YES	NULL
NameSubtext_Lang_frFR	VARCHAR(100)			YES	NULL
NameSubtext_Lang_deDE	VARCHAR(100)			YES	NULL
NameSubtext_Lang_enCN	VARCHAR(100)			YES	NULL
NameSubtext_Lang_zhCN	VARCHAR(100)			YES	NULL
NameSubtext_Lang_enTW	VARCHAR(100)			YES	NULL
NameSubtext_Lang_zhTW	VARCHAR(100)			YES	NULL
NameSubtext_Lang_esES	VARCHAR(100)			YES	NULL
NameSubtext_Lang_esMX	VARCHAR(100)			YES	NULL
NameSubtext_Lang_ruRU	VARCHAR(100)			YES	NULL
NameSubtext_Lang_ptPT	VARCHAR(100)			YES	NULL
NameSubtext_Lang_ptBR	VARCHAR(100)			YES	NULL
NameSubtext_Lang_itIT	VARCHAR(100)			YES	NULL
NameSubtext_Lang_Unk	VARCHAR(100)			YES	NULL
NameSubtext_Lang_Mask	INT	UNSIGNED		NO	0
Description_Lang_enUS	TEXT			YES	NULL
Description_Lang_enGB	TEXT			YES	NULL
Description_Lang_koKR	TEXT			YES	NULL
Description_Lang_frFR	TEXT			YES	NULL
Description_Lang_deDE	TEXT			YES	NULL
Description_Lang_enCN	TEXT			YES	NULL
Description_Lang_zhCN	TEXT			YES	NULL
Description_Lang_enTW	TEXT			YES	NULL
Description_Lang_zhTW	TEXT			YES	NULL
Description_Lang_esES	TEXT			YES	NULL
Description_Lang_esMX	TEXT			YES	NULL
Description_Lang_ruRU	TEXT			YES	NULL
Description_Lang_ptPT	TEXT			YES	NULL
Description_Lang_ptBR	TEXT			YES	NULL
Description_Lang_itIT	TEXT			YES	NULL
Description_Lang_Unk	TEXT			YES	NULL
Description_Lang_Mask	INT	UNSIGNED		NO	0
AuraDescription_Lang_enUS	VARCHAR(550)			YES	NULL
AuraDescription_Lang_enGB	VARCHAR(550)			YES	NULL
AuraDescription_Lang_koKR	VARCHAR(550)			YES	NULL
AuraDescription_Lang_frFR	VARCHAR(550)			YES	NULL
AuraDescription_Lang_deDE	VARCHAR(550)			YES	NULL
AuraDescription_Lang_enCN	VARCHAR(550)			YES	NULL
AuraDescription_Lang_zhCN	VARCHAR(550)			YES	NULL
AuraDescription_Lang_enTW	VARCHAR(550)			YES	NULL
AuraDescription_Lang_zhTW	VARCHAR(550)			YES	NULL
AuraDescription_Lang_esES	VARCHAR(550)			YES	NULL
AuraDescription_Lang_esMX	VARCHAR(550)			YES	NULL
AuraDescription_Lang_ruRU	VARCHAR(550)			YES	NULL
AuraDescription_Lang_ptPT	VARCHAR(550)			YES	NULL
AuraDescription_Lang_ptBR	VARCHAR(550)			YES	NULL
AuraDescription_Lang_itIT	VARCHAR(550)			YES	NULL
AuraDescription_Lang_Unk	VARCHAR(100)			YES	NULL
AuraDescription_Lang_Mask	INT	UNSIGNED		NO	0
ManaCostPct	INT	UNSIGNED		NO	0
StartRecoveryCategory	INT	UNSIGNED		NO	0
StartRecoveryTime	INT	UNSIGNED		NO	0
MaxTargetLevel	INT	UNSIGNED		NO	0
SpellClassSet	INT	UNSIGNED		NO	0
SpellClassMask_1	INT	UNSIGNED		NO	0
SpellClassMask_2	INT	UNSIGNED		NO	0
SpellClassMask_3	INT	UNSIGNED		NO	0
MaxTargets	INT	UNSIGNED		NO	0
DefenseType	INT	UNSIGNED		NO	0
PreventionType	INT	UNSIGNED		NO	0
StanceBarOrder	INT	UNSIGNED		NO	0
EffectChainAmplitude_1	FLOAT			NO	0
EffectChainAmplitude_2	FLOAT			NO	0
EffectChainAmplitude_3	FLOAT			NO	0
MinFactionID	INT	UNSIGNED		NO	0
MinReputation	INT	UNSIGNED		NO	0
RequiredAuraVision	INT	UNSIGNED		NO	0
RequiredTotemCategoryID_1	INT	UNSIGNED		NO	0
RequiredTotemCategoryID_2	INT	UNSIGNED		NO	0
RequiredAreasID	INT			NO	0
SchoolMask	INT	UNSIGNED		NO	0
RuneCostID	INT	UNSIGNED		NO	0
SpellMissileID	INT	UNSIGNED		NO	0
PowerDisplayID	INT			NO	0
EffectBonusMultiplier_1	FLOAT			NO	0
EffectBonusMultiplier_2	FLOAT			NO	0
EffectBonusMultiplier_3	FLOAT			NO	0
SpellDescriptionVariableID	INT	UNSIGNED		NO	0
SpellDifficultyID	INT	UNSIGNED		NO	0

Description of the fields

Columns that end in _1, _2 or _3 hold one value per spell effect, and are described together. The core loads the columns that are not marked "Not used by the core", the others only need to be filled in so the row matches the layout of Spell.dbc.

ID

The ID of the spell. A row with the same ID as a spell in Spell.dbc replaces that spell.

Category

ID from SpellCategory.dbc. Spells in the same category share a cooldown, see CategoryRecoveryTime.

DispelType

The dispel type of the spell, which sets what can dispel it. See Dispel Type.

Mechanic

The mechanic of the spell, for example stun or root. Used for immunities and diminishing returns. See Spell Mechanic.

Attributes

Flags from the SpellAttr0 enum (SPELL_ATTR0_*) in SharedDefines.h.

AttributesEx

Flags from the SpellAttr1 enum (SPELL_ATTR1_*) in SharedDefines.h.

AttributesEx2

Flags from the SpellAttr2 enum (SPELL_ATTR2_*) in SharedDefines.h.

AttributesEx3

Flags from the SpellAttr3 enum (SPELL_ATTR3_*) in SharedDefines.h.

AttributesEx4

Flags from the SpellAttr4 enum (SPELL_ATTR4_*) in SharedDefines.h.

AttributesEx5

Flags from the SpellAttr5 enum (SPELL_ATTR5_*) in SharedDefines.h.

AttributesEx6

Flags from the SpellAttr6 enum (SPELL_ATTR6_*) in SharedDefines.h.

AttributesEx7

Flags from the SpellAttr7 enum (SPELL_ATTR7_*) in SharedDefines.h.

ShapeshiftMask

Bitmask of the shapeshift forms the caster must be in to cast the spell. Each form sets the bit 1 << (form - 1), with the form IDs from SpellShapeshiftForm.dbc.

unk_320

unk_320_2 and unk_320_3. Not used by the core.

ShapeshiftExclude

Bitmask of the shapeshift forms the caster can not be in to cast the spell. Uses the same bits as ShapeshiftMask.

Targets

Flags for the kinds of targets the spell can be cast on (TARGET_FLAG_* in SpellInfo.h), for example a unit, an item or a location.

TargetCreatureType

Bitmask of the creature types the spell can target. Each type sets the bit 1 << (type - 1), see Creature Type. 0 means any type.

RequiresSpellFocus

ID from SpellFocusObject.dbc. The caster must be near a gameobject of this spell focus type, for example an anvil or a forge.

FacingCasterFlags

If 1, a player caster must face the target to cast the spell.

CasterAuraState

Aura state (AURA_STATE_* in SharedDefines.h) the caster must have to cast the spell.

TargetAuraState

Aura state the target must have.

ExcludeCasterAuraState

Aura state the caster must not have.

ExcludeTargetAuraState

Aura state the target must not have.

CasterAuraSpell

ID of a spell whose aura the caster must have.

TargetAuraSpell

ID of a spell whose aura the target must have.

ExcludeCasterAuraSpell

ID of a spell whose aura the caster must not have.

ExcludeTargetAuraSpell

ID of a spell whose aura the target must not have.

CastingTimeIndex

ID from SpellCastTimes.dbc, which sets the cast time. 1 is an instant cast.

RecoveryTime

Cooldown of the spell in milliseconds.

CategoryRecoveryTime

Cooldown in milliseconds that is started for all spells in the same Category.

InterruptFlags

Flags for what interrupts the cast (SPELL_INTERRUPT_FLAG_* in SpellDefines.h), for example movement or taking damage.

AuraInterruptFlags

Flags for what removes the aura from the target (AURA_INTERRUPT_FLAG_* in SpellDefines.h).

ChannelInterruptFlags

Flags for what interrupts a channeled spell. Uses the same values as AuraInterruptFlags.

ProcTypeMask

Flags for the events that make the aura proc. See spell_proc.ProcFlags.

ProcChance

Chance in percent that the aura procs.

ProcCharges

Number of times the aura can proc before it is removed. 0 means no limit.

MaxLevel

Level after which the spell stops getting stronger from the caster's level.

BaseLevel

Level the spell's level-based values start from.

SpellLevel

Level the spell is learned at.

DurationIndex

ID from SpellDuration.dbc, which sets the duration of the aura.

PowerType

The power the spell costs. See Power Type.

ManaCost

Flat power cost of the spell.

ManaCostPerLevel

Power cost added per level of the caster.

ManaPerSecond

Power drained per second while the spell is channeled.

ManaPerSecondPerLevel

Power drained per second per level of the caster.

RangeIndex

ID from SpellRange.dbc, which sets the range of the spell.

Speed

Travel speed of the spell's missile in yards per second. 0 means the spell hits instantly.

ModalNextSpell

Not used by the core.

CumulativeAura

Maximum number of stacks of the aura.

Totem

Totem_1 and Totem_2. Item IDs of tools the caster must have in their bags to cast the spell.

Reagent

Reagent_1 to Reagent_8. Item IDs of reagents the spell uses.

ReagentCount

ReagentCount_1 to ReagentCount_8. Number of each Reagent the spell uses.

EquippedItemClass

Item class the caster must have equipped, see item_template.class. -1 means no item is needed.

EquippedItemSubclass

Bitmask of the item subclasses of EquippedItemClass that are allowed. Each subclass sets the bit 1 << subclass.

EquippedItemInvTypes

Bitmask of the inventory types that are allowed, see item_template.InventoryType. Each type sets the bit 1 << type.

Effect

The effect of each of the three spell effects. See Spell Effects Reference.

EffectDieSides

Random value added to EffectBasePoints. The effect's value is between BasePoints + 1 and BasePoints + DieSides.

EffectRealPointsPerLevel

Value added to the effect per level of the caster above BaseLevel, up to MaxLevel.

EffectBasePoints

The base value of the effect. The actual value is one higher, see EffectDieSides.

EffectMechanic

Mechanic of the effect. Overrides the spell's Mechanic for this effect.

ImplicitTargetA

Target type of the effect (TARGET_* in SharedDefines.h), for example the caster or the selected target.

ImplicitTargetB

Second target type of the effect, for example the units in an area around the target selected by ImplicitTargetA.

EffectRadiusIndex

ID from SpellRadius.dbc, which sets the radius of area effects.

EffectAura

The aura applied by an Apply Aura effect. See Spell Aura Reference.

EffectAuraPeriod

Time in milliseconds between the ticks of a periodic aura.

EffectMultipleValue

Multiplier for effects that convert a value, for example the health gained per point of mana drained.

EffectChainTargets

Number of targets a chain effect can jump to.

EffectItemType

Item ID created by a Create Item effect.

EffectMiscValue

Extra value used by the effect or aura, for example a creature entry or a school mask. See Spell Effects Reference and Spell Aura Reference.

EffectMiscValueB

Second extra value used by the effect or aura.

EffectTriggerSpell

ID of a spell the effect triggers.

EffectPointsPerCombo

Value added to the effect per combo point.

EffectSpellClassMaskA

First 32 bits of the spell family mask the effect affects. Together with EffectSpellClassMaskB and EffectSpellClassMaskC it selects the spells of the same SpellClassSet that an aura modifies.

EffectSpellClassMaskB

Second 32 bits of the spell family mask. See EffectSpellClassMaskA.

EffectSpellClassMaskC

Third 32 bits of the spell family mask. See EffectSpellClassMaskA.

SpellVisualID

SpellVisualID_1 and SpellVisualID_2. IDs from SpellVisual.dbc for the visual effects of the spell.

SpellIconID

ID from SpellIcon.dbc for the icon of the spell.

ActiveIconID

ID from SpellIcon.dbc for the icon shown while the spell is active.

SpellPriority

Not used by the core.

Name_Lang

Name_Lang_enUS to Name_Lang_Unk, one column per client locale, and Name_Lang_Mask. The name of the spell. The mask is not used by the core.

NameSubtext_Lang

NameSubtext_Lang_enUS to NameSubtext_Lang_Unk and NameSubtext_Lang_Mask. The rank text of the spell, for example "Rank 1". The mask is not used by the core.

Description_Lang

Description_Lang_enUS to Description_Lang_Unk and Description_Lang_Mask. The description of the spell. Not used by the core.

AuraDescription_Lang

AuraDescription_Lang_enUS to AuraDescription_Lang_Unk and AuraDescription_Lang_Mask. The tooltip of the aura. Not used by the core.

ManaCostPct

Power cost in percent of the caster's base power. Used instead of ManaCost if set.

StartRecoveryCategory

Global cooldown category of the spell. 133 is the normal global cooldown.

StartRecoveryTime

Global cooldown the spell starts, in milliseconds.

MaxTargetLevel

Highest level a target can have to be affected by the spell. 0 means no limit.

SpellClassSet

The spell family, usually the class the spell belongs to. See spell_proc.SpellFamilyName.

SpellClassMask

SpellClassMask_1 to SpellClassMask_3. The 96 bit spell family mask of the spell. Auras use it together with SpellClassSet to select the spells they modify, see EffectSpellClassMaskA.

MaxTargets

Maximum number of targets the spell can hit. 0 means no limit.

DefenseType

Value	Damage class
0	None
1	Magic
2	Melee
3	Ranged

Sets how the spell hits, for example whether it can be dodged or resisted.

PreventionType

Value	Prevention type
0	None
1	Silence. The spell can not be cast while silenced.
2	Pacify. The spell can not be cast while pacified.

StanceBarOrder

Not used by the core.

EffectChainAmplitude

Multiplier applied to the effect's value each time a chain effect jumps to the next target.

MinFactionID

Not used by the core.

MinReputation

Not used by the core.

RequiredAuraVision

Not used by the core.

RequiredTotemCategoryID

RequiredTotemCategoryID_1 and RequiredTotemCategoryID_2. IDs from TotemCategory.dbc of tools the caster must have, for example a Blacksmith Hammer.

RequiredAreasID

ID from AreaGroup.dbc. The spell can only be cast in these areas. 0 means anywhere.

SchoolMask

The school of the spell. See School Mask.

RuneCostID

ID from SpellRuneCost.dbc, which sets the rune cost of Death Knight spells.

SpellMissileID

Not used by the core.

PowerDisplayID

Not used by the core.

EffectBonusMultiplier

Multiplier for the bonus the effect gets from spell power or attack power.

SpellDescriptionVariableID

Not used by the core.

SpellDifficultyID

Not used by the core. Spell difficulties are set in spelldifficulty_dbc.