Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 09-06-2010, 02:38 AM
blackdragonsdg
Dragon
 
Join Date: Dec 2008
Location: Tennessee
Posts: 656
Default

Using Navicat and GeorgeS tools you should be able to find anything you want in the database.

If you know the name of the item you can use GeorgeS tools to find the item id or mod then run the following query in Navicat:

select * from items where Name = 'insertnamehere';

The above query will only work if you know the exact name.

Once you have the item id mod and run the following query:

select * from lootdrop_entries where item_id = X;

When you run the above query it will return a list of all loot tables that contain the specified item id. Get a loottable_id from that list and insert it into the following query then run it.

select * from npc_types where loottable_id = Y;

The above query will return information on all npc’s that have the loottable_id that you specified.
Reply With Quote
 

Thread Tools
Display Modes

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