<?php

$g_vars['page']['location'] = array('test_manager', 'test_manager');
$g_smarty->assign('g_vars', $g_vars);
displayTemplate('_header');
$g_vars['page']['selected_section'] = 'testmanager';
$g_vars['page']['selected_tab'] = 'testmanager';
$g_vars['page']['menu_2_items'] = getMenu2Items($g_vars['page']['selected_section']);
writePanel2($g_vars['page']['menu_2_items']);
echo '<h2>' . $lngstr['page_header_edittests'] . '</h2>';
writeErrorsWarningsBar();
writeInfoBar($lngstr['tooltip_tests']);
$i_pagewide_id = 0;
$i_subjectid_addon = '';
$i_sql_where_addon = '';
if (isset($_GET['subjectid']) && $_GET['subjectid'] != '') {
    $i_subjectid_addon .= '&subjectid=' . (int) $_GET['subjectid'];
    $i_sql_where_addon .= $srv_settings['table_prefix'] . 'tests.subjectid=' . (int) $_GET['subjectid'] . ' AND ';
}
$i_testid_addon = '';
if (isset($_GET['testid']) && $_GET['testid'] != '') {
    $i_testid_addon .= '&testid=' . (int) $_GET['testid'];
    $i_sql_where_addon .= $srv_settings['table_prefix'] . 'tests.testid=' . (int) $_GET['testid'] . ' AND ';
}
$i_direction = '';
$i_order_addon = '';
$i_sql_order_addon = '';
$i_tablefields = array(array($lngstr['label_edittests_hdr_testid'], $lngstr['label_edittests_hdr_testid_hint'], $srv_settings['table_prefix'] . "tests.testid"), array($lngstr['label_edittests_hdr_test_notes'], $lngstr['label_edittests_hdr_test_notes_hint'], ""), array($lngstr['label_edittests_hdr_test_name'], $lngstr['label_edittests_hdr_test_name_hint'], $srv_settings['table_prefix'] . "tests.test_name"), array($lngstr['label_edittests_hdr_subjectid'], $lngstr['label_edittests_hdr_subjectid_hint'], $srv_settings['table_prefix'] . "tests.subjectid"), array($lngstr['label_edittests_hdr_test_datestart'], $lngstr['label_edittests_hdr_test_datestart_hint'], $srv_settings['table_prefix'] . "tests.test_datestart"), array($lngstr['label_edittests_hdr_test_dateend'], $lngstr['label_edittests_hdr_test_dateend_hint'], $srv_settings['table_prefix'] . "tests.test_dateend"), array($lngstr['label_edittests_hdr_test_enabled'], $lngstr['label_edittests_hdr_test_enabled_hint'], $srv_settings['table_prefix'] . "tests.test_enabled"));
$i_order_no = isset($_GET["order"]) ? (int) $_GET["order"] : 0;
if ($i_order_no >= count($i_tablefields)) {
    $i_order_no = -1;
<?php

//location
//9917
$g_vars['page']['location'] = array('administration', 'groups');
$g_smarty->assign('g_vars', $g_vars);
displayTemplate('_header');
$g_vars['page']['selected_section'] = 'administration';
//9917
//selected_tab
$g_vars['page']['selected_tab'] = 'groups';
$g_vars['page']['menu_2_items'] = getMenu2Items($g_vars['page']['selected_section']);
writePanel2($g_vars['page']['menu_2_items']);
echo '<h2>' . $lngstr['page_header_managegroups'] . '</h2>';
writeErrorsWarningsBar();
writeInfoBar($lngstr['tooltip_groups']);
$i_pagewide_id = 0;
$i_direction = '';
$i_order_addon = '';
$i_sql_order_addon = '';
$i_tablefields = array(array($lngstr['label_managegroups_hdr_groupid'], $lngstr['label_managegroups_hdr_groupid_hint'], $srv_settings['table_prefix'] . "groups.groupid"), array($lngstr['label_managegroups_hdr_group_name'], $lngstr['label_managegroups_hdr_group_name_hint'], $srv_settings['table_prefix'] . "groups.group_name"), array($lngstr['label_managegroups_hdr_group_description'], $lngstr['label_managegroups_hdr_group_description_hint'], $srv_settings['table_prefix'] . "groups.group_description"));
$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;
}
$i_url_limitto_addon = '';
<?php

