function _get_quiz_status_chart in Quiz 6.6
Same name and namespace in other branches
- 8.6 modules/quiz_stats/quiz_stats.admin.inc \_get_quiz_status_chart()
- 8.4 modules/quiz_stats/quiz_stats.admin.inc \_get_quiz_status_chart()
- 8.5 modules/quiz_stats/quiz_stats.admin.inc \_get_quiz_status_chart()
- 6.4 includes/quiz_stats/quiz_stats.admin.inc \_get_quiz_status_chart()
- 7.6 modules/quiz_stats/quiz_stats.admin.inc \_get_quiz_status_chart()
- 7 includes/quiz_stats/quiz_stats.admin.inc \_get_quiz_status_chart()
- 7.4 includes/quiz_stats/quiz_stats.admin.inc \_get_quiz_status_chart()
- 7.5 modules/quiz_stats/quiz_stats.admin.inc \_get_quiz_status_chart()
- 6.x modules/quiz_stats/quiz_stats.admin.inc \_get_quiz_status_chart()
1 call to _get_quiz_status_chart()
- quiz_dashboard_get_adv_stats in includes/
quiz_dashboard/ quiz_dashboard.admin.inc
File
- includes/
quiz_dashboard/ quiz_dashboard.admin.inc, line 144
Code
function _get_quiz_status_chart($nid = 0, $uid = 0) {
// get the pass rate of the given quiz by nid
$pass_rate = db_result(db_query("SELECT pass_rate FROM {quiz_node_properties} WHERE nid = %d", intval($nid)));
// get the count value of results row above and below pass rate
$sql = "SELECT SUM(score > {$pass_rate}) AS no_pass, SUM(score < {$pass_rate}) AS no_fail, SUM(score = 0) AS no_incomplete FROM {quiz_node_results} WHERE nid = %d";
$quiz = db_fetch_array(db_query($sql, intval($nid)));
if ($quiz['no_pass'] + $quiz['no_fail'] + $quiz['no_incomplete'] < 3) {
return;
// no sufficient data
}
// generates quiz status chart 3D pie chart
$output = '<div id="get_quiz_status_chart" class="quiz-dashboard-chart-space">';
$output .= theme('get_quiz_status_chart', $quiz);
$output .= '</div>';
return $output;
}