diff options
| -rw-r--r-- | sql/updates/world/2014_07_27_02_world_waypoints.sql | 97 |
1 files changed, 97 insertions, 0 deletions
diff --git a/sql/updates/world/2014_07_27_02_world_waypoints.sql b/sql/updates/world/2014_07_27_02_world_waypoints.sql new file mode 100644 index 00000000000..badb3af6078 --- /dev/null +++ b/sql/updates/world/2014_07_27_02_world_waypoints.sql @@ -0,0 +1,97 @@ +-- Pathing for Murkblood Invader Entry: 18238 +SET @NPC := 65508; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1928.632,`position_y`=8725.079,`position_z`=24.25752,`orientation`=3.095328 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,17891, ''); +UPDATE `creature` SET `position_x`=-1918.632,`position_y`=8724.079,`position_z`=24.25752,`orientation`=3.095328 WHERE `guid`=65506; +UPDATE `creature` SET `position_x`=-1908.632,`position_y`=8724.079,`position_z`=24.64092,`orientation`=3.095328 WHERE `guid`=65507; +DELETE FROM `creature_formations` WHERE `leaderGUID`=65508; +INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`)VALUES +(65508,65508,0,0,2),(65508,65506,10,0,2),(65508,65507,20,0,2); +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,-1928.632,8725.079,24.25752,0,0,0,0,100,0), +(@PATH,2,-1966.446,8717.539,21.99185,0,0,0,0,100,0), +(@PATH,3,-2005.826,8716.254,19.80993,0,0,0,0,100,0), +(@PATH,4,-2016.783,8714.921,19.39349,0,0,0,0,100,0), +(@PATH,5,-2042.417,8701.892,18.07981,0,0,0,0,100,0), +(@PATH,6,-2068.804,8680.673,18.93495,0,0,0,0,100,0), +(@PATH,7,-2087.212,8652.72,17.59001,0,0,0,0,100,0), +(@PATH,8,-2102.178,8631.095,17.35943,0,0,0,0,100,0), +(@PATH,9,-2124.29,8607.336,17.17577,0,0,0,0,100,0), +(@PATH,10,-2125.007,8588.16,17.36669,0,0,0,0,100,0), +(@PATH,11,-2116.553,8560.366,19.12604,0,0,0,0,100,0), +(@PATH,12,-2114.252,8531.596,21.75403,0,0,0,0,100,0), +(@PATH,13,-2108.561,8507.092,23.44275,0,0,0,0,100,0), +(@PATH,14,-2106.812,8478.482,22.60953,0,0,0,0,100,0), +(@PATH,15,-2106.71,8463.584,22.14218,0,0,0,0,100,0), +(@PATH,16,-2088.777,8437.308,21.56343,0,0,0,0,100,0), +(@PATH,17,-2074.934,8402.895,18.74801,0,0,0,0,100,0), +(@PATH,18,-2054.847,8372.031,17.88245,0,0,0,0,100,0), +(@PATH,19,-2044.42,8353.194,16.45808,0,0,0,0,100,0), +(@PATH,20,-2040.957,8337.205,14.9322,0,0,0,0,100,0), +(@PATH,21,-2021.216,8310.251,11.5401,0,0,0,0,100,0), +(@PATH,22,-2004.646,8291.519,10.82406,0,0,0,0,100,0), +(@PATH,23,-1989.724,8273.373,8.883897,0,0,0,0,100,0), +(@PATH,24,-1983.553,8259.863,6.539972,0,0,0,0,100,0), +(@PATH,25,-1982.861,8233.603,2.136774,0,0,0,0,100,0), +(@PATH,26,-1986.143,8199.416,0.9015293,0,0,0,0,100,0), +(@PATH,27,-2011.609,8175.506,0.3361206,0,0,0,0,100,0), +(@PATH,28,-2030.666,8151.698,1.648474,0,0,0,0,100,0), +(@PATH,29,-2048.426,8130.438,2.55332,0,0,0,0,100,0), +(@PATH,30,-2064.924,8112.038,2.538671,0,0,0,0,100,0), +(@PATH,31,-2079.267,8093.191,2.946595,0,0,0,0,100,0), +(@PATH,32,-2091.217,8071.594,2.854432,0,0,0,0,100,0), +(@PATH,33,-2106.352,8049.733,1.976455,0,0,0,0,100,0), +(@PATH,34,-2121.393,8026.129,1.529545,0,0,0,0,100,0), +(@PATH,35,-2126.731,8001.408,0.009037018,0,0,0,0,100,0), +(@PATH,36,-2133.614,7980.045,-1.761643,0,0,0,0,100,0), +(@PATH,37,-2141.162,7953.366,-4.754976,0,0,0,0,100,0), +(@PATH,38,-2141.755,7928.814,-6.847231,0,0,0,0,100,0), +(@PATH,39,-2143.836,7906.825,-8.610537,0,0,0,0,100,0), +(@PATH,40,-2146.907,7880.856,-10.76713,0,0,0,0,100,0), +(@PATH,41,-2149.451,7859.555,-11.69755,0,0,0,0,100,0), +(@PATH,42,-2149.775,7839.294,-12.42301,0,0,0,0,100,0), +(@PATH,43,-2152.03,7824.522,-12.74447,0,0,0,0,100,0), +(@PATH,44,-2149.775,7839.294,-12.42301,0,0,0,0,100,0), +(@PATH,45,-2149.451,7859.555,-11.69755,0,0,0,0,100,0), +(@PATH,46,-2146.907,7880.856,-10.76713,0,0,0,0,100,0), +(@PATH,47,-2143.836,7906.825,-8.610537,0,0,0,0,100,0), +(@PATH,48,-2141.755,7928.814,-6.847231,0,0,0,0,100,0), +(@PATH,49,-2141.162,7953.366,-4.754976,0,0,0,0,100,0), +(@PATH,50,-2133.614,7980.045,-1.761643,0,0,0,0,100,0), +(@PATH,51,-2126.731,8001.408,0.009037018,0,0,0,0,100,0), +(@PATH,52,-2121.393,8026.129,1.529545,0,0,0,0,100,0), +(@PATH,53,-2106.352,8049.733,1.976455,0,0,0,0,100,0), +(@PATH,54,-2091.217,8071.594,2.854432,0,0,0,0,100,0), +(@PATH,55,-2079.267,8093.191,2.946595,0,0,0,0,100,0), +(@PATH,56,-2064.924,8112.038,2.538671,0,0,0,0,100,0), +(@PATH,57,-2048.426,8130.438,2.55332,0,0,0,0,100,0), +(@PATH,58,-2030.666,8151.698,1.648474,0,0,0,0,100,0), +(@PATH,59,-2011.609,8175.506,0.3361206,0,0,0,0,100,0), +(@PATH,60,-1986.143,8199.416,0.9015293,0,0,0,0,100,0), +(@PATH,61,-1982.861,8233.603,2.136774,0,0,0,0,100,0), +(@PATH,62,-1983.553,8259.863,6.539972,0,0,0,0,100,0), +(@PATH,63,-1989.724,8273.373,8.883897,0,0,0,0,100,0), +(@PATH,64,-2004.646,8291.519,10.82406,0,0,0,0,100,0), +(@PATH,65,-2021.216,8310.251,11.5401,0,0,0,0,100,0), +(@PATH,66,-2040.957,8337.205,14.9322,0,0,0,0,100,0), +(@PATH,67,-2044.42,8353.194,16.45808,0,0,0,0,100,0), +(@PATH,68,-2054.847,8372.031,17.88245,0,0,0,0,100,0), +(@PATH,69,-2074.934,8402.895,18.74801,0,0,0,0,100,0), +(@PATH,70,-2088.777,8437.308,21.56343,0,0,0,0,100,0), +(@PATH,71,-2106.71,8463.584,22.14218,0,0,0,0,100,0), +(@PATH,72,-2106.812,8478.482,22.60953,0,0,0,0,100,0), +(@PATH,73,-2108.561,8507.092,23.44275,0,0,0,0,100,0), +(@PATH,74,-2114.252,8531.596,21.75403,0,0,0,0,100,0), +(@PATH,75,-2116.553,8560.366,19.12604,0,0,0,0,100,0), +(@PATH,76,-2125.007,8588.16,17.36669,0,0,0,0,100,0), +(@PATH,77,-2124.29,8607.336,17.17577,0,0,0,0,100,0), +(@PATH,78,-2102.178,8631.095,17.35943,0,0,0,0,100,0), +(@PATH,79,-2087.212,8652.72,17.59001,0,0,0,0,100,0), +(@PATH,80,-2068.804,8680.673,18.93495,0,0,0,0,100,0), +(@PATH,81,-2042.417,8701.892,18.07981,0,0,0,0,100,0), +(@PATH,82,-2016.783,8714.921,19.39349,0,0,0,0,100,0), +(@PATH,83,-2005.826,8716.254,19.80993,0,0,0,0,100,0), +(@PATH,84,-1966.446,8717.539,21.99185,0,0,0,0,100,0); |