: This is taking longer than I thought. Mainly because I've confuzed myself silly with the id's that were needed. But now its starting to look good. Here was the problem, The main Quiz Topic needed a topic and then questions had to be identified to this topic. However Answers needed to be linked with the questions. So I took care of this by making three tables, each with a main id. The questions table also has an extra id field which records which Quiz Topic it belongs to. The answers work the same way but record wich Question they belong to.
Reason for this
: This is so an Admin could setup a Quiz Topic with unlimited questions / answers. Basically in your ACP you'll be able to add a new Quiz, edit that quiz and Add questions to it. It works like how the Ranks System works. If you want a new Rank you just add a new one. In the question editor you'll be able to add as many possible answers to the question as you see fit. There will also be a radio toggle so you can click on which answer is the right answer. This won't be shown to users until they finish the quiz.
: Theres also slots for charging/rewarding users per Quiz Topic, Question, and Answer. This will help in configuring your quiz charging methods. If you only want to charge/reward per quiz then you can. If you want to take it a step further then you can also charge/reward for each question answered. Theres also a Bonus slot if you wish to reward your users for completing the quiz with all questions answered correctly.
If anyone else has any ideas that haven't been posted here
, then please list them now so they can be included when all the hard stuff has been done.