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
  #46  
Old 05-24-2012, 07:42 PM
kimura
Hill Giant
 
Join Date: Oct 2011
Posts: 132
Default

I'm using the latest db, i think 2133? I am not at home to check :-(
Reply With Quote
  #47  
Old 05-25-2012, 11:57 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

Ok, I'll take a look when I'm at the PC

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


http://www.georgestools.chrsschb.com//
Reply With Quote
  #48  
Old 09-11-2012, 07:49 PM
Burningsoul
Banned
 
Join Date: Oct 2009
Posts: 312
Default

Also experiencing this with rev2197 - the problem is the tables have been slightly changed, and lootdrop_entries now has two added columns: minlevel and maxlevel.

Edit: Also, this was solved in the thread three below this post. Further reading fail. My bad.
Reply With Quote
  #49  
Old 10-27-2012, 07:19 PM
Furinex
Hill Giant
 
Join Date: Apr 2002
Location: Rochester, NY
Posts: 178
Default

Getting an error for this D2 loot maker tool, talking about your Connector to Mysql. Runtime error.
__________________
U.S. Navy - Retired
17 Year EQ Veteran
Reply With Quote
  #50  
Old 10-27-2012, 09:36 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

NPC editor is the only one that works with current DB ATM.

I'm working on these now

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


http://www.georgestools.chrsschb.com//
Reply With Quote
  #51  
Old 10-28-2012, 10:39 AM
Furinex
Hill Giant
 
Join Date: Apr 2002
Location: Rochester, NY
Posts: 178
Default

Thanks George, I appreciate the work you do. been using your tools for a long time now. Had to rebuild my Database the other day and the only thing I have left to do is run this D2 tool. By the way. Is there an easier way make all mobs have a chance to drop every item? On my server, I've removed the level req. for the items and the no drop is also removed. I would like to make it so anything can drop off of any mob.
__________________
U.S. Navy - Retired
17 Year EQ Veteran
Reply With Quote
  #52  
Old 10-29-2012, 07:37 PM
Furinex
Hill Giant
 
Join Date: Apr 2002
Location: Rochester, NY
Posts: 178
Default

Also George, is there a way to run levels 1-60 (or max) with all the armor/weapons/items in one shot instead of going through each one and executing them?
__________________
U.S. Navy - Retired
17 Year EQ Veteran
Reply With Quote
  #53  
Old 10-30-2012, 12:19 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

No that is not possible, but a tool like this is easy to write.
What I may imagine you want is to import a custom item id list and have that added to all npc's say 10 items at a time per lootdrop and 10 lootdrops per npc?

I can whip this up pretty fast if you want

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


http://www.georgestools.chrsschb.com//
Reply With Quote
  #54  
Old 10-30-2012, 12:31 PM
Furinex
Hill Giant
 
Join Date: Apr 2002
Location: Rochester, NY
Posts: 178
Default

Well I removed the level requirements on all items, and the no drop / lore flags. what im trying to do is fill ALL mob loot tables with completely randomized drops to make it feel like you could get something different from every kill. I would want the chance of drops to be high. Similar to what your D2 loot tool does, but instead of clicking 1-10, armor execute, 1-10 weapons exectute etc, i could do 1-60 all execute. If you could just add that into the Current D2 Loot (after it works again of course) i think that would be awesome. it would save a lot of time if you wanted to do it all in a batch like myself.
__________________
U.S. Navy - Retired
17 Year EQ Veteran
Reply With Quote
  #55  
Old 10-31-2012, 03:39 PM
Furinex
Hill Giant
 
Join Date: Apr 2002
Location: Rochester, NY
Posts: 178
Default

I really hope this D2Loot tool works again soon. Im finding it very tedious to do this all by hand :( Im terrible with SQL as well.. probably gonna jack something up.
__________________
U.S. Navy - Retired
17 Year EQ Veteran
Reply With Quote
  #56  
Old 11-04-2012, 12:28 PM
Furinex
Hill Giant
 
Join Date: Apr 2002
Location: Rochester, NY
Posts: 178
Default

Any update on this?
__________________
U.S. Navy - Retired
17 Year EQ Veteran
Reply With Quote
  #57  
Old 11-04-2012, 05:27 PM
Burningsoul
Banned
 
Join Date: Oct 2009
Posts: 312
Default

Give George some time dude. Instead of bumping the post every day why not learn some simple sql commands rather than just saying that it's too hard?
Reply With Quote
  #58  
Old 11-04-2012, 07:12 PM
Furinex
Hill Giant
 
Join Date: Apr 2002
Location: Rochester, NY
Posts: 178
Default

Quote:
Originally Posted by Burningsoul View Post
Give George some time dude. Instead of bumping the post every day why not learn some simple sql commands rather than just saying that it's too hard?
If it was so simple, why not post the solution instead of belittling someone? Im working on my own solution but its very tedious. Time isnt something I like to waste.
__________________
U.S. Navy - Retired
17 Year EQ Veteran
Reply With Quote
  #59  
Old 11-04-2012, 08:13 PM
c0ncrete's Avatar
c0ncrete
Dragon
 
Join Date: Dec 2009
Posts: 719
Default

no offense, but i've already gone out of my way to attempt to assist you with an alternate solution in one of your posts on the subject.

http://www.eqemulator.org/forums/showthread.php?t=35923

you didn't indicate you had any interest in tailoring it to better suit your needs, that you had any questions, or even that you read it.
Reply With Quote
  #60  
Old 11-04-2012, 08:31 PM
Furinex
Hill Giant
 
Join Date: Apr 2002
Location: Rochester, NY
Posts: 178
Default

Hrm, my subscription didnt notify me about your response. I am going to try that now.
__________________
U.S. Navy - Retired
17 Year EQ Veteran
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 02:13 AM.


 

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