EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=596)
-   -   How do you double the drops? (https://www.eqemulator.org/forums/showthread.php?t=30206)

eski2 12-30-2009 10:04 AM

How do you double the drops?
 
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

Quote:

Originally Posted by eski2 (Post 182165)
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!


All times are GMT -4. The time now is 06:08 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.