diff options
| -rw-r--r-- | sql/updates/world/master/2021_01_16_01_world_2017_10_28_00_world.sql | 619 |
1 files changed, 619 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_01_16_01_world_2017_10_28_00_world.sql b/sql/updates/world/master/2021_01_16_01_world_2017_10_28_00_world.sql new file mode 100644 index 00000000000..9c82634d8e0 --- /dev/null +++ b/sql/updates/world/master/2021_01_16_01_world_2017_10_28_00_world.sql @@ -0,0 +1,619 @@ +-- Pathing for Razorfen Defender Entry: 4442 +SET @NPC := 87345; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2107.421,`position_y`=1597.128,`position_z`=81.6817 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,2114.893,1607.468,81.0593,0,0,0,0,100,0), +(@PATH,2,2113.559,1609.265,80.98724,0,0,0,0,100,0), +(@PATH,3,2109.438,1606.844,80.59975,0,0,0,0,100,0), +(@PATH,4,2102.749,1604.79,80.30435,0,0,0,0,100,0), +(@PATH,5,2101.194,1601.532,80.31017,0,0,0,0,100,0), +(@PATH,6,2103.617,1595.386,80.96045,0,0,0,0,100,0), +(@PATH,7,2104.562,1587.409,80.99598,0,0,0,0,100,0), +(@PATH,8,2109.039,1582.875,81.48859,0,0,0,0,100,0), +(@PATH,9,2117.06,1583.574,81.66257,0,0,0,0,100,0), +(@PATH,10,2124.898,1582.786,81.64199,0,0,0,0,100,0), +(@PATH,11,2129.119,1584.171,81.76122,0,0,0,0,100,0), +(@PATH,12,2133.977,1580.883,81.5472,0,0,0,0,100,0), +(@PATH,13,2131.737,1573.881,81.49727,0,0,0,0,100,0), +(@PATH,14,2125.913,1566.676,80.32833,0,0,0,0,100,0), +(@PATH,15,2120.009,1565.401,80.254,0,0,0,0,100,0), +(@PATH,16,2116.996,1571.149,80.69305,0,0,0,0,100,0), +(@PATH,17,2112.323,1580.617,81.29841,0,0,0,0,100,0), +(@PATH,18,2110.271,1586.586,81.6452,0,0,0,0,100,0), +(@PATH,19,2107.51,1592.111,81.31756,0,0,0,0,100,0), +(@PATH,20,2107.421,1597.128,81.6817,0,0,0,0,100,0); + +-- Pathing for Razorfen Defender Entry: 4442 +SET @NPC := 87316; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2088.563,`position_y`=1550.666,`position_z`=81.383 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,2091.913,1548.273,80.96783,0,0,0,0,100,0), +(@PATH,2,2099.715,1547.863,81.34792,0,0,0,0,100,0), +(@PATH,3,2105.978,1546.3,81.55984,0,0,0,0,100,0), +(@PATH,4,2112.462,1549.684,81.62385,0,0,0,0,100,0), +(@PATH,5,2110.668,1553.25,81.51666,0,0,0,0,100,0), +(@PATH,6,2103.905,1551.207,81.62385,0,0,0,0,100,0), +(@PATH,7,2098.591,1551.75,81.48356,0,0,0,0,100,0), +(@PATH,8,2092.094,1556.073,81.2539,0,0,0,0,100,0), +(@PATH,9,2086.51,1556.822,81.37848,0,0,0,0,100,0), +(@PATH,10,2088.563,1550.666,81.383,0,0,0,0,100,0); + +-- Pathing for Agam'ar Entry: 4511 +SET @NPC := 87424; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2096.03,`position_y`=1786.564,`position_z`=51.27811 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,2085.907,1785.014,53.36885,0,0,0,0,100,0), +(@PATH,2,2079.124,1781.515,54.96775,0,0,0,0,100,0), +(@PATH,3,2077.211,1778.933,55.20493,0,0,0,0,100,0), +(@PATH,4,2081.743,1784.075,54.41806,0,0,0,0,100,0), +(@PATH,5,2088.712,1787.013,52.70948,0,0,0,0,100,0), +(@PATH,6,2099.211,1787.745,50.50051,0,0,0,0,100,0), +(@PATH,7,2100.05,1790.695,50.18368,0,0,0,0,100,0), +(@PATH,8,2097.266,1793.817,50.68781,0,0,0,0,100,0), +(@PATH,9,2085.132,1788.337,53.74854,0,0,0,0,100,0), +(@PATH,10,2080.077,1784.589,54.77439,0,0,0,0,100,0), +(@PATH,11,2075.331,1780.218,55.5807,0,0,0,0,100,0), +(@PATH,12,2080.79,1785.138,54.62421,0,0,0,0,100,0), +(@PATH,13,2087.91,1788.103,52.95766,0,0,0,0,100,0), +(@PATH,14,2095.274,1790.427,51.26003,0,0,0,0,100,0), +(@PATH,15,2086.218,1786.107,53.32716,0,0,0,0,100,0), +(@PATH,16,2073.822,1781.411,55.85382,0,0,0,0,100,0), +(@PATH,17,2081.04,1787.842,54.90159,0,0,0,0,100,0), +(@PATH,18,2093.317,1795.974,51.78655,0,0,0,0,100,0), +(@PATH,19,2099.931,1798.821,49.75352,0,0,0,0,100,0), +(@PATH,20,2103.046,1792.126,49.4443,0,0,0,0,100,0), +(@PATH,21,2104.787,1787.911,49.17257,0,0,0,0,100,0), +(@PATH,22,2096.03,1786.564,51.27811,0,0,0,0,100,0); + +-- Pathing for Agam'ar Entry: 4511 +SET @NPC := 87432; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2145.761,`position_y`=1839.933,`position_z`=48.77192 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,2142.696,1832.58,47.38148,0,0,0,0,100,0), +(@PATH,2,2138.982,1820.909,47.09259,0,0,0,0,100,0), +(@PATH,3,2138.687,1816.16,46.89988,0,0,0,0,100,0), +(@PATH,4,2133.455,1809.252,46.88326,0,0,0,0,100,0), +(@PATH,5,2125.034,1807.003,46.73381,0,0,0,0,100,0), +(@PATH,6,2116.036,1802.396,47.39417,0,0,0,0,100,0), +(@PATH,7,2116.691,1791.58,47.86673,0,0,0,0,100,0), +(@PATH,8,2124.233,1791.097,47.61297,0,0,0,0,100,0), +(@PATH,9,2132.302,1795.763,47.21243,0,0,0,0,100,0), +(@PATH,10,2137.479,1804.041,47.17542,0,0,0,0,100,0), +(@PATH,11,2138.468,1811.364,46.94453,0,0,0,0,100,0), +(@PATH,12,2134.186,1822.26,46.82648,0,0,0,0,100,0), +(@PATH,13,2133.21,1832.513,46.70514,0,0,0,0,100,0), +(@PATH,14,2131.556,1840.734,47.83244,0,0,0,0,100,0), +(@PATH,15,2129.286,1848.3,49.10868,0,0,0,0,100,0), +(@PATH,16,2132.14,1854.085,50.78709,0,0,0,0,100,0), +(@PATH,17,2136.563,1856.633,51.39883,0,0,0,0,100,0), +(@PATH,18,2144.213,1854.57,50.71241,0,0,0,0,100,0), +(@PATH,19,2148.088,1848.01,50.4381,0,0,0,0,100,0), +(@PATH,20,2145.761,1839.933,48.77192,0,0,0,0,100,0); + +-- Pathing for Raging Agam'ar Entry: 4514 +SET @NPC := 87392; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2139.96,`position_y`=1673.604,`position_z`=58.55344 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,2155.755,1680.389,58.5962,0,0,0,0,100,0), +(@PATH,2,2149.106,1679.827,57.96727,0,0,0,0,100,0), +(@PATH,3,2136.626,1673.143,58.55163,0,0,0,0,100,0), +(@PATH,4,2124.211,1671.252,58.57498,0,0,0,0,100,0), +(@PATH,5,2112.027,1670.41,59.17719,0,0,0,0,100,0), +(@PATH,6,2099.69,1672.588,59.71073,0,0,0,0,100,0), +(@PATH,7,2088.552,1673.508,61.25085,0,0,0,0,100,0), +(@PATH,8,2081.336,1669.674,61.25143,0,0,0,0,100,0), +(@PATH,9,2073.589,1665.513,61.09065,0,0,0,0,100,0), +(@PATH,10,2065.993,1657.292,61.2337,0,0,0,0,100,0), +(@PATH,11,2062.475,1653.62,61.18982,0,0,0,0,100,0), +(@PATH,12,2061.51,1647.463,61.72988,0,0,0,0,100,0), +(@PATH,13,2063.625,1640.532,62.76986,0,0,0,0,100,0), +(@PATH,14,2065.712,1626.571,64.44929,0,0,0,0,100,0), +(@PATH,15,2066.252,1636.553,63.79743,0,0,0,0,100,0), +(@PATH,16,2064.955,1653.818,61.21502,0,0,0,0,100,0), +(@PATH,17,2068.105,1660.412,61.23128,0,0,0,0,100,0), +(@PATH,18,2075.192,1666.602,61.19273,0,0,0,0,100,0), +(@PATH,19,2081.34,1669.145,61.25577,0,0,0,0,100,0), +(@PATH,20,2088.21,1671.554,61.26539,0,0,0,0,100,0), +(@PATH,21,2094.216,1672.949,60.74401,0,0,0,0,100,0), +(@PATH,22,2105.022,1673.325,59.05119,0,0,0,0,100,0), +(@PATH,23,2115.466,1670.424,59.22596,0,0,0,0,100,0), +(@PATH,24,2139.96,1673.604,58.55344,0,0,0,0,100,0); + +-- Pathing for Rotting Agam'ar Entry: 4512 +SET @NPC := 87436; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2063.36,`position_y`=1847.869,`position_z`=55.53937 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,2068.148,1842.792,56.19976,0,0,0,0,100,0), +(@PATH,2,2071.428,1841.88,56.40713,0,0,0,0,100,0), +(@PATH,3,2077.612,1841.523,55.54581,0,0,0,0,100,0), +(@PATH,4,2083.211,1842.328,53.36441,0,0,0,0,100,0), +(@PATH,5,2090.784,1845.256,51.16241,0,0,0,0,100,0), +(@PATH,6,2096.728,1850.309,50.04328,0,0,0,0,100,0), +(@PATH,7,2095.041,1857.167,49.79569,0,0,0,0,100,0), +(@PATH,8,2089.37,1858.995,51.32528,0,0,0,0,100,0), +(@PATH,9,2079.101,1852.991,53.26225,0,0,0,0,100,0), +(@PATH,10,2074.516,1849.417,53.96615,0,0,0,0,100,0), +(@PATH,11,2071.997,1847.792,54.55695,0,0,0,0,100,0), +(@PATH,12,2067.029,1848.406,55.32259,0,0,0,0,100,0), +(@PATH,13,2062.753,1847.629,55.57483,0,0,0,0,100,0), +(@PATH,14,2056.324,1843.5,56.11672,0,0,0,0,100,0), +(@PATH,15,2047.929,1844.346,56.30235,0,0,0,0,100,0), +(@PATH,16,2047.554,1853.73,55.61036,0,0,0,0,100,0), +(@PATH,17,2052.718,1858.686,56.04894,0,0,0,0,100,0), +(@PATH,18,2063.36,1847.869,55.53937,0,0,0,0,100,0); + +-- Pathing for Rotting Agam'ar Entry: 4512 +SET @NPC := 87416; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2052.472,`position_y`=1702.112,`position_z`=59.06878 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,2060.335,1702.303,58.44148,0,0,0,0,100,0), -- 54:51 +(@PATH,2,2064.091,1701.021,58.09085,0,0,0,0,100,0), -- 54:54 +(@PATH,3,2073.108,1701.76,57.20672,0,0,0,0,100,0), -- 54:55 +(@PATH,4,2086.73,1706.065,56.3343,0,0,0,0,100,0), -- 54:58 +(@PATH,5,2093.51,1709.195,56.07202,0,0,0,0,100,0), -- 55:05 +(@PATH,6,2102.587,1718.31,54.41,0,0,0,0,100,0), -- 55:08 +(@PATH,7,2115.782,1727.701,53.16241,0,0,0,0,100,0), -- 55:13 +(@PATH,8,2125.403,1734.609,52.16546,0,0,0,0,100,0), -- 55:19 +(@PATH,9,2134.975,1738.386,51.6567,0,0,0,0,100,0), -- 55:24 +(@PATH,10,2143.869,1734.868,51.49122,0,0,0,0,100,0), -- 55:28 +(@PATH,11,2157.675,1729.202,52.19218,0,0,0,0,100,0), -- 55:33 +(@PATH,12,2166.984,1720.267,53.25206,0,0,0,0,100,0), -- 55:38 +(@PATH,13,2166.542,1712.489,53.85883,0,0,0,0,100,0), -- 55:44 +(@PATH,14,2154.661,1716.851,52.84023,0,0,0,0,100,0), -- 55:46 +(@PATH,15,2143.729,1724.37,52.36889,0,0,0,0,100,0), -- 55:51 +(@PATH,16,2133.999,1729.626,52.04773,0,0,0,0,100,0), -- 55:57 +(@PATH,17,2126.431,1731.602,51.99927,0,0,0,0,100,0), -- 56:02 +(@PATH,18,2114.009,1729.264,53.28587,0,0,0,0,100,0), -- 56:04 +(@PATH,19,2104.882,1722.333,54.5862,0,0,0,0,100,0), -- 56:09 +(@PATH,20,2092.062,1709.69,55.87567,0,0,0,0,100,0), -- 56:14 +(@PATH,21,2080.463,1704.365,56.56325,0,0,0,0,100,0), -- 56:21 +(@PATH,22,2070.483,1701.719,57.19421,0,0,0,0,100,0), -- 56:26 +(@PATH,23,2062.857,1702.526,58.22356,0,0,0,0,100,0), -- 56:31 +(@PATH,24,2057.357,1707.382,58.71372,0,0,0,0,100,0), -- 56:34 +(@PATH,25,2051.841,1714.146,59.40524,0,0,0,0,100,0), -- 56:37 +(@PATH,26,2046.19,1715.718,59.78969,0,0,0,0,100,0), -- 56:40 +(@PATH,27,2040.404,1713.414,59.80349,0,0,0,0,100,0), -- 56:42 +(@PATH,28,2042.458,1705.426,59.96202,0,0,0,0,100,0), -- 56:45 +(@PATH,29,2047.105,1701.524,59.5788,0,0,0,0,100,0), -- 56:48 +(@PATH,30,2052.472,1702.112,59.06878,0,0,0,0,100,0); -- 56:51 + +-- Pathing for Raging Agam'ar Entry: 4514 +SET @NPC := 87319; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2032.172,`position_y`=1754.218,`position_z`=60.4647 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,2035.138,1745.788,60.3933,0,0,0,0,100,0), -- 55:39 +(@PATH,2,2035.717,1736.743,60.65516,0,0,0,0,100,0), -- 55:43 +(@PATH,3,2031.431,1732.204,60.83634,0,0,0,0,100,0), -- 55:46 +(@PATH,4,2029.669,1727.54,60.45228,0,0,0,0,100,0), -- 55:49 +(@PATH,5,2030.052,1721.121,60.25993,0,0,0,0,100,0), -- 55:51 +(@PATH,6,2034.821,1714.521,60.16006,0,0,0,0,100,0), -- 55:54 +(@PATH,7,2041.953,1706.905,59.92676,0,0,0,0,100,0), -- 55:56 +(@PATH,8,2048.065,1703.16,59.40845,0,0,0,0,100,0), -- 56:01 +(@PATH,9,2051.396,1708.162,59.06941,0,0,0,0,100,0), -- 56:04 +(@PATH,10,2045.333,1716.266,59.92817,0,0,0,0,100,0), -- 56:06 +(@PATH,11,2040.001,1722.506,60.47118,0,0,0,0,100,0), -- 56:10 +(@PATH,12,2036.937,1728.058,60.79508,0,0,0,0,100,0), -- 56:13 +(@PATH,13,2038.388,1741.962,60.3935,0,0,0,0,100,0), -- 56:16 +(@PATH,14,2042.487,1752.383,59.94053,0,0,0,0,100,0), -- 56:22 +(@PATH,15,2045.754,1759.89,59.55702,0,0,0,0,100,0), -- 56:27 +(@PATH,16,2049.796,1764.984,59.06327,0,0,0,0,100,0), -- 56:29 +(@PATH,17,2059.261,1767.341,58.06811,0,0,0,0,100,0), -- 56:32 +(@PATH,18,2067.314,1770.503,57.23711,0,0,0,0,100,0), -- 56:36 +(@PATH,19,2080.536,1779.038,54.66039,0,0,0,0,100,0), -- 56:39 +(@PATH,20,2097.544,1790.442,50.76727,0,0,0,0,100,0), -- 56:46 +(@PATH,21,2087.033,1789.196,53.22539,0,0,0,0,100,0), -- 56:54 +(@PATH,22,2072.284,1779.995,55.99961,0,0,0,0,100,0), -- 56:58 +(@PATH,23,2062.56,1773.932,57.95657,0,0,0,0,100,0), -- 57:06 +(@PATH,24,2050.032,1773.168,59.01479,0,0,0,0,100,0), -- 57:11 +(@PATH,25,2042.163,1772.459,59.84247,0,0,0,0,100,0), -- 57:16 +(@PATH,26,2036.88,1767.39,59.99329,0,0,0,0,100,0), -- 57:18 +(@PATH,27,2034.55,1761.736,60.27701,0,0,0,0,100,0), -- 57:22 +(@PATH,28,2032.172,1754.218,60.4647,0,0,0,0,100,0); -- 57:24 + +-- Pathing for Raging Agam'ar Entry: 4514 +SET @NPC := 87315; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2066.079,`position_y`=1608.026,`position_z`=62.37017 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,2066.605,1614.46,63.15455,0,0,0,0,100,0), +(@PATH,2,2066.83,1624.417,64.38802,0,1000,0,0,100,0), +(@PATH,3,2065.609,1626.417,64.44986,0,0,0,0,100,0), +(@PATH,4,2062.611,1608.333,62.35115,0,0,0,0,100,0), +(@PATH,5,2058.045,1600.916,62.46653,0,0,0,0,100,0), +(@PATH,6,2057.503,1593.019,62.96184,0,0,0,0,100,0), +(@PATH,7,2057.701,1583.68,64.00708,0,0,0,0,100,0), +(@PATH,8,2046.453,1576.105,64.51681,0,0,0,0,100,0), +(@PATH,9,2044.112,1567.474,64.3503,0,0,0,0,100,0), +(@PATH,10,2050.936,1564.057,64.64704,0,0,0,0,100,0), +(@PATH,11,2052.142,1572.717,64.31072,0,0,0,0,100,0), +(@PATH,12,2057.872,1578.538,64.1582,0,0,0,0,100,0), +(@PATH,13,2058.871,1590.09,63.21131,0,0,0,0,100,0), +(@PATH,14,2061.044,1599.244,62.41414,0,0,0,0,100,0), +(@PATH,15,2066.079,1608.026,62.37017,0,0,0,0,100,0); + +-- Pathing for Raging Agam'ar Entry: 4514 +SET @NPC := 87437; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2055.007,`position_y`=1845.796,`position_z`=55.89343 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,2062.865,1842.589,56.42229,0,0,0,0,100,0), +(@PATH,2,2069.917,1842.933,56.11264,0,0,0,0,100,0), +(@PATH,3,2074.16,1843.636,55.77161,0,0,0,0,100,0), +(@PATH,4,2082.133,1844.38,52.99316,0,0,0,0,100,0), +(@PATH,5,2090.826,1845.744,51.04036,0,0,0,0,100,0), +(@PATH,6,2098.35,1847.418,50.19639,0,0,0,0,100,0), +(@PATH,7,2108.214,1849.857,49.01111,0,0,0,0,100,0), +(@PATH,8,2102.665,1854.577,49.56808,0,0,0,0,100,0), +(@PATH,9,2094.424,1855.651,49.93146,0,0,0,0,100,0), +(@PATH,10,2080.563,1853.904,52.76198,0,0,0,0,100,0), +(@PATH,11,2069.352,1852.929,55.06715,0,0,0,0,100,0), +(@PATH,12,2059.862,1854.154,56.13989,0,0,0,0,100,0), +(@PATH,13,2048.714,1858.587,55.87393,0,0,0,0,100,0), +(@PATH,14,2043.315,1860.27,55.746,0,0,0,0,100,0), +(@PATH,15,2042.087,1855.476,55.73419,0,0,0,0,100,0), +(@PATH,16,2045.027,1850.036,55.96173,0,0,0,0,100,0), +(@PATH,17,2055.007,1845.796,55.89343,0,0,0,0,100,0); + +-- Pathing for Death's Head Seer Entry: 4519 +SET @NPC := 87343; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2098.684,`position_y`=1540.76,`position_z`=85.16721 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,2100.012,1539.687,86.38844,0,0,0,0,100,0), +(@PATH,2,2103.12,1539.157,87.14921,0,13000,0,0,100,0), +(@PATH,3,2100.012,1539.687,86.38844,0,0,0,0,100,0), +(@PATH,4,2098.684,1540.76,85.16721,0,0,0,0,100,0), +(@PATH,5,2091.968,1543.625,80.99364,0,0,0,0,100,0), +(@PATH,6,2090.485,1546.336,80.93262,0,24000,0,0,100,0), +(@PATH,7,2091.968,1543.625,80.99364,0,0,0,0,100,0), +(@PATH,8,2098.684,1540.76,85.16721,0,0,0,0,100,0); + +-- Pathing for Death's Head Priest Entry: 4517 +SET @NPC := 87448; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2178.34,`position_y`=1855.082,`position_z`=58.19644 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,2174.453,1851.825,58.33954,0,0,0,0,100,0), +(@PATH,2,2176.394,1843.422,58.15576,0,0,0,0,100,0), +(@PATH,3,2181.557,1839.734,59.17974,0,0,0,0,100,0), +(@PATH,4,2185.224,1834.477,59.87947,0,0,0,0,100,0), +(@PATH,5,2184.219,1826.638,60.93966,0,0,0,0,100,0), +(@PATH,6,2185.368,1821.765,61.63937,0,0,0,0,100,0), +(@PATH,7,2187.973,1818.724,62.1631,0,0,0,0,100,0), +(@PATH,8,2194.436,1819.924,61.89945,0,0,0,0,100,0), +(@PATH,9,2197.274,1821.988,61.88156,0,0,0,0,100,0), +(@PATH,10,2196.079,1831.449,61.22343,0,0,0,0,100,0), +(@PATH,11,2192.44,1838.419,60.03462,0,0,0,0,100,0), +(@PATH,12,2192.103,1843.89,59.62682,0,0,0,0,100,0), +(@PATH,13,2191.981,1849.101,58.84718,0,0,0,0,100,0), +(@PATH,14,2190.316,1855.051,58.41751,0,0,0,0,100,0), +(@PATH,15,2188.429,1860.81,58.33215,0,0,0,0,100,0), +(@PATH,16,2186.214,1860.086,58.22411,0,0,0,0,100,0), +(@PATH,17,2178.34,1855.082,58.19644,0,0,0,0,100,0); + +-- Pathing for Death's Head Priest Entry: 4517 +SET @NPC := 87456; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2187.822,`position_y`=1834.436,`position_z`=60.13253 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,2183.277,1843.486,59.02925,0,0,0,0,100,0), +(@PATH,2,2176.345,1851.903,58.33517,0,0,0,0,100,0), +(@PATH,3,2169.563,1854.612,58.02235,0,0,0,0,100,0), +(@PATH,4,2176.345,1851.903,58.33517,0,0,0,0,100,0), +(@PATH,5,2183.277,1843.486,59.02925,0,0,0,0,100,0), +(@PATH,6,2187.781,1834.517,60.05606,0,0,0,0,100,0), +(@PATH,7,2190.464,1827.093,61.33936,0,0,0,0,100,0), +(@PATH,8,2189.615,1816.533,62.54241,0,0,0,0,100,0), +(@PATH,9,2190.538,1826.89,61.3537,0,0,0,0,100,0), +(@PATH,10,2187.822,1834.436,60.13253,0,0,0,0,100,0); + +-- Pathing for Razorfen Quilguard Entry: 4436 +SET @NPC := 87305; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2014.151,`position_y`=1647.922,`position_z`=80.97002 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,2008.324,1642.817,80.35912,0,0,0,0,100,0), +(@PATH,2,2004.396,1638.403,80.51665,0,0,0,0,100,0), +(@PATH,3,2000.928,1633.265,80.97063,0,0,0,0,100,0), +(@PATH,4,1998.693,1627.001,81.02338,0,0,0,0,100,0), +(@PATH,5,1996.198,1622.218,82.22533,0,0,0,0,100,0), +(@PATH,6,1993.378,1625.59,81.49384,0,0,0,0,100,0), +(@PATH,7,1993.948,1628.972,81.07971,0,0,0,0,100,0), +(@PATH,8,1997.675,1634.351,80.77856,0,0,0,0,100,0), +(@PATH,9,2003.769,1638.847,80.47289,0,0,0,0,100,0), +(@PATH,10,2009.364,1644.574,80.30908,0,0,0,0,100,0), +(@PATH,11,2015.501,1649.102,80.9803,0,0,0,0,100,0), +(@PATH,12,2017.452,1651.314,81.4091,0,0,0,0,100,0), +(@PATH,13,2017.554,1654.779,81.66192,0,0,0,0,100,0), +(@PATH,14,2020.155,1658.124,82.14635,0,0,0,0,100,0), +(@PATH,15,2023.652,1659.764,81.76729,0,0,0,0,100,0), +(@PATH,16,2030.597,1661.048,81.07684,0,0,0,0,100,0), +(@PATH,17,2036.931,1660.413,80.72527,0,0,0,0,100,0), +(@PATH,18,2040.397,1655.858,81.0736,0,0,0,0,100,0), +(@PATH,19,2035.366,1656.879,80.22555,0,0,0,0,100,0), +(@PATH,20,2030.426,1660.441,80.93649,0,0,0,0,100,0), +(@PATH,21,2024.278,1659.282,81.718,0,0,0,0,100,0), +(@PATH,22,2022.62,1657.101,82.43031,0,0,0,0,100,0), +(@PATH,23,2014.151,1647.922,80.97002,0,0,0,0,100,0); + +-- Pathing for Greater Kraul Bat Entry: 4539 +SET @NPC := 87468; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2122.867,`position_y`=1989.361,`position_z`=64.2011 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,2119.471,1982.974,64.17838,0,0,0,0,100,0), +(@PATH,2,2108.916,1979.109,64.87038,0,0,0,0,100,0), +(@PATH,3,2102.991,1983.012,65.08557,0,0,0,0,100,0), +(@PATH,4,2091.936,1987.228,64.38224,0,0,0,0,100,0), +(@PATH,5,2086.783,1983.47,64.12414,0,0,0,0,100,0), +(@PATH,6,2077.326,1981.735,63.48634,0,0,0,0,100,0), +(@PATH,7,2072.816,1977.414,63.01323,0,0,0,0,100,0), +(@PATH,8,2069.224,1968.839,62.03327,0,0,0,0,100,0), +(@PATH,9,2074.309,1965.289,62.34666,0,0,0,0,100,0), +(@PATH,10,2080.863,1960.025,63.66449,0,0,0,0,100,0), +(@PATH,11,2086.398,1963.47,64.85815,0,0,0,0,100,0), +(@PATH,12,2089.173,1969.579,65.23668,0,0,0,0,100,0), +(@PATH,13,2085.244,1979.623,64.27675,0,0,0,0,100,0), +(@PATH,14,2087.208,1987.823,63.74189,0,0,0,0,100,0), +(@PATH,15,2092.497,1989.432,64.52837,0,0,0,0,100,0), +(@PATH,16,2096.048,1990.466,65.12543,0,0,0,0,100,0), +(@PATH,17,2098.869,1996.237,65.25151,0,0,0,0,100,0), +(@PATH,18,2105.595,2005.276,65.27394,0,0,0,0,100,0), +(@PATH,19,2116.778,2004.364,64.87038,0,0,0,0,100,0), +(@PATH,20,2121.197,2004.139,64.87038,0,0,0,0,100,0), +(@PATH,21,2126.033,2003.283,64.87038,0,0,0,0,100,0), +(@PATH,22,2123.96,1995.334,64.30733,0,0,0,0,100,0), +(@PATH,23,2122.867,1989.361,64.2011,0,0,0,0,100,0); + +-- Pathing for Blood of Agamaggan Entry: 4541 +SET @NPC := 87426; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2130.472,`position_y`=1848.927,`position_z`=49.23372 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,2133.878,1841.073,47.84394,0,0,0,0,100,0), +(@PATH,2,2137.288,1833.684,46.65741,0,0,0,0,100,0), +(@PATH,3,2142.935,1824.701,47.38944,0,0,0,0,100,0), +(@PATH,4,2142.771,1819.232,47.67385,0,0,0,0,100,0), +(@PATH,5,2141.188,1810.284,47.06269,0,0,0,0,100,0), +(@PATH,6,2138.225,1801.953,47.29019,0,0,0,0,100,0), +(@PATH,7,2133.334,1797.093,47.02711,0,0,0,0,100,0), +(@PATH,8,2127.183,1790.409,47.51778,0,0,0,0,100,0), +(@PATH,9,2123.581,1789.841,47.68044,0,0,0,0,100,0), +(@PATH,10,2118.854,1791.837,47.79222,0,0,0,0,100,0), +(@PATH,11,2115.593,1796.454,47.73401,0,0,0,0,100,0), +(@PATH,12,2118.855,1801.601,47.38517,0,0,0,0,100,0), +(@PATH,13,2126.449,1807.001,46.86285,0,0,0,0,100,0), +(@PATH,14,2130.195,1808.294,46.84606,0,0,0,0,100,0), +(@PATH,15,2132.681,1815.324,46.91436,0,0,0,0,100,0), +(@PATH,16,2134.869,1820.328,46.89141,0,0,0,0,100,0), +(@PATH,17,2135.539,1828.899,46.57799,0,0,0,0,100,0), +(@PATH,18,2137.002,1832.216,46.62844,0,0,0,0,100,0), +(@PATH,19,2138.4,1835.487,46.75941,0,0,0,0,100,0), +(@PATH,20,2144.043,1841.499,48.68194,0,0,0,0,100,0), +(@PATH,21,2146.708,1849.135,50.11401,0,0,0,0,100,0), +(@PATH,22,2143.896,1854.989,50.84016,0,0,0,0,100,0), +(@PATH,23,2137.195,1856.388,51.2458,0,0,0,0,100,0), +(@PATH,24,2132.518,1851.993,49.97353,0,0,0,0,100,0), +(@PATH,25,2130.472,1848.927,49.23372,0,0,0,0,100,0); + +-- Pathing for Blood of Agamaggan Entry: 4541 +SET @NPC := 87429; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2090.525,`position_y`=1707.353,`position_z`=56.40569 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,2098.015,1714.226,54.92541,0,0,0,0,100,0), +(@PATH,2,2103.385,1720.315,54.51497,0,0,0,0,100,0), +(@PATH,3,2108.919,1725.167,54.04745,0,0,0,0,100,0), +(@PATH,4,2118.578,1730.136,52.90612,0,0,0,0,100,0), +(@PATH,5,2132.439,1734.546,51.80573,0,13000,0,0,100,0), +(@PATH,6,2123.643,1732.562,52.38219,0,0,0,0,100,0), +(@PATH,7,2117.904,1729.931,52.9194,0,0,0,0,100,0), +(@PATH,8,2104.57,1720.452,54.46609,0,0,0,0,100,0), +(@PATH,9,2094.942,1711.386,55.54934,0,0,0,0,100,0), +(@PATH,10,2086.199,1706.155,56.26017,0,0,0,0,100,0), +(@PATH,11,2079.804,1703.917,56.69853,0,0,0,0,100,0), +(@PATH,12,2070.831,1700.533,57.39662,0,0,0,0,100,0), +(@PATH,13,2061.656,1701.943,58.31971,0,0,0,0,100,0), +(@PATH,14,2058.082,1702.922,58.69167,0,17000,0,0,100,0), +(@PATH,15,2063.635,1701.552,58.13944,0,0,0,0,100,0), +(@PATH,16,2070.139,1701.076,57.30006,0,0,0,0,100,0), +(@PATH,17,2079.066,1703.696,56.82508,0,0,0,0,100,0), +(@PATH,18,2090.525,1707.353,56.40569,0,0,0,0,100,0); + +-- Pathing for Blood of Agamaggan Entry: 4541 +SET @NPC := 87390; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `id`=4541,`spawndist`=0,`MovementType`=2,`position_x`=2164.323,`position_y`=1691.301,`position_z`=56.84164 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,2157.073,1685.369,57.93908,0,0,0,0,100,0), +(@PATH,2,2154.69,1677.314,58.87576,0,0,0,0,100,0), +(@PATH,3,2147.898,1672.951,59.1782,0,0,0,0,100,0), +(@PATH,4,2140.698,1675.78,58.07055,0,0,0,0,100,0), +(@PATH,5,2142.277,1679.984,58.22276,0,0,0,0,100,0), +(@PATH,6,2144.172,1684.408,58.18035,0,0,0,0,100,0), +(@PATH,7,2148.83,1690.948,57.99367,0,0,0,0,100,0), +(@PATH,8,2154.595,1696.041,56.11627,0,0,0,0,100,0), +(@PATH,9,2158.22,1705.284,54.65466,0,0,0,0,100,0), +(@PATH,10,2160.252,1714.086,53.17568,0,0,0,0,100,0), +(@PATH,11,2162.731,1719.535,52.75797,0,0,0,0,100,0), +(@PATH,12,2168.902,1717.577,53.77048,0,0,0,0,100,0), +(@PATH,13,2172.589,1711.47,54.84762,0,0,0,0,100,0), +(@PATH,14,2173.192,1704.445,55.48201,0,0,0,0,100,0), +(@PATH,15,2171.546,1696.724,56.45893,0,0,0,0,100,0), +(@PATH,16,2164.323,1691.301,56.84164,0,0,0,0,100,0); + +-- Pathing for Razorfen Stalker Entry: 6035 +SET @NPC := 87489; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2152.86,`position_y`=1926.615,`position_z`=66.59495 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,2158.86,1922.016,66.59574,0,0,0,0,100,0), +(@PATH,2,2165.115,1918.638,67.83205,0,0,0,0,100,0), +(@PATH,3,2167.671,1916.226,68.76556,0,0,0,0,100,0), +(@PATH,4,2171.736,1914.535,69.57543,0,0,0,0,100,0), +(@PATH,5,2179.248,1910.936,69.82761,0,0,0,0,100,0), +(@PATH,6,2193.254,1903.004,71.05865,0,0,0,0,100,0), +(@PATH,7,2179.248,1910.936,69.82761,0,0,0,0,100,0), +(@PATH,8,2171.736,1914.535,69.57543,0,0,0,0,100,0), +(@PATH,9,2167.671,1916.226,68.76556,0,0,0,0,100,0), +(@PATH,10,2165.115,1918.638,67.83205,0,0,0,0,100,0), +(@PATH,11,2158.86,1922.016,66.59574,0,0,0,0,100,0), +(@PATH,12,2152.86,1926.615,66.59495,0,0,0,0,100,0); + +-- Pathing for Quilguard Champion Entry: 4623 +SET @NPC := 87393; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2140.23,`position_y`=1634.293,`position_z`=81.90321 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,2143.314,1628.368,81.60458,0,0,0,0,100,0), -- 49:24 +(@PATH,2,2140.299,1634.161,81.88406,0,0,0,0,100,0), -- 49:29 +(@PATH,3,2134.956,1642.65,82.24873,0,0,0,0,100,0), -- 49:30 +(@PATH,4,2132.034,1646.701,82.23985,0,0,0,0,100,0), -- 49:34 +(@PATH,5,2130.662,1651.305,82.10767,0,0,0,0,100,0), -- 49:36 +(@PATH,6,2129.971,1657.905,82.04201,0,0,0,0,100,0), -- 49:39 +(@PATH,7,2129.474,1664.574,82.66071,0,0,0,0,100,0), -- 49:41 +(@PATH,8,2128.147,1671.855,82.16047,0,0,0,0,100,0), -- 49:44 +(@PATH,9,2127.142,1678.336,82.5769,0,0,0,0,100,0), -- 49:47 +(@PATH,10,2125.827,1687.057,81.51637,0,0,0,0,100,0), -- 49:50 +(@PATH,11,2123.738,1693.419,80.39718,0,0,0,0,100,0), -- 53:22 +(@PATH,12,2120.174,1700.864,79.91035,0,0,0,0,100,0), -- 53:20 +(@PATH,13,2117.048,1706.28,80.65261,0,0,0,0,100,0), -- 53:18 +(@PATH,14,2120.174,1700.864,79.91035,0,0,0,0,100,0), -- 53:20 +(@PATH,15,2123.738,1693.419,80.39718,0,0,0,0,100,0), -- 53:22 +(@PATH,16,2125.827,1687.057,81.51637,0,0,0,0,100,0), -- 53:26 +(@PATH,17,2127.142,1678.336,82.5769,0,0,0,0,100,0), -- 53:28 +(@PATH,18,2128.147,1671.855,82.16047,0,0,0,0,100,0), -- 53:32 +(@PATH,19,2129.474,1664.574,82.66071,0,0,0,0,100,0), -- 53:34 +(@PATH,20,2129.971,1657.905,82.04201,0,0,0,0,100,0), -- 53:37 +(@PATH,21,2130.662,1651.305,82.10767,0,0,0,0,100,0), -- 53:40 +(@PATH,22,2132.034,1646.701,82.23985,0,0,0,0,100,0), -- 53:43 +(@PATH,23,2134.956,1642.65,82.24873,0,0,0,0,100,0), -- 53:44 +(@PATH,24,2140.23,1634.293,81.90321,0,0,0,0,100,0); -- 53:46 + +-- Pathing for Death's Head Acolyte Entry: 4515 +SET @NPC := 87379; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2182.066,`position_y`=1536.653,`position_z`=71.79845 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,2188.081,1536.191,72.05502,0,0,0,0,100,0), -- 41:00 +(@PATH,2,2195.706,1531.923,72.93341,0,0,0,0,100,0), -- 41:02 +(@PATH,3,2197.902,1526.016,72.89204,0,0,0,0,100,0), -- 41:05 +(@PATH,4,2198.892,1515.474,72.48969,0,0,0,0,100,0), -- 41:07 +(@PATH,5,2197.205,1507.643,72.7455,0,0,0,0,100,0), -- 41:12 +(@PATH,6,2190.766,1503.397,73.81425,0,0,0,0,100,0), -- 41:16 +(@PATH,7,2178.97,1496.977,73.17003,0,0,0,0,100,0), -- 41:18 +(@PATH,8,2175.032,1490.408,72.85684,0,0,0,0,100,0), -- 41:24 +(@PATH,9,2176.586,1481.719,72.83849,0,0,0,0,100,0), -- 41:27 +(@PATH,10,2185.094,1484.374,72.816,0,0,0,0,100,0), -- 41:30 +(@PATH,11,2186.793,1492.113,72.8675,0,0,0,0,100,0), -- 41:34 +(@PATH,12,2186.97,1500.637,73.57037,0,0,0,0,100,0), -- 41:38 +(@PATH,13,2190.372,1503.825,73.90714,0,0,0,0,100,0), -- 41:40 +(@PATH,14,2197.789,1513.378,72.69975,0,0,0,0,100,0), -- 41:43 +(@PATH,15,2197.359,1522.274,72.66833,0,0,0,0,100,0), -- 41:48 +(@PATH,16,2194.852,1530.686,72.99499,0,0,0,0,100,0), -- 41:51 +(@PATH,17,2187.881,1535.706,72.00735,0,0,0,0,100,0), -- 41:55 +(@PATH,18,2178.126,1536.009,71.67631,0,0,0,0,100,0), -- 41:57 +(@PATH,19,2182.066,1536.653,71.79845,0,0,0,0,100,0); -- 42:02 + +-- Pathing for Razorfen Warrior Entry: 4435 +SET @NPC := 87291; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2004.841,`position_y`=1525.423,`position_z`=80.50848 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,2005.701,1530,80.87834,0,0,0,0,100,0), -- 34:59 +(@PATH,2,2007.366,1538.389,79.65939,0,0,0,0,100,0), -- 35:00 +(@PATH,3,2008.361,1546.181,78.66383,0,0,0,0,100,0), -- 35:03 +(@PATH,4,2007.064,1551.882,79.57407,0,0,0,0,100,0), -- 35:06 +(@PATH,5,2002.433,1561.567,81.50003,0,0,0,0,100,0), -- 35:09 +(@PATH,6,2001.195,1566.652,82.29926,0,0,0,0,100,0), -- 35:14 +(@PATH,7,1998.848,1575.452,82.17207,0,0,0,0,100,0), -- 35:15 +(@PATH,8,1995.95,1589.264,80.10281,0,0,0,0,100,0), -- 35:19 +(@PATH,9,2001.675,1587.134,80.87109,0,0,0,0,100,0), -- 35:25 +(@PATH,10,1999.646,1571.909,82.2473,0,0,0,0,100,0), -- 35:27 +(@PATH,11,2001.582,1567.512,82.26955,0,0,0,0,100,0), -- 35:33 +(@PATH,12,2002.453,1560.95,81.43659,0,0,0,0,100,0), -- 35:36 +(@PATH,13,2004.99,1553.852,80.15679,0,0,0,0,100,0), -- 35:38 +(@PATH,14,2011.123,1548.021,79.32449,0,0,0,0,100,0), -- 35:41 +(@PATH,15,2017.961,1542.419,80.9518,0,0,0,0,100,0), -- 35:44 +(@PATH,16,2025.82,1535.566,80.51386,0,0,0,0,100,0), -- 35:48 +(@PATH,17,2029.185,1532.684,80.43591,0,0,0,0,100,0), -- 35:53 +(@PATH,18,2026.733,1526.938,80.00459,0,0,0,0,100,0), -- 35:54 +(@PATH,19,2024.966,1520.724,79.29298,0,0,0,0,100,0), -- 35:56 +(@PATH,20,2019.758,1516.571,79.15639,0,0,0,0,100,0), -- 35:59 +(@PATH,21,2007.736,1514.946,79.54068,0,0,0,0,100,0), -- 36:01 +(@PATH,22,2005.342,1521.371,80.2472,0,0,0,0,100,0), -- 36:06 +(@PATH,23,2004.841,1525.423,80.50848,0,0,0,0,100,0); -- 36:10 |