Originally Posted by Jim

Well, what you can do, is make a kill table. Every kill of a monster will be stored in that table. With simply the user_id and monster_id. Then you can make a drop table which coresponds to the kill table: kill_id, drop_type, quanity, and just store every droptype in a new record.

This might not be the best option since i don't know if you want to store the kills, but maybe it helps you in a way.


(I don't get it btw, why store the drops in a database? Can't you just randomize the drop with each kill and automatically store the drops in the inventory of the users?)