diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2021_08_14_06_world_335.sql | 96 |
1 files changed, 96 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2021_08_14_06_world_335.sql b/sql/updates/world/3.3.5/2021_08_14_06_world_335.sql new file mode 100644 index 00000000000..76631f2294b --- /dev/null +++ b/sql/updates/world/3.3.5/2021_08_14_06_world_335.sql @@ -0,0 +1,96 @@ +-- +UPDATE `creature` SET `position_x`=-9493.627,`position_y`=67.18815,`position_z`=56.24675 WHERE `guid`=80283; +DELETE FROM `waypoint_data` WHERE `id`=802830; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(802830,1,-9493.627,67.18815,56.24675,0,0,0,0,100,0), +(802830,2,-9486.809,89.65723,56.21941,0,0,0,0,100,0), +(802830,3,-9483.946,102.302,56.50797,0,0,0,0,100,0), +(802830,4,-9480.245,126.3048,56.63297,0,0,0,0,100,0), +(802830,5,-9482.919,145.2651,56.43309,0,0,0,0,100,0), +(802830,6,-9485.429,167.3975,56.05416,0,0,0,0,100,0), +(802830,7,-9484.816,180.0712,55.42916,0,0,0,0,100,0), +(802830,8,-9493.019,196.9338,54.55416,0,0,0,0,100,0), +(802830,9,-9508.471,218.0667,52.96415,0,0,0,0,100,0), +(802830,10,-9533.104,242.1964,50.86973,0,0,0,0,100,0), +(802830,11,-9519.216,232.3553,51.83915,0,0,0,0,100,0), +(802830,12,-9515.605,227.5241,52.2238,0,0,0,0,100,0), +(802830,13,-9503.669,216.6386,52.90214,0,0,0,0,100,0), +(802830,14,-9498.017,202.3757,54.15273,0,0,0,0,100,0), +(802830,15,-9486.037,183.3565,55.22677,0,0,0,0,100,0), +(802830,16,-9483.614,166.1485,56.05247,0,0,0,0,100,0), +(802830,17,-9481.871,138.393,56.67747,0,0,0,0,100,0), +(802830,18,-9483.646,118.8074,56.60807,0,0,0,0,100,0), +(802830,19,-9486.335,100.2849,56.50797,0,0,0,0,100,0), +(802830,20,-9487.605,81.91924,56.0739,0,0,0,0,100,0), +(802830,21,-9485.286,71.61192,56.40178,0,0,0,0,100,0), +(802830,22,-9479.711,67.17296,56.32232,0,0,0,0,100,0), +(802830,23,-9467.877,61.33068,56.1054,0,0,0,0,100,0), +(802830,24,-9454.594,66.6288,56.20298,0,0,0,0,100,0), +(802830,25,-9415.596,86.5546,56.99038,0,0,0,0,100,0), +(802830,26,-9402.721,93.8989,58.41055,0,0,0,0,100,0), +(802830,27,-9383.628,105.0891,60.03624,0,0,0,0,100,0), +(802830,28,-9362.592,111.672,61.55702,0,0,0,0,100,0), +(802830,29,-9337.428,124.4685,63.71767,0,0,0,0,100,0), +(802830,30,-9316.489,136.0714,64.95474,0,0,0,0,100,0), +(802830,31,-9298.161,143.4155,65.91209,0,0,0,0,100,0), +(802830,32,-9273.096,151.2024,67.00413,0,0,0,0,100,0), +(802830,33,-9256.78,159.3222,67.66848,0,0,0,0,100,0), +(802830,34,-9242.877,174.1646,67.97204,0,0,0,0,100,0), +(802830,35,-9232.261,186.1395,67.72204,0,0,0,0,100,0), +(802830,36,-9217.805,203.6647,69.03122,0,0,0,0,100,0), +(802830,37,-9201.397,220.0502,71.15402,0,0,0,0,100,0), +(802830,38,-9188.232,236.8916,72.44244,0,0,0,0,100,0), +(802830,39,-9182.984,255.7783,73.85345,0,0,0,0,100,0), +(802830,40,-9182.252,275.1166,75.44212,0,0,0,0,100,0), +(802830,41,-9180.925,301.3294,78.33094,0,0,0,0,100,0), +(802830,42,-9178.171,323.0379,80.88319,0,0,0,0,100,0), +(802830,43,-9173.903,335.753,83.66998,0,0,0,0,100,0), +(802830,44,-9168.686,347.0231,86.27471,0,0,0,0,100,0), +(802830,45,-9142.421,375.9646,90.75526,0,0,0,0,100,0), +(802830,46,-9125.449,389.9619,91.57055,0,0,0,0,100,0), +(802830,47,-9144.014,376.6461,90.75526,0,0,0,0,100,0), +(802830,48,-9150.359,370.6424,90.63026,0,0,0,0,100,0), +(802830,49,-9159.769,358.9712,89.09229,0,0,0,0,100,0), +(802830,50,-9169.689,347.3052,86.06768,0,0,0,0,100,0), +(802830,51,-9176.393,336.1326,83.34795,0,0,0,0,100,0), +(802830,52,-9179.039,324.0334,81.12244,0,0,0,0,100,0), +(802830,53,-9181.582,310.6828,79.00208,0,0,0,0,100,0), +(802830,54,-9182.38,299.1464,77.95396,0,0,0,0,100,0), +(802830,55,-9183.653,286.0146,76.42735,0,0,0,0,100,0), +(802830,56,-9184.186,259.5755,74.10345,0,0,0,0,100,0), +(802830,57,-9187.476,239.7987,72.50726,0,0,0,0,100,0), +(802830,58,-9193.939,228.3685,71.82954,0,0,0,0,100,0), +(802830,59,-9217.061,204.2547,69.10202,0,0,0,0,100,0), +(802830,60,-9229.925,191.6477,68.03234,0,0,0,0,100,0), +(802830,61,-9239.118,181.4567,67.84704,0,0,0,0,100,0), +(802830,62,-9252.867,160.5058,67.88796,0,0,0,0,100,0), +(802830,63,-9270.517,152.484,67.12913,0,0,0,0,100,0), +(802830,64,-9281.984,150.6615,66.75413,0,0,0,0,100,0), +(802830,65,-9303.524,142.9477,65.81363,0,0,0,0,100,0), +(802830,66,-9326.493,133.6549,64.28152,0,0,0,0,100,0), +(802830,67,-9338.177,126.1314,63.79213,0,0,0,0,100,0), +(802830,68,-9357.066,114.8676,62.03004,0,0,0,0,100,0), +(802830,69,-9376.01,105.7821,60.5753,0,0,0,0,100,0), +(802830,70,-9396.483,100.0127,58.82322,0,0,0,0,100,0), +(802830,71,-9415.729,90.13653,57.42837,0,0,0,0,100,0), +(802830,72,-9430.02,79.53779,56.53139,0,0,0,0,100,0), +(802830,73,-9441.903,69.07547,56.12108,0,0,0,0,100,0), +(802830,74,-9459.128,61.95774,55.895,0,0,0,0,100,0), +(802830,75,-9471.797,63.62576,56.15252,0,0,0,0,100,0), +(802830,76,-9492.84,58.88786,55.85588,0,0,0,0,100,0), +(802830,77,-9502.176,40.73476,56.34699,0,0,0,0,100,0), +(802830,78,-9513.744,15.73003,56.48589,0,0,0,0,100,0), +(802830,79,-9519.953,3.746257,56.11089,0,0,0,0,100,0), +(802830,80,-9526.677,-8.577745,55.88026,0,0,0,0,100,0), +(802830,81,-9535.507,-27.89106,55.83387,0,0,0,0,100,0), +(802830,82,-9544.865,-53.43615,56.81581,0,0,0,0,100,0), +(802830,83,-9550.579,-84.43788,57.65163,0,0,0,0,100,0), +(802830,84,-9550.719,-113.8145,57.65856,0,0,0,0,100,0), +(802830,85,-9549.074,-80.8469,57.51955,0,0,0,0,100,0), +(802830,86,-9543.954,-52.83002,56.81581,0,0,0,0,100,0), +(802830,87,-9537.006,-30.56196,55.88392,0,0,0,0,100,0), +(802830,88,-9529.335,-14.98915,55.83778,0,0,0,0,100,0), +(802830,89,-9522.49,-4.730361,55.99379,0,0,0,0,100,0), +(802830,90,-9517.441,9.093316,56.23589,0,0,0,0,100,0), +(802830,91,-9508.014,28.54688,56.48589,0,0,0,0,100,0), +(802830,92,-9496.207,50.32487,55.88494,0,0,0,0,100,0); |