EQEmulator Forums - Queries QUestion

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

- Support::General Support (https://www.eqemulator.org/forums/forumdisplay.php?f=598)

- - Queries QUestion (https://www.eqemulator.org/forums/showthread.php?t=26932)

Queries QUestion

Does anyone have a good Query for to (Increase drop rate) ... and increase money drop

I would like for it not to make it stupid amount but maybe like 30% more
like insted of one item dropping maybe 2 or 3 drop , also maybe insted of 1 gold dropping maybe 3-4 , just Above avg. drop rates

It may sound like a cluster fuck of what im saying but if anyone knows what im talking about please

help = )

To increase money drops for ALL NPCs, you should be able to run this query (which affects the loottable table in the DB) to increase the money dropped by 3x:

Code:

UPDATE loottable SET mincash = mincash * 3, maxcash = maxcash & 3, avgcoin = avgcoin * 3;

As for items dropping, if memory serves me correctly, you should be able to run this against the loottable_entries table to increase the chance of any given loot table to drop by 3x:

Code:

UPDATE loottable_entries SET probability = probability * 3 WHERE probability < 100;

UPDATE loottable_entries SET probability = 100 WHERE probability > 100;

Hope this helps.