diff options
| -rw-r--r-- | sql/updates/world/master/2021_12_08_18_world_2019_05_29_04_world.sql | 64 |
1 files changed, 64 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_08_18_world_2019_05_29_04_world.sql b/sql/updates/world/master/2021_12_08_18_world_2019_05_29_04_world.sql new file mode 100644 index 00000000000..76738c29523 --- /dev/null +++ b/sql/updates/world/master/2021_12_08_18_world_2019_05_29_04_world.sql @@ -0,0 +1,64 @@ +-- +DELETE FROM `creature` WHERE `id` IN (22966) AND `guid` IN (107034, 107091, 107116, 107119, 107120); +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnDifficulties`, `phaseId`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES +(107034, 22966, 530, '0', 0, 1, -3522.26, 738.341, -25.4523, 3.29867, 180, 0, 0), +(107091, 22966, 530, '0', 0, 1, -3520.18, 747.038, -25.5588, 3.12458, 180, 0, 0), +(107116, 22966, 530, '0', 0, 1, -3524.67, 740.825, -24.8284, 3.12458, 180, 0, 2), +(107119, 22966, 530, '0', 0, 1, -3522.77, 743.976, -25.1917, 3.12458, 180, 0, 0), +(107120, 22966, 530, '0', 0, 1, -3518.95, 736.246, -26.1553, 3.12458, 180, 0, 0); + +DELETE FROM `creature_formations` WHERE `leaderGUID` IN (107116) AND `memberGUID`; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(107116, 107116, 0, 0, 515, 4, 21), +(107116, 107119, 3, 80, 515, 4, 21), +(107116, 107034, 3, 280, 515, 4, 21), +(107116, 107120, 5, 290, 515, 4, 21), +(107116, 107091, 5, 70, 515, 4, 21); + +DELETE FROM `creature_addon` WHERE `guid`=107116; +INSERT INTO `creature_addon` (`guid`, `mount`, `path_id`,`bytes2`) VALUES +(107116,19872,1071160,1); + +DELETE FROM `waypoint_data` WHERE `id`=1071160; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `orientation`, `delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(1071160, 1, -3544.346924, 738.908630, -18.48411, 2.649413, 0, 0, 0, 100,0), +(1071160, 2, -3557.083496, 718.876892, -12.25905, 4.440121, 0, 0, 0, 100,0), +(1071160, 3, -3561.290527, 705.239319, -9.830259, 4.534368, 0, 0, 0, 100,0), +(1071160, 4, -3560.002441, 659.057251, -0.587001, 4.618543, 0, 0, 0, 100,0), +(1071160, 5, -3562.015381, 709.829712, -10.47335, 1.586905, 0, 0, 0, 100,0), +(1071160, 6, -3557.072021, 726.534790, -13.89236, 1.198133, 0, 0, 0, 100,0), +(1071160, 7, -3529.740967, 740.475647, -23.33332, 6.237247, 0, 0, 0, 100,0), +(1071160, 8, -3486.057373, 743.447388, -34.35799, 0.075798, 0, 0, 0, 100,0), +(1071160, 9, -3433.837158, 748.860291, -33.93565, 0.103287, 0, 0, 0, 100,0), +(1071160, 10, -3386.945801, 755.229370, -33.22412, 0.075798, 0, 0, 0, 100,0), +(1071160, 11, -3355.546631, 757.324280, -28.26970, 0.083048, 0, 0, 0, 100,0), +(1071160, 12, -3308.908691, 764.899475, -22.58408, 0.169442, 0, 0, 0, 100,0), +(1071160, 13, -3274.458496, 779.707825, -19.39744, 0.220493, 0, 0, 0, 100,0), +(1071160, 14, -3253.569092, 781.860352, -19.08190, 0.102683, 0, 0, 0, 100,0), +(1071160, 15, -3218.626709, 783.026611, -19.77280, 0.012362, 0, 0, 0, 100,0), +(1071160, 16, -3195.864502, 780.622437, -20.49794, 6.228789, 0, 0, 0, 100,0), +(1071160, 17, -3166.147217, 783.096069, -21.58725, 0.083048, 0, 0, 0, 100,0), +(1071160, 18, -3136.940186, 788.566406, -22.31406, 0.185150, 0, 0, 0, 100,0), +(1071160, 19, -3122.018555, 804.972595, -22.61055, 1.528181, 0, 0, 0, 100,0), +(1071160, 20, -3112.934326, 831.376282, -21.67629, 1.300415, 0, 0, 0, 100,0), +(1071160, 21, -3100.982178, 849.321777, -21.05871, 0.982329, 0, 0, 0, 100,0), +(1071160, 22, -3112.934326, 831.376282, -21.67629, 1.300415, 0, 0, 0, 100,0), +(1071160, 23, -3122.018555, 804.972595, -22.61055, 1.528181, 0, 0, 0, 100,0), +(1071160, 24, -3136.940186, 788.566406, -22.31406, 0.185150, 0, 0, 0, 100,0), +(1071160, 25, -3166.147217, 783.096069, -21.58725, 0.083048, 0, 0, 0, 100,0), +(1071160, 26, -3195.864502, 780.622437, -20.49794, 6.228789, 0, 0, 0, 100,0), +(1071160, 27, -3218.626709, 783.026611, -19.77280, 0.012362, 0, 0, 0, 100,0), +(1071160, 28, -3253.569092, 781.860352, -19.08190, 0.102683, 0, 0, 0, 100,0), +(1071160, 29, -3274.458496, 779.707825, -19.39744, 0.220493, 0, 0, 0, 100,0), +(1071160, 30, -3308.908691, 764.899475, -22.58408, 0.169442, 0, 0, 0, 100,0), +(1071160, 31, -3355.546631, 757.324280, -28.26970, 0.083048, 0, 0, 0, 100,0), +(1071160, 32, -3386.945801, 755.229370, -33.22412, 0.075798, 0, 0, 0, 100,0), +(1071160, 33, -3433.837158, 748.860291, -33.93565, 0.103287, 0, 0, 0, 100,0), +(1071160, 34, -3486.057373, 743.447388, -34.35799, 0.075798, 0, 0, 0, 100,0), +(1071160, 35, -3529.740967, 740.475647, -23.33332, 6.237247, 0, 0, 0, 100,0), +(1071160, 36, -3557.072021, 726.534790, -13.89236, 1.198133, 0, 0, 0, 100,0), +(1071160, 37, -3562.015381, 709.829712, -10.47335, 1.586905, 0, 0, 0, 100,0), +(1071160, 38, -3560.002441, 659.057251, -0.587001, 4.618543, 0, 0, 0, 100,0), +(1071160, 39, -3561.290527, 705.239319, -9.830259, 4.534368, 0, 0, 0, 100,0), +(1071160, 40, -3557.083496, 718.876892, -12.25905, 4.440121, 0, 0, 0, 100,0), +(1071160, 41, -3544.346924, 738.908630, -18.48411, 2.649413, 0, 0, 0, 100,0); |