Queries QUestion

**AndMetal** · #2 12-07-2008, 03:09 AM

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.