DB/Creature: Complete the event at Icecrown Citadel entrance

Ref  #18713

(cherry picked from commit 705852c2a210ae435703aa28b099fb5de943b8ad)

1 files changed, 36 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_10_23_04_world_2018_08_30_01_world.sql b/sql/updates/world/master/2021_10_23_04_world_2018_08_30_01_world.sql
new file mode 100644
index 00000000000..f2c24ad5e96
--- /dev/null
+++ b/sql/updates/world/master/2021_10_23_04_world_2018_08_30_01_world.sql
@@ -0,0 +1,36 @@
+-- 
+UPDATE `smart_scripts` SET `event_param1`=180000, `event_param2`=180000, `event_param3`=180000, `event_param4`=180000 WHERE `entryorguid` IN (-111996, -112005) AND `source_type`=0 AND `id`=0;
+
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN(38505);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN(-112002,-111993,38505,38493) AND `source_type`=0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN(3850500,38505*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`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(-112002, 0, 0, 0, 60, 0, 100, 0, 60000, 90000, 60000, 90000, 80, 38505*100, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Knight of the Ebon Blade - On Update - Run Script'),
+(38505*100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 38505, 4, 120000, 0, 0, 0, 8, 0, 0, 0, 5898.320, 2041.114, 636.0415, 1.841691, 'Knight of the Ebon Blade - On Script - Summon Creature Knight of the Ebon Blade'),
+(-111993, 0, 0, 0, 60, 0, 100, 0, 60000, 90000, 60000, 90000, 80, 38505*100+1, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Cruasder - On Update - Run Script'),
+(38505*100+1, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 38493, 4, 120000, 0, 0, 0, 8, 0, 0, 0, 5837.231, 2179.012, 636.0412, 6.169237, 'Argent Cruasder - On Script - Summon Creature Argent Cruasder'),
+(38505, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 53, 0, 38505, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Knight of the Ebon Blade - On Just summoned - start watpoint'),
+(38505, 0, 1, 0, 40, 0, 100, 0, 9, 38505, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Knight of the Ebon Blade - On waypoint reached - despawn'),
+(38493, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 53, 0, 38493, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Cruasder - On Just summoned - start watpoint'),
+(38493, 0, 1, 0, 40, 0, 100, 0, 9, 38493, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Argent Cruasder - On waypoint reached - despawn');
+
+DELETE FROM `waypoints` WHERE `entry` IN (38493,38505);
+INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`point_comment`) VALUES
+(38493,1,5856.899, 2179.507, 636.041,""),
+(38493,2,5867.398, 2157.619, 636.041,""),
+(38493,3,5873.770, 2144.504, 636.041,""),
+(38493,4,5871.876, 2124.536, 636.041,""),
+(38493,5,5865.335, 2107.692, 635.977,""),
+(38493,6,5854.102, 2101.100, 636.034,""),
+(38493,7,5826.581, 2088.601, 636.064,""),
+(38493,8,5810.641, 2081.362, 636.064,""),
+(38493,9,5782.596, 2068.108, 636.064,""),
+(38505,1,5894.719, 2067.567, 636.041,""),
+(38505,2,5886.676, 2082.452, 636.041,""),
+(38505,3,5876.980, 2088.505, 636.041,""),
+(38505,4,5868.985, 2102.083, 636.041,""),
+(38505,5,5868.985, 2102.083, 636.041,""),
+(38505,6,5853.833, 2101.389, 636.034,""),
+(38505,7,5830.794, 2090.629, 636.063,""),
+(38505,8,5812.584, 2082.479, 636.063,""),
+(38505,9,5782.596, 2068.108, 636.064,"");