Scripts/Icecrown Citadel: Added Festergut script, thx Cromash for providing the base and Cyrax for sniffs

Scripts/Icecrown Citadel: Added Professor Putricide script handling ONLY Festergut related events

--HG--
branch : trunk

8 files changed, 92 insertions, 8 deletions

diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index 3936238030b..d15a5dd59c5 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -14824,6 +14824,19 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
 ( 72438, 'spell_deathbringer_blood_nova'),
 ( 72439, 'spell_deathbringer_blood_nova'),
 ( 72440, 'spell_deathbringer_blood_nova'),
+( 71123, 'spell_stinky_precious_decimate'),
+( 73032, 'spell_festergut_pungent_blight'),
+( 73031, 'spell_festergut_pungent_blight'),
+( 71219, 'spell_festergut_pungent_blight'),
+( 69195, 'spell_festergut_pungent_blight'),
+( 72219, 'spell_festergut_gastric_bloat'),
+( 72551, 'spell_festergut_gastric_bloat'),
+( 72552, 'spell_festergut_gastric_bloat'),
+( 72553, 'spell_festergut_gastric_bloat'),
+( 69290, 'spell_festergut_blighted_spores'),
+( 71222, 'spell_festergut_blighted_spores'),
+( 73033, 'spell_festergut_blighted_spores'),
+( 73034, 'spell_festergut_blighted_spores'),
 -- quest
 ( 45449, 'spell_q11587_arcane_prisoner_rescue'),
 ( 46023, 'spell_q11730_ultrasonic_screwdriver'),
@@ -15812,12 +15825,12 @@ DROP TABLE IF EXISTS `vehicle_accessory`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `vehicle_accessory` (
-        `entry` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
-        `accessory_entry` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
-        `seat_id` TINYINT(1) SIGNED NOT NULL DEFAULT 0,
-        `minion` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
-        `description` TEXT NOT NULL,
-        PRIMARY KEY (`entry`, `seat_id`)
+  `entry` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
+  `accessory_entry` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
+  `seat_id` TINYINT(1) SIGNED NOT NULL DEFAULT 0,
+  `minion` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
+  `description` TEXT NOT NULL,
+  PRIMARY KEY (`entry`, `seat_id`)
 )
 COLLATE=utf8_general_ci
 ENGINE=MyISAM
@@ -15831,6 +15844,9 @@ AVG_ROW_LENGTH=0;
 
 LOCK TABLES `vehicle_accessory` WRITE;
 /*!40000 ALTER TABLE `vehicle_accessory` DISABLE KEYS */;
+INSERT INTO `vehicle_accessory` VALUES
+(36678,38309,0,1, 'Professor Putricide - trigger'),
+(36678,38308,1,1, 'Professor Putricide - trigger');
 /*!40000 ALTER TABLE `vehicle_accessory` ENABLE KEYS */;
 UNLOCK TABLES;
 
diff --git a/sql/scripts/world_script_texts.sql b/sql/scripts/world_script_texts.sql
index e6862edf56c..0706d616886 100644
--- a/sql/scripts/world_script_texts.sql
+++ b/sql/scripts/world_script_texts.sql
@@ -2744,6 +2744,21 @@ INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1`
    (37187,-1631076,'You will have a proper ceremony in Nagrand next to the pyres of your mother and ancestors.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,17101,0,0,0,'SAY_OUTRO_HORDE_3'),
    (37187,-1631077,'Honor, young heroes... no matter how dire the battle... Never forsake it!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,17102,0,0,0,'SAY_OUTRO_HORDE_4'),
 
+-- Festergut
+   (36626,-1631078,'NOOOO! You kill Stinky! You pay!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16907,1,0,0,'SAY_STINKY_DEAD'),
+   (36626,-1631079,'Fun time!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16901,1,0,0,'SAY_AGGRO'),
+   (36678,-1631080,'Just an ordinary gas cloud. But watch out, because that''s no ordinary gas cloud!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,17119,1,0,432,'SAY_GASEOUS_BLIGHT'),
+   (36626,-1631081,'Festergut farts.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16911,2,0,0,'EMOTE_GAS_SPORE'),
+   (36626,-1631082,'Festergut releases Gas Spores!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,3,0,0,'EMOTE_WARN_GAS_SPORE'),
+   (36626,-1631083,'Gyah! Uhhh, I not feel so good...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16906,1,0,0,'SAY_PUNGENT_BLIGHT'),
+   (36626,-1631084,'Festergut begins to cast |cFFFF7F00Pungent Blight!|r',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,3,0,0,'EMOTE_WARN_PUNGENT_BLIGHT'),
+   (36626,-1631085,'Festergut vomits.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,2,0,0,'EMOTE_PUNGENT_BLIGHT'),
+   (36626,-1631086,'Daddy, I did it!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16902,1,0,0,'SAY_KILL_1'),
+   (36626,-1631087,'Dead, dead, dead!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16903,1,0,0,'SAY_KILL_2'),
+   (36626,-1631088,'Fun time over!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16905,1,0,0,'SAY_BERSERK'),
+   (36626,-1631089,'Da ... Ddy...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16904,1,0,0,'SAY_DEATH'),
+   (36678,-1631090,'Oh, Festergut. You were always my favorite. Next to Rotface. The good news is you left behind so much gas, I can practically taste it!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,17124,1,0,0,'SAY_FESTERGUT_DEATH'),
+
 -- -1 632 000 ICECROWN CITADEL: FROZEN HALLS: FORGE OF SOULS
 -- Bronjham
    (36497,-1632001,'Finally...a captive audience!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16595,1,0,0,'Bronjham SAY_AGGRO'),
diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql
index 8f57b394d44..8711d54f36b 100644
--- a/sql/scripts/world_scripts_full.sql
+++ b/sql/scripts/world_scripts_full.sql
@@ -841,6 +841,9 @@ UPDATE `creature_template` SET `ScriptName`='boss_deathbringer_saurfang' WHERE `
 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;
 UPDATE `creature_template` SET `ScriptName`='npc_saurfang_event' WHERE `entry` IN (37920,37830);
