View Single Post
  #2  
Old 12-07-2008, 03:09 AM
AndMetal
Developer
 
Join Date: Mar 2007
Location: Ohio
Posts: 648
Default

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.
__________________
GM-Impossible of 'A work in progress'
A non-legit PEQ DB server
How to create your own non-legit server

My Contributions to the Wiki
Reply With Quote