diff options
| -rw-r--r-- | sql/updates/world/master/2021_09_23_09_world_2018_03_29_00_world.sql | 441 |
1 files changed, 441 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_09_23_09_world_2018_03_29_00_world.sql b/sql/updates/world/master/2021_09_23_09_world_2018_03_29_00_world.sql new file mode 100644 index 00000000000..9288c55e1ed --- /dev/null +++ b/sql/updates/world/master/2021_09_23_09_world_2018_03_29_00_world.sql @@ -0,0 +1,441 @@ +-- Duplicates removed +DELETE FROM creature WHERE guid IN (128989,129260,128975,128971,129421,129426,129420,129422,129419,129429,129418,129430,129427,129431,129425,129428,129424,129423,128961,128951,128952,128950,129000,128992,128983,128955,128969,128933,128941,128931,128954,128972,128960,128926,128981,128912,128977,128978,128929,128979,128914,128987,128918,128944,128994,128995,128942,128993,128945,128964,128917,128956,128943,128996,128916,128940,128965,128930,128963,128928,128970,128982,129001,128953,128920,128922,128973,128966,128913,128968,128937,128938,128967,128915,128976,128932,128980,128947,128921,128958,128959,128911,128984,128962); +DELETE FROM creature_addon WHERE guid IN (128989,151046,129260,128975,128971,129421,129426,129420,129422,129419,129429,129418,129430,129427,129431,129425,129428,129424,129423,128961,128951,128952,128950,129000,128992,128983,128955,128969,128933,128941,128931,128954,128972,128960,128926,128981,128912,128977,128978,128929,128979,128914,128987,128918,128944,128994,128995,128942,128993,128945,128964,128917,128956,128943,128996,128916,128940,128965,128930,128963,128928,128970,128982,129001,128953,128920,128922,128973,128966,128913,128968,128937,128938,128967,128915,128976,128932,128980,128947,128921,128958,128959,128911,128984,128962); +-- Saronite Arrow +DELETE FROM gameobject WHERE guid IN (66149, 66150, 66151, 66153, 66154, 66155, 66157, 66158, 66161, 66163, 66164, 66165, 66166, 66169, 66170, 66171, 66174, 66176, 66177, 66178, 66180, 66182, 66183, 66186, 66188,66194, 66195, 66197, 66201, 66203, 66204, 66208, 66209, 66210, 66211, 66212, 66213, 66219, 66220, 66221, 66222, 66223, 66224, 66225, 66227, 66229, 66231, 66232); +-- Citizen of Havenshire +UPDATE creature SET spawntimesecs = 5 WHERE id IN (28576,28577); +-- #1 +UPDATE creature SET position_x = 2056.845215, position_y = -5887.278809, position_z = 105.142105, orientation = 5.18, MovementType = 2, spawndist = 0 WHERE guid = 128934; +DELETE FROM `creature_addon` WHERE `guid` IN (128934); +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `auras`) VALUES +(128934, 1289340, 0, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=1289340; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(1289340,1,2056.84,-5887.27,105.142, 0, 1, 0, 100, 0), +(1289340,2,2057.01,-5896.95,105.123, 0, 1, 0, 100, 0), +(1289340,3,2035.39,-5906.56,105.121, 0, 1, 0, 100, 0), +(1289340,4,2017.4, -5907.31,104.623, 0, 1, 0, 100, 0), +(1289340,5,1975.06,-5904.35,102.864, 0, 1, 0, 100, 0), +(1289340,6,1945.99,-5904.95,101.207, 0, 1, 0, 100, 0), +(1289340,7,1917.03,-5911.18,101.617, 0, 1, 0, 100, 0), +(1289340,8,1903.82,-5909.42,101.736, 0, 1, 0, 100, 0), +(1289340,9,1877.38,-5911.21,103.984, 0, 1, 0, 100, 0), +(1289340,10,1827.52,-5927.2,111.352, 0, 1, 0, 100, 0), +(1289340,11,1813.52,-5931.47,114.61, 0, 1, 0, 100, 0), +(1289340,12,1807.51,-5941.81,115.80, 0, 1, 0, 100, 0), +(1289340,13,1807.12,-5972.92,116.18, 0, 1, 0, 100, 0), +(1289340,14,1807.86,-5991.78,117.61, 0, 1, 0, 100, 0), +(1289340,15,1810.83,-6000.76,117.63, 2000, 1, 1188, 100, 0); +-- #2 +UPDATE creature SET spawndist = 0, MovementType = 2 WHERE guid = 128999; +DELETE FROM `creature_addon` WHERE `guid` IN (128999); +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `auras`) VALUES +(128999, 1289990, 0, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=1289990; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(1289990,1,2240.29,-5923.61,98.8092, 0, 1, 0, 100, 0), +(1289990,2,2225.95,-5917.15,100.564, 0, 1, 0, 100, 0), +(1289990,3,2183.44,-5892.94,100.710, 0, 1, 0, 100, 0), +(1289990,4,2165.87,-5868.91,101.326, 0, 1, 0, 100, 0), +(1289990,5,2144.29,-5833.26,101.282, 0, 1, 0, 100, 0), +(1289990,6,2134.01,-5800.38,99.6541, 0, 1, 0, 100, 0), +(1289990,7,2124.79,-5797.24,99.4295, 0, 1, 0, 100, 0), +(1289990,8,2116.25,-5802.6,100.7940, 2000, 1, 1188, 100, 0); +-- #3 +UPDATE creature SET position_x = 2279.38, position_y = -5792.860840, position_z = 100.936661, orientation = 2.211558, spawndist = 0, MovementType = 2 WHERE guid = 128957; +DELETE FROM `creature_addon` WHERE `guid` IN (128957); +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `auras`) VALUES +(128957, 1289570, 0, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=1289570; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(1289570,1,2279.38,-5792.86,100.936, 0, 1, 0, 100, 0), +(1289570,2,2237.48,-5762.68,101.423, 0, 1, 0, 100, 0), +(1289570,3,2195.92,-5750.89,102.247, 0, 1, 0, 100, 0), +(1289570,4,2159.98,-5731.86,101.111, 0, 1, 0, 100, 0), +(1289570,5,2137.79,-5726.60,100.368, 0, 1, 0, 100, 0), +(1289570,6,2122.49,-5721.89,100.341, 0, 1, 0, 100, 0), +(1289570,7,2079.47,-5736.64,100.508, 0, 1, 0, 100, 0), +(1289570,8,2043.49,-5745.04,98.6616, 0, 1, 0, 100, 0), +(1289570,9,2016.05,-5748.10,99.5260, 0, 1, 0, 100, 0), +(1289570,10,1980.49,-5754.46,99.502, 0, 1, 0, 100, 0), +(1289570,11,1945.86,-5764.75,102.86, 0, 1, 0, 100, 0), +(1289570,12,1917.47,-5769.25,102.56, 0, 1, 0, 100, 0), +(1289570,13,1898.75,-5770.96,103.71, 0, 1, 0, 100, 0), +(1289570,14,1862.43,-5790.36,102.18, 0, 1, 0, 100, 0), +(1289570,15,1825.73,-5806.88,102.91, 0, 1, 0, 100, 0), +(1289570,16,1797.47,-5813.53,109.97, 0, 1, 0, 100, 0), +(1289570,17,1769.65,-5813.99,115.93, 0, 1, 0, 100, 0), +(1289570,18,1752.63,-5817.66,116.12, 0, 1, 0, 100, 0), +(1289570,19,1747.26,-5809.18,116.12, 0, 1, 0, 100, 0), +(1289570,20,1748.11,-5802.21,117.12, 2000, 1, 1188, 100, 0); +-- #4 +UPDATE creature SET position_x = 2260.174805, position_y = -5801.781250, position_z = 102.004921, orientation = 3.76, spawndist = 0, MovementType = 2 WHERE guid = 128948; +DELETE FROM `creature_addon` WHERE `guid` IN (128948); +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `auras`) VALUES +(128948, 1289480, 0, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=1289480; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(1289480,1,2260.17,-5801.78,102.01, 0, 1, 0, 100, 0), +(1289480,2,2250.01,-5803.18,100.98, 0, 1, 0, 100, 0), +(1289480,3,2165.42,-5814.7,101.322, 0, 1, 0, 100, 0), +(1289480,4,2101.6,-5840.02,102.298, 0, 1, 0, 100, 0), +(1289480,5,2038.31,-5843.82,100.35, 0, 1, 0, 100, 0), +(1289480,6,1945.59,-5846.08,100.35, 0, 1, 0, 100, 0), +(1289480,7,1902.9,-5844.42,100.833, 0, 1, 0, 100, 0), +(1289480,8,1849.54,-5819.23,99.928, 0, 1, 0, 100, 0), +(1289480,9,1767.95,-5819.02,116.02, 0, 1, 0, 100, 0), +(1289480,10,1745.79,-5834.48,116.8, 0, 1, 0, 100, 0), +(1289480,11,1723.42,-5867.11,116.1, 0, 1, 0, 100, 0), +(1289480,12,1729.19,-5872.37,116.1, 0, 1, 0, 100, 0), +(1289480,13,1739.22,-5872.44,116.6, 2000, 1, 1188, 100, 0); +-- #5 +UPDATE creature SET position_x = 2286.046631, position_y = -5829.061035, position_z = 100.934441, orientation = 2.1, spawndist = 0, MovementType = 2 WHERE guid = 128949; +DELETE FROM `creature_addon` WHERE `guid` IN (128949); +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `auras`) VALUES +(128949, 1289490, 0, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=1289490; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(1289490,1,2286.04,-5829.06,100.934, 0, 1, 0, 100, 0), +(1289490,2,2273.30,-5836.75,100.934, 0, 1, 0, 100, 0), +(1289490,3,2249.23,-5837.22,101.289, 0, 1, 0, 100, 0), +(1289490,4,2186.37,-5864.02,101.326, 0, 1, 0, 100, 0), +(1289490,5,2165.92,-5868.08,101.326, 0, 1, 0, 100, 0), +(1289490,6,2140.53,-5857.96,101.363, 0, 1, 0, 100, 0), +(1289490,7,2107.88,-5872.78,103.037, 0, 1, 0, 100, 0), +(1289490,8,2104.77,-5877.18,103.393, 0, 1, 0, 100, 0), +(1289490,9,2107.28,-5882.22,103.865, 2000, 1, 1188, 100, 0); +-- #6 +UPDATE creature SET position_x = 2270.406494, position_y = -5825.929199, position_z = 100.935585, orientation = 2.91, spawndist = 0, MovementType = 2 WHERE guid = 128946; +DELETE FROM `creature_addon` WHERE `guid` IN (128946); +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `auras`) VALUES +(128946, 1289460, 0, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=1289460; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(1289460,1,2270.40,-5825.92,100.935, 0, 1, 0, 100, 0), +(1289460,2,2235.89,-5826.65,101.323, 0, 1, 0, 100, 0), +(1289460,3,2211.43,-5824.89,101.391, 0, 1, 0, 100, 0), +(1289460,4,2161.91,-5813.19,101.513, 0, 1, 0, 100, 0), +(1289460,5,2112.32,-5785.67,98.9869, 0, 1, 0, 100, 0), +(1289460,6,2085.38,-5800.41,102.163, 0, 1, 0, 100, 0), +(1289460,7,2069.57,-5809.84,103.118, 0, 1, 0, 100, 0), +(1289460,8,2021.36,-5802.96,100.410, 0, 1, 0, 100, 0), +(1289460,9,1981.07,-5806.64,100.999, 0, 1, 0, 100, 0), +(1289460,10,1941.97,-5799.79,100.25, 2000, 1, 1188, 100, 0); +-- #7 +UPDATE creature SET position_x = 2269.964844, position_y = -5826.081055, position_z = 100.936157, orientation = 3.1, spawndist = 0, MovementType = 2 WHERE guid = 128997; +DELETE FROM `creature_addon` WHERE `guid` IN (128997); +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `auras`) VALUES +(128997, 1289970, 0, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=1289970; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(1289970,1,2269.96,-5826.08,100.932, 8000, 1, 0, 100, 0), +(1289970,2,2236.19,-5803.16,101.208, 0, 1, 0, 100, 0), +(1289970,3,2167.06,-5816.79,101.337, 0, 1, 0, 100, 0), +(1289970,4,2105.5,-5839.54,102.1880, 0, 1, 0, 100, 0), +(1289970,5,2049.9,-5864.14,102.8060, 0, 1, 0, 100, 0), +(1289970,6,1987.16,-5898.45,102.500, 0, 1, 0, 100, 0), +(1289970,7,1937.49,-5907.82,101.143, 0, 1, 0, 100, 0), +(1289970,8,1886.73,-5910.87,103.037, 0, 1, 0, 100, 0), +(1289970,9,1853.53,-5921.4,105.2080, 0, 1, 0, 100, 0), +(1289970,10,1812.25,-5927.43,114.55, 0, 1, 0, 100, 0), +(1289970,11,1768.08,-5923.11,116.12, 0, 1, 0, 100, 0), +(1289970,12,1761.5,-5930.56,116.119, 0, 1, 0, 100, 0), +(1289970,13,1742.4,-5967.17,117.122, 2000, 1, 1188, 100, 0); +-- #8 +UPDATE creature SET position_x = 2258.272461, position_y = -5805.730957, position_z = 100.938576, orientation = 4.38, spawndist = 0, MovementType = 2 WHERE guid = 128998; +DELETE FROM `creature_addon` WHERE `guid` IN (128998); +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `auras`) VALUES +(128998, 1289980, 0, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=1289980; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(1289980,1,2258.27,-5805.73,100.938, 5000, 1, 0, 100, 0), +(1289980,2,2253.32,-5824.7,101.0520, 0, 1, 0, 100, 0), +(1289980,3,2232.21,-5831.54,101.341, 0, 1, 0, 100, 0), +(1289980,4,2196.33,-5826.97,101.406, 0, 1, 0, 100, 0), +(1289980,5,2140.07,-5816.52,100.652, 0, 1, 0, 100, 0), +(1289980,6,2126.99,-5799.26,99.5154, 0, 1, 0, 100, 0), +(1289980,7,2117.59,-5801.23,99.9204, 2000, 1, 1188, 100, 0); +-- #9 +UPDATE creature SET position_x = 2277.270020, position_y = -5867.498047, position_z = 100.942833, orientation = 1.66, spawndist = 0, MovementType = 2 WHERE guid = 128990; +DELETE FROM `creature_addon` WHERE `guid` IN (128990); +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `auras`) VALUES +(128990, 1289900, 0, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=1289900; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(1289900,1,2277.27,-5867.49,100.942, 7000, 1, 0, 100, 0), +(1289900,2,2272.55,-5847.26,100.935, 0, 1, 0, 100, 0), +(1289900,3,2248.3,-5807.73,100.9950, 0, 1, 0, 100, 0), +(1289900,4,2229.75,-5773.74,101.512, 0, 1, 0, 100, 0), +(1289900,5,2207.39,-5751.6,102.4630, 0, 1, 0, 100, 0), +(1289900,6,2162.07,-5722.95,101.576, 0, 1, 0, 100, 0), +(1289900,7,2144.9,-5704.05,102.2520, 0, 1, 0, 100, 0), +(1289900,8,2132.24,-5701.09,101.273, 0, 1, 0, 100, 0), +(1289900,9,2098.18,-5703.38,100.270, 0, 1, 0, 100, 0), +(1289900,10,2083.12,-5711.63,100.36, 0, 1, 0, 100, 0), +(1289900,11,2071.02,-5730.28,100.25, 0, 1, 0, 100, 0), +(1289900,12,2039.03,-5757.86,98.815, 0, 1, 0, 100, 0), +(1289900,13,2014.79,-5784.96,100.44, 0, 1, 0, 100, 0), +(1289900,14,2015.79,-5833.84,100.67, 0, 1, 0, 100, 0), +(1289900,15,2014.32,-5862.64,100.46, 0, 1, 0, 100, 0), +(1289900,16,2005.57,-5893.96,102.37, 0, 1, 0, 100, 0), +(1289900,17,1985.4,-5923.43,104.304, 0, 1, 0, 100, 0), +(1289900,18,1971.35,-5933.44,102.88, 0, 1, 0, 100, 0), +(1289900,19,1913.35,-5938.29,102.50, 0, 1, 0, 100, 0), +(1289900,20,1866.07,-5922.39,104.32, 0, 1, 0, 100, 0), +(1289900,21,1840.94,-5922.4,107.583, 0, 1, 0, 100, 0), +(1289900,22,1813.25,-5930.15,114.56, 0, 1, 0, 100, 0), +(1289900,23,1789.73,-5930.3,116.116, 0, 1, 0, 100, 0), +(1289900,24,1713.48,-5892.5,116.135, 0, 1, 0, 100, 0), +(1289900,25,1691.18,-5872.74,116.15, 0, 1, 0, 100, 0), +(1289900,26,1682.69,-5868.98,116.23, 0, 1, 0, 100, 0), +(1289900,27,1658.57,-5878.73,117.14, 2000, 1, 1188, 100, 0); +-- #10 +UPDATE creature SET position_x = 2244.684570, position_y = -5863.497070, position_z = 101.023544, orientation = 3.25, spawndist = 0, MovementType = 2 WHERE guid = 128988; +DELETE FROM `creature_addon` WHERE `guid` IN (128988); +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `auras`) VALUES +(128988, 1289880, 0, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=1289880; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(1289880,1,2244.68,-5863.49,101.023, 10000, 1, 0, 100, 0), +(1289880,2,2236.78,-5865.79,101.105, 0, 1, 0, 100, 0), +(1289880,3,2176.49,-5844.66,101.348, 0, 1, 0, 100, 0), +(1289880,4,2143.43,-5844.3,101.3280, 0, 1, 0, 100, 0), +(1289880,5,2088.85,-5847.07,103.921, 0, 1, 0, 100, 0), +(1289880,6,2068.05,-5859.08,103.275, 0, 1, 0, 100, 0), +(1289880,7,2026.17,-5873.86,101.836, 0, 1, 0, 100, 0), +(1289880,8,1970.37,-5871.27,100.618, 0, 1, 0, 100, 0), +(1289880,9,1950.31,-5859.67,100.117, 0, 1, 0, 100, 0), +(1289880,10,1922.59,-5845.54,100.15, 0, 1, 0, 100, 0), +(1289880,11,1870.15,-5833.8,101.252, 0, 1, 0, 100, 0), +(1289880,12,1831.83,-5825.1,101.150, 0, 1, 0, 100, 0), +(1289880,13,1762.85,-5824.3,116.116, 0, 1, 0, 100, 0), +(1289880,14,1714.55,-5821.33,116.12, 0, 1, 0, 100, 0), +(1289880,15,1701.84,-5811.57,116.01, 0, 1, 0, 100, 0), +(1289880,16,1667.87,-5798.99,116.11, 0, 1, 0, 100, 0), +(1289880,17,1648.39,-5804.74,117.12, 2000, 1, 1188, 100, 0); +-- #11 +UPDATE creature SET position_x = 2170.995605, position_y = -5910.861816, position_z = 100.466431, orientation = 2.95, spawndist = 0, MovementType = 2 WHERE guid = 128991; +DELETE FROM `creature_addon` WHERE `guid` IN (128991); +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `auras`) VALUES +(128991, 1289910, 0, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=1289910; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(1289910,1,2170.99,-5910.86,100.460, 0, 1, 0, 100, 0), +(1289910,2,2123.96,-5908.37,103.537, 0, 1, 0, 100, 0), +(1289910,3,2063.83,-5917.86,106.994, 0, 1, 0, 100, 0), +(1289910,4,2018.57,-5925.72,104.636, 0, 1, 0, 100, 0), +(1289910,5,1978.91,-5931.81,103.270, 0, 1, 0, 100, 0), +(1289910,6,1930.42,-5925.82,103.547, 0, 1, 0, 100, 0), +(1289910,7,1882.12,-5918.43,104.002, 0, 1, 0, 100, 0), +(1289910,8,1847.43,-5919.06,106.024, 0, 1, 0, 100, 0), +(1289910,9,1803.47,-5923.31,115.736, 0, 1, 0, 100, 0), +(1289910,10,1746.99,-5912.37,116.11, 0, 1, 0, 100, 0), +(1289910,11,1706.68,-5886.96,116.13, 0, 1, 0, 100, 0), +(1289910,12,1658.84,-5845.24,116.13, 0, 1, 0, 100, 0), +(1289910,13,1644.38,-5842.67,117.29, 2000, 1, 1188, 100, 0); +-- #12 +UPDATE creature SET position_x = 2170.457764, position_y = -5907.129883, position_z = 100.424911, orientation = 3.02, spawndist = 0, MovementType = 2 WHERE guid = 128935; +DELETE FROM `creature_addon` WHERE `guid` IN (128935); +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `auras`) VALUES +(128935, 1289350, 0, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=1289350; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(1289350,1,2170.45,-5907.12,100.424, 4000, 1, 0, 100, 0), +(1289350,2,2142.37,-5894.82,101.973, 0, 1, 0, 100, 0), +(1289350,3,2107.72,-5872.92,103.053, 0, 1, 0, 100, 0), +(1289350,4,2067.51,-5867.54,103.870, 0, 1, 0, 100, 0), +(1289350,5,2024.79,-5869.48,101.221, 0, 1, 0, 100, 0), +(1289350,6,1951.56,-5846.48,100.403, 0, 1, 0, 100, 0), +(1289350,7,1869.61,-5831.08,100.987, 0, 1, 0, 100, 0), +(1289350,8,1830.11,-5820.79,101.520, 0, 1, 0, 100, 0), +(1289350,9,1768.9,-5799.65,116.1450, 0, 1, 0, 100, 0), +(1289350,10,1756.63,-5788.3,116.123, 0, 1, 0, 100, 0), +(1289350,11,1744.66,-5783.13,116.12, 0, 1, 0, 100, 0), +(1289350,12,1742.19,-5775.26,116.120, 0, 1, 0, 100, 0), +(1289350,13,1748.05,-5772.54,117.08, 2000, 1, 1188, 100, 0); +-- #13 +UPDATE creature SET position_x = 2217.407471, position_y = -5875.900391, position_z = 101.085777, orientation = 2.83, spawndist = 0, MovementType = 2 WHERE guid = 128985; +DELETE FROM `creature_addon` WHERE `guid` IN (128985); +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `auras`) VALUES +(128985, 1289850, 0, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=1289850; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(1289850,1,2217.40,-5875.90,101.085, 6000, 1, 0, 100, 0), +(1289850,2,2196.64,-5866.59,101.304, 0, 1, 0, 100, 0), +(1289850,3,2170.04,-5867.43,101.340, 0, 1, 0, 100, 0), +(1289850,4,2137.81,-5856.76,101.391, 0, 1, 0, 100, 0), +(1289850,5,2082.67,-5847.29,103.244, 0, 1, 0, 100, 0), +(1289850,6,2029.99,-5848.05,100.431, 0, 1, 0, 100, 0), +(1289850,7,1969.77,-5874.91,100.636, 0, 1, 0, 100, 0), +(1289850,8,1918.99,-5906.72,101.467, 0, 1, 0, 100, 0), +(1289850,9,1858.61,-5915.66,104.490, 0, 1, 0, 100, 0), +(1289850,10,1803.63,-5926.08,115.62, 0, 1, 0, 100, 0), +(1289850,11,1768.5,-5923.63,116.119, 0, 1, 0, 100, 0), +(1289850,12,1754.77,-5942.33,116.14, 0, 1, 0, 100, 0), +(1289850,13,1742.09,-5966.46,117.12, 2000, 1, 1188, 100, 0); +-- #14 +UPDATE creature SET position_x = 1941.105225, position_y = -5799.148926, position_z = 100.515633, orientation = 5.55, spawndist = 0, MovementType = 2 WHERE guid = 128936; +DELETE FROM `creature_addon` WHERE `guid` IN (128936); +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `auras`) VALUES +(128936, 1289360, 0, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=1289360; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(1289360,1,1941.10,-5799.14,100.515, 0, 1, 0, 100, 0), +(1289360,2,1945.67,-5802.12,100.476, 0, 1, 0, 100, 0), +(1289360,3,1951.73,-5799.14,100.577, 0, 1, 0, 100, 0), +(1289360,4,1942.04,-5772.9,102.1260, 0, 1, 0, 100, 0), +(1289360,5,1927.43,-5772.54,101.941, 0, 1, 0, 100, 0), +(1289360,6,1895.65,-5808.82,101.188, 0, 1, 0, 100, 0), +(1289360,7,1866.02,-5820.96,100.295, 0, 1, 0, 100, 0), +(1289360,8,1826.25,-5818.95,102.312, 0, 1, 0, 100, 0), +(1289360,9,1772.64,-5818.85,115.730, 0, 1, 0, 100, 0), +(1289360,10,1717.71,-5814.72,116.15, 0, 1, 0, 100, 0), +(1289360,11,1664.44,-5790.83,116.12, 0, 1, 0, 100, 0), +(1289360,12,1608.48,-5763.8,116.663, 0, 1, 0, 100, 0), +(1289360,13,1595.3,-5741.35,119.236, 0, 1, 0, 100, 0), +(1289360,14,1585.9,-5721.38,121.680, 0, 1, 0, 100, 0), +(1289360,15,1575.5,-5724.96,120.779, 2000, 1, 1188, 100, 0); +-- #15 +UPDATE creature SET position_x = 1941.454590, position_y = -5800.637695, position_z = 100.260811, orientation = 5.36, spawndist = 0, MovementType = 2 WHERE guid = 128927; +DELETE FROM `creature_addon` WHERE `guid` IN (128927); +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `auras`) VALUES +(128927, 1289270, 0, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=1289270; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(1289270,1,1941.45,-5800.63,100.260, 5000, 1, 0, 100, 0), +(1289270,2,1886.91,-5834.98,101.234, 0, 1, 0, 100, 0), +(1289270,3,1852.12,-5830.11,100.757, 0, 1, 0, 100, 0), +(1289270,4,1831.31,-5827.4,101.2170, 0, 1, 0, 100, 0), +(1289270,5,1779.23,-5826.67,115.221, 0, 1, 0, 100, 0), +(1289270,6,1733.84,-5854.41,116.616, 0, 1, 0, 100, 0), +(1289270,7,1683.82,-5870.42,116.177, 0, 1, 0, 100, 0), +(1289270,8,1659.01,-5878.35,117.142, 2000, 1, 1188, 100, 0); +-- #16 +UPDATE creature SET position_x = 1939.179810, position_y = -5802.433105, position_z = 100.259399, orientation = 4.3, spawndist = 0, MovementType = 2 WHERE guid = 128924; +DELETE FROM `creature_addon` WHERE `guid` IN (128924); +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `auras`) VALUES +(128924, 1289240, 0, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=1289240; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(1289240,1,1939.17,-5802.43,100.259, 3000, 1, 0, 100, 0), +(1289240,2,1905.17,-5812.59,100.617, 0, 1, 0, 100, 0), +(1289240,3,1839.49,-5820.87,100.435, 0, 1, 0, 100, 0), +(1289240,4,1770.56,-5825.94,115.982, 0, 1, 0, 100, 0), +(1289240,5,1750.1,-5823.17,116.1220, 0, 1, 0, 100, 0), +(1289240,6,1747.84,-5801.86,117.123, 2000, 1, 1188, 100, 0); +-- #17 +UPDATE creature SET position_x = 1938.616211, position_y = -5867.627930, position_z = 99.059547, orientation = 0.5, spawndist = 0, MovementType = 2 WHERE guid = 128986; +DELETE FROM `creature_addon` WHERE `guid` IN (128986); +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `auras`) VALUES +(128986, 1289860, 0, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=1289860; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(1289860,1,1938.61,-5867.62,99.0595, 0, 1, 0, 100, 0), +(1289860,2,1953.07,-5871.43,100.064, 0, 1, 0, 100, 0), +(1289860,3,1957.82,-5886.43,101.620, 0, 1, 0, 100, 0), +(1289860,4,1927.15,-5905.47,101.052, 0, 1, 0, 100, 0), +(1289860,5,1865.38,-5906.94,103.945, 0, 1, 0, 100, 0), +(1289860,6,1813.74,-5924.07,114.088, 0, 1, 0, 100, 0), +(1289860,7,1744.47,-5905.5,116.1420, 0, 1, 0, 100, 0), +(1289860,8,1666.27,-5874.95,116.156, 0, 1, 0, 100, 0), +(1289860,9,1659.64,-5878.93,117.141, 2000, 1, 1188, 100, 0); +-- #18 +UPDATE creature SET position_x = 2067.154541, position_y = -5900.735840, position_z = 105.315590, orientation = 3.37, spawndist = 0, MovementType = 2 WHERE guid = 128925; +DELETE FROM `creature_addon` WHERE `guid` IN (128925); +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `auras`) VALUES +(128925, 1289250, 0, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=1289250; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(1289250,1,2067.15,-5900.73,105.315, 10000, 1, 0, 100, 0), +(1289250,2,2023.75,-5909.85,104.968, 0, 1, 0, 100, 0), +(1289250,3,1950.40,-5910.79,101.778, 0, 1, 0, 100, 0), +(1289250,4,1898.09,-5912.00,101.896, 0, 1, 0, 100, 0), +(1289250,5,1854.49,-5919.36,104.994, 0, 1, 0, 100, 0), +(1289250,6,1805.89,-5925.83,115.401, 0, 1, 0, 100, 0), +(1289250,7,1739.83,-5908.36,116.121, 0, 1, 0, 100, 0), +(1289250,8,1695.83,-5881.50,116.135, 0, 1, 0, 100, 0), +(1289250,9,1652.39,-5843.25,116.135, 0, 1, 0, 100, 0), +(1289250,10,1645.1,-5842.39,117.290, 2000, 1, 1188, 100, 0); +-- #19 +UPDATE creature SET spawndist = 0, MovementType = 2 WHERE guid = 128919; +DELETE FROM `creature_addon` WHERE `guid` IN (128919); +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `auras`) VALUES +(128919, 1289190, 0, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=1289190; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(1289190,1,2159.18,-5892.81,101.401, 0, 1, 0, 100, 0), +(1289190,2,2132.78,-5865.54,101.596, 0, 1, 0, 100, 0), +(1289190,3,2084.84,-5829.55,102.578, 0, 1, 0, 100, 0), +(1289190,4,2054.93,-5803.12,102.494, 0, 1, 0, 100, 0), +(1289190,5,1997.51,-5805.87,100.678, 0, 1, 0, 100, 0), +(1289190,6,1977.29,-5813.95,101.035, 0, 1, 0, 100, 0), +(1289190,7,1959.61,-5811.83,101.148, 0, 1, 0, 100, 0), +(1289190,8,1941.14,-5799.42,100.516, 2000, 1, 1188, 100, 0); +-- #20 +UPDATE creature SET position_x = 2067.149414, position_y = -5885.223633, position_z = 104.120804, orientation = 3.6, spawndist = 0, MovementType = 2 WHERE guid = 128974; +DELETE FROM `creature_addon` WHERE `guid` IN (128974); +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `auras`) VALUES +(128974, 1289740, 0, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=1289740; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(1289740,1,2067.14,-5885.22,104.120, 6000, 1, 0, 100, 0), +(1289740,2,2034.37,-5906.14,105.076, 0, 1, 0, 100, 0), +(1289740,3,1948.81,-5904.8,101.3640, 0, 1, 0, 100, 0), +(1289740,4,1899, -5901.04,102.011, 0, 1, 0, 100, 0), +(1289740,5,1857.14,-5919.97,104.759, 0, 1, 0, 100, 0), +(1289740,6,1806.77,-5925.39,115.368, 0, 1, 0, 100, 0), +(1289740,7,1743.95,-5906.21,116.130, 0, 1, 0, 100, 0), +(1289740,8,1696.17,-5874.24,116.141, 0, 1, 0, 100, 0), +(1289740,9,1666.11,-5875.97,116.156, 0, 1, 0, 100, 0), +(1289740,10,1660.01,-5877.95,117.14, 2000, 1, 1188, 100, 0); +-- #21 +UPDATE creature SET position_x = 2140.980225, position_y = -5779.114258, position_z = 99.407547, orientation = 3.5, spawndist = 0, MovementType = 2 WHERE guid = 128939; +DELETE FROM `creature_addon` WHERE `guid` IN (128939); +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `auras`) VALUES +(128939, 1289390, 0, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=1289390; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(1289390,1,2140.98,-5779.11,99.4075, 6000, 1, 0, 100, 0), +(1289390,2,2086.14,-5775.21,99.1742, 0, 1, 0, 100, 0), +(1289390,3,2043.6,-5761.94,98.89110, 0, 1, 0, 100, 0), +(1289390,4,2008.65,-5779.73,100.501, 0, 1, 0, 100, 0), +(1289390,5,1977.81,-5796.46,100.932, 0, 1, 0, 100, 0), +(1289390,6,1942.26,-5800.28,100.278, 2000, 1, 1188, 100, 0); +-- #22 +UPDATE creature SET position_x = 2116.1, position_y = -5802.52, position_z = 100.8, orientation = 0.9, spawndist = 0, MovementType = 2 WHERE guid = 128923; +DELETE FROM `creature_addon` WHERE `guid` IN (128923); +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `auras`) VALUES +(128923, 1289230, 0, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=1289230; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(1289230,1,2116.10,-5802.52,100.800, 0, 1, 0, 100, 0), +(1289230,2,2119.35,-5797.03,99.6076, 0, 1, 0, 100, 0), +(1289230,3,2117.58,-5787.27,98.7951, 0, 1, 0, 100, 0), +(1289230,4,2076.21,-5768.19,99.1701, 0, 1, 0, 100, 0), +(1289230,5,2034.56,-5763.16,99.7534, 0, 1, 0, 100, 0), +(1289230,6,2000.9,-5792.28,100.6950, 0, 1, 0, 100, 0), +(1289230,7,1956.93,-5830.99,100.828, 0, 1, 0, 100, 0), +(1289230,8,1906.43,-5844.33,100.691, 0, 1, 0, 100, 0), +(1289230,9,1870.69,-5831.22,101.043, 0, 1, 0, 100, 0), +(1289230,10,1837.45,-5821.06,100.59, 0, 1, 0, 100, 0), +(1289230,11,1774.77,-5819.43,115.49, 0, 1, 0, 100, 0), +(1289230,12,1752.66,-5819.17,116.12, 0, 1, 0, 100, 0), +(1289230,13,1747.47,-5809.54,116.12, 0, 1, 0, 100, 0), +(1289230,14,1748.39,-5803.1,117.124, 2000, 1, 1188, 100, 0); +-- #23 +UPDATE creature SET position_x = 1908.830811, position_y = -5884.311035, position_z = 100.260605, orientation = 4.1, spawndist = 0, MovementType = 2 WHERE guid = 128910; +DELETE FROM `creature_addon` WHERE `guid` IN (128910); +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `auras`) VALUES +(128910, 1289100, 0, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=1289100; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(1289100,1,1908.8,-5884.31,100.260, 0, 1, 0, 100, 0), +(1289100,2,1870.1,-5910.93,104.046, 0, 1, 0, 100, 0), +(1289100,3,1823.62,-5927.41,112.22, 0, 1, 0, 100, 0), +(1289100,4,1793.2,-5931.67,116.089, 0, 1, 0, 100, 0), +(1289100,5,1751.19,-5914.43,116.11, 0, 1, 0, 100, 0), +(1289100,6,1696.15,-5881.5,116.137, 0, 1, 0, 100, 0), +(1289100,7,1652.94,-5833.58,116.20, 0, 1, 0, 100, 0), +(1289100,8,1615.36,-5781.67,116.11, 0, 1, 0, 100, 0), +(1289100,9,1586.79,-5723.86,121.68, 2000, 1, 1188, 100, 0); |