aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/world
diff options
context:
space:
mode:
authorMachiavelli <machiavelli.trinity@gmail.com>2011-06-10 18:24:16 +0200
committerMachiavelli <machiavelli.trinity@gmail.com>2011-06-10 18:24:16 +0200
commit680798a11d48e9da51bf4a7eb31503bb450a502f (patch)
treeb37ec55bebc494328247e5ce7dd4c9ff13144af4 /sql/updates/world
parentbf739402491d7f18f902543fab53d0299eb35cee (diff)
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
Diffstat (limited to 'sql/updates/world')
-rw-r--r--sql/updates/world/2011_06_10_02_world_misc.sql31
1 files changed, 31 insertions, 0 deletions
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