*Update naxx script.

--HG--
branch : trunk

1 files changed, 34 insertions, 0 deletions

diff --git a/sql/updates/3233_world_scripts_naxx.sql b/sql/updates/3233_world_scripts_naxx.sql
new file mode 100644
index 00000000000..7272b328f8e
--- /dev/null
+++ b/sql/updates/3233_world_scripts_naxx.sql
@@ -0,0 +1,34 @@
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (-28169);
+INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES
+(-28169, 28206,  0, 'Mutating Injection - Mutagen Explosion'),
+(-28169, 28240,  0, 'Mutating Injection - Poison Cloud');
+
+UPDATE creature_template SET scriptname = 'boss_grobbulus' WHERE entry = 15931;
+
+INSERT INTO creature_template (entry, spell1, flags_extra, scriptname) VALUES
+(16363, 28158, 128, ''), # Grobbulus Cloud
+(29379, 54362, 128, '')  # Grobbulus Cloud (H)
+ON DUPLICATE KEY UPDATE
+spell1 = VALUES(spell1),
+flags_extra = VALUES(flags_extra),
+scriptname = VALUES(scriptname);
+
+INSERT INTO creature_template (entry, spell1, spell2, flags_extra, scriptname) VALUES
+(16474, 28547, 1000, 128, 'trigger_periodic'), # Blizzard (Sapphiron)
+(30000, 55699, 1000, 128, 'trigger_periodic')  # Blizzard (Sapphiron) (H)
+ON DUPLICATE KEY UPDATE
+spell1 = VALUES(spell1),
+spell2 = VALUES(spell2),
+flags_extra = VALUES(flags_extra),
+scriptname = VALUES(scriptname);
+
+DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (29912);
+INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_id`, `cast_flags`) VALUES
+(29912, 55479, 0, 1); # Obedience Crystal - Force Obedience
+
+DELETE FROM `spell_script_target` WHERE `entry` IN (55479);
+INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
+(55479, 1, 16803); # Force Obedience - Death Knight Understudy
+
+# Death Knight Understudy
+UPDATE creature_template SET spell1=0, spell2=0, spell3=0, spell4=61696, spell5=29060, spell6=29061 WHERE entry IN (16803,29941);