Core/Scripts: Teron Gorefiend encounter rewrite (#18263)

(cherry picked from commit 109174146cb6b54b6f33cb51983671e5e51d95a2)

4 files changed, 47 insertions, 8 deletions

diff --git a/sql/updates/world/master/2018_02_11_05_world_2016_11_26_00_world.sql b/sql/updates/world/master/2018_02_11_05_world_2016_11_26_00_world.sql
index 67c687b1034..36049ecccd2 100644
--- a/sql/updates/world/master/2018_02_11_05_world_2016_11_26_00_world.sql
+++ b/sql/updates/world/master/2018_02_11_05_world_2016_11_26_00_world.sql
@@ -7,9 +7,9 @@ DELETE FROM `spell_script_names` WHERE `ScriptName`= 'spell_najentus_needle_spin
 INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
 (39992,'spell_najentus_needle_spine');
 
-DELETE FROM `creature_text` WHERE `entry`=22887 AND (`groupid` IN(5,6) OR (`groupid`=4 AND `id`=1));
-INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES
+DELETE FROM `creature_text` WHERE `CreatureID`=22887 AND (`GroupID` IN(5,6) OR (`GroupID`=4 AND `ID`=1));
+INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES
 (22887,4,1,'My patience has run out! Die! Die!',14,0,100,0,0,11458,21096,0,"High Warlord Naj'entus SAY_ENRAGE2"),
 (22887,5,0,'Lord Illidan will... crush you!',14,0,100,0,0,11459,21093,0,"High Warlord Naj'entus SAY_DEATH");
 
-UPDATE `creature_text` SET `text`='Stick around...',`BroadcastTextId`=21089 WHERE `entry`=22887 AND `groupid`=1 AND `id`=0;
+UPDATE `creature_text` SET `Text`='Stick around...',`BroadcastTextId`=21089 WHERE `CreatureID`=22887 AND `GroupID`=1 AND `ID`=0;
diff --git a/sql/updates/world/master/2018_02_11_07_world_2016_11_26_02_world.sql b/sql/updates/world/master/2018_02_11_07_world_2016_11_26_02_world.sql
index b9cdadf6bf7..db6f5470a91 100644
--- a/sql/updates/world/master/2018_02_11_07_world_2016_11_26_02_world.sql
+++ b/sql/updates/world/master/2018_02_11_07_world_2016_11_26_02_world.sql
@@ -17,7 +17,7 @@ INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry
 (13,3,40603,0,0,31,0,3,22948,0,0,0,0,'','Effect_0 and Effect_1 - Hits Gurtogg Bloodboil');
 
 -- Fix Texts
-UPDATE `creature_text` SET `text`='I hunger.',`BroadcastTextId`=21744 WHERE `entry`=22948 AND `groupid`=2 AND `id`=1;
-DELETE FROM `creature_text` WHERE `entry`=22948 AND `groupid`IN(3,4);
-INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES
+UPDATE `creature_text` SET `Text`='I hunger.',`BroadcastTextId`=21744 WHERE `CreatureID`=22948 AND `GroupID`=2 AND `ID`=1;
+DELETE FROM `creature_text` WHERE `CreatureID`=22948 AND `GroupID`IN(3,4);
+INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES
 (22948,3,0,'I\'ll rip the meat from your bones!',14,0,100,0,0,11438,21745,0,'bloodboil SAY_ENRAGE');
diff --git a/sql/updates/world/master/2018_02_11_08_world_2016_11_26_03_world.sql b/sql/updates/world/master/2018_02_11_08_world_2016_11_26_03_world.sql
index 36882e654c8..e6af3773be1 100644
--- a/sql/updates/world/master/2018_02_11_08_world_2016_11_26_03_world.sql
+++ b/sql/updates/world/master/2018_02_11_08_world_2016_11_26_03_world.sql
@@ -1,4 +1,4 @@
-DELETE FROM `creature_text` WHERE entry=22984;
-INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES
+DELETE FROM `creature_text` WHERE CreatureID=22984;
+INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES
 (22984, 0, 0, 'You hear a loud rumble of metal grinding on stone...', 16, 0, 100, 0, 0, 0, 18600, 2, "Black Temple Trigger - when High Warlord Naj'entus dies - Emote"),
 (22984, 1, 0, 'The door to The Den of Mortal Delights has opened.', 16, 0, 100, 0, 0, 0, 21494, 2, 'Black Temple Trigger - when Lower Temple Defeated - Emote');
diff --git a/sql/updates/world/master/2018_02_11_09_world_2016_11_26_04_world.sql b/sql/updates/world/master/2018_02_11_09_world_2016_11_26_04_world.sql
new file mode 100644
index 00000000000..2ab7c3baff3
--- /dev/null
+++ b/sql/updates/world/master/2018_02_11_09_world_2016_11_26_04_world.sql
@@ -0,0 +1,39 @@
+-- Add Flying InhabitType for Doom Blossom.
+UPDATE `creature_template` SET `InhabitType`=`InhabitType`|4 WHERE `entry`= 23123;
+-- Add missing spells to Ghost (Vengeful Spirit)
+UPDATE `creature_template` SET `spell1`=40325, `spell3`=40157, `spell4`=40175, `spell5`=40314, `spell7`=40322 WHERE `entry`=23109;
+-- Add missing auras in Shadowy Construct
+DELETE FROM `creature_template_addon` WHERE `entry`=23111;
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(23111, 0, 0, 0, 0, 0, '40326 40334');
+
+-- Teron Gorefiend texts
+DELETE FROM `creature_text` where `CreatureID`= 22871;
+INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES
+(22871, 0, 0, 'I was the first you know. For me the wheel of death has spun many times. So much time has passed... I have a lot of catching up to do.' , 14, 0, 100, 0, 0, 11512, 21098, 0, 'Teron Gorefiend SAY_INTRO'),
+(22871, 1, 0, 'Vengeance is mine!', 14, 0, 100, 0, 0, 11513, 21097, 0, 'Teron Gorefiend SAY_AGGRO'),
+(22871, 2, 0, 'I have use for you...', 14, 0, 100, 0, 0, 11514, 21099, 0, 'Teron Gorefiend SAY_SLAY1'),
+(22871, 2, 1, 'It gets worse.', 14, 0, 100, 0, 0, 11515, 21100, 0, 'Teron Gorefiend SAY_SLAY2'),
+(22871, 3, 0, 'What are you afraid of?', 14, 0, 100, 0, 0, 11517, 21102, 0, 'Teron Gorefiend SAY_INCINERATE1'),
+(22871, 3, 1, 'You will show the proper respect!', 14, 0, 100, 0, 0, 11520, 21105, 0, 'Teron Gorefiend SAY_INCINERATE2'),
+(22871, 4, 0, "Death really isn't so bad.", 14, 0, 100, 0, 0, 11516, 21101, 0, 'Teron Gorefiend SAY_DOOM_BLOSSOM1'),
+(22871, 4, 1, 'I have something for you...', 14, 0, 100, 0, 0, 11519, 21104, 0, 'Teron Gorefiend SAY_DOOM_BLOSSOM2'),
+(22871, 5, 0, 'Give in.', 14, 0, 100, 0, 0, 11518, 21103, 0, 'Teron Gorefiend SPELL_CRUSHING_SHADOWS'),
+(22871, 6, 0, 'The wheel... spins... again.', 14, 0, 100, 0, 0, 11521, 21106, 0, 'Teron Gorefiend SAY_DEATH');
+
+-- Area Trigger
+DELETE FROM `areatrigger_scripts` WHERE `entry`=4665;
+INSERT INTO `areatrigger_scripts` (`entry`, `ScriptName`) VALUES
+(4665,'at_teron_gorefiend_entrance');
+
+-- Spell scripts
+DELETE FROM `spell_script_names` WHERE `ScriptName` IN('spell_teron_gorefiend_spiritual_vengeance','spell_teron_gorefiend_shadow_of_death','spell_teron_gorefiend_shadow_of_death_remove');
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(40268,'spell_teron_gorefiend_spiritual_vengeance'),
+(40251,'spell_teron_gorefiend_shadow_of_death'),
+(41999,'spell_teron_gorefiend_shadow_of_death_remove');
+
+-- Conditions
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=40268;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(13,3,40268,0,0,31,0,3,23109,0,0,0,0,'','Effect_0 and Effect_1 hits Vengeful Spirit');