spell_dbc

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

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

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

-