EQEmulator Forums - Increasing Drop Rates

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Development::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=596)

- - Increasing Drop Rates (https://www.eqemulator.org/forums/showthread.php?t=32335)

gryphinn

10-21-2010 07:32 AM

Increasing Drop Rates

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

Thanks for the quick response!

All times are GMT -4. The time now is 12:03 PM.