I'll try this out the next time I want to reset all the stats. I've already started a new contest so I don't want to disturb the data for now. Thanks for the help. It's been a busy 1st quarter.

Absolutely... sorry for the delay, gets hectic sometimes. These were all created with the mod installation. You should have copies of the original files you sent me for deleting users info and quiz info from my PM to you. Tables and Fields phpbb_quiz quiz_id quiz_name quiz_author quiz_enabled quiz_c...

I want to reset all the stats for the current quizzes. I'd like to be able to do it with one swoop, truncate the plays, stats and members but keep all the quizzes so everyone can start over and so I can start a new contest. We get new members so the questions will always be good so even maybe a cut-...

The quiz contest worked out fine and now I want to open up the quizzes for everyone to play as they like but I would like a couple Modifications if you have the time. First there is a section at the bottom of the stats page that shows the names of all the quizzes and how many times they have been pl...

I've tried your latest addition to my request and it worked great. Specific member and specific quiz deleted just fine. Others may be able to use this as well. Thanks again for all your help.

Thanks for the fix... I've been gone because I was sick and then I had to go out-of-town for a few days on John Wayne business. That looks like exactly what I need and since I have it set so they can only play a quiz once, multiple plays of the same quiz is not a problem. Thanks again for your time ...

I have another option for you... what if someone make a valid mistake and hit "Enter" before they were done with a quiz. Now I know he quiz gets assigned a number. If I wanted to delete quiz #4 or q=4 for user# 738 or $q_user_id = 738, could that be put in that SQL deletion routine so I ca...

Here is the file: Look for these: // Edit these $q_user_id = 738; $q_quiz_table = 'phpbb_quiz_statistics'; Edit the number to change the user_id, and if you use a table prefix other than phpbb_ you can change the $q_quiz_table variable to reflect this. :) As always when deleting data, it is advisab...

Yes, but unfortunately I have no access. I told you, these people are really strict on access. Eventually I will dump the quizzes as they get old so the blanks will leave then I guess. Okay. What about FTP access? If I gave you a file with which to run containing this SQL query, would you be able t...

Yes, but unfortunately I have no access. I told you, these people are really strict on access. Eventually I will dump the quizzes as they get old so the blanks will leave then I guess.

I tried it and it didn't do a thing... no change at all.

Sorry... I've been gone for a few days... Here is the quiz_stats.php file. Thanks! <?php /*************************************************************************** * quiz_stats.php * ------------------- * begin : Fri, Nov 18, 2005 * copyright : (C) 2005 Battye @ CricketMX.com * email : cricketmx@h...

If you read my Intro post you see that I have a forum that just loves this Quiz mod... and as Administrator it's not that hard of a mod to handle but there are a couple things I'd like to see done or added or made available on this Quiz mod. First would be a sorting function on the Quiz Stats page. ...