Spell dbc tc2

From TrinityCore Wiki
Jump to: navigation, search

Contents

Back to world database list of tables.


The `spell_dbc` table

This table contains data regarding serverside spells which are not to be found in Client DBC files, but that we find in WDB data.


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

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

Mechanic

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

Attributes

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

AttributesEx

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

Stances

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

StancesNot

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

Targets

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

CastingTimeIndex

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

AuraInterruptFlags

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

ProcFlags

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

ProcChance

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

ProcCharges

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

MaxLevel

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

BaseLevel

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

SpellLevel

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

DurationIndex

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

RangeIndex

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

StackAmount

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

EquippedItemClass

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

EquippedItemSubClassMask

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

EquippedItemInventoryTypeMask

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

Effect

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

EffectDieSides

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

EffectRealPointsPerLevel

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

EffectBasePoints

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

EffectMechanic

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

EffectImplicitTargetA

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

EffectImplicitTargetB

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

EffectRadiusIndex

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

EffectApplyAuraName

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

EffectAmplitude

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

EffectMultipleValue

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

EffectMiscValue

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

EffectMiscValueB

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

EffectTriggerSpell

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

EffectSpellClassMaskA

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

EffectSpellClassMaskB

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

EffectSpellClassMaskC

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

MaxTargetLevel

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

SpellFamilyName

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

SpellFamilyFlags

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

MaxAffectedTarget

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

DmgClass

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

PreventionType

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

DmgMultiplier

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

AreaGroupId

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

SchoolMask

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

Comment

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.


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
Personal tools
Namespaces
Variants
Actions
Navigation
Toolbox