From bf73409f4934754fcd8b85e70a16ceb2715e60d0 Mon Sep 17 00:00:00 2001
From: Giuseppe Montesanto <montesanto.giuseppe@live.it>
Date: Sun, 1 Jan 2012 04:34:14 +0100
Subject: Fix 'The Undying' and 'The Immortal' achievements.

---
 .../world/2011_12_26_00_world_achievements.sql     | 29 ++++++++++++++++++++++
 1 file changed, 29 insertions(+)
 create mode 100644 sql/updates/world/2011_12_26_00_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
new file mode 100644
index 00000000000..cbd5efa3cd6
--- /dev/null
+++ b/sql/updates/world/2011_12_26_00_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