return false; } } else { $g_vars['page']['notifications'] = $lngstr['inf_cant_passtest']; return false; } } else { $g_vars['page']['errors'] = $lngstr['err_no_tests']; return false; } $i_rSet1->Close(); } } $f_testid = (int) readGetVar('testid'); $f_pending_test_result_ids = readCookieVar('pending_test_result_ids'); $f_pending_test_ids = readCookieVar('pending_test_ids'); if ($f_pending_test_result_ids > 0 && ($f_pending_test_ids == $f_testid || $f_testid == 0)) { $i_rSet1 = $g_db->SelectLimit("SELECT * FROM " . $srv_settings['table_prefix'] . "results WHERE resultid=" . $f_pending_test_result_ids . " AND id=" . $G_SESSION['id'] . " AND gscale_gradeid=0", 1); if (!$i_rSet1) { showDBError(__FILE__, 1); } else { if (!$i_rSet1->EOF) { $i_answered_questionids = array(); $i_teststart = $i_rSet1->fields['result_datestart']; $i_got_answers = 0; $i_got_points = 0; $i_points_pending = 0; $i_rSet2 = $g_db->Execute("SELECT questionid, result_answer_points, result_answer_iscorrect FROM " . $srv_settings['table_prefix'] . "results_answers WHERE resultid=" . $f_pending_test_result_ids); if (!$i_rSet2) { showDBError(__FILE__, 2); } else {
define('FPDF_FONTPATH', $DOCUMENT_FPDF . 'font/'); define('SMARTY_DIR', $DOCUMENT_INC . 'smarty/'); require_once $DOCUMENT_LANG . 'en.lng.php'; require_once $DOCUMENT_INC . 'functions.inc.php'; require_once $DOCUMENT_INC . 'events.inc.php'; require_once $DOCUMENT_INC . 'adodb/adodb.inc.php'; require_once $DOCUMENT_INC . 'connect.inc.php'; require_once $DOCUMENT_INC . 'logs.inc.php'; $m_strCurrentKVersion = ''; if (!empty($srv_settings['version'])) { $m_strCurrentKVersion = $srv_settings['version']; } else { $m_strCurrentKVersion = 'NAV'; } header("X-LM1-Version: " . IGT_TIMESTAMP . "-" . $m_strCurrentKVersion); $m_strCurrentLanguage = readCookieVar('current_language'); if (!empty($m_strCurrentLanguage)) { $srv_settings['language'] = $m_strCurrentLanguage; } else { } if ($srv_settings['language'] != 'en') { include_once $DOCUMENT_LANG . $srv_settings['language'] . '.lng.php'; } if (file_exists($DOCUMENT_LANG . 'custom.lng.php')) { include_once $DOCUMENT_LANG . 'custom.lng.php'; } require_once SMARTY_DIR . 'Smarty.class.php'; $g_smarty = new Smarty(); $g_smarty->template_dir = $DOCUMENT_INC . 'templates/default/'; $g_smarty->compile_dir = $DOCUMENT_INC . 'templates/default/compiled/'; $g_smarty->config_dir = $DOCUMENT_INC . 'templates/default/configs/';
$i_sql_where_addon = ''; } } else { $i_sql_where_addon = $srv_settings['table_prefix'] . 'results.id=' . $G_SESSION['id'] . ' AND '; } $f_user_lastname = readCookieVar('filter_reportsmanager_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_testid = readCookieVar('filter_reportsmanager_testid', readGetVar('testid')); if (!empty($f_testid)) { $f_testid = (int) $f_testid; $i_sql_where_addon .= $srv_settings['table_prefix'] . 'results.testid=' . $f_testid . ' AND '; } $f_result_date = readCookieVar('filter_reportsmanager_result_date', readGetVar('result_date', 1)); if ($f_result_date > 0) { $i_result_date = mktime(date("H"), date("i"), date("s"), date("m"), date("d"), date("Y") - $f_result_date); $i_sql_where_addon .= $srv_settings['table_prefix'] . 'results.result_datestart>=' . $i_result_date . ' AND '; } $i_direction = ''; $i_order_addon = ''; $i_sql_order_addon = ''; $i_tablefields = array(array($lngstr['label_report_hdr_resultid'], $lngstr['label_report_hdr_resultid_hint'], $srv_settings['table_prefix'] . 'results.resultid'), array($lngstr['label_report_hdr_result_datestart'], $lngstr['label_report_hdr_result_datestart_hint'], $srv_settings['table_prefix'] . 'results.result_datestart'), array($lngstr['label_report_hdr_username'], $lngstr['label_report_hdr_username_hint'], $srv_settings['table_prefix'] . 'users.username'), array($lngstr['label_report_hdr_test_name'], $lngstr['label_report_hdr_test_name_hint'], $srv_settings['table_prefix'] . 'tests.test_name'), array($lngstr['page_reportsmanager']['hdr_test_attempts'], $lngstr['page_reportsmanager']['hdr_test_attempts_hint'], ''), array($lngstr['label_report_hdr_result_timeexceeded'], $lngstr['label_report_hdr_result_timeexceeded_hint'], $srv_settings['table_prefix'] . 'results.result_timeexceeded'), array($lngstr['label_report_hdr_result_points'], $lngstr['label_report_hdr_result_points_hint'], $srv_settings['table_prefix'] . 'results.result_points'), array($lngstr['label_report_hdr_result_pointsmax'], $lngstr['label_report_hdr_result_pointsmax_hint'], $srv_settings['table_prefix'] . 'results.result_pointsmax'), array($lngstr['label_report_hdr_result_score'], $lngstr['label_report_hdr_result_score_hint'], 'result_score'), array($lngstr['label_report_hdr_gscale_gradeid'], $lngstr['label_report_hdr_gscale_gradeid_hint'], $srv_settings['table_prefix'] . 'gscales_grades.gscale_gradeid')); $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;
if ($i_rSet1->fields['test_datestart'] > $now) { $g_vars['page']['test'][$i_test_count]['status_label'] = sprintf($lngstr['page_panel_status_will_be_available_on'], getDateLocal($lngstr['language']['date_format'], $i_rSet1->fields['test_datestart'])); } else { if ($g_vars['page']['test'][$i_test_count]['attempts_total'] > 0) { if ($g_vars['page']['test'][$i_test_count]['attempts'] >= $g_vars['page']['test'][$i_test_count]['attempts_total']) { $g_vars['page']['test'][$i_test_count]['status_label'] = $lngstr['page-takeatest']['attempts_limit_reached']; } else { $g_vars['page']['test'][$i_test_count]['status_label'] = sprintf($lngstr['page-takeatest']['attempts_left'], $g_vars['page']['test'][$i_test_count]['attempts_total'] - $g_vars['page']['test'][$i_test_count]['attempts']); $g_vars['page']['test'][$i_test_count]['status'] = IGT_TEST_STATUS_AVAILABLE; } } else { $g_vars['page']['test'][$i_test_count]['status_label'] = $lngstr['page_panel_status_available']; $g_vars['page']['test'][$i_test_count]['status'] = IGT_TEST_STATUS_AVAILABLE; } } if ($g_vars['page']['test'][$i_test_count]['testid'] == readCookieVar('pending_test_ids') && $g_vars['page']['test'][$i_test_count]['status'] == IGT_TEST_STATUS_AVAILABLE) { $g_vars['page']['test'][$i_test_count]['status'] = IGT_TEST_STATUS_INPROGRESS; } $g_vars['page']['test'][$i_test_count]['status'] = eventOnQueryTestStatus(array('testno' => $i_test_count, 'testid' => $g_vars['page']['test'][$i_test_count]['testid'], 'status' => $g_vars['page']['test'][$i_test_count]['status'])); } $i_rSet1->MoveNext(); } $i_rSet1->Close(); } } if ($g_vars['page']['user_points_max'] != 0) { $g_vars['page']['user_score'] = $g_vars['page']['user_points'] * 100 / $g_vars['page']['user_points_max']; } else { $g_vars['page']['user_score'] = 0; } $g_vars['page']['test_count'] = $i_test_count;
$i_rSet2->Close(); } $f_testid = (int) readGetVar('testid', readCookieVar('filter_reportsmanager_testid')); $g_vars['page']['testid_content'] = getSelectElement('testid', $f_testid, $i_tests); $i_subjects = array('' => $lngstr['label_none']); $i_rSet2 = $g_db->Execute("SELECT * FROM " . $srv_settings['table_prefix'] . "subjects"); if (!$i_rSet2) { showDBError(__FILE__, 2); } else { while (!$i_rSet2->EOF) { $i_subjects[$i_rSet2->fields['subjectid']] = $i_rSet2->fields['subject_name']; $i_rSet2->MoveNext(); } $i_rSet2->Close(); } $f_subjectid = (int) readGetVar('subjectid', readCookieVar('filter_reportsmanager_subjectid')); $g_vars['page']['subjectid_content'] = getSelectElement('subjectid', $f_subjectid, $i_subjects); if ($G_SESSION['access_reportsmanager'] > 1) { $i_rtemplates = array('' => $lngstr['label_none']); $i_rSet2 = $g_db->Execute("SELECT * FROM " . $srv_settings['table_prefix'] . "rtemplates"); if (!$i_rSet2) { showDBError(__FILE__, 2); } else { while (!$i_rSet2->EOF) { $i_rtemplates[$i_rSet2->fields['rtemplateid']] = $i_rSet2->fields['rtemplate_name']; $i_rSet2->MoveNext(); } $i_rSet2->Close(); } $f_rtemplateid = (int) readGetVar('rtemplateid'); $g_vars['page']['rtemplateid_content'] = getSelectElement('rtemplateid', $f_rtemplateid, $i_rtemplates, ' onchange="document.location.href=\'reports-manager.php?rtemplateid=\'+this.value+\'' . $i_order_addon . $i_url_limitto_addon . '\';"');
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')); $i_order_no = isset($_GET['order']) ? (int) $_GET['order'] : 0; if ($i_order_no >= count($i_tablefields)) { $i_order_no = -1; }
function writeInfoBar($i_content) { global $_COOKIE, $lngstr; $i_isvisible = readCookieVar('showinfobar', 'N') == 'Y'; if ($i_content) { echo '<div id="infobar" style="display: ' . ($i_isvisible ? 'block' : 'none') . ';"><table cellpadding=0 cellspacing=0 border=0 width="97%" align=center style="border: 1px solid #8097D1; background-color: #F3F6FF;">'; echo '<tr><td width=32 vAlign=top style="padding: 5px;"><img src="images/dialog-info.gif" width=32 height=32></td>'; echo '<td width="100%" vAlign=middle style="padding: 5px;"><a href="javascript:ShowInfoBar(false);" title="' . $lngstr['tooltip_closebar'] . '"><img src="images/button-cross-infobar.gif" align=right width=20 height=20 border=0></a>'; echo $i_content; echo '</td>'; echo '</tr></table></div>'; } }