function writeQuestionStats($i_questionid)
{
global $g_db, $i_counter, $lngstr, $srv_settings;
$i_questionid = (int) $i_questionid;
$i_rSet1 = $g_db->SelectLimit("SELECT * FROM " . $srv_settings['table_prefix'] . "questions WHERE questionid=" . $i_questionid, 1);
if (!$i_rSet1) {
showDBError(__FILE__, 1);
} else {
if (!$i_rSet1->EOF) {
$i_question_text = $i_rSet1->fields["question_text"];
$i_question_type = $i_rSet1->fields["question_type"];
}
$i_rSet1->Close();
}
$i_answers_text = array();
$i_answercount = 0;
$i_answers_correct = array();
$answers_clicks = array();
$answers_clicks_total = 0;
$question_views_total = 0;
$question_correct = 0;
$question_incorrect = 0;
$question_partially = 0;
$question_undefined = 0;
$i_rSet2 = $g_db->Execute("SELECT * FROM " . $srv_settings['table_prefix'] . "answers WHERE questionid=" . $i_questionid . " ORDER BY answerid");
if (!$i_rSet2) {
showDBError(__FILE__, 2);
} else {
while (!$i_rSet2->EOF) {
$i_answercount++;
$i_answers_text[$i_answercount] = $i_rSet2->fields["answer_text"];
$i_answers_correct[$i_answercount] = $i_rSet2->fields["answer_correct"];
$answers_clicks[$i_answercount] = 0;
$i_rSet2->MoveNext();
}
$i_rSet2->Close();
}
$i_rSet3 = $g_db->Execute("SELECT * FROM " . $srv_settings['table_prefix'] . "results_answers WHERE questionid=" . $i_questionid . " ORDER BY result_answerid");
if (!$i_rSet2) {
showDBError(__FILE__, 3);
} else {
switch ($i_question_type) {
case QUESTION_TYPE_MULTIPLECHOICE:
case QUESTION_TYPE_TRUEFALSE:
while (!$i_rSet3->EOF) {
$answers_clicks[(int) $i_rSet3->fields["result_answer_text"]]++;
switch ($i_rSet3->fields["result_answer_iscorrect"]) {
case IGT_ANSWER_IS_INCORRECT:
$question_incorrect++;
break;
case IGT_ANSWER_IS_PARTIALLYCORRECT:
$question_partially++;
break;
case IGT_ANSWER_IS_CORRECT:
$question_correct++;
break;
}
$answers_clicks_total++;
$question_views_total++;
$i_rSet3->MoveNext();
}
break;
case QUESTION_TYPE_MULTIPLEANSWER:
while (!$i_rSet3->EOF) {
if ($i_rSet3->fields["result_answer_text"]) {
$i_answers_given = explode(QUESTION_TYPE_MULTIPLEANSWER_BREAK, $i_rSet3->fields["result_answer_text"]);
foreach ($i_answers_given as $i_answer_given) {
$answers_clicks[(int) $i_answer_given]++;
$answers_clicks_total++;
}
}
switch ($i_rSet3->fields["result_answer_iscorrect"]) {
case IGT_ANSWER_IS_INCORRECT:
$question_incorrect++;
break;
case IGT_ANSWER_IS_PARTIALLYCORRECT:
$question_partially++;
break;
case IGT_ANSWER_IS_CORRECT:
$question_correct++;
break;
}
$question_views_total++;
$i_rSet3->MoveNext();
}
break;
case QUESTION_TYPE_FILLINTHEBLANK:
$i_fillintheblank_text = array();
$i_fillintheblank_clicks = array();
$i_fillintheblank_count = 0;
while (!$i_rSet3->EOF) {
$i_found = array_search($i_rSet3->fields["result_answer_text"], $i_fillintheblank_text);
if (!$i_found) {
$i_fillintheblank_count++;
$i_fillintheblank_text[$i_fillintheblank_count] = $i_rSet3->fields["result_answer_text"];
$i_fillintheblank_clicks[$i_fillintheblank_count] = 1;
} else {
$i_fillintheblank_clicks[$i_found]++;
}
switch ($i_rSet3->fields["result_answer_iscorrect"]) {
case IGT_ANSWER_IS_INCORRECT:
$question_incorrect++;
break;
case IGT_ANSWER_IS_PARTIALLYCORRECT:
$question_partially++;
break;
case IGT_ANSWER_IS_CORRECT:
$question_correct++;
break;
}
$answers_clicks_total++;
$question_views_total++;
$i_rSet3->MoveNext();
}
break;
case QUESTION_TYPE_ESSAY:
while (!$i_rSet3->EOF) {
switch ($i_rSet3->fields["result_answer_iscorrect"]) {
case IGT_ANSWER_IS_INCORRECT:
$question_incorrect++;
break;
case IGT_ANSWER_IS_PARTIALLYCORRECT:
$question_partially++;
break;
case IGT_ANSWER_IS_CORRECT:
$question_correct++;
break;
case IGT_ANSWER_IS_UNDEFINED:
$question_undefined++;
break;
}
$answers_clicks_total++;
$question_views_total++;
$i_rSet3->MoveNext();
}
break;
}
$i_rSet3->Close();
}
switch ($i_question_type) {
case QUESTION_TYPE_MULTIPLECHOICE:
case QUESTION_TYPE_TRUEFALSE:
case QUESTION_TYPE_MULTIPLEANSWER:
case QUESTION_TYPE_ESSAY:
echo '<tr id=tr_' . $i_counter . ' class=rowone>';
echo '<td rowspan=' . ($i_answercount + 5 + ($i_question_type == QUESTION_TYPE_ESSAY ? 1 : 0)) . ' align=right>' . $i_questionid . '</td>';
echo '<td colspan=4><b>' . getTruncatedHTML($i_question_text, SYSTEM_TRUNCATED_LENGTH_LONG) . '</b></td>';
echo '<td rowspan=' . ($i_answercount + 5 + ($i_question_type == QUESTION_TYPE_ESSAY ? 1 : 0)) . ' align=center><a href="question-bank.php?questionid=' . $i_questionid . '&action=editq"><img width=20 height=20 border=0 src="images/button-edit.gif" title="' . $lngstr['label_action_question_edit'] . '"></a></td>';
echo '</tr>';
foreach ($i_answers_text as $key => $val) {
echo '<tr class=rowone>';
echo '<td>' . getTruncatedHTML($val, SYSTEM_TRUNCATED_LENGTH_LONG) . '</td>';
if ($answers_clicks_total != 0) {
$i_answers_clicks_percentage = $answers_clicks[(int) $key] * 100 / $answers_clicks_total;
echo '<td>' . getGauge($i_answers_clicks_percentage) . '</td>';
echo '<td align=right>' . $answers_clicks[(int) $key] . '</td>';
echo '<td align=right>' . sprintf("%.2f", $i_answers_clicks_percentage) . '%</td>';
} else {
echo '<td colspan=3 align=center class=gray>' . $lngstr['label_notapplicable'] . '</td>';
}
echo '</tr>';
}
break;
case QUESTION_TYPE_FILLINTHEBLANK:
$i_sort_order_1 = SORT_DESC;
$i_sort_type_1 = SORT_NUMERIC;
$i_sort_order_2 = SORT_ASC;
$i_sort_type_2 = SORT_STRING;
array_multisort($i_fillintheblank_clicks, $i_sort_order_1, $i_sort_type_1, $i_fillintheblank_text, $i_sort_order_2, $i_sort_type_2);
$i_answercount = min(sizeof($i_fillintheblank_clicks), MAX_STATS_ANSWERS_FILLINTHEBLANK) + 1;
echo '<tr id=tr_' . $i_counter . ' class=rowone>';
echo '<td rowspan=' . ($i_answercount + 5) . ' align=right>' . $i_questionid . '</td>';
echo '<td colspan=4><b>' . getTruncatedHTML($i_question_text, SYSTEM_TRUNCATED_LENGTH_LONG) . '</b></td>';
echo '<td rowspan=' . ($i_answercount + 5) . ' align=center><a href="question-bank.php?questionid=' . $i_questionid . '&action=editq"><img width=20 height=20 border=0 src="images/button-edit.gif" title="' . $lngstr['label_action_question_edit'] . '"></a></td>';
echo '</tr>';
$i = 0;
$i_others_clicks = 0;
$i_others_count = 0;
foreach ($i_fillintheblank_clicks as $key => $val) {
$i++;
if ($i <= MAX_STATS_ANSWERS_FILLINTHEBLANK) {
echo '<tr class=rowone>';
echo '<td>' . getTruncatedHTML($i_fillintheblank_text[$key], SYSTEM_TRUNCATED_LENGTH_LONG) . '</td>';
if ($answers_clicks_total != 0) {
$i_answers_clicks_percentage = $val * 100 / $answers_clicks_total;
echo '<td>' . getGauge($i_answers_clicks_percentage) . '</td>';
echo '<td align=right>' . $val . '</td>';
echo '<td align=right>' . sprintf("%.2f", $i_answers_clicks_percentage) . '%</td>';
} else {
echo '<td colspan=3 align=center class=gray>' . $lngstr['label_notapplicable'] . '</td>';
}
echo '</tr>';
} else {
$i_others_clicks += $val;
$i_others_count++;
}
}
echo '<tr class=rowone>';
echo '<td>' . sprintf($lngstr['page_questionstats_fillintheblank_others'], $i_others_count) . '</td>';
if ($answers_clicks_total != 0) {
$i_answers_clicks_percentage = $i_others_clicks * 100 / $answers_clicks_total;
echo '<td>' . getGauge($i_answers_clicks_percentage) . '</td>';
echo '<td align=right>' . $i_others_clicks . '</td>';
echo '<td align=right>' . sprintf("%.2f", $i_answers_clicks_percentage) . '%</td>';
} else {
echo '<td colspan=3 align=center class=gray>' . $lngstr['label_notapplicable'] . '</td>';
}
echo '</tr>';
break;
case QUESTION_TYPE_RANDOM:
echo '<tr id=tr_' . $i_counter . ' class=rowone>';
echo '<td rowspan=5 align=right>' . $i_questionid . '</td>';
echo '<td colspan=4><b></b></td>';
echo '<td rowspan=5 align=center><a href="question-bank.php?questionid=' . $i_questionid . '&action=editq"><img width=20 height=20 border=0 src="images/button-edit.gif" title="' . $lngstr['label_action_question_edit'] . '"></a></td>';
echo '</tr>';
break;
}
echo '<tr class=rowone><td colspan=4><img src="images/1x1.gif" width=1 height=5></td></tr>';
echo '<tr class=rowone>';
echo '<td>' . $lngstr['page_questionstats_correct_count'] . '</td>';
if ($question_views_total != 0) {
$question_correct_percentage = $question_correct * 100 / $question_views_total;
echo '<td>' . getGauge($question_correct_percentage, 'green') . '</td>';
echo '<td align=right>' . $question_correct . '</td>';
echo '<td align=right>' . sprintf("%.2f", $question_correct_percentage) . '%</td>';
} else {
echo '<td colspan=3 align=center class=gray>' . $lngstr['label_notapplicable'] . '</td>';
}
echo '</tr>';
echo '<tr class=rowone>';
echo '<td>' . $lngstr['page_questionstats_partially_count'] . '</td>';
if ($question_views_total != 0) {
$question_partially_percentage = $question_partially * 100 / $question_views_total;
echo '<td>' . getGauge($question_partially_percentage, 'yellow') . '</td>';
echo '<td align=right>' . $question_partially . '</td>';
echo '<td align=right>' . sprintf("%.2f", $question_partially_percentage) . '%</td>';
} else {
echo '<td colspan=3 align=center class=gray>' . $lngstr['label_notapplicable'] . '</td>';
}
echo '</tr>';
echo '<tr class=rowone>';
echo '<td>' . $lngstr['page_questionstats_incorrect_count'] . '</td>';
if ($question_views_total != 0) {
$question_incorrect_percentage = $question_incorrect * 100 / $question_views_total;
echo '<td>' . getGauge($question_incorrect_percentage, 'red') . '</td>';
echo '<td align=right>' . $question_incorrect . '</td>';
echo '<td align=right>' . sprintf("%.2f", $question_incorrect_percentage) . '%</td>';
} else {
echo '<td colspan=3 align=center class=gray>' . $lngstr['label_notapplicable'] . '</td>';
}
echo '</tr>';
if ($i_question_type == QUESTION_TYPE_ESSAY) {
echo '<tr class=rowone>';
echo '<td>' . $lngstr['page_questionstats_undefined_count'] . '</td>';
if ($question_views_total != 0) {
$question_undefined_percentage = $question_undefined * 100 / $question_views_total;
echo '<td>' . getGauge($question_undefined_percentage, 'gray') . '</td>';
echo '<td align=right>' . $question_undefined . '</td>';
echo '<td align=right>' . sprintf("%.2f", $question_undefined_percentage) . '%</td>';
} else {
echo '<td colspan=3 align=center class=gray>' . $lngstr['label_notapplicable'] . '</td>';
}
echo '</tr>';
}
}
function writeTestStats($i_testid)
{
global $g_db, $lngstr, $srv_settings;
$i_testid = (int) $i_testid;
$i_test_name = '';
$i_gscaleid = 0;
$i_rSet1 = $g_db->SelectLimit("SELECT * FROM " . $srv_settings['table_prefix'] . "tests WHERE testid=" . $i_testid, 1);
if (!$i_rSet1) {
showDBError(__FILE__, 1);
} else {
if (!$i_rSet1->EOF) {
$i_test_name = $i_rSet1->fields['test_name'];
$i_gscaleid = $i_rSet1->fields['gscaleid'];
}
$i_rSet1->Close();
}
$i_gradecount = 0;
$i_grades_times_total = 0;
$i_rSet2 = $g_db->Execute("SELECT * FROM " . $srv_settings['table_prefix'] . "gscales_grades WHERE gscaleid=" . $i_gscaleid . " ORDER BY gscale_gradeid");
if (!$i_rSet2) {
showDBError(__FILE__, 2);
} else {
while (!$i_rSet2->EOF) {
$i_gradecount++;
$i_gradeid = $i_rSet2->fields['gscale_gradeid'];
$i_grades_names[$i_gradeid] = $i_rSet2->fields['grade_name'];
$i_grades_times[$i_gradeid] = getRecordCount($srv_settings['table_prefix'] . 'results', 'testid=' . $i_testid . ' AND gscaleid=' . $i_gscaleid . ' AND gscale_gradeid=' . $i_gradeid);
$i_grades_times_total += $i_grades_times[$i_gradeid];
$i_rSet2->MoveNext();
}
$i_rSet2->Close();
}
$i_resultcount = 0;
$i_points_max = 0;
$i_points_low = IGT_MAX_FLOAT;
$i_points_high = 0;
$i_points_total = 0;
$i_points_total_max = 0;
$i_rSet3 = $g_db->Execute("SELECT * FROM " . $srv_settings['table_prefix'] . "results WHERE testid=" . $i_testid . " AND gscale_gradeid > 0");
if (!$i_rSet3) {
showDBError(__FILE__, 3);
} else {
while (!$i_rSet3->EOF) {
$i_resultcount++;
$i_points = $i_rSet3->fields['result_points'];
$i_points_max = $i_rSet3->fields['result_pointsmax'];
if ($i_points > $i_points_high) {
$i_points_high = $i_points;
}
if ($i_points < $i_points_low) {
$i_points_low = $i_points;
}
$i_points_total += $i_points;
$i_points_total_max += $i_points_max;
$i_rSet3->MoveNext();
}
$i_rSet3->Close();
}
echo '<tr class=rowone>';
echo '<td rowspan=' . ($i_gradecount + 8) . ' align=right>' . $i_testid . '</td>';
echo '<td colspan=4><b>' . $i_test_name . '</b></td>';
echo '</tr>';
echo '<tr class=rowone><td colspan=4><img src="images/1x1.gif" width=1 height=5></td></tr>';
echo '<tr class=rowone>';
echo '<td>' . $lngstr['page_testmanager_stats']['test_average_score'] . '</td>';
if ($i_points_total_max > 0 && $i_resultcount > 0) {
$i_points_average = $i_points_total / $i_resultcount;
$i_points_average_percentage = $i_points_total * 100 / $i_points_total_max;
echo '<td>' . getGauge($i_points_average_percentage, 'yellow') . '</td>';
echo '<td align=right>' . sprintf("%.0f", $i_points_average) . '</td>';
echo '<td align=right>' . sprintf("%.2f", $i_points_average_percentage) . '%</td>';
} else {
echo '<td colspan=3 align=center class=gray>' . $lngstr['label_notapplicable'] . '</td>';
}
echo '</tr>';
echo '<tr class=rowone>';
echo '<td>' . $lngstr['page_testmanager_stats']['test_high_score'] . '</td>';
if ($i_points_max > 0) {
$i_points_high_percentage = $i_points_high * 100 / $i_points_max;
echo '<td>' . getGauge($i_points_high_percentage, 'green') . '</td>';
echo '<td align=right>' . $i_points_high . '</td>';
echo '<td align=right>' . sprintf("%.2f", $i_points_high_percentage) . '%</td>';
} else {
echo '<td colspan=3 align=center class=gray>' . $lngstr['label_notapplicable'] . '</td>';
}
echo '</tr>';
echo '<tr class=rowone>';
echo '<td>' . $lngstr['page_testmanager_stats']['test_low_score'] . '</td>';
if ($i_points_max > 0) {
$i_points_low_percentage = $i_points_low * 100 / $i_points_max;
echo '<td>' . getGauge($i_points_low_percentage, 'red') . '</td>';
echo '<td align=right>' . $i_points_low . '</td>';
echo '<td align=right>' . sprintf("%.2f", $i_points_low_percentage) . '%</td>';
} else {
echo '<td colspan=3 align=center class=gray>' . $lngstr['label_notapplicable'] . '</td>';
}
echo '</tr>';
echo '<tr class=rowone><td colspan=4><img src="images/1x1.gif" width=1 height=5></td></tr>';
echo '<tr class=rowone><td colspan=2 class=rowhdr1 title="' . $lngstr['page_testmanager_stats']['hdr_grade_data_hint'] . '">' . $lngstr['page_testmanager_stats']['hdr_grade_data'] . '</td><td class=rowhdr1 title="' . $lngstr['page_testmanager_stats']['hdr_grade_responses_hint'] . '">' . $lngstr['page_testmanager_stats']['hdr_grade_responses_hint'] . '</td><td class=rowhdr1 title="' . $lngstr['page_testmanager_stats']['hdr_percents_hint'] . '">' . $lngstr['page_testmanager_stats']['hdr_percents'] . '</td></tr>';
foreach ($i_grades_names as $i_gradeid => $i_grade_name) {
echo '<tr class=rowone>';
echo '<td>' . $i_grade_name . '</td>';
if ($i_grades_times_total > 0) {
$i_grade_times_percentage = $i_grades_times[$i_gradeid] * 100 / $i_grades_times_total;
echo '<td>' . getGauge($i_grade_times_percentage) . '</td>';
echo '<td align=right>' . $i_grades_times[$i_gradeid] . '</td>';
echo '<td align=right>' . sprintf("%.2f", $i_grade_times_percentage) . '%</td>';
} else {
echo '<td colspan=3 align=center class=gray>' . $lngstr['label_notapplicable'] . '</td>';
}
echo '</tr>';
}
echo '<tr class=rowone>';
echo '<td>' . $lngstr['page_testmanager_stats']['total_responses'] . '</td>';
echo '<td></td>';
echo '<td align=right>' . $i_resultcount . '</td>';
echo '<td align=right></td>';
echo '</tr>';
}