From 356c07c1baf216deacab76366199cccf489f760b Mon Sep 17 00:00:00 2001 From: dr-j Date: Wed, 28 Apr 2021 20:15:21 +0300 Subject: DB/Spells: Blade's Edge Ogre Force Reaction (After completion of Into The Soulgrinder) Closes #26484 (cherry picked from commit e0e450cd12ada6c27e75e813e17788d3c5d5ac7b) --- .../world/master/2022_03_09_07_world_2021_04_28_07_world.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 sql/updates/world/master/2022_03_09_07_world_2021_04_28_07_world.sql diff --git a/sql/updates/world/master/2022_03_09_07_world_2021_04_28_07_world.sql b/sql/updates/world/master/2022_03_09_07_world_2021_04_28_07_world.sql new file mode 100644 index 00000000000..f3b0fa6fdc2 --- /dev/null +++ b/sql/updates/world/master/2022_03_09_07_world_2021_04_28_07_world.sql @@ -0,0 +1,11 @@ +-- +UPDATE `serverside_spell` SET `AttributesEx`=`AttributesEx`|32, `AttributesEx2`=1, `AttributesEx3`=1048576, `RangeIndex`=13, `SchoolMask`=0 WHERE `Id`=39960; + +DELETE FROM `serverside_spell_effect` WHERE `SpellID`=39960; +INSERT INTO `serverside_spell_effect` (`SpellID`,`EffectIndex`,`Effect`,`EffectAura`,`EffectChainAmplitude`,`EffectBasePoints`,`EffectMiscValue1`,`ImplicitTarget1`) VALUES +(39960, 0, 6, 139, 1, 2, 929, 1), +(39960, 1, 6, 139, 1, 2, 1001, 1); + +DELETE FROM `spell_area` WHERE `spell`=39960; +INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `flags`, `quest_start_status`, `quest_end_status`) VALUES +(39960, 3522, 11000, 0, 0, 0, 2, 3, 64, 11); -- cgit v1.2.3