aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorkaelima <kaelima@live.se>2012-01-11 17:21:03 +0100
committerkaelima <kaelima@live.se>2012-01-11 17:21:03 +0100
commit233d8919528879a26b1aa03373fee590f2307c9d (patch)
tree41cd27a5bb68f2ed02747b4e4804839c1e2f624c /sql
parentc398f2098805fe6030dc9c08543f13cdef5fd043 (diff)
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.
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2012_01_11_01_world_achievement_criteria_data.sql4
-rw-r--r--sql/updates/world/2012_01_11_01_world_spell_script_names.sql4
2 files changed, 8 insertions, 0 deletions
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');