diff options
| author | dr-j <dr-j@users.noreply.github.com> | 2021-04-28 20:15:21 +0300 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-03-09 13:15:04 +0100 |
| commit | 356c07c1baf216deacab76366199cccf489f760b (patch) | |
| tree | fedd30a36ad4ba594c174200272e34a9a2092c8b | |
| parent | a511e9e91bddc937e8bc626f7164f983aa056791 (diff) | |
DB/Spells: Blade's Edge Ogre Force Reaction (After completion of Into The Soulgrinder)
Closes #26484
(cherry picked from commit e0e450cd12ada6c27e75e813e17788d3c5d5ac7b)
| -rw-r--r-- | sql/updates/world/master/2022_03_09_07_world_2021_04_28_07_world.sql | 11 |
1 files changed, 11 insertions, 0 deletions
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); |