What is the best way to structure this database?
View Single Post
06-12-2008, 08:22 PM
Join Date: Jun 2008
Originally Posted by
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?)
I am not the one creating the MMO, this is just a site for statistics to see how rare items are.
and that idea is pretty good, I think I will do it that way unless some one else has a better suggestion.
View Public Profile
Send a private message to TexasMd91
Find More Posts by TexasMd91