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.
|