Loot tables example?

[c0ncrete]

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.

[ghanja]

Originally Posted by c0ncrete

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.

So the table: lootdrop is nothing more than a table created for comments/reference? Or does the "id" field relate to something? (haven't looked yet to see if there is a relation -- just asking preemptively)

[c0ncrete]

Originally Posted by ghanja

So the table: lootdrop is nothing more than a table created for comments/reference? Or does the "id" field relate to something? (haven't looked yet to see if there is a relation -- just asking preemptively)

there is a lootdrop_id field in both the loottable_entries and lootdrop_entries tables. it's what ties them together, via the corresponding record in the lootdrop table, which really serves no other purpose. it didn't really make a whole lot of sense to me either when i first started digging into how it was all put together.

[ghanja]

Originally Posted by c0ncrete

there is a lootdrop_id field in both the loottable_entries and lootdrop_entries tables. it's what ties them together, via the corresponding record in the lootdrop table, which really serves no other purpose. it didn't really make a whole lot of sense to me either when i first started digging into how it was all put together.

Ok ok. Between missing the "loottable_id" field in the NPC_TYPES table and thinking that the LOOTDROP table was functional, no wonder I hadn't a clue.

I appreciate everyone's time in answering, it truly is appreciated, hope you all know that.. for sure.

Now, time to begin adjusting/populating, as I don't have an excuse any longer not to do so... sooooo, thanks? :p