42 lines
1.7 KiB
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;
|