diff options
| author | Supabad <supabad.trinity@gmail.com> | 2011-03-26 09:59:41 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2011-03-26 10:00:41 +0100 |
| commit | e494a154c7ea7bcf2db8d9c386c4150717eabec3 (patch) | |
| tree | 3810af5915d3dd98442b55a22c73a49da3d86460 /sql/updates | |
| parent | 18995661a79837953e5345090645c5506f9d46bf (diff) | |
Scripts/Ulduar:
Some cleanup in Flame Leviathan script
Add support for Shutout - Three Car Garage - Unbroken - Quick Shave
Add reset to Razorscale controller on fight end
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/2011_03_26_0_world_achievement_criteria_data.sql | 29 |
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); |