diff options
| -rw-r--r-- | sql/updates/world/master/2022_01_24_12_world_2020_07_31_13_world.sql | 120 |
1 files changed, 120 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_24_12_world_2020_07_31_13_world.sql b/sql/updates/world/master/2022_01_24_12_world_2020_07_31_13_world.sql new file mode 100644 index 00000000000..d0281c3893a --- /dev/null +++ b/sql/updates/world/master/2022_01_24_12_world_2020_07_31_13_world.sql @@ -0,0 +1,120 @@ +-- Remove all wps from non-leaders +DELETE FROM `creature_addon` WHERE `guid` IN (53026,48395,48373,48161,48195,48392,48398,48393,48359); +DELETE FROM `creature_formations` WHERE `leaderGUID` IN (48194,48397,48396); +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(48194,48194,0,0,515,0,0), +(48194,48359,2,360,515,12,26), +(48194,48393,2,120,515,12,26), +(48194,48398,2,240,515,12,26), +(48397,48397,0,0,515,0,0), +(48397,48392,2,360,515,15,32), +(48397,48195,2,120,515,15,32), +(48397,48161,2,240,515,15,32), +(48396,48396,0,0,515,0,0), +(48396,48373,2,360,515,15,30), +(48396,48395,2,120,515,15,30), +(48396,53026,2,240,515,15,30); + +UPDATE `creature` SET `position_x` = 1611.243, `position_y` = 1054.284, `position_z` = 35.79039, `orientation` = 1.579244 WHERE `guid` = 48397; +UPDATE `creature` SET `position_x` = 1609.562, `position_y` = 1048.224, `position_z` = 35.76407, `orientation` = 1.579241 WHERE `guid` = 48161; +UPDATE `creature` SET `position_x` = 1613.026, `position_y` = 1048.253, `position_z` = 35.76405, `orientation` = 1.579236 WHERE `guid` = 48195; +UPDATE `creature` SET `position_x` = 1611.269, `position_y` = 1051.238, `position_z` = 35.69367, `orientation` = 1.579241 WHERE `guid` = 48392; +UPDATE `creature` SET `position_x` = 1646.127, `position_y` = 975.6876, `position_z` = 16.0957, `orientation` = 1.561919 WHERE `guid` = 48194; +UPDATE `creature` SET `position_x` = 1644.34, `position_y` = 969.4986, `position_z` = 16.10431, `orientation` = 1.767221 WHERE `guid` = 48398; +UPDATE `creature` SET `position_x` = 1647.804, `position_y` = 969.4678, `position_z` = 16.10431, `orientation` = 1.750014 WHERE `guid` = 48393; +UPDATE `creature` SET `position_x` = 1644.34, `position_y` = 969.4986, `position_z` = 16.10431, `orientation` = 1.767221 WHERE `guid` = 48359; +UPDATE `creature` SET `position_x` = 1769.404, `position_y` = 836.6418, `position_z` = 35.42621, `orientation` = 3.41411 WHERE `guid` = 48396; +UPDATE `creature` SET `position_x` = 1779.512, `position_y` = 837.6188, `position_z` = 36.33966, `orientation` = 5.984658 WHERE `guid` = 53026; +UPDATE `creature` SET `position_x` = 1773.624, `position_y` = 839.6193, `position_z` = 36.33966, `orientation` = 2.816358 WHERE `guid` = 48395; +UPDATE `creature` SET `position_x` = 1771.42, `position_y` = 837.2551, `position_z` = 35.5854, `orientation` = 3.610206 WHERE `guid` = 48373; + +DELETE FROM `waypoint_data` WHERE `id` IN (530260,483950,483730,483960,481610,481950,483920,483970,483980,483930,483590,481940); +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES +(483970, 1, 1612.504, 1069.74, 36.54088), +(483970, 2, 1623.098, 1084.906, 38.59561), +(483970, 3, 1636.604, 1093.099, 41.89016), +(483970, 4, 1646.123, 1094.137, 44.31969), +(483970, 5, 1662.944, 1095.168, 47.95127), +(483970, 6, 1680.21, 1095.865, 51.14401), +(483970, 7, 1689.766, 1096.077, 52.76806), +(483970, 8, 1706.036, 1095.975, 52.78514), +(483970, 9, 1722.817, 1095.916, 52.76872), +(483970, 10, 1737.716, 1094.958, 50.69076), +(483970, 11, 1758.963, 1094.388, 46.62092), +(483970, 12, 1776.157, 1091.317, 42.73067), +(483970, 13, 1795.451, 1079.286, 37.95823), +(483970, 14, 1802.001, 1065.321, 36.41524), +(483970, 15, 1803.239, 1049.792, 35.75908), +(483970, 16, 1802.001, 1065.321, 36.41524), +(483970, 17, 1795.451, 1079.286, 37.95823), +(483970, 18, 1776.157, 1091.317, 42.73067), +(483970, 19, 1759.162, 1094.353, 46.57588), +(483970, 20, 1737.716, 1094.958, 50.69076), +(483970, 21, 1722.817, 1095.916, 52.76872), +(483970, 22, 1706.036, 1095.975, 52.78514), +(483970, 23, 1689.766, 1096.077, 52.76806), +(483970, 24, 1680.21, 1095.865, 51.14401), +(483970, 25, 1662.944, 1095.168, 47.95127), +(483970, 26, 1646.288, 1094.155, 44.35245), +(483970, 27, 1636.604, 1093.099, 41.89016), +(483970, 28, 1623.098, 1084.906, 38.59561), +(483970, 29, 1612.504, 1069.74, 36.54088), +(483970, 30, 1611.199, 1059.485, 35.99176), +(483970, 31, 1611.313, 1049.952, 35.64724), +(483970, 32, 1611.199, 1059.485, 35.99176), +(481940, 1, 1647.324, 996.7984, 16.10431), +(481940, 2, 1651.942, 1013.945, 16.11007), +(481940, 3, 1657.114, 1022.965, 16.11007), +(481940, 4, 1662.921, 1031.976, 16.11007), +(481940, 5, 1671.689, 1044.911, 16.11073), +(481940, 6, 1688.925, 1056.034, 16.11073), +(481940, 7, 1698.74, 1058.056, 18.02951), +(481940, 8, 1712.989, 1058.221, 18.02951), +(481940, 9, 1732.618, 1055.407, 16.11051), +(481940, 10, 1743.39, 1041.823, 16.10991), +(481940, 11, 1756.496, 1019.775, 16.11079), +(481940, 12, 1776.512, 986.125, 16.11079), +(481940, 13, 1756.496, 1019.775, 16.11079), +(481940, 14, 1743.39, 1041.823, 16.10991), +(481940, 15, 1732.618, 1055.407, 16.11051), +(481940, 16, 1712.989, 1058.221, 18.02951), +(481940, 17, 1698.74, 1058.056, 18.02951), +(481940, 18, 1688.925, 1056.034, 16.11073), +(481940, 19, 1671.689, 1044.911, 16.11073), +(481940, 20, 1662.921, 1031.976, 16.11007), +(481940, 21, 1657.114, 1022.965, 16.11007), +(481940, 22, 1651.942, 1013.945, 16.11007), +(481940, 23, 1647.324, 996.7984, 16.10431), +(481940, 24, 1646.149, 978.1148, 16.10431), +(481940, 25, 1646.284, 964.768, 16.1043), +(481940, 26, 1646.149, 978.1148, 16.10431), +(483960, 1, 1752.846, 836.4012, 33.92809), +(483960, 2, 1733.849, 836.577, 33.92806), +(483960, 3, 1714.563, 836.6511, 35.55497), +(483960, 4, 1694.059, 837.0853, 35.56247), +(483960, 5, 1658.319, 838.1326, 33.92808), +(483960, 6, 1637.456, 838.439, 35.3343), +(483960, 7, 1624.532, 840.1978, 36.07137), +(483960, 8, 1617.169, 849.7756, 36.07135), +(483960, 9, 1610.096, 858.7788, 36.07133), +(483960, 10, 1607.275, 866.5177, 36.33961), +(483960, 11, 1606.87, 884.1786, 35.57532), +(483960, 12, 1606.955, 907.5817, 35.57426), +(483960, 13, 1607.656, 933.418, 35.57269), +(483960, 14, 1608.352, 957.584, 35.57119), +(483960, 15, 1608.94, 987.1241, 35.57898), +(483960, 16, 1608.352, 957.584, 35.57119), +(483960, 17, 1607.656, 933.418, 35.57269), +(483960, 18, 1606.955, 907.5817, 35.57426), +(483960, 19, 1606.87, 884.1786, 35.57532), +(483960, 20, 1607.275, 866.5177, 36.33961), +(483960, 21, 1610.096, 858.7788, 36.07133), +(483960, 22, 1617.169, 849.7756, 36.07135), +(483960, 23, 1624.486, 840.2041, 36.07137), +(483960, 24, 1637.412, 838.4397, 35.4757), +(483960, 25, 1658.319, 838.1326, 33.92808), +(483960, 26, 1694.059, 837.0853, 35.56247), +(483960, 27, 1714.563, 836.6511, 35.55497), +(483960, 28, 1733.849, 836.577, 33.92806), +(483960, 29, 1752.846, 836.4012, 33.92809), +(483960, 30, 1768.207, 836.3605, 35.1517); |