Log in

View Full Version : Increasing Drop Rates


gryphinn
10-21-2010, 07:32 AM
I would like to increase drop rates across the board for my private server. Can I do that with 1 SQL query? and if so what would that query be?

Thanks in advance!

joligario
10-21-2010, 07:55 AM
Increase by how much?

Example 1: If you wanted to just set every table to drop 100% of the time, you would do 'UPDATE loottable_entries SET probability = 100;'

Example 2: If you wanted to bump by ... say 5% ... you would do 'UPDATE loottable_entries SET probability = probability + 5 WHERE probability <= 95;'

gryphinn
10-21-2010, 02:50 PM
Thanks for the quick response!