include "lang/$language/common.inc.php"; $extra_messages = "config/{$language_codes[$language]}.inc.php"; if (file_exists($extra_messages)) { include $extra_messages; } else { $extra_messages = false; } include "lang/$language/messages.inc.php"; if ($extra_messages) { include $extra_messages; } } // check if we are guest user if (!$upgrade_begin and $uid and !isset($_GET['logout'])) { if (check_guest()) { // if the user is a guest send him straight to the corresponding lesson $guest = Database::get()->querySingle("SELECT code FROM course_user, course WHERE course.id = course_user.course_id AND user_id = ?d", $uid); if ($guest) { $dbname = $guest->code; $_SESSION['dbname'] = $dbname; header("Location: {$urlServer}courses/$dbname/index.php"); exit; } } // if user is not guest redirect him to portfolio header("Location: {$urlServer}main/portfolio.php"); } else { // check authentication methods
$is_opencourses_reviewer = TRUE; } if (isset($require_course_admin) and $require_course_admin) { if (!$is_course_admin) { $toolContent_ErrorExists = $langCheckCourseAdmin; } } if (isset($require_editor) and $require_editor) { if (!$is_editor) { $toolContent_ErrorExists = $langCheckProf; } } $module_id = current_module_id(); // Security check:: Users must not be able to access inactive (if students) or disabled tools. if (isset($course_id) and $module_id and !defined('STATIC_MODULE')) { if (!$uid or check_guest()) { $moduleIDs = Database::get()->queryArray("SELECT module_id FROM course_module\n WHERE visible = 1 AND\n course_id = ?d AND\n module_id NOT IN (SELECT module_id FROM module_disable) AND\n module_id NOT IN (" . MODULE_ID_CHAT . ",\n " . MODULE_ID_ASSIGN . ",\n " . MODULE_ID_BBB . ",\n " . MODULE_ID_DROPBOX . ",\n " . MODULE_ID_QUESTIONNAIRE . ",\n " . MODULE_ID_FORUM . ",\n " . MODULE_ID_GROUPS . ",\n " . MODULE_ID_GRADEBOOK . ",\n " . MODULE_ID_ATTENDANCE . ",\n " . MODULE_ID_LP . ")", $course_id); } elseif ($is_editor) { $moduleIDs = Database::get()->queryArray("SELECT module_id FROM course_module\n WHERE module_id NOT IN (SELECT module_id FROM module_disable) AND\n course_id = ?d", $course_id); } else { $moduleIDs = Database::get()->queryArray("SELECT module_id FROM course_module\n WHERE visible = 1 AND\n module_id NOT IN (SELECT module_id FROM module_disable) AND\n course_id = ?d", $course_id); } $publicModules = array(); foreach ($moduleIDs as $module) { $publicModules[] = $module->module_id; } if (!in_array($module_id, $publicModules)) { $toolContent_ErrorExists = $langCheckPublicTools; } } set_glossary_cache();
if (!$is_course_admin) { $toolContent_ErrorExists = $langCheckCourseAdmin; $errorMessagePath = "../../"; } } if (isset($require_editor) and $require_editor) { if (!$is_editor) { $toolContent_ErrorExists = $langCheckProf; $errorMessagePath = "../../"; } } $module_id = current_module_id(); // Security check:: Users that do not have Professor access for a course must not // be able to access inactive tools. if (isset($course_id) and !$is_editor and $module_id and !defined('STATIC_MODULE')) { if (isset($_SESSION['uid']) and $_SESSION['uid'] and !check_guest()) { $moduleIDs = Database::get()->queryArray("SELECT module_id FROM course_module\n WHERE visible = 1 AND\n course_id = ?d", $course_id); } else { $moduleIDs = Database::get()->queryArray("SELECT module_id FROM course_module\n WHERE visible = 1 AND\n course_id = ?d AND\n module_id NOT IN (" . MODULE_ID_CHAT . ",\n " . MODULE_ID_ASSIGN . ",\n " . MODULE_ID_BBB . ",\n " . MODULE_ID_DROPBOX . ",\n " . MODULE_ID_QUESTIONNAIRE . ",\n " . MODULE_ID_FORUM . ",\n " . MODULE_ID_GROUPS . ",\n " . MODULE_ID_WIKI . ",\n " . MODULE_ID_GRADEBOOK . ",\n " . MODULE_ID_GRADEBOOKTOTAL . ",\n " . MODULE_ID_ATTENDANCE . ",\n " . MODULE_ID_LP . ")", $course_id); } $publicModules = array(); foreach ($moduleIDs as $module) { $publicModules[] = $module->module_id; } if (!in_array($module_id, $publicModules)) { $toolContent_ErrorExists = $langCheckPublicTools; $errorMessagePath = "../../"; } } set_glossary_cache(); $tool_content = $head_content = '';
WHERE course_id = ?d AND status = " . USER_TEACHER . " AND user_id != ?d LIMIT 1", $course_id, $uid); if ($result) { if ($result->cnt == 0) { $unregister_ok = false; } } } if ($unregister_ok) { Database::get()->query("DELETE FROM course_user WHERE user_id = ?d AND course_id = ?d", $unregister_gid, $course_id); if (check_guest($unregister_gid)) { Database::get()->query("DELETE FROM user WHERE id = ?d", $unregister_gid); } Database::get()->query("DELETE FROM group_members WHERE user_id = ?d AND group_id IN (SELECT id FROM `group` WHERE course_id = ?d)", $unregister_gid, $course_id); } exit(); } $limit = intval($_GET['iDisplayLength']); $offset = intval($_GET['iDisplayStart']); if (!empty($_GET['sSearch'])) { $search_values = array_fill(0, 4, '%' . $_GET['sSearch'] . '%'); $search_sql = 'AND (user.surname LIKE ?s OR user.givenname LIKE ?s OR user.username LIKE ?s OR user.email LIKE ?s)';
* Panepistimiopolis Ilissia, 15784, Athens, Greece * e-mail: info@openeclass.org * ======================================================================== */ $require_help = true; $require_login = true; $helpTopic = 'Profile'; include '../../include/baseTheme.php'; require_once 'modules/auth/auth.inc.php'; require_once 'include/lib/fileUploadLib.inc.php'; require_once 'include/lib/pwgen.inc.php'; $require_valid_uid = TRUE; require_once 'include/lib/user.class.php'; require_once 'include/lib/hierarchy.class.php'; require_once 'include/log.php'; check_uid(); check_guest(); $toolName = $langMyProfile; $pageName = $langModifyProfile; $navigation[] = array('url' => 'display_profile.php', 'name' => $langMyProfile); $tree = new Hierarchy(); $userObj = new User(); $image_path = $webDir . '/courses/userimg/' . $_SESSION['uid']; load_js('jstree'); load_js('tools.js'); $head_content .= "<script type='text/javascript'>\nvar lang = { \n addPicture: '" . js_escape($langAddPicture) . "',\n confirmDelete: '" . js_escape($langConfirmDelete) . "'}; \n\$(profile_init);</script>"; $myrow = Database::get()->querySingle("SELECT surname, givenname, username, email, am, phone,\n lang, status, has_icon, description,\n email_public, phone_public, am_public, password\n FROM user WHERE id = ?d", $uid); $password = $myrow->password; $auth = array_search($password, $auth_ids); if (!$auth) { $auth = 1; }
function getToolsArray($cat) { global $currentCourse, $course_code; $currentCourse = $course_code; $cid = course_code_to_id($currentCourse); switch ($cat) { case 'Public': $sql = "SELECT * FROM course_module\n WHERE visible = 1 AND\n course_id = {$cid} AND\n module_id NOT IN (" . MODULE_ID_CHAT . ",\n " . MODULE_ID_ASSIGN . ",\n " . MODULE_ID_DROPBOX . ",\n " . MODULE_ID_QUESTIONNAIRE . ",\n " . MODULE_ID_FORUM . ",\n " . MODULE_ID_GROUPS . ",\n " . MODULE_ID_WIKI . ",\n " . MODULE_ID_ATTENDANCE . ",\n " . MODULE_ID_GRADEBOOK . ",\n " . MODULE_ID_GRADEBOOKTOTAL . ",\n " . MODULE_ID_LP . ")\n\n ORDER BY module_id"; if (!check_guest()) { if (isset($_SESSION['uid']) and $_SESSION['uid']) { $result = Database::get()->queryArray("SELECT * FROM course_module\n WHERE visible = 1 AND\n course_id = ?d\n ORDER BY module_id", $cid); } else { $result = Database::get()->queryArray($sql); } } else { $result = Database::get()->queryArray($sql); } break; case 'PublicButHide': $result = Database::get()->queryArray("SELECT * FROM course_module\n WHERE visible = 0 AND\n course_id = ?d\n ORDER BY module_id", $cid); break; } return $result; }
function getToolsArray($cat) { global $course_code; $cid = course_code_to_id($course_code); switch ($cat) { case 'Public': $sql = "SELECT * FROM course_module WHERE visible = 1 AND course_id = $cid AND module_id NOT IN (" . MODULE_ID_CHAT . ", " . MODULE_ID_ASSIGN . ", " . MODULE_ID_DROPBOX . ", " . MODULE_ID_QUESTIONNAIRE . ", " . MODULE_ID_FORUM . ", " . MODULE_ID_GROUPS . ", " . MODULE_ID_ATTENDANCE . ", " . MODULE_ID_GRADEBOOK . ", " . MODULE_ID_LP . ") AND module_id NOT IN (SELECT module_id FROM module_disable)"; if (!check_guest()) { if (isset($_SESSION['uid']) and $_SESSION['uid']) { $result = Database::get()->queryArray("SELECT * FROM course_module WHERE visible = 1 AND module_id NOT IN (SELECT module_id FROM module_disable) AND course_id = ?d", $cid); } else { $result = Database::get()->queryArray($sql); } } else { $result = Database::get()->queryArray($sql); } break; case 'PublicButHide': $result = Database::get()->queryArray("SELECT * FROM course_module WHERE visible = 0 AND module_id NOT IN (SELECT module_id FROM module_disable) AND course_id = ?d", $cid); break; } return $result; }