aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2021-08-12 21:28:09 +0300
committerShauren <shauren.trinity@gmail.com>2022-03-12 15:50:01 +0100
commit7e22abaf6af13f04c21f42e2cd493642c495d8e2 (patch)
treea9c61ca0629b7b44be622d44eb13a68baaf52d3e
parentf4b37190f8be081a69c0762d50a9dfc641724583 (diff)
DB/Quest: Reduce drop chance of some quest items
Closes #26800 Closes #26801 (cherry picked from commit 2da09a4da214933a807a62757e2084ff326ec46d)
-rw-r--r--sql/updates/world/master/2022_03_12_16_world_2021_08_12_05_world_335.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_12_16_world_2021_08_12_05_world_335.sql b/sql/updates/world/master/2022_03_12_16_world_2021_08_12_05_world_335.sql
new file mode 100644
index 00000000000..2472eb697ef
--- /dev/null
+++ b/sql/updates/world/master/2022_03_12_16_world_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;