AzerothCore
Posts (Latest 10 updated) :
Read all

spell_dbc

<-Back-to:World

The `spell_dbc` table

This table contains data regarding serverside spells which are not to be found in Client DBC files.

Note: Not longer used since Warlords of Draenor Expansion (see Hotfixes)

Structure

Field

Type

Attributes

Key

Null

Default

Extra

Comment

Id

int(10)

unsigned

PRI

NO

NULL



Dispel

tinyint(3)

unsigned


NO

0



Mechanic

tinyint(3)

unsigned


NO

0



Attributes

int(10)

unsigned


NO

0



AttributesEx

int(10)

unsigned


NO

0



AttributesEx2

int(10)

unsigned


NO

0



AttributesEx3

int(10)

unsigned


NO

0



AttributesEx4

int(10)

unsigned


NO

0



AttributesEx5

int(10)

unsigned


NO

0



Stances

int(10)

unsigned


NO

0



StancesNot

int(10)

unsigned


NO

0



Targets

int(10)

unsigned


NO

0



CastingTimeIndex

tinyint(3)

unsigned


NO

1



AuraInterruptFlags

int(10)

unsigned


NO

0



ProcFlags

int(10)

unsigned


NO

0



ProcChance

tinyint(3)

unsigned


NO

0



ProcCharges

tinyint(3)

unsigned


NO

0



MaxLevel

tinyint(3)

unsigned


NO

0



BaseLevel

tinyint(3)

unsigned


NO

0



SpellLevel

tinyint(3)

unsigned


NO

0



DurationIndex

smallint(5)

unsigned


NO

0



RangeIndex

tinyint(3)

unsigned


NO

1



StackAmount

tinyint(3)

unsigned


NO

0



EquippedItemClass

int(11)

signed


NO

-1



EquippedItemSubClassMask

int(11)

signed


NO

0



EquippedItemInventoryTypeMask

int(11)

signed


NO

0



Effect1

tinyint(3)

unsigned


NO

0



Effect2

tinyint(3)

unsigned


NO

0



Effect3

tinyint(3)

unsigned


NO

0



EffectDieSides1

int(11)

signed


NO

0



EffectDieSides2

int(11)

signed


NO

0



EffectDieSides3

int(11)

signed


NO

0



EffectRealPointsPerLevel1

float

signed


NO

0



EffectRealPointsPerLevel2

float

signed


NO

0



EffectRealPointsPerLevel3

float

signed


NO

0



EffectBasePoints1

int(11)

signed


NO

0



EffectBasePoints2

int(11)

signed


NO

0



EffectBasePoints3

int(11)

signed


NO

0



EffectMechanic1

tinyint(3)

unsigned


NO

0



EffectMechanic2

tinyint(3)

unsigned


NO

0



EffectMechanic3

tinyint(3)

unsigned


NO

0



EffectImplicitTargetA1

tinyint(3)

unsigned


NO

0



EffectImplicitTargetA2

tinyint(3)

unsigned


NO

0



EffectImplicitTargetA3

tinyint(3)

unsigned


NO

0



EffectImplicitTargetB1

tinyint(3)

unsigned


NO

0



EffectImplicitTargetB2

tinyint(3)

unsigned


NO

0



EffectImplicitTargetB3

tinyint(3)

unsigned


NO

0



EffectRadiusIndex1

tinyint(3)

unsigned


NO

0



EffectRadiusIndex2

tinyint(3)

unsigned


NO

0



EffectRadiusIndex3

tinyint(3)

unsigned


NO

0



EffectApplyAuraName1

smallint(5)

unsigned


NO

0



EffectApplyAuraName2

smallint(5)

unsigned


NO

0



EffectApplyAuraName3

smallint(5)

unsigned


NO

0



EffectAmplitude1

int(11)

signed


NO

0



EffectAmplitude2

int(11)

signed


NO

0



EffectAmplitude3

int(11)

