From e5f8202adf33478083f686794da33b7af917366a Mon Sep 17 00:00:00 2001 From: Daribon Date: Wed, 5 Feb 2025 23:05:30 +0100 Subject: [PATCH] Add correct waypoints for Warsong Outrider. --- sql/migrations/20250205220436_world.sql | 83 +++++++++++++++++++++++++ 1 file changed, 83 insertions(+) create mode 100644 sql/migrations/20250205220436_world.sql diff --git a/sql/migrations/20250205220436_world.sql b/sql/migrations/20250205220436_world.sql new file mode 100644 index 00000000000..5ec5aae21f3 --- /dev/null +++ b/sql/migrations/20250205220436_world.sql @@ -0,0 +1,83 @@ +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`='20250205220436'); +IF v = 0 THEN +INSERT INTO `migrations` VALUES ('20250205220436'); +-- Add your query below. + + +-- Pathing for Warsong Outrider Entry: 12864 +SET @NPC := 52348; +UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=2526.8582,`position_y`=-2817.9739,`position_z`=158.47528 WHERE `guid`=@NPC; +DELETE FROM `creature_movement` WHERE `id`=@NPC; +INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES +(@NPC,1,2526.8582,-2817.9739,158.47528,100,500,0,0), +(@NPC,2,2540.766,-2842.0305,158.76918,100,0,0,0), +(@NPC,3,2545.9739,-2881.4832,159.93704,100,0,0,0), +(@NPC,4,2547.2024,-2909.2507,160.65646,100,0,0,0), +(@NPC,5,2561.121,-2944.6003,160.71104,100,0,0,0), +(@NPC,6,2570.664,-2966.118,160.94241,100,0,0,0), +(@NPC,7,2583.3774,-2983.5793,161.02318,100,0,0,0), +(@NPC,8,2606.161,-3008.301,161.01553,100,0,0,0), +(@NPC,9,2628.309,-3032.5183,160.96677,100,0,0,0), +(@NPC,10,2644.6921,-3052.551,160.94405,100,0,0,0), +(@NPC,11,2670.138,-3084.3665,160.54523,100,0,0,0), +(@NPC,12,2691.5747,-3118.9158,158.34998,100,0,0,0), +(@NPC,13,2709.9124,-3162.228,155.40817,100,0,0,0), +(@NPC,14,2724.1768,-3196.505,150.26207,100,0,0,0), +(@NPC,15,2731.0337,-3234.6477,143.83606,100,0,0,0), +(@NPC,16,2735.6064,-3260.1433,139.50423,100,0,0,0), +(@NPC,17,2739.5166,-3287.8691,134.18207,100,0,0,0), +(@NPC,18,2751.0486,-3332.722,128.75993,100,0,0,0), +(@NPC,19,2765.7734,-3372.0156,125.371155,100,0,0,0), +(@NPC,20,2783.2122,-3405.1013,118.3583,100,0,0,0), +(@NPC,21,2804.1604,-3432.5493,114.457634,100,0,0,0), +(@NPC,22,2832.3386,-3471.6987,111.19728,100,0,0,0), +(@NPC,23,2855.4336,-3502.9731,106.7065,100,0,0,0), +(@NPC,24,2875.1675,-3536.3335,102.57702,100,0,0,0), +(@NPC,25,2889.254,-3572.0205,98.290695,100,0,0,0), +(@NPC,26,2888.6672,-3611.5266,95.19931,100,0,0,0), +(@NPC,27,2885.1162,-3647.2708,94.62988,100,0,0,0), +(@NPC,28,2877.6182,-3677.461,93.44174,100,0,0,0), +(@NPC,29,2864.4346,-3710.9297,89.09955,100,0,0,0), +(@NPC,30,2841.7183,-3754.8047,82.044014,100,500,0,0), +(@NPC,31,2864.3906,-3711.0808,89.11301,100,0,0,0), +(@NPC,32,2877.6182,-3677.461,93.44174,100,0,0,0), +(@NPC,33,2885.1162,-3647.2708,94.62988,100,0,0,0), +(@NPC,34,2888.6672,-3611.5266,95.19931,100,0,0,0), +(@NPC,35,2889.254,-3572.0205,98.290695,100,0,0,0), +(@NPC,36,2875.1675,-3536.3335,102.57702,100,0,0,0), +(@NPC,37,2855.4336,-3502.9731,106.7065,100,0,0,0), +(@NPC,38,2832.3386,-3471.6987,111.19728,100,0,0,0), +(@NPC,39,2804.1604,-3432.5493,114.457634,100,0,0,0), +(@NPC,40,2783.2122,-3405.1013,118.3583,100,0,0,0), +(@NPC,41,2765.8293,-3372.1438,125.43472,100,0,0,0), +(@NPC,42,2751.1045,-3332.8516,128.70139,100,0,0,0), +(@NPC,43,2739.5354,-3287.977,134.21512,100,0,0,0), +(@NPC,44,2735.625,-3260.25,139.58159,100,0,0,0), +(@NPC,45,2731.0337,-3234.6477,143.83606,100,0,0,0), +(@NPC,46,2724.1768,-3196.505,150.26207,100,0,0,0), +(@NPC,47,2709.9766,-3162.3242,155.43712,100,0,0,0), +(@NPC,48,2691.5747,-3118.9158,158.34998,100,0,0,0), +(@NPC,49,2670.138,-3084.3665,160.54523,100,0,0,0), +(@NPC,50,2644.6921,-3052.551,160.94405,100,0,0,0), +(@NPC,51,2628.309,-3032.5183,160.96677,100,0,0,0), +(@NPC,52,2606.161,-3008.301,161.01553,100,0,0,0), +(@NPC,53,2583.3774,-2983.5793,161.02318,100,0,0,0), +(@NPC,54,2570.664,-2966.118,160.94241,100,0,0,0), +(@NPC,55,2561.121,-2944.6003,160.71104,100,0,0,0), +(@NPC,56,2547.2024,-2909.2507,160.65646,100,0,0,0), +(@NPC,57,2545.9739,-2881.4832,159.93704,100,0,0,0), +(@NPC,58,2540.766,-2842.0305,158.76918,100,0,0,0); +-- 0x20566000200C9000000051000052F218 .go xyz 2526.8582 -2817.9739 158.47528 + + +-- End of migration. +END IF; +END?? +DELIMITER ; +CALL add_migration(); +DROP PROCEDURE IF EXISTS add_migration;