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


-- Correct Horde Guard spawns in Camp Taurajo
-- Remove waypoints and set co2 spawn for Horde Guard near mailbox
UPDATE `creature` SET `wander_distance`=5,`movement_type`=1,`position_x`=-2351.38427734375,`position_y`=-1949.239990234375,`position_z`=95.94014739990234375, `orientation`=4.298455715179443359 WHERE `guid`=19385;
DELETE FROM `creature_movement` WHERE `id`=193585;
-- Set co2 spawn and update wander distance
UPDATE `creature` SET `wander_distance`=5,`movement_type`=1,`position_x`=-2302.7001953125,`position_y`=-1985.91845703125,`position_z`=94.2811279296875, `orientation`=1.191323757171630859 WHERE `guid`=19379;
-- Set co2 spawn and update wander distance
UPDATE `creature` SET `wander_distance`=5,`movement_type`=1,`position_x`=-2331.15087890625,`position_y`=-2005.046875,`position_z`=96.18682861328125, `orientation`=4.268116950988769531 WHERE `guid`=19357;

-- Pathing for Horde Guard Entry: 3501
SET @NPC := 19362;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-478.12756,`position_y`=-2696.8027,`position_z`=95.22583 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,-478.12756,-2696.8027,95.22583,100,0,0,0),
(@NPC,2,-473.3291,-2690.0833,95.55884,100,0,0,0),
(@NPC,3,-470.67627,-2685.7786,95.579315,100,0,0,0),
(@NPC,4,-467.0397,-2679.627,95.58475,100,0,0,0),
(@NPC,5,-464.33292,-2674.8772,95.60349,100,0,0,0),
(@NPC,6,-461.5956,-2669.5435,95.46922,100,0,0,0),
(@NPC,7,-460.47614,-2663.7903,95.539276,100,0,0,0),
(@NPC,8,-460.37164,-2659.5298,95.60132,100,0,0,0),
(@NPC,9,-460.25006,-2654.547,95.70298,100,0,0,0),
(@NPC,10,-459.1114,-2652.0808,95.64264,100,0,0,0),
(@NPC,11,-456.01938,-2650.1694,95.50108,100,0,0,0),
(@NPC,12,-453.56693,-2649.9846,95.47043,100,0,0,0),
(@NPC,13,-448.99988,-2654.2002,95.56348,100,0,0,0),
(@NPC,14,-446.13144,-2659.3333,95.58326,100,0,0,0),
(@NPC,15,-442.95544,-2664.193,95.60261,100,0,0,0),
(@NPC,16,-438.828,-2669.2935,95.782684,100,0,0,0),
(@NPC,17,-432.41022,-2674.375,95.82079,100,0,0,0),
(@NPC,18,-426.58096,-2676.1921,95.67903,100,0,0,0),
(@NPC,19,-411.23288,-2678.5117,95.62643,100,0,0,0),
(@NPC,20,-399.44904,-2679.5442,95.635506,100,0,0,0),
(@NPC,21,-389.18805,-2679.6633,95.745316,100,0,0,0),
(@NPC,22,-374.1944,-2679.7373,95.823586,100,0,0,0),
(@NPC,23,-371.32965,-2682.4368,95.823586,100,0,0,0),
(@NPC,24,-379.93033,-2681.6719,95.768616,100,0,0,0),
(@NPC,25,-389.37076,-2680.5754,95.76187,100,0,0,0),
(@NPC,26,-404.42636,-2679.8027,95.583015,100,0,0,0),
(@NPC,27,-413.5514,-2678.4329,95.66014,100,0,0,0),
(@NPC,28,-422.9829,-2677.0183,95.70952,100,0,0,0),
(@NPC,29,-436.03223,-2672.7202,95.86464,100,0,0,0),
(@NPC,30,-442.52737,-2666.1133,95.623856,100,0,0,0),
(@NPC,31,-448.37555,-2656.4756,95.570984,100,0,0,0),
(@NPC,32,-454.06595,-2653.7769,95.64012,100,0,0,0),
(@NPC,33,-461.11356,-2651.4731,95.66539,100,0,0,0),
(@NPC,34,-468.13785,-2650.6287,95.56515,100,0,0,0),
(@NPC,35,-479.75613,-2651.9854,95.72882,100,0,0,0),
(@NPC,36,-493.58084,-2653.502,95.80476,100,0,0,0),
(@NPC,37,-505.1935,-2654.4753,95.54703,100,0,0,0),
(@NPC,38,-514.5447,-2654.2454,95.506645,100,0,0,0),
(@NPC,39,-523.8786,-2653.3635,95.614136,100,0,0,0),
(@NPC,40,-530.3094,-2653.5288,95.71179,100,0,0,0),
(@NPC,41,-545.59766,-2653.4062,95.54569,100,0,0,0),
(@NPC,42,-556.0206,-2653.3486,95.54418,100,0,0,0),
(@NPC,43,-542.4315,-2652.444,95.60315,100,0,0,0),
(@NPC,44,-533.1839,-2653.4321,95.67679,100,0,0,0),
(@NPC,45,-522.7951,-2653.7834,95.554855,100,0,0,0),
(@NPC,46,-512.3304,-2653.7556,95.5638,100,0,0,0),
(@NPC,47,-500.15543,-2654.2065,95.60589,100,0,0,0),
(@NPC,48,-489.84793,-2653.919,95.88697,100,0,0,0),
(@NPC,49,-479.96735,-2651.9575,95.73096,100,0,0,0),
(@NPC,50,-468.40518,-2649.9524,95.547424,100,0,0,0),
(@NPC,51,-460.01672,-2647.7314,95.62808,100,0,0,0),
(@NPC,52,-455.14935,-2644.9475,95.570526,100,0,0,0),
(@NPC,53,-446.6304,-2635.4363,95.47058,100,0,0,0),
(@NPC,54,-443.3464,-2629.744,95.499016,100,0,0,0),
(@NPC,55,-436.6126,-2622.8972,95.51384,100,0,0,0),
(@NPC,56,-427.22635,-2614.2725,95.637115,100,0,0,0),
(@NPC,57,-421.7624,-2610.4324,95.686035,100,0,0,0),
(@NPC,58,-413.2547,-2603.049,95.696335,100,0,0,0),
(@NPC,59,-406.6516,-2594.3374,95.77803,100,0,0,0),
(@NPC,60,-400.36624,-2587.7107,95.771835,100,0,0,0),
(@NPC,61,-388.71634,-2577.1292,95.62767,100,0,0,0),
(@NPC,62,-382.73807,-2570.0928,95.737236,100,0,0,0),
(@NPC,63,-373.62616,-2559.0913,95.758255,100,0,0,0),
(@NPC,64,-365.175,-2548.7996,95.692444,100,0,0,0),
(@NPC,65,-357.87302,-2537.294,95.70286,100,0,0,0),
(@NPC,66,-353.51315,-2526.4304,95.6944,100,0,0,0),
(@NPC,67,-347.58673,-2509.6516,94.79089,100,0,0,0),
(@NPC,68,-350.73862,-2520.7893,95.44385,100,0,0,0),
(@NPC,69,-352.89932,-2529.2275,95.74251,100,0,0,0),
(@NPC,70,-356.4977,-2538.373,95.69266,100,0,0,0),
(@NPC,71,-362.6343,-2546.3608,95.71392,100,0,0,0),
(@NPC,72,-368.7768,-2553.8296,95.74439,100,0,0,0),
(@NPC,73,-376.91226,-2563.5105,95.737076,100,0,0,0),
(@NPC,74,-384.22964,-2571.7805,95.69521,100,0,0,0),
(@NPC,75,-395.81604,-2583.5427,95.70881,100,0,0,0),
(@NPC,76,-403.50742,-2590.6511,95.80324,100,0,0,0),
(@NPC,77,-413.21597,-2602.3057,95.701004,100,0,0,0),
(@NPC,78,-422.8308,-2611.8394,95.66372,100,0,0,0),
(@NPC,79,-426.37466,-2615.1477,95.63547,100,0,0,0),
(@NPC,80,-435.59683,-2626.752,95.59421,100,0,0,0),
(@NPC,81,-441.53775,-2629.5007,95.51355,100,0,0,0),
(@NPC,82,-447.18985,-2635.6013,95.46695,100,0,0,0),
(@NPC,83,-450.06757,-2641.5447,95.52036,100,0,0,0),
(@NPC,84,-454.3317,-2647.8918,95.459915,100,0,0,0),
(@NPC,85,-456.02652,-2651.0752,95.54039,100,0,0,0),
(@NPC,86,-460.99908,-2661.7805,95.59456,100,0,0,0),
(@NPC,87,-459.93625,-2665.6665,95.49159,100,0,0,0),
(@NPC,88,-462.00684,-2672.625,95.46988,100,0,0,0),
(@NPC,89,-469.1162,-2682.7058,95.54627,100,0,0,0),
(@NPC,90,-474.36887,-2690.4858,95.52333,100,0,0,0);
-- 0x2056600020036B4000003800025D1833 .go xyz -478.12756 -2696.8027 95.22583

