Queries QUestion

[Producer_BMW]

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 = )

[AndMetal]

To increase money drops for ALL NPCs, you should be able to run this query (which affects the loottable (http://www.eqemulator.net/wiki/wikka.php?wakka=EQEmuDBSchemaloottable) table in the DB) to increase the money dropped by 3x:
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 (http://www.eqemulator.net/wiki/wikka.php?wakka=EQEmuDBSchemaloottableentries) table to increase the chance of any given loot table (http://www.eqemulator.net/wiki/wikka.php?wakka=EQEmuDBSchemalootdropentries) to drop by 3x:

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

Hope this helps.