Increasing Drop Rates

gryphinn · #1 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** · #2 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 · #3 10-21-2010, 02:50 PM

Thanks for the quick response!