*/ $cidReset = true; require_once '../inc/global.inc.php'; $this_section=SECTION_PLATFORM_ADMIN; api_protect_global_admin_script(); if (!api_get_multiple_access_url()) { header('Location: index.php'); exit; } $form_sent = 0; $first_letter_course = ''; $courses = array (); $url_list = array(); $users = array(); $tbl_access_url_rel_course = Database:: get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE); $tbl_access_url = Database:: get_main_table(TABLE_MAIN_ACCESS_URL); $tbl_user = Database:: get_main_table(TABLE_MAIN_USER); $tbl_course = Database:: get_main_table(TABLE_MAIN_COURSE); /* Header */ $tool_name = get_lang('AddCoursesToURL'); $interbreadcrumb[] = array ('url' => 'index.php', 'name' => get_lang('PlatformAdmin')); $interbreadcrumb[] = array ('url' => 'access_urls.php', 'name' => get_lang('MultipleAccessURLs')); Display :: display_header($tool_name); echo '
'; echo Display::url( Display::return_icon('edit.png', get_lang('EditCoursesToURL'), ''), api_get_path(WEB_CODE_PATH).'admin/access_url_edit_courses_to_url.php' ); echo '
'; api_display_tool_title($tool_name); if (isset($_POST['form_sent']) && $_POST['form_sent']) { $form_sent = $_POST['form_sent']; $courses = is_array($_POST['course_list']) ? $_POST['course_list'] : array() ; $url_list = is_array($_POST['url_list']) ? $_POST['url_list'] : array() ; $first_letter_course = $_POST['first_letter_course']; foreach ($users as $key => $value) { $users[$key] = intval($value); } if ($form_sent == 1) { if (count($courses) == 0 || count($url_list) == 0) { Display :: display_error_message(get_lang('AtLeastOneCourseAndOneURL')); } else { UrlManager::add_courses_to_urls($courses, $url_list); Display :: display_confirmation_message(get_lang('CourseBelongURL')); } } } if (empty($first_letter_user)) { $sql = "SELECT count(*) as num_courses FROM $tbl_course"; $result = Database::query($sql); $num_row = Database::fetch_array($result); if ($num_row['num_courses']>1000) { //if there are too much num_courses to gracefully handle with the HTML select list, // assign a default filter on users names $first_letter_user = 'A'; } unset($result); } $first_letter_course_lower = Database::escape_string(api_strtolower($first_letter_course)); $sql = "SELECT code, title FROM $tbl_course WHERE title LIKE '".$first_letter_course_lower."%' OR title LIKE '".$first_letter_course_lower."%' ORDER BY title, code DESC "; $result = Database::query($sql); $db_courses = Database::store_result($result); unset($result); $sql = "SELECT id, url FROM $tbl_access_url WHERE active=1 ORDER BY url"; $result = Database::query($sql); $db_urls = Database::store_result($result); unset($result); ?>


:
  :