index.php 34 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * @package chamilo.main
  5. * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University, Refactoring
  6. * @version $Id: index.php 22368 2009-07-24 23:25:57Z iflorespaz $
  7. * @todo check the different @todos in this page and really do them
  8. * @todo check if the news management works as expected
  9. */
  10. // Only this script should have this constant defined. This is used to activate the javascript that
  11. // gives the login name automatic focus in header.inc.html.
  12. /** @todo Couldn't this be done using the $HtmlHeadXtra array? */
  13. define('DOKEOS_HOMEPAGE', true);
  14. $language_file = array('courses', 'index');
  15. /* Flag forcing the 'current course' reset, as we're not inside a course anymore */
  16. // Maybe we should change this into an api function? an example: Coursemanager::unset();
  17. $cidReset = true;
  18. /* Included libraries */
  19. /** @todo make all the library files consistent, use filename.lib.php and not filename.lib.inc.php */
  20. require_once 'main/inc/global.inc.php';
  21. require_once api_get_path(LIBRARY_PATH).'course.lib.php';
  22. require_once api_get_path(LIBRARY_PATH).'events.lib.inc.php';
  23. require_once api_get_path(LIBRARY_PATH).'system_announcements.lib.php';
  24. require_once api_get_path(LIBRARY_PATH).'groupmanager.lib.php';
  25. require_once api_get_path(LIBRARY_PATH).'formvalidator/FormValidator.class.php';
  26. require_once 'main/chat/chat_functions.lib.php';
  27. require_once api_get_path(LIBRARY_PATH).'custompages.lib.php';
  28. $loginFailed = isset($_GET['loginFailed']) ? true : isset($loginFailed);
  29. $setting_show_also_closed_courses = api_get_setting('show_closed_courses') == 'true';
  30. // the section (for the tabs)
  31. $this_section = SECTION_CAMPUS;
  32. /* Action Handling */
  33. /** @todo Wouldn't it make more sense if this would be done in local.inc.php so that local.inc.php become the only place where authentication is done?
  34. * by doing this you could logout from any page instead of only from index.php. From the moment there is a logout=true in the url you will be logged out
  35. * this can be usefull when you are on an open course and you need to log in to edit something and you immediately want to check how anonymous users
  36. * will see it.
  37. */
  38. $my_user_id = api_get_user_id();
  39. if (!empty($_GET['logout'])) {
  40. logout();
  41. }
  42. /* Table definitions */
  43. $main_course_table = Database :: get_main_table(TABLE_MAIN_COURSE);
  44. $main_category_table = Database :: get_main_table(TABLE_MAIN_CATEGORY);
  45. $track_login_table = Database :: get_statistic_table(TABLE_STATISTIC_TRACK_E_LOGIN);
  46. /* Constants and CONFIGURATION parameters */
  47. /** @todo these configuration settings should move to the dokeos config settings */
  48. /** defines wether or not anonymous visitors can see a list of the courses on the Dokeos homepage that are open to the world */
  49. $_setting['display_courses_to_anonymous_users'] = 'true';
  50. /** @todo remove this piece of code because this is not used */
  51. if (isset($_user['user_id'])) {
  52. $nameTools = api_get_setting('siteName');
  53. }
  54. /* LOGIN */
  55. /**
  56. * @todo This piece of code should probably move to local.inc.php where the actual login / logout procedure is handled.
  57. * @todo consider removing this piece of code because does nothing.
  58. */
  59. if (isset($_GET['submitAuth']) && $_GET['submitAuth'] == 1) {
  60. // nice lie!!!
  61. echo 'Attempted breakin - sysadmins notified.';
  62. session_destroy();
  63. die();
  64. }
  65. // Delete session neccesary for legal terms
  66. if (api_get_setting('allow_terms_conditions') == 'true') {
  67. unset($_SESSION['update_term_and_condition']);
  68. unset($_SESSION['info_current_user']);
  69. }
  70. /**
  71. * @todo This piece of code should probably move to local.inc.php where the actual login procedure is handled.
  72. * @todo check if this code is used. I think this code is never executed because after clicking the submit button
  73. * the code does the stuff in local.inc.php and then redirects to index.php or user_portal.php depending
  74. * on api_get_setting('page_after_login')
  75. */
  76. if (!empty($_POST['submitAuth'])) {
  77. // the user is already authenticated, we now find the last login of the user.
  78. if (isset ($_user['user_id'])) {
  79. $sql_last_login = "SELECT UNIX_TIMESTAMP(login_date)
  80. FROM $track_login_table
  81. WHERE login_user_id = '".$_user['user_id']."'
  82. ORDER BY login_date DESC LIMIT 1";
  83. $result_last_login = Database::query($sql_last_login);
  84. if (!$result_last_login) {
  85. if (Database::num_rows($result_last_login) > 0) {
  86. $user_last_login_datetime = Database::fetch_array($result_last_login);
  87. $user_last_login_datetime = $user_last_login_datetime[0];
  88. api_session_register('user_last_login_datetime');
  89. }
  90. }
  91. Database::free_result($result_last_login);
  92. //event_login();
  93. if (api_is_platform_admin()) {
  94. // decode all open event informations and fill the track_c_* tables
  95. include api_get_path(LIBRARY_PATH).'stats.lib.inc.php';
  96. decodeOpenInfos();
  97. }
  98. }
  99. } // end login -- if ($_POST['submitAuth'])
  100. else {
  101. // only if login form was not sent because if the form is sent the user was already on the page.
  102. event_open();
  103. }
  104. //checks user status and redirect him through custom page if setting is enabled
  105. $user_status = (isset($_SESSION['_user']['user_id'])) ? $_user['status'] : null;
  106. if ( $user_status == STUDENT && !api_get_setting('student_page_after_login') == '' ){
  107. $redirect_url = html_entity_decode(api_get_setting('student_page_after_login'));
  108. if ($redirect_url[0] == "/") {
  109. $redirect_url = substr(api_get_path(WEB_PATH), 0, -1).$redirect_url;
  110. }
  111. header('Location: '.$redirect_url);
  112. exit();
  113. }
  114. if ( $user_status == COURSEMANAGER && !api_get_setting('teacher_page_after_login') == '' ){
  115. $redirect_url = html_entity_decode(api_get_setting('teacher_page_after_login'));
  116. if ($redirect_url[0] == "/") {
  117. $redirect_url = substr(api_get_path(WEB_PATH), 0, -1).$redirect_url;
  118. }
  119. header('Location: '.$redirect_url);
  120. exit();
  121. }
  122. if ( $user_status == DRH && !api_get_setting('DRH_page_after_login') == '' ){
  123. $redirect_url = html_entity_decode(api_get_setting('DRH_page_after_login'));
  124. if ($redirect_url[0] == "/") {
  125. $redirect_url = substr(api_get_path(WEB_PATH), 0, -1).$redirect_url;
  126. }
  127. header('Location: '.$redirect_url);
  128. exit();
  129. }
  130. if ( $user_status == SESSIONADMIN && !api_get_setting('sessionadmin_page_after_login') == '' ){
  131. $redirect_url = html_entity_decode(api_get_setting('sessionadmin_page_after_login'));
  132. if ($redirect_url[0] == "/") {
  133. $redirect_url = substr(api_get_path(WEB_PATH), 0, -1).$redirect_url;
  134. }
  135. header('Location: '.$redirect_url);
  136. exit();
  137. }
  138. // Custom pages
  139. if (api_get_setting('use_custom_pages') == 'true') {
  140. if (api_get_user_id()) {
  141. CustomPages::displayPage('index-logged');
  142. }
  143. else {
  144. CustomPages::displayPage('index-unlogged');
  145. }
  146. }
  147. // the header
  148. Display::display_header(get_lang('Homepage'));
  149. /*
  150. MAIN CODE
  151. */
  152. echo '<div class="maincontent" id="content">';
  153. // Plugins for loginpage_main AND campushomepage_main
  154. if (!api_get_user_id()) {
  155. api_plugin('loginpage_main');
  156. } else {
  157. api_plugin('campushomepage_main');
  158. }
  159. $home = 'home/';
  160. if ($_configuration['multiple_access_urls']) {
  161. $access_url_id = api_get_current_access_url_id();
  162. if ($access_url_id != -1){
  163. $url_info = api_get_access_url($access_url_id);
  164. $url = api_remove_trailing_slash(preg_replace('/https?:\/\//i', '', $url_info['url']));
  165. $clean_url = replace_dangerous_char($url);
  166. $clean_url = str_replace('/', '-', $clean_url);
  167. $clean_url .= '/';
  168. $home_old = 'home/';
  169. $home = 'home/'.$clean_url;
  170. }
  171. }
  172. // Including the page for the news
  173. $page_included = false;
  174. if (!empty($_GET['include']) && preg_match('/^[a-zA-Z0-9_-]*\.html$/', $_GET['include'])) {
  175. $open = @(string)file_get_contents(api_get_path(SYS_PATH).$home.$_GET['include']);
  176. $open = api_to_system_encoding($open, api_detect_encoding(strip_tags($open)));
  177. echo $open;
  178. $page_included = true;
  179. } else {
  180. if (!empty($_SESSION['user_language_choice'])) {
  181. $user_selected_language = $_SESSION['user_language_choice'];
  182. } elseif (!empty($_SESSION['_user']['language'])) {
  183. $user_selected_language = $_SESSION['_user']['language'];
  184. } else {
  185. $user_selected_language = api_get_setting('platformLanguage');
  186. }
  187. if (!file_exists($home.'home_news_'.$user_selected_language.'.html')) {
  188. if (file_exists($home.'home_top.html')) {
  189. $home_top_temp = file($home.'home_top.html');
  190. } else {
  191. $home_top_temp = file($home_old.'home_top.html');
  192. }
  193. $home_top_temp = implode('', $home_top_temp);
  194. } else {
  195. if (file_exists($home.'home_top_'.$user_selected_language.'.html')) {
  196. $home_top_temp = file_get_contents($home.'home_top_'.$user_selected_language.'.html');
  197. } else {
  198. $home_top_temp = file_get_contents($home.'home_top.html');
  199. }
  200. }
  201. if(trim($home_top_temp)=='') {
  202. $home_top_temp = get_lang('PortalHomepageDefaultIntroduction');
  203. }
  204. $open = str_replace('{rel_path}', api_get_path(REL_PATH), $home_top_temp);
  205. $open = api_to_system_encoding($open, api_detect_encoding(strip_tags($open)));
  206. echo $open;
  207. }
  208. // Display System announcements
  209. $announcement = isset($_GET['announcement']) ? $_GET['announcement'] : -1;
  210. $announcement = intval($announcement);
  211. if (isset($_user['user_id'])) {
  212. $visibility = api_is_allowed_to_create_course() ? VISIBLE_TEACHER : VISIBLE_STUDENT;
  213. SystemAnnouncementManager :: display_announcements($visibility, $announcement);
  214. } else {
  215. SystemAnnouncementManager :: display_announcements(VISIBLE_GUEST, $announcement);
  216. }
  217. // Display courses and category list
  218. if (!$page_included) {
  219. if (api_get_setting('display_categories_on_homepage') == 'true') {
  220. echo '<div class="home_cats">';
  221. display_anonymous_course_list();
  222. echo '</div>';
  223. }
  224. }
  225. echo '</div>';
  226. // Display right menu: language form, login section + useful weblinks
  227. echo '<div class="menu" id="menu">';
  228. display_anonymous_right_menu();
  229. echo '</div>';
  230. /*
  231. Footer
  232. */
  233. Display :: display_footer();
  234. /*
  235. Functions
  236. */
  237. /**
  238. * This function handles the logout and is called whenever there is a $_GET['logout']
  239. *
  240. * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
  241. */
  242. function logout() {
  243. global $_configuration, $extAuthSource;
  244. // variable initialisation
  245. $query_string = '';
  246. if (!empty($_SESSION['user_language_choice'])) {
  247. $query_string = '?language='.$_SESSION['user_language_choice'];
  248. }
  249. // Database table definition
  250. $tbl_track_login = Database :: get_statistic_table(TABLE_STATISTIC_TRACK_E_LOGIN);
  251. // selecting the last login of the user
  252. $uid = intval($_GET['uid']);
  253. $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";
  254. $q_last_connection = Database::query($sql_last_connection);
  255. if (Database::num_rows($q_last_connection) > 0) {
  256. $i_id_last_connection = Database::result($q_last_connection, 0, 'login_id');
  257. }
  258. if (!isset($_SESSION['login_as'])) {
  259. $current_date = date('Y-m-d H:i:s', time());
  260. $s_sql_update_logout_date = "UPDATE $tbl_track_login SET logout_date='".$current_date."' WHERE login_id='$i_id_last_connection'";
  261. Database::query($s_sql_update_logout_date);
  262. }
  263. LoginDelete($uid, $_configuration['statistics_database']); //from inc/lib/online.inc.php - removes the "online" status
  264. //the following code enables the use of an external logout function.
  265. //example: define a $extAuthSource['ldap']['logout']="file.php" in configuration.php
  266. // then a function called ldap_logout() inside that file
  267. // (using *authent_name*_logout as the function name) and the following code
  268. // will find and execute it
  269. $uinfo = api_get_user_info($uid);
  270. if (($uinfo['auth_source'] != PLATFORM_AUTH_SOURCE) && is_array($extAuthSource)) {
  271. if (is_array($extAuthSource[$uinfo['auth_source']])) {
  272. $subarray = $extAuthSource[$uinfo['auth_source']];
  273. if (!empty($subarray['logout']) && file_exists($subarray['logout'])) {
  274. include_once ($subarray['logout']);
  275. $logout_function = $uinfo['auth_source'].'_logout';
  276. if (function_exists($logout_function)) {
  277. $logout_function($uinfo);
  278. }
  279. }
  280. }
  281. }
  282. exit_of_chat($uid);
  283. api_session_destroy();
  284. header("Location: index.php$query_string");
  285. exit();
  286. }
  287. /**
  288. * This function checks if there are courses that are open to the world in the platform course categories (=faculties)
  289. *
  290. * @param unknown_type $category
  291. * @return boolean
  292. */
  293. function category_has_open_courses($category) {
  294. global $setting_show_also_closed_courses;
  295. $user_identified = (api_get_user_id() > 0 && !api_is_anonymous());
  296. $main_course_table = Database :: get_main_table(TABLE_MAIN_COURSE);
  297. $sql_query = "SELECT * FROM $main_course_table WHERE category_code='$category'";
  298. $sql_result = Database::query($sql_query);
  299. while ($course = Database::fetch_array($sql_result)) {
  300. if (!$setting_show_also_closed_courses) {
  301. if ((api_get_user_id() > 0
  302. && $course['visibility'] == COURSE_VISIBILITY_OPEN_PLATFORM)
  303. || ($course['visibility'] == COURSE_VISIBILITY_OPEN_WORLD)) {
  304. return true; //at least one open course
  305. }
  306. } else {
  307. if (isset($course['visibility'])) {
  308. return true; //at least one course (does not matter weither it's open or not because $setting_show_also_closed_courses = true
  309. }
  310. }
  311. }
  312. return false;
  313. }
  314. /**
  315. * Display create course link
  316. */
  317. function display_create_course_link() {
  318. echo '<li><a href="main/create_course/add_course.php">'.get_lang('CourseCreate').'</a></li>';
  319. }
  320. /**
  321. * Display edit course list links
  322. */
  323. function display_edit_course_list_links() {
  324. echo '<li><a href="main/auth/courses.php">'.get_lang('CourseManagement').'</a></li>';
  325. }
  326. /**
  327. * Display dashboard link
  328. */
  329. function display_dashboard_link() {
  330. echo '<li><a href="main/dashboard/index.php">'.get_lang('Dashboard').'</a></li>';
  331. }
  332. /**
  333. * Displays the right-hand menu for anonymous users:
  334. * login form, useful links, help section
  335. * Warning: function defines globals
  336. * @version 1.0.1
  337. * @todo does $_plugins need to be global?
  338. */
  339. function display_anonymous_right_menu() {
  340. global $loginFailed, $_plugins, $_user, $menu_navigation;
  341. $platformLanguage = api_get_setting('platformLanguage');
  342. $sys_path = api_get_path(SYS_PATH);
  343. if (!($_user['user_id']) || api_is_anonymous($_user['user_id']) ) { // Only display if the user isn't logged in
  344. api_display_language_form(true);
  345. echo '<br />';
  346. display_login_form();
  347. if ($loginFailed) {
  348. echo '<br />';
  349. handle_login_failed();
  350. }
  351. if (api_get_setting('allow_lostpassword') == 'true' || api_get_setting('allow_registration') == 'true') {
  352. echo '<div class="menusection"><span class="menusectioncaption">'.get_lang('MenuUser').'</span><ul class="menulist">';
  353. if (api_get_setting('allow_registration') != 'false') {
  354. echo '<li><a href="main/auth/inscription.php">'.get_lang('Reg').'</a></li>';
  355. }
  356. if (api_get_setting('allow_lostpassword') == 'true') {
  357. display_lost_password_info();
  358. }
  359. echo '</ul></div>';
  360. }
  361. if (api_number_of_plugins('loginpage_menu') > 0) {
  362. echo '<div class="note" style="background: none">';
  363. api_plugin('loginpage_menu');
  364. echo '</div>';
  365. }
  366. }
  367. // My Account section
  368. if (isset($_SESSION['_user']['user_id']) && $_SESSION['_user']['user_id'] != 0) {
  369. // tabs that are deactivated are added here
  370. $show_menu = false;
  371. $show_create_link = false;
  372. $show_course_link = false;
  373. $display_add_course_link = api_is_allowed_to_create_course() && ($_SESSION['studentview'] != 'studentenview');
  374. if ($display_add_course_link) {
  375. //display_create_course_link();
  376. $show_menu = true;
  377. $show_create_link = true;
  378. }
  379. if (api_is_platform_admin() || api_is_course_admin() || api_is_allowed_to_create_course()) {
  380. $show_menu = true;
  381. $show_course_link = true;
  382. } else {
  383. if (api_get_setting('allow_students_to_browse_courses') == 'true') {
  384. $show_menu = true;
  385. $show_course_link = true;
  386. }
  387. }
  388. if ($show_menu) {
  389. echo '<div class="menusection">';
  390. echo '<span class="menusectioncaption">'.get_lang('MenuUser').'</span>';
  391. echo '<ul class="menulist">';
  392. if ($show_create_link) {
  393. display_create_course_link();
  394. }
  395. if ($show_course_link) {
  396. if (!api_is_drh() && !api_is_session_admin()) {
  397. display_edit_course_list_links();
  398. } else {
  399. display_dashboard_link();
  400. }
  401. }
  402. echo '</ul></div>';
  403. }
  404. // Deleting the myprofile link
  405. if (api_get_setting('allow_social_tool') == 'true') {
  406. unset($menu_navigation['myprofile']);
  407. }
  408. if (!empty($menu_navigation)) {
  409. echo '<div class="menusection">';
  410. echo '<span class="menusectioncaption">'.get_lang('MainNavigation').'</span>';
  411. echo '<ul class="menulist">';
  412. foreach ($menu_navigation as $section => $navigation_info) {
  413. $current = $section == $GLOBALS['this_section'] ? ' id="current"' : '';
  414. echo '<li'.$current.'><a href="'.$navigation_info['url'].'" target="_self">'.$navigation_info['title'].'</a></li>', "\n";
  415. }
  416. echo '</ul></div>';
  417. }
  418. }
  419. // Help section
  420. /*** Hide right menu "general" and other parts on anonymous right menu *****/
  421. $user_selected_language = api_get_interface_language();
  422. global $home, $home_old;
  423. if (!isset($user_selected_language)) {
  424. $user_selected_language = $platformLanguage;
  425. }
  426. $home_menu = @(string)file_get_contents($sys_path.$home.'home_menu_'.$user_selected_language.'.html');
  427. if (empty($home_menu)) {
  428. $home_menu = @(string)file_get_contents($sys_path.$home_old.'home_menu_'.$user_selected_language.'.html');
  429. }
  430. if (empty($home_menu)) {
  431. $home_menu = @(string)file_get_contents($sys_path.$home.'home_menu.html');
  432. }
  433. if (empty($home_menu)) {
  434. $home_menu = @(string)file_get_contents($sys_path.$home_old.'home_menu.html');
  435. }
  436. if (!empty($home_menu)) {
  437. echo '<div class="menusection">', '<span class="menusectioncaption">'.get_lang('MenuGeneral').'</span>';
  438. echo '<ul class="menulist">';
  439. $home_menu = api_to_system_encoding($home_menu, api_detect_encoding(strip_tags($home_menu)));
  440. echo $home_menu;
  441. echo '</ul></div>';
  442. }
  443. if ($_user['user_id'] && api_number_of_plugins('campushomepage_menu') > 0) {
  444. echo '<div class="note" style="background: none">';
  445. api_plugin('campushomepage_menu');
  446. echo '</div>';
  447. }
  448. // includes for any files to be displayed below anonymous right menu
  449. $home_notice = @(string)file_get_contents($sys_path.$home.'home_notice_'.$user_selected_language.'.html');
  450. if (empty($home_notice)) {
  451. $home_notice = @(string)file_get_contents($sys_path.$home.'home_notice.html');
  452. }
  453. if (!empty($home_notice)) {
  454. echo '<div class="note">';
  455. $home_notice = api_to_system_encoding($home_notice, api_detect_encoding(strip_tags($home_notice)));
  456. echo $home_notice;
  457. echo '</div>';
  458. }
  459. }
  460. /**
  461. * Reacts on a failed login:
  462. * Displays an explanation with a link to the registration form.
  463. *
  464. * @version 1.0.1
  465. */
  466. function handle_login_failed() {
  467. if (!isset($_GET['error'])) {
  468. $message = get_lang('InvalidId');
  469. if (api_is_self_registration_allowed()) {
  470. $message = get_lang('InvalidForSelfRegistration');
  471. }
  472. } else {
  473. switch ($_GET['error']) {
  474. case '':
  475. $message = get_lang('InvalidId');
  476. if (api_is_self_registration_allowed()) {
  477. $message = get_lang('InvalidForSelfRegistration');
  478. }
  479. break;
  480. case 'account_expired':
  481. $message = get_lang('AccountExpired');
  482. break;
  483. case 'account_inactive':
  484. $message = get_lang('AccountInactive');
  485. break;
  486. case 'user_password_incorrect':
  487. $message = get_lang('InvalidId');
  488. break;
  489. case 'access_url_inactive':
  490. $message = get_lang('AccountURLInactive');
  491. break;
  492. }
  493. }
  494. echo '<div id="login_fail">'.$message.'</div>';
  495. }
  496. /**
  497. * Adds a form to let users login
  498. * @version 1.1
  499. */
  500. function display_login_form() {
  501. $form = new FormValidator('formLogin');
  502. $form->addElement('text', 'login', get_lang('UserName'), array('size' => 17));
  503. $form->addElement('password', 'password', get_lang('Pass'), array('size' => 17));
  504. $form->addElement('style_submit_button','submitAuth', get_lang('LoginEnter'), array('class' => 'login'));
  505. $renderer =& $form->defaultRenderer();
  506. $renderer->setElementTemplate('<div><label>{label}</label></div><div>{element}</div>');
  507. $form->display();
  508. if (api_get_setting('openid_authentication') == 'true') {
  509. include_once 'main/auth/openid/login.php';
  510. echo '<div>'.openid_form().'</div>';
  511. }
  512. }
  513. /**
  514. * Displays a link to the lost password section
  515. */
  516. function display_lost_password_info() {
  517. echo '<li><a href="main/auth/lostPassword.php">'.get_lang('LostPassword').'</a></li>';
  518. }
  519. /**
  520. * Display list of courses in a category.
  521. * (for anonymous users)
  522. *
  523. * @version 1.1
  524. * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University - refactoring and code cleaning
  525. */
  526. function display_anonymous_course_list() {
  527. $ctok = $_SESSION['sec_token'];
  528. $stok = Security::get_token();
  529. //init
  530. $user_identified = (api_get_user_id() > 0 && !api_is_anonymous());
  531. $web_course_path = api_get_path(WEB_COURSE_PATH);
  532. $category = Database::escape_string($_GET['category']);
  533. global $setting_show_also_closed_courses;
  534. // Database table definitions
  535. $main_course_table = Database :: get_main_table(TABLE_MAIN_COURSE);
  536. $main_category_table = Database :: get_main_table(TABLE_MAIN_CATEGORY);
  537. $platformLanguage = api_get_setting('platformLanguage');
  538. //get list of courses in category $category
  539. $sql_get_course_list = "SELECT * FROM $main_course_table cours
  540. WHERE category_code = '".Database::escape_string($_GET['category'])."'
  541. ORDER BY title, UPPER(visual_code)";
  542. //showing only the courses of the current access_url_id
  543. global $_configuration;
  544. if ($_configuration['multiple_access_urls']) {
  545. $url_access_id = api_get_current_access_url_id();
  546. if ($url_access_id != -1) {
  547. $tbl_url_rel_course = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE);
  548. $sql_get_course_list = "SELECT * FROM $main_course_table as course INNER JOIN $tbl_url_rel_course as url_rel_course
  549. ON (url_rel_course.course_code=course.code)
  550. WHERE access_url_id = $url_access_id AND category_code = '".Database::escape_string($_GET['category'])."' ORDER BY title, UPPER(visual_code)";
  551. }
  552. }
  553. // Removed: AND cours.visibility='".COURSE_VISIBILITY_OPEN_WORLD."'
  554. $sql_result_courses = Database::query($sql_get_course_list);
  555. while ($course_result = Database::fetch_array($sql_result_courses)) {
  556. $course_list[] = $course_result;
  557. }
  558. $platform_visible_courses = '';
  559. // $setting_show_also_closed_courses
  560. if($user_identified) {
  561. if ($setting_show_also_closed_courses) {
  562. $platform_visible_courses = '';
  563. } else {
  564. $platform_visible_courses = " AND (t3.visibility='".COURSE_VISIBILITY_OPEN_WORLD."' OR t3.visibility='".COURSE_VISIBILITY_OPEN_PLATFORM."' )";
  565. }
  566. } else {
  567. if ($setting_show_also_closed_courses) {
  568. $platform_visible_courses = '';
  569. } else {
  570. $platform_visible_courses = " AND (t3.visibility='".COURSE_VISIBILITY_OPEN_WORLD."' )";
  571. }
  572. }
  573. $sqlGetSubCatList = "
  574. SELECT t1.name,t1.code,t1.parent_id,t1.children_count,COUNT(DISTINCT t3.code) AS nbCourse
  575. FROM $main_category_table t1
  576. LEFT JOIN $main_category_table t2 ON t1.code=t2.parent_id
  577. LEFT JOIN $main_course_table t3 ON (t3.category_code=t1.code $platform_visible_courses)
  578. WHERE t1.parent_id ". (empty ($category) ? "IS NULL" : "='$category'")."
  579. GROUP BY t1.name,t1.code,t1.parent_id,t1.children_count ORDER BY t1.tree_pos, t1.name";
  580. // Showing only the category of courses of the current access_url_id
  581. global $_configuration;
  582. if ($_configuration['multiple_access_urls']) {
  583. $url_access_id = api_get_current_access_url_id();
  584. if ($url_access_id != -1) {
  585. $tbl_url_rel_course = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE);
  586. $sqlGetSubCatList = "
  587. SELECT t1.name,t1.code,t1.parent_id,t1.children_count,COUNT(DISTINCT t3.code) AS nbCourse
  588. FROM $main_category_table t1
  589. LEFT JOIN $main_category_table t2 ON t1.code=t2.parent_id
  590. LEFT JOIN $main_course_table t3 ON (t3.category_code=t1.code $platform_visible_courses)
  591. INNER JOIN $tbl_url_rel_course as url_rel_course
  592. ON (url_rel_course.course_code=t3.code)
  593. WHERE access_url_id = $url_access_id AND t1.parent_id ".(empty($category) ? "IS NULL" : "='$category'")."
  594. GROUP BY t1.name,t1.code,t1.parent_id,t1.children_count ORDER BY t1.tree_pos, t1.name";
  595. }
  596. }
  597. $resCats = Database::query($sqlGetSubCatList);
  598. $thereIsSubCat = false;
  599. if (Database::num_rows($resCats) > 0) {
  600. $htmlListCat = '<h4 style="margin-top: 0px;">'.get_lang('CatList').'</h4><ul>';
  601. while ($catLine = Database::fetch_array($resCats)) {
  602. if ($catLine['code'] != $category) {
  603. $category_has_open_courses = category_has_open_courses($catLine['code']);
  604. if ($category_has_open_courses) {
  605. // The category contains courses accessible to anonymous visitors
  606. $htmlListCat .= '<li>';
  607. $htmlListCat .= '<a href="'.api_get_self().'?category='.$catLine['code'].'">'.$catLine['name'].'</a>';
  608. if (api_get_setting('show_number_of_courses') == 'true') {
  609. $htmlListCat .= ' ('.$catLine['nbCourse'].' '.get_lang('Courses').')';
  610. }
  611. $htmlListCat .= "</li>\n";
  612. $thereIsSubCat = true;
  613. } elseif ($catLine['children_count'] > 0) {
  614. // The category has children, subcategories
  615. $htmlListCat .= '<li>';
  616. $htmlListCat .= '<a href="'.api_get_self().'?category='.$catLine['code'].'">'.$catLine['name'].'</a>';
  617. $htmlListCat .= "</li>\n";
  618. $thereIsSubCat = true;
  619. }
  620. /************************************************************************
  621. end changed code to eliminate the (0 courses) after empty categories
  622. ************************************************************************/
  623. elseif (api_get_setting('show_empty_course_categories') == 'true') {
  624. $htmlListCat .= '<li>';
  625. $htmlListCat .= $catLine['name'];
  626. $htmlListCat .= "</li>\n";
  627. $thereIsSubCat = true;
  628. } //else don't set thereIsSubCat to true to avoid printing things if not requested
  629. } else {
  630. $htmlTitre = '<p>';
  631. if (api_get_setting('show_back_link_on_top_of_tree') == 'true') {
  632. $htmlTitre .= '<a href="'.api_get_self().'">&lt;&lt; '.get_lang('BackToHomePage').'</a>';
  633. }
  634. if (!is_null($catLine['parent_id']) || (api_get_setting('show_back_link_on_top_of_tree') != 'true' && !is_null($catLine['code']))) {
  635. $htmlTitre .= '<a href="'.api_get_self().'?category='.$catLine['parent_id'].'">&lt;&lt; '.get_lang('Up').'</a>';
  636. }
  637. $htmlTitre .= "</p>\n";
  638. if ($category != "" && !is_null($catLine['code'])) {
  639. $htmlTitre .= '<h3>'.$catLine['name']."</h3>\n";
  640. } else {
  641. $htmlTitre .= '<h3>'.get_lang('Categories')."</h3>\n";
  642. }
  643. }
  644. }
  645. $htmlListCat .= "</ul>\n";
  646. }
  647. echo $htmlTitre;
  648. if ($thereIsSubCat) {
  649. echo $htmlListCat;
  650. }
  651. while ($categoryName = Database::fetch_array($resCats)) {
  652. echo '<h3>', $categoryName['name'], "</h3>\n";
  653. }
  654. $numrows = Database::num_rows($sql_result_courses);
  655. $courses_list_string = '';
  656. $courses_shown = 0;
  657. if ($numrows > 0) {
  658. if ($thereIsSubCat) {
  659. $courses_list_string .= "<hr size=\"1\" noshade=\"noshade\">\n";
  660. }
  661. $courses_list_string .= '<h4 style="margin-top: 0px;">'.get_lang('CourseList')."</h4>\n<ul>\n";
  662. if (api_get_user_id()) {
  663. $courses_of_user = get_courses_of_user(api_get_user_id());
  664. }
  665. foreach ($course_list as $course) {
  666. // $setting_show_also_closed_courses
  667. if (!$setting_show_also_closed_courses) {
  668. // If we do not show the closed courses
  669. // we only show the courses that are open to the world (to everybody)
  670. // and the courses that are open to the platform (if the current user is a registered user
  671. if( ($user_identified && $course['visibility'] == COURSE_VISIBILITY_OPEN_PLATFORM) || ($course['visibility'] == COURSE_VISIBILITY_OPEN_WORLD)) {
  672. $courses_shown++;
  673. $courses_list_string .= "<li>\n";
  674. $courses_list_string .= '<a href="'.$web_course_path.$course['directory'].'/">'.$course['title'].'</a><br />';
  675. if (api_get_setting('display_coursecode_in_courselist') == 'true') {
  676. $courses_list_string .= $course['visual_code'];
  677. }
  678. if (api_get_setting('display_coursecode_in_courselist') == 'true' && api_get_setting('display_teacher_in_courselist') == 'true') {
  679. $courses_list_string .= ' - ';
  680. }
  681. if (api_get_setting('display_teacher_in_courselist') == 'true') {
  682. $courses_list_string .= $course['tutor_name'];
  683. }
  684. if (api_get_setting('show_different_course_language') == 'true' && $course['course_language'] != api_get_setting('platformLanguage')) {
  685. $courses_list_string .= ' - '.$course['course_language'];
  686. }
  687. $courses_list_string .= "</li>\n";
  688. }
  689. }
  690. // We DO show the closed courses.
  691. // The course is accessible if (link to the course homepage)
  692. // 1. the course is open to the world (doesn't matter if the user is logged in or not): $course['visibility'] == COURSE_VISIBILITY_OPEN_WORLD)
  693. // 2. the user is logged in and the course is open to the world or open to the platform: ($user_identified && $course['visibility'] == COURSE_VISIBILITY_OPEN_PLATFORM)
  694. // 3. the user is logged in and the user is subscribed to the course and the course visibility is not COURSE_VISIBILITY_CLOSED
  695. // 4. the user is logged in and the user is course admin of te course (regardless of the course visibility setting)
  696. // 5. the user is the platform admin api_is_platform_admin()
  697. //
  698. else {
  699. $courses_shown++;
  700. $courses_list_string .= "<li>\n";
  701. if ($course['visibility'] == COURSE_VISIBILITY_OPEN_WORLD
  702. || ($user_identified && $course['visibility'] == COURSE_VISIBILITY_OPEN_PLATFORM)
  703. || ($user_identified && key_exists($course['code'], $courses_of_user) && $course['visibility'] != COURSE_VISIBILITY_CLOSED)
  704. || $courses_of_user[$course['code']]['status'] == '1'
  705. || api_is_platform_admin()) {
  706. $courses_list_string .= '<a href="'.$web_course_path.$course['directory'].'/">';
  707. }
  708. $courses_list_string .= $course['title'];
  709. if ($course['visibility'] == COURSE_VISIBILITY_OPEN_WORLD
  710. || ($user_identified && $course['visibility'] == COURSE_VISIBILITY_OPEN_PLATFORM)
  711. || ($user_identified && key_exists($course['code'], $courses_of_user) && $course['visibility'] != COURSE_VISIBILITY_CLOSED)
  712. || $courses_of_user[$course['code']]['status'] == '1'
  713. || api_is_platform_admin()) {
  714. $courses_list_string .= '</a><br />';
  715. }
  716. if (api_get_setting('display_coursecode_in_courselist') == 'true') {
  717. $courses_list_string .= ' '.$course['visual_code'];
  718. }
  719. if (api_get_setting('display_coursecode_in_courselist') == 'true' && api_get_setting('display_teacher_in_courselist') == 'true') {
  720. $courses_list_string .= ' - ';
  721. }
  722. if (api_get_setting('display_teacher_in_courselist') == 'true') {
  723. $courses_list_string .= $course['tutor_name'];
  724. }
  725. if (api_get_setting('show_different_course_language') == 'true' && $course['course_language'] != api_get_setting('platformLanguage')) {
  726. $courses_list_string .= ' - '.$course['course_language'];
  727. }
  728. if (api_get_setting('show_different_course_language') == 'true' && $course['course_language'] != api_get_setting('platformLanguage')) {
  729. $courses_list_string .= ' - '.$course['course_language'];
  730. }
  731. // We display a subscription link if
  732. // 1. it is allowed to register for the course and if the course is not already in the courselist of the user and if the user is identiefied
  733. // 2
  734. if ($user_identified && !key_exists($course['code'], $courses_of_user)) {
  735. if ($course['subscribe'] == '1') {
  736. $courses_list_string .= '<form action="main/auth/courses.php?action=subscribe&category='.Security::remove_XSS($_GET['category']).'" method="post">';
  737. $courses_list_string .= '<input type="hidden" name="sec_token" value="'.$stok.'">';
  738. $courses_list_string .= '<input type="hidden" name="subscribe" value="'.$course['code'].'" />';
  739. $courses_list_string .= '<input type="image" name="unsub" src="main/img/enroll.gif" alt="'.get_lang('Subscribe').'" />'.get_lang('Subscribe').'</form>';
  740. } else {
  741. $courses_list_string .= '<br />'.get_lang('SubscribingNotAllowed');
  742. }
  743. }
  744. $courses_list_string .= "</li>\n";
  745. }
  746. }
  747. $courses_list_string .= "</ul>\n";
  748. } else {
  749. // echo '<blockquote>', get_lang('_No_course_publicly_available'), "</blockquote>\n";
  750. }
  751. if ($courses_shown > 0) { //only display the list of courses and categories if there was more than
  752. // 0 courses visible to the world (we're in the anonymous list here)
  753. echo $courses_list_string;
  754. }
  755. if ($category != '') {
  756. echo '<p><a href="'.api_get_self().'"> ', Display :: return_icon('back.png', get_lang('BackToHomePage')), get_lang('BackToHomePage'), '</a></p>', "\n";
  757. }
  758. }
  759. /**
  760. * retrieves all the courses that the user has already subscribed to
  761. * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University, Belgium
  762. * @param int $user_id: the id of the user
  763. * @return array an array containing all the information of the courses of the given user
  764. */
  765. function get_courses_of_user($user_id) {
  766. $table_course = Database::get_main_table(TABLE_MAIN_COURSE);
  767. $table_course_user = Database::get_main_table(TABLE_MAIN_COURSE_USER);
  768. // Secondly we select the courses that are in a category (user_course_cat <> 0) and sort these according to the sort of the category
  769. $user_id = intval($user_id);
  770. $sql_select_courses = "SELECT course.code k, course.visual_code vc, course.subscribe subscr, course.unsubscribe unsubscr,
  771. course.title i, course.tutor_name t, course.db_name db, course.directory dir, course_rel_user.status status,
  772. course_rel_user.sort sort, course_rel_user.user_course_cat user_course_cat
  773. FROM $table_course course,
  774. $table_course_user course_rel_user
  775. WHERE course.code = course_rel_user.course_code
  776. AND course_rel_user.user_id = '".$user_id."'
  777. AND course_rel_user.relation_type<>".COURSE_RELATION_TYPE_RRHH."
  778. ORDER BY course_rel_user.sort ASC";
  779. $result = Database::query($sql_select_courses);
  780. $courses = array();
  781. while ($row = Database::fetch_array($result)) {
  782. // We only need the database name of the course
  783. $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']);
  784. }
  785. return $courses;
  786. }