diff options
| author | ariel- <ariel-@users.noreply.github.com> | 2017-12-20 02:24:06 -0300 |
|---|---|---|
| committer | funjoker <funjoker109@gmail.com> | 2021-04-15 05:53:27 +0200 |
| commit | 16ec008290861573fac7137af054be6d9642712f (patch) | |
| tree | 0d89126d2b3dd946d77d2409e0de5f77e81b108d /sql | |
| parent | f97e4ad1f462597a0702cfd2130fbac9c46a7eab (diff) | |
Core/Spells: fix some DB errors
Ref #18542
- Implemented Choking Vines transformation at 5 stacks
- Implemented periodic Aura of Fear ticks
- Fixed Savage Rend passive proccing on anything (raptor pets)
(cherry picked from commit de9f9042699e849af38363430cd9aa390c62d1a2)
(cherry picked from commit 32e2207ab9863b9d79b994afd929730ca04bbce8)
(cherry picked from commit 9934a43e0948b6dfd46bd549e6a1c7028c40e22d)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2021_03_17_00_world_2017_12_20_00_world.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_03_17_00_world_2017_12_20_00_world.sql b/sql/updates/world/master/2021_03_17_00_world_2017_12_20_00_world.sql new file mode 100644 index 00000000000..b12e6abd98d --- /dev/null +++ b/sql/updates/world/master/2021_03_17_00_world_2017_12_20_00_world.sql @@ -0,0 +1,13 @@ +DELETE FROM `spell_proc` WHERE `SpellId` IN (45092/*, 50871*/); +INSERT INTO `spell_proc` (`SpellId`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `ProcFlags`, `SpellTypeMask`, `SpellPhaseMask`, `HitMask`, `AttributesMask`, `ProcsPerMinute`, `Chance`, `Cooldown`, `Charges`) VALUES +(45092, 0x0, 0, 0x00000000, 0x00000000, 0x00000000, 0x0, 0x0, 0x0, 0x0, 0x0, 0, 0, 0, 0); -- Faction, Spar Buddy (SERVERSIDE) - needed to drop charge +-- (50871, 0x0, 9, 0x00000000, 0x40000000, 0x00000000, 0x0, 0x1, 0x2, 0x2, 0x0, 0, 0, 0, 0); -- Savage Rend + +DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_gen_aura_of_fear'/*,'spell_gen_choking_vines'*/); +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(28313, 'spell_gen_aura_of_fear'); +-- (35244, 'spell_gen_choking_vines'); + +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_gen_proc_charge_drop_only' AND `spell_id`=45092; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(45092, 'spell_gen_proc_charge_drop_only'); |