diff options
author | tails2k <33679365+tails2k@users.noreply.github.com> | 2020-05-12 08:07:11 +0200 |
---|---|---|
committer | GitHub <noreply@github.com> | 2020-05-12 08:07:11 +0200 |
commit | 0c7655e4ccff854acadd279a1d0f5f87b355c6ad (patch) | |
tree | 8d00f2ea27c92cffe33ae7c063055c682c7d2321 | |
parent | 2420b174e3955e13382977303350b2250a752211 (diff) |
Update 2020_05_11_05_world_335.sql (#24606)
-rw-r--r-- | sql/updates/world/3.3.5/2020_05_11_05_world_335.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/updates/world/3.3.5/2020_05_11_05_world_335.sql b/sql/updates/world/3.3.5/2020_05_11_05_world_335.sql index 35de8fa47e0..627311b3538 100644 --- a/sql/updates/world/3.3.5/2020_05_11_05_world_335.sql +++ b/sql/updates/world/3.3.5/2020_05_11_05_world_335.sql @@ -8,7 +8,7 @@ UPDATE `gameobject` SET `id`=3730 WHERE `id`=1622 AND `guid` IN (2928, 2930, 295 DELETE FROM `gameobject` WHERE `id` IN (3725, 3729, 3730, 3726, 3727,3724) AND `guid` IN (14489, 14488, 14487, 14486, 14485, 14482, 14481, 14480, 14479, 14478, 14477, 14476, 14475, 14474, 14473, 14472, 14471, 14470, 14468, 14467, 14464, 14463, 14462, 14460, 14459, 14458, 14457, 14456, 14455, 14454, 14453, 14452, 14451, 14450, 14446, 14302, 14301, 14298, 14297, 14236, 14204, 14203, 14202, 14201, 14200, 14199, 14187, 14184, 14008, 13969, 13821, 13820, 13702, 13701, 13700, 13699, 13698, 13697, 13696, 13695, 13694, 13693, 13692, 13691, 13690, 13689, 13688, 13687, 13686, 13685, 13684, 13675, 13674, 13673, 13639, 13629, 13628, 13624, 13622, 13620, 13619, 13605, 13602, 13601, 13600, 13599, 13598, 13597, 13596, 13595, 13591, 13590, 13589, 13588, 13587, 13586, 13585, 13584, 13583, 13582, 13581, 13580, 13579, 13578, 13577, 13576, 13575, 13574, 13573, 13572, 13571, 13570, 13568, 13567, 13566, 13565, 13564, 13563, 13562, 13561, 13560, 13559, 13558, 13557, 13556, 13555, 13554, 13553, 13552, 13551, 13550, 13549, 13548, 13547, 13546, 13545, 30205, 30889, 30894, 31974, 31975, 31976, 31978, 32011, 32014, 32015, 32017, 32519, 33549, 33553, 33557, 35024, 63421, 63422, 63423, 63424, 63425, 63426, 63427, 63428, 63429, 63430, 63431, 65121, 65122, 65123, 86351, 86352, 86353, 86354, 86355, 86356, 86357, 86358, 86359, 86360, 86361, 86362, 86363, 86364, 86365, 86366, 86367, 86368, 86369, 86370, 86371, 86372, 86373, 86374, 86375, 86376, 86377, 86378, 86379, 86380, 86381, 87283, 87284, 87285, 87286, 87287, 87288, 87289, 87290, 87291, 87292, 87293, 87294, 87295, 87296, 87484); DELETE FROM `gameobject` WHERE `guid` IN (2094, 2474); DELETE FROM `gameobject_addon` WHERE `guid` IN (2474, 14489, 14488, 14487, 14486, 14485, 14482, 14480, 14479, 14478, 14477, 14476, 14475, 14474, 14473, 14472, 14471, 14470, 14468, 14467, 14464, 14463, 14462, 14460, 14459, 14458, 14456, 14455, 14454, 14453, 14452, 14451, 14450, 14446, 14302, 14301, 14298, 14297, 14236, 14204, 14203, 14202, 14201, 14200, 14199, 14187, 14184, 14008, 13969, 13821, 13820, 13702, 13701, 13700, 13699, 13698, 13697, 13696, 13695, 13694, 13693, 13692, 13691, 13690, 13689, 13688, 13687, 13686, 13685, 13684, 13675, 13674, 13673, 13639, 13629, 13628, 13624, 13622, 13620, 13619, 13605, 13602, 13601, 13600, 13599, 13598, 13597, 13596, 13595, 13591, 13590, 13589, 13588, 13587, 13586, 13585, 13584, 13583, 13582, 13581, 13580, 13579, 13578, 13577, 13576, 13575, 13574, 13573, 13572, 13571, 13570, 13568, 13567, 13566, 13565, 13564, 13563, 13562, 13561, 13560, 13559, 13558, 13557, 13556, 13555, 13554, 13553, 13552, 13551, 13550, 13549, 13548, 13547, 13546, 13545, 30205, 30889, 30894, 31974, 31975, 31976, 31978, 32011, 32014, 32015, 32017, 32519, 33549, 33553, 33557, 35024); -DELETE FROM `spawn_group` WHERE `spawntType`=1 AND `spawnId` IN (2094, 2474, 13545, 13546, 13547, 13548, 13549, 13550, 13551, 13552, 13553, 13554, 13555, 13556, 13557, 13558, 13559, 13560, 13561, 13562, 13563, 13564, 13565, 13566, 13567, 13568, 13570, 13571, 13572, 13573, 13574, 13575, 13576, 13577, 13578, 13579, 13580, 13581, 13582, 13583, 13584, 13585, 13586, 13587, 13588, 13589, 13590, 13591, 13595, 13596, 13597, 13598, 13599, 13600, 13601, 13602, 13605, 13619, 13620, 13622, 13624, 13628, 13629, 13639, 13673, 13674, 13675, 13684, 13685, 13686, 13687, 13688, 13689, 13690, 13691, 13692, 13693, 13694, 13695, 13696, 13697, 13698, 13699, 13700, 13701, 13702, 13820, 13821, 13969, 14008, 14184, 14187, 14199, 14200, 14201, 14202, 14203, 14204, 14236, 14297, 14298, 14301, 14302, 14446, 14450, 14451, 14452, 14453, 14454, 14455, 14456, 14457, 14458, 14459, 14460, 14462, 14463, 14464, 14467, 14468, 14470, 14471, 14472, 14473, 14474, 14475, 14476, 14477, 14478, 14479, 14480, 14481, 14482, 14485, 14486, 14487, 14488, 14489, 30205, 30889, 30894, 31974, 31975, 31976, 31978, 32011, 32014, 32015, 32017, 32519, 33549, 33553, 33557, 35024, 63421, 63422, 63423, 63424, 63425, 63426, 63427, 63428, 63429, 63430, 63431, 65121, 65122, 65123, 86351, 86352, 86353, 86354, 86355, 86356, 86357, 86358, 86359, 86360, 86361, 86362, 86363, 86364, 86365, 86366, 86367, 86368, 86369, 86370, 86371, 86372, 86373, 86374, 86375, 86376, 86377, 86378, 86379, 86380, 86381, 87283, 87284, 87285, 87286, 87287, 87288, 87289, 87290, 87291, 87292, 87293, 87294, 87295, 87296, 87484); +DELETE FROM `spawn_group` WHERE `spawnType`=1 AND `spawnId` IN (2094, 2474, 13545, 13546, 13547, 13548, 13549, 13550, 13551, 13552, 13553, 13554, 13555, 13556, 13557, 13558, 13559, 13560, 13561, 13562, 13563, 13564, 13565, 13566, 13567, 13568, 13570, 13571, 13572, 13573, 13574, 13575, 13576, 13577, 13578, 13579, 13580, 13581, 13582, 13583, 13584, 13585, 13586, 13587, 13588, 13589, 13590, 13591, 13595, 13596, 13597, 13598, 13599, 13600, 13601, 13602, 13605, 13619, 13620, 13622, 13624, 13628, 13629, 13639, 13673, 13674, 13675, 13684, 13685, 13686, 13687, 13688, 13689, 13690, 13691, 13692, 13693, 13694, 13695, 13696, 13697, 13698, 13699, 13700, 13701, 13702, 13820, 13821, 13969, 14008, 14184, 14187, 14199, 14200, 14201, 14202, 14203, 14204, 14236, 14297, 14298, 14301, 14302, 14446, 14450, 14451, 14452, 14453, 14454, 14455, 14456, 14457, 14458, 14459, 14460, 14462, 14463, 14464, 14467, 14468, 14470, 14471, 14472, 14473, 14474, 14475, 14476, 14477, 14478, 14479, 14480, 14481, 14482, 14485, 14486, 14487, 14488, 14489, 30205, 30889, 30894, 31974, 31975, 31976, 31978, 32011, 32014, 32015, 32017, 32519, 33549, 33553, 33557, 35024, 63421, 63422, 63423, 63424, 63425, 63426, 63427, 63428, 63429, 63430, 63431, 65121, 65122, 65123, 86351, 86352, 86353, 86354, 86355, 86356, 86357, 86358, 86359, 86360, 86361, 86362, 86363, 86364, 86365, 86366, 86367, 86368, 86369, 86370, 86371, 86372, 86373, 86374, 86375, 86376, 86377, 86378, 86379, 86380, 86381, 87283, 87284, 87285, 87286, 87287, 87288, 87289, 87290, 87291, 87292, 87293, 87294, 87295, 87296, 87484); -- Add Root Sample loot only in herbs spawned in The Barrens DELETE FROM `gameobject_loot_template` WHERE `Entry` IN (1414,1415,1416,1417,1418,1419,1420,1421,1733,1734,2511,2512,2513,2514,2515,2516) AND `Item` = 5056; INSERT INTO `gameobject_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`) VALUES |