From 24f4cf6cb5a0b416617db0fcdadee3fbcf3c9cfc Mon Sep 17 00:00:00 2001 From: Lopin Date: Mon, 20 Jun 2011 17:07:01 +0200 Subject: Core/Achievements: Fixed achievement Safety Dance in Heigan the Unclean's encounter --- sql/updates/world/2011_06_20_03_world_spell_script_names.sql | 4 ++++ sql/updates/world/2011_06_20_04_world_achievement_criteria_data.sql | 6 ++++++ 2 files changed, 10 insertions(+) create mode 100644 sql/updates/world/2011_06_20_03_world_spell_script_names.sql create mode 100644 sql/updates/world/2011_06_20_04_world_achievement_criteria_data.sql (limited to 'sql') 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'); -- cgit v1.2.3