diff options
| -rw-r--r-- | sql/updates/world/2015_05_12_03_world.sql | 507 |
1 files changed, 507 insertions, 0 deletions
diff --git a/sql/updates/world/2015_05_12_03_world.sql b/sql/updates/world/2015_05_12_03_world.sql new file mode 100644 index 00000000000..2bcfa9d091b --- /dev/null +++ b/sql/updates/world/2015_05_12_03_world.sql @@ -0,0 +1,507 @@ +-- DB/Creature: Grizzlyhills Pathing -2 +UPDATE `smart_scripts` SET `action_param6`=2 WHERE `entryorguid` IN (2658200, 2658201) AND `source_type`=9 AND `id`=0 AND `link`=0; + +SET @NPC := 99310; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4194.24,`position_y`=-1806.269,`position_z`=200.4735 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,4194.24,-1806.269,200.4735,0,0,0,0,100,0), +(@PATH,2,4197.74,-1808.269,201.2235,0,0,0,0,100,0), +(@PATH,3,4199.49,-1809.269,201.7235,0,0,0,0,100,0), +(@PATH,4,4202.99,-1811.269,202.2235,0,0,0,0,100,0), +(@PATH,5,4209.49,-1815.269,202.9735,0,0,0,0,100,0), +(@PATH,6,4226.4,-1825.46,203.2541,0,0,0,0,100,0), +(@PATH,7,4227.65,-1833.96,202.7541,0,0,0,0,100,0), +(@PATH,8,4228.602,-1839.474,202.2388,0,0,0,0,100,0), +(@PATH,9,4242.543,-1857.213,202.6918,0,0,0,0,100,0), +(@PATH,10,4242.543,-1863.963,203.1918,0,0,0,0,100,0), +(@PATH,11,4242.595,-1859.661,202.7076,0,0,0,0,100,0), +(@PATH,12,4242.467,-1856.869,202.4443,0,0,0,0,100,0), +(@PATH,13,4238.217,-1851.369,201.9443,0,0,0,0,100,0), +(@PATH,14,4228.504,-1839.239,202.5002,0,0,0,0,100,0), +(@PATH,15,4227.504,-1832.739,203.0002,0,0,0,0,100,0), +(@PATH,16,4226.358,-1825.27,203.1885,0,0,0,0,100,0), +(@PATH,17,4208.108,-1814.52,202.6885,0,0,0,0,100,0), +(@PATH,18,4200.608,-1810.02,201.9385,0,0,0,0,100,0), +(@PATH,19,4198.108,-1808.52,201.1885,0,0,0,0,100,0), +(@PATH,20,4194.608,-1806.52,200.6885,0,0,0,0,100,0), +(@PATH,21,4190.358,-1803.77,199.9385,0,0,0,0,100,0); + +SET @NPC := 99309; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4163.295,`position_y`=-1958.695,`position_z`=208.3958 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,4163.295,-1958.695,208.3958,0,0,0,0,100,0), +(@PATH,2,4167.545,-1960.945,208.8958,0,0,0,0,100,0), +(@PATH,3,4189.578,-1972.83,209.2269,0,0,0,0,100,0), +(@PATH,4,4193.578,-1973.83,208.7269,0,0,0,0,100,0), +(@PATH,5,4189.997,-1972.962,209.24,0,0,0,0,100,0), +(@PATH,6,4164.317,-1959.296,208.4842,0,0,0,0,100,0), +(@PATH,7,4163.099,-1958.743,208.3662,0,0,0,0,100,0), +(@PATH,8,4157.599,-1963.243,209.1162,0,0,0,0,100,0), +(@PATH,9,4154.599,-1965.743,209.8662,0,0,0,0,100,0), +(@PATH,10,4151.599,-1968.243,210.3662,0,0,0,0,100,0), +(@PATH,11,4148.349,-1970.743,210.8662,0,0,0,0,100,0), +(@PATH,12,4143.349,-1974.993,211.3662,0,0,0,0,100,0), +(@PATH,13,4136.349,-1980.993,212.1162,0,0,0,0,100,0), +(@PATH,14,4134.099,-1982.743,212.6162,0,0,0,0,100,0), +(@PATH,15,4133.807,-1983.081,212.7842,0,0,0,0,100,0), +(@PATH,16,4137.057,-1980.331,212.0342,0,0,0,0,100,0), +(@PATH,17,4143.807,-1974.581,211.2842,0,0,0,0,100,0), +(@PATH,18,4149.057,-1970.331,210.5342,0,0,0,0,100,0), +(@PATH,19,4152.807,-1967.081,210.0342,0,0,0,0,100,0), +(@PATH,20,4155.057,-1965.331,209.5342,0,0,0,0,100,0), +(@PATH,21,4159.057,-1962.081,209.0342,0,0,0,0,100,0); + +SET @NPC := 99308; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4257.948,`position_y`=-1914.651,`position_z`=201.9758 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,4257.948,-1914.651,201.9758,0,0,0,0,100,0), +(@PATH,2,4257.902,-1914.741,202.4635,0,0,0,0,100,0), +(@PATH,3,4257.152,-1923.741,202.9635,0,0,0,0,100,0), +(@PATH,4,4256.652,-1929.491,203.4635,0,0,0,0,100,0), +(@PATH,5,4256.402,-1934.241,203.9635,0,0,0,0,100,0), +(@PATH,6,4255.238,-1946.397,204.331,0,0,0,0,100,0), +(@PATH,7,4252.988,-1961.897,204.831,0,0,0,0,100,0), +(@PATH,8,4252.238,-1966.897,205.331,0,0,0,0,100,0), +(@PATH,9,4252.688,-1964.002,204.8374,0,0,0,0,100,0), +(@PATH,10,4254.188,-1953.252,204.5874,0,0,0,0,100,0), +(@PATH,11,4255.508,-1946.051,204.2277,0,0,0,0,100,0), +(@PATH,12,4256.758,-1930.551,203.4777,0,0,0,0,100,0), +(@PATH,13,4257.008,-1925.551,202.9777,0,0,0,0,100,0), +(@PATH,14,4257.508,-1919.551,202.4777,0,0,0,0,100,0), +(@PATH,15,4257.833,-1914.49,202.1853,0,0,0,0,100,0); + +SET @NPC := 104074; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4245.058,`position_y`=-2021.197,`position_z`=237.4276 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,4245.058,-2021.197,237.4276,0,0,0,0,100,0), +(@PATH,2,4245.791,-2017.078,233.2036,0,0,0,0,100,0), +(@PATH,3,4246.791,-2007.328,223.2036,0,0,0,0,100,0), +(@PATH,4,4247.152,-2007.004,222.8537,0,0,0,0,100,0), +(@PATH,5,4247.402,-2005.004,220.8537,0,0,0,0,100,0), +(@PATH,6,4248.152,-1999.504,215.8537,0,0,0,0,100,0), +(@PATH,7,4249.402,-1990.004,207.3537,0,0,0,0,100,0), +(@PATH,8,4249.673,-1989.776,207.2351,0,0,0,0,100,0), +(@PATH,9,4249.673,-1988.776,207.2351,0,0,0,0,100,0), +(@PATH,10,4250.423,-1976.026,206.7351,0,0,0,0,100,0), +(@PATH,11,4250.069,-1981.066,206.8915,0,0,0,0,100,0), +(@PATH,12,4248.495,-1989.926,206.7487,0,0,0,0,100,0), +(@PATH,13,4247.745,-1999.926,215.9987,0,0,0,0,100,0), +(@PATH,14,4247.169,-2005.335,221.2139,0,0,0,0,100,0), +(@PATH,15,4246.919,-2007.335,223.2139,0,0,0,0,100,0), +(@PATH,16,4245.507,-2017.251,233.4465,0,0,0,0,100,0); + +DELETE FROM `creature_addon` WHERE `guid`=110106; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(110106,0,0,0,1,69, ''); + +SET @NPC := 10299; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3333.925,`position_y`=-1773.206,`position_z`=88.87373 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,3333.925,-1773.206,88.87373,0,0,0,0,100,0), +(@PATH,2,3334.675,-1774.456,88.37373,0,0,0,0,100,0), +(@PATH,3,3335.175,-1775.456,88.37373,0,0,0,0,100,0), +(@PATH,4,3337.425,-1775.956,88.62373,0,0,0,0,100,0), +(@PATH,5,3338.675,-1779.706,89.12373,0,0,0,0,100,0), +(@PATH,6,3339.705,-1778.929,89.08168,0,0,0,0,100,0), +(@PATH,7,3339.705,-1775.929,88.58168,0,0,0,0,100,0), +(@PATH,8,3339.705,-1774.679,88.33168,0,0,0,0,100,0), +(@PATH,9,3339.705,-1771.679,87.83168,0,0,0,0,100,0), +(@PATH,10,3339.705,-1770.929,87.58168,0,0,0,0,100,0), +(@PATH,11,3339.705,-1766.679,87.33168,0,0,0,0,100,0), +(@PATH,12,3341.205,-1761.679,88.08168,0,0,0,0,100,0), +(@PATH,13,3340.286,-1761.39,87.88223,0,0,0,0,100,0), +(@PATH,14,3357.286,-1763.39,89.13223,0,0,0,0,100,0), +(@PATH,15,3358.286,-1763.39,89.38223,0,0,0,0,100,0), +(@PATH,16,3358.156,-1762.816,89.31908,0,0,0,0,100,0), +(@PATH,17,3357.656,-1762.816,89.06908,0,0,0,0,100,0), +(@PATH,18,3357.156,-1762.816,89.31908,0,0,0,0,100,0), +(@PATH,19,3340.241,-1761.592,87.80875,0,0,0,0,100,0), +(@PATH,20,3339.741,-1764.592,87.55875,0,0,0,0,100,0), +(@PATH,21,3339.741,-1766.592,87.30875,0,0,0,0,100,0), +(@PATH,22,3339.741,-1770.842,87.55875,0,0,0,0,100,0), +(@PATH,23,3339.741,-1774.592,88.30875,0,0,0,0,100,0), +(@PATH,24,3339.741,-1778.842,89.05875,0,0,0,0,100,0), +(@PATH,25,3335.925,-1777.206,88.87373,0,0,0,0,100,0), +(@PATH,26,3334.675,-1775.206,88.37373,0,0,0,0,100,0); + +SET @NPC := 103003; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3392.038,`position_y`=-1786.48,`position_z`=99.89154 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,3392.038,-1786.48,99.89154,0,0,0,0,100,0), +(@PATH,2,3393.788,-1785.98,99.64154,0,0,0,0,100,0), +(@PATH,3,3395.788,-1784.48,99.64154,0,0,0,0,100,0), +(@PATH,4,3398.038,-1784.48,99.64154,0,0,0,0,100,0), +(@PATH,5,3400.038,-1783.73,99.39154,0,0,0,0,100,0), +(@PATH,6,3408.288,-1780.23,99.14154,0,0,0,0,100,0), +(@PATH,7,3410.538,-1780.23,99.14154,0,0,0,0,100,0), +(@PATH,8,3412.538,-1780.23,99.39154,0,0,0,0,100,0), +(@PATH,9,3414.538,-1780.23,99.39154,0,0,0,0,100,0), +(@PATH,10,3416.788,-1780.23,99.64154,0,0,0,0,100,0), +(@PATH,11,3418.788,-1780.23,99.64154,0,0,0,0,100,0), +(@PATH,12,3418.788,-1782.48,100.8915,0,0,0,0,100,0), +(@PATH,13,3418.288,-1782.98,101.1415,0,0,0,0,100,0), +(@PATH,14,3418.538,-1786.48,102.1415,0,0,0,0,100,0), +(@PATH,15,3418.788,-1788.48,102.1415,0,0,0,0,100,0), +(@PATH,16,3418.788,-1790.23,102.6415,0,0,0,0,100,0), +(@PATH,17,3417.788,-1790.73,103.1415,0,0,0,0,100,0), +(@PATH,18,3412.288,-1793.98,103.1415,0,0,0,0,100,0), +(@PATH,19,3409.038,-1795.23,103.1415,0,0,0,0,100,0), +(@PATH,20,3402.038,-1798.23,103.1415,0,0,0,0,100,0), +(@PATH,21,3405.601,-1802.971,103.1744,0,0,0,0,100,0), +(@PATH,22,3412.601,-1804.221,103.1744,0,0,0,0,100,0), +(@PATH,23,3414.101,-1804.471,102.1744,0,0,0,0,100,0), +(@PATH,24,3414.601,-1803.471,102.1744,0,0,0,0,100,0), +(@PATH,25,3415.601,-1801.721,101.9244,0,0,0,0,100,0), +(@PATH,26,3415.601,-1799.721,101.9244,0,0,0,0,100,0), +(@PATH,27,3416.601,-1798.721,101.6744,0,0,0,0,100,0), +(@PATH,28,3420.351,-1795.471,101.4244,0,0,0,0,100,0), +(@PATH,29,3422.351,-1791.721,101.1744,0,0,0,0,100,0), +(@PATH,30,3423.851,-1789.471,101.1744,0,0,0,0,100,0), +(@PATH,31,3423.851,-1787.471,100.6744,0,0,0,0,100,0), +(@PATH,32,3423.851,-1785.471,100.4244,0,0,0,0,100,0), +(@PATH,33,3423.851,-1783.221,99.92442,0,0,0,0,100,0), +(@PATH,34,3422.851,-1781.721,99.42442,0,0,0,0,100,0), +(@PATH,35,3421.851,-1781.721,99.42442,0,0,0,0,100,0), +(@PATH,36,3420.851,-1781.721,99.67442,0,0,0,0,100,0), +(@PATH,37,3418.851,-1780.221,99.67442,0,0,0,0,100,0), +(@PATH,38,3416.601,-1780.221,99.67442,0,0,0,0,100,0), +(@PATH,39,3414.601,-1780.221,99.42442,0,0,0,0,100,0), +(@PATH,40,3412.601,-1780.221,99.42442,0,0,0,0,100,0), +(@PATH,41,3410.351,-1780.221,99.17442,0,0,0,0,100,0), +(@PATH,42,3408.351,-1780.221,99.17442,0,0,0,0,100,0), +(@PATH,43,3404.601,-1783.221,99.92442,0,0,0,0,100,0), +(@PATH,44,3403.101,-1783.971,99.67442,0,0,0,0,100,0), +(@PATH,45,3402.101,-1783.971,99.42442,0,0,0,0,100,0), +(@PATH,46,3401.101,-1783.971,99.42442,0,0,0,0,100,0), +(@PATH,47,3400.101,-1783.971,99.42442,0,0,0,0,100,0), +(@PATH,48,3397.851,-1784.471,99.67442,0,0,0,0,100,0), +(@PATH,49,3395.851,-1784.471,99.67442,0,0,0,0,100,0), +(@PATH,50,3393.851,-1784.471,99.42442,0,0,0,0,100,0); + +SET @NPC := 103000; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3389.137,`position_y`=-1830.333,`position_z`=103.4552 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,3389.137,-1830.333,103.4552,0,0,0,0,100,0), +(@PATH,2,3389.637,-1832.583,102.9552,0,0,0,0,100,0), +(@PATH,3,3383.887,-1839.083,102.9552,0,0,0,0,100,0), +(@PATH,4,3382.887,-1840.083,102.4552,0,0,0,0,100,0), +(@PATH,5,3382.387,-1840.583,102.7052,0,0,0,0,100,0), +(@PATH,6,3382.387,-1841.583,102.7052,0,0,0,0,100,0), +(@PATH,7,3378.887,-1844.833,103.4552,0,0,0,0,100,0), +(@PATH,8,3376.137,-1847.833,103.9552,0,0,0,0,100,0), +(@PATH,9,3375.137,-1848.833,104.2052,0,0,0,0,100,0), +(@PATH,10,3374.137,-1849.833,104.2052,0,0,0,0,100,0), +(@PATH,11,3372.387,-1852.083,104.7052,0,0,0,0,100,0), +(@PATH,12,3372.262,-1852.324,105.0966,0,0,0,0,100,0), +(@PATH,13,3371.512,-1853.574,105.3466,0,0,0,0,100,0), +(@PATH,14,3393.262,-1859.574,105.8466,0,0,0,0,100,0), +(@PATH,15,3397.262,-1860.824,106.5966,0,0,0,0,100,0), +(@PATH,16,3399.262,-1861.324,106.8466,0,0,0,0,100,0), +(@PATH,17,3403.012,-1862.324,107.5966,0,0,0,0,100,0), +(@PATH,18,3406.762,-1863.574,108.5966,0,0,0,0,100,0), +(@PATH,19,3382.792,-1856.847,105.1871,0,0,0,0,100,0), +(@PATH,20,3392.687,-1859.487,105.7214,0,0,0,0,100,0), +(@PATH,21,3396.437,-1860.737,106.4714,0,0,0,0,100,0), +(@PATH,22,3399.187,-1861.237,107.2214,0,0,0,0,100,0), +(@PATH,23,3402.937,-1862.237,107.7214,0,0,0,0,100,0), +(@PATH,24,3406.937,-1863.487,108.7214,0,0,0,0,100,0), +(@PATH,25,3408.163,-1863.834,108.8378,0,0,0,0,100,0), +(@PATH,26,3406.163,-1863.334,108.0878,0,0,0,0,100,0), +(@PATH,27,3402.413,-1862.084,107.3378,0,0,0,0,100,0), +(@PATH,28,3398.663,-1861.084,106.8378,0,0,0,0,100,0), +(@PATH,29,3394.663,-1860.084,105.8378,0,0,0,0,100,0), +(@PATH,30,3388.163,-1858.334,105.0878,0,0,0,0,100,0), +(@PATH,31,3376.036,-1851.585,104.1596,0,0,0,0,100,0), +(@PATH,32,3377.786,-1847.835,103.6596,0,0,0,0,100,0), +(@PATH,33,3379.536,-1844.335,103.1596,0,0,0,0,100,0), +(@PATH,34,3381.036,-1841.085,102.6596,0,0,0,0,100,0), +(@PATH,35,3382.036,-1839.835,102.6596,0,0,0,0,100,0), +(@PATH,36,3383.036,-1839.085,102.9096,0,0,0,0,100,0), +(@PATH,37,3389.537,-1832.41,102.813,0,0,0,0,100,0), +(@PATH,38,3389.037,-1829.91,102.813,0,0,0,0,100,0), +(@PATH,39,3388.787,-1827.91,104.813,0,0,0,0,100,0), +(@PATH,40,3386.787,-1816.66,111.313,0,0,0,0,100,0), +(@PATH,41,3386.537,-1815.41,112.063,0,0,0,0,100,0), +(@PATH,42,3386.537,-1813.41,113.313,0,0,0,0,100,0), +(@PATH,43,3386.537,-1812.41,113.813,0,0,0,0,100,0), +(@PATH,44,3386.367,-1811.625,114.3062,0,0,0,0,100,0), +(@PATH,45,3386.617,-1813.375,113.3062,0,0,0,0,100,0), +(@PATH,46,3386.867,-1814.375,112.5562,0,0,0,0,100,0), +(@PATH,47,3387.117,-1816.875,111.3062,0,0,0,0,100,0), +(@PATH,48,3388.867,-1827.875,104.8062,0,0,0,0,100,0); + +UPDATE `smart_scripts` SET `action_param1`=1 WHERE `entryorguid`=26447 AND `source_type`=0 AND `id`=0 AND `link`=0; + +SET @NPC := 102007; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4364.09,`position_y`=-3079.468,`position_z`=339.3658 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,4364.09,-3079.468,339.3658,0,0,0,0,100,0), +(@PATH,2,4367.34,-3080.468,339.6158,0,0,0,0,100,0), +(@PATH,3,4367.589,-3080.702,339.5166,0,0,0,0,100,0), +(@PATH,4,4363.933,-3079.255,339.4127,0,0,0,0,100,0), +(@PATH,5,4359.433,-3077.505,336.4127,0,0,0,0,100,0), +(@PATH,6,4355.786,-3075.964,334.2474,0,0,0,0,100,0), +(@PATH,7,4355.695,-3075.981,334.1053,0,0,0,0,100,0), +(@PATH,8,4356.195,-3076.231,334.3553,0,0,0,0,100,0), +(@PATH,9,4359.195,-3077.231,336.3553,0,0,0,0,100,0), +(@PATH,10,4364.154,-3079.562,339.3983,0,0,0,0,100,0), +(@PATH,11,4367.404,-3080.312,339.6483,0,0,0,0,100,0), +(@PATH,12,4367.589,-3080.702,339.5166,0,0,0,0,100,0), +(@PATH,13,4363.904,-3079.155,339.4361,0,0,0,0,100,0), +(@PATH,14,4359.404,-3077.405,336.4361,0,0,0,0,100,0); + +DELETE FROM `creature_addon` WHERE `guid` IN (111265,111249,111251,111254,111253,111287,111250,111252,111256, 111257, 111255, 111258); +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(111255,0,0,3,1,0, ''), +(111258,0,0,3,1,0, ''), +(111257,0,0,3,1,0, ''), +(111256,0,0,3,1,0, ''), +(111265,0,0,3,1,0, ''), +(111252,0,0,3,1,0, ''), +(111250,0,0,3,1,0, ''), +(111287,0,0,3,1,0, ''), +(111253,0,0,3,1,0, ''), +(111254,0,0,3,1,0, ''), +(111251,0,0,3,1,0, ''), +(111249,0,0,3,1,0, ''); + +SET @NPC := 111286; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4542.684,`position_y`=-3543.378,`position_z`=229.5949 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,4542.684,-3543.378,229.5949,0,0,0,0,100,0), +(@PATH,2,4538.324,-3550.24,230.4706,0,0,0,0,100,0), +(@PATH,3,4538.574,-3554.24,230.9706,0,0,0,0,100,0), +(@PATH,4,4538.824,-3559.99,231.4706,0,0,0,0,100,0), +(@PATH,5,4538.906,-3559.937,231.3715,0,0,0,0,100,0), +(@PATH,6,4538.906,-3560.937,231.8715,0,0,0,0,100,0), +(@PATH,7,4558.198,-3552.972,231.0125,0,0,0,0,100,0), +(@PATH,8,4556.198,-3549.472,230.5125,0,0,0,0,100,0), +(@PATH,9,4553.948,-3546.472,229.7625,0,0,0,0,100,0), +(@PATH,10,4551.948,-3543.222,229.5125,0,0,0,0,100,0), +(@PATH,11,4542.659,-3543.267,229.5627,0,0,0,0,100,0); + +SET @NPC := 111288; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4520.46,`position_y`=-3406.525,`position_z`=227.3326 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,4520.46,-3406.525,227.3326,0,0,0,0,100,0), +(@PATH,2,4521.017,-3406.375,227.0677,0,0,0,0,100,0), +(@PATH,3,4520.318,-3406.741,227.3123,0,0,0,0,100,0), +(@PATH,4,4517.467,-3403.935,227.3069,0,0,0,0,100,0), +(@PATH,5,4526.76,-3393.349,227.3997,0,0,0,0,100,0), +(@PATH,6,4531.26,-3395.099,227.8997,0,0,0,0,100,0), +(@PATH,7,4531.282,-3395.075,227.8239,0,0,0,0,100,0), +(@PATH,8,4533.532,-3395.825,228.3239,0,0,0,0,100,0), +(@PATH,9,4532.032,-3397.075,228.0739,0,0,0,0,100,0), +(@PATH,10,4527.532,-3400.825,227.3239,0,0,0,0,100,0), +(@PATH,11,4520.34,-3406.549,227.3216,0,0,0,0,100,0), +(@PATH,12,4517.471,-3403.86,227.3069,0,0,0,0,100,0), +(@PATH,13,4526.883,-3393.393,227.3997,0,0,0,0,100,0), +(@PATH,14,4531.383,-3394.893,227.8997,0,0,0,0,100,0), +(@PATH,15,4531.462,-3395.123,227.7483,0,0,0,0,100,0), +(@PATH,16,4533.462,-3395.873,228.4983,0,0,0,0,100,0), +(@PATH,17,4531.962,-3397.123,227.9983,0,0,0,0,100,0), +(@PATH,18,4527.462,-3400.623,227.2483,0,0,0,0,100,0), +(@PATH,19,4520.34,-3406.627,227.3305,0,0,0,0,100,0), +(@PATH,20,4517.294,-3403.789,227.3069,0,0,0,0,100,0), +(@PATH,21,4526.909,-3393.429,227.3997,0,0,0,0,100,0), +(@PATH,22,4531.409,-3394.929,227.8997,0,0,0,0,100,0); + +SET @NPC := 111289; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4484.351,`position_y`=-3478.285,`position_z`=227.3069 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,4484.351,-3478.285,227.3069,0,0,0,0,100,0), +(@PATH,2,4480.057,-3487.22,227.2323,0,0,0,0,100,0), +(@PATH,3,4472.557,-3489.22,227.7323,0,0,0,0,100,0), +(@PATH,4,4472.306,-3489.237,227.8791,0,0,0,0,100,0), +(@PATH,5,4470.556,-3489.737,227.6291,0,0,0,0,100,0), +(@PATH,6,4462.207,-3481.591,227.8329,0,0,0,0,100,0), +(@PATH,7,4464.199,-3484.106,227.8086,0,0,0,0,100,0), +(@PATH,8,4476.075,-3486.219,227.4328,0,0,0,0,100,0), +(@PATH,9,4480.054,-3487.25,227.2926,0,0,0,0,100,0), +(@PATH,10,4472.554,-3489.25,227.7926,0,0,0,0,100,0), +(@PATH,11,4470.448,-3489.726,227.6761,0,0,0,0,100,0), +(@PATH,12,4461.976,-3481.571,227.8154,0,0,0,0,100,0), +(@PATH,13,4466.938,-3472.407,227.8242,0,0,0,0,100,0), +(@PATH,14,4479.269,-3468.501,227.1355,0,0,0,0,100,0), +(@PATH,15,4484.383,-3478.306,227.3069,0,0,0,0,100,0), +(@PATH,16,4479.968,-3487.13,227.2323,0,0,0,0,100,0), +(@PATH,17,4472.468,-3489.13,227.7323,0,0,0,0,100,0); + +SET @NPC := 103184; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4462.269,`position_y`=-3450.493,`position_z`=229.296 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,4462.269,-3450.493,229.296,0,0,0,0,100,0), +(@PATH,2,4459.769,-3447.243,230.296,0,0,0,0,100,0), +(@PATH,3,4458.269,-3445.243,231.046,0,0,0,0,100,0), +(@PATH,4,4457.019,-3443.493,231.796,0,0,0,0,100,0), +(@PATH,5,4455.269,-3441.243,232.546,0,0,0,0,100,0), +(@PATH,6,4453.519,-3438.743,233.046,0,0,0,0,100,0), +(@PATH,7,4452.269,-3437.243,233.796,0,0,0,0,100,0), +(@PATH,8,4452.268,-3436.947,233.8038,0,0,0,0,100,0), +(@PATH,9,4451.268,-3435.697,234.0538,0,0,0,0,100,0), +(@PATH,10,4456.768,-3431.197,233.5538,0,0,0,0,100,0), +(@PATH,11,4463.518,-3425.947,232.8038,0,0,0,0,100,0), +(@PATH,12,4466.768,-3423.447,232.3038,0,0,0,0,100,0), +(@PATH,13,4471.518,-3419.947,232.0538,0,0,0,0,100,0), +(@PATH,14,4467.077,-3423.216,232.6244,0,0,0,0,100,0), +(@PATH,15,4463.827,-3425.716,232.8744,0,0,0,0,100,0), +(@PATH,16,4458.577,-3429.716,233.6244,0,0,0,0,100,0), +(@PATH,17,4452.327,-3434.716,234.1244,0,0,0,0,100,0), +(@PATH,18,4452.155,-3435.054,234.091,0,0,0,0,100,0), +(@PATH,19,4451.155,-3435.804,234.091,0,0,0,0,100,0), +(@PATH,20,4452.905,-3438.304,233.341,0,0,0,0,100,0), +(@PATH,21,4454.905,-3440.554,232.841,0,0,0,0,100,0), +(@PATH,22,4455.905,-3442.304,232.091,0,0,0,0,100,0), +(@PATH,23,4457.155,-3443.804,231.591,0,0,0,0,100,0), +(@PATH,24,4458.905,-3446.054,230.841,0,0,0,0,100,0), +(@PATH,25,4460.655,-3448.304,229.841,0,0,0,0,100,0), +(@PATH,26,4462.905,-3451.554,229.091,0,0,0,0,100,0); + +SET @NPC := 103186; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4494.403,`position_y`=-3398.471,`position_z`=228.9183 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,4494.403,-3398.471,228.9183,0,0,0,0,100,0), +(@PATH,2,4497.653,-3396.221,229.6683,0,0,0,0,100,0), +(@PATH,3,4500.653,-3394.221,230.1683,0,0,0,0,100,0), +(@PATH,4,4509.161,-3388.243,230.0648,0,0,0,0,100,0), +(@PATH,5,4526.161,-3376.743,230.3148,0,0,0,0,100,0), +(@PATH,6,4529.797,-3374.429,230.5572,0,0,0,0,100,0), +(@PATH,7,4532.547,-3377.179,230.0572,0,0,0,0,100,0), +(@PATH,8,4531.893,-3376.673,230.1904,0,0,0,0,100,0), +(@PATH,9,4529.376,-3374.406,230.6659,0,0,0,0,100,0), +(@PATH,10,4525.376,-3377.156,230.1659,0,0,0,0,100,0), +(@PATH,11,4516.626,-3383.156,229.6659,0,0,0,0,100,0), +(@PATH,12,4508.783,-3388.445,229.8696,0,0,0,0,100,0), +(@PATH,13,4503.033,-3392.445,230.1196,0,0,0,0,100,0), +(@PATH,14,4497.533,-3396.195,229.6196,0,0,0,0,100,0), +(@PATH,15,4494.283,-3398.445,228.8696,0,0,0,0,100,0); + +SET @NPC := 102291; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3636.139,`position_y`=-4596.764,`position_z`=191.9429 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,3636.139,-4596.764,191.9429,0,0,0,0,100,0), +(@PATH,2,3635.861,-4596.798,191.7083,0,0,0,0,100,0), +(@PATH,3,3635.853,-4596.449,191.8018,0,0,0,0,100,0), +(@PATH,4,3625.146,-4589.744,191.7298,0,0,0,0,100,0), +(@PATH,5,3624.396,-4588.744,191.7298,0,0,0,0,100,0), +(@PATH,6,3623.646,-4587.744,191.9798,0,0,0,0,100,0), +(@PATH,7,3623.146,-4586.994,192.7298,0,0,0,0,100,0), +(@PATH,8,3622.646,-4586.244,193.2298,0,0,0,0,100,0), +(@PATH,9,3619.531,-4582.521,193.1351,0,0,0,0,100,0), +(@PATH,10,3608.531,-4574.021,193.6351,0,0,0,0,100,0), +(@PATH,11,3607.281,-4573.271,192.6351,0,0,0,0,100,0), +(@PATH,12,3606.781,-4572.771,192.6351,0,0,0,0,100,0), +(@PATH,13,3606.531,-4572.521,192.3851,0,0,0,0,100,0), +(@PATH,14,3606.273,-4572.244,192.437,0,0,0,0,100,0), +(@PATH,15,3604.773,-4570.994,192.687,0,0,0,0,100,0), +(@PATH,16,3603.523,-4569.494,193.187,0,0,0,0,100,0), +(@PATH,17,3602.023,-4566.994,194.187,0,0,0,0,100,0), +(@PATH,18,3600.023,-4563.744,194.687,0,0,0,0,100,0), +(@PATH,19,3597.773,-4560.494,195.437,0,0,0,0,100,0), +(@PATH,20,3596.023,-4557.994,196.187,0,0,0,0,100,0), +(@PATH,21,3593.575,-4554.499,197.0962,0,0,0,0,100,0), +(@PATH,22,3591.325,-4550.999,197.8462,0,0,0,0,100,0), +(@PATH,23,3589.575,-4547.999,198.3462,0,0,0,0,100,0), +(@PATH,24,3587.575,-4544.499,199.0962,0,0,0,0,100,0), +(@PATH,25,3587.266,-4544.312,199.2521,0,0,0,0,100,0), +(@PATH,26,3586.766,-4543.312,199.2521,0,0,0,0,100,0), +(@PATH,27,3583.266,-4534.312,199.7521,0,0,0,0,100,0), +(@PATH,28,3581.901,-4530.598,199.9242,0,0,0,0,100,0), +(@PATH,29,3577.257,-4510.44,199.8448,0,0,0,0,100,0), +(@PATH,30,3576.757,-4505.69,199.3448,0,0,0,0,100,0), +(@PATH,31,3576.196,-4499.946,199.2152,0,0,0,0,100,0), +(@PATH,32,3580.946,-4493.946,199.7152,0,0,0,0,100,0), +(@PATH,33,3581.288,-4493.67,199.6084,0,0,0,0,100,0), +(@PATH,34,3581.538,-4493.42,199.6084,0,0,0,0,100,0), +(@PATH,35,3586.788,-4484.17,199.1084,0,0,0,0,100,0), +(@PATH,36,3588.606,-4481.567,199.091,0,0,0,0,100,0), +(@PATH,37,3594.356,-4476.567,198.341,0,0,0,0,100,0), +(@PATH,38,3596.606,-4474.567,197.841,0,0,0,0,100,0), +(@PATH,39,3596,-4475.001,198.0385,0,0,0,0,100,0), +(@PATH,40,3593,-4477.751,198.5385,0,0,0,0,100,0), +(@PATH,41,3588.387,-4481.783,199.0264,0,0,0,0,100,0), +(@PATH,42,3582.387,-4491.783,199.5264,0,0,0,0,100,0), +(@PATH,43,3582.222,-4492.081,199.736,0,0,0,0,100,0), +(@PATH,44,3581.222,-4493.581,199.486,0,0,0,0,100,0), +(@PATH,45,3576.117,-4500.31,199.3681,0,0,0,0,100,0), +(@PATH,46,3577.448,-4510.77,199.8773,0,0,0,0,100,0), +(@PATH,47,3582.276,-4530.902,199.8257,0,0,0,0,100,0), +(@PATH,48,3585.526,-4540.152,199.3257,0,0,0,0,100,0), +(@PATH,49,3587.005,-4543.549,199.229,0,0,0,0,100,0), +(@PATH,50,3589.755,-4548.549,198.229,0,0,0,0,100,0), +(@PATH,51,3592.005,-4551.799,197.729,0,0,0,0,100,0), +(@PATH,52,3593.605,-4554.598,197.1403,0,0,0,0,100,0), +(@PATH,53,3595.355,-4557.098,196.3903,0,0,0,0,100,0), +(@PATH,54,3596.855,-4559.598,195.6403,0,0,0,0,100,0), +(@PATH,55,3598.355,-4562.098,195.1403,0,0,0,0,100,0), +(@PATH,56,3600.355,-4565.348,194.6403,0,0,0,0,100,0), +(@PATH,57,3602.105,-4567.848,193.8903,0,0,0,0,100,0), +(@PATH,58,3603.605,-4570.348,193.1403,0,0,0,0,100,0), +(@PATH,59,3604.866,-4572.453,192.3813,0,0,0,0,100,0), +(@PATH,60,3606.116,-4573.453,192.3813,0,0,0,0,100,0), +(@PATH,61,3606.366,-4573.703,192.8813,0,0,0,0,100,0), +(@PATH,62,3607.866,-4574.703,193.6313,0,0,0,0,100,0), +(@PATH,63,3619.845,-4582.56,193.2473,0,0,0,0,100,0), +(@PATH,64,3622.345,-4585.81,192.9973,0,0,0,0,100,0), +(@PATH,65,3623.095,-4586.81,192.7473,0,0,0,0,100,0), +(@PATH,66,3623.845,-4587.56,191.9973,0,0,0,0,100,0), +(@PATH,67,3624.595,-4588.81,191.7473,0,0,0,0,100,0), +(@PATH,68,3624.654,-4589.03,191.5894,0,0,0,0,100,0), +(@PATH,69,3625.404,-4589.78,191.5894,0,0,0,0,100,0), +(@PATH,70,3636.153,-4596.696,191.9285,0,0,0,0,100,0); |