DB/Quest: Gaining the advantage - Nether residue - Add Missing drops

Closes #16536

1 files changed, 28 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2020_05_11_04_world.sql b/sql/updates/world/3.3.5/2020_05_11_04_world.sql
new file mode 100644
index 00000000000..4ac98de4ef6
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_05_11_04_world.sql
@@ -0,0 +1,28 @@
+--
+DELETE FROM `gameobject_loot_template` WHERE `Entry` IN (18111,18112,18113,19627,19628,19629,18359,18361,18363,26861) AND `Item` = 35229;
+INSERT INTO `gameobject_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`) VALUES
+(18111,35229,0,25,1,1,0,1,1),
+(18112,35229,0,25,1,1,0,1,1),
+(18113,35229,0,25,1,1,0,1,1),
+(19627,35229,0,25,1,1,0,1,1),
+(19628,35229,0,25,1,1,0,1,1),
+(19629,35229,0,25,1,1,0,1,1),
+(18359,35229,0,25,1,1,0,1,1),
+(18361,35229,0,25,1,1,0,1,1),
+(18363,35229,0,25,1,1,0,1,1),
+(26861,35229,0,25,1,1,0,1,1);
+
+DELETE FROM `skinning_loot_template` WHERE `Entry` IN (70171,70172,70170,70169,70168,70167,70166,70165,70164,70163,70162,70161) AND `Item`=35229;
+INSERT INTO `skinning_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES 
+(70172, 35229, 0, 25, 1, 1, 0, 1, 1, 'Nether Residue'),
+(70171, 35229, 0, 25, 1, 1, 0, 1, 1, 'Nether Residue'),
+(70170, 35229, 0, 25, 1, 1, 0, 1, 1, 'Nether Residue'),
+(70169, 35229, 0, 25, 1, 1, 0, 1, 1, 'Nether Residue'),
+(70168, 35229, 0, 25, 1, 1, 0, 1, 1, 'Nether Residue'),
+(70167, 35229, 0, 25, 1, 1, 0, 1, 1, 'Nether Residue'),
+(70166, 35229, 0, 25, 1, 1, 0, 1, 1, 'Nether Residue'),
+(70165, 35229, 0, 25, 1, 1, 0, 1, 1, 'Nether Residue'),
+(70164, 35229, 0, 25, 1, 1, 0, 1, 1, 'Nether Residue'),
+(70163, 35229, 0, 25, 1, 1, 0, 1, 1, 'Nether Residue'),
+(70162, 35229, 0, 25, 1, 1, 0, 1, 1, 'Nether Residue'),
+(70161, 35229, 0, 25, 1, 1, 0, 1, 1, 'Nether Residue');