2f20dd8e60
credit cmangos
150 lines
9.3 KiB
SQL
150 lines
9.3 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`='20250802135049');
|
|
IF v = 0 THEN
|
|
INSERT INTO `migrations` VALUES ('20250802135049');
|
|
-- Add your query below.
|
|
|
|
|
|
-- Add Two Cliff Walker Paths (credit cmangos)
|
|
-- 35158
|
|
UPDATE `creature` SET `position_x` = 3516.5552, `position_y` = -4615.619, `position_z` = 102.81993, `orientation` = 5.8294 WHERE `guid`= 35158;
|
|
DELETE FROM `creature_movement` WHERE `id` = 35158;
|
|
SET @POINT := 0;
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
|
|
(35158, (@POINT := @POINT + 1), 3516.5552, -4615.619, 102.81993, 100),
|
|
(35158, (@POINT := @POINT + 1), 3546.866, -4616.823, 105.41513, 100),
|
|
(35158, (@POINT := @POINT + 1), 3573.7246, -4629.1074, 110.33565, 100),
|
|
(35158, (@POINT := @POINT + 1), 3592.0142, -4637.6567, 116.50315, 100),
|
|
(35158, (@POINT := @POINT + 1), 3612.087, -4650.4307, 116.094284, 100),
|
|
(35158, (@POINT := @POINT + 1), 3612.0295, -4664.635, 118.691864, 100),
|
|
(35158, (@POINT := @POINT + 1), 3622.3489, -4700.8735, 116.26894, 100),
|
|
(35158, (@POINT := @POINT + 1), 3648.048, -4719.3643, 119.50047, 100),
|
|
(35158, (@POINT := @POINT + 1), 3683.8716, -4723.8726, 120.74617, 100),
|
|
(35158, (@POINT := @POINT + 1), 3700.1367, -4742.6396, 123.31503, 100),
|
|
(35158, (@POINT := @POINT + 1), 3716.8003, -4773.619, 130.48708, 100),
|
|
(35158, (@POINT := @POINT + 1), 3725.6511, -4805.1167, 130.23367, 100),
|
|
(35158, (@POINT := @POINT + 1), 3720.1653, -4839.743, 129.21039, 100),
|
|
(35158, (@POINT := @POINT + 1), 3715.7964, -4883.4404, 126.20636, 100),
|
|
(35158, (@POINT := @POINT + 1), 3712.8281, -4923.3613, 130.27824, 100),
|
|
(35158, (@POINT := @POINT + 1), 3719.6484, -4946.6226, 134.08133, 100),
|
|
(35158, (@POINT := @POINT + 1), 3752.2578, -4957.272, 140.00893, 100),
|
|
(35158, (@POINT := @POINT + 1), 3759.2778, -4987.692, 144.18474, 100),
|
|
(35158, (@POINT := @POINT + 1), 3785.8271, -5003.676, 142.4399, 100),
|
|
(35158, (@POINT := @POINT + 1), 3815.8237, -5015.008, 136.07559, 100),
|
|
(35158, (@POINT := @POINT + 1), 3848.4648, -5047.0684, 130.25903, 100),
|
|
(35158, (@POINT := @POINT + 1), 3855.675, -5084.094, 131.13708, 100),
|
|
(35158, (@POINT := @POINT + 1), 3880.1523, -5116.5767, 129.31058, 100),
|
|
(35158, (@POINT := @POINT + 1), 3911.6233, -5147.8594, 126.500336, 100),
|
|
(35158, (@POINT := @POINT + 1), 3942.5051, -5182.2964, 121.87777, 100),
|
|
(35158, (@POINT := @POINT + 1), 3958.5898, -5213.9297, 114.622635, 100),
|
|
(35158, (@POINT := @POINT + 1), 3982.2222, -5243.111, 112.10889, 100),
|
|
(35158, (@POINT := @POINT + 1), 4017.4392, -5254.9785, 108.97523, 100),
|
|
(35158, (@POINT := @POINT + 1), 4045.645, -5278.112, 105.1101, 100),
|
|
(35158, (@POINT := @POINT + 1), 4076.9944, -5305.6943, 107.01301, 100),
|
|
(35158, (@POINT := @POINT + 1), 4086.49, -5346.0815, 112.65893, 100),
|
|
(35158, (@POINT := @POINT + 1), 4119.749, -5382.796, 110.99826, 100),
|
|
(35158, (@POINT := @POINT + 1), 4086.49, -5346.0815, 112.65893, 100),
|
|
(35158, (@POINT := @POINT + 1), 4076.9944, -5305.6943, 107.01301, 100),
|
|
(35158, (@POINT := @POINT + 1), 4045.645, -5278.112, 105.1101, 100),
|
|
(35158, (@POINT := @POINT + 1), 4017.4392, -5254.9785, 108.97523, 100),
|
|
(35158, (@POINT := @POINT + 1), 3982.2222, -5243.111, 112.10889, 100),
|
|
(35158, (@POINT := @POINT + 1), 3958.5898, -5213.9297, 114.622635, 100),
|
|
(35158, (@POINT := @POINT + 1), 3942.5051, -5182.2964, 121.87777, 100),
|
|
(35158, (@POINT := @POINT + 1), 3911.6233, -5147.8594, 126.500336, 100),
|
|
(35158, (@POINT := @POINT + 1), 3880.1523, -5116.5767, 129.31058, 100),
|
|
(35158, (@POINT := @POINT + 1), 3855.675, -5084.094, 131.13708, 100),
|
|
(35158, (@POINT := @POINT + 1), 3848.4648, -5047.0684, 130.25903, 100),
|
|
(35158, (@POINT := @POINT + 1), 3815.8237, -5015.008, 136.07559, 100),
|
|
(35158, (@POINT := @POINT + 1), 3785.8271, -5003.676, 142.4399, 100),
|
|
(35158, (@POINT := @POINT + 1), 3759.2778, -4987.692, 144.18474, 100),
|
|
(35158, (@POINT := @POINT + 1), 3752.2578, -4957.272, 140.00893, 100),
|
|
(35158, (@POINT := @POINT + 1), 3719.6484, -4946.6226, 134.08133, 100),
|
|
(35158, (@POINT := @POINT + 1), 3712.8281, -4923.3613, 130.27824, 100),
|
|
(35158, (@POINT := @POINT + 1), 3715.7964, -4883.4404, 126.20636, 100),
|
|
(35158, (@POINT := @POINT + 1), 3720.1653, -4839.743, 129.21039, 100),
|
|
(35158, (@POINT := @POINT + 1), 3725.6511, -4805.1167, 130.23367, 100),
|
|
(35158, (@POINT := @POINT + 1), 3716.8003, -4773.619, 130.48708, 100),
|
|
(35158, (@POINT := @POINT + 1), 3700.1367, -4742.6396, 123.31503, 100),
|
|
(35158, (@POINT := @POINT + 1), 3683.8716, -4723.8726, 120.74617, 100),
|
|
(35158, (@POINT := @POINT + 1), 3648.048, -4719.3643, 119.50047, 100),
|
|
(35158, (@POINT := @POINT + 1), 3622.3489, -4700.8735, 116.26894, 100),
|
|
(35158, (@POINT := @POINT + 1), 3612.0295, -4664.635, 118.691864, 100),
|
|
(35158, (@POINT := @POINT + 1), 3612.087, -4650.4307, 116.094284, 100),
|
|
(35158, (@POINT := @POINT + 1), 3592.0142, -4637.6567, 116.50315, 100),
|
|
(35158, (@POINT := @POINT + 1), 3573.7246, -4629.1074, 110.33565, 100),
|
|
(35158, (@POINT := @POINT + 1), 3546.866, -4616.823, 105.41513, 100);
|
|
|
|
-- 35159
|
|
UPDATE `creature` SET `position_x` = 3083.06, `position_y` = -4250.1953, `position_z` = 98.17152, `orientation` = 5.8294 WHERE `guid`= 35159;
|
|
DELETE FROM `creature_movement` WHERE `id` = 35159;
|
|
SET @POINT := 0;
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
|
|
(35159, (@POINT := @POINT + 1), 3083.06, -4250.1953, 98.17152, 100),
|
|
(35159, (@POINT := @POINT + 1), 3085.554, -4224.6, 96.74145, 100),
|
|
(35159, (@POINT := @POINT + 1), 3120.0325, -4213.5103, 102.545456, 100),
|
|
(35159, (@POINT := @POINT + 1), 3147.3577, -4193.87, 109.33615, 100),
|
|
(35159, (@POINT := @POINT + 1), 3180.3496, -4178.9795, 106.83352, 100),
|
|
(35159, (@POINT := @POINT + 1), 3209.5574, -4183.872, 108.3196, 100),
|
|
(35159, (@POINT := @POINT + 1), 3251.016, -4187.7456, 104.06883, 100),
|
|
(35159, (@POINT := @POINT + 1), 3283.2522, -4187.094, 105.66244, 100),
|
|
(35159, (@POINT := @POINT + 1), 3313.218, -4174.6665, 105.61368, 100),
|
|
(35159, (@POINT := @POINT + 1), 3340.6863, -4185.7476, 107.70574, 100),
|
|
(35159, (@POINT := @POINT + 1), 3350.8677, -4217.8735, 108.06882, 100),
|
|
(35159, (@POINT := @POINT + 1), 3356.595, -4243.6323, 110.74051, 100),
|
|
(35159, (@POINT := @POINT + 1), 3378.7205, -4282.577, 100.246315, 100),
|
|
(35159, (@POINT := @POINT + 1), 3384.9744, -4317.9756, 99.071014, 100),
|
|
(35159, (@POINT := @POINT + 1), 3391.9062, -4353.9556, 107.65627, 100),
|
|
(35159, (@POINT := @POINT + 1), 3418.8745, -4384.3604, 119.14389, 100),
|
|
(35159, (@POINT := @POINT + 1), 3449.467, -4387.3794, 121.007515, 100),
|
|
(35159, (@POINT := @POINT + 1), 3481.4673, -4376.656, 120.5705, 100),
|
|
(35159, (@POINT := @POINT + 1), 3507.2234, -4347.0225, 126.079544, 100),
|
|
(35159, (@POINT := @POINT + 1), 3502.2634, -4316.4507, 122.326355, 100),
|
|
(35159, (@POINT := @POINT + 1), 3506.7983, -4283.325, 98.99569, 100),
|
|
(35159, (@POINT := @POINT + 1), 3498.406, -4247.0376, 93.2444, 100),
|
|
(35159, (@POINT := @POINT + 1), 3509.613, -4213.6914, 98.78307, 100),
|
|
(35159, (@POINT := @POINT + 1), 3520.6797, -4181.5576, 102.32655, 100),
|
|
(35159, (@POINT := @POINT + 1), 3521.0833, -4155.315, 107.141235, 100),
|
|
(35159, (@POINT := @POINT + 1), 3522.4033, -4123.1846, 106.15934, 100),
|
|
(35159, (@POINT := @POINT + 1), 3537.9148, -4085.6086, 102.31384, 100),
|
|
(35159, (@POINT := @POINT + 1), 3553.3215, -4056.631, 96.99243, 100),
|
|
(35159, (@POINT := @POINT + 1), 3581.8857, -4047.4902, 95.85323, 100),
|
|
(35159, (@POINT := @POINT + 1), 3553.3215, -4056.631, 96.99243, 100),
|
|
(35159, (@POINT := @POINT + 1), 3537.9148, -4085.6086, 102.31384, 100),
|
|
(35159, (@POINT := @POINT + 1), 3522.4033, -4123.1846, 106.15934, 100),
|
|
(35159, (@POINT := @POINT + 1), 3521.0833, -4155.315, 107.141235, 100),
|
|
(35159, (@POINT := @POINT + 1), 3520.6797, -4181.5576, 102.32655, 100),
|
|
(35159, (@POINT := @POINT + 1), 3509.613, -4213.6914, 98.78307, 100),
|
|
(35159, (@POINT := @POINT + 1), 3498.406, -4247.0376, 93.2444, 100),
|
|
(35159, (@POINT := @POINT + 1), 3506.7983, -4283.325, 98.99569, 100),
|
|
(35159, (@POINT := @POINT + 1), 3502.2634, -4316.4507, 122.326355, 100),
|
|
(35159, (@POINT := @POINT + 1), 3507.2234, -4347.0225, 126.079544, 100),
|
|
(35159, (@POINT := @POINT + 1), 3481.4673, -4376.656, 120.5705, 100),
|
|
(35159, (@POINT := @POINT + 1), 3449.467, -4387.3794, 121.007515, 100),
|
|
(35159, (@POINT := @POINT + 1), 3418.8745, -4384.3604, 119.14389, 100),
|
|
(35159, (@POINT := @POINT + 1), 3391.9062, -4353.9556, 107.65627, 100),
|
|
(35159, (@POINT := @POINT + 1), 3384.9744, -4317.9756, 99.071014, 100),
|
|
(35159, (@POINT := @POINT + 1), 3378.7205, -4282.577, 100.246315, 100),
|
|
(35159, (@POINT := @POINT + 1), 3356.595, -4243.6323, 110.74051, 100),
|
|
(35159, (@POINT := @POINT + 1), 3350.8677, -4217.8735, 108.06882, 100),
|
|
(35159, (@POINT := @POINT + 1), 3340.6863, -4185.7476, 107.70574, 100),
|
|
(35159, (@POINT := @POINT + 1), 3313.218, -4174.6665, 105.61368, 100),
|
|
(35159, (@POINT := @POINT + 1), 3283.2522, -4187.094, 105.66244, 100),
|
|
(35159, (@POINT := @POINT + 1), 3251.016, -4187.7456, 104.06883, 100),
|
|
(35159, (@POINT := @POINT + 1), 3209.5574, -4183.872, 108.3196, 100),
|
|
(35159, (@POINT := @POINT + 1), 3180.3496, -4178.9795, 106.83352, 100),
|
|
(35159, (@POINT := @POINT + 1), 3147.3577, -4193.87, 109.33615, 100),
|
|
(35159, (@POINT := @POINT + 1), 3120.0325, -4213.5103, 102.545456, 100),
|
|
(35159, (@POINT := @POINT + 1), 3085.554, -4224.6, 96.74145, 100);
|
|
|
|
|
|
-- End of migration.
|
|
END IF;
|
|
END??
|
|
DELIMITER ;
|
|
CALL add_migration();
|
|
DROP PROCEDURE IF EXISTS add_migration;
|