DB: Fix Some waypoints

Some Drakes on Dragonblight and Frimarra are on top of each other

(cherry picked from commit bdc554e5909bbae267ca62bfc2fb2d2369609a04)

1 files changed, 97 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_10_23_03_world_2018_08_30_00_world.sql b/sql/updates/world/master/2021_10_23_03_world_2018_08_30_00_world.sql
new file mode 100644
index 00000000000..374691c8842
--- /dev/null
+++ b/sql/updates/world/master/2021_10_23_03_world_2018_08_30_00_world.sql
@@ -0,0 +1,97 @@
+-- 
+SET @NPC := 100206;
+SET @PATH := @NPC*10;
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,8,3662.692,328.2304,338.4197,0,0,0,100,0),
+(@PATH,7,3648.806,293.8063,321.0587,0,0,0,100,0),
+(@PATH,6,3677.441,213.8859,320.1976,0,0,0,100,0),
+(@PATH,5,3615.31,209.5691,324.1698,0,0,0,100,0),
+(@PATH,4,3637.643,254.0089,332.7251,0,0,0,100,0),
+(@PATH,3,3699.886,260.6509,327.8641,0,0,0,100,0),
+(@PATH,2,3720.373,308.941,337.7808,0,0,0,100,0),
+(@PATH,1,3691.676,352.0933,342.2254,0,0,0,100,0);
+
+SET @NPC := 100209;
+SET @PATH := @NPC*10;
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,3748.806,293.8063,201.0587,0,0,0,100,0),
+(@PATH,2,3777.441,213.8859,200.1976,0,0,0,100,0),
+(@PATH,3,3715.31,209.5691,204.1698,0,0,0,100,0),
+(@PATH,4,3737.643,254.0089,202.7251,0,0,0,100,0),
+(@PATH,5,3799.886,260.6509,207.8641,0,0,0,100,0),
+(@PATH,6,3820.373,308.941,207.7808,0,0,0,100,0),
+(@PATH,7,3791.676,352.0933,202.2254,0,0,0,100,0),
+(@PATH,8,3762.692,328.2304,208.4197,0,0,0,100,0);
+
+SET @NPC := 99108;
+SET @PATH := @NPC*10;
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,18,3506.288,141.7649,169.6936,0,0,0,100,0),
+(@PATH,17,3378.177,251.381,169.6936,0,0,0,100,0),
+(@PATH,16,3448.559,417.0887,169.6936,0,0,0,100,0),
+(@PATH,15,3659.633,429.129,169.6936,0,0,0,100,0),
+(@PATH,14,3726.806,236.8274,169.6936,0,0,0,100,0),
+(@PATH,13,3554.261,69.58746,169.6936,0,0,0,100,0),
+(@PATH,12,3337.373,175.2911,169.6936,0,0,0,100,0),
+(@PATH,11,3292.872,421.84,169.6936,0,0,0,100,0),
+(@PATH,10,3355.351,609.4697,169.6936,0,0,0,100,0),
+(@PATH,9,3233.689,777.6954,207.249,0,0,0,100,0),
+(@PATH,8,3049.014,721.6703,224.4991,0,0,0,100,0),
+(@PATH,7,3044.268,566.5984,169.6936,0,0,0,100,0),
+(@PATH,6,3142.397,481.2142,169.6936,0,0,0,100,0),
+(@PATH,5,3328.336,435.8111,169.6936,0,0,0,100,0),
+(@PATH,4,3583.232,539.7742,169.6936,0,0,0,100,0),
+(@PATH,3,3799.81,460.638,169.6936,0,0,0,100,0),
+(@PATH,2,3717.946,244.38,169.6936,0,0,0,100,0),
+(@PATH,1,3542.247,134.1484,169.6936,0,0,0,100,0);
+
+SET @NPC := 100824;
+SET @PATH := @NPC*10;
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,14,3559.792,412.912,244.8625,0,0,0,100,0),
+(@PATH,13,3625.949,456.7731,244.8625,0,0,0,100,0),
+(@PATH,12,3683.285,437.189,244.8625,0,0,0,100,0),
+(@PATH,11,3727.341,385.3615,244.8625,0,0,0,100,0),
+(@PATH,10,3786.656,388.9702,244.8625,0,0,0,100,0),
+(@PATH,9,3811.097,463.1342,244.8625,0,0,0,100,0),
+(@PATH,8,3769.007,516.1342,244.8625,0,0,0,100,0),
+(@PATH,7,3685.209,493.7117,244.8625,0,0,0,100,0),
+(@PATH,6,3589.482,475.7777,244.8625,0,0,0,100,0),
+(@PATH,5,3491.84,496.9259,244.8625,0,0,0,100,0),
+(@PATH,4,3406.895,485.8197,244.8625,0,0,0,100,0),
+(@PATH,3,3370.333,427.0351,244.8625,0,0,0,100,0),
+(@PATH,2,3411.417,366.7467,244.8625,0,0,0,100,0),
+(@PATH,1,3479.214,376.5652,244.8625,0,0,0,100,0);
+
+DELETE FROM `waypoint_data` WHERE `id`=1241240;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(1241240, 26, 4024.11, 7168.08, 232.048,0,0,0,100,0),
+(1241240, 25, 4012.89, 7180.92, 232.048,0,0,0,100,0),
+(1241240, 24, 3994.29, 7197.3, 232.048,0,0,0,100,0),
+(1241240, 23, 3962.67, 7211.43, 232.048,0,0,0,100,0),
+(1241240, 22, 3928.03, 7221.9, 232.048,0,0,0,100,0),
+(1241240, 21, 3903.5, 7236.1, 237.687,0,0,0,100,0),
+(1241240, 20, 3882.38, 7232.92, 242.242,0,0,0,100,0),
+(1241240, 19, 3858.55, 7224.29, 241.215,0,0,0,100,0),
+(1241240, 18, 3844.43, 7205.01, 231.298,0,0,0,100,0),
+(1241240, 17, 3844.95, 7183.08, 225.631,0,0,0,100,0),
+(1241240, 16, 3853.11, 7151.16, 217.326,0,0,0,100,0),
+(1241240, 15, 3870.74, 7131.27, 210.326,0,0,0,100,0),
+(1241240, 14, 3896.19, 7103.67, 211.27,0,0,0,100,0),
+(1241240, 13, 3918.27, 7080.29, 210.742,0,0,0,100,0),
+(1241240, 12, 3937.72, 7052.57, 210.27,0,0,0,100,0),
+(1241240, 11, 3952.93, 7028.98, 209.187,0,0,0,100,0),
+(1241240, 10, 3971.03, 7002.62, 209.881,0,0,0,100,0),
+(1241240, 9, 4004.69, 6989.1, 213.854,0,0,0,100,0),
+(1241240, 8, 4041.09, 7000.58, 221.326,0,0,0,100,0),
+(1241240, 7, 4071.54, 7033.09, 221.52,0,0,0,100,0),
+(1241240, 6, 4086.07, 7065.28, 224.604,0,0,0,100,0),
+(1241240, 5, 4097.13, 7102.44, 232.048,0,0,0,100,0),
+(1241240, 4, 4095.98, 7138.24, 243.492,0,0,0,100,0),
+(1241240, 3, 4083.88, 7155.52, 249.465,0,0,0,100,0),
+(1241240, 2, 4058.74, 7162.29, 244.631,0,0,0,100,0),
+(1241240, 1, 4038.05, 7165.02, 238.298,0,0,0,100,0);