registerFunction('search_courses'); // setting the section (for the tabs) $this_section = SECTION_PLATFORM_ADMIN; // setting breadcrumbs //$interbreadcrumb[] = array('url' => 'index.php', 'name' => get_lang('PlatformAdmin')); $interbreadcrumb[] = array('url' => 'session_list.php','name' => get_lang('SessionList')); // Database Table Definitions $tbl_session_rel_course_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER); $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION); $tbl_session_category = Database::get_main_table(TABLE_MAIN_SESSION_CATEGORY); $tbl_session_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_USER); $tbl_session_rel_course = Database::get_main_table(TABLE_MAIN_SESSION_COURSE); $tbl_course = Database::get_main_table(TABLE_MAIN_COURSE); // setting the name of the tool $tool_name = get_lang('SubscribeSessionsToCategory'); $id_session = isset($_GET['id_session']) ? intval($_GET['id_session']) : null; SessionManager::protectSession($id_session); $add_type = 'multiple'; if (isset($_GET['add_type']) && $_GET['add_type'] != '') { $add_type = Security::remove_XSS($_REQUEST['add_type']); } if (!api_is_platform_admin() && !api_is_session_admin()) { $sql = 'SELECT session_admin_id FROM ' . Database:: get_main_table(TABLE_MAIN_SESSION) . ' WHERE id=' . $id_session; $rs = Database::query($sql); if (Database::result($rs, 0, 0) != $_user['user_id']) { api_not_allowed(true); } } $xajax -> processRequests(); $htmlHeadXtra[] = $xajax->getJavascript('../inc/lib/xajax/'); $htmlHeadXtra[] = ' '; $formSent = 0; $errorMsg = $firstLetterCourse = $firstLetterSession = ''; $CourseList = $SessionList = array(); $courses = $sessions = array(); $categoryId = isset($_POST['CategorySessionId']) ? intval($_POST['CategorySessionId']) : null; if (isset($_POST['formSent']) && $_POST['formSent']) { $formSent = $_POST['formSent']; $sessionCategoryList = $_POST['SessionCategoryList']; if ($categoryId != 0 && count($sessionCategoryList) > 0) { // Removing all $sql = "UPDATE $tbl_session SET session_category_id = NULL WHERE session_category_id = $categoryId"; Database::query($sql); // Adding new $sessionCategoryList = array_map('intval', $sessionCategoryList); $session_id = join(',', $sessionCategoryList); $sql = "UPDATE $tbl_session SET session_category_id = $categoryId WHERE id in ($session_id) "; Database::query($sql); header('Location: add_many_session_to_category.php?id_category=' . $categoryId . '&msg=ok'); exit; } else { header('Location: add_many_session_to_category.php?msg=error'); exit; } } if (isset($_GET['id_category'])) { $categoryId = intval($_GET['id_category']); } if (isset($_GET['msg']) && $_GET['msg'] == 'error') { $errorMsg = get_lang('MsgErrorSessionCategory'); } if (isset($_GET['msg']) && $_GET['msg'] == 'ok') { $OkMsg = get_lang('SessionCategoryUpdate'); } $page = isset($_GET['page']) ? Security::remove_XSS($_GET['page']) : null; Display::display_header($tool_name); $where = ''; $rows_category_session = array(); if ((isset($_POST['CategorySessionId']) && $_POST['formSent'] == 0) || isset($_GET['id_category'])) { $where = 'WHERE session_category_id != ' . $categoryId .' OR session_category_id IS NULL'; $sql = 'SELECT id, name FROM ' . $tbl_session . ' WHERE session_category_id =' . $categoryId . ' ORDER BY name'; $result = Database::query($sql); $rows_category_session = Database::store_result($result); } $rows_session_category = SessionManager::get_all_session_category(); if (empty($rows_session_category)) { Display::display_warning_message(get_lang('YouNeedToAddASessionCategoryFirst')); Display::display_footer(); exit; } if (api_get_multiple_access_url()) { $table_access_url_rel_session= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION); $access_url_id = api_get_current_access_url_id(); $sql = "SELECT s.id, s.name FROM $tbl_session s INNER JOIN $table_access_url_rel_session u ON s.id = u.session_id $where AND u.access_url_id = $access_url_id ORDER BY name"; } else { $sql = "SELECT id, name FROM $tbl_session $where ORDER BY name"; } $result=Database::query($sql); $rows_session = Database::store_result($result); ?>

		:
:		:

	'.get_lang('SubscribeSessionsToCategory').''; ?>