I'm considering trying to use Construct2 for a new action RPG idea I have. My plan is to use Construct as the front-end, but still store all of the user and game data in a MySQL database, and use PHP to process all the game logic on the server side.
My idea is that I would have a series of generic layouts that load different resources from the MySQL database via AJAX depending on what the user is doing. For example, the user might enter a building. This would cause all of the assets and graphics for the interior of the building to be loaded (layout background, furniture, NPCs, etc) dynamically from the server via AJAX. Another example might be that a user opens a chest. This would dynamically load from the server a list of the contents of the chest for the user to view and manipulate, and then update the server if the user takes something from or puts something in the chest.
Is this something that makes any kind of sense, or is this totally the wrong way of going about handling RPG game assets within Construct? I've been trying and failing to wrap my head around the best practices for storing and retrieving large amounts of data with Construct. It would be nice if I could keep it all internal within Construct itself, but this seems totally impractical to me since the game could potentially have hundreds (or thousands) of items, NPCs, locations, attributes, etc, etc. Additionally I'm a lot more familiar and comfortable coding game logic with PHP, processing all game logic server-side also has a number of inherent security benefits, and storing all game data server side allows for adding new content with relative ease.
I'm trying to make an RPG which will have lots of stuff in it (hundreds of items, NPCs, locations, attributes, etc). What is the best method to store and retrieve large amounts of data such as this using Construct2?
Thanks for your help!