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.