Scripts/Ulduar: Add script for Hodir encounter.

6 files changed, 69 insertions, 0 deletions

diff --git a/sql/scripts/world_script_texts.sql b/sql/scripts/world_script_texts.sql
index 39f9b04cf40..0c66169cbfb 100644
--- a/sql/scripts/world_script_texts.sql
+++ b/sql/scripts/world_script_texts.sql
@@ -2474,6 +2474,7 @@ INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1`
    (32914,-1603201,'Matron, flee! They are ruthless....',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15503,1,0,0,'Elder Stonebark SAY_DEATH'),
 
 -- Hodir
+   (32845,-1603209,'Hodir begins to cast Flash Freeze!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,3,0,0,'Hodir - EMOTE_FREEZE'),
    (32845,-1603210,'You will suffer for this trespass!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15552,1,0,0,'Hodir SAY_AGGRO'),
    (32845,-1603211,'Tragic. To come so far, only to fail.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15553,1,0,0,'Hodir SAY_SLAY_1'),
    (32845,-1603212,'Welcome to the endless winter.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15554,1,0,0,'Hodir SAY_SLAY_2'),
@@ -2483,6 +2484,7 @@ INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1`
    (32845,-1603216,'Enough! This ends now!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15558,1,0,0,'Hodir SAY_BERSERK'),
    (32845,-1603217,'The veil of winter will protect you, champions!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15559,1,0,0,'Hodir SAY_YS_HELP'),
    (32845,-1603218,'Hodir shatters the Rare Cache of Hodir!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,6,0,0,'Hodir SAY_HARD_MODE_MISSED'),
+   (32845,-1603219,'Hodir gains Frozen Blows!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,3,0,0,'Hodir - EMOTE_BLOW'),
 
 -- Ignis
    (33118,-1603220,'Insolent whelps! Your blood will temper the weapons used to reclaim this world!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15564,1,0,0,'Ignis SAY_AGGRO'),
diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql
index 82b6cd76db9..97109710071 100644
--- a/sql/scripts/world_scripts_full.sql
+++ b/sql/scripts/world_scripts_full.sql
@@ -1580,6 +1580,16 @@ UPDATE `gameobject_template` SET `ScriptName`= 'go_ulduar_tower' WHERE `entry`=1
 UPDATE `gameobject_template` SET `ScriptName`= 'go_ulduar_tower' WHERE `entry`=194371;
 UPDATE `gameobject_template` SET `ScriptName`= 'go_ulduar_tower' WHERE `entry`=194370;
 UPDATE `gameobject_template` SET `ScriptName`= 'go_ulduar_tower' WHERE `entry`=194377;
+UPDATE `creature_template` SET `ScriptName`='npc_hodir_priest' WHERE `entry` IN (32897,33326,32948,33330);
+UPDATE `creature_template` SET `ScriptName`='npc_hodir_shaman' WHERE `entry` IN (33328,32901,33332,32950);
+UPDATE `creature_template` SET `ScriptName`='npc_hodir_druid' WHERE `entry` IN (33325,32900,32941,33333);
+UPDATE `creature_template` SET `ScriptName`='npc_hodir_mage' WHERE `entry` IN (32893,33327,33331,32946);
+UPDATE `creature_template` SET `ScriptName`='npc_toasty_fire' WHERE `entry`=33342;
+UPDATE `creature_template` SET `ScriptName`='npc_flash_freeze' WHERE `entry`=32926;
+UPDATE `creature_template` SET `ScriptName`='npc_icicle' WHERE `entry` IN (33169,33173);
+UPDATE `creature_template` SET `ScriptName`='npc_snowpacked_icicle' WHERE `entry`=33174;
+UPDATE `creature_template` SET `ScriptName`='npc_ice_block' WHERE `entry`=32938;
+UPDATE `creature_template` SET `ScriptName`='boss_hodir' WHERE `entry`=32845;
 
 
 /* UN'GORO CRATER */
diff --git a/sql/updates/world/2011_05_19_01_world_instance_misc.sql b/sql/updates/world/2011_05_19_01_world_instance_misc.sql
new file mode 100644
index 00000000000..1e3d1d9475b
--- /dev/null
+++ b/sql/updates/world/2011_05_19_01_world_instance_misc.sql
@@ -0,0 +1,37 @@
+-- Clean Up
+DELETE FROM `creature_addon` WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (32941,33333,33332,32950,33331,32946,32948,33330,32938));
+DELETE FROM `creature` WHERE `id` IN (32941,33333,33332,32950,33331,32946,32948,33330,32938);
+
+-- Factions
+UPDATE `creature_template` SET `faction_A`=1665, `faction_H`=1665, `unit_flags`=32768 WHERE `entry` IN (33325,32901,33328,32901,32893,33327,32897,33326,32941,33333,33332,32950,33331,32946,32948,33330);
+UPDATE `creature_template` SET `faction_A`=14, `faction_H`=14 WHERE `entry` IN (33352,33353);
+
+-- Unit Flags
+UPDATE `creature_template` SET `unit_flags`=0 WHERE `entry`=32941;
+UPDATE `creature_template` SET `unit_flags`=33686016, `flags_extra`=2 WHERE `entry`=30298;
+UPDATE `creature_template` SET `unit_flags`=33817094 WHERE `entry`=33174;
+UPDATE `creature_template` SET `unit_flags`=393220 WHERE `entry`=32938;
+UPDATE `creature_template` SET `unit_flags`=33948166 WHERE `entry`=33174;
+UPDATE `creature_template` SET `unit_flags`=393220 WHERE `entry` IN (33352,33353);
+
+-- Immunities
+UPDATE `creature_template` SET `mechanic_immune_mask`=612597599 WHERE `entry` IN (32938,32926,33352,33353);
+UPDATE `creature_template` SET `mechanic_immune_mask`=650854239 WHERE `entry`=32845;
+
+-- Miscelaneous
+UPDATE `creature_template` SET `difficulty_entry_1`=33352, `flags_extra`=0 WHERE `entry`=32926;
+UPDATE `creature_template` SET `flags_extra`=0 WHERE `entry` IN (32938,33352,33353);
+
+-- GameObjects
+UPDATE `gameobject_template` SET `flags`=4 WHERE `entry`=194173;
+
+-- Spell Linked Spell
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (61990,61969,65280);
+INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`)
+VALUES 
+(61990,-62457,2,'Hodir - Ice Shards Immunity'),
+(61990,-65370,2,'Hodir - Ice Shards Immunity'),
+(65280,-62469,2,'Toasty fire - Freeze imunity'),
+(65280,-62039,2,'Toasty fire - Biting cold imunity'),
+(61969,7940,2,'Hodir - Flash Freeze immunity'),
+(61990,7940,2,'Hodir - Flash Freeze immunity');
diff --git a/sql/updates/world/2011_05_19_01_world_script_text.sql b/sql/updates/world/2011_05_19_01_world_script_text.sql
new file mode 100644
index 00000000000..1e9530478ef
--- /dev/null
+++ b/sql/updates/world/2011_05_19_01_world_script_text.sql
@@ -0,0 +1,5 @@
+DELETE FROM `script_texts` WHERE `entry` IN (-1603209,-1603219);
+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
+(32845,-1603209,'Hodir begins to cast Flash Freeze!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,3,0,0,'Hodir - EMOTE_FREEZE'),
+(32845,-1603219,'Hodir gains Frozen Blows!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,3,0,0,'Hodir - EMOTE_BLOW');
diff --git a/sql/updates/world/2011_05_19_01_world_scriptname.sql b/sql/updates/world/2011_05_19_01_world_scriptname.sql
new file mode 100644
index 00000000000..fa73710abbd
--- /dev/null
+++ b/sql/updates/world/2011_05_19_01_world_scriptname.sql
@@ -0,0 +1,10 @@
+UPDATE `creature_template` SET `ScriptName`='npc_hodir_priest' WHERE `entry` IN (32897,33326,32948,33330);
+UPDATE `creature_template` SET `ScriptName`='npc_hodir_shaman' WHERE `entry` IN (33328,32901,33332,32950);
+UPDATE `creature_template` SET `ScriptName`='npc_hodir_druid' WHERE `entry` IN (33325,32900,32941,33333);
+UPDATE `creature_template` SET `ScriptName`='npc_hodir_mage' WHERE `entry` IN (32893,33327,33331,32946);
+UPDATE `creature_template` SET `ScriptName`='npc_toasty_fire' WHERE `entry`=33342;
+UPDATE `creature_template` SET `ScriptName`='npc_flash_freeze' WHERE `entry`=32926;
+UPDATE `creature_template` SET `ScriptName`='npc_icicle' WHERE `entry` IN (33169,33173);
+UPDATE `creature_template` SET `ScriptName`='npc_snowpacked_icicle' WHERE `entry`=33174;
+UPDATE `creature_template` SET `ScriptName`='npc_ice_block' WHERE `entry`=32938;
+UPDATE `creature_template` SET `ScriptName`='boss_hodir' WHERE `entry`=32845;
diff --git a/sql/updates/world/2011_05_19_01_world_spell_script_names.sql b/sql/updates/world/2011_05_19_01_world_spell_script_names.sql
new file mode 100644
index 00000000000..5e7989aaef7
--- /dev/null
+++ b/sql/updates/world/2011_05_19_01_world_spell_script_names.sql
@@ -0,0 +1,5 @@
+DELETE FROM `spell_script_names` WHERE `spell_id` IN (62038,62039);
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`)
+VALUES
+(62038,'spell_biting_cold'),
+(62039,'spell_biting_cold_dot');