Abandoned Quizzes

Hi Matt --
Love the quiz module, it's beautifully designed. I downloaded Quiz
6.x-2.0, hoping it would handle abandoned quizzes. Right now, Quiz counts
a viewing of the first question as an actual test, whether a question is
answered or not. This led me to wonder about abandoned quiz efforts and
the possibility of starting a viewer where they left off during a quiz.
I'm new to Drupal, but have been coding in PHP for awhile. I haven't yet
learned how to play in the Drupal development arena, so I hope I'm sending
this code snippet to the right person. If not, please forward it. To
resolve this "unexpected feature" (so much nicer than bug..), I added a new
function "quiz_is_active" to be called from your function
"quiz_start_actions". Both are below. Please feel free to write back with
questions/comments. I've tested this and it works -- please let me know if
this seems worthwhile to you.

best,
- terri
________________________________________________________________________
function quiz_start_actions($quiz) {
global $user;

$user_is_admin = user_access('create quiz');

// Make sure this is available.
if ($quiz->quiz_always != 1) {
// Compare current GMT time to the open and close dates (which should
still be in GMT time).
$now = gmmktime();
if ($now >= $quiz->quiz_close || $now < $quiz->quiz_open) {
drupal_set_message(t('This @quiz is not currently available.',
array('@quiz' => QUIZ_NAME)), 'status');
if (!$user_is_admin) {
// Can't take quiz.
return FALSE;
}
}
}

// Check to see if this user is allowed to take the quiz again:
if($quiz->takes > 0) {
$query = "SELECT COUNT(*) AS takes FROM {quiz_node_results} WHERE uid
= %s AND nid = %s AND vid = %s";
$taken = db_result(db_query($query, $user->uid, $quiz->nid,
$quiz->vid));
$allowed_times = format_plural($quiz->takes, '1 time', '@count
times');
$taken_times = format_plural($taken, '1 time', '@count times');

// The user has already taken this quiz (nid/vid combo).
if ($taken) {
// If the user has already taken this quiz too many times, stop the
user.
if ($taken >= $quiz->takes) {
drupal_set_message(t('You have already taken this quiz @really.
You may not take it again.', array('@really' => $taken_times)), 'error');
if (!$user_is_admin) {
return FALSE;
}
}
// If the user has taken the quiz more than once, see if we should
report this.
else if (variable_get('quiz_show_allowed_times', TRUE)) {
drupal_set_message(t("You can only take this quiz @allowed. You
have taken it @really.", array('@allowed' => $allowed_times, '@really' =>
$taken_times)), 'status');
}
}
}

// Check to see if the (a) user is registered, and (b) user alredy
passed this quiz.
if ($user->uid && quiz_is_passed($user->uid, $quiz->nid, $quiz->vid)) {
drupal_set_message(t('You have already passed this @quiz.',
array('@quiz' => QUIZ_NAME)), 'status');
}

// On error, we want to return before here to avoid creating an empty
entry in quiz_node_results.
// Otherwise, we get fairly clutter Quiz Results.

// Insert quiz_node_results record.
// TJT: OK, you need to initialize record prior to adding answers,
// perhaps you could check for if abandoned quiz exists first
$active_quiz = quiz_is_active($user->uid, $quiz->nid, $quiz->vid);

if(isset($active_quiz)) {
return $active_quiz;
} else {
$result = db_query(
"INSERT INTO {quiz_node_results} (result_id, nid, vid, uid,
time_start) VALUES (%d, %d, %d, %d, %d)",
$rid, $quiz->nid, $quiz->vid, $user->uid, time()
);
if ($result) {
// Return the last RID.
return db_last_insert_id('quiz_node_results', 'result_id');
}
else {
drupal_set_message(t('There was a problem starting the @quiz. Please
try again later.', array('@quiz' => QUIZ_NAME), 'error'));
return FALSE;
}
}
}

/**
* TJT: Check a user/quiz combo to see if the user has an active quiz.
* This will return the RESULT_ID of any incomplete quiz and allow the
user
* to continue and complete the quiz.
* @param $uid
* The user ID.
* @param $nid
* The node ID.
* @param $vid
* The version ID.
*/
function quiz_is_active($uid, $nid, $vid) {
$arid = db_result(db_query("SELECT result_id as arid
FROM {quiz_node_results}
WHERE vid = %d AND nid = %d AND uid =%d AND time_end IS NULL",
$vid, $nid, $uid
));

return $arid;
}