diff options
author | Rushor <PBienati@web.de> | 2015-07-17 23:05:05 +0200 |
---|---|---|
committer | Rushor <PBienati@web.de> | 2015-07-17 23:05:05 +0200 |
commit | 2b5afe64b44bc425a15376a1180ff5e63073a0d0 (patch) | |
tree | f4e67d2c687ad04b8647565ba07233a1d8428c02 | |
parent | c9a7fac8f96b2bc20cd675a5964b299894dbc68c (diff) |
DB/Pathing: Dragonblight - Icemist Village (West) + Azjol Nerub + Agmars Hammer Area + Obsidian Dragonshrine
-rw-r--r-- | sql/updates/world/2015_07_17_04_world.sql | 1070 |
1 files changed, 1070 insertions, 0 deletions
diff --git a/sql/updates/world/2015_07_17_04_world.sql b/sql/updates/world/2015_07_17_04_world.sql new file mode 100644 index 00000000000..4c28f811d27 --- /dev/null +++ b/sql/updates/world/2015_07_17_04_world.sql @@ -0,0 +1,1070 @@ +-- Dragonblight - Icemist Village (West) + Azjol Nerub + Agmars hammer Area + Obsidian Dragonshrine +-- 1. Anub'ar Slayer +SET @NPC := 118379; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3844.24,`position_y`=1991.705,`position_z`=117.7844 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,3844.24,1991.705,117.7844,0,0,0,0,100,0), +(@PATH,2,3844.74,1993.705,118.5344,0,0,0,0,100,0), +(@PATH,3,3845.49,1995.455,119.2844,0,0,0,0,100,0), +(@PATH,4,3845.99,1997.455,120.0344,0,0,0,0,100,0), +(@PATH,5,3846.49,1999.455,120.7844,0,0,0,0,100,0), +(@PATH,6,3847.24,2001.205,121.5344,0,0,0,0,100,0), +(@PATH,7,3847.99,2004.205,122.0344,0,0,0,0,100,0), +(@PATH,8,3848.24,2005.955,122.5344,0,0,0,0,100,0), +(@PATH,9,3848.99,2007.705,123.0344,0,0,0,0,100,0), +(@PATH,10,3849.49,2009.705,123.7844,0,0,0,0,100,0), +(@PATH,11,3849.99,2011.705,124.5344,0,0,0,0,100,0), +(@PATH,12,3851.24,2015.455,125.5344,0,0,0,0,100,0), +(@PATH,13,3851.74,2017.455,126.0344,0,0,0,0,100,0), +(@PATH,14,3852.49,2019.205,126.7844,0,0,0,0,100,0), +(@PATH,15,3853.396,2021.607,127.8077,0,0,0,0,100,0), +(@PATH,16,3854.146,2023.357,128.3077,0,0,0,0,100,0), +(@PATH,17,3855.896,2027.107,129.5577,0,0,0,0,100,0), +(@PATH,18,3856.646,2028.857,130.0577,0,0,0,0,100,0), +(@PATH,19,3857.646,2030.607,130.8077,0,0,0,0,100,0), +(@PATH,20,3858.896,2033.357,131.3077,0,0,0,0,100,0), +(@PATH,21,3860.146,2036.107,132.0577,0,0,0,0,100,0), +(@PATH,22,3862.396,2040.607,132.8077,0,0,0,0,100,0), +(@PATH,23,3865.896,2048.357,133.3077,0,0,0,0,100,0), +(@PATH,24,3862.61,2041.309,132.7594,0,0,0,0,100,0), +(@PATH,25,3860.11,2035.809,132.2594,0,0,0,0,100,0), +(@PATH,26,3859.11,2034.059,131.5094,0,0,0,0,100,0), +(@PATH,27,3858.36,2032.309,131.0094,0,0,0,0,100,0), +(@PATH,28,3857.36,2030.309,130.2594,0,0,0,0,100,0), +(@PATH,29,3856.11,2027.809,129.7594,0,0,0,0,100,0), +(@PATH,30,3855.36,2025.809,129.0094,0,0,0,0,100,0), +(@PATH,31,3854.11,2023.059,128.2594,0,0,0,0,100,0); + +-- 2. Anub'ar Slayer +SET @NPC := 118392; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3978.878,`position_y`=2129.151,`position_z`=131.7932 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,3978.878,2129.151,131.7932,0,0,0,0,100,0), +(@PATH,2,3980.628,2130.151,132.5432,0,0,0,0,100,0), +(@PATH,3,3981.628,2130.651,132.7932,0,0,0,0,100,0), +(@PATH,4,3983.128,2133.151,133.7932,0,0,0,0,100,0), +(@PATH,5,3984.378,2134.651,134.7932,0,0,0,0,100,0), +(@PATH,6,3985.878,2136.901,135.2932,0,0,0,0,100,0), +(@PATH,7,3986.878,2138.651,136.0432,0,0,0,0,100,0), +(@PATH,8,3988.628,2141.151,136.7932,0,0,0,0,100,0), +(@PATH,9,3989.628,2142.651,137.5432,0,0,0,0,100,0), +(@PATH,10,3990.824,2144.517,138.8614,0,0,0,0,100,0), +(@PATH,11,3991.074,2146.267,139.6114,0,0,0,0,100,0), +(@PATH,12,3991.324,2148.267,140.6114,0,0,0,0,100,0), +(@PATH,13,3991.15,2146.69,139.8553,0,0,0,0,100,0), +(@PATH,14,3991.4,2148.69,140.8553,0,0,0,0,100,0), +(@PATH,15,3991.4,2149.44,141.3553,0,0,0,0,100,0), +(@PATH,16,3990.9,2151.19,142.1053,0,0,0,0,100,0), +(@PATH,17,3990.4,2153.94,143.1053,0,0,0,0,100,0), +(@PATH,18,3990.002,2154.259,143.4339,0,0,0,0,100,0), +(@PATH,19,3989.752,2155.509,144.1839,0,0,0,0,100,0), +(@PATH,20,3987.252,2156.509,144.9339,0,0,0,0,100,0), +(@PATH,21,3986.963,2156.64,145.1332,0,0,0,0,100,0), +(@PATH,22,3985.213,2157.64,145.8832,0,0,0,0,100,0), +(@PATH,23,3982.963,2158.64,147.3832,0,0,0,0,100,0), +(@PATH,24,3981.213,2159.64,148.3832,0,0,0,0,100,0), +(@PATH,25,3980.972,2159.955,148.7739,0,0,0,0,100,0), +(@PATH,26,3979.222,2160.955,149.7739,0,0,0,0,100,0), +(@PATH,27,3976.222,2161.205,150.2739,0,0,0,0,100,0), +(@PATH,28,3975.472,2161.455,150.7739,0,0,0,0,100,0), +(@PATH,29,3973.472,2161.955,151.5239,0,0,0,0,100,0), +(@PATH,30,3971.472,2162.455,152.2739,0,0,0,0,100,0), +(@PATH,31,3973.324,2162.219,151.6995,0,0,0,0,100,0), +(@PATH,32,3971.324,2162.469,152.4495,0,0,0,0,100,0), +(@PATH,33,3970.824,2162.469,152.6995,0,0,0,0,100,0), +(@PATH,34,3967.824,2162.719,153.1995,0,0,0,0,100,0), +(@PATH,35,3966.074,2162.719,153.6995,0,0,0,0,100,0), +(@PATH,36,3963.074,2162.969,154.4495,0,0,0,0,100,0), +(@PATH,37,3960.074,2162.969,155.1995,0,0,0,0,100,0), +(@PATH,38,3961.69,2162.802,154.4806,0,0,0,0,100,0), +(@PATH,39,3965.44,2162.802,153.7306,0,0,0,0,100,0), +(@PATH,40,3967.44,2162.802,153.4806,0,0,0,0,100,0), +(@PATH,41,3970.44,2162.802,152.7306,0,0,0,0,100,0), +(@PATH,42,3971.105,2162.66,152.28,0,0,0,0,100,0), +(@PATH,43,3974.105,2161.91,151.53,0,0,0,0,100,0), +(@PATH,44,3975.855,2161.66,150.78,0,0,0,0,100,0), +(@PATH,45,3977.605,2161.16,150.03,0,0,0,0,100,0), +(@PATH,46,3977.957,2160.945,149.8899,0,0,0,0,100,0), +(@PATH,47,3979.207,2160.695,149.3899,0,0,0,0,100,0), +(@PATH,48,3981.457,2159.445,147.8899,0,0,0,0,100,0), +(@PATH,49,3983.457,2158.695,147.1399,0,0,0,0,100,0), +(@PATH,50,3985.337,2157.532,145.9426,0,0,0,0,100,0), +(@PATH,51,3987.837,2156.282,144.4426,0,0,0,0,100,0), +(@PATH,52,3989.813,2155.219,143.7359,0,0,0,0,100,0), +(@PATH,53,3990.313,2153.219,142.9859,0,0,0,0,100,0), +(@PATH,54,3990.813,2151.719,142.4859,0,0,0,0,100,0), +(@PATH,55,3991.367,2149.397,141.2258,0,0,0,0,100,0), +(@PATH,56,3991.117,2147.647,140.2258,0,0,0,0,100,0), +(@PATH,57,3991.117,2145.647,139.2258,0,0,0,0,100,0), +(@PATH,58,3990.926,2145.543,138.8234,0,0,0,0,100,0), +(@PATH,59,3990.926,2144.293,138.5734,0,0,0,0,100,0), +(@PATH,60,3990.426,2143.543,137.8234,0,0,0,0,100,0), +(@PATH,61,3989.176,2141.793,137.3234,0,0,0,0,100,0), +(@PATH,62,3987.926,2140.293,136.3234,0,0,0,0,100,0), +(@PATH,63,3986.426,2138.043,135.8234,0,0,0,0,100,0), +(@PATH,64,3985.426,2136.293,135.0734,0,0,0,0,100,0), +(@PATH,65,3983.676,2133.793,134.3234,0,0,0,0,100,0), +(@PATH,66,3982.676,2132.293,133.5734,0,0,0,0,100,0), +(@PATH,67,3979.418,2129.389,132.0764,0,0,0,0,100,0), +(@PATH,68,3977.918,2128.639,131.5764,0,0,0,0,100,0), +(@PATH,69,3977.643,2128.496,131.3747,0,0,0,0,100,0), +(@PATH,70,3976.143,2127.496,131.1247,0,0,0,0,100,0), +(@PATH,71,3967.499,2124.963,131.3031,0,0,0,0,100,0), +(@PATH,72,3967.552,2125.067,131.1799,0,0,0,0,100,0), +(@PATH,73,3967.832,2125.401,131.2291,0,0,0,0,100,0), +(@PATH,74,3973.332,2126.651,130.9791,0,0,0,0,100,0), +(@PATH,75,3976.264,2127.636,131.0546,0,0,0,0,100,0); + +-- 3. stalker enable movement +UPDATE `smart_scripts` SET `action_param1`=1 WHERE `entryorguid`=26607 AND `source_type`=0 AND `id`=0 AND `link`=0; + +-- 4. Anub'ar Cultist +SET @NPC := 115322; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4139.638,`position_y`=2187.776,`position_z`=152.073 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,4139.638,2187.776,152.073,0,0,0,0,100,0), +(@PATH,2,4125.222,2173.401,152.7884,0,0,0,0,100,0), +(@PATH,3,4129.722,2171.401,153.0384,0,0,0,0,100,0), +(@PATH,4,4136.261,2167.771,153.5541,0,0,0,0,100,0), +(@PATH,5,4156.122,2169.477,153.4162,0,0,0,0,100,0), +(@PATH,6,4156.622,2177.477,153.6662,0,0,0,0,100,0), +(@PATH,7,4159.279,2204.962,154.0739,0,0,0,0,100,0), +(@PATH,8,4148.779,2202.462,153.3239,0,0,0,0,100,0), +(@PATH,9,4146.029,2202.212,152.8239,0,0,0,0,100,0), +(@PATH,10,4148.566,2202.461,153.3116,0,0,0,0,100,0), +(@PATH,11,4145.816,2201.961,152.5616,0,0,0,0,100,0), +(@PATH,12,4145.316,2201.711,152.5616,0,0,0,0,100,0), +(@PATH,13,4143.816,2197.211,152.0616,0,0,0,0,100,0); + +-- 5. Anub'ar Cultist +SET @NPC := 115442; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4072.145,`position_y`=2152.87,`position_z`=151.803 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,4072.145,2152.87,151.803,0,0,0,0,100,0), +(@PATH,2,4063.289,2153.308,151.6255,0,0,0,0,100,0), +(@PATH,3,4036.269,2125.901,152.128,0,0,0,0,100,0), +(@PATH,4,4036.519,2121.901,152.628,0,0,0,0,100,0), +(@PATH,5,4037.019,2118.151,153.378,0,0,0,0,100,0), +(@PATH,6,4037.574,2113.689,153.5098,0,0,0,0,100,0), +(@PATH,7,4049.074,2115.439,153.7598,0,0,0,0,100,0), +(@PATH,8,4053.959,2116.021,154.2183,0,0,0,0,100,0), +(@PATH,9,4058.459,2099.771,153.4683,0,0,0,0,100,0), +(@PATH,10,4058.754,2099.856,153.4853,0,0,0,0,100,0), +(@PATH,11,4059.504,2097.106,153.2353,0,0,0,0,100,0), +(@PATH,12,4071.065,2106.125,153.3759,0,0,0,0,100,0), +(@PATH,13,4064.68,2124.183,153.3009,0,0,0,0,100,0), +(@PATH,14,4063.93,2130.183,152.8009,0,0,0,0,100,0), +(@PATH,15,4062.723,2138.603,152.7833,0,0,0,0,100,0), +(@PATH,16,4071.648,2140.312,152.1933,0,0,0,0,100,0), +(@PATH,17,4072.156,2152.939,151.7936,0,0,0,0,100,0); + +-- 6. Anub'ar Underlord +SET @NPC := 118240; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3764.97,`position_y`=2077.278,`position_z`=27.45173 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,3764.97,2077.278,27.45173,0,0,0,0,100,0), +(@PATH,2,3765.22,2075.278,26.45173,0,0,0,0,100,0), +(@PATH,3,3765.97,2072.528,25.20173,0,0,0,0,100,0), +(@PATH,4,3765.97,2071.278,24.45173,0,0,0,0,100,0), +(@PATH,5,3766.72,2067.278,22.95173,0,0,0,0,100,0), +(@PATH,6,3766.97,2065.028,22.20173,0,0,0,0,100,0), +(@PATH,7,3767.851,2060.972,20.25034,0,0,0,0,100,0), +(@PATH,8,3767.101,2058.972,19.75034,0,0,0,0,100,0), +(@PATH,9,3766.101,2056.472,19.75034,0,0,0,0,100,0), +(@PATH,10,3765.601,2055.222,19.25034,0,0,0,0,100,0), +(@PATH,11,3764.351,2051.472,19.25034,0,0,0,0,100,0), +(@PATH,12,3763.351,2047.972,19.00034,0,0,0,0,100,0), +(@PATH,13,3762.851,2046.722,19.00034,0,0,0,0,100,0), +(@PATH,14,3762.351,2045.222,19.00034,0,0,0,0,100,0), +(@PATH,15,3761.101,2041.972,18.75034,0,0,0,0,100,0), +(@PATH,16,3760.875,2041.626,18.76631,0,0,0,0,100,0), +(@PATH,17,3760.375,2040.626,18.76631,0,0,0,0,100,0), +(@PATH,18,3753.875,2033.876,19.51631,0,0,0,0,100,0), +(@PATH,19,3750.625,2029.626,20.26631,0,0,0,0,100,0), +(@PATH,20,3750.561,2029.815,20.21903,0,0,0,0,100,0), +(@PATH,21,3754.061,2033.565,19.71903,0,0,0,0,100,0), +(@PATH,22,3760.538,2040.82,18.7297,0,0,0,0,100,0), +(@PATH,23,3761.038,2041.82,18.4797,0,0,0,0,100,0), +(@PATH,24,3762.288,2045.32,18.9797,0,0,0,0,100,0), +(@PATH,25,3762.788,2046.82,18.9797,0,0,0,0,100,0), +(@PATH,26,3763.038,2048.07,18.9797,0,0,0,0,100,0), +(@PATH,27,3764.288,2051.07,19.2297,0,0,0,0,100,0), +(@PATH,28,3765.788,2055.07,19.4797,0,0,0,0,100,0), +(@PATH,29,3766.038,2056.57,19.4797,0,0,0,0,100,0), +(@PATH,30,3767.038,2058.82,19.7297,0,0,0,0,100,0), +(@PATH,31,3767.726,2061.085,20.49327,0,0,0,0,100,0), +(@PATH,32,3766.976,2065.085,21.99327,0,0,0,0,100,0), +(@PATH,33,3766.726,2067.335,22.99327,0,0,0,0,100,0), +(@PATH,34,3765.976,2071.085,24.49327,0,0,0,0,100,0), +(@PATH,35,3765.726,2072.585,25.24327,0,0,0,0,100,0), +(@PATH,36,3765.226,2075.335,26.49327,0,0,0,0,100,0), +(@PATH,37,3764.976,2077.335,27.49327,0,0,0,0,100,0); + +-- 7. Rabid Grizzly +UPDATE `creature` SET `spawndist`=15 WHERE `id`=26643 AND `MovementType`=1; + +-- 8. unneded creature +DELETE FROM `creature` WHERE `guid`=106838; + +-- 9. Arctic Grizzly +SET @NPC := 106550; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3481.951,`position_y`=1739.695,`position_z`=74.35007 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,3481.951,1739.695,74.35007,0,0,0,0,100,0), +(@PATH,2,3480.951,1729.945,75.10007,0,0,0,0,100,0), +(@PATH,3,3480.406,1727.057,75.38726,0,0,0,0,100,0), +(@PATH,4,3474.906,1722.557,76.13726,0,0,0,0,100,0), +(@PATH,5,3471.406,1719.807,76.38726,0,0,0,0,100,0), +(@PATH,6,3468.906,1717.807,77.13726,0,0,0,0,100,0), +(@PATH,7,3465.906,1715.557,77.63726,0,0,0,0,100,0), +(@PATH,8,3465.586,1715.328,77.93961,0,0,0,0,100,0), +(@PATH,9,3462.586,1713.078,78.43961,0,0,0,0,100,0), +(@PATH,10,3458.586,1713.578,78.93961,0,0,0,0,100,0), +(@PATH,11,3454.586,1713.828,79.43961,0,0,0,0,100,0), +(@PATH,12,3449.836,1714.328,79.93961,0,0,0,0,100,0), +(@PATH,13,3445.836,1714.828,80.68961,0,0,0,0,100,0), +(@PATH,14,3442.836,1715.078,81.18961,0,0,0,0,100,0), +(@PATH,15,3439.06,1715.405,82.13708,0,0,0,0,100,0), +(@PATH,16,3439.56,1716.905,81.88708,0,0,0,0,100,0), +(@PATH,17,3439.56,1721.155,81.88708,0,0,0,0,100,0), +(@PATH,18,3440.56,1725.155,81.88708,0,0,0,0,100,0), +(@PATH,19,3440.56,1727.405,81.88708,0,0,0,0,100,0), +(@PATH,20,3440.56,1729.155,81.88708,0,0,0,0,100,0), +(@PATH,21,3439.56,1730.655,82.38708,0,0,0,0,100,0), +(@PATH,22,3437.81,1732.905,82.88708,0,0,0,0,100,0), +(@PATH,23,3437.31,1734.405,82.88708,0,0,0,0,100,0), +(@PATH,24,3437.31,1735.405,82.88708,0,0,0,0,100,0), +(@PATH,25,3436.81,1737.405,82.63708,0,0,0,0,100,0), +(@PATH,26,3436.422,1741.343,82.92067,0,0,0,0,100,0), +(@PATH,27,3436.672,1748.343,82.42067,0,0,0,0,100,0), +(@PATH,28,3436.922,1757.093,81.67067,0,0,0,0,100,0), +(@PATH,29,3436.922,1761.093,81.17067,0,0,0,0,100,0), +(@PATH,30,3437.172,1765.093,80.67067,0,0,0,0,100,0), +(@PATH,31,3437.422,1767.843,80.17067,0,0,0,0,100,0), +(@PATH,32,3437.422,1771.843,79.42067,0,0,0,0,100,0), +(@PATH,33,3437.699,1772.124,79.32373,0,0,0,0,100,0), +(@PATH,34,3437.699,1772.874,79.32373,0,0,0,0,100,0), +(@PATH,35,3440.449,1775.874,78.32373,0,0,0,0,100,0), +(@PATH,36,3442.449,1778.124,77.82373,0,0,0,0,100,0), +(@PATH,37,3444.949,1780.874,77.32373,0,0,0,0,100,0), +(@PATH,38,3448.449,1784.374,76.57373,0,0,0,0,100,0), +(@PATH,39,3439.527,1774.827,78.44974,0,0,0,0,100,0), +(@PATH,40,3441.005,1776.632,78.0695,0,0,0,0,100,0), +(@PATH,41,3444.505,1780.132,77.3195,0,0,0,0,100,0), +(@PATH,42,3447.005,1782.882,76.8195,0,0,0,0,100,0), +(@PATH,43,3450.255,1786.632,76.3195,0,0,0,0,100,0), +(@PATH,44,3450.573,1786.573,76.03406,0,0,0,0,100,0), +(@PATH,45,3451.823,1787.823,75.78406,0,0,0,0,100,0), +(@PATH,46,3457.823,1787.573,75.28406,0,0,0,0,100,0), +(@PATH,47,3468.269,1786.707,74.7675,0,0,0,0,100,0), +(@PATH,48,3476.019,1772.957,74.2675,0,0,0,0,100,0), +(@PATH,49,3484.32,1758.88,74.12106,0,0,0,0,100,0); + +-- 10. Arctic Grizzly +SET @NPC := 106529; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3449.267,`position_y`=1832.76,`position_z`=73.18204 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,3449.267,1832.76,73.18204,0,0,0,0,100,0), +(@PATH,2,3449.145,1833.027,73.57118,0,0,0,0,100,0), +(@PATH,3,3445.395,1833.777,74.07118,0,0,0,0,100,0), +(@PATH,4,3441.395,1834.777,75.07118,0,0,0,0,100,0), +(@PATH,5,3439.645,1834.777,76.07118,0,0,0,0,100,0), +(@PATH,6,3436.895,1835.527,76.82118,0,0,0,0,100,0), +(@PATH,7,3434.895,1835.777,77.57118,0,0,0,0,100,0), +(@PATH,8,3432.895,1836.277,78.32118,0,0,0,0,100,0), +(@PATH,9,3432.998,1836.261,78.43837,0,0,0,0,100,0), +(@PATH,10,3430.998,1836.761,79.18837,0,0,0,0,100,0), +(@PATH,11,3431.748,1835.011,78.68837,0,0,0,0,100,0), +(@PATH,12,3432.498,1833.011,77.93837,0,0,0,0,100,0), +(@PATH,13,3434.248,1829.511,77.68837,0,0,0,0,100,0), +(@PATH,14,3437.604,1822.21,77.63651,0,0,0,0,100,0), +(@PATH,15,3439.354,1813.71,78.13651,0,0,0,0,100,0), +(@PATH,16,3441.048,1805.784,78.10193,0,0,0,0,100,0), +(@PATH,17,3444.048,1800.784,77.35193,0,0,0,0,100,0), +(@PATH,18,3445.798,1797.284,76.85193,0,0,0,0,100,0), +(@PATH,19,3446.03,1797.108,76.77455,0,0,0,0,100,0), +(@PATH,20,3448.03,1794.108,76.27455,0,0,0,0,100,0), +(@PATH,21,3451.78,1793.358,75.77455,0,0,0,0,100,0), +(@PATH,22,3457.53,1791.858,75.52455,0,0,0,0,100,0), +(@PATH,23,3461.201,1791.049,75.08163,0,0,0,0,100,0), +(@PATH,24,3469.701,1791.799,74.58163,0,0,0,0,100,0), +(@PATH,25,3477.701,1792.049,74.08163,0,0,0,0,100,0), +(@PATH,26,3477.925,1792.344,73.87752,0,0,0,0,100,0), +(@PATH,27,3478.675,1792.344,73.87752,0,0,0,0,100,0), +(@PATH,28,3482.925,1800.344,73.12752,0,0,0,0,100,0), +(@PATH,29,3485.925,1806.344,72.62752,0,0,0,0,100,0), +(@PATH,30,3491.197,1815.79,72.10048,0,0,0,0,100,0), +(@PATH,31,3493.197,1835.54,71.60048,0,0,0,0,100,0), +(@PATH,32,3493.164,1835.473,71.6538,0,0,0,0,100,0), +(@PATH,33,3493.164,1836.973,71.4038,0,0,0,0,100,0), +(@PATH,34,3476.524,1835.397,71.76717,0,0,0,0,100,0), +(@PATH,35,3456.774,1833.647,72.26717,0,0,0,0,100,0), +(@PATH,36,3452.774,1833.397,72.76717,0,0,0,0,100,0); + +-- 11. Arctic Grizzly +SET @NPC := 106539; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3521.5,`position_y`=1542.095,`position_z`=78.4709 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,3521.5,1542.095,78.4709,0,0,0,0,100,0), +(@PATH,2,3527.75,1521.345,78.9709,0,0,0,0,100,0), +(@PATH,3,3529.25,1516.595,79.4709,0,0,0,0,100,0), +(@PATH,4,3522.44,1537.992,78.17085,0,0,0,0,100,0), +(@PATH,5,3527.488,1521.912,78.91429,0,0,0,0,100,0), +(@PATH,6,3529.238,1516.162,79.41429,0,0,0,0,100,0), +(@PATH,7,3529.923,1513.275,79.85568,0,0,0,0,100,0), +(@PATH,8,3528.608,1507.05,80.59282,0,0,0,0,100,0), +(@PATH,9,3530.608,1505.05,81.34282,0,0,0,0,100,0), +(@PATH,10,3534.358,1501.55,82.09282,0,0,0,0,100,0), +(@PATH,11,3549.608,1486.3,81.34282,0,0,0,0,100,0), +(@PATH,12,3552.918,1483.245,81.48457,0,0,0,0,100,0), +(@PATH,13,3540.918,1484.495,81.98457,0,0,0,0,100,0), +(@PATH,14,3532.918,1485.495,82.48457,0,0,0,0,100,0), +(@PATH,15,3515.317,1487.455,82.82484,0,0,0,0,100,0), +(@PATH,16,3513.567,1494.205,82.32484,0,0,0,0,100,0), +(@PATH,17,3512.317,1498.955,81.57484,0,0,0,0,100,0), +(@PATH,18,3511.317,1502.955,81.32484,0,0,0,0,100,0), +(@PATH,19,3509.817,1508.455,80.57484,0,0,0,0,100,0), +(@PATH,20,3505.693,1523.168,80.0349,0,0,0,0,100,0), +(@PATH,21,3510.693,1529.418,79.2849,0,0,0,0,100,0), +(@PATH,22,3514.943,1534.418,79.0349,0,0,0,0,100,0); + +-- 12. Arctic Grizzly +SET @NPC := 106555; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3534.733,`position_y`=1463.331,`position_z`=80.96077 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,3534.733,1463.331,80.96077,0,0,0,0,100,0), +(@PATH,2,3517.525,1444.107,81.40329,0,0,0,0,100,0), +(@PATH,3,3513.775,1437.107,82.15329,0,0,0,0,100,0), +(@PATH,4,3511.525,1431.857,82.40329,0,0,0,0,100,0), +(@PATH,5,3509.775,1428.357,83.15329,0,0,0,0,100,0), +(@PATH,6,3507.525,1423.857,83.90329,0,0,0,0,100,0), +(@PATH,7,3507.099,1423.537,83.95262,0,0,0,0,100,0), +(@PATH,8,3506.349,1422.037,84.20262,0,0,0,0,100,0), +(@PATH,9,3504.349,1417.537,84.45262,0,0,0,0,100,0), +(@PATH,10,3500.099,1406.537,85.20262,0,0,0,0,100,0), +(@PATH,11,3495.931,1396.913,85.77196,0,0,0,0,100,0), +(@PATH,12,3500.681,1395.163,86.27196,0,0,0,0,100,0), +(@PATH,13,3505.431,1393.413,86.77196,0,0,0,0,100,0), +(@PATH,14,3508.181,1392.413,87.27196,0,0,0,0,100,0), +(@PATH,15,3511.681,1390.913,87.77196,0,0,0,0,100,0), +(@PATH,16,3515.431,1389.663,88.52196,0,0,0,0,100,0), +(@PATH,17,3518.931,1388.163,89.27196,0,0,0,0,100,0), +(@PATH,18,3501.829,1394.554,85.97783,0,0,0,0,100,0), +(@PATH,19,3505.768,1393.15,86.8895,0,0,0,0,100,0), +(@PATH,20,3508.518,1391.9,87.6395,0,0,0,0,100,0), +(@PATH,21,3512.018,1390.9,87.8895,0,0,0,0,100,0), +(@PATH,22,3514.768,1389.65,88.6395,0,0,0,0,100,0), +(@PATH,23,3519.518,1387.9,89.1395,0,0,0,0,100,0), +(@PATH,24,3519.695,1387.92,89.08109,0,0,0,0,100,0), +(@PATH,25,3520.945,1387.42,89.58109,0,0,0,0,100,0), +(@PATH,26,3540.021,1398.454,89.58588,0,0,0,0,100,0), +(@PATH,27,3550.771,1405.204,90.08588,0,0,0,0,100,0), +(@PATH,28,3556.521,1408.954,90.83588,0,0,0,0,100,0), +(@PATH,29,3560.511,1411.545,91.08447,0,0,0,0,100,0), +(@PATH,30,3561.261,1419.545,90.58447,0,0,0,0,100,0), +(@PATH,31,3562.511,1428.545,89.83447,0,0,0,0,100,0), +(@PATH,32,3563.761,1438.045,89.33447,0,0,0,0,100,0), +(@PATH,33,3564.261,1442.045,88.83447,0,0,0,0,100,0), +(@PATH,34,3565.011,1448.045,88.33447,0,0,0,0,100,0), +(@PATH,35,3565.056,1448.33,88.06328,0,0,0,0,100,0), +(@PATH,36,3565.306,1449.83,87.81328,0,0,0,0,100,0), +(@PATH,37,3562.556,1451.08,87.06328,0,0,0,0,100,0), +(@PATH,38,3559.806,1452.33,86.56328,0,0,0,0,100,0), +(@PATH,39,3557.806,1453.08,85.81328,0,0,0,0,100,0), +(@PATH,40,3556.056,1453.83,85.06328,0,0,0,0,100,0), +(@PATH,41,3553.306,1455.08,84.56328,0,0,0,0,100,0), +(@PATH,42,3551.556,1455.83,84.06328,0,0,0,0,100,0), +(@PATH,43,3549.806,1456.58,83.31328,0,0,0,0,100,0), +(@PATH,44,3548.056,1457.33,82.81328,0,0,0,0,100,0), +(@PATH,45,3544.556,1459.08,82.06328,0,0,0,0,100,0), +(@PATH,46,3540.806,1460.58,81.56328,0,0,0,0,100,0), +(@PATH,47,3534.788,1463.195,80.97893,0,0,0,0,100,0); + +-- 13. Arctic Grizzly +SET @NPC := 106556; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3455.761,`position_y`=1389.917,`position_z`=87.44398 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,3455.761,1389.917,87.44398,0,0,0,0,100,0), +(@PATH,2,3454.761,1392.917,86.94398,0,0,0,0,100,0), +(@PATH,3,3453.511,1395.667,86.44398,0,0,0,0,100,0), +(@PATH,4,3452.511,1398.417,85.69398,0,0,0,0,100,0), +(@PATH,5,3450.511,1403.167,85.44398,0,0,0,0,100,0), +(@PATH,6,3449.011,1407.417,84.69398,0,0,0,0,100,0), +(@PATH,7,3445.261,1416.667,84.19398,0,0,0,0,100,0), +(@PATH,8,3444.911,1417.082,83.78072,0,0,0,0,100,0), +(@PATH,9,3444.661,1417.832,83.78072,0,0,0,0,100,0), +(@PATH,10,3442.661,1420.082,83.28072,0,0,0,0,100,0), +(@PATH,11,3439.411,1423.582,82.53072,0,0,0,0,100,0), +(@PATH,12,3436.911,1426.582,82.03072,0,0,0,0,100,0), +(@PATH,13,3432.936,1430.678,81.68824,0,0,0,0,100,0), +(@PATH,14,3431.186,1430.178,81.68824,0,0,0,0,100,0), +(@PATH,15,3429.186,1429.678,81.93824,0,0,0,0,100,0), +(@PATH,16,3428.186,1429.678,81.93824,0,0,0,0,100,0), +(@PATH,17,3427.186,1429.678,82.18824,0,0,0,0,100,0), +(@PATH,18,3424.936,1430.178,82.18824,0,0,0,0,100,0), +(@PATH,19,3420.186,1429.678,82.93824,0,0,0,0,100,0), +(@PATH,20,3416.936,1429.178,83.18824,0,0,0,0,100,0), +(@PATH,21,3417.03,1429.223,83.38808,0,0,0,0,100,0), +(@PATH,22,3414.28,1429.723,83.38808,0,0,0,0,100,0), +(@PATH,23,3417.03,1417.973,84.13808,0,0,0,0,100,0), +(@PATH,24,3417.53,1415.223,84.63808,0,0,0,0,100,0), +(@PATH,25,3418.28,1412.223,85.38808,0,0,0,0,100,0), +(@PATH,26,3418.78,1409.473,86.13808,0,0,0,0,100,0), +(@PATH,27,3419.28,1406.473,86.88808,0,0,0,0,100,0), +(@PATH,28,3419.443,1406.238,87.10477,0,0,0,0,100,0), +(@PATH,29,3419.943,1404.238,87.35477,0,0,0,0,100,0), +(@PATH,30,3421.693,1400.488,88.10477,0,0,0,0,100,0), +(@PATH,31,3422.943,1397.738,88.60477,0,0,0,0,100,0), +(@PATH,32,3424.943,1393.238,89.10477,0,0,0,0,100,0), +(@PATH,33,3431.943,1377.988,89.85477,0,0,0,0,100,0), +(@PATH,34,3421.011,1401.419,87.52162,0,0,0,0,100,0), +(@PATH,35,3422.643,1398.666,88.66834,0,0,0,0,100,0), +(@PATH,36,3424.643,1394.166,89.16834,0,0,0,0,100,0), +(@PATH,37,3428.643,1385.416,89.66834,0,0,0,0,100,0), +(@PATH,38,3433.494,1374.968,90.31676,0,0,0,0,100,0), +(@PATH,39,3437.744,1369.468,90.81676,0,0,0,0,100,0), +(@PATH,40,3443.744,1361.718,91.31676,0,0,0,0,100,0), +(@PATH,41,3451.327,1352.092,91.52166,0,0,0,0,100,0), +(@PATH,42,3457.827,1356.342,91.02166,0,0,0,0,100,0), +(@PATH,43,3465.905,1361.588,90.31755,0,0,0,0,100,0), +(@PATH,44,3463.655,1368.088,89.81755,0,0,0,0,100,0), +(@PATH,45,3460.905,1375.838,89.31755,0,0,0,0,100,0), +(@PATH,46,3458.905,1382.088,88.56755,0,0,0,0,100,0), +(@PATH,47,3457.405,1385.838,88.31755,0,0,0,0,100,0), +(@PATH,48,3456.155,1389.588,87.56755,0,0,0,0,100,0); + +-- 14. Arctic Grizzly +SET @NPC := 106543; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3701.145,`position_y`=1421.221,`position_z`=97.34148 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,3701.145,1421.221,97.34148,0,0,0,0,100,0), +(@PATH,2,3705.645,1424.721,96.59148,0,0,0,0,100,0), +(@PATH,3,3711.247,1429.553,96.25771,0,0,0,0,100,0), +(@PATH,4,3718.247,1430.803,95.50771,0,0,0,0,100,0), +(@PATH,5,3728.997,1432.553,95.25771,0,0,0,0,100,0), +(@PATH,6,3744.497,1435.553,94.50771,0,0,0,0,100,0), +(@PATH,7,3755.995,1437.502,94.64568,0,0,0,0,100,0), +(@PATH,8,3760.495,1430.752,95.39568,0,0,0,0,100,0), +(@PATH,9,3763.245,1426.752,95.89568,0,0,0,0,100,0), +(@PATH,10,3764.745,1424.252,96.64568,0,0,0,0,100,0), +(@PATH,11,3765.745,1422.502,96.89568,0,0,0,0,100,0), +(@PATH,12,3767.495,1420.252,97.39568,0,0,0,0,100,0), +(@PATH,13,3768.745,1418.752,98.14568,0,0,0,0,100,0), +(@PATH,14,3774.245,1410.502,98.64568,0,0,0,0,100,0), +(@PATH,15,3776.956,1406.144,99.39243,0,0,0,0,100,0), +(@PATH,16,3775.956,1401.144,100.1424,0,0,0,0,100,0), +(@PATH,17,3775.206,1398.394,100.6424,0,0,0,0,100,0), +(@PATH,18,3774.456,1395.394,101.3924,0,0,0,0,100,0), +(@PATH,19,3773.956,1393.394,101.8924,0,0,0,0,100,0), +(@PATH,20,3773.206,1390.644,102.6424,0,0,0,0,100,0), +(@PATH,21,3772.206,1386.894,103.1424,0,0,0,0,100,0), +(@PATH,22,3771.456,1383.144,103.6424,0,0,0,0,100,0), +(@PATH,23,3770.706,1379.144,104.3924,0,0,0,0,100,0), +(@PATH,24,3769.956,1376.144,105.1424,0,0,0,0,100,0), +(@PATH,25,3769.206,1373.394,105.8924,0,0,0,0,100,0), +(@PATH,26,3768.706,1371.394,106.3924,0,0,0,0,100,0), +(@PATH,27,3768.206,1369.394,107.1424,0,0,0,0,100,0), +(@PATH,28,3775.4,1399.415,100.3198,0,0,0,0,100,0), +(@PATH,29,3774.76,1396.617,101.1326,0,0,0,0,100,0), +(@PATH,30,3774.01,1393.617,101.8826,0,0,0,0,100,0), +(@PATH,31,3773.51,1391.617,102.3826,0,0,0,0,100,0), +(@PATH,32,3772.51,1387.867,103.1326,0,0,0,0,100,0), +(@PATH,33,3771.76,1384.867,103.6326,0,0,0,0,100,0), +(@PATH,34,3771.01,1381.117,104.1326,0,0,0,0,100,0), +(@PATH,35,3770.51,1378.367,104.6326,0,0,0,0,100,0), +(@PATH,36,3769.51,1374.367,105.3826,0,0,0,0,100,0), +(@PATH,37,3769.01,1372.367,106.1326,0,0,0,0,100,0), +(@PATH,38,3768.51,1370.617,106.6326,0,0,0,0,100,0), +(@PATH,39,3768.01,1368.617,107.3826,0,0,0,0,100,0), +(@PATH,40,3768.11,1370.323,107.0328,0,0,0,0,100,0), +(@PATH,41,3767.86,1368.323,107.7828,0,0,0,0,100,0), +(@PATH,42,3767.61,1367.823,107.7828,0,0,0,0,100,0), +(@PATH,43,3766.86,1366.073,108.2828,0,0,0,0,100,0), +(@PATH,44,3765.86,1364.073,109.0328,0,0,0,0,100,0), +(@PATH,45,3765.11,1362.323,109.7828,0,0,0,0,100,0), +(@PATH,46,3763.86,1359.573,110.5328,0,0,0,0,100,0), +(@PATH,47,3763.11,1357.823,110.7828,0,0,0,0,100,0), +(@PATH,48,3762.36,1356.323,111.5328,0,0,0,0,100,0), +(@PATH,49,3761.61,1354.323,112.0328,0,0,0,0,100,0), +(@PATH,50,3760.36,1351.573,112.7828,0,0,0,0,100,0), +(@PATH,51,3759.61,1349.823,113.5328,0,0,0,0,100,0), +(@PATH,52,3758.36,1347.073,114.2828,0,0,0,0,100,0), +(@PATH,53,3756.86,1343.573,115.0328,0,0,0,0,100,0), +(@PATH,54,3756.467,1343.57,115.0719,0,0,0,0,100,0), +(@PATH,55,3755.967,1342.07,115.3219,0,0,0,0,100,0), +(@PATH,56,3752.217,1344.07,114.5719,0,0,0,0,100,0), +(@PATH,57,3750.467,1344.82,114.0719,0,0,0,0,100,0), +(@PATH,58,3747.967,1346.32,113.0719,0,0,0,0,100,0), +(@PATH,59,3744.217,1348.07,112.3219,0,0,0,0,100,0), +(@PATH,60,3741.967,1349.57,111.8219,0,0,0,0,100,0), +(@PATH,61,3738.467,1351.07,111.0719,0,0,0,0,100,0), +(@PATH,62,3733.967,1353.32,110.5719,0,0,0,0,100,0), +(@PATH,63,3730.183,1355.318,109.7408,0,0,0,0,100,0), +(@PATH,64,3728.933,1358.318,108.9908,0,0,0,0,100,0), +(@PATH,65,3727.683,1361.068,108.2408,0,0,0,0,100,0), +(@PATH,66,3726.183,1364.568,107.4908,0,0,0,0,100,0), +(@PATH,67,3724.433,1368.318,106.9908,0,0,0,0,100,0), +(@PATH,68,3723.933,1369.818,106.2408,0,0,0,0,100,0), +(@PATH,69,3722.433,1373.568,105.7408,0,0,0,0,100,0), +(@PATH,70,3721.683,1375.318,104.7408,0,0,0,0,100,0), +(@PATH,71,3720.933,1377.318,103.9908,0,0,0,0,100,0), +(@PATH,72,3719.683,1380.068,103.2408,0,0,0,0,100,0), +(@PATH,73,3718.433,1382.818,102.4908,0,0,0,0,100,0), +(@PATH,74,3718.25,1383.087,102.3833,0,0,0,0,100,0), +(@PATH,75,3717.25,1384.837,101.8833,0,0,0,0,100,0), +(@PATH,76,3712.25,1391.087,101.3833,0,0,0,0,100,0), +(@PATH,77,3710.5,1393.087,100.6333,0,0,0,0,100,0), +(@PATH,78,3708.25,1396.337,100.1333,0,0,0,0,100,0), +(@PATH,79,3706.25,1398.587,99.13326,0,0,0,0,100,0), +(@PATH,80,3705,1400.087,98.63326,0,0,0,0,100,0), +(@PATH,81,3700.767,1405.75,97.7948,0,0,0,0,100,0), +(@PATH,82,3700.628,1413.103,97.39193,0,0,0,0,100,0); + +-- 15. Arctic Grizzly +SET @NPC := 106541; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3676.833,`position_y`=1414.063,`position_z`=98.84348 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,3676.833,1414.063,98.84348,0,0,0,0,100,0), +(@PATH,2,3694.586,1400.876,99.14937,0,0,0,0,100,0), +(@PATH,3,3692.336,1396.376,99.89937,0,0,0,0,100,0), +(@PATH,4,3689.836,1392.126,100.3994,0,0,0,0,100,0), +(@PATH,5,3686.586,1385.876,101.1494,0,0,0,0,100,0), +(@PATH,6,3683.336,1380.126,101.6494,0,0,0,0,100,0), +(@PATH,7,3681.086,1375.626,102.1494,0,0,0,0,100,0), +(@PATH,8,3679.586,1372.876,102.8994,0,0,0,0,100,0), +(@PATH,9,3677.586,1369.376,103.8994,0,0,0,0,100,0), +(@PATH,10,3676.586,1367.626,104.3994,0,0,0,0,100,0), +(@PATH,11,3675.336,1365.126,105.1494,0,0,0,0,100,0), +(@PATH,12,3675.097,1364.952,105.4686,0,0,0,0,100,0), +(@PATH,13,3674.597,1364.202,105.9686,0,0,0,0,100,0), +(@PATH,14,3672.347,1361.952,106.4686,0,0,0,0,100,0), +(@PATH,15,3670.347,1359.952,107.2186,0,0,0,0,100,0), +(@PATH,16,3667.597,1356.952,107.4686,0,0,0,0,100,0), +(@PATH,17,3664.097,1353.702,108.2186,0,0,0,0,100,0), +(@PATH,18,3660.597,1350.202,108.9686,0,0,0,0,100,0), +(@PATH,19,3657.097,1346.702,109.7186,0,0,0,0,100,0), +(@PATH,20,3654.347,1343.702,110.4686,0,0,0,0,100,0), +(@PATH,21,3654.127,1343.598,110.5599,0,0,0,0,100,0), +(@PATH,22,3653.127,1342.598,110.8099,0,0,0,0,100,0), +(@PATH,23,3647.627,1340.598,111.5599,0,0,0,0,100,0), +(@PATH,24,3641.877,1338.348,112.3099,0,0,0,0,100,0), +(@PATH,25,3639.419,1337.456,112.0975,0,0,0,0,100,0), +(@PATH,26,3624.259,1331.715,112.3128,0,0,0,0,100,0), +(@PATH,27,3624.287,1331.878,112.378,0,0,0,0,100,0), +(@PATH,28,3623.287,1333.878,111.628,0,0,0,0,100,0), +(@PATH,29,3622.037,1336.378,110.878,0,0,0,0,100,0), +(@PATH,30,3621.537,1338.378,110.128,0,0,0,0,100,0), +(@PATH,31,3620.537,1340.128,109.378,0,0,0,0,100,0), +(@PATH,32,3619.287,1342.628,108.878,0,0,0,0,100,0), +(@PATH,33,3618.537,1344.378,108.128,0,0,0,0,100,0), +(@PATH,34,3617.537,1346.128,107.378,0,0,0,0,100,0), +(@PATH,35,3616.787,1347.878,106.878,0,0,0,0,100,0), +(@PATH,36,3616.705,1348.066,106.495,0,0,0,0,100,0), +(@PATH,37,3615.705,1350.316,106.245,0,0,0,0,100,0), +(@PATH,38,3618.455,1354.566,105.245,0,0,0,0,100,0), +(@PATH,39,3620.955,1358.816,104.745,0,0,0,0,100,0), +(@PATH,40,3623.455,1362.816,104.245,0,0,0,0,100,0), +(@PATH,41,3625.955,1367.066,103.495,0,0,0,0,100,0), +(@PATH,42,3628.993,1371.444,102.7551,0,0,0,0,100,0), +(@PATH,43,3632.243,1375.194,102.0051,0,0,0,0,100,0), +(@PATH,44,3636.743,1380.694,101.5051,0,0,0,0,100,0), +(@PATH,45,3640.493,1384.944,101.0051,0,0,0,0,100,0), +(@PATH,46,3645.743,1390.944,100.2551,0,0,0,0,100,0), +(@PATH,47,3648.854,1394.165,99.80745,0,0,0,0,100,0), +(@PATH,48,3667.354,1407.415,99.30745,0,0,0,0,100,0); + +-- rndmmove for condor +UPDATE `creature` SET `spawndist`=20 WHERE `guid`=106590; + +-- 16. Arctic Ram +SET @NPC := 101135; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4188.842,`position_y`=1451.876,`position_z`=180.7509 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,4188.842,1451.876,180.7509,0,0,0,0,100,0), +(@PATH,2,4190.092,1450.626,182.0009,0,0,0,0,100,0), +(@PATH,3,4192.342,1448.376,183.2509,0,0,0,0,100,0), +(@PATH,4,4194.842,1445.876,184.5009,0,0,0,0,100,0), +(@PATH,5,4196.342,1444.376,185.2509,0,0,0,0,100,0), +(@PATH,6,4198.342,1442.376,186.0009,0,0,0,0,100,0), +(@PATH,7,4200.592,1440.126,187.2509,0,0,0,0,100,0), +(@PATH,8,4200.806,1439.96,187.4033,0,0,0,0,100,0), +(@PATH,9,4199.556,1441.21,186.6533,0,0,0,0,100,0), +(@PATH,10,4196.556,1444.21,185.1533,0,0,0,0,100,0), +(@PATH,11,4195.306,1445.46,184.6533,0,0,0,0,100,0), +(@PATH,12,4193.306,1447.46,184.1533,0,0,0,0,100,0), +(@PATH,13,4191.306,1449.46,182.6533,0,0,0,0,100,0), +(@PATH,14,4189.056,1451.71,181.1533,0,0,0,0,100,0), +(@PATH,15,4188.963,1452.041,181.1161,0,0,0,0,100,0), +(@PATH,16,4188.463,1452.291,180.6161,0,0,0,0,100,0), +(@PATH,17,4187.213,1453.541,179.3661,0,0,0,0,100,0), +(@PATH,18,4184.963,1455.791,178.6161,0,0,0,0,100,0), +(@PATH,19,4183.713,1456.791,178.1161,0,0,0,0,100,0), +(@PATH,20,4180.713,1459.541,176.3661,0,0,0,0,100,0), +(@PATH,21,4179.463,1461.041,175.3661,0,0,0,0,100,0), +(@PATH,22,4180.656,1459.806,176.1817,0,0,0,0,100,0), +(@PATH,23,4179.156,1461.056,175.1817,0,0,0,0,100,0), +(@PATH,24,4178.156,1462.306,174.6817,0,0,0,0,100,0), +(@PATH,25,4176.656,1463.556,173.9317,0,0,0,0,100,0), +(@PATH,26,4175.906,1464.306,173.4317,0,0,0,0,100,0), +(@PATH,27,4174.906,1465.556,172.6817,0,0,0,0,100,0), +(@PATH,28,4174.156,1466.306,171.9317,0,0,0,0,100,0), +(@PATH,29,4172.656,1467.806,171.4317,0,0,0,0,100,0), +(@PATH,30,4171.406,1469.056,170.6817,0,0,0,0,100,0), +(@PATH,31,4170.656,1469.806,169.9317,0,0,0,0,100,0), +(@PATH,32,4169.906,1470.556,168.6817,0,0,0,0,100,0), +(@PATH,33,4170.206,1470.184,169.8859,0,0,0,0,100,0), +(@PATH,34,4171.706,1468.684,170.6359,0,0,0,0,100,0), +(@PATH,35,4172.456,1467.934,171.1359,0,0,0,0,100,0), +(@PATH,36,4173.706,1466.684,171.8859,0,0,0,0,100,0), +(@PATH,37,4174.956,1465.434,172.6359,0,0,0,0,100,0), +(@PATH,38,4175.706,1464.684,173.3859,0,0,0,0,100,0), +(@PATH,39,4176.956,1463.184,173.8859,0,0,0,0,100,0), +(@PATH,40,4177.706,1462.434,174.6359,0,0,0,0,100,0), +(@PATH,41,4177.146,1462.896,174.3548,0,0,0,0,100,0), +(@PATH,42,4177.896,1462.396,174.8548,0,0,0,0,100,0), +(@PATH,43,4178.396,1461.896,175.1048,0,0,0,0,100,0), +(@PATH,44,4179.646,1460.646,175.6048,0,0,0,0,100,0), +(@PATH,45,4182.396,1458.146,176.8548,0,0,0,0,100,0), +(@PATH,46,4183.896,1456.646,177.8548,0,0,0,0,100,0), +(@PATH,47,4186.646,1453.896,179.3548,0,0,0,0,100,0), +(@PATH,48,4186.964,1453.736,179.5386,0,0,0,0,100,0); + +-- 17. Arctic Ram +SET @NPC := 101132; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4215.616,`position_y`=1515.419,`position_z`=207.816 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,4215.616,1515.419,207.816,0,0,0,0,100,0), +(@PATH,2,4213.616,1511.919,207.066,0,0,0,0,100,0), +(@PATH,3,4212.116,1509.169,205.566,0,0,0,0,100,0), +(@PATH,4,4210.616,1505.919,204.816,0,0,0,0,100,0), +(@PATH,5,4209.616,1504.169,204.316,0,0,0,0,100,0), +(@PATH,6,4208.116,1501.669,203.316,0,0,0,0,100,0), +(@PATH,7,4207.116,1499.919,202.566,0,0,0,0,100,0), +(@PATH,8,4206.116,1498.169,201.566,0,0,0,0,100,0), +(@PATH,9,4204.866,1495.419,200.566,0,0,0,0,100,0), +(@PATH,10,4204.583,1495.215,200.336,0,0,0,0,100,0), +(@PATH,11,4204.333,1494.715,199.836,0,0,0,0,100,0), +(@PATH,12,4203.833,1491.715,198.836,0,0,0,0,100,0), +(@PATH,13,4203.583,1489.965,197.836,0,0,0,0,100,0), +(@PATH,14,4203.333,1489.215,197.336,0,0,0,0,100,0), +(@PATH,15,4202.833,1487.215,196.586,0,0,0,0,100,0), +(@PATH,16,4202.833,1486.215,195.836,0,0,0,0,100,0), +(@PATH,17,4202.333,1484.215,194.836,0,0,0,0,100,0), +(@PATH,18,4202.274,1483.991,194.5572,0,0,0,0,100,0), +(@PATH,19,4202.024,1481.991,194.0572,0,0,0,0,100,0), +(@PATH,20,4206.736,1473.298,193.3837,0,0,0,0,100,0), +(@PATH,21,4206.486,1471.298,192.6337,0,0,0,0,100,0), +(@PATH,22,4206.236,1468.298,191.8837,0,0,0,0,100,0), +(@PATH,23,4205.986,1466.548,191.3837,0,0,0,0,100,0), +(@PATH,24,4205.236,1461.548,190.8837,0,0,0,0,100,0), +(@PATH,25,4205.236,1459.548,190.1337,0,0,0,0,100,0), +(@PATH,26,4205.582,1460.412,190.5629,0,0,0,0,100,0), +(@PATH,27,4205.832,1463.412,191.3129,0,0,0,0,100,0), +(@PATH,28,4206.082,1467.162,191.5629,0,0,0,0,100,0), +(@PATH,29,4206.332,1469.162,192.3129,0,0,0,0,100,0), +(@PATH,30,4206.582,1472.162,193.0629,0,0,0,0,100,0), +(@PATH,31,4206.725,1472.178,193.1707,0,0,0,0,100,0), +(@PATH,32,4206.725,1473.428,193.4207,0,0,0,0,100,0), +(@PATH,33,4201.904,1482.221,194.188,0,0,0,0,100,0), +(@PATH,34,4202.404,1484.221,194.938,0,0,0,0,100,0), +(@PATH,35,4202.404,1485.221,195.438,0,0,0,0,100,0), +(@PATH,36,4202.904,1487.221,196.438,0,0,0,0,100,0), +(@PATH,37,4203.404,1488.971,197.188,0,0,0,0,100,0), +(@PATH,38,4203.654,1489.721,197.938,0,0,0,0,100,0), +(@PATH,39,4203.654,1491.721,198.938,0,0,0,0,100,0), +(@PATH,40,4204.154,1493.721,199.688,0,0,0,0,100,0); + +-- 18. Arctic Ram +SET @NPC := 101131; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4166.649,`position_y`=1502.883,`position_z`=174.9744 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,4166.649,1502.883,174.9744,0,0,0,0,100,0), +(@PATH,2,4166.899,1503.883,175.2244,0,0,0,0,100,0), +(@PATH,3,4166.399,1506.883,176.2244,0,0,0,0,100,0), +(@PATH,4,4165.899,1508.633,177.7244,0,0,0,0,100,0), +(@PATH,5,4165.399,1512.633,179.9744,0,0,0,0,100,0), +(@PATH,6,4165.025,1512.903,180.4279,0,0,0,0,100,0), +(@PATH,7,4164.775,1514.653,181.9279,0,0,0,0,100,0), +(@PATH,8,4164.775,1516.653,184.1779,0,0,0,0,100,0), +(@PATH,9,4164.775,1518.653,185.1779,0,0,0,0,100,0), +(@PATH,10,4164.775,1520.403,185.9279,0,0,0,0,100,0), +(@PATH,11,4164.525,1522.403,187.1779,0,0,0,0,100,0), +(@PATH,12,4164.525,1524.403,188.1779,0,0,0,0,100,0), +(@PATH,13,4164.413,1525.177,188.6098,0,0,0,0,100,0), +(@PATH,14,4164.413,1522.177,187.1098,0,0,0,0,100,0), +(@PATH,15,4164.413,1519.427,185.6098,0,0,0,0,100,0), +(@PATH,16,4164.663,1517.427,184.6098,0,0,0,0,100,0), +(@PATH,17,4164.663,1515.427,182.8598,0,0,0,0,100,0), +(@PATH,18,4164.959,1515.221,182.5752,0,0,0,0,100,0), +(@PATH,19,4164.959,1514.721,182.0752,0,0,0,0,100,0), +(@PATH,20,4165.209,1512.721,180.0752,0,0,0,0,100,0), +(@PATH,21,4165.959,1508.971,178.0752,0,0,0,0,100,0), +(@PATH,22,4166.209,1507.221,176.3252,0,0,0,0,100,0), +(@PATH,23,4166.709,1505.221,175.0752,0,0,0,0,100,0), +(@PATH,24,4166.632,1504.813,174.7487,0,0,0,0,100,0), +(@PATH,25,4166.882,1503.813,174.9987,0,0,0,0,100,0), +(@PATH,26,4166.632,1501.813,174.2487,0,0,0,0,100,0), +(@PATH,27,4166.632,1500.813,172.7487,0,0,0,0,100,0), +(@PATH,28,4166.382,1497.813,171.9987,0,0,0,0,100,0), +(@PATH,29,4166.132,1496.063,171.2487,0,0,0,0,100,0), +(@PATH,30,4165.882,1493.063,170.4987,0,0,0,0,100,0), +(@PATH,31,4165.882,1491.063,169.7487,0,0,0,0,100,0), +(@PATH,32,4165.632,1489.063,168.9987,0,0,0,0,100,0), +(@PATH,33,4165.35,1488.758,168.9216,0,0,0,0,100,0), +(@PATH,34,4165.35,1487.758,168.6716,0,0,0,0,100,0), +(@PATH,35,4164.85,1485.758,167.9216,0,0,0,0,100,0), +(@PATH,36,4164.6,1483.758,166.9216,0,0,0,0,100,0), +(@PATH,37,4164.1,1481.758,165.9216,0,0,0,0,100,0), +(@PATH,38,4163.6,1479.758,165.4216,0,0,0,0,100,0), +(@PATH,39,4163.6,1478.008,164.6716,0,0,0,0,100,0), +(@PATH,40,4163.1,1475.258,164.1716,0,0,0,0,100,0), +(@PATH,41,4162.35,1471.258,163.4216,0,0,0,0,100,0), +(@PATH,42,4163.021,1475.005,164.0384,0,0,0,0,100,0), +(@PATH,43,4163.521,1478.005,164.7884,0,0,0,0,100,0), +(@PATH,44,4163.771,1479.755,165.2884,0,0,0,0,100,0), +(@PATH,45,4164.021,1481.755,165.7884,0,0,0,0,100,0), +(@PATH,46,4164.521,1483.505,166.7884,0,0,0,0,100,0), +(@PATH,47,4165.021,1486.505,168.5384,0,0,0,0,100,0), +(@PATH,48,4165.224,1486.69,168.6532,0,0,0,0,100,0), +(@PATH,49,4165.474,1487.94,168.9032,0,0,0,0,100,0), +(@PATH,50,4165.724,1490.94,169.6532,0,0,0,0,100,0), +(@PATH,51,4165.724,1492.94,170.4032,0,0,0,0,100,0), +(@PATH,52,4165.974,1494.69,170.9032,0,0,0,0,100,0), +(@PATH,53,4166.224,1496.69,171.4032,0,0,0,0,100,0), +(@PATH,54,4166.474,1498.69,172.4032,0,0,0,0,100,0); + +-- 19. Burning Depths Necrolyte <Cult of the Damned> +SET @NPC := 117037; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4375.307,`position_y`=1395.783,`position_z`=140.5138 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,4375.307,1395.783,140.5138,0,0,0,0,100,0), +(@PATH,2,4375.307,1394.783,140.2638,0,0,0,0,100,0), +(@PATH,3,4375.307,1388.783,139.7638,0,0,0,0,100,0), +(@PATH,4,4375.307,1385.783,140.7638,0,0,0,0,100,0), +(@PATH,5,4375.307,1384.783,141.5138,0,0,0,0,100,0), +(@PATH,6,4375.307,1383.783,142.2638,0,0,0,0,100,0), +(@PATH,7,4375.307,1381.033,143.2638,0,0,0,0,100,0), +(@PATH,8,4375.307,1379.033,143.5138,0,0,0,0,100,0), +(@PATH,9,4375.557,1377.033,144.2638,0,0,0,0,100,0), +(@PATH,10,4375.557,1375.033,144.7638,0,0,0,0,100,0), +(@PATH,11,4375.557,1372.033,145.7638,0,0,0,0,100,0), +(@PATH,12,4375.557,1369.033,146.5138,0,0,0,0,100,0), +(@PATH,13,4375.93,1366.373,146.9263,0,0,0,0,100,0), +(@PATH,14,4376.18,1364.373,147.6763,0,0,0,0,100,0), +(@PATH,15,4377.18,1359.373,147.1763,0,0,0,0,100,0), +(@PATH,16,4378.18,1355.623,147.9263,0,0,0,0,100,0), +(@PATH,17,4378.18,1354.623,148.6763,0,0,0,0,100,0), +(@PATH,18,4381.43,1338.123,147.9263,0,0,0,0,100,0), +(@PATH,19,4382.134,1333.749,147.7211,0,0,0,0,100,0), +(@PATH,20,4379.884,1319.249,148.4711,0,0,0,0,100,0), +(@PATH,21,4379.384,1315.249,148.9711,0,0,0,0,100,0), +(@PATH,22,4379.134,1312.249,149.4711,0,0,0,0,100,0), +(@PATH,23,4378.634,1309.249,150.2211,0,0,0,0,100,0), +(@PATH,24,4378.84,1311.001,149.8701,0,0,0,0,100,0), +(@PATH,25,4379.34,1313.751,149.1201,0,0,0,0,100,0), +(@PATH,26,4380.09,1318.751,148.6201,0,0,0,0,100,0), +(@PATH,27,4380.59,1323.501,147.8701,0,0,0,0,100,0), +(@PATH,28,4379.336,1315.488,148.6863,0,0,0,0,100,0), +(@PATH,29,4379.244,1318.646,148.2479,0,0,0,0,100,0), +(@PATH,30,4378.744,1323.646,147.7479,0,0,0,0,100,0), +(@PATH,31,4377.494,1339.646,148.7479,0,0,0,0,100,0), +(@PATH,32,4376.744,1355.396,147.9979,0,0,0,0,100,0), +(@PATH,33,4376.494,1358.396,146.9979,0,0,0,0,100,0), +(@PATH,34,4376.244,1361.396,147.7479,0,0,0,0,100,0), +(@PATH,35,4375.716,1366.575,147.0361,0,0,0,0,100,0), +(@PATH,36,4375.716,1368.575,146.5361,0,0,0,0,100,0), +(@PATH,37,4375.466,1370.575,146.0361,0,0,0,0,100,0), +(@PATH,38,4375.466,1372.575,145.2861,0,0,0,0,100,0), +(@PATH,39,4375.466,1375.575,144.5361,0,0,0,0,100,0), +(@PATH,40,4375.466,1377.575,143.7861,0,0,0,0,100,0), +(@PATH,41,4375.466,1379.325,143.5361,0,0,0,0,100,0), +(@PATH,42,4375.466,1381.325,142.7861,0,0,0,0,100,0), +(@PATH,43,4375.466,1385.325,141.5361,0,0,0,0,100,0), +(@PATH,44,4375.466,1386.325,140.7861,0,0,0,0,100,0), +(@PATH,45,4375.466,1387.325,139.7861,0,0,0,0,100,0), +(@PATH,46,4375.466,1391.325,140.7861,0,0,0,0,100,0), +(@PATH,47,4374.962,1394.948,140.1392,0,0,0,0,100,0), +(@PATH,48,4374.962,1396.948,139.6392,0,0,0,0,100,0), +(@PATH,49,4374.712,1399.948,139.1392,0,0,0,0,100,0), +(@PATH,50,4374.712,1403.948,138.6392,0,0,0,0,100,0), +(@PATH,51,4374.462,1409.698,137.8892,0,0,0,0,100,0), +(@PATH,52,4374.437,1406.731,138.2402,0,0,0,0,100,0), +(@PATH,53,4374.687,1402.981,138.4902,0,0,0,0,100,0), +(@PATH,54,4374.937,1398.981,139.2402,0,0,0,0,100,0), +(@PATH,55,4374.937,1395.981,140.2402,0,0,0,0,100,0); + +-- 20. Burning Depths Necrolyte <Cult of the Damned> +SET @NPC := 117039; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4390.645,`position_y`=1411.049,`position_z`=139.3636 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,4390.645,1411.049,139.3636,0,0,0,0,100,0), +(@PATH,2,4390.895,1409.299,139.1136,0,0,0,0,100,0), +(@PATH,3,4389.645,1404.299,140.1136,0,0,0,0,100,0), +(@PATH,4,4389.145,1401.299,140.6136,0,0,0,0,100,0), +(@PATH,5,4388.395,1398.799,141.1136,0,0,0,0,100,0), +(@PATH,6,4387.645,1394.799,141.8636,0,0,0,0,100,0), +(@PATH,7,4386.595,1389.674,142.2216,0,0,0,0,100,0), +(@PATH,8,4387.595,1385.674,140.9716,0,0,0,0,100,0), +(@PATH,9,4387.845,1384.674,139.7216,0,0,0,0,100,0), +(@PATH,10,4388.095,1383.924,138.9716,0,0,0,0,100,0), +(@PATH,11,4388.345,1382.174,139.9716,0,0,0,0,100,0), +(@PATH,12,4388.595,1381.174,141.2216,0,0,0,0,100,0), +(@PATH,13,4389.095,1379.174,141.9716,0,0,0,0,100,0), +(@PATH,14,4389.595,1378.174,143.2216,0,0,0,0,100,0), +(@PATH,15,4389.845,1377.424,144.2216,0,0,0,0,100,0), +(@PATH,16,4389.562,1377.924,143.5365,0,0,0,0,100,0), +(@PATH,17,4389.812,1377.174,144.5365,0,0,0,0,100,0), +(@PATH,18,4390.062,1376.174,144.5365,0,0,0,0,100,0), +(@PATH,19,4389.812,1374.174,145.0365,0,0,0,0,100,0), +(@PATH,20,4389.812,1372.174,145.5365,0,0,0,0,100,0), +(@PATH,21,4389.562,1369.174,146.2865,0,0,0,0,100,0), +(@PATH,22,4389.562,1367.174,147.0365,0,0,0,0,100,0), +(@PATH,23,4389.312,1365.174,147.5365,0,0,0,0,100,0), +(@PATH,24,4389.312,1362.424,148.0365,0,0,0,0,100,0), +(@PATH,25,4389.062,1359.424,148.7865,0,0,0,0,100,0), +(@PATH,26,4389.062,1357.424,147.7865,0,0,0,0,100,0), +(@PATH,27,4388.812,1355.424,146.5365,0,0,0,0,100,0), +(@PATH,28,4388.812,1351.424,147.2865,0,0,0,0,100,0), +(@PATH,29,4388.812,1349.424,148.7865,0,0,0,0,100,0), +(@PATH,30,4388.525,1346.521,148.9962,0,0,0,0,100,0), +(@PATH,31,4388.775,1340.521,148.2462,0,0,0,0,100,0), +(@PATH,32,4388.775,1332.521,147.7462,0,0,0,0,100,0), +(@PATH,33,4389.025,1319.771,148.2462,0,0,0,0,100,0), +(@PATH,34,4389.025,1314.771,148.9962,0,0,0,0,100,0), +(@PATH,35,4388.973,1313.884,148.9365,0,0,0,0,100,0), +(@PATH,36,4388.973,1318.884,148.4365,0,0,0,0,100,0), +(@PATH,37,4388.723,1323.884,147.9365,0,0,0,0,100,0), +(@PATH,38,4388.723,1340.634,148.4365,0,0,0,0,100,0), +(@PATH,39,4388.706,1346.772,148.8016,0,0,0,0,100,0), +(@PATH,40,4388.706,1350.772,147.3016,0,0,0,0,100,0), +(@PATH,41,4388.956,1352.772,146.5516,0,0,0,0,100,0), +(@PATH,42,4389.206,1355.772,147.3016,0,0,0,0,100,0), +(@PATH,43,4389.206,1357.772,148.5516,0,0,0,0,100,0), +(@PATH,44,4389.456,1364.522,147.8016,0,0,0,0,100,0), +(@PATH,45,4389.456,1366.522,147.0516,0,0,0,0,100,0), +(@PATH,46,4389.706,1369.522,146.3016,0,0,0,0,100,0), +(@PATH,47,4389.706,1371.522,146.0516,0,0,0,0,100,0), +(@PATH,48,4389.956,1374.522,145.0516,0,0,0,0,100,0), +(@PATH,49,4389.836,1374.809,144.7985,0,0,0,0,100,0), +(@PATH,50,4390.086,1376.309,144.2985,0,0,0,0,100,0), +(@PATH,51,4389.586,1378.309,143.2985,0,0,0,0,100,0), +(@PATH,52,4389.336,1379.309,142.0485,0,0,0,0,100,0), +(@PATH,53,4388.836,1380.059,141.2985,0,0,0,0,100,0), +(@PATH,54,4388.336,1381.809,140.0485,0,0,0,0,100,0), +(@PATH,55,4388.086,1383.809,139.0485,0,0,0,0,100,0), +(@PATH,56,4387.836,1384.809,139.7985,0,0,0,0,100,0), +(@PATH,57,4387.586,1385.809,141.0485,0,0,0,0,100,0), +(@PATH,58,4387.336,1386.559,141.7985,0,0,0,0,100,0), +(@PATH,59,4387.349,1387.044,141.5437,0,0,0,0,100,0), +(@PATH,60,4386.599,1389.794,142.0437,0,0,0,0,100,0), +(@PATH,61,4387.849,1395.794,141.5437,0,0,0,0,100,0), +(@PATH,62,4389.099,1400.294,140.7937,0,0,0,0,100,0), +(@PATH,63,4389.599,1404.294,139.7937,0,0,0,0,100,0), +(@PATH,64,4390.599,1408.044,139.2937,0,0,0,0,100,0), +(@PATH,65,4387.381,1394.341,141.5419,0,0,0,0,100,0), +(@PATH,66,4387.803,1399.542,140.961,0,0,0,0,100,0), +(@PATH,67,4387.803,1403.542,140.461,0,0,0,0,100,0), +(@PATH,68,4387.803,1405.542,139.711,0,0,0,0,100,0), +(@PATH,69,4387.803,1408.542,139.211,0,0,0,0,100,0), +(@PATH,70,4387.803,1410.292,138.461,0,0,0,0,100,0), +(@PATH,71,4387.803,1411.292,137.711,0,0,0,0,100,0), +(@PATH,72,4387.803,1412.292,136.961,0,0,0,0,100,0), +(@PATH,73,4387.803,1413.292,136.211,0,0,0,0,100,0), +(@PATH,74,4388.053,1415.292,137.211,0,0,0,0,100,0), +(@PATH,75,4388.053,1417.292,138.211,0,0,0,0,100,0), +(@PATH,76,4388.053,1420.292,137.461,0,0,0,0,100,0), +(@PATH,77,4388.053,1423.292,136.711,0,0,0,0,100,0), +(@PATH,78,4388.303,1425.292,136.211,0,0,0,0,100,0); + +-- 21. Burning Depths Necrolyte <Cult of the Damned> +SET @NPC := 117036; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4435.859,`position_y`=1631.857,`position_z`=127.5077 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,4435.859,1631.857,127.5077,0,0,0,0,100,0), +(@PATH,2,4431.109,1632.607,127.5077,0,0,0,0,100,0), +(@PATH,3,4428.609,1633.107,127.2577,0,0,0,0,100,0), +(@PATH,4,4428.475,1632.951,127.0568,0,0,0,0,100,0), +(@PATH,5,4425.475,1633.451,126.8068,0,0,0,0,100,0), +(@PATH,6,4424.475,1632.951,126.8068,0,0,0,0,100,0), +(@PATH,7,4422.975,1632.451,127.0568,0,0,0,0,100,0), +(@PATH,8,4421.225,1631.451,127.0568,0,0,0,0,100,0), +(@PATH,9,4419.725,1631.201,127.3068,0,0,0,0,100,0), +(@PATH,10,4419.432,1630.834,127.7514,0,0,0,0,100,0), +(@PATH,11,4417.182,1629.834,127.5014,0,0,0,0,100,0), +(@PATH,12,4415.932,1625.084,127.5014,0,0,0,0,100,0), +(@PATH,13,4415.182,1622.084,127.5014,0,0,0,0,100,0), +(@PATH,14,4414.432,1620.334,127.7514,0,0,0,0,100,0), +(@PATH,15,4413.432,1616.834,128.2514,0,0,0,0,100,0), +(@PATH,16,4412.584,1613.733,128.5013,0,0,0,0,100,0), +(@PATH,17,4407.584,1607.983,128.5013,0,0,0,0,100,0), +(@PATH,18,4407.739,1607.879,128.4342,0,0,0,0,100,0), +(@PATH,19,4412.698,1614.088,128.5545,0,0,0,0,100,0), +(@PATH,20,4413.448,1616.838,128.0545,0,0,0,0,100,0), +(@PATH,21,4414.198,1620.338,127.8045,0,0,0,0,100,0), +(@PATH,22,4414.698,1621.838,127.5545,0,0,0,0,100,0), +(@PATH,23,4415.698,1625.088,127.3045,0,0,0,0,100,0), +(@PATH,24,4417.482,1629.833,127.2481,0,0,0,0,100,0), +(@PATH,25,4419.732,1630.833,127.4981,0,0,0,0,100,0), +(@PATH,26,4420.982,1631.583,127.2481,0,0,0,0,100,0), +(@PATH,27,4422.732,1632.333,126.9981,0,0,0,0,100,0), +(@PATH,28,4424.482,1633.083,126.7481,0,0,0,0,100,0), +(@PATH,29,4424.64,1633.052,126.7388,0,0,0,0,100,0), +(@PATH,30,4425.89,1633.552,126.9888,0,0,0,0,100,0), +(@PATH,31,4428.64,1633.052,127.2388,0,0,0,0,100,0), +(@PATH,32,4431.14,1632.552,127.4888,0,0,0,0,100,0), +(@PATH,33,4435.64,1631.802,127.4888,0,0,0,0,100,0); + +-- 22. Fordragon Marksman +SET @NPC := 133467; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4537.731,`position_y`=1521.444,`position_z`=231.3829 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,4537.731,1521.444,231.3829,0,0,0,0,100,0), +(@PATH,2,4535.481,1519.444,232.3829,0,0,0,0,100,0), +(@PATH,3,4533.231,1517.444,232.8829,0,0,0,0,100,0), +(@PATH,4,4530.981,1515.944,233.6329,0,0,0,0,100,0), +(@PATH,5,4527.981,1513.194,234.3829,0,0,0,0,100,0), +(@PATH,6,4527.713,1513.105,234.7522,0,0,0,0,100,0), +(@PATH,7,4525.463,1511.105,235.2522,0,0,0,0,100,0), +(@PATH,8,4524.963,1509.355,236.0022,0,0,0,0,100,0), +(@PATH,9,4523.713,1506.605,236.7522,0,0,0,0,100,0), +(@PATH,10,4522.963,1504.855,237.2522,0,0,0,0,100,0), +(@PATH,11,4522.713,1503.855,237.7522,0,0,0,0,100,0), +(@PATH,12,4522.213,1503.105,238.5022,0,0,0,0,100,0), +(@PATH,13,4522.544,1503.647,238.0983,0,0,0,0,100,0), +(@PATH,14,4522.044,1502.647,238.8483,0,0,0,0,100,0), +(@PATH,15,4521.794,1501.897,239.8483,0,0,0,0,100,0), +(@PATH,16,4520.294,1499.647,241.3483,0,0,0,0,100,0), +(@PATH,17,4518.544,1497.147,242.5983,0,0,0,0,100,0), +(@PATH,18,4518.346,1496.989,242.8267,0,0,0,0,100,0), +(@PATH,19,4517.846,1496.489,243.3267,0,0,0,0,100,0), +(@PATH,20,4516.346,1495.239,244.0767,0,0,0,0,100,0), +(@PATH,21,4514.096,1493.739,245.5767,0,0,0,0,100,0), +(@PATH,22,4512.346,1492.489,246.5767,0,0,0,0,100,0), +(@PATH,23,4510.846,1491.489,247.3267,0,0,0,0,100,0), +(@PATH,24,4512.135,1492.247,247.0319,0,0,0,0,100,0), +(@PATH,25,4510.635,1491.247,247.5319,0,0,0,0,100,0), +(@PATH,26,4510.135,1490.747,248.0319,0,0,0,0,100,0), +(@PATH,27,4509.635,1488.747,248.7819,0,0,0,0,100,0), +(@PATH,28,4509.385,1486.747,249.5319,0,0,0,0,100,0), +(@PATH,29,4508.885,1484.997,250.2819,0,0,0,0,100,0), +(@PATH,30,4508.635,1482.997,251.2819,0,0,0,0,100,0), +(@PATH,31,4508.135,1479.997,252.0319,0,0,0,0,100,0), +(@PATH,32,4507.777,1479.854,252.0074,0,0,0,0,100,0), +(@PATH,33,4507.527,1477.854,252.5074,0,0,0,0,100,0), +(@PATH,34,4506.656,1467.186,252.5542,0,0,0,0,100,0), +(@PATH,35,4506.156,1464.436,251.8042,0,0,0,0,100,0), +(@PATH,36,4505.906,1460.686,251.3042,0,0,0,0,100,0), +(@PATH,37,4505.76,1460.309,251.155,0,0,0,0,100,0), +(@PATH,38,4505.51,1458.809,250.905,0,0,0,0,100,0), +(@PATH,39,4505.76,1456.059,250.405,0,0,0,0,100,0), +(@PATH,40,4505.502,1458.276,250.9913,0,0,0,0,100,0), +(@PATH,41,4505.252,1461.026,251.4913,0,0,0,0,100,0), +(@PATH,42,4505.252,1464.026,251.9913,0,0,0,0,100,0), +(@PATH,43,4505.068,1466.344,252.281,0,0,0,0,100,0), +(@PATH,44,4505.568,1469.344,253.031,0,0,0,0,100,0), +(@PATH,45,4506.721,1478.235,252.4351,0,0,0,0,100,0), +(@PATH,46,4506.971,1479.985,251.9351,0,0,0,0,100,0), +(@PATH,47,4506.971,1481.735,251.1851,0,0,0,0,100,0), +(@PATH,48,4507.221,1483.735,250.6851,0,0,0,0,100,0), +(@PATH,49,4507.471,1485.735,250.1851,0,0,0,0,100,0), +(@PATH,50,4507.616,1485.947,249.8183,0,0,0,0,100,0), +(@PATH,51,4507.866,1487.947,249.0683,0,0,0,0,100,0), +(@PATH,52,4509.616,1490.447,248.0683,0,0,0,0,100,0), +(@PATH,53,4510.366,1491.947,247.0683,0,0,0,0,100,0), +(@PATH,54,4512.179,1494.746,245.7769,0,0,0,0,100,0), +(@PATH,55,4514.679,1495.996,244.0269,0,0,0,0,100,0), +(@PATH,56,4516.179,1497.246,243.0269,0,0,0,0,100,0), +(@PATH,57,4517.929,1498.246,242.2769,0,0,0,0,100,0), +(@PATH,58,4519.679,1499.246,241.7769,0,0,0,0,100,0), +(@PATH,59,4519.817,1499.441,241.3417,0,0,0,0,100,0), +(@PATH,60,4520.317,1499.691,241.3417,0,0,0,0,100,0), +(@PATH,61,4520.817,1500.691,240.3417,0,0,0,0,100,0), +(@PATH,62,4521.317,1501.441,239.5917,0,0,0,0,100,0), +(@PATH,63,4521.817,1502.441,238.8417,0,0,0,0,100,0), +(@PATH,64,4522.567,1503.941,238.0917,0,0,0,0,100,0), +(@PATH,65,4523.567,1505.691,237.0917,0,0,0,0,100,0), +(@PATH,66,4524.567,1507.441,236.3417,0,0,0,0,100,0), +(@PATH,67,4525.855,1509.507,235.6382,0,0,0,0,100,0), +(@PATH,68,4527.605,1511.757,234.8882,0,0,0,0,100,0), +(@PATH,69,4529.355,1513.757,234.1382,0,0,0,0,100,0), +(@PATH,70,4531.105,1516.257,233.6382,0,0,0,0,100,0), +(@PATH,71,4532.355,1517.757,232.6382,0,0,0,0,100,0), +(@PATH,72,4532.722,1518.117,232.478,0,0,0,0,100,0), +(@PATH,73,4533.722,1519.117,232.478,0,0,0,0,100,0), +(@PATH,74,4536.722,1521.117,231.478,0,0,0,0,100,0); |