From fe31f100c31b0d16d33f4ba5ca611139bfb974be Mon Sep 17 00:00:00 2001
From: Dr-J <daniel.jarrott0@gmail.com>
Date: Mon, 24 Nov 2014 19:09:52 +0000
Subject: DB/Achievement: Pilgrim's Peril

Believe original author of this fix may be @VincentMichael its tested anyway and fixes https://github.com/TrinityCore/TrinityCore/issues/11258

Fixes it so you dont get the full achievement by sitting in any char regardless of whether wearing pilgrims robe, dress or attire or not and without having to sit in any other city.
---
 sql/updates/world/2014_11_24_03_world.sql | 29 +++++++++++++++++++++++++++++
 1 file changed, 29 insertions(+)
 create mode 100644 sql/updates/world/2014_11_24_03_world.sql

(limited to 'sql/updates')

diff --git a/sql/updates/world/2014_11_24_03_world.sql b/sql/updates/world/2014_11_24_03_world.sql
new file mode 100644
index 00000000000..afde0f04e51
--- /dev/null
+++ b/sql/updates/world/2014_11_24_03_world.sql
@@ -0,0 +1,29 @@
+    -- Achievement: Pilgrims Peril
+    DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (11134,11135,11136,11137,11138,11139,11140,11141);
+    INSERT INTO `achievement_criteria_data` (`criteria_id`, `type`, `value1`, `value2`) VALUES
+    -- Alliance
+    (11134, 5, 66303, 0), -- Orgrimmar
+    (11134, 6, 14, 0), -- Orgrimmar
+    (11134, 16, 404, 0), -- Orgrimmar
+    (11135, 5, 66303, 0), -- Silvermoon City
+    (11135, 6, 3470, 0), -- Silvermoon City
+    (11135, 16, 404, 0), -- Silvermoon City
+    (11136, 5, 66303, 0), -- Thunder Bluff
+    (11136, 6, 1638, 0), -- Thunder Bluff
+    (11136, 16, 404, 0), -- Thunder Bluff
+    (11137, 5, 66303, 0), -- Undercity
+    (11137, 6, 1497, 0), -- Undercity
+    (11137, 16, 404, 0), -- Undercity
+    -- Horde
+    (11138, 5, 66303, 0), -- Exodar
+    (11138, 6, 3557, 0), -- Exodar
+    (11138, 16, 404, 0), -- Exodar
+    (11139, 5, 66303, 0), -- Darnassus
+    (11139, 6, 1657, 0), -- Darnassus
+    (11139, 16, 404, 0), -- Darnassus
+    (11140, 5, 66303, 0), -- Ironforge
+    (11140, 6, 809, 0), -- Ironforge
+    (11140, 16, 404, 0), -- Ironforge
+    (11141, 5, 66303, 0), -- Stormwind
+    (11141, 6, 12, 0), -- Stormwind
+    (11141, 16, 404, 0); -- Stormwind
-- 
cgit v1.2.3