diff options
| -rw-r--r-- | sql/updates/world/master/2022_01_06_62_world_2020_06_18_00_world.sql | 365 |
1 files changed, 365 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_06_62_world_2020_06_18_00_world.sql b/sql/updates/world/master/2022_01_06_62_world_2020_06_18_00_world.sql new file mode 100644 index 00000000000..26af8a744de --- /dev/null +++ b/sql/updates/world/master/2022_01_06_62_world_2020_06_18_00_world.sql @@ -0,0 +1,365 @@ +-- +-- delete new spawns +DELETE FROM `creature` WHERE `guid` IN (362188,362189,362190); + +-- restore 3.3.5 spawns +DELETE FROM `creature` WHERE `guid` IN (43201,43202,43203); +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `phaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES +(43201, 15541, 1, 0, 0, '0', 0, 0, 1, -6374.21, 532.318, 6.19409, 4.31401, 600, 0, 0, 0, 0, 2, 0, 0, 0, '', 0), +(43202, 15542, 1, 0, 0, '0', 0, 0, 1, -6362.06, 551.901, 7.30232, 4.29159, 300, 0, 0, 0, 0, 2, 0, 0, 0, '', 0), +(43203, 15542, 1, 0, 0, '0', 0, 0, 1, -6366.48, 541.942, 6.9074, 4.32893, 300, 0, 0, 0, 0, 2, 0, 0, 0, '', 0); + +DELETE FROM `creature_addon` WHERE `guid` IN (43201,43202,43203); +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES +(43201, 432010, 14337, 0, 1, 0, 0, NULL); + +DELETE FROM `waypoint_data` WHERE `id` IN (432010,432020,432030); +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(432010, 1, -6381.83, 522.263, 6.33608, 0, 0, 0, 0, 100, 0), +(432010, 2, -6388.62, 511.913, 6.40844, 0, 0, 0, 0, 100, 0), +(432010, 3, -6396.02, 501.126, 5.96868, 0, 0, 0, 0, 100, 0), +(432010, 4, -6403.3, 493.654, 4.30304, 0, 0, 0, 0, 100, 0), +(432010, 5, -6408.62, 486.992, 2.68521, 0, 0, 0, 0, 100, 0), +(432010, 6, -6414.09, 479.644, 0.827286, 0, 0, 0, 0, 100, 0), +(432010, 7, -6415.84, 474.03, -1.00684, 0, 0, 0, 0, 100, 0), +(432010, 8, -6418.49, 464.595, 0.523592, 0, 0, 0, 0, 100, 0), +(432010, 9, -6418.49, 464.595, 0.523592, 0, 0, 0, 0, 100, 0), +(432010, 10, -6425.01, 441.027, 2.01444, 0, 0, 0, 0, 100, 0), +(432010, 11, -6430.5, 429.614, 2.89218, 0, 0, 0, 0, 100, 0), +(432010, 12, -6434.42, 425.346, 3.12233, 0, 0, 0, 0, 100, 0), +(432010, 13, -6452.57, 408.975, 3.49116, 0, 0, 0, 0, 100, 0), +(432010, 14, -6469.84, 391.597, 2.38939, 0, 0, 0, 0, 100, 0), +(432010, 15, -6471.76, 389.704, 2.10586, 0, 0, 0, 0, 100, 0), +(432010, 16, -6471.76, 389.704, 2.10586, 0, 0, 0, 0, 100, 0), +(432010, 17, -6499.13, 374.662, 2.13876, 0, 0, 0, 0, 100, 0), +(432010, 18, -6501.03, 373.994, 2.01011, 0, 0, 0, 0, 100, 0), +(432010, 19, -6527.96, 388.841, 4.81061, 0, 0, 0, 0, 100, 0), +(432010, 20, -6530.47, 388.01, 4.49237, 0, 0, 0, 0, 100, 0), +(432010, 21, -6541.67, 369.928, 1.47049, 0, 0, 0, 0, 100, 0), +(432010, 22, -6544.27, 367.978, 1.26933, 0, 0, 0, 0, 100, 0), +(432010, 23, -6544.27, 367.978, 1.26933, 0, 0, 0, 0, 100, 0), +(432010, 24, -6568.99, 350.006, 3.62838, 0, 0, 0, 0, 100, 0), +(432010, 25, -6581.04, 334.773, 0.99317, 0, 0, 0, 0, 100, 0), +(432010, 26, -6581.04, 334.773, 0.99317, 0, 0, 0, 0, 100, 0), +(432010, 27, -6581.04, 334.773, 0.99317, 0, 0, 0, 0, 100, 0), +(432010, 28, -6604.63, 310.711, 3.49995, 0, 0, 0, 0, 100, 0), +(432010, 29, -6608.37, 309.531, 3.46286, 0, 0, 0, 0, 100, 0), +(432010, 30, -6623.45, 305.414, 3.13978, 0, 0, 0, 0, 100, 0), +(432010, 31, -6634.63, 297.475, 3.05937, 0, 0, 0, 0, 100, 0), +(432010, 32, -6640.44, 291.236, 2.59651, 0, 0, 0, 0, 100, 0), +(432010, 33, -6649.03, 282.408, 2.2899, 0, 0, 0, 0, 100, 0), +(432010, 34, -6660.82, 271.363, 4.43145, 0, 0, 0, 0, 100, 0), +(432010, 35, -6660.82, 271.363, 4.43145, 0, 0, 0, 0, 100, 0), +(432010, 36, -6677.3, 253.233, 3.84925, 0, 0, 0, 0, 100, 0), +(432010, 37, -6695.4, 233.018, 2.69341, 0, 0, 0, 0, 100, 0), +(432010, 38, -6708.32, 223.081, 2.06455, 0, 0, 0, 0, 100, 0), +(432010, 39, -6720.52, 207.81, 2.13145, 0, 0, 0, 0, 100, 0), +(432010, 40, -6728.84, 193.182, 3.85769, 0, 0, 0, 0, 100, 0), +(432010, 41, -6729.12, 189.274, 3.89565, 0, 0, 0, 0, 100, 0), +(432010, 42, -6733.38, 165.157, 2.50309, 0, 0, 0, 0, 100, 0), +(432010, 43, -6733.73, 161.548, 2.26791, 0, 0, 0, 0, 100, 0), +(432010, 44, -6733.41, 137.063, 4.09396, 0, 0, 0, 0, 100, 0), +(432010, 45, -6740.68, 126.034, 4.11355, 0, 0, 0, 0, 100, 0), +(432010, 46, -6752.78, 121.21, 2.5664, 0, 0, 0, 0, 100, 0), +(432010, 47, -6763.03, 119.278, 1.11022, 0, 0, 0, 0, 100, 0), +(432010, 48, -6770.36, 116.385, 0.736461, 0, 0, 0, 0, 100, 0), +(432010, 49, -6786.8, 109.532, 4.10522, 0, 0, 0, 0, 100, 0), +(432010, 50, -6786.8, 109.532, 4.10522, 0, 0, 0, 0, 100, 0), +(432010, 51, -6798.34, 133.72, 3.8605, 0, 0, 0, 0, 100, 0), +(432010, 52, -6803.13, 143.68, 3.29543, 0, 0, 0, 0, 100, 0), +(432010, 53, -6806.7, 156.926, 1.91714, 0, 0, 0, 0, 100, 0), +(432010, 54, -6809.22, 162.987, 1.34973, 0, 0, 0, 0, 100, 0), +(432010, 55, -6822.97, 177.835, 0.423451, 0, 0, 0, 0, 100, 0), +(432010, 56, -6830.98, 184.459, 1.24963, 0, 0, 0, 0, 100, 0), +(432010, 57, -6847.84, 202.184, 3.13678, 0, 0, 0, 0, 100, 0), +(432010, 58, -6853.92, 213.165, 2.3177, 0, 0, 0, 0, 100, 0), +(432010, 59, -6853.92, 213.165, 2.3177, 0, 0, 0, 0, 100, 0), +(432010, 60, -6862.69, 230.697, 0.189849, 0, 0, 0, 0, 100, 0), +(432010, 61, -6875.76, 248.494, 0.714978, 0, 0, 0, 0, 100, 0), +(432010, 62, -6886.87, 260.405, 3.01083, 0, 0, 0, 0, 100, 0), +(432010, 63, -6890.23, 268.041, 3.75853, 0, 0, 0, 0, 100, 0), +(432010, 64, -6891.84, 282.321, 3.93235, 0, 0, 0, 0, 100, 0), +(432010, 65, -6898.99, 305.754, 3.84856, 0, 0, 0, 0, 100, 0), +(432010, 66, -6908.82, 323.496, 3.55015, 0, 0, 0, 0, 100, 0), +(432010, 67, -6908.82, 323.496, 3.55015, 0, 0, 0, 0, 100, 0), +(432010, 68, -6928.57, 337.92, 3.2281, 0, 0, 0, 0, 100, 0), +(432010, 69, -6937.24, 345.285, 4.01963, 0, 0, 0, 0, 100, 0), +(432010, 70, -6951.84, 361.005, 5.90094, 0, 0, 0, 0, 100, 0), +(432010, 71, -6964.7, 382.142, 5.41806, 0, 0, 0, 0, 100, 0), +(432010, 72, -6968.47, 401.663, 3.03619, 0, 0, 0, 0, 100, 0), +(432010, 73, -6968.47, 401.663, 3.03619, 0, 0, 0, 0, 100, 0), +(432010, 74, -6970.83, 418.38, 5.32879, 0, 0, 0, 0, 100, 0), +(432010, 75, -6981.98, 440.13, 8.42832, 0, 0, 0, 0, 100, 0), +(432010, 76, -6983.44, 444.071, 8.45617, 0, 0, 0, 0, 100, 0), +(432010, 77, -6994.07, 473.436, 8.02054, 0, 0, 0, 0, 100, 0), +(432010, 78, -7006.97, 484.434, 5.74935, 0, 0, 0, 0, 100, 0), +(432010, 79, -7008.14, 488.174, 6.09104, 0, 0, 0, 0, 100, 0), +(432010, 80, -7010.18, 493.008, 8.48791, 0, 0, 0, 0, 100, 0), +(432010, 81, -7014.82, 499.297, 9.05018, 0, 0, 0, 0, 100, 0), +(432010, 82, -7024.9, 503.993, 8.78707, 0, 0, 0, 0, 100, 0), +(432010, 83, -7024.9, 503.993, 8.78707, 0, 0, 0, 0, 100, 0), +(432010, 84, -7035.93, 484.679, 9.25159, 0, 0, 0, 0, 100, 0), +(432010, 85, -7054.55, 463.783, 9.08453, 0, 0, 0, 0, 100, 0), +(432010, 86, -7059.05, 460.609, 8.44962, 0, 0, 0, 0, 100, 0), +(432010, 87, -7059.05, 460.609, 8.44962, 0, 0, 0, 0, 100, 0), +(432010, 88, -7066.06, 434.783, 8.65003, 0, 0, 0, 0, 100, 0), +(432010, 89, -7076.38, 423.931, 8.2561, 0, 0, 0, 0, 100, 0), +(432010, 90, -7083.91, 418.745, 7.81772, 0, 0, 0, 0, 100, 0), +(432010, 91, -7090.38, 419.532, 6.20053, 0, 0, 0, 0, 100, 0), +(432010, 92, -7094.1, 423.171, 6.0317, 0, 0, 0, 0, 100, 0), +(432010, 93, -7103.52, 439.507, 5.07884, 0, 0, 0, 0, 100, 0), +(432010, 94, -7106.42, 449.528, 5.01998, 0, 0, 0, 0, 100, 0), +(432010, 95, -7112.86, 467.14, 6.73329, 0, 0, 0, 0, 100, 0), +(432010, 96, -7112.86, 467.14, 6.73329, 0, 0, 0, 0, 100, 0), +(432010, 97, -7125.08, 487.981, 3.37296, 0, 0, 0, 0, 100, 0), +(432010, 98, -7125.08, 487.981, 3.37296, 0, 0, 0, 0, 100, 0), +(432010, 99, -7138.8, 508.267, 3.89067, 0, 0, 0, 0, 100, 0), +(432010, 100, -7138.8, 508.267, 3.89067, 0, 0, 0, 0, 100, 0), +(432010, 101, -7138.8, 508.267, 3.89067, 0, 0, 0, 0, 100, 0), +(432010, 102, -7152.07, 526.486, 7.64068, 0, 0, 0, 0, 100, 0), +(432010, 103, -7152.07, 526.486, 7.64068, 0, 0, 0, 0, 100, 0), +(432010, 104, -7169.3, 543.895, 4.61447, 0, 0, 0, 0, 100, 0), +(432010, 105, -7169.3, 543.895, 4.61447, 0, 0, 0, 0, 100, 0), +(432010, 106, -7195.62, 568.831, 4.7267, 0, 0, 0, 0, 100, 0), +(432010, 107, -7204.96, 574.829, 3.99974, 0, 0, 0, 0, 100, 0), +(432010, 108, -7215.56, 577.951, 2.85007, 0, 0, 0, 0, 100, 0), +(432010, 109, -7215.56, 577.951, 2.85007, 0, 0, 0, 0, 100, 0), +(432010, 110, -7215.56, 577.951, 2.85007, 0, 0, 0, 0, 100, 0), +(432010, 111, -7250.56, 582.17, 4.64078, 0, 0, 0, 0, 100, 0), +(432010, 112, -7263.12, 585.77, 3.49723, 0, 0, 0, 0, 100, 0), +(432010, 113, -7263.12, 585.77, 3.49723, 0, 0, 0, 0, 100, 0), +(432010, 114, -7291.6, 592.721, 0.04386, 0, 0, 0, 0, 100, 0), +(432010, 115, -7296.71, 595.531, 0.542263, 0, 0, 0, 0, 100, 0), +(432010, 116, -7296.71, 595.531, 0.542263, 0, 0, 0, 0, 100, 0), +(432010, 117, -7321.67, 613.23, 1.97044, 0, 0, 0, 0, 100, 0), +(432010, 118, -7323.46, 614.139, 1.88293, 0, 0, 0, 0, 100, 0), +(432010, 119, -7323.46, 614.139, 1.88293, 0, 0, 0, 0, 100, 0), +(432010, 120, -7335.5, 645.596, -0.95606, 0, 0, 0, 0, 100, 0), +(432010, 121, -7335.5, 645.596, -0.95606, 0, 0, 0, 0, 100, 0), +(432010, 122, -7335.02, 670.041, 2.23719, 0, 0, 0, 0, 100, 0), +(432010, 123, -7335.76, 680.791, 2.78817, 0, 0, 0, 0, 100, 0), +(432010, 124, -7339.75, 697.307, 2.04653, 0, 0, 0, 0, 100, 0), +(432010, 125, -7340.77, 700.481, 1.524, 0, 0, 0, 0, 100, 0), +(432010, 126, -7340.77, 700.481, 1.524, 0, 0, 0, 0, 100, 0), +(432010, 127, -7349.28, 720.233, 1.48185, 0, 0, 0, 0, 100, 0), +(432010, 128, -7355.21, 742.987, 4.43733, 0, 0, 0, 0, 100, 0), +(432010, 129, -7355.21, 742.987, 4.43733, 0, 0, 0, 0, 100, 0), +(432010, 130, -7358.45, 767.271, 3.88032, 0, 0, 0, 0, 100, 0), +(432010, 131, -7359.12, 772.767, 3.10525, 0, 0, 0, 0, 100, 0), +(432010, 132, -7359.12, 772.767, 3.10525, 0, 0, 0, 0, 100, 0), +(432010, 133, -7360.41, 797.233, 2.03258, 0, 0, 0, 0, 100, 0), +(432010, 134, -7360.41, 797.233, 2.03258, 0, 0, 0, 0, 100, 0), +(432010, 135, -7364.25, 832.479, 6.24249, 0, 0, 0, 0, 100, 0), +(432010, 136, -7364.25, 832.479, 6.24249, 0, 0, 0, 0, 100, 0), +(432010, 137, -7359.69, 852.841, 5.61188, 0, 0, 0, 0, 100, 0), +(432010, 138, -7359.75, 868.507, 4.5219, 0, 0, 0, 0, 100, 0), +(432010, 139, -7364.21, 879.221, 3.08032, 0, 0, 0, 0, 100, 0), +(432010, 140, -7369.78, 884.806, 2.19951, 0, 0, 0, 0, 100, 0), +(432010, 141, -7379.47, 897.887, 1.88811, 0, 0, 0, 0, 100, 0), +(432010, 142, -7385.87, 909.284, 1.4183, 0, 0, 0, 0, 100, 0), +(432010, 143, -7385.87, 909.284, 1.4183, 0, 0, 0, 0, 100, 0), +(432010, 144, -7385.87, 909.284, 1.4183, 0, 0, 0, 0, 100, 0), +(432010, 145, -7394.29, 932.24, 3.78666, 0, 0, 0, 0, 100, 0), +(432010, 146, -7401.88, 952.018, 4.22339, 0, 0, 0, 0, 100, 0), +(432010, 147, -7408.17, 962.726, 3.8838, 0, 0, 0, 0, 100, 0), +(432010, 148, -7419.52, 973.376, 3.74543, 0, 0, 0, 0, 100, 0), +(432010, 149, -7419.52, 973.376, 3.74543, 0, 0, 0, 0, 100, 0), +(432010, 150, -7440.39, 985.459, 3.41013, 0, 0, 0, 0, 100, 0), +(432010, 151, -7463.75, 996.742, 3.0073, 0, 0, 0, 0, 100, 0), +(432010, 152, -7463.75, 996.742, 3.0073, 0, 0, 0, 0, 100, 0), +(432010, 153, -7482.49, 1008.83, 1.90533, 0, 0, 0, 0, 100, 0), +(432010, 154, -7500.16, 1012.46, 2.21159, 0, 0, 0, 0, 100, 0), +(432010, 155, -7507.99, 1011.99, 2.44511, 0, 0, 0, 0, 100, 0), +(432010, 156, -7529.33, 1002.12, 1.56887, 0, 0, 0, 0, 100, 0), +(432010, 157, -7542.13, 999.824, 2.58838, 0, 0, 0, 0, 100, 0), +(432010, 158, -7562.8, 1001.46, 2.63714, 0, 0, 0, 0, 100, 0), +(432010, 159, -7562.8, 1001.46, 2.63714, 0, 0, 0, 0, 100, 0), +(432010, 160, -7562.8, 1001.46, 2.63714, 0, 0, 0, 0, 100, 0), +(432010, 161, -7591.28, 1015.61, 3.19717, 0, 0, 0, 0, 100, 0), +(432010, 162, -7591.28, 1015.61, 3.19717, 0, 0, 0, 0, 100, 0), +(432010, 163, -7607.47, 1031.64, 5.29972, 0, 0, 0, 0, 100, 0), +(432010, 164, -7614.83, 1035.81, 4.79784, 0, 0, 0, 0, 100, 0), +(432010, 165, -7624.34, 1038.39, 4.65626, 0, 0, 0, 0, 100, 0), +(432010, 166, -7643.9, 1043.74, 4.92598, 0, 0, 0, 0, 100, 0), +(432010, 167, -7661.32, 1052.34, 4.82357, 0, 0, 0, 0, 100, 0), +(432010, 168, -7661.32, 1052.34, 4.82357, 0, 0, 0, 0, 100, 0), +(432010, 169, -7678.65, 1069.65, 3.93121, 0, 0, 0, 0, 100, 0), +(432010, 170, -7691.84, 1080.81, 3.53004, 0, 0, 0, 0, 100, 0), +(432010, 171, -7696.62, 1084.24, 3.41852, 0, 0, 0, 0, 100, 0), +(432010, 172, -7708.09, 1093.96, 2.98749, 0, 0, 0, 0, 100, 0), +(432010, 173, -7718.06, 1105.22, 2.59431, 0, 0, 0, 0, 100, 0), +(432010, 174, -7733.52, 1124.22, 1.73916, 0, 0, 0, 0, 100, 0), +(432010, 175, -7741.22, 1134.37, 1.33201, 0, 0, 0, 0, 100, 0), +(432010, 176, -7751.82, 1156.45, 0.576632, 0, 0, 0, 0, 100, 0), +(432010, 177, -7762.49, 1178.51, -0.154873, 0, 0, 0, 0, 100, 0), +(432010, 178, -7762.49, 1178.51, -0.154873, 0, 0, 0, 0, 100, 0), +(432010, 179, -7773.03, 1200.62, -1.26206, 0, 0, 0, 0, 100, 0), +(432010, 180, -7783.37, 1222.83, -3.7369, 0, 0, 0, 0, 100, 0), +(432010, 181, -7793.09, 1245.32, -6.71451, 0, 0, 0, 0, 100, 0), +(432010, 182, -7800.12, 1259.61, -9.0872, 0, 0, 0, 0, 100, 0), +(432010, 183, -7806.61, 1270.22, -10.4451, 0, 0, 0, 0, 100, 0), +(432010, 184, -7802.96, 1289.36, -8.34551, 0, 0, 0, 0, 100, 0), +(432010, 185, -7802.96, 1289.36, -8.34551, 0, 0, 0, 0, 100, 0), +(432010, 186, -7795.69, 1314.38, -5.09394, 0, 0, 0, 0, 100, 0), +(432010, 187, -7810.15, 1326.26, -7.40606, 0, 0, 0, 0, 100, 0), +(432010, 188, -7822.73, 1319.24, -10.681, 0, 0, 0, 0, 100, 0), +(432010, 189, -7826.93, 1308.33, -10.038, 0, 0, 0, 0, 100, 0), +(432010, 190, -7828.93, 1298.77, -9.55642, 0, 0, 0, 0, 100, 0), +(432010, 191, -7826.23, 1286.24, -11.5585, 0, 0, 0, 0, 100, 0), +(432010, 192, -7826.23, 1286.24, -11.5585, 0, 0, 0, 0, 100, 0), +(432010, 193, -7826.23, 1286.24, -11.5585, 0, 0, 0, 0, 100, 0), +(432010, 194, -7803.98, 1261.54, -9.61223, 0, 0, 0, 0, 100, 0), +(432010, 195, -7798.21, 1252.14, -7.91404, 0, 0, 0, 0, 100, 0), +(432010, 196, -7786.57, 1230.64, -4.86232, 0, 0, 0, 0, 100, 0), +(432010, 197, -7776.76, 1208.36, -1.91932, 0, 0, 0, 0, 100, 0), +(432010, 198, -7776.76, 1208.36, -1.91932, 0, 0, 0, 0, 100, 0), +(432010, 199, -7767.4, 1185.77, -0.426412, 0, 0, 0, 0, 100, 0), +(432010, 200, -7751.14, 1153.63, 0.568985, 0, 0, 0, 0, 100, 0), +(432010, 201, -7742.45, 1142.21, 0.981252, 0, 0, 0, 0, 100, 0), +(432010, 202, -7726.66, 1123.48, 1.76707, 0, 0, 0, 0, 100, 0), +(432010, 203, -7726.66, 1123.48, 1.76707, 0, 0, 0, 0, 100, 0), +(432010, 204, -7710.6, 1105.02, 2.66458, 0, 0, 0, 0, 100, 0), +(432010, 205, -7694.26, 1086.76, 3.33483, 0, 0, 0, 0, 100, 0), +(432010, 206, -7677.74, 1068.78, 3.94982, 0, 0, 0, 0, 100, 0), +(432010, 207, -7659.43, 1052.14, 4.91582, 0, 0, 0, 0, 100, 0), +(432010, 208, -7649.08, 1046.71, 4.95878, 0, 0, 0, 0, 100, 0), +(432010, 209, -7649.08, 1046.71, 4.95878, 0, 0, 0, 0, 100, 0), +(432010, 210, -7625.01, 1042.15, 4.46894, 0, 0, 0, 0, 100, 0), +(432010, 211, -7603.3, 1040.11, 4.48228, 0, 0, 0, 0, 100, 0), +(432010, 212, -7579.12, 1039.98, 3.99961, 0, 0, 0, 0, 100, 0), +(432010, 213, -7579.12, 1039.98, 3.99961, 0, 0, 0, 0, 100, 0), +(432010, 214, -7554.95, 1036.01, 3.35316, 0, 0, 0, 0, 100, 0), +(432010, 215, -7530.86, 1031.55, 2.74821, 0, 0, 0, 0, 100, 0), +(432010, 216, -7518.82, 1029.07, 2.71235, 0, 0, 0, 0, 100, 0), +(432010, 217, -7518.82, 1029.07, 2.71235, 0, 0, 0, 0, 100, 0), +(432010, 218, -7489.37, 1018.31, 1.95638, 0, 0, 0, 0, 100, 0), +(432010, 219, -7462.4, 1006.38, 2.20385, 0, 0, 0, 0, 100, 0), +(432010, 220, -7455.77, 998.396, 2.89252, 0, 0, 0, 0, 100, 0), +(432010, 221, -7455.77, 998.396, 2.89252, 0, 0, 0, 0, 100, 0), +(432010, 222, -7448.96, 974.863, 4.33075, 0, 0, 0, 0, 100, 0), +(432010, 223, -7441.17, 948.264, 1.65803, 0, 0, 0, 0, 100, 0), +(432010, 224, -7441.17, 948.264, 1.65803, 0, 0, 0, 0, 100, 0), +(432010, 225, -7428.39, 927.429, 3.78599, 0, 0, 0, 0, 100, 0), +(432010, 226, -7423.08, 919.427, 3.25806, 0, 0, 0, 0, 100, 0), +(432010, 227, -7415.13, 912.745, 2.17476, 0, 0, 0, 0, 100, 0), +(432010, 228, -7415.13, 912.745, 2.17476, 0, 0, 0, 0, 100, 0), +(432010, 229, -7393.35, 901.621, 1.19573, 0, 0, 0, 0, 100, 0), +(432010, 230, -7377.8, 892.678, 1.60292, 0, 0, 0, 0, 100, 0), +(432010, 231, -7368.15, 885.076, 2.38997, 0, 0, 0, 0, 100, 0), +(432010, 232, -7356.76, 872.538, 4.52426, 0, 0, 0, 0, 100, 0), +(432010, 233, -7349.03, 859.142, 5.9086, 0, 0, 0, 0, 100, 0), +(432010, 234, -7349.03, 859.142, 5.9086, 0, 0, 0, 0, 100, 0), +(432010, 235, -7347.9, 834.669, 5.75347, 0, 0, 0, 0, 100, 0), +(432010, 236, -7347.27, 820.669, 4.12543, 0, 0, 0, 0, 100, 0), +(432010, 237, -7345.37, 799.572, 0.922967, 0, 0, 0, 0, 100, 0), +(432010, 238, -7341.02, 793.882, 2.23596, 0, 0, 0, 0, 100, 0), +(432010, 239, -7328.22, 783.823, 3.96613, 0, 0, 0, 0, 100, 0), +(432010, 240, -7318.78, 766.824, 5.08772, 0, 0, 0, 0, 100, 0), +(432010, 241, -7312.81, 748.878, 5.60424, 0, 0, 0, 0, 100, 0), +(432010, 242, -7308.44, 735.218, 4.81518, 0, 0, 0, 0, 100, 0), +(432010, 243, -7308.44, 735.218, 4.81518, 0, 0, 0, 0, 100, 0), +(432010, 244, -7297.61, 713.247, 1.50116, 0, 0, 0, 0, 100, 0), +(432010, 245, -7292.83, 704.299, 2.73024, 0, 0, 0, 0, 100, 0), +(432010, 246, -7292.83, 704.299, 2.73024, 0, 0, 0, 0, 100, 0), +(432010, 247, -7292.83, 704.299, 2.73024, 0, 0, 0, 0, 100, 0), +(432010, 248, -7273.99, 688.644, 6.33373, 0, 0, 0, 0, 100, 0), +(432010, 249, -7262.51, 679.462, 8.53285, 0, 0, 0, 0, 100, 0), +(432010, 250, -7262.51, 679.462, 8.53285, 0, 0, 0, 0, 100, 0), +(432010, 251, -7240.23, 661.377, 9.91954, 0, 0, 0, 0, 100, 0), +(432010, 252, -7232.97, 654.869, 8.79697, 0, 0, 0, 0, 100, 0), +(432010, 253, -7220.35, 638.217, 5.59505, 0, 0, 0, 0, 100, 0), +(432010, 254, -7218.06, 632.807, 4.35276, 0, 0, 0, 0, 100, 0), +(432010, 255, -7218.06, 632.807, 4.35276, 0, 0, 0, 0, 100, 0), +(432010, 256, -7209.08, 610.059, 3.65591, 0, 0, 0, 0, 100, 0), +(432010, 257, -7209.08, 610.059, 3.65591, 0, 0, 0, 0, 100, 0), +(432010, 258, -7199.58, 587.481, 4.66785, 0, 0, 0, 0, 100, 0), +(432010, 259, -7187.62, 565.051, 5.23083, 0, 0, 0, 0, 100, 0), +(432010, 260, -7187.62, 565.051, 5.23083, 0, 0, 0, 0, 100, 0), +(432010, 261, -7168.85, 548.013, 4.94201, 0, 0, 0, 0, 100, 0), +(432010, 262, -7164.35, 545.33, 4.51328, 0, 0, 0, 0, 100, 0), +(432010, 263, -7164.35, 545.33, 4.51328, 0, 0, 0, 0, 100, 0), +(432010, 264, -7149.8, 539.532, 5.34474, 0, 0, 0, 0, 100, 0), +(432010, 265, -7141.45, 538.382, 6.5345, 0, 0, 0, 0, 100, 0), +(432010, 266, -7124.94, 539.611, 8.79837, 0, 0, 0, 0, 100, 0), +(432010, 267, -7124.94, 539.611, 8.79837, 0, 0, 0, 0, 100, 0), +(432010, 268, -7096.07, 559.827, 9.06105, 0, 0, 0, 0, 100, 0), +(432010, 269, -7074.14, 570.737, 9.21615, 0, 0, 0, 0, 100, 0), +(432010, 270, -7055.48, 579.401, 8.91715, 0, 0, 0, 0, 100, 0), +(432010, 271, -7033.3, 581.961, 7.69663, 0, 0, 0, 0, 100, 0), +(432010, 272, -7027.81, 578.488, 7.82374, 0, 0, 0, 0, 100, 0), +(432010, 273, -7003.35, 560.111, 10.0738, 0, 0, 0, 0, 100, 0), +(432010, 274, -6994.12, 555.279, 10.789, 0, 0, 0, 0, 100, 0), +(432010, 275, -6971.16, 545.977, 12.5531, 0, 0, 0, 0, 100, 0), +(432010, 276, -6963.99, 539.302, 11.223, 0, 0, 0, 0, 100, 0), +(432010, 277, -6963.99, 539.302, 11.223, 0, 0, 0, 0, 100, 0), +(432010, 278, -6951.38, 523.417, 7.45497, 0, 0, 0, 0, 100, 0), +(432010, 279, -6932.52, 525.206, 6.87967, 0, 0, 0, 0, 100, 0), +(432010, 280, -6910.77, 536.454, 5.98403, 0, 0, 0, 0, 100, 0), +(432010, 281, -6890.04, 545.287, 4.17121, 0, 0, 0, 0, 100, 0), +(432010, 282, -6866.77, 552.948, 1.73102, 0, 0, 0, 0, 100, 0), +(432010, 283, -6849.96, 556.929, -0.124853, 0, 0, 0, 0, 100, 0), +(432010, 284, -6828.53, 556.161, -1.31591, 0, 0, 0, 0, 100, 0), +(432010, 285, -6811.72, 549.231, -0.449676, 0, 0, 0, 0, 100, 0), +(432010, 286, -6805.68, 540.093, -0.889439, 0, 0, 0, 0, 100, 0), +(432010, 287, -6797.24, 517.093, -0.001643, 0, 0, 0, 0, 100, 0), +(432010, 288, -6789.19, 494.001, 3.80897, 0, 0, 0, 0, 100, 0), +(432010, 289, -6789.19, 494.001, 3.80897, 0, 0, 0, 0, 100, 0), +(432010, 290, -6782.8, 470.402, 6.88729, 0, 0, 0, 0, 100, 0), +(432010, 291, -6777.81, 448.479, 8.23635, 0, 0, 0, 0, 100, 0), +(432010, 292, -6777.81, 448.479, 8.23635, 0, 0, 0, 0, 100, 0), +(432010, 293, -6775.02, 424.207, 10.8402, 0, 0, 0, 0, 100, 0), +(432010, 294, -6772.4, 399.848, 12.9945, 0, 0, 0, 0, 100, 0), +(432010, 295, -6771.25, 375.415, 13.9048, 0, 0, 0, 0, 100, 0), +(432010, 296, -6770.56, 353.532, 12.4543, 0, 0, 0, 0, 100, 0), +(432010, 297, -6772.69, 329.132, 8.25087, 0, 0, 0, 0, 100, 0), +(432010, 298, -6772.69, 329.132, 8.25087, 0, 0, 0, 0, 100, 0), +(432010, 299, -6776.96, 305.008, 5.71315, 0, 0, 0, 0, 100, 0), +(432010, 300, -6780.88, 278.513, 4.82217, 0, 0, 0, 0, 100, 0), +(432010, 301, -6774.67, 270.074, 3.44356, 0, 0, 0, 0, 100, 0), +(432010, 302, -6774.67, 270.074, 3.44356, 0, 0, 0, 0, 100, 0), +(432010, 303, -6761.04, 254.448, 2.76589, 0, 0, 0, 0, 100, 0), +(432010, 304, -6746.12, 240.139, 3.58501, 0, 0, 0, 0, 100, 0), +(432010, 305, -6743.11, 238.827, 3.47093, 0, 0, 0, 0, 100, 0), +(432010, 306, -6723.7, 233.256, 0.354174, 0, 0, 0, 0, 100, 0), +(432010, 307, -6707.6, 234.206, 2.14407, 0, 0, 0, 0, 100, 0), +(432010, 308, -6690.34, 243.172, 3.02167, 0, 0, 0, 0, 100, 0), +(432010, 309, -6690.34, 243.172, 3.02167, 0, 0, 0, 0, 100, 0), +(432010, 310, -6673.31, 260.704, 3.89955, 0, 0, 0, 0, 100, 0), +(432010, 311, -6657.19, 279.159, 3.90556, 0, 0, 0, 0, 100, 0), +(432010, 312, -6657.19, 279.159, 3.90556, 0, 0, 0, 0, 100, 0), +(432010, 313, -6637.75, 301.124, 3.42846, 0, 0, 0, 0, 100, 0), +(432010, 314, -6616.3, 313.404, 3.37217, 0, 0, 0, 0, 100, 0), +(432010, 315, -6610.57, 314.709, 3.38045, 0, 0, 0, 0, 100, 0), +(432010, 316, -6588.86, 319.15, 2.14188, 0, 0, 0, 0, 100, 0), +(432010, 317, -6583.84, 326.755, -0.328794, 0, 0, 0, 0, 100, 0), +(432010, 318, -6583.84, 326.755, -0.328794, 0, 0, 0, 0, 100, 0), +(432010, 319, -6583.84, 326.755, -0.328794, 0, 0, 0, 0, 100, 0), +(432010, 320, -6564.96, 355.03, 3.12191, 0, 0, 0, 0, 100, 0), +(432010, 321, -6564.96, 355.03, 3.12191, 0, 0, 0, 0, 100, 0), +(432010, 322, -6564.96, 355.03, 3.12191, 0, 0, 0, 0, 100, 0), +(432010, 323, -6546.82, 371.491, 0.773827, 0, 0, 0, 0, 100, 0), +(432010, 324, -6538.95, 379.691, 2.40596, 0, 0, 0, 0, 100, 0), +(432010, 325, -6538.95, 379.691, 2.40596, 0, 0, 0, 0, 100, 0), +(432010, 326, -6522.84, 398.149, 5.48816, 0, 0, 0, 0, 100, 0), +(432010, 327, -6511.4, 411.906, 5.84552, 0, 0, 0, 0, 100, 0), +(432010, 328, -6494.62, 442.794, 5.71744, 0, 0, 0, 0, 100, 0), +(432010, 329, -6494.62, 442.794, 5.71744, 0, 0, 0, 0, 100, 0), +(432010, 330, -6480.24, 455.155, 4.56112, 0, 0, 0, 0, 100, 0), +(432010, 331, -6467.78, 463.666, 3.73075, 0, 0, 0, 0, 100, 0), +(432010, 332, -6463.69, 466.871, 2.66855, 0, 0, 0, 0, 100, 0), +(432010, 333, -6459.07, 469.336, 0.357515, 0, 0, 0, 0, 100, 0), +(432010, 334, -6452.34, 473.297, 1.23904, 0, 0, 0, 0, 100, 0), +(432010, 335, -6447.84, 477.083, 2.19392, 0, 0, 0, 0, 100, 0), +(432010, 336, -6441.07, 484.1, 3.19477, 0, 0, 0, 0, 100, 0), +(432010, 337, -6441.07, 484.1, 3.19477, 0, 0, 0, 0, 100, 0), +(432010, 338, -6422.88, 500.376, 4.78336, 0, 0, 0, 0, 100, 0), +(432010, 339, -6411.08, 510.095, 5.67832, 0, 0, 0, 0, 100, 0), +(432010, 340, -6390.46, 523.301, 6.31597, 0, 0, 0, 0, 100, 0), +(432010, 341, -6390.46, 523.301, 6.31597, 0, 0, 0, 0, 100, 0), +(432010, 342, -6370.45, 536.218, 6.39885, 0, 0, 0, 0, 100, 0); + +DELETE FROM `creature_formations` WHERE `memberGUID` IN (43201,43202,43203); +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES +(43201, 43201, 0, 0, 515), +(43201, 43202, 5, 45, 515), +(43201, 43203, 5, 315, 515); |