From 0485c3f0ba2bcbda3ece7a03229eddd86a86a107 Mon Sep 17 00:00:00 2001 From: offl Date: Mon, 11 May 2020 17:56:02 +0200 Subject: DB/Quest: Gaining the advantage - Nether residue - Add Missing drops Closes #16536 (cherry picked from commit 16d4a39c7d32e6d269f7926228b0df539722f44e) --- .../2022_01_04_06_world_2020_05_11_04_world.sql | 28 ++++++++++++++++++++++ 1 file changed, 28 insertions(+) create mode 100644 sql/updates/world/master/2022_01_04_06_world_2020_05_11_04_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2022_01_04_06_world_2020_05_11_04_world.sql b/sql/updates/world/master/2022_01_04_06_world_2020_05_11_04_world.sql new file mode 100644 index 00000000000..4ac98de4ef6 --- /dev/null +++ b/sql/updates/world/master/2022_01_04_06_world_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'); -- cgit v1.2.3