Scripts/Ulduar/XT-002:

- Implement achievement Nerf Engineering
- Implement achievement Nerf Gravity Bombs
- Implement achievement Heartbreaker
- Boombot's shouldn't melee
- Call BossAI::Reset in XT002::Reset, fixes some timer issues

2 files changed, 35 insertions, 2 deletions

diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql
index bcb6f02dc02..84776a121b2 100644
--- a/sql/scripts/world_scripts_full.sql
+++ b/sql/scripts/world_scripts_full.sql
@@ -2210,8 +2210,10 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
 ( 62274, 'spell_shield_of_runes'),
 ( 63018, 'spell_xt002_searing_light_spawn_life_spark'),
 ( 65121, 'spell_xt002_searing_light_spawn_life_spark'),
-( 64234, 'spell_xt002_gravity_bomb_spawn_void_zone'),
-( 63024, 'spell_xt002_gravity_bomb_spawn_void_zone'),
+( 64234, 'spell_xt002_gravity_bomb_aura'),
+( 63024, 'spell_xt002_gravity_bomb_aura'),
+( 64233, 'spell_xt002_gravity_bomb_damage'),
+( 63025, 'spell_xt002_gravity_bomb_damage'),
 ( 62791, 'spell_xt002_heart_overload_periodic'),
 ( 62775, 'spell_xt002_tympanic_tantrum'),
 ( 37751, 'spell_xt002_submerged'),
diff --git a/sql/updates/world/2011_06_10_02_world_misc.sql b/sql/updates/world/2011_06_10_02_world_misc.sql
new file mode 100644
index 00000000000..af07fab967a
--- /dev/null
+++ b/sql/updates/world/2011_06_10_02_world_misc.sql
@@ -0,0 +1,31 @@
+-- Delete disabled achievements
+DELETE FROM `disables` WHERE `sourceType`=4 AND `entry` IN(10074,10075,10220,10221,10077,10079);
+
+DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN(10074,10075,10220,10221,10077,10079);
+INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`ScriptName`) VALUES
+-- Nerf Engineering 10m
+(10074,11,0,'achievement_nerf_engineering'),
+(10074,12,0,''),
+-- Nerf Engineering 25m
+(10075,11,0,'achievement_nerf_engineering'),
+(10075,12,1,''),
+-- Heartbreaker 10m
+(10221,11,0,'achievement_heartbreaker'),
+(10221,12,0,''),
+-- Heartbreaker 25m
+(10220,11,0,'achievement_heartbreaker'),
+(10220,12,1,''),
+-- Nerf Gravity Bombs 10m
+(10077,11,0,'achievement_nerf_gravity_bombs'),
+(10077,12,0,''),
+-- Nerf Gravity Bombs 25m
+(10079,11,0,'achievement_nerf_gravity_bombs'),
+(10079,12,1,'');
+
+DELETE FROM `spell_script_names` WHERE `spell_id` IN(64233,63025);
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
+(64233,'spell_xt002_gravity_bomb_damage'),
+(63025,'spell_xt002_gravity_bomb_damage');
+
+-- Better naming for changed script with new functionality
+UPDATE `spell_script_names` SET `ScriptName`='spell_xt002_gravity_bomb_aura' WHERE `spell_id` IN(64234,63024)
\ No newline at end of file