spell_template

Back to world database list of tables.

The `spell_template` table

holds data about every spell used.

Structure

ID	Field	Type	Null	Key	Default	Extra
	Id	INT UNSIGNED	NO		0
	Category	INT UNSIGNED	NO		0
	Dispel	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
	Stances	INT UNSIGNED	NO		0
	StancesNot	INT UNSIGNED	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
	CasterAuraStateNot	INT UNSIGNED	NO		0
	TargetAuraStateNot	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
	procFlags	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(11) unsigned	NO		0
	powerType	INT UNSIGNED	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		1
	speed	FLOAT	NO		0
	StackAmount	INT UNSIGNED	NO		0
	Totem1	INT UNSIGNED	NO		0
	Totem2	INT UNSIGNED	NO		0
	Reagent1	INT UNSIGNED	NO		0
	ReagentCount1	INT UNSIGNED	NO		0
	EquippedItemClass	INT UNSIGNED	NO		-1
	EquippedItemSubClassMask	INT UNSIGNED	NO		0
	EquippedItemInventoryTypeMask	INT UNSIGNED	NO		0
	Effect1	INT UNSIGNED	NO		0
	EffectDieSides1	INT UNSIGNED	NO		0
	EffectBaseDice1	INT UNSIGNED	NO		0
	EffectDicePerLevel1	FLOAT	NO		0
	EffectRealPointsPerLevel1	FLOAT	NO		0
	EffectBasePoints1	INT UNSIGNED	NO		0
	EffectMechanic1	INT UNSIGNED	NO		0
	EffectImplicitTargetA1	INT UNSIGNED	NO		0
	EffectImplicitTargetB1	INT UNSIGNED	NO		0
	EffectRadiusIndex1	INT UNSIGNED	NO		0
	EffectApplyAuraName1	INT UNSIGNED	NO		0
	EffectAmplitude1	INT UNSIGNED	NO		0
	EffectMultipleValue1	FLOAT	NO		0
	EffectChainTarget1	INT UNSIGNED	NO		0
	EffectItemType1	INT UNSIGNED	NO		0
	EffectMiscValue1	INT UNSIGNED	NO		0
	EffectMiscValueB1	INT	NO		0
	EffectTriggerSpell1	INT UNSIGNED	NO		0
	EffectPointsPerComboPoint1	FLOAT	NO		0
	SpellVisual	INT UNSIGNED	NO		0
	SpellIconID	INT UNSIGNED	NO		0
	activeIconID	INT UNSIGNED	NO		0
	spellPriority	INT UNSIGNED	NO		0
	SpellName	TEXT	NO		0
	Rank	TEXT	NULL		0
	ManaCostPercentage	INT UNSIGNED	NO		0
	StartRecoveryCategory	INT UNSIGNED	NO		0
	StartRecoveryTime	INT UNSIGNED	NO		0
	MaxTargetLevel	INT UNSIGNED	NO		0
	SpellFamilyName	INT UNSIGNED	NO		0
	SpellFamilyFlags	BIGINT UNSIGNED	NO		0
	MaxAffectedTargets	INT UNSIGNED	NO		0
	DmgClass	INT UNSIGNED	NO		0
	PreventionType	INT UNSIGNED	NO		0
	DmgMultiplier1	INT UNSIGNED	NO		0
	TotemCategory1	INT UNSIGNED	NO		0
	TotemCategory2	INT UNSIGNED	NO		0
	AreaId	INT UNSIGNED	NO		0
	SchoolMask	INT UNSIGNED	NO		0
	IsServerSide	INT UNSIGNED	NO		0
	AttributesServerside	INT UNSIGNED	NO		0

Description of the fields

Id

The spell ID.

Dispel

Dispel type of a spell. Some spells can only dispel specific types of spells, for example poisons.

Mechanic

Spells effects utilize a mechanics. For example bleed, root, silence.

Attributes

Special rules for spells. There are several columns for attributes. These rules can do anything, and some can be name only.

AttributesEx

AttributesEx2

AttributesEx3

AttributesEx4

AttributesEx5

AttributesEx6

Stances

Determines specific stances in which caster must be for spell to be successfully cast.

StancesNot

Determines specific stances in which caster cannot be for spell to be successfully cast.

Targets

Determines the default targets for some effects. Seems to be connected to TARGET_NONE.

TargetCreatureType

Specifies what creature types the spell can target, for example Humanoid or Beast.

RequiresSpellFocus

Specifies the spell focus GO, around which the caster has to be for a successful cast.

Indicates that this spell needs a GO near (e.g. forges). Required object has the type GAMEOBJECT_TYPE_SPELLFOCUS and data0 matches the RequiresSpellFocus value.

FacingCasterFlags

Specifies how the caster has to face the target so that the spell is successful. enum SpellFacingFlags in Unit.h

CasterAuraState

Specifies the caster AuraState required for the cast to be successful.

TargetAuraState

Specifies the target AuraState required for the cast to be successful.

