What is the best way to structure this database?
View Single Post
06-13-2008, 07:07 PM
Join Date: Jun 2008
Originally Posted by
You insert into the lookup table multiple times....
Orc Drops 1 Hide, 1 Weapon
INSERT INTO drops VALUES (monster_id_of_orc_goes_here, item_id_of_hide_goes_here);
INSERT INTO drops VALUES (monster_id_of_orc_goes_here, item_id_of_weapon_goes_here);
But then it would register that is 2 kills when really the player only killed it once and got both items in 1 go.
I ended up creating a monDropID which is used to say which drop it is, so if the user gets 2 drops at once then the monDropID will be the same as the first for the second drop.
Another thing to remember, is that with an MMO you really only need to record when someone picks up an item, and keeps it in their inventory.
I am creating a website for users to log in what drops they get (I created a program in c++ which is pretty much a logger where the user can easily insert their drop information.) The statistics will then be used to show how different variables matter. (IE: if the user is wearing a special item which increases drop ratio).
View Public Profile
Send a private message to TexasMd91
Find More Posts by TexasMd91