DB/GameObject: Arakkoa Egg

(cherry picked from commit cc41323d6f04603c03d847e57a6ac79ff0fce3df)

1 files changed, 124 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_01_01_28_world_2020_04_19_01_world.sql b/sql/updates/world/master/2022_01_01_28_world_2020_04_19_01_world.sql
new file mode 100644
index 00000000000..cd6e4f2f53a
--- /dev/null
+++ b/sql/updates/world/master/2022_01_01_28_world_2020_04_19_01_world.sql
@@ -0,0 +1,124 @@
+-- 
+DELETE FROM `gameobject` WHERE `guid` IN (9392, 9394, 9396, 9397, 9409, 9412, 9414, 9415, 9419, 9420, 9425, 9426, 9429, 9431, 9433, 9434, 9435, 9436, 9438, 9441, 9443, 9444, 9449, 9451, 9453, 9454, 9456, 9459, 9461, 25624, 9462, 25625, 9463, 25626, 9473, 28454, 9475, 28456, 9480, 28458, 9482, 28460, 9483, 28473, 9486, 25623);
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `phaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
+(9392, 184796, 530, 3520, 3745, '0', 0, -4071.222, 1931.083, 76.91239, 5.951575, 0, 0, -0.1650467, 0.9862857, 180, 255, 1, 15595), -- 184796 (Area: 3745 - Difficulty: 0)
+(9394, 184795, 530, 3520, 3745, '0', 0, -4071.222, 1931.083, 76.91239, 5.951575, 0, 0, -0.1650467, 0.9862857, 180, 255, 1, 15595), -- 184796 (Area: 3745 - Difficulty: 0)
+(9396, 184796, 530, 3520, 3745, '0', 0, -4068.589, 1933.354, 76.95588, 1.850049, 0, 0, 0.7986355, 0.601815, 180, 255, 1, 15595), -- 184796 (Area: 3745 - Difficulty: 0)
+(9397, 184795, 530, 3520, 3745, '0', 0, -4068.589, 1933.354, 76.95588, 1.850049, 0, 0, 0.7986355, 0.601815, 180, 255, 1, 15595), -- 184796 (Area: 3745 - Difficulty: 0)
+(9409, 184796, 530, 3520, 3932, '0', 0, -4127.222, 1788.201, 110.0853, 1.186823, 0, 0, 0.5591927, 0.8290377, 180, 255, 1, 15595), -- 184796 (Area: 3932 - Difficulty: 0)
+(9412, 184795, 530, 3520, 3932, '0', 0, -4127.222, 1788.201, 110.0853, 1.186823, 0, 0, 0.5591927, 0.8290377, 180, 255, 1, 15595), -- 184796 (Area: 3932 - Difficulty: 0)
+(9414, 184796, 530, 3520, 3932, '0', 0, -4082.125, 1765.661, 99.30643, 6.021387, 0, 0, -0.1305256, 0.9914449, 180, 255, 1, 15595), -- 184796 (Area: 3932 - Difficulty: 0)
+(9415, 184795, 530, 3520, 3932, '0', 0, -4082.125, 1765.661, 99.30643, 6.021387, 0, 0, -0.1305256, 0.9914449, 180, 255, 1, 15595), -- 184796 (Area: 3932 - Difficulty: 0)
+(9419, 184796, 530, 3520, 3932, '0', 0, -4120.258, 1693.838, 101.6568, 4.904376, 0, 0, -0.6360779, 0.7716249, 180, 255, 1, 15595), -- 184796 (Area: 3932 - Difficulty: 0)
+(9420, 184795, 530, 3520, 3932, '0', 0, -4120.258, 1693.838, 101.6568, 4.904376, 0, 0, -0.6360779, 0.7716249, 180, 255, 1, 15595), -- 184796 (Area: 3932 - Difficulty: 0)
+(9425, 184796, 530, 3520, 3932, '0', 0, -4199.024, 1828.667, 119.5858, 1.692969, 0, 0, 0.7489557, 0.6626201, 180, 255, 1, 15595), -- 184796 (Area: 3932 - Difficulty: 0)
+(9426, 184795, 530, 3520, 3932, '0', 0, -4199.024, 1828.667, 119.5858, 1.692969, 0, 0, 0.7489557, 0.6626201, 180, 255, 1, 15595), -- 184796 (Area: 3932 - Difficulty: 0)
+(9429, 184796, 530, 3520, 3932, '0', 0, -4059.632, 1748.609, 99.80735, 3.316144, 0, 0, -0.9961939, 0.08716504, 180, 255, 1, 15595), -- 184795 (Area: 3932 - Difficulty: 0)
+(9431, 184795, 530, 3520, 3932, '0', 0, -4059.632, 1748.609, 99.80735, 3.316144, 0, 0, -0.9961939, 0.08716504, 180, 255, 1, 15595), -- 184795 (Area: 3932 - Difficulty: 0)
+(9433, 184796, 530, 3520, 3745, '0', 0, -4083.812, 1757.471, 99.34342, 0.104721, 0, 0, 0.0523361, 0.99863, 180, 255, 1, 15595), -- 184796 (Area: 3932 - Difficulty: 0)
+(9434, 184795, 530, 3520, 3745, '0', 0, -4083.812, 1757.471, 99.34342, 0.104721, 0, 0, 0.0523361, 0.99863, 180, 255, 1, 15595), -- 184796 (Area: 3932 - Difficulty: 0)
+(9435, 184796, 530, 3520, 3745, '0', 0, -4056.731, 1796.722, 94.60732, 2.984512, 0, 0, 0.996917, 0.0784656, 180, 255, 1, 15595), -- 184796 (Area: 3932 - Difficulty: 0)
+(9436, 184795, 530, 3520, 3745, '0', 0, -4056.731, 1796.722, 94.60732, 2.984512, 0, 0, 0.996917, 0.0784656, 180, 255, 1, 15595), -- 184796 (Area: 3932 - Difficulty: 0)
+(9438, 184796, 530, 3520, 3932, '0', 0, -4050.613, 1818.764, 86.40541, -0.73303, 0, 0, -0.358368, 0.93358, 180, 255, 1, 15595), -- 184796 (Area: 3932 - Difficulty: 0)
+(9441, 184795, 530, 3520, 3932, '0', 0, -4050.613, 1818.764, 86.40541, -0.73303, 0, 0, -0.358368, 0.93358, 180, 255, 1, 15595), -- 184796 (Area: 3932 - Difficulty: 0)
+(9443, 184796, 530, 3520, 3932, '0', 0, -4032.654, 1821.491, 86.18673, -2.39111, 0, 0, -0.930417, 0.366502, 180, 255, 1, 15595), -- 184796 (Area: 3932 - Difficulty: 0)
+(9444, 184795, 530, 3520, 3932, '0', 0, -4032.654, 1821.491, 86.18673, -2.39111, 0, 0, -0.930417, 0.366502, 180, 255, 1, 15595), -- 184796 (Area: 3932 - Difficulty: 0)
+(9449, 184796, 530, 3520, 3932, '0', 0, -4008.571, 1765.893, 97.12081, -0.95993, 0, 0, -0.461749, 0.887011, 180, 255, 1, 15595), -- 184796 (Area: 3932 - Difficulty: 0)
+(9451, 184795, 530, 3520, 3932, '0', 0, -4008.571, 1765.893, 97.12081, -0.95993, 0, 0, -0.461749, 0.887011, 180, 255, 1, 15595), -- 184796 (Area: 3932 - Difficulty: 0)
+(9453, 184796, 530, 3520, 3932, '0', 0, -4002.442, 1844.231, 81.57851, 0.226893, 0, 0, 0.113203, 0.993572, 180, 255, 1, 15595), -- 184796 (Area: 3932 - Difficulty: 0)
+(9454, 184795, 530, 3520, 3932, '0', 0, -4002.442, 1844.231, 81.57851, 0.226893, 0, 0, 0.113203, 0.993572, 180, 255, 1, 15595), -- 184796 (Area: 3932 - Difficulty: 0)
+(9456, 184796, 530, 3520, 3932, '0', 0, -3972.181, 1767.471, 99.75364, -0.22689, 0, 0, -0.113203, 0.993572, 180, 255, 1, 15595), -- 184796 (Area: 3932 - Difficulty: 0)
+(9459, 184795, 530, 3520, 3932, '0', 0, -3972.181, 1767.471, 99.75364, -0.22689, 0, 0, -0.113203, 0.993572, 180, 255, 1, 15595), -- 184796 (Area: 3932 - Difficulty: 0)
+(9461, 184795, 530, 0, 0, '0', 0, -3951.12, 1842.48, 91.3865, -2.56563, 0, 0, -0.958819, 0.284017, 180, 255, 1, 15595), 
+(25624, 184796, 530, 0, 0, '0', 0, -3951.12, 1842.48, 91.3865, -2.56563, 0, 0, -0.958819, 0.284017, 180, 255, 1, 15595),
+(9462, 184795, 530, 0, 0, '0', 0, -3965.86, 1861.5, 82.6874, -0.10472, 0, 0, -0.0523361, 0.998630, 180, 255, 1, 15595), 
+(25625, 184796, 530, 0, 0, '0', 0, -3965.86, 1861.5, 82.6874, -0.10472, 0, 0, -0.0523361, 0.998630, 180, 255, 1, 15595),
+(9463, 184795, 530, 0, 0, '0', 0, -4176.82, 1821.99, 111.444, -1.23918, 0, 0, -0.580701, 0.814117, 180, 255, 1, 15595), 
+(25626, 184796, 530, 0, 0, '0', 0, -4176.82, 1821.99, 111.444, -1.23918, 0, 0, -0.580701, 0.814117, 180, 255, 1, 15595),
+(9473, 184795, 530, 0, 0, '0', 0, -4011.48, 1762.5, 97.2144, -0.959931, 0, 0, -0.461749, 0.887011, 180, 255, 1, 15595), 
+(28454, 184796, 530, 0, 0, '0', 0, -4011.48, 1762.5, 97.2144, -0.959931, 0, 0, -0.461749, 0.887011, 180, 255, 1, 15595),
+(9475, 184795, 530, 0, 0, '0', 0, -4016, 1792.08, 93.658300, 2.56563, 0, 0, 0.958819, 0.284017000, 180, 255, 1, 15595), 
+(28456, 184796, 530, 0, 0, '0', 0, -4016, 1792.08, 93.658300, 2.56563, 0, 0, 0.958819, 0.284017000, 180, 255, 1, 15595),
+(9480, 184795, 530, 0, 0, '0', 0, -4020.93, 1784.86, 95.3865, -2.04204, 0, 0, -0.852641, 0.522496, 180, 255, 1, 15595), 
+(28458, 184796, 530, 0, 0, '0', 0, -4020.93, 1784.86, 95.3865, -2.04204, 0, 0, -0.852641, 0.522496, 180, 255, 1, 15595),
+(9482, 184795, 530, 0, 0, '0', 0, -4029.34, 1783.06, 95.5917, -2.1293, 0, 0, -0.874619, 0.4848100, 180, 255, 1, 15595), 
+(28460, 184796, 530, 0, 0, '0', 0, -4029.34, 1783.06, 95.5917, -2.1293, 0, 0, -0.874619, 0.4848100, 180, 255, 1, 15595),
+(9483, 184795, 530, 0, 0, '0', 0, -4091.62, 1897.92, 75.4492, 1.90241, 0, 0, 0.814116, 0.58070200, 180, 255, 1, 15595), 
+(28473, 184796, 530, 0, 0, '0', 0, -4091.62, 1897.92, 75.4492, 1.90241, 0, 0, 0.814116, 0.58070200, 180, 255, 1, 15595),
+(9486, 184796, 530, 0, 0, '0', 0, -4091.07, 1892.19, 75.4612, -2.60054, 0, 0, -0.96363, 0.2672390, 180, 255, 1, 15595), 
+(25623, 184795, 530, 0, 0, '0', 0, -4091.07, 1892.19, 75.4612, -2.60054, 0, 0, -0.96363, 0.2672390, 180, 255, 1, 15595);
+
+DELETE FROM `pool_members` WHERE `poolSpawnId` IN (352, 353, 354, 356, 357, 359, 360, 361, 362, 363, 364, 365, 366, 367, 370, 652, 653, 654, 655, 656, 657, 658, 659);
+INSERT INTO `pool_members` (`type`, `spawnId`, `poolSpawnId`, `chance`, `description`) VALUES
+(1, 9392,  352, 80, "Arakkoa Egg"),
+(1, 9394,  352, 20, "Arakkoa Egg"),
+(1, 9396,  353, 80, "Arakkoa Egg"),
+(1, 9397,  353, 20, "Arakkoa Egg"),
+(1, 9409,  354, 80, "Arakkoa Egg"),
+(1, 9412,  354, 20, "Arakkoa Egg"),
+(1, 9414,  356, 80, "Arakkoa Egg"),
+(1, 9415,  356, 20, "Arakkoa Egg"),
+(1, 9419,  357, 80, "Arakkoa Egg"),
+(1, 9420,  357, 20, "Arakkoa Egg"),
+(1, 9425,  359, 80, "Arakkoa Egg"),
+(1, 9426,  359, 20, "Arakkoa Egg"),
+(1, 9429,  360, 80, "Arakkoa Egg"),
+(1, 9431,  360, 20, "Arakkoa Egg"),
+(1, 9433,  361, 80, "Arakkoa Egg"),
+(1, 9434,  361, 20, "Arakkoa Egg"),
+(1, 9435,  362, 80, "Arakkoa Egg"),
+(1, 9436,  362, 20, "Arakkoa Egg"),
+(1, 9438,  363, 80, "Arakkoa Egg"),
+(1, 9441,  363, 20, "Arakkoa Egg"),
+(1, 9443,  364, 80, "Arakkoa Egg"),
+(1, 9444,  364, 20, "Arakkoa Egg"),
+(1, 9449,  365, 80, "Arakkoa Egg"),
+(1, 9451,  365, 20, "Arakkoa Egg"),
+(1, 9453,  366, 80, "Arakkoa Egg"),
+(1, 9454,  366, 20, "Arakkoa Egg"),
+(1, 9456,  367, 80, "Arakkoa Egg"),
+(1, 9459,  367, 20, "Arakkoa Egg"),
+(1, 9461,  370, 80, "Arakkoa Egg"),
+(1, 25624, 370, 20, "Arakkoa Egg"),
+(1, 9462,  652, 80, "Arakkoa Egg"),
+(1, 25625, 652, 20, "Arakkoa Egg"),
+(1, 9463,  653, 80, "Arakkoa Egg"),
+(1, 25626, 653, 20, "Arakkoa Egg"),
+(1, 9473,  654, 80, "Arakkoa Egg"),
+(1, 28454, 654, 20, "Arakkoa Egg"),
+(1, 9475,  655, 80, "Arakkoa Egg"),
+(1, 28456, 655, 20, "Arakkoa Egg"),
+(1, 9480,  656, 80, "Arakkoa Egg"),
+(1, 28458, 656, 20, "Arakkoa Egg"),
+(1, 9482,  657, 80, "Arakkoa Egg"),
+(1, 28460, 657, 20, "Arakkoa Egg"),
+(1, 9483,  658, 80, "Arakkoa Egg"),
+(1, 28473, 658, 20, "Arakkoa Egg"),
+(1, 9486,  659, 80, "Arakkoa Egg"),
+(1, 25623, 659, 20, "Arakkoa Egg");
+
+DELETE FROM `pool_template` WHERE `entry` IN (352, 353, 354, 356, 357, 359, 360, 361, 362, 363, 364, 365, 366, 367, 370, 652, 653, 654, 655, 656, 657, 658, 659);
+INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES 
+(352, 1, 'Arakkoa Egg1'),
+(353, 1, 'Arakkoa Egg2'),
+(354, 1, 'Arakkoa Egg3'),
+(356, 1, 'Arakkoa Egg4'),
+(357, 1, 'Arakkoa Egg5'),
+(359, 1, 'Arakkoa Egg6'),
+(360, 1, 'Arakkoa Egg7'),
+(361, 1, 'Arakkoa Egg8'),
+(362, 1, 'Arakkoa Egg9'),
+(363, 1, 'Arakkoa Egg10'),
+(364, 1, 'Arakkoa Egg11'),
+(365, 1, 'Arakkoa Egg12'),
+(366, 1, 'Arakkoa Egg13'),
+(367, 1, 'Arakkoa Egg14'),
+(370, 1, 'Arakkoa Egg15'),
+(652, 1, 'Arakkoa Egg16'),
+(653, 1, 'Arakkoa Egg17'),
+(654, 1, 'Arakkoa Egg18'),
+(655, 1, 'Arakkoa Egg19'),
+(656, 1, 'Arakkoa Egg20'),
+(657, 1, 'Arakkoa Egg21'),
+(658, 1, 'Arakkoa Egg22'),
+(659, 1, 'Arakkoa Egg23');