aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2019-03-26 18:33:13 +0100
committerShauren <shauren.trinity@gmail.com>2021-11-24 22:59:19 +0100
commit75ec727e021c1a365b6784a2b7907bb7168ec945 (patch)
tree98e12b41b360a95c35ac84f0d503239c67dce3ea
parent4261a1ca5e39a5595d757e8c33beffc0ff3fb3ad (diff)
DB/Creature: Great Reef Shark & Orca part2
(cherry picked from commit ac8238c6342675041800eb49a3b5a0980da1e29d)
-rw-r--r--sql/updates/world/master/2021_11_24_42_world_2019_03_26_01_world.sql319
1 files changed, 319 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_11_24_42_world_2019_03_26_01_world.sql b/sql/updates/world/master/2021_11_24_42_world_2019_03_26_01_world.sql
new file mode 100644
index 00000000000..9d87ebeaeb8
--- /dev/null
+++ b/sql/updates/world/master/2021_11_24_42_world_2019_03_26_01_world.sql
@@ -0,0 +1,319 @@
+--
+DELETE FROM `creature` WHERE `guid` IN (134527,101752,101750,101748,101779,101780,101749) AND `id`=24637;
+DELETE FROM `spawn_group` WHERE `SpawnId` IN (134527,101752,101750,101748,101779,101780,101749) AND `spawnType`=0;
+
+UPDATE `creature` SET `spawndist`=0, `MovementType`=2 WHERE `guid` IN (134526,97757,97756,54256,134524,134529,97753,134525,134528,97758,97731,134523,101746,101740,54259,97763,97789,101798,101799,100474,100469,100475,97880,134519,97846);
+DELETE FROM `creature_addon` WHERE `guid` IN (134526,97757,97756,54256,134524,134529,97753,134525,134528,97758,97731,134523,101746,101740,54259,97763,97789,101798,101799,100474,100469,100475,97880,134519,97846);
+INSERT INTO `creature_addon` (`guid`, `path_id`) VALUES
+(134526, 1345260),(97757, 977570),(97756, 977560),(54256, 542560),(134524,1345240),(134529,1345290),(97753,977530),(134525,1345250),(134528,1345280),(97758,977580),(97731,977310),(134523,1345230),(101746,1017460),(101740,1017400),(54259,542590),(97763,977630),(97789,977890),(101798,1017980),(101799,1017990),(100474,1004740),(100469,1004690),(100475,1004750),(97880,978800),(134519,1345190),(97846,978460);
+
+DELETE FROM `waypoint_data` WHERE `id` IN (1345260,977570,977560,542560,1345240,1345290,977530,1345250,1345280,977580,977310,1345230,1017460,1017400,977890,1017980,1017990,542590,977630,1004740,1004690,1004750,978800,1345190,978460);
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `action_chance`) VALUES
+(1345260, 1, -178.19140, -3220.88476, -1.089, 100),
+(1345260, 2, -175.61610, -3257.77026, -1.089, 100),
+(1345260, 3, -195.50367, -3290.54126, -1.089, 100),
+(1345260, 4, -224.77066, -3313.37890, -1.089, 100),
+(1345260, 5, -257.08056, -3282.47412, -1.089, 100),
+(1345260, 6, -296.54544, -3242.22558, -1.089, 100),
+(1345260, 7, -276.15615, -3208.87768, -1.089, 100),
+(1345260, 8, -208.64962, -3178.07714, -1.089, 100),
+(1345260, 9, -176.21484, -3221.96484, -1.089, 100),
+(977570, 1, -135.272, -3769.125, -1.54618, 100),
+(977570, 2, -167.715, -3755.004, -1.54618, 100),
+(977570, 3, -216.870, -3753.588, -1.54618, 100),
+(977570, 4, -254.328, -3774.173, -1.54618, 100),
+(977570, 5, -253.746, -3823.340, -1.54618, 100),
+(977570, 6, -247.485, -3858.234, -1.54618, 100),
+(977570, 7, -192.214, -3864.409, -1.54618, 100),
+(977570, 8, -153.820, -3839.142, -1.54618, 100),
+(977570, 9, -140.916, -3800.253, -1.54618, 100),
+(977570, 10, -135.272, -3769.12, -1.54618, 100),
+(977560, 1, -107.69, -3891.3208, -1.61583,100),
+(977560, 2, -68.729, -3907.762, -1.61583,100),
+(977560, 3, -40.329, -3943.995, -1.61583,100),
+(977560, 4, -41.809, -3969.983, -1.61583,100),
+(977560, 5, -64.392, -3973.788, -1.61583,100),
+(977560, 6, -97.449, -3968.241, -1.61583,100),
+(977560, 7, -128.185, -3961.960, -1.61583,100),
+(977560, 8, -151.959, -3964.451, -1.61583,100),
+(977560, 9, -181.215, -3976.930, -1.61583,100),
+(977560, 10, -209.958, -3983.197, -1.61583,100),
+(977560, 11, -220.657, -3960.428, -1.61583,100),
+(977560, 12, -222.835, -3927.491, -1.61583,100),
+(977560, 13, -215.674, -3886.774, -1.61583,100),
+(977560, 14, -190.656, -3860.308, -1.61583,100),
+(977560, 15, -170.036, -3840.534, -1.61583,100),
+(977560, 16, -149.027, -3843.768, -1.61583,100),
+(977560, 17, -129.050, -3849.574, -1.61583,100),
+(977560, 18, -107.691, -3891.320, -1.61583,100),
+(542560, 1, -91.942, -3238.544, -1.5214, 100),
+(542560, 2, -114.926, -3256.371, -1.5214, 100),
+(542560, 3, -132.438, -3270.081, -1.5214, 100),
+(542560, 4, -162.989, -3278.457, -1.5214, 100),
+(542560, 5, -195.433, -3287.233, -1.5214, 100),
+(542560, 6, -218.944, -3293.580, -1.5214, 100),
+(542560, 7, -226.507, -3307.878, -1.5214, 100),
+(542560, 8, -218.501, -3322.086, -1.5214, 100),
+(542560, 9, -203.014, -3325.130, -1.5214, 100),
+(542560, 10, -179.868, -3315.421, -1.5214, 100),
+(542560, 11, -158.055, -3308.261, -1.5214, 100),
+(542560, 12, -129.228, -3291.947, -1.5214, 100),
+(542560, 13, -109.375, -3283.626, -1.5214, 100),
+(542560, 14, -81.527, -3277.270, -1.5214, 100),
+(542560, 15, -60.986, -3262.188, -1.5214, 100),
+(542560, 16, -59.008, -3233.678, -1.5214, 100),
+(542560, 17, -75.029, -3237.895, -1.5214, 100),
+(1345240, 1, -56.237, -3058.839, -1.78777, 100),
+(1345240, 2, -53.297, -3021.344, -1.78777, 100),
+(1345240, 3, -61.263, -3006.809, -1.78777, 100),
+(1345240, 4, -72.017, -2987.502, -1.78777, 100),
+(1345240, 5, -87.465, -2978.876, -1.78777, 100),
+(1345240, 6, -108.756, -2969.761, -1.78777, 100),
+(1345240, 7, -135.152, -2970.602, -1.78777, 100),
+(1345240, 8, -165.930, -2978.978, -1.78777, 100),
+(1345240, 9, -179.362, -2997.731, -1.78777, 100),
+(1345240, 10, -185.327, -3026.939, -1.78777, 100),
+(1345240, 11, -169.540, -3057.981, -1.78777, 100),
+(1345240, 12, -134.582, -3090.131, -1.78777, 100),
+(1345240, 13, -97.169, -3092.837, -1.78777, 100),
+(1345240, 14, -80.268, -3078.499, -1.78777, 100),
+(1345290, 1, -12.483, -3189.730, -1.88411, 100),
+(1345290, 2, -27.681, -3210.118, -1.88411, 100),
+(1345290, 3, -44.496, -3226.150, -1.88411, 100),
+(1345290, 4, -63.653, -3244.551, -1.88411, 100),
+(1345290, 5, -76.919, -3257.928, -1.88411, 100),
+(1345290, 6, -51.894, -3277.361, -1.88411, 100),
+(1345290, 7, -25.979, -3283.028, -1.88411, 100),
+(1345290, 8, 10.043, -3255.927, -1.88411, 100),
+(1345290, 9, 16.088, -3235.854, -1.88411, 100),
+(1345290, 10, 7.969, -3217.682, -1.88411, 100),
+(1345290, 11, -5.409, -3197.317, -1.88411, 100),
+(977530, 1, -0.799, -3728.150, -1.73373, 100),
+(977530, 2, -41.401, -3696.214, -1.73373, 100),
+(977530, 3, -75.176, -3699.148, -1.73373, 100),
+(977530, 4, -102.276, -3702.385, -1.73373, 100),
+(977530, 5, -128.381, -3710.329, -1.73373, 100),
+(977530, 6, -142.482, -3722.874, -1.73373, 100),
+(977530, 7, -136.399, -3751.016, -1.73373, 100),
+(977530, 8, -99.556, -3752.630, -1.73373, 100),
+(977530, 9, -64.293, -3749.483, -1.73373, 100),
+(977530, 10, -23.515, -3742.821, -1.73373, 100),
+(1345250, 1, 7.7921, -3121.860, -1.69252, 100),
+(1345250, 2, 44.371, -3117.223, -1.69252, 100),
+(1345250, 3, 69.551, -3108.693, -1.69252, 100),
+(1345250, 4, 77.651, -3098.289, -1.69252, 100),
+(1345250, 5, 79.135, -3068.111, -1.69252, 100),
+(1345250, 6, 74.091, -3046.957, -1.69252, 100),
+(1345250, 7, 60.798, -3039.055, -1.69252, 100),
+(1345250, 8, 30.964, -3034.649, -1.69252, 100),
+(1345280, 1, 12.856, -3052.450, -1.77095, 100),
+(1345280, 2, 32.466, -3029.106, -1.77095, 100),
+(1345280, 3, 68.421, -3029.793, -1.77095, 100),
+(1345280, 4, 88.241, -3046.280, -1.77095, 100),
+(1345280, 5, 93.500, -3072.290, -1.77095, 100),
+(1345280, 6, 79.899, -3088.801, -1.77095, 100),
+(1345280, 7, 53.504, -3088.600, -1.77095, 100),
+(1345280, 8, 24.393, -3080.491, -1.77095, 100),
+(977580, 1, 17.011, -3911.200, -1.78777, 100),
+(977580, 2, -4.243, -3896.609, -1.78777, 100),
+(977580, 3, -37.486, -3879.183, -1.78777, 100),
+(977580, 4, -75.083, -3876.502, -1.78777, 100),
+(977580, 5, -84.929, -3894.692, -1.78777, 100),
+(977580, 6, -72.302, -3908.089, -1.78777, 100),
+(977580, 7, -57.237, -3929.823, -1.78777, 100),
+(977580, 8, -42.639, -3957.142, -1.78777, 100),
+(977580, 9, -16.259, -3965.184, -1.78777, 100),
+(977580, 10, 5.376, -3952.662, -1.78777, 100),
+(977580, 11, 11.524, -3937.625, -1.78777, 100),
+(977310, 1, 54.851, -3816.060, -1.73447, 100),
+(977310, 2, 39.079, -3838.333, -1.73447, 100),
+(977310, 3, 30.949, -3853.208, -1.73447, 100),
+(977310, 4, 4.0180, -3871.647, -1.73447, 100),
+(977310, 5, 13.805, -3893.769, -1.73447, 100),
+(977310, 6, 31.404, -3888.467, -1.73447, 100),
+(977310, 7, 53.653, -3876.931, -1.73447, 100),
+(977310, 8, 69.053, -3854.402, -1.73447, 100),
+(977310, 9, 64.809, -3839.506, -1.73447, 100),
+(1345230, 1, 123.12, -2996.760, -1.83427, 100),
+(1345230, 2, 85.244, -2977.095, -1.83427, 100),
+(1345230, 3, 51.374, -2933.640, -1.83427, 100),
+(1345230, 4, 48.431, -2911.102, -1.83427, 100),
+(1345230, 5, 86.436, -2887.638, -1.83427, 100),
+(1345230, 6, 127.037, -2898.678, -1.83427, 100),
+(1345230, 7, 162.514, -2915.115, -1.83427, 100),
+(1345230, 8, 197.360, -2934.364, -1.83427, 100),
+(1345230, 9, 218.053, -2962.130, -1.83427, 100),
+(1345230, 10, 220.536, -2994.917, -1.83427, 100),
+(1345230, 11, 192.300, -3014.477, -1.83427, 100),
+(1345230, 12, 158.032, -3012.762, -1.83427, 100),
+(1017460, 1, 239.109, -3679.640, -1.90007, 100),
+(1017460, 2, 275.360, -3673.851, -1.90007, 100),
+(1017460, 3, 297.867, -3666.715, -1.90007, 100),
+(1017460, 4, 356.002, -3655.866, -1.90007, 100),
+(1017460, 5, 377.948, -3682.652, -1.90007, 100),
+(1017460, 6, 361.623, -3703.445, -1.90007, 100),
+(1017460, 7, 336.670, -3716.053, -1.90007, 100),
+(1017460, 8, 277.720, -3734.125, -1.90007, 100),
+(1017460, 9, 242.385, -3736.168, -1.90007, 100),
+(1017460, 10, 216.658, -3733.857, -1.90007, 100),
+(1017460, 11, 195.136, -3712.580, -1.90007, 100),
+(1017460, 12, 184.811, -3670.613, -1.90007, 100),
+(1017460, 13, 194.529, -3663.914, -1.90007, 100),
+(1017460, 14, 208.284, -3666.443, -1.90007, 100),
+(1017400, 1, 314.235, -3687.390, -1.71962, 100),
+(1017400, 2, 354.406, -3670.704, -1.71962, 100),
+(1017400, 3, 386.688, -3647.338, -1.71962, 100),
+(1017400, 4, 417.562, -3631.685, -1.71962, 100),
+(1017400, 5, 446.478, -3639.054, -1.71962, 100),
+(1017400, 6, 447.155, -3664.876, -1.71962, 100),
+(1017400, 7, 440.476, -3685.828, -1.71962, 100),
+(1017400, 8, 411.726, -3708.646, -1.71962, 100),
+(1017400, 9, 392.127, -3711.993, -1.71962, 100),
+(1017400, 10, 365.489, -3724.618, -1.71962, 100),
+(1017400, 11, 331.604, -3731.901, -1.71962, 100),
+(1017400, 12, 302.858, -3732.119, -1.71962, 100),
+(1017400, 13, 283.225, -3725.688, -1.71962, 100),
+(1017400, 14, 274.197, -3710.517, -1.71962, 100),
+(1017400, 15, 297.642, -3687.497, -1.71962, 100),
+(542590, 1, 318.389, -3608.560, -1.70646, 100),
+(542590, 2, 279.338, -3623.926, -1.70646, 100),
+(542590, 3, 266.291, -3647.865, -1.70646, 100),
+(542590, 4, 248.542, -3684.340, -1.70646, 100),
+(542590, 5, 244.616, -3709.931, -1.70646, 100),
+(542590, 6, 264.318, -3712.919, -1.70646, 100),
+(542590, 7, 295.043, -3703.279, -1.70646, 100),
+(542590, 8, 320.361, -3688.189, -1.70646, 100),
+(542590, 9, 353.666, -3682.558, -1.70646, 100),
+(542590, 10, 369.942, -3664.672, -1.70646, 100),
+(542590, 11, 371.423, -3636.672, -1.70646, 100),
+(542590, 12, 361.752, -3616.007, -1.70646, 100),
+(542590, 13, 351.341, -3607.779, -1.70646, 100),
+(977630, 1, 359.046, -3492.860, -1.88047, 100),
+(977630, 2, 377.283, -3534.649, -1.88047, 100),
+(977630, 3, 389.101, -3571.861, -1.88047, 100),
+(977630, 4, 416.230, -3594.330, -1.88047, 100),
+(977630, 5, 440.541, -3579.358, -1.88047, 100),
+(977630, 6, 440.608, -3555.986, -1.88047, 100),
+(977630, 7, 430.716, -3514.187, -1.88047, 100),
+(977630, 8, 418.122, -3488.339, -1.88047, 100),
+(977630, 9, 406.393, -3435.741, -1.88047, 100),
+(977630, 10, 376.258, -3418.498, -1.88047, 100),
+(977630, 11, 353.069, -3435.681, -1.88047, 100),
+(977630, 12, 346.578, -3452.965, -1.88047, 100),
+(977890, 1, 433.782, -3539.520, -1.72213, 100),
+(977890, 2, 471.865, -3551.203, -1.68850, 100),
+(977890, 3, 502.452, -3565.878, -1.68850, 100),
+(977890, 4, 530.357, -3589.356, -1.68850, 100),
+(977890, 5, 534.588, -3614.074, -1.68850, 100),
+(977890, 6, 522.432, -3638.967, -1.68850, 100),
+(977890, 7, 495.376, -3658.352, -1.68850, 100),
+(977890, 8, 468.065, -3661.448, -1.68850, 100),
+(977890, 9, 439.845, -3649.183, -1.68850, 100),
+(977890, 10, 424.012, -3621.577, -1.68850, 100),
+(977890, 11, 415.327, -3588.083, -1.68850, 100),
+(977890, 12, 415.862, -3560.258, -1.68850, 100),
+(1017980, 1, 2328.350, 5043.590, -14.56250, 100),
+(1017980, 2, 2311.019, 5073.538, -14.56250, 100),
+(1017980, 3, 2307.831, 5089.989, -14.56250, 100),
+(1017980, 4, 2323.202, 5102.323, -14.56250, 100),
+(1017980, 5, 2343.469, 5095.246, -14.56250, 100),
+(1017980, 6, 2347.354, 5058.339, -14.56250, 100),
+(1017980, 7, 2340.368, 5023.554, -14.56250, 100),
+(1017980, 8, 2335.301, 4998.231, -14.56250, 100),
+(1017980, 9, 2309.956, 5017.784, -14.56250, 100),
+(1017990, 1, 2368.110, 5019.140, -12.95290, 100),
+(1017990, 2, 2380.458, 4998.106, -12.17708, 100),
+(1017990, 3, 2372.448, 4977.898, -12.68714, 100),
+(1017990, 4, 2355.628, 4981.614, -19.38374, 100),
+(1017990, 5, 2354.135, 4997.606, -17.30708, 100),
+(1017990, 6, 2353.177, 5016.381, -13.66882, 100),
+(1017990, 7, 2356.125, 5039.826, -7.773650, 100),
+(1004740, 1, 884.651, -6148.100, -1.79357, 100),
+(1004740, 2, 847.445, -6140.337, -1.79357, 100),
+(1004740, 3, 808.499, -6122.439, -1.79357, 100),
+(1004740, 4, 779.279, -6143.680, -1.79357, 100),
+(1004740, 5, 746.009, -6160.957, -1.79357, 100),
+(1004740, 6, 729.383, -6177.561, -1.79357, 100),
+(1004740, 7, 736.379, -6195.015, -1.79357, 100),
+(1004740, 8, 770.739, -6208.076, -1.79357, 100),
+(1004740, 9, 807.232, -6217.005, -1.79357, 100),
+(1004740, 10, 840.171, -6208.443, -1.79357, 100),
+(1004740, 11, 864.804, -6192.317, -1.79357, 100),
+(1004740, 12, 884.580, -6178.163, -1.79357, 100),
+(1004690, 1, 895.303, -6215.690, -1.77848, 100),
+(1004690, 2, 931.163, -6215.083, -1.77848, 100),
+(1004690, 3, 963.089, -6241.313, -1.77848, 100),
+(1004690, 4, 987.759, -6262.374, -1.77848, 100),
+(1004690, 5, 1013.831, -6286.340, -1.77848, 100),
+(1004690, 6, 1023.835, -6313.716, -3.14371, 100),
+(1004690, 7, 1003.886, -6333.667, -1.68851, 100),
+(1004690, 8, 961.138, -6314.424, -1.68851, 100),
+(1004690, 9, 938.300, -6279.411, -1.75174, 100),
+(1004690, 10, 922.899, -6238.828, -1.75174, 100),
+(1004750, 1, 201.019, -3458.440, -1.71607, 100),
+(1004750, 2, 232.980, -3430.003, -1.71607, 100),
+(1004750, 3, 273.094, -3415.840, -1.71607, 100),
+(1004750, 4, 317.208, -3419.204, -1.71607, 100),
+(1004750, 5, 366.746, -3432.938, -1.71607, 100),
+(1004750, 6, 381.064, -3472.649, -1.71607, 100),
+(1004750, 7, 375.751, -3496.251, -1.71607, 100),
+(1004750, 8, 348.674, -3525.972, -1.71607, 100),
+(1004750, 9, 322.364, -3511.167, -1.71607, 100),
+(1004750, 10, 294.582, -3495.954, -1.71607, 100),
+(1004750, 11, 263.302, -3476.646, -1.71607, 100),
+(1004750, 12, 234.945, -3472.642, -1.71607, 100),
+(978800, 1, 904.984, -2792.140, -1.78777, 100),
+(978800, 2, 863.563, -2799.208, -1.78777, 100),
+(978800, 3, 810.088, -2805.591, -1.78777, 100),
+(978800, 4, 781.367, -2805.082, -1.78777, 100),
+(978800, 5, 770.252, -2784.359, -1.78777, 100),
+(978800, 6, 775.811, -2755.422, -1.78777, 100),
+(978800, 7, 797.161, -2730.622, -1.78777, 100),
+(978800, 8, 825.779, -2728.678, -1.78777, 100),
+(978800, 9, 859.567, -2730.338, -1.78777, 100),
+(978800, 10, 866.824, -2746.432, -1.78777, 100),
+(1345190, 1, 168.621, -2742.330, -1.84160, 100),
+(1345190, 2, 207.608, -2739.418, -1.70824, 100),
+(1345190, 3, 249.636, -2739.630, -1.70824, 100),
+(1345190, 4, 275.430, -2750.125, -1.70824, 100),
+(1345190, 5, 304.355, -2767.815, -1.70824, 100),
+(1345190, 6, 319.351, -2788.786, -1.70824, 100),
+(1345190, 7, 336.256, -2812.979, -1.70824, 100),
+(1345190, 8, 352.478, -2838.527, -1.70824, 100),
+(1345190, 9, 359.251, -2860.401, -1.70824, 100),
+(1345190, 10, 359.660, -2890.847, -1.70824, 100),
+(1345190, 11, 338.885, -2895.948, -1.70824, 100),
+(1345190, 12, 315.342, -2902.212, -1.70824, 100),
+(1345190, 13, 285.986, -2912.250, -1.70824, 100),
+(1345190, 14, 266.480, -2919.127, -1.70824, 100),
+(1345190, 15, 242.117, -2919.346, -1.70824, 100),
+(1345190, 16, 203.806, -2921.793, -1.70824, 100),
+(1345190, 17, 169.442, -2918.557, -1.70824, 100),
+(1345190, 18, 141.073, -2908.250, -1.70824, 100),
+(1345190, 19, 118.989, -2893.533, -1.70824, 100),
+(1345190, 20, 125.656, -2863.286, -1.70824, 100),
+(1345190, 21, 128.016, -2828.705, -1.70824, 100),
+(1345190, 22, 124.191, -2785.347, -1.70824, 100),
+(1345190, 23, 135.291, -2752.185, -1.68852, 100),
+(978460, 1, -95.155, -3095.260, -1.74494, 100),
+(978460, 2, -134.563, -3126.269, -1.74494, 100),
+(978460, 3, -164.723, -3162.275, -1.74494, 100),
+(978460, 4, -177.257, -3188.715, -1.74494, 100),
+(978460, 5, -175.235, -3221.346, -1.74494, 100),
+(978460, 6, -156.022, -3265.201, -1.74494, 100),
+(978460, 7, -140.444, -3281.037, -1.74494, 100),
+(978460, 8, -108.838, -3265.697, -1.68851, 100),
+(978460, 9, -84.571, -3235.948, -1.68851, 100),
+(978460, 10, -69.744, -3209.839, -1.68851, 100),
+(978460, 11, -61.023, -3172.502, -1.68851, 100),
+(978460, 12, -47.047, -3140.830, -1.68851, 100),
+(978460, 13, -53.080, -3116.563, -1.68851, 100);
+
+UPDATE `waypoint_data` SET `position_x`=619.3435, `position_y`= -2534.014, `position_z`= -1.92944 WHERE `id`=1345200 AND `point`=16;
+UPDATE `waypoint_data` SET `position_x`=675.4564, `position_y`= -2561.505, `position_z`= -1.92944 WHERE `id`=1345200 AND `point`=17;
+UPDATE `waypoint_data` SET `position_x`=732.1259, `position_y`= -2602.046, `position_z`= -1.92944 WHERE `id`=1345200 AND `point`=18;
+UPDATE `waypoint_data` SET `position_x`=764.5170, `position_y`= -2642.866, `position_z`= -1.92944 WHERE `id`=1345200 AND `point`=19;
+UPDATE `waypoint_data` SET `position_x`=750.1561, `position_y`= -2673.675, `position_z`= -1.92944 WHERE `id`=1345200 AND `point`=20;
+UPDATE `waypoint_data` SET `position_x`=706.2441, `position_y`= -2688.023, `position_z`= -1.92944 WHERE `id`=1345200 AND `point`=21;
+UPDATE `waypoint_data` SET `position_x`= -346.954346, `position_y`= -4042.656494, `position_z`= -1.87226 WHERE `id`=1345220 AND `point`=4;
+UPDATE `waypoint_data` SET `position_x`= -369.076416, `position_y`= -4008.857422, `position_z`= -1.87226 WHERE `id`=1345220 AND `point`=5;