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
  #1  
Old 10-30-2012, 12:19 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
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
  #2  
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
  #3  
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
  #4  
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
  #5  
Old 11-04-2012, 05:27 PM
Burningsoul
Discordant
 
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
  #6  
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
  #7  
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
  #8  
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
  #9  
Old 11-12-2012, 07:49 PM
opyrus
Hill Giant
 
Join Date: Apr 2008
Location: in doors
Posts: 138
Default

Is this tool working with DB Version 2214 yet?
Reply With Quote
  #10  
Old 11-12-2012, 11:49 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
Default

No, tool will be finished by this friday. I'll commit time this week.

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


http://www.georgestools.chrsschb.com//
Reply With Quote
  #11  
Old 11-22-2012, 11:08 PM
Furinex
Hill Giant
 
Join Date: Apr 2002
Location: Rochester, NY
Posts: 178
Default

I redownloaded the tool and tried it again with the same issue. Runtime error :(
__________________
U.S. Navy - Retired
17 Year EQ Veteran
Reply With Quote
  #12  
Old 11-23-2012, 02:29 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
Default

When it's done the update will be posted here. RL is been busy

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


http://www.georgestools.chrsschb.com//
Reply With Quote
  #13  
Old 11-23-2012, 08:59 PM
ChaosSlayerZ's Avatar
ChaosSlayerZ
Demi-God
 
Join Date: Mar 2009
Location: Umm
Posts: 1,492
Default

as of today we are on 2260
Reply With Quote
  #14  
Old 11-24-2012, 10:05 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
Default

Tool is now compatible with current schema. This takes into consideration the loot changes that broke the tool.

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


http://www.georgestools.chrsschb.com//
Reply With Quote
  #15  
Old 12-05-2012, 02:44 AM
Burningsoul
Discordant
 
Join Date: Oct 2009
Posts: 312
Default

Just a heads up.. downloaded the new version, server revision at 2243. My fields are set as follows.. 100% NPCs, 100% Chance to drop, 15 items.
In game, the drops are far rarer.. one in 10 mobs MIGHT have one of the new drops.

Browsing some droplists with the PHP Editor, I see that all the new loot has a very low chance to drop, and each table's droprate is only 15% or so.
Even with a 100 probability I'm still not getting results like I did before the lootdrop revision. Is it the cause of these problems?

Also, I notice this program is quite faster than it used to be, but I'm assuming that's because even if you set Chance for NPC to get loot to 100%, it's not really selecting them all - I've never see it working on more than ~5000 npcs each pass now.
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:00 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