aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2011_06_20_03_world_spell_script_names.sql4
-rw-r--r--sql/updates/world/2011_06_20_04_world_achievement_criteria_data.sql6
2 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/2011_06_20_03_world_spell_script_names.sql b/sql/updates/world/2011_06_20_03_world_spell_script_names.sql
new file mode 100644
index 00000000000..0f0efa3fcae
--- /dev/null
+++ b/sql/updates/world/2011_06_20_03_world_spell_script_names.sql
@@ -0,0 +1,4 @@
+DELETE FROM `spell_script_names` WHERE `spell_id`=29371;
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`)
+VALUES
+(29371,'spell_heigan_eruption');
diff --git a/sql/updates/world/2011_06_20_04_world_achievement_criteria_data.sql b/sql/updates/world/2011_06_20_04_world_achievement_criteria_data.sql
new file mode 100644
index 00000000000..16ccd48a28f
--- /dev/null
+++ b/sql/updates/world/2011_06_20_04_world_achievement_criteria_data.sql
@@ -0,0 +1,6 @@
+DELETE FROM `disables` WHERE `entry` IN (7264,7548);
+DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (7264,7548) AND `type`=11;
+INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`)
+VALUES
+(7264,11,0,0,'achievement_safety_dance'),
+(7548,11,0,0,'achievement_safety_dance');