aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorVanDobben <VanDobben@users.noreply.github.com>2020-05-11 01:28:45 +0200
committerKillyana <morphone1@gmail.com>2020-05-11 01:28:45 +0200
commit267e707fe3404788df8316166bd31ab139909fd1 (patch)
treedc47b336bb72303bf7ee880cf4bc14aaf4d52fcf
parent3e1aede6fadd7ed17f099182abb0e1e41383c80c (diff)
DB/Loot: Fix some loots in The Obsidian Sanctum
Closes #24598
-rw-r--r--sql/updates/world/3.3.5/2020_05_11_00_world.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_05_11_00_world.sql b/sql/updates/world/3.3.5/2020_05_11_00_world.sql
new file mode 100644
index 00000000000..9d29652cd07
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_05_11_00_world.sql
@@ -0,0 +1,7 @@
+--
+UPDATE `creature_template` SET `mingold` = 21855, `maxgold` = 23530 WHERE `entry` = 30453;
+UPDATE `creature_template` SET `mingold` = 43710, `maxgold` = 47060 WHERE `entry` = 31001;
+UPDATE `creature_template` SET `mingold` = 1800000, `maxgold` = 2000000 WHERE `entry` = 28860;
+UPDATE `creature_template` SET `skinloot`=28860, `mingold` = 2000000, `maxgold` = 2250000 WHERE `entry` = 31311;
+UPDATE `creature_template` SET `mingold` = 21855, `maxgold` = 23530 WHERE `entry` IN (30681, 30680);
+UPDATE `creature_template` SET `mingold` = 43710, `maxgold` = 47060 WHERE `entry` IN (30998, 30999);