From 051faf9835988e4d9bac16ced8477142a44a3f9f Mon Sep 17 00:00:00 2001 From: kaelima Date: Mon, 9 Jan 2012 14:30:22 +0100 Subject: SQL: Add map difficulty limitation for the achievement added in f850baeb30e2532d2fb52fbd49368f313b73fe04 Thanks Vincent-Michael --- .../world/2012_01_09_00_world_achievement_criteria_data.sql | 5 ----- .../world/2012_01_09_01_world_achievement_criteria_data.sql | 7 +++++++ 2 files changed, 7 insertions(+), 5 deletions(-) delete mode 100644 sql/updates/world/2012_01_09_00_world_achievement_criteria_data.sql create mode 100644 sql/updates/world/2012_01_09_01_world_achievement_criteria_data.sql (limited to 'sql') diff --git a/sql/updates/world/2012_01_09_00_world_achievement_criteria_data.sql b/sql/updates/world/2012_01_09_00_world_achievement_criteria_data.sql deleted file mode 100644 index 6c2bcc86d03..00000000000 --- a/sql/updates/world/2012_01_09_00_world_achievement_criteria_data.sql +++ /dev/null @@ -1,5 +0,0 @@ -DELETE FROM `disables` WHERE `sourceType`=4 AND `entry` IN (7612,7613); -DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (7612,7613); -INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) VALUES -(7612,11,0,0, 'achievement_spore_loser'), -(7613,11,0,0, 'achievement_spore_loser'); diff --git a/sql/updates/world/2012_01_09_01_world_achievement_criteria_data.sql b/sql/updates/world/2012_01_09_01_world_achievement_criteria_data.sql new file mode 100644 index 00000000000..ae3c2ec960a --- /dev/null +++ b/sql/updates/world/2012_01_09_01_world_achievement_criteria_data.sql @@ -0,0 +1,7 @@ +DELETE FROM `disables` WHERE `sourceType`=4 AND `entry` IN (7612,7613); +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (7612,7613); +INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) VALUES +(7612,11,0,0, 'achievement_spore_loser'), +(7612,12,0,0,''), +(7613,11,0,0, 'achievement_spore_loser'), +(7613,12,1,0,''); -- cgit v1.2.3