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;
}
