From b42239b237f53dc4bfc4d5a7498260df34fedaa8 Mon Sep 17 00:00:00 2001 From: Machiavelli Date: Thu, 9 Jun 2011 04:37:38 +0200 Subject: Scripts/Ulduar/XT-002: - Implement "Nerf Scrapbots" achievement - Proper target conditions for Boombot Boom - Pummeler add should walk towards raid on spawn --- sql/updates/world/2011_06_09_00_world_misc.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 sql/updates/world/2011_06_09_00_world_misc.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2011_06_09_00_world_misc.sql b/sql/updates/world/2011_06_09_00_world_misc.sql new file mode 100644 index 00000000000..0c56d63520f --- /dev/null +++ b/sql/updates/world/2011_06_09_00_world_misc.sql @@ -0,0 +1,14 @@ +DELETE FROM `spell_dbc` WHERE `id`=65037; +INSERT INTO `spell_dbc` (`Id`,`Effect1`,`EffectImplicitTargetA1`,`comment`)VALUES +(65037,3,1,'Nerf the Scrapbots Achievement Criteria Marker'); + +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN(10401,10402) AND `type`=18; + +DELETE FROM `conditions` WHERE `SourceEntry`=62834 AND `SourceTypeOrReferenceId`=13 AND `ConditionTypeOrReference`=18; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`Comment`)VALUES +(13,62834,18,1,0,'Boombot Boom - Player target'), +(13,62834,18,1,33343,'Boombot Boom - Scrapbot target'), +(13,62834,18,1,33344,'Boombot Boom - Pummeler target'), +(13,62834,18,1,33346,'Boombot Boom - Boombot target'), +(13,62834,18,1,33329,'Boombot Boom - Heart of the Deconstructor target'), +(13,62834,18,1,33293,'Boombot Boom - XT-002 target'); -- cgit v1.2.3