diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2022_01_01_28_world_2020_04_19_01_world.sql | 124 |
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'); |