I've started learning web development using Visual Studio, and a new feature I've learned is something called the 'Entity Framework' model/system.
It allows you to bind to a database context, and then graphically create your database objects, and then have your entity model sent to the database and have the tables created automatically.
I've done an example one here to show how you could actually easilly plan and create a game system using the model.
You can see I have a 'User' entity (logins)
Which maps to Servers - (one user can have multiple servers) : I was thinking about provisioning NWN Servers programatically - but forget about this for the time being.
Each user then has one or more GameAccounts (bioware login names)
Which can then have multiple characters associated with each game account.
Each character has 1 inventory
Which then has multiple instances of 'Item' entity.
I believe I can couple this with web services to have in-game data represented in an online web site.
Eg: Entire Inventory viewable, character information, even the ability to delete characters through web GUI etc, without the need for polling a heartbeat script etc.
Has anyone ever experimented with this?
Modifié par Baaleos, 14 février 2014 - 01:23 .