aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/2011_03_26_0_world_achievement_criteria_data.sql29
1 files changed, 29 insertions, 0 deletions
diff --git a/sql/updates/world/2011_03_26_0_world_achievement_criteria_data.sql b/sql/updates/world/2011_03_26_0_world_achievement_criteria_data.sql
new file mode 100644
index 00000000000..ed92b7ea830
--- /dev/null
+++ b/sql/updates/world/2011_03_26_0_world_achievement_criteria_data.sql
@@ -0,0 +1,29 @@
+DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (10062,10063,10054,10055,10046,10047,10048,10049,10050,10051,10044,10045);
+INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) VALUES
+(10062,12,0,0, 'achievement_quick_shave'),
+(10063,12,1,0, 'achievement_quick_shave'),
+(10044,12,0,0, 'achievement_unbroken'),
+(10045,12,1,0, 'achievement_unbroken'),
+(10054,12,0,0, 'achievement_shutout'),
+(10055,12,1,0, 'achievement_shutout'),
+(10046,12,0,0, 'achievement_three_car_garage_chopper'),
+(10047,12,0,0, 'achievement_three_car_garage_siege'),
+(10048,12,0,0, 'achievement_three_car_garage_demolisher'),
+(10049,12,1,0, 'achievement_three_car_garage_chopper'),
+(10050,12,1,0, 'achievement_three_car_garage_siege'),
+(10051,12,1,0, 'achievement_three_car_garage_demolisher'),
+(10062,11,0,0, 'achievement_quick_shave'),
+(10063,11,0,0, 'achievement_quick_shave'),
+(10044,11,0,0, 'achievement_unbroken'),
+(10045,11,0,0, 'achievement_unbroken'),
+(10054,11,0,0, 'achievement_shutout'),
+(10055,11,0,0, 'achievement_shutout'),
+(10046,11,0,0, 'achievement_three_car_garage_chopper'),
+(10047,11,0,0, 'achievement_three_car_garage_siege'),
+(10048,11,0,0, 'achievement_three_car_garage_demolisher'),
+(10049,11,0,0, 'achievement_three_car_garage_chopper'),
+(10050,11,0,0, 'achievement_three_car_garage_siege'),
+(10051,11,0,0, 'achievement_three_car_garage_demolisher');
+
+-- Remove disabled entries
+DELETE FROM `disables` WHERE `sourceType`=4 AND `entry` IN (10044,10045,10046,10047,10048,10049,10050,10051,10054,10055,10062,10063);