DB/Creature: Rework Archmage Vargoth's gossip menu handling & add outro event for 'Ar'kelos the Guardian'

(cherry picked from commit af39c21e72089a08a065b45b9e68b325b6ce57ad)

1 files changed, 62 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_02_28_39_world_2020_10_20_01_world.sql b/sql/updates/world/master/2022_02_28_39_world_2020_10_20_01_world.sql
new file mode 100644
index 00000000000..bd34d082b43
--- /dev/null
+++ b/sql/updates/world/master/2022_02_28_39_world_2020_10_20_01_world.sql
@@ -0,0 +1,62 @@
+-- Default menu
+UPDATE `creature_template` SET `gossip_menu_id` = 8025 WHERE `entry` = 19481;
+DELETE FROM `gossip_menu` WHERE `MenuID` = 8025 AND `TextID` = 9902;
+INSERT INTO `gossip_menu` (`MenuID`,`TextID`,`VerifiedBuild`) VALUES
+(8025,9902,14007);
+
+-- Old non-sniffed menus for Dalaran, new we'll send in script since there's only one NPC but two different menus
+DELETE FROM `gossip_menu` WHERE (`MenuID` = 21255 AND `TextID` = 14192) OR (`MenuID` = 21256 AND `TextID` = 14194);
+UPDATE `gossip_menu_option` SET `MenuID` = 10212, `ActionMenuID` = 10213 WHERE `MenuID` = 21255;
+UPDATE `gossip_menu_option` SET `MenuID` = 10213 WHERE `MenuID` = 21256;
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 14 AND `SourceGroup` = 21255;
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 15 AND `SourceGroup` IN (21255,10212);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
+(15,10212,0,0,0,17,0,1956,0,0,0,0,0,"","Group 0: Show Gossip Option 0 if achievement 'Higher Learning' is completed"),
+(15,10212,0,0,0,2,0,44738,1,1,1,0,0,"","Group 0: Show Gossip Option 0 if player does not have item 'Kirin Tor Familiar'");
+
+-- Old script for NPC in Dalaran
+DELETE FROM `smart_scripts` WHERE `entryorguid` = -98174 AND `source_type` = 0;
+
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 19481 AND `source_type` = 0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 1948100 AND `source_type` = 9;
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(19481,0,0,0,20,0,100,0,10176,0,0,0,0,80,1948100,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Archmage Vargoth - On Quest 'Ar'kelos the Guardian' Finished - Run Script"),
+(19481,0,1,0,64,0,100,0,0,0,0,0,0,98,10212,14192,0,0,0,0,7,0,0,0,0,0,0,0,0,"Archmage Vargoth - On Gossip Hello - Send Gossip"),
+(19481,0,2,3,62,0,100,0,10213,0,0,0,0,11,61457,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Archmage Vargoth - On Gossip Option 0 Selected - Cast 'Kirin Tor Familiar'"),
+(19481,0,3,0,61,0,100,0,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Archmage Vargoth - On Link - Close Gossip"),
+
+(1948100,9,0,0,0,0,100,0,0,0,0,0,0,1,0,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Archmage Vargoth - On Script - Say Line 0"),
+(1948100,9,1,0,0,0,100,0,0,0,0,0,0,83,3,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Archmage Vargoth - On Script - Remove NPC Flags Gossip & Questgiver"),
+(1948100,9,2,0,0,0,100,0,4000,4000,0,0,0,11,30416,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Archmage Vargoth - On Script - Cast 'Quest - Wood Cleanse Effect'"),
+(1948100,9,3,0,0,0,100,0,1000,1000,0,0,0,107,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Archmage Vargoth - On Script - Summon Group 0"),
+(1948100,9,4,0,0,0,100,0,4000,4000,0,0,0,11,34679,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Archmage Vargoth - On Script - Cast 'Archmage Vargoth's Ritual'"),
+(1948100,9,5,0,0,0,100,0,9000,9000,0,0,0,86,34725,0,11,19924,50,0,1,0,0,0,0,0,0,0,0,"Archmage Vargoth - On Script - Cross Cast 'Shadow Nova' (Invis Ritual Crystal)"),
+(1948100,9,6,0,0,0,100,0,1000,1000,0,0,0,11,13360,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Archmage Vargoth - On Script - Cast 'Knockdown'"),
+(1948100,9,7,0,0,0,100,0,0,0,0,0,0,17,64,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Archmage Vargoth - On Script - Set Emote State 64"),
+(1948100,9,8,0,0,0,100,0,4000,4000,0,0,0,1,1,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Archmage Vargoth - On Script - Say Line 1"),
+(1948100,9,9,0,0,0,100,0,4000,4000,0,0,0,17,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Archmage Vargoth - On Script - Set Emote State 0"),
+(1948100,9,10,0,0,0,100,0,2000,2000,0,0,0,1,2,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Archmage Vargoth - On Script - Say Line 2"),
+(1948100,9,11,0,0,0,100,0,0,0,0,0,0,82,3,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Archmage Vargoth - On Script - Add NPC Flags Gossip & Questgiver");
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 22 AND `SourceEntry` = 19481 AND `SourceId` = 0;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
+(22,2,19481,0,0,4,1,4395,0,0,0,0,0,"","Group 0: Execute SAI (Action 1) if creature is located in Dalaran");
+
+DELETE FROM `creature_text` WHERE `CreatureID` = 19481;
+INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES
+(19481,0,0,"I can't thank you enough for your help, $n. At long last, I will be free of this tower and Kael's damnable magic!",12,0,100,1,0,0,17524,0,"Archmage Vargoth"),
+(19481,1,0,"No! How could the ritual fail?",12,0,100,0,0,0,17526,0,"Archmage Vargoth"),
+(19481,2,0,"The curse remains intact. We'll have to find another way.",12,0,100,5,0,0,17535,0,"Archmage Vargoth");
+
+DELETE FROM `creature_summon_groups` WHERE `summonerId` = 19481 AND `summonerType` = 0;
+INSERT INTO `creature_summon_groups` (`summonerId`,`summonerType`,`groupId`,`entry`,`position_x`,`position_y`,`position_z`,`orientation`,`summonType`,`summonTime`,`Comment`) VALUES
+(19481,0,0,19916,2240.22,2234.18,136.190,0.71558,3,13000,"Archmage Vargoth - Group 0 - Archmage's Ritual Crystal"),
+(19481,0,0,19916,2236.69,2224.65,136.419,5.63741,3,13000,"Archmage Vargoth - Group 0 - Archmage's Ritual Crystal"),
+(19481,0,0,19924,2236.65,2224.67,136.415,5.21853,3,13000,"Archmage Vargoth - Group 0 - Invis Ritual Crystal"),
+(19481,0,0,19924,2248.51,2239.90,136.592,5.04400,3,13000,"Archmage Vargoth - Group 0 - Invis Ritual Crystal"),
+(19481,0,0,19924,2240.18,2234.19,136.186,0.10471,3,13000,"Archmage Vargoth - Group 0 - Invis Ritual Crystal"),
+(19481,0,0,19916,2248.53,2239.87,136.594,5.60250,3,13000,"Archmage Vargoth - Group 0 - Archmage's Ritual Crystal");
+
+UPDATE `creature_template` SET `speed_walk` = 1, `speed_run` = 1, `BaseAttackTime` = 2000, `RangeAttackTime` = 2000, `unit_flags` = 33555200 WHERE `entry` = 19916;
+UPDATE `creature_template` SET `speed_walk` = 1, `BaseAttackTime` = 2000, `RangeAttackTime` = 2000, `unit_flags` = 33555200 WHERE `entry` = 19924;