Database loot tables
Posted: Mon Jan 28, 2013 3:44 pm
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.
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.