aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorMachiavelli <machiavelli.trinity@gmail.com>2011-06-09 04:37:38 +0200
committerMachiavelli <machiavelli.trinity@gmail.com>2011-06-09 04:43:57 +0200
commitb42239b237f53dc4bfc4d5a7498260df34fedaa8 (patch)
treeb8a8bc24457fae0f1a16a2cb70cbe6f2ff8aa460 /sql/updates
parent14067416b41d4dbc76d9f0b7c0844ca2ea756258 (diff)
Scripts/Ulduar/XT-002:
- Implement "Nerf Scrapbots" achievement - Proper target conditions for Boombot Boom - Pummeler add should walk towards raid on spawn
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/2011_06_09_00_world_misc.sql14
1 files changed, 14 insertions, 0 deletions
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');