DB/GameObject: Add 58 More Netherwing Eggs

Closes #24688

1 files changed, 122 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2020_05_25_01_world.sql b/sql/updates/world/3.3.5/2020_05_25_01_world.sql
new file mode 100644
index 00000000000..9621bfdedc4
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_05_25_01_world.sql
@@ -0,0 +1,122 @@
+-- 
+DELETE FROM `pool_members` WHERE `poolSpawnId`=762 AND `spawnid` IN (6974, 6976, 6991, 6995, 7003, 7005, 7006, 7009, 9492, 9493, 9497, 9500, 9502, 9503, 9504, 9505, 9506, 9509, 9510, 9511, 9513, 9514, 9515, 9516, 9517, 9519, 9521, 9523, 9524, 9526, 9528, 9529, 9530, 9532, 9537, 9540, 9541, 9544, 9546, 9547, 9548, 9550, 9551, 9552, 9554, 9555, 9557, 9558, 9559, 9560, 9561, 9563, 9567, 9569, 9570, 9572, 9574, 9576);
+INSERT INTO `pool_members` (`type`, `spawnId`, `poolSpawnId`, `chance`, `description`) VALUES 
+(1, 6974, 762, 0, 'Netherwing Egg'),
+(1, 6976, 762, 0, 'Netherwing Egg'),
+(1, 6991, 762, 0, 'Netherwing Egg'),
+(1, 6995, 762, 0, 'Netherwing Egg'),
+(1, 7003, 762, 0, 'Netherwing Egg'),
+(1, 7005, 762, 0, 'Netherwing Egg'),
+(1, 7006, 762, 0, 'Netherwing Egg'),
+(1, 7009, 762, 0, 'Netherwing Egg'),
+(1, 9492, 762, 0, 'Netherwing Egg'),
+(1, 9493, 762, 0, 'Netherwing Egg'),
+(1, 9497, 762, 0, 'Netherwing Egg'),
+(1, 9500, 762, 0, 'Netherwing Egg'),
+(1, 9502, 762, 0, 'Netherwing Egg'),
+(1, 9503, 762, 0, 'Netherwing Egg'),
+(1, 9504, 762, 0, 'Netherwing Egg'),
+(1, 9505, 762, 0, 'Netherwing Egg'),
+(1, 9506, 762, 0, 'Netherwing Egg'),
+(1, 9509, 762, 0, 'Netherwing Egg'),
+(1, 9510, 762, 0, 'Netherwing Egg'),
+(1, 9511, 762, 0, 'Netherwing Egg'),
+(1, 9513, 762, 0, 'Netherwing Egg'),
+(1, 9514, 762, 0, 'Netherwing Egg'),
+(1, 9515, 762, 0, 'Netherwing Egg'),
+(1, 9516, 762, 0, 'Netherwing Egg'),
+(1, 9517, 762, 0, 'Netherwing Egg'),
+(1, 9519, 762, 0, 'Netherwing Egg'),
+(1, 9521, 762, 0, 'Netherwing Egg'),
+(1, 9523, 762, 0, 'Netherwing Egg'),
+(1, 9524, 762, 0, 'Netherwing Egg'),
+(1, 9526, 762, 0, 'Netherwing Egg'),
+(1, 9528, 762, 0, 'Netherwing Egg'),
+(1, 9529, 762, 0, 'Netherwing Egg'),
+(1, 9530, 762, 0, 'Netherwing Egg'),
+(1, 9532, 762, 0, 'Netherwing Egg'),
+(1, 9537, 762, 0, 'Netherwing Egg'),
+(1, 9540, 762, 0, 'Netherwing Egg'),
+(1, 9541, 762, 0, 'Netherwing Egg'),
+(1, 9544, 762, 0, 'Netherwing Egg'),
+(1, 9546, 762, 0, 'Netherwing Egg'),
+(1, 9547, 762, 0, 'Netherwing Egg'),
+(1, 9548, 762, 0, 'Netherwing Egg'),
+(1, 9550, 762, 0, 'Netherwing Egg'),
+(1, 9551, 762, 0, 'Netherwing Egg'),
+(1, 9552, 762, 0, 'Netherwing Egg'),
+(1, 9554, 762, 0, 'Netherwing Egg'),
+(1, 9555, 762, 0, 'Netherwing Egg'),
+(1, 9557, 762, 0, 'Netherwing Egg'),
+(1, 9558, 762, 0, 'Netherwing Egg'),
+(1, 9559, 762, 0, 'Netherwing Egg'),
+(1, 9560, 762, 0, 'Netherwing Egg'),
+(1, 9561, 762, 0, 'Netherwing Egg'),
+(1, 9563, 762, 0, 'Netherwing Egg'),
+(1, 9567, 762, 0, 'Netherwing Egg'),
+(1, 9569, 762, 0, 'Netherwing Egg'),
+(1, 9570, 762, 0, 'Netherwing Egg'),
+(1, 9572, 762, 0, 'Netherwing Egg'),
+(1, 9574, 762, 0, 'Netherwing Egg'),
+(1, 9576, 762, 0, 'Netherwing Egg');
+
+DELETE FROM `gameobject` WHERE `id`=185915 AND `guid` IN (6974, 6976, 6991, 6995, 7003, 7005, 7006, 7009, 9492, 9493, 9497, 9500, 9502, 9503, 9504, 9505, 9506, 9509, 9510, 9511, 9513, 9514, 9515, 9516, 9517, 9519, 9521, 9523, 9524, 9526, 9528, 9529, 9530, 9532, 9537, 9540, 9541, 9544, 9546, 9547, 9548, 9550, 9551, 9552, 9554, 9555, 9557, 9558, 9559, 9560, 9561, 9563, 9567, 9569, 9570, 9572, 9574, 9576);; -- And insert 58 missing sniffed spawns
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES 
+(6974, 185915, 530, 1, -5448.83, -24.3292, 110.702, 2.00713, 0, 0, 0.843391, 0.5373, 3600, 255, 1),
+(6976, 185915, 530, 1, -5418.63, 477.225, 46.6154, 2.47837, 0, 0, 0.945518, 0.325568, 3600, 255, 1),
+(6991, 185915, 530, 1, -5397.3, 612.787, 85.1582, 3.927, 0, 0, -0.923879, 0.382686, 3600, 255, 1),
+(6995, 185915, 530, 1, -5308.35, 57.9292, 110.024, 1.11701, 0, 0, 0.529919, 0.848048, 3600, 255, 1),
+(7003, 185915, 530, 1, -5303.76, 544.032, 34.0402, 2.42601, 0, 0, 0.936672, 0.350207, 3600, 255, 1),
+(7005, 185915, 530, 1, -5238, 137.927, -13.1254, 3.927, 0, 0, -0.923879, 0.382686, 3600, 255, 1),
+(7006, 185915, 530, 1, -5228.35, 798.669, 173.603, 3.00195, 0, 0, 0.997563, 0.0697661, 3600, 255, 1),
+(7009, 185915, 530, 1, -5215.15, 322.214, 123.416, 3.08918, 0, 0, 0.999657, 0.0262017, 3600, 255, 1),
+(9492, 185915, 530, 1, -5189.28, 123.318, -11.8921, 5.46288, 0, 0, -0.398748, 0.91706, 3600, 255, 1),
+(9493, 185915, 530, 1, -5182.99, 424.538, -10.4361, 0.226893, 0, 0, 0.113203, 0.993572, 3600, 255, 1),
+(9497, 185915, 530, 1, -5179.29, 363.463, -20.2674, 0.0698117, 0, 0, 0.0348988, 0.999391, 3600, 255, 1),
+(9500, 185915, 530, 1, -5174.38, -152.213, 51.7318, 2.56563, 0, 0, 0.958819, 0.284016, 3600, 255, 1),
+(9502, 185915, 530, 1, -5164.58, 615.068, 36.5102, 1.69297, 0, 0, 0.748956, 0.66262, 3600, 255, 1),
+(9503, 185915, 530, 1, -5152.54, 707.566, 43.6404, 4.04917, 0, 0, -0.898793, 0.438373, 3600, 255, 1),
+(9504, 185915, 530, 1, -5149.71, 671.502, 41.1243, 1.43117, 0, 0, 0.656058, 0.75471, 3600, 255, 1),
+(9505, 185915, 530, 1, -5136.7, 353.425, -18.5068, 5.61996, 0, 0, -0.325567, 0.945519, 3600, 255, 1),
+(9506, 185915, 530, 1, -5117.88, 294.901, 159.32, 1.15192, 0, 0, 0.544639, 0.838671, 3600, 255, 1),
+(9509, 185915, 530, 1, -5117.35, -109.776, 68.2887, 4.97419, 0, 0, -0.608761, 0.793354, 3600, 255, 1),
+(9510, 185915, 530, 1, -5109.37, 524.847, -10.3982, 4.85202, 0, 0, -0.656058, 0.75471, 3600, 255, 1),
+(9511, 185915, 530, 1, -5100.64, 166.182, -8.61069, 3.61284, 0, 0, -0.972369, 0.233448, 3600, 255, 1),
+(9513, 185915, 530, 1, -5096.4, -29.9565, 169.821, 0.418879, 0, 0, 0.207912, 0.978148, 3600, 255, 1),
+(9514, 185915, 530, 1, -5095.69, 641.456, 32.7262, 2.79252, 0, 0, 0.984807, 0.173652, 3600, 255, 1),
+(9515, 185915, 530, 1, -5093.74, 439.616, -5.25503, 5.8294, 0, 0, -0.224951, 0.97437, 3600, 255, 1),
+(9516, 185915, 530, 1, -5089.8, 336.709, 4.87949, 4.41568, 0, 0, -0.803857, 0.594823, 3600, 255, 1),
+(9517, 185915, 530, 1, -5084.45, 139.49, 130.919, 0.645772, 0, 0, 0.317305, 0.948324, 3600, 255, 1),
+(9519, 185915, 530, 1, -5080.83, 491.369, -9.40129, 0.383971, 0, 0, 0.190808, 0.981627, 3600, 255, 1),
+(9521, 185915, 530, 1, -5071.84, 663.63, 33.1395, 1.90241, 0, 0, 0.814116, 0.580703, 3600, 255, 1),
+(9523, 185915, 530, 1, -5068.72, 178.252, -8.99214, 0.436332, 0, 0, 0.216439, 0.976296, 3600, 255, 1),
+(9524, 185915, 530, 1, -5061.81, 640.964, 29.3313, 6.03884, 0, 0, -0.121869, 0.992546, 3600, 255, 1),
+(9526, 185915, 530, 1, -5055.72, 623.2, 89.5802, 0.0174525, 0, 0, 0.00872612, 0.999962, 3600, 255, 1),
+(9528, 185915, 530, 1, -5053.39, 312.4, 5.84981, 5.20108, 0, 0, -0.515037, 0.857168, 3600, 255, 1),
+(9529, 185915, 530, 1, -5039.54, 415.692, -10.7986, 5.5676, 0, 0, -0.350207, 0.936672, 3600, 255, 1),
+(9530, 185915, 530, 1, -5026.72, 347.3, 170.65, 4.71239, 0, 0, -0.707107, 0.707107, 3600, 255, 1),
+(9532, 185915, 530, 1, -5023.42, 589.374, 163.848, 1.83259, 0, 0, 0.793353, 0.608762, 3600, 255, 1),
+(9537, 185915, 530, 1, -5019.65, 654.349, 23.1631, 5.75959, 0, 0, -0.258819, 0.965926, 3600, 255, 1),
+(9540, 185915, 530, 1, -5017.84, 232.669, 109.655, 4.95674, 0, 0, -0.615661, 0.788011, 3600, 255, 1),
+(9541, 185915, 530, 1, -5013.82, 447.382, 17.7421, 1.91986, 0, 0, 0.819152, 0.573577, 3600, 255, 1),
+(9544, 185915, 530, 1, -5012.23, 435.849, -8.50751, 1.98967, 0, 0, 0.83867, 0.54464, 3600, 255, 1),
+(9546, 185915, 530, 1, -4996.78, 669.637, 23.5955, 0.523598, 0, 0, 0.258819, 0.965926, 3600, 255, 1),
+(9547, 185915, 530, 1, -4993.62, 157.017, -14.6653, 5.55015, 0, 0, -0.358368, 0.933581, 3600, 255, 1),
+(9548, 185915, 530, 1, -4987.07, 735.798, 81.0512, 1.93731, 0, 0, 0.824125, 0.566408, 3600, 255, 1),
+(9550, 185915, 530, 1, -4972.33, 87.7207, 61.2606, 1.22173, 0, 0, 0.573576, 0.819152, 3600, 255, 1),
+(9551, 185915, 530, 1, -4971.98, 487.725, 5.24322, 4.57276, 0, 0, -0.754709, 0.656059, 3600, 255, 1),
+(9552, 185915, 530, 1, -4968.88, 144.102, 94.8483, 5.42798, 0, 0, -0.414693, 0.909962, 3600, 255, 1),
+(9554, 185915, 530, 1, -4960.82, 216.069, -11.42, 5.84685, 0, 0, -0.216439, 0.976296, 3600, 255, 1),
+(9555, 185915, 530, 1, -4959.43, 646.737, 18.4241, 0.85521, 0, 0, 0.414693, 0.909962, 3600, 255, 1),
+(9557, 185915, 530, 1, -4957.64, 382.887, -2.43409, 1.46608, 0, 0, 0.66913, 0.743145, 3600, 255, 1),
+(9558, 185915, 530, 1, -4947.62, 477.917, 144.214, 3.24635, 0, 0, -0.998629, 0.0523532, 3600, 255, 1),
+(9559, 185915, 530, 1, -4928.36, 288.022, -12.45, 2.51327, 0, 0, 0.951056, 0.309017, 3600, 255, 1),
+(9560, 185915, 530, 1, -4911.07, 316.849, -11.5435, 1.3439, 0, 0, 0.622514, 0.782609, 3600, 255, 1),
+(9561, 185915, 530, 1, -4883.4, 404.646, -5.77738, 1.95477, 0, 0, 0.829038, 0.559193, 3600, 255, 1),
+(9563, 185915, 530, 1, -4856.32, 467.917, -5.42577, 4.72984, 0, 0, -0.700909, 0.713251, 3600, 255, 1),
+(9567, 185915, 530, 1, -4817.81, 933.67, -14.7275, 0.0523589, 0, 0, 0.0261765, 0.999657, 3600, 255, 1),
+(9569, 185915, 530, 1, -4239.12, 436.852, 49.3634, 2.89724, 0, 0, 0.992546, 0.12187, 3600, 255, 1),
+(9570, 185915, 530, 1, -4197.24, 528.217, 29.2594, 4.66003, 0, 0, -0.725374, 0.688355, 3600, 255, 1),
+(9572, 185915, 530, 1, -4190.31, 456.136, 30.5841, 5.42798, 0, 0, -0.414693, 0.909962, 3600, 255, 1),
+(9574, 185915, 530, 1, -4175.07, 300.02, 125.415, 4.64258, 0, 0, -0.731354, 0.681998, 3600, 255, 1),
+(9576, 185915, 530, 1, -4159.2, 369.727, 142.105, 0.349065, 0, 0, 0.173648, 0.984808, 3600, 255, 1);