+UPDATE `creature_template` SET `ScriptName`='boss_festergut' WHERE `entry`=36626;
+UPDATE `creature_template` SET `ScriptName`='npc_stinky_icc' WHERE `entry`=37025;
+UPDATE `creature_template` SET `ScriptName`='boss_professor_putricide' WHERE `entry`=36678;
 
 /* IRONFORGE */
 UPDATE `creature_template` SET `ScriptName`='npc_royal_historian_archesonus' WHERE `entry`=8879;
@@ -1721,7 +1724,7 @@ UPDATE `outdoorpvp_template` SET `ScriptName`='outdoorpvp_si' WHERE `TypeId`=5;
 UPDATE `outdoorpvp_template` SET `ScriptName`='outdoorpvp_ep' WHERE `TypeId`=6;
 
 /* ACHIEVEMENTS */
-DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (3693,6641,6642,6643,6644,3804,3805,3806,3807,3808,3809,3810,3811,3812,3813,1234,1239,5605,5606,12778,13036,13035,13037) AND `type` IN (0,11);
+DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (3693,6641,6642,6643,6644,3804,3805,3806,3807,3808,3809,3810,3811,3812,3813,1234,1239,5605,5606,12778,13036,13035,13037,12977,12967,12986,12982) AND `type` IN (0,11);
 INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) VALUES
 (3693,11,0,0, 'achievement_storm_glory'),
 (6641,11,0,0, 'achievement_school_of_hard_knocks'),
@@ -1745,6 +1748,10 @@ INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,
 (12778,11,0,0, 'achievement_ive_gone_and_made_a_mess'),
 (13036,11,0,0, 'achievement_ive_gone_and_made_a_mess'),
 (13035,11,0,0, 'achievement_ive_gone_and_made_a_mess'),
-(13037,11,0,0, 'achievement_ive_gone_and_made_a_mess');
+(13037,11,0,0, 'achievement_ive_gone_and_made_a_mess'),
+(12977,11,0,0, 'achievement_flu_shot_shortage'),
+(12967,11,0,0, 'achievement_flu_shot_shortage'),
+(12986,11,0,0, 'achievement_flu_shot_shortage'),
+(12982,11,0,0, 'achievement_flu_shot_shortage');
 
 /* EOF */
