Files
moonwell-core-vanilla/sql/migrations/20250802134639_world.sql
2025-08-04 15:27:00 +03:00

98 lines
5.2 KiB
SQL

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`='20250802134639');
IF v = 0 THEN
INSERT INTO `migrations` VALUES ('20250802134639');
-- Add your query below.
-- Correct Apothecary Lycanus Waypoints (credit cmangos)
DELETE FROM `creature_movement` WHERE `id` = 38093;
UPDATE `creature` SET `position_x` = 1453.947, `position_y` = 351.2875, `position_z` = -62.10241, `orientation` = 0.5569137 WHERE `guid`= 38093;
SET @POINT := 0;
INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`) VALUES
(5733, (@POINT := @POINT + 1), 1479.409, 372.6641, -62.18579),
(5733, (@POINT := @POINT + 1), 1490.668, 382.7879, -62.13049),
(5733, (@POINT := @POINT + 1), 1507.254, 392.7480, -57.15340),
(5733, (@POINT := @POINT + 1), 1510.655, 391.4390, -57.15269),
(5733, (@POINT := @POINT + 1), 1518.012, 377.2852, -50.84839),
(5733, (@POINT := @POINT + 1), 1526.585, 360.7172, -57.15204),
(5733, (@POINT := @POINT + 1), 1530.330, 362.3312, -57.15204),
(5733, (@POINT := @POINT + 1), 1537.363, 367.8207, -62.18076),
(5733, (@POINT := @POINT + 1), 1541.788, 366.9868, -62.18503),
(5733, (@POINT := @POINT + 1), 1543.513, 362.1345, -62.18871),
(5733, (@POINT := @POINT + 1), 1537.399, 358.0874, -61.50328),
(5733, (@POINT := @POINT + 1), 1523.827, 350.3899, -61.47989),
(5733, (@POINT := @POINT + 1), 1516.754, 348.5895, -60.78263),
(5733, (@POINT := @POINT + 1), 1506.970, 341.4081, -60.08857),
(5733, (@POINT := @POINT + 1), 1494.426, 328.6796, -60.08972),
(5733, (@POINT := @POINT + 1), 1485.358, 324.8369, -60.78840),
(5733, (@POINT := @POINT + 1), 1481.448, 320.6308, -60.76874),
(5733, (@POINT := @POINT + 1), 1477.088, 312.4247, -57.15205),
(5733, (@POINT := @POINT + 1), 1474.103, 311.8581, -57.15205),
(5733, (@POINT := @POINT + 1), 1460.298, 320.6215, -50.84841),
(5733, (@POINT := @POINT + 1), 1446.570, 328.6499, -57.15267),
(5733, (@POINT := @POINT + 1), 1443.132, 327.8983, -57.15334),
(5733, (@POINT := @POINT + 1), 1438.031, 318.6035, -62.30432),
(5733, (@POINT := @POINT + 1), 1434.720, 317.2854, -62.25796),
(5733, (@POINT := @POINT + 1), 1431.855, 318.8524, -62.24274),
(5733, (@POINT := @POINT + 1), 1430.826, 325.7559, -62.18589),
(5733, (@POINT := @POINT + 1), 1422.317, 340.9035, -62.18488),
(5733, (@POINT := @POINT + 1), 1412.049, 346.4379, -66.01148),
(5733, (@POINT := @POINT + 1), 1393.417, 363.7184, -66.04475),
(5733, (@POINT := @POINT + 1), 1383.044, 366.0187, -66.00156),
(5733, (@POINT := @POINT + 1), 1365.521, 370.2274, -70.45621),
(5733, (@POINT := @POINT + 1), 1363.163, 377.8648, -70.51649),
(5733, (@POINT := @POINT + 1), 1367.676, 391.4300, -71.58265),
(5733, (@POINT := @POINT + 1), 1373.875, 401.1192, -73.41265),
(5733, (@POINT := @POINT + 1), 1382.895, 409.3970, -75.89713),
(5733, (@POINT := @POINT + 1), 1389.492, 415.1714, -77.23779),
(5733, (@POINT := @POINT + 1), 1396.454, 415.7548, -77.23812),
(5733, (@POINT := @POINT + 1), 1408.307, 403.3368, -84.96553),
(5733, (@POINT := @POINT + 1), 1414.507, 401.6818, -84.96911),
(5733, (@POINT := @POINT + 1), 1428.567, 386.7604, -85.00344),
(5733, (@POINT := @POINT + 1), 1439.069, 395.1042, -85.27096),
(5733, (@POINT := @POINT + 1), 1448.465, 404.8771, -84.99477),
(5733, (@POINT := @POINT + 1), 1443.744, 412.5832, -84.98980),
(5733, (@POINT := @POINT + 1), 1435.269, 421.8757, -84.96635),
(5733, (@POINT := @POINT + 1), 1430.059, 429.9826, -83.02303),
(5733, (@POINT := @POINT + 1), 1419.351, 439.9147, -77.23872),
(5733, (@POINT := @POINT + 1), 1420.962, 445.0159, -77.23551),
(5733, (@POINT := @POINT + 1), 1434.677, 457.1974, -70.46587),
(5733, (@POINT := @POINT + 1), 1444.693, 453.6557, -70.45750),
(5733, (@POINT := @POINT + 1), 1454.077, 444.2845, -65.72675),
(5733, (@POINT := @POINT + 1), 1459.657, 438.8900, -65.72455),
(5733, (@POINT := @POINT + 1), 1470.865, 441.2971, -64.91907),
(5733, (@POINT := @POINT + 1), 1481.018, 448.8758, -61.92701),
(5733, (@POINT := @POINT + 1), 1491.781, 449.9227, -61.20277),
(5733, (@POINT := @POINT + 1), 1502.774, 444.2577, -63.65751),
(5733, (@POINT := @POINT + 1), 1507.677, 435.0599, -65.22881),
(5733, (@POINT := @POINT + 1), 1504.628, 426.7937, -63.94162),
(5733, (@POINT := @POINT + 1), 1494.864, 421.1157, -62.18553),
(5733, (@POINT := @POINT + 1), 1494.723, 410.3156, -62.18560),
(5733, (@POINT := @POINT + 1), 1499.950, 402.4439, -62.18579),
(5733, (@POINT := @POINT + 1), 1492.950, 388.4385, -62.17412),
(5733, (@POINT := @POINT + 1), 1482.611, 374.4702, -62.18579),
(5733, (@POINT := @POINT + 1), 1465.898, 357.5466, -62.18579),
(5733, (@POINT := @POINT + 1), 1454.054, 347.8523, -62.20852),
(5733, (@POINT := @POINT + 1), 1435.188, 340.4975, -62.18568),
(5733, (@POINT := @POINT + 1), 1428.785, 327.0564, -62.18573),
(5733, (@POINT := @POINT + 1), 1432.436, 318.3015, -62.24369),
(5733, (@POINT := @POINT + 1), 1438.110, 318.5949, -62.30505),
(5733, (@POINT := @POINT + 1), 1442.610, 326.1132, -57.15322),
(5733, (@POINT := @POINT + 1), 1446.589, 333.3574, -57.15327),
(5733, (@POINT := @POINT + 1), 1450.780, 340.8258, -62.25450),
(5733, (@POINT := @POINT + 1), 1455.385, 349.8915, -62.19318),
(5733, (@POINT := @POINT + 1), 1463.855, 357.4573, -62.18579);
-- End of migration.
END IF;
END??
DELIMITER ;
CALL add_migration();
DROP PROCEDURE IF EXISTS add_migration;