sindoring/moonwell-core-vanilla
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
Files
development
moonwell-core-vanilla/sql/migrations/20250705094422_world.sql
T
NickTyrer 7f1e83d8da Add Mesa and Elder Mesa Buzzard Waypoints (#3081) 
credit to cmangos
2025-07-05 14:15:34 +03:00

655 lines
45 KiB
SQL
Raw Permalink Blame History

DROP PROCEDURE IF EXISTS add_migration;
DELIMITER ??
CREATE PROCEDURE `add_migration`()
BEGIN
DECLARE v INT DEFAULT 1;
SET v = (SELECT COUNT(*) FROM `migrations` WHERE `id`='20250705094422');
IF v = 0 THEN
INSERT INTO `migrations` VALUES ('20250705094422');
-- Add your query below.
UPDATE `creature` SET `position_x` = -1556.5776, `position_y` = -2047.8619, `position_z` = 31.889364, `orientation` = 5.8294, `movement_type` = 2, `wander_distance` = 0 WHERE `guid`= 11288;
DELETE FROM `creature_movement` WHERE `id` = 11288;
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
(11288, (@POINT := @POINT + 1), -1556.5776, -2047.8619, 31.889364, 100),
(11288, (@POINT := @POINT + 1), -1575.7899, -2019.9989, 33.51178, 100),
(11288, (@POINT := @POINT + 1), -1603.3778, -2018.6033, 31.563534, 100),
(11288, (@POINT := @POINT + 1), -1618.7311, -2053.0657, 35.804874, 100),
(11288, (@POINT := @POINT + 1), -1626.2305, -2082.129, 36.005917, 100),
(11288, (@POINT := @POINT + 1), -1612.8171, -2101.3123, 31.484987, 100),
(11288, (@POINT := @POINT + 1), -1584.1738, -2081.2148, 33.46573, 100),
(11288, (@POINT := @POINT + 1), -1547.0465, -2081.343, 30.534023, 100),
(11288, (@POINT := @POINT + 1), -1518.3867, -2076.8125, 23.53268, 100),
(11288, (@POINT := @POINT + 1), -1500.0211, -2050.4329, 21.51177, 100),
(11288, (@POINT := @POINT + 1), -1477.5669, -2058.3345, 21.026371, 100),
(11288, (@POINT := @POINT + 1), -1466.3167, -2036.3099, 22.560013, 100),
(11288, (@POINT := @POINT + 1), -1463.6844, -2010.7238, 26.987274, 100),
(11288, (@POINT := @POINT + 1), -1478.4191, -1985.0983, 35.566547, 100),
(11288, (@POINT := @POINT + 1), -1498.4199, -1985.918, 37.894066, 100),
(11288, (@POINT := @POINT + 1), -1514.8833, -2010.5985, 34.784218, 100),
(11288, (@POINT := @POINT + 1), -1509.9464, -2028.743, 28.400759, 100),
(11288, (@POINT := @POINT + 1), -1531.6699, -2046.3672, 28.91656, 100);
UPDATE `creature` SET `position_x` = -1629.2408, `position_y` = -2213.1497, `position_z` = 32.05107, `orientation` = 5.8294, `movement_type` = 2, `wander_distance` = 0 WHERE `guid`= 11250;
DELETE FROM `creature_movement` WHERE `id` = 11250;
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
(11250, (@POINT := @POINT + 1), -1629.2408, -2213.1497, 32.05107, 100),
(11250, (@POINT := @POINT + 1), -1618.972, -2182.7131, 32.220276, 100),
(11250, (@POINT := @POINT + 1), -1635.4635, -2148.552, 26.275602, 100),
(11250, (@POINT := @POINT + 1), -1638.5408, -2124.3694, 30.140118, 100),
(11250, (@POINT := @POINT + 1), -1630.5505, -2095.6045, 34.678677, 100),
(11250, (@POINT := @POINT + 1), -1670.3629, -2111.1616, 34.911083, 100),
(11250, (@POINT := @POINT + 1), -1671.6478, -2087.6519, 38.51817, 100),
(11250, (@POINT := @POINT + 1), -1668.0875, -2052.7847, 40.586967, 100),
(11250, (@POINT := @POINT + 1), -1694.9297, -2055.5273, 50.27736, 100),
(11250, (@POINT := @POINT + 1), -1712.6852, -2066.223, 54.728508, 100),
(11250, (@POINT := @POINT + 1), -1723.2006, -2076.8665, 54.508583, 100),
(11250, (@POINT := @POINT + 1), -1716.7784, -2095.0872, 49.91513, 100),
(11250, (@POINT := @POINT + 1), -1726.017, -2114.2236, 46.501083, 100),
(11250, (@POINT := @POINT + 1), -1734.5044, -2142.759, 47.538414, 100),
(11250, (@POINT := @POINT + 1), -1720.9209, -2171.0693, 41.81534, 100),
(11250, (@POINT := @POINT + 1), -1696.8356, -2174.2297, 32.41775, 100),
(11250, (@POINT := @POINT + 1), -1676.8203, -2187.496, 27.177794, 100),
(11250, (@POINT := @POINT + 1), -1639.3398, -2193.8047, 27.968384, 100);
UPDATE `creature` SET `position_x` = -1626.9554, `position_y` = -2255.347, `position_z` = 32.90119, `orientation` = 5.8294, `movement_type` = 2, `wander_distance` = 0 WHERE `guid`= 11393;
DELETE FROM `creature_movement` WHERE `id` = 11393;
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
(11393, (@POINT := @POINT + 1), -1626.9554, -2255.347, 32.90119, 100),
(11393, (@POINT := @POINT + 1), -1647.0282, -2271.6199, 32.13307, 100),
(11393, (@POINT := @POINT + 1), -1667.4176, -2266.7317, 34.34539, 100),
(11393, (@POINT := @POINT + 1), -1682.2966, -2294.3706, 31.987679, 100),
(11393, (@POINT := @POINT + 1), -1702.3391, -2306.0156, 32.714775, 100),
(11393, (@POINT := @POINT + 1), -1725.4542, -2295.1257, 38.087578, 100),
(11393, (@POINT := @POINT + 1), -1755.9702, -2295.2395, 41.244793, 100),
(11393, (@POINT := @POINT + 1), -1765.0958, -2272.315, 40.633774, 100),
(11393, (@POINT := @POINT + 1), -1745.6189, -2242.8586, 44.99635, 100),
(11393, (@POINT := @POINT + 1), -1765.7784, -2241.7097, 48.213665, 100),
(11393, (@POINT := @POINT + 1), -1776.34, -2222.6594, 54.511536, 100),
(11393, (@POINT := @POINT + 1), -1762.6832, -2212.4927, 50.350555, 100),
(11393, (@POINT := @POINT + 1), -1749.2614, -2199.9233, 46.330006, 100),
(11393, (@POINT := @POINT + 1), -1749.168, -2180.1536, 49.58055, 100),
(11393, (@POINT := @POINT + 1), -1724.3184, -2181.0496, 40.99491, 100),
(11393, (@POINT := @POINT + 1), -1717.916, -2202.1035, 40.53112, 100),
(11393, (@POINT := @POINT + 1), -1712.2383, -2212.6777, 40.65865, 100),
(11393, (@POINT := @POINT + 1), -1703.38, -2226.8538, 35.40592, 100),
(11393, (@POINT := @POINT + 1), -1673.9426, -2220.0469, 27.68444, 100),
(11393, (@POINT := @POINT + 1), -1663.0201, -2244.2048, 31.701468, 100);
UPDATE `creature` SET `position_x` = -1803.82, `position_y` = -2257.4844, `position_z` = 47.355293, `orientation` = 5.8294, `movement_type` = 2, `wander_distance` = 0 WHERE `guid`= 11504;
DELETE FROM `creature_movement` WHERE `id` = 11504;
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
(11504, (@POINT := @POINT + 1), -1803.82, -2257.4844, 47.355293, 100),
(11504, (@POINT := @POINT + 1), -1823.173, -2247.4927, 50.92298, 100),
(11504, (@POINT := @POINT + 1), -1833.1567, -2249.3884, 58.235092, 100),
(11504, (@POINT := @POINT + 1), -1844.9197, -2266.6406, 51.962383, 100),
(11504, (@POINT := @POINT + 1), -1833.4045, -2276.9097, 47.17028, 100),
(11504, (@POINT := @POINT + 1), -1834.5309, -2301.2585, 46.70603, 100),
(11504, (@POINT := @POINT + 1), -1817.2235, -2325.4636, 34.970787, 100),
(11504, (@POINT := @POINT + 1), -1814.0352, -2341.1504, 31.288443, 100),
(11504, (@POINT := @POINT + 1), -1792.0284, -2334.2112, 30.326347, 100),
(11504, (@POINT := @POINT + 1), -1766.8635, -2335.7942, 30.639942, 100),
(11504, (@POINT := @POINT + 1), -1755.4559, -2344.6147, 30.678593, 100),
(11504, (@POINT := @POINT + 1), -1734.8853, -2311.6506, 38.593037, 100),
(11504, (@POINT := @POINT + 1), -1762.2927, -2296.8645, 41.19758, 100),
(11504, (@POINT := @POINT + 1), -1762.0223, -2272.636, 40.553955, 100),
(11504, (@POINT := @POINT + 1), -1745.189, -2253.9854, 40.672394, 100),
(11504, (@POINT := @POINT + 1), -1763.7959, -2245.529, 46.67375, 100),
(11504, (@POINT := @POINT + 1), -1783.9088, -2264.4185, 44.820908, 100);
UPDATE `creature` SET `position_x` = -2114.4646, `position_y` = -2635.114, `position_z` = 89.34839, `orientation` = 5.8294, `movement_type` = 2, `wander_distance` = 0 WHERE `guid`= 11251;
DELETE FROM `creature_movement` WHERE `id` = 11251;
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
(11251, (@POINT := @POINT + 1), -2114.4646, -2635.114, 89.34839, 100),
(11251, (@POINT := @POINT + 1), -2117.4006, -2631.2605, 88.63836, 100),
(11251, (@POINT := @POINT + 1), -2119.3228, -2622.7527, 89.83918, 100),
(11251, (@POINT := @POINT + 1), -2120.322, -2616.5435, 89.09747, 100),
(11251, (@POINT := @POINT + 1), -2123.7668, -2606.2546, 86.19681, 100),
(11251, (@POINT := @POINT + 1), -2125.2207, -2590.5847, 85.30442, 100),
(11251, (@POINT := @POINT + 1), -2110.6309, -2587.127, 81.381294, 100),
(11251, (@POINT := @POINT + 1), -2090.8203, -2575.4473, 75.850044, 100),
(11251, (@POINT := @POINT + 1), -2093.5657, -2555.9683, 76.39316, 100),
(11251, (@POINT := @POINT + 1), -2085.1658, -2531.993, 72.15154, 100),
(11251, (@POINT := @POINT + 1), -2072.5657, -2519.4207, 72.5091, 100),
(11251, (@POINT := @POINT + 1), -2043.774, -2518.8457, 70.19351, 100),
(11251, (@POINT := @POINT + 1), -2038.0148, -2538.2478, 70.11869, 100),
(11251, (@POINT := @POINT + 1), -2022.4391, -2558.819, 70.85634, 100),
(11251, (@POINT := @POINT + 1), -1995.6777, -2560.7974, 72.1541, 100),
(11251, (@POINT := @POINT + 1), -1977.1353, -2575.431, 74.73687, 100),
(11251, (@POINT := @POINT + 1), -2007.8951, -2597.3276, 74.91048, 100),
(11251, (@POINT := @POINT + 1), -1991.2935, -2618.8474, 78.49979, 100),
(11251, (@POINT := @POINT + 1), -2008.8854, -2642.9727, 80.92586, 100),
(11251, (@POINT := @POINT + 1), -2026.4137, -2661.7424, 79.91611, 100),
(11251, (@POINT := @POINT + 1), -2031.2773, -2675.9219, 80.288956, 100),
(11251, (@POINT := @POINT + 1), -2046.8184, -2678.6797, 78.936485, 100),
(11251, (@POINT := @POINT + 1), -2058.516, -2663.2637, 79.79747, 100),
(11251, (@POINT := @POINT + 1), -2061.173, -2639.8875, 80.92668, 100),
(11251, (@POINT := @POINT + 1), -2045.7203, -2625.7295, 80.06837, 100),
(11251, (@POINT := @POINT + 1), -2044.4293, -2611.9348, 77.25268, 100),
(11251, (@POINT := @POINT + 1), -2063.4465, -2599.4692, 76.77804, 100),
(11251, (@POINT := @POINT + 1), -2072.5217, -2618.7153, 79.98508, 100),
(11251, (@POINT := @POINT + 1), -2075.6165, -2632.2446, 81.84905, 100),
(11251, (@POINT := @POINT + 1), -2082.7825, -2641.4944, 80.40054, 100),
(11251, (@POINT := @POINT + 1), -2097.3445, -2640.367, 86.39485, 100);
UPDATE `creature` SET `position_x` = -1811.775, `position_y` = -2662.5503, `position_z` = 54.091053, `orientation` = 5.8294, `movement_type` = 2, `wander_distance` = 0 WHERE `guid`= 11591;
DELETE FROM `creature_movement` WHERE `id` = 11591;
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
(11591, (@POINT := @POINT + 1), -1811.775, -2662.5503, 54.091053, 100),
(11591, (@POINT := @POINT + 1), -1821.9185, -2683.5552, 53.66115, 100),
(11591, (@POINT := @POINT + 1), -1861.9933, -2665.9775, 52.719795, 100),
(11591, (@POINT := @POINT + 1), -1876.7344, -2639.4905, 59.04285, 100),
(11591, (@POINT := @POINT + 1), -1913.2188, -2613.2883, 70.658615, 100),
(11591, (@POINT := @POINT + 1), -1891.856, -2598.1182, 63.346268, 100),
(11591, (@POINT := @POINT + 1), -1870.1576, -2603.1804, 54.761295, 100),
(11591, (@POINT := @POINT + 1), -1851.4801, -2603.036, 53.796387, 100),
(11591, (@POINT := @POINT + 1), -1834.9349, -2583.2593, 52.017174, 100),
(11591, (@POINT := @POINT + 1), -1807.3066, -2595.0957, 48.27391, 100),
(11591, (@POINT := @POINT + 1), -1793.3473, -2613.9392, 48.68366, 100),
(11591, (@POINT := @POINT + 1), -1777.0566, -2604.1797, 59.679276, 100),
(11591, (@POINT := @POINT + 1), -1773.9609, -2596.8027, 61.97496, 100),
(11591, (@POINT := @POINT + 1), -1770.6975, -2592.7036, 63.879726, 100),
(11591, (@POINT := @POINT + 1), -1764.1172, -2598.2786, 63.472153, 100),
(11591, (@POINT := @POINT + 1), -1757.2454, -2605.5059, 65.35879, 100),
(11591, (@POINT := @POINT + 1), -1760.9785, -2614.3955, 66.834625, 100),
(11591, (@POINT := @POINT + 1), -1767.8828, -2613.248, 64.52551, 100),
(11591, (@POINT := @POINT + 1), -1776.1222, -2613.1487, 59.881287, 100),
(11591, (@POINT := @POINT + 1), -1782.5586, -2621.664, 52.108864, 100),
(11591, (@POINT := @POINT + 1), -1790.1935, -2635.3923, 52.20903, 100);
UPDATE `creature` SET `position_x` = -1758.2928, `position_y` = -2643.7803, `position_z` = 45.001564, `orientation` = 5.8294, `movement_type` = 2, `wander_distance` = 0 WHERE `guid`= 11584;
DELETE FROM `creature_movement` WHERE `id` = 11584;
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
(11584, (@POINT := @POINT + 1), -1758.2928, -2643.7803, 45.001564, 100),
(11584, (@POINT := @POINT + 1), -1743.6482, -2631.9146, 46.490402, 100),
(11584, (@POINT := @POINT + 1), -1732.4017, -2630.6372, 48.094467, 100),
(11584, (@POINT := @POINT + 1), -1718.3822, -2641.803, 46.15836, 100),
(11584, (@POINT := @POINT + 1), -1696.7048, -2638.888, 43.79434, 100),
(11584, (@POINT := @POINT + 1), -1684.849, -2647.9402, 44.239883, 100),
(11584, (@POINT := @POINT + 1), -1678.5798, -2675.618, 43.305386, 100),
(11584, (@POINT := @POINT + 1), -1686.9626, -2712.393, 41.11186, 100),
(11584, (@POINT := @POINT + 1), -1699.5751, -2730.6868, 42.77458, 100),
(11584, (@POINT := @POINT + 1), -1712.7081, -2747.4597, 48.560825, 100),
(11584, (@POINT := @POINT + 1), -1692.5393, -2776.9873, 47.60826, 100),
(11584, (@POINT := @POINT + 1), -1692.9149, -2800.5867, 42.07308, 100),
(11584, (@POINT := @POINT + 1), -1707.5797, -2810.6401, 41.608456, 100),
(11584, (@POINT := @POINT + 1), -1697.2153, -2829.4412, 39.46142, 100),
(11584, (@POINT := @POINT + 1), -1704.3262, -2856.1533, 36.044655, 100),
(11584, (@POINT := @POINT + 1), -1737.5684, -2839.8945, 39.886543, 100),
(11584, (@POINT := @POINT + 1), -1752.8942, -2812.5103, 48.330265, 100),
(11584, (@POINT := @POINT + 1), -1738.5228, -2780.886, 48.526268, 100),
(11584, (@POINT := @POINT + 1), -1726.2344, -2757.9844, 49.829544, 100),
(11584, (@POINT := @POINT + 1), -1741.0289, -2737.238, 47.735096, 100),
(11584, (@POINT := @POINT + 1), -1750.1616, -2695.4373, 40.98978, 100),
(11584, (@POINT := @POINT + 1), -1750.738, -2658.4583, 40.828945, 100);
UPDATE `creature` SET `position_x` = -1853.5865, `position_y` = -2924.7139, `position_z` = 71.374756, `orientation` = 5.8294, `movement_type` = 2, `wander_distance` = 0 WHERE `guid`= 13296;
DELETE FROM `creature_movement` WHERE `id` = 13296;
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
(13296, (@POINT := @POINT + 1), -1853.5865, -2924.7139, 71.374756, 100),
(13296, (@POINT := @POINT + 1), -1851.6788, -2915.2534, 68.84781, 100),
(13296, (@POINT := @POINT + 1), -1843.3594, -2897.0898, 67.43565, 100),
(13296, (@POINT := @POINT + 1), -1826.7548, -2879.924, 63.000492, 100),
(13296, (@POINT := @POINT + 1), -1806.0703, -2858.1855, 58.11657, 100),
(13296, (@POINT := @POINT + 1), -1769.5408, -2839.2947, 49.088303, 100),
(13296, (@POINT := @POINT + 1), -1745.997, -2855.084, 43.43052, 100),
(13296, (@POINT := @POINT + 1), -1720.833, -2865.921, 37.08848, 100),
(13296, (@POINT := @POINT + 1), -1694.6119, -2833.3208, 39.686337, 100),
(13296, (@POINT := @POINT + 1), -1660.6324, -2820.265, 39.403736, 100),
(13296, (@POINT := @POINT + 1), -1634.684, -2831.663, 37.29193, 100),
(13296, (@POINT := @POINT + 1), -1636.8613, -2861.1829, 31.804012, 100),
(13296, (@POINT := @POINT + 1), -1683.6619, -2877.9841, 35.794746, 100),
(13296, (@POINT := @POINT + 1), -1697.9696, -2901.078, 33.319744, 100),
(13296, (@POINT := @POINT + 1), -1711.5115, -2910.4446, 36.647385, 100),
(13296, (@POINT := @POINT + 1), -1743.8524, -2924.2578, 36.56499, 100),
(13296, (@POINT := @POINT + 1), -1765.3245, -2909.1, 43.644447, 100),
(13296, (@POINT := @POINT + 1), -1790.2754, -2907.9277, 51.27762, 100),
(13296, (@POINT := @POINT + 1), -1805.543, -2920.1387, 58.42266, 100),
(13296, (@POINT := @POINT + 1), -1824.6764, -2937.5503, 63.263664, 100),
(13296, (@POINT := @POINT + 1), -1837.1836, -2937.6619, 69.25708, 100),
(13296, (@POINT := @POINT + 1), -1847.6569, -2930.7236, 71.292114, 100);
UPDATE `creature` SET `position_x` = -1706.9736, `position_y` = -3087.1594, `position_z` = 25.185772, `orientation` = 5.8294, `movement_type` = 2, `wander_distance` = 0 WHERE `guid`= 11466;
DELETE FROM `creature_movement` WHERE `id` = 11466;
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
(11466, (@POINT := @POINT + 1), -1706.9736, -3087.1594, 25.185772, 100),
(11466, (@POINT := @POINT + 1), -1690.0427, -3108.5989, 27.289703, 100),
(11466, (@POINT := @POINT + 1), -1712.9824, -3122.838, 30.69747, 100),
(11466, (@POINT := @POINT + 1), -1749.3126, -3123.197, 29.8102, 100),
(11466, (@POINT := @POINT + 1), -1765.5825, -3113.552, 34.54861, 100),
(11466, (@POINT := @POINT + 1), -1758.1233, -3092.1123, 26.500357, 100),
(11466, (@POINT := @POINT + 1), -1769.9138, -3057.3833, 38.088097, 100),
(11466, (@POINT := @POINT + 1), -1796.1276, -3070.5742, 44.928555, 100),
(11466, (@POINT := @POINT + 1), -1815.0251, -3078.5032, 47.416878, 100),
(11466, (@POINT := @POINT + 1), -1836.8021, -3056.5571, 58.15141, 100),
(11466, (@POINT := @POINT + 1), -1831.7739, -3017.9856, 56.40605, 100),
(11466, (@POINT := @POINT + 1), -1828.1083, -3005.1301, 59.858044, 100),
(11466, (@POINT := @POINT + 1), -1809.6785, -3002.6013, 51.30021, 100),
(11466, (@POINT := @POINT + 1), -1787.8809, -2981.9766, 48.819763, 100),
(11466, (@POINT := @POINT + 1), -1755.3599, -2966.2578, 36.05794, 100),
(11466, (@POINT := @POINT + 1), -1728.7097, -2968.745, 34.346107, 100),
(11466, (@POINT := @POINT + 1), -1711.4857, -2986.5334, 37.541943, 100),
(11466, (@POINT := @POINT + 1), -1700.3839, -3013.6008, 33.341373, 100),
(11466, (@POINT := @POINT + 1), -1706.7439, -3029.4849, 30.352676, 100),
(11466, (@POINT := @POINT + 1), -1740.7441, -3030.8125, 27.494886, 100),
(11466, (@POINT := @POINT + 1), -1728.9071, -3060.3208, 24.737259, 100);
UPDATE `creature` SET `position_x` = -1669.3337, `position_y` = -2908.4915, `position_z` = 35.842697, `orientation` = 5.8294, `movement_type` = 2, `wander_distance` = 0 WHERE `guid`= 14719;
DELETE FROM `creature_movement` WHERE `id` = 14719;
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
(14719, (@POINT := @POINT + 1), -1669.3337, -2908.4915, 35.842697, 100),
(14719, (@POINT := @POINT + 1), -1632.5834, -2887.4475, 27.834042, 100),
(14719, (@POINT := @POINT + 1), -1596.3029, -2862.5598, 32.639633, 100),
(14719, (@POINT := @POINT + 1), -1571.775, -2830.6763, 39.182503, 100),
(14719, (@POINT := @POINT + 1), -1557.5006, -2801.6636, 39.910847, 100),
(14719, (@POINT := @POINT + 1), -1522.2582, -2803.0525, 38.522293, 100),
(14719, (@POINT := @POINT + 1), -1508.2435, -2823.7427, 38.610977, 100),
(14719, (@POINT := @POINT + 1), -1495.9164, -2862.3386, 31.728428, 100),
(14719, (@POINT := @POINT + 1), -1470.1733, -2880.7356, 32.46973, 100),
(14719, (@POINT := @POINT + 1), -1493.3153, -2898.285, 29.055344, 100),
(14719, (@POINT := @POINT + 1), -1516.6045, -2918.0103, 29.865587, 100),
(14719, (@POINT := @POINT + 1), -1555.2513, -2909.5073, 24.099049, 100),
(14719, (@POINT := @POINT + 1), -1590.8973, -2913.157, 28.361277, 100),
(14719, (@POINT := @POINT + 1), -1596.9537, -2945.2239, 33.58545, 100),
(14719, (@POINT := @POINT + 1), -1627.4958, -2980.3083, 29.46118, 100),
(14719, (@POINT := @POINT + 1), -1648, -3000.8125, 22.638927, 100),
(14719, (@POINT := @POINT + 1), -1686.172, -2999.3975, 33.93516, 100),
(14719, (@POINT := @POINT + 1), -1722.0205, -2989.6885, 35.390587, 100),
(14719, (@POINT := @POINT + 1), -1709.5323, -2959.5725, 37.437614, 100),
(14719, (@POINT := @POINT + 1), -1687.454, -2956.0159, 37.411053, 100),
(14719, (@POINT := @POINT + 1), -1673.4197, -2945.0146, 36.68772, 100),
(14719, (@POINT := @POINT + 1), -1675.8961, -2933.0168, 36.772255, 100);
UPDATE `creature` SET `position_x` = -987.4506, `position_y` = -2412.9575, `position_z` = 48.689842, `orientation` = 5.8294, `movement_type` = 2, `wander_distance` = 0 WHERE `guid`= 11666;
DELETE FROM `creature_movement` WHERE `id` = 11666;
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
(11666, (@POINT := @POINT + 1), -987.4506, -2412.9575, 48.689842, 100),
(11666, (@POINT := @POINT + 1), -1006.3931, -2383.223, 47.423878, 100),
(11666, (@POINT := @POINT + 1), -1004.334, -2366.3555, 47.21541, 100),
(11666, (@POINT := @POINT + 1), -1030.3247, -2376.5674, 47.79828, 100),
(11666, (@POINT := @POINT + 1), -1031.4851, -2416.8113, 56.408596, 100),
(11666, (@POINT := @POINT + 1), -1047.8748, -2430.8179, 56.54696, 100),
(11666, (@POINT := @POINT + 1), -1063.2487, -2424.654, 55.102875, 100),
(11666, (@POINT := @POINT + 1), -1074.3417, -2410.6353, 52.34622, 100),
(11666, (@POINT := @POINT + 1), -1082.3817, -2395.7495, 47.746483, 100),
(11666, (@POINT := @POINT + 1), -1068.5084, -2357.448, 49.410667, 100),
(11666, (@POINT := @POINT + 1), -1080.7754, -2336.8945, 44.31364, 100),
(11666, (@POINT := @POINT + 1), -1083.9648, -2314.1191, 46.882256, 100),
(11666, (@POINT := @POINT + 1), -1072.9669, -2293.0803, 44.396736, 100),
(11666, (@POINT := @POINT + 1), -1048.611, -2295.035, 43.96002, 100),
(11666, (@POINT := @POINT + 1), -1024.7676, -2309.6914, 45.34777, 100),
(11666, (@POINT := @POINT + 1), -986.8953, -2307.9536, 50.59218, 100),
(11666, (@POINT := @POINT + 1), -964.1116, -2317.562, 51.800514, 100),
(11666, (@POINT := @POINT + 1), -951.33575, -2342.6633, 49.69185, 100),
(11666, (@POINT := @POINT + 1), -954.04004, -2379.5444, 46.34298, 100);
UPDATE `creature` SET `position_x` = -849.6829, `position_y` = -2263.2036, `position_z` = 54.746685, `orientation` = 5.8294, `movement_type` = 2, `wander_distance` = 0 WHERE `guid`= 11363;
DELETE FROM `creature_movement` WHERE `id` = 11363;
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
(11363, (@POINT := @POINT + 1), -849.6829, -2263.2036, 54.746685, 100),
(11363, (@POINT := @POINT + 1), -873.73175, -2240.225, 50.964245, 100),
(11363, (@POINT := @POINT + 1), -870.5084, -2216.9739, 46.15342, 100),
(11363, (@POINT := @POINT + 1), -893.9015, -2203.2485, 44.53584, 100),
(11363, (@POINT := @POINT + 1), -911.07, -2211.7446, 43.57967, 100),
(11363, (@POINT := @POINT + 1), -936.38965, -2200.9768, 42.929222, 100),
(11363, (@POINT := @POINT + 1), -959.3231, -2200.4058, 48.50083, 100),
(11363, (@POINT := @POINT + 1), -984.1758, -2203.0918, 56.03963, 100),
(11363, (@POINT := @POINT + 1), -1007.75977, -2228.9316, 58.878517, 100),
(11363, (@POINT := @POINT + 1), -1026.8005, -2244.6177, 57.82094, 100),
(11363, (@POINT := @POINT + 1), -1055.0228, -2238.6707, 58.316055, 100),
(11363, (@POINT := @POINT + 1), -1061.6807, -2264.6746, 50.01172, 100),
(11363, (@POINT := @POINT + 1), -1052.2188, -2278.7852, 47.87267, 100),
(11363, (@POINT := @POINT + 1), -1038.619, -2299.0728, 42.826096, 100),
(11363, (@POINT := @POINT + 1), -1031.1455, -2322.2937, 46.76876, 100),
(11363, (@POINT := @POINT + 1), -1004.0135, -2341.543, 49.74271, 100),
(11363, (@POINT := @POINT + 1), -983.6087, -2340.354, 50.629745, 100),
(11363, (@POINT := @POINT + 1), -957.62036, -2324.4934, 51.67833, 100),
(11363, (@POINT := @POINT + 1), -930.5213, -2306.8281, 47.460762, 100),
(11363, (@POINT := @POINT + 1), -911.6006, -2301.056, 48.607574, 100),
(11363, (@POINT := @POINT + 1), -914.5967, -2283.807, 46.74891, 100),
(11363, (@POINT := @POINT + 1), -890.2819, -2283.339, 55.244934, 100),
(11363, (@POINT := @POINT + 1), -868.4961, -2280.246, 55.032993, 100);
UPDATE `creature` SET `position_x` = -735.3092, `position_y` = -2227.4758, `position_z` = 58.93202, `orientation` = 5.8294, `movement_type` = 2, `wander_distance` = 0 WHERE `guid`= 11364;
DELETE FROM `creature_movement` WHERE `id` = 11364;
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
(11364, (@POINT := @POINT + 1), -735.3092, -2227.4758, 58.93202, 100),
(11364, (@POINT := @POINT + 1), -760.90967, -2231.6658, 55.78503, 100),
(11364, (@POINT := @POINT + 1), -773.52515, -2223.6401, 53.81728, 100),
(11364, (@POINT := @POINT + 1), -790.87537, -2242.4893, 51.6257, 100),
(11364, (@POINT := @POINT + 1), -793.4143, -2281.4497, 54.6997, 100),
(11364, (@POINT := @POINT + 1), -810.5152, -2300.3743, 56.753536, 100),
(11364, (@POINT := @POINT + 1), -837.91486, -2296.2095, 53.771328, 100),
(11364, (@POINT := @POINT + 1), -857.34766, -2311.9316, 54.045677, 100),
(11364, (@POINT := @POINT + 1), -868.6557, -2331.6045, 55.298225, 100),
(11364, (@POINT := @POINT + 1), -893.8364, -2333.507, 50.496986, 100),
(11364, (@POINT := @POINT + 1), -925.368, -2339.6292, 46.874924, 100),
(11364, (@POINT := @POINT + 1), -926.88586, -2375.4924, 47.202724, 100),
(11364, (@POINT := @POINT + 1), -910.0508, -2386.2734, 51.18087, 100),
(11364, (@POINT := @POINT + 1), -882.4531, -2397.9922, 55.513134, 100),
(11364, (@POINT := @POINT + 1), -862.4551, -2399.92, 59.515903, 100),
(11364, (@POINT := @POINT + 1), -882.4531, -2397.9922, 55.513134, 100),
(11364, (@POINT := @POINT + 1), -910.0508, -2386.2734, 51.18087, 100),
(11364, (@POINT := @POINT + 1), -926.88586, -2375.4924, 47.202724, 100),
(11364, (@POINT := @POINT + 1), -925.368, -2339.6292, 46.874924, 100),
(11364, (@POINT := @POINT + 1), -893.8364, -2333.507, 50.496986, 100),
(11364, (@POINT := @POINT + 1), -868.6557, -2331.6045, 55.298225, 100),
(11364, (@POINT := @POINT + 1), -857.34766, -2311.9316, 54.045677, 100),
(11364, (@POINT := @POINT + 1), -837.91486, -2296.2095, 53.771328, 100),
(11364, (@POINT := @POINT + 1), -810.5152, -2300.3743, 56.753536, 100),
(11364, (@POINT := @POINT + 1), -793.4143, -2281.4497, 54.6997, 100),
(11364, (@POINT := @POINT + 1), -790.87537, -2242.4893, 51.6257, 100),
(11364, (@POINT := @POINT + 1), -773.52515, -2223.6401, 53.81728, 100),
(11364, (@POINT := @POINT + 1), -760.90967, -2231.6658, 55.78503, 100);
UPDATE `creature` SET `position_x` = -1094.8578, `position_y` = -2602.6416, `position_z` = 47.94673, `orientation` = 5.8294, `movement_type` = 2, `wander_distance` = 0 WHERE `guid`= 11630;
DELETE FROM `creature_movement` WHERE `id` = 11630;
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
(11630, (@POINT := @POINT + 1), -1094.8578, -2602.6416, 47.94673, 100),
(11630, (@POINT := @POINT + 1), -1059.0438, -2615.397, 51.805, 100),
(11630, (@POINT := @POINT + 1), -1040.1377, -2595.3193, 54.46172, 100),
(11630, (@POINT := @POINT + 1), -1034.724, -2571.3582, 56.111164, 100),
(11630, (@POINT := @POINT + 1), -1022.989, -2561.259, 55.54399, 100),
(11630, (@POINT := @POINT + 1), -1006.7863, -2549.9072, 58.34285, 100),
(11630, (@POINT := @POINT + 1), -985.07074, -2550.552, 60.22013, 100),
(11630, (@POINT := @POINT + 1), -967.22754, -2547.5652, 61.78096, 100),
(11630, (@POINT := @POINT + 1), -984.6198, -2549.2122, 60.251343, 100),
(11630, (@POINT := @POINT + 1), -953.38367, -2541.1497, 61.03692, 100),
(11630, (@POINT := @POINT + 1), -955.24414, -2520.8877, 61.409676, 100),
(11630, (@POINT := @POINT + 1), -968.3368, -2503.9514, 57.340893, 100),
(11630, (@POINT := @POINT + 1), -996.00085, -2484.807, 53.48958, 100),
(11630, (@POINT := @POINT + 1), -1014.6105, -2450.636, 56.315895, 100),
(11630, (@POINT := @POINT + 1), -991.7808, -2423.0813, 50.02545, 100),
(11630, (@POINT := @POINT + 1), -954.09357, -2414.1438, 47.234055, 100),
(11630, (@POINT := @POINT + 1), -934.6819, -2433.397, 50.272625, 100),
(11630, (@POINT := @POINT + 1), -908.1614, -2446.313, 55.65712, 100),
(11630, (@POINT := @POINT + 1), -894.5508, -2464.8652, 58.67416, 100),
(11630, (@POINT := @POINT + 1), -908.1614, -2446.313, 55.65712, 100),
(11630, (@POINT := @POINT + 1), -934.6819, -2433.397, 50.272625, 100),
(11630, (@POINT := @POINT + 1), -954.09357, -2414.1438, 47.234055, 100),
(11630, (@POINT := @POINT + 1), -991.7808, -2423.0813, 50.02545, 100),
(11630, (@POINT := @POINT + 1), -1014.6105, -2450.636, 56.315895, 100),
(11630, (@POINT := @POINT + 1), -996.00085, -2484.807, 53.48958, 100),
(11630, (@POINT := @POINT + 1), -968.3368, -2503.9514, 57.340893, 100),
(11630, (@POINT := @POINT + 1), -955.24414, -2520.8877, 61.409676, 100),
(11630, (@POINT := @POINT + 1), -953.38367, -2541.1497, 61.03692, 100),
(11630, (@POINT := @POINT + 1), -984.6198, -2549.2122, 60.251343, 100),
(11630, (@POINT := @POINT + 1), -967.22754, -2547.5652, 61.78096, 100),
(11630, (@POINT := @POINT + 1), -985.07074, -2550.552, 60.22013, 100),
(11630, (@POINT := @POINT + 1), -1006.7863, -2549.9072, 58.34285, 100),
(11630, (@POINT := @POINT + 1), -1022.989, -2561.259, 55.54399, 100),
(11630, (@POINT := @POINT + 1), -1034.724, -2571.3582, 56.111164, 100),
(11630, (@POINT := @POINT + 1), -1040.1377, -2595.3193, 54.46172, 100),
(11630, (@POINT := @POINT + 1), -1059.0438, -2615.397, 51.805, 100);
UPDATE `creature` SET `position_x` = -1798.4891, `position_y` = -2004.8746, `position_z` = 57.311264, `orientation` = 5.8294, `movement_type` = 2, `wander_distance` = 0 WHERE `guid`= 11345;
DELETE FROM `creature_movement` WHERE `id` = 11345;
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
(11345, (@POINT := @POINT + 1), -1798.4891, -2004.8746, 57.311264, 100),
(11345, (@POINT := @POINT + 1), -1786.4056, -2002.3815, 55.350258, 100),
(11345, (@POINT := @POINT + 1), -1774.9644, -1989.7483, 54.21036, 100),
(11345, (@POINT := @POINT + 1), -1778.1499, -1977.8689, 54.206566, 100),
(11345, (@POINT := @POINT + 1), -1785.7393, -1964.0312, 54.20331, 100),
(11345, (@POINT := @POINT + 1), -1785.5319, -1947.151, 54.87973, 100),
(11345, (@POINT := @POINT + 1), -1776.8644, -1940.1222, 55.45025, 100),
(11345, (@POINT := @POINT + 1), -1761.7043, -1941.4495, 54.392605, 100),
(11345, (@POINT := @POINT + 1), -1758.4001, -1924.2173, 57.13734, 100),
(11345, (@POINT := @POINT + 1), -1759.3993, -1907.5452, 59.69762, 100),
(11345, (@POINT := @POINT + 1), -1766.1295, -1900.9978, 62.032787, 100),
(11345, (@POINT := @POINT + 1), -1767.457, -1893.1074, 60.97535, 100),
(11345, (@POINT := @POINT + 1), -1765.6401, -1879.9536, 57.9163, 100),
(11345, (@POINT := @POINT + 1), -1766.0747, -1865.7592, 53.83339, 100),
(11345, (@POINT := @POINT + 1), -1763.0975, -1852.7723, 44.82866, 100),
(11345, (@POINT := @POINT + 1), -1767.6128, -1845.344, 45.83384, 100),
(11345, (@POINT := @POINT + 1), -1770.1211, -1833.6016, 45.291924, 100),
(11345, (@POINT := @POINT + 1), -1768.128, -1825.8717, 41.329956, 100),
(11345, (@POINT := @POINT + 1), -1783.7227, -1822.2773, 47.729248, 100),
(11345, (@POINT := @POINT + 1), -1790.8156, -1817.4193, 50.685707, 100),
(11345, (@POINT := @POINT + 1), -1783.7227, -1822.2773, 47.729248, 100),
(11345, (@POINT := @POINT + 1), -1768.128, -1825.8717, 41.329956, 100),
(11345, (@POINT := @POINT + 1), -1770.1211, -1833.6016, 45.291924, 100),
(11345, (@POINT := @POINT + 1), -1767.6128, -1845.344, 45.83384, 100),
(11345, (@POINT := @POINT + 1), -1763.0975, -1852.7723, 44.82866, 100),
(11345, (@POINT := @POINT + 1), -1766.0747, -1865.7592, 53.83339, 100),
(11345, (@POINT := @POINT + 1), -1765.6401, -1879.9536, 57.9163, 100),
(11345, (@POINT := @POINT + 1), -1767.457, -1893.1074, 60.97535, 100),
(11345, (@POINT := @POINT + 1), -1766.1295, -1900.9978, 62.032787, 100),
(11345, (@POINT := @POINT + 1), -1759.3993, -1907.5452, 59.69762, 100),
(11345, (@POINT := @POINT + 1), -1758.4001, -1924.2173, 57.13734, 100),
(11345, (@POINT := @POINT + 1), -1761.7043, -1941.4495, 54.392605, 100),
(11345, (@POINT := @POINT + 1), -1776.8644, -1940.1222, 55.45025, 100),
(11345, (@POINT := @POINT + 1), -1785.5319, -1947.151, 54.87973, 100),
(11345, (@POINT := @POINT + 1), -1785.7393, -1964.0312, 54.20331, 100),
(11345, (@POINT := @POINT + 1), -1778.1499, -1977.8689, 54.206566, 100),
(11345, (@POINT := @POINT + 1), -1774.9644, -1989.7483, 54.21036, 100),
(11345, (@POINT := @POINT + 1), -1786.4056, -2002.3815, 55.350258, 100);
UPDATE `creature` SET `position_x` = -1826.9146, `position_y` = -1710.9154, `position_z` = 50.10554, `orientation` = 5.8294, `movement_type` = 2, `wander_distance` = 0 WHERE `guid`= 11230;
DELETE FROM `creature_movement` WHERE `id` = 11230;
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
(11230, (@POINT := @POINT + 1), -1826.9146, -1710.9154, 50.10554, 100),
(11230, (@POINT := @POINT + 1), -1835.3555, -1721.9727, 54.266647, 100),
(11230, (@POINT := @POINT + 1), -1845.3834, -1724.3605, 55.77906, 100),
(11230, (@POINT := @POINT + 1), -1850.7067, -1731.9548, 60.279778, 100),
(11230, (@POINT := @POINT + 1), -1853.0265, -1741.8114, 63.341232, 100),
(11230, (@POINT := @POINT + 1), -1860.6836, -1735.3652, 65.19264, 100),
(11230, (@POINT := @POINT + 1), -1866.2952, -1722.6797, 67.155075, 100),
(11230, (@POINT := @POINT + 1), -1872.3105, -1710.0195, 65.69068, 100),
(11230, (@POINT := @POINT + 1), -1873.625, -1707.2383, 64.272224, 100),
(11230, (@POINT := @POINT + 1), -1883.5172, -1701.2698, 63.169693, 100),
(11230, (@POINT := @POINT + 1), -1880.0436, -1691.3212, 57.372547, 100),
(11230, (@POINT := @POINT + 1), -1881.5884, -1680.6978, 53.351418, 100),
(11230, (@POINT := @POINT + 1), -1887.9536, -1664.7084, 52.27325, 100),
(11230, (@POINT := @POINT + 1), -1884.0806, -1657.2676, 45.46997, 100),
(11230, (@POINT := @POINT + 1), -1878.1901, -1648.6876, 38.621414, 100),
(11230, (@POINT := @POINT + 1), -1863.9084, -1647.925, 37.35406, 100),
(11230, (@POINT := @POINT + 1), -1853.3295, -1650.1492, 39.118637, 100),
(11230, (@POINT := @POINT + 1), -1863.9084, -1647.925, 37.35406, 100),
(11230, (@POINT := @POINT + 1), -1878.1901, -1648.6876, 38.621414, 100),
(11230, (@POINT := @POINT + 1), -1884.0806, -1657.2676, 45.46997, 100),
(11230, (@POINT := @POINT + 1), -1887.9536, -1664.7084, 52.27325, 100),
(11230, (@POINT := @POINT + 1), -1881.5884, -1680.6978, 53.351418, 100),
(11230, (@POINT := @POINT + 1), -1880.0436, -1691.3212, 57.372547, 100),
(11230, (@POINT := @POINT + 1), -1883.5172, -1701.2698, 63.169693, 100),
(11230, (@POINT := @POINT + 1), -1873.625, -1707.2383, 64.272224, 100),
(11230, (@POINT := @POINT + 1), -1872.3105, -1710.0195, 65.69068, 100),
(11230, (@POINT := @POINT + 1), -1866.2952, -1722.6797, 67.155075, 100),
(11230, (@POINT := @POINT + 1), -1860.6836, -1735.3652, 65.19264, 100),
(11230, (@POINT := @POINT + 1), -1853.0265, -1741.8114, 63.341232, 100),
(11230, (@POINT := @POINT + 1), -1850.7067, -1731.9548, 60.279778, 100),
(11230, (@POINT := @POINT + 1), -1845.3834, -1724.3605, 55.77906, 100),
(11230, (@POINT := @POINT + 1), -1835.3555, -1721.9727, 54.266647, 100);
UPDATE `creature` SET `position_x` = -1938.4944, `position_y` = -1618.6497, `position_z` = 43.814922, `orientation` = 5.8294, `movement_type` = 2, `wander_distance` = 0 WHERE `guid`= 11232;
DELETE FROM `creature_movement` WHERE `id` = 11232;
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
(11232, (@POINT := @POINT + 1), -1938.4944, -1618.6497, 43.814922, 100),
(11232, (@POINT := @POINT + 1), -1932.3853, -1624.7809, 43.36454, 100),
(11232, (@POINT := @POINT + 1), -1926.9152, -1630.0831, 43.02912, 100),
(11232, (@POINT := @POINT + 1), -1919.0254, -1631.3652, 41.816635, 100),
(11232, (@POINT := @POINT + 1), -1907.9651, -1632.0206, 39.856804, 100),
(11232, (@POINT := @POINT + 1), -1892.1858, -1630.233, 34.510384, 100),
(11232, (@POINT := @POINT + 1), -1887.2126, -1630.3448, 33.68852, 100),
(11232, (@POINT := @POINT + 1), -1881.6931, -1633.0665, 33.89424, 100),
(11232, (@POINT := @POINT + 1), -1873.2559, -1636.1777, 35.206974, 100),
(11232, (@POINT := @POINT + 1), -1879.0114, -1647.3932, 38.240696, 100),
(11232, (@POINT := @POINT + 1), -1885.2565, -1657.6344, 46.561066, 100),
(11232, (@POINT := @POINT + 1), -1888.2759, -1668.9158, 54.31051, 100),
(11232, (@POINT := @POINT + 1), -1892.3019, -1671.5728, 57.279453, 100),
(11232, (@POINT := @POINT + 1), -1899.0195, -1672.5391, 61.196358, 100),
(11232, (@POINT := @POINT + 1), -1907.5162, -1672.1259, 63.572975, 100),
(11232, (@POINT := @POINT + 1), -1916.3926, -1670.6836, 59.10928, 100),
(11232, (@POINT := @POINT + 1), -1917.7463, -1663.2755, 57.718605, 100),
(11232, (@POINT := @POINT + 1), -1916.3926, -1670.6836, 59.10928, 100),
(11232, (@POINT := @POINT + 1), -1907.5162, -1672.1259, 63.572975, 100),
(11232, (@POINT := @POINT + 1), -1899.0195, -1672.5391, 61.196358, 100),
(11232, (@POINT := @POINT + 1), -1892.3019, -1671.5728, 57.279453, 100),
(11232, (@POINT := @POINT + 1), -1888.2759, -1668.9158, 54.31051, 100),
(11232, (@POINT := @POINT + 1), -1885.2565, -1657.6344, 46.561066, 100),
(11232, (@POINT := @POINT + 1), -1879.0114, -1647.3932, 38.240696, 100),
(11232, (@POINT := @POINT + 1), -1873.2559, -1636.1777, 35.206974, 100),
(11232, (@POINT := @POINT + 1), -1881.6931, -1633.0665, 33.89424, 100),
(11232, (@POINT := @POINT + 1), -1887.2126, -1630.3448, 33.68852, 100),
(11232, (@POINT := @POINT + 1), -1892.1858, -1630.233, 34.510384, 100),
(11232, (@POINT := @POINT + 1), -1907.9651, -1632.0206, 39.856804, 100),
(11232, (@POINT := @POINT + 1), -1919.0254, -1631.3652, 41.816635, 100),
(11232, (@POINT := @POINT + 1), -1926.9152, -1630.0831, 43.02912, 100),
(11232, (@POINT := @POINT + 1), -1932.3853, -1624.7809, 43.36454, 100);
UPDATE `creature` SET `position_x` = -1845.1077, `position_y` = -1537.111, `position_z` = 65.2618, `orientation` = 5.8294, `movement_type` = 2, `wander_distance` = 0 WHERE `guid`= 11369;
DELETE FROM `creature_movement` WHERE `id` = 11369;
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
(11369, (@POINT := @POINT + 1), -1845.1077, -1537.111, 65.2618, 100),
(11369, (@POINT := @POINT + 1), -1843.5992, -1521.4142, 60.848724, 100),
(11369, (@POINT := @POINT + 1), -1842.4467, -1508.195, 57.068405, 100),
(11369, (@POINT := @POINT + 1), -1833.7565, -1502.5283, 62.341347, 100),
(11369, (@POINT := @POINT + 1), -1827.709, -1497.2793, 65.94896, 100),
(11369, (@POINT := @POINT + 1), -1819.8461, -1487.3468, 67.95902, 100),
(11369, (@POINT := @POINT + 1), -1823.3438, -1479.0508, 71.40019, 100),
(11369, (@POINT := @POINT + 1), -1818.1729, -1473.9128, 66.98664, 100),
(11369, (@POINT := @POINT + 1), -1808.2646, -1461.171, 63.034058, 100),
(11369, (@POINT := @POINT + 1), -1796.0048, -1455.6862, 67.505714, 100),
(11369, (@POINT := @POINT + 1), -1786.1061, -1460.1919, 68.10969, 100),
(11369, (@POINT := @POINT + 1), -1775.6543, -1462.7913, 68.111595, 100),
(11369, (@POINT := @POINT + 1), -1767.3969, -1459.2548, 68.12271, 100),
(11369, (@POINT := @POINT + 1), -1761.5485, -1454.9967, 68.15084, 100),
(11369, (@POINT := @POINT + 1), -1756.6653, -1449.4606, 68.19048, 100),
(11369, (@POINT := @POINT + 1), -1747.3668, -1452.7552, 67.33112, 100),
(11369, (@POINT := @POINT + 1), -1742.1783, -1457.1333, 68.91001, 100),
(11369, (@POINT := @POINT + 1), -1736.2423, -1458.009, 73.47892, 100),
(11369, (@POINT := @POINT + 1), -1727.6956, -1460.5985, 67.51582, 100),
(11369, (@POINT := @POINT + 1), -1725.8975, -1469.652, 65.64948, 100),
(11369, (@POINT := @POINT + 1), -1720.4857, -1473.5638, 64.81493, 100),
(11369, (@POINT := @POINT + 1), -1715.7109, -1471.9949, 61.828636, 100),
(11369, (@POINT := @POINT + 1), -1720.4857, -1473.5638, 64.81493, 100),
(11369, (@POINT := @POINT + 1), -1725.8975, -1469.652, 65.64948, 100),
(11369, (@POINT := @POINT + 1), -1727.6956, -1460.5985, 67.51582, 100),
(11369, (@POINT := @POINT + 1), -1736.2423, -1458.009, 73.47892, 100),
(11369, (@POINT := @POINT + 1), -1742.1783, -1457.1333, 68.91001, 100),
(11369, (@POINT := @POINT + 1), -1747.3668, -1452.7552, 67.33112, 100),
(11369, (@POINT := @POINT + 1), -1756.6653, -1449.4606, 68.19048, 100),
(11369, (@POINT := @POINT + 1), -1761.5485, -1454.9967, 68.15084, 100),
(11369, (@POINT := @POINT + 1), -1767.3969, -1459.2548, 68.12271, 100),
(11369, (@POINT := @POINT + 1), -1775.6543, -1462.7913, 68.111595, 100),
(11369, (@POINT := @POINT + 1), -1786.1061, -1460.1919, 68.10969, 100),
(11369, (@POINT := @POINT + 1), -1796.0048, -1455.6862, 67.505714, 100),
(11369, (@POINT := @POINT + 1), -1808.2646, -1461.171, 63.034058, 100),
(11369, (@POINT := @POINT + 1), -1818.1729, -1473.9128, 66.98664, 100),
(11369, (@POINT := @POINT + 1), -1823.3438, -1479.0508, 71.40019, 100),
(11369, (@POINT := @POINT + 1), -1819.8461, -1487.3468, 67.95902, 100),
(11369, (@POINT := @POINT + 1), -1827.709, -1497.2793, 65.94896, 100),
(11369, (@POINT := @POINT + 1), -1833.7565, -1502.5283, 62.341347, 100),
(11369, (@POINT := @POINT + 1), -1842.4467, -1508.195, 57.068405, 100),
(11369, (@POINT := @POINT + 1), -1843.5992, -1521.4142, 60.848724, 100);
UPDATE `creature` SET `position_x` = -1861.0165, `position_y` = -1479.2671, `position_z` = 30.092306, `orientation` = 5.8294, `movement_type` = 2, `wander_distance` = 0 WHERE `guid`= 11368;
DELETE FROM `creature_movement` WHERE `id` = 11368;
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
(11368, (@POINT := @POINT + 1), -1861.0165, -1479.2671, 30.092306, 100),
(11368, (@POINT := @POINT + 1), -1852.7338, -1471.718, 32.949883, 100),
(11368, (@POINT := @POINT + 1), -1852.686, -1463.9547, 37.41552, 100),
(11368, (@POINT := @POINT + 1), -1846.7637, -1459.4774, 41.566753, 100),
(11368, (@POINT := @POINT + 1), -1839.3485, -1464.3572, 47.12697, 100),
(11368, (@POINT := @POINT + 1), -1833.6292, -1463.9905, 49.786774, 100),
(11368, (@POINT := @POINT + 1), -1829.7028, -1457.8405, 50.671932, 100),
(11368, (@POINT := @POINT + 1), -1832.4688, -1446.7848, 58.776295, 100),
(11368, (@POINT := @POINT + 1), -1830.9138, -1440.3491, 58.84617, 100),
(11368, (@POINT := @POINT + 1), -1824.2363, -1443.9915, 55.961235, 100),
(11368, (@POINT := @POINT + 1), -1819.3763, -1450.5317, 51.571346, 100),
(11368, (@POINT := @POINT + 1), -1813.0234, -1457.7513, 58.09804, 100),
(11368, (@POINT := @POINT + 1), -1805.7103, -1455.687, 62.17366, 100),
(11368, (@POINT := @POINT + 1), -1807.588, -1447.7803, 56.354942, 100),
(11368, (@POINT := @POINT + 1), -1808.2047, -1441.6237, 52.436317, 100),
(11368, (@POINT := @POINT + 1), -1804.2904, -1433.5446, 51.942226, 100),
(11368, (@POINT := @POINT + 1), -1802.4481, -1426.4496, 49.19555, 100),
(11368, (@POINT := @POINT + 1), -1805.4689, -1422.4215, 49.013466, 100),
(11368, (@POINT := @POINT + 1), -1807.2001, -1415.9733, 51.06402, 100),
(11368, (@POINT := @POINT + 1), -1805.8778, -1411.8058, 50.362476, 100),
(11368, (@POINT := @POINT + 1), -1798.429, -1409.6334, 48.038315, 100),
(11368, (@POINT := @POINT + 1), -1789.7369, -1409.4712, 46.211514, 100),
(11368, (@POINT := @POINT + 1), -1785.8379, -1410.3535, 45.96888, 100),
(11368, (@POINT := @POINT + 1), -1781.1793, -1411.405, 45.962852, 100),
(11368, (@POINT := @POINT + 1), -1774.2932, -1407.783, 45.970135, 100),
(11368, (@POINT := @POINT + 1), -1768.5577, -1406.8584, 46.248264, 100),
(11368, (@POINT := @POINT + 1), -1774.2932, -1407.783, 45.970135, 100),
(11368, (@POINT := @POINT + 1), -1781.1793, -1411.405, 45.962852, 100),
(11368, (@POINT := @POINT + 1), -1785.8379, -1410.3535, 45.96888, 100),
(11368, (@POINT := @POINT + 1), -1789.7369, -1409.4712, 46.211514, 100),
(11368, (@POINT := @POINT + 1), -1798.429, -1409.6334, 48.038315, 100),
(11368, (@POINT := @POINT + 1), -1805.8778, -1411.8058, 50.362476, 100),
(11368, (@POINT := @POINT + 1), -1807.2001, -1415.9733, 51.06402, 100),
(11368, (@POINT := @POINT + 1), -1805.4689, -1422.4215, 49.013466, 100),
(11368, (@POINT := @POINT + 1), -1802.4481, -1426.4496, 49.19555, 100),
(11368, (@POINT := @POINT + 1), -1804.2904, -1433.5446, 51.942226, 100),
(11368, (@POINT := @POINT + 1), -1808.2047, -1441.6237, 52.436317, 100),
(11368, (@POINT := @POINT + 1), -1807.588, -1447.7803, 56.354942, 100),
(11368, (@POINT := @POINT + 1), -1805.7103, -1455.687, 62.17366, 100),
(11368, (@POINT := @POINT + 1), -1813.0234, -1457.7513, 58.09804, 100),
(11368, (@POINT := @POINT + 1), -1819.3763, -1450.5317, 51.571346, 100),
(11368, (@POINT := @POINT + 1), -1824.2363, -1443.9915, 55.961235, 100),
(11368, (@POINT := @POINT + 1), -1830.9138, -1440.3491, 58.84617, 100),
(11368, (@POINT := @POINT + 1), -1832.4688, -1446.7848, 58.776295, 100),
(11368, (@POINT := @POINT + 1), -1829.7028, -1457.8405, 50.671932, 100),
(11368, (@POINT := @POINT + 1), -1833.6292, -1463.9905, 49.786774, 100),
(11368, (@POINT := @POINT + 1), -1839.3485, -1464.3572, 47.12697, 100),
(11368, (@POINT := @POINT + 1), -1846.7637, -1459.4774, 41.566753, 100),
(11368, (@POINT := @POINT + 1), -1852.686, -1463.9547, 37.41552, 100),
(11368, (@POINT := @POINT + 1), -1852.7338, -1471.718, 32.949883, 100);
UPDATE `creature` SET `position_x` = -1241.497, `position_y` = -2814.9563, `position_z` = 48.34597, `orientation` = 5.8294, `movement_type` = 2, `wander_distance` = 0 WHERE `guid`= 13301;
DELETE FROM `creature_movement` WHERE `id` = 13301;
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
(13301, (@POINT := @POINT + 1), -1241.497, -2814.9563, 48.34597, 100),
(13301, (@POINT := @POINT + 1), -1264.5944, -2789.046, 51.01431, 100),
(13301, (@POINT := @POINT + 1), -1262.355, -2751.567, 49.051643, 100),
(13301, (@POINT := @POINT + 1), -1248.94, -2723.2415, 48.090622, 100),
(13301, (@POINT := @POINT + 1), -1224.8337, -2727.926, 51.42831, 100),
(13301, (@POINT := @POINT + 1), -1200.365, -2706.6692, 47.213104, 100),
(13301, (@POINT := @POINT + 1), -1188.1439, -2684.677, 48.87736, 100),
(13301, (@POINT := @POINT + 1), -1171.4429, -2685.0376, 51.61447, 100),
(13301, (@POINT := @POINT + 1), -1147.7715, -2681.0059, 53.78264, 100),
(13301, (@POINT := @POINT + 1), -1120.2952, -2659.7588, 50.8463, 100),
(13301, (@POINT := @POINT + 1), -1089.5558, -2657.2744, 49.982506, 100),
(13301, (@POINT := @POINT + 1), -1067.6615, -2657.1008, 50.11979, 100),
(13301, (@POINT := @POINT + 1), -1034.0502, -2636.1772, 52.02767, 100),
(13301, (@POINT := @POINT + 1), -1067.6615, -2657.1008, 50.11979, 100),
(13301, (@POINT := @POINT + 1), -1089.5558, -2657.2744, 49.982506, 100),
(13301, (@POINT := @POINT + 1), -1120.2952, -2659.7588, 50.8463, 100),
(13301, (@POINT := @POINT + 1), -1147.7715, -2681.0059, 53.78264, 100),
(13301, (@POINT := @POINT + 1), -1171.4429, -2685.0376, 51.61447, 100),
(13301, (@POINT := @POINT + 1), -1188.1439, -2684.677, 48.87736, 100),
(13301, (@POINT := @POINT + 1), -1200.365, -2706.6692, 47.213104, 100),
(13301, (@POINT := @POINT + 1), -1224.8337, -2727.926, 51.42831, 100),
(13301, (@POINT := @POINT + 1), -1248.94, -2723.2415, 48.090622, 100),
(13301, (@POINT := @POINT + 1), -1262.355, -2751.567, 49.051643, 100),
(13301, (@POINT := @POINT + 1), -1264.5944, -2789.046, 51.01431, 100);
-- End of migration.
END IF;
END??
DELIMITER ;
CALL add_migration();
DROP PROCEDURE IF EXISTS add_migration;
Reference in New Issue View Git Blame Copy Permalink