$g_vars['page']['location'] = array('test_manager', 'test_manager', 'test_sections');
$g_smarty->assign('g_vars', $g_vars);
displayTemplate('_header');
$f_testid = (int) readGetVar('testid');
$g_vars['page']['selected_section'] = 'testmanager';
$g_vars['page']['selected_tab'] = 'testsections';
$g_vars['page']['menu_2_items'] = getMenu2Items($g_vars['page']['selected_section']);
writePanel2($g_vars['page']['menu_2_items']);
echo '<h2>' . $lngstr['page_header_test_sections'] . '</h2>';
writeErrorsWarningsBar();
writeInfoBar($lngstr['tooltip_tests_sections']);
$i_pagewide_id = 0;
$i_direction = "";
$i_order_addon = "";
$i_sql_order_addon = "";
$i_tablefields = array(array($lngstr['page-sections']['hdr_sectionid'], $lngstr['page-sections']['hdr_sectionid_hint'], $srv_settings['table_prefix'] . "sections.sectionid"), array($lngstr['page-sections']['hdr_section_name'], $lngstr['page-sections']['hdr_section_name_hint'], $srv_settings['table_prefix'] . "sections.section_name"), array($lngstr['page-sections']['hdr_section_description'], $lngstr['page-sections']['hdr_section_description_hint'], $srv_settings['table_prefix'] . "sections.section_description"));
$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;
}
$i_url_limitto_addon = "";
$i_url_pageno_addon = "";
$i_url_limit_addon = "";
$i_pageno = 0;
<?php

$g_vars['page']['location'] = array('question_bank', 'subjects');
$g_smarty->assign('g_vars', $g_vars);
displayTemplate('_header');
$g_vars['page']['selected_section'] = 'questionbank';
$g_vars['page']['selected_tab'] = 'subjects';
$g_vars['page']['menu_2_items'] = getMenu2Items($g_vars['page']['selected_section']);
writePanel2($g_vars['page']['menu_2_items']);
echo '<h2>' . $lngstr['page_header_subjects'] . '</h2>';
writeErrorsWarningsBar();
writeInfoBar($lngstr['tooltip_subjects']);
$i_pagewide_id = 0;
$i_direction = "";
$i_order_addon = "";
$i_sql_order_addon = "";
$i_tablefields = array(array($lngstr["label_subjects_hdr_subjectid"], $lngstr["label_subjects_hdr_subjectid_hint"], $srv_settings['table_prefix'] . "subjects.subjectid"), array($lngstr["label_subjects_hdr_subject_name"], $lngstr["label_subjects_hdr_subject_name_hint"], $srv_settings['table_prefix'] . "subjects.subject_name"), array($lngstr["label_subjects_hdr_subject_description"], $lngstr["label_subjects_hdr_subject_description_hint"], $srv_settings['table_prefix'] . "subjects.subject_description"));
$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;
}
$i_url_limitto_addon = "";
$i_url_pageno_addon = "";
$i_url_limit_addon = "";
$i_pageno = 0;
$i_limitcount = isset($_GET["limitto"]) ? (int) $_GET["limitto"] : $G_SESSION['config_itemsperpage'];
<?php

$g_vars['page']['location'] = array('administration', 'report_templates');
$g_smarty->assign('g_vars', $g_vars);
displayTemplate('_header');
$g_vars['page']['selected_section'] = 'administration';
$g_vars['page']['selected_tab'] = 'reporttemplates';
$g_vars['page']['menu_2_items'] = getMenu2Items($g_vars['page']['selected_section']);
writePanel2($g_vars['page']['menu_2_items']);
echo '<h2>' . $lngstr['page_header_rtemplates'] . '</h2>';
writeErrorsWarningsBar();
writeInfoBar($lngstr['tooltip_rtemplates']);
$i_pagewide_id = 0;
$i_direction = "";
$i_order_addon = "";
$i_sql_order_addon = "";
$i_tablefields = array(array($lngstr['page-rtemplates']['hdr_rtemplateid'], $lngstr['page-rtemplates']['hdr_rtemplateid_hint'], $srv_settings['table_prefix'] . "rtemplates.rtemplateid"), array($lngstr['page-rtemplates']['hdr_rtemplate_name'], $lngstr['page-rtemplates']['hdr_rtemplate_name_hint'], $srv_settings['table_prefix'] . "rtemplates.rtemplate_name"), array($lngstr['page-rtemplates']['hdr_rtemplate_description'], $lngstr['page-rtemplates']['hdr_rtemplate_description_hint'], $srv_settings['table_prefix'] . "rtemplates.rtemplate_description"));
$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;
}
$i_url_limitto_addon = "";
$i_url_pageno_addon = "";
$i_url_limit_addon = "";
$i_pageno = 0;
$i_limitcount = isset($_GET["limitto"]) ? (int) $_GET["limitto"] : $G_SESSION['config_itemsperpage'];
<?php

