ratkosrb
60 lines
2.7 KiB
SQL
60 lines
2.7 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`='20260518063443');
|
|
IF v = 0 THEN
|
|
INSERT INTO `migrations` VALUES ('20260518063443');
|
|
-- Add your query below.
|
|
|
|
|
|
-- Fix order of waypoints for Mountaineer Kalmir.
|
|
DELETE FROM `creature_movement` WHERE `id`=8266;
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`, `path_id`) VALUES
|
|
(8266, 1, -6022.93, -2491.44, 309.861, 2.33874, 210000, 0, 0, 0),
|
|
(8266, 2, -6020.1, -2500.61, 309.054, 0, 0, 0, 0, 0),
|
|
(8266, 3, -6006.42, -2510.47, 308.054, 0, 0, 0, 0, 0),
|
|
(8266, 4, -5996.96, -2515.4, 308.102, 0, 0, 0, 0, 0),
|
|
(8266, 5, -5986.25, -2519.77, 307.977, 0, 0, 0, 0, 0),
|
|
(8266, 6, -5969.3, -2524.48, 307.977, 0, 0, 0, 0, 0),
|
|
(8266, 7, -5948.3, -2529.43, 308.009, 0, 0, 0, 0, 0),
|
|
(8266, 8, -5933.23, -2532.08, 307.639, 0, 0, 0, 0, 0),
|
|
(8266, 9, -5915.6, -2532.92, 307.389, 0, 0, 0, 0, 0),
|
|
(8266, 10, -5905.06, -2535.47, 307.122, 0, 0, 0, 0, 0),
|
|
(8266, 11, -5896.94, -2538.66, 307.201, 0, 0, 0, 0, 0),
|
|
(8266, 12, -5889.17, -2542.61, 307.326, 0, 0, 0, 0, 0),
|
|
(8266, 13, -5870.55, -2558.16, 307.326, 0, 0, 0, 0, 0),
|
|
(8266, 14, -5859.49, -2566.11, 308.434, 0, 0, 0, 0, 0),
|
|
(8266, 15, -5846.71, -2573.42, 309.873, 0, 0, 0, 0, 0),
|
|
(8266, 16, -5835.77, -2581.63, 311.248, 0, 0, 0, 0, 0),
|
|
(8266, 17, -5826.23, -2589.55, 312.487, 0, 0, 0, 0, 0),
|
|
(8266, 18, -5815.71, -2599.46, 314.112, 0, 0, 0, 0, 0),
|
|
(8266, 19, -5803.19, -2612.9, 317.146, 100, 150000, 0, 0, 0),
|
|
(8266, 20, -5818.31, -2596.83, 313.737, 0, 0, 0, 0, 0),
|
|
(8266, 21, -5832.67, -2584.36, 311.737, 0, 0, 0, 0, 0),
|
|
(8266, 22, -5840.37, -2577.5, 310.623, 0, 0, 0, 0, 0),
|
|
(8266, 23, -5860.45, -2565.25, 308.309, 0, 0, 0, 0, 0),
|
|
(8266, 24, -5870.4, -2558.15, 307.326, 0, 0, 0, 0, 0),
|
|
(8266, 25, -5880.91, -2549.04, 307.451, 0, 0, 0, 0, 0),
|
|
(8266, 26, -5890.77, -2542.17, 307.326, 0, 0, 0, 0, 0),
|
|
(8266, 27, -5898.68, -2537.93, 307.201, 0, 0, 0, 0, 0),
|
|
(8266, 28, -5905.8, -2535.37, 307.122, 0, 0, 0, 0, 0),
|
|
(8266, 29, -5918.47, -2532.91, 307.389, 0, 0, 0, 0, 0),
|
|
(8266, 30, -5931.82, -2532.19, 307.639, 0, 0, 0, 0, 0),
|
|
(8266, 31, -5943.23, -2530.59, 307.884, 0, 0, 0, 0, 0),
|
|
(8266, 32, -5958.02, -2527.77, 308.134, 0, 0, 0, 0, 0),
|
|
(8266, 33, -5971.92, -2524.21, 307.852, 0, 0, 0, 0, 0),
|
|
(8266, 34, -5985.28, -2520.41, 307.977, 0, 0, 0, 0, 0),
|
|
(8266, 35, -5999.92, -2514.3, 307.977, 0, 0, 0, 0, 0),
|
|
(8266, 36, -6010.38, -2507.41, 308.054, 0, 0, 0, 0, 0),
|
|
(8266, 37, -6018.31, -2501.65, 308.804, 0, 0, 0, 0, 0);
|
|
|
|
|
|
-- End of migration.
|
|
END IF;
|
|
END??
|
|
DELIMITER ;
|
|
CALL add_migration();
|
|
DROP PROCEDURE IF EXISTS add_migration;
|