-- Pathing for Horde Guard Entry: 3501
SET @NPC := 19414;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-351.41,`position_y`=-2520.7336,`position_z`=95.451324 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,-351.41,-2520.7336,95.451324,100,0,0,0),
(@NPC,2,-360.41614,-2542.235,95.73902,100,0,0,0),
(@NPC,3,-373.89252,-2561.6462,95.757515,100,0,0,0),
(@NPC,4,-390.64453,-2581.5322,95.66315,100,0,0,0),
(@NPC,5,-402.92282,-2594.762,95.79342,100,0,0,0),
(@NPC,6,-411.43463,-2604.0122,95.72727,100,0,0,0),
(@NPC,7,-422.20673,-2614.5188,95.63039,100,0,0,0),
(@NPC,8,-431.06607,-2623.018,95.614624,100,0,0,0),
(@NPC,9,-438.15,-2630.1653,95.59786,100,0,0,0),
(@NPC,10,-450.4003,-2643.2883,95.52829,100,0,0,0),
(@NPC,11,-449.92905,-2650.0103,95.60747,100,0,0,0),
(@NPC,12,-444.56345,-2657.2156,95.63224,100,0,0,0),
(@NPC,13,-439.80362,-2663.7222,95.71268,100,0,0,0),
(@NPC,14,-431.80185,-2670.2126,95.79143,100,0,0,0),
(@NPC,15,-419.9325,-2674.647,95.6751,100,0,0,0),
(@NPC,16,-407.50784,-2675.8652,95.60104,100,0,0,0),
(@NPC,17,-395.31046,-2676.8843,95.71818,100,0,0,0),
(@NPC,18,-387.00748,-2677.529,95.77024,100,0,0,0),
(@NPC,19,-373.4648,-2677.129,95.823586,100,0,0,0),
(@NPC,20,-363.8787,-2676.2014,95.72801,100,0,0,0),
(@NPC,21,-348.52966,-2675.372,95.82634,100,0,0,0),
(@NPC,22,-349.67313,-2681.1184,95.988884,100,0,0,0),
(@NPC,23,-358.94083,-2682.5085,95.79265,100,0,0,0),
(@NPC,24,-369.13458,-2684.972,95.832184,100,0,0,0),
(@NPC,25,-378.15396,-2685.5122,95.823586,100,0,0,0),
(@NPC,26,-390.74313,-2686.612,96.01384,100,0,0,0),
(@NPC,27,-398.80542,-2686.1924,95.85932,100,0,0,0),
(@NPC,28,-408.12833,-2685.0093,95.80194,100,0,0,0),
(@NPC,29,-421.94913,-2681.011,95.71943,100,0,0,0),
(@NPC,30,-427.8114,-2680.476,95.80564,100,0,0,0),
(@NPC,31,-433.06653,-2678.997,95.96336,100,0,0,0),
(@NPC,32,-438.38354,-2677.369,96.22792,100,0,0,0),
(@NPC,33,-443.02396,-2672.2053,96.06619,100,0,0,0),
(@NPC,34,-445.8046,-2666.9094,95.74715,100,0,0,0),
(@NPC,35,-449.5125,-2659.0715,95.60512,100,0,0,0),
(@NPC,36,-451.56702,-2655.4624,95.64741,100,0,0,0),
(@NPC,37,-461.7869,-2653.5793,95.71263,100,0,0,0),
(@NPC,38,-470.93256,-2653.316,95.61221,100,0,0,0),
(@NPC,39,-476.85345,-2654.5613,95.71973,100,0,0,0),
(@NPC,40,-486.59808,-2657.5496,96.14763,100,0,0,0),
(@NPC,41,-495.88956,-2658.1567,96.070885,100,0,0,0),
(@NPC,42,-504.72278,-2658.7622,95.8618,100,0,0,0),
(@NPC,43,-510.1328,-2658.1497,95.71443,100,0,0,0),
(@NPC,44,-516.5678,-2657.3203,95.59792,100,0,0,0),
(@NPC,45,-524.912,-2657.0222,95.69075,100,0,0,0),
(@NPC,46,-534.1009,-2656.3052,95.69655,100,0,0,0),
(@NPC,47,-544.25775,-2656.3035,95.62694,100,0,0,0),
(@NPC,48,-551.084,-2655.9805,95.643425,100,0,0,0),
(@NPC,49,-553.1856,-2653.428,95.56938,100,0,0,0),
(@NPC,50,-546.40155,-2650.97,95.62564,100,0,0,0),
(@NPC,51,-533.15656,-2651.632,95.712006,100,0,0,0),
(@NPC,52,-522.8734,-2652.349,95.616356,100,0,0,0),
(@NPC,53,-503.56186,-2651.9895,95.635765,100,0,0,0),
(@NPC,54,-487.55475,-2651.3833,95.84709,100,0,0,0),
(@NPC,55,-480.69357,-2649.464,95.76905,100,0,0,0),
(@NPC,56,-467.7797,-2646.921,95.658775,100,0,0,0),
(@NPC,57,-459.76297,-2643.5847,95.76921,100,0,0,0),
(@NPC,58,-449.80814,-2637.173,95.45007,100,0,0,0),
(@NPC,59,-443.39005,-2625.7268,95.564476,100,0,0,0),
(@NPC,60,-432.1683,-2615.4097,95.67137,100,0,0,0),
(@NPC,61,-419.06418,-2605.6611,95.69777,100,0,0,0),
(@NPC,62,-406.21146,-2590.1692,95.85406,100,0,0,0),
(@NPC,63,-392.41595,-2575.6814,95.746895,100,0,0,0),
(@NPC,64,-372.08267,-2552.102,95.777466,100,0,0,0),
(@NPC,65,-361.61728,-2538.2969,95.75893,100,0,0,0);
-- 0x2056600020036B4000003800005D1834 .go xyz -351.41 -2520.7336 95.451324


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