Money in Loottables.

[paaco]

On my server last night I added some loottables to a new zone. Money drops seems to be having issues. Just wondering if it has happened to anyone else or what you think the problem could be. Mobs are dropping 35k plat btw heh.
Min cash is set to 72
max cash is set to 499
avg coin has no value

Now according to http://www.eqemulator.net/wiki/wikka.php?wakka=EQEmuDBSchemaloottable that should mean 7 silver 2 copper should be the min value and 4 gold 9 silver 9 copper should be the max. But obviously something is going wrong somewhere. Anyone have any idea whats going on? This is on 0.7-871

[paaco]

More info that is kinda off. #npcstats says 4294958 Platinum 88 gold 80silver and 92 copper. But when you kill and loot them, they drop. 35120 plat, 66gold, 77 silver, and 89 copper. I'm lost now lol =/

EDIT:: OK I also just changed min and max cash to 0 for that loottable with MySQL Front. They still drop 35k. This is getting to be a mystery for me :)

[John Adams]

32k is likely the highest integer value allowed for coin drops. I could never get more than that off a fire beetle either. :)

[GeorgeS]

I think my fix was running sql

UPDATE loottable SET avgcoin=0;

That should do it
GeorgeS

[paaco]

thanks George, I got it worked out. I set them to 0, rebooted server, set them back to the money I wanted and rebooted again and it seems to work. Seems to have just been a weird glitch. Not sure what was going on :)

[GeorgeS]

Glad to help

GeorgeS