signed


NO

0



EffectMultipleValue1

float

signed


NO

0



EffectMultipleValue2

float

signed


NO

0



EffectMultipleValue3

float

signed


NO

0



EffectMiscValue1

int(11)

signed


NO

0



EffectMiscValue2

int(11)

signed


NO

0



EffectMiscValue3

int(11)

signed


NO

0



EffectMiscValueB1

int(11)

signed


NO

0



EffectMiscValueB2

int(11)

signed


NO

0



EffectMiscValueB3

int(11)

signed


NO

0



EffectTriggerSpell1

int(10)

unsigned


NO

0



EffectTriggerSpell2

int(10)

unsigned


NO

0



EffectTriggerSpell3

int(10)

unsigned


NO

0



EffectSpellClassMaskA1

int(10)

unsigned


NO

0



EffectSpellClassMaskA2

int(10)

unsigned


NO

0



EffectSpellClassMaskA3

int(10)

unsigned


NO

0



EffectSpellClassMaskB1

int(10)

unsigned


NO

0



EffectSpellClassMaskB2

int(10)

unsigned


NO

0



EffectSpellClassMaskB3

int(10)

unsigned


NO

0



EffectSpellClassMaskC1

int(10)

unsigned


NO

0



EffectSpellClassMaskC2

int(10)

unsigned


NO

0



EffectSpellClassMaskC3

int(10)

unsigned


NO

0



MaxTargetLevel

tinyint(3)

unsigned


NO

0



SpellFamilyName

tinyint(3)

unsigned


NO

0



SpellFamilyFlags1

int(10)

unsigned


NO

0



SpellFamilyFlags2

int(10)

unsigned


NO

0



SpellFamilyFlags3

int(10)

unsigned


NO

0



MaxAffectedTargets

tinyint(3)

unsigned


NO

0



DmgClass

tinyint(3)

unsigned


NO

0



PreventionType

tinyint(3)

unsigned


NO

0



DmgMultiplier1

float

signed


NO

0



DmgMultiplier2

float

signed


NO

0



DmgMultiplier3

float

signed


NO

0



AreaGroupId

int(11)

signed


NO

0



SchoolMask

int(10)

unsigned


NO

0



Comment

text

signed


NO

NULL



Description of the fields

Id

The id of the Spell.

Dispel

field-no-description|2

Mechanic

field-no-description|3

Attributes

field-no-description|4

AttributesEx

field-no-description|5

Stances

field-no-description|6

StancesNot

field-no-description|7

Targets

field-no-description|8

CastingTimeIndex

field-no-description|9

AuraInterruptFlags

field-no-description|10

ProcFlags

field-no-description|11

ProcChance

field-no-description|12

ProcCharges

field-no-description|13

MaxLevel

field-no-description|14

BaseLevel

field-no-description|15

SpellLevel

field-no-description|16

DurationIndex

field-no-description|17

RangeIndex

field-no-description|18

StackAmount

field-no-description|19

EquippedItemClass

field-no-description|20

EquippedItemSubClassMask

field-no-description|21

EquippedItemInventoryTypeMask

field-no-description|22

Effect

Effect1, Effect2 and Effect3. Effect_ID of the Spell_Effect. A Spell can only have up to three Spell_Effects.

EffectDieSides

field-no-description|24

EffectRealPointsPerLevel

field-no-description|25

EffectBasePoints

field-no-description|26

EffectMechanic

field-no-description|27

EffectImplicitTargetA

field-no-description|28

EffectImplicitTargetB

field-no-description|29

EffectRadiusIndex

field-no-description|30

EffectApplyAuraName

field-no-description|31

EffectAmplitude

field-no-description|32

EffectMultipleValue

field-no-description|33

EffectMiscValue

field-no-description|34

EffectMiscValueB

field-no-description|35

EffectTriggerSpell

field-no-description|36

EffectSpellClassMaskA

field-no-description|37

