Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
 
Thread Tools Display Modes
  #1  
Old 10-18-2011, 02:53 AM
Gregk
Sarnak
 
Join Date: Mar 2010
Posts: 41
Default Unused lootdrop_id for missing db items

I know how to add loot to npcs using Georges tools, but what I can't figure out how to add content using lootdrop_IDs starting at 33000, or any skipped number. I can use the tool to add a new lootdrop_id to the loottable, then change it to an unused number 33000. It shows up properly in tables, and the tool, but in-game, the npc is missing the added loot.

Using Georges tools to add content, I get numbers starting at 90550. I'm hoping to add content that won't interfere with new DB releases.
Reply With Quote
  #2  
Old 10-18-2011, 11:11 AM
Gregk
Sarnak
 
Join Date: Mar 2010
Posts: 41
Default

another thought... maybe the editing tool uses higher numbers to avoid using numbers that haven't necessarily been skipped, but left open for content yet to be captured from live... Any insight would be greatly appreciated.

Thank you
Reply With Quote
  #3  
Old 10-18-2011, 11:42 AM
ChaosSlayerZ's Avatar
ChaosSlayerZ
Demi-God
 
Join Date: Mar 2009
Location: Umm
Posts: 1,492
Default

yes George tools assign those numbers automatically basing off first available number after the latest number in DB
To go around this, manually, I edit my loot ids directly in the DB
To have better understanding HOW loot drops connects to a mob, you need to look at loot structure - there are 4 different tables that handle loot structure, and all of them need to be set up correctly for loot to show up.
George tools handle this automatically, but if you want manual control read more about it in the wiki
Reply With Quote
  #4  
Old 10-18-2011, 03:25 PM
Gregk
Sarnak
 
Join Date: Mar 2010
Posts: 41
Default

Sorry for the newbie question.. to which wiki are you referring? Brain is kinda mushy with all the recent searching and reading...

Thank you in advance..
Reply With Quote
  #5  
Old 10-18-2011, 05:48 PM
ChaosSlayerZ's Avatar
ChaosSlayerZ
Demi-God
 
Join Date: Mar 2009
Location: Umm
Posts: 1,492
Default

this one
http://www.eqemulator.net/wiki/wikka.php?wakka=HomePage
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:12 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