Skip to content

spell_template

Jump to bottom Edit New page
AnonXS edited this page Jun 27, 2019 · 32 revisions

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
EffectMechanic{1,2,3} INT UNSIGNED NO 0
EffectImplicitTargetA{1,2,3} INT UNSIGNED NO 0
EffectImplicitTargetB{1,2,3} 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.

Category

Category ID based on which cooldown is determined. Spells with same category go into cooldown if one of them goes into cooldown.

ID Description
0 Default
1 Summon guards
2 Entry
4 Entry

Dispel

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

Mechanic

Spells effects utilize a mechanics.

Id Enum name Comment
0 MECHANIC_NONE
1 MECHANIC_CHARM
2 MECHANIC_DISORIENTED
3 MECHANIC_DISARM
4 MECHANIC_DISTRACT
5 MECHANIC_FEAR
6 MECHANIC_FUMBLE
7 MECHANIC_ROOT
8 MECHANIC_PACIFY No spells use this mechanic
9 MECHANIC_SILENCE
10 MECHANIC_SLEEP
11 MECHANIC_SNARE
12 MECHANIC_STUN
13 MECHANIC_FREEZE
14 MECHANIC_KNOCKOUT
15 MECHANIC_BLEED
16 MECHANIC_BANDAGE
17 MECHANIC_POLYMORPH
18 MECHANIC_BANISH
19 MECHANIC_SHIELD
20 MECHANIC_SHACKLE
21 MECHANIC_MOUNT
22 MECHANIC_PERSUADE spells use this mechanic
23 MECHANIC_TURN
24 MECHANIC_HORROR
25 MECHANIC_INVULNERABILITY
26 MECHANIC_INTERRUPT
27 MECHANIC_DAZE
28 MECHANIC_DISCOVERY
29 MECHANIC_IMMUNE_SHIELD Divine (Blessing) Shield/Protection and Ice Block
30 MECHANIC_SAPPED

Attributes

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

ID ENUM NAME Description
0×00000001 SPELL_ATTR_UNK0 0
0×00000002 SPELL_ATTR_RANGED 1 All ranged abilites have this flag
0×00000004 SPELL_ATTR_ON_NEXT_SWING_1 2 on next swing
0×00000008 SPELL_ATTR_UNK3 3 not set in 3.0.3
0×00000010 SPELL_ATTR_ABILITY 4 Displays ability instead of spell clientside
0×00000020 SPELL_ATTR_TRADESPELL 5 trade spells, will be added by client to a sublist of profession spell
0×00000040 SPELL_ATTR_PASSIVE 6 Passive spell
0×00000080 SPELL_ATTR_HIDDEN_CLIENTSIDE 7 Spells with this attribute are not visible in spellbook or aura bar TODO: check usage
0×00000100 SPELL_ATTR_HIDE_IN_COMBAT_LOG 8 hide created item in tooltip (for effect=24) TODO: implement it
0×00000200 SPELL_ATTR_TARGET_MAINHAND_ITEM 9 Client automatically selects item from mainhand slot as a cast target TODO: Implement
0×00000400 SPELL_ATTR_ON_NEXT_SWING_2 10 on next swing 2
0×00000800 SPELL_ATTR_UNK11 11
0×00001000 SPELL_ATTR_DAYTIME_ONLY 12 only useable at daytime, not set in 2.4.2
0×00002000 SPELL_ATTR_NIGHT_ONLY 13 only useable at night, not set in 2.4.2
0×00004000 SPELL_ATTR_INDOORS_ONLY 14 only useable indoors, not set in 2.4.2
0×00008000 SPELL_ATTR_OUTDOORS_ONLY 15 Only useable outdoors.
0×00010000 SPELL_ATTR_NOT_SHAPESHIFT 16 Not while shapeshifted
0×00020000 SPELL_ATTR_ONLY_STEALTHED 17 Must be in stealth
0×00040000 SPELL_ATTR_DONT_AFFECT_SHEATH_STATE 18 client won’t hide unit weapons in sheath on cast/channel TODO: Implement
0×00080000 SPELL_ATTR_LEVEL_DAMAGE_CALCULATION 19 spelldamage depends on caster level
0×00100000 SPELL_ATTR_STOP_ATTACK_TARGET 20 Stop attack after use this spell (and not begin attack if use)
0×00200000 SPELL_ATTR_IMPOSSIBLE_DODGE_PARRY_BLOCK 21 Cannot be dodged/parried/blocked
0×00400000 SPELL_ATTR_SET_TRACKING_TARGET 22 SetTrackingTarget
0×00800000 SPELL_ATTR_CASTABLE_WHILE_DEAD 23 castable while dead TODO: Implement
0×01000000 SPELL_ATTR_CASTABLE_WHILE_MOUNTED 24 castable while mounted
0×02000000 SPELL_ATTR_DISABLED_WHILE_ACTIVE 25 Activate and start cooldown after aura fade or remove summoned creature or go
0×04000000 SPELL_ATTR_AURA_IS_DEBUFF 26
0×08000000 SPELL_ATTR_CASTABLE_WHILE_SITTING 27 castable while sitting
0×10000000 SPELL_ATTR_CANT_USED_IN_COMBAT 28 Cannot be used in combat
0×20000000 SPELL_ATTR_UNAFFECTED_BY_INVULNERABILITY 29 unaffected by invulnerability (hmm possible not…)
0×40000000 SPELL_ATTR_UNK30 30 breakable by damage?
0×80000000 SPELL_ATTR_CANT_CANCEL 31 positive aura can’t be canceled

AttributesEx

