What is the best way to structure this database?
View Single Post
06-13-2008, 06:51 AM
Join Date: Jun 2008
dschreck, that is exactly how I first created it, only problem is that monsters can drop more then one item at a time, also that certain item can be in more then one quantity. Just making 2 rows doesn't work because then I can't count the rows to see how many times it has been killed.
Ork dropped 1 bone, 6 gold, 1 ork skin. Ork dropped 1 bone, 3 gold.
EDIT: I could keep in the monster table how many times its been killed and increase it every time.
View Public Profile
Send a private message to TexasMd91
Find More Posts by TexasMd91