aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorSnapperRy <snapperryen@gmail.com>2016-07-15 14:23:18 +0200
committerGitHub <noreply@github.com>2016-07-15 14:23:18 +0200
commitb5cb96a56adb007a74f77e5be6b93cfaee9fe552 (patch)
treeec7b742afc5e9dc86b81ed8ad22c35016ffcec4c /sql/updates
parent4fea1c59e1d2fce1104b5f5b9277edc4a9cb710f (diff)
DB/Loot: reduce drop chance for many white items
Closes #17578
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/3.3.5/2016_07_15_01_world.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_07_15_01_world.sql b/sql/updates/world/3.3.5/2016_07_15_01_world.sql
new file mode 100644
index 00000000000..2a6466dd1cc
--- /dev/null
+++ b/sql/updates/world/3.3.5/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);