aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2021-08-12 21:28:09 +0300
committeroffl <offl@users.noreply.github.com>2021-08-12 21:28:09 +0300
commit2da09a4da214933a807a62757e2084ff326ec46d (patch)
tree502a3664aba8479671a96f5324ae96f97ab9eae5
parent8ac6d2bd739d9426fb2abe206c8f08aa095ae39e (diff)
DB/Quest: Reduce drop chance of some quest items
Closes #26800 Closes #26801
-rw-r--r--sql/updates/world/3.3.5/2021_08_12_05_world_335.sql7
1 files changed, 7 insertions, 0 deletions
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;