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!
vBulletin® v3.8.11, Copyright ©2000-2025, vBulletin Solutions Inc.