diff options
| -rw-r--r-- | sql/updates/world/master/2019_07_11_15_world_2017_01_26_11_world.sql | 761 |
1 files changed, 761 insertions, 0 deletions
diff --git a/sql/updates/world/master/2019_07_11_15_world_2017_01_26_11_world.sql b/sql/updates/world/master/2019_07_11_15_world_2017_01_26_11_world.sql new file mode 100644 index 00000000000..0081aa1f420 --- /dev/null +++ b/sql/updates/world/master/2019_07_11_15_world_2017_01_26_11_world.sql @@ -0,0 +1,761 @@ +-- ---------------------------------------------------------- +-- Elekks +-- ---------------------------------------------------------- + +-- Pathing for Entry: 18334 'TDB FORMAT' +SET @GUID := 65650; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-2700.05,`position_y`=7707.09,`position_z`=-22.9957 WHERE `guid`=@GUID; +DELETE FROM `creature_addon` WHERE `guid`=@GUID; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@GUID,@GUID,0,0,4097,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@GUID; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@GUID,1,-2674.269,7691.681,-22.02553,0,0,0,100,0), -- 14:42:09 +(@GUID,2,-2647.13,7687.174,-21.63469,0,0,0,100,0), -- 14:42:20 +(@GUID,3,-2634.092,7690.889,-24.89965,0,0,0,100,0), -- 14:42:31 +(@GUID,4,-2595.526,7696.667,-25.62142,0,0,0,100,0), -- 14:42:42 +(@GUID,5,-2550.476,7674.772,-21.62527,0,0,0,100,0), -- 14:42:57 +(@GUID,6,-2544.033,7645.498,-16.04786,0,0,0,100,0), -- 14:43:12 +(@GUID,7,-2548.478,7669.872,-20.55757,0,0,0,100,0), -- 14:43:28 +(@GUID,8,-2578.528,7694.802,-25.57306,0,0,0,100,0), -- 14:43:40 +(@GUID,9,-2603.167,7696.505,-24.80726,0,0,0,100,0), -- 14:43:56 +(@GUID,10,-2643.71,7687.625,-22.29348,0,0,0,100,0), -- 14:44:11 +(@GUID,11,-2659.478,7688.336,-20.91553,0,0,0,100,0), -- 14:44:23 +(@GUID,12,-2685.064,7699.987,-23.74258,0,0,0,100,0), -- 14:44:34 +(@GUID,13,-2714.749,7709.776,-21.0963,0,0,0,100,0), -- 14:44:45 +(@GUID,14,-2737.495,7703.183,-17.15627,0,0,0,100,0), -- 14:44:56 +(@GUID,15,-2753.035,7689.911,-15.15311,0,0,0,100,0), -- 14:45:05 +(@GUID,16,-2742.514,7700.255,-16.58095,0,0,0,100,0), -- 14:45:15 +(@GUID,17,-2721.877,7709.784,-19.91874,0,0,0,100,0), -- 14:45:22 +(@GUID,18,-2692.772,7705.893,-23.72323,0,0,0,100,0), -- 14:45:32 +(@GUID,19,-2674.066,7691.752,-21.89675,0,0,0,100,0), -- 14:45:43 +(@GUID,20,-2647.014,7687.249,-21.64456,0,0,0,100,0), -- 14:45:54 +(@GUID,21,-2634.09,7690.91,-24.85542,0,0,0,100,0), -- 14:46:04 +(@GUID,22,-2595.506,7696.591,-25.62829,0,0,0,100,0), -- 14:46:15 +(@GUID,23,-2550.469,7674.769,-21.62007,0,0,0,100,0), -- 14:46:29 +(@GUID,24,-2576.608,7690.399,-24.80136,0,0,0,100,0), -- 14:46:34 +(@GUID,25,-2575.799,7692.778,-25.154,0,0,0,100,0); -- 14:46:34 +-- 0x203AF4424011E78000004E0002A2A883 .go -2674.269 7691.681 -22.02553 + +-- Pathing for Entry: 18334 'TDB FORMAT' +SET @GUID := 65651; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-2749.34,`position_y`=7810.44,`position_z`=-32.9055 WHERE `guid`=@GUID; +DELETE FROM `creature_addon` WHERE `guid`=@GUID; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@GUID,@GUID,0,0,4097,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@GUID; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@GUID,1,-2734.878,7787.57,-31.95395,0,0,0,100,0), -- 17:48:13 +(@GUID,2,-2751.098,7813.736,-31.82531,0,0,0,100,0), -- 17:48:32 +(@GUID,3,-2766.9,7831.707,-28.99045,0,0,0,100,0), -- 17:48:48 +(@GUID,4,-2776.292,7868.074,-32.95581,0,0,0,100,0), -- 17:48:59 +(@GUID,5,-2777.775,7900.986,-36.16138,0,0,0,100,0), -- 17:49:14 +(@GUID,6,-2788.39,7918.089,-33.02819,0,0,0,100,0), -- 17:49:26 +(@GUID,7,-2807.047,7930.485,-28.70544,0,0,0,100,0), -- 17:49:34 +(@GUID,8,-2820.076,7942.464,-24.23338,0,0,0,100,0), -- 17:49:44 +(@GUID,9,-2811.142,7933.16,-27.23658,0,0,0,100,0), -- 17:49:51 +(@GUID,10,-2792.437,7922.438,-32.35848,0,0,0,100,0), -- 17:49:56 +(@GUID,11,-2779.116,7904.042,-35.84225,0,0,0,100,0), -- 17:50:06 +(@GUID,12,-2777.534,7878.43,-33.79493,0,0,0,100,0), -- 17:50:15 +(@GUID,13,-2772.507,7842.947,-29.39881,0,0,0,100,0), -- 17:50:27 +(@GUID,14,-2753.878,7817.817,-31.29185,0,0,0,100,0); -- 17:50:41 +-- 0x203AF4424011E78000004E000422A884 .go -2734.878 7787.57 -31.95395 + +-- Pathing for Entry: 18334 'TDB FORMAT' +SET @GUID := 65658; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-2194.39,`position_y`=7531.68,`position_z`=-28.4981 WHERE `guid`=@GUID; +DELETE FROM `creature_addon` WHERE `guid`=@GUID; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@GUID,@GUID,0,0,4097,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@GUID; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@GUID,1,-2174.563,7474.802,-33.41673,0,0,0,100,0), -- 23:41:01 +(@GUID,2,-2173.903,7465.789,-34.45302,0,0,0,100,0), -- 23:41:13 +(@GUID,3,-2168.34,7421.876,-33.72536,0,0,0,100,0), -- 23:41:22 +(@GUID,4,-2170.287,7433.129,-35.00093,0,0,0,100,0), -- 23:41:36 +(@GUID,5,-2174.035,7469.135,-34.35434,0,0,0,100,0), -- 23:41:49 +(@GUID,6,-2177.058,7497.729,-31.92061,0,0,0,100,0), -- 23:41:57 +(@GUID,7,-2186.501,7522.515,-30.27327,0,0,0,100,0), -- 23:42:09 +(@GUID,8,-2197.183,7534.59,-27.64496,0,0,0,100,0), -- 23:42:19 +(@GUID,9,-2210.867,7551.57,-24.63984,0,0,0,100,0), -- 23:42:26 +(@GUID,10,-2220.933,7561.727,-22.92727,0,0,0,100,0), -- 23:42:35 +(@GUID,11,-2241.067,7570.204,-20.10358,0,0,0,100,0), -- 23:42:42 +(@GUID,12,-2260.738,7566.847,-16.69444,0,0,0,100,0), -- 23:42:49 +(@GUID,13,-2274.992,7559.235,-14.27239,0,0,0,100,0), -- 23:42:58 +(@GUID,14,-2291.522,7561.524,-11.96934,0,0,0,100,0), -- 23:43:05 +(@GUID,15,-2308.261,7577.214,-8.312639,0,0,0,100,0), -- 23:43:12 +(@GUID,16,-2320.567,7584.441,-7.4962,0,0,0,100,0), -- 23:43:21 +(@GUID,17,-2336.248,7588.756,-6.660901,0,0,0,100,0), -- 23:43:27 +(@GUID,18,-2326.12,7586.88,-7.028824,0,0,0,100,0), -- 23:43:35 +(@GUID,19,-2318.203,7583.188,-7.76639,0,0,0,100,0), -- 23:43:40 +(@GUID,20,-2298.529,7566.686,-10.36064,0,0,0,100,0), -- 23:43:46 +(@GUID,21,-2281.937,7557.433,-13.36305,0,0,0,100,0), -- 23:43:55 +(@GUID,22,-2264.897,7564.749,-15.72989,0,0,0,100,0), -- 23:44:02 +(@GUID,23,-2243.441,7570.386,-19.43285,0,0,0,100,0), -- 23:44:10 +(@GUID,24,-2226.243,7565.745,-22.0393,0,0,0,100,0), -- 23:44:18 +(@GUID,25,-2216.101,7557.269,-23.55024,0,0,0,100,0), -- 23:44:25 +(@GUID,26,-2201.051,7538.647,-26.74527,0,0,0,100,0), -- 23:44:33 +(@GUID,27,-2191.496,7529.282,-28.76989,0,0,0,100,0), -- 23:44:41 +(@GUID,28,-2183.993,7516.437,-31.02223,0,0,0,100,0), -- 23:44:47 +(@GUID,29,-2174.547,7474.765,-33.41794,0,0,0,100,0), -- 23:44:58 +(@GUID,30,-2173.897,7465.742,-34.46141,0,0,0,100,0), -- 23:45:10 +(@GUID,31,-2168.338,7421.841,-33.72625,0,0,0,100,0), -- 23:45:19 +(@GUID,32,-2170.287,7433.129,-35.00093,0,0,0,100,0); -- 23:45:33 +-- 0x203AF4424011E78000004E000024F34E .go -2174.563 7474.802 -33.41673 + +-- Pathing for Entry: 18334 'TDB FORMAT' +SET @GUID := 65664; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1520.43,`position_y`=6779.92,`position_z`=15.7022 WHERE `guid`=@GUID; +DELETE FROM `creature_addon` WHERE `guid`=@GUID; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@GUID,@GUID,0,0,4097,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@GUID; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@GUID,1,-1478.384,6821.081,12.3371,0,0,0,100,0), -- 00:16:41 +(@GUID,2,-1461.294,6839.07,13.80124,0,0,0,100,0), -- 00:16:54 +(@GUID,3,-1422.633,6884.449,17.41131,0,0,0,100,0), -- 00:17:05 +(@GUID,4,-1404.191,6929.119,16.5009,0,0,0,100,0), -- 00:17:24 +(@GUID,5,-1399.407,6958.563,13.41168,0,0,0,100,0), -- 00:17:42 +(@GUID,6,-1403.5,6931.095,16.08972,0,0,0,100,0), -- 00:17:57 +(@GUID,7,-1417.5,6895.715,17.50602,0,0,0,100,0), -- 00:18:09 +(@GUID,8,-1447.766,6854.247,14.47745,0,0,0,100,0), -- 00:18:28 +(@GUID,9,-1466.076,6833.959,13.08254,0,0,0,100,0), -- 00:18:48 +(@GUID,10,-1490.93,6808.366,14.66289,0,0,0,100,0), -- 00:18:58 +(@GUID,11,-1499.758,6799.843,16.24991,0,0,0,100,0), -- 00:19:11 +(@GUID,12,-1540.873,6755.851,15.91483,0,0,0,100,0), -- 00:19:27 +(@GUID,13,-1522.77,6777.234,16.15338,0,0,0,100,0), -- 00:19:43 +(@GUID,14,-1493.864,6805.536,15.32713,0,0,0,100,0); -- 00:19:57 +-- 0x203AF4424011E78000004E000024FED8 .go -1478.384 6821.081 12.3371 + +-- Pathing for Entry: 18334 'TDB FORMAT' +SET @GUID := 65657; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@GUID; +DELETE FROM `creature_addon` WHERE `guid`=@GUID; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@GUID,@GUID,0,0,4097,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@GUID; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@GUID,1,-1966.289,7782.999,-50.16899,0,0,0,100,0), -- 18:08:38 +(@GUID,2,-1968.533,7796.549,-47.72079,0,0,0,100,0), -- 18:08:47 +(@GUID,3,-1969.226,7822.298,-41.31853,0,0,0,100,0), -- 18:08:53 +(@GUID,4,-1968.798,7843.106,-36.28822,0,0,0,100,0), -- 18:09:03 +(@GUID,5,-1968.708,7867.842,-32.81573,0,0,0,100,0), -- 18:09:12 +(@GUID,6,-1972.283,7876.478,-30.59978,0,0,0,100,0), -- 18:09:21 +(@GUID,7,-1987.089,7896.491,-31.31792,0,0,0,100,0), -- 18:09:29 +(@GUID,8,-2011.68,7902.815,-30.0549,0,0,0,100,0), -- 18:09:40 +(@GUID,9,-2021.044,7900.263,-29.21589,0,0,0,100,0), -- 18:09:48 +(@GUID,10,-2035.616,7890.054,-28.23161,0,0,0,100,0), -- 18:09:53 +(@GUID,11,-2060.752,7865.037,-26.96479,0,0,0,100,0), -- 18:09:59 +(@GUID,12,-2076.108,7844.815,-22.70536,0,0,0,100,0), -- 18:10:12 +(@GUID,13,-2089.256,7827.075,-21.07095,0,0,0,100,0), -- 18:10:23 +(@GUID,14,-2105.831,7791.486,-24.94334,0,0,0,100,0), -- 18:10:33 +(@GUID,15,-2126.039,7750.967,-27.52921,0,0,0,100,0), -- 18:10:50 +(@GUID,16,-2109.755,7782.88,-25.82896,0,0,0,100,0), -- 18:11:08 +(@GUID,17,-2096.188,7813.935,-22.10828,0,0,0,100,0), -- 18:11:23 +(@GUID,18,-2079.774,7840.229,-21.69007,0,0,0,100,0), -- 18:11:40 +(@GUID,19,-2065.585,7858.899,-26.14882,0,0,0,100,0), -- 18:11:49 +(@GUID,20,-2052.721,7873.183,-27.95574,0,0,0,100,0), -- 18:12:00 +(@GUID,21,-2031.826,7893.363,-28.59493,0,0,0,100,0), -- 18:12:13 +(@GUID,22,-2020.586,7900.396,-29.42924,0,0,0,100,0), -- 18:12:20 +(@GUID,23,-1998.706,7903.119,-30.6776,0,0,0,100,0), -- 18:12:25 +(@GUID,24,-1982.296,7891.21,-30.84521,0,0,0,100,0), -- 18:12:33 +(@GUID,25,-1969.664,7871.461,-31.65129,0,0,0,100,0), -- 18:12:44 +(@GUID,26,-1968.788,7856.637,-35.1958,0,0,0,100,0), -- 18:12:50 +(@GUID,27,-1969.054,7826.09,-40.23038,0,0,0,100,0), -- 18:13:01 +(@GUID,28,-1969.389,7801.586,-46.17776,0,0,0,100,0), -- 18:13:10 +(@GUID,29,-1966.288,7782.938,-50.05931,0,0,0,100,0), -- 18:13:19 +(@GUID,30,-1968.533,7796.549,-47.72079,0,0,0,100,0), -- 18:13:28 +(@GUID,31,-1969.296,7822.302,-41.32153,0,0,0,100,0), -- 18:13:34 +(@GUID,32,-1968.799,7843.09,-36.13723,0,0,0,100,0), -- 18:13:45 +(@GUID,33,-1968.688,7867.88,-32.93111,0,0,0,100,0), -- 18:13:53 +(@GUID,34,-1972.282,7876.555,-30.68247,0,0,0,100,0), -- 18:14:03 +(@GUID,35,-1987.122,7896.296,-31.28928,0,0,0,100,0); -- 18:14:11 +-- 0x203AF4424011E78000004E000025E6CC .go -1966.289 7782.999 -50.16899 + +-- Pathing for Entry: 18334 'TDB FORMAT' +SET @GUID := 65662; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@GUID; +DELETE FROM `creature_addon` WHERE `guid`=@GUID; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@GUID,@GUID,0,0,4097,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@GUID; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@GUID,1,-1577.223,7116.43,9.134361,0,0,0,100,0), -- 21:23:06 +(@GUID,2,-1569.741,7127.651,11.35795,0,0,0,100,0), -- 21:23:16 +(@GUID,3,-1567.184,7131.216,11.57992,0,0,0,100,0), -- 21:23:23 +(@GUID,4,-1566.232,7164.062,9.502401,0,0,0,100,0), -- 21:23:30 +(@GUID,5,-1579.337,7179.873,7.692366,0,0,0,100,0), -- 21:23:36 +(@GUID,6,-1590.527,7192.306,6.606363,0,0,0,100,0), -- 21:23:46 +(@GUID,7,-1616.887,7222.026,6.090874,0,0,0,100,0), -- 21:23:57 +(@GUID,8,-1632.668,7235.391,4.303286,0,0,0,100,0), -- 21:24:08 +(@GUID,9,-1649.182,7249.502,2.978147,0,0,0,100,0), -- 21:24:16 +(@GUID,10,-1663.21,7262.692,1.710088,0,0,0,100,0), -- 21:24:24 +(@GUID,11,-1672.39,7280.579,-0.9890751,0,0,0,100,0), -- 21:24:32 +(@GUID,12,-1671.511,7291.896,-2.59061,0,0,0,100,0), -- 21:24:40 +(@GUID,13,-1672.266,7285.227,-1.696026,0,0,0,100,0), -- 21:24:48 +(@GUID,14,-1666.033,7266.865,1.135019,0,0,0,100,0), -- 21:24:54 +(@GUID,15,-1653.479,7253.245,2.542091,0,0,0,100,0), -- 21:25:01 +(@GUID,16,-1639.864,7241.508,3.429439,0,0,0,100,0), -- 21:25:10 +(@GUID,17,-1619.332,7223.901,5.694285,0,0,0,100,0), -- 21:25:18 +(@GUID,18,-1612.078,7216.344,6.479156,0,0,0,100,0), -- 21:25:27 +(@GUID,19,-1600.532,7203.195,6.74604,0,0,0,100,0), -- 21:25:38 +(@GUID,20,-1568.358,7166.74,9.019341,0,0,0,100,0), -- 21:25:49 +(@GUID,21,-1561.81,7148.381,10.85218,0,0,0,100,0), -- 21:25:59 +(@GUID,22,-1564.552,7139.45,11.80651,0,0,0,100,0); -- 21:26:06 +-- 0x203AF4424011E78000004E0000262247 .go -1577.223 7116.43 9.134361 + +-- Pathing for Entry: 18334 'TDB FORMAT' +SET @GUID := 65647; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@GUID; +DELETE FROM `creature_addon` WHERE `guid`=@GUID; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@GUID,@GUID,0,0,4097,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@GUID; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@GUID,1,-1834.752,6454.875,26.86079,0,0,0,100,0), -- 23:32:59 +(@GUID,2,-1800.979,6461.191,35.33779,0,0,0,100,0), -- 23:33:08 +(@GUID,3,-1793.701,6460.261,40.42421,0,0,0,100,0), -- 23:33:21 +(@GUID,4,-1783.613,6462.039,41.75187,0,0,0,100,0), -- 23:33:27 +(@GUID,5,-1776.539,6477.089,46.6764,0,0,0,100,0), -- 23:33:33 +(@GUID,6,-1776.082,6469.592,43.53386,0,0,0,100,0), -- 23:33:40 +(@GUID,7,-1783.878,6461.541,41.92315,0,0,0,100,0), -- 23:33:44 +(@GUID,8,-1798.169,6461.243,37.27209,0,0,0,100,0), -- 23:33:49 +(@GUID,9,-1828.329,6454.762,27.57287,0,0,0,100,0), -- 23:33:55 +(@GUID,10,-1847.793,6456.353,26.41575,0,0,0,100,0), -- 23:34:08 +(@GUID,11,-1880.324,6458.532,28.61514,0,0,0,100,0), -- 23:34:17 +(@GUID,12,-1888.081,6457.873,29.59407,0,0,0,100,0), -- 23:34:29 +(@GUID,13,-1919.655,6459.986,28.07707,0,0,0,100,0), -- 23:34:36 +(@GUID,14,-1945.343,6469.1,22.66152,0,0,0,100,0), -- 23:34:45 +(@GUID,15,-1952.141,6471.51,22.01204,0,0,0,100,0), -- 23:34:58 +(@GUID,16,-1968.71,6476.275,22.24739,0,0,0,100,0), -- 23:35:06 +(@GUID,17,-2003.271,6473.622,21.54292,0,0,0,100,0), -- 23:35:14 +(@GUID,18,-2010.868,6471.325,21.2761,0,0,0,100,0), -- 23:35:23 +(@GUID,19,-2046.419,6450.189,23.66801,0,0,0,100,0), -- 23:35:31 +(@GUID,20,-2061.182,6432.168,28.19959,0,0,0,100,0), -- 23:35:41 +(@GUID,21,-2067.351,6422.73,29.15,0,0,0,100,0), -- 23:35:51 +(@GUID,22,-2065.856,6425.313,28.68368,0,0,0,100,0), -- 23:35:59 +(@GUID,23,-2050.113,6447.179,24.38938,0,0,0,100,0), -- 23:36:05 +(@GUID,24,-2034.957,6458.48,21.88783,0,0,0,100,0), -- 23:36:14 +(@GUID,25,-2030.312,6461.822,21.11793,0,0,0,100,0), -- 23:36:23 +(@GUID,26,-2001.154,6474.045,21.7739,0,0,0,100,0), -- 23:36:32 +(@GUID,27,-1989.639,6476.935,22.19421,0,0,0,100,0), -- 23:36:40 +(@GUID,28,-1968.369,6476.048,22.20636,0,0,0,100,0), -- 23:36:49 +(@GUID,29,-1923.969,6461.55,27.18353,0,0,0,100,0), -- 23:36:56 +(@GUID,30,-1908.116,6458.206,29.54674,0,0,0,100,0), -- 23:37:10 +(@GUID,31,-1886.354,6458.063,29.17184,0,0,0,100,0), -- 23:37:18 +(@GUID,32,-1862.282,6457.62,26.82578,0,0,0,100,0); -- 23:37:25 +-- 0x203AF4424011E78000004E00002633F0 .go -1834.752 6454.875 26.86079 + +-- Pathing for Entry: 18334 'TDB FORMAT' +SET @GUID := 65648; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@GUID; +DELETE FROM `creature_addon` WHERE `guid`=@GUID; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@GUID,@GUID,0,0,4097,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@GUID; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@GUID,1,-2126.693,6239.017,72.7256,0,0,0,100,0), -- 23:46:47 +(@GUID,2,-2119.314,6213.649,81.36611,0,0,0,100,0), -- 23:46:59 +(@GUID,3,-2107.719,6178.692,88.54082,0,0,0,100,0), -- 23:47:10 +(@GUID,4,-2118.661,6212.45,81.80202,0,0,0,100,0), -- 23:47:26 +(@GUID,5,-2125.859,6235.744,74.0819,0,0,0,100,0), -- 23:47:40 +(@GUID,6,-2127.663,6264.234,65.04448,0,0,0,100,0), -- 23:47:51 +(@GUID,7,-2152.114,6290.877,55.80878,0,0,0,100,0), -- 23:48:04 +(@GUID,8,-2176.058,6308.648,49.91105,0,0,0,100,0), -- 23:48:19 +(@GUID,9,-2202.254,6318.988,43.55692,0,0,0,100,0), -- 23:48:31 +(@GUID,10,-2222.569,6328.265,38.86273,0,0,0,100,0), -- 23:48:42 +(@GUID,11,-2252.233,6335.9,43.29943,0,0,0,100,0), -- 23:48:55 +(@GUID,12,-2283.341,6341.71,39.21158,0,0,0,100,0), -- 23:49:07 +(@GUID,13,-2311.41,6334.139,33.03185,0,0,0,100,0), -- 23:49:16 +(@GUID,14,-2329.011,6325.256,29.58763,0,0,0,100,0), -- 23:49:29 +(@GUID,15,-2316.089,6331.952,32.04526,0,0,0,100,0), -- 23:49:38 +(@GUID,16,-2285.619,6341.726,38.52241,0,0,0,100,0), -- 23:49:44 +(@GUID,17,-2266.126,6338.675,43.154,0,0,0,100,0), -- 23:49:57 +(@GUID,18,-2234.443,6332.935,39.24818,0,0,0,100,0), -- 23:50:07 +(@GUID,19,-2205.476,6320.33,42.37166,0,0,0,100,0), -- 23:50:18 +(@GUID,20,-2184.05,6312.602,48.70446,0,0,0,100,0), -- 23:50:31 +(@GUID,21,-2156.169,6294.522,54.56664,0,0,0,100,0), -- 23:50:42 +(@GUID,22,-2128.61,6266.641,64.29518,0,0,0,100,0); -- 23:50:55 +-- 0x203AF4424011E78000004E0000262662 .go -2126.693 6239.017 72.7256 + +-- Pathing for Entry: 18334 'TDB FORMAT' +SET @GUID := 65649; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@GUID; +DELETE FROM `creature_addon` WHERE `guid`=@GUID; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@GUID,@GUID,0,0,4097,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@GUID; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@GUID,1,-2585.925,6393.098,29.64841,0,0,0,100,0), -- 23:55:15 +(@GUID,2,-2591.24,6407.891,27.55262,0,0,0,100,0), -- 23:55:26 +(@GUID,3,-2599.723,6435.602,27.35635,0,0,0,100,0), -- 23:55:34 +(@GUID,4,-2603.277,6466.338,22.72696,0,0,0,100,0), -- 23:55:45 +(@GUID,5,-2604.06,6484.821,20.41327,0,0,0,100,0), -- 23:55:59 +(@GUID,6,-2599.066,6516.159,17.68868,0,0,0,100,0), -- 23:56:08 +(@GUID,7,-2589.615,6542.362,13.32788,0,0,0,100,0), -- 23:56:18 +(@GUID,8,-2577.838,6559.287,11.21143,0,0,0,100,0), -- 23:56:29 +(@GUID,9,-2558.885,6579.771,7.326009,0,0,0,100,0), -- 23:56:38 +(@GUID,10,-2545.771,6602.757,2.534073,0,0,0,100,0), -- 23:56:50 +(@GUID,11,-2539.133,6616.802,0.4829364,0,0,0,100,0), -- 23:56:59 +(@GUID,12,-2536.86,6625.967,0.8791575,0,0,0,100,0), -- 23:57:05 +(@GUID,13,-2515.356,6659.719,2.398494,0,0,0,100,0), -- 23:57:18 +(@GUID,14,-2495.58,6667.909,4.119918,0,0,0,100,0), -- 23:57:27 +(@GUID,15,-2486.859,6671.273,3.723157,0,0,0,100,0), -- 23:57:38 +(@GUID,16,-2487.116,6671.07,3.631673,0,0,0,100,0), -- 23:57:52 +(@GUID,17,-2501.805,6665.751,3.328776,0,0,0,100,0), -- 23:58:03 +(@GUID,18,-2524.225,6652.958,1.235423,0,0,0,100,0), -- 23:58:14 +(@GUID,19,-2538.057,6619.963,0.3882366,0,0,0,100,0), -- 23:58:24 +(@GUID,20,-2543.838,6606.063,1.966996,0,0,0,100,0), -- 23:58:35 +(@GUID,21,-2556.168,6583.419,6.166683,0,0,0,100,0), -- 23:58:42 +(@GUID,22,-2574.833,6562.892,9.942083,0,0,0,100,0), -- 23:58:53 +(@GUID,23,-2582.796,6551.989,12.25274,0,0,0,100,0), -- 23:59:03 +(@GUID,24,-2596.887,6521.549,16.85234,0,0,0,100,0), -- 23:59:12 +(@GUID,25,-2603.945,6496.051,19.94339,0,0,0,100,0), -- 23:59:23 +(@GUID,26,-2603.87,6471.16,21.98938,0,0,0,100,0), -- 23:59:33 +(@GUID,27,-2600.861,6440.42,26.66329,0,0,0,100,0), -- 23:59:42 +(@GUID,28,-2594.183,6416.707,27.87725,0,0,0,100,0); -- 23:59:56 +-- 0x203AF4424011E78000004E0000263789 .go -2585.925 6393.098 29.64841 + +-- Pathing for Entry: 18334 'TDB FORMAT' +SET @GUID := 65652; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@GUID; +DELETE FROM `creature_addon` WHERE `guid`=@GUID; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@GUID,@GUID,0,0,4097,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@GUID; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@GUID,1,-2138.354,8152.989,-17.22172,0,0,0,100,0), -- 00:10:50 +(@GUID,2,-2139.332,8151.859,-17.38486,0,0,0,100,0), -- 00:10:59 +(@GUID,3,-2144.721,8109.328,-14.87674,0,0,0,100,0), -- 00:11:08 +(@GUID,4,-2149.386,8096.513,-13.81364,0,0,0,100,0), -- 00:11:18 +(@GUID,5,-2169.473,8077.414,-16.66967,0,0,0,100,0), -- 00:11:25 +(@GUID,6,-2179.198,8060.242,-18.91715,0,0,0,100,0), -- 00:11:35 +(@GUID,7,-2180.498,8038.136,-17.21233,0,0,0,100,0), -- 00:11:44 +(@GUID,8,-2177.994,8019.822,-14.56186,0,0,0,100,0), -- 00:11:53 +(@GUID,9,-2181.188,8009.348,-15.42714,0,0,0,100,0), -- 00:12:00 +(@GUID,10,-2178.981,8014.441,-14.62748,0,0,0,100,0), -- 00:12:08 +(@GUID,11,-2179.929,8031.977,-16.31877,0,0,0,100,0), -- 00:12:12 +(@GUID,12,-2181.96,8054.216,-18.99487,0,0,0,100,0), -- 00:12:18 +(@GUID,13,-2171.656,8075.128,-17.34079,0,0,0,100,0), -- 00:12:28 +(@GUID,14,-2155.154,8087.903,-13.98548,0,0,0,100,0), -- 00:12:37 +(@GUID,15,-2145.264,8108.008,-14.65509,0,0,0,100,0), -- 00:12:46 +(@GUID,16,-2142.832,8124.181,-16.47704,0,0,0,100,0), -- 00:12:55 +(@GUID,17,-2141.562,8131.214,-17.44239,0,0,0,100,0), -- 00:13:03 +(@GUID,18,-2125.837,8168.122,-15.21656,0,0,0,100,0); -- 00:13:12 +-- 0x203AF4424011E78000004E0000263FB8 .go -2138.354 8152.989 -17.22172 + +-- Pathing for Entry: 18334 'TDB FORMAT' +SET @GUID := 65653; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@GUID; +DELETE FROM `creature_addon` WHERE `guid`=@GUID; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@GUID,@GUID,0,0,4097,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@GUID; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@GUID,1,-2898.377,8307.381,-31.67321,0,0,0,100,0), -- 00:19:12 +(@GUID,2,-2901.179,8298.313,-32.7457,0,0,0,100,0), -- 00:19:20 +(@GUID,3,-2901.053,8299.016,-32.60822,0,0,0,100,0), -- 00:19:30 +(@GUID,4,-2894.577,8317.129,-30.78543,0,0,0,100,0), -- 00:19:37 +(@GUID,5,-2890.901,8325.871,-30.59866,0,0,0,100,0), -- 00:19:46 +(@GUID,6,-2866.041,8345.82,-30.81076,0,0,0,100,0), -- 00:19:53 +(@GUID,7,-2849.758,8361.666,-30.32227,0,0,0,100,0), -- 00:20:03 +(@GUID,8,-2842.846,8374.494,-30.5211,0,0,0,100,0), -- 00:20:15 +(@GUID,9,-2840.746,8432.953,-30.15903,0,0,0,100,0), -- 00:20:26 +(@GUID,10,-2835.173,8446.146,-31.95422,0,0,0,100,0), -- 00:20:38 +(@GUID,11,-2827.901,8457.858,-32.86356,0,0,0,100,0), -- 00:20:46 +(@GUID,12,-2814.782,8480.281,-31.76475,0,0,0,100,0), -- 00:20:53 +(@GUID,13,-2809.755,8494.485,-30.93392,0,0,0,100,0), -- 00:21:00 +(@GUID,14,-2811.876,8487.129,-31.36007,0,0,0,100,0), -- 00:21:08 +(@GUID,15,-2819.095,8470.451,-32.65718,0,0,0,100,0), -- 00:21:12 +(@GUID,16,-2832.487,8451.91,-32.30348,0,0,0,100,0), -- 00:21:20 +(@GUID,17,-2839.542,8435.974,-30.47555,0,0,0,100,0), -- 00:21:28 +(@GUID,18,-2841.62,8424.307,-30.78892,0,0,0,100,0), -- 00:21:35 +(@GUID,19,-2842.871,8401.959,-30.77183,0,0,0,100,0), -- 00:21:48 +(@GUID,20,-2854.29,8353.625,-30.90292,0,0,0,100,0), -- 00:21:59 +(@GUID,21,-2873.958,8342.044,-30.46323,0,0,0,100,0), -- 00:22:09 +(@GUID,22,-2879.57,8339.491,-30.33056,0,0,0,100,0); -- 00:22:20 +-- 0x203AF4424011E78000004E000025E6F5 .go -2898.377 8307.381 -31.67321 + +-- Pathing for Entry: 18334 'TDB FORMAT' +SET @GUID := 65655; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@GUID; +DELETE FROM `creature_addon` WHERE `guid`=@GUID; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@GUID,@GUID,0,0,4097,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@GUID; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@GUID,1,-2278.507,8658.529,-9.223353,0,0,0,100,0), -- 00:26:54 +(@GUID,2,-2307.501,8652.371,-13.51316,0,0,0,100,0), -- 00:27:05 +(@GUID,3,-2325.801,8642.944,-16.03048,0,0,0,100,0), -- 00:27:17 +(@GUID,4,-2333.431,8628.619,-18.58308,0,0,0,100,0), -- 00:27:25 +(@GUID,5,-2338.136,8604.41,-20.94481,0,0,0,100,0), -- 00:27:32 +(@GUID,6,-2343.163,8571.582,-26.8824,0,0,0,100,0), -- 00:27:42 +(@GUID,7,-2339.06,8599.572,-22.13805,0,0,0,100,0), -- 00:27:56 +(@GUID,8,-2334.667,8625.227,-18.91174,0,0,0,100,0), -- 00:28:08 +(@GUID,9,-2327.625,8641.408,-16.31199,0,0,0,100,0), -- 00:28:18 +(@GUID,10,-2316.982,8648.273,-14.85222,0,0,0,100,0), -- 00:28:25 +(@GUID,11,-2285.132,8657.02,-10.23796,0,0,0,100,0), -- 00:28:32 +(@GUID,12,-2258.549,8661.555,-7.56432,0,0,0,100,0), -- 00:28:45 +(@GUID,13,-2255.743,8662.08,-7.521385,0,0,0,100,0), -- 00:28:55 +(@GUID,14,-2227.405,8674.256,-6.104901,0,0,0,100,0), -- 00:29:03 +(@GUID,15,-2215.896,8682.293,-3.399796,0,0,0,100,0), -- 00:29:09 +(@GUID,16,-2221.09,8678.688,-4.301564,0,0,0,100,0), -- 00:29:16 +(@GUID,17,-2235.881,8668.545,-7.750009,0,0,0,100,0), -- 00:29:22 +(@GUID,18,-2238.266,8666.847,-7.867585,0,0,0,100,0); -- 00:29:28 +-- 0x203AF4424011E78000004E000025E43C .go -2278.507 8658.529 -9.223353 + +-- Pathing for Entry: 18334 'TDB FORMAT' +SET @GUID := 65656; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@GUID; +DELETE FROM `creature_addon` WHERE `guid`=@GUID; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@GUID,@GUID,0,0,4097,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@GUID; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@GUID,1,-1956.735,8074.969,-15.64434,0,0,0,100,0), -- 00:33:55 +(@GUID,2,-1955.278,8079.891,-14.87942,0,0,0,100,0), -- 00:34:01 +(@GUID,3,-1944.631,8092.254,-14.65845,0,0,0,100,0), -- 00:34:08 +(@GUID,4,-1944.923,8092.063,-14.84067,0,0,0,100,0), -- 00:34:14 +(@GUID,5,-1944.926,8092.121,-14.69281,0,0,0,100,0), -- 00:34:17 +(@GUID,6,-1957.625,8070.56,-15.94069,0,0,0,100,0), -- 00:34:23 +(@GUID,7,-1963.358,8051.472,-17.6675,0,0,0,100,0), -- 00:34:29 +(@GUID,8,-1975.043,8038.899,-17.10886,0,0,0,100,0), -- 00:34:37 +(@GUID,9,-1994.447,8031.636,-14.62317,0,0,0,100,0), -- 00:34:44 +(@GUID,10,-2021.598,8032.464,-13.52624,0,0,0,100,0), -- 00:34:53 +(@GUID,11,-2000.459,8031.319,-14.53973,0,0,0,100,0), -- 00:35:04 +(@GUID,12,-1981.429,8035.199,-15.77899,0,0,0,100,0), -- 00:35:13 +(@GUID,13,-1967.366,8045.611,-18.14491,0,0,0,100,0), -- 00:35:21 +(@GUID,14,-1959.855,8063.115,-16.9567,0,0,0,100,0); -- 00:35:28 +-- 0x203AF4424011E78000004E0000262580 .go -1956.735 8074.969 -15.64434 + +-- Pathing for Entry: 18334 'TDB FORMAT' +SET @GUID := 65659; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@GUID; +DELETE FROM `creature_addon` WHERE `guid`=@GUID; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@GUID,@GUID,0,0,4097,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@GUID; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@GUID,1,-2070.067,7102.888,-2.052302,0,0,0,100,0), -- 00:41:16 +(@GUID,2,-2087.792,7091.019,-2.84837,0,0,0,100,0), -- 00:41:28 +(@GUID,3,-2094.955,7083.156,-7.530978,0,0,0,100,0), -- 00:41:33 +(@GUID,4,-2119.192,7073.39,-5.840673,0,0,0,100,0), -- 00:41:39 +(@GUID,5,-2144.562,7071.356,-10.23449,0,0,0,100,0), -- 00:41:50 +(@GUID,6,-2166.686,7075.237,-10.12987,0,0,0,100,0), -- 00:42:03 +(@GUID,7,-2212.567,7082.845,-12.61264,0,0,0,100,0), -- 00:42:14 +(@GUID,8,-2244.822,7077.09,-16.42495,0,0,0,100,0), -- 00:42:28 +(@GUID,9,-2255.132,7071.432,-18.17007,0,0,0,100,0), -- 00:42:41 +(@GUID,10,-2300.193,7055.505,-14.9094,0,0,0,100,0), -- 00:42:53 +(@GUID,11,-2283.766,7058.581,-18.95871,0,0,0,100,0), -- 00:43:07 +(@GUID,12,-2251.402,7073.429,-17.71605,0,0,0,100,0), -- 00:43:19 +(@GUID,13,-2218.918,7081.915,-12.42291,0,0,0,100,0), -- 00:43:31 +(@GUID,14,-2200.548,7081.673,-10.34254,0,0,0,100,0), -- 00:43:44 +(@GUID,15,-2180.577,7079.616,-10.4028,0,0,0,100,0), -- 00:43:57 +(@GUID,16,-2126.396,7072.2,-6.481983,0,0,0,100,0), -- 00:44:08 +(@GUID,17,-2100.881,7079.062,-7.246603,0,0,0,100,0), -- 00:44:22 +(@GUID,18,-2089.061,7089.905,-3.560722,0,0,0,100,0), -- 00:44:33 +(@GUID,19,-2086.757,7091.884,-2.422595,0,0,0,100,0), -- 00:44:39 +(@GUID,20,-2055.03,7111.666,-1.71111,0,0,0,100,0), -- 00:44:44 +(@GUID,21,-2037.368,7115.566,2.335891,0,0,0,100,0), -- 00:44:56 +(@GUID,22,-2051.541,7113.85,-0.620634,0,0,0,100,0); -- 00:45:04 +-- 0x203AF4424011E78000004E000026020F .go -2070.067 7102.888 -2.052302 + +-- Pathing for Entry: 18334 'TDB FORMAT' +SET @GUID := 65660; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@GUID; +DELETE FROM `creature_addon` WHERE `guid`=@GUID; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@GUID,@GUID,0,0,4097,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@GUID; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@GUID,1,-1942.642,6849.093,-72.92125,0,0,0,100,0), -- 00:49:28 +(@GUID,2,-1933.504,6826.45,-75.26394,0,0,0,100,0), -- 00:49:36 +(@GUID,3,-1931.819,6822.075,-75.37437,0,0,0,100,0), -- 00:49:46 +(@GUID,4,-1922.75,6785.666,-72.95307,0,0,0,100,0), -- 00:49:53 +(@GUID,5,-1907.188,6766.765,-69.14503,0,0,0,100,0), -- 00:50:03 +(@GUID,6,-1890.347,6751.697,-66.49285,0,0,0,100,0), -- 00:50:13 +(@GUID,7,-1871.31,6729.206,-64.48141,0,0,0,100,0), -- 00:50:22 +(@GUID,8,-1858.029,6707.824,-59.51189,0,0,0,100,0), -- 00:50:32 +(@GUID,9,-1844.132,6694.053,-50.41512,0,0,0,100,0), -- 00:50:43 +(@GUID,10,-1825.864,6681.325,-39.15125,0,0,0,100,0), -- 00:50:52 +(@GUID,11,-1802.378,6664.6,-27.10991,0,0,0,100,0), -- 00:51:02 +(@GUID,12,-1823.088,6679.301,-37.80519,0,0,0,100,0), -- 00:51:16 +(@GUID,13,-1842.906,6693.241,-49.26271,0,0,0,100,0), -- 00:51:27 +(@GUID,14,-1854.614,6704.058,-57.28621,0,0,0,100,0), -- 00:51:38 +(@GUID,15,-1869.586,6726.67,-63.91664,0,0,0,100,0), -- 00:51:46 +(@GUID,16,-1887.332,6748.798,-66.11209,0,0,0,100,0), -- 00:51:57 +(@GUID,17,-1901.292,6760.844,-67.79343,0,0,0,100,0), -- 00:52:07 +(@GUID,18,-1919.02,6779.318,-71.78227,0,0,0,100,0), -- 00:52:15 +(@GUID,19,-1928.488,6799.359,-74.2896,0,0,0,100,0), -- 00:52:25 +(@GUID,20,-1930.746,6810.968,-75.21525,0,0,0,100,0), -- 00:52:35 +(@GUID,21,-1938.882,6844.152,-72.96707,0,0,0,100,0), -- 00:52:43 +(@GUID,22,-1953.403,6859.177,-76.03436,0,0,0,100,0), -- 00:52:53 +(@GUID,23,-1967.78,6869.684,-82.02167,0,0,0,100,0), -- 00:53:02 +(@GUID,24,-1975.93,6889.724,-84.45914,0,0,0,100,0), -- 00:53:09 +(@GUID,25,-1978.575,6914.104,-85.60001,0,0,0,100,0), -- 00:53:20 +(@GUID,26,-1977.248,6935.521,-86.65601,0,0,0,100,0), -- 00:53:30 +(@GUID,27,-1970.151,6971.417,-88.13138,0,0,0,100,0), -- 00:53:43 +(@GUID,28,-1959.888,7003.455,-87.7128,0,0,0,100,0), -- 00:53:56 +(@GUID,29,-1955.091,7021.313,-89.54883,0,0,0,100,0), -- 00:54:06 +(@GUID,30,-1940.513,7054.224,-91.4761,0,0,0,100,0), -- 00:54:17 +(@GUID,31,-1946.831,7043.527,-90.23984,0,0,0,100,0), -- 00:54:28 +(@GUID,32,-1956.34,7016.11,-88.76565,0,0,0,100,0), -- 00:54:36 +(@GUID,33,-1957.891,7009.697,-88.14755,0,0,0,100,0), -- 00:54:46 +(@GUID,34,-1973.311,6960.887,-87.6763,0,0,0,100,0), -- 00:54:57 +(@GUID,35,-1978.631,6921.268,-85.86533,0,0,0,100,0), -- 00:55:10 +(@GUID,36,-1978.749,6910.597,-85.46688,0,0,0,100,0), -- 00:55:24 +(@GUID,37,-1970.894,6874.887,-83.08214,0,0,0,100,0), -- 00:55:32 +(@GUID,38,-1955.024,6860.422,-76.7248,0,0,0,100,0); -- 00:55:43 +-- 0x203AF4424011E78000004E0000262DC6 .go -1942.642 6849.093 -72.92125 + +-- Pathing for Entry: 18334 'TDB FORMAT' +SET @GUID := 65661; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@GUID; +DELETE FROM `creature_addon` WHERE `guid`=@GUID; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@GUID,@GUID,0,0,4097,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@GUID; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@GUID,1,-1404.178,6581.783,36.97878,0,0,0,100,0), -- 01:01:21 +(@GUID,2,-1415.946,6566.268,35.83021,0,0,0,100,0), -- 01:01:31 +(@GUID,3,-1423.194,6556.933,35.62516,0,0,0,100,0), -- 01:01:43 +(@GUID,4,-1423.181,6556.937,35.4207,0,0,0,100,0), -- 01:01:59 +(@GUID,5,-1410.495,6573.779,36.27173,0,0,0,100,0), -- 01:02:13 +(@GUID,6,-1392.716,6597.332,39.51819,0,0,0,100,0), -- 01:02:25 +(@GUID,7,-1382.821,6615.047,42.09058,0,0,0,100,0), -- 01:02:35 +(@GUID,8,-1371.363,6644.054,41.38248,0,0,0,100,0), -- 01:02:48 +(@GUID,9,-1364.489,6663.1,40.78107,0,0,0,100,0), -- 01:02:57 +(@GUID,10,-1339.37,6703.84,37.98162,0,0,0,100,0), -- 01:03:10 +(@GUID,11,-1331.182,6715.096,35.57928,0,0,0,100,0), -- 01:03:22 +(@GUID,12,-1306.141,6756.783,37.17308,0,0,0,100,0), -- 01:03:34 +(@GUID,13,-1295.701,6784.692,36.64917,0,0,0,100,0), -- 01:03:51 +(@GUID,14,-1286.531,6811.418,33.71194,0,0,0,100,0), -- 01:04:01 +(@GUID,15,-1273.094,6848.473,34.57795,0,0,0,100,0), -- 01:04:13 +(@GUID,16,-1271.917,6851.317,35.00767,0,0,0,100,0), -- 01:04:27 +(@GUID,17,-1249.046,6889.787,32.25288,0,0,0,100,0), -- 01:04:40 +(@GUID,18,-1257.136,6881.966,34.24331,0,0,0,100,0), -- 01:04:49 +(@GUID,19,-1267.958,6860.314,35.18145,0,0,0,100,0), -- 01:04:55 +(@GUID,20,-1278.259,6833.243,34.0903,0,0,0,100,0), -- 01:05:07 +(@GUID,21,-1293.722,6791.219,36.07722,0,0,0,100,0), -- 01:05:21 +(@GUID,22,-1300.381,6767.007,37.85215,0,0,0,100,0), -- 01:05:34 +(@GUID,23,-1320.033,6731.62,35.67615,0,0,0,100,0), -- 01:05:43 +(@GUID,24,-1336.799,6706.999,36.94962,0,0,0,100,0), -- 01:05:59 +(@GUID,25,-1349.703,6691.412,41.4528,0,0,0,100,0), -- 01:06:11 +(@GUID,26,-1358.422,6679.415,41.01048,0,0,0,100,0), -- 01:06:23 +(@GUID,27,-1372.139,6640.42,41.84719,0,0,0,100,0), -- 01:06:37 +(@GUID,28,-1389.265,6602.389,40.14487,0,0,0,100,0); -- 01:06:47 +-- 0x203AF4424011E78000004E0000264865 .go -1404.178 6581.783 36.97878 + +-- Pathing for Entry: 18334 'TDB FORMAT' +SET @GUID := 65663; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@GUID; +DELETE FROM `creature_addon` WHERE `guid`=@GUID; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@GUID,@GUID,0,0,4097,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@GUID; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@GUID,1,-1485.416,7013.551,4.497173,0,0,0,100,0), -- 01:14:49 +(@GUID,2,-1547.538,6991.499,3.110646,0,0,0,100,0), -- 01:15:06 +(@GUID,3,-1573.989,6989.81,-1.990254,0,0,0,100,0), -- 01:15:17 +(@GUID,4,-1604.381,6998.437,-0.6853603,0,0,0,100,0), -- 01:15:29 +(@GUID,5,-1621.859,7011.414,1.00204,0,0,0,100,0), -- 01:15:43 +(@GUID,6,-1647.53,7051.292,2.072027,0,0,0,100,0), -- 01:15:56 +(@GUID,7,-1658.393,7069.521,5.831712,0,0,0,100,0), -- 01:16:09 +(@GUID,8,-1676.531,7092.237,2.141031,0,0,0,100,0), -- 01:16:20 +(@GUID,9,-1696.452,7110.438,3.136701,0,0,0,100,0), -- 01:16:33 +(@GUID,10,-1700.553,7113.766,3.052119,0,0,0,100,0), -- 01:16:41 +(@GUID,11,-1700.468,7113.456,2.990931,0,0,0,100,0), -- 01:16:48 +(@GUID,12,-1689.626,7104.907,2.57127,0,0,0,100,0), -- 01:16:52 +(@GUID,13,-1665.031,7079.08,5.263766,0,0,0,100,0), -- 01:17:01 +(@GUID,14,-1650.376,7056.501,3.40823,0,0,0,100,0), -- 01:17:14 +(@GUID,15,-1636.578,7026.346,1.583237,0,0,0,100,0), -- 01:17:24 +(@GUID,16,-1614.363,7004.372,0.3699367,0,0,0,100,0), -- 01:17:38 +(@GUID,17,-1581.035,6989.616,-2.253792,0,0,0,100,0), -- 01:17:52 +(@GUID,18,-1551.522,6990.933,2.083474,0,0,0,100,0), -- 01:18:04 +(@GUID,19,-1530.861,6995.087,4.737087,0,0,0,100,0), -- 01:18:17 +(@GUID,20,-1504.083,7005.023,4.345994,0,0,0,100,0), -- 01:18:28 +(@GUID,21,-1469.36,7031.599,8.589698,0,0,0,100,0), -- 01:18:44 +(@GUID,22,-1459.101,7052.883,10.67044,0,0,0,100,0), -- 01:18:55 +(@GUID,23,-1467.617,7033.951,9.086441,0,0,0,100,0), -- 01:19:06 +(@GUID,24,-1481.243,7018.265,5.024168,0,0,0,100,0); -- 01:19:16 +-- 0x203AF4424011E78000004E0000263785 .go -1485.416 7013.551 4.497173 + +-- Pathing for Entry: 18334 'TDB FORMAT' +SET @GUID := 65665; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@GUID; +DELETE FROM `creature_addon` WHERE `guid`=@GUID; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@GUID,@GUID,0,0,4097,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@GUID; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@GUID,1,-726.1278,8258.896,46.79619,0,0,0,100,0), -- 01:24:39 +(@GUID,2,-715.5438,8258.383,50.6083,0,0,0,100,0), -- 01:24:44 +(@GUID,3,-695.5436,8269.021,50.67116,0,0,0,100,0), -- 01:24:50 +(@GUID,4,-677.5765,8283.788,51.27704,0,0,0,100,0), -- 01:25:00 +(@GUID,5,-684.4351,8277.872,50.36641,0,0,0,100,0), -- 01:25:09 +(@GUID,6,-700.7598,8265.637,51.45205,0,0,0,100,0), -- 01:25:15 +(@GUID,7,-722.9138,8258.746,47.99392,0,0,0,100,0), -- 01:25:26 +(@GUID,8,-735.8064,8260.676,43.94917,0,0,0,100,0), -- 01:25:31 +(@GUID,9,-745.5906,8261.691,42.20914,0,0,0,100,0), -- 01:25:37 +(@GUID,10,-777.6868,8258.197,39.82001,0,0,0,100,0), -- 01:25:44 +(@GUID,11,-794.8225,8248.406,37.03281,0,0,0,100,0), -- 01:25:53 +(@GUID,12,-805.4694,8241.086,36.02858,0,0,0,100,0), -- 01:26:03 +(@GUID,13,-827.6669,8229.941,33.95469,0,0,0,100,0), -- 01:26:11 +(@GUID,14,-839.8032,8213.736,32.44018,0,0,0,100,0), -- 01:26:17 +(@GUID,15,-853.3129,8196.732,30.00434,0,0,0,100,0), -- 01:26:25 +(@GUID,16,-857.1725,8186.443,29.1683,0,0,0,100,0), -- 01:26:36 +(@GUID,17,-861.9432,8163.325,27.36681,0,0,0,100,0), -- 01:26:39 +(@GUID,18,-858.407,8125.881,30.55249,0,0,0,100,0), -- 01:26:49 +(@GUID,19,-860.8428,8149.51,27.18979,0,0,0,100,0), -- 01:27:05 +(@GUID,20,-860.2225,8172.098,28.26516,0,0,0,100,0), -- 01:27:19 +(@GUID,21,-856.0573,8192.379,29.52557,0,0,0,100,0), -- 01:27:28 +(@GUID,22,-842.6394,8210.267,31.7333,0,0,0,100,0), -- 01:27:33 +(@GUID,23,-835.7462,8219.619,33.2645,0,0,0,100,0), -- 01:27:42 +(@GUID,24,-816.0286,8234.012,35.40913,0,0,0,100,0), -- 01:27:51 +(@GUID,25,-801.8287,8243.748,36.18961,0,0,0,100,0), -- 01:27:57 +(@GUID,26,-781.1525,8256.221,38.92212,0,0,0,100,0), -- 01:28:04 +(@GUID,27,-761.9681,8261.029,41.3192,0,0,0,100,0), -- 01:28:14 +(@GUID,28,-740.3534,8261.42,42.87246,0,0,0,100,0), -- 01:28:24 +(@GUID,29,-726.1328,8258.857,46.62317,0,0,0,100,0); -- 01:28:31 +-- 0x203AF4424011E78000004E00002643B8 .go -726.1278 8258.896 46.79619 + +-- Pathing for Entry: 18334 'TDB FORMAT' +SET @GUID := 65666; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@GUID; +DELETE FROM `creature_addon` WHERE `guid`=@GUID; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@GUID,@GUID,0,0,4097,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@GUID; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@GUID,1,-944.314,7694.686,38.25343,0,0,0,100,0), -- 01:32:10 +(@GUID,2,-960.3644,7712.979,30.39906,0,0,0,100,0), -- 01:32:23 +(@GUID,3,-959.1507,7729.939,31.55951,0,0,0,100,0), -- 01:32:34 +(@GUID,4,-949.505,7746.969,31.55574,0,0,0,100,0), -- 01:32:43 +(@GUID,5,-935.2028,7765.514,35.1063,0,0,0,100,0), -- 01:32:51 +(@GUID,6,-933.859,7785.102,37.44837,0,0,0,100,0), -- 01:33:00 +(@GUID,7,-935.9513,7800,37.23156,0,0,0,100,0), -- 01:33:10 +(@GUID,8,-929.7489,7828.585,38.2348,0,0,0,100,0), -- 01:33:16 +(@GUID,9,-927.9563,7837.804,39.16978,0,0,0,100,0), -- 01:33:27 +(@GUID,10,-934.1493,7865.022,38.13041,0,0,0,100,0), -- 01:33:35 +(@GUID,11,-963.676,7890.41,38.05733,0,0,0,100,0), -- 01:33:42 +(@GUID,12,-972.8056,7901.368,33.94324,0,0,0,100,0), -- 01:33:56 +(@GUID,13,-973.3759,7908.995,30.522,0,0,0,100,0), -- 01:34:02 +(@GUID,14,-967.3795,7932.751,29.69618,0,0,0,100,0), -- 01:34:09 +(@GUID,15,-971.6959,7922.502,30.16867,0,0,0,100,0), -- 01:34:16 +(@GUID,16,-973.6913,7905.07,32.06013,0,0,0,100,0), -- 01:34:20 +(@GUID,17,-964.774,7891.498,37.93332,0,0,0,100,0), -- 01:34:27 +(@GUID,18,-960.0255,7887.42,37.6365,0,0,0,100,0), -- 01:34:35 +(@GUID,19,-929.3149,7856.846,39.10969,0,0,0,100,0), -- 01:34:48 +(@GUID,20,-928.082,7854.673,39.14806,0,0,0,100,0), -- 01:34:55 +(@GUID,21,-932.9129,7820.926,37.70737,0,0,0,100,0), -- 01:35:04 +(@GUID,22,-935.6017,7798.7,37.56623,0,0,0,100,0), -- 01:35:15 +(@GUID,23,-933.3494,7773.51,36.45978,0,0,0,100,0), -- 01:35:21 +(@GUID,24,-942.5555,7755.716,32.19045,0,0,0,100,0), -- 01:35:31 +(@GUID,25,-944.2391,7753.512,31.65475,0,0,0,100,0), -- 01:35:39 +(@GUID,26,-959.8394,7723.305,30.76319,0,0,0,100,0); -- 01:35:48 +-- 0x203AF4424011E78000004E0000260FB8 .go -944.314 7694.686 38.25343 + +-- Pathing for Entry: 18334 'TDB FORMAT' +SET @GUID := 65667; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@GUID; +DELETE FROM `creature_addon` WHERE `guid`=@GUID; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@GUID,@GUID,0,0,4097,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@GUID; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@GUID,1,-1128.908,8477.045,30.33621,0,0,0,100,0), -- 01:41:12 +(@GUID,2,-1119.157,8462.143,29.5297,0,0,0,100,0), -- 01:41:22 +(@GUID,3,-1101.587,8460.635,27.21489,0,0,0,100,0), -- 01:41:29 +(@GUID,4,-1075.335,8463.006,30.54274,0,0,0,100,0), -- 01:41:40 +(@GUID,5,-1053.572,8463.48,34.12425,0,0,0,100,0), -- 01:41:48 +(@GUID,6,-1047.813,8463.867,34.53427,0,0,0,100,0), -- 01:41:58 +(@GUID,7,-1033.322,8465.708,34.65159,0,0,0,100,0), -- 01:42:04 +(@GUID,8,-1005.902,8453.615,38.15792,0,0,0,100,0), -- 01:42:09 +(@GUID,9,-995.0693,8446.64,40.08287,0,0,0,100,0), -- 01:42:17 +(@GUID,10,-966.594,8437.863,35.65092,0,0,0,100,0), -- 01:42:25 +(@GUID,11,-943.9083,8431.957,37.16125,0,0,0,100,0), -- 01:42:35 +(@GUID,12,-926.6941,8432.678,35.41687,0,0,0,100,0), -- 01:42:44 +(@GUID,13,-914.7294,8432.65,33.39082,0,0,0,100,0), -- 01:42:51 +(@GUID,14,-923.3787,8432.742,34.722,0,0,0,100,0), -- 01:43:01 +(@GUID,15,-936.4376,8431.959,37.06477,0,0,0,100,0), -- 01:43:08 +(@GUID,16,-961.6565,8436.555,35.80644,0,0,0,100,0), -- 01:43:16 +(@GUID,17,-986.3014,8441.924,39.47265,0,0,0,100,0), -- 01:43:24 +(@GUID,18,-1002.232,8450.996,38.95334,0,0,0,100,0), -- 01:43:35 +(@GUID,19,-1015.515,8460.523,35.36264,0,0,0,100,0), -- 01:43:42 +(@GUID,20,-1030.17,8465.472,34.67385,0,0,0,100,0), -- 01:43:51 +(@GUID,21,-1033.581,8465.709,34.56473,0,0,0,100,0), -- 01:43:56 +(@GUID,22,-1071.846,8463.623,31.43729,0,0,0,100,0), -- 01:44:02 +(@GUID,23,-1088.21,8460.65,28.10583,0,0,0,100,0), -- 01:44:11 +(@GUID,24,-1111.78,8460.889,28.34188,0,0,0,100,0); -- 01:44:19 +-- 0x203AF4424011E78000004E00002623F6 .go -1128.908 8477.045 30.33621 + +-- Pathing for Entry: 18334 'TDB FORMAT' +SET @GUID := 65668; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@GUID; +DELETE FROM `creature_addon` WHERE `guid`=@GUID; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@GUID,@GUID,0,0,4097,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@GUID; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@GUID,1,-1298.94,8737.665,33.7051,0,0,0,100,0), -- 01:48:20 +(@GUID,2,-1324.44,8732.457,30.85565,0,0,0,100,0), -- 01:48:30 +(@GUID,3,-1340.438,8734.076,29.74687,0,0,0,100,0), -- 01:48:40 +(@GUID,4,-1364.445,8730.121,26.79006,0,0,0,100,0), -- 01:48:49 +(@GUID,5,-1380.466,8724.014,24.07105,0,0,0,100,0), -- 01:48:56 +(@GUID,6,-1412.805,8720.652,21.99923,0,0,0,100,0), -- 01:49:07 +(@GUID,7,-1402.107,8720.162,22.95799,0,0,0,100,0), -- 01:49:18 +(@GUID,8,-1370.667,8727.73,25.72835,0,0,0,100,0), -- 01:49:25 +(@GUID,9,-1354.004,8734.844,28.96291,0,0,0,100,0), -- 01:49:36 +(@GUID,10,-1341.958,8734.481,30.00632,0,0,0,100,0), -- 01:49:44 +(@GUID,11,-1303.214,8735.422,32.89497,0,0,0,100,0), -- 01:49:52 +(@GUID,12,-1285.108,8749.334,37.11982,0,0,0,100,0), -- 01:50:03 +(@GUID,13,-1264.996,8765.237,38.6629,0,0,0,100,0), -- 01:50:13 +(@GUID,14,-1250.768,8774.912,37.94144,0,0,0,100,0), -- 01:50:24 +(@GUID,15,-1232.983,8794.147,38.70338,0,0,0,100,0), -- 01:50:33 +(@GUID,16,-1225.867,8833.785,46.07362,0,0,0,100,0), -- 01:50:42 +(@GUID,17,-1229.429,8801.566,39.74549,0,0,0,100,0), -- 01:50:58 +(@GUID,18,-1242.266,8781.217,37.74895,0,0,0,100,0), -- 01:51:12 +(@GUID,19,-1262.608,8767,38.69908,0,0,0,100,0), -- 01:51:21 +(@GUID,20,-1279.417,8753.924,37.96495,0,0,0,100,0); -- 01:51:30 +-- 0x203AF4424011E78000004E000025EAB4 .go -1298.94 8737.665 33.7051 + +-- Pathing for Entry: 18334 'TDB FORMAT' +SET @GUID := 65669; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@GUID; +DELETE FROM `creature_addon` WHERE `guid`=@GUID; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@GUID,@GUID,0,0,4097,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@GUID; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@GUID,1,-1905.752,8849.963,31.1883,0,0,0,100,0), -- 01:56:12 +(@GUID,2,-1935.98,8876.736,35.7215,0,0,0,100,0), -- 01:56:20 +(@GUID,3,-1946.287,8883.662,36.65396,0,0,0,100,0), -- 01:56:34 +(@GUID,4,-1970.356,8900.385,38.18405,0,0,0,100,0), -- 01:56:42 +(@GUID,5,-1981.821,8911.693,39.54768,0,0,0,100,0), -- 01:56:52 +(@GUID,6,-1979.206,8908.531,38.84719,0,0,0,100,0), -- 01:57:00 +(@GUID,7,-1962.636,8894.715,37.43145,0,0,0,100,0), -- 01:57:05 +(@GUID,8,-1941.701,8881.033,36.4118,0,0,0,100,0), -- 01:57:15 +(@GUID,9,-1918.998,8860.391,31.82777,0,0,0,100,0), -- 01:57:23 +(@GUID,10,-1896.513,8843.802,30.8529,0,0,0,100,0), -- 01:57:37 +(@GUID,11,-1871.678,8838.736,29.45558,0,0,0,100,0), -- 01:57:47 +(@GUID,12,-1870.336,8838.371,29.11763,0,0,0,100,0), -- 01:57:56 +(@GUID,13,-1834.845,8838.773,28.20097,0,0,0,100,0), -- 01:58:05 +(@GUID,14,-1828.867,8836.951,27.58482,0,0,0,100,0), -- 01:58:13 +(@GUID,15,-1829.162,8836.926,27.28334,0,0,0,100,0), -- 01:58:19 +(@GUID,16,-1843.316,8840.856,28.78101,0,0,0,100,0), -- 01:58:23 +(@GUID,17,-1847.484,8841.689,29.32478,0,0,0,100,0), -- 01:58:30 +(@GUID,18,-1894.005,8842.438,30.46817,0,0,0,100,0); -- 01:58:40 +-- 0x203AF4424011E78000004E0000263D08 .go -1905.752 8849.963 31.1883 + +-- Pathing for Entry: 18334 'TDB FORMAT' +SET @GUID := 65646; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@GUID; +DELETE FROM `creature_addon` WHERE `guid`=@GUID; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@GUID,@GUID,0,0,4097,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@GUID; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@GUID,1,-1612.406,6570.503,6.982493,0,0,0,100,0), -- 02:08:05 +(@GUID,2,-1614.595,6565.356,7.208048,0,0,0,100,0), -- 02:08:13 +(@GUID,3,-1638.007,6571.519,6.701593,0,0,0,100,0), -- 02:08:20 +(@GUID,4,-1654.055,6609.707,0.1810076,0,0,0,100,0), -- 02:08:30 +(@GUID,5,-1649.122,6637.95,-8.652092,0,0,0,100,0), -- 02:08:43 +(@GUID,6,-1649.657,6652.884,-9.074863,0,0,0,100,0), -- 02:08:55 +(@GUID,7,-1666.357,6710.94,-2.727369,0,0,0,100,0), -- 02:09:07 +(@GUID,8,-1676.008,6737.302,-5.586429,0,0,0,100,0), -- 02:09:26 +(@GUID,9,-1681.334,6756.157,-9.995689,0,0,0,100,0), -- 02:09:36 +(@GUID,10,-1669.921,6808.041,-11.01227,0,0,0,100,0), -- 02:09:50 +(@GUID,11,-1649.946,6842.342,-11.98508,0,0,0,100,0), -- 02:10:08 +(@GUID,12,-1645.45,6849.631,-12.52353,0,0,0,100,0), -- 02:10:26 +(@GUID,13,-1631.198,6865.211,-11.80149,0,0,0,100,0), -- 02:10:40 +(@GUID,14,-1662.066,6822.472,-12.15099,0,0,0,100,0), -- 02:10:52 +(@GUID,15,-1682.708,6775.835,-9.737608,0,0,0,100,0), -- 02:11:10 +(@GUID,16,-1676.805,6739.438,-6.040812,0,0,0,100,0), -- 02:11:27 +(@GUID,17,-1670.686,6721.969,-3.275235,0,0,0,100,0), -- 02:11:42 +(@GUID,18,-1653.276,6676.503,-8.282584,0,0,0,100,0), -- 02:11:52 +(@GUID,19,-1649.429,6649.203,-9.570678,0,0,0,100,0), -- 02:12:11 +(@GUID,20,-1653.794,6611.523,-0.473855,0,0,0,100,0), -- 02:12:23 +(@GUID,21,-1652.239,6581.729,6.184913,0,0,0,100,0), -- 02:12:35 +(@GUID,22,-1636.589,6570.722,7.107543,0,0,0,100,0), -- 02:12:48 +(@GUID,23,-1632.383,6568.686,7.45083,0,0,0,100,0), -- 02:12:57 +(@GUID,24,-1607.946,6582.783,7.268674,0,0,0,100,0), -- 02:13:04 +(@GUID,25,-1611.074,6612.02,19.03936,0,0,0,100,0), -- 02:13:13 +(@GUID,26,-1607.55,6586.147,8.281254,0,0,0,100,0); -- 02:13:27 +-- 0x203AF4424011E78000004E0000264702 .go -1612.406 6570.503 6.982493 |