Loading new missions for RPG from SQL Database

Questions & Answers
1

Hey all,

We're currently in the development stages of making an RPG that will query a SQL Database and search for new missions/quests.

Has anybody had experience in adding new content for a game from a server/database in unity? I'm not worried about connecting to the database or pulling information, but what about taking the data from the server/database and turning them into in-game missions?

I was thinking about using a C# class pattern to construct the missions from the data and instantiate the NPCs and objects needed.

Is this a good idea? Any comments or concerns would be appreciated.

2

Maybe this can help:

You can access pages in Unity with the WWW class

http://unity3d.com/support/documentation/ScriptReference/WWW.html

Maybe you can make some pages in PHP or ASP and Post data by this class. This class can also retrieve information in the page.