moonwell-core-vanilla/sql/migrations/20231111222109_world.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`='20231111222109');
IF v=0 THEN
INSERT INTO `migrations` VALUES ('20231111222109');
-- Add your query below.


-- Pathing for Anathemus Entry: 2754
SET @NPC := 27567;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-6876.906,`position_y`=-3514.3828,`position_z`=242.04547 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,-6876.906,-3514.3828,242.04547,100,0,0,0),
(@NPC,2,-6840.538,-3519.0667,241.79167,100,0,0,0),
(@NPC,3,-6820.1304,-3509.398,241.9436,100,0,0,0),
(@NPC,4,-6809.9346,-3487.4346,242.07185,100,0,0,0),
(@NPC,5,-6790.627,-3450.6472,241.79167,100,0,0,0),
(@NPC,6,-6759.354,-3422.3838,242.16667,100,0,0,0),
(@NPC,7,-6728.5444,-3389.7178,242.02257,100,0,0,0),
(@NPC,8,-6719.6704,-3352.6965,241.69453,100,0,0,0),
(@NPC,9,-6696.061,-3317.606,241.3291,100,0,0,0),
(@NPC,10,-6684.8213,-3284.0735,241.6626,100,0,0,0),
(@NPC,11,-6653.3384,-3279.8525,241.72363,100,0,0,0),
(@NPC,12,-6679.363,-3248.7168,240.8131,100,0,0,0),
(@NPC,13,-6712.4126,-3244.1365,240.85477,100,0,0,0),
(@NPC,14,-6739.8257,-3231.436,240.82924,100,0,0,0),
(@NPC,15,-6756.792,-3202.5115,240.86244,100,0,0,0),
(@NPC,16,-6766.203,-3176.1594,240.86865,100,0,0,0),
(@NPC,17,-6777.5215,-3145.0503,240.7666,100,0,0,0),
(@NPC,18,-6795.2954,-3123.2673,240.86526,100,0,0,0),
(@NPC,19,-6801.9766,-3096.6023,240.86865,100,0,0,0),
(@NPC,20,-6807.511,-3056.8308,241.74121,100,0,0,0),
(@NPC,21,-6822.888,-3011.4414,241.79167,100,0,0,0),
(@NPC,22,-6825.684,-2989.4001,242.91678,100,0,0,0),
(@NPC,23,-6842.297,-2982.216,244.27124,100,0,0,0),
(@NPC,24,-6861.3726,-2957.182,244.17899,100,0,0,0),
(@NPC,25,-6836.8813,-2934.417,243.85623,100,0,0,0),
(@NPC,26,-6819.379,-2895.1196,243.4576,100,0,0,0),
(@NPC,27,-6824.655,-2874.098,241.85579,100,0,0,0),
(@NPC,28,-6799.0176,-2865.9011,241.69374,100,0,0,0),
(@NPC,29,-6777.7173,-2853.8625,242.76283,100,0,0,0),
(@NPC,30,-6769.924,-2834.0032,243.2162,100,0,0,0),
(@NPC,31,-6764.0596,-2805.0393,242.24786,100,0,0,0),
(@NPC,32,-6779.0684,-2774.1848,242.61589,100,0,0,0),
(@NPC,33,-6781.791,-2740.3145,241.79167,100,0,0,0),
(@NPC,34,-6779.1123,-2695.4597,241.726,100,0,0,0),
(@NPC,35,-6784.9126,-2650.4187,241.74365,100,0,0,0),
(@NPC,36,-6807.5605,-2624.9778,241.30371,100,0,0,0),
(@NPC,37,-6827.269,-2592.6594,240.86865,100,0,0,0),
(@NPC,38,-6844.815,-2578.7808,240.8131,100,0,0,0),
(@NPC,39,-6857.979,-2562.3765,240.85477,100,0,0,0),
(@NPC,40,-6872.1426,-2557.7024,240.86865,100,0,0,0),
(@NPC,41,-6889.7725,-2553.7603,241.74365,100,0,0,0),
(@NPC,42,-6917.392,-2537.756,242.26831,100,0,0,0),
(@NPC,43,-6934.6597,-2529.4036,241.74365,100,0,0,0),
(@NPC,44,-6950.297,-2523.527,241.74365,100,0,0,0),
(@NPC,45,-6981.097,-2519.09,241.79167,100,0,0,0),
(@NPC,46,-7009.0293,-2539.828,242.31013,100,0,0,0),
(@NPC,47,-7015.1914,-2518.0957,244.68259,100,0,0,0),
(@NPC,48,-7033.1685,-2482.8367,241.79167,100,0,0,0),
(@NPC,49,-7034.4004,-2453.5674,242.72307,100,0,0,0),
(@NPC,50,-7033.284,-2433.064,241.68245,100,0,0,0),
(@NPC,51,-7048.4126,-2405.5105,241.68245,100,0,0,0),
(@NPC,52,-7077.315,-2374.6147,240.42804,100,0,0,0),
(@NPC,53,-7109.834,-2356.9102,241.85072,100,0,0,0),
(@NPC,54,-7129.069,-2356.5767,240.10072,100,0,0,0),
(@NPC,55,-7149.244,-2362.0757,241.71579,100,0,0,0),
(@NPC,56,-7168.445,-2381.1047,241.64453,100,0,0,0),
(@NPC,57,-7187.0464,-2404.4626,241.5232,100,0,0,0),
(@NPC,58,-7200.161,-2430.0042,243.65074,100,0,0,0),
(@NPC,59,-7207.571,-2450.6396,246.86716,100,0,0,0),
(@NPC,60,-7202.877,-2483.1697,247.73312,100,0,0,0),
(@NPC,61,-7193.0054,-2517.404,248.81508,100,0,0,0),
(@NPC,62,-7192.43,-2550.0535,246.79889,100,0,0,0),
(@NPC,63,-7186.208,-2585.835,246.12538,100,0,0,0),
(@NPC,64,-7179.0435,-2621.246,246.74574,100,0,0,0),
(@NPC,65,-7154.533,-2643.925,245.19295,100,0,0,0),
(@NPC,66,-7121.818,-2676.2449,241.79167,100,0,0,0),
(@NPC,67,-7104.3364,-2706.8499,241.72318,100,0,0,0),
(@NPC,68,-7091.729,-2748.7837,242.54167,100,0,0,0),
(@NPC,69,-7085.973,-2775.0208,243.60188,100,0,0,0),
(@NPC,70,-7083.9697,-2806.5703,241.79207,100,0,0,0),
(@NPC,71,-7083.387,-2824.21,243.06575,100,0,0,0),
(@NPC,72,-7057.346,-2856.3606,242.1274,100,0,0,0),
(@NPC,73,-7054.114,-2886.03,241.74577,100,0,0,0),
(@NPC,74,-7058.2007,-2906.9016,242.2133,100,0,0,0),
(@NPC,75,-7069.0845,-2933.9062,243.74797,100,0,0,0),
(@NPC,76,-7070.8027,-2973.9062,242.79167,100,0,0,0),
(@NPC,77,-7058.212,-2994.9126,241.79167,100,0,0,0),
(@NPC,78,-7049.141,-3009.2012,241.86446,100,0,0,0),
(@NPC,79,-7058.6074,-3058.3674,241.69846,100,0,0,0),
(@NPC,80,-7077.5615,-3082.076,241.79167,100,0,0,0),
(@NPC,81,-7090.248,-3126.3665,242.184,100,0,0,0),
(@NPC,82,-7085.412,-3159.2393,241.79167,100,0,0,0),
(@NPC,83,-7088.785,-3202.677,241.90788,100,0,0,0),
(@NPC,84,-7090.78,-3213.9644,241.79167,100,0,0,0),
(@NPC,85,-7107.1284,-3250.8547,245.49672,100,0,0,0),
(@NPC,86,-7115.118,-3290.8623,244.65096,100,0,0,0),
(@NPC,87,-7117.981,-3321.8906,242.84285,100,0,0,0),
(@NPC,88,-7118.0645,-3353.3633,242.87701,100,0,0,0),
(@NPC,89,-7112.9746,-3371.7947,242.96481,100,0,0,0),
(@NPC,90,-7103.7266,-3395.1125,242.58005,100,0,0,0),
(@NPC,91,-7089.353,-3415.3235,243.0332,100,0,0,0),
(@NPC,92,-7084.7515,-3428.7317,242.8164,100,0,0,0),
(@NPC,93,-7068.982,-3448.2668,244.56194,100,0,0,0),
(@NPC,94,-7048.892,-3462.0168,243.70259,100,0,0,0),
(@NPC,95,-7035.1353,-3478.6104,241.99422,100,0,0,0),
(@NPC,96,-7025.451,-3493.6187,241.79167,100,0,0,0),
(@NPC,97,-7011.8403,-3501.5898,242.41982,100,0,0,0),
(@NPC,98,-6969.4775,-3520.751,241.79167,100,0,0,0),
(@NPC,99,-6939.8613,-3516.1226,241.79167,100,0,0,0),
(@NPC,100,-6916.998,-3518.6948,242.41667,100,0,0,0);
-- 0x204CB0000002B080000013000039BB3C .go xyz -6876.906 -3514.3828 242.04547


-- End of migration.
END IF;
END??
delimiter ; 
CALL add_migration();
DROP PROCEDURE IF EXISTS add_migration;