Scripts/Icecrown Citadel: Added Rotting Frost Giant script

7 files changed, 15 insertions, 3 deletions

diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql
index 83e7b601905..8bb02cc045b 100644
--- a/sql/scripts/world_scripts_full.sql
+++ b/sql/scripts/world_scripts_full.sql
@@ -843,6 +843,7 @@ UPDATE `creature_template` SET `ScriptName`='boss_lady_deathwhisper' WHERE `entr
 UPDATE `creature_template` SET `ScriptName`='npc_cult_fanatic' WHERE `entry` IN (37890,38009,38135);
 UPDATE `creature_template` SET `ScriptName`='npc_cult_adherent' WHERE `entry` IN(37949,38010,38136);
 UPDATE `creature_template` SET `ScriptName`='npc_vengeful_shade' WHERE `entry`=38222;
+UPDATE `creature_template` SET `ScriptName`='npc_rotting_frost_giant' WHERE `entry` IN (38490,38494);
 UPDATE `creature_template` SET `ScriptName`='boss_deathbringer_saurfang' WHERE `entry`=37813;
 UPDATE `creature_template` SET `ScriptName`='npc_high_overlord_saurfang_icc' WHERE `entry`=37187;
 UPDATE `creature_template` SET `ScriptName`='npc_muradin_bronzebeard_icc' WHERE `entry`=37200;
@@ -1895,6 +1896,7 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
 ( 72495, 'spell_cultist_dark_martyrdom'),
 ( 72496, 'spell_cultist_dark_martyrdom'),
 ( 72497, 'spell_cultist_dark_martyrdom'),
+( 72864, 'spell_frost_giant_death_plague'),
 ( 72202, 'spell_deathbringer_blood_link'),
 ( 72178, 'spell_deathbringer_blood_link_aura'),
 ( 72371, 'spell_deathbringer_blood_power'),
@@ -2073,7 +2075,7 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
 ( 59640, 'spell_item_underbelly_elixir'),
 ( 71905, 'spell_item_shadowmourne'),
 ( 67533, 'spell_item_red_rider_air_rifle'),
-( 26678,'spell_item_create_heart_candy'),
+( 26678, 'spell_item_create_heart_candy'),
 -- warrior
 ( 12975, 'spell_warr_last_stand'),
 ( 59725, 'spell_warr_improved_spell_reflection'),
diff --git a/sql/updates/world/2011_02_12_0_world_script_name.sql b/sql/updates/world/2011_02_12_0_world_script_name.sql
deleted file mode 100644
index e3861d13dbb..00000000000
--- a/sql/updates/world/2011_02_12_0_world_script_name.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-DELETE FROM `spell_script_names` WHERE `spell_id`=26678;
-INSERT INTO `spell_script_names` VALUES (26678,'spell_item_create_heart_candy');
\ No newline at end of file
diff --git a/sql/updates/world/2011_02_12_0_world_spell_script_names.sql b/sql/updates/world/2011_02_12_0_world_spell_script_names.sql
new file mode 100644
index 00000000000..39098e1c3de
--- /dev/null
+++ b/sql/updates/world/2011_02_12_0_world_spell_script_names.sql
@@ -0,0 +1,3 @@
+DELETE FROM `spell_script_names` WHERE `spell_id`=26678;
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
+(26678,'spell_item_create_heart_candy');
diff --git a/sql/updates/world/2011_02_15_3_world_creature_template.sql b/sql/updates/world/2011_02_15_3_world_creature_template.sql
new file mode 100644
index 00000000000..cc892b30bf9
--- /dev/null
+++ b/sql/updates/world/2011_02_15_3_world_creature_template.sql
@@ -0,0 +1 @@
+UPDATE `creature_template` SET `minlevel`=82,`maxlevel`=82,`exp`=2,`unit_class`=1,`faction_A`=16,`faction_H`=16,`baseattacktime`=2000,`unit_flags`=33280,`speed_run`=0.9920629 WHERE `entry`=38494; -- Rotting Frost Giant
diff --git a/sql/updates/world/2011_02_15_3_world_creature_text.sql b/sql/updates/world/2011_02_15_3_world_creature_text.sql
new file mode 100644
index 00000000000..6642afba9b7
--- /dev/null
+++ b/sql/updates/world/2011_02_15_3_world_creature_text.sql
@@ -0,0 +1,4 @@
+DELETE FROM `creature_text` WHERE `entry` IN (38490,38494);
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
+(38490,0,0, '$n is infected with the Death Plague!',3,0,100,25,0,0, 'Rotting Frost Giant - Death Plague'),
+(38494,0,0, '$n is infected with the Death Plague!',3,0,100,25,0,0, 'Rotting Frost Giant - Death Plague');
diff --git a/sql/updates/world/2011_02_15_3_world_scriptname.sql b/sql/updates/world/2011_02_15_3_world_scriptname.sql
new file mode 100644
index 00000000000..ec7c4f3d483
--- /dev/null
+++ b/sql/updates/world/2011_02_15_3_world_scriptname.sql
@@ -0,0 +1 @@
+UPDATE `creature_template` SET `ScriptName`='npc_rotting_frost_giant' WHERE `entry` IN (38490,38494);
diff --git a/sql/updates/world/2011_02_15_3_world_spell_script_names.sql b/sql/updates/world/2011_02_15_3_world_spell_script_names.sql
new file mode 100644
index 00000000000..85c9a11fd50
--- /dev/null
+++ b/sql/updates/world/2011_02_15_3_world_spell_script_names.sql
@@ -0,0 +1,3 @@
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_frost_giant_death_plague';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
+(72864,'spell_frost_giant_death_plague');