What is the best way to structure this database?
View Single Post
06-12-2008, 09:13 AM
Join Date: Nov 2007
Location: the Netherlands
Well, what you
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?)
Who doesn't like martial arts? =)
View Public Profile
Send a private message to Jim
Visit Jim's homepage!
Find More Posts by Jim