From a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 Mon Sep 17 00:00:00 2001 From: FrancescoBorzi Date: Mon, 25 Feb 2019 19:24:20 +0100 Subject: Import DB wiki from TC 335 --- docs/spell_dbc.md | 3535 +++++++++++++++++++++++++++++++++++++++++++++++++++-- 1 file changed, 3435 insertions(+), 100 deletions(-) (limited to 'docs/spell_dbc.md') diff --git a/docs/spell_dbc.md b/docs/spell_dbc.md index 5f9de4c..63cd5c7 100644 --- a/docs/spell_dbc.md +++ b/docs/spell_dbc.md @@ -1,100 +1,3435 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [spell_dbc](spell_dbc) - -Column | Type | Description ---- | --- | --- -Id | int(10) unsigned | -Dispel | int(10) unsigned | -Mechanic | int(10) unsigned | -Attributes | int(10) unsigned | -AttributesEx | int(10) unsigned | -AttributesEx2 | int(10) unsigned | -AttributesEx3 | int(10) unsigned | -AttributesEx4 | int(10) unsigned | -AttributesEx5 | int(10) unsigned | -AttributesEx6 | int(10) unsigned | -AttributesEx7 | int(10) unsigned | -Stances | int(10) unsigned | -StancesNot | int(10) unsigned | -Targets | int(10) unsigned | -CastingTimeIndex | int(10) unsigned | -AuraInterruptFlags | int(10) unsigned | -ProcFlags | int(10) unsigned | -ProcChance | int(10) unsigned | -ProcCharges | int(10) unsigned | -MaxLevel | int(10) unsigned | -BaseLevel | int(10) unsigned | -SpellLevel | int(10) unsigned | -DurationIndex | int(10) unsigned | -RangeIndex | int(10) unsigned | -StackAmount | int(10) unsigned | -EquippedItemClass | int(11) | -EquippedItemSubClassMask | int(11) | -EquippedItemInventoryTypeMask | int(11) | -Effect1 | int(10) unsigned | -Effect2 | int(10) unsigned | -Effect3 | int(10) unsigned | -EffectDieSides1 | int(11) | -EffectDieSides2 | int(11) | -EffectDieSides3 | int(11) | -EffectRealPointsPerLevel1 | float | -EffectRealPointsPerLevel2 | float | -EffectRealPointsPerLevel3 | float | -EffectBasePoints1 | int(11) | -EffectBasePoints2 | int(11) | -EffectBasePoints3 | int(11) | -EffectMechanic1 | int(10) unsigned | -EffectMechanic2 | int(10) unsigned | -EffectMechanic3 | int(10) unsigned | -EffectImplicitTargetA1 | int(10) unsigned | -EffectImplicitTargetA2 | int(10) unsigned | -EffectImplicitTargetA3 | int(10) unsigned | -EffectImplicitTargetB1 | int(10) unsigned | -EffectImplicitTargetB2 | int(10) unsigned | -EffectImplicitTargetB3 | int(10) unsigned | -EffectRadiusIndex1 | int(10) unsigned | -EffectRadiusIndex2 | int(10) unsigned | -EffectRadiusIndex3 | int(10) unsigned | -EffectApplyAuraName1 | int(10) unsigned | -EffectApplyAuraName2 | int(10) unsigned | -EffectApplyAuraName3 | int(10) unsigned | -EffectAmplitude1 | int(11) | -EffectAmplitude2 | int(11) | -EffectAmplitude3 | int(11) | -EffectMultipleValue1 | float | -EffectMultipleValue2 | float | -EffectMultipleValue3 | float | -EffectItemType1 | int(10) unsigned | -EffectItemType2 | int(10) unsigned | -EffectItemType3 | int(10) unsigned | -EffectMiscValue1 | int(11) | -EffectMiscValue2 | int(11) | -EffectMiscValue3 | int(11) | -EffectMiscValueB1 | int(11) | -EffectMiscValueB2 | int(11) | -EffectMiscValueB3 | int(11) | -EffectTriggerSpell1 | int(10) unsigned | -EffectTriggerSpell2 | int(10) unsigned | -EffectTriggerSpell3 | int(10) unsigned | -EffectSpellClassMaskA1 | int(10) unsigned | -EffectSpellClassMaskA2 | int(10) unsigned | -EffectSpellClassMaskA3 | int(10) unsigned | -EffectSpellClassMaskB1 | int(10) unsigned | -EffectSpellClassMaskB2 | int(10) unsigned | -EffectSpellClassMaskB3 | int(10) unsigned | -EffectSpellClassMaskC1 | int(10) unsigned | -EffectSpellClassMaskC2 | int(10) unsigned | -EffectSpellClassMaskC3 | int(10) unsigned | -MaxTargetLevel | int(10) unsigned | -SpellFamilyName | int(10) unsigned | -SpellFamilyFlags1 | int(10) unsigned | -SpellFamilyFlags2 | int(10) unsigned | -SpellFamilyFlags3 | int(10) unsigned | -MaxAffectedTargets | int(10) unsigned | -DmgClass | int(10) unsigned | -PreventionType | int(10) unsigned | -DmgMultiplier1 | float | -DmgMultiplier2 | float | -DmgMultiplier3 | float | -AreaGroupId | int(11) | -SchoolMask | int(10) unsigned | -Comment | text | +# 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](https://trinitycore.atlassian.net/wiki/display/tc/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](#spell_dbc-Effect). +\\ border="1" + + +++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

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