AI Use Case: Untangle quest chains

I am currently recycling quest chains from our 12 year old game The Fishing Club 3D into our new game: Fishing Friends 3D. The quests are stored in a database and are linked by using previous_quest_id fields. There a lot of quests spread over several quest chains and the order is all over the place. So it would be really nice to have all the separate quest chains laid out in a flowchart.

Screenshot

Let’s see if OpenAI’s o1-model can do the trick by providing a pretty rough-shot prompt and pasting in the the “quests” table.

Screenshot

After “reasoning” for 3 minutes and 7 seconds the model returns some Mermaid code and let’s me know that some previous quests IDs are missing.

Screenshot

A minute later and I have my flowchart (excerpt):