ID ENUM NAME Description
0×00000001 SPELL_ATTR_EX_UNK0 0
0×00000002 SPELL_ATTR_EX_DRAIN_ALL_POWER 1 use all power (Only paladin Lay of Hands and Bunyanize)
0×00000004 SPELL_ATTR_EX_CHANNELED_1 2 channeled 1
0×00000008 SPELL_ATTR_EX_CANT_BE_REDIRECTED 3
0×00000010 SPELL_ATTR_EX_UNK4 4
0×00000020 SPELL_ATTR_EX_NOT_BREAK_STEALTH 5 Not break stealth
0×00000040 SPELL_ATTR_EX_CHANNELED_2 6 channeled 2
0×00000080 SPELL_ATTR_EX_CANT_BE_REFLECTED 7
0×00000100 SPELL_ATTR_EX_NOT_IN_COMBAT_TARGET 8 Spell req target not to be in combat state
0×00000200 SPELL_ATTR_EX_FACING_TARGET 9 TODO: CONFIRM!
0×00000400 SPELL_ATTR_EX_NO_THREAT 10 no generates threat on cast 100%
0×00000800 SPELL_ATTR_EX_UNK11 11
0×00001000 SPELL_ATTR_EX_IS_PICKPOCKET 12
0×00002000 SPELL_ATTR_EX_FARSIGHT 13 related to farsight
0×00004000 SPELL_ATTR_EX_CHANNEL_TRACK_TARGET 14
0×00008000 SPELL_ATTR_EX_DISPEL_AURAS_ON_IMMUNITY 15 remove auras on immunity
0×00010000 SPELL_ATTR_EX_UNAFFECTED_BY_SCHOOL_IMMUNE 16 unaffected by school immunity
0×00020000 SPELL_ATTR_EX_UNAUTOCASTABLE_BY_CHARMED 17 TODO: Investigate more: SPELL_ATTR_EX_PLAYER_CANT_CAST_CHARMED, likely related to MC
0×00040000 SPELL_ATTR_EX_UNK18 18
0×00080000 SPELL_ATTR_EX_CANT_TARGET_SELF 19 spells with area effect or friendly targets that exclude the caster
0×00100000 SPELL_ATTR_EX_REQ_TARGET_COMBO_POINTS 20 Req combo points on target
0×00200000 SPELL_ATTR_EX_UNK21 21
0×00400000 SPELL_ATTR_EX_REQ_COMBO_POINTS 22 Use combo points (in 4.x not required combo point target selected)
0×00800000 SPELL_ATTR_EX_UNK23 23
0×01000000 SPELL_ATTR_EX_UNK24 24 Req fishing pole??
0×02000000 SPELL_ATTR_EX_UNK25 25 not set in 2.4.2
0×04000000 SPELL_ATTR_EX_UNK26 26
0×08000000 SPELL_ATTR_EX_REFUND_POWER 27 All these spells refund power on parry or deflect
0×10000000 SPELL_ATTR_EX_DONT_DISPLAY_IN_AURA_BAR 28
0×20000000 SPELL_ATTR_EX_CHANNEL_DISPLAY_SPELL_NAME 29
0×40000000 SPELL_ATTR_EX_ENABLE_AT_DODGE 30 overpower
0×80000000 SPELL_ATTR_EX_UNK31 31

AttributesEx2

