Db/Pathing: Pathed second set of Murkblood Invaders in Nagrand

1 files changed, 89 insertions, 0 deletions

diff --git a/sql/updates/world/2014_07_28_02_world_misc.sql b/sql/updates/world/2014_07_28_02_world_misc.sql
new file mode 100644
index 00000000000..c4a6bdf03fb
--- /dev/null
+++ b/sql/updates/world/2014_07_28_02_world_misc.sql
@@ -0,0 +1,89 @@
+-- Pathing for Murkblood Invader Entry: 18238
+SET @NPC := 65511;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-975.0311,`position_y`=8003.268,`position_z`=24.70724 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`=-967.0311,`position_y`=8010.268,`position_z`=25.46785,`orientation`=3.095328 WHERE `guid`=65510;
+UPDATE `creature` SET `position_x`=-959.0311,`position_y`=8016.268,`position_z`=26.73114,`orientation`=3.095328 WHERE `guid`=65509;
+DELETE FROM `creature_formations` WHERE `leaderGUID`=65511;
+INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`)VALUES
+(65511,65511,0,0,2),(65511,65510,10,0,2),(65511,65509,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,-975.0311,8003.268,24.70724,0,0,0,0,100,0),
+(@PATH,2,-997.3242,7988.124,23.90081,0,0,0,0,100,0),
+(@PATH,3,-1024.918,7967.106,22.78156,0,0,0,0,100,0),
+(@PATH,4,-1048.562,7947.569,21.29751,0,0,0,0,100,0),
+(@PATH,5,-1066.489,7937.455,20.27663,0,0,0,0,100,0),
+(@PATH,6,-1088.943,7921.778,18.32084,0,0,0,0,100,0),
+(@PATH,7,-1102.926,7906.132,16.31742,0,0,0,0,100,0),
+(@PATH,8,-1114.524,7884.297,15.90722,0,0,0,0,100,0),
+(@PATH,9,-1123.868,7866.92,15.65722,0,0,0,0,100,0),
+(@PATH,10,-1136.17,7848.297,14.90967,0,0,0,0,100,0),
+(@PATH,11,-1151.416,7823.156,13.6708,0,0,0,0,100,0),
+(@PATH,12,-1154.832,7816.532,13.38034,0,0,0,0,100,0),
+(@PATH,13,-1166.244,7797.691,11.91216,0,0,0,0,100,0),
+(@PATH,14,-1169.851,7792.627,12.57034,0,0,0,0,100,0),
+(@PATH,15,-1180.903,7774.724,12.0325,0,0,0,0,100,0),
+(@PATH,16,-1186.413,7751.253,11.90193,0,0,0,0,100,0),
+(@PATH,17,-1216.748,7712.277,10.70068,0,0,0,0,100,0),
+(@PATH,18,-1241.251,7681.352,9.454306,0,0,0,0,100,0),
+(@PATH,19,-1216.748,7712.277,10.70068,0,0,0,0,100,0),
+(@PATH,20,-1186.413,7751.253,11.90193,0,0,0,0,100,0),
+(@PATH,21,-1180.903,7774.724,12.0325,0,0,0,0,100,0),
+(@PATH,22,-1169.851,7792.627,12.57034,0,0,0,0,100,0),
+(@PATH,23,-1166.244,7797.691,11.91216,0,0,0,0,100,0),
+(@PATH,24,-1154.972,7816.302,13.51729,0,0,0,0,100,0),
+(@PATH,25,-1151.416,7823.156,13.6708,0,0,0,0,100,0),
+(@PATH,26,-1136.17,7848.297,14.90967,0,0,0,0,100,0),
+(@PATH,27,-1123.868,7866.92,15.65722,0,0,0,0,100,0),
+(@PATH,28,-1114.524,7884.297,15.90722,0,0,0,0,100,0),
+(@PATH,29,-1102.926,7906.132,16.31742,0,0,0,0,100,0),
+(@PATH,30,-1088.943,7921.778,18.32084,0,0,0,0,100,0),
+(@PATH,31,-1066.489,7937.455,20.27663,0,0,0,0,100,0),
+(@PATH,32,-1048.562,7947.569,21.29751,0,0,0,0,100,0),
+(@PATH,33,-1024.918,7967.106,22.78156,0,0,0,0,100,0),
+(@PATH,34,-997.3242,7988.124,23.90081,0,0,0,0,100,0),
+(@PATH,35,-975.0311,8003.268,24.70724,0,0,0,0,100,0),
+(@PATH,36,-950.7655,8028.221,26.45019,0,0,0,0,100,0),
+(@PATH,37,-927.2802,8053.072,23.7813,0,0,0,0,100,0),
+(@PATH,38,-923.4583,8083.05,20.75642,0,0,0,0,100,0),
+(@PATH,39,-942.1875,8120.313,15.28892,0,0,0,0,100,0),
+(@PATH,40,-941.4887,8118.656,15.8869,0,0,0,0,100,0),
+(@PATH,41,-960.761,8156.537,10.70663,0,0,0,0,100,0),
+(@PATH,42,-967.709,8169.791,14.39479,0,0,0,0,100,0),
+(@PATH,43,-972.3214,8185.858,15.8854,0,0,0,0,100,0),
+(@PATH,44,-972.4633,8204.367,16.85678,0,0,0,0,100,0),
+(@PATH,45,-969.6346,8233.534,18.45239,0,0,0,0,100,0),
+(@PATH,46,-963.277,8258.822,19.3653,0,0,0,0,100,0),
+(@PATH,47,-952.5289,8277.955,19.9442,0,0,0,0,100,0),
+(@PATH,48,-941.4935,8296.437,21.77709,0,0,0,0,100,0),
+(@PATH,49,-927.161,8313.917,23.47841,0,0,0,0,100,0),
+(@PATH,50,-904.2444,8338.236,24.87936,0,0,0,0,100,0),
+(@PATH,51,-875.242,8346.935,27.22016,0,0,0,0,100,0),
+(@PATH,52,-845.6073,8354.45,29.7155,0,0,0,0,100,0),
+(@PATH,53,-821.9045,8365.908,31.60839,0,0,0,0,100,0),
+(@PATH,54,-797.6428,8377.114,32.67945,0,0,0,0,100,0),
+(@PATH,55,-774.5784,8385.888,33.82203,0,0,0,0,100,0),
+(@PATH,56,-754.1369,8393.085,33.83342,0,0,0,0,100,0),
+(@PATH,57,-774.5784,8385.888,33.82203,0,0,0,0,100,0),
+(@PATH,58,-797.6428,8377.114,32.67945,0,0,0,0,100,0),
+(@PATH,59,-821.9045,8365.908,31.60839,0,0,0,0,100,0),
+(@PATH,60,-845.3145,8354.584,29.7509,0,0,0,0,100,0),
+(@PATH,61,-875.242,8346.935,27.22016,0,0,0,0,100,0),
+(@PATH,62,-904.2444,8338.236,24.87936,0,0,0,0,100,0),
+(@PATH,63,-927.161,8313.917,23.47841,0,0,0,0,100,0),
+(@PATH,64,-941.4935,8296.437,21.77709,0,0,0,0,100,0),
+(@PATH,65,-952.5289,8277.955,19.9442,0,0,0,0,100,0),
+(@PATH,66,-963.277,8258.822,19.3653,0,0,0,0,100,0),
+(@PATH,67,-969.6346,8233.534,18.45239,0,0,0,0,100,0),
+(@PATH,68,-972.4633,8204.367,16.85678,0,0,0,0,100,0),
+(@PATH,69,-972.3214,8185.858,15.8854,0,0,0,0,100,0),
+(@PATH,70,-966.993,8169.693,14.49245,0,0,0,0,100,0),
+(@PATH,71,-960.761,8156.537,10.70663,0,0,0,0,100,0),
+(@PATH,72,-941.4887,8118.656,15.8869,0,0,0,0,100,0),
+(@PATH,73,-942.1875,8120.313,15.28892,0,0,0,0,100,0),
+(@PATH,74,-923.4583,8083.05,20.75642,0,0,0,0,100,0),
+(@PATH,75,-927.2802,8053.072,23.7813,0,0,0,0,100,0),
+(@PATH,76,-950.7655,8028.221,26.45019,0,0,0,0,100,0);