06-13-2008, 05:03 PM
|
#6 (permalink)
|
|
The Contributor
Join Date: Nov 2007
Location: California
Posts: 56
Thanks: 0
|
Quote:
Originally Posted by TexasMd91
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.
|
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);
Not sure what you'd do with Gold... but that would probably go into their items...
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.
But if you're just trying to record what items drop off of what monster, the drops look up table should work fine. |
|
|
|