Inventory Structure

[austin070]

Hey guys,

I'm working on implementing an inventory system. I was wondering what would be the best way to structure it in my script and in my SQL database. Is this type of thing normally associated with the primary users table or would it be better to link a player inventory table to the users table through primary key?

[Plastikmensch]

I would recommend to keep things separate.
the primary table only for important stuff like username, password, money, score...
and another one for the inventory.
As for code structure: This really just depends on preference.
And creating a own table for the inventory could have some advantages, but that depends on what you want and how you want to do it.

[DRIFT_HUNTER]

Keep things separate. In fact i would make containers for items and reuse them for things like vehicle storage, boxes and other stuff.

[austin070]

Originally Posted by DRIFT_HUNTER

Keep things separate. In fact i would make containers for items and reuse them for things like vehicle storage, boxes and other stuff.

I've seen this in the form of briefcases. I'm not entirely sure of the best way to code that, however. I went ahead and made a general inventory table, a weapons inventory table, and an ore inventory table. I definitely see how much easier that is than putting all of that information in a single table.

[d3Pedro]

You can go by making it separate, just like you do vehicles for example, make the same thing with inventory and load it from player username or a player row id.

[Gammix]

Here's how i would do it, so i am making this database schema based on your server has dynamic inventory items and item types.

Table: "ItemTypes"

id

Table: "Items"

id

[austin070]

Originally Posted by Gammix

Here's how i would do it, so i am making this database schema based on your server has dynamic inventory items and item types.

Table: "ItemTypes"


Table: "Items"

This is very helpful. Thank you for taking the time to write that post.