aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSnapperRy <snapperryen@gmail.com>2016-07-15 14:23:18 +0200
committerjoschiwald <joschiwald.trinity@gmail.com>2017-02-05 17:25:55 +0100
commitbec8570eb214842049fed2eeac93fce7b5ffb092 (patch)
tree3b2b8a29253032585f8206bd283a153ad438b863
parentcfca1896deef6279dfb3cf8e48723c2cb0d5280a (diff)
DB/Loot: reduce drop chance for many white items
Closes #17578 (cherry picked from commit b5cb96a56adb007a74f77e5be6b93cfaee9fe552)
-rw-r--r--sql/updates/world/master/2017_02_05_17_world_2016_07_15_01_world.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_02_05_17_world_2016_07_15_01_world.sql b/sql/updates/world/master/2017_02_05_17_world_2016_07_15_01_world.sql
new file mode 100644
index 00000000000..2a6466dd1cc
--- /dev/null
+++ b/sql/updates/world/master/2017_02_05_17_world_2016_07_15_01_world.sql
@@ -0,0 +1,2 @@
+--
+UPDATE `creature_loot_template` SET `Chance`=5.7 WHERE `Chance` > 5 AND `Reference`=0 AND `Item` IN (1438, 2959, 2960, 2963, 2964, 2967, 2972, 2975, 3200, 3207, 3213, 3214, 3323, 3643, 4560, 4658, 4662, 4684, 4690, 6506, 6508, 6514, 6515, 6517, 6549, 6566, 6579, 7350, 7351, 9744, 9745, 9750, 9752, 9754, 9759, 9760);