Display quiz results on member page

This is currently not a feature available, but I am looking into implementing it within the next few releases.

Ollie

Rough, that’s essentially the single most valuable feature I can think of. Is there an SQL query that I could use to pull the data from the database, if the user were $user? .

I’ll look into this…

Thank you very much.

SELECT percentage FROM YOURTABLEPREFIX_wpsqt_all_results
where person_name = ‘value’

You can also pull out SCORE and TOTAL
value is the persons name.

There is a PERSON field that’s an array of data as well.

I apologize Joe, I am a bit of a lamen when it comes to pulling data from the db with mysql. Would you mind clarifying a bit with php. Also, I absolutely am going to want to display the score and total.

This page is a good overview. I could post the code but then it would get into “it doesn’t work for me” and we’d go back and forth. Learn the fundamentals on this page and you’ll do great.

I’ll only add one thing. On that page, they say “SELECT *” which pulls all fields from the table. You want score and total so it would be similar to: “SELECT score, total, percentage”

Excellent, I appreciate it.

All,

As I said, I will be implementing this in the next release. You can probably expect it within the week.

Ollie

Thanks Ollie,
How are you planning on implementing it? Would it use a shortcode where you would specify the user? e.g. [quiz user=”name”] or do you have something else in mind?

Let’s give him some time to implement it first and then tell us how he does it. As a programmer myself, I can tell you what works in my head doesn’t always work out that way.

Fair enough, I look forward to seeing the results.

I will likely implement a shortcode for ease of use. Something else may happen though as I haven’t started to look at it yet – have major bugs that need fixing first.

How about a widget with top scores? I would love that as well. Good luck Ollie!

Another good idea. Will try and get that done – quite busy this week.

Ollie