Loot tables example?

[ghanja]

Can't seem to get my head wrapped around it.

I'd like to ask for a template of sorts. I realize this will take someone some time (maybe though, depends on your proficiency I guess) to type out using code blocks and such, regardless your time IS value and I thank you.

Let's go with three example items in the items table:

A) Rabid Tooth
B) PETA Approved Fur Coat
C) Decorative Wolf Skull
D) Little Red Robin Guts

So, loot A, B, C and D.

The NPC:

1) Big Bad Wolf

Zones found:

a) gfaydark
b) ecommons


Loot B is worn by NPC 1, loot A, C and D are drops.

Loot A will drop all the time, guaranteed drop, times two.

EITHER loot C -or- D is 30% chance (probability, or whatever it's called anymore) of dropping, times one. So between C and D, one or the other will drop, but, the chance of either of them dropping is 30% and only one will drop. (hoping I explained that correctly)



Great, now.. where to begin? I haven't a clue. First step, is to establish and legitimize the items, ok, items are in the items table.

Assuming tables: lootdrop, lootdrop_entries, loottable and loottable_entries (the only ones I'm aware of that decide loot, are there others?) have no entries/records, what would go where?

What is the order in which I should deal with these tables?


I realize this may appear to some or many as the lazy (do the work for me) approach and I may just agree with you, to a point. I learn very quickly by example, though, when tables are fully populated as is the case "out of the box", I get flustered, confused and I haven't gotten a single brain cell that isn't filled with "stupid" when looking at them all. I just -might- be making things more complex than necessary, I'll agree with that as well, but again, refer to "stupid" brain cells.

Please help. <enter shameless plug> am looking for a developer btw. I've been told there normally isn't "compensation" involved other than the developer's desire to work on the proposed content for either fun, challenge, etc. though, I believe everyone's time is worth -something- even if it's just enough to get the stereotyped hot pockets and pepsi/coke/monster, etc. (Sweet chili dorito's are my vice, along with chicken in a bisquit and coffee but whatever floats your boat). Though that's not to say, I wish to be continually ignorant of the workings of EQEMU, thus the question. (To a developer who may be interested, no, I don't plan to have actual loot of "PETA Approved Fur Coat" and "Red Robin Guts" albeit, I wanted to inject some humor in the question posed.)

Thank you in advance, it's greatly appreciated..