06-13-2008, 08:07 PM
|
#7 (permalink)
|
|
The Wanderer
Join Date: Jun 2008
Posts: 8
Thanks: 1
|
Quote:
Originally Posted by dschreck
You insert into the lookup table multiple times....
IE:
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.
Quote:
|
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). |
|
|
|