diff options
| -rw-r--r-- | sql/updates/world/master/2021_11_21_10_world_2019_01_12_01_world.sql | 49 |
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; |