From a370103c037b7fb21f9df4ced47137bb64775952 Mon Sep 17 00:00:00 2001 From: Shauren Date: Sun, 16 Jan 2011 17:41:49 +0100 Subject: SQL: Removed unused spell script name. Scripts/Icecrown Citadel: Fixed Professor Putricide adds chasing different targets than selected. Scripts/Icecrown Citadel: Fixed Coldflame ticking twice because of too close spawning. Scripts/Icecrown Citadel: Fixed Coldflame affecting spiked targets. --- sql/scripts/world_scripts_full.sql | 5 ++++- sql/updates/2011_01_16_0_world_spell_script_names.sql | 7 +++++++ 2 files changed, 11 insertions(+), 1 deletion(-) create mode 100644 sql/updates/2011_01_16_0_world_spell_script_names.sql (limited to 'sql') diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql index 94b1b296bea..4c7b081d67e 100644 --- a/sql/scripts/world_scripts_full.sql +++ b/sql/scripts/world_scripts_full.sql @@ -1847,7 +1847,10 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES ( 72089, 'spell_marrowgar_bone_spike_graveyard'), ( 69140, 'spell_marrowgar_coldflame'), ( 72705, 'spell_marrowgar_coldflame'), -( 69147, 'spell_marrowgar_coldflame_trigger'), +( 69146, 'spell_marrowgar_coldflame_damage'), +( 70823, 'spell_marrowgar_coldflame_damage'), +( 70824, 'spell_marrowgar_coldflame_damage'), +( 70825, 'spell_marrowgar_coldflame_damage'); ( 69075, 'spell_marrowgar_bone_storm'), ( 70834, 'spell_marrowgar_bone_storm'), ( 70835, 'spell_marrowgar_bone_storm'), diff --git a/sql/updates/2011_01_16_0_world_spell_script_names.sql b/sql/updates/2011_01_16_0_world_spell_script_names.sql new file mode 100644 index 00000000000..2d0c1f28efd --- /dev/null +++ b/sql/updates/2011_01_16_0_world_spell_script_names.sql @@ -0,0 +1,7 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_marrowgar_coldflame_trigger'; +DELETE FROM `spell_script_names` WHERE `spell_id` IN (69146,70823,70824,70825) AND `ScriptName`='spell_marrowgar_coldflame_damage'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(69146,'spell_marrowgar_coldflame_damage'), +(70823,'spell_marrowgar_coldflame_damage'), +(70824,'spell_marrowgar_coldflame_damage'), +(70825,'spell_marrowgar_coldflame_damage'); -- cgit v1.2.3