From 7a21507aa141a1dd00aaaa572b12e685d8128550 Mon Sep 17 00:00:00 2001
From: avarishd <46330494+avarishd@users.noreply.github.com>
Date: Sat, 1 Apr 2023 21:00:58 +0300
Subject: Add SummonProperties and Spell Effects/Aura Reference (#886)
* add SummonProperties and Spell Effects Reference
* Update dbc-summon-properties.md
* ()
* :(
* update
* some hyperlinks
* update
* up
* update
---
_includes/azerothcore/sidebar.html | 1 +
docs/database-world.md | 1 +
docs/dbc-index.md | 1 +
docs/documentation-index.md | 2 +
docs/spell-aura-reference.md | 488 ++++++++++++++++++++++++++++++++
docs/spell-effects-reference.md | 556 +++++++++++++++++++++++++++++++++++++
docs/spell_dbc.md | 184 +-----------
docs/summonproperties_dbc.md | 118 ++++++++
8 files changed, 1177 insertions(+), 174 deletions(-)
create mode 100644 docs/spell-aura-reference.md
create mode 100644 docs/spell-effects-reference.md
create mode 100644 docs/summonproperties_dbc.md
diff --git a/_includes/azerothcore/sidebar.html b/_includes/azerothcore/sidebar.html
index cf5d5cd..f227d2e 100644
--- a/_includes/azerothcore/sidebar.html
+++ b/_includes/azerothcore/sidebar.html
@@ -68,6 +68,7 @@
Remote Access
Information about waypoints
How to obtain free records
+ Spell Effects Reference
Archive
diff --git a/docs/database-world.md b/docs/database-world.md
index caca1a5..fad282c 100644
--- a/docs/database-world.md
+++ b/docs/database-world.md
@@ -202,6 +202,7 @@
- [spell_target_position](spell_target_position.md)
- [spell_threat](spell_threat.md)
- [spelldifficulty_dbc](spelldifficulty_dbc.md)
+- [summonproperties_dbc](summonproperties_dbc.md)
## T
- [transports](transports.md)
diff --git a/docs/dbc-index.md b/docs/dbc-index.md
index 8848e31..5776b21 100644
--- a/docs/dbc-index.md
+++ b/docs/dbc-index.md
@@ -14,5 +14,6 @@
* [Map](map.md)
* [PageTextMaterial](pagetextmaterial.md)
* [SkillLine](skillline.md)
+* [SummonProperties](summonproperties_dbc.md)
* [Spell](spell.md)
* [TotemCategory](totemcategory.md)
diff --git a/docs/documentation-index.md b/docs/documentation-index.md
index d23e998..cd8e4d3 100644
--- a/docs/documentation-index.md
+++ b/docs/documentation-index.md
@@ -40,6 +40,8 @@ redirect_from: /documentation_index
* [MySQL types (C++)](mysqltypescpp.md)
* [Project Versioning](project-versioning.md)
* [Sniffing & Parsing](sniffing-and-parsing)
+* [Spell Effects Reference](spell-effects-reference.md)
+* [Spell Aura Reference](spell-aura-reference.md)
* [SQL Directory](sql-directory.md)
* [SQL Versioning](sql-versioning.md)
diff --git a/docs/spell-aura-reference.md b/docs/spell-aura-reference.md
new file mode 100644
index 0000000..b7ea120
--- /dev/null
+++ b/docs/spell-aura-reference.md
@@ -0,0 +1,488 @@
+# Spell Aura Reference
+
+[`Back-to:Spell Effects Reference`](spell-effects-reference.md)
+
+[`Back-to:spell_dbc`](spell_dbc.md)
+
+
+### This page contains description regarding the usage of EffectMiscValue and other Spell Aura values.
+### Contains only Spell Auras that have known usage of EffectMiscValue or other unconventional values.
+
+**Version is : 3.3.5a**
+
+# Spell Aura Names
+
+SPELL_AURA_MOD_POSSESS = 2
+- BasePoints: (+Die Points) Up to the level that can be charmed
+
+SPELL_AURA_MOD_CHARM = 6
+- BasePoints: (+Die Points) Up to the level that can be charmed
+
+SPELL_AURA_MOD_THREAT = 10
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MOD_DAMAGE_DONE = 13
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MOD_DAMAGE_TAKEN = 14
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MOD_STEALTH = 16
+- EffectMiscValueA: Stealth Type (0 = General, 1 = Trap)
+
+SPELL_AURA_MOD_STEALTH_DETECT = 17
+- EffectMiscValueA: Stealth Type (0 = General, 1 = Trap)
+
+SPELL_AURA_MOD_INVISIBILITY = 18
+- EffectMiscValueA: [Invisibility Type](#invisibility-type)
+
+SPELL_AURA_MOD_INVISIBILITY_DETECT = 19
+- EffectMiscValueA: [Invisibility Type](#invisibility-type)
+
+SPELL_AURA_OBS_MOD_POWER = 21
+- EffectMiscValueA: [Power Type](#power-type)
+
+SPELL_AURA_MOD_RESISTANCE = 22
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_PERIODIC_TRIGGER_SPELL = 23
+- TriggerSpell: Spell ID
+- Amplitude: The time in MS that the trigger will land.
+
+SPELL_AURA_PERIODIC_ENERGIZE = 24
+- EffectMiscValueA: [Power Type](#power-type)
+
+SPELL_AURA_MOD_STAT = 29
+- EffectMiscValueA: [Stats Type](#stats-type)
+
+SPELL_AURA_MOD_SKILL = 30
+- EffectMiscValueA: [Skill ID](skillline.md)
+
+SPELL_AURA_MOD_INCREASE_ENERGY = 35
+- EffectMiscValueA: [Power Type](#power-type)
+
+SPELL_AURA_MOD_SHAPESHIFT = 36
+- EffectMiscValueA: ID from SpellShapeshiftForm.dbc
+
+SPELL_AURA_EFFECT_IMMUNITY = 37
+- EffectMiscValueA: ID from [Spell Effect](spell-effects-reference.md) to become immune to.
+
+SPELL_AURA_STATE_IMMUNITY = 38
+- EffectMiscValueA: ID from Spell Auras
+
+SPELL_AURA_SCHOOL_IMMUNITY = 39
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_DAMAGE_IMMUNITY = 40
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_DISPEL_IMMUNITY = 41
+- EffectMiscValueA: [Dispel Type](#dispel-type)
+
+SPELL_AURA_TRACK_CREATURES = 44
+- EffectMiscValueA: [Creature Type](#creature-type)
+
+SPELL_AURA_TRACK_RESOURCES = 45
+- EffectMiscValueA: [Lock Type](#lock-type)
+
+SPELL_AURA_TRANSFORM = 56
+- EffectMiscValueA: [Creature ID](creature_template.md)
+
+SPELL_AURA_MOD_DAMAGE_DONE_CREATURE = 59
+- EffectMiscValueA: [Creature Type](#creature-type)
+
+SPELL_AURA_SCHOOL_ABSORB = 69
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MOD_SPELL_CRIT_CHANCE_SCHOOL = 71
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MOD_POWER_COST_SCHOOL_PCT = 72
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MOD_POWER_COST_SCHOOL = 73
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_REFLECT_SPELLS_SCHOOL = 74
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MOD_LANGUAGE = 75
+- EffectMiscValueA: [Language ID](languages.md)
+
+SPELL_AURA_MECHANIC_IMMUNITY = 77
+- EffectMiscValueA: [Spell Mechanic](#spell-mechanic)
+
+SPELL_AURA_MOUNTED = 78
+- EffectMiscValueA: [Creature ID](creature_template.md)
+
+SPELL_AURA_MOD_DAMAGE_PERCENT_DONE = 79
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MOD_PERCENT_STAT = 80
+- EffectMiscValueA: [Stats Type](#stats-type)
+
+SPELL_AURA_SPLIT_DAMAGE_PCT = 81
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MOD_BASE_RESISTANCE = 83
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MOD_POWER_REGEN = 85
+- EffectMiscValueA: [Power Type](#power-type)
+
+SPELL_AURA_MOD_DAMAGE_PERCENT_TAKEN = 87
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MANA_SHIELD = 97
+- EffectMiscValueA: [Power Type](#power-type)
+
+SPELL_AURA_MOD_SKILL_TALENT = 98
+- EffectMiscValueA: [Skill ID](skillline.md)
+
+SPELL_AURA_MOD_RESISTANCE_PCT = 101
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MOD_MELEE_ATTACK_POWER_VERSUS = 102
+- EffectMiscValueA: [Creature Type](#creature-type)
+
+SPELL_AURA_ADD_FLAT_MODIFIER = 107
+- EffectMiscValueA: [Modifier Type](#modifier-type)
+
+SPELL_AURA_ADD_PCT_MODIFIER = 108
+- EffectMiscValueA: [Modifier Type](#modifier-type)
+
+SPELL_AURA_MOD_POWER_REGEN_PERCENT = 110
+- EffectMiscValueA: [Power Type](#power-type)
+
+SPELL_AURA_MOD_RANGED_DAMAGE_TAKEN = 113
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MOD_RANGED_DAMAGE_TAKEN_PCT = 114
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MOD_HEALING = 115
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MOD_MECHANIC_RESISTANCE = 117
+- EffectMiscValueA: [Spell Mechanic](#spell-mechanic)
+
+SPELL_AURA_MOD_HEALING_PCT = 118
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MOD_RANGED_ATTACK_POWER_VERSUS = 131
+- EffectMiscValueA: [Creature Type](#creature-type)
+
+SPELL_AURA_MOD_INCREASE_ENERGY_PERCENT = 132
+- EffectMiscValueA: [Power Type](#power-type)
+
+SPELL_AURA_MOD_HEALING_DONE = 135
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MOD_HEALING_DONE_PERCENT = 136
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MOD_TOTAL_STAT_PERCENTAGE = 137
+- EffectMiscValueA: [Stats Type](#stats-type)
+
+SPELL_AURA_FORCE_REACTION = 139
+- EffectMiscValueA: ID from [faction.dbc](faction.md)
+
+SPELL_AURA_MOD_BASE_RESISTANCE_PCT = 142
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MOD_RESISTANCE_EXCLUSIVE = 143
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MECHANIC_IMMUNITY_MASK = 147
+- EffectMiscValueA: [Creature Immunity](creature_template.md)
+
+SPELL_AURA_SPLIT_DAMAGE_FLAT = 153
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MOD_CRIT_DAMAGE_BONUS = 163
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MOD_DAMAGE_DONE_VERSUS = 168
+- EffectMiscValueA: [Creature Type](#creature-type)
+
+SPELL_AURA_MOD_CRIT_PERCENT_VERSUS = 169
+- EffectMiscValueA: [Creature Type](#creature-type)
+
+SPELL_AURA_MOD_SPELL_DAMAGE_OF_STAT_PERCENT = 174
+- EffectMiscValueA: [School Mask](#school-mask)
+- EffectMiscValueB: [Stats Type](#stats-type)
+
+SPELL_AURA_MOD_SPELL_HEALING_OF_STAT_PERCENT = 175
+- EffectMiscValueA: [Stats Type](#stats-type)
+
+SPELL_AURA_MOD_DEBUFF_RESISTANCE = 178
+- EffectMiscValueA: [Dispel Type](#dispel-type)
+
+SPELL_AURA_MOD_ATTACKER_SPELL_CRIT_CHANCE = 179
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MOD_FLAT_SPELL_DAMAGE_VERSUS = 180
+- EffectMiscValueA: [Creature Type](#creature-type)
+
+SPELL_AURA_MOD_CRITICAL_THREAT = 183
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MOD_ATTACKER_SPELL_HIT_CHANCE = 186
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MOD_RATING = 189
+- EffectMiscValueA: Rating Type
+
+SPELL_AURA_MOD_FACTION_REPUTATION_GAIN = 190
+- EffectMiscValueA: ID from [faction.dbc](faction.md)
+
+SPELL_AURA_MOD_TARGET_ABSORB_SCHOOL = 194
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MOD_TARGET_ABILITY_ABSORB_SCHOOL = 195
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MOD_INCREASES_SPELL_PCT_TO_HIT = 199
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MOD_SCHOOL_CRIT_DMG_TAKEN = 205
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MOD_RANGED_ATTACK_POWER_OF_STAT_PERCENT = 212
+- EffectMiscValueA: [Stats Type](#stats-type)
+
+SPELL_AURA_MOD_MANA_REGEN_FROM_STAT = 219
+- EffectMiscValueA: [Stats Type](#stats-type)
+
+SPELL_AURA_MOD_RATING_FROM_STAT = 220
+- EffectMiscValueA: Rating Type
+
+SPELL_AURA_MOD_AOE_DAMAGE_AVOIDANCE = 229
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MECHANIC_DURATION_MOD = 232
+- EffectMiscValueA: [Spell Mechanic](#spell-mechanic)
+
+SPELL_AURA_CHANGE_MODEL_FOR_ALL_HUMANOIDS = 233
+- EffectMiscValueA: [Creature ID](creature_template.md)
+
+SPELL_AURA_MECHANIC_DURATION_MOD_NOT_STACK = 234
+- EffectMiscValueA: [Spell Mechanic](#spell-mechanic)
+
+SPELL_AURA_MOD_FACTION = 243
+- EffectMiscValueA: ID from [faction.dbc](faction.md)
+
+SPELL_AURA_COMPREHEND_LANGUAGE = 244
+- EffectMiscValueA: [Language ID](languages.md)
+
+SPELL_AURA_MOD_AURA_DURATION_BY_DISPEL = 245
+- EffectMiscValueA: [Dispel Type](#dispel-type)
+
+SPELL_AURA_MOD_AURA_DURATION_BY_DISPEL_NOT_STACK = 246
+- EffectMiscValueA: [Dispel Type](#dispel-type)
+
+SPELL_AURA_CONVERT_RUNE = 249
+- EffectMiscValueA: Rune Type to convert
+- EffectMiscValueB: The converted new Rune
+
+SPELL_AURA_MOD_MECHANIC_DAMAGE_TAKEN_PERCENT = 255
+- EffectMiscValueA: [Spell Mechanic](#spell-mechanic)
+
+SPELL_AURA_NO_REAGENT_USE = 256
+- EffectMiscValueA: Some sort of a reagent type.
+
+SPELL_AURA_MOD_HOT_PCT = 259
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_SCREEN_EFFECT = 260
+- EffectMiscValueA: ID from screen ScreenEffect.dbc
+
+SPELL_AURA_PHASE = 261
+- EffectMiscValueA: Phase Mask
+
+SPELL_AURA_MOD_IMMUNE_AURA_APPLY_SCHOOL = 267
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MOD_ATTACK_POWER_OF_STAT_PERCENT = 268
+- EffectMiscValueA: [Stats Type](#stats-type)
+
+SPELL_AURA_MOD_IGNORE_TARGET_RESIST = 269
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MOD_ABILITY_IGNORE_TARGET_RESIS
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MOD_DAMAGE_FROM_CASTER = 271
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_X_RAY = 273
+- EffectMiscValueA: [Creature ID](creature_template.md)
+
+SPELL_AURA_MOD_DAMAGE_DONE_FOR_MECHANIC = 276
+- EffectMiscValueA: [Spell Mechanic](#spell-mechanic)
+
+SPELL_AURA_OVERRIDE_SPELLS = 293
+- EffectMiscValueA: ID from screen OverrideSpellData.dbc
+
+SPELL_AURA_PREVENT_REGENERATE_POWER = 294
+- EffectMiscValueA: [Power Type](#power-type)
+
+SPELL_AURA_SET_VEHICLE_ID = 296
+- EffectMiscValueA: ID from Vehicle.dbc
+
+SPELL_AURA_SHARE_DAMAGE_PCT = 300
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_SCHOOL_HEAL_ABSORB = 301
+- EffectMiscValueA: [School Mask](#school-mask)
+
+SPELL_AURA_MOD_DAMAGE_DONE_VERSUS_AURASTATE = 303
+- EffectMiscValueA: ID from AuraStateType (master/src/server/shared/SharedDefines.h)
+
+SPELL_AURA_MOD_FAKE_INEBRIATE = 304
+- EffectMiscValueA: [Creature ID](creature_template.md)
+
+SPELL_AURA_MOD_CREATURE_AOE_DAMAGE_AVOIDANCE = 310
+- EffectMiscValueA: [School Mask](#school-mask)
+
+### School Mask
+
+| ID | School |
+| --- | -------- |
+| 1 | Physical |
+| 2 | Holy |
+| 4 | Fire |
+| 8 | Nature |
+| 16 | Frost |
+| 32 | Shadow |
+| 64 | Arcane |
+| 127 | All |
+
+### Invisibility Type
+
+| ID | Type |
+| -- | -------------------- |
+| 0 | INVISIBILITY_GENERAL |
+| 1 | INVISIBILITY_UNK1 |
+| 2 | INVISIBILITY_UNK2 |
+| 3 | INVISIBILITY_TRAP |
+| 4 | INVISIBILITY_UNK4 |
+| 5 | INVISIBILITY_UNK5 |
+| 6 | INVISIBILITY_DRUNK |
+| 7 | INVISIBILITY_UNK7 |
+| 8 | INVISIBILITY_UNK8 |
+| 9 | INVISIBILITY_UNK9 |
+| 10 | INVISIBILITY_UNK10 |
+| 11 | INVISIBILITY_UNK11 |
+
+### Power Type
+
+| ID | Type |
+| --- | ---------- |
+| 0 | Mana |
+| 1 | Rage |
+| 2 | Focus |
+| 3 | Energy |
+| 4 | Happiness |
+| 5 | Rune |
+| 6 | Runic |
+| 7 | Max powers |
+| 127 | All powers |
+| -2 | HP |
+
+### Stats Type
+
+| ID | Stat |
+| -- | ------------ |
+| 0 | Strength |
+| 1 | Agility |
+| 2 | Stamina |
+| 3 | Intelligence |
+| 4 | Spirit |
+| -1 | All |
+
+### Dispel Type
+
+| ID | Type | ID | Type | ID | Type |
+| -- | ---------- | -- | ------------ | -- | --------------- |
+| 0 | None | 4 | Poison | 8 | SPE_NPC_ONLY |
+| 1 | Magic | 5 | Stealth | 9 | Enrage |
+| 2 | Curse | 6 | Invisibility | 10 | ZG Trinket |
+| 3 | Disease | 7 | ALL | 11 | Old Unseen |
+
+### Creature Type
+
+| ID | Type |
+| --- | -------------- |
+| 0 | None |
+| 1 | Beast |
+| 2 | Dragonkin |
+| 3 | Demon |
+| 4 | Elemental |
+| 5 | Giant |
+| 6 | Undead |
+| 7 | Humanoid |
+| 8 | Critter |
+| 9 | Mechanical |
+| 10 | Not specified |
+| 11 | Totem |
+| 12 | Non-Combat Pet |
+| 13 | Gas Cloud |
+
+### Lock Type
+
+| ID | Type |
+| -- | ----------------------------- |
+| 1 | LOCKTYPE_PICKLOCK |
+| 2 | LOCKTYPE_HERBALISM |
+| 3 | LOCKTYPE_MINING |
+| 4 | LOCKTYPE_DISARM_TRAP |
+| 5 | LOCKTYPE_OPEN |
+| 6 | LOCKTYPE_TREASURE |
+| 7 | LOCKTYPE_CALCIFIED_ELVEN_GEMS |
+| 8 | LOCKTYPE_CLOSE |
+| 9 | LOCKTYPE_ARM_TRAP |
+| 10 | LOCKTYPE_QUICK_OPEN |
+| 11 | LOCKTYPE_QUICK_CLOSE |
+| 12 | LOCKTYPE_OPEN_TINKERING |
+| 13 | LOCKTYPE_OPEN_KNEELING |
+| 14 | LOCKTYPE_OPEN_ATTACKING |
+| 15 | LOCKTYPE_GAHZRIDIAN |
+| 16 | LOCKTYPE_BLASTING |
+| 17 | LOCKTYPE_SLOW_OPEN |
+| 18 | LOCKTYPE_SLOW_CLOSE |
+| 19 | LOCKTYPE_FISHING |
+| 20 | LOCKTYPE_INSCRIPTION |
+| 21 | LOCKTYPE_OPEN_FROM_VEHICLE |
+
+### Spell Mechanic
+
+| ID | Mechanic | ID | Mechanic | ID | Mechanic |
+| -- | ---------- | -- | ---------- | -- | --------------- |
+| 0 | None | 11 | Snare | 22 | Infected |
+| 1 | Charm | 12 | Stun | 23 | Turn |
+| 2 | Disorient | 13 | Freeze | 24 | Horror |
+| 3 | Disarm | 14 | Knockout | 25 | Invulnerability |
+| 4 | Distract | 15 | Bleed | 26 | Interrupt |
+| 5 | Fear | 16 | Bandage | 27 | Daze |
+| 6 | Grip | 17 | Polymorph | 28 | Discovery |
+| 7 | Root | 18 | Banish | 29 | immunity shield |
+| 8 | Slow | 19 | Shield | 30 | All powers |
+| 9 | Silence | 20 | Shackle | 31 | Sap |
+| 10 | Sleep | 21 | Mount | 31 | Enrage |
+
+### Modifier Type
+
+| ID | Modifier | ID | Modifier | ID | Modifier |
+| -- | ----------- | -- | ------------------ | -- | ------------------------ |
+| 0 | damage | 11 | CD | 22 | DoT |
+| 1 | duration | 12 | effect2 | 23 | effect3 |
+| 2 | threat | 13 | ignore armor | 24 | bonus multiplier |
+| 3 | effect1 | 14 | cost | 25 | --- |
+| 4 | charges | 15 | crit damage bonus | 26 | PPM |
+| 5 | range | 16 | resist miss chance | 27 | value multipler |
+| 6 | radius | 17 | jump targets | 28 | resist dispel chance |
+| 7 | crit chance | 18 | Chance of success | 29 | crit damage bonus 2 |
+| 8 | all effects | 19 | Amplitude | 30 | pell cost refund on fail |
+| 9 | No pushback | 20 | Dmg multiplier |
+| 10 | Cast Time | 21 | GCD |
diff --git a/docs/spell-effects-reference.md b/docs/spell-effects-reference.md
new file mode 100644
index 0000000..9931a51
--- /dev/null
+++ b/docs/spell-effects-reference.md
@@ -0,0 +1,556 @@
+# Spell Effects Reference
+
+[<-Back-to:spell_dbc](spell_dbc.md)
+
+### This page contains description regarding the usage of EffectMiscValue and other Spell Effects values.
+
+### Contains the list of all Spell Effects.
+
+**Version is : 3.3.5a**
+
+### Related Information
+[Summon Properties](summonproperties_dbc.md)
+
+[Spell Aura](spell-aura-reference.md)
+
+# Spell Effect Names
+
+SPELL_EFFECT_INSTAKILL = 1
+
+SPELL_EFFECT_SCHOOL_DAMAGE = 2
+- BasePoints: Base damage
+- Multiple: Damage multiplier
+
+SPELL_EFFECT_DUMMY = 3
+- BasePoints: Anything
+
+SPELL_EFFECT_PORTAL_TELEPORT = 4
+
+SPELL_EFFECT_TELEPORT_UNITS = 5
+- TargetB: Teleport location
+
+SPELL_EFFECT_APPLY_AURA = 6
+- BasePoints: Value of aura (depends on Aura ID)
+- EffectAura: [Spell Aura](spell-aura-reference.md)
+
+SPELL_EFFECT_ENVIRONMENTAL_DAMAGE = 7
+- BasePoints: Base damage
+
+SPELL_EFFECT_POWER_DRAIN = 8
+- BasePoints: Base drain
+- Multiple: Drain multiplier
+
+SPELL_EFFECT_HEALTH_LEECH = 9
+- BasePoints: Base drain
+- Multiple: Drain multiplier
+- TargetB: If used, TargetA is healed
+
+SPELL_EFFECT_HEAL = 10
+- BasePoints: Base heal
+- Multiple: Heal multiplier
+- TargetB: If used, TargetA is healed
+
+SPELL_EFFECT_BIND = 11
+- BasePoints: Unknown
+- EffectMiscValueA: Area ID (Death Gate only)
+
+SPELL_EFFECT_PORTAL = 12
+- TargetA: Teleport Destination
+- TargetB: Targets
+
+SPELL_EFFECT_RITUAL_BASE = 13 // Unused
+
+SPELL_EFFECT_RITUAL_SPECIALIZE = 14 // Unused
+
+SPELL_EFFECT_RITUAL_ACTIVATE_PORTAL = 15 // Unused
+
+SPELL_EFFECT_QUEST_COMPLETE = 16
+- EffectMiscValueA: Quest ID
+- TargetB: Additional Targets (Used by 30790)
+
+SPELL_EFFECT_WEAPON_DAMAGE_NOSCHOOL = 17
+- BasePoints: Base damage
+
+SPELL_EFFECT_RESURRECT = 18
+- BasePoints: Percentage (%) of restored health and mana
+- TargetB: Additional Targets (Used by 29820, mass revive)
+
+SPELL_EFFECT_ADD_EXTRA_ATTACKS = 19
+- BasePoints: Number of extra melee attacks
+
+SPELL_EFFECT_DODGE = 20
+
+SPELL_EFFECT_EVADE = 21
+
+SPELL_EFFECT_PARRY = 22
+
+SPELL_EFFECT_BLOCK = 23
+
+SPELL_EFFECT_CREATE_ITEM = 24
+- BasePoints: Number of items
+- EffectItemType: [Item ID](item_template.md)
+
+SPELL_EFFECT_WEAPON = 25
+
+SPELL_EFFECT_DEFENSE = 26
+
+SPELL_EFFECT_PERSISTENT_AREA_AURA = 27
+- BasePoints: Depends on [Spell Aura](spell-aura-reference.md)
+
+SPELL_EFFECT_SUMMON = 28
+- BasePoints: Number of summons
+- EffectMiscValueA: [Creature ID](creature_template.md)
+- EffectMiscValueB: [Summon Properties](summonproperties_dbc.md)
+- Radius: Spawn range
+
+SPELL_EFFECT_LEAP = 29
+- TargetA: Target
+- TargetB: Destination
+- Radius: Blink/leap distance
+
+SPELL_EFFECT_ENERGIZE = 30
+- BasePoints: Amount
+- TargetB: Additional Targets
+- EffectMiscValueA: Power Type
+
+| ID | Type |
+| --- | ---------- |
+| 0 | Mana |
+| 1 | Rage |
+| 2 | Focus |
+| 3 | Energy |
+| 4 | Happiness |
+| 5 | Rune |
+| 6 | Runic |
+| 7 | Max powers |
+| 127 | All powers |
+| -2 | HP |
+
+SPELL_EFFECT_WEAPON_PERCENT_DAMAGE = 31
+- BasePoints: Percentage base damage
+
+SPELL_EFFECT_TRIGGER_MISSILE = 32
+- TriggerSpell: Spell ID
+
+SPELL_EFFECT_OPEN_LOCK = 33
+- BasePoints: Required lockpicking skill level
+
+SPELL_EFFECT_SUMMON_CHANGE_ITEM = 34 // Weapons like Benedictions
+EffectItemType: New [Item ID](item_template.md)
+
+SPELL_EFFECT_APPLY_AREA_AURA_PARTY = 35
+- BasePoints: Depends on [Spell Aura](spell-aura-reference.md)
+
+SPELL_EFFECT_LEARN_SPELL = 36
+- TriggerSpell: Spell ID
+
+SPELL_EFFECT_SPELL_DEFENSE = 37
+
+SPELL_EFFECT_DISPEL = 38
+- BasePoints: Number of spells to dispell
+- EffectMiscValueA: Dispel Type
+
+| ID | Type | ID | Type | ID | Type |
+| -- | ---------- | -- | ------------ | -- | --------------- |
+| 0 | None | 4 | Poison | 8 | SPE_NPC_ONLY |
+| 1 | Magic | 5 | Stealth | 9 | Enrage |
+| 2 | Curse | 6 | Invisibility | 10 | ZG Trinket |
+| 3 | Disease | 7 | ALL | 11 | Old Unseen |
+
+SPELL_EFFECT_LANGUAGE = 39
+- EffectMiscValueA: [Language ID](languages.md)
+
+SPELL_EFFECT_DUAL_WIELD = 40
+
+SPELL_EFFECT_JUMP = 41
+- Multiple: Unknown
+- EffectMiscValueA: Speed XY or speed Z
+- EffectMiscValueB: Speed XY or speed Z
+
+SPELL_EFFECT_JUMP_DEST = 42
+- Multiple: Unknown
+- EffectMiscValueA: Speed XY or speed Z
+- EffectMiscValueB: Speed XY or speed Z
+
+SPELL_EFFECT_TELEPORT_UNITS_FACE_CASTER = 43
+- BasePoints: Number of units to teleport
+
+SPELL_EFFECT_SKILL_STEP = 44
+- BasePoints: Unknown
+- EffectMiscValueA: [Skill ID](skillline.md)
+
+SPELL_EFFECT_ADD_HONOR = 45
+- BasePoints: Honor points to reward
+
+SPELL_EFFECT_SPAWN = 46
+
+SPELL_EFFECT_TRADE_SKILL = 47
+
+SPELL_EFFECT_STEALTH = 48
+
+SPELL_EFFECT_DETECT = 49
+
+SPELL_EFFECT_TRANS_DOOR = 50
+- EffectMiscValueA: [gameobject_template ID](gameobject_template.md)
+- gameobject_template's Data0 is the spell that is linked to the destination of the teleport when clicked.
+- Data0 entry = spell_target_position table
+
+SPELL_EFFECT_FORCE_CRITICAL_HIT = 51 // Unused
+
+SPELL_EFFECT_GUARANTEE_HIT = 52 // Unused
+
+SPELL_EFFECT_ENCHANT_ITEM = 53
+- EffectItemType: [Item ID](item_template.md) (Scrolls/Inscription)
+- EffectMiscValueA: ID from SpellItemEnchantment.dbc
+- EffectMiscValueA: 14 = armor, 15 = weapon, tied to EffectItemType.
+
+SPELL_EFFECT_ENCHANT_ITEM_TEMPORARY = 54
+- EffectMiscValueA: ID from SpellItemEnchantment.dbc
+
+SPELL_EFFECT_TAMECREATURE = 55
+
+SPELL_EFFECT_SUMMON_PET = 56
+- Multiple: Relative to Caster level (e.g a value of -3 will be caster level -3) Does not currently work.
+- EffectMiscValueA: [Creature ID](creature_template.md)
+
+SPELL_EFFECT_LEARN_PET_SPELL = 57
+- TriggerSpell: Spell ID
+
+SPELL_EFFECT_WEAPON_DAMAGE = 58
+- BasePoints: Additional damage
+- TargetB: Additional Targets
+- Chain Target: Additional Targets
+
+SPELL_EFFECT_CREATE_RANDOM_ITEM = 59
+- EffectMiscValueA: Unknown
+
+SPELL_EFFECT_PROFICIENCY = 60
+
+SPELL_EFFECT_SEND_EVENT = 61
+- EffectMiscValueA: Calls for an event from acevent_scripts table.\
+(Most are missmatched, but there are few that are correct.)
+
+SPELL_EFFECT_POWER_BURN = 62
+- BasePoints: Amount of mana to burn
+- TargetB: Additional Targets
+- Multiple: conversion % to dmg (e.g if 0.5, for 1 mana burned, deal 0.5 damage)
+- Chain Target: Additional Targets
+
+SPELL_EFFECT_THREAT = 63
+- BasePoints: Amount of threat to add/remove
+
+SPELL_EFFECT_TRIGGER_SPELL = 64
+- TriggerSpell: Spell ID
+
+SPELL_EFFECT_APPLY_AREA_AURA_RAID = 65
+- BasePoints: Depends on [Spell Aura](spell-aura-reference.md)
+- EffectMiscValueA: Unknown
+
+SPELL_EFFECT_CREATE_MANA_GEM = 66
+- BasePoints: Number to refill
+- EffectItemType: [Item ID](item_template.md) to create/refill
+
+SPELL_EFFECT_HEAL_MAX_HEALTH = 67
+
+SPELL_EFFECT_INTERRUPT_CAST = 68
+- EffectMechanic: Interupted
+
+SPELL_EFFECT_DISTRACT = 69
+- BasePoints: Duration in seconds.
+
+SPELL_EFFECT_PULL = 70
+
+SPELL_EFFECT_PICKPOCKET = 71
+
+SPELL_EFFECT_ADD_FARSIGHT = 72
+
+SPELL_EFFECT_UNTRAIN_TALENTS = 73
+
+SPELL_EFFECT_APPLY_GLYPH = 74
+- EffectMiscValueA: ID from GlyphProperties.dbc
+
+SPELL_EFFECT_HEAL_MECHANICAL = 75
+- BasePoints: Amount
+
+SPELL_EFFECT_SUMMON_OBJECT_WILD = 76
+- EffectMiscValueA: [gameobject_template ID](gameobject_template.md)
+
+SPELL_EFFECT_SCRIPT_EFFECT = 77 Assigned to a [Core Script](/wiki/core-scripts#spell-scripts) in the DB.
+
+SPELL_EFFECT_ATTACK = 78
+
+SPELL_EFFECT_SANCTUARY = 79
+
+SPELL_EFFECT_ADD_COMBO_POINTS = 80
+- BasePoints: Number of combo points to add
+
+SPELL_EFFECT_CREATE_HOUSE = 81
+
+SPELL_EFFECT_BIND_SIGHT = 82
+
+SPELL_EFFECT_DUEL = 83
+- EffectMiscValueA: [gameobject_template ID](gameobject_template.md) (Duel Flag)
+
+SPELL_EFFECT_STUCK = 84
+
+SPELL_EFFECT_SUMMON_PLAYER = 85
+
+SPELL_EFFECT_ACTIVATE_OBJECT = 86
+- EffectMiscValueA: Unknown
+
+SPELL_EFFECT_GAMEOBJECT_DAMAGE = 87
+- BasePoints: Base damage
+
+SPELL_EFFECT_GAMEOBJECT_REPAIR = 88
+
+SPELL_EFFECT_GAMEOBJECT_SET_DESTRUCTION_STATE = 89
+- EffectMiscValueA: State
+
+| ID | State |
+| -- | ---------- |
+| 0 | Intact |
+| 1 | Damaged |
+| 2 | Destroyed |
+| 3 | Rebuilding |
+
+SPELL_EFFECT_KILL_CREDIT = 90
+- EffectMiscValueA: [Creature ID](creature_template.md)
+
+SPELL_EFFECT_THREAT_ALL = 91 // Unused
+
+SPELL_EFFECT_ENCHANT_HELD_ITEM = 92
+- EffectMiscValueA: ID from SpellItemEnchantment.dbc
+
+SPELL_EFFECT_FORCE_DESELECT = 93
+
+SPELL_EFFECT_SELF_RESURRECT = 94
+- BasePoints: Positive = %, Negative = Flat Value
+- EffectMiscValueA: Mana (Flat Value)
+
+SPELL_EFFECT_SKINNING = 95
+
+SPELL_EFFECT_CHARGE = 96
+
+SPELL_EFFECT_CAST_BUTTON = 97 (Totem bar since 3.2.2a)
+- EffectMiscValueA: Totem combinations = 0,4,8
+- EffectMiscValueB: Unknown (Always 4), possibly totem amount
+
+SPELL_EFFECT_KNOCK_BACK = 98
+- BasePoints: Distance
+- EffectMiscValueA: Distance
+
+SPELL_EFFECT_DISENCHANT = 99
+
+SPELL_EFFECT_INEBRIATE = 100
+- BasePoints: Drunk power
+
+SPELL_EFFECT_FEED_PET = 101
+- BasePoints: Happiness Amount
+- TriggerSpell: Spell ID
+
+SPELL_EFFECT_DISMISS_PET = 102
+
+SPELL_EFFECT_REPUTATION = 103
+- BasePoints: Reputation Amount
+- EffectMiscValueA: ID from [faction.dbc](faction.md)
+
+SPELL_EFFECT_SUMMON_OBJECT_SLOT1 = 104
+- EffectMiscValueA: [gameobject_template ID](gameobject_template.md)
+
+SPELL_EFFECT_SUMMON_OBJECT_SLOT2 = 105
+- EffectMiscValueA: [gameobject_template ID](gameobject_template.md)
+
+SPELL_EFFECT_SUMMON_OBJECT_SLOT3 = 106
+- EffectMiscValueA: [gameobject_template ID](gameobject_template.md)
+
+SPELL_EFFECT_SUMMON_OBJECT_SLOT4 = 107 // Unused
+
+SPELL_EFFECT_DISPEL_MECHANIC = 108
+- EffectMiscValueA: Dispel Mechanic
+
+| ID | Mechanic | ID | Mechanic | ID | Mechanic |
+| -- | ---------- | -- | ---------- | -- | --------------- |
+| 0 | None | 11 | Snare | 22 | Infected |
+| 1 | Charm | 12 | Stun | 23 | Turn |
+| 2 | Disorient | 13 | Freeze | 24 | Horror |
+| 3 | Disarm | 14 | Knockout | 25 | Invulnerability |
+| 4 | Distract | 15 | Bleed | 26 | Interrupt |
+| 5 | Fear | 16 | Bandage | 27 | Daze |
+| 6 | Grip | 17 | Polymorph | 28 | Discovery |
+| 7 | Root | 18 | Banish | 29 | immunity shield |
+| 8 | Slow | 19 | Shield | 30 | All powers |
+| 9 | Silence | 20 | Shackle | 31 | Sap |
+| 10 | Sleep | 21 | Mount | 31 | Enrage |
+
+SPELL_EFFECT_RESURRECT_PET = 109
+- BasePoints: % base health to heal
+
+SPELL_EFFECT_DESTROY_ALL_TOTEMS = 110
+- BasePoints: % mana refund
+
+SPELL_EFFECT_DURABILITY_DAMAGE = 111
+- BasePoints: Positive = Durability damage, Negative = Durability restore
+- EffectMiscValueA: Unknown
+
+SPELL_EFFECT_112 = 112 // Unused
+
+SPELL_EFFECT_RESURRECT_NEW = 113
+- BasePoints: Health to restore (Flat Value)
+- EffectMiscValueA: Mana (Flat Value)
+
+SPELL_EFFECT_ATTACK_ME = 114
+
+SPELL_EFFECT_DURABILITY_DAMAGE_PCT = 115
+- BasePoints: Durability damage %
+- EffectMiscValueA: Unknown
+
+SPELL_EFFECT_SKIN_PLAYER_CORPSE = 116
+
+SPELL_EFFECT_SPIRIT_HEAL = 117
+- BasePoints: Health %
+
+SPELL_EFFECT_SKILL = 118
+- BasePoints: Unknown
+- EffectMiscValueA: [Skill ID](skillline.md)
+
+SPELL_EFFECT_APPLY_AREA_AURA_PET = 119
+- BasePoints: Depends on [Spell Aura](spell-aura-reference.md)
+
+SPELL_EFFECT_TELEPORT_GRAVEYARD = 120
+
+SPELL_EFFECT_NORMALIZED_WEAPON_DMG = 121
+- BasePoints: Base damage
+- Chain Target: Additional Targets
+
+SPELL_EFFECT_122 = 122 // Unused
+
+SPELL_EFFECT_SEND_TAXI = 123
+- EffectMiscValueA: ID from TaxiPath.dbc
+
+SPELL_EFFECT_PULL_TOWARDS = 124
+- EffectMiscValueA: Speed of pull
+
+SPELL_EFFECT_MODIFY_THREAT_PERCENT = 125
+- BasePoints: Threat %
+
+SPELL_EFFECT_STEAL_BENEFICIAL_BUFF = 126
+- BasePoints: Number of buffs to steal
+
+SPELL_EFFECT_PROSPECTING = 127
+
+SPELL_EFFECT_APPLY_AREA_AURA_FRIEND = 128
+- BasePoints: Depends on [Spell Aura](spell-aura-reference.md)
+
+SPELL_EFFECT_APPLY_AREA_AURA_ENEMY = 129
+- BasePoints: Depends on [Spell Aura](spell-aura-reference.md)
+
+SPELL_EFFECT_REDIRECT_THREAT = 130
+- BasePoints: % Threat to redirect
+- TargetB: Unit to redirect threat to
+
+SPELL_EFFECT_PLAY_SOUND = 131
+- EffectMiscValueA: ID from SoundEntries.dbc
+
+SPELL_EFFECT_PLAY_MUSIC = 132
+- EffectMiscValueA: ID from SoundEntries.dbc
+
+SPELL_EFFECT_UNLEARN_SPECIALIZATION = 133
+- TriggerSpell: Spell ID
+
+SPELL_EFFECT_KILL_CREDIT2 = 134
+- EffectMiscValueA: [Creature ID](creature_template.md)
+
+SPELL_EFFECT_CALL_PET = 135
+
+SPELL_EFFECT_HEAL_PCT = 136
+- BasePoints: % Heal
+
+SPELL_EFFECT_ENERGIZE_PCT = 137
+- BasePoints: % to restore
+- EffectMiscValueA: Power Type (Same as EFFECT 30)
+
+SPELL_EFFECT_LEAP_BACK = 138
+- BasePoints: Distance
+- EffectMiscValueA: Distance
+
+SPELL_EFFECT_CLEAR_QUEST = 139
+- BasePoints: 2nd quest ID to clear (e.g Spell ID 56518)
+- EffectMiscValueA: Quest ID
+
+SPELL_EFFECT_FORCE_CAST = 140
+- TriggerSpell: Spell ID
+
+SPELL_EFFECT_FORCE_CAST_WITH_VALUE = 141
+- BasePoints: Value for the TriggerSpell
+- TriggerSpell: Spell ID
+
+SPELL_EFFECT_TRIGGER_SPELL_WITH_VALUE = 142
+- BasePoints: Value for the TriggerSpell
+- TriggerSpell: Spell ID
+
+SPELL_EFFECT_APPLY_AREA_AURA_OWNER = 143
+- BasePoints: Depends on [Spell Aura](spell-aura-reference.md)
+
+SPELL_EFFECT_KNOCK_BACK_DEST = 144
+- BasePoints: Distance
+- TargetB: Destionation
+- EffectMiscValueA: Distance
+
+SPELL_EFFECT_PULL_TOWARDS_DEST = 145 (Black Hole Effect)
+- EffectMiscValueA: Distance
+
+SPELL_EFFECT_ACTIVATE_RUNE = 146
+- BasePoints: Number of runes to activate (1 or 2)
+- EffectMiscValueA: Rune Type
+
+SPELL_EFFECT_QUEST_FAIL = 147
+- EffectMiscValueA: Quest ID
+
+SPELL_EFFECT_TRIGGER_MISSILE_SPELL_WITH_VALUE = 148
+- BasePoints: Value
+- TriggerSpell: Spell ID
+
+SPELL_EFFECT_CHARGE_DEST = 149
+
+SPELL_EFFECT_QUEST_START = 150
+- EffectMiscValueA: Quest ID
+
+SPELL_EFFECT_TRIGGER_SPELL_2 = 151
+- TriggerSpell: Spell ID
+
+SPELL_EFFECT_SUMMON_RAF_FRIEND = 152
+- TriggerSpell: Spell ID (Summon)
+
+SPELL_EFFECT_CREATE_TAMED_PET = 153
+- EffectMiscValueA: [Creature ID](creature_template.md)
+
+SPELL_EFFECT_DISCOVER_TAXI = 154
+- EffectMiscValueA: ID from TaxiNodes.dbc
+
+SPELL_EFFECT_TITAN_GRIP = 155
+- EffectMiscValueA: Spell ID
+
+SPELL_EFFECT_ENCHANT_ITEM_PRISMATIC = 156
+
+SPELL_EFFECT_CREATE_ITEM_2 = 157
+- EffectItemType: [Item ID](item_template.md) to transform
+- EffectMiscValueA: Unknown
+
+SPELL_EFFECT_MILLING = 158
+- BasePoints: Number of herbs to mill.
+
+SPELL_EFFECT_ALLOW_RENAME_PET = 159
+
+SPELL_EFFECT_160 = 160
+
+SPELL_EFFECT_TALENT_SPEC_COUNT = 161
+- BasePoints: Number of active talent specs
+
+SPELL_EFFECT_TALENT_SPEC_SELECT = 162
+- BasePoints: Talent spec ID to activate
+
+SPELL_EFFECT_163 = 163 // Unused
+
+SPELL_EFFECT_REMOVE_AURA = 164
+- BasePoints: Spell ID to remove 2
+- TriggerSpell: Spell ID to remove
diff --git a/docs/spell_dbc.md b/docs/spell_dbc.md
index fbab82b..f227f20 100644
--- a/docs/spell_dbc.md
+++ b/docs/spell_dbc.md
@@ -13,6 +13,14 @@ Fixes for this table should always contain:
1) the `INSERT IGNORE` query adding the original spell from the DBC (unless that spell is already present in `spell_dbc`)
2) the `UPDATE` query containing the desired overrides
+**Spell\_Effect\_ID**
+
+- Effect\_IDs of [Effect1, Effect2 and/or Effect3](spell-effects-reference.md).
+
+**Spell\_Effect\_Apply\_Aura_ID**
+
+- EffectApplyAuraName\_IDs of [EffectApplyAuraName1, EffectApplyAuraName2 and/or EffectApplyAuraName3](spell-aura-reference.md).
+
**Structure**
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
@@ -201,7 +209,7 @@ The id of the Spell.
### Effect
-Effect1, Effect2 and Effect3. Effect\_ID of the Spell\_Effect. A Spell can only have up to three Spell\_Effects.
+[Effect1, Effect2 and Effect3. Effect\_ID of the Spell\_Effect. A Spell can only have up to three Spell\_Effects.](spell-effects-reference.md)
### EffectDieSides
@@ -233,7 +241,7 @@ Effect1, Effect2 and Effect3. Effect\_ID of the Spell\_Effect. A Spell can only
### EffectApplyAuraName
-`field-no-description|31`
+[EffectApplyAuraName1, EffectApplyAuraName2 and EffectApplyAuraName3. EffectApplyAuraName\_ID of the Spell\_Effect\_Apply\_Aura.](spell-aura-reference.md)
### EffectAmplitude
@@ -306,175 +314,3 @@ Effect1, Effect2 and Effect3. Effect\_ID of the Spell\_Effect. A Spell can only
### Comment
`field-no-description|49`
-
-**SPELL\_EFFECT\_ID**
-
-Effect\_IDs of [Effect1, Effect2 and/or Effect3](#spell_dbc-Effect).
-
-| 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