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.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 09-26-2011, 08:49 PM
Baruuk
Sarnak
 
Join Date: Aug 2005
Posts: 64
Default Defiant not dropping

Thanks Werebat - but I can't seem to get this to work. I'm hoping someone can help. To test out the code on my server, I took the first section (pasted below) and put it into a SQL file and sourced it in. Things went fine. I reloaded the world, killed about 20 mobs under lvl 5 and never saw 1 drop of Defiant armor. I then opened George's NPC/Loot tool (just started using), selected several random lvl 1-4 mobs in various zones and I see that they have a Lootdrop_ID listed for the entry I just imported (ie: 100001) with a 20% chance. However, on the right pane where Item_Id, Equipped, Chance, etc is listed in the tool, I see no entries for the armor. Did I miss a step to get that in there? I see other loot entries for mobs - ie - for a bat I see bat fur, etc. I made certain I had no Lootdrop_IDs above 90,000. I can however, simply go in game and do a #fi Crude Defiant and I get a listing of the various armor/weapons. Any thoughts on what might be wrong?

Here's the code I sourced in as a test:

#add defiant drops
insert into lootdrop values (100001, 'Crude Defiant');
insert into lootdrop_entries select 100001, id, 1, 1, 2 from items where name like 'Crude Defiant%' and nodrop = 0;
insert into loottable_entries select distinct loottable_id, 100001, 1, 20 from npc_types where loottable_id > 0 and level between 0 and 4;

Any help is appreciated - looking forward to having defiant in.

Thanks in advance!

Last edited by Baruuk; 09-26-2011 at 08:51 PM.. Reason: left out info
Reply With Quote
 


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 11:06 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 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3