- Home /
RPG Quest structure in MySQL
Hello everyone,
I'm creating an online RPG and I've been looking around for a way to save players' progressions in quests in MySQL. I've been looking at this answer for a while and I've come to the conclusion that this might work, but then my question would be:
Where/how do I store if a player currently has a quest accepted? How do I keep track of at which step of the quest the player currently is? This has to be saved somehow but I can't seem to figure out how I would do that. Let me know if you can help me out.
Thanks!
Why not do the same with Player progression ? You have to store the Player information somewhere anyway and chances are that you most probably will want to use a Database for that, so what would stop you from having a Table with information about Quests player have accepted and the current status they are at ?
If the Quests have multiple steps, it would be as easy as storing the Players ID, the Quest ID and the step on which the player is on. (not counting of course, other requirements that you might or might not have)