Quote:
Originally Posted by ghanja
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? :/
|
you can pretty much ignore the name field of the lootdrop table entirely as it simply gives a "human readable" name (please note the quotations) to the lootdrop record, which doesn't really have anything to do with mechanics. it's just a note. records in loottable_entries and lootdrop_entries both relate to each other by way of lootdrop_id.