123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837 |
- <?php
-
- define('DOKEOS_HOMEPAGE', true);
- $language_file = array ('courses', 'index');
- $cidReset = true;
- require_once ('main/inc/global.inc.php');
- include_once (api_get_path(LIBRARY_PATH).'course.lib.php');
- include_once (api_get_path(LIBRARY_PATH).'debug.lib.inc.php');
- include_once (api_get_path(LIBRARY_PATH).'events.lib.inc.php');
- include_once (api_get_path(LIBRARY_PATH).'system_announcements.lib.php');
- include_once (api_get_path(LIBRARY_PATH).'groupmanager.lib.php');
- include_once (api_get_path(LIBRARY_PATH).'formvalidator/FormValidator.class.php');
- require_once 'main/chat/chat_functions.lib.php';
- $loginFailed = isset($_GET['loginFailed']) ? true : isset($loginFailed);
- $setting_show_also_closed_courses = (api_get_setting('show_closed_courses')=='true') ? true : false;
- $this_section = SECTION_CAMPUS;
- $my_user_id=api_get_user_id();
- if (!empty($_GET['logout'])) {
- logout();
- }
- $main_course_table = Database :: get_main_table(TABLE_MAIN_COURSE);
- $main_category_table = Database :: get_main_table(TABLE_MAIN_CATEGORY);
- $track_login_table = Database :: get_statistic_table(TABLE_STATISTIC_TRACK_E_LOGIN);
- $_setting['display_courses_to_anonymous_users'] = 'true';
- if (isset ($_user['user_id'])) {
- $nameTools = api_get_setting('siteName');
- }
- if (isset($_GET['submitAuth']) && $_GET['submitAuth'] == 1) {
-
- echo 'Attempted breakin - sysadmins notified.';
- session_destroy();
- die();
- }
- if (!empty($_POST["submitAuth"])) {
-
- if (isset ($_user['user_id'])) {
- $sql_last_login = "SELECT UNIX_TIMESTAMP(login_date)
- FROM $track_login_table
- WHERE login_user_id = '".$_user['user_id']."'
- ORDER BY login_date DESC LIMIT 1";
- $result_last_login = api_sql_query($sql_last_login, __FILE__, __LINE__);
- if (!$result_last_login)
- if (Database::num_rows($result_last_login) > 0) {
- $user_last_login_datetime = Database::fetch_array($result_last_login);
- $user_last_login_datetime = $user_last_login_datetime[0];
- api_session_register('user_last_login_datetime');
- }
- mysql_free_result($result_last_login);
-
- if (api_is_platform_admin()) {
-
- include (api_get_path(LIBRARY_PATH)."stats.lib.inc.php");
- decodeOpenInfos();
- }
- }
- }
- else {
-
- event_open();
- }
- Display :: display_header('', 'dokeos');
- echo '<div class="maincontent" id="content">';
- if (!api_get_user_id()) {
- api_plugin('loginpage_main');
- } else {
- api_plugin('campushomepage_main');
- }
- $home= 'home/';
- if ($_configuration['multiple_access_urls']==true) {
- $access_url_id = api_get_current_access_url_id();
- if ($access_url_id != -1){
- $url_info = api_get_access_url($access_url_id);
-
- $url = substr($url_info['url'],7,strlen($url_info['url'])-8);
- $clean_url = replace_dangerous_char($url);
- $clean_url = str_replace('/','-',$clean_url);
- $clean_url = $clean_url.'/';
- $home_old = 'home/';
- $home= 'home/'.$clean_url;
- }
- }
- $page_included = false;
- if (!empty ($_GET['include']) && preg_match('/^[a-zA-Z0-9_-]*\.html$/',$_GET['include'])) {
- include ('./'.$home.$_GET['include']);
- $page_included = true;
- } else {
-
- if (!empty($_SESSION['user_language_choice'])) {
- $user_selected_language=$_SESSION['user_language_choice'];
- } elseif(!empty($_SESSION['_user']['language'])) {
- $user_selected_language=$_SESSION['_user']['language'];
- } else {
- $user_selected_language=get_setting('platformLanguage');
- }
-
- if(!file_exists($home.'home_news_'.$user_selected_language.'.html')) {
- if (file_exists($home.'home_top.html'))
- $home_top_temp=file($home.'home_top.html');
- else {
- $home_top_temp=file($home_old.'home_top.html');
- }
- $home_top_temp=implode('',$home_top_temp);
- $open=str_replace('{rel_path}',api_get_path(REL_PATH),$home_top_temp);
- echo $open;
- } else {
- if(file_exists($home.'home_top_'.$user_selected_language.'.html')) {
- $home_top_temp = file_get_contents($home.'home_top_'.$user_selected_language.'.html');
- } else {
- $home_top_temp = file_get_contents($home.'home_top.html');
- }
- $open=str_replace('{rel_path}',api_get_path(REL_PATH),$home_top_temp);
- echo $open;
- }
- }
- $announcement = isset($_GET['announcement']) ? $_GET['announcement'] : -1;
- $announcement = intval($announcement);
- if (isset($_user['user_id'])) {
- $visibility = api_is_allowed_to_create_course() ? VISIBLE_TEACHER : VISIBLE_STUDENT;
- SystemAnnouncementManager :: display_announcements($visibility, $announcement);
- } else {
- SystemAnnouncementManager :: display_announcements(VISIBLE_GUEST, $announcement);
- }
- if (!$page_included) {
- if (api_get_setting('display_categories_on_homepage') == 'true') {
- echo '<div class="home_cats">';
- display_anonymous_course_list();
- echo '</div>';
- }
- }
- echo '</div>';
- echo '<div class="menu" id="menu">';
- display_anonymous_right_menu();
- echo '</div>';
- Display :: display_footer();
- function logout()
- {
- global $_configuration, $extAuthSource;
-
- $query_string='';
- if (!empty($_SESSION['user_language_choice'])) {
- $query_string='?language='.$_SESSION['user_language_choice'];
- }
-
- $tbl_track_login = Database :: get_statistic_table(TABLE_STATISTIC_TRACK_E_LOGIN);
-
- $uid = intval($_GET['uid']);
- $sql_last_connection="SELECT login_id, login_date FROM $tbl_track_login WHERE login_user_id='$uid' ORDER BY login_date DESC LIMIT 0,1";
- $q_last_connection=api_sql_query($sql_last_connection);
- if (Database::num_rows($q_last_connection)>0) {
- $i_id_last_connection=Database::result($q_last_connection,0,"login_id");
- }
-
- if (!isset($_SESSION['login_as'])) {
- $current_date=date('Y-m-d H:i:s',time());
- $s_sql_update_logout_date="UPDATE $tbl_track_login SET logout_date='".$current_date."' WHERE login_id='$i_id_last_connection'";
- api_sql_query($s_sql_update_logout_date);
- }
- LoginDelete($uid, $_configuration['statistics_database']);
-
-
-
-
-
-
- $uinfo = api_get_user_info($uid);
- if (($uinfo['auth_source'] != PLATFORM_AUTH_SOURCE) && is_array($extAuthSource)) {
- if (is_array($extAuthSource[$uinfo['auth_source']])) {
- $subarray = $extAuthSource[$uinfo['auth_source']];
- if (!empty($subarray['logout']) && file_exists($subarray['logout'])) {
- include_once($subarray['logout']);
- $logout_function = $uinfo['auth_source'].'_logout';
- if (function_exists($logout_function)) {
- $logout_function($uinfo);
- }
- }
- }
- }
- exit_of_chat($uid);
- api_session_destroy();
- header("Location: index.php$query_string");
- exit();
- }
- function category_has_open_courses($category) {
- global $setting_show_also_closed_courses;
-
- $user_identified = (api_get_user_id()>0 && !api_is_anonymous());
- $main_course_table = Database :: get_main_table(TABLE_MAIN_COURSE);
- $sql_query = "SELECT * FROM $main_course_table WHERE category_code='$category'";
- $sql_result = api_sql_query($sql_query, __FILE__, __LINE__);
- while ($course = Database::fetch_array($sql_result)) {
- if ($setting_show_also_closed_courses == false) {
- if ((api_get_user_id()>0
- and $course['visibility'] == COURSE_VISIBILITY_OPEN_PLATFORM)
- or ($course['visibility'] == COURSE_VISIBILITY_OPEN_WORLD)) {
- return true;
- }
- } else {
- if(isset($course['visibility'])){
- return true;
- }
- }
- }
- return false;
- }
- function display_create_course_link() {
- echo "<li><a href=\"main/create_course/add_course.php\">".get_lang("CourseCreate")."</a></li>";
- }
- function display_edit_course_list_links() {
- echo "<li><a href=\"main/auth/courses.php\">".get_lang("CourseManagement")."</a></li>";
- }
- function display_anonymous_right_menu() {
- global $loginFailed, $_plugins, $_user, $menu_navigation;
- $platformLanguage = api_get_setting('platformLanguage');
- if ( !($_user['user_id']) or api_is_anonymous($_user['user_id']) ) {
- api_display_language_form(true);
- echo '<br />';
- display_login_form();
- if ($loginFailed) {
- echo '<br />';
- handle_login_failed();
- }
- if (api_get_setting('allow_lostpassword') == 'true' OR api_get_setting('allow_registration') == 'true') {
- echo '<div class="menusection"><span class="menusectioncaption">'.get_lang('MenuUser').'</span><ul class="menulist">';
- if (get_setting('allow_registration') <> 'false') {
- echo '<li><a href="main/auth/inscription.php">'.get_lang('Reg').'</a></li>';
- }
- if (get_setting('allow_lostpassword') == 'true') {
- display_lost_password_info();
- }
- echo '</ul></div>';
- }
- if (api_number_of_plugins('loginpage_menu') > 0) {
- echo '<div class="note" style="background: none">';
- api_plugin('loginpage_menu');
- echo '</div>';
- }
- }
-
- echo "<div class=\"menusection\">", "<span class=\"menusectioncaption\">".get_lang("MenuGeneral")."</span>";
- echo "<ul class=\"menulist\">";
- $user_selected_language = api_get_interface_language();
- global $home, $home_old;
- if (!isset ($user_selected_language))
- $user_selected_language = $platformLanguage;
- if (!file_exists($home.'home_menu_'.$user_selected_language.'.html')) {
- if (file_exists($home.'home_menu.html'))
- include ($home.'home_menu.html');
- else {
- include ($home_old.'home_menu.html');
- }
- } else {
- include($home.'home_menu_'.$user_selected_language.'.html');
- }
- echo '</ul>';
- echo '</div>';
- if ($_user['user_id'] && api_number_of_plugins('campushomepage_menu') > 0) {
- echo '<div class="note" style="background: none">';
- api_plugin('campushomepage_menu');
- echo '</div>';
- }
-
- if (isset($_SESSION['_user']['user_id']) && $_SESSION['_user']['user_id']!=0) {
-
- if (!empty($menu_navigation)) {
- echo "<div class=\"menusection\">";
- echo "<span class=\"menusectioncaption\">".get_lang("MainNavigation")."</span>";
- echo "<ul class=\"menulist\">";
- foreach($menu_navigation as $section => $navigation_info) {
- $current = ($section == $GLOBALS['this_section'] ? ' id="current"' : '');
- echo '<li'.$current.'>';
- echo '<a href="'.$navigation_info['url'].'" target="_top">'.$navigation_info['title'].'</a>';
- echo '</li>';
- echo "\n";
- }
- echo "</ul>";
- echo '</div>';
- }
- $show_menu=false;
- $show_create_link=false;
- $show_course_link=false;
-
- $display_add_course_link = api_is_allowed_to_create_course() && ($_SESSION["studentview"] != "studentenview");
-
- if ($display_add_course_link) {
-
- $show_menu=true;
- $show_create_link=true;
- }
-
- if (api_is_platform_admin() || api_is_course_admin() || api_is_allowed_to_create_course()) {
- $show_menu=true;
- $show_course_link=true;
- } else {
- if (api_get_setting('allow_students_to_browse_courses')=='true') {
- $show_menu=true;
- $show_course_link=true;
- }
- }
-
- if ($show_menu){
- echo "<div class=\"menusection\">";
- echo "<span class=\"menusectioncaption\">".get_lang("MenuUser")."</span>";
- echo "<ul class=\"menulist\">";
- if ($show_create_link)
- display_create_course_link();
- if ($show_course_link)
- display_edit_course_list_links();
- echo "</ul>";
- echo "</div>";
- }
- }
-
-
-
- if (!file_exists($home.'home_notice_'.$user_selected_language.'.html') && file_exists($home.'home_notice.html') && file_get_contents($home.'home_notice.html')!='') {
- echo '<div class="note">';
- if (file_exists($home.'home_notice.html'))
- include ($home.'home_notice.html');
- else {
- include ($home_old.'home_notice.html');
- }
- echo '</div>';
- } elseif(file_exists($home.'home_notice_'.$user_selected_language.'.html') && file_exists($home.'home_notice_'.$user_selected_language.'.html') && file_get_contents($home.'home_notice_'.$user_selected_language.'.html')!='') {
- echo '<div class="note">';
- include($home.'home_notice_'.$user_selected_language.'.html');
- echo '</div>';
- }
- }
- function handle_login_failed() {
- if (!isset($_GET['error'])) {
- $message = get_lang("InvalidId");
- if (api_is_self_registration_allowed()) {
- $message = get_lang("InvalidForSelfRegistration");
- }
- } else {
- switch ($_GET['error']) {
- case '':
- $message = get_lang('InvalidId');
- if (api_is_self_registration_allowed()) {
- $message = get_lang('InvalidForSelfRegistration');
- }
- break;
- case 'account_expired':
- $message=get_lang('AccountExpired');
- break;
- case 'account_inactive':
- $message=get_lang('AccountInactive');
- break;
- case 'user_password_incorrect':
- $message=get_lang('InvalidId');
- break;
- case 'access_url_inactive':
- $message=get_lang('AccountURLInactive');
- break;
- }
- }
- echo "<div id=\"login_fail\">".$message."</div>";
- }
- function display_login_form()
- {
- $form = new FormValidator('formLogin');
- $form->addElement('text','login',get_lang('UserName'),array('size'=>15));
- $form->addElement('password','password',get_lang('Pass'),array('size'=>15));
- $form->addElement('style_submit_button','submitAuth',get_lang('langEnter'),'class="login"');
- $renderer =& $form->defaultRenderer();
- $renderer->setElementTemplate('<div><label>{label}</label></div><div>{element}</div>');
- $form->display();
- if (api_get_setting('openid_authentication')=='true') {
- include_once('main/auth/openid/login.php');
- echo '<div>'.openid_form().'</div>';
- }
- }
- function display_lost_password_info() {
- echo "<li><a href=\"main/auth/lostPassword.php\">".get_lang("LostPassword")."</a></li>";
- }
- function display_anonymous_course_list() {
- $ctok = $_SESSION['sec_token'];
- $stok = Security::get_token();
-
-
- $user_identified = (api_get_user_id()>0 && !api_is_anonymous());
- $web_course_path = api_get_path(WEB_COURSE_PATH);
- $category = $_GET["category"];
- global $setting_show_also_closed_courses;
-
- $main_course_table = Database :: get_main_table(TABLE_MAIN_COURSE);
- $main_category_table = Database :: get_main_table(TABLE_MAIN_CATEGORY);
- $platformLanguage = api_get_setting('platformLanguage');
-
- $sql_get_course_list = "SELECT * FROM $main_course_table cours
- WHERE category_code = '".Database::escape_string($_GET["category"])."'
- ORDER BY title, UPPER(visual_code)";
-
-
- global $_configuration;
- if ($_configuration['multiple_access_urls']==true) {
- $url_access_id = api_get_current_access_url_id();
- if ($url_access_id !=-1) {
- $tbl_url_rel_course = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE);
- $sql_get_course_list="SELECT * FROM $main_course_table as course INNER JOIN $tbl_url_rel_course as url_rel_course
- ON (url_rel_course.course_code=course.code)
- WHERE access_url_id = $url_access_id AND category_code = '".Database::escape_string($_GET["category"])."' ORDER BY title, UPPER(visual_code)";
- }
- }
-
-
- $sql_result_courses = api_sql_query($sql_get_course_list, __FILE__, __LINE__);
- while ($course_result = Database::fetch_array($sql_result_courses)) {
- $course_list[] = $course_result;
- }
- $platform_visible_courses = '';
-
- if($user_identified) {
- if ($setting_show_also_closed_courses) {
- $platform_visible_courses = '';
- } else {
- $platform_visible_courses = " AND (t3.visibility='".COURSE_VISIBILITY_OPEN_WORLD."' OR t3.visibility='".COURSE_VISIBILITY_OPEN_PLATFORM."' )";
- }
- } else {
- if ($setting_show_also_closed_courses) {
- $platform_visible_courses = '';
- } else {
- $platform_visible_courses = " AND (t3.visibility='".COURSE_VISIBILITY_OPEN_WORLD."' )";
- }
- }
- $sqlGetSubCatList = "
- SELECT t1.name,t1.code,t1.parent_id,t1.children_count,COUNT(DISTINCT t3.code) AS nbCourse
- FROM $main_category_table t1
- LEFT JOIN $main_category_table t2 ON t1.code=t2.parent_id
- LEFT JOIN $main_course_table t3 ON (t3.category_code=t1.code $platform_visible_courses)
- WHERE t1.parent_id ". (empty ($category) ? "IS NULL" : "='$category'")."
- GROUP BY t1.name,t1.code,t1.parent_id,t1.children_count ORDER BY t1.tree_pos, t1.name";
-
-
-
- global $_configuration;
- if ($_configuration['multiple_access_urls']==true) {
- $url_access_id = api_get_current_access_url_id();
- if ($url_access_id !=-1) {
- $tbl_url_rel_course = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE);
- $sqlGetSubCatList = "
- SELECT t1.name,t1.code,t1.parent_id,t1.children_count,COUNT(DISTINCT t3.code) AS nbCourse
- FROM $main_category_table t1
- LEFT JOIN $main_category_table t2 ON t1.code=t2.parent_id
- LEFT JOIN $main_course_table t3 ON (t3.category_code=t1.code $platform_visible_courses)
- INNER JOIN $tbl_url_rel_course as url_rel_course
- ON (url_rel_course.course_code=t3.code)
- WHERE access_url_id = $url_access_id AND t1.parent_id ". (empty ($category) ? "IS NULL" : "='$category'")."
- GROUP BY t1.name,t1.code,t1.parent_id,t1.children_count ORDER BY t1.tree_pos, t1.name";
- }
- }
-
- $resCats = api_sql_query($sqlGetSubCatList, __FILE__, __LINE__);
- $thereIsSubCat = false;
- if (Database::num_rows($resCats) > 0) {
- $htmlListCat = "<h4 style=\"margin-top: 0px;\">".get_lang("CatList")."</h4>"."<ul>";
- while ($catLine = Database::fetch_array($resCats)) {
- if ($catLine['code'] != $category) {
- $category_has_open_courses = category_has_open_courses($catLine['code']);
- if ($category_has_open_courses) {
-
- $htmlListCat .= "<li>";
- $htmlListCat .= "<a href=\"".api_get_self()."?category=".$catLine['code']."\">".$catLine['name']."</a>";
- if (api_get_setting('show_number_of_courses') == 'true') {
- $htmlListCat .= " (".$catLine['nbCourse']." ".get_lang("Courses").")";
- }
- $htmlListCat .= "</li>\n";
- $thereIsSubCat = true;
- } elseif ($catLine['children_count'] > 0) {
-
- $htmlListCat .= "<li>";
- $htmlListCat .= "<a href=\"".api_get_self()."?category=".$catLine['code']."\">".$catLine['name']."</a>";
- $htmlListCat .= "</li>\n";
- $thereIsSubCat = true;
- }
-
- elseif (api_get_setting('show_empty_course_categories') == 'true') {
- $htmlListCat .= "<li>";
- $htmlListCat .= $catLine['name'];
- $htmlListCat .= "</li>\n";
- $thereIsSubCat = true;
- }
- } else {
- $htmlTitre = "<p>";
- if (api_get_setting('show_back_link_on_top_of_tree') == 'true') {
- $htmlTitre .= "<a href=\"".api_get_self()."\">"."<< ".get_lang("BackToHomePage")."</a>";
- }
- if (!is_null($catLine['parent_id']) || (api_get_setting('show_back_link_on_top_of_tree') <> 'true' && !is_null($catLine['code']))) {
- $htmlTitre .= "<a href=\"".api_get_self()."?category=".$catLine['parent_id']."\">"."<< ".get_lang("Up")."</a>";
- }
- $htmlTitre .= "</p>\n";
- if ($category != "" && !is_null($catLine['code'])) {
- $htmlTitre .= "<h3>".$catLine['name']."</h3>\n";
- } else {
- $htmlTitre .= "<h3>".get_lang("Categories")."</h3>\n";
- }
- }
- }
- $htmlListCat .= "</ul>\n";
- }
- echo $htmlTitre;
- if ($thereIsSubCat) {
- echo $htmlListCat;
- }
- while ($categoryName = Database::fetch_array($resCats)) {
- echo "<h3>", $categoryName['name'], "</h3>\n";
- }
- $numrows = Database::num_rows($sql_result_courses);
- $courses_list_string = '';
- $courses_shown = 0;
- if ($numrows > 0) {
- if ($thereIsSubCat) {
- $courses_list_string .= "<hr size=\"1\" noshade=\"noshade\">\n";
- }
- $courses_list_string .= "<h4 style=\"margin-top: 0px;\">".get_lang("CourseList")."</h4>\n"."<ul>\n";
-
- if (api_get_user_id()) {
- $courses_of_user = get_courses_of_user(api_get_user_id());
- }
-
- foreach ($course_list AS $course) {
-
-
- if ($setting_show_also_closed_courses==false) {
-
-
-
- if( ($user_identified && $course['visibility'] == COURSE_VISIBILITY_OPEN_PLATFORM) OR ($course['visibility'] == COURSE_VISIBILITY_OPEN_WORLD)) {
- $courses_shown++;
- $courses_list_string .= "<li>\n";
- $courses_list_string .= "<a href=\"".$web_course_path.$course['directory']."/\">".$course['title']."</a><br />";
- if (get_setting("display_coursecode_in_courselist") == "true") {
- $courses_list_string .= $course['visual_code'];
- }
- if (get_setting("display_coursecode_in_courselist") == "true" AND get_setting("display_teacher_in_courselist") == "true") {
- $courses_list_string .= " - ";
- }
- if (get_setting("display_teacher_in_courselist") == "true") {
- $courses_list_string .= $course['tutor_name'];
- }
- if (api_get_setting('show_different_course_language') == 'true' && $course['course_language'] <> api_get_setting('platformLanguage')) {
- $courses_list_string .= ' - '.$course['course_language'];
- }
- $courses_list_string .= "</li>\n";
- }
- }
-
-
-
-
-
-
-
-
- else {
- $courses_shown++;
- $courses_list_string .= "<li>\n";
- if ( $course['visibility'] == COURSE_VISIBILITY_OPEN_WORLD
- OR ($user_identified AND $course['visibility'] == COURSE_VISIBILITY_OPEN_PLATFORM)
- OR ($user_identified AND key_exists($course['code'],$courses_of_user) AND $course['visibility'] <> COURSE_VISIBILITY_CLOSED)
- OR $courses_of_user[$course['code']]['status'] == '1'
- OR api_is_platform_admin()) {
- $courses_list_string .= "<a href=\"".$web_course_path.$course['directory']."/\">";
- }
- $courses_list_string .= $course['title'];
- if ( $course['visibility'] == COURSE_VISIBILITY_OPEN_WORLD
- OR ($user_identified AND $course['visibility'] == COURSE_VISIBILITY_OPEN_PLATFORM)
- OR ($user_identified AND key_exists($course['code'],$courses_of_user) AND $course['visibility'] <> COURSE_VISIBILITY_CLOSED)
- OR $courses_of_user[$course['code']]['status'] == '1'
- OR api_is_platform_admin()) {
- $courses_list_string .="</a><br />";
- }
- if (get_setting("display_coursecode_in_courselist") == "true") {
- $courses_list_string .= $course['visual_code'];
- }
- if (get_setting("display_coursecode_in_courselist") == "true" AND get_setting("display_teacher_in_courselist") == "true") {
- $courses_list_string .= " - ";
- }
- if (get_setting("display_teacher_in_courselist") == "true")
- {
- $courses_list_string .= $course['tutor_name'];
- }
- if (api_get_setting('show_different_course_language') == 'true' && $course['course_language'] <> api_get_setting('platformLanguage')) {
- $courses_list_string .= ' - '.$course['course_language'];
- }
- if (api_get_setting('show_different_course_language') == 'true' && $course['course_language'] <> api_get_setting('platformLanguage')) {
- $courses_list_string .= ' - '.$course['course_language'];
- }
-
-
-
- if ($user_identified AND !key_exists($course['code'],$courses_of_user)) {
- if ($course['subscribe'] == '1') {
- $courses_list_string .= "<form action=\"main/auth/courses.php?action=subscribe&category=".$_GET['category']."\" method=\"post\">";
- $courses_list_string .= '<input type="hidden" name="sec_token" value="'.$stok.'">';
- $courses_list_string .= "<input type=\"hidden\" name=\"subscribe\" value=\"".$course['code']."\" />";
- $courses_list_string .= "<input type=\"image\" name=\"unsub\" src=\"main/img/enroll.gif\" alt=\"".get_lang("Subscribe")."\" />".get_lang("Subscribe")."</form>";
- } else {
- $courses_list_string .= '<br />'.get_lang("SubscribingNotAllowed");
- }
- }
- $courses_list_string .= "</li>\n";
- }
- }
- $courses_list_string .= "</ul>\n";
- } else {
-
- }
- if ($courses_shown > 0) {
-
- echo $courses_list_string;
- }
- if ($category != "") {
- echo "<p>", "<a href=\"".api_get_self()."\"><b><<</b> ", get_lang("BackToHomePage"), "</a>", "</p>\n";
- }
- }
- function get_courses_of_user($user_id) {
- $table_course = Database::get_main_table(TABLE_MAIN_COURSE);
- $table_course_user = Database::get_main_table(TABLE_MAIN_COURSE_USER);
-
- $user_id = intval($user_id);
- $sql_select_courses="SELECT course.code k, course.visual_code vc, course.subscribe subscr, course.unsubscribe unsubscr,
- course.title i, course.tutor_name t, course.db_name db, course.directory dir, course_rel_user.status status,
- course_rel_user.sort sort, course_rel_user.user_course_cat user_course_cat
- FROM $table_course course,
- $table_course_user course_rel_user
- WHERE course.code = course_rel_user.course_code
- AND course_rel_user.user_id = '".$user_id."'
- ORDER BY course_rel_user.sort ASC";
- $result = api_sql_query($sql_select_courses,__FILE__,__LINE__);
- while ($row=Database::fetch_array($result)) {
-
- $courses[$row['k']] = array("db"=> $row['db'], "code" => $row['k'], "visual_code" => $row['vc'], "title" => $row['i'], "directory" => $row['dir'], "status" => $row['status'], "tutor" => $row['t'], "subscribe" => $row['subscr'], "unsubscribe" => $row['unsubscr'], "sort" => $row['sort'], "user_course_category" => $row['user_course_cat']);
- }
- return $courses;
- }
|