2
votes
1answer
75 views

How should I store grid-based character inventories in the database?

I used to encode the whole inventory data into binary but I'm thinking of doing something different now. The inventory has a 64 slots in an 8×8 grid. Large items like weapons fill up 6 to 8 ...
2
votes
1answer
150 views

RPG - storing player data

Given the following tree structure, where each player logged in can have data for current and completed levels, quests per level, NPCs per quest, and multiple tasks per NPC... I'm trying to figure out ...
0
votes
1answer
186 views

How to setup Authentication Database and Game Database?

I'm playing around with creating a game in C# using the XNA Framework. I've decided to use technologies that I'm pretty much familiar with and create things from scratch. There are probably frameworks ...
5
votes
1answer
734 views

MySQL - Storing Character Inventory

What is the best way of storing the character's inventory (consisting of each item having a value for type and quantity). The only methods I can think of is to use the "text" type of field then parse ...