a40cc83bff
credit cmangos
98 lines
5.2 KiB
SQL
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;
|