Log in

View Full Version : How do you double the drops?


eski2
12-30-2009, 10:04 AM
I noticed on some servers, the drops of things like spider silk were doubled the normal amount, but i can't see anything on the forums about how you can do this, apart from editing each entry manually. Is there an SQL command that would do this, or would you end up with problems?

Secrets
12-30-2009, 11:34 AM
I noticed on some servers, the drops of things like spider silk were doubled the normal amount, but i can't see anything on the forums about how you can do this, apart from editing each entry manually. Is there an SQL command that would do this, or would you end up with problems?

Wrong forum.

ChaosSlayerZ
12-30-2009, 11:42 AM
If you want 1 line solution you can do this:


update loottable_entries set multiplier=multiplier*2;

This will double all loot in the world =)

eski2
12-30-2009, 11:59 AM
I'm just trying that out but i was wondering, when you make a change to the database like this one, can you refresh the server without closing down and restarting? Is there a gm command perhaps?

ChaosSlayerZ
12-30-2009, 12:19 PM
as far as I know, things like items and loot tables only load when server boots up. No idea how to reboot on the fly

eski2
12-30-2009, 12:24 PM
thanks for your help!