5 files changed, 46 insertions, 0 deletions
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');