Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::GeorgeS's Tools

Development::GeorgeS's Tools A forum just for GeorgeS's tools

Reply
 
Thread Tools Display Modes
  #31  
Old 02-14-2009, 11:23 PM
Randymarsh9
Dragon
 
Join Date: Dec 2007
Posts: 658
Default

I just noticed something else. All monters with an odd ID have extra loot drops. For instance, if I do two loot drops for armor, even IDs will have just two drops, but odd ID monsters will have 4
Reply With Quote
  #32  
Old 02-15-2009, 02:36 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

Thanks for the feedback - the odd-even might be simple to fix, and I'll look into it today.

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


http://www.georgestools.chrsschb.com//
Reply With Quote
  #33  
Old 02-15-2009, 09:12 PM
Randymarsh9
Dragon
 
Join Date: Dec 2007
Posts: 658
Default

So did you find any reason for this?
Reply With Quote
  #34  
Old 02-17-2009, 12:13 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

Yes, I looked at it now and found the following.

Many lootdrops are shared among many npc's and the program checks for duplicates. Therefore that cannot be the answer. Also, I found 5 and only 5 drops per npc. Never saw a difference among odd/even npcs. The program does not care about npc id order.

What I did see, and this makes sense, the program creates a new lootdrop id for each unique loottable, and is always the highest number. If there are other lootdrops in the npc's then new ones are made. Therefore the real way to ensure a new lootdrop and a totally custom database is to wipe all loot from all npc's first.

Therefore, I do not observe and anomalies.

Another thing, if you rerun the program for the same level npc's, you will add more custom loot.


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


http://www.georgestools.chrsschb.com//
Reply With Quote
  #35  
Old 02-18-2009, 12:58 AM
Randymarsh9
Dragon
 
Join Date: Dec 2007
Posts: 658
Default

OK, so the only way I can make it so some monsters don't have double the loot is to wipe all loot? Is there any other way because I have a lot of custom loot drops.
Reply With Quote
  #36  
Old 02-19-2009, 06:04 PM
Randymarsh9
Dragon
 
Join Date: Dec 2007
Posts: 658
Default

Does anyone else know how I could possibly avoid having to wipe all loot? I really don't want to have to do that, but it would make some monsters drop 4 items and some drop 8 if I leave it how it is.
Reply With Quote
  #37  
Old 02-20-2009, 07:00 PM
Randymarsh9
Dragon
 
Join Date: Dec 2007
Posts: 658
Default

Ok, how can I wipe all lootables and stuff so that monsters won't drop more items than I want? My server has been done for almost 2 weeks and I don't want to bring it back until I get the loot fixed.
Reply With Quote
  #38  
Old 02-21-2009, 10:24 PM
Randymarsh9
Dragon
 
Join Date: Dec 2007
Posts: 658
Default

i'm really sorry. I am not trying to complain, but I have had my server down for a while now because I don't want to bring it up when there is no random loot. I am just trying to fix the problems of some monsters having 2x loot and then the monsters 65+ also having the lootdrops from 61+ monsters. Does anyone have some suggestions for how I can fix this because I am making no progress just adding loot, removing it, and adding it again. I really want to fix these problems because it does make a big difference. I want monsters to drop 4 items per kill, but some monsters will drop 8. And then the 65+ monsters will normally drop 8, but since some monsters have double the loot they are dropping 16 items. That is 4x the amount of items I am trying to do.
Reply With Quote
  #39  
Old 08-01-2009, 12:51 AM
Randymarsh9
Dragon
 
Join Date: Dec 2007
Posts: 658
Default

I think this tool needs to be updated. I keep getting an error saying invalid use of null when I try to run it. And is it possible to make the max items per lootdrop over 100 or is that just an emulator thing?
Reply With Quote
  #40  
Old 08-01-2009, 03:59 PM
Randymarsh9
Dragon
 
Join Date: Dec 2007
Posts: 658
Default

actually I figured out the invalid use of null problem
Reply With Quote
  #41  
Old 08-01-2009, 04:08 PM
Randymarsh9
Dragon
 
Join Date: Dec 2007
Posts: 658
Default

I noticed that I get the runtime error 9 subscript out of range if I put over 5 items per loot drop. I saw someone else had that problem awhile ago and am wondering if it was fixed
Reply With Quote
  #42  
Old 08-24-2009, 09:53 AM
Wilbane
Fire Beetle
 
Join Date: Jun 2006
Posts: 5
Default

GeorgeS, great tool and thank you. I played with it over the weekend and it works very well especially the ability to import custom lists. As usual the compliment is followed by a question ... LOL. Is there a way to limit the tool to specific zones? The reason I ask is this would be a quick way of adding new content to unused zones.

Thanks, Wil
Reply With Quote
  #43  
Old 09-10-2009, 10:26 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

Quote:
Originally Posted by Randymarsh9 View Post
I noticed that I get the runtime error 9 subscript out of range if I put over 5 items per loot drop. I saw someone else had that problem awhile ago and am wondering if it was fixed
DiabloII*
ver 1.7.2 (Sep-10th-09) - added support for >5 items per lootdrop - to a max of 32

Sorry for the delay in fixing this

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


http://www.georgestools.chrsschb.com//
Reply With Quote
  #44  
Old 05-22-2012, 01:40 PM
kimura
Hill Giant
 
Join Date: Oct 2011
Posts: 132
Default runtime error with last update to source

after the latest update, now i get a runtime error saying that column doesnt match the fields in row 1 or something very similar...any suggestions GeorgeS?
Reply With Quote
  #45  
Old 05-24-2012, 12:08 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

Holy necro,

What version of DB are you using?

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


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


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 09:26 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 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3