diff options
| -rw-r--r-- | sql/updates/world/master/2021_01_20_02_world_2017_11_01_00_world.sql | 366 |
1 files changed, 366 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_01_20_02_world_2017_11_01_00_world.sql b/sql/updates/world/master/2021_01_20_02_world_2017_11_01_00_world.sql new file mode 100644 index 00000000000..f027eaf6c38 --- /dev/null +++ b/sql/updates/world/master/2021_01_20_02_world_2017_11_01_00_world.sql @@ -0,0 +1,366 @@ +-- +DELETE FROM `creature` WHERE `id`IN (21044,21195,21029,19765,21041,20795); +DELETE FROM `creature` WHERE `guid` IN (62883,62884,66695,66697,69726,69728,70352,70701,70702,70703,70704,70705,70706,70707,70708,73518,76446,76508,76509,76510,77832,77833,77834,77835,77836,77837,77838,77839,78186,78187,80539,80540,80541,80545,80546,80547,80551,80580,80646,80667,80669,80704,80708,80712,80715,80729,80743,80754,80758,80760,80766,80772,80786,80795,80810,80814,80825,80828,80860,80862,80884,80899,80911,80915,80944,80946,81020,81031,81037,81042,81054,81055,81056,81059,81060,81061,81063,81072,81079,81084,81086,81087,81088,81089,81095,81096,81097,81098,81101,81102,81103,81124,81125,81126,81128,81129,81130,81131); +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnDifficulties`, `PhaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`,`curhealth`, `curmana`, `MovementType`) VALUES +(62883, 21195, 530, '0', 0, 0, 0, -2588.75, 1091.04, 59.9092, 1.17927, 180, 5, 5900, 0, 1), +(62884, 21195, 530, '0', 0, 0, 0, -2543.62, 1118.17, 71.2176, 1.08895, 180, 5, 6000, 0, 1), +(66695, 21195, 530, '0', 0, 0, 0, -2523.45, 1153.34, 68.9991, 4.22975, 180, 5, 5900, 0, 1), +(66697, 21195, 530, '0', 0, 0, 0, -2552.1, 1175.69, 78.8479, 3.00296, 180, 5, 5900, 0, 1), +(69726, 21195, 530, '0', 0, 0, 0, -2462.39, 1273.3, 35.5286, 2.99118, 180, 5, 5900, 0, 1 ), +(69728, 21195, 530, '0', 0, 0, 0, -2481.78, 1175.69, 37.8072, 1.88377, 180, 5, 6000, 0, 1), +(70352, 21195, 530, '0', 0, 0, 0, -2546.81, 1231.11, 72.8316, 1.52637, 180, 5, 6000, 0, 1), +(70701, 21195, 530, '0', 0, 0, 0, -2511.39, 1227.9, 61.0218, 3.70192, 180, 5, 6000, 0, 1 ), +(70702, 21195, 530, '0', 0, 0, 0, -2581.92, 1220.64, 77.0188, 1.73843, 180, 5, 6000, 0, 1), +(70703, 21195, 530, '0', 0, 0, 0, -2511.58, 1204.96, 58.753, 2.79872, 180, 5, 5900, 0, 1 ), +(70704, 21195, 530, '0', 0, 0, 0, -2568.08, 1241.86, 80.5805, 2.16743, 180, 5, 5900, 0, 1), +(70705, 21195, 530, '0', 0, 0, 0, -2493.88, 1280.81, 57.6669, 2.39127, 180, 5, 6000, 0, 1), +(70706, 21195, 530, '0', 0, 0, 0, -2475.34, 1311.98, 47.4481, 2.34022, 180, 5, 5900, 0, 1), +(70707, 21195, 530, '0', 0, 0, 0, -2525.07, 1313.36, 65.936, 2.56013, 180, 5, 6000, 0, 1 ), +(70708, 21195, 530, '0', 0, 0, 0, -2570.61, 1374.26, 84.8053, 3.11384, 180, 5, 6000, 0, 1), +(73518, 21195, 530, '0', 0, 0, 0, -2550.49, 1310.61, 79.8304, 3.53168, 180, 5, 5900, 0, 1), +(76446, 21195, 530, '0', 0, 0, 0, -2507.78, 1381.64, 65.6897, 3.94401, 180, 5, 6000, 0, 1), +(76508, 21195, 530, '0', 0, 0, 0, -2567.65, 1445.42, 55.5677, 3.86547, 180, 5, 6000, 0, 1), +(76509, 21195, 530, '0', 0, 0, 0, -2583.85, 1418.77, 74.3185, 4.68669, 180, 5, 5900, 0, 1), +(76510, 21195, 530, '0', 0, 0, 0, -2623.92, 1449.6, 52.1637, 3.34732, 180, 5, 6000, 0, 1 ), +(77832, 21195, 530, '0', 0, 0, 0, -2619.86, 1364.69, 83.0265, 3.71044, 180, 5, 5900, 0, 1), +(77833, 21195, 530, '0', 0, 0, 0, -2619.8, 1316.13, 84.1189, 3.94921, 180, 5, 5900, 0, 1 ), +(77834, 21195, 530, '0', 0, 0, 0, -2706.39, 1364.84, 92.2946, 0.50056, 180, 5, 5900, 0, 1), +(77835, 21195, 530, '0', 0, 0, 0, -2701.88, 1323.35, 90.4227, 6.16328, 180, 5, 6000, 0, 1), +(77836, 21195, 530, '0', 0, 0, 0, -2749.56, 1352.11, 89.3066, 6.2693, 180, 5, 6000, 0, 1 ), +(77837, 21195, 530, '0', 0, 0, 0, -2714.38, 1304.45, 84.5302, 6.04939, 180, 5, 6000, 0, 1), +(77838, 21195, 530, '0', 0, 0, 0, -2825.32, 1259.45, 75.399, 1.02088, 180, 5, 5900, 0, 1 ), +(77839, 21195, 530, '0', 0, 0, 0, -2816.47, 1269.8, 76.3112, 0.600692, 180, 5, 5900, 0, 1), +(78186, 21195, 530, '0', 0, 0, 0, -2794.3, 1256.81, 74.7389, 5.39555, 180, 5, 6000, 0, 1 ), +(78187, 21195, 530, '0', 0, 0, 0, -2795.26, 1246.96, 74.6738, 4.73031, 180, 5, 5900, 0, 1), +(80539, 21195, 530, '0', 0, 0, 0, -2802.93, 1238.03, 75.3009, 3.27811, 180, 5, 6000, 0, 1), +(80540, 21195, 530, '0', 0, 0, 0, -2600.63, 1250.26, 80.1918, 4.33513, 180, 5, 5900, 0, 1), +(80541, 21195, 530, '0', 0, 0, 0, -2594.22, 1313.18, 80.6982, 1.63336, 180, 5, 6000, 0, 1), +(80545, 21195, 530, '0', 0, 0, 0, -2694.88, 1495, 19.2922, 2.33106, 300, 5, 5900, 0, 1), +(80546, 21195, 530, '0', 0, 0, 0, -2706.26, 1538.41, 16.6343, 1.96146, 300, 5, 5900, 0, 1), +(80547, 21029, 530, '0', 0, 0, 0, -2729.85, 1215.23, 48.2141, 1.5708, 1407, 0, 3700, 2434, 0), +(80551, 21029, 530, '0', 0, 0, 0, -2713.19, 1221.69, 38.1432, 2.09439, 1407, 0, 3700, 2434, 0), +(80580, 21029, 530, '0', 0, 0, 0, -2711.53, 1230.92, 37.3221, 2.54818, 1407, 0, 3700, 2434, 0), +(80646, 21029, 530, '0', 0, 0, 0, -2721.25, 1216.49, 41.7782, 1.79769, 1407, 0, 3700, 2434, 0), +(80667, 21029, 530, '0', 0, 0, 0, -2708.88, 1239.1, 38.1921, 3.08923, 1407, 0, 3700, 2434, 0), +(80669, 20795, 530, '0', 0, 0, 1, -2593.76, 1384.13, 44.286, 0.561506, 300, 0, 6803, 2991, 0), +(80704, 21041, 530, '0', 0, 0, 0, -2638.89, 1358.96, 35.9607, 0.574121, 180, 0, 8, 0, 0), +(80708, 21041, 530, '0', 0, 0, 0, -2614.51, 1381.27, 51.6831, 5.55015, 180, 0, 8, 0, 0), +(80712, 21041, 530, '0', 0, 0, 0, -2605.25, 1369.39, 47.99, 4.03171, 180, 0, 8, 0, 0), +(80715, 21041, 530, '0', 0, 0, 0, -2610.76, 1377.7, 41.0943, 3.50811, 180, 0, 8, 0, 0), +(80729, 21041, 530, '0', 0, 0, 0, -2605.53, 1374.24, 45.3846, 5.55015, 180, 0, 8, 0, 0), +(80743, 21041, 530, '0', 0, 0, 0, -2590.76, 1387.65, 54.3178, 4.10152, 180, 0, 8, 0, 0), +(80754, 19765, 530, '0', 0, 0, 1, -2703.64, 1374.07, 38.5804, 5.28805, 300, 0, 6800, 0, 0),-- p +(80758, 19765, 530, '0', 0, 0, 1, -2675.32, 1381.04, 37.7423, 5.21902, 300, 0, 6800, 0, 0), +(80760, 19765, 530, '0', 0, 0, 1, -2762.58, 1270.13, 33.7635, 1.73773, 300, 0, 6800, 0, 0), +(80766, 19765, 530, '0', 0, 0, 1, -2781.27, 1305.83, 33.5543, 5.41576, 300, 0, 6800, 0, 0), +(80772, 19765, 530, '0', 0, 0, 1, -2765.61, 1318.13, 33.4387, 5.33329, 300, 0, 6800, 0, 0), +(80786, 19765, 530, '0', 0, 0, 1, -2787.05, 1147.31, 7.45318, 1.33523, 300, 0, 6800, 0, 0), +(80795, 19765, 530, '0', 0, 0, 1, -2642.37, 1231.22, 11.3652, 1.22372, 300, 5, 6800, 0, 1), +(80810, 19765, 530, '0', 0, 0, 1, -2725.14, 1268.87, 33.2397, 0.988205, 300, 0, 7000, 0, 0), -- A2 +(80814, 19765, 530, '0', 0, 0, 1, -2797.2, 1159.63, 6.59181, 4.52004, 300, 0, 7000, 0, 0), -- A1 +(80825, 19765, 530, '0', 0, 0, 1, -2809.17, 1208.37, 6.36241, 1.99577, 300, 5, 7000, 0, 2), -- M1 +(80828, 19765, 530, '0', 0, 0, 1, -2625.6, 1230.3, 16.0772, 4.37159, 300, 0, 6800, 0, 2), -- M2 +(80860, 19765, 530, '0', 0, 0, 1, -2751.58, 1254.24, 33.2959, 5.17046, 300, 0, 7000, 0, 2), -- M3 +(80862, 19784, 530, '0', 0, 0, 0, -3079.14, 1609.92, 55.97, 4.15, 300, 5, 6542, 0, 1), +(80884, 19784, 530, '0', 0, 0, 0, -3083.91, 1598.23, 55.68, 2.86, 300, 5, 6542, 0, 1), +(80899, 19784, 530, '0', 0, 0, 0, -2700.81, 1218.34, 32.8339, 2.52035, 300, 0, 6542, 0, 0), +(80911, 19784, 530, '0', 0, 0, 0, -2697.99, 1227.02, 32.9681, 3.32304, 300, 0, 6542, 0, 0), +(80915, 19784, 530, '0', 0, 0, 0, -2586.7, 1393.04, 43.1409, 0.341699, 300, 0, 6542, 0, 0), +(80944, 19784, 530, '0', 0, 0, 0, -2583.66, 1386.4, 43.4713, 0.381754, 300, 0, 6542, 0, 0), +(80946, 19784, 530, '0', 0, 0, 0, -2705.87, 1316.38, 32.5245, 4.79938, 300, 0, 6542, 0, 0), +(81020, 19784, 530, '0', 0, 0, 0, -2715.36, 1312.55, 34.2753, 5.14495, 300, 0, 6542, 0, 0), +(81031, 19784, 530, '0', 0, 0, 0, -2636.83, 1260.95, 22.3503, 4.99127, 300, 0, 6542, 0, 0), +(81037, 19784, 530, '0', 0, 0, 0, -2736.01, 1146.11, 3.11515, 3.07334, 300, 0, 6542, 0, 0), +(81042, 19784, 530, '0', 0, 0, 0, -2738.83, 1137.51, 3.69936, 2.48028, 300, 0, 6542, 0, 0), +(81054, 19784, 530, '0', 0, 0, 0, -2841.49, 1248.57, 6.80746, 2.67519, 300, 5, 6542, 0, 1), +(81055, 19784, 530, '0', 0, 0, 0, -2783.33, 1278.81, 34.3858, 3.82742, 300, 0, 6542, 0, 2), -- M4 +(81056, 19784, 530, '0', 0, 0, 0, -2780.24, 1275.13, 34.1177, 3.80386, 300, 0, 6542, 0, 2), -- M5 +(81059, 19788, 530, '0', 0, 0, 1, -2703.59, 1159.87, 5.30619, 4.24358, 300, 0, 6986, 0, 2), -- M6 +(81060, 19788, 530, '0', 0, 0, 1, -2670.19, 1189.04, 2.50672, 0.717135, 300, 0, 6986, 0, 2), -- M7 +(81061, 19788, 530, '0', 0, 0, 1, -2663.22, 1283.27, 27.3812, 5.66254, 300, 0, 6986, 0, 2), -- M8 +(81063, 19788, 530, '0', 0, 0, 1, -2666.03, 1342.99, 34.4455, 3.37765, 300, 0, 6986, 0, 2), -- M9 +(81072, 19788, 530, '0', 0, 0, 1, -2631.91, 1352.43, 36.4787, 0.130435, 300, 0, 6986, 0, 2), -- M10 +(81079, 19788, 530, '0', 0, 0, 1, -2638.05, 1371.17, 36.0565, 0.833366, 300, 0, 6986, 0, 2), -- M11 +(81084, 19767, 530, '0', 0, 0, 1, -2650.88, 1350.89, 34.7686, 3.53907, 300, 5, 5589, 3155, 1), +(81086, 19767, 530, '0', 0, 0, 1, -2728.52, 1257.04, 33.6868, 3.5486, 300, 0, 5589, 3155, 0), +(81087, 19767, 530, '0', 0, 0, 1, -2735.84, 1276.24, 33.2578, 3.89497, 300, 0, 5409, 3080, 0), +(81088, 19767, 530, '0', 0, 0, 1, -2672.92, 1273.19, 27.458, 0.251734, 300, 0, 5409, 3080, 0), +(81089, 19767, 530, '0', 0, 0, 1, -2651.43, 1292.03, 28.1707, 4.99975, 300, 0, 5589, 3155, 0), +(81095, 19767, 530, '0', 0, 0, 0, -2774.5, 1157.2, 7.15576, 1.83316, 300, 0, 5589, 3155, 0), +(81096, 19767, 530, '0', 0, 0, 1, -2701.55, 1392.63, 38.5803, 5.2465, 300, 0, 5409, 3080, 0), +(81097, 19767, 530, '0', 0, 0, 1, -2696.6, 1353.23, 33.0829, 4.37698, 300, 0, 5409, 3080, 2), -- M12 +(81098, 19762, 530, '0', 0, 0, 1, -3147.14, 1601.01, 53.64, 3.85, 300, 0, 6542, 0, 0), +(81101, 19762, 530, '0', 0, 0, 1, -3158.17, 1617.75, 55.43, 4.01, 300, 0, 6542, 0, 0), +(81102, 19762, 530, '0', 0, 0, 1, -3027.45, 1579.61, 64.27, 1.65, 300, 0, 6542, 0, 0), +(81103, 19762, 530, '0', 0, 0, 1, -2966.84, 1629.48, 56.5661, 5.37121, 300, 0, 6542, 0, 0), +(81124, 19762, 530, '0', 0, 0, 1, -2928.87, 1576.1, 36.1739, 0.488692, 300, 0, 6542, 0, 0), +(81125, 19762, 530, '0', 0, 0, 1, -2885.72, 1589.38, 19.9814, 5.58505, 300, 0, 6542, 0, 0), +(81126, 19768, 530, '0', 0, 0, 1, -3101.57, 1612.96, 55.94, 0.95, 300, 5, 5233, 2991, 1), +(81128, 19768, 530, '0', 0, 0, 1, -3052.83, 1588.57, 58.81, 0.65, 300, 0, 5233, 2991, 0), +(81129, 19768, 530, '0', 0, 0, 1, -2993.46, 1601.79, 58.338, 4.51526, 300, 5, 5233, 2991, 1), +(81130, 19768, 530, '0', 0, 0, 1, -2953.91, 1632.53, 55.186, 5.20641, 180, 0, 5233, 2991, 2), -- M13 +(81131, 19789, 530, '0', 0, 0, 1, -3048.96, 1598, 59.1358, 2.63839, 300, 0, 5409, 3080, 2); -- M14 + +UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry`=21029; +DELETE FROM `creature_template_addon` WHERE `entry`=21029; +INSERT INTO `creature_template_addon` (`entry`,`auras`) VALUES (21029,'35929'); + +-- M1 +DELETE FROM `creature_addon` WHERE `guid` IN (80825); +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(80825, 808250, 0, 0, 1, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=808250; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(808250, 1, -2813.66, 1219.47, 6.26582, 2.33427,0, 0, 0, 0, 0), +(808250, 2, -2823.04, 1231.43, 6.26582, 2.21175,0, 0, 0, 0, 0), +(808250, 3, -2812.49, 1218.18, 6.26582, 5.03919,0, 0, 0, 0, 0), +(808250, 4, -2810.22, 1210.22, 6.33902, 5.35806,0, 0, 0, 0, 0), +(808250, 5, -2804.85, 1201.79, 6.35387, 5.3769,0, 0, 0, 0, 0), +(808250, 6, -2809.33, 1208.98, 6.34654, 2.08608,0, 0, 0, 0, 0); + +-- M2 +DELETE FROM `creature_addon` WHERE `guid` IN (80828); +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(80828, 808280, 0, 0, 1, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=808280; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(808280, 1, -2630.87, 1216.9, 13.2485, 4.47919,0, 0, 0, 0, 0), +(808280, 2, -2633.34, 1209.6, 11.5034, 4.14304,0, 0, 0, 0, 0), +(808280, 3, -2640.97, 1198.39, 7.09301, 3.87051,0, 0, 0, 0, 0), +(808280, 4, -2633.61, 1208.49, 11.2079, 1.15225,0, 0, 0, 0, 0), +(808280, 5, -2625.64, 1231.05, 16.2039, 1.18759,0, 0, 0, 0, 0); + +-- M3 +DELETE FROM `creature_addon` WHERE `guid` IN (80860); +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(80860, 808600, 0, 0, 1, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=808600; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(808600, 1, -2749.4, 1244.21, 33.2671, 5.14934,0, 0, 0, 0, 0), +(808600, 2, -2743.86, 1237.89, 33.1367, 5.77373,0, 0, 0, 0, 0), +(808600, 3, -2734.48, 1234.54, 33.0974, 0.004972,0, 0, 0, 0, 0), +(808600, 4, -2727.84, 1234.95, 33.3884, 0.364684,0, 0, 0, 0, 0), +(808600, 5, -2719.89, 1239.82, 33.4734, 0.623865,0, 0, 0, 0, 0), +(808600, 6, -2732.9, 1236.39, 33.2376, 3.02483,0, 0, 0, 0, 0), +(808600, 7, -2743.78, 1243.76, 33.0691, 2.42243,0, 0, 0, 0, 0), +(808600, 8, -2752.27, 1253.43, 33.3292, 2.05722,0, 0, 0, 0, 0), +(808600, 9, -2756.76, 1261.23, 33.6086, 1.78233,0, 0, 0, 0, 0), +(808600, 10, -2755.41, 1267.02, 33.5622, 1.0629,0, 0, 0, 0, 0), +(808600, 11, -2751.57, 1271.24, 33.2816, 0.772747,0, 0, 0, 0, 0), +(808600, 12, -2755.03, 1267.12, 33.5387, 4.41228,0, 0, 0, 0, 0), +(808600, 13, -2755.32, 1260.73, 33.5241, 5.02332,0, 0, 0, 0, 0), +(808600, 14, -2752.29, 1253.29, 33.3312, 5.17882,0, 0, 0, 0, 0); + +-- M4 +DELETE FROM `creature_addon` WHERE `guid` IN (81055); +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(81055, 810550, 0, 0, 1, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=810550; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(810550, 1, -2800.36, 1264.38, 33.7794, 3.85099,0, 0, 0, 0, 0), +(810550, 2, -2785.31, 1278.35, 34.5188, 0.756517,0, 0, 0, 0, 0); + +-- M5 +DELETE FROM `creature_addon` WHERE `guid` IN (81056); +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(81056, 810560, 0, 0, 1, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=810560; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(810560, 1, -2798.04, 1259.64, 33.7046, 3.85491,0, 0, 0, 0, 0), +(810560, 2, -2779.5, 1275.52, 34.0586, 0.7251,0, 0, 0, 0, 0); + +-- M6 +DELETE FROM `creature_addon` WHERE `guid` IN (81059); +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(81059, 810590, 0, 0, 1, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=810590; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(810590, 1, -2709.5, 1149.2, 3.76682, 4.05508,0, 0, 0, 0, 0), +(810590, 2, -2716.63, 1143.44, 1.55487, 3.38278,0, 0, 0, 0, 0), +(810590, 3, -2728.59, 1142.06, 1.56225, 2.93589,0, 0, 0, 0, 0), +(810590, 4, -2740.74, 1144.66, 2.58528, 2.79452,0, 0, 0, 0, 0), +(810590, 5, -2749.98, 1149.23, 4.84679, 2.69635,0, 0, 0, 0, 0), +(810590, 6, -2760.58, 1151.75, 6.37926, 2.84557,0, 0, 0, 0, 0), +(810590, 7, -2750.32, 1148.65, 5.02487, 6.11675,0, 0, 0, 0, 0), +(810590, 8, -2744.08, 1146.07, 3.08787, 5.72719,0, 0, 0, 0, 0), +(810590, 9, -2731.79, 1140.63, 2.27721, 6.15288,0, 0, 0, 0, 0), +(810590, 10, -2725.69, 1141.51, 1.0185, 0.183065,0, 0, 0, 0, 0), +(810590, 11, -2715.63, 1142.92, 1.56719, 0.745411,0, 0, 0, 0, 0), +(810590, 12, -2709.58, 1149.27, 3.79128, 1.18523,0, 0, 0, 0, 0), +(810590, 13, -2704.87, 1160.91, 5.26353, 1.047,0, 0, 0, 0, 0); + +-- M7 +DELETE FROM `creature_addon` WHERE `guid` IN (81060); +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(81060, 810600, 0, 0, 1, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=810600; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(810600, 1, -2662.78, 1194.27, 4.89809, 0.560055,0, 0, 0, 0, 0), +(810600, 2, -2652.94, 1202.78, 6.36992, 0.92448,0, 0, 0, 0, 0), +(810600, 3, -2662.1, 1193.35, 4.7841, 3.73542,0, 0, 0, 0, 0), +(810600, 4, -2669.66, 1188.71, 2.66698, 3.62311,0, 0, 0, 0, 0), +(810600, 5, -2681.1, 1177.21, 5.30023, 3.78961,0, 0, 0, 0, 0), +(810600, 6, -2693.57, 1169.01, 5.23136, 3.6506,0, 0, 0, 0, 0), +(810600, 7, -2680.37, 1178.64, 5.0248, 0.804312,0, 0, 0, 0, 0), +(810600, 8, -2669.93, 1189.34, 2.6242, 0.776037,0, 0, 0, 0, 0); + +-- M8 +DELETE FROM `creature_addon` WHERE `guid` IN (81061); +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(81061, 810610, 0, 0, 1, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=810610; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(810610, 1, -2673.27, 1287.53, 30.0059, 3.01731,0, 0, 0, 0, 0), +(810610, 2, -2686.45, 1288, 33.7323, 2.96077,0, 0, 0, 0, 0), +(810610, 3, -2702.89, 1294.32, 33.346, 1.99237,0, 0, 0, 0, 0), +(810610, 4, -2708.91, 1316.02, 33.1505, 5.27847,0, 0, 0, 0, 0), +(810610, 5, -2703.39, 1296.33, 33.1224, 5.38922,0, 0, 0, 0, 0), +(810610, 6, -2697.54, 1293.02, 33.7168, 5.88558,0, 0, 0, 0, 0), +(810610, 7, -2685.62, 1288.57, 33.6562, 5.83217,0, 0, 0, 0, 0), +(810610, 8, -2665.94, 1281.87, 27.3855, 5.13396,0, 0, 0, 0, 0); + +-- M9 +DELETE FROM `creature_addon` WHERE `guid` IN (81063); +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(81063, 810630, 0, 0, 1, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=810630; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(810630, 1, -2697.32, 1335.65, 34.4455, 3.48132,0, 0, 0, 0, 0), +(810630, 2, -2714.16, 1325.63, 34.4318, 3.49389,0, 0, 0, 0, 0), +(810630, 3, -2731.4, 1319.42, 33.3495, 3.46797,0, 0, 0, 0, 0), +(810630, 4, -2744.27, 1313.27, 33.6604, 3.85281,0, 0, 0, 0, 0), +(810630, 5, -2761.38, 1299.57, 33.234, 3.82925,0, 0, 0, 0, 0), +(810630, 6, -2735.76, 1318.91, 33.372, 0.422193,0, 0, 0, 0, 0), +(810630, 7, -2714.38, 1324.81, 34.4313, 0.432404,0, 0, 0, 0, 0), +(810630, 8, -2696.22, 1335.15, 34.4441, 0.320092,0, 0, 0, 0, 0), +(810630, 9, -2666.71, 1343.22, 34.4441, 3.28969,0, 0, 0, 0, 0); + +-- M10 +DELETE FROM `creature_addon` WHERE `guid` IN (81072); +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(81072, 810720, 0, 0, 1, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=810720; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(810720, 1, -2602.22, 1356.34, 38.5434, 0.303223,0, 0, 0, 0, 0), +(810720, 2, -2593.89, 1359.97, 39.9005, 0.578897,0, 0, 0, 0, 0), +(810720, 3, -2580.5, 1369.67, 41.5277, 0.684141,0, 0, 0, 0, 0), +(810720, 4, -2598.78, 1357.09, 38.9169, 3.24768,0, 0, 0, 0, 0), +(810720, 5, -2630.38, 1351.95, 36.5911, 3.31522,0, 0, 0, 0, 0); + +-- M11 +DELETE FROM `creature_addon` WHERE `guid` IN (81079); +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(81079, 810790, 0, 0, 1, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=810790; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(810790, 1, -2627.7, 1381.62, 37.312, 0.617383,0, 0, 0, 0, 0), +(810790, 2, -2610.51, 1394.28, 41.4979, 0.558478,0, 0, 0, 0, 0), +(810790, 3, -2601.86, 1401.56, 41.8298, 0.766608,0, 0, 0, 0, 0), +(810790, 4, -2611.51, 1393.41, 41.3773, 3.63488,0, 0, 0, 0, 0), +(810790, 5, -2629.13, 1381.32, 37.1627, 3.84066,0, 0, 0, 0, 0), +(810790, 6, -2637.9, 1371.2, 36.0518, 4.06842,0, 0, 0, 0, 0); + +-- M12 +DELETE FROM `creature_addon` WHERE `guid` IN (81097); +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(81097, 810970, 0, 0, 1, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=810970; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(810970, 1, -2695.24, 1357.19, 33.7026, 0.775927,0, 0, 0, 0, 0), +(810970, 2, -2685.75, 1365.43, 36.35, 0.607067,0, 0, 0, 0, 0), +(810970, 3, -2674.19, 1374.13, 35.8703, 1.37676,0, 0, 0, 0, 0), +(810970, 4, -2674.55, 1377.93, 36.8811, 1.88334, 8000,0, 0, 0, 0), +(810970, 5, -2673.1, 1372.77, 35.2807, 4.99351,0, 0, 0, 0, 0), +(810970, 6, -2673.87, 1369.61, 34.4183, 3.96464,0, 0, 0, 0, 0), +(810970, 7, -2675.56, 1369.15, 34.7282, 2.82582,0, 0, 0, 0, 0), +(810970, 8, -2680.29, 1370.4, 36.4156, 3.25779,0, 0, 0, 0, 0), +(810970, 9, -2691.28, 1367.88, 37.5129, 3.72902,0, 0, 0, 0, 0), +(810970, 10, -2695.36, 1365.82, 37.2766, 4.31257,0, 0, 0, 0, 0), +(810970, 11, -2697.01, 1353.85, 33.2442, 4.35739,0, 0, 0, 0, 0); + +-- M13 +DELETE FROM `creature_addon` WHERE `guid` IN (81130); +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(81130, 811300, 0, 0, 1, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=811300; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(811300, 1, -2948.85, 1620.52, 50.9339, 4.9276, 0, 0, 0, 0, 0), +(811300, 2, -2948.62, 1606.71, 46.3706, 4.71947, 0, 0, 0, 0, 0), +(811300, 3, -2946.83, 1597.38, 43.3655, 5.23076, 0, 0, 0, 0, 0), +(811300, 4, -2941.05, 1589.2, 40.6134, 5.61246, 0, 0, 0, 0, 0), +(811300, 5, -2930.78, 1584.22, 36.7235, 6.06093, 0, 0, 0, 0, 0), +(811300, 6, -2915.55, 1581.13, 30.0541, 6.27298, 0, 0, 0, 0, 0), +(811300, 7, -2902.26, 1580.24, 24.2089, 6.25884, 0, 0, 0, 0, 0), +(811300, 8, -2872.79, 1580.65, 15.7052, 6.21957, 0, 0, 0, 0, 0), +(811300, 9, -2892.4, 1580.48, 20.5454, 3.16044, 0, 0, 0, 0, 0), +(811300, 10, -2910.51, 1580.57, 27.9381, 2.89655, 0, 0, 0, 0, 0), +(811300, 11, -2923.92, 1583.02, 34.0035, 2.75596, 0, 0, 0, 0, 0), +(811300, 12, -2936.33, 1587.42, 38.8889, 2.44337, 0, 0, 0, 0, 0), +(811300, 13, -2945.42, 1595.14, 42.6182, 1.99177, 0, 0, 0, 0, 0), +(811300, 14, -2947.7, 1601.71, 44.7921, 1.57158, 0, 0, 0, 0, 0), +(811300, 15, -2948.34, 1612.44, 48.2517, 1.5543, 0, 0, 0, 0, 0), +(811300, 16, -2947.95, 1624.06, 51.8413, 1.77971, 0, 0, 0, 0, 0), +(811300, 17, -2955.93, 1638.98, 57.3739, 2.12764, 0, 0, 0, 0, 0), +(811300, 18, -2957.91, 1642.16, 58.2903, 2.12764, 0, 0, 0, 0, 0), +(811300, 19, -2962.38, 1650.06, 62.1748, 2.04518, 0, 0, 0, 0, 0), +(811300, 20, -2963.01, 1652.75, 62.1967, 1.87631, 0, 0, 0, 0, 0), +(811300, 21, -2968.32, 1662.33, 66.9122, 2.10408, 0, 0, 0, 0, 0), +(811300, 22, -2983.44, 1679.15, 67.6165, 2.35933, 0, 0, 0, 0, 0), +(811300, 23, -2968.48, 1662.08, 66.9107, 5.28887, 0, 0, 0, 0, 0), +(811300, 24, -2963.18, 1652.73, 62.198, 5.18677, 0, 0, 0, 0, 0), +(811300, 25, -2961.16, 1650.86, 62.1755, 5.32421, 0, 0, 0, 0, 0), +(811300, 26, -2957.02, 1641.53, 57.7952, 5.0297, 0, 0, 0, 0, 0), +(811300, 27, -2954.48, 1632.21, 55.2364, 5.30694, 0, 0, 0, 0, 0); + +-- M14 +DELETE FROM `creature_addon` WHERE `guid` IN (81131); +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(81131, 811310, 0, 0, 1, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=811310; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(811310, 1, -3057.21, 1600.07, 57.6605, 3.63113, 0, 0, 0, 0, 0), +(811310, 2, -3064.61, 1595.91, 56.8124, 3.74973, 2000, 0, 0, 0, 0), +(811310, 3, -3057.61, 1599.7, 57.5376, 0.254704, 0, 0, 0, 0, 0), +(811310, 4, -3050.85, 1599.52, 59.142, 6.0588, 0, 0, 0, 0, 0), +(811310, 5, -3023.77, 1598.26, 59.081, 6.25907, 0, 0, 0, 0, 0), +(811310, 6, -3015.37, 1597.73, 58.738, 5.43048, 0, 0, 0, 0, 0), +(811310, 7, -3005.35, 1588.81, 58.859, 4.74096, 0, 0, 0, 0, 0), +(811310, 8, -3006.79, 1581.08, 59.520, 4.00662, 0, 0, 0, 0, 0), +(811310, 9, -3011.55, 1576.15, 60.745, 3.86525, 2000, 0, 0, 0, 0), +(811310, 10, -3003.55, 1584.7, 59.487, 1.46978, 0, 0, 0, 0, 0), +(811310, 11, -3005.9, 1593.1, 58.9026, 2.41933, 0, 0, 0, 0, 0), +(811310, 12, -3021.37, 1598.45, 59.06, 3.09713, 0, 0, 0, 0, 0), +(811310, 13, -3040.07, 1595.73, 58.82, 2.86229, 0, 0, 0, 0, 0), +(811310, 14, -3050.3, 1597.91, 59.201, 2.73427, 0, 0, 0, 0, 0); + +DELETE FROM `creature_addon` WHERE `guid` IN (80814, 80810); +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(80814, 0, 0, 0, 1, 173, ''), -- A1 +(80810, 0, 0, 0, 1, 173, ''); -- A2 +UPDATE `creature` SET `position_x`=-2616.36, `position_y`=1372.07, `position_z`=46.0286, `orientation`=3.85718 WHERE `id`=21027; + +DELETE FROM `gameobject` WHERE `guid` IN (1009,1043,1060,1069,1076,1083,1111,1145,1174,1204,1211,1215,1244,1245,1348,1351,1364,1379,1388,1405,1409,1424,1427); +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnDifficulties`, `PhaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +(1009, 184716, 530, '0', 0, -3044.93, 1629.39, 60.8308, 1.13446, 0, 0, 0.537298, 0.843393, 300, 255, 1), +(1043, 184716, 530, '0', 0, -2900.39, 1302.51, 6.85874, 2.1293, 0, 0, 0.874619, 0.48481, 120, 255, 1), +(1060, 184716, 530, '0', 0, -2914.77, 1390.09, 7.06381, 6.12611, 0, 0, -0.0784588, 0.996917, 120, 255, 1), +(1069, 184716, 530, '0', 0, -2835.52, 1293.71, 6.35783, 3.10665, 0, 0, 0.999847, 0.0174693, 120, 255, 1), +(1076, 184716, 530, '0', 0, -2784.34, 1311.39, 33.6127, 0.279252, 0, 0, 0.139173, 0.990268, 120, 255, 1), +(1083, 184716, 530, '0', 0, -2771, 1197.01, 6.66843, 3.45576, 0, 0, -0.987688, 0.156436, 120, 255, 1), +(1111, 184716, 530, '0', 0, -2749.1, 1229.3, 33.4285, 1.39626, 0, 0, 0.642787, 0.766045, 120, 255, 1), +(1145, 184716, 530, '0', 0, -2792.3, 1222.5, 6.8073, 3.7001, 0, 0, -0.961261, 0.27564, 120, 255, 1), +(1174, 184716, 530, '0', 0, -2726.82, 1275.03, 33.318, 3.80482, 0, 0, -0.945518, 0.325568, 120, 255, 1), +(1204, 184716, 530, '0', 0, -2711.77, 1300.37, 34.1015, 1.43117, 0, 0, 0.656058, 0.75471, 120, 255, 1), +(1211, 184716, 530, '0', 0, -2677.44, 1271.89, 28.6845, 0.95993, 0, 0, 0.461748, 0.887011, 120, 255, 1), +(1215, 184716, 530, '0', 0, -2800.67, 1159.09, 6.86852, 0.994837, 0, 0, 0.477158, 0.878817, 120, 255, 1), +(1244, 184716, 530, '0', 0, -2679, 1384.25, 38.4438, 4.90824, 0, 0, 0.634586, -0.772852, 120, 255, 1), +(1245, 184716, 530, '0', 0, -2686.16, 1394.24, 38.5802, 4.15388, 0, 0, -0.874619, 0.48481, 120, 255, 1), +(1348, 184716, 530, '0', 0, -2707.96, 1389.91, 38.5802, 5.55015, 0, 0, -0.358368, 0.933581, 120, 255, 1), +(1351, 184716, 530, '0', 0, -2630.94, 1267.08, 23.9588, 3.99681, 0, 0, -0.909961, 0.414694, 120, 255, 1), +(1364, 184716, 530, '0', 0, -2576.08, 1405.02, 40.7724, 4.06662, 0, 0, -0.894934, 0.446199, 120, 255, 1), +(1379, 184716, 530, '0', 0, -2817.58, 1253.35, 6.74906, 4.35564, 0, 0, 0.821351, -0.570424, 120, 255, 1), +(1388, 184716, 530, '0', 0, -2638.01, 1221.84, 9.4381, 2.20363, 0, 0, 0.892029, 0.451978, 120, 255, 1), +(1405, 184716, 530, '0', 0, -2623.03, 1238.01, 17.3887, 4.36662, 0, 0, 0.818206, -0.574925, 120, 255, 1), +(1409, 184716, 530, '0', 0, -2715.44, 1336.68, 34.3086, 5.1049, 0, 0, 0.55565, -0.831416, 120, 255, 1), +(1424, 184716, 530, '0', 0, -2665.92, 1331.43, 34.4453, 1.82562, 0, 0, 0.791227, 0.611523, 120, 255, 1), +(1427, 184683, 530, '0', 0, -2804.58, 1259.3, 74.6677, 3.13983, 0.00436163, -0.0218144, 0.999752, 0.000976562, 25, 255, 1); |