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

42 lines
1.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`='20250205213703');
IF v = 0 THEN
INSERT INTO `migrations` VALUES ('20250205213703');
-- Add your query below.
-- Pathing for Tenell Leafrunner Entry: 10923
SET @NPC := 39102;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=3909.6858,`position_y`=-1266.3507,`position_z`=223.739 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,3909.6858,-1266.3507,223.739,100,500,0,0),
(@NPC,2,3916.3025,-1269.1881,223.80756,100,0,0,0),
(@NPC,3,3928.731,-1274.601,225.03976,100,0,0,0),
(@NPC,4,3938.7578,-1280.9681,226.99359,100,0,0,0),
(@NPC,5,3947.347,-1284.8043,229.73364,100,0,0,0),
(@NPC,6,3955.0986,-1285.6556,232.99527,100,0,0,0),
(@NPC,7,3961.6082,-1286.5798,236.43521,100,0,0,0),
(@NPC,8,3967.5051,-1289.9736,239.88536,100,0,0,0),
(@NPC,9,3972.9426,-1293.2542,243.07068,100,500,0,0),
(@NPC,10,3967.5051,-1289.9736,239.88536,100,0,0,0),
(@NPC,11,3961.6082,-1286.5798,236.43521,100,0,0,0),
(@NPC,12,3955.0986,-1285.6556,232.99527,100,0,0,0),
(@NPC,13,3947.347,-1284.8043,229.73364,100,0,0,0),
(@NPC,14,3938.7578,-1280.9681,226.99359,100,0,0,0),
(@NPC,15,3928.731,-1274.601,225.03976,100,0,0,0),
(@NPC,16,3916.3025,-1269.1881,223.80756,100,0,0,0);
-- 0x20566000200AAAC000004D000052F217 .go xyz 3909.6858 -1266.3507 223.739
-- End of migration.
END IF;
END??
DELIMITER ;
CALL add_migration();
DROP PROCEDURE IF EXISTS add_migration;