<?php
if (isset($_POST["box_grades"])) {
foreach ($_POST["box_grades"] as $f_gscaleid) {
deleteGrade((int) $f_gscaleid);
}
} else {
$f_gscaleid = (int) readGetVar('gscaleid');
deleteGrade($f_gscaleid);
}
gotoLocation('grades.php' . getURLAddon('', array('action', 'confirmed', 'gscaleid')));
function deleteGrade($i_gscaleid)
{
global $g_db, $srv_settings;
if ($i_gscaleid > SYSTEM_GRADES_MAX_INDEX) {
if ($g_db->Execute("UPDATE " . $srv_settings['table_prefix'] . "tests SET gscaleid=1 WHERE gscaleid=" . $i_gscaleid) === false) {
showDBError(__FILE__, 1);
}
if ($g_db->Execute("DELETE FROM " . $srv_settings['table_prefix'] . "gscales_grades WHERE gscaleid={$i_gscaleid}") === false) {
showDBError(__FILE__, 2);
}
if ($g_db->Execute("DELETE FROM " . $srv_settings['table_prefix'] . "gscales WHERE gscaleid={$i_gscaleid}") === false) {
showDBError(__FILE__, 3);
}
}
}
<?php
$f_groupid = (int) readGetVar('groupid');
$f_testids = explode(SYSTEM_ARRAY_ITEM_SEPARATOR, readGetVar('testids'));
$i_sql_where_addon = '';
if ($_GET["set"]) {
foreach ($f_testids as $i_testid) {
//9917//9917
$g_db->Execute("INSERT INTO " . $srv_settings['table_prefix'] . "groups_tests (groupid, testid) VALUES ({$f_groupid}, {$i_testid})");
}
} else {
reset($f_testids);
if (list(, $val) = each($f_testids)) {
$i_sql_where_addon .= "testid=" . (int) $val;
}
while (list(, $val) = each($f_testids)) {
$i_sql_where_addon .= " OR testid=" . (int) $val;
}
if ($i_sql_where_addon) {
$i_sql_where_addon = ' AND (' . $i_sql_where_addon . ')';
}
//9917//9917
if ($g_db->Execute("DELETE FROM " . $srv_settings['table_prefix'] . "groups_tests WHERE groupid={$f_groupid}" . $i_sql_where_addon) === false) {
showDBError(__FILE__, 2);
}
}
gotoLocation('test-manager.php' . getURLAddon('?action=groups', array('action', 'groupid', 'set')));
setCookieVar('filter_reportsmanager_result_date', 0);
setCookieVar('filter_reportsmanager_result_datestart', 0);
setCookieVar('filter_reportsmanager_result_dateend', 0);
setCookieVar('filter_reportsmanager_id', '');
setCookieVar('filter_reportsmanager_testid', '');
setCookieVar('filter_reportsmanager_user_lastname', '');
setCookieVar('filter_reportsmanager_user_department', '');
setCookieVar('filter_reportsmanager_subjectid', '');
gotoLocation('reports-manager.php' . getURLAddon('?action=', array('action', 'id', 'user_lastname', 'user_department', 'testid')));
}
break;
case 'exportcsv':
if ($G_SESSION['access_reportsmanager'] > 1) {
include_once $DOCUMENT_PAGES . 'reports-manager-exportcsv.inc.php';
} else {
gotoLocation('reports-manager.php' . getURLAddon('?action=', array('action')));
}
break;
case 'preview':
case 'print':
include_once $DOCUMENT_PAGES . 'reports-manager-report-1.inc.php';
break;
default:
include_once $DOCUMENT_PAGES . 'reports-manager-1.inc.php';
}
} else {
$g_vars['page']['notifications'] = $lngstr['inf_cant_view_results'];
include_once $DOCUMENT_PAGES . 'home.inc.php';
}
} else {
$g_vars['page']['title'] = $lngstr['page_title_signin'];
$i_strData = str_replace("\r", '', $i_strData);
$i_strData = str_replace(' ', '', $i_strData);
$i_nData = (int) $i_strData;
if ($i_nData < 0) {
$i_nData = 0;
}
$f_subjectid = $i_nData;
break;
}
$i_nCurrNearest = $i_nNextNearest;
$i_nCurrNearestPos = $i_nNextNearestPos;
}
if (!empty($f_question_text)) {
insertQuestion();
}
gotoLocation('test-manager.php' . getURLAddon('?action=editt', array('action')));
function NewValueApply($i_nAnswerType, $i_strValue)
{
global $f_answer_correct, $f_answer_percents;
switch ($i_nAnswerType) {
case QUESTION_TYPE_MULTIPLECHOICE:
case QUESTION_TYPE_TRUEFALSE:
case QUESTION_TYPE_MULTIPLEANSWER:
if (!is_array($f_answer_correct)) {
$f_answer_correct = array();
}
if (!is_array($f_answer_percents)) {
$f_answer_percents = array();
}
$i_nValue = (int) $i_strValue;
if ($i_nValue > 0 and $i_nValue <= MAX_ANSWER_COUNT) {
<?php
$f_testid = (int) readGetVar('testid');
$f_id = (int) readGetVar('id');
if ((int) readGetVar('set')) {
$g_db->Execute("INSERT INTO " . $srv_settings['table_prefix'] . "tests_attempts (testid, id, test_attempt_count) VALUES (" . $f_testid . ", " . $f_id . ", 0)");
$g_db->Execute("UPDATE " . $srv_settings['table_prefix'] . "tests_attempts SET test_attempt_count=999999 WHERE testid=" . $f_testid . " AND id=" . $f_id);
} else {
$g_db->Execute("DELETE FROM " . $srv_settings['table_prefix'] . "tests_attempts WHERE testid=" . $f_testid . " AND id=" . $f_id);
}
gotoLocation('reports-manager.php' . getURLAddon('?action=', array('action', 'testid', 'id', 'set')));
<?php
$f_id = (int) readGetVar('id');
$f_set = isset($_GET["set"]) ? (int) $_GET["set"] : 0;
if ($g_db->Execute("UPDATE " . $srv_settings['table_prefix'] . "users SET user_enabled=" . $f_set . " WHERE id=" . $f_id) === false) {
showDBError(__FILE__, 1);
}
gotoLocation('users.php' . getURLAddon('', array('action', 'set')));
if (isset($_POST['bsubmit']) || isset($_POST['bsubmit2'])) {
if ($G_SESSION['access_questionbank'] > 1) {
include_once $DOCUMENT_PAGES . "edit_questions-3.inc.php";
} else {
if (isset($_GET['testid'])) {
gotoLocation('test-manager.php' . getURLAddon('?action=editt', array('action', 'questionid')));
} else {
gotoLocation('question-bank.php' . getURLAddon('', array('action')));
}
}
} else {
if (isset($_POST['bcancel'])) {
if (isset($_GET['testid'])) {
gotoLocation('test-manager.php' . getURLAddon('?action=editt', array('action', 'questionid')));
} else {
gotoLocation('question-bank.php' . getURLAddon('', array('action')));
}
} else {
include_once $DOCUMENT_PAGES . "edit_questions-2.inc.php";
}
}
}
break;
case 'statsq':
$g_vars['page']['title'] = $lngstr['page_title_question_stats'] . $lngstr['item_separator'] . $g_vars['page']['title'];
if (isset($_GET['questionid']) || isset($_POST["box_questions"])) {
include_once $DOCUMENT_PAGES . "question-bank-2.inc.php";
} else {
gotoLocation('question-bank.php');
}
break;
<?php
require_once "../inc/init.inc.php";
$i_url = '/guide.php' . getURLAddon();
if (!empty($_GET['language'])) {
$i_language = readGetVar('language');
} else {
$i_language = $srv_settings['language'];
}
if ($i_language != 'en' && $i_language != 'de' && $i_language != 'es') {
$i_language = 'en';
}
$i_url = $i_language . '' . $i_url;
gotoLocation($i_url);
<?php
$f_groupid = (int) readGetVar('groupid');
$f_ids = explode(SYSTEM_ARRAY_ITEM_SEPARATOR, readGetVar('ids'));
if ($_GET["set"]) {
foreach ($f_ids as $i_id) {
//9917//9917
$g_db->Execute("INSERT INTO " . $srv_settings['table_prefix'] . "groups_users (groupid, id) VALUES ({$f_groupid}, {$i_id})");
}
} else {
$i_sql_where_addon = '';
reset($f_ids);
if (list(, $val) = each($f_ids)) {
$i_sql_where_addon .= "id=" . (int) $val;
}
while (list(, $val) = each($f_ids)) {
$i_sql_where_addon .= " OR id=" . (int) $val;
}
if ($i_sql_where_addon) {
$i_sql_where_addon = ' AND (' . $i_sql_where_addon . ')';
}
//9917//9917
if ($g_db->Execute("DELETE FROM " . $srv_settings['table_prefix'] . "groups_users WHERE groupid={$f_groupid}" . $i_sql_where_addon) === false) {
showDBError(__FILE__, 2);
}
}
gotoLocation('users.php' . getURLAddon('?action=groups', array('action')));
$i_confirm_url = 'groups.php?groupid=' . (int) $_GET['groupid'] . '&action=delete';
include_once $DOCUMENT_PAGES . "confirm.inc.php";
}
}
} else {
gotoLocation('groups.php' . getURLAddon('', array('action')));
}
break;
case 'edit':
$g_vars['page']['title'] = $lngstr['page_title_groups_settings'] . $lngstr['item_separator'] . $g_vars['page']['title'];
if (isset($_GET['groupid'])) {
if (isset($_POST['bsubmit'])) {
if ($G_SESSION['access_groups'] > 1) {
include_once $DOCUMENT_PAGES . "groups-3.inc.php";
} else {
gotoLocation('groups.php' . getURLAddon('', array('action')));
}
} else {
if (isset($_POST['bcancel'])) {
gotoLocation('groups.php');
} else {
include_once $DOCUMENT_PAGES . "groups-2.inc.php";
}
}
}
break;
default:
include_once $DOCUMENT_PAGES . "groups-1.inc.php";
}
} else {
$g_vars['page']['notifications'] = $lngstr['inf_cant_access_groups'];
<?php
if (isset($_POST["box_rtemplates"])) {
foreach ($_POST["box_rtemplates"] as $f_rtemplateid) {
deleteRTemplate((int) $f_rtemplateid);
}
} else {
$f_rtemplateid = (int) readGetVar('rtemplateid');
deleteRTemplate($f_rtemplateid);
}
gotoLocation('report-templates.php' . getURLAddon('', array('action', 'confirmed', 'rtemplateid')));
function deleteRTemplate($i_rtemplateid)
{
global $g_db, $srv_settings;
if ($i_rtemplateid > SYSTEM_RTEMPLATES_MAX_INDEX) {
if ($g_db->Execute("UPDATE " . $srv_settings['table_prefix'] . "tests SET rtemplateid=0 WHERE rtemplateid={$i_rtemplateid}") === false) {
showDBError(__FILE__, 1);
}
if ($g_db->Execute("DELETE FROM " . $srv_settings['table_prefix'] . "rtemplates WHERE rtemplateid={$i_rtemplateid}") === false) {
showDBError(__FILE__, 2);
}
}
}
}
if ($i_pageno <= $i_pageno_count - floor($nPageWindow / 2) && $nStartPage + $nPageWindow - 1 <= $i_pageno_count) {
$nEndPage = $nStartPage + $nPageWindow - 1;
} else {
$nEndPage = $i_pageno_count;
if ($nEndPage - $nPageWindow + 1 >= 1) {
$nStartPage = $nEndPage - $nPageWindow + 1;
}
}
$nRecordFrom = ($i_pageno - 1) * $i_limitcount + 1;
if ($i_pageno != $i_pageno_count) {
$nRecordTo = $i_pageno * $i_limitcount;
} else {
$nRecordTo = $i_recordcount;
}
$g_vars['page']['filter']['url_addon'] = getURLAddon('?action=filter', array('action'));
$g_vars['page']['filter']['result_date'] = $f_result_date;
$g_vars['page']['filter']['result_datestart_formatted'] = $f_result_datestart > 0 ? getDateLocal($lngstr['language']['calendar']['date_format'], $f_result_datestart) : '';
$g_vars['page']['filter']['result_dateend_formatted'] = $f_result_dateend > 0 ? getDateLocal($lngstr['language']['calendar']['date_format'], $f_result_dateend) : '';
if ($G_SESSION['access_reportsmanager'] > 1) {
$i_users = array('' => $lngstr['label_none']);
$i_rSet2 = $g_db->Execute("SELECT * FROM " . $srv_settings['table_prefix'] . "users");
if (!$i_rSet2) {
showDBError(__FILE__, 2);
} else {
while (!$i_rSet2->EOF) {
$i_users[$i_rSet2->fields['id']] = $i_rSet2->fields['username'];
$i_rSet2->MoveNext();
}
$i_rSet2->Close();
}
$g_vars['page']['title'] = $lngstr['page_title_users_memberof'] . $lngstr['item_separator'] . $g_vars['page']['title'];
if (isset($_GET['id']) || isset($_POST['box_users']) || isset($_GET['ids'])) {
include_once $DOCUMENT_PAGES . 'manageusers-8.inc.php';
} else {
gotoLocation('users.php');
}
break;
case 'memberof':
if ($G_SESSION['access_users'] > 1 && $G_SESSION['access_groups'] > 1) {
if (isset($_GET['groupid']) && isset($_GET['ids'])) {
include_once $DOCUMENT_PAGES . 'manageusers-9.inc.php';
}
} else {
gotoLocation('users.php' . getURLAddon('?action=groups', array('action')));
}
break;
default:
if ($G_SESSION['access_users'] == 2 || $G_SESSION['access_users'] == 4) {
include_once $DOCUMENT_PAGES . 'manageusers-1.inc.php';
} else {
gotoLocation('users.php' . getURLAddon('?action=edit&id=' . $G_SESSION['id'], array('action', 'id')));
}
}
} else {
$g_vars['page']['notifications'] = $lngstr['inf_cant_access_users'];
include_once $DOCUMENT_PAGES . 'home.inc.php';
}
} else {
$g_vars['page']['title'] = $lngstr['page_title_signin'];
include_once $DOCUMENT_PAGES . 'signin-1.inc.php';
}
<?php
if (isset($_POST["box_users"])) {
foreach ($_POST["box_users"] as $f_id) {
deleteUser((int) $f_id);
}
} else {
$f_id = (int) readGetVar('id');
deleteUser($f_id);
}
gotoLocation('users.php' . getURLAddon('', array('action', 'confirmed')));
function deleteUser($i_id)
{
global $g_db, $srv_settings;
if ($i_id > SYSTEM_USER_MAX_INDEX) {
$g_db->Execute("DELETE FROM " . $srv_settings['table_prefix'] . "tests_attempts WHERE id=" . $i_id);
$i_rSet1 = $g_db->Execute("SELECT resultid FROM " . $srv_settings['table_prefix'] . "results WHERE id=" . $i_id);
if (!$i_rSet1) {
showDBError(__FILE__, 1);
} else {
while (!$i_rSet1->EOF) {
deleteResultRecord($i_rSet1->fields["resultid"]);
$i_rSet1->MoveNext();
}
$i_rSet1->Close();
}
if ($g_db->Execute("DELETE FROM " . $srv_settings['table_prefix'] . "results WHERE id=" . $i_id) === false) {
showDBError(__FILE__, 2);
}
//9917//9917
if ($g_db->Execute("DELETE FROM " . $srv_settings['table_prefix'] . "groups_users WHERE id=" . $i_id) === false) {
switch ($f_question_type) {
case QUESTION_TYPE_FILLINTHEBLANK:
$f_answer_feedback = array(1 => $g_db->qstr('', 0));
$f_answer_correct = array(1 => 1);
$f_answer_percents = array(1 => 100);
break;
}
include_once $DOCUMENT_PAGES . 'edit_questions-3-int.inc.php';
$f_answercount = (int) readPostVar('answercount');
if (isset($_GET['resultid'])) {
if (isset($_POST['bsubmit2'])) {
gotoLocation('question-bank.php' . getURLAddon('?action=createq&question_type=' . $f_question_type . '&subjectid=' . $f_subjectid . '&answercount=' . $f_answercount, array('action', 'questionid', 'question_type', 'subjectid', 'answercount')));
} else {
gotoLocation('reports-manager.php' . getURLAddon('?action=viewq', array('action', 'questionid', 'question_type', 'subjectid', 'answercount')));
}
} else {
if (isset($_GET['testid'])) {
$f_testid = (int) readGetVar('testid');
if (isset($_POST['bsubmit2'])) {
gotoLocation('question-bank.php' . getURLAddon('?action=createq&question_type=' . $f_question_type . '&subjectid=' . $f_subjectid . '&answercount=' . $f_answercount, array('action', 'questionid', 'question_type', 'subjectid', 'answercount')));
} else {
gotoLocation('test-manager.php' . getURLAddon('?action=editt', array('action', 'questionid', 'question_type', 'subjectid', 'answercount')));
}
} else {
if (isset($_POST['bsubmit2'])) {
gotoLocation('question-bank.php' . getURLAddon('?action=createq&question_type=' . $f_question_type . '&subjectid=' . $f_subjectid . '&answercount=' . $f_answercount, array('action', 'questionid', 'question_type', 'subjectid', 'answercount')));
} else {
gotoLocation('question-bank.php' . getURLAddon('', array('action', 'questionid', 'question_type', 'subjectid', 'answercount')));
}
}
}
<?php
$f_testid = (int) readGetVar('testid');
$f_set = isset($_GET['set']) ? (int) $_GET['set'] : 0;
if ($g_db->Execute("UPDATE " . $srv_settings['table_prefix'] . "tests SET test_enabled={$f_set} WHERE testid={$f_testid}") === false) {
showDBError(__FILE__, 1);
}
gotoLocation('test-manager.php' . getURLAddon('', array('action', 'testid', 'confirmed', 'set')));
<?php
if (isset($_POST["box_etemplates"])) {
foreach ($_POST["box_etemplates"] as $f_etemplateid) {
deleteETemplate((int) $f_etemplateid);
}
} else {
$f_etemplateid = (int) readGetVar('etemplateid');
deleteETemplate($f_etemplateid);
}
gotoLocation('email-templates.php' . getURLAddon('', array('action', 'confirmed', 'etemplateid')));
function deleteETemplate($i_etemplateid)
{
global $g_db, $srv_settings;
if ($i_etemplateid > SYSTEM_ETEMPLATES_MAX_INDEX) {
if ($g_db->Execute("UPDATE " . $srv_settings['table_prefix'] . "tests SET result_etemplateid=0 WHERE result_etemplateid={$i_etemplateid}") === false) {
showDBError(__FILE__, 1);
}
if ($g_db->Execute("DELETE FROM " . $srv_settings['table_prefix'] . "etemplates WHERE etemplateid={$i_etemplateid}") === false) {
showDBError(__FILE__, 2);
}
}
}
<?php
$f_gscaleid = (int) readGetVar('gscaleid');
$f_gscale_gradeid = (int) readGetVar('gscale_gradeid');
$i_gradecount = getRecordCount($srv_settings['table_prefix'] . 'gscales_grades', "gscaleid=" . $f_gscaleid);
if ($f_gscale_gradeid < $i_gradecount) {
$g_db->Execute("LOCK TABLES " . $srv_settings['table_prefix'] . "gscales_grades WRITE");
$g_db->Execute("UPDATE " . $srv_settings['table_prefix'] . "gscales_grades SET gscale_gradeid=0 WHERE gscale_gradeid=" . ($f_gscale_gradeid + 1) . " AND gscaleid=" . $f_gscaleid);
$g_db->Execute("UPDATE " . $srv_settings['table_prefix'] . "gscales_grades SET gscale_gradeid=gscale_gradeid+1 WHERE gscale_gradeid=" . $f_gscale_gradeid . " AND gscaleid=" . $f_gscaleid);
$g_db->Execute("UPDATE " . $srv_settings['table_prefix'] . "gscales_grades SET gscale_gradeid=" . $f_gscale_gradeid . " WHERE gscale_gradeid=0 AND gscaleid=" . $f_gscaleid);
$g_db->Execute("UNLOCK TABLES");
}
gotoLocation('grades.php' . getURLAddon('?action=edit', array('action')));
setConfigItem(CONFIG_reg_values_userfield3, readPostVar('values_userfield3'));
setConfigItem(CONFIG_reg_userfield4, (int) readPostVar('userfield4'));
setConfigItem(CONFIG_reg_caption_userfield4, readPostVar('caption_userfield4'));
setConfigItem(CONFIG_reg_type_userfield4, readPostVar('type_userfield4'));
setConfigItem(CONFIG_reg_values_userfield4, readPostVar('values_userfield4'));
setConfigItem(CONFIG_reg_userfield5, (int) readPostVar('userfield5'));
setConfigItem(CONFIG_reg_caption_userfield5, readPostVar('caption_userfield5'));
setConfigItem(CONFIG_reg_type_userfield5, readPostVar('type_userfield5'));
setConfigItem(CONFIG_reg_values_userfield5, readPostVar('values_userfield5'));
setConfigItem(CONFIG_reg_userfield6, (int) readPostVar('userfield6'));
setConfigItem(CONFIG_reg_caption_userfield6, readPostVar('caption_userfield6'));
setConfigItem(CONFIG_reg_type_userfield6, readPostVar('type_userfield6'));
setConfigItem(CONFIG_reg_values_userfield6, readPostVar('values_userfield6'));
setConfigItem(CONFIG_reg_userfield7, (int) readPostVar('userfield7'));
setConfigItem(CONFIG_reg_caption_userfield7, readPostVar('caption_userfield7'));
setConfigItem(CONFIG_reg_type_userfield7, readPostVar('type_userfield7'));
setConfigItem(CONFIG_reg_values_userfield7, readPostVar('values_userfield7'));
setConfigItem(CONFIG_reg_userfield8, (int) readPostVar('userfield8'));
setConfigItem(CONFIG_reg_caption_userfield8, readPostVar('caption_userfield8'));
setConfigItem(CONFIG_reg_type_userfield8, readPostVar('type_userfield8'));
setConfigItem(CONFIG_reg_values_userfield8, readPostVar('values_userfield8'));
setConfigItem(CONFIG_reg_userfield9, (int) readPostVar('userfield9'));
setConfigItem(CONFIG_reg_caption_userfield9, readPostVar('caption_userfield9'));
setConfigItem(CONFIG_reg_type_userfield9, readPostVar('type_userfield9'));
setConfigItem(CONFIG_reg_values_userfield9, readPostVar('values_userfield9'));
setConfigItem(CONFIG_reg_userfield10, (int) readPostVar('userfield10'));
setConfigItem(CONFIG_reg_caption_userfield10, readPostVar('caption_userfield10'));
setConfigItem(CONFIG_reg_type_userfield10, readPostVar('type_userfield10'));
setConfigItem(CONFIG_reg_values_userfield10, readPostVar('values_userfield10'));
gotoLocation('config.php' . getURLAddon('', array('action')));
<?php
if (isset($_POST["box_questions"])) {
foreach ($_POST["box_questions"] as $f_questionid) {
deleteQuestion((int) $f_questionid);
}
} else {
$f_questionid = (int) readGetVar('questionid');
deleteQuestion($f_questionid);
}
if (isset($_GET["testid"])) {
gotoLocation('test-manager.php' . getURLAddon('?action=editt', array('action', 'confirmed', 'questionid')));
} else {
gotoLocation('question-bank.php' . getURLAddon('', array('action', 'confirmed', 'questionid')));
}
function deleteQuestion($i_questionid)
{
global $g_db, $srv_settings;
$i_rSet1 = $g_db->Execute("SELECT test_questionid, testid FROM " . $srv_settings['table_prefix'] . "tests_questions WHERE questionid={$i_questionid} ORDER BY test_questionid DESC");
if (!$i_rSet1) {
showDBError(__FILE__, 1);
} else {
while (!$i_rSet1->EOF) {
deleteQuestionLink($i_rSet1->fields["testid"], $i_rSet1->fields["test_questionid"]);
$i_rSet1->MoveNext();
}
$i_rSet1->Close();
}
if ($g_db->Execute("DELETE FROM " . $srv_settings['table_prefix'] . "answers WHERE questionid={$i_questionid}") === false) {
showDBError(__FILE__, 2);
}
<?php
$f_testid = (int) readGetVar('testid');
if (isset($_POST["box_qlinks"]) && is_array($_POST["box_qlinks"])) {
$i_qlinks = $_POST["box_qlinks"];
rsort($i_qlinks, SORT_NUMERIC);
foreach ($i_qlinks as $f_test_questionid) {
deleteQuestionLink($f_testid, (int) $f_test_questionid);
}
} else {
$f_test_questionid = (int) readGetVar('test_questionid');
deleteQuestionLink($f_testid, $f_test_questionid);
}
gotoLocation('test-manager.php' . getURLAddon('?action=editt', array('action', 'confirmed', 'test_questionid')));
<?php
$f_testid = (int) readGetVar('testid');
if ($f_testid) {
$i_subjectid = 0;
$i_rSet1 = $g_db->Execute("SELECT subjectid FROM " . $srv_settings['table_prefix'] . "tests WHERE testid={$f_testid}");
if (!$i_rSet1) {
showDBError(__FILE__, 1);
} else {
if (!$i_rSet1->EOF) {
$i_subjectid = (int) $i_rSet1->fields['subjectid'];
}
$i_rSet1->Close();
}
if ($g_db->Execute("INSERT INTO " . $srv_settings['table_prefix'] . "questions (subjectid, question_pre, question_post, question_text, question_solution) VALUES(" . $i_subjectid . ", '', '', '', '')") === false) {
showDBError(__FILE__, 2);
}
$i_questionid = (int) $g_db->Insert_ID($srv_settings['table_prefix'] . 'questions', 'questionid');
createQuestionLink($f_testid, $i_questionid);
gotoLocation('question-bank.php' . getURLAddon('?action=editq&questionid=' . $i_questionid, array('action', 'questionid')));
} else {
if ($g_db->Execute("INSERT INTO " . $srv_settings['table_prefix'] . "questions (question_pre, question_post, question_text, question_solution) VALUES('', '', '', '')") === false) {
showDBError(__FILE__, 3);
}
$i_questionid = (int) $g_db->Insert_ID($srv_settings['table_prefix'] . 'questions', 'questionid');
gotoLocation('question-bank.php' . getURLAddon('?action=editq&questionid=' . $i_questionid, array('action', 'questionid')));
}
} else {
}
}
break;
case 'results':
if (isset($G_SESSION['yt_state']) && $G_SESSION['yt_state'] == TEST_STATE_TRESULTS) {
include_once $DOCUMENT_PAGES . 'test-showresults.inc.php';
}
break;
default:
if (!isset($G_SESSION['testid']) || isset($_GET['testid']) && $_GET['testid'] != $G_SESSION['testid'] || isset($G_SESSION['yt_state']) && ($G_SESSION['yt_state'] >= TEST_STATE_TRESULTS || $G_SESSION['yt_state'] == TEST_STATE_TESTINTRO)) {
include_once $DOCUMENT_PAGES . 'test-3.inc.php';
} else {
if (isset($_POST['breview']) && !empty($_POST['review_questionno'])) {
$i_questionno = (int) $_POST['review_questionno'];
gotoLocation('test.php' . getURLAddon('?action=review&questionno=' . $i_questionno, array('action')));
} else {
if (isset($_POST['bsubmit']) || isset($_POST['bsubmit_prev']) || isset($_POST['bsubmit_next']) || isset($_POST['bsubmit_answer'])) {
if ($G_SESSION['yt_test_qsperpage'] != 1) {
include_once $DOCUMENT_PAGES . 'test-7.inc.php';
} else {
include_once $DOCUMENT_PAGES . 'test-2.inc.php';
}
} else {
if ($G_SESSION['yt_test_qsperpage'] != 1) {
include_once $DOCUMENT_PAGES . 'test-6.inc.php';
} else {
include_once $DOCUMENT_PAGES . 'test-1.inc.php';
}
}
}
$i_confirm_url = 'subjects.php?subjectid=' . (int) $_GET['subjectid'] . '&action=delete';
include_once $DOCUMENT_PAGES . "confirm.inc.php";
}
}
} else {
gotoLocation('subjects.php' . getURLAddon('', array('action', 'confirmed')));
}
break;
case 'edit':
$g_vars['page']['title'] = $lngstr['page_title_subjects_settings'] . $lngstr['item_separator'] . $g_vars['page']['title'];
if (isset($_GET['subjectid'])) {
if (isset($_POST['bsubmit'])) {
if ($G_SESSION['access_subjects'] > 1) {
include_once $DOCUMENT_PAGES . "subjects-3.inc.php";
} else {
gotoLocation('subjects.php' . getURLAddon('', array('action')));
}
} else {
if (isset($_POST['bcancel'])) {
gotoLocation('subjects.php');
} else {
include_once $DOCUMENT_PAGES . "subjects-2.inc.php";
}
}
}
break;
default:
include_once $DOCUMENT_PAGES . "subjects-1.inc.php";
}
} else {
$g_vars['page']['notifications'] = $lngstr['inf_cant_access_subjects'];
<?php
if (isset($_POST["box_subjects"])) {
foreach ($_POST["box_subjects"] as $f_subjectid) {
deletesubject((int) $f_subjectid);
}
} else {
$f_subjectid = (int) readGetVar('subjectid');
deletesubject($f_subjectid);
}
gotoLocation('subjects.php' . getURLAddon('', array('action', 'confirmed')));
function deletesubject($i_subjectid)
{
global $g_db, $srv_settings;
if ($i_subjectid > SYSTEM_SUBJECTS_MAX_INDEX) {
if ($g_db->Execute("UPDATE " . $srv_settings['table_prefix'] . "tests SET subjectid=1 WHERE subjectid=" . $i_subjectid) === false) {
showDBError(__FILE__, 1);
}
if ($g_db->Execute("UPDATE " . $srv_settings['table_prefix'] . "questions SET subjectid=1 WHERE subjectid=" . $i_subjectid) === false) {
showDBError(__FILE__, 2);
}
if ($g_db->Execute("DELETE FROM " . $srv_settings['table_prefix'] . "subjects WHERE subjectid={$i_subjectid}") === false) {
showDBError(__FILE__, 3);
}
}
}
<?php
if (isset($_POST["box_results"])) {
foreach ($_POST["box_results"] as $f_resultid) {
deleteResultRecord((int) $f_resultid);
}
} else {
$f_resultid = (int) readGetVar('resultid');
deleteResultRecord($f_resultid);
}
gotoLocation('reports-manager.php' . getURLAddon('?action=', array('action', 'resultid', 'confirmed')));
break;
case QUESTION_TYPE_ESSAY:
writeTR2($lngstr['page_editquestion_answer_count'], $lngstr['label_notapplicable']);
writeTR2($lngstr['page_editquestion_question_text'], getTextEditor($G_SESSION['config_editortype'], 'question_text', !empty($i_rSet1->fields['question_text']) ? $i_rSet1->fields['question_text'] : $lngstr['page_editquestion_emptyquestion']));
break;
case QUESTION_TYPE_RANDOM:
writeTR2($lngstr['page_editquestion_question_name'], getInputElement('question_text', !empty($i_rSet1->fields['question_text']) ? $i_rSet1->fields['question_text'] : $lngstr['label_atype_random'] . ' (' . $i_subjects[$f_subjectid] . ')'));
break;
}
$i_rSet3->Close();
}
if ($f_question_type != QUESTION_TYPE_RANDOM) {
writeTR2($lngstr['page_editquestion_points'], getInputElement('question_points', $i_rSet1->fields['question_points'], 3));
}
echo '</table>';
echo '<p class=center><input class=btn type=submit name=bsubmit value=" ' . $lngstr['button_update'] . ' "> <input class=btn type=submit name=bsubmit2 value=" ' . $lngstr['button_update_and_create_new_question'] . ' "> <input class=btn type=submit name=bcancel value=" ' . $lngstr['button_cancel'] . ' "></form>';
echo '<script language=JavaScript type="text/javascript">
function updateQuestion() {
ctlQuestionType = document.getElementById("question_type");
nQuestionType = ctlQuestionType ? document.getElementById("question_type").options[document.getElementById("question_type").selectedIndex].value : "";
ctlSubjectID = document.getElementById("subjectid");
nSubjectID = ctlSubjectID ? ctlSubjectID.options[ctlSubjectID.selectedIndex].value : "";
ctlAnswerCount = document.getElementById("answercount");
nAnswerCount = ctlAnswerCount ? ctlAnswerCount.options[ctlAnswerCount.selectedIndex].value : "";
window.open("question-bank.php' . getURLAddon('', array('question_type', 'subjectid', 'answercount')) . '&question_type="+nQuestionType+"&subjectid="+nSubjectID+"&answercount="+nAnswerCount,"_top");
}
</script>';
}
$i_rSet1->Close();
}
displayTemplate('_footer');
if ($i_rSet2 = $g_db->Execute("SELECT subjectid FROM " . $srv_settings['table_prefix'] . "subjects WHERE subjectid={$f_subjectid}")) {
$sql_subject_exists = $i_rSet2->RecordCount() > 0;
} else {
$sql_subject_exists = false;
}
if (!$sql_subject_exists) {
$g_vars['page']['errors'] .= $lngstr['err_subject_doesnotexist'];
}
$strQrySet = "test_type=" . $f_test_type . ", subjectid=" . $f_subjectid . ", gscaleid=" . $f_gscaleid . ", rtemplateid=" . $f_rtemplateid . ", test_reportgradecondition=" . $f_test_reportgradecondition . ", result_etemplateid=" . $f_result_etemplateid . ", test_name=" . $f_test_name . ", test_code=" . $f_test_code . ", test_description=" . $f_test_description . ", test_time=" . $nTestTime . ", test_timeforceout={$f_test_timeforceout}, test_attempts={$f_test_attempts}, test_contentprotection={$f_test_contentprotection}, test_shuffleq={$f_test_shuffleq}, test_shufflea={$f_test_shufflea}, test_qsperpage={$f_test_qsperpage}, test_canreview={$f_test_canreview}, test_showqfeedback={$f_test_showqfeedback}, test_result_showgrade={$f_test_result_showgrade}, test_result_showgradefeedback={$f_test_result_showgradefeedback}, test_result_showanswers={$f_test_result_showanswers}, test_result_showpoints={$f_test_result_showpoints}, test_result_rtemplateid={$f_test_result_rtemplateid}, test_result_showhtml={$f_test_result_showhtml}, test_result_showpdf={$f_test_result_showpdf}, test_result_email={$f_test_result_email}, test_result_emailtouser={$f_test_result_emailtouser}, test_datestart={$f_test_datestart}, test_dateend={$f_test_dateend}, test_instructions={$f_test_instructions}, test_prevtestid={$f_test_prevtestid}, test_nexttestid={$f_test_nexttestid}, test_price={$f_test_price}, test_other_repeatuntilcorrect={$f_test_other_repeatuntilcorrect}, test_notes={$f_test_notes}, test_forall={$f_test_forall}, test_enabled={$f_test_enabled}";
if ($g_vars['page']['errors']) {
include_once $DOCUMENT_PAGES . "test-manager-2.inc.php";
} else {
if ($g_db->Execute("UPDATE " . $srv_settings['table_prefix'] . "tests SET " . $strQrySet . " WHERE testid={$f_testid}") === false) {
showDBError(__FILE__, 1);
}
//9917//9917
if ($g_db->Execute("DELETE FROM " . $srv_settings['table_prefix'] . "groups_tests WHERE testid=" . $f_testid) === false) {
showDBError(__FILE__, 2);
}
foreach ($f_group as $i_groupid => $i_ischecked) {
if ($i_ischecked) {
//9917//9917
$g_db->Execute("INSERT INTO " . $srv_settings['table_prefix'] . "groups_tests (groupid, testid) VALUES (" . $i_groupid . ", " . $f_testid . ")");
}
}
if (isset($_POST['bsubmit2'])) {
gotoLocation('test-manager.php' . getURLAddon('?action=editt', array('action')));
} else {
gotoLocation('test-manager.php' . getURLAddon('', array('action', 'testid')));
}
}
if ($f_confirmed == 1) {
if (isset($_GET['visitorid']) || isset($_POST['box_visitors'])) {
include_once $DOCUMENT_PAGES . 'visitors-4.inc.php';
} else {
gotoLocation('visitors.php' . getURLAddon('', array('action', 'visitorid')));
}
} else {
if ($f_confirmed == '0') {
gotoLocation('visitors.php' . getURLAddon('', array('action', 'visitorid')));
} else {
$i_confirm_header = $lngstr['page_visitors_delete_visitor'];
$i_confirm_request = $lngstr['qst_delete_visitor'];
$i_confirm_url = 'visitors.php' . getURLAddon();
include_once $DOCUMENT_PAGES . 'confirm.inc.php';
}
}
} else {
gotoLocation('visitors.php' . getURLAddon('', array('action', 'visitorid')));
}
break;
default:
include_once $DOCUMENT_PAGES . 'visitors-1.inc.php';
}
} else {
$g_vars['page']['notifications'] = $lngstr['inf_cant_access_visitors'];
include_once $DOCUMENT_PAGES . 'home.inc.php';
}
} else {
$g_vars['page']['title'] = $lngstr['page_title_signin'];
include_once $DOCUMENT_PAGES . 'signin-1.inc.php';
}