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 05-31-2009, 02:05 PM
vales
Discordant
 
Join Date: May 2006
Posts: 458
Default D2Loot Tool

Hey George. I'm using your D2 Loot Tool, and I absolutely, love it. However, I had some questions/suggestions.

If there any way to set it so the items are not worn by the mobs? Fighting a level 5 mob with a level 75 procc'ing weapon is pretty hilarious.

Also, is there a query or something I can set so all of the items can automated with the generator? For example, I have to click every single level range from 1-10, 11-20, 21-30, etc., etc., then select the loot category and wait. What I was thinking is maybe have it so I can just select all of the level ranges and loot categories then just cue everything automatically so I won't have to sit there and do every single entry.

Or, is there maybe a SQL query to accomplish all of this?
Reply With Quote
  #2  
Old 05-31-2009, 06:23 PM
vales
Discordant
 
Join Date: May 2006
Posts: 458
Default

Would help if I posted in the right section as well, lol. That's what I get for posting without my daily dose of coffee.
Reply With Quote
  #3  
Old 06-01-2009, 12:36 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
Default

Yes I think that's possible - perhaps with a software toggle option.

Unless I'm wrong, this is done by setting a flag=0 in lootdrop_entries.equip_item.

If you want a quick fix, you can run this query
Code:
UPDATE lootdrop_entries,lootdrop SET equip_item=0 WHERE
 (lootdrop.id=lootdrop_entries.lootdrop_id) AND lootdrop.name LIKE "lvl_%"
GeorgeS
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
  #4  
Old 06-01-2009, 03:53 PM
vales
Discordant
 
Join Date: May 2006
Posts: 458
Default

Thanks, George. I'll give it a go.
Reply With Quote
  #5  
Old 06-05-2009, 06:44 PM
vales
Discordant
 
Join Date: May 2006
Posts: 458
Default

Works excellent! Mobs are no longer equipping the uber items.
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 12:00 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