diff options
| -rw-r--r-- | sql/updates/world/master/2022_02_27_01_world_2020_09_18_04_world.sql | 95 |
1 files changed, 95 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_02_27_01_world_2020_09_18_04_world.sql b/sql/updates/world/master/2022_02_27_01_world_2020_09_18_04_world.sql new file mode 100644 index 00000000000..a0d409a4083 --- /dev/null +++ b/sql/updates/world/master/2022_02_27_01_world_2020_09_18_04_world.sql @@ -0,0 +1,95 @@ +-- Waypoints for some creatures are still missing, formations requires adjustments +-- Creatures: 83315, 83344, 83329, 91202 +DELETE FROM `creature_formations` WHERE `leaderGUID` IN (83301,83320,91215,91240,91172); +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(83301,83301,0,0,515,0,0), +(83301,83302,3,270,515,7,12), +(83320,83320,0,0,515,0,0), +(83320,83315,4,270,515,0,0), +(91215,91215,0,0,515,0,0), +(91215,91216,5,270,515,3,6), +(91240,91240,0,0,515,0,0), +(91240,91241,5,270,515,2,4), +(91172,91172,0,0,515,0,0), +(91172,91173,3,270,515,0,0); + +UPDATE `creature` SET `position_x` = -72.43526, `position_y` = -17.8413, `position_z` = -0.87099, `orientation` = 0.80285 WHERE `guid` = 83301; +UPDATE `creature` SET `position_x` = -67.27693, `position_y` = -18.9735, `position_z` = -0.871, `orientation` = 2.72743 WHERE `guid` = 83302; +UPDATE `creature` SET `position_x` = -204.871, `position_y` = -214.858, `position_z` = 0.2629 WHERE `guid` = 83346; +UPDATE `creature` SET `position_x` = -260.558, `position_y` = -185.374, `position_z` = -0.62035 WHERE `guid` = 91185; +UPDATE `creature` SET `position_x` = -374.752, `position_y` = -176.951, `position_z` = -0.95391 WHERE `guid` = 91172; +-- Only random movement +UPDATE `creature` SET `wander_distance` = 5, `MovementType` = 1 WHERE `guid` = 91235; +DELETE FROM `creature_addon` WHERE `guid` = 91235; + +DELETE FROM `waypoint_data` WHERE `id` IN (833010,912150,912400,911600,833460,911850,911720,912350,912340,912010,911940); +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES +(833010,1,-67.99796,-31.6907,-0.9516085), +(833010,2,-67.722946,-23.282206,-0.952602), +(833010,3,-65.677895,-14.919224,-0.9472823), +(833010,4,-60.18082,-8.535985,-0.9498009), +(833010,5,-53.91151,-2.550814,-0.9489453), +(833010,6,-46.68223,0.860986,-0.954333), +(833010,7,-36.528965,1.502573,-0.95433265), +(833010,8,-46.68223,0.860986,-0.954333), +(833010,9,-53.91151,-2.550814,-0.9489453), +(833010,10,-60.18082,-8.535985,-0.9498009), +(833010,11,-65.677895,-14.919224,-0.9472823), +(833010,12,-67.722946,-23.282206,-0.952602), +(912150,1,-118.24131,-209.97723,-0.6744513), +(912150,2,-136.36037,-214.06665,-0.4485481), +(912150,3,-143.3705,-220.97308,-0.53293836), +(912150,4,-136.36037,-214.06665,-0.4485481), +(912150,5,-118.24131,-209.97723,-0.6744513), +(912150,6,-111.1761,-219.2728,-0.15511769), +(912400,1,-49.952377,-221.03786,-0.06442847), +(912400,2,-73.87033,-218.72505,-0.17712471), +(912400,3,-49.952377,-221.03786,-0.06442847), +(912400,4,-32.762417,-223.56038,-0.17517339), +(911600,1,-106.17904,-213.0709,-1.1736038), +(911600,2,-98.29801,-220.66646,-1.0128464), +(911600,3,-90.19468,-229.46202,0.22722928), +(911600,4,-81.76385,-235.159,-0.0013113776), +(911600,5,-90.19468,-229.46202,0.22722928), +(911600,6,-98.29801,-220.66646,-1.0128464), +(911600,7,-106.17904,-213.0709,-1.1736038), +(911600,8,-115.79944,-204.35925,-1.289422), +(833460,1,-203.31392,-226.93602,-0.9557935), +(833460,2,-204.53967,-238.08087,-0.9558625), +(833460,3,-212.76714,-245.90474,-0.9559642), +(833460,4,-204.53967,-238.08087,-0.9558625), +(833460,5,-203.31392,-226.93602,-0.9557935), +(833460,6,-204.87102,-214.85806,0.26295376), +(911850,1,-267.18024,-183.95139,-0.61404943), +(911850,2,-272.5438,-177.76714,-1.0101689), +(911850,3,-275.6246,-167.48929,-2.2277827), +(911850,4,-271.68774,-159.06718,-2.3313134), +(911850,5,-275.6246,-167.48929,-2.2277827), +(911850,6,-272.5438,-177.76714,-1.0101689), +(911850,7,-267.18024,-183.95139,-0.61404943), +(911850,8,-260.55893,-185.37411,-0.6203554), +(911720,1,-365.67285,-175.00563,-0.95876896), +(911720,2,-360.13977,-165.7273,-0.99950916), +(911720,3,-363.37717,-158.51936,-0.95876485), +(911720,4,-370.46817,-152.6236,-0.9587616), +(911720,5,-378.27777,-155.3499,-0.9587638), +(911720,6,-383.9432,-171.95404,-0.9587667), +(911720,7,-374.7526,-176.95155,-0.95391774), +(912340,1,-374.06653,-56.737812,-0.98709744), +(912340,2,-380.67374,-61.6305,-0.9587699), +(912340,3,-384.3248,-69.727554,-0.95876795), +(912340,4,-380.67374,-61.6305,-0.9587699), +(912340,5,-374.06653,-56.737812,-0.98709744), +(912340,6,-365.25406,-58.696316,-0.9375797), +(912340,7,-360.66693,-67.70981,-0.9587661), +(912340,8,-365.2416,-58.720757,-0.95876634), +(912010,1,-286.58047,2.692342,16.787771), +(912010,2,-286.7902,15.48573,18.410303), +(912010,3,-275.94824,25.733856,22.140972), +(912010,4,-286.72964,15.542957,18.451094), +(912010,5,-286.58047,2.692342,16.787771), +(912010,6,-283.24155,-4.0018206,16.685318), +(911940,1,-231.31323,9.442994,16.808558), +(911940,2,-214.384,9.683906,16.860193), +(911940,3,-231.31323,9.442994,16.808558), +(911940,4,-246.6945,9.225361,16.794338); |