Lootdrop table question

[KLS]

npc_types have an entry 'loottable_id' which points to a loottable
loottable_entries with the matching loottable_id point to lootdrop_id
lootdrop_entries are what you're at right now and contain references to items

So you sort of need to go backwards given the lootdrop_id you have you need to find all the loottables that point to it. Then you need to go backwards from there and find each npc_type that points to that loottable.

[scrubtasticx]

the easiest way to add defiant gear drops to your server (and i JUST did this yesterday for my hotzones) is use george's tools he has a npc loot editor it works wonders and it will also give you a great handle on where things are in the database also so you can edit them from navicat/hiedi in the future.