$g_vars['page']['location'] = array('test_manager', 'grading_systems');
$g_smarty->assign('g_vars', $g_vars);
displayTemplate('_header');
$g_vars['page']['selected_section'] = 'testmanager';
$g_vars['page']['selected_tab'] = 'grades';
$g_vars['page']['menu_2_items'] = getMenu2Items($g_vars['page']['selected_section']);
writePanel2($g_vars['page']['menu_2_items']);
echo '<h2>' . $lngstr['page_header_grades'] . '</h2>';
writeErrorsWarningsBar();
writeInfoBar($lngstr['tooltip_gscales']);
$i_pagewide_id = 0;
$i_direction = "";
$i_order_addon = "";
$i_sql_order_addon = "";
$i_tablefields = array(array($lngstr["label_grades_hdr_gscaleid"], $lngstr["label_grades_hdr_gscaleid_hint"], "gscaleid"), array($lngstr["label_grades_hdr_gscale_name"], $lngstr["label_grades_hdr_gscale_name_hint"], "gscale_name"), array($lngstr["label_grades_hdr_gscale_description"], $lngstr["label_grades_hdr_gscale_description_hint"], "gscale_description"));
$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;
}
$i_url_limitto_addon = "";
$i_url_pageno_addon = "";
$i_url_limit_addon = "";
$i_pageno = 0;
$i_limitcount = isset($_GET["limitto"]) ? (int) $_GET["limitto"] : $G_SESSION['config_itemsperpage'];
<?php

$g_vars['page']['location'] = array('administration', 'web_statistics');
$g_smarty->assign('g_vars', $g_vars);
displayTemplate('_header');
$g_vars['page']['selected_section'] = 'administration';
$g_vars['page']['selected_tab'] = 'visitors';
$g_vars['page']['menu_2_items'] = getMenu2Items($g_vars['page']['selected_section']);
writePanel2($g_vars['page']['menu_2_items']);
echo '<h2>' . $lngstr['page_header_visitors'] . '</h2>';
writeErrorsWarningsBar();
writeInfoBar($lngstr['tooltip_visitors']);
$i_pagewide_id = 0;
$i_direction = "";
$i_order_addon = "";
$i_sql_order_addon = "";
$i_tablefields = array(array($lngstr['label_visitors_hdr_visitorid'], $lngstr['label_visitors_hdr_visitorid_hint'], $srv_settings['table_prefix'] . "visitors.visitorid"), array($lngstr['label_visitors_hdr_startdate'], $lngstr['label_visitors_hdr_startdate_hint'], $srv_settings['table_prefix'] . "visitors.startdate"), array($lngstr['label_visitors_hdr_username'], $lngstr['label_visitors_hdr_username_hint'], $srv_settings['table_prefix'] . "visitors.id"), array($lngstr['label_visitors_hdr_hits'], $lngstr['label_visitors_hdr_hits_hint'], $srv_settings['table_prefix'] . "visitors.hits"), array($lngstr['label_visitors_hdr_ip'], $lngstr['label_visitors_hdr_ip_hint'], ""), array($lngstr['label_visitors_hdr_host'], $lngstr['label_visitors_hdr_host_hint'], $srv_settings['table_prefix'] . "visitors.host"), array($lngstr['label_visitors_hdr_referer'], $lngstr['label_visitors_hdr_referer_hint'], $srv_settings['table_prefix'] . "visitors.referer"));
$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;
}
$i_url_limitto_addon = "";
$i_url_pageno_addon = "";
$i_url_limit_addon = "";
$i_pageno = 0;
$i_limitcount = isset($_GET["limitto"]) ? (int) $_GET["limitto"] : $G_SESSION['config_itemsperpage'];
<?php

