// the logged Javascript timestamp // prepare the log array $logArray = array(); // to be stored for ($i = 0, $j = 3; $i < sizeof($logtime) / 3 - 1; $i++, $j += 3) { $logArray[$i] = array($logtime[$j], $logtime[$j + 1], ($PHPstartTime + $logtime[$j + 2] - $JSstartTime) / 1000); } //---------------------------------------- // Calculate points and achievements //---------------------------------------- // prepare the achievement array for possible multiple achievements $achievement_array = array(); // Calculate Points to award $achievement_array = $member->calculatePoints($quiz->quiz_id, $quiz->isPublished(), $achievement_array); // Check for achievements $achievement_array = checkAchievements($facebookID, $achievement_array); //---------------------------------------- // Retrieve Quiz results for display //---------------------------------------- // select the result data $query_getResultInfo = "SELECT * FROM q_results WHERE result_id = " . $row_getResults['fk_result']; $getResultInfo = mysql_query($query_getResultInfo, $quizroo) or die(mysql_error()); $row_getResultInfo = mysql_fetch_assoc($getResultInfo); $totalRows_getResultInfo = mysql_num_rows($getResultInfo); // get results to build the pie chart //$query_getResultChart = sprintf("SELECT COUNT(*) AS count, result_title FROM q_store_result, q_results WHERE q_store_result.fk_quiz_id = %d AND result_id = fk_result_id GROUP BY fk_result_id", $quiz->quiz_id); $query_getResultChart = sprintf("SELECT count, result_title FROM (SELECT COUNT(*) AS count, fk_result_id FROM q_store_result WHERE q_store_result.fk_quiz_id = %d GROUP BY fk_result_id) r RIGHT JOIN (SELECT result_id, result_title FROM q_results WHERE fk_quiz_id = %d) t ON r.fk_result_id = t.result_id", $quiz->quiz_id, $quiz->quiz_id); $getResultChart = mysql_query($query_getResultChart, $quizroo) or die(mysql_error()); $row_getResultChart = mysql_fetch_assoc($getResultChart); $totalRows_getResultChart = mysql_num_rows($getResultChart); if ($quiz->isPublished() && $totalRows_getResultChart != 0) {
$achievement_array = array(); // set the quiz as published $level = $quiz->publish($member->id); if ($level == false) { // authentication error $quiz_exist = false; } elseif ($level == -2) { // publish failed, redirect user header("Location: modifyQuiz.php?step=4&id=" . $quiz->quiz_id); } else { if ($level != -1) { $achievement_array[] = $level; // provide the ID of the level acheievement } // check if there are any achievements $achievement_array = checkAchievements($member->id, $achievement_array); } //---------------------------------------- // Display splash screen with results //---------------------------------------- $achievement_details = retrieveAchievements($achievement_array); } } else { $quiz_exist = false; } } else { $quiz_exist = false; } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml">