aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2011-03-26 10:33:54 +0100
committerShauren <shauren.trinity@gmail.com>2011-03-26 10:33:54 +0100
commit587baa1518d03ddd47e8b88be032694aa63b8bf7 (patch)
tree3e444bb97321e1e2070e1ad43281d7f1f9e508da
parente494a154c7ea7bcf2db8d9c386c4150717eabec3 (diff)
DB/Achievements: Corrected achievement_criteria_data startup errors
-rw-r--r--sql/updates/world/2011_03_26_1_world_achievement_criteria_data.sql14
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/world/2011_03_26_1_world_achievement_criteria_data.sql b/sql/updates/world/2011_03_26_1_world_achievement_criteria_data.sql
new file mode 100644
index 00000000000..0f1d5083f14
--- /dev/null
+++ b/sql/updates/world/2011_03_26_1_world_achievement_criteria_data.sql
@@ -0,0 +1,14 @@
+DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (10062,10063,10054,10055,10046,10047,10048,10049,10050,10051,10044,10045) AND `type`!=11;
+INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) VALUES
+(10062,12,0,0, ''),
+(10063,12,1,0, ''),
+(10044,12,0,0, ''),
+(10045,12,1,0, ''),
+(10054,12,0,0, ''),
+(10055,12,1,0, ''),
+(10046,12,0,0, ''),
+(10047,12,0,0, ''),
+(10048,12,0,0, ''),
+(10049,12,1,0, ''),
+(10050,12,1,0, ''),
+(10051,12,1,0, '');