diff options
| author | Shocker <shocker@freakz.ro> | 2012-01-04 13:27:43 -0800 |
|---|---|---|
| committer | Shocker <shocker@freakz.ro> | 2012-01-04 13:27:43 -0800 |
| commit | ecb1bdd7c3f85eb7721f1661af2f8f6f74e1f0b3 (patch) | |
| tree | 3fe8d1b18355c971f5bfab6f29557872fc79339f /sql | |
| parent | 0a17ab2e4ce86940c6066230de1fe9939656ad3d (diff) | |
| parent | bf73409f4934754fcd8b85e70a16ceb2715e60d0 (diff) | |
Merge pull request #4489 from devilcoredev/fix_001
Core/Achievemens: Fix 'The Undying' and 'The Immortal' achievements
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2011_12_26_00_world_achievements.sql | 29 |
1 files changed, 29 insertions, 0 deletions
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, ''); |