DB/Waypoints: Pathing for Empoor and Formation for his bodyguard

1 files changed, 169 insertions, 0 deletions

diff --git a/sql/updates/world/2014_07_24_16_world_waypoints.sql b/sql/updates/world/2014_07_24_16_world_waypoints.sql
new file mode 100644
index 00000000000..8aaf55b2136
--- /dev/null
+++ b/sql/updates/world/2014_07_24_16_world_waypoints.sql
@@ -0,0 +1,169 @@
+-- Pathing for Empoor Entry: 18482 and Formation for his bodyguard
+SET @NPC := 66605;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1954.978,`position_y`=4752.3,`position_z`=-2.763442 WHERE `guid`=@NPC;
+UPDATE `creature` SET `position_x`=-1956.585, `position_y`=4751.758, `position_z`=-2.86066, `orientation`=2.005122 WHERE `guid`=66606;
+DELETE FROM `creature_formations` WHERE `leaderGUID`=66605;
+INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`)VALUES
+(66605,66605,0,0,2),(66605,66606,2,270,2);
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,-1954.978,4752.3,-2.763442,0,0,0,0,100,0),
+(@PATH,2,-1957.74,4762.069,-2.1277,0,0,0,0,100,0),
+(@PATH,3,-1958.931,4774.595,-1.305666,0,0,0,0,100,0),
+(@PATH,4,-1959.278,4786.453,-0.680666,0,0,0,0,100,0),
+(@PATH,5,-1957.059,4799.901,-0.05566597,0,0,0,0,100,0),
+(@PATH,6,-1952.969,4812.153,0.4542291,0,0,0,0,100,0),
+(@PATH,7,-1947.459,4824.405,0.695318,0,0,0,0,100,0),
+(@PATH,8,-1940.22,4836.162,1.116857,0,0,0,0,100,0),
+(@PATH,9,-1931.706,4848.864,1.735298,0,0,0,0,100,0),
+(@PATH,10,-1926.987,4857.382,1.735298,0,0,0,0,100,0),
+(@PATH,11,-1922.212,4869.189,1.888846,0,0,0,0,100,0),
+(@PATH,12,-1918.467,4883.836,2.155447,0,0,0,0,100,0),
+(@PATH,13,-1918.326,4893.268,2.520438,0,0,0,0,100,0),
+(@PATH,14,-1921.362,4904.434,4.286795,0,0,0,0,100,0),
+(@PATH,15,-1926.933,4916.866,7.852347,0,0,0,0,100,0),
+(@PATH,16,-1932.68,4930.549,12.62505,0,0,0,0,100,0),
+(@PATH,17,-1936.969,4938.175,15.91945,0,0,0,0,100,0),
+(@PATH,18,-1943.332,4944.548,19.00856,0,0,0,0,100,0),
+(@PATH,19,-1949.685,4955.148,22.99416,0,0,0,0,100,0),
+(@PATH,20,-1957.245,4971.249,26.83323,0,0,0,0,100,0),
+(@PATH,21,-1959.033,4989.208,29.75962,0,0,0,0,100,0),
+(@PATH,22,-1959.903,5001.704,31.27128,0,0,0,0,100,0),
+(@PATH,23,-1958.824,5016.848,32.75065,0,0,0,0,100,0),
+(@PATH,24,-1955.496,5027.162,32.08219,0,0,0,0,100,0),
+(@PATH,25,-1949.074,5037.299,27.67075,0,0,0,0,100,0),
+(@PATH,26,-1940.842,5049.157,22.12509,0,0,0,0,100,0),
+(@PATH,27,-1933.553,5052.723,20.48105,0,0,0,0,100,0),
+(@PATH,28,-1932.813,5055.973,19.7382,0,0,0,0,100,0),
+(@PATH,29,-1935.718,5059.009,19.13364,0,0,0,0,100,0),
+(@PATH,30,-1938.679,5057.717,19.45517,0,0,0,0,100,0),
+(@PATH,31,-1940.78,5053.983,20.79599,0,0,0,0,100,0),
+(@PATH,32,-1940.788,5050.398,21.78232,0,0,0,0,100,0),
+(@PATH,33,-1943.925,5045.257,23.89938,0,0,0,0,100,0),
+(@PATH,34,-1948.459,5038.444,27.02377,0,0,0,0,100,0),
+(@PATH,35,-1952.349,5033.815,29.49814,0,0,0,0,100,0),
+(@PATH,36,-1955.94,5026.934,32.19035,0,0,0,0,100,0),
+(@PATH,37,-1958.847,5018.866,32.87931,0,0,0,0,100,0),
+(@PATH,38,-1960.388,5008.151,32.10392,0,0,0,0,100,0),
+(@PATH,39,-1959.649,4995.389,30.60495,0,0,0,0,100,0),
+(@PATH,40,-1958.526,4982.475,28.72519,0,0,0,0,100,0),
+(@PATH,41,-1956.045,4969.47,26.49472,0,0,0,0,100,0),
+(@PATH,42,-1951.652,4957.231,23.63356,0,0,0,0,100,0),
+(@PATH,43,-1946.108,4948.339,20.83034,0,0,0,0,100,0),
+(@PATH,44,-1939.516,4941.397,17.3329,0,0,0,0,100,0),
+(@PATH,45,-1932.445,4928.974,12.04595,0,0,0,0,100,0),
+(@PATH,46,-1927.229,4916.588,7.915579,0,0,0,0,100,0),
+(@PATH,47,-1922.276,4905.163,4.571219,0,0,0,0,100,0),
+(@PATH,48,-1915.32,4900.36,2.12908,0,0,0,0,100,0),
+(@PATH,49,-1909.361,4900.604,1.032401,0,0,0,0,100,0),
+(@PATH,50,-1901.186,4904.915,-0.7529998,0,0,0,0,100,0),
+(@PATH,51,-1893.884,4911.838,-3.170728,0,0,0,0,100,0),
+(@PATH,52,-1886.202,4920.901,-6.797315,0,0,0,0,100,0),
+(@PATH,53,-1878.948,4930.252,-11.26155,0,0,0,0,100,0),
+(@PATH,54,-1873.738,4937.32,-14.07134,0,0,0,0,100,0),
+(@PATH,55,-1869.677,4942.98,-16.16705,0,0,0,0,100,0),
+(@PATH,56,-1866.752,4948.752,-17.90313,0,0,0,0,100,0),
+(@PATH,57,-1864.945,4956.149,-19.62491,0,0,0,0,100,0),
+(@PATH,58,-1864.546,4965.338,-21.15067,0,0,0,0,100,0),
+(@PATH,59,-1865.516,4969.611,-21.61164,0,0,0,0,100,0),
+(@PATH,60,-1867.728,4970.081,-21.52201,0,0,0,0,100,0),
+(@PATH,61,-1869.4,4967.932,-21.26408,0,0,0,0,100,0),
+(@PATH,62,-1868.561,4963.51,-20.60308,0,0,0,0,100,0),
+(@PATH,63,-1866.918,4958.647,-20.03289,0,0,0,0,100,0),
+(@PATH,64,-1867.127,4953.813,-18.94048,0,0,0,0,100,0),
+(@PATH,65,-1868.12,4949.346,-17.88165,0,0,0,0,100,0),
+(@PATH,66,-1870.746,4943.62,-16.19219,0,0,0,0,100,0),
+(@PATH,67,-1874.541,4937.907,-14.24078,0,0,0,0,100,0),
+(@PATH,68,-1879.867,4930.647,-11.21943,0,0,0,0,100,0),
+(@PATH,69,-1886.922,4921.398,-6.743848,0,0,0,0,100,0),
+(@PATH,70,-1894.731,4912.087,-2.997022,0,0,0,0,100,0),
+(@PATH,71,-1901.48,4905.404,-0.8352752,0,0,0,0,100,0),
+(@PATH,72,-1908.661,4897.943,1.188406,0,0,0,0,100,0),
+(@PATH,73,-1915.186,4888.852,2.12908,0,0,0,0,100,0),
+(@PATH,74,-1919.656,4879.008,2.12908,0,0,0,0,100,0),
+(@PATH,75,-1922.473,4867.417,2.00408,0,0,0,0,100,0),
+(@PATH,76,-1927.96,4855.975,1.735298,0,0,0,0,100,0),
+(@PATH,77,-1934.882,4844.2,1.505529,0,0,0,0,100,0),
+(@PATH,78,-1943.717,4831.167,0.7706354,0,0,0,0,100,0),
+(@PATH,79,-1950.078,4818.386,0.5792291,0,0,0,0,100,0),
+(@PATH,80,-1957.056,4801.952,0.1136529,0,0,0,0,100,0),
+(@PATH,81,-1958.388,4790.062,-0.430666,0,0,0,0,100,0),
+(@PATH,82,-1958.355,4777.865,-1.180666,0,0,0,0,100,0),
+(@PATH,83,-1956.92,4764.738,-1.932387,0,0,0,0,100,0),
+(@PATH,84,-1956.379,4755.673,-2.520034,0,0,0,0,100,0),
+(@PATH,85,-1952.63,4747.662,-2.888442,0,0,0,0,100,0),
+(@PATH,86,-1947.632,4738.14,-3.12416,0,0,0,0,100,0),
+(@PATH,87,-1943.565,4726.114,-3.106597,0,0,0,0,100,0),
+(@PATH,88,-1940.986,4712.541,-2.731597,0,0,0,0,100,0),
+(@PATH,89,-1941.015,4699.2,-2.249105,0,0,0,0,100,0),
+(@PATH,90,-1941.772,4688.908,-2.124105,0,0,0,0,100,0),
+(@PATH,91,-1945.519,4676.243,-1.860556,0,0,0,0,100,0),
+(@PATH,92,-1949.903,4664.792,-1.32178,0,0,0,0,100,0),
+(@PATH,93,-1953.648,4652.405,-0.9228547,0,0,0,0,100,0),
+(@PATH,94,-1955.702,4641.475,-0.1967804,0,0,0,0,100,0),
+(@PATH,95,-1954.826,4628.333,0.6725454,0,0,0,0,100,0),
+(@PATH,96,-1953.227,4618.669,1.832091,0,0,0,0,100,0),
+(@PATH,97,-1949.518,4608.742,3.148376,0,0,0,0,100,0),
+(@PATH,98,-1947.033,4598.139,4.958476,0,0,0,0,100,0),
+(@PATH,99,-1946.533,4587.874,6.832988,0,0,0,0,100,0),
+(@PATH,100,-1948.285,4576.442,8.562114,0,0,0,0,100,0),
+(@PATH,101,-1952.725,4567.673,9.98936,0,0,0,0,100,0),
+(@PATH,102,-1958.148,4560.353,11.17323,0,0,0,0,100,0),
+(@PATH,103,-1965.709,4551.65,12.39723,0,0,0,0,100,0),
+(@PATH,104,-1971.081,4543.296,13.14356,0,0,0,0,100,0),
+(@PATH,105,-1975.564,4532.993,13.48565,0,0,0,0,100,0),
+(@PATH,106,-1977.15,4525.117,13.41509,0,0,0,0,100,0),
+(@PATH,107,-1978.05,4513.065,12.86065,0,0,0,0,100,0),
+(@PATH,108,-1978.589,4501.11,12.18145,0,0,0,0,100,0),
+(@PATH,109,-1981.737,4483.694,11.36078,0,0,0,0,100,0),
+(@PATH,110,-1987.182,4470.06,10.33051,0,0,0,0,100,0),
+(@PATH,111,-1996.76,4455.001,8.793629,0,0,0,0,100,0),
+(@PATH,112,-2004.436,4442.11,7.641087,0,0,0,0,100,0),
+(@PATH,113,-2007.973,4429.895,6.499888,0,0,0,0,100,0),
+(@PATH,114,-2013.409,4410.697,4.321177,0,0,0,0,100,0),
+(@PATH,115,-2023.097,4394.424,2.780378,0,0,0,0,100,0),
+(@PATH,116,-2032.503,4383.386,2.058576,0,0,0,0,100,0),
+(@PATH,117,-2043.49,4372.459,1.706719,0,0,0,0,100,0),
+(@PATH,118,-2051.505,4359.686,2.099432,0,0,0,0,100,0),
+(@PATH,119,-2054.104,4350.861,2.433538,0,0,0,0,100,0),
+(@PATH,120,-2056.367,4340.22,2.724432,0,0,0,0,100,0),
+(@PATH,121,-2056.542,4330.677,2.99682,0,0,0,0,100,0),
+(@PATH,122,-2056.664,4324.11,2.99682,0,0,0,0,100,0),
+(@PATH,123,-2056.214,4332.018,2.99682,0,0,0,0,100,0),
+(@PATH,124,-2056.039,4340.757,2.724432,0,0,0,0,100,0),
+(@PATH,125,-2054.203,4351.41,2.349432,0,0,0,0,100,0),
+(@PATH,126,-2051.373,4359.925,2.099432,0,0,0,0,100,0),
+(@PATH,127,-2045.291,4369.335,1.699029,0,0,0,0,100,0),
+(@PATH,128,-2036.629,4378.904,1.956719,0,0,0,0,100,0),
+(@PATH,129,-2028.419,4387.346,2.141706,0,0,0,0,100,0),
+(@PATH,130,-2020.791,4397.267,2.932233,0,0,0,0,100,0),
+(@PATH,131,-2014.119,4409.571,4.224986,0,0,0,0,100,0),
+(@PATH,132,-2010.106,4421.343,5.473643,0,0,0,0,100,0),
+(@PATH,133,-2006.266,4435.879,7.076633,0,0,0,0,100,0),
+(@PATH,134,-2000.813,4450.336,8.24387,0,0,0,0,100,0),
+(@PATH,135,-1991.514,4462.025,9.336842,0,0,0,0,100,0),
+(@PATH,136,-1984.121,4478.006,10.909,0,0,0,0,100,0),
+(@PATH,137,-1979.109,4494.063,11.96088,0,0,0,0,100,0),
+(@PATH,138,-1977.873,4513.339,12.86065,0,0,0,0,100,0),
+(@PATH,139,-1977.565,4527.156,13.43194,0,0,0,0,100,0),
+(@PATH,140,-1974.89,4537.26,13.51856,0,0,0,0,100,0),
+(@PATH,141,-1965.713,4550.698,12.51149,0,0,0,0,100,0),
+(@PATH,142,-1956.546,4560.43,11.15467,0,0,0,0,100,0),
+(@PATH,143,-1949.815,4570.688,9.502421,0,0,0,0,100,0),
+(@PATH,144,-1945.956,4583.912,7.290629,0,0,0,0,100,0),
+(@PATH,145,-1947.067,4599.292,4.717265,0,0,0,0,100,0),
+(@PATH,146,-1951.106,4613.875,2.407409,0,0,0,0,100,0),
+(@PATH,147,-1955.157,4628.071,0.7039175,0,0,0,0,100,0),
+(@PATH,148,-1955.746,4639.441,-0.1173127,0,0,0,0,100,0),
+(@PATH,149,-1952.89,4651.96,-0.8695099,0,0,0,0,100,0),
+(@PATH,150,-1949.483,4665.713,-1.32178,0,0,0,0,100,0),
+(@PATH,151,-1945.589,4678.891,-2.186483,0,0,0,0,100,0),
+(@PATH,152,-1942.095,4687.913,-2.124105,0,0,0,0,100,0),
+(@PATH,153,-1941.368,4696.736,-2.249105,0,0,0,0,100,0),
+(@PATH,154,-1941.158,4708.608,-2.731597,0,0,0,0,100,0),
+(@PATH,155,-1942.176,4717.764,-2.855133,0,0,0,0,100,0),
+(@PATH,156,-1945.629,4731.166,-3.231597,0,0,0,0,100,0),
+(@PATH,157,-1949.973,4740.833,-2.925796,0,0,0,0,100,0);