DB/Creature: Fix some spawns on Crystal Spine

(cherry picked from commit 1cb8f7374122ec5efa41608f1fd4f0f7a414cc0b)

1 files changed, 49 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_11_21_10_world_2019_01_12_01_world.sql b/sql/updates/world/master/2021_11_21_10_world_2019_01_12_01_world.sql
new file mode 100644
index 00000000000..41b6df6468b
--- /dev/null
+++ b/sql/updates/world/master/2021_11_21_10_world_2019_01_12_01_world.sql
@@ -0,0 +1,49 @@
+-- 
+DELETE FROM `creature` WHERE `guid` IN (77761,77762,77763,77764,77765,77766,77767,77768,77769,77770,77771,77772,77773,77774,77775,77776,77777,77778,77779,77780,77781,77782,77783,77784,77785,77786);
+DELETE FROM `creature_addon` WHERE `guid` IN (77761,77762,77763,77764,77765,77766,77767,77768,77769,77770,77771,77772,77773,77774,77775,77776,77777,77778,77779,77780,77781,77782,77783,77784,77785,77786);
+DELETE FROM `spawn_group` WHERE `spawnType`=0 AND `spawnId` IN (77761,77762,77763,77764,77765,77766,77767,77768,77769,77770,77771,77772,77773,77774,77775,77776,77777,77778,77779,77780,77781,77782,77783,77784,77785,77786);
+DELETE FROM `creature` WHERE `guid` IN (78206, 77790,77789,77788,77787, 77791,78247,78248,78249,78250,78251,78252,78253,78254,78255,78256,78257,78258,78259,78260,78261);
+DELETE FROM `creature_addon` WHERE `guid` IN (78206, 77790,77789,77788,77787, 77791,78247,78248,78249,78250,78251,78252,78253,78254,78255,78256,78257,78258,78259,78260,78261);
+DELETE FROM `spawn_group` WHERE `spawnType`=0 AND `spawnId` IN (78206, 77790,77789,77788,77787, 77791,78247,78248,78249,78250,78251,78252,78253,78254,78255,78256,78257,78258,78259,78260,78261); 
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnDifficulties`, `phaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES
+(77761, 22180, 530, '0', 0, 0, 0, 3981.956, 5249.081, 264.6908, 1.1774140, 300, 15, 0, 7181, 0, 1),
+(77762, 22180, 530, '0', 0, 0, 0, 3916.724, 5249.964, 266.5047, 5.4910770, 300, 15, 0, 7181, 0, 1),
+(77763, 22180, 530, '0', 0, 0, 0, 3948.115, 5215.917, 264.4878, 6.1804580, 300, 15, 0, 7181, 0, 1),
+(77764, 22180, 530, '0', 0, 0, 0, 3981.652, 5184.359, 265.1032, 0.2977977, 300, 15, 0, 7181, 0, 1),
+(77765, 22180, 530, '0', 0, 0, 0, 3980.714, 5100.546, 267.2501, 1.4148750, 300, 15, 0, 7181, 0, 1),
+(77766, 22180, 530, '0', 0, 0, 0, 3949.159, 4948.539, 267.8004, 0.3183079, 300, 15, 0, 7181, 0, 1),
+(77767, 22180, 530, '0', 0, 0, 0, 4015.229, 4985.836, 266.7146, 4.1626240, 300, 15, 0, 7181, 0, 1),
+(77768, 22180, 530, '0', 0, 0, 0, 3979.582, 4853.900, 267.2379, 6.2098660, 300, 15, 0, 7181, 0, 1),
+(77769, 22180, 530, '0', 0, 0, 0, 4015.782, 4885.833, 266.1422, 4.1786310, 300, 15, 0, 7181, 0, 1),
+(77770, 22180, 530, '0', 0, 0, 0, 4080.435, 5043.157, 266.2294, 2.8894350, 300, 15, 0, 7181, 0, 1),
+(77771, 22180, 530, '0', 0, 0, 0, 4015.329, 5049.436, 268.3489, 0.7155850, 300, 15, 0, 7181, 0, 1),
+(77772, 22180, 530, '0', 0, 0, 0, 4090.619, 5213.258, 265.0390, 2.2775740, 300, 15, 0, 7181, 0, 1),
+(77773, 22180, 530, '0', 0, 0, 0, 4083.265, 5382.761, 264.8060, 2.6575580, 300, 15, 0, 7181, 0, 1),
+(77774, 22181, 530, '0', 0, 0, 0, 3964.200, 5277.536, 284.495, 1.34883, 300, 10, 0, 0, 0, 1),
+(77775, 22181, 530, '0', 0, 0, 0, 3914.42, 4963.17, 278.11, 4.54688, 300, 10, 0, 0, 0, 1),
+(77776, 22181, 530, '0', 0, 0, 0, 3921.46, 4859.61, 268.40, 0.94403, 300, 10, 0, 0, 0, 1),
+(77777, 22181, 530, '0', 0, 0, 0, 4070.218, 5169.972, 297.128, 1.66695, 300, 10, 0, 0, 0, 1),
+(77778, 22181, 530, '0', 0, 0, 0, 4001.26, 5181.49, 281.25, 4.39857, 300, 10, 0, 0, 0, 1),
+(77779, 22181, 530, '0', 0, 0, 0, 3957.707, 5090.804, 298.836, 1.92479, 300, 10, 0, 0, 0, 1),
+(77780, 22181, 530, '0', 0, 0, 0, 4003.33, 5072.77, 299.66, 3.08282, 300, 10, 0, 0, 0, 1),
+(77781, 22181, 530, '0', 0, 0, 0, 4004.93, 4868.43, 279.12, 0.23275, 300, 10, 0, 0, 0, 1),
+(77782, 22181, 530, '0', 0, 0, 0, 4028.27, 5017.34, 272.31, 2.56337, 300, 10, 0, 0, 0, 1),
+(77783, 22181, 530, '0', 0, 0, 0, 4074.06, 5080.125, 302.859, 3.07678, 300, 10, 0, 0, 0, 1),
+(77784, 22181, 530, '0', 0, 0, 0, 4002.284, 5425.788, 287.479, 3.353, 300, 10, 0, 0, 0, 1),
+(77785, 22181, 530, '0', 0, 0, 0, 4065.752, 5531.675, 282.261, 0.589, 300, 10, 0, 0, 0, 1),
+(77786, 22181, 530, '0', 0, 0, 0, 3998.506, 5580.593, 300.837, 2.674, 300, 10, 0, 0, 0, 1),
+(77787, 22181, 530, '0', 0, 0, 0, 3993.243, 5694.740, 293.714, 2.587, 300, 10, 0, 0, 0, 1),
+(77788, 22181, 530, '0', 0, 0, 0, 3933.252, 5745.506, 288.675, 2.972, 300, 10, 0, 0, 0, 1),
+(77789, 22175, 530, '0', 0, 0, 0, 3921.162, 5035.858, 300.770, 3.569613, 300, 0, 0, 0, 0, 0),
+(77790, 22175, 530, '0', 0, 0, 0, 4033.197, 5195.042, 278.525, 5.270002, 300, 0, 0, 0, 0, 0),
+(77791, 22175, 530, '0', 0, 0, 0, 3968.708, 5295.452, 274.819, 6.098598, 300, 0, 0, 0, 0, 0),
+(78206, 22175, 530, '0', 0, 0, 0, 3904.207, 5366.365, 278.272, 1.150588, 300, 0, 0, 0, 0, 0),
+(78247, 22175, 530, '0', 0, 0, 0, 3998.913, 5466.808, 274.713, 1.229128, 300, 0, 0, 0, 0, 0),
+(78248, 22175, 530, '0', 0, 0, 0, 4069.118, 5657.789, 271.636, 1.401916, 300, 0, 0, 0, 0, 0),
+(78249, 22175, 530, '0', 0, 0, 0, 3987.810, 5707.203, 273.632, 2.300256, 300, 0, 0, 0, 0, 0);
+
+DELETE FROM `creature_template_addon` WHERE entry = 22180;
+INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES
+(22180, 0, 0, 0, "40773");
+
+UPDATE `creature` SET `position_x`=4031.834, `position_y`=5100.4785, `position_z`=272.756, `orientation`=5.350242 WHERE `guid`=144807;