CasterAuraStateNot

Specifies which AuraState the caster must not have for the cast to be successful.

TargetAuraStateNot

Specifies which AuraState the target must not have for the cast to be successful.

CastingTimeIndex

CastingTime (Id) that defines how long it takes for the spell to cast in milliseconds.

ID	CastTime	CastTimePerLevel	MinCastTime
1	0	0	0
2	250	0	250
3	500	0	500
4	1000	0	1000
5	2000	XXX	XXX
6	5000	XXX	XXX
7	10000	XXX	XXX
8	20000	XXX	XXX
9	30000	XXX	XXX
10	1000	-100	500
11	2000	-100	1000
12	5000	-100	2500
13	30000	-1000	10000
14	3000	XXX	XXX
15	4000	XXX	XXX
16	1500	XXX	XXX
17	XXX	XXX	XXX
18	-1000000	XXX	XXX
19	2500	XXX	XXX
20	2500	XXX	XXX
21	2600	XXX	XXX
22	3500	XXX	XXX
23	1800	XXX	XXX
24	XXX	XXX	XXX
25	XXX	XXX	XXX
26	XXX	XXX	XXX
27	XXX	XXX	XXX
28	XXX	XXX	XXX
29	XXX	XXX	XXX
30	XXX	XXX	XXX
31	XXX	XXX	XXX
32	XXX	XXX	XXX
33	XXX	XXX	XXX
34	XXX	XXX	XXX
35	XXX	XXX	XXX
36	XXX	XXX	XXX
37	XXX	XXX	XXX
38	XXX	XXX	XXX
39	XXX	XXX	XXX
50	XXX	XXX	XXX
70	300000	XXX	XXX
90	XXX	XXX	XXX
91	XXX	XXX	XXX
170	8000	XXX	XXX
170	6000	XXX	XXX
192	15000	XXX	XXX
193	12000	XXX	XXX

RecoveryTime

CategoryRecoveryTime

InterruptFlags

AuraInterruptFlags

ChannelInterruptFlags

procFlags

Bit	Flag	Comment
0	Killed
1	Kill
2	Successful Melee Hit
3	Taken Melee Hit
4	Successful Melee Spell Hit
5	Taken Melee Spell Hit
6	Successful Ranged Hit
7	Taken Ranged Hit
8	Successful Ranged Spell Hit
9	Taken Ranged Spell Hit
10	Successful Positive Aoe Hit
11	Taken Positive Aoe
12	Successful Aoe Spell Hit
13	Taken Aoe Spell Hit
14	Successful Positive Spell
15	Taken Positive Spell
16	Successful Negative Spell Hit
17	Taken Negative Spell Hit
18	On Do Periodic
19	On Take Periodic
20	Taken Any Damage
21	On Trap Activation
22	Successful Mainhand Hit
23	Successful Offhand Hit
24	Death

procChance

procCharges

maxLevel

baseLevel

spellLevel

DurationIndex

powerType

ID	Description
0	Mana
1	Rage
2	?
3	Energy

manaCost

manaCostPerlevel

manaPerSecond

manaPerSecondPerLevel

rangeIndex

speed

StackAmount

Totem1

Totem2

Reagent1

ReagentCount1

EquippedItemClass

EquippedItemSubClassMask

EquippedItemInventoryTypeMask

Effect1

EffectDieSides1

Random Value of the Die that is rolled for the SPELL_EFFECT
Max(EffectDieSides1) + (EffectBaseDice1 + EffectBasePoints1) = MaxValue for SPELL_EFFECT

EffectBaseDice1

Base Value for the SPELL_EFFECT, mostly 1
EffectBaseDice1 + EffectBasePoints1 = MinValue for SPELL_EFFECT

EffectDicePerLevel1

EffectRealPointsPerLevel1

EffectBasePoints1

Value added to EffectBaseDice1

EffectMechanic1

EffectImplicitTargetA1

EffectImplicitTargetB1

EffectRadiusIndex1

EffectApplyAuraName1

EffectAmplitude1

EffectMultipleValue1

EffectChainTarget1

EffectItemType1

EffectMiscValue1

EffectMiscValueB1

EffectTriggerSpell1

EffectPointsPerComboPoint1

SpellVisual

SpellIconID

activeIconID

spellPriority

SpellName

Rank

ManaCostPercentage

StartRecoveryCategory

StartRecoveryTime

MaxTargetLevel

SpellFamilyName

SpellFamilyFlags

MaxAffectedTargets

DmgClass

PreventionType

DmgMultiplier1

TotemCategory1

TotemCategory2

AreaId

Specifies the Allowed areas for a successful cast.
IDs taken from AreaGroup.dbc

SchoolMask

IsServerSide

AttributesServerside

General Links:

Subsystems:

Playerbot Module

Database Structure:

Additional Data:

Core Repositories:

DB Repositories:

ID	Description
0	Default
1	Summon guards
2	Entry
4	Entry