コード例 #1
0
ファイル: resultEngine.php プロジェクト: hienvuong/Quizroo
// 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) {
コード例 #2
0
ファイル: publishQuiz.php プロジェクト: hienvuong/Quizroo
            $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">