aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2011-01-16 17:41:49 +0100
committerShauren <shauren.trinity@gmail.com>2011-01-16 17:41:49 +0100
commita370103c037b7fb21f9df4ced47137bb64775952 (patch)
treea346ec9063a4d8857fd9ed933cd6a152b27b0c37 /sql
parent44670c2e4f845be1e362082f843288ef515cf51e (diff)
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.
Diffstat (limited to 'sql')
-rw-r--r--sql/scripts/world_scripts_full.sql5
-rw-r--r--sql/updates/2011_01_16_0_world_spell_script_names.sql7
2 files changed, 11 insertions, 1 deletions
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');