$g_vars['page']['location'] = array('administration', 'users');
$g_smarty->assign('g_vars', $g_vars);
displayTemplate('_header');
$g_vars['page']['selected_section'] = 'administration';
$g_vars['page']['selected_tab'] = 'users';
$g_vars['page']['menu_2_items'] = getMenu2Items($g_vars['page']['selected_section']);
writePanel2($g_vars['page']['menu_2_items']);
echo '<h2>' . $lngstr['page_header_manageusers'] . '</h2>';
writeErrorsWarningsBar();
writeInfoBar($lngstr['tooltip_users']);
$i_pagewide_id = 0;
$i_sql_where_addon = '';
$f_user_lastname = readCookieVar('filter_administration_users_user_lastname', readGetVar('user_lastname'));
if (!empty($f_user_lastname)) {
    $i_user_lastname = $g_db->qstr($f_user_lastname, get_magic_quotes_gpc());
    $i_sql_where_addon .= $srv_settings['table_prefix'] . 'users.user_lastname LIKE ' . $i_user_lastname . ' AND ';
}
$f_user_department = readCookieVar('filter_administration_users_user_department', readGetVar('user_department'));
if (!empty($f_user_department)) {
    $i_user_department = $g_db->qstr($f_user_department, get_magic_quotes_gpc());
    $i_sql_where_addon .= $srv_settings['table_prefix'] . 'users.user_department LIKE ' . $i_user_department . ' AND ';
}
if (!empty($i_sql_where_addon)) {
    $i_sql_where_addon = substr($i_sql_where_addon, 0, strlen($i_sql_where_addon) - 5);
}
$i_direction = '';
$i_order_addon = '';
$i_sql_order_addon = '';
$i_tablefields = array(array($lngstr['label_manageusers_hdr_id'], $lngstr['label_manageusers_hdr_id_hint'], $srv_settings['table_prefix'] . 'users.id'), array($lngstr['label_manageusers_hdr_user_notes'], $lngstr['label_manageusers_hdr_user_notes_hint'], ''), array($lngstr['label_manageusers_hdr_username'], $lngstr['label_manageusers_hdr_username_hint'], $srv_settings['table_prefix'] . 'users.username'), array($lngstr['label_manageusers_hdr_email'], $lngstr['label_manageusers_hdr_email_hint'], $srv_settings['table_prefix'] . 'users.email'), array($lngstr['label_manageusers_hdr_user_firstname'], $lngstr['label_manageusers_hdr_user_firstname_hint'], $srv_settings['table_prefix'] . 'users.user_firstname'), array($lngstr['label_manageusers_hdr_user_lastname'], $lngstr['label_manageusers_hdr_user_lastname_hint'], $srv_settings['table_prefix'] . 'users.user_lastname'), array($lngstr['label_manageusers_hdr_user_enabled'], $lngstr['label_manageusers_hdr_user_enabled_hint'], $srv_settings['table_prefix'] . 'users.user_enabled'));
<?php

$g_vars['page']['location'] = array('question_bank', 'question_bank');
$g_smarty->assign('g_vars', $g_vars);
displayTemplate('_header');
$g_vars['page']['selected_section'] = 'questionbank';
$g_vars['page']['selected_tab'] = 'questionbank';
$g_vars['page']['menu_2_items'] = getMenu2Items($g_vars['page']['selected_section']);
writePanel2($g_vars['page']['menu_2_items']);
echo '<h2>' . $lngstr['page_header_questionbank'] . '</h2>';
writeErrorsWarningsBar();
writeInfoBar($lngstr['tooltip_questionbank']);
$i_pagewide_id = 0;
$i_subjectid_addon = '';
$i_sql_where_addon = '';
if (isset($_GET['subjectid']) && $_GET['subjectid'] != '') {
    $i_subjectid_addon .= '&subjectid=' . (int) readGetVar('subjectid');
    $i_sql_where_addon .= $srv_settings['table_prefix'] . 'questions.subjectid=' . (int) readGetVar('subjectid') . ' AND ';
}
$i_direction = "";
$i_order_addon = "";
$i_sql_order_addon = "";
$i_tablefields = array(array($lngstr["label_editquestions_hdr_questionid"], $lngstr["label_editquestions_hdr_questionid_hint"], $srv_settings['table_prefix'] . "questions.questionid"), array($lngstr["label_editquestions_hdr_subjectid"], $lngstr["label_editquestions_hdr_subjectid_hint"], $srv_settings['table_prefix'] . "questions.subjectid"), array($lngstr["label_editquestions_hdr_question_text"], $lngstr["label_editquestions_hdr_question_text_hint"], ""), array($lngstr["label_editquestions_hdr_question_type"], $lngstr["label_editquestions_hdr_question_type_hint"], $srv_settings['table_prefix'] . "questions.question_type"), array($lngstr["label_editquestions_hdr_question_points"], $lngstr["label_editquestions_hdr_question_points_hint"], $srv_settings['table_prefix'] . "questions.question_points"));
$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;