Scripts: Added script for Lord Marrowgar

Added base script for Icecrown Citadel instance

--HG--
branch : trunk

3 files changed, 32 insertions, 0 deletions

diff --git a/sql/updates/9453_world_script_texts.sql b/sql/updates/9453_world_script_texts.sql
new file mode 100644
index 00000000000..956ca43ccb2
--- /dev/null
+++ b/sql/updates/9453_world_script_texts.sql
@@ -0,0 +1,12 @@
+DELETE FROM `script_texts` WHERE `entry` BETWEEN -1631999 AND -1631000;
+INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`,`sound`,`type`,`language`,`emote`,`comment`) VALUES
+(36612,-1631000,'This is the beginning AND the end, mortals. None may enter the master''s sanctum!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16950,1,0,0,'SAY_ENTER_ZONE'),
+(36612,-1631001,'The Scourge will wash over this world as a swarm of death and destruction!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16941,1,0,0,'SAY_AGGRO'),
+(36612,-1631002,'BONE STORM!',NULL,NULL, NULL,NULL,NULL,NULL,NULL,NULL,16946,1,0,0,'SAY_BONE_STORM'),
+(36612,-1631003,'Bound by bone!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16947,1,0,0, 'SAY_BONESPIKE_1'),
+(36612,-1631004,'Stick Around!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16948,1,0,0,'SAY_BONESPIKE_2'),
+(36612,-1631005,'The only escape is death!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16949,1,0,0,'SAY_BONESPIKE_3'),
+(36612,-1631006,'More bones for the offering!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16942,1,0,0,'SAY_KILL_1'),
+(36612,-1631007,'Languish in damnation!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16943,1,0,0,'SAY_KILL_2'),
+(36612,-1631008,'I see... only darkness...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16944,1,0,0,'SAY_DEATH'),
+(36612,-1631009,'THE MASTER''S RAGE COURSES THROUGH ME!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16945,1,0,0,'SAY_BERSERK');
diff --git a/sql/updates/9453_world_scriptname.sql b/sql/updates/9453_world_scriptname.sql
new file mode 100644
index 00000000000..9b1c3617496
--- /dev/null
+++ b/sql/updates/9453_world_scriptname.sql
@@ -0,0 +1,7 @@
+-- Lord Marrowgar
+UPDATE `creature_template` SET `ScriptName`='boss_lord_marrowgar' WHERE `entry`=36612;
+UPDATE `creature_template` SET `ScriptName`='npc_coldflame' WHERE `entry`=36672;
+UPDATE `creature_template` SET `ScriptName`='npc_bone_spike' WHERE `entry`=38711;
+
+-- Instance
+UPDATE `instance_template` SET `script`='instance_icecrown_citadel' WHERE `map`=631;
diff --git a/sql/updates/9453_world_spell_script_names.sql b/sql/updates/9453_world_spell_script_names.sql
new file mode 100644
index 00000000000..cae78c9a8b9
--- /dev/null
+++ b/sql/updates/9453_world_spell_script_names.sql
@@ -0,0 +1,13 @@
+DELETE FROM `spell_script_names` WHERE `spell_id`=69057 AND `ScriptName`='spell_marrowgar_bone_spike_graveyard';
+DELETE FROM `spell_script_names` WHERE `spell_id` IN (69140,72705) AND `ScriptName`='spell_marrowgar_coldflame';
+DELETE FROM `spell_script_names` WHERE `spell_id`=69147 AND `ScriptName`='spell_marrowgar_coldflame_trigger';
+DELETE FROM `spell_script_names` WHERE `spell_id` IN (69075,70834,70835,70836) AND `ScriptName`='spell_marrowgar_bone_storm';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
+(69057,'spell_marrowgar_bone_spike_graveyard'),
+(69140,'spell_marrowgar_coldflame'),
+(72705,'spell_marrowgar_coldflame'),
+(69147,'spell_marrowgar_coldflame_trigger'),
+(69075,'spell_marrowgar_bone_storm'),
+(70834,'spell_marrowgar_bone_storm'),
+(70835,'spell_marrowgar_bone_storm'),
+(70836,'spell_marrowgar_bone_storm');