Scripts/Icecrown Citadel: Fixed Professor Putricide ooze adds behavior (cannot taunt/aggro anymore), also removed targeting dbc hack and scripted the spell properly

2 files changed, 16 insertions, 0 deletions

diff --git a/sql/updates/world/2011_04_06_03_world_spell_linked_spell.sql b/sql/updates/world/2011_04_06_03_world_spell_linked_spell.sql
new file mode 100644
index 00000000000..c27e26d33be
--- /dev/null
+++ b/sql/updates/world/2011_04_06_03_world_spell_linked_spell.sql
@@ -0,0 +1,6 @@
+DELETE FROM `spell_linked_spell` WHERE `spell_effect`=70530;
+INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES
+(-70447,70530,0, 'Putricide: Volatile Ooze Adhesive Protection'),
+(-72836,70530,0, 'Putricide: Volatile Ooze Adhesive Protection'),
+(-72837,70530,0, 'Putricide: Volatile Ooze Adhesive Protection'),
+(-72838,70530,0, 'Putricide: Volatile Ooze Adhesive Protection');
diff --git a/sql/updates/world/2011_04_06_03_world_spell_script_names.sql b/sql/updates/world/2011_04_06_03_world_spell_script_names.sql
new file mode 100644
index 00000000000..b5c4d151c2b
--- /dev/null
+++ b/sql/updates/world/2011_04_06_03_world_spell_script_names.sql
@@ -0,0 +1,10 @@
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_putricide_ooze_channel';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
+(70447, 'spell_putricide_ooze_channel'),
+(72836, 'spell_putricide_ooze_channel'),
+(72837, 'spell_putricide_ooze_channel'),
+(72838, 'spell_putricide_ooze_channel'),
+(70672, 'spell_putricide_ooze_channel'),
+(72455, 'spell_putricide_ooze_channel'),
+(72832, 'spell_putricide_ooze_channel'),
+(72833, 'spell_putricide_ooze_channel');