Show a Random Quiz on single page

I like a challenge. So if you can get an array of random quiz IDs all you’d need is another array of all quiz Ids that person has done, and then go through your first array and if the ID is not is second Array then show that quiz.

So I’ll get some code for you that gets an array of quiz Ids that person has taken.
Give me a day or two to have time to look at it properly.

Alex

OK – what you need to do is query the AI_Quiz_tblQuizAttempts table.
If you’re using multisite you’ll need to check the table prefix.
The following example is the SQL that should return an array of quiz IDs that a user has taken. You can then compare that to the array of quiz IDs you are also creating:

global $wpdb;
		$table_name = $wpdb->prefix . "AI_Quiz_tblQuizAttempts";		

		$SQL='Select quizID FROM '.$table_name.' Where username = "alexfurr"';
		$rs = $wpdb->get_results( $SQL, ARRAY_A );

For historical reasons it stores the data against username (login) rather than user ID.
That should work for you.

Thanks for the code, Alex. I wrote a sql query that generates random quiz id for user that has not attempted yet. Here is the code:

SELECT t1.quizID
FROM wp_AI_Quiz_tblQuizzes t1
LEFT JOIN (SELECT * FROM wp_AI_Quiz_tblQuizAttempts t2 WHERE t2.username = 'admin') t3 ON t3.quizID = t1.quizID
WHERE t3.quizID IS NULL
ORDER BY RANd()
LIMIT 1

This is working on phpmyadmin. Do you think this is also a correct approach? If so, I can use this directly on my page template as a variable that I can pass on to your Quiz ID shortcode. Am I doing it right?