From 5e9882f8623263913fd2a1771d5e8666c18f949f Mon Sep 17 00:00:00 2001 From: Shocker Date: Wed, 4 Jan 2012 23:28:36 +0200 Subject: SQL: Correct SQL file name after recent pull --- .../world/2011_12_26_00_world_achievements.sql | 29 ---------------------- .../world/2012_01_04_02_world_achievements.sql | 29 ++++++++++++++++++++++ 2 files changed, 29 insertions(+), 29 deletions(-) delete mode 100644 sql/updates/world/2011_12_26_00_world_achievements.sql create mode 100644 sql/updates/world/2012_01_04_02_world_achievements.sql (limited to 'sql') diff --git a/sql/updates/world/2011_12_26_00_world_achievements.sql b/sql/updates/world/2011_12_26_00_world_achievements.sql deleted file mode 100644 index cbd5efa3cd6..00000000000 --- a/sql/updates/world/2011_12_26_00_world_achievements.sql +++ /dev/null @@ -1,29 +0,0 @@ --- The Undying -DELETE FROM `disables` WHERE `sourceType` = 4 AND `entry` IN (13237, 13238, 13239, 13240, 7617); -- Enable criteria -DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (13237, 13238, 13239, 13240, 7617); -- Enable instance script execution for achievement criteria -INSERT INTO `achievement_criteria_data` VALUES -(13237, 12, 0, 0, ''), -(13237, 18, 0, 0, ''), -(13238, 12, 0, 0, ''), -(13238, 18, 0, 0, ''), -(13239, 12, 0, 0, ''), -(13239, 18, 0, 0, ''), -(13240, 12, 0, 0, ''), -(13240, 18, 0, 0, ''), -(7617, 12, 0, 0, ''), -(7617, 18, 0, 0, ''); - --- The Immortal -DELETE FROM `disables` WHERE `sourceType` = 4 AND `entry` IN (13233, 13234, 13235, 13236, 7616); -- Enable criteria -DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (13233, 13234, 13235, 13236, 7616); -- Enable instance script execution for achievement criteria -INSERT INTO `achievement_criteria_data` VALUES -(13233, 12, 1, 0, ''), -(13233, 18, 0, 0, ''), -(13234, 12, 1, 0, ''), -(13234, 18, 0, 0, ''), -(13235, 12, 1, 0, ''), -(13235, 18, 0, 0, ''), -(13236, 12, 1, 0, ''), -(13236, 18, 0, 0, ''), -(7616, 12, 1, 0, ''), -(7616, 18, 0, 0, ''); diff --git a/sql/updates/world/2012_01_04_02_world_achievements.sql b/sql/updates/world/2012_01_04_02_world_achievements.sql new file mode 100644 index 00000000000..cbd5efa3cd6 --- /dev/null +++ b/sql/updates/world/2012_01_04_02_world_achievements.sql @@ -0,0 +1,29 @@ +-- The Undying +DELETE FROM `disables` WHERE `sourceType` = 4 AND `entry` IN (13237, 13238, 13239, 13240, 7617); -- Enable criteria +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (13237, 13238, 13239, 13240, 7617); -- Enable instance script execution for achievement criteria +INSERT INTO `achievement_criteria_data` VALUES +(13237, 12, 0, 0, ''), +(13237, 18, 0, 0, ''), +(13238, 12, 0, 0, ''), +(13238, 18, 0, 0, ''), +(13239, 12, 0, 0, ''), +(13239, 18, 0, 0, ''), +(13240, 12, 0, 0, ''), +(13240, 18, 0, 0, ''), +(7617, 12, 0, 0, ''), +(7617, 18, 0, 0, ''); + +-- The Immortal +DELETE FROM `disables` WHERE `sourceType` = 4 AND `entry` IN (13233, 13234, 13235, 13236, 7616); -- Enable criteria +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (13233, 13234, 13235, 13236, 7616); -- Enable instance script execution for achievement criteria +INSERT INTO `achievement_criteria_data` VALUES +(13233, 12, 1, 0, ''), +(13233, 18, 0, 0, ''), +(13234, 12, 1, 0, ''), +(13234, 18, 0, 0, ''), +(13235, 12, 1, 0, ''), +(13235, 18, 0, 0, ''), +(13236, 12, 1, 0, ''), +(13236, 18, 0, 0, ''), +(7616, 12, 1, 0, ''), +(7616, 18, 0, 0, ''); -- cgit v1.2.3