sindoring/moonwell-core-vanilla
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
Files
development
moonwell-core-vanilla/sql/migrations/20231017191618_world.sql
T
Daribon abc6da573b Correct misc waypoints and spawns. (#2233)
2023-10-18 11:04:06 +03:00

789 lines
41 KiB
SQL
Raw Permalink Blame History

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`='20231017191618');
IF v=0 THEN
INSERT INTO `migrations` VALUES ('20231017191618');
-- Add your query below.
-- Pathing for Meggi Peppinrocker Entry: 11754
SET @NPC := 42312;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=6712.424,`position_y`=-4694.905,`position_z`=721.4019 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,6712.424,-4694.905,721.4019,100,0,0,0),
(@NPC,2,6721.999,-4669.791,720.9736,100,0,0,0),
(@NPC,3,6745.51,-4669.717,722.9445,100,0,0,0),
(@NPC,4,6757.705,-4671.697,723.9316,100,0,0,0),
(@NPC,5,6745.629,-4669.687,723.0085,100,0,0,0),
(@NPC,6,6721.999,-4669.791,720.9736,100,0,0,0),
(@NPC,7,6712.424,-4694.905,721.4019,100,0,0,0),
(@NPC,8,6720.713,-4657.241,720.9419,100,0,0,0),
(@NPC,9,6727.289,-4634.758,721.0771,100,0,0,0),
(@NPC,10,6726.451,-4618.407,721.0268,100,0,0,0),
(@NPC,11,6727.289,-4634.758,721.0771,100,0,0,0),
(@NPC,12,6720.713,-4657.241,720.9419,100,0,0,0);
-- .go xyz 6712.424 -4694.905 721.4019
-- Pathing for Gadgetzan Bruiser Entry: 9460
SET @NPC := 23574;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-7176.78,`position_y`=-3786.48,`position_z`=8.45713, `orientation`=1.37062 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,-7176.066,-3782.855,8.494802,100,0,0,0),
(@NPC,2,-7174.341,-3774.461,8.494802,100,0,0,0),
(@NPC,3,-7168.987,-3765.671,8.4948,100,0,0,0),
(@NPC,4,-7161.991,-3755.583,8.470134,100,0,0,0),
(@NPC,5,-7155.807,-3750.344,8.470134,100,0,0,0),
(@NPC,6,-7146.562,-3744.295,8.470134,100,0,0,0),
(@NPC,7,-7138.168,-3741.932,8.470134,100,0,0,0),
(@NPC,8,-7131.735,-3742.635,8.456431,100,0,0,0),
(@NPC,9,-7127.003,-3743.257,8.456431,100,0,0,0),
(@NPC,10,-7117.987,-3749.063,8.456431,100,0,0,0),
(@NPC,11,-7112.508,-3755.256,8.456431,100,0,0,0),
(@NPC,12,-7109.489,-3763.145,8.456431,100,0,0,0),
(@NPC,13,-7108.184,-3776.282,8.619409,100,0,0,0),
(@NPC,14,-7107.608,-3786.073,8.494409,100,0,0,0),
(@NPC,15,-7110.442,-3799.096,8.494409,100,0,0,0),
(@NPC,16,-7113.263,-3806.811,8.494409,100,0,0,0),
(@NPC,17,-7118.754,-3819.464,8.494409,100,0,0,0),
(@NPC,18,-7128.461,-3824.538,8.494409,100,0,0,0),
(@NPC,19,-7134.276,-3825.595,8.494802,100,0,0,0),
(@NPC,20,-7144.804,-3827.123,8.494802,100,0,0,0),
(@NPC,21,-7154.484,-3823.713,8.494802,100,0,0,0),
(@NPC,22,-7166.102,-3813.337,8.494802,100,0,0,0),
(@NPC,23,-7174.249,-3797.551,8.494802,100,0,0,0);
-- .go xyz -7176.066 -3782.855 8.494802
-- Pathing for Gadgetzan Bruiser Entry: 9460
SET @NPC := 23570;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-7183.59,`position_y`=-3850.61,`position_z`=9.07167, `orientation`=2.58309 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,-7183.338,-3849.927,8.807791,100,0,0,0),
(@NPC,2,-7180.19,-3840.474,8.635672,100,0,0,0),
(@NPC,3,-7176.548,-3829.155,9.119802,100,0,0,0),
(@NPC,4,-7173.867,-3823.532,9.119802,100,0,0,0),
(@NPC,5,-7158.03,-3820.096,8.494802,100,0,0,0),
(@NPC,6,-7145.749,-3824.311,8.672048,100,0,0,0),
(@NPC,7,-7135.521,-3823.348,8.494802,100,0,0,0),
(@NPC,8,-7119.781,-3825.909,8.558129,100,0,0,0),
(@NPC,9,-7108.362,-3829.184,9.558862,100,0,0,0),
(@NPC,10,-7111.663,-3837.394,10.0345,100,0,0,0),
(@NPC,11,-7117.092,-3844.873,9.42097,100,0,0,0),
(@NPC,12,-7128.118,-3853.502,9.517161,100,0,0,0),
(@NPC,13,-7131.41,-3866.42,10.48567,100,0,0,0),
(@NPC,14,-7141.612,-3870.367,9.748546,100,0,0,0),
(@NPC,15,-7159.92,-3863.409,9.166189,100,0,0,0),
(@NPC,16,-7175,-3859.084,9.02239,100,0,0,0),
(@NPC,17,-7181.881,-3857.015,9.412283,100,0,0,0);
-- .go xyz -7183.338 -3849.927 8.807791
-- Pathing for Gadgetzan Bruiser Entry: 9460
SET @NPC := 23575;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-7140,`position_y`=-3814.85,`position_z`=9.17645, `orientation`=5.79449 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,-7138.69,-3814.225,9.119802,100,0,0,0),
(@NPC,2,-7126.971,-3811.693,8.744409,100,0,0,0),
(@NPC,3,-7116.857,-3803.883,8.494409,100,0,0,0),
(@NPC,4,-7111.98,-3787.063,8.494409,100,0,0,0),
(@NPC,5,-7115.765,-3776.998,8.698754,100,0,0,0),
(@NPC,6,-7117.159,-3762.148,8.453013,100,0,0,0),
(@NPC,7,-7125.475,-3755.373,8.783092,100,0,0,0),
(@NPC,8,-7135.885,-3755.68,9.214274,100,0,0,0),
(@NPC,9,-7152.627,-3760.519,8.542399,100,0,0,0),
(@NPC,10,-7165.76,-3773.929,8.4948,100,0,0,0),
(@NPC,11,-7171.473,-3784.72,8.494802,100,0,0,0),
(@NPC,12,-7168.043,-3794.855,8.892018,100,0,0,0),
(@NPC,13,-7164.325,-3804.394,8.713307,100,0,0,0),
(@NPC,14,-7152.052,-3811.553,8.994802,100,0,0,0);
-- .go xyz -7138.69 -3814.225 9.119802
-- Pathing for Gadgetzan Bruiser Entry: 9460
SET @NPC := 23586;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-7136.45,`position_y`=-3703.79,`position_z`=9.47267, `orientation`=5.63741 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,-7137.959,-3702.868,9.208591,100,0,0,0),
(@NPC,2,-7147.056,-3701.081,9.076266,100,0,0,0),
(@NPC,3,-7158.31,-3706.74,9.511081,100,0,0,0),
(@NPC,4,-7167.938,-3719.48,9.619808,100,0,0,0),
(@NPC,5,-7178.012,-3734.715,9.016528,100,0,0,0),
(@NPC,6,-7176.58,-3761.706,8.4948,100,0,0,0),
(@NPC,7,-7168.661,-3766.066,8.4948,100,0,0,0),
(@NPC,8,-7157.015,-3755.967,8.470134,100,0,0,0),
(@NPC,9,-7146.816,-3750.354,8.470134,100,0,0,0),
(@NPC,10,-7132.403,-3746.406,8.456431,100,0,0,0),
(@NPC,11,-7106.71,-3744.646,8.456431,100,0,0,0),
(@NPC,12,-7102.137,-3737.292,8.831431,100,0,0,0),
(@NPC,13,-7105.467,-3724.7,8.846464,100,0,0,0),
(@NPC,14,-7117.679,-3717.516,8.880156,100,0,0,0),
(@NPC,15,-7125.375,-3711.695,11.59549,100,0,0,0);
-- .go xyz -7137.959 -3702.868 9.208591
-- Pathing for Gadgetzan Bruiser Entry: 9460
SET @NPC := 23594;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-7198.44,`position_y`=-3778.12,`position_z`=8.4634, `orientation`=3.82227 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,-7199.577,-3777.644,8.494802,100,0,0,0),
(@NPC,2,-7217.438,-3772.997,8.494802,100,0,0,0),
(@NPC,3,-7218.223,-3761.291,8.952322,100,0,0,0),
(@NPC,4,-7208.93,-3743.44,8.494802,100,0,0,0),
(@NPC,5,-7201.552,-3734.939,8.494802,100,0,0,0),
(@NPC,6,-7194.897,-3736.132,8.4948,100,0,0,0),
(@NPC,7,-7184.88,-3748.332,8.4948,100,0,0,0),
(@NPC,8,-7170.151,-3761.111,8.4948,100,0,0,0),
(@NPC,9,-7149.903,-3757.382,8.470134,100,0,0,0),
(@NPC,10,-7129.627,-3754.529,9.168345,100,0,0,0),
(@NPC,11,-7103.061,-3755.546,8.456431,100,0,0,0),
(@NPC,12,-7083.393,-3755.723,8.744067,100,0,0,0),
(@NPC,13,-7078.975,-3768.649,8.870678,100,0,0,0),
(@NPC,14,-7081.307,-3787.739,8.676342,100,0,0,0),
(@NPC,15,-7086.559,-3798.405,8.495678,100,0,0,0),
(@NPC,16,-7100.719,-3797.739,8.494409,100,0,0,0),
(@NPC,17,-7118.827,-3809.278,8.494409,100,0,0,0),
(@NPC,18,-7129.359,-3818.396,8.560082,100,0,0,0),
(@NPC,19,-7143.384,-3819.459,8.847096,100,0,0,0),
(@NPC,20,-7156.702,-3813.151,8.604177,100,0,0,0),
(@NPC,21,-7172.139,-3798.79,8.494802,100,0,0,0),
(@NPC,22,-7185.893,-3786.555,8.494802,100,0,0,0);
-- .go xyz -7199.577 -3777.644 8.494802
-- Pathing for Everlook Bruiser Entry: 11190
SET @NPC := 42289;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=6712.801,`position_y`=-4640.004,`position_z`=721.4033 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,6712.801,-4640.004,721.4033,100,1000,0,0),
(@NPC,2,6718.815,-4649.531,721.1697,100,0,0,0),
(@NPC,3,6719.494,-4656.592,721.0881,100,0,0,0),
(@NPC,4,6716.95,-4663.692,720.99,100,0,0,0),
(@NPC,5,6711.768,-4667.429,721.0986,100,1000,0,0),
(@NPC,6,6716.95,-4663.692,720.99,100,0,0,0),
(@NPC,7,6719.494,-4656.592,721.0881,100,0,0,0),
(@NPC,8,6718.815,-4649.531,721.1697,100,0,0,0);
-- .go xyz 6712.801 -4640.004 721.4033
-- Pathing for Everlook Bruiser Entry: 11190
SET @NPC := 42293;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=6714.022,`position_y`=-4691.308,`position_z`=721.3486 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,6714.022,-4691.308,721.3486,100,0,0,0),
(@NPC,2,6717.968,-4679.837,721.1166,100,0,0,0),
(@NPC,3,6724.618,-4671.613,721.0676,100,0,0,0),
(@NPC,4,6728.09,-4670.169,720.8073,100,0,0,0),
(@NPC,5,6735.956,-4669.475,721.4467,100,0,0,0),
(@NPC,6,6744.62,-4670.933,722.7365,100,0,0,0),
(@NPC,7,6757.797,-4670.824,723.8214,100,0,0,0),
(@NPC,8,6753.273,-4669.212,723.9066,100,0,0,0),
(@NPC,9,6740.137,-4666.286,722.3732,100,0,0,0),
(@NPC,10,6732.994,-4661.645,720.905,100,0,0,0),
(@NPC,11,6733.887,-4654.246,721.3657,100,0,0,0),
(@NPC,12,6738.181,-4643.156,721.6838,100,0,0,0),
(@NPC,13,6744.223,-4645.468,722.178,100,0,0,0),
(@NPC,14,6749.959,-4651.49,724.4252,100,0,0,0),
(@NPC,15,6750.333,-4660.228,724.7289,100,0,0,0),
(@NPC,16,6746.749,-4666.85,723.5728,100,0,0,0),
(@NPC,17,6741.206,-4667.995,722.3617,100,0,0,0),
(@NPC,18,6732.619,-4665.083,720.9668,100,0,0,0),
(@NPC,19,6725.346,-4656.443,720.865,100,0,0,0),
(@NPC,20,6723.433,-4648.296,721.115,100,0,0,0),
(@NPC,21,6725.489,-4639.336,721.24,100,0,0,0),
(@NPC,22,6725.974,-4625.182,720.91,100,0,0,0),
(@NPC,23,6725.201,-4617.709,721.2608,100,0,0,0),
(@NPC,24,6726.097,-4632.547,721.035,100,0,0,0),
(@NPC,25,6722.884,-4647.296,721.115,100,0,0,0),
(@NPC,26,6718.971,-4660.717,720.99,100,0,0,0),
(@NPC,27,6718.08,-4669.557,720.9736,100,0,0,0),
(@NPC,28,6717.741,-4679.664,721.0959,100,0,0,0);
-- .go xyz 6714.022 -4691.308 721.3486
-- Update Everlook Bruiser position
UPDATE `creature` SET `position_x`=6727.17,`position_y`=-4654.55,`position_z`=721.007, `orientation`=2.5573 WHERE `guid`=42290;
-- Pathing for Lord Kazzak Entry: 12397
SET @NPC := 156950;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-12260.24,`position_y`=-2442.24,`position_z`=3.430978 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,-12260.24,-2442.24,3.430978,5.480334,0,0,0),
(@NPC,2,-12226.76,-2433.571,1.828683,100,0,0,0),
(@NPC,3,-12199.39,-2443.944,-0.7508845,100,0,0,0),
(@NPC,4,-12176.75,-2463.179,-0.6481013,100,0,0,0),
(@NPC,5,-12162.13,-2490.048,1.366774,100,0,0,0),
(@NPC,6,-12129.58,-2509.904,3.587029,100,0,0,0),
(@NPC,7,-12105.12,-2514.273,3.377312,100,0,0,0),
(@NPC,8,-12185.21,-2510.919,0.1409316,100,0,0,0),
(@NPC,9,-12202.61,-2521.488,1.035176,100,0,0,0),
(@NPC,10,-12200.35,-2529.228,1.605,100,0,0,0),
(@NPC,11,-12220.61,-2521.741,1.535176,100,0,0,0),
(@NPC,12,-12254.35,-2523.169,1.328878,100,0,0,0),
(@NPC,13,-12283.78,-2530.946,5.201876,100,0,0,0),
(@NPC,14,-12281.98,-2493.777,5.096412,100,0,0,0),
(@NPC,15,-12281.54,-2458.933,5.138525,100,0,0,0),
(@NPC,16,-12272.15,-2450.711,4.348242,100,0,0,0);
-- .go xyz -12260.24 -2442.24 3.430978
-- Pathing for Feathermoon Sentinel Entry: 7939
SET @NPC := 49977;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-4492.235,`position_y`=3249.824,`position_z`=11.19775 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,-4492.235,3249.824,11.19775,100,0,0,0),
(@NPC,2,-4487.403,3257.882,11.73058,100,0,0,0),
(@NPC,3,-4483.56,3266.073,11.90636,100,0,0,0),
(@NPC,4,-4481.206,3272.186,11.50963,100,0,0,0),
(@NPC,5,-4475.127,3275.971,11.25963,100,0,0,0),
(@NPC,6,-4464.258,3277.783,11.2362,100,0,0,0),
(@NPC,7,-4458.422,3276.395,11.75963,100,0,0,0),
(@NPC,8,-4444.554,3276.981,11.88463,100,0,0,0),
(@NPC,9,-4437.29,3275.923,11.88463,100,0,0,0),
(@NPC,10,-4434.73,3272.417,11.73986,100,0,0,0),
(@NPC,11,-4435.162,3259.731,11.59671,100,0,0,0),
(@NPC,12,-4435.778,3249.712,11.59671,100,0,0,0),
(@NPC,13,-4438.908,3235.844,11.73294,100,0,0,0),
(@NPC,14,-4435.328,3250.432,11.60745,100,0,0,0),
(@NPC,15,-4434.434,3263.361,11.72171,100,0,0,0),
(@NPC,16,-4434.104,3271.15,11.75963,100,0,0,0),
(@NPC,17,-4432.815,3276.464,11.69438,100,0,0,0),
(@NPC,18,-4419,3283.278,11.81938,100,0,0,0),
(@NPC,19,-4411.474,3291.167,12.19438,100,0,0,0),
(@NPC,20,-4405.729,3299.063,13.01945,100,0,0,0),
(@NPC,21,-4398.124,3303.507,13.04439,100,0,0,0),
(@NPC,22,-4392.737,3305,13.066,100,0,0,0),
(@NPC,23,-4401.931,3300.659,13.15779,100,0,0,0),
(@NPC,24,-4408.975,3294.774,12.50468,100,0,0,0),
(@NPC,25,-4418.45,3284.844,11.81938,100,0,0,0),
(@NPC,26,-4425.491,3281.187,11.81938,100,0,0,0),
(@NPC,27,-4432.89,3279.537,11.91752,100,0,0,0),
(@NPC,28,-4442.861,3277.892,11.88463,100,0,0,0),
(@NPC,29,-4451.866,3276.966,12.00963,100,0,0,0),
(@NPC,30,-4457.539,3278.462,12.00963,100,0,0,0),
(@NPC,31,-4469.577,3275.757,11.25963,100,0,0,0),
(@NPC,32,-4480.475,3269.403,11.74377,100,0,0,0),
(@NPC,33,-4485.726,3259.336,11.87414,100,0,0,0);
-- .go xyz -4492.235 3249.824 11.19775
-- Pathing for Scholar Runethorn Entry: 14374
SET @NPC := 50011;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-4434.478,`position_y`=3274.137,`position_z`=11.66845 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,-4434.478,3274.137,11.66845,100,0,0,0),
(@NPC,2,-4424.573,3280.727,11.69413,100,0,0,0),
(@NPC,3,-4416.88,3285.675,11.91288,100,0,0,0),
(@NPC,4,-4401.731,3275.461,12.31938,100,0,0,0),
(@NPC,5,-4384.45,3273.314,13.84571,100,0,0,0),
(@NPC,6,-4374.603,3271.167,13.65119,100,0,0,0),
(@NPC,7,-4375.006,3251.661,12.68514,100,0,0,0),
(@NPC,8,-4377.151,3233.96,12.10176,100,0,0,0),
(@NPC,9,-4389.308,3230.345,12.14654,100,0,0,0),
(@NPC,10,-4403.13,3225.249,11.7395,100,0,0,0),
(@NPC,11,-4422.025,3224.992,11.75854,100,0,0,0),
(@NPC,12,-4437.809,3234.865,11.85037,100,0,0,0),
(@NPC,13,-4435.035,3255.315,11.47171,100,0,0,0);
-- .go xyz -4434.478 3274.137 11.66845
-- Pathing for Elder Mesa Buzzard Entry: 2580
SET @NPC := 11369;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-1845.108,`position_y`=-1537.111,`position_z`=65.40875 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,-1845.108,-1537.111,65.40875,100,0,0,0),
(@NPC,2,-1843.599,-1521.414,60.91593,100,0,0,0),
(@NPC,3,-1842.447,-1508.195,57.16911,100,0,0,0),
(@NPC,4,-1833.756,-1502.528,62.44181,100,0,0,0),
(@NPC,5,-1827.709,-1497.279,66.00378,100,0,0,0),
(@NPC,6,-1819.846,-1487.347,68.12878,100,0,0,0),
(@NPC,7,-1823.38,-1478.947,71.59093,100,0,0,0),
(@NPC,8,-1818.173,-1473.913,67.01379,100,0,0,0),
(@NPC,9,-1808.265,-1461.171,63.07932,100,0,0,0),
(@NPC,10,-1796.005,-1455.686,67.54326,100,0,0,0),
(@NPC,11,-1786.106,-1460.192,68.13554,100,0,0,0),
(@NPC,12,-1775.654,-1462.791,68.13554,100,0,0,0),
(@NPC,13,-1767.397,-1459.255,68.13554,100,0,0,0),
(@NPC,14,-1761.548,-1454.997,68.23097,100,0,0,0),
(@NPC,15,-1756.665,-1449.461,68.23097,100,0,0,0),
(@NPC,16,-1747.367,-1452.755,67.40749,100,0,0,0),
(@NPC,17,-1742.178,-1457.133,69.03346,100,0,0,0),
(@NPC,18,-1736.242,-1458.009,73.54128,100,0,0,0),
(@NPC,19,-1727.696,-1460.599,67.59557,100,0,0,0),
(@NPC,20,-1725.897,-1469.652,65.71997,100,0,0,0),
(@NPC,21,-1720.486,-1473.564,64.82056,100,0,0,0),
(@NPC,22,-1715.711,-1471.995,61.79223,100,0,0,0),
(@NPC,23,-1725.897,-1469.652,65.71997,100,0,0,0),
(@NPC,24,-1727.696,-1460.599,67.59557,100,0,0,0),
(@NPC,25,-1736.242,-1458.009,73.54128,100,0,0,0),
(@NPC,26,-1742.178,-1457.133,69.03346,100,0,0,0),
(@NPC,27,-1747.367,-1452.755,67.40749,100,0,0,0),
(@NPC,28,-1756.665,-1449.461,68.23097,100,0,0,0),
(@NPC,29,-1761.548,-1454.997,68.23097,100,0,0,0),
(@NPC,30,-1767.397,-1459.255,68.13554,100,0,0,0),
(@NPC,31,-1775.654,-1462.791,68.13554,100,0,0,0),
(@NPC,32,-1786.106,-1460.192,68.13554,100,0,0,0),
(@NPC,33,-1796.005,-1455.686,67.54326,100,0,0,0),
(@NPC,34,-1808.265,-1461.171,63.07932,100,0,0,0),
(@NPC,35,-1818.173,-1473.913,67.01379,100,0,0,0),
(@NPC,36,-1823.38,-1478.947,71.59093,100,0,0,0),
(@NPC,37,-1819.881,-1487.244,68.00378,100,0,0,0),
(@NPC,38,-1827.714,-1497.284,65.92443,100,0,0,0),
(@NPC,39,-1833.762,-1502.533,62.37516,100,0,0,0),
(@NPC,40,-1842.447,-1508.195,57.16911,100,0,0,0),
(@NPC,41,-1843.599,-1521.414,60.91593,100,0,0,0);
-- .go xyz -1845.108 -1537.111 65.40875
-- Pathing for Boulderfist Lord Entry: 2571
SET @NPC := 11658;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-1787.068,`position_y`=-1519.569,`position_z`=78.26667 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,-1787.068,-1519.569,78.26667,100,0,0,0),
(@NPC,2,-1783.133,-1523.462,78.28279,100,0,0,0),
(@NPC,3,-1777.671,-1524.568,79.37039,100,0,0,0),
(@NPC,4,-1768.864,-1520.528,82.38766,100,0,0,0),
(@NPC,5,-1765.722,-1514.994,84.23361,100,0,0,0),
(@NPC,6,-1765.568,-1509.044,84.88705,100,0,0,0),
(@NPC,7,-1767.216,-1506.247,85.09273,100,0,0,0),
(@NPC,8,-1771.831,-1509.441,85.12987,100,0,0,0),
(@NPC,9,-1778.485,-1513.008,85.33758,100,0,0,0),
(@NPC,10,-1780.662,-1509.464,84.70084,100,0,0,0),
(@NPC,11,-1782.649,-1506.446,83.29977,100,0,0,0),
(@NPC,12,-1786.436,-1502.757,81.59764,100,0,0,0),
(@NPC,13,-1789.515,-1505.83,80.88887,100,0,0,0),
(@NPC,14,-1790.921,-1510.939,79.23459,100,0,0,0),
(@NPC,15,-1790.198,-1515.494,78.58383,100,0,0,0);
-- .go xyz -1787.068 -1519.569 78.26667
-- Pathing for Boulderfist Lord Entry: 2571
SET @NPC := 11652;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-1773.165,`position_y`=-1516.006,`position_z`=75.08616 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,-1773.165,-1516.006,75.08616,100,0,0,0),
(@NPC,2,-1770.06,-1511.038,72.20582,100,0,0,0),
(@NPC,3,-1770.966,-1507.84,70.35487,100,0,0,0),
(@NPC,4,-1772.347,-1504.272,69.59764,100,0,0,0),
(@NPC,5,-1767.672,-1504.722,69.72246,100,0,0,0),
(@NPC,6,-1765.533,-1515.222,65.90397,100,0,0,0),
(@NPC,7,-1768.77,-1518.182,64.99765,100,0,0,0),
(@NPC,8,-1772.903,-1517.783,64.99765,100,0,0,0),
(@NPC,9,-1776.978,-1514.561,64.99765,100,0,0,0),
(@NPC,10,-1777.663,-1511.805,64.99765,100,0,0,0),
(@NPC,11,-1772.903,-1517.783,64.99765,100,0,0,0),
(@NPC,12,-1768.797,-1518.206,64.99765,100,0,0,0),
(@NPC,13,-1765.533,-1515.222,65.90397,100,0,0,0),
(@NPC,14,-1765.531,-1509.426,68.00388,100,0,0,0),
(@NPC,15,-1767.616,-1504.786,69.70332,100,0,0,0),
(@NPC,16,-1769.725,-1502.373,69.59763,100,0,0,0),
(@NPC,17,-1772.347,-1504.272,69.59764,100,0,0,0),
(@NPC,18,-1770.966,-1507.84,70.35487,100,0,0,0),
(@NPC,19,-1770.06,-1511.038,72.20582,100,0,0,0);
-- 0x20516C00000282C000001200001D3507 .go xyz -1773.165 -1516.006 75.08616
-- Pathing for Boulderfist Shaman Entry: 2570
SET @NPC := 11651;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-1779.104,`position_y`=-1525.453,`position_z`=90.68996 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,-1779.104,-1525.453,90.68996,100,0,0,0),
(@NPC,2,-1787.832,-1522.945,90.72302,100,0,0,0),
(@NPC,3,-1792.385,-1516.236,90.74519,100,0,0,0),
(@NPC,4,-1792.107,-1508.027,90.79764,100,0,0,0),
(@NPC,5,-1787.824,-1501.817,90.69627,100,0,0,0),
(@NPC,6,-1780.531,-1496.547,90.73058,100,0,0,0),
(@NPC,7,-1772.366,-1497.809,90.71568,100,0,0,0),
(@NPC,8,-1767.031,-1500.861,90.7571,100,0,0,0),
(@NPC,9,-1765.412,-1512.501,90.68889,100,0,0,0),
(@NPC,10,-1767.458,-1519.41,90.67276,100,0,0,0),
(@NPC,11,-1773.587,-1524.809,90.69104,100,0,0,0);
-- .go xyz -1779.104 -1525.453 90.68996
-- Pathing for Boulderfist Shaman Entry: 2570
SET @NPC := 11683;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-1780.002,`position_y`=-1524.046,`position_z`=64.99765 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,-1780.002,-1524.046,64.99765,100,0,0,0),
(@NPC,2,-1788.88,-1518.838,68.45383,100,0,0,0),
(@NPC,3,-1789.906,-1512.857,70.42406,100,0,0,0),
(@NPC,4,-1790.338,-1509.854,71.61338,100,0,0,0),
(@NPC,5,-1788.771,-1505.967,72.39764,100,0,0,0),
(@NPC,6,-1787.159,-1503.2,72.39764,100,0,0,0),
(@NPC,7,-1784.028,-1502.155,72.39764,100,0,0,0),
(@NPC,8,-1777.255,-1514.407,75.60347,100,0,0,0),
(@NPC,9,-1774.516,-1518.338,75.45952,100,0,0,0),
(@NPC,10,-1771.719,-1523.118,75.39764,100,0,0,0),
(@NPC,11,-1777.255,-1514.407,75.60347,100,0,0,0),
(@NPC,12,-1779.24,-1510.243,75.18117,100,0,0,0),
(@NPC,13,-1780.899,-1507.463,74.39077,100,0,0,0),
(@NPC,14,-1784.028,-1502.155,72.39764,100,0,0,0),
(@NPC,15,-1787.159,-1503.2,72.39764,100,0,0,0),
(@NPC,16,-1788.771,-1505.967,72.39764,100,0,0,0),
(@NPC,17,-1790.338,-1509.854,71.61338,100,0,0,0),
(@NPC,18,-1789.906,-1512.857,70.42406,100,0,0,0),
(@NPC,19,-1788.888,-1518.792,68.47718,100,0,0,0),
(@NPC,20,-1784.59,-1522.349,66.52057,100,0,0,0);
-- .go xyz -1780.002 -1524.046 64.99765
-- Pathing for Beetix Ficklespragg Entry: 15189
SET @NPC := 42916;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-6855.655,`position_y`=739.6216,`position_z`=55.05116 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,-6855.655,739.6216,55.05116,100,5000,0,0),
(@NPC,2,-6852.965,733.1834,55.05116,100,2000,0,0);
-- .go xyz -6855.655 739.6216 55.05116
-- Update Cenarion Hold Infantry position to is_spawn
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-6758.98,`position_y`=761.723,`position_z`=87.0481, `orientation`=3.71755 WHERE `guid`=42897;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-6757.06,`position_y`=762.689,`position_z`=87.3247, `orientation`=3.49066 WHERE `guid`=60006;
-- Pathing for Cenarion Hold Infantry Entry: 15184
SET @NPC := 42897;
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,-6758.621,760.6922,87.04973,100,0,0,0),
(@NPC,2,-6766.431,753.6038,85.08977,100,0,0,0),
(@NPC,3,-6779.673,750.002,79.01744,100,0,0,0),
(@NPC,4,-6787.776,755.208,74.94444,100,0,0,0),
(@NPC,5,-6793.854,766.7786,68.64055,100,0,0,0),
(@NPC,6,-6792.49,786.3465,52.47892,100,0,0,0),
(@NPC,7,-6805.73,794.1757,51.00132,100,0,0,0),
(@NPC,8,-6822.387,816.8485,50.26434,100,0,0,0),
(@NPC,9,-6815.217,833.3524,49.71984,100,0,0,0),
(@NPC,10,-6799.795,838.4564,48.49956,100,0,0,0),
(@NPC,11,-6769.241,840.9318,42.76591,100,0,0,0),
(@NPC,12,-6764.696,849.5421,35.99612,100,0,0,0),
(@NPC,13,-6771.036,862.9793,26.40056,100,0,0,0),
(@NPC,14,-6766.45,869.8455,23.53795,100,0,0,0),
(@NPC,15,-6742.604,847.0293,15.90433,100,0,0,0),
(@NPC,16,-6766.45,869.8455,23.53795,100,0,0,0),
(@NPC,17,-6771.036,862.9793,26.40056,100,0,0,0),
(@NPC,18,-6764.696,849.5421,35.99612,100,0,0,0),
(@NPC,19,-6769.241,840.9318,42.76591,100,0,0,0),
(@NPC,20,-6799.795,838.4564,48.49956,100,0,0,0),
(@NPC,21,-6815.217,833.3524,49.71984,100,0,0,0),
(@NPC,22,-6822.387,816.8485,50.26434,100,0,0,0),
(@NPC,23,-6805.816,794.29,51.01291,100,0,0,0),
(@NPC,24,-6792.49,786.3465,52.47892,100,0,0,0),
(@NPC,25,-6793.854,766.7786,68.64055,100,0,0,0),
(@NPC,26,-6787.776,755.208,74.94444,100,0,0,0),
(@NPC,27,-6779.673,750.002,79.01744,100,0,0,0),
(@NPC,28,-6766.431,753.6038,85.08977,100,0,0,0);
-- .go xyz -6758.621 760.6922 87.04973
-- Lady Jaina Proudmoore should have random movement
UPDATE `creature` SET `wander_distance`=1.5,`movement_type`=1 WHERE `guid`=7895;
-- Vincent Hyal should not have any equipment in vanilla
DELETE FROM `creature_equip_template` WHERE `entry`=5082 AND `item1`=2705 AND `item2`=0 AND `item3`=0;
UPDATE `creature_template` SET `equipment_id`=0 WHERE `entry`=5082;
-- Pathing for Guard Clarke Entry: 934
SET @NPC := 10088;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-9266.45,`position_y`=-2182.234,`position_z`=64.1563 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,-9266.45,-2182.234,64.1563,100,0,0,0),
(@NPC,2,-9268.26,-2200.005,64.1563,100,0,0,0),
(@NPC,3,-9269.661,-2222.433,64.1563,100,0,0,0),
(@NPC,4,-9270.646,-2245.761,64.04616,100,0,0,0),
(@NPC,5,-9271.06,-2266.026,66.2466,100,0,0,0),
(@NPC,6,-9275.419,-2273.584,67.4109,100,0,0,0),
(@NPC,7,-9281.135,-2260.52,65.97218,100,0,0,0),
(@NPC,8,-9283.647,-2243.695,63.57106,100,0,0,0),
(@NPC,9,-9284.114,-2226.769,63.39107,100,0,0,0),
(@NPC,10,-9285.208,-2216.076,63.25996,100,0,0,0),
(@NPC,11,-9297.224,-2212.776,61.95629,100,0,0,0),
(@NPC,12,-9311.435,-2210.67,61.95629,100,0,0,0),
(@NPC,13,-9322.396,-2210.031,61.9563,100,0,0,0),
(@NPC,14,-9335.028,-2207.953,61.95629,100,0,0,0),
(@NPC,15,-9344.355,-2206.349,61.95629,100,0,0,0),
(@NPC,16,-9335.028,-2207.953,61.95629,100,0,0,0),
(@NPC,17,-9322.396,-2210.031,61.9563,100,0,0,0),
(@NPC,18,-9311.435,-2210.67,61.95629,100,0,0,0),
(@NPC,19,-9297.224,-2212.776,61.95629,100,0,0,0),
(@NPC,20,-9285.208,-2216.076,63.25996,100,0,0,0),
(@NPC,21,-9284.114,-2226.769,63.39107,100,0,0,0),
(@NPC,22,-9283.647,-2243.695,63.57106,100,0,0,0),
(@NPC,23,-9281.135,-2260.52,65.97218,100,0,0,0),
(@NPC,24,-9275.419,-2273.584,67.4109,100,0,0,0),
(@NPC,25,-9271.06,-2266.026,66.2466,100,0,0,0),
(@NPC,26,-9270.646,-2245.761,64.04616,100,0,0,0),
(@NPC,27,-9269.661,-2222.433,64.1563,100,0,0,0),
(@NPC,28,-9268.26,-2200.005,64.1563,100,0,0,0);
-- .go xyz -9266.45 -2182.234 64.1563
-- Delete prespawned Lakeshire Guard
DELETE FROM `creature` WHERE `guid`=31839;
-- Pathing for Southshore Guard Entry: 2386
SET @NPC := 15323;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-680.8098,`position_y`=-422.5727,`position_z`=66.93989 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,-680.8098,-422.5727,66.93989,100,0,0,0),
(@NPC,2,-682.9655,-427.8931,67.04997,100,0,0,0),
(@NPC,3,-680.9497,-431.634,66.95007,100,0,0,0),
(@NPC,4,-676.5903,-434.4274,66.93056,100,0,0,0),
(@NPC,5,-672.2703,-434.1398,66.99996,100,0,0,0),
(@NPC,6,-670.167,-432.3922,66.93301,100,0,0,0),
(@NPC,7,-667.9529,-428.7198,67.00827,100,0,0,0),
(@NPC,8,-667.6899,-424.5533,67.00462,100,0,0,0),
(@NPC,9,-669.7689,-422.3329,66.8884,100,0,0,0),
(@NPC,10,-672.7508,-420.1314,66.97158,100,0,0,0),
(@NPC,11,-677.3453,-420.2057,66.99928,100,0,0,0);
-- .go xyz -680.8098 -422.5727 66.93989
-- Pathing for Southshore Guard Entry: 2386
SET @NPC := 15928;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-797.3588,`position_y`=-525.4022,`position_z`=17.23382 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,-797.3588,-525.4022,17.23382,100,0,0,0),
(@NPC,2,-808.3094,-528.867,15.45718,100,0,0,0),
(@NPC,3,-830.2421,-521.8862,12.47403,100,0,0,0),
(@NPC,4,-843.0829,-527.0458,11.30999,100,0,0,0),
(@NPC,5,-866.6998,-538.3126,8.527973,100,0,0,0),
(@NPC,6,-876.2786,-542.1104,7.753315,100,0,0,0),
(@NPC,7,-890.7396,-540.6976,6.96938,100,0,0,0),
(@NPC,8,-876.2786,-542.1104,7.753315,100,0,0,0),
(@NPC,9,-866.6998,-538.3126,8.527973,100,0,0,0),
(@NPC,10,-843.0829,-527.0458,11.30999,100,0,0,0),
(@NPC,11,-830.2421,-521.8862,12.47403,100,0,0,0),
(@NPC,12,-808.3094,-528.867,15.45718,100,0,0,0);
-- .go xyz -797.3588 -525.4022 17.23382
-- Pathing for Southshore Guard Entry: 2386
SET @NPC := 15672;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-663.7242,`position_y`=-411.809,`position_z`=31.61638 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,-663.7242,-411.809,31.61638,100,0,0,0),
(@NPC,2,-671.3255,-408.9535,31.69665,100,0,0,0),
(@NPC,3,-682.3085,-407.823,31.69808,100,0,0,0),
(@NPC,4,-688.3499,-413.3312,31.64048,100,0,0,0),
(@NPC,5,-692.722,-418.8364,31.71779,100,0,0,0),
(@NPC,6,-694.8457,-425.3675,31.69657,100,0,0,0),
(@NPC,7,-695.1766,-431.1532,31.69657,100,0,0,0),
(@NPC,8,-690.6848,-438.8092,31.69657,100,0,0,0),
(@NPC,9,-683.988,-444.3011,31.5941,100,0,0,0),
(@NPC,10,-673.6478,-446.6058,31.69658,100,0,0,0),
(@NPC,11,-664.2532,-443.7435,31.63104,100,0,0,0),
(@NPC,12,-657.4524,-434.3368,31.69657,100,0,0,0),
(@NPC,13,-656.3378,-424.8232,31.6325,100,0,0,0),
(@NPC,14,-660.5198,-416.8098,31.69658,100,0,0,0);
-- .go xyz -663.7242 -411.809 31.61638
-- Delete custom path for Southshore Guard and set random movement
DELETE FROM `creature_movement` WHERE `id`=15668;
UPDATE `creature` SET `wander_distance`=3,`movement_type`=1 WHERE `guid`=15668;
-- Correct position of Southshore Guard
UPDATE `creature` SET `position_x`=-869.167, `position_y`=-513.7, `position_z`=11.6632, `orientation`=4.76475 WHERE `guid`=15327;
-- Correct position of Tarren Mill Deathguard
UPDATE `creature` SET `position_x`=1.27648, `position_y`=-920.911, `position_z`=56.8078, `orientation`=0.366519 WHERE `guid`=15537;
-- Mountainer Angst should have random movement
UPDATE `creature` SET `wander_distance`=5, `movement_type`=1 WHERE `guid`=8242;
-- Pathing for Southshore Guard Entry: 2386
SET @NPC := 16387;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-838.3504,`position_y`=-685.415,`position_z`=8.660884 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,-838.3504,-685.415,8.660884,100,0,0,0),
(@NPC,2,-826.8138,-689.3942,8.764832,100,0,0,0),
(@NPC,3,-814.6146,-689.7004,7.719421,100,0,0,0),
(@NPC,4,-802.3196,-688.4636,7.7724,100,0,0,0),
(@NPC,5,-792.9668,-686.6743,9.574158,100,0,0,0),
(@NPC,6,-779.313,-685.7726,10.1142,100,0,0,0),
(@NPC,7,-762.2469,-688.8851,10.8293,100,0,0,0),
(@NPC,8,-748.2556,-684.8719,11.89351,100,0,0,0),
(@NPC,9,-762.2469,-688.8851,10.8293,100,0,0,0),
(@NPC,10,-779.313,-685.7726,10.1142,100,0,0,0),
(@NPC,11,-792.9668,-686.6743,9.574158,100,0,0,0),
(@NPC,12,-802.3196,-688.4636,7.7724,100,0,0,0),
(@NPC,13,-814.6146,-689.7004,7.719421,100,0,0,0),
(@NPC,14,-826.8138,-689.3942,8.764832,100,0,0,0);
-- .go xyz -838.3504 -685.415 8.660884
-- Pathing for Menethil Sentry Entry: 1434
SET @NPC := 9553;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-3702.036,`position_y`=-814.3842,`position_z`=10.33128 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,-3702.036,-814.3842,10.33128,100,0,0,0),
(@NPC,2,-3678.112,-827.6763,9.913949,100,0,0,0),
(@NPC,3,-3656.101,-841.0471,9.926273,100,0,0,0),
(@NPC,4,-3634.194,-850.5345,10.0799,100,0,0,0),
(@NPC,5,-3613.517,-860.9927,12.50108,100,0,0,0),
(@NPC,6,-3597.684,-868.6395,13.05111,100,0,0,0),
(@NPC,7,-3577.651,-878.9908,12.96002,100,0,0,0),
(@NPC,8,-3558.783,-888.7969,11.9978,100,0,0,0),
(@NPC,9,-3536.671,-899.8129,8.931274,100,0,0,0),
(@NPC,10,-3558.783,-888.7969,11.9978,100,0,0,0),
(@NPC,11,-3577.651,-878.9908,12.96002,100,0,0,0),
(@NPC,12,-3597.684,-868.6395,13.05111,100,0,0,0),
(@NPC,13,-3613.517,-860.9927,12.50108,100,0,0,0),
(@NPC,14,-3634.194,-850.5345,10.0799,100,0,0,0),
(@NPC,15,-3656.101,-841.0471,9.926273,100,0,0,0),
(@NPC,16,-3678.112,-827.6763,9.913949,100,0,0,0);
-- .go xyz -3702.036 -814.3842 10.33128
-- Pathing for Menethil Sentry Entry: 1434
SET @NPC := 9516;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-3725.996,`position_y`=-827.8249,`position_z`=11.68747 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,-3725.996,-827.8249,11.68747,100,0,0,0),
(@NPC,2,-3711.971,-808.1677,10.17311,100,0,0,0),
(@NPC,3,-3703.448,-786.9999,11.67935,100,0,0,0),
(@NPC,4,-3715.001,-780.3721,11.64425,100,0,0,0),
(@NPC,5,-3726.325,-803.9718,11.53127,100,0,0,0),
(@NPC,6,-3738.466,-821.5736,11.6555,100,0,0,0);
-- .go xyz -3725.996 -827.8249 11.68747
-- Pathing for Menethil Sentry Entry: 1434
SET @NPC := 9451;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-3857.57,`position_y`=-851.9611,`position_z`=6.655662 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,-3857.57,-851.9611,6.655662,100,0,0,0),
(@NPC,2,-3852.601,-872.1973,7.949479,100,0,0,0),
(@NPC,3,-3838.928,-890.0887,6.677262,100,0,0,0),
(@NPC,4,-3825.319,-905.2488,6.728694,100,0,0,0),
(@NPC,5,-3808.665,-917.5515,5.773372,100,0,0,0),
(@NPC,6,-3793.158,-921.8026,6.754763,100,0,0,0),
(@NPC,7,-3808.665,-917.5515,5.773372,100,0,0,0),
(@NPC,8,-3825.319,-905.2488,6.728694,100,0,0,0),
(@NPC,9,-3838.928,-890.0887,6.677262,100,0,0,0),
(@NPC,10,-3852.601,-872.1973,7.949479,100,0,0,0);
-- 0x205160000001668000020500039E5F5A .go xyz -3857.57 -851.9611 6.655662
-- Pathing for Menethil Sentry Entry: 1434
SET @NPC := 9514;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-3808.185,`position_y`=-765.5248,`position_z`=8.131272 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,-3808.185,-765.5248,8.131272,100,0,0,0),
(@NPC,2,-3822.523,-767.0237,8.218322,100,0,0,0),
(@NPC,3,-3838.22,-778.4105,4.448983,100,0,0,0),
(@NPC,4,-3833.177,-808.2225,9.69239,100,0,0,0),
(@NPC,5,-3856.571,-822.2552,8.652298,100,0,0,0),
(@NPC,6,-3856.179,-833.0389,9.192093,100,0,0,0),
(@NPC,7,-3856.571,-822.2552,8.652298,100,0,0,0),
(@NPC,8,-3833.177,-808.2225,9.69239,100,0,0,0),
(@NPC,9,-3838.22,-778.4105,4.448983,100,0,0,0),
(@NPC,10,-3822.523,-767.0237,8.218322,100,0,0,0);
-- .go xyz -3808.185 -765.5248 8.131272
-- Pathing for Menethil Sentry Entry: 1434
SET @NPC := 9557;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-3742.756,`position_y`=-798.3773,`position_z`=11.53127 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,-3742.756,-798.3773,11.53127,100,0,0,0),
(@NPC,2,-3737.791,-787.0203,15.53127,100,0,0,0),
(@NPC,3,-3722.656,-794.8729,20.33127,100,0,0,0),
(@NPC,4,-3730.861,-808.1197,20.33127,100,0,0,0),
(@NPC,5,-3722.656,-794.8729,20.33127,100,0,0,0),
(@NPC,6,-3737.777,-786.9871,15.53127,100,0,0,0);
-- .go xyz -3742.756 -798.3773 11.53127
-- Pathing for Menethil Sentry Entry: 1434
SET @NPC := 9696;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-3717.036,`position_y`=-732.6176,`position_z`=11.13578 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,-3717.036,-732.6176,11.13578,100,0,0,0),
(@NPC,2,-3718.424,-726.033,10.69022,100,0,0,0),
(@NPC,3,-3710.911,-719.7656,9.716347,100,0,0,0),
(@NPC,4,-3706.72,-711.1649,8.714394,100,0,0,0),
(@NPC,5,-3686.314,-694.7046,5.121346,100,0,0,0),
(@NPC,6,-3706.72,-711.1649,8.714394,100,0,0,0),
(@NPC,7,-3710.911,-719.7656,9.716347,100,0,0,0),
(@NPC,8,-3718.424,-726.033,10.69022,100,0,0,0);
-- .go xyz -3717.036 -732.6176 11.13578
-- Pathing for Stromgarde Defender Entry: 2584
SET @NPC := 12007;
UPDATE `creature` SET `wander_distance`=0,`movement_type`=2,`position_x`=-1549.325,`position_y`=-1901.269,`position_z`=67.82639 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,-1549.325,-1901.269,67.82639,100,0,0,0),
(@NPC,2,-1549.696,-1894.195,67.73683,100,0,0,0),
(@NPC,3,-1549.717,-1887.33,67.74586,100,0,0,0),
(@NPC,4,-1549.705,-1878.791,67.7361,100,0,0,0),
(@NPC,5,-1549.157,-1871.896,67.49586,100,0,0,0),
(@NPC,6,-1548.986,-1865.27,67.42509,100,0,0,0),
(@NPC,7,-1544.397,-1859.491,67.10917,100,0,0,0),
(@NPC,8,-1537.813,-1856.054,67.50907,100,0,0,0),
(@NPC,9,-1529.115,-1852.296,67.62733,100,0,0,0),
(@NPC,10,-1528.478,-1844.241,67.87733,100,0,0,0),
(@NPC,11,-1528.312,-1836.913,67.91737,100,0,0,0),
(@NPC,12,-1528.36,-1830.106,68.25278,100,0,0,0),
(@NPC,13,-1528.312,-1836.913,67.91737,100,0,0,0),
(@NPC,14,-1528.478,-1844.241,67.87733,100,0,0,0),
(@NPC,15,-1529.115,-1852.296,67.62733,100,0,0,0),
(@NPC,16,-1537.813,-1856.054,67.50907,100,0,0,0),
(@NPC,17,-1544.397,-1859.491,67.10917,100,0,0,0),
(@NPC,18,-1548.986,-1865.27,67.42509,100,0,0,0),
(@NPC,19,-1549.157,-1871.896,67.49586,100,0,0,0),
(@NPC,20,-1549.705,-1878.791,67.7361,100,0,0,0),
(@NPC,21,-1549.717,-1887.33,67.74586,100,0,0,0),
(@NPC,22,-1549.696,-1894.195,67.73683,100,0,0,0);
-- .go xyz -1549.325 -1901.269 67.82639
-- Add random movement to Stromgrade Vindicator
UPDATE `creature` SET `wander_distance`=3, `movement_type`=1 WHERE `guid`=12014;
UPDATE `creature` SET `wander_distance`=3, `movement_type`=1 WHERE `guid`=14611;
UPDATE `creature` SET `wander_distance`=3, `movement_type`=1 WHERE `guid`=14618;
UPDATE `creature` SET `wander_distance`=3, `movement_type`=1 WHERE `guid`=12008;
-- Add random movement to Prince Galen Trollbane
UPDATE `creature` SET `wander_distance`=2, `movement_type`=1 WHERE `guid`=12013;
-- Delete custom Stromgarde Troll Hunter spawn
DELETE FROM `creature_movement` WHERE `id`=14607;
DELETE FROM `creature` WHERE `guid`=14607;
-- Add and correct random movement for Stromgarde Troll Hunter
UPDATE `creature` SET `wander_distance`=3, `movement_type`=1 WHERE `guid`=14608;
UPDATE `creature` SET `wander_distance`=3, `movement_type`=1 WHERE `guid`=14610;
UPDATE `creature` SET `wander_distance`=3, `movement_type`=1 WHERE `guid`=14614;
UPDATE `creature` SET `wander_distance`=3, `movement_type`=1 WHERE `guid`=14617;
UPDATE `creature` SET `wander_distance`=3, `movement_type`=1 WHERE `guid`=14620;
UPDATE `creature` SET `wander_distance`=3, `movement_type`=1 WHERE `guid`=14623;
UPDATE `creature` SET `wander_distance`=3, `movement_type`=1 WHERE `guid`=11537;
UPDATE `creature` SET `wander_distance`=3, `movement_type`=1 WHERE `guid`=14757;
UPDATE `creature` SET `wander_distance`=3, `movement_type`=1 WHERE `guid`=14622;
UPDATE `creature` SET `wander_distance`=3, `movement_type`=1 WHERE `guid`=14612;
-- Add random movement to Caretakers
UPDATE `creature` SET `wander_distance`=2, `movement_type`=1 WHERE `guid`=11531;
UPDATE `creature` SET `wander_distance`=2, `movement_type`=1 WHERE `guid`=11532;
UPDATE `creature` SET `wander_distance`=2, `movement_type`=1 WHERE `guid`=11527;
-- Add missing campfire to Bear's Head, Azshara
INSERT INTO `gameobject` VALUES (21105, 88496, 1, 3962.28, -5029.25, 137.339, 3.14159, 0, 0, 1, 0, 180, 180, 100, 1, 0, 0, 0, 10);
-- Table `creature` have creature (GUID: 40486 Entry: 10083) with `MovementType`=0 (idle) have `wander_distance`<>0, set to 0.
-- Table `creature` have creature (GUID: 40483 Entry: 10083) with `MovementType`=0 (idle) have `wander_distance`<>0, set to 0.
UPDATE `creature` SET `movement_type`=1 WHERE `guid` IN (40486, 40483);
-- End of migration.
END IF;
END??
delimiter ;
CALL add_migration();
DROP PROCEDURE IF EXISTS add_migration;
Reference in New Issue View Git Blame Copy Permalink