From e12bbf0261fefd18230a454e22723375a752074d Mon Sep 17 00:00:00 2001 From: Killyana Date: Tue, 9 Apr 2019 16:18:16 +0200 Subject: DB/Fishing: Fix quest loots in The Underbelly and The Violet Hold (Dalaran) (cherry picked from commit 7aa91653c9e11e5c26642fe40f8f035b5d93af25) --- .../world/master/2021_11_26_24_world_2019_04_09_01_world.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 sql/updates/world/master/2021_11_26_24_world_2019_04_09_01_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2021_11_26_24_world_2019_04_09_01_world.sql b/sql/updates/world/master/2021_11_26_24_world_2019_04_09_01_world.sql new file mode 100644 index 00000000000..ad54714ff40 --- /dev/null +++ b/sql/updates/world/master/2021_11_26_24_world_2019_04_09_01_world.sql @@ -0,0 +1,10 @@ +-- +DELETE FROM `fishing_loot_template` WHERE `Item` IN (45323,45328,45903); +DELETE FROM `reference_loot_template` WHERE `Item` IN (45328); +INSERT INTO `reference_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(11024, 45328, 0, 10, 1, 1, 2, 1, 1, ""); +DELETE FROM `conditions` WHERE `SourceGroup` IN (11026) AND `SourceTypeOrReferenceId`=10 AND `SourceEntry`=45328; +UPDATE `fishing_loot_template` SET `GroupID`=0 WHERE `entry` IN (4567,4560); +UPDATE `reference_loot_template` SET `GroupID`=1 WHERE `entry` IN (11024,11026); +UPDATE `reference_loot_template` SET `Chance`=6 WHERE `entry` IN (11024) AND `Item` IN (43658,43695,43696); +UPDATE `reference_loot_template` SET `GroupID`=2 WHERE `Item` IN (45328,45903); -- cgit v1.2.3