DB/Creature: Murkblood Invader

(cherry picked from commit 60d625ea838d5c9541b5eac050e8138ff7e936ef)

1 files changed, 149 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_11_24_43_world_2019_03_26_02_world.sql b/sql/updates/world/master/2021_11_24_43_world_2019_03_26_02_world.sql
new file mode 100644
index 00000000000..166803e6947
--- /dev/null
+++ b/sql/updates/world/master/2021_11_24_43_world_2019_03_26_02_world.sql
@@ -0,0 +1,149 @@
+-- 
+UPDATE `creature` SET `position_x` = -2109.18, `position_y` =8509.76, `position_z` =23.3588, `orientation` =1.79943 WHERE `guid` =65508;
+UPDATE `creature` SET `position_x` = -2108.68, `position_y` =8507.86, `position_z` =23.4079, `orientation` =1.80518, `SpawnDist` = 0, `MovementType` = 0 WHERE `guid` =65507;
+UPDATE `creature` SET `position_x` = -2108.21, `position_y` =8505.88, `position_z` =23.5648, `orientation` =1.80518, `SpawnDist` = 0, `MovementType` = 0 WHERE `guid` =65506;
+UPDATE `creature` SET `position_x` = -972.506, `position_y` =8193.48, `position_z` =16.2088, `orientation` =4.66057 WHERE `guid` =65511;
+UPDATE `creature` SET `position_x` = -972.427, `position_y` =8200.72, `position_z` =16.5906, `orientation` =4.7178, `SpawnDist` = 0, `MovementType` = 0 WHERE `guid` =65510;
+UPDATE `creature` SET `position_x` = -972.495, `position_y` =8210.52, `position_z` =17.338,  `orientation` =4.7159, `SpawnDist` = 0, `MovementType` = 0 WHERE `guid` =65509;
+UPDATE `creature_addon` SET `path_id`=0 WHERE `guid` IN (65507,65506,65510,65509);
+DELETE FROM `waypoint_data` WHERE `id` IN (655070,655060,655100,655090,655080,655110);
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `action_chance`) VALUES
+(655080, 1, -2114, 8540.97, 21.6609, 1.69045, 0, 100),
+(655080, 2, -2116.74, 8563.22, 18.8982, 1.81612, 0, 100),
+(655080, 3, -2121.28, 8577.2, 18.2144, 1.6237, 0, 100),
+(655080, 4, -2123.59, 8600.54, 17.0157, 1.37656, 0, 100),
+(655080, 5, -2121.05, 8610.07, 17.2115, 1.03335, 0, 100),
+(655080, 6, -2095.63, 8641.19, 17.3336, 0.893545, 0, 100),
+(655080, 7, -2072.63, 8674.07, 18.2208, 0.712118, 0, 100),
+(655080, 8, -2053.18, 8692.6, 18.0131, 0.727826, 0, 100),
+(655080, 9, -2032.84, 8708.34, 18.4604, 0.540901, 0, 100),
+(655080, 10, -2014.81, 8717.41, 19.3475, 0.210248, 0, 100),
+(655080, 11, -1991.24, 8719, 20.2555, 6.24211, 0, 100),
+(655080, 12, -1961.48, 8717.67, 22.1747, 0.193754, 0, 100),
+(655080, 13, -1922.69, 8726.31, 24.1223, 0.103434, 5000, 100),
+(655080, 14, -1957.51, 8719.2, 22.4158, 3.17984, 0, 100),
+(655080, 15, -1986.21, 8717.92, 20.5196, 3.11465, 0, 100),
+(655080, 16, -2010.96, 8719.18, 19.5189, 3.48065, 0, 100),
+(655080, 17, -2026.05, 8713.06, 18.6949, 3.61416, 0, 100),
+(655080, 18, -2052.3, 8693.82, 17.933, 3.80266, 0, 100),
+(655080, 19, -2067.75, 8681.47, 18.8638, 3.94796, 0, 100),
+(655080, 20, -2088.98, 8651.36, 17.4626, 4.09325, 0, 100),
+(655080, 21, -2109.52, 8625.68, 17.0178, 4.05006, 0, 100),
+(655080, 22, -2120.54, 8608.14, 17.1577, 4.6336, 0, 100),
+(655080, 23, -2123.62, 8588.89, 17.3189, 4.92498, 0, 100),
+(655080, 24, -2116.93, 8560.67, 19.0643, 4.90928, 0, 100),
+(655080, 25, -2114.2, 8544.9, 21.2733, 4.78362, 0, 100),
+(655080, 26, -2110.35, 8517.2, 23.1965, 4.9132, 0, 100),
+(655080, 27, -2107, 8490.6, 23.6432, 4.76398, 0, 100),
+(655080, 28, -2106.07, 8465.5, 22.0591, 4.99567, 0, 100),
+(655080, 29, -2097.13, 8448.45, 21.7315, 5.25878, 0, 100),
+(655080, 30, -2086.01, 8430.91, 21.2486, 5.03494, 0, 100),
+(655080, 31, -2075.78, 8405.72, 19.0172, 5.25877, 0, 100),
+(655080, 32, -2047.59, 8359.41, 17.0068, 5.23129, 0, 100),
+(655080, 33, -2041.92, 8339.47, 15.0923, 4.97996, 0, 100),
+(655080, 34, -2036.57, 8328.36, 13.879, 5.37423, 0, 100),
+(655080, 35, -2012.22, 8299.83, 10.9893, 5.44099, 0, 100),
+(655080, 36, -1991.31, 8275.25, 9.14579, 5.33104, 0, 100),
+(655080, 37, -1984.31, 8262.11, 6.92359, 5.01688, 0, 100),
+(655080, 38, -1982.4, 8250.58, 4.59313, 4.77733, 0, 100),
+(655080, 39, -1986.4, 8205.41, 0.977083, 4.3006, 0, 100),
+(655080, 40, -1995.71, 8191.48, -0.0648872, 4.06499, 0, 100),
+(655080, 41, -2017.96, 8166.87, 0.230461, 4.03357, 0, 100),
+(655080, 42, -2043.02, 8136.3, 2.41803, 4.00216, 0, 100),
+(655080, 43, -2060.48, 8116.36, 2.61751, 3.97859, 0, 100),
+(655080, 44, -2073.88, 8100.45, 2.68867, 4.05713, 0, 100),
+(655080, 45, -2086.91, 8079.41, 2.55276, 4.17494, 0, 100),
+(655080, 46, -2101.96, 8055.87, 2.2554, 4.05714, 0, 100),
+(655080, 47, -2112.85, 8040.26, 1.89121, 4.12782, 0, 100),
+(655080, 48, -2122.31, 8022.82, 1.44427, 4.30453, 0, 100),
+(655080, 49, -2127.07, 8002.84, 1.78789, 4.56371, 0, 100),
+(655080, 50, -2132.32, 7981.63, -1.49405, 4.41056, 0, 100),
+(655080, 51, -2139.69, 7957.81, -4.22691, 4.58335, 0, 100),
+(655080, 52, -2142.67, 7923.39, -7.45212, 4.64618, 0, 100),
+(655080, 53, -2146.24, 7887.79, -10.5239, 4.59906, 0, 100),
+(655080, 54, -2150.9, 7850.28, -11.8882, 4.69723, 5000, 100),
+(655080, 55, -2146.32, 7888.51, -10.4643, 1.45353, 0, 100),
+(655080, 56, -2142.38, 7919.59, -7.73704, 1.46924, 0, 100),
+(655080, 57, -2139.8, 7957.17, -4.32855, 1.4928, 0, 100),
+(655080, 58, -2134.51, 7980.34, -1.89184, 1.30431, 0, 100),
+(655080, 59, -2125.9, 8010.97, 0.446152, 1.33965, 0, 100),
+(655080, 60, -2118.5, 8030.54, 1.77208, 1.09225, 0, 100),
+(655080, 61, -2102.07, 8056.03, 2.23708, 0.98622, 0, 100),
+(655080, 62, -2085.48, 8082.49, 2.62174, 1.02549, 0, 100),
+(655080, 63, -2066.38, 8109.69, 2.4755, 0.931242, 0, 100),
+(655080, 64, -2048.25, 8130.69, 2.54083, 0.864484, 0, 100),
+(655080, 65, -2020.25, 8164.08, 0.282843, 0.899827, 0, 100),
+(655080, 66, -1997.74, 8189.36, -0.113347, 0.821287, 0, 100),
+(655080, 67, -1986.3, 8206.65, 0.936384, 1.31609, 0, 100),
+(655080, 68, -1982.24, 8239.88, 4.10747, 1.50458, 0, 100),
+(655080, 69, -1983.01, 8258.15, 6.16102, 1.80303, 0, 100),
+(655080, 70, -1989.82, 8272.75, 8.79162, 2.26642, 0, 100),
+(655080, 71, -2006.22, 8292.39, 10.7762, 2.26642, 0, 100),
+(655080, 72, -2023.96, 8313.5, 11.8595, 2.27035, 0, 100),
+(655080, 73, -2038.11, 8331.37, 14.2917, 2.07007, 0, 100),
+(655080, 84, -2046.88, 8357.56, 16.9689, 1.9719, 0, 100),
+(655080, 85, -2062.12, 8383.65, 17.8571, 2.11327, 0, 100),
+(655080, 86, -2078.21, 8410.31, 19.5278, 2.06222, 0, 100),
+(655080, 87, -2087.42, 8433.05, 21.2959, 2.07007, 0, 100),
+(655080, 88, -2103.29, 8458.69, 21.6851, 1.91692, 0, 100),
+(655080, 89, -2106.71, 8467.22, 22.089, 1.76376, 0, 100),
+(655080, 90, -2108.85, 8510.73, 23.4202, 1.7402, 0, 100),
+(655110, 1, -969.258, 8173.74, 14.519, 5.02496, 0, 100),
+(655110, 2, -964.978, 8165.19, 14.0309, 5.17811, 0, 100),
+(655110, 3, -955.831, 8146.86, 8.18516, 5.18203, 0, 100),
+(655110, 4, -948.537, 8132.72, 9.17469, 5.18989, 0, 100),
+(655110, 5, -940.834, 8117.29, 16.0521, 5.18989, 0, 100),
+(655110, 6, -927.489, 8089.55, 20.0447, 5.0014, 0, 100),
+(655110, 7, -925.78, 8062.36, 22.5056, 4.58907, 0, 100),
+(655110, 8, -940.867, 8041.1, 24.9053, 4.03144, 0, 100),
+(655110, 9, -955.193, 8021.02, 27.2015, 3.98039, 0, 100),
+(655110, 10, -982.122, 7998.03, 24.4603, 3.71021, 0, 100),
+(655110, 11, -1016.23, 7973.55, 23.1907, 3.78875, 0, 100),
+(655110, 12, -1049.58, 7948.08, 21.2606, 3.75341, 0, 100),
+(655110, 13, -1084.05, 7924.9, 18.7175, 3.77304, 0, 100),
+(655110, 14, -1105.74, 7901.69, 16.006, 4.1304, 0, 100),
+(655110, 15, -1119.9, 7877.54, 15.7645, 4.19323, 0, 100),
+(655110, 16, -1135.73, 7850.31, 15.0149, 4.1736, 0, 100),
+(655110, 17, -1153.12, 7818.84, 13.4431, 4.1736, 0, 100),
+(655110, 18, -1167.18, 7796.36, 11.4752, 4.14611, 0, 100),
+(655110, 19, -1178.13, 7779.59, 12.1305, 4.20894, 0, 100),
+(655110, 20, -1183.29, 7766.83, 11.9431, 4.3935, 0, 100),
+(655110, 21, -1190.21, 7746.34, 11.6888, 4.25606, 0, 100),
+(655110, 22, -1200.45, 7731.6, 11.2401, 4.00867, 0, 100),
+(655110, 23, -1236.8, 7686.81, 9.68634, 3.97725, 0, 100),
+(655110, 24, -1211.65, 7718.21, 10.4192, 0.914195, 0, 100),
+(655110, 25, -1192.15, 7741.8, 11.6894, 1.03986, 0, 100),
+(655110, 26, -1185.76, 7755.28, 11.8804, 1.25192, 0, 100),
+(655110, 27, -1176.96, 7780.66, 12.218, 0.984881, 0, 100),
+(655110, 28, -1167.24, 7795.77, 11.4395, 1.03201, 0, 100),
+(655110, 29, -1153.44, 7817.9, 13.0679, 1.01237, 0, 100),
+(655110, 30, -1134.84, 7851.6, 15.0348, 1.07128, 0, 100),
+(655110, 31, -1115.03, 7884.6, 15.8627, 1.02808, 0, 100),
+(655110, 32, -1099.92, 7908.16, 16.5578, 0.977027, 0, 100),
+(655110, 33, -1085.16, 7924, 18.5925, 0.7257, 0, 100),
+(655110, 34, -1069.2, 7936.06, 19.9505, 0.596894, 0, 100),
+(655110, 35, -1046.46, 7950.2, 21.402, 0.577259, 0, 100),
+(655110, 36, -1021.17, 7968.96, 22.9191, 0.655799, 0, 100),
+(655110, 37, -978.595, 8000.42, 24.546, 0.644018, 0, 100),
+(655110, 38, -960.673, 8015.12, 26.537, 0.714704, 0, 100),
+(655110, 39, -953.002, 8023.33, 27.1627, 0.966032, 0, 100),
+(655110, 40, -934.678, 8048.94, 23.8428, 0.930689, 0, 100),
+(655110, 41, -927.145, 8064.62, 22.2443, 1.19772, 0, 100),
+(655110, 42, -925.531, 8084.46, 20.462, 1.61791, 0, 100),
+(655110, 43, -929.955, 8100.56, 19.2077, 2.08522, 0, 100),
+(655110, 44, -941.076, 8117.97, 16.1933, 2.01847, 0, 100),
+(655110, 45, -950.445, 8136.7, 8.46156, 2.04595, 0, 100),
+(655110, 46, -961.349, 8157.99, 11.2468, 2.04203, 0, 100),
+(655110, 47, -966.493, 8168.31, 14.7536, 2.01847, 0, 100),
+(655110, 48, -972.338, 8184.73, 15.6714, 1.76321, 0, 100),
+(655110, 49, -972.804, 8223.08, 17.8149, 1.61556, 0, 100),
+(655110, 50, -967.869, 8247.88, 18.97, 1.32889, 0, 100),
+(655110, 51, -961.649, 8264.25, 19.72, 1.16317, 0, 100),
+(655110, 52, -943.117, 8296.46, 21.5, 0.96289, 0, 100),
+(655110, 53, -927.318, 8315.15, 23.386, 0.837226, 0, 100),
+(655110, 54, -910.694, 8332.79, 24.4268, 0.778321, 0, 100),
+(655110, 55, -940.544, 8298.11, 21.7331, 4.04165, 0, 100),
+(655110, 56, -952.892, 8278.76, 19.9521, 4.17516, 0, 100),
+(655110, 57, -964.942, 8256.17, 19.3332, 4.34795, 0, 100),
+(655110, 58, -972.327, 8230.33, 18.1723, 4.582, 0, 100),
+(655110, 59, -972.936, 8194.27, 16.2379, 4.71944, 0, 100);