Core/Scripts Update boss Skadi the Ruthless (#19114)

(cherrypicked from 4536846d7d30508a046f394d1f561a2c3fdcf5f0)

1 files changed, 54 insertions, 0 deletions

diff --git a/sql/updates/world/master/2019_07_18_04_world_2017_02_12_00_world.sql b/sql/updates/world/master/2019_07_18_04_world_2017_02_12_00_world.sql
new file mode 100644
index 00000000000..7a86fc91e34
--- /dev/null
+++ b/sql/updates/world/master/2019_07_18_04_world_2017_02_12_00_world.sql
@@ -0,0 +1,54 @@
+SET @PATH := 2689300;
+
+DELETE FROM `waypoint_data` WHERE `id` IN(@PATH, @PATH+1, @PATH+2);
+DELETE FROM `script_spline_chain_meta` WHERE `entry`=26893;
+INSERT INTO `script_spline_chain_meta` (`entry`,`chainId`,`splineId`,`expectedDuration`,`msUntilNext`) VALUES
+(26893, 1, 0, 15064, 0),
+(26893, 2, 0, 3397, 0),
+(26893, 3, 0, 4472, 0),
+(26893, 4, 0, 23930, 0),
+(26893, 5, 0, 24026, 0);
+
+DELETE FROM `script_spline_chain_waypoints` WHERE `entry`=26893;
+INSERT INTO `script_spline_chain_waypoints` (`entry`,`chainId`,`splineId`,`wpId`,`x`,`y`,`z`) VALUES
+(26893, 1, 0, 0, 341.74110, -516.95450, 104.66950), -- INITIAL
+(26893, 1, 0, 1, 310.21650, -510.53020, 120.54870),
+(26893, 1, 0, 2, 300.86850, -520.32490, 133.36640),
+(26893, 1, 0, 3, 298.34470, -529.48180, 137.28310),
+(26893, 1, 0, 4, 309.09590, -540.31950, 134.97740),
+(26893, 1, 0, 5, 323.64150, -547.97150, 130.31060),
+(26893, 1, 0, 6, 357.07800, -549.15970, 116.31050),
+(26893, 1, 0, 7, 401.25730, -550.27680, 114.92160),
+(26893, 1, 0, 8, 464.50620, -555.94420, 114.44940),
+(26893, 1, 0, 9, 496.19200, -556.96280, 114.86610),
+(26893, 1, 0, 10, 523.20110, -548.99160, 114.86610),
+(26893, 2, 0, 0, 520.48270, -541.56330, 119.84160), -- BREACH RIGHT
+(26893, 2, 0, 1, 496.43400, -517.57800, 120.00000),
+(26893, 3, 0, 0, 520.48270, -541.56330, 119.84160), -- BREACH LEFT
+(26893, 3, 0, 1, 500.24300, -501.69300, 120.00000),
+(26893, 4, 0, 0, 496.43400, -517.57800, 120.00000), -- RIGHT
+(26893, 4, 0, 1, 453.12420, -517.17000, 120.02730),
+(26893, 4, 0, 2, 388.33120, -514.37680, 121.11930),
+(26893, 4, 0, 3, 340.27520, -512.09260, 122.31380),
+(26893, 4, 0, 4, 313.07560, -509.13800, 125.17500),
+(26893, 4, 0, 5, 296.69640, -522.67050, 133.70260),
+(26893, 4, 0, 6, 301.29570, -549.45830, 137.42490),
+(26893, 4, 0, 7, 335.07460, -552.12110, 119.84160),
+(26893, 4, 0, 8, 397.62370, -553.92030, 119.84160),
+(26893, 4, 0, 9, 459.63210, -558.00780, 119.84160),
+(26893, 4, 0, 10, 505.54580, -568.78150, 119.84160),
+(26893, 4, 0, 11, 518.09900, -560.84990, 119.84160),
+(26893, 4, 0, 12, 520.48270, -541.56330, 119.84160),
+(26893, 5, 0, 0, 500.24300, -501.69300, 120.00000), -- LEFT
+(26893, 5, 0, 1, 451.98240, -509.25080, 120.02730),
+(26893, 5, 0, 2, 399.26070, -510.07190, 121.11930),
+(26893, 5, 0, 3, 350.60990, -508.39010, 122.31380),
+(26893, 5, 0, 4, 325.82170, -506.77690, 125.17500),
+(26893, 5, 0, 5, 301.29410, -516.67060, 133.70260),
+(26893, 5, 0, 6, 301.29570, -549.45830, 137.42490),
+(26893, 5, 0, 7, 335.07460, -552.12110, 119.84160),
+(26893, 5, 0, 8, 397.62370, -553.92030, 119.84160),
+(26893, 5, 0, 9, 459.63210, -558.00780, 119.84160),
+(26893, 5, 0, 10, 505.54580, -568.78150, 119.84160),
+(26893, 5, 0, 11, 518.09900, -560.84990, 119.84160),
+(26893, 5, 0, 12, 520.48270, -541.56330, 119.84160);