ID ENUM NAME Description
0×00000001 SPELL_ATTR_EX2_CAN_TARGET_DEAD 0 can target dead unit or corpse
0×00000002 SPELL_ATTR_EX2_UNK1 1
0×00000004 SPELL_ATTR_EX2_IGNORE_LOS 2 do not need LOS (e.g. 18220 since 3.3.3)
0×00000008 SPELL_ATTR_EX2_UNK3 3 auto targeting? (e.g. fishing skill enhancement items since 3.3.3)
0×00000010 SPELL_ATTR_EX2_DISPLAY_IN_STANCE_BAR 4
0×00000020 SPELL_ATTR_EX2_AUTOREPEAT_FLAG 5
0×00000040 SPELL_ATTR_EX2_CANT_TARGET_TAPPED 6 only usable on tabbed by yourself
0×00000080 SPELL_ATTR_EX2_UNK7 7
0×00000100 SPELL_ATTR_EX2_UNK8 8 not set in 2.4.2
0×00000200 SPELL_ATTR_EX2_UNK9 9
0×00000400 SPELL_ATTR_EX2_UNK10 10
0×00000800 SPELL_ATTR_EX2_HEALTH_FUNNEL 11
0×00001000 SPELL_ATTR_EX2_UNK12 12
0×00002000 SPELL_ATTR_EX2_UNK13 13
0×00004000 SPELL_ATTR_EX2_UNK14 14
0×00008000 SPELL_ATTR_EX2_UNK15 15 not set in 3.0.3
0×00010000 SPELL_ATTR_EX2_TAME_BEAST 16
0×00020000 SPELL_ATTR_EX2_NOT_RESET_AUTO_ACTIONS 17 suspend weapon timer instead of resetting it, (?Hunters Shot and Stings only have this flag?)
0×00040000 SPELL_ATTR_EX2_REQ_DEAD_PET 18 Only Revive pet – possible req dead pet
0×00080000 SPELL_ATTR_EX2_NOT_NEED_SHAPESHIFT 19 does not necessarly need shapeshift
0×00100000 SPELL_ATTR_EX2_FACING_TARGETS_BACK 20 TODO: CONFIRM!
0×00200000 SPELL_ATTR_EX2_DAMAGE_REDUCED_SHIELD 21 for ice blocks, pala immunity buffs, priest absorb shields, but used also for other spells → not sure!
0×00400000 SPELL_ATTR_EX2_UNK22 22
0×00800000 SPELL_ATTR_EX2_IS_ARCANE_CONCENTRATION 23 Only mage Arcane Concentration have this flag
0×01000000 SPELL_ATTR_EX2_UNK24 24
0×02000000 SPELL_ATTR_EX2_UNK25 25
0×04000000 SPELL_ATTR_EX2_UNK26 26 unaffected by school immunity
0×08000000 SPELL_ATTR_EX2_UNK27 27
0×10000000 SPELL_ATTR_EX2_UNK28 28 no breaks stealth if it fails??
0×20000000 SPELL_ATTR_EX2_CANT_CRIT 29 Spell can’t crit
0×40000000 SPELL_ATTR_EX2_TRIGGERED_CAN_TRIGGER_PROC 30
0×80000000 SPELL_ATTR_EX2_FOOD_BUFF 31 Food or Drink Buff (like Well Fed

AttributesEx3

ID ENUM NAME Description
0×00000001 SPELL_ATTR_EX3_OUT_OF_COMBAT_ATTACK 0 Spell landed counts as hostile action against enemy even if it doesn’t trigger combat state, propagates PvP flags
0×00000002 SPELL_ATTR_EX3_UNK1 1
0×00000004 SPELL_ATTR_EX3_UNK2 2
0×00000008 SPELL_ATTR_EX3_BLOCKABLE_SPELL 3 TODO: Investigate more
0×00000010 SPELL_ATTR_EX3_IGNORE_RESURRECTION_TIMER 4 Druid Rebirth only this spell have this flag
0×00000020 SPELL_ATTR_EX3_UNK5 5
0×00000040 SPELL_ATTR_EX3_UNK6 6
0×00000080 SPELL_ATTR_EX3_STACK_FOR_DIFF_CASTERS 7 create a separate (de)buff stack for each caster
0×00000100 SPELL_ATTR_EX3_TARGET_ONLY_PLAYER 8 Can target only player
0×00000200 SPELL_ATTR_EX3_TRIGGERED_CAN_TRIGGER_SPECIAL 9 Can only proc auras with SPELL_ATTR_EX3_CAN_PROC_FROM_TRIGGERED_SPECIAL
0×00000400 SPELL_ATTR_EX3_MAIN_HAND 10 Main hand weapon required
0×00000800 SPELL_ATTR_EX3_BATTLEGROUND 11 Can casted only on battleground
0×00001000 SPELL_ATTR_EX3_CAST_ON_DEAD 12 target is a dead player (not every spell has this flag)
0×00002000 SPELL_ATTR_EX3_DONT_DISPLAY_CHANNEL_BAR 13
0×00004000 SPELL_ATTR_EX3_IS_HONORLESS_TARGET 14 “Honorless Target” only this spells have this flag
0×00008000 SPELL_ATTR_EX3_UNK15 15 Auto Shoot, Shoot, Throw, – this is autoshot flag
0×00010000 SPELL_ATTR_EX3_CANT_TRIGGER_PROC 16 confirmed by patchnotes
0×00020000 SPELL_ATTR_EX3_NO_INITIAL_AGGRO 17 Causes no aggro if not missed
0×00040000 SPELL_ATTR_EX3_CANT_MISS 18 Spell should always hit its target
0×00080000 SPELL_ATTR_EX3_UNK19 19
0×00100000 SPELL_ATTR_EX3_DEATH_PERSISTENT 20 Death persistent spells
0×00200000 SPELL_ATTR_EX3_UNK21 21
0×00400000 SPELL_ATTR_EX3_REQ_WAND 22 Req wand
0×00800000 SPELL_ATTR_EX3_UNK23 23
0×01000000 SPELL_ATTR_EX3_REQ_OFFHAND 24 Req offhand weapon
0×02000000 SPELL_ATTR_EX3_UNK25 25 no cause spell pushback ?
0×04000000 SPELL_ATTR_EX3_CAN_PROC_FROM_TRIGGERED_SPECIAL 26 Auras with this attribute can proc off SPELL_ATTR_EX3_TRIGGERED_CAN_TRIGGER_SPECIAL
0×08000000 SPELL_ATTR_EX3_DRAIN_SOUL 27
0×10000000 SPELL_ATTR_EX3_UNK28 28 always cast ok ? (requires more research)
0×20000000 SPELL_ATTR_EX3_NO_DONE_BONUS 29
0×40000000 SPELL_ATTR_EX3_DONT_DISPLAY_RANGE 30
0×80000000 SPELL_ATTR_EX3_UNK31 31

AttributesEx4

ID ENUM NAME Description
0×00000001 SPELL_ATTR_EX4_IGNORE_RESISTANCES 0
0×00000002 SPELL_ATTR_EX4_UNK1 1 proc on finishing move?
0×00000004 SPELL_ATTR_EX4_UNK2 2
0×00000008 SPELL_ATTR_EX4_UNK3 3
0×00000010 SPELL_ATTR_EX4_UNK4 4 This will no longer cause guards to attack on use??
0×00000020 SPELL_ATTR_EX4_UNK5 5
0×00000040 SPELL_ATTR_EX4_NOT_STEALABLE 6 although such auras might be dispellable, they cannot be stolen
0×00000080 SPELL_ATTR_EX4_CAN_CAST_WHILE_CASTING 7 In theory, can use this spell while another is channeled/cast/autocast
0×00000100 SPELL_ATTR_EX4_STACK_DOT_MODIFIER 8 no effect on non DoTs?
0×00000200 SPELL_ATTR_EX4_TRIGGER_ACTIVATE 9 initially disabled / trigger activate from event (Execute, Riposte, Deep Freeze end other)
0×00000400 SPELL_ATTR_EX4_SPELL_VS_EXTEND_COST 10 Rogue Shiv have this flag
0×00000800 SPELL_ATTR_EX4_UNK11 11
0×00001000 SPELL_ATTR_EX4_UNK12 12
0×00002000 SPELL_ATTR_EX4_UNK13 13
0×00004000 SPELL_ATTR_EX4_DAMAGE_DOESNT_BREAK_AURAS 14
0×00008000 SPELL_ATTR_EX4_UNK15 15
0×00010000 SPELL_ATTR_EX4_NOT_USABLE_IN_ARENA 16 not usable in arena
0×00020000 SPELL_ATTR_EX4_USABLE_IN_ARENA 17 usable in arena
0×00040000 SPELL_ATTR_EX4_UNK18 18
0×00080000 SPELL_ATTR_EX4_UNK19 19
0×00100000 SPELL_ATTR_EX4_NOT_CHECK_SELFCAST_POWER 20 do not give “more powerful spell” error message
0×00200000 SPELL_ATTR_EX4_UNK21 21
0×00400000 SPELL_ATTR_EX4_UNK22 22
0×00800000 SPELL_ATTR_EX4_UNK23 23
0×01000000 SPELL_ATTR_EX4_UNK24 24
0×02000000 SPELL_ATTR_EX4_IS_PET_SCALING 25 pet scaling auras
0×04000000 SPELL_ATTR_EX4_CAST_ONLY_IN_OUTLAND 26 Can only be used in Outland.
0×08000000 SPELL_ATTR_EX4_UNK27 27
0×10000000 SPELL_ATTR_EX4_UNK28 28
0×20000000 SPELL_ATTR_EX4_UNK29 29
0×40000000 SPELL_ATTR_EX4_UNK30 30
0×80000000 SPELL_ATTR_EX4_UNK31 31

AttributesEx5

ID ENUM NAME Description
0×00000001 SPELL_ATTR_EX5_CAN_CHANNEL_WHEN_MOVING 0 don’t interrupt channeling spells when moving
0×00000002 SPELL_ATTR_EX5_NO_REAGENT_WHILE_PREP 1 not need reagents if UNIT_FLAG_PREPARATION
0×00000004 SPELL_ATTR_EX5_REMOVE_ON_ARENA_ENTER 2 removed at enter arena (e.g. 31850 since 3.3.3)
0×00000008 SPELL_ATTR_EX5_USABLE_WHILE_STUNNED 3 usable while stunned
0×00000010 SPELL_ATTR_EX5_UNK4 4
0×00000020 SPELL_ATTR_EX5_SINGLE_TARGET_SPELL 5 Only one target can be apply at a time
0×00000040 SPELL_ATTR_EX5_UNK6 6
0×00000080 SPELL_ATTR_EX5_UNK7 7
0×00000100 SPELL_ATTR_EX5_UNK8 8
0×00000200 SPELL_ATTR_EX5_START_PERIODIC_AT_APPLY 9 begin periodic tick at aura apply
0×00000400 SPELL_ATTR_EX5_HIDE_DURATION 10
0×00000800 SPELL_ATTR_EX5_ALLOW_TARGET_OF_TARGET_AS_TARGET 11
0×00001000 SPELL_ATTR_EX5_CLEAVE_FRONT_TARGET 12
0×00002000 SPELL_ATTR_EX5_HASTE_AFFECT_DURATION 13 haste affects duration
0×00004000 SPELL_ATTR_EX5_UNK14 14
0×00008000 SPELL_ATTR_EX5_UNK15 15
0×00010000 SPELL_ATTR_EX5_UNK16 16
0×00020000 SPELL_ATTR_EX5_USABLE_WHILE_FEARED 17 usable while feared
0×00040000 SPELL_ATTR_EX5_USABLE_WHILE_CONFUSED 18 usable while confused
0×00080000 SPELL_ATTR_EX5_DONT_TURN_DURING_CAST 19
0×00100000 SPELL_ATTR_EX5_UNK20 20
0×00200000 SPELL_ATTR_EX5_UNK21 21
0×00400000 SPELL_ATTR_EX5_UNK22 22
0×00800000 SPELL_ATTR_EX5_UNK23 23
0×01000000 SPELL_ATTR_EX5_UNK24 24
0×02000000 SPELL_ATTR_EX5_UNK25 25
0×04000000 SPELL_ATTR_EX5_UNK26 26
0×08000000 SPELL_ATTR_EX5_DONT_SHOW_AURA_IF_SELF_CAST 27 Auras with this attribute are not visible on units that are the caster
0×10000000 SPELL_ATTR_EX5_DONT_SHOW_AURA_IF_NOT_SELF_CAST 28 Auras with this attribute are not visible on units that are not the caster
0×20000000 SPELL_ATTR_EX5_UNK29 29
0×40000000 SPELL_ATTR_EX5_UNK30 30
0×80000000 SPELL_ATTR_EX5_USE_PHYSICAL_HIT_CHANCE 31 Introduced in patch 2.3: Taunt, Growl, etc spells use ability miss calculation (see implementation for details)

AttributesEx6

ID ENUM NAME Description
0×00000001 SPELL_ATTR_EX6_DONT_DISPLAY_COOLDOWN 0 Only Move spell have this flag
0×00000002 SPELL_ATTR_EX6_ONLY_IN_ARENA 1 only usable in arena, not used in 3.2.0a and early
0×00000004 SPELL_ATTR_EX6_IGNORE_CASTER_AURAS 2
0×00000008 SPELL_ATTR_EX6_UNK3 3
0×00000010 SPELL_ATTR_EX6_UNK4 4
0×00000020 SPELL_ATTR_EX6_UNK5 5
0×00000040 SPELL_ATTR_EX6_USE_SPELL_CAST_EVENT 6 Auras with this attribute trigger SPELL_CAST combat log event instead of SPELL_AURA_START (clientside attribute)
0×00000080 SPELL_ATTR_EX6_UNK7 7
0×00000100 SPELL_ATTR_EX6_IGNORE_CC_TARGETS 8 ignores target with cc effects
0×00000200 SPELL_ATTR_EX6_UNK9 9
0×00000400 SPELL_ATTR_EX6_UNK10 10
0×00000800 SPELL_ATTR_EX6_NOT_IN_RAID_INSTANCE 11 not usable in raid instance
0×00001000 SPELL_ATTR_EX6_UNK12 12 for auras SPELL_AURA_TRACK_CREATURES, SPELL_AURA_TRACK_RESOURCES and SPELL_AURA_TRACK_STEALTHED select non-stacking tracking spells
0×00002000 SPELL_ATTR_EX6_UNK13 13
0×00004000 SPELL_ATTR_EX6_UNK14 14
0×00008000 SPELL_ATTR_EX6_UNK15 15 not set in 3.0.3
0×00010000 SPELL_ATTR_EX6_UNK16 16
0×00020000 SPELL_ATTR_EX6_UNK17 17
0×00040000 SPELL_ATTR_EX6_UNK18 18
0×00080000 SPELL_ATTR_EX6_UNK19 19
0×00100000 SPELL_ATTR_EX6_UNK20 20
0×00200000 SPELL_ATTR_EX6_UNK21 21
0×00400000 SPELL_ATTR_EX6_UNK22 22
0×00800000 SPELL_ATTR_EX6_UNK23 23 not set in 3.0.3
0×01000000 SPELL_ATTR_EX6_UNK24 24 not set in 3.0.3
0×02000000 SPELL_ATTR_EX6_UNK25 25 not set in 3.0.3
0×04000000 SPELL_ATTR_EX6_UNK26 26 not set in 3.0.3
0×08000000 SPELL_ATTR_EX6_UNK27 27 not set in 3.0.3
0×10000000 SPELL_ATTR_EX6_UNK28 28 not set in 3.0.3
0×20000000 SPELL_ATTR_EX6_NO_DMG_PERCENT_MODS 29 do not apply damage mods (usually in cases where it has already been applied)
0×40000000 SPELL_ATTR_EX6_UNK30 30 not set in 3.0.3
0×80000000 SPELL_ATTR_EX6_UNK31 31 not set in 3.0.3

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.

Id ENUM Name Description
0×00 – No special requirement.
0×01 SPELL_FACING_FLAG_INFRONT Must be in front of the caster.

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 0 2000
6 5000 0 5000
7 10000 0 10000
8 20000 0 20000
9 30000 0 30000
10 1000 -100 500
11 2000 -100 1000
12 5000 -100 2500
13 30000 -1000 10000
14 3000 0 3000
15 4000 0 4000
16 1500 0 1500
17 NA NA NA
18 -1000000 0 -1000000
19 2500 0 2500
20 2500 0 2500
21 2600 0 2600
22 3500 0 3500
23 1800 0 1800
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 0 300000
90 1700 0 1700
91 2800 0 2800
170 8000 0 8000
171 6000 0 6000
192 15000 0 15000
193 12000 0 12000
193 12000 0 12000
195 1100 0 0
196 750 0 0
197 850 0 0
198 900 0 0
199 333 0 333

RecoveryTime

CategoryRecoveryTime

InterruptFlags

Bit Enum name Comment
0×01 SPELL_INTERRUPT_FLAG_MOVEMENT
0×02 SPELL_INTERRUPT_FLAG_DAMAGE
0×04 SPELL_INTERRUPT_FLAG_INTERRUPT
0×08 SPELL_INTERRUPT_FLAG_AUTOATTACK
0×10 SPELL_INTERRUPT_FLAG_ABORT_ON_DMG // complete interrupt on direct damage
0×20 SPELL_INTERRUPT_UNK // unk, 564 of 727 spells having this spell start with “Glyph”

AuraInterruptFlags

Bit Enum name Comment
0×00000001 AURA_INTERRUPT_FLAG_HITBYSPELL removed when getting hit by a negative spell
0×00000002 AURA_INTERRUPT_FLAG_DAMAGE removed by any damage
0×00000004 AURA_INTERRUPT_FLAG_UNK2
0×00000008 AURA_INTERRUPT_FLAG_MOVE removed by any movement
0×00000010 AURA_INTERRUPT_FLAG_TURNING removed by any turning
0×00000020 AURA_INTERRUPT_FLAG_ENTER_COMBAT removed by entering combat
0×00000040 AURA_INTERRUPT_FLAG_NOT_MOUNTED removed by unmounting
0×00000080 AURA_INTERRUPT_FLAG_NOT_ABOVEWATER removed by entering water
0×00000100 AURA_INTERRUPT_FLAG_NOT_UNDERWATER removed by leaving water
0×00000200 AURA_INTERRUPT_FLAG_NOT_SHEATHED removed by unsheathing
0×00000400 AURA_INTERRUPT_FLAG_TALK talk to npc / loot? action on creature
0×00000800 AURA_INTERRUPT_FLAG_USE mine/use/open action on gameobject
0×00001000 AURA_INTERRUPT_FLAG_MELEE_ATTACK removed by attack
0×00002000 AURA_INTERRUPT_FLAG_UNK13
0×00004000 AURA_INTERRUPT_FLAG_UNK14
0×00008000 AURA_INTERRUPT_FLAG_UNK15 removed by casting a spell?
0×00010000 AURA_INTERRUPT_FLAG_UNK16
0×00020000 AURA_INTERRUPT_FLAG_MOUNTING removed by mounting
0×00040000 AURA_INTERRUPT_FLAG_NOT_SEATED removed by standing up (used by food and drink mostly and sleep/Fake Death like)
0×00080000 AURA_INTERRUPT_FLAG_CHANGE_MAP leaving map/getting teleported
0×00100000 AURA_INTERRUPT_FLAG_IMMUNE_OR_LOST_SELECTION removed by auras that make you invulnerable, or make other to loose selection on you
0×00200000 AURA_INTERRUPT_FLAG_UNK21
0×00400000 AURA_INTERRUPT_FLAG_TELEPORTED
0×00800000 AURA_INTERRUPT_FLAG_ENTER_PVP_COMBAT removed by entering pvp combat
0×01000000 AURA_INTERRUPT_FLAG_DIRECT_DAMAGE removed by any direct damage
0×02000000 AURA_INTERRUPT_FLAG_LANDING removed by hitting the ground or water

ChannelInterruptFlags

Bit Enum name Comment
0×0001 CHANNEL_FLAG_UNK
0×0002 CHANNEL_FLAG_DAMAGE
0×0008 CHANNEL_FLAG_MOVEMENT
0×0010 CHANNEL_FLAG_TURNING
0×0080 CHANNEL_FLAG_DAMAGE2
0×1000 CHANNEL_FLAG_UNK2
0×4000 CHANNEL_FLAG_DELAY

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

Duration Description Bit Extra
DURATION_MAX_10_SEC 1
DURATION_BMAX_30_SEC 2 BaseDuration 300000010
DURATION_MAX_60_SEC 3
DURATION_MAX_120_SEC 4
DURATION_MAX_300_SEC 5
DURATION_MAX_600_SEC 6
DURATION_BMAX_5_SEC_1 7 BaseDuration 5000000
DURATION_MAX_15_SEC 8
DURATION_MAX_30_SEC 9
DURATION_BMAX_60_SEC 10 BaseDuration 60000000
DURATION_BPMAX_15_SEC 11 BaseDuration 100000000 PerLevel 200
DURATION_BPMAX_40_SEC_1 12 BaseDuration 30000000 PerLevel 200
DURATION_BPMAX_80_SEC_1 13 BaseDuration 6000000 PerLevel 200
DURATION_BPMAX_3_HRS 14 BaseDuration 12000000 PerLevel 10000
DURATION_BPMAX_7_HRS 15 BaseDuration 30000000 PerLevel 10000
DURATION_MAX_230_MIN 16
DURATION_BPMAX_7_SEC 17 BaseDuration 5000000 PerLevel 100
DURATION_MAX_20_SEC 18
DURATION_BPMAX_40_SEC_2 19 BaseDuration 3000000 PerLevel 500
DURATION_BPMAX_80_SEC_2 20 BaseDuration 60000000 PerLevel 1000
DURATION_MAX_INFINITY 21
DURATION_MAX_45_SEC 22
DURATION_MAX_90_SEC 23
DURATION_MAX_160_SEC 24
DURATION_MAX_180_SEC 25
DURATION_MAX_240_SEC 26
DURATION_MAX_3_SEC 27
DURATION_MAX_5_SEC 28
DURATION_MAX_12_SEC 29
DURATION_MAX_30_MIN 30
DURATION_MAX_8_SEC 31
DURATION_MAX_6_SEC 32
DURATION_MAX_4_SEC 35
DURATION_MAX_1_SEC 36
DURATION_MAX_1_MSEC 37
DURATION_MAX_11_SEC 38
DURATION_MAX_2_SEC 39
DURATION_MAX_20_MIN 40
DURATION_MAX_6_MIN 41
DURATION_MAX_60_MIN 42
DURATION_MAX_75_SEC 62
DURATION_MAX_25_SEC 63
DURATION_MAX_40_SEC 64
DURATION_MAX_1_5_SEC 65
DURATION_MAX_2_5_SEC 66
DURATION_MAX_18_SEC 85
DURATION_MAX_21_SEC 86
DURATION_MAX_9_SEC 105
DURATION_MAX_24_SEC 106
DURATION_MAX_35_SEC 125
DURATION_MAX_45_MIN 145
DURATION_MAX_7_SEC 165
DURATION_BMAX_21_SEC 185 BaseDuration 6000
DURATION_BMAX_22_SEC 186 BaseDuration 2000
DURATION_BMAX_5_SEC_2 187 BaseDuration 0
DURATION_MAX_27_SEC 205
DURATION_MAX_7_DAYS 225
DURATION_MAX_50_SEC 245
DURATION_MAX_55_SEC 265
DURATION_BMAX_6_SEC_1 285 BaseDuration 1000
DURATION_MAX_14_SEC 305
DURATION_MAX_36_SEC 325
DURATION_MAX_44_SEC 326
DURATION_MAX_500_MSEC 327
DURATION_MAX_250_MSEC 328
DURATION_MAX_15_MIN 347
DURATION_MAX_2_HRS 367
DURATION_MAX_16_SEC 387
DURATION_MAX_100_MSEC 407
DURATION_BPMAX_10_MIN 427 BaseDuration -600000 PerLevel 60000
DURATION_BMAX_6_SEC_2 447 BaseDuration 2000
DURATION_MAX_22_SEC 467
DURATION_MAX_26_SEC 468
DURATION_MAX_1_7_SEC 487
DURATION_MAX_1_1_SEC_1 507
DURATION_MAX_1_1_SEC_2 508
DURATION_MAX_4_HRS 527
DURATION_MAX_90_MIN 547
DURATION_MAX_3_HRS 548
DURATION_MAX_3_8_SEC 549
DURATION_MAX_24_8_DAYS 550
DURATION_MAX_3_5_SEC 551
DURATION_MAX_210_SEC 552
DURATION_BMAX_16_SEC 553 BaseDuration 6000
DURATION_MAX_155_SEC 554
DURATION_MAX_4_5_SEC 555
DURATION_MAX_28_SEC 556
DURATION_MAX_165_SEC 557
DURATION_MAX_114_SEC 558
DURATION_MAX_53_SEC 559
DURATION_MAX_299_SEC 560
DURATION_MAX_55_MIN 561
DURATION_MAX_150_SEC 562
DURATION_MAX_20_5_SEC 563
DURATION_MAX_13_SEC 564
DURATION_MAX_70_SEC 565
DURATION_MAX_0_SEC 566
DURATION_MAX_135_SEC 567
DURATION_MAX_1250_MSEC 568
DURATION_MAX_280_SEC 569
DURATION_MAX_32_SEC 570
DURATION_MAX_5_5_SEC 571
DURATION_MAX_100_SEC 572
DURATION_MAX_9999_MSEC 573
DURATION_MAX_200_MSEC 574
DURATION_MAX_17_SEC 575
DURATION_MAX_12_HRS 576
DURATION_MAX_18_HRS 580

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

EffectMechanicN

The mechanic of the effect with the same id `N` (e.g. `EffectMechanic1` relates to `Effect1`). There are up to three effects, N = {1,2,3}. See Mechanic.

EffectImplicitTargetAN

The target of the effect with the same id `N` (e.g. `EffectImplicitTargetA1` relates to `Effect1`). There are up to three effects, N = {1,2,3}.

For example: Food buff item spells usually work on the player eating them, indicated by `TARGET_UNIT_CASTER` (`1`).

Id Enum name
0 TARGET_NONE
1 TARGET_UNIT_CASTER
2 TARGET_UNIT_ENEMY_NEAR_CASTER
3 TARGET_UNIT_FRIEND_NEAR_CASTER
4 TARGET_UNIT_NEAR_CASTER
5 TARGET_UNIT_CASTER_PET
6 TARGET_UNIT_ENEMY
7 TARGET_ENUM_UNITS_SCRIPT_AOE_AT_SRC_LOC
8 TARGET_ENUM_UNITS_SCRIPT_AOE_AT_DEST_LOC
9 TARGET_LOCATION_CASTER_HOME_BIND
10 TARGET_LOCATION_CASTER_DIVINE_BIND_NYI
11 TARGET_PLAYER_NYI
12 TARGET_PLAYER_NEAR_CASTER_NYI
13 TARGET_PLAYER_ENEMY_NYI
14 TARGET_PLAYER_FRIEND_NYI
15 TARGET_ENUM_UNITS_ENEMY_AOE_AT_SRC_LOC
16 TARGET_ENUM_UNITS_ENEMY_AOE_AT_DEST_LOC
17 TARGET_LOCATION_DATABASE
18 TARGET_LOCATION_CASTER_DEST
19 TARGET_UNK_19
20 TARGET_ENUM_UNITS_PARTY_WITHIN_CASTER_RANGE
21 TARGET_UNIT_FRIEND
22 TARGET_LOCATION_CASTER_SRC
23 TARGET_GAMEOBJECT
24 TARGET_ENUM_UNITS_ENEMY_IN_CONE_24
25 TARGET_UNIT
26 TARGET_LOCKED
27 TARGET_UNIT_CASTER_MASTER
28 TARGET_ENUM_UNITS_ENEMY_AOE_AT_DYNOBJ_LOC
29 TARGET_ENUM_UNITS_FRIEND_AOE_AT_DYNOBJ_LOC
30 TARGET_ENUM_UNITS_FRIEND_AOE_AT_SRC_LOC
31 TARGET_ENUM_UNITS_FRIEND_AOE_AT_DEST_LOC
32 TARGET_LOCATION_UNIT_MINION_POSITION
33 TARGET_ENUM_UNITS_PARTY_AOE_AT_SRC_LOC
34 TARGET_ENUM_UNITS_PARTY_AOE_AT_DEST_LOC
35 TARGET_UNIT_PARTY
36 TARGET_ENUM_UNITS_ENEMY_WITHIN_CASTER_RANGE
37 TARGET_UNIT_FRIEND_AND_PARTY
38 TARGET_UNIT_SCRIPT_NEAR_CASTER
39 TARGET_LOCATION_CASTER_FISHING_SPOT
40 TARGET_GAMEOBJECT_SCRIPT_NEAR_CASTER
41 TARGET_LOCATION_CASTER_FRONT_RIGHT
42 TARGET_LOCATION_CASTER_BACK_RIGHT
43 TARGET_LOCATION_CASTER_BACK_LEFT
44 TARGET_LOCATION_CASTER_FRONT_LEFT
45 TARGET_UNIT_FRIEND_CHAIN_HEAL
46 TARGET_LOCATION_SCRIPT_NEAR_CASTER
47 TARGET_LOCATION_CASTER_FRONT
48 TARGET_LOCATION_CASTER_BACK
49 TARGET_LOCATION_CASTER_LEFT
50 TARGET_LOCATION_CASTER_RIGHT
51 TARGET_ENUM_GAMEOBJECTS_SCRIPT_AOE_AT_SRC_LOC
52 TARGET_ENUM_GAMEOBJECTS_SCRIPT_AOE_AT_DEST_LOC
53 TARGET_LOCATION_CASTER_TARGET_POSITION
54 TARGET_ENUM_UNITS_ENEMY_IN_CONE_54
55 TARGET_LOCATION_CASTER_FRONT_LEAP
56 TARGET_ENUM_UNITS_RAID_WITHIN_CASTER_RANGE
57 TARGET_UNIT_RAID
58 TARGET_UNIT_RAID_NEAR_CASTER
59 TARGET_ENUM_UNITS_FRIEND_IN_CONE
60 TARGET_ENUM_UNITS_SCRIPT_IN_CONE_60
61 TARGET_UNIT_RAID_AND_CLASS
62 TARGET_PLAYER_RAID_NYI
63 TARGET_LOCATION_UNIT_POSITION
64 TARGET_LOCATION_UNIT_FRONT
65 TARGET_LOCATION_UNIT_BACK
66 TARGET_LOCATION_UNIT_RIGHT
67 TARGET_LOCATION_UNIT_LEFT
68 TARGET_LOCATION_UNIT_FRONT_RIGHT
69 TARGET_LOCATION_UNIT_BACK_RIGHT
70 TARGET_LOCATION_UNIT_BACK_LEFT
71 TARGET_LOCATION_UNIT_FRONT_LEFT
72 TARGET_LOCATION_CASTER_RANDOM_SIDE
73 TARGET_LOCATION_CASTER_RANDOM_CIRCUMFERENCE
74 TARGET_LOCATION_UNIT_RANDOM_SIDE
75 TARGET_LOCATION_UNIT_RANDOM_CIRCUMFERENCE
76 TARGET_LOCATION_DYNOBJ_POSITION
77 TARGET_UNIT_CHANNEL_TARGET
78 TARGET_LOCATION_NORTH
79 TARGET_LOCATION_SOUTH
80 TARGET_LOCATION_EAST
81 TARGET_LOCATION_WEST
82 TARGET_LOCATION_NE
83 TARGET_LOCATION_NW
84 TARGET_LOCATION_SE
85 TARGET_LOCATION_SW
86 TARGET_LOCATION_RANDOM_SIDE
87 TARGET_LOCATION_CURRENT_REFERENCE
88 TARGET_ENUM_UNITS_SCRIPT_AOE_AT_DYNOBJ_LOC
89 TARGET_LOCATION_TRAJECTORY
90 TARGET_UNIT_CASTER_COMPANION
91 TARGET_LOCATION_RANDOM_CIRCUMFERENCE
92 TARGET_UNIT_CASTER_SUMMONER
93 TARGET_CORPSE_ENEMY_NEAR_CASTER_NYI

EffectImplicitTargetBN

See EffectImplicitTargetAN.

EffectRadiusIndex1

EffectApplyAuraName1

EffectAmplitude1

EffectMultipleValue1

EffectChainTarget1

EffectItemType1

EffectMiscValue1

EffectMiscValueB1

EffectTriggerSpell1

EffectPointsPerComboPoint1

SpellVisual

SpellIconID

activeIconID

spellPriority

SpellName

Rank

ManaCostPercentage

StartRecoveryCategory

StartRecoveryTime

MaxTargetLevel

SpellFamilyName

ID Name
0 SPELLFAMILY_GENERIC
1 SPELLFAMILY_UNK1 // events, holidays
2 unused
3 SPELLFAMILY_MAGE
4 SPELLFAMILY_WARRIOR
5 SPELLFAMILY_WARLOCK
6 SPELLFAMILY_PRIEST
7 SPELLFAMILY_DRUID
8 SPELLFAMILY_ROGUE
9 SPELLFAMILY_HUNTER
10 SPELLFAMILY_PALADIN
11 SPELLFAMILY_SHAMAN
12 SPELLFAMILY_UNK2
13 SPELLFAMILY_POTION
14 unused
15 SPELLFAMILY_DEATHKNIGHT
16 unused
17 SPELLFAMILY_UNK3

SpellFamilyFlags

MaxAffectedTargets

DmgClass

PreventionType

Id Name
0 SPELL_PREVENTION_TYPE_NONE
1 SPELL_PREVENTION_TYPE_SILENCE
2 SPELL_PREVENTION_TYPE_PACIFY

DmgMultiplier1

TotemCategory1

TotemCategory2

AreaId

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

SchoolMask

IsServerSide

AttributesServerside

Id Description
0 Default Spell.sql Data
1 Ported Spell from other CMaNGOS Spell.sql
2 Designed serverside Spell using spell.xml

TODO: Describe rest of columns
|24|casterAuraSpell|uint|
|25|targetAuraSpell|uint|
|26|excludeCasterAuraSpell|uint|
|27|excludeTargetAuraSpell|uint|
|28|CastingTimeIndex|uint|
|29|RecoveryTime|uint|
|30|CategoryRecoveryTime|uint|
|31|InterruptFlags|uint|
|32|AuraInterruptFlags|uint|
|33|ChannelInterruptFlags|uint|
|34|procFlags|uint|
|35|procChance|uint|
|36|procCharges|uint|
|37|maxLevel|uint|
|38|baseLevel|uint|
|39|spellLevel|uint|
|40|DurationIndex|uint|
|42|manaCost|uint|
|43|manaCostPerlevel|uint|
|44|manaPerSecond|uint|
|45|manaPerSecondPerLevel|uint|
|46|rangeIndex|uint|
|47|speed|float|
|48|modalNextSpell|uint|
|49|StackAmount|uint|
|50|Totem1|uint|
|51|Totem2|uint|
|52|Reagent1|int|
|53|Reagent2|int|
|54|Reagent3|int|
|55|Reagent4|int|
|56|Reagent5|int|
|57|Reagent6|int|
|58|Reagent7|int|
|59|Reagent8|int|
|60|ReagentCount1|uint|
|61|ReagentCount2|uint|
|62|ReagentCount3|uint|
|63|ReagentCount4|uint|
|64|ReagentCount5|uint|
|65|ReagentCount6|uint|
|66|ReagentCount7|uint|
|67|ReagentCount8|uint|
|68|EquippedItemClass|int|
|69|EquippedItemSubClassMask|int|
|70|EquippedItemInventoryTypeMask|int|
|71|Effect1|uint|
|72|Effect2|uint|
|73|Effect3|uint|
|75|EffectDieSides2|int|
|76|EffectDieSides3|int|
|77|EffectRealPointsPerLevel1|float|
|78|EffectRealPointsPerLevel2|float|
|79|EffectRealPointsPerLevel3|float|
|81|EffectBasePoints2|int|
|82|EffectBasePoints3|int|
|83|EffectMechanic1|uint|
|84|EffectMechanic2|uint|
|85|EffectMechanic3|uint|
|86|EffectImplicitTargetA1|uint|
|87|EffectImplicitTargetA2|uint|
|88|EffectImplicitTargetA3|uint|
|89|EffectImplicitTargetB1|uint|
|90|EffectImplicitTargetB2|uint|
|91|EffectImplicitTargetB3|uint|
|92|EffectRadiusIndex1|uint|
|93|EffectRadiusIndex2|uint|
|94|EffectRadiusIndex3|uint|
|95|EffectApplyAuraName1|uint|
|96|EffectApplyAuraName2|uint|
|97|EffectApplyAuraName3|uint|
|98|EffectAmplitude1|uint|
|99|EffectAmplitude2|uint|
|100|EffectAmplitude3|uint|
|101|EffectValueMultiplier1|float|
|102|EffectValueMultiplier2|float|
|103|EffectValueMultiplier3|float|
|104|EffectChainTarget1|uint|
|105|EffectChainTarget2|uint|
|106|EffectChainTarget3|uint|
|107|EffectItemType1|uint|
|108|EffectItemType2|uint|
|109|EffectItemType3|uint|
|110|EffectMiscValue1|int|
|111|EffectMiscValue2|int|
|112|EffectMiscValue3|int|
|113|EffectMiscValueB1|int|
|114|EffectMiscValueB2|int|
|115|EffectMiscValueB3|int|
|116|EffectTriggerSpell1|uint|
|117|EffectTriggerSpell2|uint|
|118|EffectTriggerSpell3|uint|
|119|EffectPointsPerComboPoint1|float|
|120|EffectPointsPerComboPoint2|float|
|121|EffectPointsPerComboPoint3|float|
|122|EffectSpellClassMask1|flag96|
|123|EffectSpellClassMask2|flag96|
|124|EffectSpellClassMask3|flag96|
|125|EffectSpellClassMask4|flag96|
|126|EffectSpellClassMask5|flag96|
|127|EffectSpellClassMask6|flag96|
|128|EffectSpellClassMask7|flag96|
|129|EffectSpellClassMask8|flag96|
|130|EffectSpellClassMask9|flag96|
|131|SpellVisual1|uint|
|132|SpellVisual2|uint|
|133|SpellIconID|uint|
|134|activeIconID|uint|
|135|spellPriority|uint|
|136|SpellName_0|string|
|137|SpellName_1|string|
|138|SpellName_2|string|
|139|SpellName_3|string|
|140|SpellName_4|string|
|141|SpellName_5|string|
|142|SpellName_6|string|
|143|SpellName_7|string|
|144|SpellName_8|string|
|145|SpellName_9|string|
|146|SpellName_10|string|
|147|SpellName_11|string|
|148|SpellName_12|string|
|149|SpellName_13|string|
|150|SpellName_14|string|
|151|SpellName_15|string|
|152|SpellNameFlag|uint|
|153|Rank_0|string|
|154|Rank_1|string|
|155|Rank_2|string|
|156|Rank_3|string|
|157|Rank_4|string|
|158|Rank_5|string|
|159|Rank_6|string|
|160|Rank_7|string|
|161|Rank_8|string|
|162|Rank_9|string|
|163|Rank_10|string|
|164|Rank_11|string|
|165|Rank_12|string|
|166|Rank_13|string|
|167|Rank_14|string|
|168|Rank_15|string|
|169|RankFlags|uint|
|170|Description_0|string|
|171|Description_1|string|
|172|Description_2|string|
|173|Description_3|string|
|174|Description_4|string|
|175|Description_5|string|
|176|Description_6|string|
|177|Description_7|string|
|178|Description_8|string|
|179|Description_9|string|
|180|Description_10|string|
|181|Description_11|string|
|182|Description_12|string|
|183|Description_13|string|
|184|Description_14|string|
|185|Description_15|string|
|186|DescriptionFlags|uint|
|187|ToolTip_0|string|
|188|ToolTip_1|string|
|189|ToolTip_2|string|
|190|ToolTip_3|string|
|191|ToolTip_4|string|
|192|ToolTip_5|string|
|193|ToolTip_6|string|
|194|ToolTip_7|string|
|195|ToolTip_8|string|
|196|ToolTip_9|string|
|197|ToolTip_10|string|
|198|ToolTip_11|string|
|199|ToolTip_12|string|
|200|ToolTip_13|string|
|201|ToolTip_14|string|
|202|ToolTip_15|string|
|203|ToolTipFlags|uint|
|204|ManaCostPercentage|uint|
|205|StartRecoveryCategory|uint|
|206|StartRecoveryTime|uint|
|207|MaxTargetLevel|uint|
|208|SpellFamilyName|uint|
|209|SpellFamilyFlagsLow|flag96|
|210|SpellFamilyFlagsHigh|flag96|
|211|SpellFamilyFlags2|flag96|
|212|MaxAffectedTargets|uint|
|213|DmgClass|uint|
|214|PreventionType|uint|
|215|StanceBarOrder|uint|
|216|EffectDamageMultiplier1|float|
|217|EffectDamageMultiplier2|float|
|218|EffectDamageMultiplier3|float|
|219|MinFactionId|uint|
|220|MinReputation|uint|
|221|RequiredAuraVision|uint|
|222|TotemCategory1|uint|
|223|TotemCategory2|uint|
|225|SchoolMask|uint|
|226|runeCostID|uint|
|227|spellMissileID|uint|
|228|PowerDisplayId|uint|
|229|EffectBonusMultiplier1|float|
|230|EffectBonusMultiplier2|float|
|231|EffectBonusMultiplier3|float|
|232|spellDescriptionVariableID|uint|
|233|SpellDifficultyId|uint|

Add a custom footer

General Links:

Subsystems:

Database Structure:

Additional Data:

Core Repositories:

DB Repositories:

Clone this wiki locally