DB/Quest: Rework 'Rescuing Evanor' (11681)

(cherry picked from commit 4eafa57adb427841704b9b9b4ea44f0ad767fe95)

1 files changed, 241 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_03_05_34_world_2021_01_04_05_world.sql b/sql/updates/world/master/2022_03_05_34_world_2021_01_04_05_world.sql
new file mode 100644
index 00000000000..61bd94e2edf
--- /dev/null
+++ b/sql/updates/world/master/2022_03_05_34_world_2021_01_04_05_world.sql
@@ -0,0 +1,241 @@
+-- Pretty sure some parts are scripted differently, since there are multiple inlvolved creatures it's hard to say
+-- what exactly triggers certain events, are they asynchronous or not. Some timers seems to be wrong, even 0.5 sec
+-- delay significantly changes event
+-- There is area trigger 4883, purpose unk
+UPDATE `spell_target_position` SET `PositionX` = 3646.74, `PositionY` = 5893.2, `PositionZ` = 174.483, `VerifiedBuild` = 12340 WHERE `ID` = 46018;
+
+UPDATE `quest_template_addon` SET `SourceSpellID` = 0 WHERE `ID` = 11681;
+
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger` = -45992;
+INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES
+(-45992,45883,0,"Taxi - Amber Ledge to Beryl Point Platform - On Aura Removed - Target - Cast 'Amber Ledge to Beryl Point'");
+
+-- Warmage Anzim SAI
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 25356 AND `source_type` = 0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 2535600 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
+(25356,0,0,0,19,0,100,0,11681,0,0,0,0,80,2535600,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Warmage Anzim - On Quest 'Rescuing Evanor' Taken - Run Script"),
+
+(2535600,9,0,0,0,0,100,0,0,0,0,0,0,11,45992,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Warmage Anzim - On Script - Cast 'Taxi - Amber Ledge to Beryl Point Platform'"),
+(2535600,9,1,0,0,0,100,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Warmage Anzim - On Script - Say Line 0"),
+(2535600,9,2,0,0,0,100,0,1000,1000,0,0,0,45,1,1,0,0,0,0,19,27888,50,0,0,0,0,0,0,"Warmage Anzim - On Script - Set Data 1 1 (Warmage Archus)"),
+(2535600,9,3,0,0,0,100,0,0,0,0,0,0,45,1,1,0,0,0,0,19,25727,50,0,0,0,0,0,0,"Warmage Anzim - On Script - Set Data 1 1 (Warmage Moran)"),
+(2535600,9,4,0,0,0,100,0,0,0,0,0,0,45,1,1,0,0,0,0,19,25732,50,0,0,0,0,0,0,"Warmage Anzim - On Script - Set Data 1 1 (Warmage Preston)"),
+(2535600,9,5,0,0,0,100,0,0,0,0,0,0,45,1,1,0,0,0,0,19,25733,50,0,0,0,0,0,0,"Warmage Anzim - On Script - Set Data 1 1 (Warmage Austin)");
+
+-- Taking Wing Timer Bunny and Anzim Controller Bunny should be used instead
+-- For some reason Taking Wing Timer Bunny wasn't spawned at all in sniff
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 22 AND `SourceEntry` = 25356 AND `SourceId` = 0;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
+(22,1,25356,0,0,29,0,27888,50,0,0,0,0,"","Group 0: Execute SAI (Action 0) if alive creature 'Warmage Archus' is within 50 yards"),
+(22,1,25356,0,0,29,0,25727,50,0,0,0,0,"","Group 0: Execute SAI (Action 0) if alive creature 'Warmage Moran' is within 50 yards"),
+(22,1,25356,0,0,29,0,25732,50,0,0,0,0,"","Group 0: Execute SAI (Action 0) if alive creature 'Warmage Preston' is within 50 yards"),
+(22,1,25356,0,0,29,0,25733,50,0,0,0,0,"","Group 0: Execute SAI (Action 0) if alive creature 'Warmage Austin' is within 50 yards");
+
+-- Warmage Archus SAI
+SET @ID := 27888;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = @ID AND `source_type` = 0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` BETWEEN @ID*100+0 AND @ID*100+1 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
+(@ID,0,0,1,38,0,100,0,1,1,0,0,0,53,1,27888,0,0,0,0,1,0,0,0,0,0,0,0,0,"Warmage Archus - On Data Set 1 1 - Start Waypoint"),
+(@ID,0,1,0,61,0,100,0,0,0,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Warmage Archus - On Data Set 1 1 - Set Active On"),
+(@ID,0,2,0,40,0,100,0,12,0,0,0,0,80,@ID*100+0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Warmage Archus - On Waypoint 12 Reached - Run Script"),
+(@ID,0,3,0,40,0,100,0,14,0,0,0,0,80,@ID*100+1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Warmage Archus - On Waypoint 14 Reached - Run Script"),
+
+-- This one arrives first, waits arrival of other and forces them to continue movement
+(@ID*100+0,9,0,0,0,0,100,0,7000,7000,0,0,0,45,1,2,0,0,0,0,19,25727,0,0,0,0,0,0,0,"Warmage Archus - On Script - Set Data 1 2 (Warmage Moran)"),
+(@ID*100+0,9,1,0,0,0,100,0,0,0,0,0,0,45,1,2,0,0,0,0,19,25732,0,0,0,0,0,0,0,"Warmage Archus - On Script - Set Data 1 2 (Warmage Preston)"),
+(@ID*100+0,9,2,0,0,0,100,0,0,0,0,0,0,45,1,2,0,0,0,0,19,25733,0,0,0,0,0,0,0,"Warmage Archus - On Script - Set Data 1 2 (Warmage Austin)"),
+
+(@ID*100+1,9,0,0,0,0,100,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Warmage Archus - On Script - Say Line 0"),
+(@ID*100+1,9,1,0,0,0,100,0,0,0,0,0,0,11,45913,0,0,0,0,0,19,25724,0,0,0,0,0,0,0,"Warmage Archus - On Script - Cast 'Warmage Drake Fireball'"),
+(@ID*100+1,9,2,0,0,0,100,0,6000,6000,0,0,0,11,45913,0,0,0,0,0,19,25724,0,0,0,0,0,0,0,"Warmage Archus - On Script - Cast 'Warmage Drake Fireball'"),
+(@ID*100+1,9,3,0,0,0,100,0,6000,6000,0,0,0,11,45913,0,0,0,0,0,19,25724,0,0,0,0,0,0,0,"Warmage Archus - On Script - Cast 'Warmage Drake Fireball'");
+
+DELETE FROM `waypoints` WHERE `entry` = 27888;
+INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`point_comment`) VALUES
+(27888,1,3455.625,5893.702,147.46953,0,0,"Warmage Archus"),
+(27888,2,3444.9219,5897.1685,149.60324,0,0,"Warmage Archus"),
+(27888,3,3429.8596,5901.5566,152.02946,0,0,"Warmage Archus"),
+(27888,4,3404.945,5908.6284,156.36287,0,0,"Warmage Archus"),
+(27888,5,3367.2473,5916.6626,161.72395,0,0,"Warmage Archus"),
+(27888,6,3340.2002,5924.8774,164.69623,0,0,"Warmage Archus"),
+(27888,7,3313.7268,5936.971,164.72398,0,0,"Warmage Archus"),
+(27888,8,3274.5618,5960.1597,163.11285,0,0,"Warmage Archus"),
+(27888,9,3248.3792,5984.673,155.39067,0,0,"Warmage Archus"),
+(27888,10,3220.3267,6007.317,146.02954,0,0,"Warmage Archus"),
+(27888,11,3200.061,6032.292,137.2518,0,0,"Warmage Archus"),
+(27888,12,3199.989,6061.957,123.27971,0,7000,"Warmage Archus"), --
+(27888,13,3200.0925,6071.211,141.77905,0,0,"Warmage Archus"),
+(27888,14,3200.9895,6074.8984,144.97356,0,13000,"Warmage Archus"), --
+(27888,15,3209.1426,6061.523,141.88358,0,0,"Warmage Archus"),
+(27888,16,3222.4565,6044.5776,176.49445,0,0,"Warmage Archus"),
+(27888,17,3235.9856,6025.278,198.77245,0,0,"Warmage Archus");
+
+DELETE FROM `creature_text` WHERE `CreatureID` = 27888;
+INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES
+(27888,0,0,"For Dalaran! Attack!",14,0,100,0,0,0,24890,0,"Warmage Archus");
+
+-- Warmage Preston SAI
+SET @ID := 25732;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = @ID AND `source_type` = 0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = @ID*100+0 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
+(@ID,0,0,1,38,0,100,0,1,1,0,0,0,53,1,25732,0,0,0,0,1,0,0,0,0,0,0,0,0,"Warmage Preston - On Data Set 1 1 - Start Waypoint"),
+(@ID,0,1,0,61,0,100,0,0,0,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Warmage Preston - On Data Set 1 1 - Set Active On"),
+(@ID,0,2,0,38,0,100,0,1,2,0,0,0,65,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Warmage Preston - On Data Set 1 2 - Resume Waypoint"),
+(@ID,0,3,0,40,0,100,0,15,0,0,0,0,80,@ID*100+0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Warmage Preston - On Waypoint 15 Reached - Run Script"),
+(@ID,0,4,0,40,0,100,0,13,0,0,0,0,54,15000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Warmage Preston - On Waypoint 13 Reached - Pause Waypoint"),
+
+(@ID*100+0,9,0,0,0,0,100,0,5000,5000,0,0,0,11,45913,0,0,0,0,0,19,25724,0,0,0,0,0,0,0,"Warmage Preston - On Script - Cast 'Warmage Drake Fireball'"),
+(@ID*100+0,9,1,0,0,0,100,0,6000,6000,0,0,0,11,45913,0,0,0,0,0,19,25724,0,0,0,0,0,0,0,"Warmage Preston - On Script - Cast 'Warmage Drake Fireball'");
+
+DELETE FROM `waypoints` WHERE `entry` = 25732;
+INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`point_comment`) VALUES
+(25732,1,3442.4233,5890.586,151.80292,0,0,"Warmage Preston"),
+(25732,2,3428.3008,5898.2583,152.02946,0,0,"Warmage Preston"),
+(25732,3,3404.945,5908.6284,156.36287,0,0,"Warmage Preston"),
+(25732,4,3367.2473,5916.6626,161.72395,0,0,"Warmage Preston"),
+(25732,5,3340.2002,5924.8774,164.69623,0,0,"Warmage Preston"),
+(25732,6,3313.7268,5936.971,164.72398,0,0,"Warmage Preston"),
+(25732,7,3274.5618,5960.1597,163.11285,0,0,"Warmage Preston"),
+(25732,8,3248.5293,5977.7803,155.39067,0,0,"Warmage Preston"),
+(25732,9,3245.32,6007.739,146.02954,0,0,"Warmage Preston"),
+(25732,10,3260.1267,6034.221,131.44637,0,0,"Warmage Preston"),
+(25732,11,3256.6243,6055.6704,131.44637,0,0,"Warmage Preston"),
+(25732,12,3247.428,6068.3037,130.3353,0,0,"Warmage Preston"),
+(25732,13,3232.0784,6079.069,124.50193,0,0,"Warmage Preston"), --
+(25732,14,3231.549,6079.4277,132.86238,0,0,"Warmage Preston"),
+(25732,15,3224.7488,6083.0376,147.5568,0,14000,"Warmage Preston"), --
+(25732,16,3230.0708,6064.604,141.88358,0,0,"Warmage Preston"),
+(25732,17,3235.9856,6025.278,235.91063,0,0,"Warmage Preston"),
+(25732,18,3250.0664,6003.68,299.3278,0,0,"Warmage Preston"),
+(25732,19,3277.5513,5971.299,338.18866,0,0,"Warmage Preston");
+
+-- Warmage Austin SAI
+SET @ID := 25733;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = @ID AND `source_type` = 0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = @ID*100+0 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
+(@ID,0,0,1,38,0,100,0,1,1,0,0,0,53,1,25733,0,0,0,0,1,0,0,0,0,0,0,0,0,"Warmage Austin - On Data Set 1 1 - Start Waypoint"),
+(@ID,0,1,0,61,0,100,0,0,0,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Warmage Austin - On Data Set 1 1 - Set Active On"),
+(@ID,0,2,0,38,0,100,0,1,2,0,0,0,65,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Warmage Austin - On Data Set 1 2 - Resume Waypoint"),
+(@ID,0,3,0,40,0,100,0,18,0,0,0,0,80,@ID*100+0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Warmage Austin - On Waypoint 18 Reached - Run Script"),
+(@ID,0,4,0,40,0,100,0,16,0,0,0,0,54,15000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Warmage Austin - On Waypoint 13 Reached - Pause Waypoint"),
+
+(@ID*100+0,9,0,0,0,0,100,0,3000,3000,0,0,0,11,45913,0,0,0,0,0,19,25724,0,0,0,0,0,0,0,"Warmage Austin - On Script - Cast 'Warmage Drake Fireball'"),
+(@ID*100+0,9,1,0,0,0,100,0,6000,6000,0,0,0,11,45913,0,0,0,0,0,19,25724,0,0,0,0,0,0,0,"Warmage Austin - On Script - Cast 'Warmage Drake Fireball'");
+
+DELETE FROM `waypoints` WHERE `entry` = 25733;
+INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`point_comment`) VALUES
+(25733,1,3423.0476,5891.1543,151.80273,0,0,"Warmage Austin"),
+(25733,2,3414.578,5894.0923,149.60324,0,0,"Warmage Austin"),
+(25733,3,3399.283,5899.8457,152.02946,0,0,"Warmage Austin"),
+(25733,4,3383.5579,5907.456,156.36287,0,0,"Warmage Austin"),
+(25733,5,3363.4604,5915.892,161.72395,0,0,"Warmage Austin"),
+(25733,6,3340.2002,5924.8774,164.69623,0,0,"Warmage Austin"),
+(25733,7,3313.7268,5936.971,164.72398,0,0,"Warmage Austin"),
+(25733,8,3274.5618,5960.1597,163.11285,0,0,"Warmage Austin"),
+(25733,9,3248.3792,5984.673,155.39067,0,0,"Warmage Austin"),
+(25733,10,3242.2053,6019.475,146.02954,0,0,"Warmage Austin"),
+(25733,11,3258.1528,6062.04,137.2518,0,0,"Warmage Austin"),
+(25733,12,3268.7927,6084.862,131.44637,0,0,"Warmage Austin"),
+(25733,13,3266.5671,6115.484,131.44637,0,0,"Warmage Austin"),
+(25733,14,3249.3186,6131.7163,131.44637,0,0,"Warmage Austin"),
+(25733,15,3230.5322,6123.678,128.8631,0,0,"Warmage Austin"),
+(25733,16,3225.4934,6115.8145,127.02973,0,0,"Warmage Austin"), --
+(25733,17,3225.812,6111.0366,143.61238,0,0,"Warmage Austin"),
+(25733,18,3224.3362,6105.71,146.77905,0,13000,"Warmage Austin"), --
+(25733,19,3244.6826,6099.2446,133.1058,0,0,"Warmage Austin"),
+(25733,20,3247.6614,6067.4385,179.46667,0,0,"Warmage Austin"),
+(25733,21,3245.7947,6032.932,214.77235,0,0,"Warmage Austin"),
+(25733,22,3259.2083,5997.6973,236.60551,0,0,"Warmage Austin");
+
+-- Warmage Moran SAI
+SET @ID := 25727;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = @ID AND `source_type` = 0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = @ID*100+0 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
+(@ID,0,0,1,38,0,100,0,1,1,0,0,0,53,1,25727,0,0,0,0,1,0,0,0,0,0,0,0,0,"Warmage Moran - On Data Set 1 1 - Start Waypoint"),
+(@ID,0,1,0,61,0,100,0,0,0,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Warmage Moran - On Data Set 1 1 - Set Active On"),
+(@ID,0,2,0,38,0,100,0,1,2,0,0,0,65,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Warmage Moran - On Data Set 1 2 - Resume Waypoint"),
+(@ID,0,3,0,40,0,100,0,18,0,0,0,0,80,@ID*100+0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Warmage Moran - On Waypoint 18 Reached - Run Script"),
+(@ID,0,4,0,40,0,100,0,16,0,0,0,0,54,15000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Warmage Moran - On Waypoint 13 Reached - Pause Waypoint"),
+
+(@ID*100+0,9,0,0,0,0,100,0,2000,2000,0,0,0,11,45913,0,0,0,0,0,19,25724,0,0,0,0,0,0,0,"Warmage Moran - On Script - Cast 'Warmage Drake Fireball'"),
+(@ID*100+0,9,1,0,0,0,100,0,6000,6000,0,0,0,11,45913,0,0,0,0,0,19,25724,0,0,0,0,0,0,0,"Warmage Moran - On Script - Cast 'Warmage Drake Fireball'");
+
+DELETE FROM `waypoints` WHERE `entry` = 25727;
+INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`point_comment`) VALUES
+(25727,1,3432.6145,5915.464,147.46953,0,0,"Warmage Moran"),
+(25727,2,3422.9866,5912.3257,149.60324,0,0,"Warmage Moran"),
+(25727,3,3410.0647,5909.5728,152.02946,0,0,"Warmage Moran"),
+(25727,4,3393.3308,5909.92,156.36287,0,0,"Warmage Moran"),
+(25727,5,3367.2473,5916.6626,161.72395,0,0,"Warmage Moran"),
+(25727,6,3340.2002,5924.8774,164.69623,0,0,"Warmage Moran"),
+(25727,7,3313.7268,5936.971,164.72398,0,0,"Warmage Moran"),
+(25727,8,3274.5618,5960.1597,163.11285,0,0,"Warmage Moran"),
+(25727,9,3248.3792,5984.673,155.39067,0,0,"Warmage Moran"),
+(25727,10,3222.7993,6007.353,146.02954,0,0,"Warmage Moran"),
+(25727,11,3190.0996,6031.6606,134.91856,0,0,"Warmage Moran"),
+(25727,12,3165.8325,6043.715,131.44637,0,0,"Warmage Moran"),
+(25727,13,3145.7979,6060.3247,131.44637,0,0,"Warmage Moran"),
+(25727,14,3138.7566,6079.489,131.44637,0,0,"Warmage Moran"),
+(25727,15,3156.847,6108.7153,131.44637,0,0,"Warmage Moran"),
+(25727,16,3183.6033,6109.2544,126.83527,0,0,"Warmage Moran"), --
+(25727,17,3191.0652,6104.512,132.86238,0,0,"Warmage Moran"),
+(25727,18,3195.6409,6102.6733,147.5568,0,13000,"Warmage Moran"), --
+(25727,19,3178.9836,6067.5054,141.88358,0,0,"Warmage Moran"),
+(25727,20,3203.0337,6040.6235,207.30002,0,0,"Warmage Moran"),
+(25727,21,3222.4402,6012.923,253.57777,0,0,"Warmage Moran"),
+(25727,22,3240.0286,5986.9424,289.54984,0,0,"Warmage Moran");
+
+-- Ascended Mage Hunter SAI
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 25724 AND `source_type` = 0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 2572400 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
+(25724,0,0,0,11,0,100,0,0,0,0,0,0,8,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ascended Mage Hunter - On Respawn - Set Reactstate Passive"),
+(25724,0,1,0,1,0,100,1,1000,1000,0,0,0,11,45940,0,0,0,0,0,19,25594,10,0,0,0,0,0,0,"Ascended Mage Hunter - Out of Combat - Cast 'Evanor's Prison Chains' (No Repeat)"),
+(25724,0,2,0,8,0,100,0,45913,0,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ascended Mage Hunter - On Spellhit 'Warmage Drake Fireball' - Set Active On"),
+(25724,0,3,0,8,0,100,0,45913,0,0,0,0,92,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ascended Mage Hunter - On Spellhit 'Warmage Drake Fireball' - Interrupt Spell"),
+(25724,0,4,0,8,0,100,0,45913,0,0,0,0,63,1,1,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ascended Mage Hunter - On Spellhit 'Warmage Drake Fireball' - Set Counter 1 1"),
+(25724,0,5,0,77,0,100,0,1,1,0,0,0,11,42726,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ascended Mage Hunter - On Counter Set 1 1 - Cast 'Cosmetic - Immolation (Whole Body)'"),
+(25724,0,6,0,77,0,100,0,1,1,0,0,0,89,5,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ascended Mage Hunter - On Counter Set 1 1 - Start Random Movement"),
+(25724,0,7,0,77,0,100,0,1,2,0,0,0,11,29266,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ascended Mage Hunter - On Counter Set 1 2 - Cast 'Permanent Feign Death'"),
+(25724,0,8,0,77,0,100,0,1,2,0,0,0,89,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ascended Mage Hunter - On Counter Set 1 2 - Stop Random Movement"),
+(25724,0,9,0,77,0,100,0,1,2,0,0,0,63,1,1,0,0,0,0,19,24771,0,0,0,0,0,0,0,"Ascended Mage Hunter - On Counter Set 1 2 - Set Counter 1 1 (Coldarra Invisman)"),
+-- Guessed, otherwise we have to reset counter, remove all auras and force creature to cast channeling spell again
+(25724,0,10,0,77,0,100,0,1,2,0,0,0,41,25000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Ascended Mage Hunter - On Counter Set 1 2 - Delayed Despawn");
+
+-- Coldarra Invisman SAI
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 24771 AND `source_type` = 0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 2477100 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
+(24771,0,0,0,77,0,100,0,1,4,0,0,0,80,2477100,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Coldarra Invisman - On Counter Set 1 4 - Run Script"),
+
+(2477100,9,0,0,0,0,100,0,3000,3000,0,0,0,9,0,0,0,0,0,0,20,187884,20,0,0,0,0,0,0,"Coldarra Invisman - On Script - Activate Closest Gameobject 'Evanor's Prison'"),
+(2477100,9,1,0,0,0,100,0,5000,5000,0,0,0,11,46013,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Coldarra Invisman - On Script - Cast 'Summon Lady Evanor'"),
+(2477100,9,2,0,0,0,100,0,1000,1000,0,0,0,41,0,0,0,0,0,0,19,27888,250,0,0,0,0,0,0,"Coldarra Invisman - On Script - Despawn Instant (Warmage Archus)"),
+(2477100,9,3,0,0,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,19,25727,250,0,0,0,0,0,0,"Coldarra Invisman - On Script - Despawn Instant (Warmage Moran)"),
+(2477100,9,4,0,0,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,19,25732,250,0,0,0,0,0,0,"Coldarra Invisman - On Script - Despawn Instant (Warmage Preston)"),
+(2477100,9,5,0,0,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,19,25733,250,0,0,0,0,0,0,"Coldarra Invisman - On Script - Despawn Instant (Warmage Austin)"),
+(2477100,9,6,0,0,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Coldarra Invisman - On Script - Despawn Instant");
+
+-- Archmage Evanor SAI
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 25784 AND `source_type` = 0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 2578400 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
+(25784,0,0,0,54,0,100,0,0,0,0,0,0,80,2578400,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Archmage Evanor - On Just Summoned - Run Script"),
+
+(2578400,9,0,0,0,0,100,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Archmage Evanor - On Script - Say Line 0"),
+(2578400,9,1,0,0,0,100,0,3000,3000,0,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Archmage Evanor - On Script - Say Line 1"),
+(2578400,9,2,0,0,0,100,0,0,0,0,0,0,11,46018,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Archmage Evanor - On Script - Cast 'Teleport'"),
+(2578400,9,3,0,0,0,100,0,8000,8000,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Archmage Evanor - On Script - Despawn Instant");
+
+-- Respawn time
+-- Coldarra Invisman, sniffed (respawned before player was teleported)
+UPDATE `creature` SET `spawntimesecs` = 15 WHERE `guid` = 114368 AND `id` = 24771;
+-- Warmages, guessed, should be less than 40 sec (sniff)
+UPDATE `creature` SET `spawntimesecs` = 15 WHERE `id` IN (27888,25727,25732,25733);
+-- Ascended Mage Hunter, guessed
+UPDATE `creature` SET `spawntimesecs` = 15 WHERE `id` = 25724;