diff options
author | Rushor <PBienati@web.de> | 2015-07-15 16:10:27 +0200 |
---|---|---|
committer | Rushor <PBienati@web.de> | 2015-07-15 16:10:27 +0200 |
commit | d81f15759b29157354ef447a29e43bb665faff75 (patch) | |
tree | 58a436afe89f2aeff7f9eb09c4ccfc2d28853a08 | |
parent | ab0c0b7cb89c3693b2ce8e8f64a6ea16d9408b27 (diff) |
DB/Pathing: Drgaonblight - Woods of Lothalor + Indu'le Village + Moonrest Gardens
-rw-r--r-- | sql/updates/world/2015_07_15_02_world.sql | 1099 |
1 files changed, 1099 insertions, 0 deletions
diff --git a/sql/updates/world/2015_07_15_02_world.sql b/sql/updates/world/2015_07_15_02_world.sql new file mode 100644 index 00000000000..07c59a8190b --- /dev/null +++ b/sql/updates/world/2015_07_15_02_world.sql @@ -0,0 +1,1099 @@ +-- Drgaonblight - Woods of Lothalor + Indu'le Village + Moonrest Gardens + +-- 1. Woods +SET @NPC := 117136; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2856.349,`position_y`=1587.259,`position_z`=159.2038 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,2856.349,1587.259,159.2038,0,0,0,0,100,0), +(@PATH,2,2856.849,1588.009,159.2038,0,0,0,0,100,0), +(@PATH,3,2859.849,1592.009,158.4538,0,0,0,0,100,0), +(@PATH,4,2863.099,1597.009,157.9538,0,0,0,0,100,0), +(@PATH,5,2865.349,1600.259,157.2038,0,0,0,0,100,0), +(@PATH,6,2867.599,1603.259,156.9538,0,0,0,0,100,0), +(@PATH,7,2871.599,1609.009,156.4538,0,0,0,0,100,0), +(@PATH,8,2874.849,1614.009,155.7038,0,0,0,0,100,0), +(@PATH,9,2877.849,1618.009,155.2038,0,0,0,0,100,0), +(@PATH,10,2875.091,1614.135,155.5487,0,0,0,0,100,0), +(@PATH,11,2878.091,1618.385,154.7987,0,0,0,0,100,0), +(@PATH,12,2878.591,1618.885,154.7987,0,0,0,0,100,0), +(@PATH,13,2879.341,1621.885,154.2987,0,0,0,0,100,0), +(@PATH,14,2880.091,1624.635,153.5487,0,0,0,0,100,0), +(@PATH,15,2880.591,1626.635,153.0487,0,0,0,0,100,0), +(@PATH,16,2881.341,1629.635,152.0487,0,0,0,0,100,0), +(@PATH,17,2881.841,1632.385,151.5487,0,0,0,0,100,0), +(@PATH,18,2882.341,1634.385,151.0487,0,0,0,0,100,0), +(@PATH,19,2883.091,1637.135,150.2987,0,0,0,0,100,0), +(@PATH,20,2884.091,1640.885,149.7987,0,0,0,0,100,0), +(@PATH,21,2886.091,1647.635,149.0487,0,0,0,0,100,0), +(@PATH,22,2887.591,1653.385,148.5487,0,0,0,0,100,0), +(@PATH,23,2888.591,1657.385,147.7987,0,0,0,0,100,0), +(@PATH,24,2888.601,1657.646,147.5282,0,0,0,0,100,0), +(@PATH,25,2889.101,1659.646,147.2782,0,0,0,0,100,0), +(@PATH,26,2887.601,1664.396,146.7782,0,0,0,0,100,0), +(@PATH,27,2886.101,1670.146,146.5282,0,0,0,0,100,0), +(@PATH,28,2877.101,1702.646,146.0282,0,0,0,0,100,0), +(@PATH,29,2876.471,1704.117,145.9214,0,0,0,0,100,0), +(@PATH,30,2865.971,1714.617,146.6714,0,0,0,0,100,0), +(@PATH,31,2860.471,1720.117,146.9214,0,0,0,0,100,0), +(@PATH,32,2856.971,1723.617,147.6714,0,0,0,0,100,0), +(@PATH,33,2854.221,1726.617,148.4214,0,0,0,0,100,0), +(@PATH,34,2854.013,1726.797,148.4403,0,0,0,0,100,0), +(@PATH,35,2852.263,1728.547,148.4403,0,0,0,0,100,0), +(@PATH,36,2850.513,1734.297,147.6903,0,0,0,0,100,0), +(@PATH,37,2845.263,1753.297,146.9403,0,0,0,0,100,0), +(@PATH,38,2841.619,1765.818,146.5513,0,0,0,0,100,0), +(@PATH,39,2838.869,1772.068,146.3013,0,0,0,0,100,0), +(@PATH,40,2836.369,1777.568,146.8013,0,0,0,0,100,0), +(@PATH,41,2835.619,1779.568,146.3013,0,0,0,0,100,0), +(@PATH,42,2832.369,1786.568,146.5513,0,0,0,0,100,0), +(@PATH,43,2830.869,1790.068,146.3013,0,0,0,0,100,0), +(@PATH,44,2830.369,1791.068,144.5513,0,0,0,0,100,0), +(@PATH,45,2830.119,1792.068,143.5513,0,0,0,0,100,0), +(@PATH,46,2829.619,1792.818,144.3013,0,0,0,0,100,0), +(@PATH,47,2829.119,1793.818,146.0513,0,0,0,0,100,0), +(@PATH,48,2828.369,1795.568,146.5513,0,0,0,0,100,0), +(@PATH,49,2825.869,1801.068,145.5513,0,0,0,0,100,0), +(@PATH,50,2825.119,1803.068,144.5513,0,0,0,0,100,0), +(@PATH,51,2824.619,1803.818,143.8013,0,0,0,0,100,0), +(@PATH,52,2823.869,1805.818,144.5513,0,0,0,0,100,0), +(@PATH,53,2823.619,1806.568,145.3013,0,0,0,0,100,0), +(@PATH,54,2823.119,1807.568,146.5513,0,0,0,0,100,0), +(@PATH,55,2821.561,1811.26,146.7066,0,0,0,0,100,0), +(@PATH,56,2824.561,1817.51,146.2066,0,0,0,0,100,0), +(@PATH,57,2827.061,1823.01,145.4566,0,0,0,0,100,0), +(@PATH,58,2828.561,1826.51,144.9566,0,0,0,0,100,0), +(@PATH,59,2830.561,1831.01,143.9566,0,0,0,0,100,0), +(@PATH,60,2832.061,1834.51,143.7066,0,0,0,0,100,0), +(@PATH,61,2833.311,1837.26,143.2066,0,0,0,0,100,0), +(@PATH,62,2834.561,1840.01,142.4566,0,0,0,0,100,0), +(@PATH,63,2834.474,1839.311,142.597,0,0,0,0,100,0), +(@PATH,64,2833.224,1836.811,143.347,0,0,0,0,100,0), +(@PATH,65,2831.474,1833.061,143.847,0,0,0,0,100,0), +(@PATH,66,2830.224,1830.311,144.347,0,0,0,0,100,0), +(@PATH,67,2828.474,1826.811,144.847,0,0,0,0,100,0), +(@PATH,68,2826.724,1822.311,145.597,0,0,0,0,100,0), +(@PATH,69,2824.974,1818.811,146.097,0,0,0,0,100,0), +(@PATH,70,2821.974,1812.311,146.847,0,0,0,0,100,0), +(@PATH,71,2822.149,1812.075,146.7974,0,0,0,0,100,0), +(@PATH,72,2821.649,1811.075,146.5474,0,0,0,0,100,0), +(@PATH,73,2823.149,1807.325,146.2974,0,0,0,0,100,0), +(@PATH,74,2823.649,1806.325,145.5474,0,0,0,0,100,0), +(@PATH,75,2823.899,1805.575,144.5474,0,0,0,0,100,0), +(@PATH,76,2824.399,1804.575,143.7974,0,0,0,0,100,0), +(@PATH,77,2825.149,1802.825,144.7974,0,0,0,0,100,0), +(@PATH,78,2825.649,1801.825,145.7974,0,0,0,0,100,0), +(@PATH,79,2826.149,1800.825,146.2974,0,0,0,0,100,0), +(@PATH,80,2828.899,1794.575,146.0474,0,0,0,0,100,0), +(@PATH,81,2829.399,1793.575,145.2974,0,0,0,0,100,0), +(@PATH,82,2829.649,1792.825,143.5474,0,0,0,0,100,0), +(@PATH,83,2830.649,1790.825,145.5474,0,0,0,0,100,0), +(@PATH,84,2830.899,1790.325,146.2974,0,0,0,0,100,0), +(@PATH,85,2831.399,1789.325,146.7974,0,0,0,0,100,0), +(@PATH,86,2833.649,1783.825,146.2974,0,0,0,0,100,0), +(@PATH,87,2835.899,1778.325,146.7974,0,0,0,0,100,0), +(@PATH,88,2836.899,1776.575,146.2974,0,0,0,0,100,0), +(@PATH,89,2841.948,1765.41,146.7317,0,0,0,0,100,0), +(@PATH,90,2846.448,1748.41,147.4817,0,0,0,0,100,0), +(@PATH,91,2851.198,1732.16,147.9817,0,0,0,0,100,0), +(@PATH,92,2851.44,1731.802,147.8846,0,0,0,0,100,0), +(@PATH,93,2852.44,1728.302,148.3846,0,0,0,0,100,0), +(@PATH,94,2856.69,1724.052,147.6346,0,0,0,0,100,0), +(@PATH,95,2858.69,1722.052,147.1346,0,0,0,0,100,0), +(@PATH,96,2866.19,1714.302,146.6346,0,0,0,0,100,0), +(@PATH,97,2869.19,1711.552,145.8846,0,0,0,0,100,0), +(@PATH,98,2876.837,1703.784,145.8906,0,0,0,0,100,0), +(@PATH,99,2878.837,1696.034,146.3906,0,0,0,0,100,0), +(@PATH,100,2887.337,1665.534,146.8906,0,0,0,0,100,0), +(@PATH,101,2889.193,1659.311,147.7064,0,0,0,0,100,0), +(@PATH,102,2887.693,1654.561,148.4564,0,0,0,0,100,0), +(@PATH,103,2886.193,1648.561,148.9564,0,0,0,0,100,0), +(@PATH,104,2884.443,1641.811,149.7064,0,0,0,0,100,0), +(@PATH,105,2883.193,1637.311,150.4564,0,0,0,0,100,0), +(@PATH,106,2882.693,1634.561,150.9564,0,0,0,0,100,0), +(@PATH,107,2882.193,1632.561,151.4564,0,0,0,0,100,0), +(@PATH,108,2881.443,1629.561,152.2064,0,0,0,0,100,0), +(@PATH,109,2880.693,1627.561,152.7064,0,0,0,0,100,0), +(@PATH,110,2880.193,1625.811,153.4564,0,0,0,0,100,0), +(@PATH,111,2879.443,1622.811,153.9564,0,0,0,0,100,0), +(@PATH,112,2878.693,1620.061,154.7064,0,0,0,0,100,0), +(@PATH,113,2878.51,1619.793,154.8954,0,0,0,0,100,0), +(@PATH,114,2878.26,1618.793,155.1454,0,0,0,0,100,0), +(@PATH,115,2874.76,1613.793,155.6454,0,0,0,0,100,0), +(@PATH,116,2871.51,1608.793,156.3954,0,0,0,0,100,0), +(@PATH,117,2868.01,1604.293,156.6454,0,0,0,0,100,0), +(@PATH,118,2866.01,1600.793,157.3954,0,0,0,0,100,0), +(@PATH,119,2863.01,1596.793,157.8954,0,0,0,0,100,0), +(@PATH,120,2860.26,1592.793,158.6454,0,0,0,0,100,0), +(@PATH,121,2857.26,1588.543,159.1454,0,0,0,0,100,0), +(@PATH,122,2857.219,1588.32,159.5233,0,0,0,0,100,0), +(@PATH,123,2856.719,1587.82,159.5233,0,0,0,0,100,0), +(@PATH,124,2852.969,1584.32,159.7733,0,0,0,0,100,0), +(@PATH,125,2848.719,1580.07,160.5233,0,0,0,0,100,0), +(@PATH,126,2837.219,1569.57,161.2733,0,0,0,0,100,0), +(@PATH,127,2834.219,1566.82,161.7733,0,0,0,0,100,0), +(@PATH,128,2834.094,1566.463,161.6562,0,0,0,0,100,0), +(@PATH,129,2829.844,1562.463,161.1562,0,0,0,0,100,0), +(@PATH,130,2814.094,1544.713,160.4062,0,0,0,0,100,0), +(@PATH,131,2809.594,1539.463,159.9062,0,0,0,0,100,0), +(@PATH,132,2809.271,1539.142,159.6762,0,0,0,0,100,0), +(@PATH,133,2808.521,1538.392,159.4262,0,0,0,0,100,0), +(@PATH,134,2807.021,1534.642,158.9262,0,0,0,0,100,0), +(@PATH,135,2806.021,1531.892,158.1762,0,0,0,0,100,0), +(@PATH,136,2805.271,1530.142,157.6762,0,0,0,0,100,0), +(@PATH,137,2803.771,1526.392,157.1762,0,0,0,0,100,0), +(@PATH,138,2803.271,1524.392,156.6762,0,0,0,0,100,0), +(@PATH,139,2801.521,1521.142,155.9262,0,0,0,0,100,0), +(@PATH,140,2800.021,1517.392,155.1762,0,0,0,0,100,0), +(@PATH,141,2795.555,1505.82,154.9095,0,0,0,0,100,0), +(@PATH,142,2795.305,1494.82,155.4095,0,0,0,0,100,0), +(@PATH,143,2795.055,1482.07,155.6595,0,0,0,0,100,0), +(@PATH,144,2794.805,1472.07,156.4095,0,0,0,0,100,0), +(@PATH,145,2794.471,1463.688,156.3312,0,0,0,0,100,0), +(@PATH,146,2794.971,1460.688,155.5812,0,0,0,0,100,0), +(@PATH,147,2795.221,1458.688,155.0812,0,0,0,0,100,0), +(@PATH,148,2795.471,1456.688,154.3312,0,0,0,0,100,0), +(@PATH,149,2795.721,1453.688,153.5812,0,0,0,0,100,0), +(@PATH,150,2796.221,1450.688,152.8312,0,0,0,0,100,0), +(@PATH,151,2796.471,1448.938,152.3312,0,0,0,0,100,0), +(@PATH,152,2796.471,1446.938,151.5812,0,0,0,0,100,0), +(@PATH,153,2796.721,1444.938,151.0812,0,0,0,0,100,0), +(@PATH,154,2797.221,1440.938,150.3312,0,0,0,0,100,0), +(@PATH,155,2797.471,1439.188,149.3312,0,0,0,0,100,0), +(@PATH,156,2797.721,1437.188,148.5812,0,0,0,0,100,0), +(@PATH,157,2797.971,1435.188,148.0812,0,0,0,0,100,0), +(@PATH,158,2798.221,1433.188,147.3312,0,0,0,0,100,0), +(@PATH,159,2798.166,1432.999,147.353,0,0,0,0,100,0), +(@PATH,160,2797.916,1434.999,148.103,0,0,0,0,100,0), +(@PATH,161,2797.666,1436.999,148.603,0,0,0,0,100,0), +(@PATH,162,2797.416,1438.999,149.353,0,0,0,0,100,0), +(@PATH,163,2797.166,1440.999,150.353,0,0,0,0,100,0), +(@PATH,164,2796.916,1442.999,151.103,0,0,0,0,100,0), +(@PATH,165,2796.416,1446.999,151.603,0,0,0,0,100,0), +(@PATH,166,2796.416,1448.749,152.353,0,0,0,0,100,0), +(@PATH,167,2796.166,1450.749,152.853,0,0,0,0,100,0), +(@PATH,168,2795.916,1453.749,153.603,0,0,0,0,100,0), +(@PATH,169,2795.416,1456.749,154.353,0,0,0,0,100,0), +(@PATH,170,2795.166,1458.749,155.103,0,0,0,0,100,0), +(@PATH,171,2794.916,1460.749,155.603,0,0,0,0,100,0), +(@PATH,172,2794.664,1463.807,156.3249,0,0,0,0,100,0), +(@PATH,173,2794.914,1477.807,155.8249,0,0,0,0,100,0), +(@PATH,174,2794.914,1491.557,155.3249,0,0,0,0,100,0), +(@PATH,175,2795.164,1501.557,155.0749,0,0,0,0,100,0), +(@PATH,176,2795.31,1501.878,155.0099,0,0,0,0,100,0), +(@PATH,177,2795.56,1505.878,154.7599,0,0,0,0,100,0), +(@PATH,178,2800.31,1518.128,155.5099,0,0,0,0,100,0), +(@PATH,179,2802.06,1522.378,156.2599,0,0,0,0,100,0), +(@PATH,180,2803.31,1525.128,157.0099,0,0,0,0,100,0), +(@PATH,181,2804.81,1528.878,157.5099,0,0,0,0,100,0), +(@PATH,182,2805.81,1531.628,158.2599,0,0,0,0,100,0), +(@PATH,183,2807.06,1534.378,159.0099,0,0,0,0,100,0), +(@PATH,184,2807.293,1534.594,159.2192,0,0,0,0,100,0), +(@PATH,185,2808.793,1538.344,159.4692,0,0,0,0,100,0), +(@PATH,186,2812.043,1542.094,160.2192,0,0,0,0,100,0), +(@PATH,187,2828.293,1560.844,160.9692,0,0,0,0,100,0), +(@PATH,188,2828.378,1561.043,160.8421,0,0,0,0,100,0), +(@PATH,189,2829.878,1562.793,161.0921,0,0,0,0,100,0), +(@PATH,190,2833.628,1566.043,161.8421,0,0,0,0,100,0), +(@PATH,191,2837.378,1569.543,161.0921,0,0,0,0,100,0), +(@PATH,192,2847.378,1578.793,160.5921,0,0,0,0,100,0), +(@PATH,193,2851.628,1583.043,159.8421,0,0,0,0,100,0), +(@PATH,194,2856.128,1587.043,159.5921,0,0,0,0,100,0), +(@PATH,195,2856.338,1587.402,159.2415,0,0,0,0,100,0), +(@PATH,196,2856.838,1587.902,159.2415,0,0,0,0,100,0), +(@PATH,197,2859.838,1592.152,158.4915,0,0,0,0,100,0), +(@PATH,198,2863.088,1596.902,157.9915,0,0,0,0,100,0), +(@PATH,199,2865.588,1600.152,157.2415,0,0,0,0,100,0), +(@PATH,200,2867.588,1603.402,156.9915,0,0,0,0,100,0), +(@PATH,201,2871.588,1609.152,156.4915,0,0,0,0,100,0), +(@PATH,202,2874.838,1613.902,155.7415,0,0,0,0,100,0), +(@PATH,203,2877.838,1618.152,155.2415,0,0,0,0,100,0); + +-- 2. Ta' zinni +SET @NPC := 113899; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2847.589,`position_y`=1833.015,`position_z`=139.5768 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,2847.589,1833.015,139.5768,0,0,0,0,100,0), +(@PATH,2,2848.839,1836.765,139.0768,0,0,0,0,100,0), +(@PATH,3,2850.589,1841.515,138.0768,0,0,0,0,100,0), +(@PATH,4,2851.589,1845.015,137.8268,0,0,0,0,100,0), +(@PATH,5,2853.089,1849.765,136.8268,0,0,0,0,100,0), +(@PATH,6,2855.238,1855.55,136.0215,0,0,0,0,100,0), +(@PATH,7,2857.988,1856.8,135.2715,0,0,0,0,100,0), +(@PATH,8,2860.738,1858.3,134.5215,0,0,0,0,100,0), +(@PATH,9,2865.238,1860.05,134.0215,0,0,0,0,100,0), +(@PATH,10,2870.488,1862.55,134.5215,0,0,0,0,100,0), +(@PATH,11,2872.238,1863.55,133.7715,0,0,0,0,100,0), +(@PATH,12,2873.238,1864.05,133.0215,0,0,0,0,100,0), +(@PATH,13,2874.988,1864.8,132.2715,0,0,0,0,100,0), +(@PATH,14,2876.738,1865.55,131.2715,0,0,0,0,100,0), +(@PATH,15,2876.947,1865.783,131.0452,0,0,0,0,100,0), +(@PATH,16,2877.947,1866.033,130.7952,0,0,0,0,100,0), +(@PATH,17,2882.697,1864.533,131.5452,0,0,0,0,100,0), +(@PATH,18,2887.447,1862.783,131.0452,0,0,0,0,100,0), +(@PATH,19,2888.947,1862.283,131.5452,0,0,0,0,100,0), +(@PATH,20,2891.947,1861.283,130.2952,0,0,0,0,100,0), +(@PATH,21,2892.697,1861.033,129.7952,0,0,0,0,100,0), +(@PATH,22,2893.697,1860.783,128.7952,0,0,0,0,100,0), +(@PATH,23,2894.697,1860.533,129.5452,0,0,0,0,100,0), +(@PATH,24,2895.697,1860.033,130.0452,0,0,0,0,100,0), +(@PATH,25,2896.697,1859.783,130.7952,0,0,0,0,100,0), +(@PATH,26,2899.447,1858.783,129.7952,0,0,0,0,100,0), +(@PATH,27,2900.447,1858.533,129.0452,0,0,0,0,100,0), +(@PATH,28,2899.692,1858.481,129.6603,0,0,0,0,100,0), +(@PATH,29,2900.692,1858.231,129.1603,0,0,0,0,100,0), +(@PATH,30,2901.942,1857.731,128.9103,0,0,0,0,100,0), +(@PATH,31,2904.692,1855.981,128.1603,0,0,0,0,100,0), +(@PATH,32,2908.692,1853.481,128.9103,0,0,0,0,100,0), +(@PATH,33,2922.463,1844.618,129.8401,0,0,0,0,100,0), +(@PATH,34,2924.713,1841.368,130.5901,0,0,0,0,100,0), +(@PATH,35,2926.713,1838.118,131.0901,0,0,0,0,100,0), +(@PATH,36,2927.713,1836.618,131.5901,0,0,0,0,100,0), +(@PATH,37,2929.963,1833.118,132.0901,0,0,0,0,100,0), +(@PATH,38,2932.148,1829.933,132.7596,0,0,0,0,100,0), +(@PATH,39,2933.648,1825.433,133.5096,0,0,0,0,100,0), +(@PATH,40,2935.148,1821.933,133.7596,0,0,0,0,100,0), +(@PATH,41,2936.398,1819.183,134.5096,0,0,0,0,100,0), +(@PATH,42,2936.329,1818.895,134.4582,0,0,0,0,100,0), +(@PATH,43,2937.329,1816.395,135.2082,0,0,0,0,100,0), +(@PATH,44,2936.829,1804.895,134.4582,0,0,0,0,100,0), +(@PATH,45,2936.426,1792.523,134.2393,0,0,0,0,100,0), +(@PATH,46,2928.676,1786.523,134.7393,0,0,0,0,100,0), +(@PATH,47,2926.926,1785.273,135.9893,0,0,0,0,100,0), +(@PATH,48,2925.426,1784.273,136.9893,0,0,0,0,100,0), +(@PATH,49,2923.176,1782.273,135.7393,0,0,0,0,100,0), +(@PATH,50,2921.676,1781.273,134.2393,0,0,0,0,100,0), +(@PATH,51,2920.176,1780.023,132.7393,0,0,0,0,100,0), +(@PATH,52,2917.676,1778.023,133.2393,0,0,0,0,100,0), +(@PATH,53,2916.176,1776.773,134.2393,0,0,0,0,100,0), +(@PATH,54,2913.926,1775.023,134.9893,0,0,0,0,100,0), +(@PATH,55,2913.46,1774.671,135.3759,0,0,0,0,100,0), +(@PATH,56,2912.21,1773.671,134.8759,0,0,0,0,100,0), +(@PATH,57,2900.71,1772.421,135.6259,0,0,0,0,100,0), +(@PATH,58,2898.71,1772.171,136.1259,0,0,0,0,100,0), +(@PATH,59,2895.212,1771.508,136.4189,0,0,0,0,100,0), +(@PATH,60,2892.462,1770.258,137.1689,0,0,0,0,100,0), +(@PATH,61,2888.712,1768.508,137.9189,0,0,0,0,100,0), +(@PATH,62,2886.212,1767.508,138.4189,0,0,0,0,100,0), +(@PATH,63,2884.462,1766.758,139.1689,0,0,0,0,100,0), +(@PATH,64,2881.712,1765.508,139.6689,0,0,0,0,100,0), +(@PATH,65,2881.425,1765.528,139.6664,0,0,0,0,100,0), +(@PATH,66,2880.425,1765.028,139.9164,0,0,0,0,100,0), +(@PATH,67,2875.675,1768.528,140.4164,0,0,0,0,100,0), +(@PATH,68,2869.425,1773.028,139.6664,0,0,0,0,100,0), +(@PATH,69,2863.509,1777.198,140.0486,0,0,0,0,100,0), +(@PATH,70,2856.009,1784.948,140.7986,0,0,0,0,100,0), +(@PATH,71,2853.797,1787.424,141.0812,0,0,0,0,100,0), +(@PATH,72,2853.097,1798.46,141.2018,0,0,0,0,100,0), +(@PATH,73,2850.904,1812.617,141.2262,0,0,0,0,100,0), +(@PATH,74,2850.154,1817.617,140.7262,0,0,0,0,100,0), +(@PATH,75,2848.654,1827.117,140.2262,0,0,0,0,100,0); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=113899; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(113899, 113899, 0, 0, 2, 0, 0), +(113899, 111823, 3, 90, 2, 0, 0); + +DELETE FROM `creature_template_addon` WHERE `entry` IN (26280, 26344); +INSERT INTO `creature_template_addon` (`entry`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(26280,0,0,0,1,27, ''), +(26344,0,0,0,1,27, ''); + +-- 3. Deranged Indu'le Villager +SET @NPC := 100043; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3244.186,`position_y`=1513.984,`position_z`=170.5267 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,3244.186,1513.984,170.5267,0,0,0,0,100,0), +(@PATH,2,3237.186,1522.484,170.7767,0,0,0,0,100,0), +(@PATH,3,3230.436,1530.734,171.2767,0,0,0,0,100,0), +(@PATH,4,3237.859,1521.501,170.5541,0,0,0,0,100,0), +(@PATH,5,3244.26,1513.659,170.1406,0,0,0,0,100,0), +(@PATH,6,3248.01,1498.409,169.6406,0,0,0,0,100,0), +(@PATH,7,3248.402,1498.378,169.4282,0,0,0,0,100,0), +(@PATH,8,3248.902,1496.378,169.1782,0,0,0,0,100,0), +(@PATH,9,3250.152,1481.628,168.9282,0,0,0,0,100,0), +(@PATH,10,3250.505,1476.892,169.1679,0,0,0,0,100,0), +(@PATH,11,3250.755,1469.142,169.6679,0,0,0,0,100,0), +(@PATH,12,3250.755,1466.142,169.9179,0,0,0,0,100,0), +(@PATH,13,3250.755,1463.142,170.6679,0,0,0,0,100,0), +(@PATH,14,3250.721,1466.701,169.9852,0,0,0,0,100,0), +(@PATH,15,3250.721,1469.451,169.7352,0,0,0,0,100,0), +(@PATH,16,3250.721,1475.451,168.9852,0,0,0,0,100,0), +(@PATH,17,3250.58,1475.712,169.0303,0,0,0,0,100,0), +(@PATH,18,3250.58,1477.212,169.0303,0,0,0,0,100,0), +(@PATH,19,3248.476,1496.626,169.5226,0,0,0,0,100,0), +(@PATH,20,3247.226,1501.626,170.0226,0,0,0,0,100,0); + +-- 4. Indu'le Mystic Visual +-- Indu'le Mystic SAI +SET @ENTRY := 26336; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0 AND `id`>=10; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,10,11,25,0,100,0,0,0,0,0,75,32423,0,0,0,0,0,1,0,0,0,0,0,0,0,"Indu'le Mystic - On Reset - Add Aura 'Blue Radiation'"), +(@ENTRY,0,11,0,61,0,100,0,0,0,0,0,11,39550,0,0,0,0,0,1,0,0,0,0,0,0,0,"Indu'le Mystic - On Reset - Cast 'Arcane Channeling'"); + +-- 5. Deranged Indu'le Villager +SET @NPC := 100041; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3126.96,`position_y`=1293.866,`position_z`=158.7721 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,3126.96,1293.866,158.7721,0,0,0,0,100,0), +(@PATH,2,3146.06,1321.432,158.7955,0,0,0,0,100,0), +(@PATH,3,3146.06,1325.182,158.7955,0,0,0,0,100,0), +(@PATH,4,3150.31,1330.432,158.5455,0,0,0,0,100,0), +(@PATH,5,3151.31,1331.432,158.5455,0,0,0,0,100,0), +(@PATH,6,3151.31,1333.432,158.5455,0,0,0,0,100,0), +(@PATH,7,3152.06,1337.432,158.0455,0,0,0,0,100,0), +(@PATH,8,3154.06,1338.432,157.7955,0,0,0,0,100,0), +(@PATH,9,3156.31,1339.182,157.5455,0,0,0,0,100,0), +(@PATH,10,3158.31,1341.182,157.5455,0,0,0,0,100,0), +(@PATH,11,3158.545,1341.367,157.3181,0,0,0,0,100,0), +(@PATH,12,3159.045,1344.367,156.8181,0,0,0,0,100,0), +(@PATH,13,3160.545,1349.117,156.0681,0,0,0,0,100,0), +(@PATH,14,3161.545,1351.867,155.3181,0,0,0,0,100,0), +(@PATH,15,3161.795,1353.617,154.8181,0,0,0,0,100,0), +(@PATH,16,3162.795,1356.367,154.0681,0,0,0,0,100,0), +(@PATH,17,3163.795,1359.367,153.5681,0,0,0,0,100,0), +(@PATH,18,3164.795,1362.117,152.8181,0,0,0,0,100,0), +(@PATH,19,3165.856,1365.882,151.9305,0,0,0,0,100,0), +(@PATH,20,3165.106,1368.882,151.4305,0,0,0,0,100,0), +(@PATH,21,3164.856,1369.882,151.1805,0,0,0,0,100,0), +(@PATH,22,3163.168,1383.639,150.3603,0,0,0,0,100,0), +(@PATH,23,3159.668,1396.889,149.6103,0,0,0,0,100,0), +(@PATH,24,3159.668,1397.889,149.8603,0,0,0,0,100,0), +(@PATH,25,3158.668,1400.639,150.6103,0,0,0,0,100,0), +(@PATH,26,3157.283,1404.197,151.2236,0,0,0,0,100,0), +(@PATH,27,3156.533,1411.947,151.7236,0,0,0,0,100,0), +(@PATH,28,3155.533,1424.697,151.2236,0,0,0,0,100,0), +(@PATH,29,3154.572,1430.593,150.8368,0,0,0,0,100,0), +(@PATH,30,3148.822,1447.343,150.5868,0,0,0,0,100,0), +(@PATH,31,3146.595,1453.135,150.8087,0,0,0,0,100,0), +(@PATH,32,3142.095,1460.885,150.8087,0,0,0,0,100,0), +(@PATH,33,3135.345,1472.635,151.5587,0,0,0,0,100,0), +(@PATH,34,3135.122,1473.082,151.7024,0,0,0,0,100,0), +(@PATH,35,3133.622,1475.582,151.7024,0,0,0,0,100,0), +(@PATH,36,3126.122,1483.582,152.2024,0,0,0,0,100,0), +(@PATH,37,3113.515,1497.401,152.5099,0,0,0,0,100,0), +(@PATH,38,3110.765,1502.901,153.2599,0,0,0,0,100,0), +(@PATH,39,3108.515,1508.151,153.5099,0,0,0,0,100,0), +(@PATH,40,3106.765,1511.651,154.2599,0,0,0,0,100,0), +(@PATH,41,3103.515,1518.901,154.7599,0,0,0,0,100,0), +(@PATH,42,3101.554,1522.729,155.3441,0,0,0,0,100,0), +(@PATH,43,3101.054,1527.729,155.8441,0,0,0,0,100,0), +(@PATH,44,3100.804,1532.729,156.3441,0,0,0,0,100,0), +(@PATH,45,3100.554,1539.479,156.8441,0,0,0,0,100,0), +(@PATH,46,3100.304,1545.479,157.3441,0,0,0,0,100,0), +(@PATH,47,3099.449,1555.321,157.6841,0,0,0,0,100,0), +(@PATH,48,3079.664,1574.581,157.6775,0,0,0,0,100,0), +(@PATH,49,3052.813,1585.949,157.3968,0,0,0,0,100,0), +(@PATH,50,3018.021,1584.038,157.1514,0,0,0,0,100,0), +(@PATH,51,3000.271,1585.538,156.4014,0,0,0,0,100,0), +(@PATH,52,2994.271,1586.038,156.1514,0,0,0,0,100,0), +(@PATH,53,2993.949,1586.003,155.8834,0,0,0,0,100,0), +(@PATH,54,2992.699,1586.003,156.1334,0,0,0,0,100,0), +(@PATH,55,2976.199,1579.753,155.3834,0,0,0,0,100,0), +(@PATH,56,2976.037,1579.397,155.2239,0,0,0,0,100,0), +(@PATH,57,2972.787,1578.147,154.9739,0,0,0,0,100,0), +(@PATH,58,2969.537,1575.647,154.2239,0,0,0,0,100,0), +(@PATH,59,2966.787,1573.147,153.7239,0,0,0,0,100,0), +(@PATH,60,2962.287,1569.397,153.2239,0,0,0,0,100,0), +(@PATH,61,2959.287,1566.897,152.4739,0,0,0,0,100,0), +(@PATH,62,2958.891,1566.53,152.3397,0,0,0,0,100,0), +(@PATH,63,2957.141,1565.03,151.8397,0,0,0,0,100,0), +(@PATH,64,2952.891,1557.28,151.5897,0,0,0,0,100,0), +(@PATH,65,2945.898,1543.377,151.6312,0,0,0,0,100,0), +(@PATH,66,2948.596,1515.54,151.5872,0,0,0,0,100,0), +(@PATH,67,2957.712,1494.943,151.9908,0,0,0,0,100,0), +(@PATH,68,2966.525,1471.69,151.3434,0,0,0,0,100,0), +(@PATH,69,2966.692,1453.166,151.393,0,0,0,0,100,0), +(@PATH,70,2955.593,1436.157,151.5051,0,0,0,0,100,0), +(@PATH,71,2937.633,1421.492,151.8211,0,0,0,0,100,0), +(@PATH,72,2922.334,1406.523,151.9465,0,0,0,0,100,0), +(@PATH,73,2920.334,1398.023,152.6965,0,0,0,0,100,0), +(@PATH,74,2919.584,1394.273,152.9465,0,0,0,0,100,0), +(@PATH,75,2918.834,1391.273,153.9465,0,0,0,0,100,0), +(@PATH,76,2918.692,1391.122,154.1996,0,0,0,0,100,0), +(@PATH,77,2918.442,1389.122,154.6996,0,0,0,0,100,0), +(@PATH,78,2918.942,1386.372,155.4496,0,0,0,0,100,0), +(@PATH,79,2919.442,1384.622,155.9496,0,0,0,0,100,0), +(@PATH,80,2920.192,1380.622,156.6996,0,0,0,0,100,0), +(@PATH,81,2920.442,1378.872,157.1996,0,0,0,0,100,0), +(@PATH,82,2920.429,1378.551,157.5849,0,0,0,0,100,0), +(@PATH,83,2920.679,1377.801,157.8349,0,0,0,0,100,0), +(@PATH,84,2920.179,1374.801,158.3349,0,0,0,0,100,0), +(@PATH,85,2919.679,1372.801,158.8349,0,0,0,0,100,0), +(@PATH,86,2918.929,1368.051,159.5849,0,0,0,0,100,0), +(@PATH,87,2918.179,1364.301,160.0849,0,0,0,0,100,0), +(@PATH,88,2917.84,1363.903,160.1811,0,0,0,0,100,0), +(@PATH,89,2917.59,1363.403,160.1811,0,0,0,0,100,0), +(@PATH,90,2916.84,1353.403,160.9311,0,0,0,0,100,0), +(@PATH,91,2915.305,1333.434,160.8125,0,0,0,0,100,0), +(@PATH,92,2915.305,1326.434,160.3125,0,0,0,0,100,0), +(@PATH,93,2915.305,1321.684,159.5625,0,0,0,0,100,0), +(@PATH,94,2915.305,1318.684,158.8125,0,0,0,0,100,0), +(@PATH,95,2915.305,1315.684,158.0625,0,0,0,0,100,0), +(@PATH,96,2915.305,1312.684,157.3125,0,0,0,0,100,0), +(@PATH,97,2915.305,1310.684,156.5625,0,0,0,0,100,0), +(@PATH,98,2915.664,1310.57,156.5071,0,0,0,0,100,0), +(@PATH,99,2915.664,1310.07,156.0071,0,0,0,0,100,0), +(@PATH,100,2916.414,1308.32,155.2571,0,0,0,0,100,0), +(@PATH,101,2917.664,1305.57,154.5071,0,0,0,0,100,0), +(@PATH,102,2918.914,1302.82,153.7571,0,0,0,0,100,0), +(@PATH,103,2920.414,1299.07,153.0071,0,0,0,0,100,0), +(@PATH,104,2921.664,1295.57,152.2571,0,0,0,0,100,0), +(@PATH,105,2928.093,1280.75,151.4069,0,0,0,0,100,0), +(@PATH,106,2939.343,1272.75,151.1569,0,0,0,0,100,0), +(@PATH,107,2952.039,1263.536,151.009,0,0,0,0,100,0), +(@PATH,108,2962.289,1257.036,150.509,0,0,0,0,100,0), +(@PATH,109,2968.039,1253.536,150.009,0,0,0,0,100,0), +(@PATH,110,2978.197,1247.234,149.3385,0,0,0,0,100,0), +(@PATH,111,2991.994,1240.328,149.4494,0,0,0,0,100,0), +(@PATH,112,3016.52,1238.816,149.564,0,0,0,0,100,0), +(@PATH,113,3033.02,1242.066,149.814,0,0,0,0,100,0), +(@PATH,114,3037.41,1243.237,150.3568,0,0,0,0,100,0), +(@PATH,115,3044.66,1246.487,150.8568,0,0,0,0,100,0), +(@PATH,116,3052.66,1249.737,151.3568,0,0,0,0,100,0), +(@PATH,117,3052.973,1250.125,151.7139,0,0,0,0,100,0), +(@PATH,118,3056.473,1251.625,152.2139,0,0,0,0,100,0), +(@PATH,119,3060.473,1252.375,152.7139,0,0,0,0,100,0), +(@PATH,120,3063.473,1252.375,153.4639,0,0,0,0,100,0), +(@PATH,121,3065.973,1252.875,154.2139,0,0,0,0,100,0), +(@PATH,122,3067.973,1253.375,154.7139,0,0,0,0,100,0), +(@PATH,123,3070.973,1253.875,155.7139,0,0,0,0,100,0), +(@PATH,124,3073.973,1254.375,156.2139,0,0,0,0,100,0), +(@PATH,125,3077.973,1254.875,156.9639,0,0,0,0,100,0), +(@PATH,126,3078.058,1255.08,157.1807,0,0,0,0,100,0), +(@PATH,127,3079.308,1255.33,157.4307,0,0,0,0,100,0), +(@PATH,128,3083.058,1258.83,157.9307,0,0,0,0,100,0), +(@PATH,129,3087.308,1263.08,158.6807,0,0,0,0,100,0), +(@PATH,130,3099.604,1274.983,158.773,0,0,0,0,100,0); + +-- 6. Corrupted Lothalor Ancient +SET @NPC := 117140; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3027.883,`position_y`=1675.255,`position_z`=150.5858 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,3027.883,1675.255,150.5858,0,0,0,0,100,0), +(@PATH,2,3029.883,1677.005,150.0858,0,0,0,0,100,0), +(@PATH,3,3044.133,1681.755,149.5858,0,0,0,0,100,0), +(@PATH,4,3047.133,1682.505,148.8358,0,0,0,0,100,0), +(@PATH,5,3050.883,1683.505,148.0858,0,0,0,0,100,0), +(@PATH,6,3063.883,1687.755,147.3358,0,0,0,0,100,0), +(@PATH,7,3067.633,1689.005,146.8358,0,0,0,0,100,0), +(@PATH,8,3072.383,1690.505,146.0858,0,0,0,0,100,0), +(@PATH,9,3072.838,1690.899,146.1686,0,0,0,0,100,0), +(@PATH,10,3074.588,1691.399,145.9186,0,0,0,0,100,0), +(@PATH,11,3081.588,1692.649,145.1686,0,0,0,0,100,0), +(@PATH,12,3103.088,1695.899,145.9186,0,0,0,0,100,0), +(@PATH,13,3110.838,1697.149,146.4186,0,0,0,0,100,0), +(@PATH,14,3117.838,1698.149,146.9186,0,0,0,0,100,0), +(@PATH,15,3121.838,1698.899,147.4186,0,0,0,0,100,0), +(@PATH,16,3122.006,1699.197,147.5443,0,0,0,0,100,0), +(@PATH,17,3124.006,1699.447,147.7943,0,0,0,0,100,0), +(@PATH,18,3127.756,1700.697,148.0443,0,0,0,0,100,0), +(@PATH,19,3132.506,1702.197,148.7943,0,0,0,0,100,0), +(@PATH,20,3148.506,1707.447,148.0443,0,0,0,0,100,0), +(@PATH,21,3151.256,1708.447,147.2943,0,0,0,0,100,0), +(@PATH,22,3154.006,1709.447,146.7943,0,0,0,0,100,0), +(@PATH,23,3157.756,1710.697,145.7943,0,0,0,0,100,0), +(@PATH,24,3160.756,1711.697,145.2943,0,0,0,0,100,0), +(@PATH,25,3165.506,1713.197,144.5443,0,0,0,0,100,0), +(@PATH,26,3165.761,1713.305,144.3196,0,0,0,0,100,0), +(@PATH,27,3167.261,1713.805,144.3196,0,0,0,0,100,0), +(@PATH,28,3183.761,1707.055,144.8196,0,0,0,0,100,0), +(@PATH,29,3200.261,1700.305,144.3196,0,0,0,0,100,0), +(@PATH,30,3204.761,1698.555,143.5696,0,0,0,0,100,0), +(@PATH,31,3207.511,1697.305,143.0696,0,0,0,0,100,0), +(@PATH,32,3207.937,1697.012,142.9652,0,0,0,0,100,0), +(@PATH,33,3209.687,1696.262,142.7152,0,0,0,0,100,0), +(@PATH,34,3214.187,1694.262,141.7152,0,0,0,0,100,0), +(@PATH,35,3224.937,1689.512,142.4652,0,0,0,0,100,0), +(@PATH,36,3229.437,1687.512,143.2152,0,0,0,0,100,0), +(@PATH,37,3233.937,1685.512,143.7152,0,0,0,0,100,0), +(@PATH,38,3238.687,1683.262,144.2152,0,0,0,0,100,0), +(@PATH,39,3238.768,1683.138,144.2682,0,0,0,0,100,0), +(@PATH,40,3241.518,1681.888,144.7682,0,0,0,0,100,0), +(@PATH,41,3241.768,1679.888,145.2682,0,0,0,0,100,0), +(@PATH,42,3242.018,1676.888,146.0182,0,0,0,0,100,0), +(@PATH,43,3242.268,1673.888,146.5182,0,0,0,0,100,0), +(@PATH,44,3242.518,1671.888,147.2682,0,0,0,0,100,0), +(@PATH,45,3243.268,1666.888,147.7682,0,0,0,0,100,0), +(@PATH,46,3243.518,1664.138,148.5182,0,0,0,0,100,0), +(@PATH,47,3245.599,1647.204,149.1092,0,0,0,0,100,0), +(@PATH,48,3249.599,1643.954,148.3592,0,0,0,0,100,0), +(@PATH,49,3254.099,1639.954,147.6092,0,0,0,0,100,0), +(@PATH,50,3255.599,1638.704,146.8592,0,0,0,0,100,0), +(@PATH,51,3259.349,1635.704,146.1092,0,0,0,0,100,0), +(@PATH,52,3262.099,1633.204,145.6092,0,0,0,0,100,0), +(@PATH,53,3265.849,1629.704,144.8592,0,0,0,0,100,0), +(@PATH,54,3268.849,1627.204,144.3592,0,0,0,0,100,0), +(@PATH,55,3275.599,1621.204,143.8592,0,0,0,0,100,0), +(@PATH,56,3271.495,1624.821,144.2386,0,0,0,0,100,0), +(@PATH,57,3266.995,1628.821,144.7386,0,0,0,0,100,0), +(@PATH,58,3263.245,1632.071,145.4886,0,0,0,0,100,0), +(@PATH,59,3260.495,1634.571,145.9886,0,0,0,0,100,0), +(@PATH,60,3257.495,1637.071,146.7386,0,0,0,0,100,0), +(@PATH,61,3254.495,1639.821,147.7386,0,0,0,0,100,0), +(@PATH,62,3249.995,1643.571,148.4886,0,0,0,0,100,0), +(@PATH,63,3245.63,1647.635,149.0679,0,0,0,0,100,0), +(@PATH,64,3245.13,1651.385,148.3179,0,0,0,0,100,0), +(@PATH,65,3243.38,1667.135,147.8179,0,0,0,0,100,0), +(@PATH,66,3243.13,1670.135,147.3179,0,0,0,0,100,0), +(@PATH,67,3242.63,1673.135,146.5679,0,0,0,0,100,0), +(@PATH,68,3242.38,1676.135,146.0679,0,0,0,0,100,0), +(@PATH,69,3242.13,1679.135,145.5679,0,0,0,0,100,0), +(@PATH,70,3242.099,1676.364,145.9094,0,0,0,0,100,0), +(@PATH,71,3241.849,1679.364,145.1594,0,0,0,0,100,0), +(@PATH,72,3241.349,1682.114,144.4094,0,0,0,0,100,0), +(@PATH,73,3237.849,1683.614,143.9094,0,0,0,0,100,0), +(@PATH,74,3233.349,1685.614,143.4094,0,0,0,0,100,0), +(@PATH,75,3225.849,1688.864,142.4094,0,0,0,0,100,0), +(@PATH,76,3221.599,1690.864,141.6594,0,0,0,0,100,0), +(@PATH,77,3211.599,1695.364,142.6594,0,0,0,0,100,0), +(@PATH,78,3211.41,1695.772,142.5507,0,0,0,0,100,0), +(@PATH,79,3209.41,1696.522,142.8007,0,0,0,0,100,0), +(@PATH,80,3206.66,1697.772,143.3007,0,0,0,0,100,0), +(@PATH,81,3203.91,1698.772,144.0507,0,0,0,0,100,0), +(@PATH,82,3198.41,1701.022,144.8007,0,0,0,0,100,0), +(@PATH,83,3174.66,1710.772,144.0507,0,0,0,0,100,0), +(@PATH,84,3167.045,1713.788,144.4697,0,0,0,0,100,0), +(@PATH,85,3162.295,1712.288,145.2197,0,0,0,0,100,0), +(@PATH,86,3159.295,1711.288,145.7197,0,0,0,0,100,0), +(@PATH,87,3156.545,1710.288,146.2197,0,0,0,0,100,0), +(@PATH,88,3153.795,1709.288,146.9697,0,0,0,0,100,0), +(@PATH,89,3149.795,1708.038,147.9697,0,0,0,0,100,0), +(@PATH,90,3146.295,1706.788,148.4697,0,0,0,0,100,0), +(@PATH,91,3126.545,1700.288,147.9697,0,0,0,0,100,0), +(@PATH,92,3126.278,1700.021,147.9305,0,0,0,0,100,0), +(@PATH,93,3123.778,1699.271,147.6805,0,0,0,0,100,0), +(@PATH,94,3118.778,1698.271,146.9305,0,0,0,0,100,0), +(@PATH,95,3113.778,1697.521,146.6805,0,0,0,0,100,0), +(@PATH,96,3105.028,1696.021,145.9305,0,0,0,0,100,0), +(@PATH,97,3097.278,1695.021,145.4305,0,0,0,0,100,0), +(@PATH,98,3074.387,1691.2,145.9351,0,0,0,0,100,0), +(@PATH,99,3069.637,1689.7,146.4351,0,0,0,0,100,0), +(@PATH,100,3065.887,1688.45,147.1851,0,0,0,0,100,0), +(@PATH,101,3061.137,1686.95,147.6851,0,0,0,0,100,0), +(@PATH,102,3049.887,1683.45,148.1851,0,0,0,0,100,0), +(@PATH,103,3046.137,1682.2,149.4351,0,0,0,0,100,0), +(@PATH,104,3043.137,1681.45,149.9351,0,0,0,0,100,0), +(@PATH,105,3029.504,1676.955,150.2377,0,0,0,0,100,0), +(@PATH,106,3027.504,1674.955,151.2377,0,0,0,0,100,0), +(@PATH,107,3025.254,1672.705,151.9877,0,0,0,0,100,0), +(@PATH,108,3023.004,1670.705,152.4877,0,0,0,0,100,0), +(@PATH,109,3020.754,1668.705,152.9877,0,0,0,0,100,0), +(@PATH,110,3018.004,1665.955,153.4877,0,0,0,0,100,0), +(@PATH,111,3015.254,1663.705,154.4877,0,0,0,0,100,0), +(@PATH,112,3013.754,1662.205,155.4877,0,0,0,0,100,0), +(@PATH,113,3004.754,1654.205,156.2377,0,0,0,0,100,0), +(@PATH,114,3004.595,1654.042,156.1276,0,0,0,0,100,0), +(@PATH,115,3003.345,1653.042,156.3776,0,0,0,0,100,0), +(@PATH,116,2997.345,1653.042,155.8776,0,0,0,0,100,0), +(@PATH,117,2992.345,1653.042,155.1276,0,0,0,0,100,0), +(@PATH,118,2985.345,1652.792,154.6276,0,0,0,0,100,0), +(@PATH,119,2978.595,1652.792,153.8776,0,0,0,0,100,0), +(@PATH,120,2974.595,1652.792,153.6276,0,0,0,0,100,0), +(@PATH,121,2970.595,1652.792,152.8776,0,0,0,0,100,0), +(@PATH,122,2966.595,1652.792,152.3776,0,0,0,0,100,0), +(@PATH,123,2954.505,1652.478,151.8357,0,0,0,0,100,0), +(@PATH,124,2949.505,1653.728,151.0857,0,0,0,0,100,0), +(@PATH,125,2945.755,1654.728,150.3357,0,0,0,0,100,0), +(@PATH,126,2941.755,1655.478,149.5857,0,0,0,0,100,0), +(@PATH,127,2936.755,1656.728,148.8357,0,0,0,0,100,0), +(@PATH,128,2933.255,1657.478,148.3357,0,0,0,0,100,0), +(@PATH,129,2928.255,1658.478,147.8357,0,0,0,0,100,0), +(@PATH,130,2923.505,1659.478,147.0857,0,0,0,0,100,0), +(@PATH,131,2919.505,1660.478,146.5857,0,0,0,0,100,0), +(@PATH,132,2910.18,1662.967,145.9415,0,0,0,0,100,0), +(@PATH,133,2906.43,1666.217,145.1915,0,0,0,0,100,0), +(@PATH,134,2887.43,1683.717,145.9415,0,0,0,0,100,0), +(@PATH,135,2884.68,1686.467,146.4415,0,0,0,0,100,0), +(@PATH,136,2884.797,1686.268,146.0567,0,0,0,0,100,0), +(@PATH,137,2888.297,1682.768,145.8067,0,0,0,0,100,0), +(@PATH,138,2894.297,1677.518,145.0567,0,0,0,0,100,0), +(@PATH,139,2908.047,1664.768,145.5567,0,0,0,0,100,0), +(@PATH,140,2908.294,1664.457,145.5768,0,0,0,0,100,0), +(@PATH,141,2910.294,1662.707,146.0768,0,0,0,0,100,0), +(@PATH,142,2917.044,1660.957,146.5768,0,0,0,0,100,0), +(@PATH,143,2920.044,1660.457,147.0768,0,0,0,0,100,0), +(@PATH,144,2927.794,1658.707,147.8268,0,0,0,0,100,0), +(@PATH,145,2932.544,1657.707,148.3268,0,0,0,0,100,0), +(@PATH,146,2936.294,1656.707,148.5768,0,0,0,0,100,0), +(@PATH,147,2940.294,1655.957,149.3268,0,0,0,0,100,0), +(@PATH,148,2943.294,1655.207,150.0768,0,0,0,0,100,0), +(@PATH,149,2947.044,1654.207,150.8268,0,0,0,0,100,0), +(@PATH,150,2951.044,1653.457,151.5768,0,0,0,0,100,0), +(@PATH,151,2951.341,1653.032,151.6568,0,0,0,0,100,0), +(@PATH,152,2954.591,1652.532,151.9068,0,0,0,0,100,0), +(@PATH,153,2968.591,1652.782,152.6568,0,0,0,0,100,0), +(@PATH,154,2972.591,1652.782,153.1568,0,0,0,0,100,0), +(@PATH,155,2977.341,1652.782,153.6568,0,0,0,0,100,0), +(@PATH,156,2983.341,1652.782,154.4068,0,0,0,0,100,0), +(@PATH,157,2991.341,1653.032,154.9068,0,0,0,0,100,0), +(@PATH,158,2996.341,1653.032,155.6568,0,0,0,0,100,0), +(@PATH,159,3001.341,1653.032,156.1568,0,0,0,0,100,0), +(@PATH,160,3001.542,1653.045,156.0563,0,0,0,0,100,0), +(@PATH,161,3003.542,1653.045,156.3063,0,0,0,0,100,0), +(@PATH,162,3006.542,1655.795,155.5563,0,0,0,0,100,0), +(@PATH,163,3010.292,1659.045,155.0563,0,0,0,0,100,0), +(@PATH,164,3015.292,1663.795,154.0563,0,0,0,0,100,0), +(@PATH,165,3018.792,1667.045,153.3063,0,0,0,0,100,0), +(@PATH,166,3021.042,1669.045,152.8063,0,0,0,0,100,0); + +-- 7. Dragonblight Mage Hunter +SET @NPC := 101653; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3249.54,`position_y`=2495.336,`position_z`=41.3687 WHERE `guid`=@NPC; +UPDATE `creature` SET `spawndist`=0,`MovementType`=0,`position_x`=3249.54,`position_y`=2495.336,`position_z`=41.3687 WHERE `guid`=111808; +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,3249.54,2495.336,41.3687,0,0,0,0,100,0), +(@PATH,2,3247.784,2497.835,41.32549,0,0,0,0,100,0), +(@PATH,3,3246.039,2500.317,41.57574,0,0,0,0,100,0), +(@PATH,4,3243.765,2503.621,41.63885,0,0,0,0,100,0), +(@PATH,5,3242.897,2506.686,42.08795,0,0,0,0,100,0), +(@PATH,6,3242.029,2509.75,42.35028,0,0,0,0,100,0), +(@PATH,7,3241.156,2512.833,42.49152,0,0,0,0,100,0), +(@PATH,8,3240.284,2515.91,42.68109,0,0,0,0,100,0), +(@PATH,9,3239.402,2519.024,42.89935,0,0,0,0,100,0), +(@PATH,10,3238.608,2521.823,43.01495,0,0,0,0,100,0), +(@PATH,11,3237.81,2525.788,43.5097,0,0,0,0,100,0), +(@PATH,12,3238.228,2527.319,44.10952,0,0,0,0,100,0), +(@PATH,13,3238.811,2531.506,44.63812,0,0,0,0,100,0), +(@PATH,14,3238.982,2532.672,45.19152,0,0,0,0,100,0), +(@PATH,15,3239.754,2536.995,46.44672,0,0,0,0,100,0), +(@PATH,16,3239.925,2537.223,46.66315,0,0,0,0,100,0), +(@PATH,17,3240.774,2542.87,46.6424,0,0,0,0,100,0), +(@PATH,18,3240.929,2543.77,46.67103,0,0,0,0,100,0), +(@PATH,19,3241.179,2545.52,46.17103,0,0,0,0,100,0), +(@PATH,20,3243.802,2550.656,46.20685,0,0,0,0,100,0), +(@PATH,21,3246.092,2551.326,46.62245,0,0,0,0,100,0), +(@PATH,22,3249.739,2553.132,46.82648,0,0,0,0,100,0), +(@PATH,23,3252.717,2554.374,46.80084,0,0,0,0,100,0), +(@PATH,24,3255.739,2555.634,46.3985,0,0,0,0,100,0), +(@PATH,25,3257.392,2556.255,46.19845,0,0,0,0,100,0), +(@PATH,26,3261.364,2557.993,46.04279,0,0,0,0,100,0), +(@PATH,27,3261.723,2558.14,46.06793,0,0,0,0,100,0), +(@PATH,28,3262.484,2558.443,46.44879,0,0,0,0,100,0), +(@PATH,29,3259.649,2557.261,45.92462,0,0,0,0,100,0), +(@PATH,30,3256.858,2556.097,46.16437,0,0,0,0,100,0), +(@PATH,31,3255.227,2555.73,46.65943,0,0,0,0,100,0), +(@PATH,32,3251.336,2553.795,46.72723,0,0,0,0,100,0), +(@PATH,33,3248.548,2552.632,46.76642,0,0,0,0,100,0), +(@PATH,34,3245.899,2551.529,46.45856,0,0,0,0,100,0), +(@PATH,35,3241.96,2548.564,45.88812,0,0,0,0,100,0), +(@PATH,36,3241.213,2545.438,45.6059,0,0,0,0,100,0), +(@PATH,37,3241.248,2544.033,46.72429,0,0,0,0,100,0), +(@PATH,38,3240.605,2541.107,47.42216,0,0,0,0,100,0), +(@PATH,39,3239.73,2536.885,46.3222,0,0,0,0,100,0), +(@PATH,40,3239.816,2536.917,46.76496,0,0,0,0,100,0), +(@PATH,41,3239.566,2535.917,45.51496,0,0,0,0,100,0), +(@PATH,42,3238.69,2530.889,44.5611,0,0,0,0,100,0), +(@PATH,43,3238.202,2528.103,44.2962,0,0,0,0,100,0), +(@PATH,44,3238.193,2526.375,44.04677,0,0,0,0,100,0), +(@PATH,45,3238.818,2521.086,42.9516,0,0,0,0,100,0), +(@PATH,46,3239.648,2518.154,42.8244,0,0,0,0,100,0), +(@PATH,47,3240.475,2515.234,42.6983,0,0,0,0,100,0), +(@PATH,48,3241.311,2512.285,42.55267,0,0,0,0,100,0), +(@PATH,49,3242.144,2509.343,42.37787,0,0,0,0,100,0), +(@PATH,50,3242.942,2506.525,42.07416,0,0,0,0,100,0), +(@PATH,51,3244.205,2502.925,41.66071,0,0,0,0,100,0), +(@PATH,52,3245.86,2501.084,41.68626,0,0,0,0,100,0), +(@PATH,53,3247.701,2497.951,41.32951,0,0,0,0,100,0), +(@PATH,54,3249.436,2495.482,41.38664,0,0,0,0,100,0), +(@PATH,55,3251.177,2493.005,41.40324,0,0,0,0,100,0), +(@PATH,56,3252.918,2490.528,41.55168,0,0,0,0,100,0), +(@PATH,57,3254.689,2489.256,41.85149,0,0,0,0,100,0), +(@PATH,58,3255.654,2486.35,41.83318,0,0,0,0,100,0), +(@PATH,59,3256.631,2483.408,41.76433,0,0,0,0,100,0), +(@PATH,60,3257.608,2480.464,41.79485,0,0,0,0,100,0), +(@PATH,61,3258.569,2477.571,41.65385,0,0,0,0,100,0), +(@PATH,62,3259.544,2474.634,41.51701,0,0,0,0,100,0), +(@PATH,63,3261.051,2472.938,41.82683,0,0,0,0,100,0), +(@PATH,64,3260.772,2469.941,41.91692,0,0,0,0,100,0), +(@PATH,65,3260.499,2467,42.18571,0,0,0,0,100,0), +(@PATH,66,3260.221,2464.014,41.71806,0,0,0,0,100,0), +(@PATH,67,3259.942,2461.022,41.49309,0,0,0,0,100,0), +(@PATH,68,3259.677,2458.177,41.21782,0,0,0,0,100,0), +(@PATH,69,3259.97,2456.653,41.09612,0,0,0,0,100,0), +(@PATH,70,3258.444,2455.153,40.83181,0,0,0,0,100,0), +(@PATH,71,3257.242,2453.706,40.29644,0,0,0,0,100,0), +(@PATH,72,3254.1,2450.069,39.60124,0,0,0,0,100,0), +(@PATH,73,3251.918,2447.62,39.26897,0,0,0,0,100,0), +(@PATH,74,3251.019,2445.633,39.03606,0,0,0,0,100,0), +(@PATH,75,3248.314,2444.291,38.83647,0,0,0,0,100,0), +(@PATH,76,3245.607,2442.948,38.51164,0,0,0,0,100,0), +(@PATH,77,3242.906,2441.608,38.13213,0,0,0,0,100,0), +(@PATH,78,3240.204,2440.267,38.09355,0,0,0,0,100,0), +(@PATH,79,3237.515,2438.933,37.79057,0,0,0,0,100,0), +(@PATH,80,3234.787,2437.579,37.58818,0,0,0,0,100,0), +(@PATH,81,3232.052,2436.222,37.36251,0,0,0,0,100,0), +(@PATH,82,3229.354,2434.884,37.16512,0,0,0,0,100,0), +(@PATH,83,3226.098,2433.842,36.86872,0,0,0,0,100,0), +(@PATH,84,3223.527,2429.761,36.31184,0,0,0,0,100,0), +(@PATH,85,3223.332,2427.012,35.90656,0,0,0,0,100,0), +(@PATH,86,3223.007,2423.796,35.80329,0,0,0,0,100,0), +(@PATH,87,3222.761,2420.986,35.03156,0,0,0,0,100,0), +(@PATH,88,3222.67,2419.866,34.95074,0,0,0,0,100,0), +(@PATH,89,3222.215,2414.667,34.53156,0,0,0,0,100,0), +(@PATH,90,3222.585,2411.538,34.38386,0,0,0,0,100,0), +(@PATH,91,3222.955,2408.417,34.33942,0,0,0,0,100,0), +(@PATH,92,3223.325,2405.291,34.40656,0,0,0,0,100,0), +(@PATH,93,3223.688,2402.226,34.40656,0,0,0,0,100,0), +(@PATH,94,3223.757,2401.642,34.40656,0,0,0,0,100,0), +(@PATH,95,3223.854,2400.822,34.45649,0,0,0,0,100,0), +(@PATH,96,3223.704,2402.094,34.41949,1.907491,0,0,0,100,0), +(@PATH,97,3223.371,2404.902,34.40656,0,0,0,0,100,0), +(@PATH,98,3223.018,2407.881,34.27338,0,0,0,0,100,0), +(@PATH,99,3222.658,2410.924,34.37507,0,0,0,0,100,0), +(@PATH,100,3222.188,2414.38,34.53156,0,0,0,0,100,0), +(@PATH,101,3222.448,2417.364,34.65656,0,0,0,0,100,0), +(@PATH,102,3222.708,2420.347,34.82319,0,0,0,0,100,0), +(@PATH,103,3222.798,2422.253,35.76775,0,0,0,0,100,0), +(@PATH,104,3223.228,2426.303,35.83149,0,0,0,0,100,0), +(@PATH,105,3223.538,2431.997,36.43073,0,0,0,0,100,0), +(@PATH,106,3226.257,2433.346,36.79208,0,0,0,0,100,0), +(@PATH,107,3228.991,2434.703,37.14327,0,0,0,0,100,0), +(@PATH,108,3231.738,2436.066,37.32479,0,0,0,0,100,0), +(@PATH,109,3234.458,2437.415,37.67375,0,0,0,0,100,0), +(@PATH,110,3237.203,2438.777,37.91228,0,0,0,0,100,0), +(@PATH,111,3239.911,2440.121,38.07597,0,0,0,0,100,0), +(@PATH,112,3242.646,2441.478,38.11638,0,0,0,0,100,0), +(@PATH,113,3245.364,2442.826,38.48235,0,0,0,0,100,0), +(@PATH,114,3247.745,2442.945,38.81718,0,0,0,0,100,0), +(@PATH,115,3249.769,2445.207,39.08855,0,0,0,0,100,0), +(@PATH,116,3251.768,2447.441,39.25102,0,0,0,0,100,0), +(@PATH,117,3253.778,2449.686,39.61699,0,0,0,0,100,0), +(@PATH,118,3255.782,2451.925,39.98259,0,0,0,0,100,0), +(@PATH,119,3257.676,2454.054,40.47624,0,0,0,0,100,0), +(@PATH,120,3259.36,2454.74,40.72893,0,0,0,0,100,0), +(@PATH,121,3259.639,2457.743,41.15642,0,0,0,0,100,0), +(@PATH,122,3259.916,2460.717,41.48357,0,0,0,0,100,0), +(@PATH,123,3260.195,2463.712,41.70927,0,0,0,0,100,0), +(@PATH,124,3260.463,2466.59,42.35124,0,0,0,0,100,0), +(@PATH,125,3261.546,2468.533,42.35674,0,0,0,0,100,0), +(@PATH,126,3260.587,2471.431,41.76701,0,0,0,0,100,0), +(@PATH,127,3259.62,2474.355,41.53508,0,0,0,0,100,0), +(@PATH,128,3258.656,2477.27,41.63872,0,0,0,0,100,0), +(@PATH,129,3257.693,2480.179,41.77104,0,0,0,0,100,0), +(@PATH,130,3256.725,2483.108,41.87578,0,0,0,0,100,0), +(@PATH,131,3256.498,2485.439,41.91081,0,0,0,0,100,0), +(@PATH,132,3254.773,2487.893,41.74675,0,0,0,0,100,0), +(@PATH,133,3253.035,2490.365,41.61113,0,0,0,0,100,0), +(@PATH,134,3251.277,2492.866,41.3643,0,0,0,0,100,0); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=101653; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(101653, 101653, 0, 0, 2, 0, 0), +(101653, 111808, 3, 90, 2, 0, 0); + +-- levitating for dummy +UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry`=26832; + +-- kneelemotes +DELETE FROM `creature_addon` WHERE `guid`=115057; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(115057,0,0,0x8,1,0, ''); + +-- 8. Dragonblight Mage Hunter +SET @NPC := 101647; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3309.655,`position_y`=2685.866,`position_z`=37.56147 WHERE `guid`=@NPC; +UPDATE `creature` SET `spawndist`=0,`MovementType`=0,`position_x`=3309.655,`position_y`=2685.866,`position_z`=37.56147 WHERE `guid`=111799; +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,3309.655,2685.866,37.56147,0,0,0,0,100,0), +(@PATH,2,3307.381,2683.79,37.43366,0,0,0,0,100,0), +(@PATH,3,3305.116,2681.713,37.16193,0,0,0,0,100,0), +(@PATH,4,3303.542,2680.563,37.09797,0,0,0,0,100,0), +(@PATH,5,3301.671,2678.077,36.98542,0,0,0,0,100,0), +(@PATH,6,3299.763,2675.542,36.91856,0,0,0,0,100,0), +(@PATH,7,3297.884,2673.043,36.91856,0,0,0,0,100,0), +(@PATH,8,3296.002,2670.543,36.91856,0,0,0,0,100,0), +(@PATH,9,3294.122,2668.044,36.91856,0,0,0,0,100,0), +(@PATH,10,3292.247,2665.552,36.95589,0,0,0,0,100,0), +(@PATH,11,3290.969,2664.57,36.95589,0,0,0,0,100,0), +(@PATH,12,3289.89,2661.572,36.95589,0,0,0,0,100,0), +(@PATH,13,3287.939,2659.763,36.90929,0,0,0,0,100,0), +(@PATH,14,3287.745,2655.615,36.84457,0,0,0,0,100,0), +(@PATH,15,3286.667,2652.621,36.95589,0,0,0,0,100,0), +(@PATH,16,3285.605,2649.669,36.95589,0,0,0,0,100,0), +(@PATH,17,3284.536,2646.7,36.95589,0,0,0,0,100,0), +(@PATH,18,3283.062,2646.839,36.95589,0,0,0,0,100,0), +(@PATH,19,3283.566,2643.667,36.95589,0,0,0,0,100,0), +(@PATH,20,3284.072,2640.483,36.95589,0,0,0,0,100,0), +(@PATH,21,3284.576,2637.308,36.83089,0,0,0,0,100,0), +(@PATH,22,3285.082,2634.127,36.83089,0,0,0,0,100,0), +(@PATH,23,3285.59,2630.929,36.80254,0,0,0,0,100,0), +(@PATH,24,3286.098,2627.732,36.78325,0,0,0,0,100,0), +(@PATH,25,3286.605,2624.542,36.80254,0,0,0,0,100,0), +(@PATH,26,3287.11,2621.364,36.80254,0,0,0,0,100,0), +(@PATH,27,3287.619,2618.154,36.97575,0,0,0,0,100,0), +(@PATH,28,3287.749,2617.342,36.96025,0,0,0,0,100,0), +(@PATH,29,3287.878,2616.527,36.75676,0,0,0,0,100,0), +(@PATH,30,3287.711,2617.576,36.96477,0,0,0,0,100,0), +(@PATH,31,3287.237,2620.564,36.92754,0,0,0,0,100,0), +(@PATH,32,3286.757,2623.586,36.80254,0,0,0,0,100,0), +(@PATH,33,3286.281,2626.581,36.76128,0,0,0,0,100,0), +(@PATH,34,3285.808,2629.553,36.80254,0,0,0,0,100,0), +(@PATH,35,3285.332,2632.555,36.80254,0,0,0,0,100,0), +(@PATH,36,3284.856,2635.548,36.83578,0,0,0,0,100,0), +(@PATH,37,3284.379,2638.547,36.95589,0,0,0,0,100,0), +(@PATH,38,3283.906,2641.528,36.95589,0,0,0,0,100,0), +(@PATH,39,3282.922,2642.217,36.95589,0,0,0,0,100,0), +(@PATH,40,3284.02,2645.266,36.95589,0,0,0,0,100,0), +(@PATH,41,3285.111,2648.295,36.95589,0,0,0,0,100,0), +(@PATH,42,3286.196,2651.31,36.95589,0,0,0,0,100,0), +(@PATH,43,3287.283,2654.332,36.95589,0,0,0,0,100,0), +(@PATH,44,3288.363,2657.331,36.63863,0,0,0,0,100,0), +(@PATH,45,3289.951,2657.276,37.58014,0,0,0,0,100,0), +(@PATH,46,3290.701,2658.776,39.08014,0,0,0,0,100,0), +(@PATH,47,3290.416,2659.119,38.98893,0,0,0,0,100,0), +(@PATH,48,3290.666,2661.369,37.48893,0,0,0,0,100,0), +(@PATH,49,3291.475,2664.526,36.95589,0,0,0,0,100,0), +(@PATH,50,3293.363,2667.036,36.91856,0,0,0,0,100,0), +(@PATH,51,3295.251,2669.545,36.91856,0,0,0,0,100,0), +(@PATH,52,3297.131,2672.044,36.91856,0,0,0,0,100,0), +(@PATH,53,3299.018,2674.551,36.91856,0,0,0,0,100,0), +(@PATH,54,3300.889,2677.038,36.98542,0,0,0,0,100,0), +(@PATH,55,3302.237,2679.074,36.98542,0,0,0,0,100,0), +(@PATH,56,3304.474,2681.119,37.08491,0,0,0,0,100,0), +(@PATH,57,3306.711,2683.164,37.35322,0,0,0,0,100,0), +(@PATH,58,3308.952,2685.212,37.47089,0,0,0,0,100,0), +(@PATH,59,3311.189,2687.257,37.76264,0,0,0,0,100,0), +(@PATH,60,3313.433,2689.311,38.0052,0,0,0,0,100,0), +(@PATH,61,3315.657,2691.347,38.17683,0,0,0,0,100,0), +(@PATH,62,3316.266,2693.495,37.96796,0,0,0,0,100,0), +(@PATH,63,3319.241,2694.128,38.12397,0,0,0,0,100,0), +(@PATH,64,3322.216,2694.76,38.3017,0,0,0,0,100,0), +(@PATH,65,3325.18,2695.39,38.35114,0,0,0,0,100,0), +(@PATH,66,3328.141,2696.019,38.48542,0,0,0,0,100,0), +(@PATH,67,3331.135,2696.655,38.61042,0,0,0,0,100,0), +(@PATH,68,3332.212,2696.884,38.61042,0,0,0,0,100,0), +(@PATH,69,3333.025,2697.056,38.80158,0,0,0,0,100,0), +(@PATH,70,3329.989,2696.411,38.61042,0,0,0,0,100,0), +(@PATH,71,3327.034,2695.782,38.36054,0,0,0,0,100,0), +(@PATH,72,3324.059,2695.149,38.25495,0,0,0,0,100,0), +(@PATH,73,3321.09,2694.519,38.17377,0,0,0,0,100,0), +(@PATH,74,3319.666,2695.016,38.06855,0,0,0,0,100,0), +(@PATH,75,3317.396,2692.941,38.14497,0,0,0,0,100,0), +(@PATH,76,3315.104,2690.846,38.1103,0,0,0,0,100,0), +(@PATH,77,3312.783,2688.725,37.99751,0,0,0,0,100,0), +(@PATH,78,3310.485,2686.624,37.66938,0,0,0,0,100,0); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=101647; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(101647, 101647, 0, 0, 2, 0, 0), +(101647, 111799, 3, 90, 2, 0, 0); + +-- 9. Dragonblight Mage Hunter +SET @NPC := 101641; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3428.104,`position_y`=2735.986,`position_z`=48.71296 WHERE `guid`=@NPC; +UPDATE `creature` SET `spawndist`=0,`MovementType`=0,`position_x`=3428.104,`position_y`=2735.986,`position_z`=48.71296 WHERE `guid`=111771; +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,3428.104,2735.986,48.71296,0,0,0,0,100,0), +(@PATH,2,3425.443,2734.516,48.53644,0,0,0,0,100,0), +(@PATH,3,3422.782,2733.046,48.31248,0,0,0,0,100,0), +(@PATH,4,3420.109,2731.57,48.01024,0,0,0,0,100,0), +(@PATH,5,3416.655,2729.232,47.60484,0,0,0,0,100,0), +(@PATH,6,3413.609,2729.071,47.40611,0,0,0,0,100,0), +(@PATH,7,3410.579,2728.911,47.14818,0,0,0,0,100,0), +(@PATH,8,3407.57,2728.752,46.89305,0,0,0,0,100,0), +(@PATH,9,3404.551,2728.593,46.5117,0,0,0,0,100,0), +(@PATH,10,3401.51,2728.432,46.12743,0,0,0,0,100,0), +(@PATH,11,3398.489,2728.273,45.76253,0,0,0,0,100,0), +(@PATH,12,3395.658,2728.124,45.1761,0,0,0,0,100,0), +(@PATH,13,3393.825,2728.066,45.12178,0,0,0,0,100,0), +(@PATH,14,3389.51,2727.801,44.52693,0,0,0,0,100,0), +(@PATH,15,3386.867,2727.344,44.22895,0,0,0,0,100,0), +(@PATH,16,3382.715,2727.908,43.73738,0,0,0,0,100,0), +(@PATH,17,3379.876,2728.978,43.65327,0,0,0,0,100,0), +(@PATH,18,3377.013,2730.056,43.56892,0,0,0,0,100,0), +(@PATH,19,3374.167,2731.129,43.64705,0,0,0,0,100,0), +(@PATH,20,3371.302,2732.209,43.78133,0,0,0,0,100,0), +(@PATH,21,3368.437,2733.288,43.81526,0,0,0,0,100,0), +(@PATH,22,3365.587,2734.363,44.07652,0,0,0,0,100,0), +(@PATH,23,3362.738,2735.437,44.11741,0,0,0,0,100,0), +(@PATH,24,3359.883,2736.514,44.28306,0,0,0,0,100,0), +(@PATH,25,3357.022,2737.593,44.57383,0,0,0,0,100,0), +(@PATH,26,3353.997,2738.707,44.68626,0,0,0,0,100,0), +(@PATH,27,3351.277,2740.072,44.88865,0,0,0,0,100,0), +(@PATH,28,3348.575,2741.427,45.23033,0,0,0,0,100,0), +(@PATH,29,3345.891,2742.774,45.41209,0,0,0,0,100,0), +(@PATH,30,3343.344,2744.049,45.89647,0,0,0,0,100,0), +(@PATH,31,3341.882,2745.033,46.25793,0,0,0,0,100,0), +(@PATH,32,3337.835,2746.815,46.7794,0,0,0,0,100,0), +(@PATH,33,3336.501,2747.732,47.26428,0,0,0,0,100,0), +(@PATH,34,3333.486,2748.996,47.77147,0,0,0,0,100,0), +(@PATH,35,3333.358,2749.061,47.74632,0,0,0,0,100,0), +(@PATH,36,3332.592,2749.449,47.84582,0,0,0,0,100,0), +(@PATH,37,3334.399,2748.542,47.55919,0,0,0,0,100,0), +(@PATH,38,3337.077,2747.199,46.96263,0,0,0,0,100,0), +(@PATH,39,3339.018,2746.477,46.75876,0,0,0,0,100,0), +(@PATH,40,3342.365,2744.546,45.89647,0,0,0,0,100,0), +(@PATH,41,3344.059,2743.823,45.77831,0,0,0,0,100,0), +(@PATH,42,3347.866,2741.788,45.23179,0,0,0,0,100,0), +(@PATH,43,3350.572,2740.428,44.9741,0,0,0,0,100,0), +(@PATH,44,3353.47,2738.932,44.73997,0,0,0,0,100,0), +(@PATH,45,3356.303,2737.865,44.55296,0,0,0,0,100,0), +(@PATH,46,3359.149,2736.792,44.26182,0,0,0,0,100,0), +(@PATH,47,3361.988,2735.723,44.21995,0,0,0,0,100,0), +(@PATH,48,3364.817,2734.656,44.05455,0,0,0,0,100,0), +(@PATH,49,3367.636,2733.593,43.83228,0,0,0,0,100,0), +(@PATH,50,3370.488,2732.518,43.75142,0,0,0,0,100,0), +(@PATH,51,3373.357,2731.437,43.72078,0,0,0,0,100,0), +(@PATH,52,3376.19,2730.368,43.66975,0,0,0,0,100,0), +(@PATH,53,3379.01,2729.305,43.62801,0,0,0,0,100,0), +(@PATH,54,3382.68,2727.433,43.61934,0,0,0,0,100,0), +(@PATH,55,3385.647,2727.59,44.01289,0,0,0,0,100,0), +(@PATH,56,3388.653,2727.749,44.41158,0,0,0,0,100,0), +(@PATH,57,3391.682,2727.909,44.77693,0,0,0,0,100,0), +(@PATH,58,3394.659,2728.066,45.20857,0,0,0,0,100,0), +(@PATH,59,3396.602,2728.118,45.59418,0,0,0,0,100,0), +(@PATH,60,3400.709,2728.385,46.02562,0,0,0,0,100,0), +(@PATH,61,3403.696,2728.543,46.40306,0,0,0,0,100,0), +(@PATH,62,3406.69,2728.701,46.78123,0,0,0,0,100,0), +(@PATH,63,3409.732,2728.861,47.04063,0,0,0,0,100,0), +(@PATH,64,3412.678,2729.02,47.28807,0,0,0,0,100,0), +(@PATH,65,3416.686,2729.679,47.59825,0,0,0,0,100,0), +(@PATH,66,3419.314,2731.13,47.95763,0,0,0,0,100,0), +(@PATH,67,3421.962,2732.593,48.25804,0,0,0,0,100,0), +(@PATH,68,3424.603,2734.052,48.3559,0,0,0,0,100,0), +(@PATH,69,3427.245,2735.512,48.65607,0,0,0,0,100,0), +(@PATH,70,3429.927,2736.994,48.8321,0,0,0,0,100,0), +(@PATH,71,3432.565,2738.451,48.88373,0,0,0,0,100,0), +(@PATH,72,3435.226,2739.921,49.06432,0,0,0,0,100,0), +(@PATH,73,3437.894,2741.395,49.15575,0,0,0,0,100,0), +(@PATH,74,3440.145,2742.745,49.19273,0,0,0,0,100,0), +(@PATH,75,3442.959,2743.869,49.23497,0,0,0,0,100,0), +(@PATH,76,3445.774,2744.994,49.33763,0,0,0,0,100,0), +(@PATH,77,3448.623,2746.132,49.50084,0,0,0,0,100,0), +(@PATH,78,3451.444,2747.26,49.73448,0,0,0,0,100,0), +(@PATH,79,3454.29,2748.397,49.99596,0,0,0,0,100,0), +(@PATH,80,3457.107,2749.522,50.16612,0,0,0,0,100,0), +(@PATH,81,3459.942,2750.655,50.38133,0,0,0,0,100,0), +(@PATH,82,3462.752,2751.779,50.59361,0,0,0,0,100,0), +(@PATH,83,3462.882,2751.83,50.60912,0,0,0,0,100,0), +(@PATH,84,3463.669,2752.137,50.70372,0,0,0,0,100,0), +(@PATH,85,3462.899,2751.834,50.65291,-2.511428,0,0,0,100,0), +(@PATH,86,3459.888,2750.627,50.37498,0,0,0,0,100,0), +(@PATH,87,3457.07,2749.5,50.16173,0,0,0,0,100,0), +(@PATH,88,3454.263,2748.379,49.99376,0,0,0,0,100,0), +(@PATH,89,3451.435,2747.249,49.73326,0,0,0,0,100,0), +(@PATH,90,3448.594,2746.111,49.50084,0,0,0,0,100,0), +(@PATH,91,3445.782,2744.991,49.33727,0,0,0,0,100,0), +(@PATH,92,3443.023,2743.892,49.23009,0,0,0,0,100,0), +(@PATH,93,3440.526,2742.849,49.25084,0,0,0,0,100,0), +(@PATH,94,3437.858,2741.375,49.15331,0,0,0,0,100,0), +(@PATH,95,3435.19,2739.901,49.06615,0,0,0,0,100,0), +(@PATH,96,3432.551,2738.443,48.88263,0,0,0,0,100,0), +(@PATH,97,3429.882,2736.969,48.8321,0,0,0,0,100,0); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=101641; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(101641, 101641, 0, 0, 2, 0, 0), +(101641, 111771, 3, 90, 2, 0, 0); + +-- 10. Dragonblight Mage Hunter +SET @NPC := 111795; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3397.47,`position_y`=2651.581,`position_z`=39.35016 WHERE `guid`=@NPC; +UPDATE `creature` SET `spawndist`=0,`MovementType`=0,`position_x`=3397.47,`position_y`=2651.581,`position_z`=39.35016 WHERE `guid`=101644; +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,3397.47,2651.581,39.35016,0,0,0,0,100,0), +(@PATH,2,3397.22,2644.831,40.10016,0,0,0,0,100,0), +(@PATH,3,3396.798,2620.336,39.82126,0,0,0,0,100,0), +(@PATH,4,3399.798,2599.836,40.32126,0,0,0,0,100,0), +(@PATH,5,3400.298,2596.086,40.82126,0,0,0,0,100,0), +(@PATH,6,3400.475,2595.626,41.18766,0,0,0,0,100,0), +(@PATH,7,3400.725,2594.126,41.18766,0,0,0,0,100,0), +(@PATH,8,3407.975,2586.126,41.93766,0,0,0,0,100,0), +(@PATH,9,3410.975,2582.376,42.18766,0,0,0,0,100,0), +(@PATH,10,3413.475,2579.376,42.93766,0,0,0,0,100,0), +(@PATH,11,3416.225,2576.376,43.43766,0,0,0,0,100,0), +(@PATH,12,3416.429,2576.059,43.769,0,0,0,0,100,0), +(@PATH,13,3416.679,2575.559,44.019,0,0,0,0,100,0), +(@PATH,14,3422.679,2571.809,44.269,0,0,0,0,100,0), +(@PATH,15,3428.179,2568.059,44.769,0,0,0,0,100,0), +(@PATH,16,3438.179,2561.559,45.519,0,0,0,0,100,0), +(@PATH,17,3440.305,2559.861,45.74776,0,0,0,0,100,0), +(@PATH,18,3440.555,2542.111,46.24776,0,0,0,0,100,0), +(@PATH,19,3440.805,2533.111,46.74776,0,0,0,0,100,0), +(@PATH,20,3441.055,2526.111,47.24776,0,0,0,0,100,0), +(@PATH,21,3441.322,2525.875,47.48122,0,0,0,0,100,0), +(@PATH,22,3441.322,2524.375,47.73122,0,0,0,0,100,0), +(@PATH,23,3446.072,2522.875,48.48122,0,0,0,0,100,0), +(@PATH,24,3450.072,2521.875,49.23122,0,0,0,0,100,0), +(@PATH,25,3452.572,2521.125,49.73122,0,0,0,0,100,0), +(@PATH,26,3455.572,2520.125,50.48122,0,0,0,0,100,0), +(@PATH,27,3458.322,2519.375,51.23122,0,0,0,0,100,0), +(@PATH,28,3461.322,2518.375,51.73122,0,0,0,0,100,0), +(@PATH,29,3461.1,2518.589,51.82127,0,0,0,0,100,0), +(@PATH,30,3459.35,2519.089,51.07127,0,0,0,0,100,0), +(@PATH,31,3455.35,2520.339,50.32127,0,0,0,0,100,0), +(@PATH,32,3452.6,2520.839,49.82127,0,0,0,0,100,0), +(@PATH,33,3450.1,2521.589,49.07127,0,0,0,0,100,0), +(@PATH,34,3447.1,2522.589,48.57127,0,0,0,0,100,0), +(@PATH,35,3442.35,2524.089,47.82127,0,0,0,0,100,0), +(@PATH,36,3442.223,2524.163,47.5437,0,0,0,0,100,0), +(@PATH,37,3441.473,2524.663,47.5437,0,0,0,0,100,0), +(@PATH,38,3441.223,2530.663,46.7937,0,0,0,0,100,0), +(@PATH,39,3440.973,2538.663,46.5437,0,0,0,0,100,0), +(@PATH,40,3440.723,2551.413,45.7937,0,0,0,0,100,0), +(@PATH,41,3440.154,2560.19,45.4841,0,0,0,0,100,0), +(@PATH,42,3431.154,2566.19,44.9841,0,0,0,0,100,0), +(@PATH,43,3425.404,2569.94,44.4841,0,0,0,0,100,0), +(@PATH,44,3418.654,2574.44,43.9841,0,0,0,0,100,0), +(@PATH,45,3418.408,2574.603,43.66738,0,0,0,0,100,0), +(@PATH,46,3416.408,2575.853,43.66738,0,0,0,0,100,0), +(@PATH,47,3413.908,2578.853,42.91738,0,0,0,0,100,0), +(@PATH,48,3411.408,2581.853,42.16738,0,0,0,0,100,0), +(@PATH,49,3408.408,2585.603,41.91738,0,0,0,0,100,0), +(@PATH,50,3401.158,2593.853,41.16738,0,0,0,0,100,0), +(@PATH,51,3400.958,2594.205,40.95194,0,0,0,0,100,0), +(@PATH,52,3400.458,2594.455,40.95194,0,0,0,0,100,0), +(@PATH,53,3399.958,2598.455,40.45194,0,0,0,0,100,0), +(@PATH,54,3399.458,2602.455,40.20194,0,0,0,0,100,0), +(@PATH,55,3396.748,2620.664,39.6376,0,0,0,0,100,0), +(@PATH,56,3397.248,2634.664,40.3876,0,0,0,0,100,0), +(@PATH,57,3397.248,2646.414,39.6376,0,0,0,0,100,0), +(@PATH,58,3397.732,2652.038,39.51247,0,0,0,0,100,0), +(@PATH,59,3400.301,2676.48,39.35812,0,0,0,0,100,0), +(@PATH,60,3402.051,2685.98,39.85812,0,0,0,0,100,0), +(@PATH,61,3403.301,2691.98,40.60812,0,0,0,0,100,0), +(@PATH,62,3402.772,2690.127,40.33588,0,0,0,0,100,0), +(@PATH,63,3401.772,2684.377,39.83588,0,0,0,0,100,0); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=111795; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(111795, 111795, 0, 0, 2, 0, 0), +(111795, 101644, 4, 0, 2, 0, 0); |