diff options
| author | ariel- <ariel-@users.noreply.github.com> | 2017-12-14 13:39:05 -0300 |
|---|---|---|
| committer | funjoker <funjoker109@gmail.com> | 2021-03-15 20:17:31 +0100 |
| commit | 97e869e8b36afd9e7f0452b9001287f6b4a02ef2 (patch) | |
| tree | 1ff3293a43a66744da16506fac7a93de96bb030a /sql | |
| parent | fd786c03a369b60bd29773e19f4213fd2e01624b (diff) | |
Core/Auras: periodics refactor part 3: move more switch hacks to scripts
- Incidentally fixed some spells which were supposed to be removed by proc instead of healing to full
(cherry picked from commit 16e20711d277bc43ae3ac350208df73827306ea6)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2021_03_07_02_world_2017_12_15_01_world_335.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_03_07_02_world_2017_12_15_01_world_335.sql b/sql/updates/world/master/2021_03_07_02_world_2017_12_15_01_world_335.sql new file mode 100644 index 00000000000..b1296e55b2f --- /dev/null +++ b/sql/updates/world/master/2021_03_07_02_world_2017_12_15_01_world_335.sql @@ -0,0 +1,20 @@ +DELETE FROM `spell_proc` WHERE `SpellId` IN (35321, 38363, 39215); +INSERT INTO `spell_proc` (`SpellId`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `ProcFlags`, `SpellTypeMask`, `SpellPhaseMask`, `HitMask`, `AttributesMask`, `ProcsPerMinute`, `Chance`, `Cooldown`, `Charges`) VALUES +(35321, 0x0, 0, 0x00000000, 0x00000000, 0x00000000, 0x0, 0x2, 0x0, 0x0, 0x0, 0, 0, 0, 0), +(38363, 0x0, 0, 0x00000000, 0x00000000, 0x00000000, 0x0, 0x2, 0x0, 0x0, 0x0, 0, 0, 0, 0), +(39215, 0x0, 0, 0x00000000, 0x00000000, 0x00000000, 0x0, 0x2, 0x0, 0x0, 0x0, 0, 0, 0, 0); + +DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_gen_remove_on_health_pct','spell_gen_remove_on_full_health','spell_gen_remove_on_full_health_pct','spell_trash_npc_glacial_strike','spell_iron_ring_guard_impale'); +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(38772, 'spell_gen_remove_on_health_pct'), +(43937, 'spell_gen_remove_on_health_pct'), +(62331, 'spell_gen_remove_on_health_pct'), +(62418, 'spell_gen_remove_on_health_pct'), +(31956, 'spell_gen_remove_on_full_health'), +(38801, 'spell_gen_remove_on_full_health'), +(43093, 'spell_gen_remove_on_full_health'), +(58517, 'spell_gen_remove_on_full_health'), +(59262, 'spell_gen_remove_on_full_health'), +(70292, 'spell_gen_remove_on_full_health_pct'), +(71316, 'spell_gen_remove_on_full_health_pct'); +-- (71317, 'spell_gen_remove_on_full_health_pct'); |