From 2da09a4da214933a807a62757e2084ff326ec46d Mon Sep 17 00:00:00 2001 From: offl Date: Thu, 12 Aug 2021 21:28:09 +0300 Subject: DB/Quest: Reduce drop chance of some quest items Closes #26800 Closes #26801 --- sql/updates/world/3.3.5/2021_08_12_05_world_335.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/world/3.3.5/2021_08_12_05_world_335.sql (limited to 'sql/updates') diff --git a/sql/updates/world/3.3.5/2021_08_12_05_world_335.sql b/sql/updates/world/3.3.5/2021_08_12_05_world_335.sql new file mode 100644 index 00000000000..2472eb697ef --- /dev/null +++ b/sql/updates/world/3.3.5/2021_08_12_05_world_335.sql @@ -0,0 +1,7 @@ +-- https://www.wowhead.com/item=22227/starbreeze-village-relic#comments +-- https://www.wowhead.com/item=22226/druidical-remains#comments +-- https://www.wowhead.com/item=22228/brilliant-sword-of-zealotry#comments +-- https://www.wowhead.com/item=22229/soul-ashes-of-the-banished#comments +UPDATE `creature_loot_template` SET `Chance` = 10 WHERE `Item` IN (22226,22227,22228,22229) AND `Reference` = 0; +-- https://www.wowhead.com/quest=8310/breaking-the-code#comments +UPDATE `creature_loot_template` SET `Chance` = 20 WHERE `Item` IN (20457,20458,20459) AND `Reference` = 0; -- cgit v1.2.3