Amazing how much clearer things are when one finally sees the "lootable_id" field in the npc_types table.
Now, what oh what does the "lootdrop" table do? Initially it seemed the "id" field was a foreign key (relation) for another table, but then many of the NPC names have a number and hyphen (e.g. 8099_A_Ghoulish_Darta_Knight_Wear) which may suggest the number is a key.
The "_Wear" and "_Trade" make sense, I suppose, if I understand what that is signifying... Is the "8099" the lootdrop_id as found in table lootdrop_entries ? Or is "id" in table: lootdrop key for lootdrop_id in table lootdrop_entries? I would think "equip_item" in table: lootdrop_entries would cover whether or not it is "worn" (or "_Wear"). Is the table: lootdrop used then?
Where's the smiley shooting himself in the head at? :/
|