echo '<td width=32><img src="images/button-first-big-inactive.gif" border=0 title="' . $lngstr['button_first_page'] . '"></td>';
echo '<td width=32><img src="images/button-prev-big-inactive.gif" border=0 title="' . $lngstr['button_prev_page'] . '"></td>';
}
if ($i_pageno < $i_pageno_count) {
echo '<td width=32><a href="groups.php?pageno=' . min($i_pageno + 1, $i_pageno_count) . $i_url_pages_addon . '"><img src="images/button-next-big.gif" border=0 title="' . $lngstr['button_next_page'] . '"></a></td>';
echo '<td width=32><a href="groups.php?pageno=' . $i_pageno_count . $i_url_pages_addon . '"><img src="images/button-last-big.gif" border=0 title="' . $lngstr['button_last_page'] . '"></a></td>';
} else {
echo '<td width=32><img src="images/button-next-big-inactive.gif" border=0 title="' . $lngstr['button_next_page'] . '"></td>';
echo '<td width=32><img src="images/button-last-big-inactive.gif" border=0 title="' . $lngstr['button_last_page'] . '"></td>';
}
}
echo '<td width=2><img src="images/toolbar-right.gif" width=2 height=32></td></tr></table>';
echo '</td></tr><tr><td>';
echo '<table class=rowtable2 cellpadding=5 cellspacing=1 border=0 width="100%">';
echo '<tr vAlign=top><td class=rowhdr1 title="' . $lngstr['label_hdr_select_hint'] . '" width=22><input type=checkbox name=toggleAll onclick="toggleCBs(this);"></td>';
writeQryTableHeaders('groups.php?action=' . $i_url_limit_addon, $i_tablefields, $i_order_no, $i_direction);
echo '<td class=rowhdr1 colspan=2>' . $lngstr['label_hdr_action'] . '</td></tr>';
//9917
$i_rSet1 = $g_db->SelectLimit("SELECT * FROM " . $srv_settings['table_prefix'] . "groups" . $i_sql_order_addon, $i_limitcount, $i_limitfrom);
if (!$i_rSet1) {
showDBError(__FILE__, 1);
} else {
$i_counter = 0;
while (!$i_rSet1->EOF) {
$rowname = $i_counter % 2 ? "rowone" : "rowtwo";
echo '<tr id=tr_' . $i_pagewide_id . ' class=' . $rowname . ' onmouseover="rollTR(' . $i_pagewide_id . ',1);" onmouseout="rollTR(' . $i_pagewide_id . ',0);"><td align=center width=22' . ($i_rSet1->fields["groupid"] > SYSTEM_GROUP_MAX_INDEX ? '' : ' class=system') . '><input id=cb_' . $i_pagewide_id . ' type=checkbox name=box_groups[] value="' . $i_rSet1->fields["groupid"] . '" onclick="toggleCB(this);"></td><td align=right>' . $i_rSet1->fields["groupid"] . '</td><td>' . getTruncatedHTML($i_rSet1->fields["group_name"]) . '</td><td>' . $i_rSet1->fields["group_description"] . '</td>';
echo '<td align=center width=22><a href="groups.php?groupid=' . $i_rSet1->fields["groupid"] . $i_order_addon . $i_url_limit_addon . '&action=edit"><img width=20 height=20 border=0 src="images/button-edit.gif" title="' . $lngstr['label_action_group_edit'] . '"></a></td><td align=center width=22>' . ($i_rSet1->fields["groupid"] > SYSTEM_GROUP_MAX_INDEX ? '<a href="groups.php?groupid=' . $i_rSet1->fields["groupid"] . $i_order_addon . $i_url_limit_addon . '&action=delete" onclick="return confirmMessage(this, \'' . $lngstr['qst_delete_group'] . '\')"><img width=20 height=20 border=0 src="images/button-cross.gif" title="' . $lngstr['label_action_group_delete'] . '"></a>' : '<img width=20 height=20 border=0 src="images/button-cross-inactive.gif">') . '</td></tr>';
$i_counter++;
$i_pagewide_id++;
$i_rSet1->MoveNext();
}
echo '<td width=32><img src="images/button-first-big-inactive.gif" border=0 title="' . $lngstr['button_first_page'] . '"></td>';
echo '<td width=32><img src="images/button-prev-big-inactive.gif" border=0 title="' . $lngstr['button_prev_page'] . '"></td>';
}
if ($i_pageno < $i_pageno_count) {
echo '<td width=32><a href="test-manager.php?action=edits&testid=' . $f_testid . '&pageno=' . min($i_pageno + 1, $i_pageno_count) . $i_url_limitto_addon . $i_order_addon . '"><img src="images/button-next-big.gif" border=0 title="' . $lngstr['button_next_page'] . '"></a></td>';
echo '<td width=32><a href="test-manager.php?action=edits&testid=' . $f_testid . '&pageno=' . $i_pageno_count . $i_url_limitto_addon . $i_order_addon . '"><img src="images/button-last-big.gif" border=0 title="' . $lngstr['button_last_page'] . '"></a></td>';
} else {
echo '<td width=32><img src="images/button-next-big-inactive.gif" border=0 title="' . $lngstr['button_next_page'] . '"></td>';
echo '<td width=32><img src="images/button-last-big-inactive.gif" border=0 title="' . $lngstr['button_last_page'] . '"></td>';
}
}
echo '<td width=2><img src="images/toolbar-right.gif" width=2 height=32></td></tr></table>';
echo '</td></tr><tr><td>';
echo '<table class=rowtable2 cellpadding=5 cellspacing=1 border=0 width="100%">';
echo '<tr vAlign=top><td class=rowhdr1 title="' . $lngstr['label_hdr_select_hint'] . '" width=22><input type=checkbox name=toggleAll onclick="toggleCBs(this);"></td>';
writeQryTableHeaders('test-manager.php?action=edits&testid=' . $f_testid . $i_url_limit_addon, $i_tablefields, $i_order_no, $i_direction);
echo '<td class=rowhdr1 colspan=2>' . $lngstr['label_hdr_action'] . '</td></tr>';
$i_rSet1 = $g_db->SelectLimit("SELECT * FROM " . $srv_settings['table_prefix'] . "sections WHERE 1=1" . $i_sql_order_addon, $i_limitcount, $i_limitfrom);
if (!$i_rSet1) {
showDBError(__FILE__, 1);
} else {
$i_counter = 0;
while (!$i_rSet1->EOF) {
$rowname = $i_counter % 2 ? "rowone" : "rowtwo";
echo '<tr id=tr_' . $i_pagewide_id . ' class=' . $rowname . ' onmouseover="rollTR(' . $i_pagewide_id . ',1);" onmouseout="rollTR(' . $i_pagewide_id . ',0);"><td align=center width=22><input id=cb_' . $i_pagewide_id . ' type=checkbox name=box_sections[] value="' . $i_rSet1->fields["sectionid"] . '" onclick="toggleCB(this);"></td><td align=right>' . $i_rSet1->fields["sectionid"] . '</td><td>' . getTruncatedHTML($i_rSet1->fields["section_name"]) . '</td><td>' . $i_rSet1->fields["section_description"] . '</td>';
echo '<td align=center width=22><a href="test-manager.php?action=edits2&testid=' . $f_testid . '§ionid=' . $i_rSet1->fields["sectionid"] . $i_order_addon . $i_url_limit_addon . '"><img width=20 height=20 border=0 src="images/button-edit.gif" title="' . $lngstr['page-sections']['action_section_edit'] . '"></a></td><td align=center width=22><a href="test-manager.php?action=deletes&testid=' . $f_testid . '§ionid=' . $i_rSet1->fields["sectionid"] . $i_order_addon . $i_url_limit_addon . '" onclick="return confirmMessage(this, \'' . $lngstr['page-sections']['qst_section_delete'] . '\')"><img width=20 height=20 border=0 src="images/button-cross.gif" title="' . $lngstr['page-sections']['action_section_delete'] . '"></a></td></tr>';
$i_counter++;
$i_pagewide_id++;
$i_rSet1->MoveNext();
}
$i_rSet1->Close();
echo '<td width=32><img src="images/button-first-big-inactive.gif" border=0 title="' . $lngstr['button_first_page'] . '"></td>';
echo '<td width=32><img src="images/button-prev-big-inactive.gif" border=0 title="' . $lngstr['button_prev_page'] . '"></td>';
}
if ($i_pageno < $i_pageno_count) {
echo '<td width=32><a href="test-manager.php?pageno=' . min($i_pageno + 1, $i_pageno_count) . $i_url_pages_addon . '"><img src="images/button-next-big.gif" border=0 title="' . $lngstr['button_next_page'] . '"></a></td>';
echo '<td width=32><a href="test-manager.php?pageno=' . $i_pageno_count . $i_url_pages_addon . '"><img src="images/button-last-big.gif" border=0 title="' . $lngstr['button_last_page'] . '"></a></td>';
} else {
echo '<td width=32><img src="images/button-next-big-inactive.gif" border=0 title="' . $lngstr['button_next_page'] . '"></td>';
echo '<td width=32><img src="images/button-last-big-inactive.gif" border=0 title="' . $lngstr['button_last_page'] . '"></td>';
}
}
echo '<td width=2><img src="images/toolbar-right.gif" width=2 height=32></td></tr></table>';
echo '</td></tr><tr><td>';
echo '<table class=rowtable2 cellpadding=5 cellspacing=1 border=0 width="100%">';
echo '<tr vAlign=top><td class=rowhdr1 title="' . $lngstr['label_hdr_select_hint'] . '" width=22><input type=checkbox name=toggleAll onclick="toggleCBs(this);"></td>';
writeQryTableHeaders('test-manager.php?action=' . $i_testid_addon . $i_subjectid_addon . $i_url_limit_addon, $i_tablefields, $i_order_no, $i_direction);
echo '<td class=rowhdr1 colspan=5>' . $lngstr['label_hdr_action'] . '</td></tr>';
$i_rSet1 = $g_db->SelectLimit("SELECT " . $srv_settings['table_prefix'] . "tests.testid, " . $srv_settings['table_prefix'] . "tests.test_name, " . $srv_settings['table_prefix'] . "tests.subjectid, " . $srv_settings['table_prefix'] . "tests.test_datestart, " . $srv_settings['table_prefix'] . "tests.test_dateend, " . $srv_settings['table_prefix'] . "tests.test_notes, " . $srv_settings['table_prefix'] . "tests.test_enabled, " . $srv_settings['table_prefix'] . "subjects.subject_name FROM " . $srv_settings['table_prefix'] . "tests, " . $srv_settings['table_prefix'] . "subjects WHERE " . $i_sql_where_addon . "" . $srv_settings['table_prefix'] . "tests.subjectid=" . $srv_settings['table_prefix'] . "subjects.subjectid" . $i_sql_order_addon, $i_limitcount, $i_limitfrom);
if (!$i_rSet1) {
showDBError(__FILE__, 1);
} else {
$i_counter = 0;
while (!$i_rSet1->EOF) {
$rowname = $i_counter % 2 ? "rowone" : "rowtwo";
echo '<tr id=tr_' . $i_pagewide_id . ' class=' . $rowname . ' onmouseover="rollTR(' . $i_pagewide_id . ',1);" onmouseout="rollTR(' . $i_pagewide_id . ',0);"><td align=center width=22><input id=cb_' . $i_pagewide_id . ' type=checkbox name=box_tests[] value="' . $i_rSet1->fields["testid"] . '" onclick="toggleCB(this);"></td><td align=right>' . $i_rSet1->fields["testid"] . '</td><td align=center width=16 style="padding: 1px;"><a href="javascript:void(0)" onClick="showDialog(\'test-manager.php?testid=' . $i_rSet1->fields["testid"] . '&action=notes\', 300, 200)"><img src="images/button-notes.gif" width=16 height=20 title="' . convertTextValue($i_rSet1->fields["test_notes"]) . '" border=0></a></td><td>' . convertTextValue($i_rSet1->fields["test_name"]) . '</td><td><a href="test-manager.php?subjectid=' . (isset($_GET["subjectid"]) && $_GET["subjectid"] != "" ? "" : $i_rSet1->fields["subjectid"]) . $i_order_addon . $i_url_limitto_addon . '">' . convertTextValue($i_rSet1->fields["subject_name"]) . '</a></td><td>' . getDateLocal($lngstr['language']['date_format'], $i_rSet1->fields["test_datestart"]) . '</td><td>' . getDateLocal($lngstr['language']['date_format'], $i_rSet1->fields["test_dateend"]) . '</td><td align=center><a href="test-manager.php?testid=' . $i_rSet1->fields["testid"] . $i_order_addon . $i_url_limit_addon . '&action=enable&set=' . ($i_rSet1->fields["test_enabled"] ? '0"><img src="images/button-checkbox-2.gif" width=13 height=13 border=0 title="' . $lngstr['label_yes'] . '">' : '1"><img src="images/button-checkbox-0.gif" width=13 height=13 border=0 title="' . $lngstr['label_no'] . '">') . '</a></td>';
echo '<td align=center width=22><a href="test-manager.php?testid=' . $i_rSet1->fields["testid"] . '&action=settings"><img width=20 height=20 border=0 src="images/button-gear.gif" title="' . $lngstr['label_action_test_settings'] . '"></a></td>';
if (IGT_TESTMANAGER_SHOWSTATS) {
echo '<td align=center width=22><a href="test-manager.php?testids=' . $i_rSet1->fields["testid"] . '&action=statst"><img width=20 height=20 border=0 src="images/button-stats.gif" title="' . $lngstr['page_testmanager']['view_test_stats'] . '"></a></td>';
}
echo '<td align=center width=22><a href="test-manager.php?testids=' . $i_rSet1->fields["testid"] . '&action=groups"><img width=20 height=20 border=0 src="images/button-groups.gif" title="' . $lngstr['label_action_test_groups_select'] . '"></a></td>';
echo '<td align=center width=22><a href="test-manager.php?testid=' . $i_rSet1->fields["testid"] . '&action=editt"><img width=20 height=20 border=0 src="images/button-edit.gif" title="' . $lngstr['label_action_questions_edit'] . '"></a></td>';
$i_direction = "";
$i_order_addon = "";
$i_sql_order_addon = "";
$i_tablefields = array(array($lngstr['label_report_hdr2_result_answerid'], $lngstr['label_report_hdr2_result_answerid_hint'], $srv_settings['table_prefix'] . "results_answers.result_answerid"), array($lngstr['label_report_hdr2_test_questionid'], $lngstr['label_report_hdr2_test_questionid_hint'], $srv_settings['table_prefix'] . "results_answers.test_questionid"), array($lngstr['label_report_hdr2_result_answer_timespent'], $lngstr['label_report_hdr2_result_answer_timespent_hint'], $srv_settings['table_prefix'] . "results_answers.result_answer_timespent"), array($lngstr['label_report_hdr2_result_answer_text'], $lngstr['label_report_hdr2_result_answer_text_hint'], ""), array($lngstr['label_report_hdr2_result_answer_points'], $lngstr['label_report_hdr2_result_answer_points_hint'], $srv_settings['table_prefix'] . "results_answers.result_answer_points"), array($lngstr['label_report_hdr2_result_answer_timeexceeded'], $lngstr['label_report_hdr2_result_answer_timeexceeded_hint'], $srv_settings['table_prefix'] . "results_answers.result_answer_timeexceeded"), array($lngstr['label_report_hdr2_result_answer_iscorrect'], $lngstr['label_report_hdr2_result_answer_iscorrect_hint'], $srv_settings['table_prefix'] . "results_answers.result_answer_iscorrect"));
$i_order_no = isset($_GET["order"]) ? (int) $_GET["order"] : 0;
if ($i_order_no >= count($i_tablefields)) {
$i_order_no = -1;
}
if ($i_order_no >= 0) {
$i_direction = isset($_GET["direction"]) && $_GET["direction"] ? "DESC" : "";
$i_order_addon = "&order=" . $i_order_no . "&direction=" . $i_direction;
$i_sql_order_addon = " ORDER BY " . $i_tablefields[$i_order_no][2] . " " . $i_direction;
}
echo '<p><table class=rowtable2 cellpadding=5 cellspacing=1 border=0 width="100%">';
echo '<tr vAlign=top>';
writeQryTableHeaders('reports-manager.php?action=viewq' . $i_resultid_addon, $i_tablefields, $i_order_no, $i_direction);
echo '<td class=rowhdr1 colspan=2 width=22>' . $lngstr['label_hdr_action'] . '</td></tr>';
$i_rSet2 = $g_db->Execute("SELECT result_answerid, questionid, test_questionid, result_answer_text, result_answer_points, result_answer_iscorrect, result_answer_timespent, result_answer_timeexceeded FROM " . $srv_settings['table_prefix'] . "results_answers WHERE resultid=" . $f_resultid . $i_sql_order_addon);
if (!$i_rSet2) {
showDBError(__FILE__, 2);
} else {
$i_counter = 0;
while (!$i_rSet2->EOF) {
$rowname = $i_counter % 2 ? 'rowone' : 'rowtwo';
if (IGT_NUMBERING_STYLE_ANSWERS == IGT_NUMBERING_STYLES_LETTERS) {
$nQuestionType = getRecordItem($srv_settings['table_prefix'] . 'questions', 'question_type', 'questionid=' . $i_rSet2->fields['questionid']);
switch ($nQuestionType) {
case QUESTION_TYPE_MULTIPLECHOICE:
case QUESTION_TYPE_TRUEFALSE:
case QUESTION_TYPE_MULTIPLEANSWER:
$strAnswerText = $i_rSet2->fields['result_answer_text'];
echo '<td width=32><img src="images/button-first-big-inactive.gif" border=0 title="' . $lngstr['button_first_page'] . '"></td>';
echo '<td width=32><img src="images/button-prev-big-inactive.gif" border=0 title="' . $lngstr['button_prev_page'] . '"></td>';
}
if ($i_pageno < $i_pageno_count) {
echo '<td width=32><a href="report-templates.php?pageno=' . min($i_pageno + 1, $i_pageno_count) . $i_url_pages_addon . '"><img src="images/button-next-big.gif" border=0 title="' . $lngstr['button_next_page'] . '"></a></td>';
echo '<td width=32><a href="report-templates.php?pageno=' . $i_pageno_count . $i_url_pages_addon . '"><img src="images/button-last-big.gif" border=0 title="' . $lngstr['button_last_page'] . '"></a></td>';
} else {
echo '<td width=32><img src="images/button-next-big-inactive.gif" border=0 title="' . $lngstr['button_next_page'] . '"></td>';
echo '<td width=32><img src="images/button-last-big-inactive.gif" border=0 title="' . $lngstr['button_last_page'] . '"></td>';
}
}
echo '<td width=2><img src="images/toolbar-right.gif" width=2 height=32></td></tr></table>';
echo '</td></tr><tr><td>';
echo '<table class=rowtable2 cellpadding=5 cellspacing=1 border=0 width="100%">';
echo '<tr vAlign=top><td class=rowhdr1 title="' . $lngstr['label_hdr_select_hint'] . '" width=22><input type=checkbox name=toggleAll onclick="toggleCBs(this);"></td>';
writeQryTableHeaders('report-templates.php?action=' . $i_url_limit_addon, $i_tablefields, $i_order_no, $i_direction);
echo '<td class=rowhdr1 colspan=3>' . $lngstr['label_hdr_action'] . '</td></tr>';
$i_rSet1 = $g_db->SelectLimit("SELECT * FROM " . $srv_settings['table_prefix'] . "rtemplates WHERE 1=1" . $i_sql_order_addon, $i_limitcount, $i_limitfrom);
if (!$i_rSet1) {
showDBError(__FILE__, 1);
} else {
$i_counter = 0;
while (!$i_rSet1->EOF) {
$rowname = $i_counter % 2 ? "rowone" : "rowtwo";
echo '<tr id=tr_' . $i_pagewide_id . ' class=' . $rowname . ' onmouseover="rollTR(' . $i_pagewide_id . ',1);" onmouseout="rollTR(' . $i_pagewide_id . ',0);"><td align=center width=22' . ($i_rSet1->fields["rtemplateid"] > SYSTEM_RTEMPLATES_MAX_INDEX ? '' : ' class=system') . '><input id=cb_' . $i_pagewide_id . ' type=checkbox name=box_rtemplates[] value="' . $i_rSet1->fields["rtemplateid"] . '" onclick="toggleCB(this);"></td><td align=right>' . $i_rSet1->fields["rtemplateid"] . '</td><td>' . getTruncatedHTML($i_rSet1->fields["rtemplate_name"]) . '</td><td>' . $i_rSet1->fields["rtemplate_description"] . '</td>';
echo '<td align=center width=22><a href="report-templates.php?rtemplateid=' . $i_rSet1->fields["rtemplateid"] . $i_order_addon . $i_url_limit_addon . '&action=edit"><img width=20 height=20 border=0 src="images/button-edit.gif" title="' . $lngstr['page-rtemplates']['action_rtemplates_edit'] . '"></a></td>';
echo '<td align=center width=22>' . ($i_rSet1->fields["rtemplateid"] > SYSTEM_RTEMPLATES_MAX_INDEX ? '<a href="report-templates.php?rtemplateid=' . $i_rSet1->fields["rtemplateid"] . $i_order_addon . $i_url_limit_addon . '&action=delete" onclick="return confirmMessage(this, \'' . $lngstr['page-rtemplates']['qst_rtemplate_delete'] . '\')"><img width=20 height=20 border=0 src="images/button-cross.gif" title="' . $lngstr['page-rtemplates']['action_rtemplate_delete'] . '"></a>' : '<img width=20 height=20 border=0 src="images/button-cross-inactive.gif">') . '</td></tr>';
$i_counter++;
$i_pagewide_id++;
$i_rSet1->MoveNext();
}
echo '<td width=32><img src="images/button-first-big-inactive.gif" border=0 title="' . $lngstr['button_first_page'] . '"></td>';
echo '<td width=32><img src="images/button-prev-big-inactive.gif" border=0 title="' . $lngstr['button_prev_page'] . '"></td>';
}
if ($i_2_pageno < $i_2_pageno_count) {
echo '<td width=32><a href="users.php?action=groups&pageno2=' . min($i_2_pageno + 1, $i_2_pageno_count) . $i_2_url_pages_addon . '"><img src="images/button-next-big.gif" border=0 title="' . $lngstr['button_next_page'] . '"></a></td>';
echo '<td width=32><a href="users.php?action=groups&pageno2=' . $i_2_pageno_count . $i_2_url_pages_addon . '"><img src="images/button-last-big.gif" border=0 title="' . $lngstr['button_last_page'] . '"></a></td>';
} else {
echo '<td width=32><img src="images/button-next-big-inactive.gif" border=0 title="' . $lngstr['button_next_page'] . '"></td>';
echo '<td width=32><img src="images/button-last-big-inactive.gif" border=0 title="' . $lngstr['button_last_page'] . '"></td>';
}
}
echo '<td width=2><img src="images/toolbar-right.gif" width=2 height=32></td></tr></table>';
echo '</td></tr><tr><td>';
echo '<table class=rowtable2 cellpadding=5 cellspacing=1 border=0 width="100%">';
echo '<tr vAlign=top><td class=rowhdr1 title="' . $lngstr['label_hdr_select_hint'] . '" width=22><input type=checkbox name=toggleAll onclick="toggleCBs(this);"></td>';
writeQryTableHeaders('users.php?action=groups' . $i_ids_addon . $i_order_addon . $i_2_url_limit_addon, $i_2_tablefields, $i_2_order_no, $i_2_direction, '2');
echo '<td class=rowhdr1 title="' . $lngstr['label_managegroups_hdr_member_of_hint'] . '" vAlign=top>' . $lngstr['label_managegroups_hdr_member_of'] . '</td>';
echo '<td class=rowhdr1 colspan=2>' . $lngstr['label_hdr_action'] . '</td></tr>';
//9917
$i_rSet2 = $g_db->SelectLimit("SELECT * FROM " . $srv_settings['table_prefix'] . "groups" . $i_2_sql_order_addon, $i_2_limitcount, $i_2_limitfrom);
if (!$i_rSet2) {
showDBError(__FILE__, 2);
} else {
$i_counter = 0;
while (!$i_rSet2->EOF) {
//9917//9917
$i_member_count = getRecordCount($srv_settings['table_prefix'] . 'groups_users', ($f_ids ? "id IN (" . implode(',', $f_ids) . ") AND " : "") . "groupid=" . $i_rSet2->fields["groupid"]);
$rowname = $i_counter % 2 ? "rowone" : "rowtwo";
echo '<tr id=tr_' . $i_pagewide_id . ' class=' . $rowname . ' onmouseover="rollTR(' . $i_pagewide_id . ',1);" onmouseout="rollTR(' . $i_pagewide_id . ',0);"><td align=center width=22' . ($i_rSet2->fields["groupid"] > SYSTEM_GROUP_MAX_INDEX ? '' : ' class=system') . '><input id=cb_' . $i_pagewide_id . ' type=checkbox name=box_groups[] value="' . $i_rSet2->fields["groupid"] . '" onclick="toggleCB(this);"></td><td align=right>' . $i_rSet2->fields["groupid"] . '</td><td>' . getTruncatedHTML($i_rSet2->fields["group_name"]) . '</td><td>' . $i_rSet2->fields["group_description"] . '</td><td align=center><a href="users.php?action=memberof&groupid=' . $i_rSet2->fields["groupid"] . $i_order_addon . $i_ids_addon . $i_2_order_addon . $i_2_url_limit_addon . '&set=' . ($i_member_count >= sizeof($f_ids) ? '0"><img src="images/button-checkbox-2.gif" width=13 height=13 border=0 title="' . $lngstr['label_yes'] . '">' : ($i_member_count > 0 ? '1"><img src="images/button-checkbox-1.gif" width=13 height=13 border=0 title="' . $lngstr['label_partially'] . '">' : '1"><img src="images/button-checkbox-0.gif" width=13 height=13 border=0 title="' . $lngstr['label_no'] . '">')) . '</a></td>';
echo '<td align=center width=22><a href="groups.php?groupid=' . $i_rSet2->fields["groupid"] . '&action=edit"><img width=20 height=20 border=0 src="images/button-edit.gif" title="' . $lngstr['label_action_group_edit'] . '"></a></td><td align=center width=22>' . ($i_rSet2->fields["groupid"] > SYSTEM_GROUP_MAX_INDEX ? '<a href="groups.php?groupid=' . $i_rSet2->fields["groupid"] . '&action=delete" onclick="return confirmMessage(this, \'' . $lngstr['qst_delete_group'] . '\')"><img width=20 height=20 border=0 src="images/button-cross.gif" title="' . $lngstr['label_action_group_delete'] . '"></a>' : '<img width=20 height=20 border=0 src="images/button-cross-inactive.gif">') . '</td></tr>';
$i_counter++;
echo '<td width=32><img src="images/button-first-big-inactive.gif" border=0 title="' . $lngstr['button_first_page'] . '"></td>';
echo '<td width=32><img src="images/button-prev-big-inactive.gif" border=0 title="' . $lngstr['button_prev_page'] . '"></td>';
}
if ($i_pageno < $i_pageno_count) {
echo '<td width=32><a href="grades.php?action=edit&gscaleid=' . $f_gscaleid . '&pageno=' . min($i_pageno + 1, $i_pageno_count) . $i_url_limitto_addon . $i_order_addon . '"><img src="images/button-next-big.gif" border=0 title="' . $lngstr['button_next_page'] . '"></a></td>';
echo '<td width=32><a href="grades.php?action=edit&gscaleid=' . $f_gscaleid . '&pageno=' . $i_pageno_count . $i_url_limitto_addon . $i_order_addon . '"><img src="images/button-last-big.gif" border=0 title="' . $lngstr['button_last_page'] . '"></a></td>';
} else {
echo '<td width=32><img src="images/button-next-big-inactive.gif" border=0 title="' . $lngstr['button_next_page'] . '"></td>';
echo '<td width=32><img src="images/button-last-big-inactive.gif" border=0 title="' . $lngstr['button_last_page'] . '"></td>';
}
}
echo '<td width=2><img src="images/toolbar-right.gif" width=2 height=32></td></tr></table>';
echo '</td></tr><tr><td>';
echo '<table class=rowtable2 cellpadding=5 cellspacing=1 border=0 width="100%">';
echo '<tr vAlign=top><td class=rowhdr1 title="' . $lngstr['label_hdr_select_hint'] . '" width=22><input type=checkbox name=toggleAll onclick="toggleCBs(this);"></td>';
writeQryTableHeaders('grades.php?action=edit&gscaleid=' . $f_gscaleid . $i_url_limit_addon, $i_tablefields, $i_order_no, $i_direction);
echo '<td class=rowhdr1 colspan=3>' . $lngstr['label_hdr_action'] . '</td></tr>';
$i_rSet1 = $g_db->SelectLimit("SELECT * FROM " . $srv_settings['table_prefix'] . "gscales_grades WHERE gscaleid=" . $f_gscaleid . $i_sql_order_addon, $i_limitcount, $i_limitfrom);
if (!$i_rSet1) {
showDBError(__FILE__, 1);
} else {
$i_counter = 0;
while (!$i_rSet1->EOF) {
$rowname = $i_counter % 2 ? "rowone" : "rowtwo";
echo '<tr id=tr_' . $i_pagewide_id . ' class=' . $rowname . ' onmouseover="rollTR(' . $i_pagewide_id . ',1);" onmouseout="rollTR(' . $i_pagewide_id . ',0);"><td align=center width=22><input id=cb_' . $i_pagewide_id . ' type=checkbox name=box_gradescales[] value="' . $i_rSet1->fields["gscale_gradeid"] . '" onclick="toggleCB(this);"></td><td align=right>' . $i_rSet1->fields["gscale_gradeid"] . '</td><td align=right>' . sprintf("%.2f", $i_rSet1->fields["grade_from"]) . '%</td><td align=right>' . sprintf("%.2f", $i_rSet1->fields["grade_to"] == 100 || $i_rSet1->fields["grade_to"] == 0 ? $i_rSet1->fields["grade_to"] : $i_rSet1->fields["grade_to"] - 0.01) . '%</td><td>' . getTruncatedHTML($i_rSet1->fields["grade_name"]) . '</td><td>' . $i_rSet1->fields["grade_description"] . '</td>';
echo '<td align=center width=22><a href="grades.php?gscaleid=' . $f_gscaleid . '&gscale_gradeid=' . $i_rSet1->fields["gscale_gradeid"] . '&action=edits"><img width=20 height=20 border=0 src="images/button-edit.gif" title="' . $lngstr['label_action_gradescale_edit'] . '"></a></td><td align=center width=22><a href="grades.php?gscaleid=' . $f_gscaleid . '&gscale_gradeid=' . $i_rSet1->fields["gscale_gradeid"] . '&action=moveup"><img width=20 height=10 border=0 src="images/button-up.gif" title="' . $lngstr['label_action_grade_moveup'] . '"></a><br><a href="grades.php?gscaleid=' . $f_gscaleid . '&gscale_gradeid=' . $i_rSet1->fields["gscale_gradeid"] . '&action=movedown"><img width=20 height=10 border=0 src="images/button-down.gif" title="' . $lngstr['label_action_grade_movedown'] . '"></a></td><td align=center width=22><a href="grades.php?gscaleid=' . $f_gscaleid . '&gscale_gradeid=' . $i_rSet1->fields["gscale_gradeid"] . $i_url_limit_addon . '&action=deletes" onclick="return confirmMessage(this, \'' . $lngstr['qst_delete_gradescale'] . '\')"><img width=20 height=20 border=0 src="images/button-cross.gif" title="' . $lngstr['label_action_gradescale_delete'] . '"></a></td></tr>';
$i_counter++;
$i_pagewide_id++;
$i_rSet1->MoveNext();
}
$i_rSet1->Close();
echo '<td width=32><img src="images/button-first-big-inactive.gif" border=0 title="' . $lngstr['button_first_page'] . '"></td>';
echo '<td width=32><img src="images/button-prev-big-inactive.gif" border=0 title="' . $lngstr['button_prev_page'] . '"></td>';
}
if ($i_2_pageno < $i_2_pageno_count) {
echo '<td width=32><a href="test-manager.php?action=groups&pageno2=' . min($i_2_pageno + 1, $i_2_pageno_count) . $i_testids_addon . $i_order_addon . $i_2_order_addon . $i_2_url_limitto_addon . '"><img src="images/button-next-big.gif" border=0 title="' . $lngstr['button_next_page'] . '"></a></td>';
echo '<td width=32><a href="test-manager.php?action=groups&pageno2=' . $i_2_pageno_count . $i_testids_addon . $i_order_addon . $i_2_order_addon . $i_2_url_limitto_addon . '"><img src="images/button-last-big.gif" border=0 title="' . $lngstr['button_last_page'] . '"></a></td>';
} else {
echo '<td width=32><img src="images/button-next-big-inactive.gif" border=0 title="' . $lngstr['button_next_page'] . '"></td>';
echo '<td width=32><img src="images/button-last-big-inactive.gif" border=0 title="' . $lngstr['button_last_page'] . '"></td>';
}
}
echo '<td width=2><img src="images/toolbar-right.gif" width=2 height=32></td></tr></table>';
echo '</td></tr><tr><td>';
echo '<table class=rowtable2 cellpadding=5 cellspacing=1 border=0 width="100%">';
echo '<tr vAlign=top><td class=rowhdr1 title="' . $lngstr['label_hdr_select_hint'] . '" width=22><input type=checkbox name=toggleAll onclick="toggleCBs(this);"></td>';
writeQryTableHeaders('test-manager.php?action=groups' . $i_testids_addon . $i_order_addon . $i_2_url_limit_addon, $i_2_tablefields, $i_2_order_no, $i_2_direction, '2');
echo '<td class=rowhdr1 title="' . $lngstr['page_assignto_hdr_assignto_hint'] . '" vAlign=top>' . $lngstr['page_assignto_hdr_assignto'] . '</td>';
echo '<td class=rowhdr1 colspan=2>' . $lngstr['label_hdr_action'] . '</td></tr>';
//9917
$i_rSet3 = $g_db->SelectLimit("SELECT * FROM " . $srv_settings['table_prefix'] . "groups" . $i_2_sql_order_addon, $i_2_limitcount, $i_2_limitfrom);
if (!$i_rSet3) {
showDBError(__FILE__, 3);
} else {
$i_counter = 0;
while (!$i_rSet3->EOF) {
//9917
$i_member_count = getRecordCount($srv_settings['table_prefix'] . 'groups_tests', $i_sql_where_addon . "groupid=" . $i_rSet3->fields["groupid"]);
$rowname = $i_counter % 2 ? "rowone" : "rowtwo";
echo '<tr id=tr_' . $i_pagewide_id . ' class=' . $rowname . ' onmouseover="rollTR(' . $i_pagewide_id . ',1);" onmouseout="rollTR(' . $i_pagewide_id . ',0);"><td align=center width=22' . ($i_rSet3->fields["groupid"] > SYSTEM_GROUP_MAX_INDEX ? '' : ' class=system') . '><input id=cb_' . $i_pagewide_id . ' type=checkbox name=box_groups[] value="' . $i_rSet3->fields["groupid"] . '" onclick="toggleCB(this);"></td><td align=right>' . $i_rSet3->fields["groupid"] . '</td><td>' . getTruncatedHTML($i_rSet3->fields["group_name"]) . '</td><td>' . $i_rSet3->fields["group_description"] . '</td><td align=center><a href="test-manager.php?action=assignto&groupid=' . $i_rSet3->fields["groupid"] . $i_order_addon . $i_testids_addon . $i_2_url_limit_addon . '&set=' . ($i_member_count >= sizeof($f_testids) ? '0"><img src="images/button-checkbox-2.gif" width=13 height=13 border=0 title="' . $lngstr['label_yes'] . '">' : ($i_member_count > 0 ? '1"><img src="images/button-checkbox-1.gif" width=13 height=13 border=0 title="' . $lngstr['label_partially'] . '">' : '1"><img src="images/button-checkbox-0.gif" width=13 height=13 border=0 title="' . $lngstr['label_no'] . '">')) . '</a></td>';
echo '<td align=center width=22><a href="groups.php?groupid=' . $i_rSet3->fields["groupid"] . '&action=edit"><img width=20 height=20 border=0 src="images/button-edit.gif" title="' . $lngstr['label_action_group_edit'] . '"></a></td><td align=center width=22>' . ($i_rSet3->fields["groupid"] > SYSTEM_GROUP_MAX_INDEX ? '<a href="groups.php?groupid=' . $i_rSet3->fields["groupid"] . '&action=delete" onclick="return confirmMessage(this, \'' . $lngstr['qst_delete_group'] . '\')"><img width=20 height=20 border=0 src="images/button-cross.gif" title="' . $lngstr['label_action_group_delete'] . '"></a>' : '<img width=20 height=20 border=0 src="images/button-cross-inactive.gif">') . '</td></tr>';
$i_counter++;
echo '<td width=32><img src="images/button-first-big-inactive.gif" width=32 height=32 border=0 title="' . $lngstr['button_first_page'] . '"></td>';
echo '<td width=32><img src="images/button-prev-big-inactive.gif" width=32 height=32 border=0 title="' . $lngstr['button_prev_page'] . '"></td>';
}
if ($i_2_pageno < $i_2_pageno_count) {
echo '<td width=32><a href="test-manager.php?action=editt&pageno2=' . min($i_2_pageno + 1, $i_2_pageno_count) . '&testid=' . $f_testid . $i_subjectid_addon . $i_order_addon . $i_url_limit_addon . $i_2_subjectid_addon . $i_2_order_addon . $i_2_url_limitto_addon . '"><img src="images/button-next-big.gif" width=32 height=32 border=0 title="' . $lngstr['button_next_page'] . '"></a></td>';
echo '<td width=32><a href="test-manager.php?action=editt&pageno2=' . $i_2_pageno_count . '&testid=' . $f_testid . $i_subjectid_addon . $i_order_addon . $i_url_limit_addon . $i_2_subjectid_addon . $i_2_order_addon . $i_2_url_limitto_addon . '"><img src="images/button-last-big.gif" width=32 height=32 border=0 title="' . $lngstr['button_last_page'] . '"></a></td>';
} else {
echo '<td width=32><img src="images/button-next-big-inactive.gif" width=32 height=32 border=0 title="' . $lngstr['button_next_page'] . '"></td>';
echo '<td width=32><img src="images/button-last-big-inactive.gif" width=32 height=32 border=0 title="' . $lngstr['button_last_page'] . '"></td>';
}
}
echo '<td width=2><img src="images/toolbar-right.gif" width=2 height=32></td></tr></table>';
echo '</td></tr><tr><td>';
echo '<table class=rowtable2 cellpadding=5 cellspacing=1 border=0 width="100%">';
echo '<tr vAlign=top><td class=rowhdr1 title="' . $lngstr['label_hdr_select_hint'] . '" width=22><input type=checkbox name=toggleAll onclick="toggleCBs(this);"></td>';
writeQryTableHeaders('test-manager.php?action=editt&testid=' . $f_testid . $i_subjectid_addon . $i_order_addon . $i_url_limit_addon . $i_2_subjectid_addon . $i_2_url_limit_addon, $i_2_tablefields, $i_2_order_no, $i_2_direction, '2');
echo '<td class=rowhdr1 colspan=3>' . $lngstr['label_hdr_action'] . '</td></tr>';
$i_rSet2 = $g_db->SelectLimit("SELECT " . $srv_settings['table_prefix'] . "questions.questionid, " . $srv_settings['table_prefix'] . "questions.subjectid, " . $srv_settings['table_prefix'] . "questions.question_text, " . $srv_settings['table_prefix'] . "questions.question_time, " . $srv_settings['table_prefix'] . "questions.question_type, " . $srv_settings['table_prefix'] . "questions.question_points, " . $srv_settings['table_prefix'] . "subjects.subject_name FROM " . $srv_settings['table_prefix'] . "questions, " . $srv_settings['table_prefix'] . "subjects WHERE " . $i_2_sql_where_addon . "" . $srv_settings['table_prefix'] . "questions.subjectid=" . $srv_settings['table_prefix'] . "subjects.subjectid" . $i_2_sql_order_addon, $i_2_limitcount, $i_2_limitfrom);
if (!$i_rSet2) {
showDBError(__FILE__, 2);
} else {
$i_counter = 0;
while (!$i_rSet2->EOF) {
$rowname = $i_counter % 2 ? 'rowone' : 'rowtwo';
$i_rowtitle = '';
if (!in_array($i_rSet2->fields['questionid'], $i_questionids_in_the_test) || $i_rSet2->fields['question_type'] == QUESTION_TYPE_RANDOM) {
echo '<tr id=tr_' . $i_pagewide_id . ' class=' . $rowname . ' title="' . $i_rowtitle . '" onmouseover="rollTR(' . $i_pagewide_id . ',1);" onmouseout="rollTR(' . $i_pagewide_id . ',0);"><td align=center width=22><input id=cb_' . $i_pagewide_id . ' type=checkbox name=box_questions[] value="' . $i_rSet2->fields['questionid'] . '" onclick="toggleCB(this);"></td><td align=right>' . $i_rSet2->fields['questionid'] . '</td><td><a href="test-manager.php?testid=' . $f_testid . (isset($_GET['subjectid2']) && $_GET['subjectid2'] != '' ? '' : '&subjectid2=' . $i_rSet2->fields['subjectid']) . $i_subjectid_addon . $i_order_addon . $i_url_limit_addon . $i_2_order_addon . $i_2_url_limit_addon . '&action=editt">' . convertTextValue($i_rSet2->fields['subject_name']) . '</a></td><td>' . getTruncatedHTML($i_rSet2->fields['question_text']) . '</td><td>';
switch ($i_rSet2->fields['question_type']) {
case QUESTION_TYPE_MULTIPLECHOICE:
echo $lngstr['label_atype_multiple_choice'];
break;
echo '<td width=32><img src="images/button-first-big-inactive.gif" border=0 title="' . $lngstr['button_first_page'] . '"></td>';
echo '<td width=32><img src="images/button-prev-big-inactive.gif" border=0 title="' . $lngstr['button_prev_page'] . '"></td>';
}
if ($i_pageno < $i_pageno_count) {
echo '<td width=32><a href="question-bank.php?pageno=' . min($i_pageno + 1, $i_pageno_count) . $i_url_pages_addon . '"><img src="images/button-next-big.gif" border=0 title="' . $lngstr['button_next_page'] . '"></a></td>';
echo '<td width=32><a href="question-bank.php?pageno=' . $i_pageno_count . $i_url_pages_addon . '"><img src="images/button-last-big.gif" border=0 title="' . $lngstr['button_last_page'] . '"></a></td>';
} else {
echo '<td width=32><img src="images/button-next-big-inactive.gif" border=0 title="' . $lngstr['button_next_page'] . '"></td>';
echo '<td width=32><img src="images/button-last-big-inactive.gif" border=0 title="' . $lngstr['button_last_page'] . '"></td>';
}
}
echo '<td width=2><img src="images/toolbar-right.gif" width=2 height=32></td></tr></table>';
echo '</td></tr><tr><td>';
echo '<table class=rowtable2 cellpadding=5 cellspacing=1 border=0 width="100%">';
echo '<tr vAlign=top><td class=rowhdr1 title="' . $lngstr['label_hdr_select_hint'] . '" width=22><input type=checkbox name=toggleAll onclick="toggleCBs(this);"></td>';
writeQryTableHeaders('question-bank.php?action=' . $i_subjectid_addon . $i_url_limit_addon, $i_tablefields, $i_order_no, $i_direction);
echo '<td class=rowhdr1 colspan=3>' . $lngstr['label_hdr_action'] . '</td></tr>';
$i_rSet1 = $g_db->SelectLimit("SELECT " . $srv_settings['table_prefix'] . "questions.questionid, " . $srv_settings['table_prefix'] . "questions.subjectid, " . $srv_settings['table_prefix'] . "questions.question_text, " . $srv_settings['table_prefix'] . "questions.question_time, " . $srv_settings['table_prefix'] . "questions.question_type, " . $srv_settings['table_prefix'] . "questions.question_points, " . $srv_settings['table_prefix'] . "subjects.subject_name FROM " . $srv_settings['table_prefix'] . "questions, " . $srv_settings['table_prefix'] . "subjects WHERE " . $i_sql_where_addon . "" . $srv_settings['table_prefix'] . "questions.subjectid=" . $srv_settings['table_prefix'] . "subjects.subjectid" . $i_sql_order_addon, $i_limitcount, $i_limitfrom);
if (!$i_rSet1) {
showDBError(__FILE__, 1);
} else {
$i_counter = 0;
while (!$i_rSet1->EOF) {
$rowname = $i_counter % 2 ? "rowone" : "rowtwo";
echo '<tr id=tr_' . $i_pagewide_id . ' class=' . $rowname . ' onmouseover="rollTR(' . $i_pagewide_id . ',1);" onmouseout="rollTR(' . $i_pagewide_id . ',0);"><td align=center width=22><input id=cb_' . $i_pagewide_id . ' type=checkbox name=box_questions[] value="' . $i_rSet1->fields["questionid"] . '" onclick="toggleCB(this);"></td><td align=right>' . $i_rSet1->fields["questionid"] . '</td><td><a href="question-bank.php?action=editt' . (isset($_GET["subjectid"]) && $_GET["subjectid"] != "" ? "" : '&subjectid=' . $i_rSet1->fields["subjectid"]) . $i_order_addon . $i_url_limit_addon . '">' . convertTextValue($i_rSet1->fields["subject_name"]) . '</a></td><td>' . getTruncatedHTML($i_rSet1->fields["question_text"]) . '</td><td>';
switch ($i_rSet1->fields["question_type"]) {
case QUESTION_TYPE_MULTIPLECHOICE:
echo $lngstr['label_atype_multiple_choice'];
break;
case QUESTION_TYPE_TRUEFALSE:
echo $lngstr['label_atype_truefalse'];
