diff options
| author | offl <offl@users.noreply.github.com> | 2020-05-11 17:56:02 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-01-04 01:02:22 +0100 |
| commit | 0485c3f0ba2bcbda3ece7a03229eddd86a86a107 (patch) | |
| tree | defdc69797f00f3877521866972870eaad44595c | |
| parent | 63e1c04b4cbcac5826a84d96eb86ba1987b1d6a8 (diff) | |
DB/Quest: Gaining the advantage - Nether residue - Add Missing drops
Closes #16536
(cherry picked from commit 16d4a39c7d32e6d269f7926228b0df539722f44e)
| -rw-r--r-- | sql/updates/world/master/2022_01_04_06_world_2020_05_11_04_world.sql | 28 |
1 files changed, 28 insertions, 0 deletions
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'); |