MDL-29912 course search - oracle inabilities with concats, empties, nulls and type...
[moodle.git] / index.php
blobb013887034842f8164c31e4c29f81c0a31da2e11
1 <?php
3 // This file is part of Moodle - http://moodle.org/
4 //
5 // Moodle is free software: you can redistribute it and/or modify
6 // it under the terms of the GNU General Public License as published by
7 // the Free Software Foundation, either version 3 of the License, or
8 // (at your option) any later version.
9 //
10 // Moodle is distributed in the hope that it will be useful,
11 // but WITHOUT ANY WARRANTY; without even the implied warranty of
12 // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13 // GNU General Public License for more details.
15 // You should have received a copy of the GNU General Public License
16 // along with Moodle. If not, see <http://www.gnu.org/licenses/>.
18 /**
19 * Moodle frontpage.
21 * @package core
22 * @copyright 1999 onwards Martin Dougiamas (http://dougiamas.com)
23 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
26 if (!file_exists('./config.php')) {
27 header('Location: install.php');
28 die;
31 require_once('config.php');
32 require_once($CFG->dirroot .'/course/lib.php');
33 require_once($CFG->libdir .'/filelib.php');
35 redirect_if_major_upgrade_required();
37 if ($CFG->forcelogin) {
38 require_login();
39 } else {
40 user_accesstime_log();
43 $hassiteconfig = has_capability('moodle/site:config', get_context_instance(CONTEXT_SYSTEM));
45 $PAGE->set_url('/');
46 $PAGE->set_course($SITE);
48 /// If the site is currently under maintenance, then print a message
49 if (!empty($CFG->maintenance_enabled) and !$hassiteconfig) {
50 print_maintenance_message();
53 if ($hassiteconfig && moodle_needs_upgrading()) {
54 redirect($CFG->wwwroot .'/'. $CFG->admin .'/index.php');
57 if (get_home_page() != HOMEPAGE_SITE) {
58 // Redirect logged-in users to My Moodle overview if required
59 if (optional_param('setdefaulthome', false, PARAM_BOOL)) {
60 set_user_preference('user_home_page_preference', HOMEPAGE_SITE);
61 } else if ($CFG->defaulthomepage == HOMEPAGE_MY && (optional_param('redirect', true, PARAM_BOOL) || !$hassiteconfig)) {
62 redirect($CFG->wwwroot .'/my/');
63 } else if (!empty($CFG->defaulthomepage) && $CFG->defaulthomepage == HOMEPAGE_USER) {
64 $PAGE->settingsnav->get('usercurrentsettings')->add(get_string('makethismyhome'), new moodle_url('/', array('setdefaulthome'=>true)), navigation_node::TYPE_SETTING);
68 if (isloggedin()) {
69 add_to_log(SITEID, 'course', 'view', 'view.php?id='.SITEID, SITEID);
72 /// If the hub plugin is installed then we let it take over the homepage here
73 if (get_config('local_hub', 'hubenabled') && file_exists($CFG->dirroot.'/local/hub/lib.php')) {
74 require_once($CFG->dirroot.'/local/hub/lib.php');
75 $hub = new local_hub();
76 $continue = $hub->display_homepage();
77 //display_homepage() return true if the hub home page is not displayed
78 //mostly when search form is not displayed for not logged users
79 if (empty($continue)) {
80 exit;
84 $PAGE->set_pagetype('site-index');
85 $PAGE->set_other_editing_capability('moodle/course:manageactivities');
86 $PAGE->set_docs_path('');
87 $PAGE->set_pagelayout('frontpage');
88 $editing = $PAGE->user_is_editing();
89 $PAGE->set_title($SITE->fullname);
90 $PAGE->set_heading($SITE->fullname);
91 echo $OUTPUT->header();
93 /// Print Section
94 if ($SITE->numsections > 0) {
96 if (!$section = $DB->get_record('course_sections', array('course'=>$SITE->id, 'section'=>1))) {
97 $DB->delete_records('course_sections', array('course'=>$SITE->id, 'section'=>1)); // Just in case
98 $section->course = $SITE->id;
99 $section->section = 1;
100 $section->summary = '';
101 $section->summaryformat = FORMAT_HTML;
102 $section->sequence = '';
103 $section->visible = 1;
104 $section->id = $DB->insert_record('course_sections', $section);
107 if (!empty($section->sequence) or !empty($section->summary) or $editing) {
108 echo $OUTPUT->box_start('generalbox sitetopic');
110 /// If currently moving a file then show the current clipboard
111 if (ismoving($SITE->id)) {
112 $stractivityclipboard = strip_tags(get_string('activityclipboard', '', $USER->activitycopyname));
113 echo '<p><font size="2">';
114 echo "$stractivityclipboard&nbsp;&nbsp;(<a href=\"course/mod.php?cancelcopy=true&amp;sesskey=".sesskey()."\">". get_string('cancel') .'</a>)';
115 echo '</font></p>';
118 $context = get_context_instance(CONTEXT_COURSE, SITEID);
119 $summarytext = file_rewrite_pluginfile_urls($section->summary, 'pluginfile.php', $context->id, 'course', 'section', $section->id);
120 $summaryformatoptions = new stdClass();
121 $summaryformatoptions->noclean = true;
122 $summaryformatoptions->overflowdiv = true;
124 echo format_text($summarytext, $section->summaryformat, $summaryformatoptions);
126 if ($editing) {
127 $streditsummary = get_string('editsummary');
128 echo "<a title=\"$streditsummary\" ".
129 " href=\"course/editsection.php?id=$section->id\"><img src=\"" . $OUTPUT->pix_url('t/edit') . "\" ".
130 " class=\"iconsmall\" alt=\"$streditsummary\" /></a><br /><br />";
133 get_all_mods($SITE->id, $mods, $modnames, $modnamesplural, $modnamesused);
134 print_section($SITE, $section, $mods, $modnamesused, true);
136 if ($editing) {
137 print_section_add_menus($SITE, $section->section, $modnames);
139 echo $OUTPUT->box_end();
143 if (isloggedin() and !isguestuser() and isset($CFG->frontpageloggedin)) {
144 $frontpagelayout = $CFG->frontpageloggedin;
145 } else {
146 $frontpagelayout = $CFG->frontpage;
149 foreach (explode(',',$frontpagelayout) as $v) {
150 switch ($v) { /// Display the main part of the front page.
151 case FRONTPAGENEWS:
152 if ($SITE->newsitems) { // Print forums only when needed
153 require_once($CFG->dirroot .'/mod/forum/lib.php');
155 if (! $newsforum = forum_get_course_forum($SITE->id, 'news')) {
156 print_error('cannotfindorcreateforum', 'forum');
159 // fetch news forum context for proper filtering to happen
160 $newsforumcm = get_coursemodule_from_instance('forum', $newsforum->id, $SITE->id, false, MUST_EXIST);
161 $newsforumcontext = get_context_instance(CONTEXT_MODULE, $newsforumcm->id, MUST_EXIST);
163 $forumname = format_string($newsforum->name, true, array('context' => $newsforumcontext));
164 echo html_writer::tag('a', get_string('skipa', 'access', moodle_strtolower(strip_tags($forumname))), array('href'=>'#skipsitenews', 'class'=>'skip-block'));
166 if (isloggedin()) {
167 $SESSION->fromdiscussion = $CFG->wwwroot;
168 $subtext = '';
169 if (forum_is_subscribed($USER->id, $newsforum)) {
170 if (!forum_is_forcesubscribed($newsforum)) {
171 $subtext = get_string('unsubscribe', 'forum');
173 } else {
174 $subtext = get_string('subscribe', 'forum');
176 echo $OUTPUT->heading($forumname, 2, 'headingblock header');
177 $suburl = new moodle_url('/mod/forum/subscribe.php', array('id' => $newsforum->id, 'sesskey' => sesskey()));
178 echo html_writer::tag('div', html_writer::link($suburl, $subtext), array('class' => 'subscribelink'));
179 } else {
180 echo $OUTPUT->heading($forumname, 2, 'headingblock header');
183 forum_print_latest_discussions($SITE, $newsforum, $SITE->newsitems, 'plain', 'p.modified DESC');
184 echo html_writer::tag('span', '', array('class'=>'skip-block-to', 'id'=>'skipsitenews'));
186 break;
188 case FRONTPAGECOURSELIST:
189 if (isloggedin() and !$hassiteconfig and !isguestuser() and empty($CFG->disablemycourses)) {
190 echo html_writer::tag('a', get_string('skipa', 'access', moodle_strtolower(get_string('mycourses'))), array('href'=>'#skipmycourses', 'class'=>'skip-block'));
191 echo $OUTPUT->heading(get_string('mycourses'), 2, 'headingblock header');
192 print_my_moodle();
193 echo html_writer::tag('span', '', array('class'=>'skip-block-to', 'id'=>'skipmycourses'));
194 } else if ((!$hassiteconfig and !isguestuser()) or ($DB->count_records('course') <= FRONTPAGECOURSELIMIT)) {
195 // admin should not see list of courses when there are too many of them
196 echo html_writer::tag('a', get_string('skipa', 'access', moodle_strtolower(get_string('availablecourses'))), array('href'=>'#skipavailablecourses', 'class'=>'skip-block'));
197 echo $OUTPUT->heading(get_string('availablecourses'), 2, 'headingblock header');
198 print_courses(0);
199 echo html_writer::tag('span', '', array('class'=>'skip-block-to', 'id'=>'skipavailablecourses'));
201 break;
203 case FRONTPAGECATEGORYNAMES:
204 echo html_writer::tag('a', get_string('skipa', 'access', moodle_strtolower(get_string('categories'))), array('href'=>'#skipcategories', 'class'=>'skip-block'));
205 echo $OUTPUT->heading(get_string('categories'), 2, 'headingblock header');
206 echo $OUTPUT->box_start('generalbox categorybox');
207 print_whole_category_list(NULL, NULL, NULL, -1, false);
208 echo $OUTPUT->box_end();
209 print_course_search('', false, 'short');
210 echo html_writer::tag('span', '', array('class'=>'skip-block-to', 'id'=>'skipcategories'));
211 break;
213 case FRONTPAGECATEGORYCOMBO:
214 echo html_writer::tag('a', get_string('skipa', 'access', moodle_strtolower(get_string('courses'))), array('href'=>'#skipcourses', 'class'=>'skip-block'));
215 echo $OUTPUT->heading(get_string('courses'), 2, 'headingblock header');
216 $renderer = $PAGE->get_renderer('core','course');
217 // if there are too many courses, budiling course category tree could be slow,
218 // users should go to course index page to see the whole list.
219 $coursecount = $DB->count_records('course');
220 if (empty($CFG->numcoursesincombo)) {
221 // if $CFG->numcoursesincombo hasn't been set, use default value 500
222 $CFG->numcoursesincombo = 500;
224 if ($coursecount > $CFG->numcoursesincombo) {
225 $link = new moodle_url('/course/');
226 echo $OUTPUT->notification(get_string('maxnumcoursesincombo', 'moodle', array('link'=>$link->out(), 'maxnumofcourses'=>$CFG->numcoursesincombo, 'numberofcourses'=>$coursecount)));
227 } else {
228 echo $renderer->course_category_tree(get_course_category_tree());
230 print_course_search('', false, 'short');
231 echo html_writer::tag('span', '', array('class'=>'skip-block-to', 'id'=>'skipcourses'));
232 break;
234 case FRONTPAGETOPICONLY: // Do nothing!! :-)
235 break;
238 echo '<br />';
241 echo $OUTPUT->footer();