diff options
| -rw-r--r-- | sql/updates/world/2015_07_31_05_world.sql | 943 |
1 files changed, 943 insertions, 0 deletions
diff --git a/sql/updates/world/2015_07_31_05_world.sql b/sql/updates/world/2015_07_31_05_world.sql new file mode 100644 index 00000000000..67863bd27ad --- /dev/null +++ b/sql/updates/world/2015_07_31_05_world.sql @@ -0,0 +1,943 @@ +-- DB/Pathing: Deadwind Pass 4.x + 6.x + (maybe 3.x except the spiders) +UPDATE `creature` SET `spawndist`=2, `MovementType`=1 WHERE `id`=12380; +UPDATE `creature` SET `spawndist`=5, `MovementType`=1 WHERE `id` IN (7376, 7369, 7379, 7379, 7372, 7371, 7370, 12377, 12378, 12377, 12379); +UPDATE `creature` SET `spawndist`=3, `MovementType`=1 WHERE `id` IN (51983); +UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry`=7376; + +-- oger +SET @NPC := 290796; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-11152.41,`position_y`=-2402.39,`position_z`=107.8207 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-11152.41,-2402.39,107.8207,0,0,0,0,100,0), +(@PATH,2,-11150.91,-2403.89,107.5707,0,0,0,0,100,0), +(@PATH,3,-11147.66,-2407.14,107.3207,0,0,0,0,100,0), +(@PATH,4,-11147.38,-2407.568,107.0629,0,0,0,0,100,0), +(@PATH,5,-11144.38,-2410.318,106.8129,0,0,0,0,100,0), +(@PATH,6,-11144.13,-2411.568,106.8129,0,0,0,0,100,0), +(@PATH,7,-11143.38,-2412.568,106.5629,0,0,0,0,100,0), +(@PATH,8,-11142.13,-2414.818,106.5629,0,0,0,0,100,0), +(@PATH,9,-11141.86,-2414.921,106.5999,0,0,0,0,100,0), +(@PATH,10,-11140.11,-2418.671,106.5999,0,0,0,0,100,0), +(@PATH,11,-11140.11,-2421.171,106.8499,0,0,0,0,100,0), +(@PATH,12,-11140.11,-2424.421,107.3499,0,0,0,0,100,0), +(@PATH,13,-11139.86,-2426.671,107.5999,0,0,0,0,100,0), +(@PATH,14,-11139.66,-2424.525,107.2991,0,0,0,0,100,0), +(@PATH,15,-11139.66,-2427.025,107.5491,0,0,0,0,100,0), +(@PATH,16,-11139.66,-2428.525,107.5491,0,0,0,0,100,0), +(@PATH,17,-11139.41,-2431.775,107.5491,0,0,0,0,100,0), +(@PATH,18,-11139.41,-2436.275,106.7991,0,0,0,0,100,0), +(@PATH,19,-11138.91,-2441.775,106.2991,0,0,0,0,100,0), +(@PATH,20,-11138.73,-2441.95,106.0568,0,0,0,0,100,0), +(@PATH,21,-11138.73,-2442.7,106.0568,0,0,0,0,100,0), +(@PATH,22,-11139.48,-2444.95,106.0568,0,0,0,0,100,0), +(@PATH,23,-11140.23,-2446.7,106.0568,0,0,0,0,100,0), +(@PATH,24,-11141.48,-2451.2,105.8068,0,0,0,0,100,0), +(@PATH,25,-11142.48,-2453.95,105.8068,0,0,0,0,100,0), +(@PATH,26,-11142.79,-2454.27,105.646,0,0,0,0,100,0), +(@PATH,27,-11143.29,-2455.77,105.646,0,0,0,0,100,0), +(@PATH,28,-11144.04,-2456.27,105.646,0,0,0,0,100,0), +(@PATH,29,-11147.54,-2458.77,104.646,0,0,0,0,100,0), +(@PATH,30,-11151.04,-2461.52,104.646,0,0,0,0,100,0), +(@PATH,31,-11152.29,-2462.27,104.396,0,0,0,0,100,0), +(@PATH,32,-11151.28,-2461.577,104.4617,0,0,0,0,100,0), +(@PATH,33,-11152.53,-2462.577,104.4617,0,0,0,0,100,0), +(@PATH,34,-11154.28,-2463.827,104.2117,0,0,0,0,100,0), +(@PATH,35,-11156.03,-2465.827,103.9617,0,0,0,0,100,0), +(@PATH,36,-11157.53,-2467.827,104.4617,0,0,0,0,100,0), +(@PATH,37,-11159.78,-2470.827,104.7117,0,0,0,0,100,0), +(@PATH,38,-11163.28,-2475.327,104.7117,0,0,0,0,100,0), +(@PATH,39,-11163.26,-2475.348,104.7722,0,0,0,0,100,0), +(@PATH,40,-11160.01,-2470.848,104.5222,0,0,0,0,100,0), +(@PATH,41,-11157.51,-2467.848,104.2722,0,0,0,0,100,0), +(@PATH,42,-11156.01,-2465.848,104.0222,0,0,0,0,100,0), +(@PATH,43,-11167.01,-2480.041,104.7494,0,0,0,0,100,0), +(@PATH,44,-11167.62,-2480.83,104.7494,0,0,0,0,100,0), +(@PATH,45,-11163.62,-2475.692,104.6252,0,0,0,0,100,0), +(@PATH,46,-11159.91,-2470.935,104.4077,0,0,0,0,100,0), +(@PATH,47,-11157.51,-2467.856,104.0211,0,0,0,0,100,0), +(@PATH,48,-11155.97,-2465.885,103.641,0,0,0,0,100,0), +(@PATH,49,-11154.4,-2463.866,103.795,0,0,0,0,100,0), +(@PATH,50,-11154.4,-2463.866,103.795,0,0,0,0,100,0), +(@PATH,51,-11152.31,-2462.266,104.3967,0,0,0,0,100,0), +(@PATH,52,-11151.06,-2461.516,104.6467,0,0,0,0,100,0), +(@PATH,53,-11147.56,-2459.016,104.6467,0,0,0,0,100,0), +(@PATH,54,-11144.06,-2456.266,105.6467,0,0,0,0,100,0), +(@PATH,55,-11143.91,-2456.071,105.5428,0,0,0,0,100,0), +(@PATH,56,-11143.16,-2455.321,105.5428,0,0,0,0,100,0), +(@PATH,57,-11142.66,-2454.071,105.5428,0,0,0,0,100,0), +(@PATH,58,-11141.91,-2451.321,105.7928,0,0,0,0,100,0), +(@PATH,59,-11140.16,-2447.071,106.0428,0,0,0,0,100,0), +(@PATH,60,-11139.41,-2444.821,106.0428,0,0,0,0,100,0), +(@PATH,61,-11140.18,-2446.861,106.4788,0,0,0,0,100,0), +(@PATH,62,-11139.43,-2444.611,106.2288,0,0,0,0,100,0), +(@PATH,63,-11138.93,-2442.861,106.2288,0,0,0,0,100,0), +(@PATH,64,-11138.93,-2441.861,106.2288,0,0,0,0,100,0), +(@PATH,65,-11139.43,-2436.361,106.9788,0,0,0,0,100,0), +(@PATH,66,-11139.68,-2431.861,107.7288,0,0,0,0,100,0), +(@PATH,67,-11139.8,-2431.455,107.6868,0,0,0,0,100,0), +(@PATH,68,-11139.8,-2428.955,107.6868,0,0,0,0,100,0), +(@PATH,69,-11139.8,-2426.455,107.4368,0,0,0,0,100,0), +(@PATH,70,-11139.8,-2425.205,107.4368,0,0,0,0,100,0), +(@PATH,71,-11139.8,-2422.205,106.6868,0,0,0,0,100,0), +(@PATH,72,-11140.09,-2421.899,106.8443,0,0,0,0,100,0), +(@PATH,73,-11140.09,-2418.649,106.5943,0,0,0,0,100,0), +(@PATH,74,-11142.09,-2414.899,106.5943,0,0,0,0,100,0), +(@PATH,75,-11143.09,-2412.899,106.8443,0,0,0,0,100,0), +(@PATH,76,-11143.84,-2411.649,106.8443,0,0,0,0,100,0), +(@PATH,77,-11143.42,-2412.43,106.8697,0,0,0,0,100,0), +(@PATH,78,-11144.17,-2411.43,106.8697,0,0,0,0,100,0), +(@PATH,79,-11144.67,-2410.18,106.8697,0,0,0,0,100,0), +(@PATH,80,-11147.42,-2407.43,106.8697,0,0,0,0,100,0), +(@PATH,81,-11150.92,-2403.93,107.6197,0,0,0,0,100,0), +(@PATH,82,-11151.25,-2403.608,107.7203,0,0,0,0,100,0), +(@PATH,83,-11152.75,-2402.108,107.7203,0,0,0,0,100,0), +(@PATH,84,-11155.5,-2399.858,108.4703,0,0,0,0,100,0), +(@PATH,85,-11156.25,-2399.108,108.4703,0,0,0,0,100,0); + +-- oger +SET @NPC := 290933; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-11108.92,`position_y`=-2370.972,`position_z`=112.3171 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-11108.92,-2370.972,112.3171,0,0,0,0,100,0), +(@PATH,2,-11110.42,-2370.222,112.3171,0,0,0,0,100,0), +(@PATH,3,-11111.67,-2364.222,112.5671,0,0,0,0,100,0), +(@PATH,4,-11111.92,-2363.222,112.5671,0,0,0,0,100,0), +(@PATH,5,-11112.17,-2361.972,112.3171,0,0,0,0,100,0), +(@PATH,6,-11113.17,-2357.972,112.3171,0,0,0,0,100,0), +(@PATH,7,-11113.36,-2357.755,112.3302,0,0,0,0,100,0), +(@PATH,8,-11114.11,-2354.505,112.8302,0,0,0,0,100,0), +(@PATH,9,-11114.61,-2353.005,113.3302,0,0,0,0,100,0), +(@PATH,10,-11114.86,-2351.255,113.3302,0,0,0,0,100,0), +(@PATH,11,-11115.36,-2347.505,113.8302,0,0,0,0,100,0), +(@PATH,12,-11115.61,-2346.005,114.0802,0,0,0,0,100,0), +(@PATH,13,-11116.11,-2343.255,115.0802,0,0,0,0,100,0), +(@PATH,14,-11116.12,-2342.867,115.461,0,0,0,0,100,0), +(@PATH,15,-11116.87,-2339.867,116.461,0,0,0,0,100,0), +(@PATH,16,-11113.12,-2335.617,116.711,0,0,0,0,100,0), +(@PATH,17,-11110.62,-2332.367,118.211,0,0,0,0,100,0), +(@PATH,18,-11108.62,-2329.617,118.211,0,0,0,0,100,0), +(@PATH,19,-11108.56,-2329.775,118.126,0,0,0,0,100,0), +(@PATH,20,-11110.56,-2332.275,118.126,0,0,0,0,100,0), +(@PATH,21,-11112.81,-2335.025,117.126,0,0,0,0,100,0), +(@PATH,22,-11116.68,-2340.196,116.3412,0,0,0,0,100,0), +(@PATH,23,-11116.18,-2343.196,115.0912,0,0,0,0,100,0), +(@PATH,24,-11115.68,-2345.946,114.0912,0,0,0,0,100,0), +(@PATH,25,-11115.43,-2347.196,113.8412,0,0,0,0,100,0), +(@PATH,26,-11114.68,-2351.196,113.3412,0,0,0,0,100,0), +(@PATH,27,-11114.43,-2352.446,113.3412,0,0,0,0,100,0), +(@PATH,28,-11114.63,-2351.489,113.0744,0,0,0,0,100,0), +(@PATH,29,-11114.38,-2352.739,113.0744,0,0,0,0,100,0), +(@PATH,30,-11113.88,-2354.989,112.5744,0,0,0,0,100,0), +(@PATH,31,-11113.38,-2357.239,112.3244,0,0,0,0,100,0), +(@PATH,32,-11112.38,-2361.739,112.5744,0,0,0,0,100,0), +(@PATH,33,-11112.13,-2362.739,112.5744,0,0,0,0,100,0), +(@PATH,34,-11111.88,-2364.239,112.5744,0,0,0,0,100,0), +(@PATH,35,-11110.63,-2369.239,112.3244,0,0,0,0,100,0), +(@PATH,36,-11110.25,-2369.446,112.2569,0,0,0,0,100,0), +(@PATH,37,-11110,-2370.446,112.2569,0,0,0,0,100,0), +(@PATH,38,-11108.5,-2371.196,112.2569,0,0,0,0,100,0), +(@PATH,39,-11107,-2371.946,112.5069,0,0,0,0,100,0), +(@PATH,40,-11105.25,-2372.946,112.7569,0,0,0,0,100,0), +(@PATH,41,-11101.5,-2374.946,112.5069,0,0,0,0,100,0), +(@PATH,42,-11096.75,-2377.446,112.7569,0,0,0,0,100,0), +(@PATH,43,-11096.51,-2377.824,112.9202,0,0,0,0,100,0), +(@PATH,44,-11095.26,-2378.574,112.9202,0,0,0,0,100,0), +(@PATH,45,-11092.51,-2379.824,112.9202,0,0,0,0,100,0), +(@PATH,46,-11089.26,-2381.074,113.4202,0,0,0,0,100,0), +(@PATH,47,-11086.51,-2382.324,113.4202,0,0,0,0,100,0), +(@PATH,48,-11084.01,-2383.574,113.4202,0,0,0,0,100,0), +(@PATH,49,-11086.28,-2382.667,113.6271,0,0,0,0,100,0), +(@PATH,50,-11083.78,-2383.667,113.3771,0,0,0,0,100,0), +(@PATH,51,-11082.53,-2384.417,113.6271,0,0,0,0,100,0), +(@PATH,52,-11081.28,-2386.167,113.8771,0,0,0,0,100,0), +(@PATH,53,-11078.28,-2390.417,112.8771,0,0,0,0,100,0), +(@PATH,54,-11077.53,-2391.417,112.6271,0,0,0,0,100,0), +(@PATH,55,-11077.7,-2391.482,112.6648,0,0,0,0,100,0), +(@PATH,56,-11078.2,-2390.482,112.9148,0,0,0,0,100,0), +(@PATH,57,-11080.95,-2386.732,113.9148,0,0,0,0,100,0), +(@PATH,58,-11081.15,-2386.458,113.738,0,0,0,0,100,0), +(@PATH,59,-11082.65,-2383.958,113.488,0,0,0,0,100,0), +(@PATH,60,-11083.9,-2383.458,113.488,0,0,0,0,100,0), +(@PATH,61,-11086.4,-2382.708,113.488,0,0,0,0,100,0), +(@PATH,62,-11088.9,-2381.458,113.488,0,0,0,0,100,0), +(@PATH,63,-11092.4,-2379.708,112.988,0,0,0,0,100,0), +(@PATH,64,-11095.22,-2378.323,112.5722,0,0,0,0,100,0), +(@PATH,65,-11096.72,-2377.573,112.5722,0,0,0,0,100,0), +(@PATH,66,-11101.47,-2375.073,112.5722,0,0,0,0,100,0), +(@PATH,67,-11105.22,-2373.073,112.5722,0,0,0,0,100,0), +(@PATH,68,-11106.97,-2372.073,112.3222,0,0,0,0,100,0), +(@PATH,69,-11108.47,-2371.073,112.3222,0,0,0,0,100,0), +(@PATH,70,-11103.95,-2373.839,112.452,0,0,0,0,100,0), +(@PATH,71,-11103.95,-2373.839,112.452,0,0,0,0,100,0); + +-- ghost +SET @NPC := 290807; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-11357.55,`position_y`=-2186.109,`position_z`=22.97028 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-11357.55,-2186.109,22.97028,0,0,0,0,100,0), +(@PATH,2,-11384.52,-2183.385,23.1736,0,0,0,0,100,0), +(@PATH,3,-11396.77,-2194.385,23.1736,0,0,0,0,100,0), +(@PATH,4,-11397.52,-2195.135,23.1736,0,0,0,0,100,0), +(@PATH,5,-11404.52,-2201.635,23.4236,0,0,0,0,100,0), +(@PATH,6,-11404.8,-2201.527,23.68835,0,0,0,0,100,0), +(@PATH,7,-11406.3,-2203.027,23.68835,0,0,0,0,100,0), +(@PATH,8,-11406.55,-2198.527,23.68835,0,0,0,0,100,0), +(@PATH,9,-11406.55,-2193.277,23.43835,0,0,0,0,100,0), +(@PATH,10,-11406.55,-2188.027,27.93835,0,0,0,0,100,0), +(@PATH,11,-11406.55,-2178.527,34.93835,0,0,0,0,100,0), +(@PATH,12,-11406.67,-2178.375,34.83125,0,0,0,0,100,0), +(@PATH,13,-11406.67,-2177.125,34.83125,0,0,0,0,100,0), +(@PATH,14,-11406.82,-2177.324,34.66116,0,0,0,0,100,0), +(@PATH,15,-11406.65,-2177.404,34.73546,0,0,0,0,100,0), +(@PATH,16,-11406.65,-2178.654,34.73546,0,0,0,0,100,0), +(@PATH,17,-11406.65,-2187.904,27.73546,0,0,0,0,100,0), +(@PATH,18,-11406.65,-2193.404,23.48546,0,0,0,0,100,0), +(@PATH,19,-11406.65,-2198.404,23.73546,0,0,0,0,100,0), +(@PATH,20,-11406.39,-2203.11,23.42908,0,0,0,0,100,0), +(@PATH,21,-11404.64,-2201.61,23.42908,0,0,0,0,100,0), +(@PATH,22,-11397.64,-2195.11,23.17908,0,0,0,0,100,0), +(@PATH,23,-11396.89,-2194.36,23.17908,0,0,0,0,100,0), +(@PATH,24,-11384.43,-2183.397,23.23336,0,0,0,0,100,0), +(@PATH,25,-11358.43,-2185.897,22.98336,0,0,0,0,100,0); + +-- ghost +SET @NPC := 290810; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-11285.16,`position_y`=-2192.621,`position_z`=22.9577 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-11285.16,-2192.621,22.9577,0,0,0,0,100,0), +(@PATH,2,-11304.45,-2188.722,22.9573,0,0,0,0,100,0), +(@PATH,3,-11317.27,-2191.545,22.95722,0,0,0,0,100,0), +(@PATH,4,-11335.63,-2186.83,22.95722,0,0,0,0,100,0), +(@PATH,5,-11344.63,-2186.58,22.95722,0,0,0,0,100,0), +(@PATH,6,-11351.92,-2186.214,22.80923,0,0,0,0,100,0), +(@PATH,7,-11354.17,-2186.214,22.80923,0,0,0,0,100,0), +(@PATH,8,-11358.17,-2186.214,23.05923,0,0,0,0,100,0), +(@PATH,9,-11358.56,-2186.159,23.05923,0,0,0,0,100,0), +(@PATH,10,-11354.06,-2186.159,22.80923,0,0,0,0,100,0), +(@PATH,11,-11351.53,-2186.225,22.97278,0,0,0,0,100,0), +(@PATH,12,-11344.78,-2186.475,22.97278,0,0,0,0,100,0), +(@PATH,13,-11335.54,-2186.707,22.95722,0,0,0,0,100,0), +(@PATH,14,-11316.8,-2191.492,22.95722,0,0,0,0,100,0), +(@PATH,15,-11304.19,-2188.713,22.95788,0,0,0,0,100,0), +(@PATH,16,-11284.94,-2192.873,22.95729,0,0,0,0,100,0), +(@PATH,17,-11267.99,-2193.994,22.9556,0,0,0,0,100,0), +(@PATH,18,-11254.79,-2195.179,22.95457,0,0,0,0,100,0), +(@PATH,19,-11249.99,-2199.038,22.95328,0,0,0,0,100,0), +(@PATH,20,-11241.49,-2199.788,22.95328,0,0,0,0,100,0), +(@PATH,21,-11237.99,-2200.038,22.95328,0,0,0,0,100,0), +(@PATH,22,-11237.73,-2200.055,22.95811,0,0,0,0,100,0), +(@PATH,23,-11236.98,-2200.055,22.95811,0,0,0,0,100,0), +(@PATH,24,-11231.98,-2199.055,22.95811,0,0,0,0,100,0), +(@PATH,25,-11224.29,-2197.586,22.97294,0,0,0,0,100,0), +(@PATH,26,-11224.64,-2197.935,22.71374,0,0,0,0,100,0), +(@PATH,27,-11224.68,-2197.919,22.96178,0,0,0,0,100,0), +(@PATH,28,-11231.68,-2199.169,22.96178,0,0,0,0,100,0), +(@PATH,29,-11236.68,-2199.919,22.96178,0,0,0,0,100,0); + +-- ghost +SET @NPC := 290954; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-11228.15,`position_y`=-2223.346,`position_z`=22.96585 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-11228.15,-2223.346,22.96585,0,0,0,0,100,0), +(@PATH,2,-11232.65,-2222.096,22.96585,0,0,0,0,100,0), +(@PATH,3,-11234.9,-2221.596,22.96585,0,0,0,0,100,0), +(@PATH,4,-11234.9,-2221.528,22.96743,0,0,0,0,100,0), +(@PATH,5,-11232.65,-2222.278,22.96743,0,0,0,0,100,0), +(@PATH,6,-11227.87,-2223.239,22.96367,0,0,0,0,100,0), +(@PATH,7,-11218.3,-2237.203,22.96388,0,0,0,0,100,0), +(@PATH,8,-11218.55,-2239.203,22.96388,0,0,0,0,100,0), +(@PATH,9,-11218.75,-2243.816,22.96791,0,0,0,0,100,0), +(@PATH,10,-11218,-2239.316,22.96791,0,0,0,0,100,0), +(@PATH,11,-11217.5,-2237.066,22.96791,0,0,0,0,100,0), +(@PATH,12,-11216.12,-2231.53,22.96245,0,0,0,0,100,0), +(@PATH,13,-11206.62,-2232.03,22.96245,0,0,0,0,100,0), +(@PATH,14,-11203.37,-2232.28,22.96245,0,0,0,0,100,0), +(@PATH,15,-11200.12,-2232.28,22.96245,0,0,0,0,100,0), +(@PATH,16,-11199.64,-2232.362,22.96899,0,0,0,0,100,0), +(@PATH,17,-11196.64,-2232.612,22.96899,0,0,0,0,100,0), +(@PATH,18,-11192.89,-2232.612,22.96899,0,0,0,0,100,0), +(@PATH,19,-11187.64,-2232.612,22.96899,0,0,0,0,100,0), +(@PATH,20,-11177.79,-2232.909,22.96883,0,0,0,0,100,0), +(@PATH,21,-11175.11,-2240.497,22.96412,0,0,0,0,100,0), +(@PATH,22,-11175.11,-2242.997,22.96412,0,0,0,0,100,0), +(@PATH,23,-11175.06,-2247.079,22.96218,0,0,0,0,100,0), +(@PATH,24,-11174.81,-2243.079,22.96218,0,0,0,0,100,0), +(@PATH,25,-11174.81,-2240.829,22.96218,0,0,0,0,100,0), +(@PATH,26,-11174.56,-2237.079,22.96218,0,0,0,0,100,0), +(@PATH,27,-11174.29,-2236.847,22.9634,0,0,0,0,100,0), +(@PATH,28,-11174.04,-2234.847,22.9634,0,0,0,0,100,0), +(@PATH,29,-11163.79,-2229.597,22.9634,0,0,0,0,100,0), +(@PATH,30,-11163.52,-2229.304,22.96021,0,0,0,0,100,0), +(@PATH,31,-11160.77,-2228.054,22.96021,0,0,0,0,100,0), +(@PATH,32,-11158.77,-2228.054,22.96021,0,0,0,0,100,0), +(@PATH,33,-11158.78,-2227.63,22.95865,0,0,0,0,100,0), +(@PATH,34,-11155.78,-2227.38,22.95865,0,0,0,0,100,0), +(@PATH,35,-11157.78,-2226.88,22.95865,0,0,0,0,100,0), +(@PATH,36,-11158.78,-2226.88,22.95865,0,0,0,0,100,0), +(@PATH,37,-11162.47,-2225.595,22.96747,0,0,0,0,100,0), +(@PATH,38,-11166.72,-2220.845,22.96747,0,0,0,0,100,0), +(@PATH,39,-11167.97,-2219.345,22.96747,0,0,0,0,100,0), +(@PATH,40,-11171.44,-2215.594,22.97846,0,0,0,0,100,0), +(@PATH,41,-11170.69,-2199.094,22.97846,0,0,0,0,100,0), +(@PATH,42,-11170.2,-2185.32,22.97534,0,0,0,0,100,0), +(@PATH,43,-11162.19,-2178.09,22.96563,0,0,0,0,100,0), +(@PATH,44,-11155.69,-2178.84,22.96563,0,0,0,0,100,0), +(@PATH,45,-11153.44,-2179.09,22.96563,0,0,0,0,100,0), +(@PATH,46,-11153.36,-2178.751,22.96519,0,0,0,0,100,0), +(@PATH,47,-11150.61,-2179.001,22.96519,0,0,0,0,100,0), +(@PATH,48,-11153.36,-2178.251,22.96519,0,0,0,0,100,0), +(@PATH,49,-11155.61,-2177.501,22.96519,0,0,0,0,100,0), +(@PATH,50,-11163.61,-2175.251,22.96519,0,0,0,0,100,0), +(@PATH,51,-11163.79,-2174.966,22.96431,0,0,0,0,100,0), +(@PATH,52,-11167.29,-2173.716,22.96431,0,0,0,0,100,0), +(@PATH,53,-11167.79,-2168.716,22.96431,0,0,0,0,100,0), +(@PATH,54,-11168.29,-2163.466,22.96431,0,0,0,0,100,0), +(@PATH,55,-11168.54,-2161.466,22.96431,0,0,0,0,100,0), +(@PATH,56,-11168.54,-2160.216,22.96431,0,0,0,0,100,0), +(@PATH,57,-11168.87,-2160.217,22.96051,0,0,0,0,100,0), +(@PATH,58,-11169.12,-2156.717,22.96051,0,0,0,0,100,0), +(@PATH,59,-11170.12,-2160.217,22.96051,0,0,0,0,100,0), +(@PATH,60,-11170.37,-2161.717,22.96051,0,0,0,0,100,0), +(@PATH,61,-11170.62,-2163.717,22.96051,0,0,0,0,100,0), +(@PATH,62,-11171.62,-2167.467,22.96051,0,0,0,0,100,0), +(@PATH,63,-11172.56,-2170.771,22.96473,0,0,0,0,100,0), +(@PATH,64,-11189.09,-2169.78,22.96945,0,0,0,0,100,0), +(@PATH,65,-11192.09,-2170.03,22.96945,0,0,0,0,100,0), +(@PATH,66,-11199.84,-2170.53,22.96945,0,0,0,0,100,0), +(@PATH,67,-11211.05,-2170.868,22.96526,0,0,0,0,100,0), +(@PATH,68,-11211.3,-2168.118,22.96526,0,0,0,0,100,0), +(@PATH,69,-11212.05,-2159.618,22.96526,0,0,0,0,100,0), +(@PATH,70,-11212.3,-2157.618,22.96526,0,0,0,0,100,0), +(@PATH,71,-11212.55,-2156.368,22.96526,0,0,0,0,100,0), +(@PATH,72,-11212.58,-2157.621,22.9605,0,0,0,0,100,0), +(@PATH,73,-11212.83,-2156.371,22.9605,0,0,0,0,100,0), +(@PATH,74,-11213.08,-2154.371,22.9605,0,0,0,0,100,0), +(@PATH,75,-11213.33,-2156.371,22.9605,0,0,0,0,100,0), +(@PATH,76,-11213.83,-2157.871,22.9605,0,0,0,0,100,0), +(@PATH,77,-11214.33,-2159.871,22.9605,0,0,0,0,100,0), +(@PATH,78,-11216.33,-2170.621,22.9605,0,0,0,0,100,0), +(@PATH,79,-11216.67,-2170.949,22.95807,0,0,0,0,100,0), +(@PATH,80,-11217.17,-2172.949,22.95807,0,0,0,0,100,0), +(@PATH,81,-11220.92,-2172.949,22.95807,0,0,0,0,100,0), +(@PATH,82,-11228.42,-2172.699,22.95807,0,0,0,0,100,0), +(@PATH,83,-11230.67,-2172.699,22.95807,0,0,0,0,100,0), +(@PATH,84,-11230.58,-2172.783,22.96055,0,0,0,0,100,0), +(@PATH,85,-11228.33,-2173.033,22.96055,0,0,0,0,100,0), +(@PATH,86,-11221.08,-2173.033,22.96055,0,0,0,0,100,0), +(@PATH,87,-11216.89,-2173.025,22.95843,0,0,0,0,100,0), +(@PATH,88,-11216.64,-2170.775,22.95843,0,0,0,0,100,0), +(@PATH,89,-11214.14,-2160.025,22.95843,0,0,0,0,100,0), +(@PATH,90,-11213.64,-2158.025,22.95843,0,0,0,0,100,0), +(@PATH,91,-11213.39,-2156.525,22.95843,0,0,0,0,100,0), +(@PATH,92,-11213.14,-2156.411,22.96162,0,0,0,0,100,0), +(@PATH,93,-11212.64,-2154.411,22.96162,0,0,0,0,100,0), +(@PATH,94,-11212.39,-2156.411,22.96162,0,0,0,0,100,0), +(@PATH,95,-11212.39,-2157.661,22.96162,0,0,0,0,100,0), +(@PATH,96,-11212.39,-2159.661,22.96162,0,0,0,0,100,0), +(@PATH,97,-11211.39,-2168.161,22.96162,0,0,0,0,100,0), +(@PATH,98,-11210.84,-2170.762,22.9667,0,0,0,0,100,0), +(@PATH,99,-11200.09,-2170.262,22.9667,0,0,0,0,100,0), +(@PATH,100,-11192.09,-2169.762,22.9667,0,0,0,0,100,0), +(@PATH,101,-11191.76,-2169.993,22.97355,0,0,0,0,100,0), +(@PATH,102,-11189.01,-2169.743,22.97355,0,0,0,0,100,0), +(@PATH,103,-11172.66,-2170.633,22.9623,0,0,0,0,100,0), +(@PATH,104,-11171.91,-2167.633,22.9623,0,0,0,0,100,0), +(@PATH,105,-11170.91,-2163.633,22.9623,0,0,0,0,100,0), +(@PATH,106,-11170.41,-2161.633,22.9623,0,0,0,0,100,0), +(@PATH,107,-11169.91,-2160.133,22.9623,0,0,0,0,100,0), +(@PATH,108,-11168.84,-2156.562,22.96515,0,0,0,0,100,0), +(@PATH,109,-11168.59,-2160.312,22.96515,0,0,0,0,100,0), +(@PATH,110,-11168.59,-2161.312,22.96515,0,0,0,0,100,0), +(@PATH,111,-11168.59,-2163.312,22.96515,0,0,0,0,100,0), +(@PATH,112,-11167.84,-2168.812,22.96515,0,0,0,0,100,0), +(@PATH,113,-11167.12,-2174.091,22.95806,0,0,0,0,100,0), +(@PATH,114,-11163.62,-2175.091,22.95806,0,0,0,0,100,0), +(@PATH,115,-11155.62,-2177.341,22.95806,0,0,0,0,100,0), +(@PATH,116,-11153.37,-2178.091,22.95806,0,0,0,0,100,0), +(@PATH,117,-11153.4,-2178.109,22.96325,0,0,0,0,100,0), +(@PATH,118,-11150.4,-2179.109,22.96325,0,0,0,0,100,0), +(@PATH,119,-11153.4,-2178.859,22.96325,0,0,0,0,100,0), +(@PATH,120,-11155.65,-2178.609,22.96325,0,0,0,0,100,0), +(@PATH,121,-11162.27,-2178.183,22.97392,0,0,0,0,100,0), +(@PATH,122,-11170.13,-2185.393,22.97823,0,0,0,0,100,0), +(@PATH,123,-11170.63,-2198.143,22.97823,0,0,0,0,100,0), +(@PATH,124,-11171.44,-2215.942,22.97005,0,0,0,0,100,0), +(@PATH,125,-11168.19,-2219.192,22.97005,0,0,0,0,100,0), +(@PATH,126,-11166.94,-2220.692,22.97005,0,0,0,0,100,0), +(@PATH,127,-11162.27,-2225.437,22.96269,0,0,0,0,100,0), +(@PATH,128,-11158.77,-2226.687,22.96269,0,0,0,0,100,0), +(@PATH,129,-11157.77,-2226.937,22.96269,0,0,0,0,100,0), +(@PATH,130,-11158.8,-2226.779,22.9582,0,0,0,0,100,0), +(@PATH,131,-11157.55,-2227.279,22.9582,0,0,0,0,100,0), +(@PATH,132,-11155.8,-2227.529,22.9582,0,0,0,0,100,0), +(@PATH,133,-11157.8,-2227.529,22.9582,0,0,0,0,100,0), +(@PATH,134,-11161.11,-2228.208,22.96246,0,0,0,0,100,0), +(@PATH,135,-11163.86,-2229.708,22.96246,0,0,0,0,100,0), +(@PATH,136,-11174.18,-2235.077,22.96141,0,0,0,0,100,0), +(@PATH,137,-11174.18,-2237.077,22.96141,0,0,0,0,100,0), +(@PATH,138,-11174.43,-2240.827,22.96141,0,0,0,0,100,0), +(@PATH,139,-11174.68,-2243.077,22.96141,0,0,0,0,100,0), +(@PATH,140,-11175.1,-2247.032,22.95994,0,0,0,0,100,0), +(@PATH,141,-11175.1,-2243.032,22.95994,0,0,0,0,100,0), +(@PATH,142,-11175.1,-2241.032,22.95994,0,0,0,0,100,0), +(@PATH,143,-11175.23,-2243.104,22.96832,0,0,0,0,100,0), +(@PATH,144,-11175.23,-2240.854,22.96832,0,0,0,0,100,0), +(@PATH,145,-11175.23,-2240.104,22.96832,0,0,0,0,100,0), +(@PATH,146,-11177.8,-2232.824,22.9684,0,0,0,0,100,0), +(@PATH,147,-11187.55,-2232.824,22.9684,0,0,0,0,100,0), +(@PATH,148,-11193.05,-2232.574,22.9684,0,0,0,0,100,0), +(@PATH,149,-11193.28,-2232.262,22.9699,0,0,0,0,100,0), +(@PATH,150,-11197.03,-2232.262,22.9699,0,0,0,0,100,0), +(@PATH,151,-11200.03,-2232.012,22.9699,0,0,0,0,100,0), +(@PATH,152,-11203.28,-2232.012,22.9699,0,0,0,0,100,0), +(@PATH,153,-11206.28,-2232.012,22.9699,0,0,0,0,100,0), +(@PATH,154,-11216.21,-2231.306,22.96424,0,0,0,0,100,0), +(@PATH,155,-11217.46,-2237.306,22.96424,0,0,0,0,100,0), +(@PATH,156,-11217.96,-2239.306,22.96424,0,0,0,0,100,0); + +-- ghost +SET @NPC := 290937; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-11174.61,`position_y`=-2075.024,`position_z`=35.75519 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-11174.61,-2075.024,35.75519,0,0,0,0,100,0), +(@PATH,2,-11173.11,-2075.274,35.75519,0,0,0,0,100,0), +(@PATH,3,-11174.61,-2075.274,35.75519,0,0,0,0,100,0), +(@PATH,4,-11178.11,-2075.274,35.75519,0,0,0,0,100,0), +(@PATH,5,-11184.09,-2075.696,35.62197,0,0,0,0,100,0), +(@PATH,6,-11184.34,-2085.196,35.62197,0,0,0,0,100,0), +(@PATH,7,-11184.59,-2091.946,31.62197,0,0,0,0,100,0), +(@PATH,8,-11184.87,-2099.878,31.4889,0,0,0,0,100,0), +(@PATH,9,-11180.37,-2101.378,31.4889,0,0,0,0,100,0), +(@PATH,10,-11177.12,-2102.628,31.4889,0,0,0,0,100,0), +(@PATH,11,-11177.13,-2102.489,31.48894,0,0,0,0,100,0), +(@PATH,12,-11175.63,-2102.989,31.48894,0,0,0,0,100,0), +(@PATH,13,-11177.13,-2102.739,31.48894,0,0,0,0,100,0), +(@PATH,14,-11180.38,-2102.239,31.48894,0,0,0,0,100,0), +(@PATH,15,-11190.38,-2100.739,31.48894,0,0,0,0,100,0), +(@PATH,16,-11193.88,-2099.989,31.48894,0,0,0,0,100,0), +(@PATH,17,-11193.79,-2100.171,31.48894,0,0,0,0,100,0), +(@PATH,18,-11197.04,-2099.421,31.48894,0,0,0,0,100,0), +(@PATH,19,-11194.04,-2100.921,31.48894,0,0,0,0,100,0), +(@PATH,20,-11190.54,-2102.421,31.48894,0,0,0,0,100,0), +(@PATH,21,-11186.95,-2104.562,31.35601,0,0,0,0,100,0), +(@PATH,22,-11187.45,-2112.062,31.35601,0,0,0,0,100,0), +(@PATH,23,-11187.95,-2118.812,27.35601,0,0,0,0,100,0), +(@PATH,24,-11188.24,-2127.056,27.22315,0,0,0,0,100,0), +(@PATH,25,-11182.74,-2128.806,27.22315,0,0,0,0,100,0), +(@PATH,26,-11177.31,-2130.637,27.22308,0,0,0,0,100,0), +(@PATH,27,-11182.81,-2129.887,27.22308,0,0,0,0,100,0), +(@PATH,28,-11192.81,-2128.387,27.22308,0,0,0,0,100,0), +(@PATH,29,-11196.31,-2128.137,27.22308,0,0,0,0,100,0), +(@PATH,30,-11199.81,-2127.637,27.22308,0,0,0,0,100,0), +(@PATH,31,-11202.7,-2127.3,27.22308,0,0,0,0,100,0), +(@PATH,32,-11199.7,-2127.8,27.22308,0,0,0,0,100,0), +(@PATH,33,-11196.2,-2128.55,27.22308,0,0,0,0,100,0), +(@PATH,34,-11193.2,-2129.05,27.22308,0,0,0,0,100,0), +(@PATH,35,-11190.22,-2129.983,27.12041,0,0,0,0,100,0), +(@PATH,36,-11189.72,-2133.233,27.12041,0,0,0,0,100,0), +(@PATH,37,-11189.22,-2138.983,27.12041,0,0,0,0,100,0), +(@PATH,38,-11189.43,-2139.324,27.08572,0,0,0,0,100,0), +(@PATH,39,-11189.18,-2142.074,25.33572,0,0,0,0,100,0), +(@PATH,40,-11189.68,-2146.074,23.08572,0,0,0,0,100,0), +(@PATH,41,-11189.75,-2146.124,23.23304,0,0,0,0,100,0), +(@PATH,42,-11189.19,-2141.758,25.33702,0,0,0,0,100,0), +(@PATH,43,-11189.19,-2139.258,27.08702,0,0,0,0,100,0), +(@PATH,44,-11189.94,-2133.258,27.08702,0,0,0,0,100,0), +(@PATH,45,-11189.87,-2133.07,27.22306,0,0,0,0,100,0), +(@PATH,46,-11190.12,-2129.82,27.22306,0,0,0,0,100,0), +(@PATH,47,-11193.12,-2129.32,27.22306,0,0,0,0,100,0), +(@PATH,48,-11196.37,-2128.57,27.22306,0,0,0,0,100,0), +(@PATH,49,-11199.87,-2127.82,27.22306,0,0,0,0,100,0), +(@PATH,50,-11199.76,-2127.828,27.22308,0,0,0,0,100,0), +(@PATH,51,-11202.76,-2127.328,27.22308,0,0,0,0,100,0), +(@PATH,52,-11199.76,-2127.578,27.22308,0,0,0,0,100,0), +(@PATH,53,-11196.26,-2128.078,27.22308,0,0,0,0,100,0), +(@PATH,54,-11193.01,-2128.578,27.22308,0,0,0,0,100,0), +(@PATH,55,-11182.76,-2129.828,27.22308,0,0,0,0,100,0), +(@PATH,56,-11177.17,-2130.648,27.22308,0,0,0,0,100,0), +(@PATH,57,-11182.67,-2128.648,27.22308,0,0,0,0,100,0), +(@PATH,58,-11188.01,-2126.888,27.35601,0,0,0,0,100,0), +(@PATH,59,-11187.76,-2119.138,27.35601,0,0,0,0,100,0), +(@PATH,60,-11187.26,-2112.388,31.35601,0,0,0,0,100,0), +(@PATH,61,-11186.94,-2104.356,31.48896,0,0,0,0,100,0), +(@PATH,62,-11190.94,-2102.606,31.48896,0,0,0,0,100,0), +(@PATH,63,-11193.94,-2101.106,31.48896,0,0,0,0,100,0), +(@PATH,64,-11193.89,-2100.936,31.48894,0,0,0,0,100,0), +(@PATH,65,-11196.89,-2099.436,31.48894,0,0,0,0,100,0), +(@PATH,66,-11193.89,-2100.186,31.48894,0,0,0,0,100,0), +(@PATH,67,-11190.39,-2100.686,31.48894,0,0,0,0,100,0), +(@PATH,68,-11180.39,-2102.436,31.48894,0,0,0,0,100,0), +(@PATH,69,-11177.14,-2102.936,31.48894,0,0,0,0,100,0), +(@PATH,70,-11177.08,-2102.93,31.48894,0,0,0,0,100,0), +(@PATH,71,-11175.58,-2103.18,31.48894,0,0,0,0,100,0), +(@PATH,72,-11177.08,-2102.68,31.48894,0,0,0,0,100,0), +(@PATH,73,-11180.33,-2101.43,31.48894,0,0,0,0,100,0), +(@PATH,74,-11184.84,-2099.517,31.62214,0,0,0,0,100,0), +(@PATH,75,-11184.59,-2092.017,31.62214,0,0,0,0,100,0), +(@PATH,76,-11184.34,-2085.517,35.62214,0,0,0,0,100,0), +(@PATH,77,-11184.09,-2075.723,35.75491,0,0,0,0,100,0), +(@PATH,78,-11178.09,-2075.473,35.75491,0,0,0,0,100,0), +(@PATH,79,-11174.59,-2075.473,35.75491,0,0,0,0,100,0), +(@PATH,80,-11174.63,-2075.039,35.7549,0,0,0,0,100,0), +(@PATH,81,-11173.13,-2075.039,35.7549,0,0,0,0,100,0), +(@PATH,82,-11174.63,-2074.789,35.7549,0,0,0,0,100,0), +(@PATH,83,-11178.13,-2074.289,35.7549,0,0,0,0,100,0), +(@PATH,84,-11188.13,-2073.039,35.7549,0,0,0,0,100,0), +(@PATH,85,-11191.38,-2072.539,35.7549,0,0,0,0,100,0), +(@PATH,86,-11193.1,-2072.229,35.75517,0,0,0,0,100,0), +(@PATH,87,-11191.35,-2072.229,35.75517,0,0,0,0,100,0), +(@PATH,88,-11187.85,-2072.229,35.75517,0,0,0,0,100,0), +(@PATH,89,-11183.15,-2072.344,35.83151,0,0,0,0,100,0), +(@PATH,90,-11182.65,-2066.344,35.83151,0,0,0,0,100,0), +(@PATH,91,-11182.4,-2064.594,37.33151,0,0,0,0,100,0), +(@PATH,92,-11182.15,-2063.344,38.33151,0,0,0,0,100,0), +(@PATH,93,-11181.9,-2060.594,38.08151,0,0,0,0,100,0), +(@PATH,94,-11181.9,-2059.094,39.58151,0,0,0,0,100,0), +(@PATH,95,-11181.91,-2059.126,39.58166,0,0,0,0,100,0), +(@PATH,96,-11181.91,-2060.376,38.08166,0,0,0,0,100,0), +(@PATH,97,-11182.16,-2062.626,38.08166,0,0,0,0,100,0), +(@PATH,98,-11182.41,-2064.626,37.33166,0,0,0,0,100,0), +(@PATH,99,-11182.41,-2065.876,35.83166,0,0,0,0,100,0), +(@PATH,100,-11181.71,-2057.746,40.65778,0,0,0,0,100,0); + +-- ghost +SET @NPC := 291023; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-10950.97,`position_y`=-1869.587,`position_z`=-17.27495 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-10950.97,-1869.587,-17.27495,0,0,0,0,100,0), +(@PATH,2,-10954.72,-1869.087,-17.27495,0,0,0,0,100,0), +(@PATH,3,-10960.72,-1870.087,-17.27495,0,0,0,0,100,0), +(@PATH,4,-10966.47,-1870.837,-17.52495,0,0,0,0,100,0), +(@PATH,5,-10972.72,-1871.587,-17.27495,0,0,0,0,100,0), +(@PATH,6,-10976.97,-1872.087,-18.77495,0,0,0,0,100,0), +(@PATH,7,-10981.22,-1872.587,-19.27495,0,0,0,0,100,0), +(@PATH,8,-10984.47,-1873.087,-19.52495,0,0,0,0,100,0), +(@PATH,9,-10984.66,-1873.062,-19.91091,0,0,0,0,100,0), +(@PATH,10,-10985.91,-1873.312,-20.41091,0,0,0,0,100,0), +(@PATH,11,-10993.16,-1873.062,-22.16091,0,0,0,0,100,0), +(@PATH,12,-10997.91,-1873.062,-23.91091,0,0,0,0,100,0), +(@PATH,13,-11000.66,-1873.062,-25.16091,0,0,0,0,100,0), +(@PATH,14,-11003.16,-1872.812,-26.41091,0,0,0,0,100,0), +(@PATH,15,-11007.16,-1872.812,-27.66091,0,0,0,0,100,0), +(@PATH,16,-11007.91,-1872.812,-27.91091,0,0,0,0,100,0), +(@PATH,17,-11016.16,-1872.812,-29.91091,0,0,0,0,100,0), +(@PATH,18,-11023.16,-1872.562,-31.16091,0,0,0,0,100,0), +(@PATH,19,-11024.91,-1872.562,-30.66091,0,0,0,0,100,0), +(@PATH,20,-11026.66,-1872.562,-30.41091,0,0,0,0,100,0), +(@PATH,21,-11032.57,-1872.342,-31.24992,0,0,0,0,100,0), +(@PATH,22,-11032.82,-1875.342,-31.49992,0,0,0,0,100,0), +(@PATH,23,-11033.32,-1880.092,-31.99992,0,0,0,0,100,0), +(@PATH,24,-11033.57,-1882.592,-32.49992,0,0,0,0,100,0), +(@PATH,25,-11034.32,-1890.592,-33.74992,0,0,0,0,100,0), +(@PATH,26,-11035.07,-1899.342,-32.99992,0,0,0,0,100,0), +(@PATH,27,-11035.82,-1907.842,-32.74992,0,0,0,0,100,0), +(@PATH,28,-11035.79,-1908.177,-32.80447,0,0,0,0,100,0), +(@PATH,29,-11035.79,-1909.177,-32.55447,0,0,0,0,100,0), +(@PATH,30,-11035.79,-1910.427,-32.55447,0,0,0,0,100,0), +(@PATH,31,-11035.79,-1920.427,-29.30447,0,0,0,0,100,0), +(@PATH,32,-11035.79,-1922.677,-28.30447,0,0,0,0,100,0), +(@PATH,33,-11036.01,-1922.828,-28.19327,0,0,0,0,100,0), +(@PATH,34,-11036.01,-1920.328,-29.19327,0,0,0,0,100,0), +(@PATH,35,-11036.01,-1910.578,-32.44327,0,0,0,0,100,0), +(@PATH,36,-11035.81,-1910.327,-32.51183,0,0,0,0,100,0), +(@PATH,37,-11035.81,-1908.827,-32.76183,0,0,0,0,100,0), +(@PATH,38,-11035.06,-1899.827,-33.01183,0,0,0,0,100,0), +(@PATH,39,-11034.56,-1890.577,-33.76183,0,0,0,0,100,0), +(@PATH,40,-11034.06,-1883.327,-32.51183,0,0,0,0,100,0), +(@PATH,41,-11033.56,-1879.077,-32.01183,0,0,0,0,100,0), +(@PATH,42,-11033.31,-1875.827,-31.76183,0,0,0,0,100,0), +(@PATH,43,-11033.06,-1873.327,-31.51183,0,0,0,0,100,0), +(@PATH,44,-11033.18,-1875.613,-31.49718,0,0,0,0,100,0), +(@PATH,45,-11032.93,-1873.113,-31.24718,0,0,0,0,100,0), +(@PATH,46,-11032.68,-1872.363,-30.99718,0,0,0,0,100,0), +(@PATH,47,-11026.68,-1872.613,-30.49718,0,0,0,0,100,0), +(@PATH,48,-11024.93,-1872.613,-30.49718,0,0,0,0,100,0), +(@PATH,49,-11023.18,-1872.613,-30.99718,0,0,0,0,100,0), +(@PATH,50,-11016.18,-1872.863,-29.74718,0,0,0,0,100,0), +(@PATH,51,-11008.18,-1873.113,-27.99718,0,0,0,0,100,0), +(@PATH,52,-11007.18,-1873.113,-27.74718,0,0,0,0,100,0), +(@PATH,53,-11003.18,-1873.113,-26.49718,0,0,0,0,100,0), +(@PATH,54,-11000.68,-1873.113,-25.24718,0,0,0,0,100,0), +(@PATH,55,-10997.93,-1873.363,-23.99718,0,0,0,0,100,0), +(@PATH,56,-10993.18,-1873.363,-22.24718,0,0,0,0,100,0), +(@PATH,57,-10985.63,-1873.344,-20.0818,0,0,0,0,100,0), +(@PATH,58,-10984.38,-1873.094,-19.5818,0,0,0,0,100,0), +(@PATH,59,-10981.13,-1872.594,-19.3318,0,0,0,0,100,0), +(@PATH,60,-10976.88,-1872.094,-18.8318,0,0,0,0,100,0), +(@PATH,61,-10973.13,-1871.594,-17.3318,0,0,0,0,100,0), +(@PATH,62,-10966.63,-1870.844,-17.5818,0,0,0,0,100,0), +(@PATH,63,-10960.63,-1870.094,-17.3318,0,0,0,0,100,0), +(@PATH,64,-10954.38,-1869.067,-17.15249,0,0,0,0,100,0), +(@PATH,65,-10951.38,-1869.317,-16.90249,0,0,0,0,100,0), +(@PATH,66,-10939.63,-1870.567,-17.40249,0,0,0,0,100,0), +(@PATH,67,-10927.63,-1871.317,-17.15249,0,0,0,0,100,0), +(@PATH,68,-10919.88,-1872.067,-15.15249,0,0,0,0,100,0), +(@PATH,69,-10918.13,-1872.317,-14.90249,0,0,0,0,100,0), +(@PATH,70,-10913.72,-1872.561,-14.60089,0,0,0,0,100,0), +(@PATH,71,-10917.97,-1872.061,-15.10089,0,0,0,0,100,0), +(@PATH,72,-10919.72,-1871.811,-15.10089,0,0,0,0,100,0), +(@PATH,73,-10927.47,-1870.811,-17.10089,0,0,0,0,100,0), +(@PATH,74,-10939.47,-1869.561,-17.60089,0,0,0,0,100,0); + +-- ghost +SET @NPC := 291025; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-10952.34,`position_y`=-1871.409,`position_z`=-17.32776 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-10952.34,-1871.409,-17.32776,0,0,0,0,100,0), +(@PATH,2,-10951.59,-1875.159,-17.32776,0,0,0,0,100,0), +(@PATH,3,-10949.34,-1877.409,-17.32776,0,0,0,0,100,0), +(@PATH,4,-10946.09,-1880.909,-17.32776,0,0,0,0,100,0), +(@PATH,5,-10944.09,-1882.909,-17.32776,0,0,0,0,100,0), +(@PATH,6,-10941.84,-1885.409,-17.07776,0,0,0,0,100,0), +(@PATH,7,-10941.58,-1885.253,-17.09584,0,0,0,0,100,0), +(@PATH,8,-10941.33,-1885.503,-17.09584,0,0,0,0,100,0), +(@PATH,9,-10938.33,-1883.503,-17.34584,0,0,0,0,100,0), +(@PATH,10,-10932.9,-1879.858,-17.30407,0,0,0,0,100,0), +(@PATH,11,-10928.65,-1879.108,-17.30407,0,0,0,0,100,0), +(@PATH,12,-10925.15,-1878.358,-16.55407,0,0,0,0,100,0), +(@PATH,13,-10920.51,-1876.974,-15.35462,0,0,0,0,100,0), +(@PATH,14,-10914.01,-1874.974,-14.60462,0,0,0,0,100,0), +(@PATH,15,-10914.14,-1874.731,-14.55564,0,0,0,0,100,0), +(@PATH,16,-10913.39,-1874.481,-14.55564,0,0,0,0,100,0), +(@PATH,17,-10913.64,-1866.981,-14.80564,0,0,0,0,100,0), +(@PATH,18,-10913.64,-1862.731,-14.80564,0,0,0,0,100,0), +(@PATH,19,-10913.71,-1855.503,-15.19139,0,0,0,0,100,0), +(@PATH,20,-10915.46,-1854.253,-15.44139,0,0,0,0,100,0), +(@PATH,21,-10917.71,-1852.503,-15.19139,0,0,0,0,100,0), +(@PATH,22,-10923.12,-1847.401,-14.91119,0,0,0,0,100,0), +(@PATH,23,-10925.62,-1846.651,-14.66119,0,0,0,0,100,0), +(@PATH,24,-10928.37,-1846.151,-14.66119,0,0,0,0,100,0), +(@PATH,25,-10935.12,-1844.151,-15.66119,0,0,0,0,100,0), +(@PATH,26,-10938.37,-1843.151,-16.66119,0,0,0,0,100,0), +(@PATH,27,-10938.48,-1843.145,-16.79991,0,0,0,0,100,0), +(@PATH,28,-10939.48,-1842.895,-17.04991,0,0,0,0,100,0), +(@PATH,29,-10942.48,-1843.395,-17.54991,0,0,0,0,100,0), +(@PATH,30,-10947.48,-1843.895,-17.54991,0,0,0,0,100,0), +(@PATH,31,-10949.23,-1844.145,-17.54991,0,0,0,0,100,0), +(@PATH,32,-10949.46,-1844.125,-17.59497,0,0,0,0,100,0), +(@PATH,33,-10950.21,-1844.125,-17.59497,0,0,0,0,100,0), +(@PATH,34,-10955.46,-1846.375,-17.59497,0,0,0,0,100,0), +(@PATH,35,-10957.21,-1847.125,-17.59497,0,0,0,0,100,0), +(@PATH,36,-10961.03,-1848.799,-17.69845,0,0,0,0,100,0), +(@PATH,37,-10960.53,-1856.049,-17.44845,0,0,0,0,100,0), +(@PATH,38,-10960.46,-1862.326,-17.32179,0,0,0,0,100,0), +(@PATH,39,-10961.46,-1867.076,-17.32179,0,0,0,0,100,0), +(@PATH,40,-10962.95,-1876.35,-17.34244,0,0,0,0,100,0), +(@PATH,41,-10962.2,-1879.6,-17.34244,0,0,0,0,100,0), +(@PATH,42,-10961.2,-1883.1,-17.09244,0,0,0,0,100,0), +(@PATH,43,-10959.95,-1888.6,-17.09244,0,0,0,0,100,0), +(@PATH,44,-10959.7,-1890.6,-17.09244,0,0,0,0,100,0), +(@PATH,45,-10959.2,-1892.1,-17.09244,0,0,0,0,100,0); + +-- ghost +SET @NPC := 290851; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-11077.86,`position_y`=-1936.072,`position_z`=-7.469562 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-11077.86,-1936.072,-7.469562,0,0,0,0,100,0), +(@PATH,2,-11072.86,-1935.322,-6.719562,0,0,0,0,100,0), +(@PATH,3,-11068.36,-1934.822,-6.219562,0,0,0,0,100,0), +(@PATH,4,-11066.61,-1934.572,-5.969562,0,0,0,0,100,0), +(@PATH,5,-11062.61,-1934.072,-5.469562,0,0,0,0,100,0), +(@PATH,6,-11060.61,-1933.572,-5.469562,0,0,0,0,100,0), +(@PATH,7,-11058.36,-1933.322,-4.969562,0,0,0,0,100,0), +(@PATH,8,-11058.01,-1932.907,-5.15441,0,0,0,0,100,0), +(@PATH,9,-11057.51,-1932.907,-5.15441,0,0,0,0,100,0), +(@PATH,10,-11054.51,-1931.657,-5.15441,0,0,0,0,100,0), +(@PATH,11,-11050.76,-1930.157,-4.90441,0,0,0,0,100,0), +(@PATH,12,-11049.51,-1929.407,-4.65441,0,0,0,0,100,0), +(@PATH,13,-11047.01,-1928.657,-4.90441,0,0,0,0,100,0), +(@PATH,14,-11040.01,-1925.657,-4.65441,0,0,0,0,100,0), +(@PATH,15,-11039.77,-1925.44,-4.495247,0,0,0,0,100,0), +(@PATH,16,-11039.02,-1924.94,-4.495247,0,0,0,0,100,0), +(@PATH,17,-11038.77,-1922.94,-4.245247,0,0,0,0,100,0), +(@PATH,18,-11036.52,-1912.19,-3.495247,0,0,0,0,100,0), +(@PATH,19,-11036.42,-1911.888,-3.413323,0,0,0,0,100,0), +(@PATH,20,-11036.17,-1909.888,-3.413323,0,0,0,0,100,0), +(@PATH,21,-11037.92,-1908.138,-3.413323,0,0,0,0,100,0), +(@PATH,22,-11039.17,-1907.138,-3.413323,0,0,0,0,100,0), +(@PATH,23,-11043.67,-1903.138,-3.913323,0,0,0,0,100,0), +(@PATH,24,-11045.67,-1901.138,-3.913323,0,0,0,0,100,0), +(@PATH,25,-11049.67,-1897.388,-3.913323,0,0,0,0,100,0), +(@PATH,26,-11049.86,-1897.173,-3.505289,0,0,0,0,100,0), +(@PATH,27,-11050.36,-1896.673,-3.505289,0,0,0,0,100,0), +(@PATH,28,-11053.86,-1896.923,-3.255289,0,0,0,0,100,0), +(@PATH,29,-11056.11,-1896.923,-3.005289,0,0,0,0,100,0), +(@PATH,30,-11058.86,-1896.923,-2.755289,0,0,0,0,100,0), +(@PATH,31,-11062.61,-1896.923,-2.005289,0,0,0,0,100,0), +(@PATH,32,-11065.11,-1896.923,-2.005289,0,0,0,0,100,0), +(@PATH,33,-11065.33,-1896.748,-1.711246,0,0,0,0,100,0), +(@PATH,34,-11067.08,-1896.748,-1.461246,0,0,0,0,100,0), +(@PATH,35,-11071.58,-1895.248,-0.4612458,0,0,0,0,100,0), +(@PATH,36,-11073.33,-1894.748,-0.2112458,0,0,0,0,100,0), +(@PATH,37,-11076.83,-1893.748,0.2887542,0,0,0,0,100,0), +(@PATH,38,-11078.83,-1893.248,0.2887542,0,0,0,0,100,0), +(@PATH,39,-11083.83,-1891.748,1.788754,0,0,0,0,100,0), +(@PATH,40,-11084.09,-1891.719,1.883329,0,0,0,0,100,0), +(@PATH,41,-11084.34,-1891.469,1.883329,0,0,0,0,100,0), +(@PATH,42,-11088.34,-1892.219,2.633329,0,0,0,0,100,0), +(@PATH,43,-11090.09,-1892.719,2.633329,0,0,0,0,100,0), +(@PATH,44,-11093.34,-1893.219,2.383329,0,0,0,0,100,0), +(@PATH,45,-11098.9,-1894.371,2.000008,0,0,0,0,100,0), +(@PATH,46,-11098.65,-1895.371,2.250008,0,0,0,0,100,0), +(@PATH,47,-11097.15,-1902.621,2.250008,0,0,0,0,100,0), +(@PATH,48,-11097.38,-1902.444,2.317019,0,0,0,0,100,0), +(@PATH,49,-11098.63,-1895.444,2.067019,0,0,0,0,100,0), +(@PATH,50,-11098.49,-1895.124,2.011541,0,0,0,0,100,0), +(@PATH,51,-11098.74,-1894.374,1.761541,0,0,0,0,100,0), +(@PATH,52,-11093.24,-1893.374,2.511541,0,0,0,0,100,0), +(@PATH,53,-11090.24,-1892.624,2.761541,0,0,0,0,100,0), +(@PATH,54,-11088.49,-1892.374,2.761541,0,0,0,0,100,0), +(@PATH,55,-11088.19,-1892.423,2.620745,0,0,0,0,100,0), +(@PATH,56,-11084.19,-1891.673,1.870745,0,0,0,0,100,0), +(@PATH,57,-11078.69,-1893.173,0.3707453,0,0,0,0,100,0), +(@PATH,58,-11076.94,-1893.923,0.3707453,0,0,0,0,100,0), +(@PATH,59,-11073.44,-1894.673,-0.1292547,0,0,0,0,100,0), +(@PATH,60,-11071.44,-1895.423,-0.6292547,0,0,0,0,100,0), +(@PATH,61,-11066.83,-1896.716,-1.619533,0,0,0,0,100,0), +(@PATH,62,-11065.08,-1896.716,-1.869533,0,0,0,0,100,0), +(@PATH,63,-11062.58,-1896.716,-1.869533,0,0,0,0,100,0), +(@PATH,64,-11059.08,-1896.716,-2.619533,0,0,0,0,100,0), +(@PATH,65,-11056.08,-1896.716,-2.869533,0,0,0,0,100,0), +(@PATH,66,-11053.83,-1896.466,-3.369533,0,0,0,0,100,0), +(@PATH,67,-11050.2,-1896.755,-3.681933,0,0,0,0,100,0), +(@PATH,68,-11045.7,-1901.005,-3.931933,0,0,0,0,100,0), +(@PATH,69,-11043.7,-1903.255,-3.931933,0,0,0,0,100,0), +(@PATH,70,-11039.2,-1907.005,-3.431933,0,0,0,0,100,0), +(@PATH,71,-11037.95,-1908.005,-3.431933,0,0,0,0,100,0), +(@PATH,72,-11036.04,-1910.147,-3.436284,0,0,0,0,100,0), +(@PATH,73,-11036.54,-1912.147,-3.436284,0,0,0,0,100,0), +(@PATH,74,-11038.54,-1922.897,-4.186284,0,0,0,0,100,0), +(@PATH,75,-11038.82,-1923.08,-4.309036,0,0,0,0,100,0), +(@PATH,76,-11039.32,-1925.33,-4.559036,0,0,0,0,100,0), +(@PATH,77,-11047.07,-1928.33,-4.809036,0,0,0,0,100,0), +(@PATH,78,-11049.32,-1929.33,-4.809036,0,0,0,0,100,0), +(@PATH,79,-11050.82,-1930.08,-4.809036,0,0,0,0,100,0), +(@PATH,80,-11054.57,-1931.58,-5.059036,0,0,0,0,100,0), +(@PATH,81,-11054.89,-1931.903,-5.314019,0,0,0,0,100,0), +(@PATH,82,-11057.89,-1933.153,-5.064019,0,0,0,0,100,0), +(@PATH,83,-11060.64,-1933.653,-5.314019,0,0,0,0,100,0), +(@PATH,84,-11062.64,-1933.903,-5.564019,0,0,0,0,100,0), +(@PATH,85,-11066.39,-1934.403,-6.064019,0,0,0,0,100,0), +(@PATH,86,-11067.64,-1934.403,-6.064019,0,0,0,0,100,0), +(@PATH,87,-11072.89,-1935.403,-6.814019,0,0,0,0,100,0), +(@PATH,88,-11078.07,-1936.366,-7.724932,0,0,0,0,100,0), +(@PATH,89,-11082.07,-1937.616,-7.474932,0,0,0,0,100,0), +(@PATH,90,-11087.32,-1939.366,-6.474932,0,0,0,0,100,0), +(@PATH,91,-11089.07,-1939.866,-6.474932,0,0,0,0,100,0), +(@PATH,92,-11094.07,-1941.366,-8.724932,0,0,0,0,100,0), +(@PATH,93,-11096.82,-1942.116,-9.474932,0,0,0,0,100,0), +(@PATH,94,-11102.46,-1943.79,-10.66358,0,0,0,0,100,0), +(@PATH,95,-11106.46,-1942.29,-11.41358,0,0,0,0,100,0), +(@PATH,96,-11115.21,-1938.79,-11.91358,0,0,0,0,100,0), +(@PATH,97,-11119.66,-1936.917,-12.55414,0,0,0,0,100,0), +(@PATH,98,-11122.41,-1930.667,-12.55414,0,0,0,0,100,0), +(@PATH,99,-11124.16,-1925.667,-12.55414,0,0,0,0,100,0), +(@PATH,100,-11125.16,-1923.667,-12.30414,0,0,0,0,100,0), +(@PATH,101,-11128.12,-1916.731,-12.99357,0,0,0,0,100,0), +(@PATH,102,-11129.87,-1909.481,-12.99357,0,0,0,0,100,0), +(@PATH,103,-11131.87,-1899.731,-12.74357,0,0,0,0,100,0), +(@PATH,104,-11132.12,-1898.231,-12.49357,0,0,0,0,100,0), +(@PATH,105,-11134.37,-1888.231,-12.49357,0,0,0,0,100,0), +(@PATH,106,-11135.37,-1883.481,-12.99357,0,0,0,0,100,0), +(@PATH,107,-11135.22,-1883.291,-12.57786,0,0,0,0,100,0), +(@PATH,108,-11135.47,-1882.541,-12.82786,0,0,0,0,100,0), +(@PATH,109,-11135.47,-1881.541,-12.82786,0,0,0,0,100,0), +(@PATH,110,-11134.47,-1875.791,-13.07786,0,0,0,0,100,0), +(@PATH,111,-11134.22,-1872.541,-11.32786,0,0,0,0,100,0), +(@PATH,112,-11133.42,-1868.931,-11.7614,0,0,0,0,100,0), +(@PATH,113,-11131.67,-1866.681,-11.7614,0,0,0,0,100,0), +(@PATH,114,-11127.67,-1861.181,-11.5114,0,0,0,0,100,0), +(@PATH,115,-11121.42,-1851.931,-11.5114,0,0,0,0,100,0), +(@PATH,116,-11121.43,-1851.781,-11.59575,0,0,0,0,100,0), +(@PATH,117,-11127.68,-1860.781,-11.34575,0,0,0,0,100,0), +(@PATH,118,-11131.68,-1866.531,-11.84575,0,0,0,0,100,0), +(@PATH,119,-11133.8,-1869.259,-11.97753,0,0,0,0,100,0), +(@PATH,120,-11134.05,-1872.509,-11.22753,0,0,0,0,100,0), +(@PATH,121,-11134.55,-1875.759,-12.97753,0,0,0,0,100,0), +(@PATH,122,-11135.3,-1881.509,-12.97753,0,0,0,0,100,0), +(@PATH,123,-11135.32,-1881.682,-13.25977,0,0,0,0,100,0), +(@PATH,124,-11135.57,-1882.682,-13.00977,0,0,0,0,100,0), +(@PATH,125,-11134.32,-1888.182,-12.50977,0,0,0,0,100,0), +(@PATH,126,-11132.32,-1897.932,-12.50977,0,0,0,0,100,0), +(@PATH,127,-11132.07,-1898.682,-12.75977,0,0,0,0,100,0), +(@PATH,128,-11129.82,-1909.432,-13.25977,0,0,0,0,100,0), +(@PATH,129,-11128.19,-1916.791,-13.02441,0,0,0,0,100,0), +(@PATH,130,-11125.19,-1923.541,-12.27441,0,0,0,0,100,0), +(@PATH,131,-11124.44,-1925.541,-12.52441,0,0,0,0,100,0), +(@PATH,132,-11122.19,-1930.541,-12.77441,0,0,0,0,100,0), +(@PATH,133,-11119.94,-1936.041,-12.52441,0,0,0,0,100,0), +(@PATH,134,-11119.63,-1936.436,-12.25877,0,0,0,0,100,0), +(@PATH,135,-11119.38,-1937.186,-12.25877,0,0,0,0,100,0), +(@PATH,136,-11115.38,-1938.936,-12.00877,0,0,0,0,100,0), +(@PATH,137,-11106.38,-1942.186,-11.50877,0,0,0,0,100,0), +(@PATH,138,-11102.24,-1943.946,-10.21096,0,0,0,0,100,0), +(@PATH,139,-11096.99,-1942.196,-9.460957,0,0,0,0,100,0), +(@PATH,140,-11094.99,-1941.446,-8.960957,0,0,0,0,100,0), +(@PATH,141,-11089.24,-1939.946,-6.460957,0,0,0,0,100,0), +(@PATH,142,-11087.49,-1939.446,-6.710957,0,0,0,0,100,0), +(@PATH,143,-11081.99,-1937.696,-7.460957,0,0,0,0,100,0); + +-- ghost +SET @NPC := 290821; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-11145.94,`position_y`=-1970.426,`position_z`=23.0355 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-11145.94,-1970.426,23.0355,0,0,0,0,100,0), +(@PATH,2,-11149.69,-1966.426,23.0355,0,0,0,0,100,0), +(@PATH,3,-11151.83,-1964.306,22.86111,0,0,0,0,100,0), +(@PATH,4,-11160.58,-1963.306,22.86111,0,0,0,0,100,0), +(@PATH,5,-11165.34,-1962.648,23.05659,0,0,0,0,100,0), +(@PATH,6,-11172.2,-1972.198,23.04974,0,0,0,0,100,0), +(@PATH,7,-11174.2,-1973.948,23.04974,0,0,0,0,100,0), +(@PATH,8,-11179.7,-1979.448,23.04974,0,0,0,0,100,0), +(@PATH,9,-11183.22,-1983.091,23.00804,0,0,0,0,100,0), +(@PATH,10,-11183.22,-1986.091,23.00804,0,0,0,0,100,0), +(@PATH,11,-11182.97,-1991.591,23.00804,0,0,0,0,100,0), +(@PATH,12,-11182.77,-1995.239,23.02066,0,0,0,0,100,0), +(@PATH,13,-11181.02,-1999.239,23.02066,0,0,0,0,100,0), +(@PATH,14,-11180.98,-1999.119,23.02632,0,0,0,0,100,0), +(@PATH,15,-11182.86,-1994.804,23.03189,0,0,0,0,100,0), +(@PATH,16,-11182.86,-1991.554,22.78189,0,0,0,0,100,0), +(@PATH,17,-11183.11,-1986.054,23.03189,0,0,0,0,100,0), +(@PATH,18,-11183.36,-1982.844,23.04076,0,0,0,0,100,0), +(@PATH,19,-11179.61,-1979.344,23.04076,0,0,0,0,100,0), +(@PATH,20,-11174.11,-1974.094,23.04076,0,0,0,0,100,0), +(@PATH,21,-11173.71,-1973.838,23.04392,0,0,0,0,100,0), +(@PATH,22,-11171.96,-1972.088,23.04392,0,0,0,0,100,0), +(@PATH,23,-11165.11,-1962.681,23.05661,0,0,0,0,100,0), +(@PATH,24,-11160.86,-1963.181,23.05661,0,0,0,0,100,0), +(@PATH,25,-11151.89,-1964.265,22.85381,0,0,0,0,100,0), +(@PATH,26,-11149.89,-1966.515,23.10381,0,0,0,0,100,0), +(@PATH,27,-11145.76,-1970.669,23.04451,0,0,0,0,100,0), +(@PATH,28,-11144.01,-1973.669,23.04451,0,0,0,0,100,0), +(@PATH,29,-11143.26,-1975.169,22.79451,0,0,0,0,100,0), +(@PATH,30,-11139.01,-1983.669,19.04451,0,0,0,0,100,0), +(@PATH,31,-11138.26,-1985.669,18.54451,0,0,0,0,100,0), +(@PATH,32,-11133.51,-1994.419,16.54451,0,0,0,0,100,0), +(@PATH,33,-11132.51,-1996.419,15.79451,0,0,0,0,100,0), +(@PATH,34,-11130.26,-2000.669,15.29451,0,0,0,0,100,0), +(@PATH,35,-11128.37,-2004.379,14.93686,0,0,0,0,100,0), +(@PATH,36,-11118.62,-2006.879,14.18686,0,0,0,0,100,0), +(@PATH,37,-11116.39,-2007.397,13.74907,0,0,0,0,100,0), +(@PATH,38,-11110.39,-2004.397,13.74907,0,0,0,0,100,0), +(@PATH,39,-11103.14,-2000.897,13.24907,0,0,0,0,100,0), +(@PATH,40,-11102.97,-2000.822,12.90639,0,0,0,0,100,0), +(@PATH,41,-11102.47,-2000.322,12.90639,0,0,0,0,100,0), +(@PATH,42,-11102.47,-1998.322,12.90639,0,0,0,0,100,0), +(@PATH,43,-11102.22,-1989.072,11.90639,0,0,0,0,100,0), +(@PATH,44,-11101.98,-1984.905,10.30396,0,0,0,0,100,0), +(@PATH,45,-11101.23,-1981.405,8.803959,0,0,0,0,100,0), +(@PATH,46,-11100.98,-1979.405,8.303959,0,0,0,0,100,0), +(@PATH,47,-11100.1,-1974.993,5.961955,0,0,0,0,100,0), +(@PATH,48,-11099.85,-1969.743,3.711955,0,0,0,0,100,0), +(@PATH,49,-11099.6,-1968.743,3.211955,0,0,0,0,100,0), +(@PATH,50,-11098.85,-1960.743,1.961955,0,0,0,0,100,0), +(@PATH,51,-11098.58,-1960.354,2.006262,0,0,0,0,100,0), +(@PATH,52,-11098.58,-1958.354,1.756262,0,0,0,0,100,0), +(@PATH,53,-11098.08,-1956.354,1.256262,0,0,0,0,100,0), +(@PATH,54,-11098.08,-1955.354,1.256262,0,0,0,0,100,0), +(@PATH,55,-11097.33,-1949.104,3.006262,0,0,0,0,100,0), +(@PATH,56,-11096.6,-1943.717,4.285551,0,0,0,0,100,0), +(@PATH,57,-11096.35,-1940.967,4.785551,0,0,0,0,100,0), +(@PATH,58,-11096.35,-1936.467,5.285551,0,0,0,0,100,0), +(@PATH,59,-11096.16,-1931.123,4.878596,0,0,0,0,100,0), +(@PATH,60,-11097.66,-1928.873,4.628596,0,0,0,0,100,0), +(@PATH,61,-11098.66,-1927.373,4.378596,0,0,0,0,100,0), +(@PATH,62,-11100.16,-1925.123,4.378596,0,0,0,0,100,0), +(@PATH,63,-11100.66,-1923.873,3.878596,0,0,0,0,100,0), +(@PATH,64,-11100.64,-1923.879,4.039156,0,0,0,0,100,0), +(@PATH,65,-11100.14,-1925.129,4.289156,0,0,0,0,100,0), +(@PATH,66,-11098.64,-1927.379,4.289156,0,0,0,0,100,0), +(@PATH,67,-11097.64,-1928.879,4.789156,0,0,0,0,100,0), +(@PATH,68,-11096.31,-1931.252,5.055262,0,0,0,0,100,0), +(@PATH,69,-11096.31,-1936.252,5.305262,0,0,0,0,100,0), +(@PATH,70,-11096.31,-1940.752,4.805262,0,0,0,0,100,0), +(@PATH,71,-11096.6,-1943.875,4.08406,0,0,0,0,100,0), +(@PATH,72,-11097.35,-1948.875,3.08406,0,0,0,0,100,0), +(@PATH,73,-11098.1,-1955.375,1.33406,0,0,0,0,100,0), +(@PATH,74,-11098.22,-1955.567,1.163555,0,0,0,0,100,0), +(@PATH,75,-11098.72,-1958.567,1.663555,0,0,0,0,100,0), +(@PATH,76,-11098.97,-1960.817,1.913555,0,0,0,0,100,0), +(@PATH,77,-11099.47,-1968.567,3.163555,0,0,0,0,100,0), +(@PATH,78,-11099.47,-1969.817,3.413555,0,0,0,0,100,0), +(@PATH,79,-11100.27,-1975.218,6.266759,0,0,0,0,100,0), +(@PATH,80,-11101.02,-1978.968,8.016759,0,0,0,0,100,0), +(@PATH,81,-11101.27,-1980.968,8.766759,0,0,0,0,100,0), +(@PATH,82,-11102.17,-1985.027,10.644,0,0,0,0,100,0), +(@PATH,83,-11102.17,-1988.527,11.644,0,0,0,0,100,0), +(@PATH,84,-11102.17,-1998.527,12.894,0,0,0,0,100,0), +(@PATH,85,-11102.42,-1998.578,12.99935,0,0,0,0,100,0), +(@PATH,86,-11102.42,-2000.578,12.99935,0,0,0,0,100,0), +(@PATH,87,-11110.17,-2004.328,13.74935,0,0,0,0,100,0), +(@PATH,88,-11116.34,-2007.627,13.87936,0,0,0,0,100,0), +(@PATH,89,-11118.59,-2006.877,14.12936,0,0,0,0,100,0), +(@PATH,90,-11128.66,-2004.037,15.17478,0,0,0,0,100,0), +(@PATH,91,-11130.41,-2000.787,15.42478,0,0,0,0,100,0), +(@PATH,92,-11132.66,-1996.287,15.67478,0,0,0,0,100,0), +(@PATH,93,-11133.66,-1994.537,16.42478,0,0,0,0,100,0), +(@PATH,94,-11137.91,-1985.787,18.42478,0,0,0,0,100,0), +(@PATH,95,-11138.41,-1984.537,18.67478,0,0,0,0,100,0), +(@PATH,96,-11143.41,-1975.287,22.67478,0,0,0,0,100,0), +(@PATH,97,-11143.91,-1974.287,22.92478,0,0,0,0,100,0), +(@PATH,98,-11144.17,-1973.957,23.02656,0,0,0,0,100,0), +(@PATH,99,-11145.92,-1970.207,23.02656,0,0,0,0,100,0), +(@PATH,100,-11149.67,-1966.457,23.02656,0,0,0,0,100,0), +(@PATH,101,-11152.03,-1964.363,22.86212,0,0,0,0,100,0), +(@PATH,102,-11160.78,-1963.113,22.86212,0,0,0,0,100,0), +(@PATH,103,-11165.25,-1962.66,23.05611,0,0,0,0,100,0), +(@PATH,104,-11172.41,-1972.385,23.04976,0,0,0,0,100,0), +(@PATH,105,-11174.16,-1973.885,23.04976,0,0,0,0,100,0), +(@PATH,106,-11179.66,-1979.385,23.04976,0,0,0,0,100,0), +(@PATH,107,-11183.17,-1983.037,23.00779,0,0,0,0,100,0), +(@PATH,108,-11183.17,-1986.037,23.00779,0,0,0,0,100,0), +(@PATH,109,-11182.92,-1991.537,23.00779,0,0,0,0,100,0), +(@PATH,110,-11182.77,-1995.188,23.0204,0,0,0,0,100,0), +(@PATH,111,-11181.02,-1999.188,23.0204,0,0,0,0,100,0), +(@PATH,112,-11180.98,-1999.119,23.02632,0,0,0,0,100,0), +(@PATH,113,-11182.87,-1994.794,23.03176,0,0,0,0,100,0), +(@PATH,114,-11182.87,-1991.544,22.78176,0,0,0,0,100,0), +(@PATH,115,-11183.12,-1986.044,23.03176,0,0,0,0,100,0), +(@PATH,116,-11183.36,-1982.805,23.04112,0,0,0,0,100,0), +(@PATH,117,-11179.61,-1979.305,23.04112,0,0,0,0,100,0), +(@PATH,118,-11174.11,-1974.055,23.04112,0,0,0,0,100,0), +(@PATH,119,-11173.94,-1973.821,23.04391,0,0,0,0,100,0), +(@PATH,120,-11171.94,-1972.071,23.04391,0,0,0,0,100,0); |