EffectSpellClassMaskB

field-no-description|38

EffectSpellClassMaskC

field-no-description|39

MaxTargetLevel

field-no-description|40

SpellFamilyName

field-no-description|41

SpellFamilyFlags

field-no-description|42

MaxAffectedTarget

field-no-description|43

DmgClass

field-no-description|44

PreventionType

field-no-description|45

DmgMultiplier

field-no-description|46

AreaGroupId

field-no-description|47

SchoolMask

field-no-description|48

Comment

field-no-description|49

SPELL_EFFECT_ID

Effect_IDs of Effect1, Effect2 and/or Effect3.

Effect_ID Spell_Effect Description
0 EffectNULL NULL
1 EffectInstaKill SPELL_EFFECT_INSTAKILL
2 EffectSchoolDMG SPELL_EFFECT_SCHOOL_DAMAGE
3 EffectDummy SPELL_EFFECT_DUMMY
4 EffectUnused SPELL_EFFECT_PORTAL_TELEPORT unused
5 EffectTeleportUnits SPELL_EFFECT_TELEPORT_UNITS
6 EffectApplyAura SPELL_EFFECT_APPLY_AURA
7 EffectEnvirinmentalDMG SPELL_EFFECT_ENVIRONMENTAL_DAMAGE
8 EffectPowerDrain SPELL_EFFECT_POWER_DRAIN
9 EffectHealthLeech SPELL_EFFECT_HEALTH_LEECH
10 EffectHeal SPELL_EFFECT_HEAL
11 EffectBind SPELL_EFFECT_BIND
12 EffectNULL SPELL_EFFECT_PORTAL
13 EffectUnused SPELL_EFFECT_RITUAL_BASE unused
14 EffectUnused SPELL_EFFECT_RITUAL_SPECIALIZE unused
15 EffectUnused SPELL_EFFECT_RITUAL_ACTIVATE_PORTAL unused
16 EffectQuestComplete SPELL_EFFECT_QUEST_COMPLETE
17 EffectWeaponDmg SPELL_EFFECT_WEAPON_DAMAGE_NOSCHOOL
18 EffectResurrect SPELL_EFFECT_RESURRECT
19 EffectAddExtraAttacks SPELL_EFFECT_ADD_EXTRA_ATTACKS
20 EffectUnused SPELL_EFFECT_DODGE one spell: Dodge
21 EffectUnused SPELL_EFFECT_EVADE one spell: Evade (DND)
22 EffectParry SPELL_EFFECT_PARRY
23 EffectBlock SPELL_EFFECT_BLOCK one spell: Block
24 EffectCreateItem SPELL_EFFECT_CREATE_ITEM
25 EffectUnused SPELL_EFFECT_WEAPON
26 EffectUnused SPELL_EFFECT_DEFENSE one spell: Defense
27 EffectPersistentAA SPELL_EFFECT_PERSISTENT_AREA_AURA
28 EffectSummonType SPELL_EFFECT_SUMMON
29 EffectLeap SPELL_EFFECT_LEAP
30 EffectEnergize SPELL_EFFECT_ENERGIZE
31 EffectWeaponDmg SPELL_EFFECT_WEAPON_PERCENT_DAMAGE
32 EffectTriggerMissileSpell SPELL_EFFECT_TRIGGER_MISSILE
33 EffectOpenLock SPELL_EFFECT_OPEN_LOCK
34 EffectSummonChangeItem SPELL_EFFECT_SUMMON_CHANGE_ITEM
35 EffectApplyAreaAura SPELL_EFFECT_APPLY_AREA_AURA_PARTY
36 EffectLearnSpell SPELL_EFFECT_LEARN_SPELL
37 EffectUnused SPELL_EFFECT_SPELL_DEFENSE one spell: SPELLDEFENSE (DND)
38 EffectDispel SPELL_EFFECT_DISPEL
39 EffectUnused SPELL_EFFECT_LANGUAGE
40 EffectDualWield SPELL_EFFECT_DUAL_WIELD
41 EffectJump SPELL_EFFECT_JUMP
42 EffectJumpDest SPELL_EFFECT_JUMP_DEST
43 EffectTeleUnitsFaceCaster SPELL_EFFECT_TELEPORT_UNITS_FACE_CASTER
44 EffectLearnSkill SPELL_EFFECT_SKILL_STEP
45 EffectAddHonor SPELL_EFFECT_ADD_HONOR
46 EffectUnused SPELL_EFFECT_SPAWN clientside, unit appears as if it was just spawned
47 EffectTradeSkill SPELL_EFFECT_TRADE_SKILL
48 EffectUnused SPELL_EFFECT_STEALTH one spell: Base Stealth
49 EffectUnused SPELL_EFFECT_DETECT one spell: Detect
50 EffectTransmitted SPELL_EFFECT_TRANS_DOOR
51 EffectUnused SPELL_EFFECT_FORCE_CRITICAL_HIT unused
52 EffectUnused SPELL_EFFECT_GUARANTEE_HIT one spell: zzOLDCritical Shot
53 EffectEnchantItemPerm SPELL_EFFECT_ENCHANT_ITEM
54 EffectEnchantItemTmp SPELL_EFFECT_ENCHANT_ITEM_TEMPORARY
55 EffectTameCreature SPELL_EFFECT_TAMECREATURE
56 EffectSummonPet SPELL_EFFECT_SUMMON_PET
57 EffectLearnPetSpell SPELL_EFFECT_LEARN_PET_SPELL
58 EffectWeaponDmg SPELL_EFFECT_WEAPON_DAMAGE
59 EffectCreateRandomItem SPELL_EFFECT_CREATE_RANDOM_ITEM create item base at spell specific loot
60 EffectProficiency SPELL_EFFECT_PROFICIENCY
61 EffectSendEvent SPELL_EFFECT_SEND_EVENT
62 EffectPowerBurn SPELL_EFFECT_POWER_BURN
63 EffectThreat SPELL_EFFECT_THREAT
64 EffectTriggerSpell SPELL_EFFECT_TRIGGER_SPELL
65 EffectApplyAreaAura SPELL_EFFECT_APPLY_AREA_AURA_RAID
66 EffectRechargeManaGem SPELL_EFFECT_CREATE_MANA_GEM (possibly recharge it, misc - is item ID)
67 EffectHealMaxHealth SPELL_EFFECT_HEAL_MAX_HEALTH
68 EffectInterruptCast SPELL_EFFECT_INTERRUPT_CAST
69 EffectDistract SPELL_EFFECT_DISTRACT
70 EffectPull SPELL_EFFECT_PULL one spell: Distract Move
71 EffectPickPocket SPELL_EFFECT_PICKPOCKET
72 EffectAddFarsight SPELL_EFFECT_ADD_FARSIGHT
73 EffectUntrainTalents SPELL_EFFECT_UNTRAIN_TALENTS
74 EffectApplyGlyph SPELL_EFFECT_APPLY_GLYPH
75 EffectHealMechanical SPELL_EFFECT_HEAL_MECHANICAL one spell: Mechanical Patch Kit
76 EffectSummonObjectWild SPELL_EFFECT_SUMMON_OBJECT_WILD
77 EffectScriptEffect SPELL_EFFECT_SCRIPT_EFFECT
78 EffectUnused SPELL_EFFECT_ATTACK
79 EffectSanctuary SPELL_EFFECT_SANCTUARY
80 EffectAddComboPoints SPELL_EFFECT_ADD_COMBO_POINTS
81 EffectUnused SPELL_EFFECT_CREATE_HOUSE one spell: Create House (TEST)
82 EffectNULL SPELL_EFFECT_BIND_SIGHT
83 EffectDuel SPELL_EFFECT_DUEL
84 EffectStuck SPELL_EFFECT_STUCK
85 EffectSummonPlayer SPELL_EFFECT_SUMMON_PLAYER
86 EffectActivateObject SPELL_EFFECT_ACTIVATE_OBJECT
87 EffectWMODamage SPELL_EFFECT_WMO_DAMAGE
88 EffectWMORepair SPELL_EFFECT_WMO_REPAIR
89 EffectWMOChange SPELL_EFFECT_WMO_CHANGE // 0 intact // 1 damaged // 2 destroyed // 3 rebuilding
90 EffectKillCreditPersonal SPELL_EFFECT_KILL_CREDIT Kill credit but only for single person
91 EffectUnused SPELL_EFFECT_THREAT_ALL one spell: zzOLDBrainwash
92 EffectEnchantHeldItem SPELL_EFFECT_ENCHANT_HELD_ITEM
93 EffectForceDeselect SPELL_EFFECT_FORCE_DESELECT
94 EffectSelfResurrect SPELL_EFFECT_SELF_RESURRECT
95 EffectSkinning SPELL_EFFECT_SKINNING
96 EffectCharge SPELL_EFFECT_CHARGE
97 EffectCastButtons SPELL_EFFECT_CAST_BUTTON (totem bar since 3.2.2a)
98 EffectKnockBack SPELL_EFFECT_KNOCK_BACK
99 EffectDisEnchant SPELL_EFFECT_DISENCHANT
100 EffectInebriate SPELL_EFFECT_INEBRIATE
101 EffectFeedPet SPELL_EFFECT_FEED_PET
102 EffectDismissPet SPELL_EFFECT_DISMISS_PET
103 EffectReputation SPELL_EFFECT_REPUTATION
104 EffectSummonObject SPELL_EFFECT_SUMMON_OBJECT_SLOT1
105 EffectSummonObject SPELL_EFFECT_SUMMON_OBJECT_SLOT2
106 EffectSummonObject SPELL_EFFECT_SUMMON_OBJECT_SLOT3
107 EffectSummonObject SPELL_EFFECT_SUMMON_OBJECT_SLOT4
108 EffectDispelMechanic SPELL_EFFECT_DISPEL_MECHANIC
109 EffectSummonDeadPet SPELL_EFFECT_SUMMON_DEAD_PET
110 EffectDestroyAllTotems SPELL_EFFECT_DESTROY_ALL_TOTEMS
111 EffectDurabilityDamage SPELL_EFFECT_DURABILITY_DAMAGE
112 EffectUnused SPELL_EFFECT_112
113 EffectResurrectNew SPELL_EFFECT_RESURRECT_NEW
114 EffectTaunt SPELL_EFFECT_ATTACK_ME
115 EffectDurabilityDamagePCT SPELL_EFFECT_DURABILITY_DAMAGE_PCT
116 EffectSkinPlayerCorpse SPELL_EFFECT_SKIN_PLAYER_CORPSE one spell: Remove Insignia, bg usage, required special corpse flags…
117 EffectSpiritHeal SPELL_EFFECT_SPIRIT_HEAL one spell: Spirit Heal
118 EffectSkill SPELL_EFFECT_SKILL professions and more
119 EffectApplyAreaAura SPELL_EFFECT_APPLY_AREA_AURA_PET
120 EffectUnused SPELL_EFFECT_TELEPORT_GRAVEYARD one spell: Graveyard Teleport Test
121 EffectWeaponDmg SPELL_EFFECT_NORMALIZED_WEAPON_DMG
122 EffectUnused SPELL_EFFECT_122 unused
123 EffectSendTaxi SPELL_EFFECT_SEND_TAXI taxi/flight related (misc value is taxi path id)
124 EffectPullTowards SPELL_EFFECT_PULL_TOWARDS
125 EffectModifyThreatPercent SPELL_EFFECT_MODIFY_THREAT_PERCENT
126 EffectStealBeneficialBuff SPELL_EFFECT_STEAL_BENEFICIAL_BUFF spell steal effect?
127 EffectProspecting SPELL_EFFECT_PROSPECTING Prospecting spell
128 EffectApplyAreaAura SPELL_EFFECT_APPLY_AREA_AURA_FRIEND
129 EffectApplyAreaAura SPELL_EFFECT_APPLY_AREA_AURA_ENEMY
130 EffectRedirectThreat SPELL_EFFECT_REDIRECT_THREAT
131 EffectPlayerNotification SPELL_EFFECT_PLAYER_NOTIFICATION
132 EffectPlayMusic SPELL_EFFECT_PLAY_MUSIC sound id in misc value (SoundEntries.dbc)
133 EffectUnlearnSpecialization SPELL_EFFECT_UNLEARN_SPECIALIZATION unlearn profession specialization
134 EffectKillCredit SPELL_EFFECT_KILL_CREDIT misc value is creature entry
135 EffectNULL SPELL_EFFECT_CALL_PET
136 EffectHealPct SPELL_EFFECT_HEAL_PCT
137 EffectEnergizePct SPELL_EFFECT_ENERGIZE_PCT
138 EffectLeapBack SPELL_EFFECT_LEAP_BACK Leap back
139 EffectQuestClear SPELL_EFFECT_CLEAR_QUEST Reset quest status (miscValue - quest ID)
140 EffectForceCast SPELL_EFFECT_FORCE_CAST
141 EffectForceCastWithValue SPELL_EFFECT_FORCE_CAST_WITH_VALUE
142 EffectTriggerSpellWithValue SPELL_EFFECT_TRIGGER_SPELL_WITH_VALUE
143 EffectApplyAreaAura SPELL_EFFECT_APPLY_AREA_AURA_OWNER
144 EffectKnockBack SPELL_EFFECT_KNOCK_BACK_DEST
145 EffectPullTowards SPELL_EFFECT_PULL_TOWARDS_DEST Black Hole Effect
146 EffectActivateRune SPELL_EFFECT_ACTIVATE_RUNE
147 EffectQuestFail SPELL_EFFECT_QUEST_FAIL quest fail
148 EffectUnused SPELL_EFFECT_148 1 spell - 43509
149 EffectChargeDest SPELL_EFFECT_CHARGE_DEST
150 EffectQuestStart SPELL_EFFECT_QUEST_START
151 EffectTriggerRitualOfSummoning SPELL_EFFECT_TRIGGER_SPELL_2
152 EffectNULL SPELL_EFFECT_152 summon Refer-a-Friend
153 EffectCreateTamedPet SPELL_EFFECT_CREATE_TAMED_PET misc value is creature entry
154 EffectDiscoverTaxi SPELL_EFFECT_DISCOVER_TAXI
155 EffectTitanGrip SPELL_EFFECT_TITAN_GRIP Allows you to equip two-handed axes, maces and swords in one hand, but you attack $49152s1% slower than normal.
156 EffectEnchantItemPrismatic SPELL_EFFECT_ENCHANT_ITEM_PRISMATIC
157 EffectCreateItem2 SPELL_EFFECT_CREATE_ITEM_2 create item or create item template and replace by some randon spell loot item
158 EffectMilling SPELL_EFFECT_MILLING milling
159 EffectRenamePet SPELL_EFFECT_ALLOW_RENAME_PET allow rename pet once again
160 EffectNULL SPELL_EFFECT_160 1 spell - 45534
161 EffectSpecCount SPELL_EFFECT_TALENT_SPEC_COUNT second talent spec (learn/revert)
162 EffectActivateSpec SPELL_EFFECT_TALENT_SPEC_SELECT activate primary/secondary spec
163 EffectNULL unused
164 EffectRemoveAura SPELL_EFFECT_REMOVE_AURA

/td-EffectSkinPlayerCorpseconfluenceTdtrp