DB/World: Cherry-picks

- ee623a4006009e729ed4cfdd36aa9bb1525d72a9 & 3965ee33efd8751d64da6352227650fb4181fe31
- 8274caeef052ffaf21c9109de13b8c2a5355d9e4
- 805be8ebba07c3280089a128f1764d49f6f84ab6
- d680e82c38068d9f69393f9d32b3f10fc9729460

4 files changed, 755 insertions, 0 deletions

diff --git a/sql/updates/world/2014_10_19_01_world_from_335.sql b/sql/updates/world/2014_10_19_01_world_from_335.sql
new file mode 100644
index 00000000000..b5048704717
--- /dev/null
+++ b/sql/updates/world/2014_10_19_01_world_from_335.sql
@@ -0,0 +1,11 @@
+SET @OGUID := 22305;
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+7 AND `id`=193997;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`,  `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
+(@OGUID+0, 193997, 571, 1, 1,  7330.436, -2212.682, 800.4834, 4.258607, 0, 0, 0, 1, 120, 255, 1), -- 193997 (Area: 67)
+(@OGUID+1, 193997, 571, 1, 1,  7211.499, -2373.856, 781.449, 4.380776, 0, 0, 0, 1, 120, 255, 1), -- 193997 (Area: 67)
+(@OGUID+2, 193997, 571, 1, 1,  6973.803, -2096.827, 777.6375, 3.263772, 0, 0, 0, 1, 120, 255, 1), -- 193997 (Area: 67)
+(@OGUID+3, 193997, 571, 1, 1,  7310.712, -2812.066, 798.081, 1.570796, 0, 0, 0, 1, 120, 255, 1), -- 193997 (Area: 67)
+(@OGUID+4, 193997, 571, 1, 1,  7301.006, -2746.12, 749.5085, 0.157079, 0, 0, 0, 1, 120, 255, 1), -- 193997 (Area: 67)
+(@OGUID+5, 193997, 571, 1, 1,  7550.374, -3154.98, 840.1462, 4.415683, 0, 0, 0, 1, 120, 255, 1), -- 193997 (Area: 67)
+(@OGUID+6, 193997, 571, 1, 1,  7177.287, -3071.111, 862.2982, 0.6806767, 0, 0, 0, 1, 120, 255, 1), -- 193997 (Area: 67)
+(@OGUID+7, 193997, 571, 1, 1,  7694.284, -3154.72, 869.7686, 3.769912, 0, 0, 0, 1, 120, 255, 1); -- 193997 (Area: 67)
diff --git a/sql/updates/world/2014_10_20_00_world_from_335.sql b/sql/updates/world/2014_10_20_00_world_from_335.sql
new file mode 100644
index 00000000000..89a6eb089d6
--- /dev/null
+++ b/sql/updates/world/2014_10_20_00_world_from_335.sql
@@ -0,0 +1,2 @@
+--
+UPDATE `creature_template` SET `faction`=1735, `unit_class`=1 WHERE `entry`=35427;
diff --git a/sql/updates/world/2014_10_21_00_world_from_335.sql b/sql/updates/world/2014_10_21_00_world_from_335.sql
new file mode 100644
index 00000000000..9a8b68bd99c
--- /dev/null
+++ b/sql/updates/world/2014_10_21_00_world_from_335.sql
@@ -0,0 +1,3 @@
+-- 
+UPDATE `achievement_criteria_data` SET `value1`=1 WHERE `criteria_id`=10291 AND `type`=12;
+UPDATE `achievement_criteria_data` SET `value1`=0 WHERE `criteria_id`=10292 AND `type`=12;
diff --git a/sql/updates/world/2014_10_22_00_world_from_335.sql b/sql/updates/world/2014_10_22_00_world_from_335.sql
new file mode 100644
index 00000000000..8da4f0600d9
--- /dev/null
+++ b/sql/updates/world/2014_10_22_00_world_from_335.sql
@@ -0,0 +1,739 @@
+DELETE FROM `creature_formations` WHERE `leaderGUID`=62078;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES
+(62078, 62078, 0, 0, 2),
+(62078, 62079, 3, 270, 2);
+-- Pathing for Falcon Watch Ranger Entry: 17282 'TDB FORMAT' 
+SET @NPC := 62078;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-629.019,`position_y`=4192.389,`position_z`=57.64539 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,-629.019,4192.389,57.64539,0,0,0,0,100,0),
+(@PATH,2,-621.6304,4173.827,61.96607,0,0,0,0,100,0),
+(@PATH,3,-622.502,4158.439,63.49118,0,0,0,0,100,0),
+(@PATH,4,-626.5296,4154.957,63.95884,0,0,0,0,100,0),
+(@PATH,5,-651.3042,4148.643,64.13602,0,0,0,0,100,0),
+(@PATH,6,-675.8679,4147.251,64.25542,0,0,0,0,100,0),
+(@PATH,7,-681.183,4148.146,64.05803,0,0,0,0,100,0),
+(@PATH,8,-685.1898,4154.62,62.10221,0,0,0,0,100,0),
+(@PATH,9,-681.183,4148.146,64.05803,0,0,0,0,100,0),
+(@PATH,10,-675.8679,4147.251,64.25542,0,0,0,100,0,0),
+(@PATH,11,-651.3042,4148.643,64.13602,0,0,0,100,0,0),
+(@PATH,12,-626.5296,4154.957,63.95884,0,0,0,100,0,0),
+(@PATH,13,-622.502,4158.439,63.49118,0,0,0,0,100,0),
+(@PATH,14,-621.6304,4173.827,61.96607,0,0,0,0,100,0);
+-- 0xF1304382000001F6 .go -629.019 4192.389 57.64539
+ 
+DELETE FROM `creature_formations` WHERE `leaderGUID`=62071;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES
+(62071, 62071, 0, 0, 2),
+(62071, 62072, 3, 270, 2);
+-- Pathing for Falcon Watch Ranger Entry: 17282 'TDB FORMAT' 
+SET @NPC := 62071;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-675.9752,`position_y`=4123.217,`position_z`=71.49055 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,-675.9752,4123.217,71.49055,0,0,0,0,100,0),
+(@PATH,2,-667.9762,4105.698,74.97163,0,0,0,0,100,0),
+(@PATH,3,-657.7415,4100.645,76.97929,0,0,0,0,100,0),
+(@PATH,4,-651.0581,4099.75,78.30082,0,0,0,0,100,0),
+(@PATH,5,-625.8835,4117.14,85.77901,0,0,0,0,100,0),
+(@PATH,6,-618.1641,4119.265,87.95321,0,0,0,0,100,0),
+(@PATH,7,-613.8455,4116.438,88.72933,0,0,0,0,100,0),
+(@PATH,8,-609.5286,4107.644,89.57821,0,0,0,0,100,0),
+(@PATH,9,-605.4523,4099.278,90.67792,0,0,0,0,100,0),
+(@PATH,10,-609.5286,4107.644,89.57821,0,0,0,0,100,0),
+(@PATH,11,-613.8455,4116.438,88.72933,0,0,0,0,100,0),
+(@PATH,12,-618.0453,4119.296,87.99764,0,0,0,0,100,0),
+(@PATH,13,-625.8835,4117.14,85.77901,0,0,0,0,100,0),
+(@PATH,14,-651.0581,4099.75,78.30082,0,0,0,0,100,0),
+(@PATH,15,-657.7415,4100.645,76.97929,0,0,0,0,100,0),
+(@PATH,16,-667.9762,4105.698,74.97163,0,0,0,0,100,0);
+-- 0xF130438200000203 .go -675.9752 4123.217 71.49055
+ 
+-- Pathing for Fel Reaver Sentry Entry: 19400 'TDB FORMAT' 
+SET @NPC := 69269;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=841.6395,`position_y`=1689.614,`position_z`=90.07014 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,841.6395,1689.614,90.07014,0,0,0,0,100,0),
+(@PATH,2,867.4593,1703.877,93.98136,0,0,0,0,100,0),
+(@PATH,3,883.9453,1719.914,103.4624,0,0,0,0,100,0),
+(@PATH,4,901.7276,1737.668,108.8486,0,0,0,0,100,0),
+(@PATH,5,925.8362,1759.348,114.9691,0,0,0,0,100,0),
+(@PATH,6,949.9918,1786.468,116.046,0,0,0,0,100,0),
+(@PATH,7,949.2334,1807.447,122.9417,0,0,0,0,100,0),
+(@PATH,8,936.9502,1821.957,129.3167,0,0,0,0,100,0),
+(@PATH,9,913.5515,1845.213,135.3171,0,0,0,0,100,0),
+(@PATH,10,883.2,1836.917,134.6228,0,0,0,0,100,0),
+(@PATH,11,853.3008,1819.786,131.9458,0,0,0,0,100,0),
+(@PATH,12,836.468,1800.237,129.0998,0,0,0,0,100,0),
+(@PATH,13,814.9409,1779.049,122.9544,0,0,0,0,100,0),
+(@PATH,14,797.8151,1759.883,121.9306,0,0,0,0,100,0),
+(@PATH,15,853.3008,1819.786,131.9458,0,0,0,0,100,0),
+(@PATH,16,883.2,1836.917,134.6228,0,0,0,0,100,0),
+(@PATH,17,913.5515,1845.213,135.3171,0,0,0,0,100,0),
+(@PATH,18,936.7758,1822.166,129.2615,0,0,0,0,100,0),
+(@PATH,19,949.1699,1807.768,122.9417,0,0,0,0,100,0),
+(@PATH,20,949.9918,1786.468,116.046,0,0,0,0,100,0),
+(@PATH,21,925.8362,1759.348,114.9691,0,0,0,0,100,0),
+(@PATH,22,901.7276,1737.668,108.8486,0,0,0,0,100,0),
+(@PATH,23,884.1349,1720.105,103.6044,0,0,0,0,100,0),
+(@PATH,24,867.6484,1704.068,93.83744,0,0,0,0,100,0);
+-- 0xF1304BC80028E16A .go 841.6395 1689.614 90.07014
+ 
+-- Pathing for Fel Reaver Sentry Entry: 19400 'TDB FORMAT' 
+SET @NPC := 69270;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=659.7363,`position_y`=1763.506,`position_z`=106.5907 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,659.7363,1763.506,106.5907,0,0,0,0,100,0),
+(@PATH,2,669.4771,1746.458,101.607,0,0,0,0,100,0),
+(@PATH,3,708.5544,1739.732,95.92836,0,0,0,0,100,0),
+(@PATH,4,734.1808,1734.606,105.1162,0,0,0,0,100,0),
+(@PATH,5,761.6609,1713.364,99.16853,0,0,0,0,100,0),
+(@PATH,6,774.5371,1705.658,99.41525,0,0,0,0,100,0),
+(@PATH,7,797.5067,1693.782,101.7913,0,0,0,0,100,0),
+(@PATH,8,836.5253,1693.207,89.73896,0,0,0,0,100,0),
+(@PATH,9,866.4222,1694.923,85.77412,0,0,0,0,100,0),
+(@PATH,10,883.9918,1697.324,92.16645,0,0,0,0,100,0),
+(@PATH,11,910.6517,1700.273,91.64384,0,0,0,0,100,0),
+(@PATH,12,953.0062,1715.017,94.01591,0,0,0,0,100,0),
+(@PATH,13,974.775,1725.138,98.3354,0,0,0,0,100,0),
+(@PATH,14,1005.147,1727.986,99.30927,0,0,0,0,100,0),
+(@PATH,15,1028.035,1734.651,99.20609,0,0,0,0,100,0),
+(@PATH,16,1050.97,1749.701,97.90122,0,0,0,0,100,0),
+(@PATH,17,1071.688,1760.824,108.7394,0,0,0,0,100,0),
+(@PATH,18,1110.738,1757.574,107.745,0,0,0,0,100,0),
+(@PATH,19,1123.154,1771.503,109.9211,0,0,0,0,100,0),
+(@PATH,20,1144.951,1802.16,117.535,0,0,0,0,100,0),
+(@PATH,21,1112.819,1818.768,122.2385,0,0,0,0,100,0),
+(@PATH,22,1097.934,1828.336,123.6704,0,0,0,0,100,0),
+(@PATH,23,1067.804,1849.203,128.4701,0,0,0,0,100,0),
+(@PATH,24,1042.273,1860.518,135.9951,0,0,0,0,100,0),
+(@PATH,25,1007.047,1865.235,138.383,0,0,0,0,100,0),
+(@PATH,26,961.6607,1871.546,137.3225,0,0,0,0,100,0),
+(@PATH,27,931.3427,1865.205,141.0557,0,0,0,0,100,0),
+(@PATH,28,908.8201,1856.518,139.9505,0,0,0,0,100,0),
+(@PATH,29,887.0521,1854.749,139.5275,0,0,0,0,100,0),
+(@PATH,30,861.2733,1852.889,138.8461,0,0,0,0,100,0),
+(@PATH,31,827.5533,1846.062,136.5966,0,0,0,0,100,0),
+(@PATH,32,798.132,1841.53,138.1245,0,0,0,0,100,0),
+(@PATH,33,774.5369,1842.917,139.7464,0,0,0,0,100,0),
+(@PATH,34,737.4844,1832.87,138.533,0,0,0,0,100,0),
+(@PATH,35,721.3911,1820.312,130.8882,0,0,0,0,100,0),
+(@PATH,36,699.2368,1807.127,127.6155,0,0,0,0,100,0),
+(@PATH,37,684.8922,1806.309,125.14,0,0,0,0,100,0),
+(@PATH,38,668.5555,1796.127,115.3672,0,0,0,0,100,0),
+(@PATH,39,659.9813,1788.506,111.5436,0,0,0,0,100,0);
+-- 0xF1304BC8002E44E3 .go 659.7363 1763.506 106.5907
+ 
+-- Pathing for Fel Reaver Sentry Entry: 19400 'TDB FORMAT' 
+SET @NPC := 69268;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=646.6895,`position_y`=1839.964,`position_z`=125.4547 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,646.6895,1839.964,125.4547,0,0,0,0,100,0),
+(@PATH,2,677.3864,1853.214,136.5473,0,0,0,0,100,0),
+(@PATH,3,706.0801,1857.406,144.2836,0,0,0,0,100,0),
+(@PATH,4,743.8764,1858.599,143.2042,0,0,0,0,100,0),
+(@PATH,5,767.1149,1850.769,141.3968,0,0,0,0,100,0),
+(@PATH,6,785.2659,1849.53,140.8406,0,0,0,0,100,0),
+(@PATH,7,823.7284,1848.935,137.2863,0,0,0,0,100,0),
+(@PATH,8,844.7641,1840.815,135.6642,0,0,0,0,100,0),
+(@PATH,9,870.2305,1846.021,136.8876,0,0,0,0,100,0),
+(@PATH,10,901.0831,1843.449,135.5533,0,0,0,0,100,0),
+(@PATH,11,938.9086,1840.775,133.339,0,0,0,0,100,0),
+(@PATH,12,984.6356,1838.182,129.0019,0,0,0,0,100,0),
+(@PATH,13,1011.226,1833.54,126.6895,0,0,0,0,100,0),
+(@PATH,14,1057.635,1836.751,126.1518,0,0,0,0,100,0),
+(@PATH,15,1067.586,1822.081,123.4199,0,0,0,0,100,0),
+(@PATH,16,1094.639,1795.399,117.2115,0,0,0,0,100,0),
+(@PATH,17,1096.268,1774.917,115.0766,0,0,0,0,100,0),
+(@PATH,18,1092.254,1762.801,109.6618,0,0,0,0,100,0),
+(@PATH,19,1077.908,1741.648,99.1233,0,0,0,0,100,0),
+(@PATH,20,1052.085,1727.124,94.70787,0,0,0,0,100,0),
+(@PATH,21,1015.579,1719.41,93.81611,0,0,0,0,100,0),
+(@PATH,22,979.6028,1719.703,93.80976,0,0,0,0,100,0),
+(@PATH,23,960.0488,1718.792,96.3173,0,0,0,0,100,0),
+(@PATH,24,935.5402,1720.851,100.5271,0,0,0,0,100,0),
+(@PATH,25,911.3182,1725.566,104.1969,0,0,0,0,100,0),
+(@PATH,26,892.9175,1721.506,103.7674,0,0,0,0,100,0),
+(@PATH,27,876.0504,1709.732,98.63383,0,0,0,0,100,0),
+(@PATH,28,857.8802,1698.331,90.26447,0,0,0,0,100,0),
+(@PATH,29,845.8919,1687.898,90.8924,0,0,0,0,100,0),
+(@PATH,30,826.5896,1689.394,94.46696,0,0,0,0,100,0),
+(@PATH,31,810.4796,1691.432,98.81523,0,0,0,0,100,0),
+(@PATH,32,793.4018,1696.299,101.5982,0,0,0,0,100,0),
+(@PATH,33,777.6357,1693.611,100.1802,0,0,0,0,100,0),
+(@PATH,34,761.6689,1694.881,97.37639,0,0,0,0,100,0),
+(@PATH,35,746.3331,1704.227,97.91486,0,0,0,0,100,0),
+(@PATH,36,730.1412,1715.37,90.97038,0,0,0,0,100,0),
+(@PATH,37,697.9177,1718.721,81.87744,0,0,0,0,100,0),
+(@PATH,38,683.4454,1731.398,98.06165,0,0,0,0,100,0),
+(@PATH,39,672.7356,1743.954,101.0712,0,0,0,0,100,0),
+(@PATH,40,655.922,1748.035,100.8441,0,0,0,0,100,0),
+(@PATH,41,636.2448,1758.785,98.42323,0,0,0,0,100,0),
+(@PATH,42,619.8185,1774.388,105.8676,0,0,0,0,100,0),
+(@PATH,43,613.7397,1804.882,113.1822,0,0,0,0,100,0),
+(@PATH,44,624.4863,1822.929,116.8767,0,0,0,0,100,0);
+-- 0xF1304BC8001BE5EA .go 646.6895 1839.964 125.4547
+ 
+-- Pathing for Avruu Entry: 17084 'TDB FORMAT' 
+SET @NPC := 59482;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1144.656,`position_y`=4221.215,`position_z`=53.53335 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,-1144.656,4221.215,53.53335,0,0,0,0,100,0),
+(@PATH,2,-1149.899,4214.391,54.47545,0,0,0,0,100,0),
+(@PATH,3,-1148.989,4220.935,53.69381,0,0,0,0,100,0),
+(@PATH,4,-1132.481,4220.839,52.68293,0,0,0,0,100,0),
+(@PATH,5,-1131.276,4211.726,50.55313,0,0,0,0,100,0),
+(@PATH,6,-1132.461,4220.687,52.65585,0,0,0,0,100,0),
+(@PATH,7,-1148.989,4220.935,53.69381,0,0,0,0,100,0),
+(@PATH,8,-1149.899,4214.391,54.47545,0,0,0,0,100,0),
+(@PATH,9,-1144.656,4221.215,53.53335,0,0,0,0,100,0),
+(@PATH,10,-1113.755,4220.15,53.67657,0,0,0,0,100,0),
+(@PATH,11,-1106.38,4213.523,55.1924,0,0,0,0,100,0),
+(@PATH,12,-1113.792,4220.234,53.68396,0,0,0,0,100,0),
+(@PATH,13,-1132.25,4220.938,52.66562,0,0,0,0,100,0),
+(@PATH,14,-1131.511,4211.614,50.52601,0,0,0,0,100,0),
+(@PATH,15,-1132.25,4220.938,52.66562,0,0,0,0,100,0);
+-- 0xF13042BC002F4AB5 .go -1144.656 4221.215 53.53335
+ 
+DELETE FROM `creature_formations` WHERE `leaderGUID`=59461;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES
+(59461, 59461, 0, 0, 2),
+(59461, 58902, 3, 60, 2),
+(59461, 58903, 3, 300, 2);
+-- Pathing for Illidari Taskmaster Entry: 17058 'TDB FORMAT' 
+SET @NPC := 59461;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-739.0243,`position_y`=4706.486,`position_z`=59.08763 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,-739.0243,4706.486,59.08763,0,0,0,0,100,0),
+(@PATH,2,-720.4598,4714.083,58.00349,0,0,0,0,100,0),
+(@PATH,3,-700.3239,4731.957,55.12849,0,0,0,0,100,0),
+(@PATH,4,-688.1065,4752.427,50.3562,0,0,0,0,100,0),
+(@PATH,5,-671.6681,4783.523,48.85718,0,0,0,0,100,0),
+(@PATH,6,-666.7562,4804.472,49.27185,0,0,0,0,100,0),
+(@PATH,7,-659.798,4809.12,49.37691,0,0,0,0,100,0),
+(@PATH,8,-628.5441,4808.44,41.65781,0,0,0,0,100,0),
+(@PATH,9,-606.4383,4807.069,37.6156,0,0,0,0,100,0),
+(@PATH,10,-600.5306,4809.674,36.55847,0,0,0,0,100,0),
+(@PATH,11,-601.5439,4825.514,36.89904,0,0,0,0,100,0),
+(@PATH,12,-599.8547,4836.65,37.78796,0,0,0,0,100,0),
+(@PATH,13,-587.3387,4850.032,38.78796,0,0,0,0,100,0),
+(@PATH,14,-574.3077,4857.394,38.76745,0,0,0,0,100,0),
+(@PATH,15,-553.303,4868.131,37.42022,0,0,0,0,100,0),
+(@PATH,16,-546.1716,4873.221,37.4395,0,0,0,0,100,0),
+(@PATH,17,-537.9453,4886.015,36.57769,0,0,0,0,100,0),
+(@PATH,18,-534.9305,4896.668,37.71563,0,0,0,0,100,0),
+(@PATH,19,-537.9453,4886.015,36.57769,0,0,0,0,100,0),
+(@PATH,20,-546.1716,4873.221,37.4395,0,0,0,0,100,0),
+(@PATH,21,-553.303,4868.131,37.42022,0,0,0,0,100,0),
+(@PATH,22,-574.3077,4857.394,38.76745,0,0,0,0,100,0),
+(@PATH,23,-587.3387,4850.032,38.78796,0,0,0,0,100,0),
+(@PATH,24,-599.8547,4836.65,37.78796,0,0,0,0,100,0),
+(@PATH,25,-601.5098,4825.779,36.90564,0,0,0,0,100,0),
+(@PATH,26,-600.5306,4809.674,36.55847,0,0,0,0,100,0),
+(@PATH,27,-606.4383,4807.069,37.6156,0,0,0,0,100,0),
+(@PATH,28,-628.5441,4808.44,41.65781,0,0,0,0,100,0),
+(@PATH,29,-659.798,4809.12,49.37691,0,0,0,0,100,0),
+(@PATH,30,-666.7562,4804.472,49.27185,0,0,0,0,100,0),
+(@PATH,31,-671.6681,4783.523,48.85718,0,0,0,0,100,0),
+(@PATH,32,-688.0059,4752.591,50.27185,0,0,0,0,100,0),
+(@PATH,33,-700.3239,4731.957,55.12849,0,0,0,0,100,0),
+(@PATH,34,-720.4598,4714.083,58.00349,0,0,0,0,100,0);
+-- 0xF13042A20038016F .go -739.0243 4706.486 59.08763
+ 
+-- Pathing for Mag'har Watcher Entry: 16911 'TDB FORMAT' 
+SET @NPC := 58668;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=544.4113,`position_y`=3863.158,`position_z`=206.4794 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,544.4113,3863.158,206.4794,0,0,0,0,100,0),
+(@PATH,2,546.8116,3867.611,206.4329,0,0,0,0,100,0),
+(@PATH,3,551.9465,3876.498,205.2316,0,0,0,0,100,0),
+(@PATH,4,554.5156,3882.23,205.1167,0,0,0,0,100,0),
+(@PATH,5,556.8832,3885.992,206.5175,0,0,0,0,100,0),
+(@PATH,6,559.1604,3890.118,208.6536,0,0,0,0,100,0),
+(@PATH,7,560.1864,3892.583,210.294,0,0,0,0,100,0),
+(@PATH,8,562.0711,3895.741,212.2924,0,0,0,0,100,0),
+(@PATH,9,559.1604,3890.118,208.6536,0,0,0,0,100,0),
+(@PATH,10,556.8832,3885.992,206.5175,0,0,0,0,100,0),
+(@PATH,11,554.5156,3882.23,205.1167,0,0,0,0,100,0),
+(@PATH,12,551.9465,3876.498,205.2316,0,0,0,0,100,0),
+(@PATH,13,546.8116,3867.611,206.4329,0,0,0,0,100,0);
+-- 0xF130420F00000681 .go 544.4113 3863.158 206.4794
+ 
+-- Pathing for Mag'har Watcher Entry: 16911 'TDB FORMAT' 
+SET @NPC := 58665;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=517.4471,`position_y`=3844.644,`position_z`=206.9812 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,517.4471,3844.644,206.9812,0,0,0,0,100,0),
+(@PATH,2,520.5403,3832.705,206.5191,0,0,0,0,100,0),
+(@PATH,3,529.7895,3827.019,206.5042,0,0,0,0,100,0),
+(@PATH,4,533.5421,3826.609,206.5398,0,0,0,0,100,0),
+(@PATH,5,547.4796,3832.629,206.5393,0,0,0,0,100,0),
+(@PATH,6,550.8764,3844.464,206.5215,0,0,0,0,100,0),
+(@PATH,7,547.1805,3853.744,206.5172,0,0,0,0,100,0),
+(@PATH,8,541.1375,3857.636,206.5186,0,0,0,0,100,0),
+(@PATH,9,534.0944,3859.733,206.2727,0,0,0,0,100,0),
+(@PATH,10,529.3141,3858.76,206.2927,0,0,0,0,100,0),
+(@PATH,11,523.7713,3855.4,206.7145,0,0,0,0,100,0),
+(@PATH,12,518.4979,3848.389,207.1368,0,0,0,0,100,0);
+-- 0xF130420F00000682 .go 517.4471 3844.644 206.9812
+ 
+-- Pathing for Honor Hold Scout Entry: 20238 'TDB FORMAT' 
+SET @NPC := 96990;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=273.5557,`position_y`=1451.374,`position_z`=-13.17962 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,273.5557,1451.374,-13.17962,0,0,0,0,100,0),
+(@PATH,2,317.6477,1400.698,-3.460944,0,0,0,0,100,0),
+(@PATH,3,335.8789,1479.614,-5.462881,0,0,0,0,100,0),
+(@PATH,4,315.942,1491.847,-10.07765,0,0,0,0,100,0),
+(@PATH,5,293.1233,1485.149,-13.06351,0,0,0,0,100,0),
+(@PATH,6,288.7853,1482.748,-12.85769,0,0,0,0,100,0),
+(@PATH,7,284.0427,1479.701,-12.68358,0,0,0,0,100,0),
+(@PATH,8,279.2419,1471.795,-13.21379,0,0,0,0,100,0),
+(@PATH,9,276.009,1464.286,-13.35486,0,0,0,0,100,0),
+(@PATH,10,274.5031,1457.938,-13.28576,0,0,0,0,100,0),
+(@PATH,11,273.5557,1451.374,-13.17962,0,0,0,0,100,0),
+(@PATH,12,317.6477,1400.698,-3.460944,0,0,0,0,100,0),
+(@PATH,13,335.8789,1479.614,-5.462881,0,0,0,0,100,0),
+(@PATH,14,315.942,1491.847,-10.07765,0,0,0,0,100,0),
+(@PATH,15,293.1233,1485.149,-13.06351,0,0,0,0,100,0),
+(@PATH,16,288.7853,1482.748,-12.85769,0,0,0,0,100,0),
+(@PATH,17,284.0427,1479.701,-12.68358,0,0,0,0,100,0),
+(@PATH,18,279.2419,1471.795,-13.21379,0,0,0,0,100,0),
+(@PATH,19,276.009,1464.286,-13.35486,0,0,0,0,100,0),
+(@PATH,20,274.5031,1457.938,-13.28576,0,0,0,0,100,0);
+-- 0xF1304F0E00005863 .go 273.5557 1451.374 -13.17962
+ 
+-- Pathing for Scout Vanura Entry: 16797 'TDB FORMAT' 
+SET @NPC := 57800;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=74.06347,`position_y`=4333.108,`position_z`=101.4732 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,74.06347,4333.108,101.4732,0,0,0,0,100,0),
+(@PATH,2,59.68077,4332.904,96.16065,0,0,0,0,100,0),
+(@PATH,3,73.1186,4333.158,101.0555,0,0,0,0,100,0),
+(@PATH,4,90.34354,4333.228,101.4834,0,0,0,0,100,0),
+(@PATH,5,122.9175,4333.386,104.8669,0,0,0,0,100,0),
+(@PATH,6,154.94,4333.245,107.505,0,0,0,0,100,0),
+(@PATH,7,122.9175,4333.386,104.8669,0,0,0,0,100,0),
+(@PATH,8,90.34354,4333.228,101.4834,0,0,0,0,100,0),
+(@PATH,9,74.06347,4333.108,101.4732,0,0,0,0,100,0),
+(@PATH,10,59.68077,4332.904,96.16065,0,0,0,0,100,0),
+(@PATH,11,73.1186,4333.158,101.0555,0,0,0,0,100,0),
+(@PATH,12,90.34354,4333.228,101.4834,0,0,0,0,100,0),
+(@PATH,13,122.9175,4333.386,104.8669,0,0,0,0,100,0),
+(@PATH,14,154.94,4333.245,107.505,0,0,0,0,100,0),
+(@PATH,15,192.0898,4333.342,116.4441,0,0,0,0,100,0),
+(@PATH,16,154.94,4333.245,107.505,0,0,0,0,100,0),
+(@PATH,17,122.9175,4333.386,104.8669,0,0,0,0,100,0),
+(@PATH,18,90.34354,4333.228,101.4834,0,0,0,0,100,0),
+(@PATH,19,74.06347,4333.108,101.4732,0,0,0,0,100,0),
+(@PATH,20,154.94,4333.245,107.505,0,0,0,0,100,0),
+(@PATH,21,192.0898,4333.342,116.4441,0,0,0,0,100,0),
+(@PATH,22,122.9175,4333.386,104.8669,0,0,0,0,100,0),
+(@PATH,23,90.34354,4333.228,101.4834,0,0,0,0,100,0),
+(@PATH,24,74.06347,4333.108,101.4732,0,0,0,0,100,0),
+(@PATH,25,59.68077,4332.904,96.16065,0,0,0,0,100,0),
+(@PATH,26,73.1186,4333.158,101.0555,0,0,0,0,100,0),
+(@PATH,27,90.34354,4333.228,101.4834,0,0,0,0,100,0),
+(@PATH,28,122.9175,4333.386,104.8669,0,0,0,0,100,0),
+(@PATH,29,154.94,4333.245,107.505,0,0,0,0,100,0),
+(@PATH,30,192.0898,4333.342,116.4441,0,0,0,0,100,0),
+(@PATH,31,90.34354,4333.228,101.4834,0,0,0,0,100,0);
+-- 0xF130419D0000219A .go 74.06347 4333.108 101.4732
+ 
+-- Should be 3 Mistress of Doom spawns not 6.
+DELETE FROM `creature` WHERE `guid` BETWEEN 68722 AND 68724;
+ 
+-- Pathing for Mistress of Doom Entry: 19192 'TDB FORMAT' 
+SET @NPC := 68725;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=421.0149,`position_y`=3339.626,`position_z`=62.06211 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,421.0149,3339.626,62.06211,0,0,0,0,100,0),
+(@PATH,2,368.5956,3364.738,63.81692,0,0,0,0,100,0),
+(@PATH,3,344.4051,3344.649,67.40168,0,0,0,0,100,0),
+(@PATH,4,327.5585,3321.236,72.71063,0,0,0,0,100,0),
+(@PATH,5,400.1786,3349.047,62.79062,0,0,0,0,100,0),
+(@PATH,6,421.0149,3339.626,62.06211,0,0,0,0,100,0),
+(@PATH,7,344.4051,3344.649,67.40168,0,0,0,0,100,0),
+(@PATH,8,327.5585,3321.236,72.71063,0,0,0,0,100,0),
+(@PATH,9,344.4051,3344.649,67.40168,0,0,0,0,100,0),
+(@PATH,10,368.5956,3364.738,63.81692,0,0,0,0,100,0),
+(@PATH,11,400.1786,3349.047,62.79062,0,0,0,0,100,0),
+(@PATH,12,421.0149,3339.626,62.06211,0,0,0,0,100,0),
+(@PATH,13,449.1115,3343.667,65.47438,0,0,0,0,100,0),
+(@PATH,14,468.069,3360.591,77.34941,0,0,0,0,100,0),
+(@PATH,15,449.1115,3343.667,65.47438,0,0,0,0,100,0),
+(@PATH,16,421.0149,3339.626,62.06211,0,0,0,0,100,0),
+(@PATH,17,400.1786,3349.047,62.79062,0,0,0,0,100,0),
+(@PATH,18,368.5956,3364.738,63.81692,0,0,0,0,100,0),
+(@PATH,19,344.4051,3344.649,67.40168,0,0,0,0,100,0),
+(@PATH,20,327.5585,3321.236,72.71063,0,0,0,0,100,0),
+(@PATH,21,344.4051,3344.649,67.40168,0,0,0,0,100,0),
+(@PATH,22,368.5956,3364.738,63.81692,0,0,0,0,100,0),
+(@PATH,23,400.1786,3349.047,62.79062,0,0,0,0,100,0),
+(@PATH,24,421.0149,3339.626,62.06211,0,0,0,0,100,0),
+(@PATH,25,449.1115,3343.667,65.47438,0,0,0,0,100,0),
+(@PATH,26,468.069,3360.591,77.34941,0,0,0,0,100,0),
+(@PATH,27,449.1115,3343.667,65.47438,0,0,0,0,100,0);
+-- 0xF1304AF80038CC31 .go 421.0149 3339.626 62.06211
+ 
+-- Pathing for Mistress of Doom Entry: 19192 'TDB FORMAT' 
+SET @NPC := 68726;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=384.5248,`position_y`=3256.693,`position_z`=74.51141 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,384.5248,3256.693,74.51141,0,0,0,0,100,0),
+(@PATH,2,372.4839,3266.02,74.55065,0,0,0,0,100,0),
+(@PATH,3,377.4411,3280.069,74.39575,0,0,0,0,100,0),
+(@PATH,4,378.1626,3299.152,74.52856,0,0,0,0,100,0),
+(@PATH,5,384.6801,3308.861,74.5426,0,0,0,0,100,0),
+(@PATH,6,402.9049,3304.486,74.55357,0,0,0,0,100,0),
+(@PATH,7,413.7969,3286.998,74.61218,0,0,0,0,100,0),
+(@PATH,8,421.3358,3276.941,74.55165,0,0,0,0,100,0),
+(@PATH,9,416.6131,3261.531,74.554,0,0,0,0,100,0),
+(@PATH,10,421.3358,3276.941,74.55165,0,0,0,0,100,0),
+(@PATH,11,413.7969,3286.998,74.61218,0,0,0,0,100,0),
+(@PATH,12,402.9049,3304.486,74.55357,0,0,0,0,100,0),
+(@PATH,13,384.6801,3308.861,74.5426,0,0,0,0,100,0),
+(@PATH,14,378.1626,3299.152,74.52856,0,0,0,0,100,0),
+(@PATH,15,377.4411,3280.069,74.39575,0,0,0,0,100,0),
+(@PATH,16,372.4839,3266.02,74.55065,0,0,0,0,100,0);
+-- 0xF1304AF80038BBB8 .go 384.5248 3256.693 74.51141
+ 
+-- Pathing for Mistress of Doom Entry: 19192 'TDB FORMAT' 
+SET @NPC := 68727;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=407.5233,`position_y`=3263.597,`position_z`=74.55978 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,407.5233,3263.597,74.55978,0,0,0,0,100,0),
+(@PATH,2,411.5036,3274.989,74.68412,0,0,0,0,100,0),
+(@PATH,3,408.0285,3293.335,74.58907,0,0,0,0,100,0),
+(@PATH,4,393.1323,3301.217,74.58429,0,0,0,0,100,0),
+(@PATH,5,383.5548,3298.82,74.53128,0,0,0,0,100,0),
+(@PATH,6,376.8429,3288.129,74.32133,0,0,0,0,100,0),
+(@PATH,7,378.8334,3272.364,74.51328,0,0,0,0,100,0),
+(@PATH,8,387.7648,3258.965,74.60986,0,0,0,0,100,0),
+(@PATH,9,378.8334,3272.364,74.51328,0,0,0,0,100,0),
+(@PATH,10,376.8651,3287.953,74.34109,0,0,0,0,100,0),
+(@PATH,11,383.5548,3298.82,74.53128,0,0,0,0,100,0),
+(@PATH,12,393.1323,3301.217,74.58429,0,0,0,0,100,0),
+(@PATH,13,408.0285,3293.335,74.58907,0,0,0,0,100,0),
+(@PATH,14,411.5036,3274.989,74.68412,0,0,0,0,100,0);
+-- 0xF1304AF80038BEE8 .go 407.5233 3263.597 74.55978
+ 
+-- Pathing for Unyielding Knight Entry: 16906 'TDB FORMAT' 
+SET @NPC := 58621;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1094.606,`position_y`=2691.313,`position_z`=-0.5718141 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,-1094.606,2691.313,-0.5718141,0,0,0,0,100,0),
+(@PATH,2,-1101.713,2727.011,-10.54628,0,0,0,0,100,0),
+(@PATH,3,-1115.584,2762.751,-13.63931,0,0,0,0,100,0),
+(@PATH,4,-1135.107,2786.331,-29.13247,0,0,0,0,100,0),
+(@PATH,5,-1153.197,2808.646,-17.71369,0,0,0,0,100,0),
+(@PATH,6,-1190.575,2828.042,-16.47421,0,0,0,0,100,0),
+(@PATH,7,-1216.98,2838.043,-16.51846,0,0,0,0,100,0),
+(@PATH,8,-1246.225,2841.554,-16.1834,0,0,0,0,100,0),
+(@PATH,9,-1216.98,2838.043,-16.51846,0,0,0,0,100,0),
+(@PATH,10,-1190.575,2828.042,-16.47421,0,0,0,0,100,0),
+(@PATH,11,-1153.197,2808.646,-17.71369,0,0,0,0,100,0),
+(@PATH,12,-1135.107,2786.331,-29.13247,0,0,0,0,100,0),
+(@PATH,13,-1115.584,2762.751,-13.63931,0,0,0,0,100,0),
+(@PATH,14,-1101.713,2727.011,-10.54628,0,0,0,0,100,0),
+(@PATH,15,-1094.606,2691.313,-0.5718141,0,0,0,0,100,0);
+ 
+-- Pathing for Unyielding Knight Entry: 16906 'TDB FORMAT' 
+SET @NPC := 58615;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1154.349,`position_y`=2673.648,`position_z`=3.767312 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,-1154.349,2673.648,3.767312,0,0,0,0,100,0),
+(@PATH,2,-1130.748,2685.984,-0.1009769,0,0,0,0,100,0),
+(@PATH,3,-1101.372,2705.62,-5.162488,0,0,0,0,100,0),
+(@PATH,4,-1088.276,2732.212,-12.38731,0,0,0,0,100,0),
+(@PATH,5,-1088.584,2765,-9.172983,0,0,0,0,100,0),
+(@PATH,6,-1091.869,2786.115,-8.024483,0,0,0,0,100,0),
+(@PATH,7,-1108.186,2802.652,-15.7359,0,0,0,0,100,0),
+(@PATH,8,-1147.134,2816.302,-17.79132,0,0,0,0,100,0),
+(@PATH,9,-1179.198,2811.857,-20.95943,0,0,0,0,100,0),
+(@PATH,10,-1193.584,2773.023,-18.83023,0,0,0,0,100,0),
+(@PATH,11,-1214.371,2734.819,-12.88417,0,0,0,0,100,0),
+(@PATH,12,-1237.986,2717.969,-9.584949,0,0,0,0,100,0),
+(@PATH,13,-1228.331,2693.615,-2.615346,0,0,0,0,100,0),
+(@PATH,14,-1227.854,2670.797,4.303111,0,0,0,0,100,0),
+(@PATH,15,-1189.622,2664.75,7.12471,0,0,0,0,100,0);
+-- 0xF130420A0051C089 .go -1154.349 2673.648 3.767312
+ 
+-- Pathing for Unyielding Knight Entry: 16906 'TDB FORMAT' 
+SET @NPC := 58621;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1135.107,`position_y`=2786.331,`position_z`=-29.13247 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,-1094.606,2691.313,-0.5718141,0,0,0,0,100,0),
+(@PATH,2,-1101.713,2727.011,-10.54628,0,0,0,0,100,0),
+(@PATH,3,-1115.584,2762.751,-13.63931,0,0,0,0,100,0),
+(@PATH,4,-1135.107,2786.331,-29.13247,0,0,0,0,100,0),
+(@PATH,5,-1153.197,2808.646,-17.71369,0,0,0,0,100,0),
+(@PATH,6,-1190.575,2828.042,-16.47421,0,0,0,0,100,0),
+(@PATH,7,-1216.98,2838.043,-16.51846,0,0,0,0,100,0),
+(@PATH,8,-1246.225,2841.554,-16.1834,0,0,0,0,100,0),
+(@PATH,9,-1284.498,2853.048,-14.62445,0,0,0,0,100,0),
+(@PATH,10,-1246.225,2841.554,-16.1834,0,0,0,0,100,0),
+(@PATH,11,-1216.98,2838.043,-16.51846,0,0,0,0,100,0),
+(@PATH,12,-1190.575,2828.042,-16.47421,0,0,0,0,100,0),
+(@PATH,13,-1153.197,2808.646,-17.71369,0,0,0,0,100,0),
+(@PATH,14,-1135.107,2786.331,-29.13247,0,0,0,0,100,0),
+(@PATH,15,-1115.584,2762.751,-13.63931,0,0,0,0,100,0),
+(@PATH,16,-1101.713,2727.011,-10.54628,0,0,0,0,100,0),
+(@PATH,17,-1094.606,2691.313,-0.5718141,0,0,0,0,100,0);
+-- 0xF130420A004D70D0 .go -1135.107 2786.331 -29.13247
+ 
+-- Pathing for Unyielding Knight Entry: 16906 'TDB FORMAT' 
+SET @NPC := 58616;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1242.694,`position_y`=2847.193,`position_z`=-14.70488 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,-1242.694,2847.193,-14.70488,0,0,0,0,100,0),
+(@PATH,2,-1333.916,2843.581,-26.88158,0,0,0,0,100,0),
+(@PATH,3,-1373.451,2821.236,-38.77312,0,0,0,0,100,0),
+(@PATH,4,-1412.447,2797.512,-50.41302,0,0,0,0,100,0),
+(@PATH,5,-1443.701,2771.588,-52.18716,0,0,0,0,100,0),
+(@PATH,6,-1444.06,2737.759,-44.08505,0,0,0,0,100,0),
+(@PATH,7,-1448.392,2707.42,-40.20878,0,0,0,0,100,0),
+(@PATH,8,-1443.701,2771.588,-52.18716,0,0,0,0,100,0),
+(@PATH,9,-1412.447,2797.512,-50.41302,0,0,0,0,100,0),
+(@PATH,10,-1373.451,2821.236,-38.77312,0,0,0,0,100,0),
+(@PATH,11,-1334.068,2843.568,-26.86644,0,0,0,0,100,0),
+(@PATH,12,-1287.16,2846.185,-17.27875,0,0,0,0,100,0);
+-- 0xF130420A00516E60 .go -1242.694 2847.193 -14.70488
+ 
+DELETE FROM `creature_formations` WHERE `leaderGUID`=59379;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES
+(59379, 59379, 0, 0, 2),
+(59379, 59378, 1, 270, 2);
+-- Pathing for Ghostly Denizen Entry: 16976 'TDB FORMAT' 
+SET @NPC := 59379;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1314.826,`position_y`=2697.474,`position_z`=-10.63524 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,-1314.826,2697.474,-10.63524,0,0,0,0,100,0),
+(@PATH,2,-1302.509,2682.092,-4.465803,0,0,0,0,100,0),
+(@PATH,3,-1285.212,2673.274,0.324069,0,0,0,0,100,0),
+(@PATH,4,-1262.781,2666.778,4.161468,0,0,0,0,100,0),
+(@PATH,5,-1239.486,2668.24,4.636199,0,0,0,0,100,0),
+(@PATH,6,-1228.059,2678.768,1.697886,0,0,0,0,100,0),
+(@PATH,7,-1226.799,2691.145,-1.925649,0,0,0,0,100,0),
+(@PATH,8,-1231.047,2708.734,-6.77056,0,0,0,0,100,0),
+(@PATH,9,-1241.512,2719.076,-10.28185,0,0,0,0,100,0),
+(@PATH,10,-1258.358,2721.242,-12.72142,0,0,0,0,100,0),
+(@PATH,11,-1277.803,2722.124,-15.09074,0,0,0,0,100,0),
+(@PATH,12,-1297.916,2717.709,-15.91459,0,0,0,0,100,0),
+(@PATH,13,-1312.5,2710.416,-14.70897,0,0,0,0,100,0);
+-- 0xF130425000001C5C .go -1314.826 2697.474 -10.63524
+ 
+-- Pathing for Eye of Grillok Entry: 19440 'TDB FORMAT' 
+SET @NPC := 69630;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1133.545,`position_y`=1974.219,`position_z`=73.66801 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,-1133.545,1974.219,73.66801,0,0,0,0,100,0),
+(@PATH,2,-1139.647,1984.812,73.48808,0,0,0,0,100,0),
+(@PATH,3,-1153.481,1986.271,73.91801,0,0,0,0,100,0),
+(@PATH,4,-1176.863,1983.853,74.17966,0,0,0,0,100,0),
+(@PATH,5,-1193.333,2001.905,73.7545,0,0,0,0,100,0),
+(@PATH,6,-1189.884,2008.264,73.80833,0,0,0,0,100,0),
+(@PATH,7,-1162.244,2001.973,72.5789,0,0,0,0,100,0),
+(@PATH,8,-1137.158,1989.238,72.25078,0,0,0,0,100,0),
+(@PATH,9,-1123.422,1973.485,73.44966,0,0,0,0,100,0),
+(@PATH,10,-1118.553,1952.296,74.29433,0,0,0,0,100,0),
+(@PATH,11,-1101.236,1949.125,76.37685,0,0,0,0,100,0),
+(@PATH,12,-1097.989,1958.75,74.65789,0,0,0,0,100,0),
+(@PATH,13,-1113.206,1975.783,72.86079,0,0,0,0,100,0),
+(@PATH,14,-1130.415,1977.334,73.54243,0,0,0,0,100,0),
+(@PATH,15,-1133.53,1974.111,73.66801,0,0,0,0,100,0),
+(@PATH,16,-1139.474,1963.058,77.44243,0,0,0,0,100,0),
+(@PATH,17,-1153.622,1941.719,81.403,0,0,0,0,100,0),
+(@PATH,18,-1143.852,1934.362,81.42173,0,0,0,0,100,0),
+(@PATH,19,-1140.552,1924.993,81.37407,0,0,0,0,100,0),
+(@PATH,20,-1135.054,1914.743,81.40356,0,0,0,0,100,0),
+(@PATH,21,-1139.732,1900.652,81.34557,0,0,0,0,100,0),
+(@PATH,22,-1158.967,1910.94,81.54838,0,0,0,0,100,0),
+(@PATH,23,-1156.435,1918.194,81.54838,0,0,0,0,100,0),
+(@PATH,24,-1168.744,1929.098,81.54708,0,0,0,0,100,0),
+(@PATH,25,-1177.184,1923.736,80.29801,0,0,0,0,100,0),
+(@PATH,26,-1188.636,1930.298,81.37504,0,0,0,0,100,0),
+(@PATH,27,-1194.5,1933.201,81.3617,0,0,0,0,100,0),
+(@PATH,28,-1198.93,1925.219,81.35394,0,0,0,0,100,0),
+(@PATH,29,-1197.309,1911.631,81.41698,0,0,0,0,100,0),
+(@PATH,30,-1192.73,1901.408,81.41022,0,0,0,0,100,0),
+(@PATH,31,-1197.309,1911.631,81.41698,0,0,0,0,100,0),
+(@PATH,32,-1198.93,1925.219,81.35394,0,0,0,0,100,0),
+(@PATH,33,-1194.5,1933.201,81.3617,0,0,0,0,100,0),
+(@PATH,34,-1188.673,1930.316,81.37252,0,0,0,0,100,0),
+(@PATH,35,-1177.206,1923.749,80.29263,0,0,0,0,100,0),
+(@PATH,36,-1168.744,1929.098,81.54708,0,0,0,0,100,0),
+(@PATH,37,-1156.435,1918.194,81.54838,0,0,0,0,100,0),
+(@PATH,38,-1158.967,1910.94,81.54838,0,0,0,0,100,0),
+(@PATH,39,-1139.825,1900.374,81.35677,0,0,0,0,100,0),
+(@PATH,40,-1135.054,1914.743,81.40356,0,0,0,0,100,0),
+(@PATH,41,-1140.528,1924.947,81.36578,0,0,0,0,100,0),
+(@PATH,42,-1143.852,1934.362,81.42173,0,0,0,0,100,0),
+(@PATH,43,-1153.749,1941.527,81.40314,0,0,0,0,100,0),
+(@PATH,44,-1139.474,1963.058,77.44243,0,0,0,0,100,0),
+(@PATH,45,-1133.53,1974.111,73.66801,0,0,0,0,100,0),
+(@PATH,46,-1130.415,1977.334,73.54243,0,0,0,0,100,0),
+(@PATH,47,-1113.206,1975.783,72.86079,0,0,0,0,100,0),
+(@PATH,48,-1097.989,1958.75,74.65789,0,0,0,0,100,0),
+(@PATH,49,-1101.236,1949.125,76.37685,0,0,0,0,100,0),
+(@PATH,50,-1118.553,1952.296,74.29433,0,0,0,0,100,0),
+(@PATH,51,-1123.422,1973.485,73.44966,0,0,0,0,100,0),
+(@PATH,52,-1137.158,1989.238,72.25078,0,0,0,0,100,0),
+(@PATH,53,-1162.244,2001.973,72.5789,0,0,0,0,100,0),
+(@PATH,54,-1189.884,2008.264,73.80833,0,0,0,0,100,0),
+(@PATH,55,-1193.333,2001.905,73.7545,0,0,0,0,100,0),
+(@PATH,56,-1176.863,1983.853,74.17966,0,0,0,0,100,0),
+(@PATH,57,-1153.481,1986.271,73.91801,0,0,0,0,100,0),
+(@PATH,58,-1139.647,1984.812,73.48808,0,0,0,0,100,0);
+-- 0xF1304BF000608EC0 .go -1133.545 1974.219 73.66801
+ 
+-- Pathing for Eye of Grillok Entry: 19440 'TDB FORMAT' 
+SET @NPC := 69632;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1102.267,`position_y`=2066.633,`position_z`=67.68956 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,-1102.267,2066.633,67.68956,0,0,0,0,100,0),
+(@PATH,2,-1083.351,2080.714,65.12747,0,0,0,0,100,0),
+(@PATH,3,-1052.895,2094.359,61.0218,0,0,0,0,100,0),
+(@PATH,4,-1017.934,2079.23,68.33347,0,0,0,0,100,0),
+(@PATH,5,-1003.467,2046.212,67.2819,0,0,0,0,100,0),
+(@PATH,6,-995.76,2017.331,67.06455,0,0,0,0,100,0),
+(@PATH,7,-1002.273,2000.312,67.06455,0,0,0,0,100,0),
+(@PATH,8,-994.0292,1982.86,67.84361,0,0,0,0,100,0),
+(@PATH,9,-989.314,1952.273,70.44984,0,0,0,0,100,0),
+(@PATH,10,-960.0438,1951.905,67.81455,0,0,0,0,100,0);
+-- 0xF1304BF000612D24 .go -1102.267 2066.633 67.68956
+ 
+-- Pathing for Eye of Grillok Entry: 19440 'TDB FORMAT' 
+SET @NPC := 69631;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1014.376,`position_y`=2076.241,`position_z`=68.65146 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,-1014.376,2076.241,68.65146,0,0,0,0,100,0),
+(@PATH,2,-991.5126,2053.373,67.06454,0,0,0,0,100,0),
+(@PATH,3,-966.9857,2030.343,67.06455,0,0,0,0,100,0),
+(@PATH,4,-959.8001,2017.528,67.03322,0,0,0,0,100,0),
+(@PATH,5,-921.6862,2020.938,61.3862,0,0,0,0,100,0),
+(@PATH,6,-904.4248,2040.584,48.97299,0,0,0,0,100,0),
+(@PATH,7,-891.9199,2071.103,32.17977,0,0,0,0,100,0),
+(@PATH,8,-902.8315,2093.767,24.96597,0,0,0,0,100,0),
+(@PATH,9,-919.9766,2121.966,20.22781,0,0,0,0,100,0),
+(@PATH,10,-939.8874,2146.113,17.11834,0,0,0,0,100,0),
+(@PATH,11,-950.2776,2165.229,15.73687,0,0,0,0,100,0),
+(@PATH,12,-970.1002,2184.593,14.41798,0,0,0,0,100,0),
+(@PATH,13,-1000.677,2189.11,14.28434,0,0,0,0,100,0),
+(@PATH,14,-1038.272,2175.676,22.84645,0,0,0,0,100,0),
+(@PATH,15,-1055.283,2148.659,38.23811,0,0,0,0,100,0),
+(@PATH,16,-1059.658,2118.107,53.76555,0,0,0,0,100,0),
+(@PATH,17,-1045.689,2098.584,60.57795,0,0,0,0,100,0);
+-- 0xF1304BF000613548 .go -1014.376 2076.241 68.65146
+ 
+-- Pathing for Eye of Grillok Entry: 19440 'TDB FORMAT' 
+SET @NPC := 69633;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-971.1483,`position_y`=2038.908,`position_z`=67.03989 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,-971.1483,2038.908,67.03989,0,0,0,0,100,0),
+(@PATH,2,-958.2822,2014.4,67.03322,0,0,0,0,100,0),
+(@PATH,3,-957.9716,1998.73,68.80885,0,0,0,0,100,0),
+(@PATH,4,-948.8636,1987.684,68.46583,0,0,0,0,100,0),
+(@PATH,5,-928.804,1988.219,66.7764,0,0,0,0,100,0),
+(@PATH,6,-920.0879,1955.257,67.56455,0,0,0,0,100,0),
+(@PATH,7,-928.804,1988.219,66.7764,0,0,0,0,100,0),
+(@PATH,8,-948.8636,1987.684,68.46583,0,0,0,0,100,0),
+(@PATH,9,-957.9716,1998.73,68.80885,0,0,0,0,100,0),
+(@PATH,10,-958.2822,2014.4,67.03322,0,0,0,0,100,0),
+(@PATH,11,-971.1483,2038.908,67.03989,0,0,0,0,100,0),
+(@PATH,12,-989.3309,2057.323,67.06454,0,0,0,0,100,0),
+(@PATH,13,-1024.213,2078.929,67.38486,0,0,0,0,100,0),
+(@PATH,14,-1046.714,2102.792,59.16204,0,0,0,0,100,0),
+(@PATH,15,-1024.213,2078.929,67.38486,0,0,0,0,100,0);
+-- 0xF1304BF00061F48A .go -971.1483 2038.908 67.03989