75 lines
3.4 KiB
SQL
75 lines
3.4 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`='20231112194606');
|
|
IF v=0 THEN
|
|
INSERT INTO `migrations` VALUES ('20231112194606');
|
|
-- Add your query below.
|
|
|
|
|
|
-- Pathing for Vile Sting Entry: 5937
|
|
SET @NPC := 51823;
|
|
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-5832.868,`position_y`=-3577.47,`position_z`=-58.645027 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,-5832.868,-3577.47,-58.645027,100,0,0,0),
|
|
(@NPC,2,-5847.7896,-3578.9922,-58.62624,100,0,0,0),
|
|
(@NPC,3,-5879.2153,-3563.779,-58.624992,100,0,0,0),
|
|
(@NPC,4,-5898.626,-3563.8586,-58.624992,100,0,0,0),
|
|
(@NPC,5,-5906.1606,-3590.3938,-58.624973,100,0,0,0),
|
|
(@NPC,6,-5906.0674,-3606.6235,-58.624973,100,0,0,0),
|
|
(@NPC,7,-5923.0366,-3626.2664,-58.624973,100,0,0,0),
|
|
(@NPC,8,-5945.6016,-3613.887,-58.624954,100,0,0,0),
|
|
(@NPC,9,-5954.7524,-3608.444,-58.624954,100,0,0,0),
|
|
(@NPC,10,-5984.0244,-3598.608,-58.624954,100,0,0,0),
|
|
(@NPC,11,-6006.2593,-3598.7825,-58.624954,100,0,0,0),
|
|
(@NPC,12,-6013.32,-3605.1987,-58.624954,100,0,0,0),
|
|
(@NPC,13,-6023.108,-3620.3386,-58.624954,100,0,0,0),
|
|
(@NPC,14,-6046.9595,-3639.2556,-58.624954,100,0,0,0),
|
|
(@NPC,15,-6055.033,-3642.866,-58.624954,100,0,0,0),
|
|
(@NPC,16,-6074.136,-3629.934,-58.624954,100,0,0,0),
|
|
(@NPC,17,-6083.2944,-3613.5764,-58.624954,100,0,0,0),
|
|
(@NPC,18,-6096.364,-3598.897,-58.624954,100,0,0,0),
|
|
(@NPC,19,-6112.0825,-3584.047,-58.624954,100,0,0,0),
|
|
(@NPC,20,-6129.6,-3575.8818,-58.624954,100,0,0,0),
|
|
(@NPC,21,-6152.832,-3570.761,-58.624954,100,0,0,0),
|
|
(@NPC,22,-6167.849,-3571.4946,-58.624954,100,0,0,0),
|
|
(@NPC,23,-6176.987,-3576.321,-58.624954,100,0,0,0),
|
|
(@NPC,24,-6187.7524,-3589.2395,-58.624954,100,0,0,0),
|
|
(@NPC,25,-6186.82,-3620.595,-58.624954,100,0,0,0),
|
|
(@NPC,26,-6186.299,-3634.014,-58.624954,100,0,0,0),
|
|
(@NPC,27,-6171.7256,-3641.8333,-58.624954,100,0,0,0),
|
|
(@NPC,28,-6154.3394,-3651.0803,-58.624954,100,0,0,0),
|
|
(@NPC,29,-6141.6694,-3650.3577,-58.624954,100,0,0,0),
|
|
(@NPC,30,-6123.28,-3640.9934,-58.624954,100,0,0,0),
|
|
(@NPC,31,-6108.6865,-3623.8994,-58.624954,100,0,0,0),
|
|
(@NPC,32,-6099.0645,-3600.8455,-58.624954,100,0,0,0),
|
|
(@NPC,33,-6093.388,-3581.6519,-58.624954,100,0,0,0),
|
|
(@NPC,34,-6096.3926,-3568.4915,-58.624954,100,0,0,0),
|
|
(@NPC,35,-6062.2173,-3546.6702,-58.624966,100,0,0,0),
|
|
(@NPC,36,-6048.2134,-3538.829,-58.624966,100,0,0,0),
|
|
(@NPC,37,-6022.5835,-3531.2087,-58.624973,100,0,0,0),
|
|
(@NPC,38,-6007.369,-3528.1714,-58.624973,100,0,0,0),
|
|
(@NPC,39,-5996.6787,-3533.4485,-58.624973,100,0,0,0),
|
|
(@NPC,40,-5978.62,-3529.2083,-58.624973,100,0,0,0),
|
|
(@NPC,41,-5963.492,-3514.8665,-58.374992,100,0,0,0),
|
|
(@NPC,42,-5950.205,-3508.0159,-58.624992,100,0,0,0),
|
|
(@NPC,43,-5927.1836,-3500.981,-58.374992,100,0,0,0),
|
|
(@NPC,44,-5911.841,-3499.235,-58.158527,100,0,0,0),
|
|
(@NPC,45,-5883.246,-3499.5684,-58.080044,100,0,0,0),
|
|
(@NPC,46,-5858.184,-3506.1418,-58.24999,100,0,0,0),
|
|
(@NPC,47,-5847.03,-3516.6768,-58.49999,100,0,0,0),
|
|
(@NPC,48,-5833.535,-3534.1719,-58.62499,100,0,0,0),
|
|
(@NPC,49,-5827.3213,-3554.03,-58.62499,100,0,0,0);
|
|
-- 0x204CB0002005CC4000056900003C219D .go xyz -5832.868 -3577.47 -58.645027
|
|
|
|
|
|
-- End of migration.
|
|
END IF;
|
|
END??
|
|
delimiter ;
|
|
CALL add_migration();
|
|
DROP PROCEDURE IF EXISTS add_migration;
|