Loading new missions for RPG from SQL Database

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.

Maybe this can help:

You can access pages in Unity with the WWW class


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.