diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2018_07_08_01_world_335.sql | 163 |
1 files changed, 163 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_07_08_01_world_335.sql b/sql/updates/world/3.3.5/2018_07_08_01_world_335.sql new file mode 100644 index 00000000000..c611eaddadd --- /dev/null +++ b/sql/updates/world/3.3.5/2018_07_08_01_world_335.sql @@ -0,0 +1,163 @@ +-- Defias Messenger +DELETE FROM `waypoint_data` WHERE `id`=455250; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(455250,1,-11024.3,1458.48,42.9863,0,0,0,0,100,0), +(455250,2,-11018.3,1434.54,43.1113,0,0,0,0,100,0), +(455250,3,-10999.9,1416.52,43.1031,0,0,0,0,100,0), +(455250,4,-10983.1,1410.91,42.9781,0,0,0,0,100,0), +(455250,5,-10965.8,1418.47,43.1677,0,0,0,0,100,0), +(455250,6,-10933.5,1423.93,43.0427,0,0,0,0,100,0), +(455250,7,-10915.6,1419.7,42.8789,0,0,0,0,100,0), +(455250,8,-10910.1,1432.67,42.5049,0,0,0,0,100,0), +(455250,9,-10900,1445.11,41.7178,0,0,0,0,100,0), +(455250,10,-10885.3,1457.35,40.7271,0,0,0,0,100,0), +(455250,11,-10866.9,1466.69,41.7989,0,0,0,0,100,0), +(455250,12,-10833.4,1477.93,44.4321,0,0,0,0,100,0), +(455250,13,-10799.9,1489.47,46.8256,0,0,0,0,100,0), +(455250,14,-10766.5,1498.05,47.711,0,0,0,0,100,0), +(455250,15,-10733,1502.48,48.0632,0,0,0,0,100,0), +(455250,16,-10700.1,1502.66,47.1882,0,0,0,0,100,0), +(455250,17,-10666.7,1507.09,46.5445,0,0,0,0,100,0), +(455250,18,-10633.3,1539.86,47.3145,0,0,0,0,100,0), +(455250,19,-10600.2,1555.27,47.4395,0,0,0,0,100,0), +(455250,20,-10566.9,1562.48,46.8828,0,0,0,0,100,0), +(455250,21,-10533.6,1587.42,44.4937,0,0,0,0,100,0), +(455250,22,-10508.9,1614.24,41.9046,0,0,0,0,100,0), +(455250,23,-10481.2,1648.12,37.4687,0,0,0,0,100,0), +(455250,24,-10461.7,1666.65,35.5912,0,0,0,0,100,0), +(455250,25,-10462.7,1691.47,35.5957,0,3000,0,0,100,0), +(455250,26,-10460.4,1693.59,35.5957,0,0,1,0,100,0), +(455250,27,-10449,1708.79,35.2494,0,0,1,0,100,0), +(455250,28,-10426.5,1743.92,33.7402,0,0,1,0,100,0), +(455250,29,-10416.6,1777.68,28.7875,0,0,1,0,100,0), +(455250,30,-10412.4,1810.25,24.3714,0,0,1,0,100,0), +(455250,31,-10404,1849.8,18.6227,0,0,1,0,100,0), +(455250,32,-10403.2,1873.64,14.9501,0,0,1,0,100,0), +(455250,33,-10414,1899.89,9.32512,0,0,1,0,100,0), +(455250,34,-10439,1920.27,10.5826,0,0,1,0,100,0), +(455250,35,-10458.1,1931.1,9.11068,0,0,1,0,100,0), +(455250,36,-10472.5,1938.23,7.89757,0,0,1,0,100,0), +(455250,37,-10464,1955.49,8.93939,0,0,1,0,100,0), +(455250,38,-10477.6,1976.32,9.24443,0,0,1,0,100,0), +(455250,39,-10501.4,1972.82,10.7568,0,0,1,0,100,0), +(455250,40,-10511.7,1961.35,7.41663,0,0,1,0,100,0), +(455250,41,-10523.6,1943.46,4.23074,0,0,1,0,100,0), +(455250,42,-10548.2,1951.47,-0.460234,0,0,1,0,100,0), +(455250,43,-10568.6,1978.86,-5.38337,0,10000,1,455250,100,0), +(455250,44,-10555.8,1958.8,-3.3736,0,0,1,0,100,0), +(455250,45,-10542.3,1947.6,1.62642,0,0,1,0,100,0), +(455250,46,-10524.9,1942.46,4.34905,0,0,1,0,100,0), +(455250,47,-10516.4,1948.99,4.69907,0,0,1,0,100,0), +(455250,48,-10503.2,1973.02,10.3947,0,0,1,0,100,0), +(455250,49,-10475.6,1974.96,9.28033,0,0,1,0,100,0), +(455250,50,-10464,1957.86,8.6916,0,0,1,0,100,0), +(455250,51,-10471.7,1938.27,7.97253,0,0,1,0,100,0), +(455250,52,-10457.9,1932.24,9.2374,0,0,1,0,100,0), +(455250,53,-10436.6,1916.33,9.53566,0,0,1,0,100,0), +(455250,54,-10418.4,1904.54,7.83281,0,0,1,0,100,0), +(455250,55,-10409.8,1887.79,11.506,0,0,1,0,100,0), +(455250,56,-10406.8,1877.75,14.0414,0,0,1,0,100,0), +(455250,57,-10400.5,1863.82,16.2073,0,0,1,0,100,0), +(455250,58,-10404.8,1832.07,21.0701,0,0,1,0,100,0), +(455250,59,-10413.2,1806.55,24.8249,0,0,1,0,100,0), +(455250,60,-10424,1772.13,29.7769,0,0,1,0,100,0), +(455250,61,-10425.3,1747.43,33.4757,0,0,1,0,100,0), +(455250,62,-10411.2,1735.17,37.0929,0,0,1,0,100,0), +(455250,63,-10387.9,1725.82,38.0202,0,0,1,0,100,0), +(455250,64,-10352.2,1724.66,36.0416,0,0,0,0,100,0), +(455250,65,-10323.8,1718.77,34.8388,0,0,0,0,100,0), +(455250,66,-10299.7,1706.26,37.1308,0,0,0,0,100,0), +(455250,67,-10266,1692.6,35.8463,0,0,0,0,100,0), +(455250,68,-10247,1675.18,34.4902,0,0,0,0,100,0), +(455250,69,-10223.5,1642.29,38.3598,0,0,0,0,100,0), +(455250,70,-10205.1,1605.19,46.0555,0,0,0,0,100,0), +(455250,71,-10185.6,1586.09,45.8647,0,0,0,0,100,0), +(455250,72,-10164.2,1572.13,44.8373,0,0,0,0,100,0), +(455250,73,-10123.5,1555.31,42.3237,0,0,0,0,100,0), +(455250,74,-10108.4,1541.78,42.2112,0,0,0,0,100,0), +(455250,75,-10085.1,1516.22,42.4478,0,0,0,0,100,0), +(455250,76,-10067.8,1486.12,46.4501,0,0,0,0,100,0), +(455250,77,-10052.9,1467.47,45.4537,0,0,1,0,100,0), +(455250,78,-10014.5,1459.66,41.2095,0,0,1,0,100,0), +(455250,79,-9991.49,1458.64,41.4995,0,0,1,0,100,0), +(455250,80,-9976.18,1457.13,45.0206,0,0,1,0,100,0), +(455250,81,-9948.04,1454.6,40.4763,0,0,1,0,100,0), +(455250,82,-9933.26,1441.73,39.1431,0,0,1,0,100,0), +(455250,83,-9923.84,1443.33,39.3621,0,0,1,0,100,0), +(455250,84,-9900.19,1457.97,40.8349,0,0,1,0,100,0), +(455250,85,-9881.88,1450.04,43.709,0,0,1,0,100,0), +(455250,86,-9875.23,1450.28,42.8109,0,0,1,0,100,0), +(455250,87,-9859.63,1457.97,41.3427,0,0,1,0,100,0), +(455250,88,-9849.83,1453.91,40.5755,0,0,1,0,100,0), +(455250,89,-9843.56,1445.74,39.0059,0,0,1,0,100,0), +(455250,90,-9823.62,1423.47,36.7852,0,0,1,0,100,0), +(455250,91,-9821.87,1412.5,36.499,0,0,1,0,100,0), +(455250,92,-9826.46,1406.79,36.9153,0,0,1,0,100,0), +(455250,93,-9835.87,1401.99,38.0764,0,0,1,0,100,0), +(455250,94,-9842.13,1396.29,37.3674,0,10000,1,1189,100,0), +(455250,95,-9823.06,1411.54,36.3635,0,0,1,0,100,0), +(455250,96,-9822.35,1420.64,36.5567,0,0,1,0,100,0), +(455250,97,-9834.79,1435.69,37.6628,0,0,1,0,100,0), +(455250,98,-9853.21,1456.05,40.9653,0,0,1,0,100,0), +(455250,99,-9870.27,1455.45,42.3767,0,0,1,0,100,0), +(455250,100,-9882.26,1448.69,43.7431,0,0,1,0,100,0), +(455250,101,-9898.55,1456.87,41.1526,0,0,1,0,100,0), +(455250,102,-9906.68,1454.73,40.4808,0,0,1,0,100,0), +(455250,103,-9932.6,1441.31,39.124,0,0,1,0,100,0), +(455250,104,-9950.89,1456.18,40.5866,0,0,1,0,100,0), +(455250,105,-9967.03,1455.99,44.5031,0,0,1,0,100,0), +(455250,106,-9991.21,1458.52,41.5305,0,0,1,0,100,0), +(455250,107,-10012.2,1466.57,40.9185,0,0,1,0,100,0), +(455250,108,-10050.7,1470.6,45.6082,0,0,1,0,100,0), +(455250,109,-10070,1490.06,46.4594,0,0,1,0,100,0), +(455250,110,-10089.4,1518.78,41.9798,0,0,0,0,100,0), +(455250,111,-10121.4,1553.17,42.3523,0,0,0,0,100,0), +(455250,112,-10158.6,1569.76,44.1323,0,0,0,0,100,0), +(455250,113,-10185.4,1584.59,45.8592,0,0,0,0,100,0), +(455250,114,-10204,1605.52,46.0855,0,0,0,0,100,0), +(455250,115,-10218.8,1633.28,40.5342,0,0,0,0,100,0), +(455250,116,-10242.3,1669.62,34.6274,0,0,0,0,100,0), +(455250,117,-10262.1,1689.54,35.5146,0,0,0,0,100,0), +(455250,118,-10282.5,1700.46,36.9913,0,0,0,0,100,0), +(455250,119,-10311.1,1711.42,36.4032,0,0,0,0,100,0), +(455250,120,-10335.8,1721.85,34.6113,0,0,0,0,100,0), +(455250,121,-10381.6,1726.92,38.463,0,0,0,0,100,0), +(455250,122,-10409,1723.05,35.455,0,0,0,0,100,0), +(455250,123,-10425.2,1708.05,34.4076,0,0,0,0,100,0), +(455250,124,-10440.8,1688.63,34.9281,0,0,0,0,100,0), +(455250,125,-10462.9,1663.45,35.5745,0,0,0,0,100,0), +(455250,126,-10482.5,1648.56,37.4599,0,0,0,0,100,0), +(455250,127,-10506.4,1618.82,41.2972,0,0,0,0,100,0), +(455250,128,-10525.8,1593.32,43.8772,0,0,0,0,100,0), +(455250,129,-10543.4,1581.86,45.0814,0,0,0,0,100,0), +(455250,130,-10554.1,1574.88,45.7229,0,0,0,0,100,0), +(455250,131,-10576.7,1557.12,47.438,0,0,0,0,100,0), +(455250,132,-10601.5,1555.4,47.4711,0,0,0,0,100,0), +(455250,133,-10625.3,1545.97,47.1961,0,0,0,0,100,0), +(455250,134,-10642.9,1533.3,47.3155,0,0,0,0,100,0), +(455250,135,-10663.4,1510.29,46.5769,0,0,0,0,100,0), +(455250,136,-10676.3,1504.88,46.0457,0,0,0,0,100,0), +(455250,137,-10706.1,1503.8,47.5113,0,0,0,0,100,0), +(455250,138,-10719.3,1503.75,48.4023,0,0,0,0,100,0), +(455250,139,-10741.6,1501.3,47.8971,0,0,0,0,100,0), +(455250,140,-10779,1495.48,47.7248,0,0,0,0,100,0), +(455250,141,-10814.5,1484.85,45.5877,0,0,0,0,100,0), +(455250,142,-10847.3,1473.48,43.427,0,0,0,0,100,0), +(455250,143,-10875.3,1462.61,41.51,0,0,0,0,100,0), +(455250,144,-10891.5,1454.56,41.0618,0,0,0,0,100,0), +(455250,145,-10904.6,1442.63,41.8719,0,0,0,0,100,0), +(455250,146,-10912.3,1429.66,42.6348,0,0,0,0,100,0), +(455250,147,-10916.2,1420.05,42.7921,0,0,0,0,100,0), +(455250,148,-10942.5,1424.95,43.1856,0,0,0,0,100,0), +(455250,149,-10957.7,1422.2,43.1459,0,0,0,0,100,0), +(455250,150,-10979.7,1411.7,42.7758,0,0,0,0,100,0), +(455250,151,-10992.3,1412.79,42.9071,0,0,0,0,100,0), +(455250,152,-11011.4,1426.53,43.0596,0,0,0,0,100,0), +(455250,153,-11021.4,1442.32,43.0378,0,0,0,0,100,0), +(455250,154,-11024.3,1459.81,42.9215,0,0,0,0,100,0); + +DELETE FROM `waypoint_scripts` WHERE `id`=455250; +INSERT INTO `waypoint_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`, `guid`) VALUES +(455250,0,0,1,0,37,0,0,0,0,2); + +UPDATE `waypoint_scripts` SET `datalong`=1 WHERE `id`=1189; |