Loot tables example?

[chrsschb]

Three separate loot drops (using new system)

1. A) 100% drop, 2 min drop, 2 max drop, 2 multiplier

2. B) 100% drop, 1 min, 1 max, 1 multi

3. C) & D) 30% drop ea, 0 min, 1 max, 1 multi

lootdrop : assigns a lootdrop id to an npc
lootdrop_entries : assigns items, multipliers, drop chance, etc to a specific lootdrop
loottable : sets the lootable identifier for that specific npc, also adjust mincash, maxcash, and avgcoin
loottable_entries : assigns lootdrops to a specific loottable, sets the probability, and sets the multiplier

I highly recommend downloading GeorgeS tools, specifically his NPC and Item editors as these will simplify the loot creation process. Since the loot tables are being revamped you will need to provide him a little time to update his tools to use the new loot system. If you haven't upgraded to the new loot system then his current tools will work fine.

[ghanja]

Originally Posted by chrsschb

Three separate loot drops (using new system)

1. A) 100% drop, 1 min drop, 1 max drop, 2 multiplier

2. B) 100% drop, 1 min, 1 max, 1 multi

3. C) & D) 30% drop ea, 1 min, 1 max, 1 multi

These are all lootdrop_entries which would go under a single loottable. This single loot table would be assigned to your respective wolves.

Appreciate your time. Unfortunately, brings me no closer to understanding than where I was I'm afraid (besides understanding the new system -- maybe). I don't have my head wrapped around this yet, I know, I may have a question regarding #3 above. I'll keep from asking it until I have a grasp on this, which I know must be elementary to many.

"loottable" from what I can tell, is just how much coin drops, or is the ID from this table linked/relationship elsewhere?

Assuming totally empty DB "tables" which tables would receive entries and what would they look like?

Ex:

"loottable"

id     name                  mincash     maxcash     avgcoin
----  ----------------- ---------- ----------- ------------
1      a_Big_Bad_Wolf    1              220           0

"lootdrop entries"

lootdrop_id    item_id     item_charges    equip_item   chance   minlevel maxlevel    multiplier
------------  -------     ------------    -----------  -------   -------- --------    ---------
              1    1001                       1                  1          1             0       127           1

And so on. IOW go in this assuming I know nothing, if you would, and if you dont mind spending the time.