aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/master/2022_01_24_17_world_2020_07_31_19_world.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_24_17_world_2020_07_31_19_world.sql b/sql/updates/world/master/2022_01_24_17_world_2020_07_31_19_world.sql
new file mode 100644
index 00000000000..21397b59179
--- /dev/null
+++ b/sql/updates/world/master/2022_01_24_17_world_2020_07_31_19_world.sql
@@ -0,0 +1,10 @@
+-- Significantly increase amount of gold drop from Doomwalker & Doom Lord Kazzak
+-- https://github.com/cmangos/tbc-db/commit/d10a189755188633a6c9c3a2fc45d8d2729dfee1#diff-b58a7adfa3834b2bdb9f236ea7e979c1R1-R13
+-- https://wow.gamepedia.com/Doomwalker#Doomwalker_at_level_80
+-- > Doomwalker will drop 2 level 70 BoE items and around 500 gold.
+-- https://youtu.be/MMgdY4FB-aM?t=418
+-- https://wow.gamepedia.com/Doomwalker#Patch_changes
+-- > Patch 2.4.0 (2008-03-25): Loot dropped by Doomlord Kazzak and Doomwalker has been changed to Bind on Equip.
+-- In addition, the cash dropped by these bosses has been significantly increased.
+-- > Patch -after cata- gold nerfed to ~1/10th of original value
+UPDATE `creature_template` SET `mingold` = 50*100*100, `maxgold` = 55*100*100 WHERE `entry` IN (17711,18728);