diff options
| -rw-r--r-- | sql/updates/world/2015_03_27_00_world.sql | 657 |
1 files changed, 657 insertions, 0 deletions
diff --git a/sql/updates/world/2015_03_27_00_world.sql b/sql/updates/world/2015_03_27_00_world.sql new file mode 100644 index 00000000000..5641b0b4115 --- /dev/null +++ b/sql/updates/world/2015_03_27_00_world.sql @@ -0,0 +1,657 @@ +-- Dragonsoul +SET @CGUID := 370492; +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+275; +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES +(@CGUID+0, 32638, 1, 1, 1, -8280.75, -4521.05, -219.09, 3.630285, 120, 0, 0), -- 32638 (Area: -1) (Auras: 61424 - 61424) +(@CGUID+1, 32639, 1, 1, 1, -8280.75, -4521.05, -219.09, 3.630285, 120, 0, 0), -- 32639 (Area: -1) (Auras: 61424 - 61424) +(@CGUID+2, 53488, 967, 3, 1, -2310.071, -2419.728, 83.88827, 0, 7200, 0, 0), -- 53488 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257, 99201 - 99201) +(@CGUID+3, 53488, 967, 3, 1, -2283.925, -2408.394, 82.84689, 0, 7200, 0, 0), -- 53488 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257, 99201 - 99201) +(@CGUID+4, 53488, 967, 3, 1, -2276.066, -2375.111, 84.80681, 0, 7200, 0, 0), -- 53488 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257, 99201 - 99201) +(@CGUID+5, 53488, 967, 3, 1, -2304.014, -2387.505, 84.37089, 0, 7200, 0, 0), -- 53488 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257, 99201 - 99201) +(@CGUID+6, 53488, 967, 3, 1, -2296.568, -2357.399, 83.09443, 0, 7200, 0, 0), -- 53488 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257, 99201 - 99201) +(@CGUID+7, 57158, 967, 3, 1, -2047.477, -2355.12, 72.04578, 2.443461, 7200, 0, 0), -- 57158 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257, 51835 - 51835) +(@CGUID+8, 57160, 967, 3, 1, -2072.759, -2330.238, 76.61806, 5.637414, 7200, 0, 0), -- 57160 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257, 51835 - 51835) +(@CGUID+9, 57158, 967, 3, 1, -2128.774, -2578.655, 79.92263, 3.089233, 7200, 0, 0), -- 57158 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257, 51835 - 51835) +(@CGUID+10, 57231, 967, 3, 1, -2147.179, -2579.137, 77.44179, 1.204277, 7200, 0, 0), -- 57231 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+11, 57158, 967, 3, 1, -2227.972, -2557.91, 71.84028, 1.884956, 7200, 0, 0), -- 57158 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257, 51835 - 51835) +(@CGUID+12, 57280, 967, 3, 1, -2224.389, -2537.384, 71.16493, 3.595378, 7200, 0, 0), -- 57280 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+13, 57160, 967, 3, 1, -2164.717, -2580.005, 75.87914, 6.230825, 7200, 0, 0), -- 57160 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257, 51835 - 51835) +(@CGUID+14, 57158, 967, 3, 1, -2158.244, -2519.952, 76.08241, 2.034859, 7200, 0, 0), -- 57158 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+15, 57160, 967, 3, 1, -2242.788, -2525.587, 70.7333, 5.026548, 7200, 0, 0), -- 57160 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257, 51835 - 51835) +(@CGUID+16, 55967, 967, 3, 1, -2080.568, -2406.094, 190.7284, 0, 7200, 0, 0), -- 55967 (Area: 5926) (Auras: 107577 - 107577) +(@CGUID+17, 57160, 967, 3, 1, -2161.173, -2492.578, 76.19443, 1.653297, 7200, 0, 0), -- 57160 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+18, 57159, 967, 3, 1, -2105.069, -2417.102, 74.34335, 2.846395, 7200, 0, 0), -- 57159 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257, 107849 - 107849) +(@CGUID+19, 57280, 967, 3, 1, -2146.526, -2591.847, 76.68642, 1.64061, 7200, 0, 0), -- 57280 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+20, 57158, 967, 3, 1, -2205.884, -2491.703, 76.63906, 1.884956, 7200, 0, 0), -- 57158 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257, 51835 - 51835) +(@CGUID+21, 57280, 967, 3, 1, -2196.104, -2353.026, 81.35667, 0.8726646, 7200, 0, 0), -- 57280 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+22, 57158, 967, 3, 1, -2092.05, -2290.632, 81.5434, 0, 7200, 0, 0), -- 57158 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+23, 57280, 967, 3, 1, -2101.29, -2491.813, 75.91229, 5.270895, 7200, 0, 0), -- 57280 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+24, 57160, 967, 3, 1, -2220.7, -2459.38, 80.96702, 5.026548, 7200, 0, 0), -- 57160 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257, 51835 - 51835) +(@CGUID+25, 57158, 967, 3, 1, -2228.335, -2414.668, 85.42023, 3.159046, 7200, 0, 0), -- 57158 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+26, 57159, 967, 3, 1, -2118.191, -2354.066, 81.87196, 2.373648, 7200, 0, 0), -- 57159 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257, 107849 - 107849) +(@CGUID+27, 57280, 967, 3, 1, -2049.95, -2329.344, 72.61543, 3.944444, 7200, 0, 0), -- 57280 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+28, 57158, 967, 3, 1, -2053.474, -2387.783, 73.33734, 3.159046, 7200, 0, 0), -- 57158 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+29, 57231, 967, 3, 1, -2184.122, -2346.644, 80.65489, 0, 7200, 0, 0), -- 57231 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+30, 57158, 967, 3, 1, -2077.382, -2495.57, 75.14075, 3.769911, 7200, 0, 0), -- 57158 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257, 51835 - 51835) +(@CGUID+31, 57280, 967, 3, 1, -2223.601, -2479.854, 80.99306, 0.4363323, 7200, 0, 0), -- 57280 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+32, 57231, 967, 3, 1, -2213.205, -2475.738, 79.28278, 0, 7200, 0, 0), -- 57231 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+33, 57160, 967, 3, 1, -2055.273, -2406.622, 73.32864, 3.159046, 7200, 0, 0), -- 57160 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+34, 57158, 967, 3, 1, -2141.201, -2510.365, 77.59682, 2.092123, 7200, 0, 0), -- 57158 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+35, 57160, 967, 3, 1, -2107.681, -2514.012, 78.84937, 0.6806784, 7200, 0, 0), -- 57160 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257, 51835 - 51835) +(@CGUID+36, 57160, 967, 3, 1, -2092.184, -2306.976, 80.89896, 0, 7200, 0, 0), -- 57160 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+37, 57159, 967, 3, 1, -2121.974, -2342.314, 81.87196, 1.58825, 7200, 0, 0), -- 57159 (Area: 5926) (Auras: 107849 - 107849) +(@CGUID+38, 57160, 967, 3, 1, -2227.646, -2387.451, 85.46072, 3.141593, 7200, 0, 0), -- 57160 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+39, 57280, 967, 3, 1, -2176.241, -2337.587, 81.13699, 4.18879, 7200, 0, 0), -- 57280 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+40, 57159, 967, 3, 1, -2098.954, -2397.076, 73.4743, 2.88099, 7200, 0, 0), -- 57159 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257, 107849 - 107849) +(@CGUID+41, 57158, 967, 3, 1, -2174.726, -2359.95, 81.27364, 2.181662, 7200, 0, 0), -- 57158 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257, 51835 - 51835) +(@CGUID+42, 57280, 967, 3, 1, -2245.689, -2546.061, 70.68924, 0.4363323, 7200, 0, 0), -- 57280 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+43, 57280, 967, 3, 1, -2082.644, -2517.938, 77.65973, 2.443461, 7200, 0, 0), -- 57280 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+44, 57160, 967, 3, 1, -2193.101, -2334.842, 80.91397, 5.375614, 7200, 0, 0), -- 57160 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257, 51835 - 51835) +(@CGUID+45, 57159, 967, 3, 1, -2111.575, -2341.887, 81.88551, 3.420845, 7200, 0, 0), -- 57159 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257, 107849 - 107849) +(@CGUID+46, 57280, 967, 3, 1, -2071.469, -2352.097, 76.32558, 1.117011, 7200, 0, 0), -- 57280 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+47, 57231, 967, 3, 1, -2235.293, -2541.945, 71.06759, 0, 7200, 0, 0), -- 57231 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+48, 57158, 967, 3, 1, -2054.401, -2427.797, 73.37003, 3.106686, 7200, 0, 0), -- 57158 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+49, 57231, 967, 3, 1, -2062.342, -2343.122, 75.09549, 4.956735, 7200, 0, 0), -- 57231 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+50, 57280, 967, 3, 1, -2202.3, -2471.177, 78.47216, 3.595378, 7200, 0, 0), -- 57280 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+51, 57231, 967, 3, 1, -2092.646, -2507.054, 77.7093, 0, 7200, 0, 0), -- 57231 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+52, 57159, 967, 3, 1, -2130.095, -2347.995, 81.87196, 2.600541, 7200, 0, 0), -- 57159 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257, 107849 - 107849) +(@CGUID+53, 57158, 967, 3, 1, -2122.56, -2402.894, 77.60768, 3.149496, 7200, 0, 0), -- 57158 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+54, 57280, 967, 3, 1, -2147.915, -2565.728, 77.4483, 4.799655, 7200, 0, 0), -- 57280 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+55, 56144, 967, 3, 1, -2066.267, -2153.258, 214.8424, 1.594105, 7200, 0, 0), -- 56144 (Area: 5926) (Auras: 107577 - 107577) +(@CGUID+56, 57280, 967, 3, 1, -1963.688, -2497.095, 63.00636, 2.059489, 7200, 0, 0), -- 57280 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+57, 57632, 967, 3, 1, -2299.445, -2425.509, 83.87738, 0.541052, 7200, 0, 0), -- 57632 (Area: 5926) +(@CGUID+58, 57280, 967, 3, 1, -1949.986, -2536.637, 65.45307, 5.585053, 7200, 0, 0), -- 57280 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+59, 57280, 967, 3, 1, -1976.67, -2321.345, 64.24426, 0.8203048, 7200, 0, 0), -- 57280 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+60, 57231, 967, 3, 1, -1968.877, -2487.974, 63.67107, 0.3316126, 7200, 0, 0), -- 57231 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257, 108012 - 108012) +(@CGUID+61, 56144, 967, 3, 1, -2044.08, -2622.558, 199.0528, 0.5785699, 7200, 0, 0), -- 56144 (Area: 5926) (Auras: 107577 - 107577) +(@CGUID+62, 58287, 967, 3, 1, -2101.181, -2287.32, 306.91, 3.193953, 7200, 0, 0), -- 58287 (Area: 5926) +(@CGUID+63, 57280, 967, 3, 1, -1971.682, -2300.25, 64.70331, 4.485496, 7200, 0, 0), -- 57280 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+64, 58287, 967, 3, 1, -2071.896, -2219.932, 306.4081, 2.443461, 7200, 0, 0), -- 58287 (Area: 5926) +(@CGUID+65, 57158, 967, 3, 1, -2005.574, -2281.198, 71.12967, 4.645951, 7200, 0, 0), -- 57158 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+66, 57158, 967, 3, 1, -2044.569, -2565.532, 76.85681, 0.5560029, 7200, 0, 0), -- 57158 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+67, 57160, 967, 3, 1, -2068.183, -2576.977, 81.01588, 3.206083, 7200, 0, 0), -- 57160 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+68, 56143, 967, 3, 1, -2073.82, -2535.823, 233.1788, 0.2669819, 7200, 0, 0), -- 56143 (Area: 5926) (Auras: 107577 - 107577) +(@CGUID+69, 57231, 967, 3, 1, -1971.2, -2310.622, 64.17452, 6.038839, 7200, 0, 0), -- 57231 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257, 108012 - 108012) +(@CGUID+70, 58287, 967, 3, 1, -2063.184, -2202.507, 321.0296, 1.884956, 7200, 0, 0), -- 58287 (Area: 5926) +(@CGUID+71, 55265, 967, 3, 1, -1981.033, -2409.299, 69.13634, 0, 7200, 0, 0), -- 55265 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+72, 57280, 967, 3, 1, -1974.807, -2478.873, 64.56046, 5.113815, 7200, 0, 0), -- 57280 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+73, 57280, 967, 3, 1, -1976.156, -2492.524, 64.12268, 0.4537856, 7200, 0, 0), -- 57280 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+74, 55476, 967, 3, 1, -2300.122, -2420.988, 83.90479, 6.091199, 7200, 0, 0), -- 55476 (Area: 5926) +(@CGUID+75, 57632, 967, 3, 1, -2297.564, -2417.405, 83.84399, 5.096361, 7200, 0, 0), -- 57632 (Area: 5926) +(@CGUID+76, 57280, 967, 3, 1, -1982.642, -2310.066, 65.75681, 6.038839, 7200, 0, 0), -- 57280 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+77, 58287, 967, 3, 1, -2048.936, -2309.91, 306.3741, 5.358161, 7200, 0, 0), -- 58287 (Area: 5926) +(@CGUID+78, 57160, 967, 3, 1, -2023.152, -2551.622, 72.21792, 2.503237, 7200, 0, 0), -- 57160 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+79, 57158, 967, 3, 1, -2043.293, -2585.29, 75.11627, 5.602904, 7200, 0, 0), -- 57158 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+80, 57280, 967, 3, 1, -1932.75, -2549.851, 62.53437, 2.408554, 7200, 0, 0), -- 57280 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+81, 56144, 967, 3, 1, -1931.366, -2583.687, 188.4668, 0.7387139, 7200, 0, 0), -- 56144 (Area: 5926) (Auras: 107577 - 107577) +(@CGUID+82, 55911, 967, 3, 1, -1798.742, -2318.787, 123.7963, 1.832908, 7200, 0, 0), -- 55911 (Area: 5926) (Auras: 107576 - 107576) +(@CGUID+83, 55913, 967, 3, 1, -1812.919, -2312.316, 188.8723, 1.556237, 7200, 0, 0), -- 55913 (Area: 5926) (Auras: 107576 - 107576) +(@CGUID+84, 56143, 967, 3, 1, -1950.03, -2700.007, 238.783, 0.9599311, 7200, 0, 0), -- 56143 (Area: 5926) (Auras: 107577 - 107577) +(@CGUID+85, 56142, 967, 3, 1, -1838.014, -2340.978, 119.7907, 2.286381, 7200, 0, 0), -- 56142 (Area: 5926) (Auras: 107576 - 107576) +(@CGUID+86, 56139, 967, 3, 1, -1849.939, -2448.458, 190.1557, 3.298672, 7200, 5, 1), -- 56139 (Area: 5926) (Auras: 107576 - 107576) (possible waypoints or random movement) +(@CGUID+87, 55967, 967, 3, 1, -1997.07, -2073.78, 131.8435, 5.188776, 7200, 0, 0), -- 55967 (Area: 5926) (Auras: 107577 - 107577) +(@CGUID+88, 56141, 967, 3, 1, -1861.82, -2348.892, 187.6788, 1.922883, 7200, 0, 0), -- 56141 (Area: 5926) (Auras: 107576 - 107576) +(@CGUID+89, 58287, 967, 3, 1, -2011.045, -2223.599, 322.2277, 0.3839724, 7200, 0, 0), -- 58287 (Area: 5926) +(@CGUID+90, 57380, 967, 3, 1, -2305.38, -2447.533, 82.64851, 6.091199, 7200, 0, 0), -- 57380 (Area: 5926) +(@CGUID+91, 56126, 967, 3, 1, -1868.342, -2428.837, 140.506, 0, 7200, 0, 0), -- 56126 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+92, 57231, 967, 3, 1, -1941.608, -2542.945, 64.03741, 0.8726646, 7200, 0, 0), -- 57231 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257, 108012 - 108012) +(@CGUID+93, 58287, 967, 3, 1, -2011.045, -2223.599, 322.2277, 0.3839724, 7200, 0, 0), -- 58287 (Area: 5926) +(@CGUID+94, 55911, 967, 3, 1, -1921.987, -2412.215, 216.7802, 4.787648, 7200, 0, 0), -- 55911 (Area: 5926) (Auras: 107576 - 107576) +(@CGUID+95, 56126, 967, 3, 1, -1861.806, -2406.896, 142.922, 0, 7200, 0, 0), -- 56126 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+96, 57280, 967, 3, 1, -1945.977, -2549.057, 64.90112, 0.8726646, 7200, 0, 0), -- 57280 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+97, 56141, 967, 3, 1, -1840.68, -2471.844, 120.3227, 3.961897, 7200, 0, 0), -- 56141 (Area: 5926) (Auras: 107576 - 107576) +(@CGUID+98, 58287, 967, 3, 1, -2018.957, -2242.233, 306.1033, 0.03490658, 7200, 0, 0), -- 58287 (Area: 5926) +(@CGUID+99, 56126, 967, 3, 1, -1874.595, -2366.163, 127.1981, 0, 7200, 0, 0), -- 56126 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+100, 55969, 967, 3, 1, -1989.598, -2630.424, 204.5508, 0.8758104, 7200, 0, 0), -- 55969 (Area: 5926) (Auras: 107577 - 107577) +(@CGUID+101, 36737, 967, 3, 1, -1880.997, -2422.495, 52.31925, 3.193953, 7200, 0, 0), -- 36737 (Area: 5926) +(@CGUID+102, 56139, 967, 3, 1, -1859.611, -2435.494, 189.8945, 3.490573, 7200, 0, 0), -- 56139 (Area: 5926) (Auras: 107576 - 107576) +(@CGUID+103, 57398, 967, 3, 1, -2316.036, -2458.448, 81.49792, 0, 7200, 0, 0), -- 57398 (Area: 5926) +(@CGUID+104, 56141, 967, 3, 1, -1863.388, -2352.084, 187.6686, 2.747959, 7200, 0, 0), -- 56141 (Area: 5926) (Auras: 107576 - 107576) +(@CGUID+105, 56142, 967, 3, 1, -1714.182, -2441.938, 187.6727, 4.777118, 7200, 0, 0), -- 56142 (Area: 5926) (Auras: 107576 - 107576) +(@CGUID+106, 56126, 967, 3, 1, -1729.799, -2331.609, 140.5968, 0, 7200, 0, 0), -- 56126 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+107, 56126, 967, 3, 1, -1714.934, -2413.399, 141.4934, 0, 7200, 0, 0), -- 56126 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+108, 55914, 967, 3, 1, -1776.199, -2472.937, 117.441, 5.128334, 7200, 0, 0), -- 55914 (Area: 5926) (Auras: 107576 - 107576) +(@CGUID+109, 55967, 967, 3, 1, -1874.006, -2692.189, 232.1979, 1.325271, 7200, 0, 0), -- 55967 (Area: 5926) (Auras: 107577 - 107577) +(@CGUID+110, 56140, 967, 3, 1, -1706.517, -2333.901, 187.7277, 0.2269687, 7200, 5, 1), -- 56140 (Area: 5926) (Auras: 107576 - 107576) (possible waypoints or random movement) +(@CGUID+111, 56143, 967, 3, 1, -1922.551, -2030.99, 144.8825, 3.649825, 7200, 0, 0), -- 56143 (Area: 5926) (Auras: 107577 - 107577) +(@CGUID+112, 56142, 967, 3, 1, -1695.743, -2417.997, 187.6598, 0.01794707, 7200, 5, 1), -- 56142 (Area: 5926) (Auras: 107576 - 107576) (possible waypoints or random movement) +(@CGUID+113, 56126, 967, 3, 1, -1783.604, -2477.932, 175.1142, 0, 7200, 0, 0), -- 56126 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+114, 55971, 967, 3, 1, -1383.741, -2412.692, 201.4203, 1.487826, 7200, 0, 0), -- 55971 (Area: 5926) (Auras: ) +(@CGUID+115, 56126, 967, 3, 1, -1795.658, -2309.014, 175.0884, 0, 7200, 0, 0), -- 56126 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+116, 55912, 967, 3, 1, -1757.719, -2472.288, 198.2249, 4.223697, 7200, 0, 0), -- 55912 (Area: 5926) (Auras: 107576 - 107576) +(@CGUID+117, 55969, 967, 3, 1, -1792.33, -2087.954, 158.27, 4.674047, 7200, 0, 0), -- 55969 (Area: 5926) (Auras: 107577 - 107577) +(@CGUID+118, 56126, 967, 3, 1, -1815.5, -2408.23, 343.8793, 0.4712389, 7200, 0, 0), -- 56126 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+119, 56139, 967, 3, 1, -1730.798, -2317.636, 121.6698, 0.7155855, 7200, 5, 1), -- 56139 (Area: 5926) (Auras: 107576 - 107576) (possible waypoints or random movement) +(@CGUID+120, 55967, 967, 3, 1, -1763.273, -2632.127, 166.9522, 1.744421, 7200, 0, 0), -- 55967 (Area: 5926) (Auras: 107577 - 107577) +(@CGUID+121, 56140, 967, 3, 1, -1720.001, -2462.555, 121.9963, 5.427974, 7200, 5, 1), -- 56140 (Area: 5926) (Auras: 107576 - 107576) (possible waypoints or random movement) +(@CGUID+122, 56126, 967, 3, 1, -1711.722, -2385.538, 144.1141, 0, 7200, 0, 0), -- 56126 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+123, 55912, 967, 3, 1, -1793.795, -2248.608, 187.6959, 1.862953, 7200, 0, 0), -- 55912 (Area: 5926) (Auras: 107576 - 107576) +(@CGUID+124, 56143, 967, 3, 1, -1926.184, -2031.669, 145.1271, 4.956856, 7200, 0, 0), -- 56143 (Area: 5926) (Auras: 107577 - 107577) +(@CGUID+125, 57348, 967, 3, 1, -2290.51, -2367.97, 83.66555, 6.143559, 7200, 0, 0), -- 57348 (Area: 5926) +(@CGUID+126, 57348, 967, 3, 1, -2301.561, -2414.328, 83.96797, 6.143559, 7200, 0, 0), -- 57348 (Area: 5926) +(@CGUID+127, 57334, 967, 3, 1, -2291.253, -2371.38, 83.8901, 6.143559, 7200, 0, 0), -- 57334 (Area: 5926) +(@CGUID+128, 57348, 967, 3, 1, -2297.946, -2366.771, 83.5505, 6.143559, 7200, 0, 0), -- 57348 (Area: 5926) +(@CGUID+129, 57334, 967, 3, 1, -2302.771, -2418.724, 83.88754, 6.143559, 7200, 0, 0), -- 57334 (Area: 5926) +(@CGUID+130, 57348, 967, 3, 1, -2308.182, -2412.924, 83.85278, 6.143559, 7200, 0, 0), -- 57348 (Area: 5926) +(@CGUID+131, 57348, 967, 3, 1, -2294.802, -2370.807, 83.80565, 6.143559, 7200, 0, 0), -- 57348 (Area: 5926) +(@CGUID+132, 57348, 967, 3, 1, -2306.054, -2417.875, 83.87161, 6.143559, 7200, 0, 0), -- 57348 (Area: 5926) +(@CGUID+133, 57334, 967, 3, 1, -2298.405, -2370.26, 83.75342, 6.143559, 7200, 0, 0), -- 57334 (Area: 5926) +(@CGUID+134, 57334, 967, 3, 1, -2309.089, -2417.193, 83.94627, 6.143559, 7200, 0, 0), -- 57334 (Area: 5926) +(@CGUID+135, 57334, 967, 3, 1, -2294.144, -2367.378, 83.60132, 6.143559, 7200, 0, 0), -- 57334 (Area: 5926) +(@CGUID+136, 57334, 967, 3, 1, -2305.002, -2413.45, 83.95477, 6.143559, 7200, 0, 0), -- 57334 (Area: 5926) +(@CGUID+137, 57348, 967, 3, 1, -2289.052, -2361.061, 83.18519, 6.143559, 7200, 0, 0), -- 57348 (Area: 5926) +(@CGUID+138, 57334, 967, 3, 1, -2289.733, -2364.556, 83.42157, 6.143559, 7200, 0, 0), -- 57334 (Area: 5926) +(@CGUID+139, 57348, 967, 3, 1, -2293.34, -2363.931, 83.35512, 6.143559, 7200, 0, 0), -- 57348 (Area: 5926) +(@CGUID+140, 57348, 967, 3, 1, -2303.67, -2422.486, 83.83498, 6.143559, 7200, 0, 0), -- 57348 (Area: 5926) +(@CGUID+141, 57334, 967, 3, 1, -2311.118, -2439.582, 82.60764, 6.143559, 7200, 0, 0), -- 57334 (Area: 5926) +(@CGUID+142, 57334, 967, 3, 1, -2292.67, -2360.484, 83.10131, 6.143559, 7200, 0, 0), -- 57334 (Area: 5926) +(@CGUID+143, 57334, 967, 3, 1, -2304.556, -2426.267, 83.73474, 6.143559, 7200, 0, 0), -- 57334 (Area: 5926) +(@CGUID+144, 57348, 967, 3, 1, -2310.021, -2421.113, 84.10983, 6.143559, 7200, 0, 0), -- 57348 (Area: 5926) +(@CGUID+145, 57348, 967, 3, 1, -2296.316, -2359.668, 83.03961, 6.143559, 7200, 0, 0), -- 57348 (Area: 5926) +(@CGUID+146, 57348, 967, 3, 1, -2307.859, -2425.273, 83.73846, 6.143559, 7200, 0, 0), -- 57348 (Area: 5926) +(@CGUID+147, 57334, 967, 3, 1, -2310.634, -2424.674, 83.89758, 6.143559, 7200, 0, 0), -- 57334 (Area: 5926) +(@CGUID+148, 57334, 967, 3, 1, -2297.127, -2363.186, 83.29938, 6.143559, 7200, 0, 0), -- 57334 (Area: 5926) +(@CGUID+149, 57334, 967, 3, 1, -2307.03, -2421.792, 83.87274, 6.143559, 7200, 0, 0), -- 57334 (Area: 5926) +(@CGUID+150, 57334, 967, 3, 1, -2310.672, -2452.399, 82.01215, 6.143559, 7200, 0, 0), -- 57334 (Area: 5926) +(@CGUID+151, 57348, 967, 3, 1, -2314.299, -2439.056, 82.53125, 6.143559, 7200, 0, 0), -- 57348 (Area: 5926) +(@CGUID+152, 57334, 967, 3, 1, -2313.146, -2447.924, 81.83855, 6.143559, 7200, 0, 0), -- 57334 (Area: 5926) +(@CGUID+153, 57348, 967, 3, 1, -2309.786, -2448.618, 82.24306, 6.143559, 7200, 0, 0), -- 57348 (Area: 5926) +(@CGUID+154, 57334, 967, 3, 1, -2308.887, -2444.856, 82.40625, 6.143559, 7200, 0, 0), -- 57334 (Area: 5926) +(@CGUID+155, 57348, 967, 3, 1, -2316.137, -2447.245, 81.68349, 6.143559, 7200, 0, 0), -- 57348 (Area: 5926) +(@CGUID+156, 57348, 967, 3, 1, -2313.976, -2451.405, 81.60097, 6.143559, 7200, 0, 0), -- 57348 (Area: 5926) +(@CGUID+157, 57334, 967, 3, 1, -2315.205, -2443.325, 82.0816, 6.143559, 7200, 0, 0), -- 57334 (Area: 5926) +(@CGUID+158, 57348, 967, 3, 1, -2307.677, -2440.46, 82.69098, 6.143559, 7200, 0, 0), -- 57348 (Area: 5926) +(@CGUID+159, 57334, 967, 3, 1, -2316.66, -2450.861, 81.41796, 6.143559, 7200, 0, 0), -- 57334 (Area: 5926) +(@CGUID+160, 57348, 967, 3, 1, -2312.17, -2444.007, 82.17709, 6.143559, 7200, 0, 0), -- 57348 (Area: 5926) +(@CGUID+161, 57380, 967, 3, 1, -2287.24, -2366.741, 83.60007, 6.091199, 7200, 0, 0), -- 57380 (Area: 5926) +(@CGUID+162, 57398, 967, 3, 1, -2290.903, -2351.738, 82.60785, 0, 7200, 0, 0), -- 57398 (Area: 5926) +(@CGUID+163, 57159, 967, 3, 1, -2043.863, -2543.309, 76.28757, 2.278787, 7200, 0, 0), -- 57159 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257, 107849 - 107849) +(@CGUID+164, 57159, 967, 3, 1, -2016.007, -2280.177, 73.1441, 3.728984, 7200, 0, 0), -- 57159 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257, 107849 - 107849) +(@CGUID+165, 57159, 967, 3, 1, -2030.591, -2533.772, 73.86372, 2.014197, 7200, 0, 0), -- 57159 (Area: 5926) (Auras: 109247 - 109247, 109257 - 109257, 107849 - 107849) +(@CGUID+166, 57159, 967, 3, 1, -1991.306, -2275.176, 70.07791, 4.679572, 7200, 0, 0), -- 57159 (Area: 5923) (Auras: 109247 - 109247, 109257 - 109257, 107849 - 107849) +(@CGUID+167, 57280, 967, 3, 1, -1905.043, -2238.856, 59.0304, 4.537856, 7200, 0, 0), -- 57280 (Area: 5923) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+168, 57261, 967, 3, 1, -1884.422, -2388.603, 52.3401, 2.052736, 7200, 0, 0), -- 57261 (Area: 5923) +(@CGUID+169, 57280, 967, 3, 1, -1915.648, -2258.589, 58.14236, 0.9424778, 7200, 0, 0), -- 57280 (Area: 5923) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+170, 57261, 967, 3, 1, -1882.141, -2373.205, 52.31054, 2.196423, 7200, 0, 0), -- 57261 (Area: 5923) +(@CGUID+171, 57261, 967, 3, 1, -1868.976, -2360.278, 52.31054, 2.582198, 7200, 0, 0), -- 57261 (Area: 5923) +(@CGUID+172, 57280, 967, 3, 1, -1917.571, -2244.714, 60.24479, 5.707227, 7200, 0, 0), -- 57280 (Area: 5923) (Auras: 109247 - 109247, 109257 - 109257) +(@CGUID+173, 57231, 967, 3, 1, -1909.446, -2249.814, 58.8439, 5.585053, 7200, 0, 0), -- 57231 (Area: 5923) (Auras: 109247 - 109247, 109257 - 109257, 108012 - 108012) +(@CGUID+174, 57261, 967, 3, 1, -1858.274, -2351.559, 51.98782, 1.470113, 7200, 0, 0), -- 57261 (Area: 5923) +(@CGUID+175, 57261, 967, 3, 1, -1866.564, -2445.378, 52.31054, 3.380869, 7200, 0, 0), -- 57261 (Area: 5923) +(@CGUID+176, 57261, 967, 3, 1, -1862.063, -2358.637, 52.24014, 1.340273, 7200, 0, 0), -- 57261 (Area: 5923) +(@CGUID+177, 57261, 967, 3, 1, -1850.009, -2340.253, 51.86509, 2.536327, 7200, 0, 0), -- 57261 (Area: 5923) +(@CGUID+178, 57261, 967, 3, 1, -1854.03, -2345.915, 51.86068, 1.822193, 7200, 0, 0), -- 57261 (Area: 5923) +(@CGUID+179, 57261, 967, 3, 1, -1823.299, -2309.767, 52.24716, 2.499671, 7200, 0, 0), -- 57261 (Area: 5923) +(@CGUID+180, 57261, 967, 3, 1, -1828.944, -2321.918, 51.96895, 2.285294, 7200, 0, 0), -- 57261 (Area: 5923) +(@CGUID+181, 57261, 967, 3, 1, -1844.328, -2452.847, 51.86209, 3.855496, 7200, 0, 0), -- 57261 (Area: 5923) +(@CGUID+182, 57261, 967, 3, 1, -1833.59, -2325.228, 51.85423, 2.192624, 7200, 0, 0), -- 57261 (Area: 5923) +(@CGUID+183, 57261, 967, 3, 1, -1839.226, -2329.535, 51.86015, 3.519087, 7200, 0, 0), -- 57261 (Area: 5923) +(@CGUID+184, 57261, 967, 3, 1, -1838.005, -2458.363, 51.86341, 2.670354, 7200, 0, 0), -- 57261 (Area: 5923) +(@CGUID+185, 57261, 967, 3, 1, -1844.627, -2334.896, 51.8536, 3.759782, 7200, 0, 0), -- 57261 (Area: 5923) +(@CGUID+186, 57261, 967, 3, 1, -1849.24, -2446.267, 52.05734, 3.116311, 7200, 0, 0), -- 57261 (Area: 5923) +(@CGUID+187, 57261, 967, 3, 1, -1831.054, -2464.222, 51.86736, 2.670354, 7200, 0, 0), -- 57261 (Area: 5926) +(@CGUID+188, 55969, 967, 3, 1, -1610.285, -2281.958, 164.666, 3.510178, 7200, 0, 0), -- 55969 (Area: 5926) (Auras: 107577 - 107577) +(@CGUID+189, 57261, 967, 3, 1, -1815.585, -2472.729, 51.92205, 2.670354, 7200, 0, 0), -- 57261 (Area: 5926) +(@CGUID+190, 57261, 967, 3, 1, -1823.319, -2467.661, 51.85656, 2.670354, 7200, 0, 0), -- 57261 (Area: 5926) +(@CGUID+191, 57261, 967, 3, 1, -1806.71, -2486.097, 52.28352, 2.670354, 7200, 0, 0), -- 57261 (Area: 5926) +(@CGUID+192, 57261, 967, 3, 1, -1807.714, -2474.998, 52.19959, 2.670354, 7200, 0, 0), -- 57261 (Area: 5926) +(@CGUID+193, 56143, 967, 3, 1, -1619.984, -2646.849, 163.2995, 2.044982, 7200, 0, 0), -- 56143 (Area: 5923) (Auras: 107577 - 107577) +(@CGUID+194, 27953, 967, 3, 1, -1891.095, -2392.642, 52.32187, 3.909538, 7200, 0, 0), -- 27953 (Area: 5923) (Auras: 58951 - 58951) +(@CGUID+195, 27953, 967, 3, 1, -1889.663, -2422.047, 52.31055, 3.141593, 7200, 0, 0), -- 27953 (Area: 5923) (Auras: 58951 - 58951) +(@CGUID+196, 27953, 967, 3, 1, -1880.891, -2351.523, 52.31054, 2.391101, 7200, 0, 0), -- 27953 (Area: 5923) (Auras: 58951 - 58951) +(@CGUID+197, 55967, 967, 3, 1, -1622.286, -2626.435, 158.6654, 4.732791, 7200, 0, 0), -- 55967 (Area: 5923) (Auras: 107577 - 107577) +(@CGUID+198, 56143, 967, 3, 1, -1621.097, -2647.279, 163.0933, 1.768175, 7200, 0, 0), -- 56143 (Area: 5923) (Auras: 107577 - 107577) +(@CGUID+199, 27953, 967, 3, 1, -1880.962, -2443.469, 52.31054, 4.153883, 7200, 0, 0), -- 27953 (Area: 5923) (Auras: 58951 - 58951) +(@CGUID+200, 56144, 967, 3, 1, -1625.824, -2264.242, 187.3111, 5.195879, 7200, 0, 0), -- 56144 (Area: 5923) (Auras: 107577 - 107577) +(@CGUID+201, 27953, 967, 3, 1, -1893.394, -2379.517, 52.31055, 2.70526, 7200, 0, 0), -- 27953 (Area: 5923) (Auras: 58951 - 58951) +(@CGUID+202, 27953, 967, 3, 1, -1837.885, -2407.79, 52.32076, 3.089233, 7200, 0, 0), -- 27953 (Area: 5923) (Auras: 58951 - 58951) +(@CGUID+203, 27953, 967, 3, 1, -1846.689, -2390.531, 52.3147, 4.258604, 7200, 0, 0), -- 27953 (Area: 5923) (Auras: 58951 - 58951) +(@CGUID+204, 55969, 967, 3, 1, -1552.491, -2379.942, 180.1804, 3.130443, 7200, 0, 0), -- 55969 (Area: 5923) (Auras: 107577 - 107577) +(@CGUID+205, 55913, 967, 3, 1, -1567.49, -2379.775, 180.1804, 6.272036, 7200, 0, 0), -- 55913 (Area: 5923) (Auras: 107576 - 107576) +(@CGUID+206, 55969, 967, 3, 1, -1649.398, -2082.927, 232.8607, 4.18879, 7200, 0, 0), -- 55969 (Area: 5923) (Auras: 107577 - 107577) +(@CGUID+207, 57882, 967, 3, 1, -1817.639, -2383.533, 343.8793, 5.934119, 7200, 0, 0), -- 57882 (Area: 5923) (Auras: 108227 - 108227, 108203 - 108203) +(@CGUID+208, 27938, 967, 3, 1, -1805.276, -2421.168, 47.3713, 0.9773844, 7200, 0, 0), -- 27938 (Area: 5923) +(@CGUID+209, 53488, 967, 3, 1, -1785.462, -2413.311, 45.73311, 0, 7200, 0, 0), -- 53488 (Area: 5923) (Auras: 109247 - 109247, 109257 - 109257, 99201 - 99201) +(@CGUID+210, 58287, 967, 3, 1, -1555.024, -2580.604, 345.9149, 3.036873, 7200, 0, 0), -- 58287 (Area: 5923) +(@CGUID+211, 27953, 967, 3, 1, -1806.309, -2502.469, 52.31054, 4.328416, 7200, 0, 0), -- 27953 (Area: 5923) (Auras: 58951 - 58951) +(@CGUID+212, 53488, 967, 3, 1, -1788.354, -2371.009, 45.74213, 0, 7200, 0, 0), -- 53488 (Area: 5923) (Auras: 109247 - 109247, 109257 - 109257, 99201 - 99201) +(@CGUID+213, 27943, 967, 3, 1, -1810.125, -2369.478, 47.37123, 5.480334, 7200, 0, 0), -- 27943 (Area: 5923) +(@CGUID+214, 53488, 967, 3, 1, -1807.533, -2393.743, 45.73864, 0, 7200, 0, 0), -- 53488 (Area: 5923) (Auras: 109247 - 109247, 109257 - 109257, 99201 - 99201) +(@CGUID+215, 57682, 967, 3, 1, -1786.389, -2393.533, 45.66348, 3.141593, 7200, 0, 0), -- 57682 (Area: 5923) +(@CGUID+216, 56144, 967, 3, 1, -1528.992, -2203.285, 149.7876, 3.955025, 7200, 0, 0), -- 56144 (Area: 5923) (Auras: 107577 - 107577) +(@CGUID+217, 27953, 967, 3, 1, -1818.835, -2291.908, 52.31055, 2.565634, 7200, 0, 0), -- 27953 (Area: 5923) (Auras: 58951 - 58951) +(@CGUID+218, 27953, 967, 3, 1, -1775.972, -2449.606, 52.44341, 4.660029, 7200, 0, 0), -- 27953 (Area: 5923) (Auras: 58951 - 58951) +(@CGUID+219, 58287, 967, 3, 1, -1548.033, -2564.188, 344.9106, 2.75762, 7200, 0, 0), -- 58287 (Area: 5923) +(@CGUID+220, 56140, 967, 3, 1, -1532.5, -2206.995, 151.2102, 0.8134355, 7200, 0, 0), -- 56140 (Area: 5923) (Auras: 107576 - 107576) +(@CGUID+221, 27940, 967, 3, 1, -1767.451, -2366.417, 47.3714, 4.08407, 7200, 0, 0), -- 27940 (Area: 5923) +(@CGUID+222, 58036, 967, 3, 1, -1767.306, -2383.359, 45.74186, 3.612832, 7200, 0, 0), -- 58036 (Area: 5923) +(@CGUID+223, 53488, 967, 3, 1, -1768.066, -2391.328, 45.73015, 0, 7200, 0, 0), -- 53488 (Area: 5923) (Auras: 109247 - 109247, 109257 - 109257, 99201 - 99201) +(@CGUID+224, 27953, 967, 3, 1, -1783.616, -2338.847, 52.3968, 2.094395, 7200, 0, 0), -- 27953 (Area: 5923) (Auras: 58951 - 58951) +(@CGUID+225, 27935, 967, 3, 1, -1762.002, -2413.701, 47.37174, 2.443461, 7200, 0, 0), -- 27935 (Area: 5923) +(@CGUID+226, 58287, 967, 3, 1, -1537.179, -2546.524, 344.3767, 2.408554, 7200, 0, 0), -- 58287 (Area: 5923) +(@CGUID+227, 58287, 967, 3, 1, -1530.438, -2538.389, 344.8503, 2.391101, 7200, 0, 0), -- 58287 (Area: 5923) +(@CGUID+228, 27953, 967, 3, 1, -1755.615, -2384.059, 47.37125, 0.541052, 7200, 0, 0), -- 27953 (Area: 5923) (Auras: 58951 - 58951) +(@CGUID+229, 27953, 967, 3, 1, -1798.531, -2324.906, 52.31055, 4.817109, 7200, 0, 0), -- 27953 (Area: 5923) (Auras: 58951 - 58951) +(@CGUID+230, 56139, 967, 3, 1, -1852.09, -2433.58, 190.1629, 3.368485, 7200, 0, 0), -- 56139 (Area: 5923) (Auras: 107576 - 107576) +(@CGUID+231, 27953, 967, 3, 1, -1735.524, -2380.203, 52.32118, 5.864306, 7200, 0, 0), -- 27953 (Area: 5926) (Auras: 58951 - 58951) +(@CGUID+232, 56144, 967, 3, 1, -1580.645, -2066.717, 215.8195, 0.3442454, 7200, 5, 1), -- 56144 (Area: 5926) (Auras: 107577 - 107577) (possible waypoints or random movement) +(@CGUID+233, 27953, 967, 3, 1, -1748.877, -2308.608, 52.02015, 0.9773844, 7200, 0, 0), -- 27953 (Area: 5926) (Auras: 58951 - 58951) +(@CGUID+234, 56143, 967, 3, 1, -1470.311, -2239.245, 211.5069, 3.932472, 7200, 5, 1), -- 56143 (Area: 5926) (Auras: 107577 - 107577) (possible waypoints or random movement) +(@CGUID+235, 27953, 967, 3, 1, -1703.51, -2383.481, 52.31845, 3.612832, 7200, 0, 0), -- 27953 (Area: 5923) (Auras: 58951 - 58951) +(@CGUID+236, 56139, 967, 3, 1, -1745.998, -2330.849, 121.6698, 0.715585, 7200, 0, 0), -- 56139 (Area: 5923) (Auras: 107576 - 107576) +(@CGUID+237, 56140, 967, 3, 1, -1733.188, -2447.385, 121.9963, 5.427974, 7200, 0, 0), -- 56140 (Area: 5923) (Auras: 107576 - 107576) +(@CGUID+238, 27953, 967, 3, 1, -1707.036, -2456.002, 52.11411, 4.468043, 7200, 0, 0), -- 27953 (Area: 5923) (Auras: 58951 - 58951) +(@CGUID+239, 58287, 967, 3, 1, -1465.543, -2579.642, 344.6656, 5.864306, 7200, 0, 0), -- 58287 (Area: 5923) +(@CGUID+240, 58287, 967, 3, 1, -1481.778, -2606.28, 344.2422, 5.497787, 7200, 0, 0), -- 58287 (Area: 5923) +(@CGUID+241, 58287, 967, 3, 1, -1493.465, -2619.611, 345.2959, 5.235988, 7200, 0, 0), -- 58287 (Area: 5923) +(@CGUID+242, 58287, 967, 3, 1, -1470.151, -2589.323, 344.2266, 5.864306, 7200, 0, 0), -- 58287 (Area: 5923) +(@CGUID+243, 56143, 967, 3, 1, -1412.944, -2509.139, 220.7589, 5.870531, 7200, 0, 0), -- 56143 (Area: 5923) (Auras: 107577 - 107577) +(@CGUID+244, 27953, 967, 3, 1, -1667.727, -2396.764, 52.31055, 2.234021, 7200, 0, 0), -- 27953 (Area: 5923) (Auras: 58951 - 58951) +(@CGUID+245, 56140, 967, 3, 1, -1726.137, -2338.432, 187.6788, 0.6988485, 7200, 0, 0), -- 56140 (Area: 5923) (Auras: 107576 - 107576) +(@CGUID+246, 56142, 967, 3, 1, -1838.014, -2340.978, 119.7907, 2.286381, 7200, 0, 0), -- 56142 (Area: 5923) (Auras: 107576 - 107576) +(@CGUID+247, 27953, 967, 3, 1, -1661.745, -2363.378, 52.31053, 5.864306, 7200, 0, 0), -- 27953 (Area: 5923) (Auras: 58951 - 58951) +(@CGUID+248, 53488, 967, 3, 1, -1801.804, -2395.571, 341.4378, 0, 7200, 0, 0), -- 53488 (Area: 0) (Auras: 109247 - 109247, 109257 - 109257, 99201 - 99201) +(@CGUID+249, 56630, 967, 3, 1, -1782.686, -2400.441, 341.4378, 2.146755, 7200, 0, 0), -- 56630 (Area: 0) +(@CGUID+250, 45979, 967, 3, 1, -1766.875, -2391.483, 341.4378, 0, 7200, 0, 0), -- 45979 (Area: 0) +(@CGUID+251, 45979, 967, 3, 1, -1767.998, -2369.535, 341.8531, 0, 7200, 5, 1), -- 45979 (Area: 0) (possible waypoints or random movement) +(@CGUID+252, 56668, 967, 3, 1, -1786.717, -2393.231, 343.6025, 0.1745329, 7200, 0, 0), -- 56668 (Area: 0) (Auras: 108544 - 108544) +(@CGUID+253, 45979, 967, 3, 1, -1757.896, -2379.458, 340.8946, 0, 7200, 0, 0), -- 45979 (Area: 0) +(@CGUID+254, 56665, 967, 3, 1, -1779.828, -2392.604, 341.4378, 3.211406, 7200, 0, 0), -- 56665 (Area: 0) +(@CGUID+255, 56664, 967, 3, 1, -1792.264, -2399.795, 341.4378, 0.8552113, 7200, 0, 0), -- 56664 (Area: 0) +(@CGUID+256, 56667, 967, 3, 1, -1793.587, -2388.05, 341.4378, 5.585053, 7200, 0, 0), -- 56667 (Area: 0) +(@CGUID+257, 56666, 967, 3, 1, -1784.79, -2384.856, 341.4378, 4.433136, 7200, 0, 0), -- 56666 (Area: 0) +(@CGUID+258, 45979, 967, 3, 1, -1766.497, -2401.847, 341.6825, 0, 7200, 0, 0), -- 45979 (Area: 0) +(@CGUID+259, 45979, 967, 3, 1, -1756.075, -2400.467, 340.8923, 0, 7200, 0, 0), -- 45979 (Area: 0) +(@CGUID+260, 53488, 967, 3, 1, -1788.946, -2375.142, 341.4378, 0, 7200, 0, 0), -- 53488 (Area: 0) (Auras: 109247 - 109247, 109257 - 109257, 99201 - 99201) +(@CGUID+261, 53488, 967, 3, 1, -1773.3, -2393.479, 341.4378, 0, 7200, 0, 0), -- 53488 (Area: 0) (Auras: 109247 - 109247, 109257 - 109257, 99201 - 99201) +(@CGUID+262, 45979, 967, 3, 1, -1768.536, -2381.059, 341.6825, 0, 7200, 0, 0), -- 45979 (Area: 0) +(@CGUID+263, 53488, 967, 3, 1, -1785.153, -2411.146, 341.4378, 0, 7200, 0, 0), -- 53488 (Area: 0) (Auras: 109247 - 109247, 109257 - 109257, 99201 - 99201) +(@CGUID+264, 45979, 967, 3, 1, -1756.786, -2390.078, 341.0033, 0, 7200, 0, 0), -- 45979 (Area: 0) +(@CGUID+265, 45979, 967, 3, 1, -1753.205, -2410.392, 340.9058, 0, 7200, 0, 0), -- 45979 (Area: 0) +(@CGUID+266, 45979, 967, 3, 1, -1733.524, -2387.752, 340.9352, 0, 7200, 0, 0), -- 45979 (Area: 0) +(@CGUID+267, 45979, 967, 3, 1, -1736.804, -2398.005, 340.9349, 0, 7200, 0, 0), -- 45979 (Area: 0) +(@CGUID+268, 45979, 967, 3, 1, -1739.314, -2377.361, 340.936, 0, 7200, 0, 0), -- 45979 (Area: 0) +(@CGUID+269, 45979, 967, 3, 1, -1747.924, -2372.128, 340.9361, 0, 7200, 0, 0), -- 45979 (Area: 0) +(@CGUID+270, 45979, 967, 3, 1, -1757.722, -2369.385, 340.9121, 0, 7200, 0, 0), -- 45979 (Area: 0) +(@CGUID+271, 45979, 967, 3, 1, -1746.642, -2394.34, 340.9193, 0, 7200, 0, 0), -- 45979 (Area: 0) +(@CGUID+272, 45979, 967, 3, 1, -1743.788, -2405.528, 340.9316, 0, 7200, 0, 0), -- 45979 (Area: 0) +(@CGUID+273, 45979, 967, 3, 1, -1746.658, -2382.299, 340.9195, 0.9610723, 7200, 0, 0), -- 45979 (Area: 0) +(@CGUID+274, 45979, 967, 3, 1, -1761.833, -2414.083, 344.4462, 0, 7200, 0, 0), -- 45979 (Area: 0) +(@CGUID+275, 55969, 967, 3, 1, -1792.188, -2084.236, 158.1033, 4.674117, 7200, 0, 0); -- 55969 (Area: 5923) (Auras: 107577 - 107577) + +SET @OGUID := 224760; +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+4; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +(@OGUID+0, 214611, 967, 3, 1, -2313.861, -2387.189, 83.48397, 6.113007, 0, 0, 0, 1, 7200, 255, 1), -- 214611 (Area: 5926) +(@OGUID+1, 210061, 967, 3, 1, -2059.583, -2263.646, 303.0815, 4.302239, 2.073922E-43, 0, 0, 0, 7200, 255, 1), -- 210061 (Area: 5926) +(@OGUID+2, 190352, 967, 3, 1, -1542.736, -3357.043, 223.0954, 5.916668, 0, 0, -0.1822356, 0.9832549, 7200, 255, 0), -- 190352 (Area: 5926) +(@OGUID+3, 210211, 967, 3, 1, -1500.045, -2562.457, 343.2026, 1.003564, 2.059909E-43, 0, 0, 0, 7200, 255, 1), -- 210211 (Area: 5926) +(@OGUID+4, 210210, 967, 3, 1, -1700.04, -2370.623, 319.2935, 1.631882, 2.059909E-43, 0, 0, 0, 7200, 255, 1); -- 210210 (Area: 5926) + +DELETE FROM `creature_template_addon` WHERE `entry` IN (32638, 32639, 53488, 57158, 57160, 57231, 57280, 55967, 57159, 56144, 57632, 58287, 56143, 55265, 55476, 55911, 55913, 56142, 56139, 56141, 57380, 56126, 55969, 36737, 57398, 55914, 56140, 55971, 55912, 57348, 57334, 57261, 27953, 57882, 27938, 27943, 57682, 27940, 58036, 27935, 56630, 45979, 56668, 56665, 56664, 56667, 56666); +INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES +(32638, 0, 0x0, 0x1, '61424'), -- 32638 - 61424 +(32639, 0, 0x0, 0x1, '61424'), -- 32639 - 61424 +(53488, 0, 0x0, 0x1, '109247 109257 99201'), -- 53488 - 109247, 109257, 99201 +(57158, 0, 0x0, 0x1, '109247 109257 51835'), -- 57158 - 109247, 109257, 51835 +(57160, 0, 0x0, 0x1, '109247 109257 51835'), -- 57160 - 109247, 109257, 51835 +(57231, 0, 0x3000000, 0x1, '109247 109257'), -- 57231 - 109247, 109257 +(57280, 0, 0x0, 0x1, '109247 109257'), -- 57280 - 109247, 109257 +(55967, 0, 0x3000000, 0x1, '107577'), -- 55967 - 107577 +(57159, 0, 0x0, 0x1, '109247 109257 107849'), -- 57159 - 109247, 109257, 107849 +(56144, 0, 0x3000000, 0x1, '107577'), -- 56144 - 107577 +(57632, 0, 0x0, 0x1, ''), -- 57632 +(58287, 0, 0x3000000, 0x1, ''), -- 58287 +(56143, 0, 0x3000000, 0x1, '107577'), -- 56143 - 107577 +(55265, 0, 0x0, 0x1, '109247 109257'), -- 55265 - 109247, 109257 +(55476, 0, 0x0, 0x1, ''), -- 55476 +(55911, 0, 0x3000000, 0x1, '107576'), -- 55911 - 107576 +(55913, 0, 0x3000000, 0x1, '107576'), -- 55913 - 107576 +(56142, 0, 0x3000000, 0x1, '107576'), -- 56142 - 107576 +(56139, 0, 0x3000000, 0x1, '107576'), -- 56139 - 107576 +(56141, 0, 0x3000000, 0x1, '107576'), -- 56141 - 107576 +(57380, 0, 0x0, 0x1, ''), -- 57380 +(56126, 0, 0x3000000, 0x1, '109247 109257'), -- 56126 - 109247, 109257 +(55969, 0, 0x3000000, 0x1, '107577'), -- 55969 - 107577 +(36737, 0, 0x0, 0x1, ''), -- 36737 +(57398, 0, 0x0, 0x1, ''), -- 57398 +(55914, 0, 0x3000000, 0x1, '107576'), -- 55914 - 107576 +(56140, 0, 0x3000000, 0x1, '107576'), -- 56140 - 107576 +(55971, 0, 0x3000000, 0x1, ''), -- 55971 +(55912, 0, 0x3000000, 0x1, '107576'), -- 55912 - 107576 +(57348, 0, 0x0, 0x1, ''), -- 57348 +(57334, 0, 0x0, 0x1, ''), -- 57334 +(57261, 0, 0x0, 0x1, ''), -- 57261 +(27953, 0, 0x0, 0x1, '58951'), -- 27953 - 58951 +(57882, 0, 0x0, 0x1, '108227 108203'), -- 57882 - 108227, 108203 +(27938, 0, 0x7, 0x101, ''), -- 27938 +(27943, 0, 0x7, 0x101, ''), -- 27943 +(57682, 0, 0x7, 0x1, ''), -- 57682 +(27940, 0, 0x7, 0x101, ''), -- 27940 +(58036, 0, 0x7, 0x101, ''), -- 58036 +(27935, 0, 0x7, 0x101, ''), -- 27935 +(56630, 0, 0x0, 0x1, ''), -- 56630 +(45979, 0, 0x0, 0x1, ''), -- 45979 +(56668, 0, 0x3000000, 0x1, '108544'), -- 56668 - 108544 +(56665, 0, 0x0, 0x1, ''), -- 56665 +(56664, 0, 0x0, 0x1, ''), -- 56664 +(56667, 0, 0x0, 0x1, ''), -- 56667 +(56666, 0, 0x0, 0x1, ''); -- 56666 + +-- correction +DELETE FROM `creature` WHERE `id` IN (32639, 32639); +UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry` IN (56140,56139,56141,55912,55911,55967,56144,55969,56143); +UPDATE `creature_template` SET `flags_extra`=128 WHERE `entry`=58287; + +-- paths and emotes + +-- Pathing for Entry: 57158 'TDB FORMAT' +SET @NPC := 370545; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-2109.353,`position_y`=-2403.057,`position_z`=76.37802 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,-2109.353,-2403.057,76.37802,0,0,0,0,100,0), +(@PATH,2,-2159.487,-2402.811,80.65933,0,0,0,0,100,0), +(@PATH,3,-2179.776,-2401.626,82.17088,0,0,0,0,100,0), +(@PATH,4,-2158.792,-2402.669,81.1102,0,0,0,0,100,0), +(@PATH,5,-2104.909,-2403.069,74.95848,0,0,0,0,100,0); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=370545; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(370545, 370545, 0, 0, 2, 0, 0), +(370545, 370510, 11, 90, 2, 0, 0), +(370545, 370532, 11, 270, 0, 0, 0); + +-- Pathing for Entry: 57160 'TDB FORMAT' +SET @NPC := 370509; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-2158.407,`position_y`=-2503.656,`position_z`=76.39027 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,-2158.407,-2503.656,76.39027,0,0,0,0,100,0), +(@PATH,2,-2162.795,-2471.412,76.93024,0,0,0,0,100,0), +(@PATH,3,-2169.045,-2451.662,78.68024,0,0,0,0,100,0), +(@PATH,4,-2163.267,-2469.951,76.98431,0,0,0,0,100,0), +(@PATH,5,-2157.228,-2508.54,76.80927,0,0,0,0,100,0); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=370509; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(370509, 370509, 0, 0, 2, 0, 0), +(370509, 370506, 11, 90, 2, 0, 0), +(370509, 370526, 11, 270, 0, 0, 0); + +-- Pathing for Entry: 57160 'TDB FORMAT' +SET @NPC := 370570; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-2023.289,`position_y`=-2551.195,`position_z`=72.36375 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,-2023.289,-2551.195,72.36375,0,0,0,0,100,0), +(@PATH,2,-2011.289,-2560.195,69.61375,0,0,0,0,100,0), +(@PATH,3,-2032.591,-2544.259,74.78496,0,0,0,0,100,0), +(@PATH,4,-2041.395,-2531.702,75.01076,0,0,0,0,100,0), +(@PATH,5,-2044.395,-2514.202,72.01076,0,0,0,0,100,0), +(@PATH,6,-2041.338,-2531.981,75.06871,0,0,0,0,100,0), +(@PATH,7,-2032.591,-2544.259,74.78496,0,0,0,0,100,0); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=370570; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(370570, 370570, 0, 0, 2, 0, 0), +(370570, 370657, 11, 90, 2, 0, 0), +(370570, 370655, 11, 270, 0, 0, 0); + +-- Pathing for Entry: 57160 'TDB FORMAT' +SET @NPC := 370559; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-2060.022,`position_y`=-2574.286,`position_z`=79.11995 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,-2060.022,-2574.286,79.11995,0,0,0,0,100,0), +(@PATH,2,-2067.522,-2575.786,81.11995,0,0,0,0,100,0), +(@PATH,3,-2077.235,-2579.704,83.24963,0,0,0,0,100,0), +(@PATH,4,-2068.775,-2575.896,81.44957,0,0,0,0,100,0), +(@PATH,5,-2058.275,-2573.896,78.94957,0,0,0,0,100,0); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=370559; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(370559, 370559, 0, 0, 2, 0, 0), +(370559, 370571, 11, 60, 2, 0, 0), +(370559, 370558, 11, 300, 0, 0, 0); + +-- Pathing for Entry: 57158 'TDB FORMAT' +SET @NPC := 370557; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-2006.322,`position_y`=-2290.907,`position_z`=70.92261 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,-2006.322,-2290.907,70.92261,0,0,0,0,100,0), +(@PATH,2,-2011.822,-2292.907,71.17261,0,0,0,0,100,0), +(@PATH,3,-2006.288,-2290.875,70.89031,0,0,0,0,100,0), +(@PATH,4,-2004.912,-2265.89,74.11736,0,0,0,0,100,0); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=370557; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(370557, 370557, 0, 0, 2, 0, 0), +(370557, 370658, 11, 90, 2, 0, 0), +(370557, 370656, 11, 270, 0, 0, 0); + +-- Pathing for Entry: 57158 'TDB FORMAT' +SET @NPC := 370514; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-2109.938,`position_y`=-2299.641,`position_z`=81.16074 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,-2109.938,-2299.641,81.16074,0,0,0,0,100,0), +(@PATH,6,-2129.284,-2300.282,79.21033,0,0,0,0,100,0), +(@PATH,7,-2145.034,-2298.532,78.46033,0,0,0,0,100,0), +(@PATH,11,-2154.784,-2297.282,79.71033,0,0,0,0,100,0), +(@PATH,15,-2145.496,-2298.506,78.63766,0,0,0,0,100,0), +(@PATH,17,-2130.729,-2300.134,78.98547,0,0,0,0,100,0); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=370514; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(370514, 370514, 0, 0, 2, 0, 0), +(370514, 370528, 15, 90, 2, 0, 0); + +DELETE FROM `creature_addon` WHERE `guid` IN (370529, 370544); +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(370529,0,0,0,1,36, '107849 109247 109257'), +(370544,0,0,0,1,36, '107849 109247 109257'); + +-- SAIs +-- Twilight Siege Captain SAI +SET @ENTRY := 57280; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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,0,0,1,0,100,31,1000,1000,1000,1000,11,45846,2,0,0,0,0,1,0,0,0,0,0,0,0,"Twilight Siege Captain - Out of Combat - Cast 'Frost Channelling' (No Repeat) (Dungeon & Raid)"), +(@ENTRY,0,1,0,0,0,100,30,2000,4500,14000,16000,11,108183,0,0,0,0,0,2,0,0,0,0,0,0,0,"Twilight Siege Captain - In Combat - Cast 'Twilight Submission' (Dungeon & Raid)"), +(@ENTRY,0,2,0,0,0,100,30,8000,9000,22000,27000,11,108172,0,0,0,0,0,2,0,0,0,0,0,0,0,"Twilight Siege Captain - In Combat - Cast 'Twilight Volley' (Dungeon & Raid)"); + +-- Flail of Go'rath SAI +SET @ENTRY := 57877; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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,0,1,4,0,100,31,0,0,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Flail of Go'rath - On Aggro - Disable Combat Movement (No Repeat) (Dungeon & Raid)"), +(@ENTRY,0,1,0,0,0,100,30,2000,4500,12000,13000,11,110102,0,0,0,0,0,2,0,0,0,0,0,0,0,"Flail of Go'rath - In Combat - Cast 'Sludge Spew' (Dungeon & Raid)"), +(@ENTRY,0,2,0,0,0,100,30,9000,9000,25000,27000,11,109199,0,0,0,0,0,1,0,0,0,0,0,0,0,"Flail of Go'rath - In Combat - Cast 'Wild Flail' (Dungeon & Raid)"); + +-- Faceless Corruptor SAI +SET @ENTRY := 57749; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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,0,0,0,0,100,30,0,0,3400,4700,11,96516,64,0,0,0,0,2,0,0,0,0,0,0,0,"Faceless Corruptor - In Combat - Cast 'Shadow Bolt' (Dungeon & Raid)"); + +-- Eye of Go'rath SAI +SET @ENTRY := 57875; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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,0,1,4,0,100,31,0,0,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Eye of Go'rath - On Aggro - Disable Combat Movement (No Repeat) (Dungeon & Raid)"), +(@ENTRY,0,1,0,0,0,100,30,7000,9000,18000,20000,11,109391,0,0,0,0,0,4,0,0,0,0,0,0,0,"Eye of Go'rath - In Combat - Cast 'Shadow Gaze' (Dungeon & Raid)"); + +-- Claw of Go'rath SAI +SET @ENTRY := 55418; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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,0,0,0,0,100,30,5000,7000,14000,18000,11,109396,0,0,0,0,0,4,0,0,0,0,0,0,0,"Claw of Go'rath - In Combat - Cast 'Ooze Spit' (Dungeon & Raid)"), +(@ENTRY,0,1,0,0,0,100,30,4000,4000,18000,22000,11,104377,0,0,0,0,0,1,0,0,0,0,0,0,0,"Claw of Go'rath - In Combat - Cast 'Black Blood of Go'rath' (Dungeon & Raid)"), +(@ENTRY,0,2,1,4,0,100,31,0,0,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Claw of Go'rath - On Aggro - Disable Combat Movement (No Repeat) (Dungeon & Raid)"); + +-- Claw of Go'rath SAI +SET @ENTRY := 57890; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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,0,0,0,0,100,30,5000,7000,14000,18000,11,109396,0,0,0,0,0,4,0,0,0,0,0,0,0,"Claw of Go'rath - In Combat - Cast 'Ooze Spit' (Dungeon & Raid)"), +(@ENTRY,0,1,0,0,0,100,30,7000,10000,15000,30000,11,109197,0,0,0,0,0,2,0,0,0,0,0,0,0,"Claw of Go'rath - In Combat - Cast 'Tentacle Toss' (Dungeon & Raid)"), +(@ENTRY,0,2,1,4,0,100,31,0,0,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Claw of Go'rath - On Aggro - Disable Combat Movement (No Repeat) (Dungeon & Raid)"); + +-- Ancient Water Lord SAI +SET @ENTRY := 57160; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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,0,0,0,0,100,30,4000,5500,13500,15500,11,107791,0,0,0,0,0,2,0,0,0,0,0,0,0,"Ancient Water Lord - In Combat - Cast 'Flood' (Dungeon & Raid)"), +(@ENTRY,0,1,0,0,0,100,30,7000,9000,25000,27000,11,107801,0,0,0,0,0,2,0,0,0,0,0,0,0,"Ancient Water Lord - In Combat - Cast 'Drenched' (Dungeon & Raid)"); + +-- Earthen Destroyer SAI +SET @ENTRY := 57158; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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,0,0,0,0,100,30,2000,4500,12000,15000,11,107597,0,0,0,0,0,4,0,0,0,0,0,0,0,"Earthen Destroyer - In Combat - Cast 'Boulder Smash' (Dungeon & Raid)"), +(@ENTRY,0,1,0,0,0,100,30,7000,9000,22000,26000,11,107675,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthen Destroyer - In Combat - Cast 'Dust Storm' (Dungeon & Raid)"), +(@ENTRY,0,2,0,0,0,100,30,0,0,3400,4700,11,95440,64,0,0,0,0,2,0,0,0,0,0,0,0,"Earthen Destroyer - In Combat - Cast 'Shadow Bolt' (Dungeon & Raid)"); + +-- Earthen Soldier SAI +SET @ENTRY := 57159; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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,0,0,0,0,100,30,0,0,3400,4700,11,95440,64,0,0,0,0,2,0,0,0,0,0,0,0,"Earthen Soldier - In Combat - Cast 'Shadow Bolt' (Dungeon & Raid)"), +(@ENTRY,0,1,0,0,0,100,30,8000,9000,24000,28000,11,107852,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthen Soldier - In Combat - Cast 'Twilight Corruption' (Dungeon & Raid)"), +(@ENTRY,0,2,0,2,0,100,31,0,30,0,0,11,107872,1,0,0,0,0,1,0,0,0,0,0,0,0,"Earthen Soldier - Between 0-30% Health - Cast 'Twilight Rage' (No Repeat) (Dungeon & Raid)"); + +-- Ancient Water Lord SAI +SET @GUID1 := -370500; +SET @GUID2 := -370536; +SET @GUID3 := -370527; +SET @GUID4 := -370505; +SET @GUID5 := -370507; +SET @GUID6 := -370516; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=57160; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@GUID1,@GUID2,@GUID2,@GUID3,@GUID4,@GUID5,@GUID6) AND `source_type`=0; +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 +(@GUID1,0,0,0,1,0,100,0,100,200,20000,20000,11,51835,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ancient Water Lord - Out of Combat - Cast 'Cosmetic - Channel Omni'"), +(@GUID2,0,0,0,1,0,100,0,100,200,20000,20000,11,51835,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ancient Water Lord - Out of Combat - Cast 'Cosmetic - Channel Omni'"), +(@GUID3,0,0,0,1,0,100,0,100,200,20000,20000,11,51835,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ancient Water Lord - Out of Combat - Cast 'Cosmetic - Channel Omni'"), +(@GUID4,0,0,0,1,0,100,0,100,200,20000,20000,11,51835,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ancient Water Lord - Out of Combat - Cast 'Cosmetic - Channel Omni'"), +(@GUID5,0,0,0,1,0,100,0,100,200,20000,20000,11,51835,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ancient Water Lord - Out of Combat - Cast 'Cosmetic - Channel Omni'"), +(@GUID6,0,0,0,1,0,100,0,100,200,20000,20000,11,51835,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ancient Water Lord - Out of Combat - Cast 'Cosmetic - Channel Omni'"); + +-- Earthen Destroyer SAI +SET @GUID1 := -370499; +SET @GUID2 := -370512; +SET @GUID3 := -370503; +SET @GUID4 := -370501; +SET @GUID5 := -370507; +SET @GUID6 := -370533; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=57158; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@GUID1,@GUID2,@GUID2,@GUID3,@GUID4,@GUID5,@GUID6) AND `source_type`=0; +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 +(@GUID1,0,0,0,1,0,100,0,100,200,20000,20000,11,51835,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthen Destroyer - Out of Combat - Cast 'Cosmetic - Channel Omni'"), +(@GUID2,0,0,0,1,0,100,0,100,200,20000,20000,11,51835,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthen Destroyer - Out of Combat - Cast 'Cosmetic - Channel Omni'"), +(@GUID3,0,0,0,1,0,100,0,100,200,20000,20000,11,51835,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthen Destroyer - Out of Combat - Cast 'Cosmetic - Channel Omni'"), +(@GUID4,0,0,0,1,0,100,0,100,200,20000,20000,11,51835,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthen Destroyer - Out of Combat - Cast 'Cosmetic - Channel Omni'"), +(@GUID5,0,0,0,1,0,100,0,100,200,20000,20000,11,51835,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthen Destroyer - Out of Combat - Cast 'Cosmetic - Channel Omni'"), +(@GUID6,0,0,0,1,0,100,0,100,200,20000,20000,11,51835,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthen Destroyer - Out of Combat - Cast 'Cosmetic - Channel Omni'"); + +-- Twilight Siege Captain SAI +SET @ENTRY := 57280; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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,0,0,1,0,100,0,2000,3000,20000,20000,11,108096,0,0,0,0,0,19,57231,30,0,0,0,0,0,"Twilight Siege Captain - Out of Combat - Cast 'Twilight Portal Beam'"); + +-- Twilight Portal SAI +SET @ENTRY := 57231; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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,0,0,25,0,100,0,0,0,0,0,3,0,39581,0,0,0,0,1,0,0,0,0,0,0,0,"Twilight Portal - On Reset - Morph To Creature Twilight Portal"), +(@ENTRY,0,1,0,11,0,100,0,0,0,0,0,3,0,39581,0,0,0,0,1,0,0,0,0,0,0,0,"Twilight Portal - On Reset - Morph To Creature Twilight Portal"); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=1 AND `SourceEntry`=108096; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13, 1, 108096, 0, 0, 31, 0, 3, 57231, 0, 0, 0, 0, '', 'Twilight Portal Beam only targets Bunny'); + +-- Twilight Portal SAI +SET @GUID := -370552; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=57231; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID AND `source_type`=0; +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 +(@GUID,0,0,0,1,0,100,0,3000,3000,6000,7000,12,57259,3,120000,0,0,0,1,0,0,0,0,0,0,0,"Twilight Portal - Out of Combat - Summon Creature 'Twilight Siege Breaker'"), +(@GUID,0,1,0,25,0,100,0,0,0,0,0,3,0,39581,0,0,0,0,1,0,0,0,0,0,0,0,"Twilight Portal - On Reset - Morph To Model 39581"), +(@GUID,0,2,0,11,0,100,0,0,0,0,0,3,0,39581,0,0,0,0,1,0,0,0,0,0,0,0,"Twilight Portal - On Respawn - Morph To Model 39581"); + +-- Twilight Portal SAI +SET @GUID := -370584; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=57231; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID AND `source_type`=0; +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 +(@GUID,0,0,0,1,0,100,0,3000,3000,6000,7000,12,57259,3,120000,0,0,0,1,0,0,0,0,0,0,0,"Twilight Portal - Out of Combat - Summon Creature 'Twilight Siege Breaker'"), +(@GUID,0,1,0,25,0,100,0,0,0,0,0,3,0,39581,0,0,0,0,1,0,0,0,0,0,0,0,"Twilight Portal - On Reset - Morph To Model 39581"), +(@GUID,0,2,0,11,0,100,0,0,0,0,0,3,0,39581,0,0,0,0,1,0,0,0,0,0,0,0,"Twilight Portal - On Respawn - Morph To Model 39581"); + +-- Twilight Portal SAI +SET @GUID := -370561; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=57231; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID AND `source_type`=0; +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 +(@GUID,0,0,0,1,0,100,0,3000,3000,6000,7000,12,57259,3,120000,0,0,0,1,0,0,0,0,0,0,0,"Twilight Portal - Out of Combat - Summon Creature 'Twilight Siege Breaker'"), +(@GUID,0,1,0,25,0,100,0,0,0,0,0,3,0,39581,0,0,0,0,1,0,0,0,0,0,0,0,"Twilight Portal - On Reset - Morph To Model 39581"), +(@GUID,0,2,0,11,0,100,0,0,0,0,0,3,0,39581,0,0,0,0,1,0,0,0,0,0,0,0,"Twilight Portal - On Respawn - Morph To Model 39581"); + +-- Twilight Portal SAI +SET @GUID := -370665; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=57231; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID AND `source_type`=0; +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 +(@GUID,0,0,0,1,0,100,0,3000,3000,6000,7000,12,57259,3,120000,0,0,0,1,0,0,0,0,0,0,0,"Twilight Portal - Out of Combat - Summon Creature 'Twilight Siege Breaker'"), +(@GUID,0,1,0,25,0,100,0,0,0,0,0,3,0,39581,0,0,0,0,1,0,0,0,0,0,0,0,"Twilight Portal - On Reset - Morph To Model 39581"), +(@GUID,0,2,0,11,0,100,0,0,0,0,0,3,0,39581,0,0,0,0,1,0,0,0,0,0,0,0,"Twilight Portal - On Respawn - Morph To Model 39581"); + +-- Twilight Siege Breaker SAI +SET @ENTRY := 57259; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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,0,2,54,0,100,0,0,0,0,0,29,1,0,0,0,0,0,19,57261,500,0,0,0,0,0,"Twilight Siege Breaker - On Just Summoned - Start Follow Closest Creature 'Siege Breaker Stalker'"), +(@ENTRY,0,1,0,38,0,100,0,1,0,0,0,51,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Twilight Siege Breaker - On Data Set 1 0 - Kill Target"), +(@ENTRY,0,2,0,61,0,100,0,0,0,0,0,8,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Twilight Siege Breaker - On Just Summoned - Set Reactstate Passive"); + +-- Siege Breaker Stalker SAI +SET @ENTRY := 57261; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +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,0,0,1,0,100,0,1000,2000,1000,2000,45,1,0,0,0,0,0,19,57259,10,0,0,0,0,0,"Siege Breaker Stalker - Out of Combat - Set Data 1 0"), +(@ENTRY,0,1,0,25,0,100,0,0,0,0,0,2,35,0,0,0,0,0,1,0,0,0,0,0,0,0,"Siege Breaker Stalker - On Reset - Set Faction 35"), +(@ENTRY,0,2,0,11,0,100,0,0,0,0,0,2,35,0,0,0,0,0,1,0,0,0,0,0,0,0,"Siege Breaker Stalker - On Respawn - Set Faction 35"); |