Thanks! It merged in fine.
To make your search easier:
Code:
select n.id, n.name, lte.loottable_id, lde.lootdrop_id
from npc_types n
inner join loottable lt on n.loottable_id = lt.id
inner join loottable_entries lte on lt.id = lte.loottable_id
inner join lootdrop_entries lde on lte.lootdrop_id = lde.lootdrop_id
where lde.item_id = 12695;
Will give you the npcid, npcname, lootdropid, and loottableid of the tables left with those bogus bone chips in them. PEQ started with 281, and after your queries it is now down to 162. You might want to run that query with each of the item ids (minus 13073 of course) as tacking an or statement on the end of course creates 7 times the results.
As for the purpose of the other chips, according to Lucy, 12695 drops off of lumpy goo in dalnir, presumably for a quest. The other 6 are all sequential which tells me they are all in the same quest, I would assume some sort of find these items, stick them in this container, combine, and hand the result back to me.
Threaded Mode
