diff options
| -rw-r--r-- | sql/updates/world/master/2021_11_30_13_world_2019_04_17_00_world.sql | 95 |
1 files changed, 95 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_11_30_13_world_2019_04_17_00_world.sql b/sql/updates/world/master/2021_11_30_13_world_2019_04_17_00_world.sql new file mode 100644 index 00000000000..2bebf7a0a90 --- /dev/null +++ b/sql/updates/world/master/2021_11_30_13_world_2019_04_17_00_world.sql @@ -0,0 +1,95 @@ +-- +DELETE FROM `creature` WHERE `guid` IN (100855, 100856, 100857, 100858, 100859); +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `phaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES +(100855, 17704, 530, 0, 0, '0', 0, 0, 0, -1901.34, -11881.1, 39.2852, 2.96334, 300, 0, 0, 102, 0, 2), +(100856, 17704, 530, 0, 0, '0', 0, 0, 0, -1901.09, -11881.2, 38.7515, 3.06454, 300, 0, 0, 102, 0, 0), +(100857, 17704, 530, 0, 0, '0', 0, 0, 0, -1901.36, -11881.3, 38.9417, 3.06454, 300, 0, 0, 102, 0, 0), +(100858, 17704, 530, 0, 0, '0', 0, 0, 0, -1901.67, -11881.2, 39.2332, 3.06846, 300, 0, 0, 102, 0, 0), +(100859, 17704, 530, 0, 0, '0', 0, 0, 0, -1901.67, -11881.2, 39.2332, 3.06846, 300, 0, 0, 102, 0, 0); + +DELETE FROM `creature_formations` WHERE `leaderGUID` IN (100855, 100856, 100857, 100858, 100859) AND `memberGUID` IN(100855, 100856, 100857, 100858, 100859); +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(100855, 100855, 0, 0, 515, 0, 0), +(100855, 100856, 2, 80, 515, 0, 0), +(100855, 100857, 2, 280, 515, 0, 0), +(100855, 100858, 4, 290, 515, 0, 0), +(100855, 100859, 4, 70, 515, 0, 0); + +DELETE FROM `creature_addon` WHERE `guid`=100855; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`) VALUES +(100855,1008550,1); + +DELETE FROM `waypoint_data` WHERE `id`=1008550; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `orientation`, `delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(1008550, 1, -1919.71, -11878.5, 43.9417, 3.05366, 2000, 0, 0, 100,0), +(1008550, 2, -1932.5, -11871.9, 48.3816, 2.41749,0, 0, 0, 100,0), +(1008550, 3, -1943.91, -11863.3, 50.3332, 2.50781,0, 0, 0, 100,0), +(1008550, 4, -1957.58, -11854.4, 50.4065, 2.78663,0, 0, 0, 100,0), +(1008550, 5, -1965.31, -11852.6, 49.8413, 3.18718,0, 0, 0, 100,0), +(1008550, 6, -1980.63, -11856, 48.0117, 3.28528,0, 0, 0, 100,0), +(1008550, 7, -1997.15, -11857.4, 47.2336, 2.94206,0, 0, 0, 100,0), +(1008550, 8, -2019.49, -11853.8, 46.9228, 2.98133,0, 0, 0, 100,0), +(1008550, 9, -2034.37, -11851.7, 47.2372, 2.67345,0, 0, 0, 100,0), +(1008550, 10, -2044.4, -11846.3, 47.7605, 2.19828,0, 0, 0, 100,0), +(1008550, 11, -2050.89, -11829.3, 47.7391, 1.86894,0, 0, 0, 100,0), +(1008550, 12, -2056.33, -11809.5, 46.1639, 1.71971,0, 0, 0, 100,0), +(1008550, 13, -2059.23, -11783.7, 45.9743, 1.58619,0, 0, 0, 100,0), +(1008550, 14, -2056.36, -11770.6, 46.2552, 0.63979,0, 0, 0, 100,0), +(1008550, 15, -2043.51, -11763.3, 51.9919, 0.467002,0, 0, 0, 100,0), +(1008550, 16, -2030.85, -11756.1, 51.6225, 0.816504,0, 0, 0, 100,0), +(1008550, 17, -2025.79, -11739.8, 49.4705, 0.969657,0, 0, 0, 100,0), +(1008550, 18, -2018.75, -11731.5, 47.7727, 0.628009,0, 0, 0, 100,0), +(1008550, 19, -2011.27, -11726.2, 45.5089, 0.367257,0, 0, 0, 100,0), +(1008550, 20, -1996.45, -11721.2, 46.9958, 0.312279,0, 0, 0, 100,0), +(1008550, 21, -1966.27, -11695.8, 40.323, 1.67495,0, 0, 0, 100,0), +(1008550, 22, -1968.31, -11664.4, 40.3921, 1.53357,0, 0, 0, 100,0), +(1008550, 23, -1967.33, -11639.4, 43.4553, 1.47467,0, 0, 0, 100,0), +(1008550, 24, -1965.45, -11625.4, 49.0818, 1.44325,0, 0, 0, 100,0), +(1008550, 25, -1961.99, -11585.6, 46.1863, 1.56106,0, 0, 0, 100,0), +(1008550, 26, -1960.29, -11556.9, 54.8725, 1.26654,0, 0, 0, 100,0), +(1008550, 27, -1948.57, -11522.8, 54.7186, 0.495274,0, 0, 0, 100,0), +(1008550, 28, -1915.01, -11500.5, 51.5661, 6.23968,0, 0, 0, 100,0), +(1008550, 29, -1887.56, -11492.9, 49.9166, 0.347618,0, 0, 0, 100,0), +(1008550, 30, -1855.26, -11476.2, 46.8787, 0.485063,0, 0, 0, 100,0), +(1008550, 31, -1831.17, -11463, 46.1476, 0.540041,0, 0, 0, 100,0), +(1008550, 32, -1815.46, -11455.4, 46.5529, 6.04411,0, 0, 0, 100,0), +(1008550, 33, -1803.95, -11465.8, 45.0146, 5.04823,0, 0, 0, 100,0), +(1008550, 34, -1801.89, -11482.8, 39.0529, 4.62806,0, 0, 0, 100,0), +(1008550, 35, -1809.38, -11515.8, 35.5228, 4.60057,0, 0, 0, 100,0), +(1008550, 36, -1805.72, -11526.2, 36.5808, 5.40795,0, 0, 0, 100,0), +(1008550, 37, -1789.44, -11548.4, 35.0002, 5.3624,0, 0, 0, 100,0), +(1008550, 38, -1777.65, -11563.1, 35.2212, 5.42523,0, 0, 0, 100,0), +(1008550, 39, -1771.04, -11572.8, 36.1952, 4.81105,0, 0, 0, 100,0), +(1008550, 40, -1771.71, -11584.3, 36.0952, 4.23144,0, 0, 0, 100,0), +(1008550, 41, -1785.03, -11607.7, 35.6682, 4.18431,0, 0, 0, 100,0), +(1008550, 42, -1798.6, -11621.4, 34.424, 3.60705,0, 0, 0, 100,0), +(1008550, 43, -1825.18, -11630.9, 35.6892, 3.66202,0, 0, 0, 100,0), +(1008550, 44, -1837.24, -11645.1, 36.076, 4.44741,0, 0, 0, 100,0), +(1008550, 45, -1835.07, -11663.1, 35.1535, 5.35883,0, 0, 0, 100,0), +(1008550, 46, -1822.54, -11671.7, 34.7502, 5.88896,0, 0, 0, 100,0), +(1008550, 47, -1790, -11671.4, 34.9058, 6.0963,0, 0, 0, 100,0), +(1008550, 48, -1782.02, -11675.5, 34.8924, 5.57873,0, 0, 0, 100,0), +(1008550, 49, -1773.67, -11676.2, 34.9571, 0.206602,0, 0, 0, 100,0), +(1008550, 50, -1756.83, -11669.9, 33.831, 0.155551,0, 0, 0, 100,0), +(1008550, 51, -1739.46, -11667.1, 35.6339, 0.155551,0, 0, 0, 100,0), +(1008550, 52, -1719.49, -11658.3, 36.1233, 0.50898,0, 0, 0, 100,0), +(1008550, 53, -1704.09, -11648.9, 35.0948, 0.157907,0, 0, 0, 100,0), +(1008550, 54, -1694.88, -11648.5, 35.5366, 5.99012,0, 0, 0, 100,0), +(1008550, 55, -1681.53, -11661.8, 38.7423, 5.2008,0, 0, 0, 100,0), +(1008550, 56, -1676.28, -11680, 41.0487, 4.90628,0, 0, 0, 100,0), +(1008550, 57, -1676.31, -11701.4, 38.9257, 4.33295,0, 0, 0, 100,0), +(1008550, 58, -1683.13, -11714.1, 36.278, 4.34866,0, 0, 0, 100,0), +(1008550, 59, -1691.73, -11739.6, 31.2819, 4.15859,0, 0, 0, 100,0), +(1008550, 60, -1703.01, -11757.7, 28.8242, 4.08241,0, 0, 0, 100,0), +(1008550, 61, -1714.62, -11767.8, 27.8882, 3.73684,0, 0, 0, 100,0), +(1008550, 62, -1733.62, -11774.8, 27.5277, 3.46587,0, 0, 0, 100,0), +(1008550, 63, -1758.87, -11783.1, 27.0512, 3.50122,0, 0, 0, 100,0), +(1008550, 64, -1771.36, -11790.2, 27.3073, 3.78317,0, 0, 0, 100,0), +(1008550, 65, -1790.91, -11811.1, 27.176, 3.94811,0, 0, 0, 100,0), +(1008550, 66, -1805.93, -11826.5, 26.9529, 3.80674,0, 0, 0, 100,0), +(1008550, 67, -1823.29, -11842.4, 27.4183, 3.92847,0, 0, 0, 100,0), +(1008550, 68, -1836.52, -11855.8, 28.1996, 3.99131,0, 0, 0, 100,0), +(1008550, 69, -1849.44, -11869.2, 29.6033, 3.83423,0, 0, 0, 100,0), +(1008550, 70, -1862.36, -11876.8, 31.401, 3.43367,0, 0, 0, 100,0), +(1008550, 71, -1878.68, -11880.4, 34.0545, 3.14307, 2000, 0, 0, 100,0), +(1008550, 72, -1899.24, -11880.4, 38.6422, 3.06846,0, 0, 0, 100,0); |