diff --git a/sql/updates/9700_world_achievement_criteria_data.sql b/sql/updates/9700_world_achievement_criteria_data.sql
new file mode 100644
index 00000000000..f94bbb2cc4d
--- /dev/null
+++ b/sql/updates/9700_world_achievement_criteria_data.sql
@@ -0,0 +1,6 @@
+DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (12977,12967,12986,12982) AND `type` IN (0,11);
+INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) VALUES
+(12977,11,0,0, 'achievement_flu_shot_shortage'),
+(12967,11,0,0, 'achievement_flu_shot_shortage'),
+(12986,11,0,0, 'achievement_flu_shot_shortage'),
+(12982,11,0,0, 'achievement_flu_shot_shortage');
diff --git a/sql/updates/9700_world_script_texts.sql b/sql/updates/9700_world_script_texts.sql
new file mode 100644
index 00000000000..de3fd927d3c
--- /dev/null
+++ b/sql/updates/9700_world_script_texts.sql
@@ -0,0 +1,15 @@
+DELETE FROM `script_texts` WHERE `entry` BETWEEN -1631090 AND -1631078;
+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
+(36626,-1631078, 'NOOOO! You kill Stinky! You pay!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16907,1,0,0, 'SAY_STINKY_DEAD'),
+(36626,-1631079, 'Fun time!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16901,1,0,0, 'SAY_AGGRO'),
+(36678,-1631080, 'Just an ordinary gas cloud. But watch out, because that''s no ordinary gas cloud!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,17119,1,0,432, 'SAY_GASEOUS_BLIGHT'),
+(36626,-1631081, 'Festergut farts.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16911,2,0,0, 'EMOTE_GAS_SPORE'),
+(36626,-1631082, 'Festergut releases Gas Spores!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,3,0,0, 'EMOTE_WARN_GAS_SPORE'),
+(36626,-1631083, 'Gyah! Uhhh, I not feel so good...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16906,1,0,0, 'SAY_PUNGENT_BLIGHT'),
+(36626,-1631084, 'Festergut begins to cast |cFFFF7F00Pungent Blight!|r',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,3,0,0, 'EMOTE_WARN_PUNGENT_BLIGHT'),
+(36626,-1631085, 'Festergut vomits.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,2,0,0, 'EMOTE_PUNGENT_BLIGHT'),
+(36626,-1631086, 'Daddy, I did it!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16902,1,0,0, 'SAY_KILL_1'),
+(36626,-1631087, 'Dead, dead, dead!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16903,1,0,0, 'SAY_KILL_2'),
+(36626,-1631088, 'Fun time over!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16905,1,0,0, 'SAY_BERSERK'),
+(36626,-1631089, 'Da ... Ddy...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16904,1,0,0, 'SAY_DEATH'),
+(36678,-1631090, 'Oh, Festergut. You were always my favorite. Next to Rotface. The good news is you left behind so much gas, I can practically taste it!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,17124,1,0,0, 'SAY_FESTERGUT_DEATH');
diff --git a/sql/updates/9700_world_scriptname.sql b/sql/updates/9700_world_scriptname.sql
new file mode 100644
index 00000000000..c3ec248a6d0
--- /dev/null
+++ b/sql/updates/9700_world_scriptname.sql
@@ -0,0 +1,3 @@
+UPDATE `creature_template` SET `ScriptName`='boss_festergut' WHERE `entry`=36626;
+UPDATE `creature_template` SET `ScriptName`='npc_stinky_icc' WHERE `entry`=37025;
+UPDATE `creature_template` SET `ScriptName`='boss_professor_putricide' WHERE `entry`=36678;
diff --git a/sql/updates/9700_world_spell_script_names.sql b/sql/updates/9700_world_spell_script_names.sql
new file mode 100644
index 00000000000..24e3a8a3e89
--- /dev/null
+++ b/sql/updates/9700_world_spell_script_names.sql
@@ -0,0 +1,18 @@
+DELETE FROM `spell_script_names` WHERE `spell_id`=73032 AND `ScriptName`='spell_stinky_precious_decimate';
+DELETE FROM `spell_script_names` WHERE `spell_id` IN (73032,73031,71219,69195) AND `ScriptName`='spell_festergut_pungent_blight';
+DELETE FROM `spell_script_names` WHERE `spell_id` IN (72219,72551,72552,72553) AND `ScriptName`='spell_festergut_gastric_bloat';
+DELETE FROM `spell_script_names` WHERE `spell_id` IN (69290,71222,73033,73034) AND `ScriptName`='spell_festergut_blighted_spores';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
+(71123,'spell_stinky_precious_decimate'),
+(73032,'spell_festergut_pungent_blight'),
+(73031,'spell_festergut_pungent_blight'),
+(71219,'spell_festergut_pungent_blight'),
+(69195,'spell_festergut_pungent_blight'),
+(72219,'spell_festergut_gastric_bloat'),
+(72551,'spell_festergut_gastric_bloat'),
+(72552,'spell_festergut_gastric_bloat'),
+(72553,'spell_festergut_gastric_bloat'),
+(69290,'spell_festergut_blighted_spores'),
+(71222,'spell_festergut_blighted_spores'),
+(73033,'spell_festergut_blighted_spores'),
+(73034,'spell_festergut_blighted_spores');
diff --git a/sql/updates/9700_world_vehicle_accessory.sql b/sql/updates/9700_world_vehicle_accessory.sql
new file mode 100644
index 00000000000..41353ee1975
--- /dev/null
+++ b/sql/updates/9700_world_vehicle_accessory.sql
@@ -0,0 +1,4 @@
+DELETE FROM `vehicle_accessory` WHERE `entry`=36678;
+INSERT INTO `vehicle_accessory` (`entry`,`accessory_entry`,`seat_id`,`minion`,`description`) VALUES
+(36678,38309,0,1, 'Professor Putricide - trigger'),
+(36678,38308,1,1, 'Professor Putricide - trigger');