diff options
| author | Dr-J <daniel.jarrott0@gmail.com> | 2014-11-24 19:09:52 +0000 |
|---|---|---|
| committer | Dr-J <daniel.jarrott0@gmail.com> | 2014-11-24 19:09:52 +0000 |
| commit | fe31f100c31b0d16d33f4ba5ca611139bfb974be (patch) | |
| tree | 688c534f1eb35e0f244ff9189e8521a4da0890f5 | |
| parent | 5e5b8e2cd7cca8c8cfb0cd8ba2a5ede4e044139d (diff) | |
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.
| -rw-r--r-- | sql/updates/world/2014_11_24_03_world.sql | 29 |
1 files changed, 29 insertions, 0 deletions
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 |