aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorNay <dnpd.dd@gmail.com>2012-08-29 14:01:38 +0100
committerNay <dnpd.dd@gmail.com>2012-08-29 14:01:38 +0100
commitaa9f2e9f18f989f1753499409599e6fb01ea220f (patch)
treebbdfe9ad2991424599fce5c22449ea7cc8271ecf /sql
parentee760ab36089c940cf53ba565102d49c6961fbf1 (diff)
parent856a5b62fb310f99852a6047dce321be18c06200 (diff)
Merge remote-tracking branch 'origin/master' into 4.3.4
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2012_08_28_00_world_spell_script_name.sql4
-rw-r--r--sql/updates/world/2012_08_28_01_world_achievement_criteria_data.sql6
2 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/2012_08_28_00_world_spell_script_name.sql b/sql/updates/world/2012_08_28_00_world_spell_script_name.sql
new file mode 100644
index 00000000000..01cfeb35f1f
--- /dev/null
+++ b/sql/updates/world/2012_08_28_00_world_spell_script_name.sql
@@ -0,0 +1,4 @@
+-- Spell script name linking for Defending Wyrmrest Temple: Destabilize Azure Dragonshrine Effect
+DELETE FROM `spell_script_names` WHERE `spell_id`=49370 ;
+INSERT INTO `spell_script_names` VALUES
+(49370,'spell_q12372_destabilize_azure_dragonshrine_dummy');
diff --git a/sql/updates/world/2012_08_28_01_world_achievement_criteria_data.sql b/sql/updates/world/2012_08_28_01_world_achievement_criteria_data.sql
new file mode 100644
index 00000000000..bf247399553
--- /dev/null
+++ b/sql/updates/world/2012_08_28_01_world_achievement_criteria_data.sql
@@ -0,0 +1,6 @@
+DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (11478,11479,12827,12828);
+INSERT INTO `achievement_criteria_data` (`criteria_id`, `type`, `value1`, `value2`, `ScriptName`) VALUES
+(11478, 12, 0, 0, ''), -- Koralon the Flame Watcher (10 player)
+(11479, 12, 1, 0, ''), -- Koralon the Flame Watcher (25 player)
+(12827, 12, 0, 0, ''), -- Toravon the Ice Watcher (10 player)
+(12828, 12, 1, 0, ''); -- Toravon the Ice Watcher (25 player)