17.09.2016, 15:57
So you have the main users table (password and all the important data) and another table for the created characters (and their statistics)? At least, that's how I'd do it.
Then a query that selects the name of each character for that player, a loop through all rows to retrieve the name and re-format it with the rest. When the loop is done, concatenate a text to allow the player create a new character.
When the player responses to an item from the dialog, check if inputtext is equal to the last sentence (to create a new character) to continue with the new name, age, etc otherwise execute a query that selects all the data where character name is the inputtext.
Then a query that selects the name of each character for that player, a loop through all rows to retrieve the name and re-format it with the rest. When the loop is done, concatenate a text to allow the player create a new character.
When the player responses to an item from the dialog, check if inputtext is equal to the last sentence (to create a new character) to continue with the new name, age, etc otherwise execute a query that selects all the data where character name is the inputtext.