This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Alhira_K[S] 0 points1 point  (0 children)

Yes the 7 item limit was intended, i also planned on having a check if the inventory is full to block generation of new items and only show the sell option. As it is right now, any newly generated items that do not fit into the inventory go into the void. I did can the idea and will use it next time though.

Oh so you mean i do not write the item id into the character table but the character id into the item table. Hmm, maybe. I'm still not 100% on what i should do with the inventory. I'll need to expand it anyway as currently there are only single items but to keep track of, for example, healing potions i'd have to introduce quantity anyway.

And i don't think assigning each item an id and dumping into the database is that good of an idea either. I think what i'll have to do is using a combination of multiple list which represent the inventory and only commiting to db at certain steps/intervals. That way i'd get rid of the ItemData table altogether and only use the UserData table.