Пример #1
0
                    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 {
Пример #2
0
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;
Пример #4
0
                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>';
    }
}