aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorFH3095 <fh3095-github@yahoo.de>2013-01-29 15:02:54 +0000
committerNay <dnpd.dd@gmail.com>2013-01-29 15:02:54 +0000
commit76910472d824a409adefc774604653e78c7d1041 (patch)
tree5475867576d90bdd49ec92dfe5d7d0fefabe7d4e
parent7b49da48f9c3c21406fbe350de170757ea6e285f (diff)
DB/Achievements: Fix Portal Jockey
Current Status: Portal Jockey(10) is rewarded from 10nh and 25nh, Portal Jockey(25) is rewarded from 10hc and 25hc. Reason: Achievement-criteria 12971 is required for Portal Jockey(25), but checks for map-difficulty 2=10hc. On the other side achievment-criteria 12979 is required for Portal Jockey(10), but checks for map-difficulty 1=25nh. Closes #9081 Ref #6810
-rw-r--r--sql/updates/world/2013_01_29_01_world_achievement_criteria_data.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/updates/world/2013_01_29_01_world_achievement_criteria_data.sql b/sql/updates/world/2013_01_29_01_world_achievement_criteria_data.sql
new file mode 100644
index 00000000000..39627a943cc
--- /dev/null
+++ b/sql/updates/world/2013_01_29_01_world_achievement_criteria_data.sql
@@ -0,0 +1,2 @@
+UPDATE `achievement_criteria_data` SET `value1`=2 WHERE `criteria_id`=12979 AND `type`=12;
+UPDATE `achievement_criteria_data` SET `value1`=1 WHERE `criteria_id`=12971 AND `type`=12;