Files
moonwell-core-vanilla/sql/migrations/20231110235622_world.sql
2023-11-18 07:43:22 +02:00

59 lines
2.6 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`='20231110235622');
IF v=0 THEN
INSERT INTO `migrations` VALUES ('20231110235622');
-- Add your query below.
-- Pathing for Lady Zephris Entry: 14277
-- https://www.youtube.com/watch?v=GAzEaEKKtgU&t=6027s
SET @NPC := 16047;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-1473.6924,`position_y`=-1099.3652,`position_z`=-4.3176775 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,-1473.6924,-1099.3652,-4.3176775,100,0,0,0),
(@NPC,2,-1478.4865,-1077.9651,-6.023244,100,0,0,0),
(@NPC,3,-1460.6696,-1051.921,-7.36767,100,0,0,0),
(@NPC,4,-1427.7164,-1040.4044,-2.0780458,100,0,0,0),
(@NPC,5,-1397.5704,-1032.105,-1.5046282,100,0,0,0),
(@NPC,6,-1359.5472,-1021.6162,-1.1081097,100,0,0,0),
(@NPC,7,-1318.3431,-1009.285,-1.7393727,100,0,0,0),
(@NPC,8,-1293.9735,-994.2434,-0.91534543,100,0,0,0),
(@NPC,9,-1279.4846,-972.2039,-1.0127575,100,0,0,0),
(@NPC,10,-1259.8593,-943.91235,0.43451452,100,0,0,0),
(@NPC,11,-1245.7662,-916.38556,0.21085262,100,0,0,0),
(@NPC,12,-1230.8981,-889.93195,-0.2990613,100,0,0,0),
(@NPC,13,-1202.3557,-861.0522,0.1274085,100,0,0,0),
(@NPC,14,-1181.9938,-838.1403,-0.07147527,100,0,0,0),
(@NPC,15,-1155.6682,-812.21387,0.00438118,100,0,0,0),
(@NPC,16,-1135.0479,-793.8221,0.73909044,100,0,0,0),
(@NPC,17,-1101.6415,-791.8814,-0.24045515,100,0,0,0),
(@NPC,18,-1135.0479,-793.8221,0.73909044,100,0,0,0),
(@NPC,19,-1155.6682,-812.21387,0.00438118,100,0,0,0),
(@NPC,20,-1181.9938,-838.1403,-0.07147527,100,0,0,0),
(@NPC,21,-1202.3557,-861.0522,0.1274085,100,0,0,0),
(@NPC,22,-1230.8981,-889.93195,-0.2990613,100,0,0,0),
(@NPC,23,-1245.7662,-916.38556,0.21085262,100,0,0,0),
(@NPC,24,-1259.8593,-943.91235,0.43451452,100,0,0,0),
(@NPC,25,-1279.4846,-972.2039,-1.0127575,100,0,0,0),
(@NPC,26,-1293.9735,-994.2434,-0.91534543,100,0,0,0),
(@NPC,27,-1318.3431,-1009.285,-1.7393727,100,0,0,0),
(@NPC,28,-1359.5472,-1021.6162,-1.1081097,100,0,0,0),
(@NPC,29,-1397.5704,-1032.105,-1.5046282,100,0,0,0),
(@NPC,30,-1427.7164,-1040.4044,-2.0780458,100,0,0,0),
(@NPC,31,-1460.6696,-1051.921,-7.36767,100,0,0,0),
(@NPC,32,-1478.4865,-1077.9651,-6.023244,100,0,0,0);
-- 0x204CB000000DF140000007000039B364 .go xyz -1473.6924 -1099.3652 -4.3176775
-- End of migration.
END IF;
END??
delimiter ;
CALL add_migration();
DROP PROCEDURE IF EXISTS add_migration;