diff options
| author | TCkiper <kiperek@o2.pl> | 2011-05-07 13:37:52 +0100 |
|---|---|---|
| committer | Duarte Duarte <dnpd.dd@gmail.com> | 2011-05-07 13:37:52 +0100 |
| commit | 024192749a80a2de69ff6c60718ace0863d9c5f9 (patch) | |
| tree | b3f20046315da6450887b58f142f2eaa51d29613 | |
| parent | 2920eb9c0b074b5ec43d391e8ef9ccd1b8437415 (diff) | |
DB/Achievements: Fix achievements Wrath of The Horde and of the Alliance
| -rw-r--r-- | sql/updates/world/2011_05_07_03_world_achievement_criteria_data.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/sql/updates/world/2011_05_07_03_world_achievement_criteria_data.sql b/sql/updates/world/2011_05_07_03_world_achievement_criteria_data.sql new file mode 100644 index 00000000000..9c5e31a8217 --- /dev/null +++ b/sql/updates/world/2011_05_07_03_world_achievement_criteria_data.sql @@ -0,0 +1,17 @@ +-- Fix criteria for Wrath of the Horde achievements +DELETE FROM `disables` WHERE `sourceType`=4 AND `entry` IN (6637,6638,6639,6640); +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (6637,6638,6639,6640); +INSERT INTO `achievement_criteria_data` (`criteria_id`, `type`, `value1`, `value2`, `ScriptName`) VALUES +(6637,6,1537,0, ''), -- killed player in Ironforge +(6638,6,1657,0, ''), -- killed player in Darnassus +(6639,6,3557,0, ''), -- killed player in The Exodar +(6640,6,1519,0, ''); -- killed player in Stormwind City + +-- Fix criteria for Wrath of the Alliance achievements +DELETE FROM `disables` WHERE `sourceType`=4 AND `entry` IN (6636,6633,6634,6635); +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (6636,6633,6634,6635); +INSERT INTO `achievement_criteria_data` (`criteria_id`, `type`, `value1`, `value2`, `ScriptName`) VALUES +(6636,6,1497,0, ''), -- killed player in Undercity +(6633,6,1638,0, ''), -- killed player in Thunder Bluff +(6634,6,3487,0, ''), -- killed player in Silvermoon City +(6635,6,1637,0, ''); -- killed player in Orgrimmar |