From 233d8919528879a26b1aa03373fee590f2307c9d Mon Sep 17 00:00:00 2001 From: kaelima Date: Wed, 11 Jan 2012 17:21:03 +0100 Subject: Scripts/Achievements: - Move achievement Shocking! to appropriate boss script instead of instance script. - Split the polarity spellscript into two and move to proper boss file - Fixed a typo in Loatheb's spore achievement. --- sql/updates/world/2012_01_11_01_world_achievement_criteria_data.sql | 4 ++++ sql/updates/world/2012_01_11_01_world_spell_script_names.sql | 4 ++++ 2 files changed, 8 insertions(+) create mode 100644 sql/updates/world/2012_01_11_01_world_achievement_criteria_data.sql create mode 100644 sql/updates/world/2012_01_11_01_world_spell_script_names.sql (limited to 'sql') diff --git a/sql/updates/world/2012_01_11_01_world_achievement_criteria_data.sql b/sql/updates/world/2012_01_11_01_world_achievement_criteria_data.sql new file mode 100644 index 00000000000..aa3ec94a5a8 --- /dev/null +++ b/sql/updates/world/2012_01_11_01_world_achievement_criteria_data.sql @@ -0,0 +1,4 @@ +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (7604, 7605) AND `type` IN (18,11); +INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) VALUES +(7604,11,0,0, 'achievement_polarity_switch'), +(7605,11,0,0, 'achievement_polarity_switch'); diff --git a/sql/updates/world/2012_01_11_01_world_spell_script_names.sql b/sql/updates/world/2012_01_11_01_world_spell_script_names.sql new file mode 100644 index 00000000000..4600f190c4e --- /dev/null +++ b/sql/updates/world/2012_01_11_01_world_spell_script_names.sql @@ -0,0 +1,4 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN (39090, 39093); +INSERT INTO `spell_script_names`(`spell_id`,`ScriptName`) VALUES +(39090, 'spell_capacitus_polarity_shift'), +(39093, 'spell_capacitus_polarity_shift'); -- cgit v1.2.3