diff options
| -rw-r--r-- | sql/updates/world/master/2017_03_15_02_world.sql | 855 |
1 files changed, 855 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_03_15_02_world.sql b/sql/updates/world/master/2017_03_15_02_world.sql new file mode 100644 index 00000000000..689b47dbf15 --- /dev/null +++ b/sql/updates/world/master/2017_03_15_02_world.sql @@ -0,0 +1,855 @@ +-- Pathing for Tawny Grisette Entry: 4554 +SET @NPC := 326504; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1585.829,`position_y`=203.3863,`position_z`=-43.10271 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,257,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,1585.829,203.3863,-43.10271,0,0,0,0,100,0), +(@PATH,2,1605.897,202.9824,-43.10271,0,0,0,0,100,0), +(@PATH,3,1615.094,208.4064,-43.10272,0,0,0,0,100,0), +(@PATH,4,1631.786,225.5727,-43.10291,0,0,0,0,100,0), +(@PATH,5,1633.566,240.9065,-43.10271,0,0,0,0,100,0), +(@PATH,6,1629.72,255.7577,-43.10271,0,0,0,0,100,0), +(@PATH,7,1615.501,270.9346,-43.10272,0,0,0,0,100,0), +(@PATH,8,1604.583,277.0562,-43.10271,0,0,0,0,100,0), +(@PATH,9,1585.277,276.9533,-43.10272,0,0,0,0,100,0), +(@PATH,10,1571.827,267.4717,-43.10272,0,0,0,0,100,0), +(@PATH,11,1562.386,258.2707,-43.10272,0,0,0,0,100,0), +(@PATH,12,1558.899,249.2707,-43.10272,0,0,0,0,100,0), +(@PATH,13,1558.865,231.9332,-43.10272,0,0,0,0,100,0), +(@PATH,14,1565.029,219.2863,-43.10272,0,0,0,0,100,0), +(@PATH,15,1575.238,209.333,-43.10272,0,0,0,0,100,0); + +-- Pathing for Morley Bates Entry: 4571 +SET @NPC := 326909; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1759.657,`position_y`=131.1934,`position_z`=-62.29543 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,257,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,1759.657,131.1934,-62.29543,0,0,0,0,100,0), +(@PATH,2,1748.012,137.4028,-62.25178,0,0,0,0,100,0), +(@PATH,3,1740.992,133.7818,-62.16055,0,0,0,0,100,0), +(@PATH,4,1734,128.82,-60.11205,0,0,0,0,100,0), +(@PATH,5,1728.17,124.1366,-60.38492,0,0,0,0,100,0), +(@PATH,6,1721.189,117.5238,-55.21569,0,0,0,0,100,0), +(@PATH,7,1717.064,115.9389,-55.21523,0,0,0,0,100,0), +(@PATH,8,1706.279,127.6673,-48.94267,0,0,0,0,100,0), +(@PATH,9,1694.081,139.2291,-55.21449,0,0,0,0,100,0), +(@PATH,10,1695.937,143.2202,-55.21449,0,0,0,0,100,0), +(@PATH,11,1701.63,150.0567,-60.46595,0,0,0,0,100,0), +(@PATH,12,1700.794,156.4153,-60.44453,0,0,0,0,100,0), +(@PATH,13,1706.71,173.6413,-60.73384,0,0,0,0,100,0), +(@PATH,14,1701.067,179.4115,-62.16849,0,0,0,0,100,0), +(@PATH,15,1689.143,177.4711,-62.17167,0,0,0,0,100,0), +(@PATH,16,1682.125,173.6181,-62.16256,0,0,0,0,100,0), +(@PATH,17,1679.01,170.4191,-62.14726,0,0,0,0,100,0), +(@PATH,18,1663.14,155.1027,-62.15337,0,0,0,0,100,0), +(@PATH,19,1660.32,151.2245,-62.16807,0,0,0,0,100,0), +(@PATH,20,1656.651,142.3302,-62.15673,0,0,0,0,100,0), +(@PATH,21,1661.991,130.196,-61.84558,0,0,0,0,100,0), +(@PATH,22,1676.097,127.9013,-60.40832,0,0,0,0,100,0), +(@PATH,23,1683.653,131.5577,-60.46751,0,0,0,0,100,0), +(@PATH,24,1691.373,139.0889,-55.21449,0,0,0,0,100,0), +(@PATH,25,1694.585,138.9976,-55.21449,0,0,0,0,100,0), +(@PATH,26,1705.707,127.6135,-48.91088,0,0,0,0,100,0), +(@PATH,27,1716.679,116.0953,-55.21507,0,0,0,0,100,0), +(@PATH,28,1715.674,112.2779,-55.21564,0,0,0,0,100,0), +(@PATH,29,1709.764,105.6789,-60.19333,0,0,0,0,100,0), +(@PATH,30,1697.478,93.34071,-62.21451,0,0,0,0,100,0), +(@PATH,31,1694.804,80.54069,-62.29027,0,0,0,0,100,0), +(@PATH,32,1700.168,73.63531,-62.29094,0,0,0,0,100,0), +(@PATH,33,1713.855,66.62489,-62.28673,0,0,0,0,100,0), +(@PATH,34,1733.035,77.48069,-62.27689,0,0,0,0,100,0), +(@PATH,35,1744.218,91.91211,-62.27553,0,0,0,0,100,0), +(@PATH,36,1757.176,102.9975,-62.27755,0,0,0,0,100,0), +(@PATH,37,1764.38,120.8597,-62.28806,0,0,0,0,100,0); + +-- Pathing for Apothecary Vallia Entry: 5731 +SET @NPC := 326725; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1559.164,`position_y`=203.8449,`position_z`=-60.77632 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,258,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,1559.164,203.8449,-60.77632,0,0,0,0,100,0), +(@PATH,2,1567.68,212.9054,-60.06765,0,0,0,0,100,0), +(@PATH,3,1581.177,225.8454,-62.09164,0,0,0,0,100,0), +(@PATH,4,1586.238,223.0969,-61.67398,0,0,0,0,100,0), +(@PATH,5,1592.253,220.8051,-57.1618,0,0,0,0,100,0), +(@PATH,6,1594.63,221.559,-57.16179,0,0,0,0,100,0), +(@PATH,7,1595.749,230.6497,-52.15401,0,0,0,0,100,0), +(@PATH,8,1588.123,232.8398,-52.15097,0,0,0,0,100,0), +(@PATH,9,1584.88,236.0808,-52.15224,0,0,0,0,100,0), +(@PATH,10,1582.759,240.1434,-52.16006,0,0,0,0,100,0), +(@PATH,11,1561.433,241.0706,-43.1027,0,0,0,0,100,0), +(@PATH,12,1557.956,237.2014,-43.10272,0,0,0,0,100,0), +(@PATH,13,1558.51,224.5973,-43.10272,0,0,0,0,100,0), +(@PATH,14,1570.15,213.5291,-43.10272,0,0,0,0,100,0), +(@PATH,15,1582.608,205.4603,-43.10271,0,0,0,0,100,0), +(@PATH,16,1590.89,204.6019,-43.10271,0,0,0,0,100,0), +(@PATH,17,1607.02,204.9123,-43.10271,0,0,0,0,100,0), +(@PATH,18,1620.113,213.9126,-43.10273,0,0,0,0,100,0), +(@PATH,19,1629.479,224.2986,-43.10285,0,0,0,0,100,0), +(@PATH,20,1632.486,234.0948,-43.10271,0,0,0,0,100,0), +(@PATH,21,1626.803,239.483,-43.5357,0,0,0,0,100,0), +(@PATH,22,1608.77,239.6058,-52.16164,0,0,0,0,100,0), +(@PATH,23,1604.651,247.2332,-52.15142,0,0,0,0,100,0), +(@PATH,24,1597.86,248.8099,-52.15112,0,0,0,0,100,0), +(@PATH,25,1595.951,250.6565,-52.20539,0,0,0,0,100,0), +(@PATH,26,1596.339,257.6151,-57.16176,0,0,0,0,100,0), +(@PATH,27,1593.608,260.0897,-57.16173,0,0,0,0,100,0), +(@PATH,28,1584.948,257.3997,-62.09802,0,0,0,0,100,0), +(@PATH,29,1580.704,256.7061,-61.90705,0,0,0,0,100,0), +(@PATH,30,1566.03,270.1387,-60.69815,0,0,0,0,100,0), +(@PATH,31,1552.022,284.4692,-60.77094,0,0,0,0,100,0), +(@PATH,32,1551.179,293.9314,-62.18154,0,0,0,0,100,0), +(@PATH,33,1560.501,301.8349,-62.1808,0,0,0,0,100,0), +(@PATH,34,1580.878,307.5726,-62.17775,0,0,0,0,100,0), +(@PATH,35,1592.493,313.8373,-62.17767,0,0,0,0,100,0), +(@PATH,36,1597.319,322.5752,-62.17767,0,0,0,0,100,0), +(@PATH,37,1598.02,353.6171,-62.17767,0,0,0,0,100,0), +(@PATH,38,1594.556,366.0296,-62.17767,0,0,0,0,100,0), +(@PATH,39,1585.444,374.394,-62.17767,0,0,0,0,100,0), +(@PATH,40,1571.183,373.7234,-62.17767,0,0,0,0,100,0), +(@PATH,41,1551.741,368.048,-62.18069,0,0,0,0,100,0), +(@PATH,42,1534.453,357.6154,-61.49976,0,0,0,0,100,0), +(@PATH,43,1517.667,348.6974,-60.78792,0,0,0,0,100,0), +(@PATH,44,1502.102,336.2555,-60.08769,0,0,0,0,100,0), +(@PATH,45,1487.438,318.3246,-60.79054,0,0,0,0,100,0), +(@PATH,46,1477.089,301.717,-61.50144,0,0,0,0,100,0), +(@PATH,47,1468.311,289.3764,-62.16127,0,0,0,0,100,0), +(@PATH,48,1466.305,282.3268,-62.17114,0,0,0,0,100,0), +(@PATH,49,1463.788,271.1567,-62.17767,0,0,0,0,100,0), +(@PATH,50,1461.636,257.5972,-62.17767,0,0,0,0,100,0), +(@PATH,51,1467.867,246.0334,-62.17767,0,0,0,0,100,0), +(@PATH,52,1480.602,242.5015,-62.17767,0,0,0,0,100,0), +(@PATH,53,1506.842,240.7696,-62.17767,0,0,0,0,100,0), +(@PATH,54,1519.246,237.4662,-62.1779,0,0,0,0,100,0), +(@PATH,55,1528.314,224.7165,-62.17772,0,0,0,0,100,0), +(@PATH,56,1527.163,214.0843,-62.17819,0,0,0,0,100,0), +(@PATH,57,1535.35,203.1634,-62.17976,0,0,0,0,100,0), +(@PATH,58,1543.278,196.9464,-62.18104,0,0,0,0,100,0), +(@PATH,59,1552.109,198.9596,-60.77146,0,0,0,0,100,0); + +-- Pathing for Apothecary Katrina Entry: 5732 +SET @NPC := 326512; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1466.422,`position_y`=280.1332,`position_z`=-61.83098 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,257,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,1466.422,280.1332,-61.83098,0,0,0,0,100,0), +(@PATH,2,1462.712,264.0277,-62.17767,0,0,0,0,100,0), +(@PATH,3,1465.767,247.5457,-62.17767,0,0,0,0,100,0), +(@PATH,4,1478.263,242.9652,-62.17767,0,0,0,0,100,0), +(@PATH,5,1501.926,242.9552,-62.17767,0,0,0,0,100,0), +(@PATH,6,1520.958,243.3809,-62.17781,0,0,0,0,100,0), +(@PATH,7,1525.291,251.1487,-62.1777,0,0,0,0,100,0), +(@PATH,8,1528.966,265.8931,-62.17767,0,0,0,0,100,0), +(@PATH,9,1535.906,275.8387,-62.18037,0,0,0,0,100,0), +(@PATH,10,1542.76,286.4127,-62.18134,0,0,0,0,100,0), +(@PATH,11,1549.165,295.0348,-62.18067,0,0,0,0,100,0), +(@PATH,12,1565.807,303.8345,-62.17983,0,0,0,0,100,0), +(@PATH,13,1577.012,309.1165,-62.17772,0,0,0,0,100,0), +(@PATH,14,1588.851,311.3029,-62.17786,0,0,0,0,100,0), +(@PATH,15,1594.247,319.3173,-62.17767,0,0,0,0,100,0), +(@PATH,16,1595.194,347.093,-62.17767,0,0,0,0,100,0), +(@PATH,17,1594.173,364.9902,-62.17767,0,0,0,0,100,0), +(@PATH,18,1586.592,373.6289,-62.17767,0,0,0,0,100,0), +(@PATH,19,1570.099,372.6948,-62.17767,0,0,0,0,100,0), +(@PATH,20,1550.568,370.0574,-62.17924,0,0,0,0,100,0), +(@PATH,21,1543.08,363.3218,-62.18589,0,0,0,0,100,0), +(@PATH,22,1519.255,348.8141,-60.79005,0,0,0,0,100,0), +(@PATH,23,1501.656,336.185,-60.08778,0,0,0,0,100,0), +(@PATH,24,1485.868,314.1041,-61.48457,0,0,0,0,100,0), +(@PATH,25,1474.473,295.6322,-62.17868,0,0,0,0,100,0); + +-- Pathing for Cedric Stumpel Entry: 5744 +SET @NPC := 326856; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1521.995,`position_y`=122.3141,`position_z`=-57.15205 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,1521.995,122.3141,-57.15205,0,0,0,0,100,0), +(@PATH,2,1514.91,126.3855,-60.78285,0,0,0,0,100,0), +(@PATH,3,1509.876,134.5304,-60.09071,0,0,0,0,100,0), +(@PATH,4,1502.532,143.4817,-60.09056,0,0,0,0,100,0), +(@PATH,5,1488.885,157.5371,-60.09068,0,0,0,0,100,0), +(@PATH,6,1480.589,161.489,-60.78409,0,0,0,0,100,0), +(@PATH,7,1477.119,168.5383,-57.15204,0,0,0,0,100,0), +(@PATH,8,1473.485,169.9341,-57.15204,0,0,0,0,100,0), +(@PATH,9,1459.536,162.9077,-50.9134,0,0,0,0,100,0), +(@PATH,10,1444.435,154.0052,-57.1529,0,0,0,0,100,0), +(@PATH,11,1436.596,165.1508,-62.31957,0,0,0,0,100,0), +(@PATH,12,1432.084,165.8221,-62.30082,0,0,0,0,100,0), +(@PATH,13,1427.117,148.912,-62.29035,0,0,0,0,100,0), +(@PATH,14,1416.204,136.2396,-62.26799,0,0,0,0,100,0), +(@PATH,15,1413.28,124.932,-62.28933,0,0,0,0,100,0), +(@PATH,16,1425.305,101.469,-62.28295,0,0,0,0,100,0), +(@PATH,17,1447.392,72.06684,-62.28094,0,0,0,0,100,0), +(@PATH,18,1463.838,56.03592,-62.29053,0,0,0,0,100,0), +(@PATH,19,1492.961,64.92709,-62.29664,0,0,0,0,100,0), +(@PATH,20,1508.147,72.9222,-62.30055,0,0,0,0,100,0), +(@PATH,21,1518.455,76.94629,-62.30362,0,0,0,0,100,0), +(@PATH,22,1518.262,82.08084,-62.30931,0,0,0,0,100,0), +(@PATH,23,1509.344,87.6492,-57.15322,0,0,0,0,100,0), +(@PATH,24,1508.419,90.72157,-57.1126,0,0,0,0,100,0), +(@PATH,25,1515.074,104.4576,-50.89963,0,0,0,0,100,0), +(@PATH,26,1524.594,119.023,-57.15205,0,0,0,0,100,0); + +-- Pathing for Hepzibah Sedgewick Entry: 5747 +SET @NPC := 326721; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1525.648,`position_y`=233.3281,`position_z`=-62.17797 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,257,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,1525.648,233.3281,-62.17797,0,0,0,0,100,0), +(@PATH,2,1526.56,219.5792,-62.1778,0,0,0,0,100,0), +(@PATH,3,1531.405,205.2021,-62.17919,0,0,0,0,100,0), +(@PATH,4,1542.791,191.3619,-62.18124,0,0,0,0,100,0), +(@PATH,5,1559.787,178.5941,-62.17767,0,0,0,0,100,0), +(@PATH,6,1577.523,172.1603,-62.17767,0,0,0,0,100,0), +(@PATH,7,1587.42,169.3764,-62.17767,0,0,0,0,100,0), +(@PATH,8,1594.174,161.3339,-62.17767,0,0,0,0,100,0), +(@PATH,9,1594.491,131.5768,-62.17767,0,0,0,0,100,0), +(@PATH,10,1592.605,113.0221,-62.17767,0,0,0,0,100,0), +(@PATH,11,1582.281,104.4307,-62.17767,0,0,0,0,100,0), +(@PATH,12,1563.744,107.6496,-62.17767,0,0,0,0,100,0), +(@PATH,13,1547.055,113.0844,-62.165,0,0,0,0,100,0), +(@PATH,14,1537.052,122.4526,-61.51208,0,0,0,0,100,0), +(@PATH,15,1532.863,139.5267,-62.17168,0,0,0,0,100,0), +(@PATH,16,1521.765,154.1877,-62.16226,0,0,0,0,100,0), +(@PATH,17,1509.385,165.7573,-62.15208,0,0,0,0,100,0), +(@PATH,18,1501.144,174.2727,-62.16141,0,0,0,0,100,0), +(@PATH,19,1488.744,180.8999,-62.18316,0,0,0,0,100,0), +(@PATH,20,1474.736,188.0014,-62.19061,0,0,0,0,100,0), +(@PATH,21,1465.005,201.3092,-62.17617,0,0,0,0,100,0), +(@PATH,22,1462.536,211.253,-62.17767,0,0,0,0,100,0), +(@PATH,23,1461.918,229.935,-62.17767,0,0,0,0,100,0), +(@PATH,24,1474.105,240.5338,-62.17767,0,0,0,0,100,0), +(@PATH,25,1514.806,238.4358,-62.17767,0,0,0,0,100,0); + +-- Pathing for Harbinger Balthazad Entry: 10879 +SET @NPC := 326526; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1583.052,`position_y`=225.3536,`position_z`=-62.09464 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,257,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,1583.052,225.3536,-62.09464,0,0,0,0,100,0), +(@PATH,2,1588.539,221.5911,-59.66184,0,0,0,0,100,0), +(@PATH,3,1595.215,219.9118,-57.16176,0,0,0,0,100,0), +(@PATH,4,1603.144,222.0246,-60.22791,0,0,0,0,100,0), +(@PATH,5,1612.337,230.1261,-62.07737,0,0,0,0,100,0), +(@PATH,6,1614.62,243.4541,-62.07421,0,0,0,0,100,0), +(@PATH,7,1609.965,254.0528,-62.09331,0,0,0,0,100,0), +(@PATH,8,1602.818,258.5897,-59.73977,0,0,0,0,100,0), +(@PATH,9,1594.158,260.0942,-57.16173,0,0,0,0,100,0), +(@PATH,10,1581.823,254.437,-62.08465,0,0,0,0,100,0), +(@PATH,11,1575.266,243.1816,-62.07736,0,0,0,0,100,0), +(@PATH,12,1576.985,231.0778,-62.08086,0,0,0,0,100,0), +(@PATH,13,1578.098,222.2382,-61.04623,0,0,0,0,100,0), +(@PATH,14,1554.738,199.4328,-60.77403,0,0,0,0,100,0), +(@PATH,15,1546.076,190.2032,-62.18095,0,0,0,0,100,0), +(@PATH,16,1570.378,175.8391,-62.17767,0,0,0,0,100,0), +(@PATH,17,1589.876,172.9214,-62.17767,0,0,0,0,100,0), +(@PATH,18,1613.641,174.841,-62.178,0,0,0,0,100,0), +(@PATH,19,1632.234,180.7852,-62.17807,0,0,0,0,100,0), +(@PATH,20,1650.286,198.471,-62.1795,0,0,0,0,100,0), +(@PATH,21,1658.255,216.4895,-62.17751,0,0,0,0,100,0), +(@PATH,22,1663.214,231.2824,-62.17767,0,0,0,0,100,0), +(@PATH,23,1661.302,260.8908,-62.17849,0,0,0,0,100,0), +(@PATH,24,1656.121,278.1525,-62.1793,0,0,0,0,100,0), +(@PATH,25,1640.977,294.3095,-62.1813,0,0,0,0,100,0), +(@PATH,26,1621.073,303.8107,-62.17767,0,0,0,0,100,0), +(@PATH,27,1597.038,305.6069,-62.17767,0,0,0,0,100,0), +(@PATH,28,1570.288,304.0811,-62.1791,0,0,0,0,100,0), +(@PATH,29,1548.99,291.5624,-62.18161,0,0,0,0,100,0), +(@PATH,30,1531.857,264.7233,-62.17787,0,0,0,0,100,0), +(@PATH,31,1528.448,242.5587,-62.17784,0,0,0,0,100,0), +(@PATH,32,1529.805,219.432,-62.17819,0,0,0,0,100,0), +(@PATH,33,1535.449,201.8574,-62.17985,0,0,0,0,100,0), +(@PATH,34,1553.841,200.0119,-60.77375,0,0,0,0,100,0), +(@PATH,35,1567.785,213.0403,-60.01043,0,0,0,0,100,0); + +-- Pathing for Dark Ranger Anya Entry: 36225 Aura 131700 missing from core +SET @NPC := 326869; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1591.848,`position_y`=169.0581,`position_z`=-62.17767 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,258,0, '18950'); +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,1591.848,169.0581,-62.17767,0,0,0,0,100,0), +(@PATH,2,1559.896,187.3829,-62.18038,0,0,0,0,100,0), +(@PATH,3,1557.058,191.5276,-62.18165,0,0,0,0,100,0), +(@PATH,4,1555.87,199.8094,-60.77327,0,0,0,0,100,0), +(@PATH,5,1556.872,201.8134,-60.77645,0,0,0,0,100,0), +(@PATH,6,1565.772,211.0227,-60.69691,0,0,0,0,100,0), +(@PATH,7,1579.981,224.1431,-61.90992,0,0,0,0,100,0), +(@PATH,8,1584.61,223.5555,-62.0985,0,0,0,0,100,0), +(@PATH,9,1592.897,220.5184,-57.16179,0,0,0,0,100,0), +(@PATH,10,1595.588,223.0015,-57.1618,0,0,0,0,100,0), +(@PATH,11,1595.533,230.76,-52.15371,0,0,0,0,100,0), +(@PATH,12,1593.387,232.0359,-52.15043,0,0,0,0,100,0), +(@PATH,13,1588.193,232.273,-52.15138,0,0,0,0,100,0), +(@PATH,14,1586.203,245.9066,-52.15466,0,0,0,0,100,0), +(@PATH,15,1586.99,247.5207,-52.15326,0,0,0,0,100,0), +(@PATH,16,1589.372,248.5877,-52.15402,0,0,0,0,100,0), +(@PATH,17,1601.85,248.9071,-52.14974,0,0,0,0,100,0), +(@PATH,18,1604.069,246.4827,-52.15089,0,0,0,0,100,0), +(@PATH,19,1606.339,242.3287,-52.15271,0,0,0,0,100,0), +(@PATH,20,1607.957,240.8379,-52.15721,0,0,0,0,100,0), +(@PATH,21,1629.973,239.2152,-43.10275,0,0,0,0,100,0), +(@PATH,22,1632.032,236.4269,-43.10271,0,0,0,0,100,0), +(@PATH,23,1632.445,233.7568,-43.10271,0,0,0,0,100,0), +(@PATH,24,1629.101,223.9509,-43.10285,0,0,0,0,100,0), +(@PATH,25,1612.131,206.9309,-43.10272,0,0,0,0,100,0), +(@PATH,26,1609.539,205.5861,-43.10281,0,0,0,0,100,0), +(@PATH,27,1597.743,203.6275,-43.10272,0,0,0,0,100,0), +(@PATH,28,1594.194,203.8103,-43.10271,0,0,0,0,100,0), +(@PATH,29,1582.785,205.5456,-43.10271,0,0,0,0,100,0), +(@PATH,30,1578.919,207.3404,-43.10276,0,0,0,0,100,0), +(@PATH,31,1562.383,223.9282,-43.10272,0,0,0,0,100,0), +(@PATH,32,1560.665,227.6953,-43.10272,0,0,0,0,100,0), +(@PATH,33,1559.218,236.039,-43.10272,0,0,0,0,100,0), +(@PATH,34,1561.987,239.8349,-43.17983,0,0,0,0,100,0), +(@PATH,35,1567.898,240.1943,-44.16556,0,0,0,0,100,0), +(@PATH,36,1583.315,240.6951,-52.15679,0,0,0,0,100,0), +(@PATH,37,1584.639,242.7373,-52.15596,0,0,0,0,100,0), +(@PATH,38,1585.509,247.5295,-52.15108,0,0,0,0,100,0), +(@PATH,39,1587.016,248.8708,-52.14987,0,0,0,0,100,0), +(@PATH,40,1594.048,249.3781,-52.15247,0,0,0,0,100,0), +(@PATH,41,1595.588,250.3003,-52.15758,0,0,0,0,100,0), +(@PATH,42,1596.237,258.3997,-57.16174,0,0,0,0,100,0), +(@PATH,43,1595.332,259.6997,-57.16173,0,0,0,0,100,0), +(@PATH,44,1583.506,256.2311,-62.09221,0,0,0,0,100,0), +(@PATH,45,1581.18,256.7343,-61.90619,0,0,0,0,100,0), +(@PATH,46,1565.844,270.0585,-60.69888,0,0,0,0,100,0), +(@PATH,47,1554.069,279.5327,-60.77287,0,0,0,0,100,0), +(@PATH,48,1550.043,280.6547,-60.79443,0,0,0,0,100,0), +(@PATH,49,1545.798,278.7816,-62.18132,0,0,0,0,100,0), +(@PATH,50,1521.743,246.2183,-62.17776,0,0,0,0,100,0), +(@PATH,51,1518.757,244.4442,-62.17779,0,0,0,0,100,0), +(@PATH,52,1481.713,240.1816,-62.17767,0,0,0,0,100,0), +(@PATH,53,1463.974,233.8326,-62.17767,0,0,0,0,100,0), +(@PATH,54,1462.324,230.5938,-62.17767,0,0,0,0,100,0), +(@PATH,55,1461.742,216.1824,-62.17767,0,0,0,0,100,0), +(@PATH,56,1464.133,199.7708,-62.17709,0,0,0,0,100,0), +(@PATH,57,1467.824,183.4344,-62.18068,0,0,0,0,100,0), +(@PATH,58,1472.803,173.5824,-57.15204,0,0,0,0,100,0), +(@PATH,59,1472.375,170.3603,-57.01588,0,0,0,0,100,0), +(@PATH,60,1460.744,164.0948,-51.05501,0,0,0,0,100,0), +(@PATH,61,1445.084,153.4704,-57.15282,0,0,0,0,100,0), +(@PATH,62,1444.569,152.0651,-57.15311,0,0,0,0,100,0), +(@PATH,63,1449.093,141.9922,-62.244,0,0,0,0,100,0), +(@PATH,64,1447.065,138.7384,-62.2677,0,0,0,0,100,0), +(@PATH,65,1425.409,134.6217,-62.29085,0,0,0,0,100,0), +(@PATH,66,1423.454,133.419,-62.29101,0,0,0,0,100,0), +(@PATH,67,1422.167,131.2488,-62.29133,0,0,0,0,100,0), +(@PATH,68,1412.971,94.48728,-62.2825,0,0,0,0,100,0), +(@PATH,69,1412.178,68.96647,-62.27882,0,0,0,0,100,0), +(@PATH,70,1410.143,66.97049,-62.27882,0,0,0,0,100,0), +(@PATH,71,1406.183,66.34741,-62.27882,0,0,0,0,100,0), +(@PATH,72,1391.262,67.51823,-62.2783,0,0,0,0,100,0), +(@PATH,73,1389.797,67.17128,-62.27804,0,0,0,0,100,0), +(@PATH,74,1387.45,65.16596,-62.27771,0,0,0,0,100,0), +(@PATH,75,1379.324,50.87375,-62.27658,0,0,0,0,100,0), +(@PATH,76,1383.912,58.94359,-62.2774,0,0,0,0,100,0), +(@PATH,77,1379.324,50.87375,-62.27658,0,0,0,0,100,0), +(@PATH,78,1379.427,48.54769,-62.27615,0,0,0,0,100,0), +(@PATH,79,1408.113,26.90218,-62.27695,0,0,0,0,100,0), +(@PATH,80,1412.155,26.69325,-62.27701,0,0,0,0,100,0), +(@PATH,81,1434.355,33.64345,-62.2767,0,0,0,0,100,0), +(@PATH,82,1438.174,36.53374,-62.27955,0,0,0,0,100,0), +(@PATH,83,1439.616,38.71452,-62.28041,0,0,0,0,100,0), +(@PATH,84,1446.229,64.73573,-62.28183,0,0,0,0,100,0), +(@PATH,85,1445.816,67.92562,-62.28107,0,0,0,0,100,0), +(@PATH,86,1444.844,70.1582,-62.28027,0,0,0,0,100,0), +(@PATH,87,1418.58,101.1985,-62.28262,0,0,0,0,100,0), +(@PATH,88,1404.943,119.9008,-62.29325,0,0,0,0,100,0), +(@PATH,89,1403.924,122.0021,-62.29424,0,0,0,0,100,0), +(@PATH,90,1403.861,125.2423,-62.30313,0,0,0,0,100,0), +(@PATH,91,1405.325,127.165,-62.29943,0,0,0,0,100,0), +(@PATH,92,1426.191,154.123,-62.28902,0,0,0,0,100,0), +(@PATH,93,1427.121,155.6431,-62.28835,0,0,0,0,100,0), +(@PATH,94,1431.452,165.7858,-62.29967,0,0,0,0,100,0), +(@PATH,95,1432.495,167.5201,-62.28262,0,0,0,0,100,0), +(@PATH,96,1434.476,167.211,-62.29101,0,0,0,0,100,0), +(@PATH,97,1442.106,155.511,-57.15324,0,0,0,0,100,0), +(@PATH,98,1445.739,154.9486,-56.83205,0,0,0,0,100,0), +(@PATH,99,1458.042,161.8466,-50.94152,0,0,0,0,100,0), +(@PATH,100,1473.62,171.051,-57.15204,0,0,0,0,100,0), +(@PATH,101,1473.786,174.2765,-57.15204,0,0,0,0,100,0), +(@PATH,102,1469.005,183.0757,-62.18139,0,0,0,0,100,0), +(@PATH,103,1469.258,185.4509,-62.18149,0,0,0,0,100,0), +(@PATH,104,1472.276,187.6451,-62.18763,0,0,0,0,100,0), +(@PATH,105,1477.591,188.1393,-62.19532,0,0,0,0,100,0), +(@PATH,106,1480.276,187.1101,-62.19708,0,0,0,0,100,0), +(@PATH,107,1481.359,185.9169,-62.19698,0,0,0,0,100,0), +(@PATH,108,1486.357,184.4406,-62.18638,0,0,0,0,100,0), +(@PATH,109,1489.255,187.5985,-62.17397,0,0,0,0,100,0), +(@PATH,110,1490.054,195.6768,-62.16235,0,0,0,0,100,0), +(@PATH,111,1490.643,198.2233,-62.15766,0,0,0,0,100,0), +(@PATH,112,1491.724,199.428,-62.15301,0,0,0,0,100,0), +(@PATH,113,1493.565,198.719,-62.14822,0,0,0,0,100,0), +(@PATH,114,1506.335,175.3599,-62.16339,0,0,0,0,100,0), +(@PATH,115,1518.162,159.0233,-62.15652,0,0,0,0,100,0), +(@PATH,116,1541.176,141.8635,-62.17168,0,0,0,0,100,0), +(@PATH,117,1541.043,137.0827,-62.17168,0,0,0,0,100,0), +(@PATH,118,1535.092,126.9977,-61.52596,0,0,0,0,100,0), +(@PATH,119,1536.23,123.4622,-61.51152,0,0,0,0,100,0), +(@PATH,120,1544.681,113.2477,-62.16837,0,0,0,0,100,0), +(@PATH,121,1547.049,111.8176,-62.16726,0,0,0,0,100,0), +(@PATH,122,1581.209,104.5857,-62.17767,0,0,0,0,100,0), +(@PATH,123,1583.091,105.6061,-62.17767,0,0,0,0,100,0), +(@PATH,124,1593.626,126.2137,-62.17767,0,0,0,0,100,0), +(@PATH,125,1594.315,130.5811,-62.17767,0,0,0,0,100,0), +(@PATH,126,1594.488,165.4759,-62.17767,0,0,0,0,100,0); + +-- Pathing for Dark Ranger Clea Entry: 36224 Aura 131700 missing from core +SET @NPC := 326201; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1596.72,`position_y`=319.1431,`position_z`=-62.17767 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,258,0, '18950'); +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,1596.72,319.1431,-62.17767,0,0,0,0,100,0), +(@PATH,2,1599.777,311.6949,-62.17767,0,0,0,0,100,0), +(@PATH,3,1630.804,295.7702,-62.17767,0,0,0,0,100,0), +(@PATH,4,1636.08,284.0114,-60.77172,0,0,0,0,100,0), +(@PATH,5,1633.37,278.824,-60.77434,0,0,0,0,100,0), +(@PATH,6,1611.436,256.5937,-61.91058,0,0,0,0,100,0), +(@PATH,7,1608.648,256.3188,-62.09788,0,0,0,0,100,0), +(@PATH,8,1598.78,259.9653,-57.16177,0,0,0,0,100,0), +(@PATH,9,1596.853,259.1426,-57.16176,0,0,0,0,100,0), +(@PATH,10,1595.788,257.0236,-56.97906,0,0,0,0,100,0), +(@PATH,11,1595.769,249.5131,-52.15273,0,0,0,0,100,0), +(@PATH,12,1603.438,249.1752,-52.14993,0,0,0,0,100,0), +(@PATH,13,1605.078,247.345,-52.1517,0,0,0,0,100,0), +(@PATH,14,1606.015,242.4335,-52.15181,0,0,0,0,100,0), +(@PATH,15,1630.534,240.4442,-43.10271,0,0,0,0,100,0), +(@PATH,16,1632.885,243.0049,-43.10271,0,0,0,0,100,0), +(@PATH,17,1632.595,249.767,-43.10271,0,0,0,0,100,0), +(@PATH,18,1631.348,254.0865,-43.10271,0,0,0,0,100,0), +(@PATH,19,1612.677,274.2907,-43.10272,0,0,0,0,100,0), +(@PATH,20,1606.971,276.3227,-43.10272,0,0,0,0,100,0), +(@PATH,21,1586.306,276.4096,-43.10272,0,0,0,0,100,0), +(@PATH,22,1580.767,274.9485,-43.10282,0,0,0,0,100,0), +(@PATH,23,1563.419,257.5845,-43.10272,0,0,0,0,100,0), +(@PATH,24,1560.005,251.9638,-43.10272,0,0,0,0,100,0), +(@PATH,25,1558.889,241.3186,-43.10272,0,0,0,0,100,0), +(@PATH,26,1559.385,231.3017,-43.10272,0,0,0,0,100,0), +(@PATH,27,1561.175,225.6089,-43.10272,0,0,0,0,100,0), +(@PATH,28,1578.664,206.9777,-43.10275,0,0,0,0,100,0), +(@PATH,29,1585.731,204.5607,-43.10271,0,0,0,0,100,0), +(@PATH,30,1605.467,204.0483,-43.10271,0,0,0,0,100,0), +(@PATH,31,1611.46,206.0352,-43.10282,0,0,0,0,100,0), +(@PATH,32,1629.382,223.7811,-43.10286,0,0,0,0,100,0), +(@PATH,33,1633.148,233.4342,-43.10271,0,0,0,0,100,0), +(@PATH,34,1630.568,236.9336,-43.10271,0,0,0,0,100,0), +(@PATH,35,1607.126,238.8718,-52.15495,0,0,0,0,100,0), +(@PATH,36,1605.703,237.4906,-52.15111,0,0,0,0,100,0), +(@PATH,37,1603.532,232.5689,-52.151,0,0,0,0,100,0), +(@PATH,38,1596.857,231.5195,-52.1516,0,0,0,0,100,0), +(@PATH,39,1595.804,230.2294,-52.15877,0,0,0,0,100,0), +(@PATH,40,1596.119,220.6832,-57.16177,0,0,0,0,100,0), +(@PATH,41,1598.207,220.2113,-57.16178,0,0,0,0,100,0), +(@PATH,42,1606.565,223.6164,-62.108,0,0,0,0,100,0), +(@PATH,43,1625.298,210.0929,-60.7001,0,0,0,0,100,0), +(@PATH,44,1639.942,197.8281,-60.77018,0,0,0,0,100,0), +(@PATH,45,1647.45,200.8475,-62.17965,0,0,0,0,100,0), +(@PATH,46,1667.022,234.6901,-62.17767,0,0,0,0,100,0), +(@PATH,47,1675.597,239.0004,-62.17767,0,0,0,0,100,0), +(@PATH,48,1723.016,239.116,-62.17767,0,0,0,0,100,0), +(@PATH,49,1727.486,241.2093,-62.17767,0,0,0,0,100,0), +(@PATH,50,1729.365,267.5403,-62.17767,0,0,0,0,100,0), +(@PATH,51,1723.585,290.4409,-62.1795,0,0,0,0,100,0), +(@PATH,52,1720.117,305.2959,-61.47769,0,0,0,0,100,0), +(@PATH,53,1718.494,309.0411,-61.47762,0,0,0,0,100,0), +(@PATH,54,1706.621,324.0278,-55.39243,0,0,0,0,100,0), +(@PATH,55,1707.659,325.9294,-55.39243,0,0,0,0,100,0), +(@PATH,56,1720.192,335.4403,-49.14024,0,0,0,0,100,0), +(@PATH,57,1734.865,346.2286,-55.3935,0,0,0,0,100,0), +(@PATH,58,1737.21,345.446,-55.39387,0,0,0,0,100,0), +(@PATH,59,1744.15,336.7069,-60.48443,0,0,0,0,100,0), +(@PATH,60,1745.905,336.5825,-60.48442,0,0,0,0,100,0), +(@PATH,61,1773.952,346.5651,-62.32407,0,0,0,0,100,0), +(@PATH,62,1786.241,357.1428,-61.96072,0,0,0,0,100,0), +(@PATH,63,1792.518,369.8833,-60.15903,0,0,0,0,100,0), +(@PATH,64,1792.492,374.1188,-60.15905,0,0,0,0,100,0), +(@PATH,65,1787.485,395.0693,-57.21076,0,0,0,0,100,0), +(@PATH,66,1789.015,398.8071,-57.21189,0,0,0,0,100,0), +(@PATH,67,1788.912,404.6029,-57.21257,0,0,0,0,100,0), +(@PATH,68,1783.725,410.248,-57.19911,0,0,0,0,100,0), +(@PATH,69,1776.076,418.3867,-58.03101,0,0,0,0,100,0), +(@PATH,70,1761.857,432.2151,-57.21456,0,0,0,0,100,0), +(@PATH,71,1758.747,431.9061,-57.21456,0,0,0,0,100,0), +(@PATH,72,1754.99,427.7975,-57.21455,0,0,0,0,100,0), +(@PATH,73,1752.367,415.7229,-57.21455,0,0,0,0,100,0), +(@PATH,74,1755.393,404.2359,-57.21456,0,0,0,0,100,0), +(@PATH,75,1761.858,397.9333,-57.21455,0,0,0,0,100,0), +(@PATH,76,1775.76,395.2629,-57.21456,0,0,0,0,100,0), +(@PATH,77,1783.611,394.9522,-57.21128,0,0,0,0,100,0), +(@PATH,78,1794.375,372.6804,-60.15904,0,0,0,0,100,0), +(@PATH,79,1793.938,370.862,-60.15904,0,0,0,0,100,0), +(@PATH,80,1779.703,349.0509,-62.35542,0,0,0,0,100,0), +(@PATH,81,1757.668,332.6843,-62.28579,0,0,0,0,100,0), +(@PATH,82,1755.163,332.6872,-62.2956,0,0,0,0,100,0), +(@PATH,83,1744.679,335.3011,-60.48439,0,0,0,0,100,0), +(@PATH,84,1743.307,336.3504,-60.48442,0,0,0,0,100,0), +(@PATH,85,1736.581,344.3666,-55.39356,0,0,0,0,100,0), +(@PATH,86,1720.657,334.8886,-49.1374,0,0,0,0,100,0), +(@PATH,87,1708.503,323.9943,-55.39243,0,0,0,0,100,0), +(@PATH,88,1708.301,322.0377,-55.39243,0,0,0,0,100,0), +(@PATH,89,1714.446,313.474,-60.48399,0,0,0,0,100,0), +(@PATH,90,1704.675,296.5861,-62.17385,0,0,0,0,100,0), +(@PATH,91,1703.603,293.716,-62.16593,0,0,0,0,100,0), +(@PATH,92,1703.467,283.3416,-62.16315,0,0,0,0,100,0), +(@PATH,93,1702.132,279.9407,-62.16033,0,0,0,0,100,0), +(@PATH,94,1698.638,280.802,-62.14895,0,0,0,0,100,0), +(@PATH,95,1697.217,284.9091,-62.15378,0,0,0,0,100,0), +(@PATH,96,1701.107,293.6302,-62.16061,0,0,0,0,100,0), +(@PATH,97,1700.357,296.7271,-62.16523,0,0,0,0,100,0), +(@PATH,98,1690.123,309.3857,-62.1693,0,0,0,0,100,0), +(@PATH,99,1668.72,328.7574,-62.15711,0,0,0,0,100,0), +(@PATH,100,1640.502,340.7791,-62.17133,0,0,0,0,100,0), +(@PATH,101,1636.327,344.5663,-62.16944,0,0,0,0,100,0), +(@PATH,102,1637.511,347.0346,-62.17056,0,0,0,0,100,0), +(@PATH,103,1642.676,346.8737,-62.17405,0,0,0,0,100,0), +(@PATH,104,1649.723,344.3992,-62.17472,0,0,0,0,100,0), +(@PATH,105,1653.708,346.0358,-62.17622,0,0,0,0,100,0), +(@PATH,106,1658.568,355.8368,-60.73808,0,0,0,0,100,0), +(@PATH,107,1656.858,359.7296,-60.75586,0,0,0,0,100,0), +(@PATH,108,1638.04,370.0992,-62.17554,0,0,0,0,100,0), +(@PATH,109,1611.813,375.1517,-62.17767,0,0,0,0,100,0), +(@PATH,110,1572.169,374.0063,-62.17767,0,0,0,0,100,0), +(@PATH,111,1551.991,369.2471,-62.17968,0,0,0,0,100,0), +(@PATH,112,1544.057,358.6568,-62.19508,0,0,0,0,100,0), +(@PATH,113,1538.388,348.9066,-62.18298,0,0,0,0,100,0), +(@PATH,114,1552.08,348.6122,-62.16525,0,0,0,0,100,0), +(@PATH,115,1557.466,348.2967,-62.15907,0,0,0,0,100,0), +(@PATH,116,1557.966,345.033,-62.15004,0,0,0,0,100,0), +(@PATH,117,1551.411,341.4445,-62.14769,0,0,0,0,100,0), +(@PATH,118,1533.871,335.0199,-62.15543,0,0,0,0,100,0), +(@PATH,119,1510.63,312.5807,-62.15595,0,0,0,0,100,0), +(@PATH,120,1498.7,297.3567,-62.17167,0,0,0,0,100,0), +(@PATH,121,1493.616,284.4332,-62.17167,0,0,0,0,100,0), +(@PATH,122,1490.81,281.0601,-62.16547,0,0,0,0,100,0), +(@PATH,123,1488.552,281.7254,-62.16162,0,0,0,0,100,0), +(@PATH,124,1490.047,297.7319,-62.17167,0,0,0,0,100,0), +(@PATH,125,1486.55,310.1917,-61.49567,0,0,0,0,100,0), +(@PATH,126,1488.01,319.712,-60.78883,0,0,0,0,100,0), +(@PATH,127,1500.952,335.121,-60.08852,0,0,0,0,100,0), +(@PATH,128,1513.509,345.5368,-60.08961,0,0,0,0,100,0), +(@PATH,129,1534.205,356.9025,-61.49869,0,0,0,0,100,0), +(@PATH,130,1554.556,368.3122,-62.18004,0,0,0,0,100,0), +(@PATH,131,1571.416,375.1871,-62.17767,0,0,0,0,100,0), +(@PATH,132,1585.837,377.7647,-62.17767,0,0,0,0,100,0), +(@PATH,133,1592.033,370.8737,-62.17767,0,0,0,0,100,0), +(@PATH,134,1597.092,347.085,-62.17767,0,0,0,0,100,0); + +-- Pathing for Dark Ranger Cyndia Entry: 36226 Aura 131700 missing from core +SET @NPC := 326565; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1665.397,`position_y`=249.8512,`position_z`=-62.17807 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,258,0, '18950'); +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,1665.397,249.8512,-62.17807,0,0,0,0,100,0), +(@PATH,2,1658.122,270.6968,-62.17899,0,0,0,0,100,0), +(@PATH,3,1655.739,273.1317,-62.17939,0,0,0,0,100,0), +(@PATH,4,1640.921,281.1269,-60.7705,0,0,0,0,100,0), +(@PATH,5,1637.546,279.3629,-60.77472,0,0,0,0,100,0), +(@PATH,6,1620.187,263.8601,-58.93944,0,0,0,0,100,0), +(@PATH,7,1610.994,255.7129,-61.90979,0,0,0,0,100,0), +(@PATH,8,1607.457,253.6334,-62.09666,0,0,0,0,100,0), +(@PATH,9,1596.368,252.8378,-62.09339,0,0,0,0,100,0), +(@PATH,10,1584.992,252.5535,-62.0893,0,0,0,0,100,0), +(@PATH,11,1584.345,225.8762,-62.09585,0,0,0,0,100,0), +(@PATH,12,1585.527,222.9704,-62.14028,0,0,0,0,100,0), +(@PATH,13,1593.445,221.0577,-57.16179,0,0,0,0,100,0), +(@PATH,14,1595.081,221.8444,-57.16179,0,0,0,0,100,0), +(@PATH,15,1594.693,230.7454,-52.15377,0,0,0,0,100,0), +(@PATH,16,1593.629,231.9807,-52.1506,0,0,0,0,100,0), +(@PATH,17,1589.602,231.8067,-52.15155,0,0,0,0,100,0), +(@PATH,18,1588.036,232.0646,-52.15156,0,0,0,0,100,0), +(@PATH,19,1586.876,246.49,-52.1549,0,0,0,0,100,0), +(@PATH,20,1590.811,248.5337,-52.15467,0,0,0,0,100,0), +(@PATH,21,1602.723,248.4079,-52.15023,0,0,0,0,100,0), +(@PATH,22,1604.857,247.4054,-52.15158,0,0,0,0,100,0), +(@PATH,23,1606.502,241.8904,-52.15316,0,0,0,0,100,0), +(@PATH,24,1630.692,241.3403,-43.10271,0,0,0,0,100,0), +(@PATH,25,1632.833,242.5227,-43.10271,0,0,0,0,100,0), +(@PATH,26,1632.958,245.9545,-43.10271,0,0,0,0,100,0), +(@PATH,27,1631.514,254.8911,-43.10271,0,0,0,0,100,0), +(@PATH,28,1613.102,273.4337,-43.10272,0,0,0,0,100,0), +(@PATH,29,1605.617,276.5178,-43.10272,0,0,0,0,100,0), +(@PATH,30,1586.844,276.654,-43.10272,0,0,0,0,100,0), +(@PATH,31,1578.671,274.2467,-43.10285,0,0,0,0,100,0), +(@PATH,32,1562.308,257.007,-43.10272,0,0,0,0,100,0), +(@PATH,33,1558.667,246.7306,-43.10272,0,0,0,0,100,0), +(@PATH,34,1559.34,229.6207,-43.10272,0,0,0,0,100,0), +(@PATH,35,1562.744,222.9461,-43.10272,0,0,0,0,100,0), +(@PATH,36,1578.147,207.4494,-43.10277,0,0,0,0,100,0), +(@PATH,37,1586.199,204.7502,-43.10271,0,0,0,0,100,0), +(@PATH,38,1604.896,204.7057,-43.10271,0,0,0,0,100,0), +(@PATH,39,1611.628,206.9705,-43.10286,0,0,0,0,100,0), +(@PATH,40,1628.336,223.248,-43.10284,0,0,0,0,100,0), +(@PATH,41,1631.788,229.7821,-43.10272,0,0,0,0,100,0), +(@PATH,42,1632.781,236.3841,-43.10271,0,0,0,0,100,0), +(@PATH,43,1630.619,237.216,-43.10271,0,0,0,0,100,0), +(@PATH,44,1607.801,239.1756,-52.15681,0,0,0,0,100,0), +(@PATH,45,1606.174,237.9438,-52.15234,0,0,0,0,100,0), +(@PATH,46,1604.563,233.8241,-52.15132,0,0,0,0,100,0), +(@PATH,47,1602.063,231.8929,-52.14881,0,0,0,0,100,0), +(@PATH,48,1596.986,231.8843,-52.1506,0,0,0,0,100,0), +(@PATH,49,1596.111,230.5926,-52.15416,0,0,0,0,100,0), +(@PATH,50,1596.206,221.5799,-57.16178,0,0,0,0,100,0), +(@PATH,51,1598.098,220.4209,-57.16178,0,0,0,0,100,0), +(@PATH,52,1606.623,223.471,-62.10796,0,0,0,0,100,0), +(@PATH,53,1609.261,223.3245,-61.90319,0,0,0,0,100,0), +(@PATH,54,1617.092,218.687,-59.24622,0,0,0,0,100,0), +(@PATH,55,1631.553,204.2361,-60.77629,0,0,0,0,100,0), +(@PATH,56,1640.147,200.0196,-60.77184,0,0,0,0,100,0), +(@PATH,57,1655.092,207.0599,-62.17844,0,0,0,0,100,0), +(@PATH,58,1668.467,234.7804,-62.17767,0,0,0,0,100,0), +(@PATH,59,1680.321,239.2071,-62.17767,0,0,0,0,100,0), +(@PATH,60,1723.507,240.4131,-62.17767,0,0,0,0,100,0), +(@PATH,61,1730.388,230.8118,-62.17767,0,0,0,0,100,0), +(@PATH,62,1728.824,211.1376,-62.17767,0,0,0,0,100,0), +(@PATH,63,1724.623,196.0272,-62.16748,0,0,0,0,100,0), +(@PATH,64,1718.686,184.9052,-60.76291,0,0,0,0,100,0), +(@PATH,65,1709.365,179.0808,-60.72816,0,0,0,0,100,0), +(@PATH,66,1701.335,182.7318,-62.16925,0,0,0,0,100,0), +(@PATH,67,1702.611,194.2011,-62.17167,0,0,0,0,100,0), +(@PATH,68,1698.507,195.957,-62.17233,0,0,0,0,100,0), +(@PATH,69,1692.651,187.9991,-62.17444,0,0,0,0,100,0), +(@PATH,70,1679.004,162.3927,-62.16057,0,0,0,0,100,0), +(@PATH,71,1649.448,142.4823,-62.14778,0,0,0,0,100,0), +(@PATH,72,1637.988,136.5618,-62.15304,0,0,0,0,100,0), +(@PATH,73,1639.086,132.6971,-62.16467,0,0,0,0,100,0), +(@PATH,74,1650.699,134.7776,-62.17007,0,0,0,0,100,0), +(@PATH,75,1667.648,127.9414,-61.48425,0,0,0,0,100,0), +(@PATH,76,1682.416,130.8727,-60.45719,0,0,0,0,100,0), +(@PATH,77,1690.934,138.4989,-55.21449,0,0,0,0,100,0), +(@PATH,78,1704.904,128.4098,-49.00898,0,0,0,0,100,0), +(@PATH,79,1716.952,114.9741,-55.21538,0,0,0,0,100,0), +(@PATH,80,1717.12,112.6673,-55.21583,0,0,0,0,100,0), +(@PATH,81,1709.333,104.537,-60.18874,0,0,0,0,100,0), +(@PATH,82,1696.452,91.29698,-62.23086,0,0,0,0,100,0), +(@PATH,83,1695.932,86.82401,-62.27069,0,0,0,0,100,0), +(@PATH,84,1702.338,70.93913,-62.29089,0,0,0,0,100,0), +(@PATH,85,1709.622,68.14681,-62.28885,0,0,0,0,100,0), +(@PATH,86,1738.57,59.20063,-59.572,0,0,0,0,100,0), +(@PATH,87,1749.862,49.09429,-52.81699,0,0,0,0,100,0), +(@PATH,88,1753.905,47.71148,-52.81699,0,0,0,0,100,0), +(@PATH,89,1766.786,58.51758,-46.32099,0,0,0,0,100,0), +(@PATH,90,1778.527,70.24653,-46.31701,0,0,0,0,100,0), +(@PATH,91,1786.401,78.94379,-52.817,0,0,0,0,100,0), +(@PATH,92,1786.197,83.47396,-52.81699,0,0,0,0,100,0), +(@PATH,93,1772.827,97.08453,-60.60096,0,0,0,0,100,0), +(@PATH,94,1770.96,104.3613,-62.27315,0,0,0,0,100,0), +(@PATH,95,1756.442,136.9941,-62.29827,0,0,0,0,100,0), +(@PATH,96,1750.686,140.2855,-62.25806,0,0,0,0,100,0), +(@PATH,97,1742.041,136.3015,-62.21549,0,0,0,0,100,0), +(@PATH,98,1729.465,125.0361,-60.31836,0,0,0,0,100,0), +(@PATH,99,1720.631,116.7737,-55.21572,0,0,0,0,100,0), +(@PATH,100,1718.348,117.2919,-55.21521,0,0,0,0,100,0), +(@PATH,101,1705.41,129.5553,-49.04819,0,0,0,0,100,0), +(@PATH,102,1694.899,140.4262,-55.21449,0,0,0,0,100,0), +(@PATH,103,1702.094,150.2608,-60.46441,0,0,0,0,100,0), +(@PATH,104,1702.372,152.2507,-60.45676,0,0,0,0,100,0), +(@PATH,105,1700.79,156.0513,-60.44584,0,0,0,0,100,0), +(@PATH,106,1712.581,176.1745,-60.75151,0,0,0,0,100,0), +(@PATH,107,1724.331,198.7045,-62.17286,0,0,0,0,100,0), +(@PATH,108,1730.761,214.786,-62.17767,0,0,0,0,100,0), +(@PATH,109,1732.083,228.0609,-62.17767,0,0,0,0,100,0), +(@PATH,110,1720.836,236.7267,-62.17767,0,0,0,0,100,0), +(@PATH,111,1675.712,241.5041,-62.17767,0,0,0,0,100,0), +(@PATH,112,1666.813,247.8042,-62.17786,0,0,0,0,100,0); + +-- Pathing for Kraxx Entry: 23713 +SET @NPC := 326531; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1565.532,`position_y`=269.0778,`position_z`=-60.69402 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,257,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,1565.532,269.0778,-60.69402,0,0,0,0,100,0), +(@PATH,2,1568.664,265.4527,-59.45133,0,0,0,0,100,0), +(@PATH,3,1573.283,260.4738,-59.29987,0,0,0,0,100,0), +(@PATH,4,1576.911,256.3331,-61.35997,0,0,0,0,100,0), +(@PATH,5,1579.964,255.3982,-61.91048,0,0,0,0,100,0), +(@PATH,6,1583.599,256.0135,-62.09205,0,0,0,0,100,0), +(@PATH,7,1586.945,257.5155,-61.42945,0,0,0,0,100,0), +(@PATH,8,1589.174,258.3727,-59.63884,0,0,0,0,100,0), +(@PATH,9,1593.715,259.7916,-57.16173,0,0,0,0,100,0), +(@PATH,10,1596.377,257.6372,-57.16175,0,0,0,0,100,0), +(@PATH,11,1595.66,252.6091,-53.6674,0,0,0,0,100,0), +(@PATH,12,1596.051,249.318,-52.1522,0,0,0,0,100,0), +(@PATH,13,1589.189,248.8007,-52.15321,0,0,0,0,100,0), +(@PATH,14,1585.727,245.9161,-52.15499,0,0,0,0,100,0), +(@PATH,15,1584.436,242.4003,-52.15607,0,0,0,0,100,0), +(@PATH,16,1579.16,241.3689,-49.83312,0,0,0,0,100,0), +(@PATH,17,1569.922,242.1324,-44.93344,0,0,0,0,100,0), +(@PATH,18,1563.141,243.8946,-43.33252,0,0,0,0,100,0), +(@PATH,19,1559.196,247.9663,-43.10272,0,0,0,0,100,0), +(@PATH,20,1561.46,256.7673,-43.10272,0,0,0,0,100,0), +(@PATH,21,1568.449,263.594,-43.10272,0,0,0,0,100,0), +(@PATH,22,1575.975,271.122,-43.10272,0,0,0,0,100,0), +(@PATH,23,1587.458,276.3201,-43.10272,0,0,0,0,100,0), +(@PATH,24,1601.59,275.179,-43.10272,0,0,0,0,100,0), +(@PATH,25,1611.949,274.5351,-43.10272,0,0,0,0,100,0), +(@PATH,26,1620.376,266.8541,-43.10272,0,0,0,0,100,0), +(@PATH,27,1628.551,255.4207,-43.10271,0,0,0,0,100,0), +(@PATH,28,1630.918,248.4954,-43.10271,0,0,0,0,100,0), +(@PATH,29,1631.487,231.2102,-43.10272,0,0,0,0,100,0), +(@PATH,30,1629.057,224.0072,-43.10284,0,0,0,0,100,0), +(@PATH,31,1621.784,216.4049,-43.10273,0,0,0,0,100,0), +(@PATH,32,1612.356,208.5639,-43.10272,0,0,0,0,100,0), +(@PATH,33,1599.454,204.7694,-43.10272,0,0,0,0,100,0), +(@PATH,34,1589.99,204.9367,-43.10271,0,0,0,0,100,0), +(@PATH,35,1579.58,207.3412,-43.10276,0,0,0,0,100,0), +(@PATH,36,1572.474,213.8005,-43.10272,0,0,0,0,100,0), +(@PATH,37,1563.911,223.0903,-43.10272,0,0,0,0,100,0), +(@PATH,38,1559.542,231.3453,-43.10272,0,0,0,0,100,0), +(@PATH,39,1558.181,239.5521,-43.10272,0,0,0,0,100,0), +(@PATH,40,1559.535,231.3589,-43.10272,0,0,0,0,100,0), +(@PATH,41,1563.911,223.0903,-43.10272,0,0,0,0,100,0), +(@PATH,42,1572.474,213.8005,-43.10272,0,0,0,0,100,0), +(@PATH,43,1579.58,207.3412,-43.10276,0,0,0,0,100,0), +(@PATH,44,1589.99,204.9367,-43.10271,0,0,0,0,100,0), +(@PATH,45,1599.454,204.7694,-43.10272,0,0,0,0,100,0), +(@PATH,46,1612.356,208.5639,-43.10272,0,0,0,0,100,0), +(@PATH,47,1621.784,216.4049,-43.10273,0,0,0,0,100,0), +(@PATH,48,1629.057,224.0072,-43.10284,0,0,0,0,100,0), +(@PATH,49,1631.487,231.2102,-43.10272,0,0,0,0,100,0), +(@PATH,50,1630.918,248.4954,-43.10271,0,0,0,0,100,0), +(@PATH,51,1628.551,255.4207,-43.10271,0,0,0,0,100,0), +(@PATH,52,1620.376,266.8541,-43.10272,0,0,0,0,100,0), +(@PATH,53,1611.949,274.5351,-43.10272,0,0,0,0,100,0), +(@PATH,54,1601.59,275.179,-43.10272,0,0,0,0,100,0), +(@PATH,55,1587.523,276.3148,-43.10272,0,0,0,0,100,0), +(@PATH,56,1575.975,271.122,-43.10272,0,0,0,0,100,0), +(@PATH,57,1568.449,263.594,-43.10272,0,0,0,0,100,0), +(@PATH,58,1561.46,256.7673,-43.10272,0,0,0,0,100,0), +(@PATH,59,1559.196,247.9663,-43.10272,0,0,0,0,100,0), +(@PATH,60,1563.141,243.8946,-43.33252,0,0,0,0,100,0), +(@PATH,61,1569.922,242.1324,-44.93344,0,0,0,0,100,0), +(@PATH,62,1579.16,241.3689,-49.83312,0,0,0,0,100,0), +(@PATH,63,1584.436,242.4003,-52.15607,0,0,0,0,100,0), +(@PATH,64,1585.727,245.9161,-52.15499,0,0,0,0,100,0), +(@PATH,65,1589.189,248.8007,-52.15321,0,0,0,0,100,0), +(@PATH,66,1596.051,249.318,-52.1522,0,0,0,0,100,0), +(@PATH,67,1595.645,252.5033,-53.58799,0,0,0,0,100,0), +(@PATH,68,1596.377,257.6372,-57.16175,0,0,0,0,100,0), +(@PATH,69,1593.801,259.8183,-57.16173,0,0,0,0,100,0), +(@PATH,70,1589.174,258.3727,-59.63884,0,0,0,0,100,0), +(@PATH,71,1586.945,257.5155,-61.42945,0,0,0,0,100,0), +(@PATH,72,1583.599,256.0135,-62.09205,0,0,0,0,100,0), +(@PATH,73,1579.964,255.3982,-61.91048,0,0,0,0,100,0), +(@PATH,74,1576.911,256.3331,-61.35997,0,0,0,0,100,0), +(@PATH,75,1573.332,260.4176,-59.31192,0,0,0,0,100,0), +(@PATH,76,1568.664,265.4527,-59.45133,0,0,0,0,100,0), +(@PATH,77,1565.532,269.0778,-60.69402,0,0,0,0,100,0), +(@PATH,78,1562.265,274.7531,-60.75778,0,0,0,0,100,0), +(@PATH,79,1558.997,279.9252,-60.77644,0,0,0,0,100,0), +(@PATH,80,1555.232,283.8405,-60.77249,0,0,0,0,100,0), +(@PATH,81,1546.767,277.976,-62.18118,0,0,0,0,100,0), +(@PATH,82,1542.865,271.8751,-62.17976,0,0,0,0,100,0), +(@PATH,83,1537.234,263.1361,-62.17771,0,0,0,0,100,0), +(@PATH,84,1536.037,255.27,-62.17767,0,0,0,0,100,0), +(@PATH,85,1535.316,247.9005,-62.17776,0,0,0,0,100,0), +(@PATH,86,1533.763,241.5542,-62.17786,0,0,0,0,100,0), +(@PATH,87,1532.851,234.1202,-62.17798,0,0,0,0,100,0), +(@PATH,88,1531.97,227.7858,-62.17788,0,0,0,0,100,0), +(@PATH,89,1530.081,215.5677,-62.17844,0,0,0,0,100,0), +(@PATH,90,1534.032,208.7355,-62.17929,0,0,0,0,100,0), +(@PATH,91,1539.645,204.4229,-62.18019,0,0,0,0,100,0), +(@PATH,92,1545.23,202.7187,-62.18094,0,0,0,0,100,0), +(@PATH,93,1550.394,203.1573,-60.77342,0,0,0,0,100,0), +(@PATH,94,1556.821,206.279,-60.77635,0,0,0,0,100,0), +(@PATH,95,1560.835,209.632,-60.74217,0,0,0,0,100,0), +(@PATH,96,1567.424,215.7635,-59.58194,0,0,0,0,100,0), +(@PATH,97,1573.73,221.6124,-59.68444,0,0,0,0,100,0), +(@PATH,98,1578.993,223.8769,-61.83548,0,0,0,0,100,0), +(@PATH,99,1583.837,224.6196,-62.09641,0,0,0,0,100,0), +(@PATH,100,1595.701,219.8233,-57.16176,0,0,0,0,100,0), +(@PATH,101,1595.651,225.8482,-55.28503,0,0,0,0,100,0), +(@PATH,102,1596.254,231.3204,-52.15216,0,0,0,0,100,0), +(@PATH,103,1605.352,230.99,-52.1525,0,0,0,0,100,0), +(@PATH,104,1607.17,235.047,-52.15261,0,0,0,0,100,0), +(@PATH,105,1607.144,240.5828,-52.15497,0,0,0,0,100,0), +(@PATH,106,1616.119,240.5933,-47.49268,0,0,0,0,100,0), +(@PATH,107,1624.231,239.4995,-43.88684,0,0,0,0,100,0), +(@PATH,108,1631.111,241.1891,-43.10271,0,0,0,0,100,0), +(@PATH,109,1624.301,239.49,-43.8772,0,0,0,0,100,0), +(@PATH,110,1616.119,240.5933,-47.49268,0,0,0,0,100,0), +(@PATH,111,1607.144,240.5828,-52.15497,0,0,0,0,100,0), +(@PATH,112,1607.17,235.047,-52.15261,0,0,0,0,100,0), +(@PATH,113,1605.352,230.99,-52.1525,0,0,0,0,100,0), +(@PATH,114,1596.254,231.3204,-52.15216,0,0,0,0,100,0), +(@PATH,115,1595.651,225.8482,-55.28503,0,0,0,0,100,0), +(@PATH,116,1595.701,219.8233,-57.16176,0,0,0,0,100,0), +(@PATH,117,1583.837,224.6196,-62.09641,0,0,0,0,100,0), +(@PATH,118,1578.993,223.8769,-61.83548,0,0,0,0,100,0), +(@PATH,119,1573.73,221.6124,-59.68444,0,0,0,0,100,0), +(@PATH,120,1567.424,215.7635,-59.58194,0,0,0,0,100,0), +(@PATH,121,1560.835,209.632,-60.74217,0,0,0,0,100,0), +(@PATH,122,1556.821,206.279,-60.77635,0,0,0,0,100,0), +(@PATH,123,1550.394,203.1573,-60.77342,0,0,0,0,100,0), +(@PATH,124,1545.23,202.7187,-62.18094,0,0,0,0,100,0), +(@PATH,125,1539.645,204.4229,-62.18019,0,0,0,0,100,0), +(@PATH,126,1534.032,208.7355,-62.17929,0,0,0,0,100,0), +(@PATH,127,1530.081,215.5677,-62.17844,0,0,0,0,100,0), +(@PATH,128,1531.97,227.7858,-62.17788,0,0,0,0,100,0), +(@PATH,129,1532.851,234.1202,-62.17798,0,0,0,0,100,0), +(@PATH,130,1533.763,241.5542,-62.17786,0,0,0,0,100,0), +(@PATH,131,1535.316,247.9005,-62.17776,0,0,0,0,100,0), +(@PATH,132,1536.037,255.27,-62.17767,0,0,0,0,100,0), +(@PATH,133,1537.234,263.1361,-62.17771,0,0,0,0,100,0), +(@PATH,134,1542.865,271.8751,-62.17976,0,0,0,0,100,0), +(@PATH,135,1546.767,277.976,-62.18118,0,0,0,0,100,0), +(@PATH,136,1555.232,283.8405,-60.77249,0,0,0,0,100,0), +(@PATH,137,1558.997,279.9252,-60.77644,0,0,0,0,100,0), +(@PATH,138,1562.265,274.7531,-60.75778,0,0,0,0,100,0); + +-- Pathing for Susan Tillinghast Entry: 2802 +SET @NPC := 326994; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1399.806,`position_y`=97.16917,`position_z`=-62.28725 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,257,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,1399.806,97.16917,-62.28725,0,0,0,0,100,0), +(@PATH,2,1417.964,141.0208,-62.2654,0,0,0,0,100,0), +(@PATH,3,1433.981,149.9107,-62.28839,0,0,0,0,100,0), +(@PATH,4,1447.694,137.1492,-62.25888,0,0,0,0,100,0), +(@PATH,5,1461.869,120.9715,-60.1887,0,0,0,0,100,0), +(@PATH,6,1464.949,111.2182,-60.19014,0,0,0,0,100,0), +(@PATH,7,1479.52,98.09299,-60.19035,0,0,0,0,100,0), +(@PATH,8,1484.867,94.61426,-62.22231,0,0,0,0,100,0), +(@PATH,9,1500.437,81.32889,-62.2982,0,0,0,0,100,0), +(@PATH,10,1481.725,47.70671,-62.29575,0,0,0,0,100,0), +(@PATH,11,1442.54,36.23264,-62.27947,0,0,0,0,100,0), +(@PATH,12,1416.399,21.24002,-62.27533,0,0,0,0,100,0), +(@PATH,13,1405.658,23.78299,-62.27602,0,0,0,0,100,0), +(@PATH,14,1387.197,36.69661,-62.27555,0,0,0,0,100,0), +(@PATH,15,1378.64,55.96495,-62.27652,0,0,0,0,100,0), +(@PATH,16,1383.241,83.3483,-62.27578,0,0,0,0,100,0); |