Files
moonwell-core-vanilla/sql/migrations/20250205220436_world.sql

84 lines
3.8 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`='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;