Database loot tables

[Criimson]

Hello everyone
So I posted this in another thread, but after thinking about it I decided to post a thread in a more appropriate place. (BAH still in wrong place...this needs to be in DB Dev forum).

Anyway, I plan on creating loot tables zone by zone (starting with the newbie zones and workign upwards) for all of the MoBs.
I found ZAM has drop rates (woot taime saver) and am wondering if this would cause any issues or be a waste of time what with the DB changes.
I would like to help create a live like DB for the community and this seems like a good place to start.
I also realize that being new to the DB/emu that you guys might have ideas on this.

One thing I notice is that there are only 2 loot tables in the DB (not a big issue) but looking at the spawn table I notice that there is no loot table reference.
I assume in the code ( I haven't looked it over yet) that on death the loottable reference is hard coded to the generic loot table id.
For now I'll start by adding some loot tables (starting with the Queen's colony) and we can add the code to check for it at some point.


Criimson

So after looking into ZAM a bit more and looking at the loot table in the DB I decided the most efficient way to do this would be to write an SQL query.
ZAM lists the soe item id for items
(Anyone that can format the following into a workign sql query for me? Im doing it off the top of my head and I still look query syntax up)
INSERT INTO eqworld.lootdrop (Id incremental) (loottable id manually entered) (itemid = soe loot id ; manually entered) (item charges = 1; manually entered)(equip item = 0; manually entered)(probability; manually entered)

This query wouuld allow me to have the ZAM window next to the DB query and with a few manual changes I'd be able to add loot tables pretty quickly.

[Jabantiz]

John is the DB/Content guy so all questions about that should be directed to him. I can tell you that a loot table is assigned to a spawn via the spawn_loot table, just takes the spawn id and the loot table id, beyond that I don't know how loot works in the emu.

[Criimson]

Ok well im at work atm. Ill look into it when i get home.
Shouldnt take overly long to get it working

------------------------
EDIT
So I did some testing and got a loot table partially built for "a coastal crab" based on http://eq2.zam.com/db/mob.html?eq2mob=b ... e011#Drops
And everything seems fine.
I'll get started on populating the loot tables for this zone and wait to hear from John about it.
Right now I'm thinking of using a naming convention for the loot tables along the lines of:
XXXYYYY - Where XXX is the zone and YYYY is just 0000, 0001, etc in alphabetical order (or as listed on ZAM - which is alpha iirc).