Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::General Support

Support::General Support Post all topics here having to do with errors while trying to connect to an EQEMu server but not about the setup/running of the Server itself.

Reply
 
Thread Tools Display Modes
  #1  
Old 10-26-2006, 11:51 PM
paaco
Discordant
 
Join Date: Jan 2005
Posts: 320
Default Money in Loottables.

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...chemaloottable 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
Reply With Quote
  #2  
Old 10-27-2006, 05:00 AM
paaco
Discordant
 
Join Date: Jan 2005
Posts: 320
Default

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

Last edited by paaco; 10-27-2006 at 01:26 PM..
Reply With Quote
  #3  
Old 10-27-2006, 06:51 AM
John Adams
Demi-God
 
Join Date: Jul 2006
Posts: 1,552
Default

32k is likely the highest integer value allowed for coin drops. I could never get more than that off a fire beetle either.
Reply With Quote
  #4  
Old 10-27-2006, 01:49 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

I think my fix was running sql

UPDATE loottable SET avgcoin=0;

That should do it
GeorgeS
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
  #5  
Old 10-27-2006, 03:41 PM
paaco
Discordant
 
Join Date: Jan 2005
Posts: 320
Default

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
Reply With Quote
  #6  
Old 10-28-2006, 05:28 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

Glad to help

GeorgeS
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 12:05 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3