aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorariel- <ariel-@users.noreply.github.com>2017-12-20 02:24:06 -0300
committerariel- <ariel-@users.noreply.github.com>2017-12-20 02:25:25 -0300
commitde9f9042699e849af38363430cd9aa390c62d1a2 (patch)
tree732eb22797f5556d21d516ee53dc7797101c38a5 /sql
parent5798fda0a027c1199ea4ddd50f5567cf24c74c5b (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)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/3.3.5/2017_12_20_00_world.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_12_20_00_world.sql b/sql/updates/world/3.3.5/2017_12_20_00_world.sql
new file mode 100644
index 00000000000..c3197c1c2ec
--- /dev/null
+++ b/sql/updates/world/3.3.5/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');