MDL-11517 reserved word MOD used in table alias in questions backup code
[moodle-pu.git] / lib / blocklib.php
blob5bfd6fd7acb7b821d3d0c5d4e5dd282239b171b8
1 <?php //$Id$
3 //This library includes all the necessary stuff to use blocks in course pages
5 define('BLOCK_MOVE_LEFT', 0x01);
6 define('BLOCK_MOVE_RIGHT', 0x02);
7 define('BLOCK_MOVE_UP', 0x04);
8 define('BLOCK_MOVE_DOWN', 0x08);
9 define('BLOCK_CONFIGURE', 0x10);
11 define('BLOCK_POS_LEFT', 'l');
12 define('BLOCK_POS_RIGHT', 'r');
14 define('BLOCKS_PINNED_TRUE',0);
15 define('BLOCKS_PINNED_FALSE',1);
16 define('BLOCKS_PINNED_BOTH',2);
18 require_once($CFG->libdir.'/pagelib.php');
19 require_once($CFG->dirroot.'/course/lib.php'); // needed to solve all those: Call to undefined function: print_recent_activity() when adding Recent Activity
21 // Returns false if this block is incompatible with the current version of Moodle.
22 function block_is_compatible($blockname) {
23 global $CFG;
25 $file = @file($CFG->dirroot.'/blocks/'.$blockname.'/block_'.$blockname.'.php'); // ignore errors when file does not exist
26 if(empty($file)) {
27 return NULL;
30 foreach($file as $line) {
31 // If you find MoodleBlock (appearing in the class declaration) it's not compatible
32 if(strpos($line, 'MoodleBlock')) {
33 return false;
35 // But if we find a { it means the class declaration is over, so it's compatible
36 else if(strpos($line, '{')) {
37 return true;
41 return NULL;
44 // Returns the case-sensitive name of the class' constructor function. This includes both
45 // PHP5- and PHP4-style constructors. If no appropriate constructor can be found, returns NULL.
46 // If there is no such class, returns boolean false.
47 function get_class_constructor($classname) {
48 // Caching
49 static $constructors = array();
51 if(!class_exists($classname)) {
52 return false;
55 // Tests indicate this doesn't hurt even in PHP5.
56 $classname = strtolower($classname);
58 // Return cached value, if exists
59 if(isset($constructors[$classname])) {
60 return $constructors[$classname];
63 // Get a list of methods. After examining several different ways of
64 // doing the check, (is_callable, method_exists, function_exists etc)
65 // it seems that this is the most reliable one.
66 $methods = get_class_methods($classname);
68 // PHP5 constructor?
69 if(phpversion() >= '5') {
70 if(in_array('__construct', $methods)) {
71 return $constructors[$classname] = '__construct';
75 // If we have PHP5 but no magic constructor, we have to lowercase the methods
76 $methods = array_map('strtolower', $methods);
78 if(in_array($classname, $methods)) {
79 return $constructors[$classname] = $classname;
82 return $constructors[$classname] = NULL;
85 //This function retrieves a method-defined property of a class WITHOUT instantiating an object
86 function block_method_result($blockname, $method, $param = NULL) {
87 if(!block_load_class($blockname)) {
88 return NULL;
90 return call_user_func(array('block_'.$blockname, $method), $param);
93 //This function creates a new object of the specified block class
94 function block_instance($blockname, $instance = NULL) {
95 if(!block_load_class($blockname)) {
96 return false;
98 $classname = 'block_'.$blockname;
99 $retval = new $classname;
100 if($instance !== NULL) {
101 $retval->_load_instance($instance);
103 return $retval;
106 //This function loads the necessary class files for a block
107 //Whenever you want to load a block, use this first
108 function block_load_class($blockname) {
109 global $CFG;
111 if(empty($blockname)) {
112 return false;
115 $classname = 'block_'.$blockname;
117 if(class_exists($classname)) {
118 return true;
121 require_once($CFG->dirroot.'/blocks/moodleblock.class.php');
122 @include_once($CFG->dirroot.'/blocks/'.$blockname.'/block_'.$blockname.'.php'); // do not throw errors if block code not present
124 return class_exists($classname);
127 // This function returns an array with the IDs of any blocks that you can add to your page.
128 // Parameters are passed by reference for speed; they are not modified at all.
129 function blocks_get_missing(&$page, &$pageblocks) {
131 $missingblocks = array();
132 $allblocks = blocks_get_record();
133 $pageformat = $page->get_format_name();
135 if(!empty($allblocks)) {
136 foreach($allblocks as $block) {
137 if($block->visible && (!blocks_find_block($block->id, $pageblocks) || $block->multiple)) {
138 // And if it's applicable for display in this format...
139 if(blocks_name_allowed_in_format($block->name, $pageformat)) {
140 // ...add it to the missing blocks
141 $missingblocks[] = $block->id;
146 return $missingblocks;
149 function blocks_remove_inappropriate($page) {
150 $pageblocks = blocks_get_by_page($page);
152 if(empty($pageblocks)) {
153 return;
156 if(($pageformat = $page->get_format_name()) == NULL) {
157 return;
160 foreach($pageblocks as $position) {
161 foreach($position as $instance) {
162 $block = blocks_get_record($instance->blockid);
163 if(!blocks_name_allowed_in_format($block->name, $pageformat)) {
164 blocks_delete_instance($instance);
170 function blocks_name_allowed_in_format($name, $pageformat) {
172 $accept = NULL;
173 $depth = -1;
174 if ($formats = block_method_result($name, 'applicable_formats')) {
175 foreach($formats as $format => $allowed) {
176 $thisformat = '^'.str_replace('*', '[^-]*', $format).'.*$';
177 if(ereg($thisformat, $pageformat)) {
178 if(($scount = substr_count($format, '-')) > $depth) {
179 $depth = $scount;
180 $accept = $allowed;
185 if($accept === NULL) {
186 $accept = !empty($formats['all']);
188 return $accept;
191 function blocks_delete_instance($instance,$pinned=false) {
192 global $CFG;
194 // Get the block object and call instance_delete() if possible
195 if($record = blocks_get_record($instance->blockid)) {
196 if($obj = block_instance($record->name, $instance)) {
197 // Return value ignored
198 $obj->instance_delete();
202 if (!empty($pinned)) {
203 delete_records('block_pinned', 'id', $instance->id);
204 // And now, decrement the weight of all blocks after this one
205 execute_sql('UPDATE '.$CFG->prefix.'block_pinned SET weight = weight - 1 WHERE pagetype = \''.$instance->pagetype.
206 '\' AND position = \''.$instance->position.
207 '\' AND weight > '.$instance->weight, false);
208 } else {
209 // Now kill the db record;
210 delete_records('block_instance', 'id', $instance->id);
211 // And now, decrement the weight of all blocks after this one
212 execute_sql('UPDATE '.$CFG->prefix.'block_instance SET weight = weight - 1 WHERE pagetype = \''.$instance->pagetype.
213 '\' AND pageid = '.$instance->pageid.' AND position = \''.$instance->position.
214 '\' AND weight > '.$instance->weight, false);
216 return true;
219 // Accepts an array of block instances and checks to see if any of them have content to display
220 // (causing them to calculate their content in the process). Returns true or false. Parameter passed
221 // by reference for speed; the array is actually not modified.
222 function blocks_have_content(&$pageblocks, $position) {
224 if (empty($pageblocks) || !is_array($pageblocks) || !array_key_exists($position,$pageblocks)) {
225 return false;
227 // use a for() loop to get references to the array elements
228 // foreach() cannot fetch references in PHP v4.x
229 for ($n=0; $n<count($pageblocks[$position]);$n++) {
230 $instance = &$pageblocks[$position][$n];
231 if (empty($instance->visible)) {
232 continue;
234 if(!$record = blocks_get_record($instance->blockid)) {
235 continue;
237 if(!$obj = block_instance($record->name, $instance)) {
238 continue;
240 if(!$obj->is_empty()) {
241 // cache rec and obj
242 // for blocks_print_group()
243 $instance->rec = $record;
244 $instance->obj = $obj;
245 return true;
249 return false;
252 // This function prints one group of blocks in a page
253 // Parameters passed by reference for speed; they are not modified.
254 function blocks_print_group(&$page, &$pageblocks, $position) {
255 global $COURSE, $CFG, $USER;
257 if (empty($pageblocks[$position])) {
258 $groupblocks = array();
259 $maxweight = 0;
260 } else {
261 $groupblocks = $pageblocks[$position];
262 $maxweight = max(array_keys($groupblocks));
266 foreach ($groupblocks as $instance) {
267 if (!empty($instance->pinned)) {
268 $maxweight--;
272 $isediting = $page->user_is_editing();
275 foreach($groupblocks as $instance) {
278 // $instance may have ->rec and ->obj
279 // cached from when we walked $pageblocks
280 // in blocks_have_content()
281 if (empty($instance->rec)) {
282 if (empty($instance->blockid)) {
283 continue; // Can't do anything
285 $block = blocks_get_record($instance->blockid);
286 } else {
287 $block = $instance->rec;
290 if (empty($block)) {
291 // Block doesn't exist! We should delete this instance!
292 continue;
295 if (empty($block->visible)) {
296 // Disabled by the admin
297 continue;
300 if (empty($instance->obj)) {
301 if (!$obj = block_instance($block->name, $instance)) {
302 // Invalid block
303 continue;
305 } else {
306 $obj = $instance->obj;
309 $editalways = $page->edit_always();
312 if (($isediting && empty($instance->pinned)) || !empty($editalways)) {
313 $options = 0;
314 // The block can be moved up if it's NOT the first one in its position. If it is, we look at the OR clause:
315 // the first block might still be able to move up if the page says so (i.e., it will change position)
316 $options |= BLOCK_MOVE_UP * ($instance->weight != 0 || ($page->blocks_move_position($instance, BLOCK_MOVE_UP) != $instance->position));
317 // Same thing for downward movement
318 $options |= BLOCK_MOVE_DOWN * ($instance->weight != $maxweight || ($page->blocks_move_position($instance, BLOCK_MOVE_DOWN) != $instance->position));
319 // For left and right movements, it's up to the page to tell us whether they are allowed
320 $options |= BLOCK_MOVE_RIGHT * ($page->blocks_move_position($instance, BLOCK_MOVE_RIGHT) != $instance->position);
321 $options |= BLOCK_MOVE_LEFT * ($page->blocks_move_position($instance, BLOCK_MOVE_LEFT ) != $instance->position);
322 // Finally, the block can be configured if the block class either allows multiple instances, or if it specifically
323 // allows instance configuration (multiple instances override that one). It doesn't have anything to do with what the
324 // administrator has allowed for this block in the site admin options.
325 $options |= BLOCK_CONFIGURE * ( $obj->instance_allow_multiple() || $obj->instance_allow_config() );
326 $obj->_add_edit_controls($options);
329 if (!$instance->visible && empty($COURSE->javascriptportal)) {
330 if ($isediting) {
331 $obj->_print_shadow();
333 } else {
334 global $COURSE;
335 if(!empty($COURSE->javascriptportal)) {
336 $COURSE->javascriptportal->currentblocksection = $position;
338 $obj->_print_block();
340 if (!empty($COURSE->javascriptportal)
341 && (empty($instance->pinned) || !$instance->pinned)) {
342 $COURSE->javascriptportal->block_add('inst'.$instance->id, !$instance->visible);
344 } // End foreach
346 // Check if
347 // we are on the default position/side AND
348 // we're editing the page AND
349 // (
350 // we have the capability to manage blocks OR
351 // we are in myMoodle page AND have the capibility to manage myMoodle blocks
352 // )
354 // for constant PAGE_MY_MOODLE
355 include_once($CFG->dirroot.'/my/pagelib.php');
357 $coursecontext = get_context_instance(CONTEXT_COURSE, $COURSE->id);
358 $myownblogpage = (isset($page->filtertype) && isset($page->filterselect) && $page->type=='blog-view' && $page->filtertype=='user' && $page->filterselect == $USER->id);
360 $managecourseblocks = has_capability('moodle/site:manageblocks', $coursecontext);
361 $editmymoodle = $page->type == PAGE_MY_MOODLE && has_capability('moodle/my:manageblocks', $coursecontext);
363 if ($page->blocks_default_position() == $position &&
364 $page->user_is_editing() &&
365 ($managecourseblocks || $editmymoodle || $myownblogpage)) {
367 blocks_print_adminblock($page, $pageblocks);
371 // This iterates over an array of blocks and calculates the preferred width
372 // Parameter passed by reference for speed; it's not modified.
373 function blocks_preferred_width(&$instances) {
374 $width = 0;
376 if(empty($instances) || !is_array($instances)) {
377 return 0;
380 $blocks = blocks_get_record();
382 foreach($instances as $instance) {
383 if(!$instance->visible) {
384 continue;
387 if (!array_key_exists($instance->blockid, $blocks)) {
388 // Block doesn't exist! We should delete this instance!
389 continue;
392 if(!$blocks[$instance->blockid]->visible) {
393 continue;
395 $pref = block_method_result($blocks[$instance->blockid]->name, 'preferred_width');
396 if($pref === NULL) {
397 continue;
399 if($pref > $width) {
400 $width = $pref;
403 return $width;
406 function blocks_get_record($blockid = NULL, $invalidate = false) {
407 static $cache = NULL;
409 if($invalidate || empty($cache)) {
410 $cache = get_records('block');
413 if($blockid === NULL) {
414 return $cache;
417 return (isset($cache[$blockid])? $cache[$blockid] : false);
420 function blocks_find_block($blockid, $blocksarray) {
421 if (empty($blocksarray)) {
422 return false;
424 foreach($blocksarray as $blockgroup) {
425 if (empty($blockgroup)) {
426 continue;
428 foreach($blockgroup as $instance) {
429 if($instance->blockid == $blockid) {
430 return $instance;
434 return false;
437 function blocks_find_instance($instanceid, $blocksarray) {
438 foreach($blocksarray as $subarray) {
439 foreach($subarray as $instance) {
440 if($instance->id == $instanceid) {
441 return $instance;
445 return false;
448 // Simple entry point for anyone that wants to use blocks
449 function blocks_setup(&$PAGE,$pinned=BLOCKS_PINNED_FALSE) {
450 switch ($pinned) {
451 case BLOCKS_PINNED_TRUE:
452 $pageblocks = blocks_get_pinned($PAGE);
453 break;
454 case BLOCKS_PINNED_BOTH:
455 $pageblocks = blocks_get_by_page_pinned($PAGE);
456 break;
457 case BLOCKS_PINNED_FALSE:
458 default:
459 $pageblocks = blocks_get_by_page($PAGE);
460 break;
462 blocks_execute_url_action($PAGE, $pageblocks,($pinned==BLOCKS_PINNED_TRUE));
463 return $pageblocks;
466 function blocks_execute_action($page, &$pageblocks, $blockaction, $instanceorid, $pinned=false, $redirect=true) {
467 global $CFG;
469 if (is_int($instanceorid)) {
470 $blockid = $instanceorid;
471 } else if (is_object($instanceorid)) {
472 $instance = $instanceorid;
475 switch($blockaction) {
476 case 'config':
477 global $USER;
478 $block = blocks_get_record($instance->blockid);
479 // Hacky hacky tricky stuff to get the original human readable block title,
480 // even if the block has configured its title to be something else.
481 // Create the object WITHOUT instance data.
482 $blockobject = block_instance($block->name);
483 if ($blockobject === false) {
484 break;
487 // First of all check to see if the block wants to be edited
488 if(!$blockobject->user_can_edit()) {
489 break;
492 // Now get the title and AFTER that load up the instance
493 $blocktitle = $blockobject->get_title();
494 $blockobject->_load_instance($instance);
496 optional_param('submitted', 0, PARAM_INT);
498 // Define the data we're going to silently include in the instance config form here,
499 // so we can strip them from the submitted data BEFORE serializing it.
500 $hiddendata = array(
501 'sesskey' => $USER->sesskey,
502 'instanceid' => $instance->id,
503 'blockaction' => 'config'
506 // To this data, add anything the page itself needs to display
507 $hiddendata = array_merge($hiddendata, $page->url_get_parameters());
509 if($data = data_submitted()) {
510 $remove = array_keys($hiddendata);
511 foreach($remove as $item) {
512 unset($data->$item);
514 if(!$blockobject->instance_config_save($data,$pinned)) {
515 error('Error saving block configuration');
517 // And nothing more, continue with displaying the page
519 else {
520 // We need to show the config screen, so we highjack the display logic and then die
521 $strheading = get_string('blockconfiga', 'moodle', $blocktitle);
522 $page->print_header(get_string('pageheaderconfigablock', 'moodle'), array($strheading => ''));
524 echo '<div class="block-config" id="'.$block->name.'">'; /// Make CSS easier
526 print_heading($strheading);
527 echo '<form method="post" name="block-config" action="'. $page->url_get_path() .'">';
528 echo '<p>';
529 foreach($hiddendata as $name => $val) {
530 echo '<input type="hidden" name="'. $name .'" value="'. $val .'" />';
532 echo '</p>';
533 $blockobject->instance_config_print();
534 echo '</form>';
536 echo '</div>';
537 $CFG->pagepath = 'blocks/' . $block->name;
538 print_footer();
539 die(); // Do not go on with the other page-related stuff
541 break;
542 case 'toggle':
543 if(empty($instance)) {
544 error('Invalid block instance for '.$blockaction);
546 $instance->visible = ($instance->visible) ? 0 : 1;
547 if (!empty($pinned)) {
548 update_record('block_pinned', $instance);
549 } else {
550 update_record('block_instance', $instance);
552 break;
553 case 'delete':
554 if(empty($instance)) {
555 error('Invalid block instance for '. $blockaction);
557 blocks_delete_instance($instance, $pinned);
558 break;
559 case 'moveup':
560 if(empty($instance)) {
561 error('Invalid block instance for '. $blockaction);
564 if($instance->weight == 0) {
565 // The block is the first one, so a move "up" probably means it changes position
566 // Where is the instance going to be moved?
567 $newpos = $page->blocks_move_position($instance, BLOCK_MOVE_UP);
568 $newweight = (empty($pageblocks[$newpos]) ? 0 : max(array_keys($pageblocks[$newpos])) + 1);
570 blocks_execute_repositioning($instance, $newpos, $newweight, $pinned);
572 else {
573 // The block is just moving upwards in the same position.
574 // This configuration will make sure that even if somehow the weights
575 // become not continuous, block move operations will eventually bring
576 // the situation back to normal without printing any warnings.
577 if(!empty($pageblocks[$instance->position][$instance->weight - 1])) {
578 $other = $pageblocks[$instance->position][$instance->weight - 1];
580 if(!empty($other)) {
581 ++$other->weight;
582 if (!empty($pinned)) {
583 update_record('block_pinned', $other);
584 } else {
585 update_record('block_instance', $other);
588 --$instance->weight;
589 if (!empty($pinned)) {
590 update_record('block_pinned', $instance);
591 } else {
592 update_record('block_instance', $instance);
595 break;
596 case 'movedown':
597 if(empty($instance)) {
598 error('Invalid block instance for '. $blockaction);
601 if($instance->weight == max(array_keys($pageblocks[$instance->position]))) {
602 // The block is the last one, so a move "down" probably means it changes position
603 // Where is the instance going to be moved?
604 $newpos = $page->blocks_move_position($instance, BLOCK_MOVE_DOWN);
605 $newweight = (empty($pageblocks[$newpos]) ? 0 : max(array_keys($pageblocks[$newpos])) + 1);
607 blocks_execute_repositioning($instance, $newpos, $newweight, $pinned);
609 else {
610 // The block is just moving downwards in the same position.
611 // This configuration will make sure that even if somehow the weights
612 // become not continuous, block move operations will eventually bring
613 // the situation back to normal without printing any warnings.
614 if(!empty($pageblocks[$instance->position][$instance->weight + 1])) {
615 $other = $pageblocks[$instance->position][$instance->weight + 1];
617 if(!empty($other)) {
618 --$other->weight;
619 if (!empty($pinned)) {
620 update_record('block_pinned', $other);
621 } else {
622 update_record('block_instance', $other);
625 ++$instance->weight;
626 if (!empty($pinned)) {
627 update_record('block_pinned', $instance);
628 } else {
629 update_record('block_instance', $instance);
632 break;
633 case 'moveleft':
634 if(empty($instance)) {
635 error('Invalid block instance for '. $blockaction);
638 // Where is the instance going to be moved?
639 $newpos = $page->blocks_move_position($instance, BLOCK_MOVE_LEFT);
640 $newweight = (empty($pageblocks[$newpos]) ? 0 : max(array_keys($pageblocks[$newpos])) + 1);
642 blocks_execute_repositioning($instance, $newpos, $newweight, $pinned);
643 break;
644 case 'moveright':
645 if(empty($instance)) {
646 error('Invalid block instance for '. $blockaction);
649 // Where is the instance going to be moved?
650 $newpos = $page->blocks_move_position($instance, BLOCK_MOVE_RIGHT);
651 $newweight = (empty($pageblocks[$newpos]) ? 0 : max(array_keys($pageblocks[$newpos])) + 1);
653 blocks_execute_repositioning($instance, $newpos, $newweight, $pinned);
654 break;
655 case 'add':
656 // Add a new instance of this block, if allowed
657 $block = blocks_get_record($blockid);
659 if(empty($block) || !$block->visible) {
660 // Only allow adding if the block exists and is enabled
661 break;
664 if(!$block->multiple && blocks_find_block($blockid, $pageblocks) !== false) {
665 // If no multiples are allowed and we already have one, return now
666 break;
669 if(!block_method_result($block->name, 'user_can_addto', $page)) {
670 // If the block doesn't want to be added...
671 break;
674 $newpos = $page->blocks_default_position();
675 if (!empty($pinned)) {
676 $sql = 'SELECT 1, max(weight) + 1 AS nextfree FROM '. $CFG->prefix .'block_pinned WHERE '
677 .' pagetype = \''. $page->get_type() .'\' AND position = \''. $newpos .'\'';
678 } else {
679 $sql = 'SELECT 1, max(weight) + 1 AS nextfree FROM '. $CFG->prefix .'block_instance WHERE pageid = '. $page->get_id()
680 .' AND pagetype = \''. $page->get_type() .'\' AND position = \''. $newpos .'\'';
682 $weight = get_record_sql($sql);
684 $newinstance = new stdClass;
685 $newinstance->blockid = $blockid;
686 if (empty($pinned)) {
687 $newinstance->pageid = $page->get_id();
689 $newinstance->pagetype = $page->get_type();
690 $newinstance->position = $newpos;
691 $newinstance->weight = empty($weight->nextfree) ? 0 : $weight->nextfree;
692 $newinstance->visible = 1;
693 $newinstance->configdata = '';
694 if (!empty($pinned)) {
695 $newinstance->id = insert_record('block_pinned', $newinstance);
696 } else {
697 $newinstance->id = insert_record('block_instance', $newinstance);
700 // If the new instance was created, allow it to do additional setup
701 if($newinstance && ($obj = block_instance($block->name, $newinstance))) {
702 // Return value ignored
703 $obj->instance_create();
706 break;
709 if ($redirect) {
710 // In order to prevent accidental duplicate actions, redirect to a page with a clean url
711 redirect($page->url_get_full());
715 // You can use this to get the blocks to respond to URL actions without much hassle
716 function blocks_execute_url_action(&$PAGE, &$pageblocks,$pinned=false) {
717 $blockaction = optional_param('blockaction', '', PARAM_ALPHA);
719 if (empty($blockaction) || !$PAGE->user_allowed_editing() || !confirm_sesskey()) {
720 return;
723 $instanceid = optional_param('instanceid', 0, PARAM_INT);
724 $blockid = optional_param('blockid', 0, PARAM_INT);
726 if (!empty($blockid)) {
727 blocks_execute_action($PAGE, $pageblocks, strtolower($blockaction), $blockid, $pinned);
730 else if (!empty($instanceid)) {
731 $instance = blocks_find_instance($instanceid, $pageblocks);
732 blocks_execute_action($PAGE, $pageblocks, strtolower($blockaction), $instance, $pinned);
736 // This shouldn't be used externally at all, it's here for use by blocks_execute_action()
737 // in order to reduce code repetition.
738 function blocks_execute_repositioning(&$instance, $newpos, $newweight, $pinned=false) {
739 global $CFG;
741 // If it's staying where it is, don't do anything, unless overridden
742 if ($newpos == $instance->position) {
743 return;
746 // Close the weight gap we 'll leave behind
747 if (!empty($pinned)) {
748 $sql = 'UPDATE '. $CFG->prefix .'block_instance SET weight = weight - 1 '.
749 'WHERE pagetype = \''. $instance->pagetype.
750 '\' AND position = \'' .$instance->position.
751 '\' AND weight > '. $instance->weight;
752 } else {
753 $sql = 'UPDATE '. $CFG->prefix .'block_instance SET weight = weight - 1 '.
754 'WHERE pagetype = \''. $instance->pagetype.
755 '\' AND pageid = '. $instance->pageid .
756 ' AND position = \'' .$instance->position.
757 '\' AND weight > '. $instance->weight;
759 execute_sql($sql,false);
761 $instance->position = $newpos;
762 $instance->weight = $newweight;
764 if (!empty($pinned)) {
765 update_record('block_pinned', $instance);
766 } else {
767 update_record('block_instance', $instance);
773 * Moves a block to the new position (column) and weight (sort order).
774 * @param $instance - The block instance to be moved.
775 * @param $destpos - BLOCK_POS_LEFT or BLOCK_POS_RIGHT. The destination column.
776 * @param $destweight - The destination sort order. If NULL, we add to the end
777 * of the destination column.
778 * @param $pinned - Are we moving pinned blocks? We can only move pinned blocks
779 * to a new position withing the pinned list. Likewise, we
780 * can only moved non-pinned blocks to a new position within
781 * the non-pinned list.
782 * @return boolean (success or failure).
784 function blocks_move_block($page, &$instance, $destpos, $destweight=NULL, $pinned=false) {
785 global $CFG;
787 if ($pinned) {
788 $blocklist = blocks_get_pinned($page);
789 } else {
790 $blocklist = blocks_get_by_page($page);
793 if ($blocklist[$instance->position][$instance->weight]->id != $instance->id) {
794 // The source block instance is not where we think it is.
795 return false;
798 // First we close the gap that will be left behind when we take out the
799 // block from it's current column.
800 if ($pinned) {
801 $closegapsql = "UPDATE {$CFG->prefix}block_instance
802 SET weight = weight - 1
803 WHERE weight > '$instance->weight'
804 AND position = '$instance->position'
805 AND pagetype = '$instance->pagetype'";
806 } else {
807 $closegapsql = "UPDATE {$CFG->prefix}block_instance
808 SET weight = weight - 1
809 WHERE weight > '$instance->weight'
810 AND position = '$instance->position'
811 AND pagetype = '$instance->pagetype'
812 AND pageid = '$instance->pageid'";
814 if (!execute_sql($closegapsql, false)) {
815 return false;
818 // Now let's make space for the block being moved.
819 if ($pinned) {
820 $opengapsql = "UPDATE {$CFG->prefix}block_instance
821 SET weight = weight + 1
822 WHERE weight >= '$destweight'
823 AND position = '$destpos'
824 AND pagetype = '$instance->pagetype'";
825 } else {
826 $opengapsql = "UPDATE {$CFG->prefix}block_instance
827 SET weight = weight + 1
828 WHERE weight >= '$destweight'
829 AND position = '$destpos'
830 AND pagetype = '$instance->pagetype'
831 AND pageid = '$instance->pageid'";
833 if (!execute_sql($opengapsql, false)) {
834 return false;
837 // Move the block.
838 $instance->position = $destpos;
839 $instance->weight = $destweight;
841 if ($pinned) {
842 $table = 'block_pinned';
843 } else {
844 $table = 'block_instance';
846 return update_record($table, $instance);
851 * Returns an array consisting of 2 arrays:
852 * 1) Array of pinned blocks for position BLOCK_POS_LEFT
853 * 2) Array of pinned blocks for position BLOCK_POS_RIGHT
855 function blocks_get_pinned($page) {
857 $visible = true;
859 if (method_exists($page,'edit_always')) {
860 if ($page->edit_always()) {
861 $visible = false;
865 $blocks = get_records_select('block_pinned', 'pagetype = \''. $page->get_type() .
866 '\''.(($visible) ? 'AND visible = 1' : ''), 'position, weight');
868 $positions = $page->blocks_get_positions();
869 $arr = array();
871 foreach($positions as $key => $position) {
872 $arr[$position] = array();
875 if(empty($blocks)) {
876 return $arr;
879 foreach($blocks as $block) {
880 $block->pinned = true; // so we know we can't move it.
881 // make up an instanceid if we can..
882 $block->pageid = $page->get_id();
883 $arr[$block->position][$block->weight] = $block;
886 return $arr;
891 * Similar to blocks_get_by_page(), except that, the array returned includes
892 * pinned blocks as well. Pinned blocks are always appended before normal
893 * block instances.
895 function blocks_get_by_page_pinned($page) {
896 $pinned = blocks_get_pinned($page);
897 $user = blocks_get_by_page($page);
899 $weights = array();
901 foreach ($pinned as $pos => $arr) {
902 $weights[$pos] = count($arr);
905 foreach ($user as $pos => $blocks) {
906 if (!array_key_exists($pos,$pinned)) {
907 $pinned[$pos] = array();
909 if (!array_key_exists($pos,$weights)) {
910 $weights[$pos] = 0;
912 foreach ($blocks as $block) {
913 $pinned[$pos][$weights[$pos]] = $block;
914 $weights[$pos]++;
917 return $pinned;
922 * Returns an array of blocks for the page. Pinned blocks are excluded.
924 function blocks_get_by_page($page) {
925 $blocks = get_records_select('block_instance', "pageid = '". $page->get_id() .
926 "' AND pagetype = '". $page->get_type() ."'", 'position, weight');
928 $positions = $page->blocks_get_positions();
929 $arr = array();
930 foreach($positions as $key => $position) {
931 $arr[$position] = array();
934 if(empty($blocks)) {
935 return $arr;
938 foreach($blocks as $block) {
939 $arr[$block->position][$block->weight] = $block;
941 return $arr;
945 //This function prints the block to admin blocks as necessary
946 function blocks_print_adminblock(&$page, &$pageblocks) {
947 global $USER;
949 $missingblocks = blocks_get_missing($page, $pageblocks);
951 if (!empty($missingblocks)) {
952 $strblocks = get_string('blocks');
953 $stradd = get_string('add');
954 foreach ($missingblocks as $blockid) {
955 $block = blocks_get_record($blockid);
956 $blockobject = block_instance($block->name);
957 if ($blockobject === false) {
958 continue;
960 if(!$blockobject->user_can_addto($page)) {
961 continue;
963 $menu[$block->id] = $blockobject->get_title();
965 asort($menu);
967 $target = $page->url_get_full(array('sesskey' => $USER->sesskey, 'blockaction' => 'add'));
968 $content = popup_form($target.'&amp;blockid=', $menu, 'add_block', '', $stradd .'...', '', '', true);
969 print_side_block($strblocks, $content, NULL, NULL, NULL, array('class' => 'block_adminblock'));
973 function blocks_repopulate_page($page) {
974 global $CFG;
976 $allblocks = blocks_get_record();
978 if(empty($allblocks)) {
979 error('Could not retrieve blocks from the database');
982 // Assemble the information to correlate block names to ids
983 $idforname = array();
984 foreach($allblocks as $block) {
985 $idforname[$block->name] = $block->id;
988 /// If the site override has been defined, it is the only valid one.
989 if (!empty($CFG->defaultblocks_override)) {
990 $blocknames = $CFG->defaultblocks_override;
992 else {
993 $blocknames = $page->blocks_get_default();
996 $positions = $page->blocks_get_positions();
997 $posblocks = explode(':', $blocknames);
999 // Now one array holds the names of the positions, and the other one holds the blocks
1000 // that are going to go in each position. Luckily for us, both arrays are numerically
1001 // indexed and the indexes match, so we can work straight away... but CAREFULLY!
1003 // Ready to start creating block instances, but first drop any existing ones
1004 delete_records('block_instance', 'pageid', $page->get_id(), 'pagetype', $page->get_type());
1006 // Here we slyly count $posblocks and NOT $positions. This can actually make a difference
1007 // if the textual representation has undefined slots in the end. So we only work with as many
1008 // positions were retrieved, not with all the page says it has available.
1009 $numpositions = count($posblocks);
1010 for($i = 0; $i < $numpositions; ++$i) {
1011 $position = $positions[$i];
1012 $blocknames = explode(',', $posblocks[$i]);
1013 $weight = 0;
1014 foreach($blocknames as $blockname) {
1015 $newinstance = new stdClass;
1016 $newinstance->blockid = $idforname[$blockname];
1017 $newinstance->pageid = $page->get_id();
1018 $newinstance->pagetype = $page->get_type();
1019 $newinstance->position = $position;
1020 $newinstance->weight = $weight;
1021 $newinstance->visible = 1;
1022 $newinstance->configdata = '';
1024 if(!empty($newinstance->blockid)) {
1025 // Only add block if it was recognized
1026 insert_record('block_instance', $newinstance);
1027 ++$weight;
1032 return true;
1035 function upgrade_blocks_db($continueto) {
1036 /// This function upgrades the blocks tables, if necessary
1037 /// It's called from admin/index.php
1039 global $CFG, $db;
1041 require_once ($CFG->dirroot .'/blocks/version.php'); // Get code versions
1043 if (empty($CFG->blocks_version)) { // Blocks have never been installed.
1044 $strdatabaseupgrades = get_string('databaseupgrades');
1045 print_header($strdatabaseupgrades, $strdatabaseupgrades,
1046 build_navigation(array(array('name' => $strdatabaseupgrades, 'link' => null, 'type' => 'misc'))), '',
1047 upgrade_get_javascript(), false, '&nbsp;', '&nbsp;');
1049 upgrade_log_start();
1050 print_heading('blocks');
1051 $db->debug=true;
1053 /// Both old .sql files and new install.xml are supported
1054 /// but we priorize install.xml (XMLDB) if present
1055 $status = false;
1056 if (file_exists($CFG->dirroot . '/blocks/db/install.xml')) {
1057 $status = install_from_xmldb_file($CFG->dirroot . '/blocks/db/install.xml'); //New method
1058 } else if (file_exists($CFG->dirroot . '/blocks/db/' . $CFG->dbtype . '.sql')) {
1059 $status = modify_database($CFG->dirroot . '/blocks/db/' . $CFG->dbtype . '.sql'); //Old method
1062 $db->debug = false;
1063 if ($status) {
1064 if (set_config('blocks_version', $blocks_version)) {
1065 notify(get_string('databasesuccess'), 'notifysuccess');
1066 notify(get_string('databaseupgradeblocks', '', $blocks_version), 'notifysuccess');
1067 print_continue($continueto);
1068 print_footer('none');
1069 exit;
1070 } else {
1071 error('Upgrade of blocks system failed! (Could not update version in config table)');
1073 } else {
1074 error('Blocks tables could NOT be set up successfully!');
1078 /// Upgrading code starts here
1079 $oldupgrade = false;
1080 $newupgrade = false;
1081 if (is_readable($CFG->dirroot . '/blocks/db/' . $CFG->dbtype . '.php')) {
1082 include_once($CFG->dirroot . '/blocks/db/' . $CFG->dbtype . '.php'); // defines old upgrading function
1083 $oldupgrade = true;
1085 if (is_readable($CFG->dirroot . '/blocks/db/upgrade.php')) {
1086 include_once($CFG->dirroot . '/blocks/db/upgrade.php'); // defines new upgrading function
1087 $newupgrade = true;
1090 if ($blocks_version > $CFG->blocks_version) { // Upgrade tables
1091 $strdatabaseupgrades = get_string('databaseupgrades');
1092 print_header($strdatabaseupgrades, $strdatabaseupgrades,
1093 build_navigation(array(array('name' => $strdatabaseupgrades, 'link' => null, 'type' => 'misc'))), '', upgrade_get_javascript());
1095 upgrade_log_start();
1096 print_heading('blocks');
1098 /// Run de old and new upgrade functions for the module
1099 $oldupgrade_function = 'blocks_upgrade';
1100 $newupgrade_function = 'xmldb_blocks_upgrade';
1102 /// First, the old function if exists
1103 $oldupgrade_status = true;
1104 if ($oldupgrade && function_exists($oldupgrade_function)) {
1105 $db->debug = true;
1106 $oldupgrade_status = $oldupgrade_function($CFG->blocks_version);
1107 } else if ($oldupgrade) {
1108 notify ('Upgrade function ' . $oldupgrade_function . ' was not available in ' .
1109 '/blocks/db/' . $CFG->dbtype . '.php');
1112 /// Then, the new function if exists and the old one was ok
1113 $newupgrade_status = true;
1114 if ($newupgrade && function_exists($newupgrade_function) && $oldupgrade_status) {
1115 $db->debug = true;
1116 $newupgrade_status = $newupgrade_function($CFG->blocks_version);
1117 } else if ($newupgrade) {
1118 notify ('Upgrade function ' . $newupgrade_function . ' was not available in ' .
1119 '/blocks/db/upgrade.php');
1122 $db->debug=false;
1123 /// Now analyze upgrade results
1124 if ($oldupgrade_status && $newupgrade_status) { // No upgrading failed
1125 if (set_config('blocks_version', $blocks_version)) {
1126 notify(get_string('databasesuccess'), 'notifysuccess');
1127 notify(get_string('databaseupgradeblocks', '', $blocks_version), 'notifysuccess');
1128 print_continue($continueto);
1129 print_footer('none');
1130 exit;
1131 } else {
1132 error('Upgrade of blocks system failed! (Could not update version in config table)');
1134 } else {
1135 error('Upgrade failed! See blocks/version.php');
1138 } else if ($blocks_version < $CFG->blocks_version) {
1139 upgrade_log_start();
1140 notify('WARNING!!! The Blocks version you are using is OLDER than the version that made these databases!');
1142 upgrade_log_finish();
1145 //This function finds all available blocks and install them
1146 //into blocks table or do all the upgrade process if newer
1147 function upgrade_blocks_plugins($continueto) {
1149 global $CFG, $db;
1151 $blocktitles = array();
1152 $invalidblocks = array();
1153 $validblocks = array();
1154 $notices = array();
1156 //Count the number of blocks in db
1157 $blockcount = count_records('block');
1158 //If there isn't records. This is the first install, so I remember it
1159 if ($blockcount == 0) {
1160 $first_install = true;
1161 } else {
1162 $first_install = false;
1165 $site = get_site();
1167 if (!$blocks = get_list_of_plugins('blocks', 'db') ) {
1168 error('No blocks installed!');
1171 include_once($CFG->dirroot .'/blocks/moodleblock.class.php');
1172 if(!class_exists('block_base')) {
1173 error('Class block_base is not defined or file not found for /blocks/moodleblock.class.php');
1176 foreach ($blocks as $blockname) {
1178 if ($blockname == 'NEWBLOCK') { // Someone has unzipped the template, ignore it
1179 continue;
1182 if(!block_is_compatible($blockname)) {
1183 // This is an old-style block
1184 //$notices[] = 'Block '. $blockname .' is not compatible with the current version of Mooodle and needs to be updated by a programmer.';
1185 $invalidblocks[] = $blockname;
1186 continue;
1189 $fullblock = $CFG->dirroot .'/blocks/'. $blockname;
1191 if ( is_readable($fullblock.'/block_'.$blockname.'.php')) {
1192 include_once($fullblock.'/block_'.$blockname.'.php');
1193 } else {
1194 $notices[] = 'Block '. $blockname .': '. $fullblock .'/block_'. $blockname .'.php was not readable';
1195 continue;
1198 $oldupgrade = false;
1199 $newupgrade = false;
1200 if ( @is_dir($fullblock .'/db/')) {
1201 if ( @is_readable($fullblock .'/db/'. $CFG->dbtype .'.php')) {
1202 include_once($fullblock .'/db/'. $CFG->dbtype .'.php'); // defines old upgrading function
1203 $oldupgrade = true;
1205 if ( @is_readable($fullblock .'/db/upgrade.php')) {
1206 include_once($fullblock .'/db/upgrade.php'); // defines new upgrading function
1207 $newupgrade = true;
1211 $classname = 'block_'.$blockname;
1212 if(!class_exists($classname)) {
1213 $notices[] = 'Block '. $blockname .': '. $classname .' not implemented';
1214 continue;
1217 // Here is the place to see if the block implements a constructor (old style),
1218 // an init() function (new style) or nothing at all (error time).
1220 $constructor = get_class_constructor($classname);
1221 if(empty($constructor)) {
1222 // No constructor
1223 $notices[] = 'Block '. $blockname .': class does not have a constructor';
1224 $invalidblocks[] = $blockname;
1225 continue;
1228 $block = new stdClass; // This may be used to update the db below
1229 $blockobj = new $classname; // This is what we 'll be testing
1231 // Inherits from block_base?
1232 if(!is_subclass_of($blockobj, 'block_base')) {
1233 $notices[] = 'Block '. $blockname .': class does not inherit from block_base';
1234 continue;
1237 // OK, it's as we all hoped. For further tests, the object will do them itself.
1238 if(!$blockobj->_self_test()) {
1239 $notices[] = 'Block '. $blockname .': self test failed';
1240 continue;
1242 $block->version = $blockobj->get_version();
1244 if (!isset($block->version)) {
1245 $notices[] = 'Block '. $blockname .': has no version support. It must be updated by a programmer.';
1246 continue;
1249 $block->name = $blockname; // The name MUST match the directory
1250 $blocktitle = $blockobj->get_title();
1252 if ($currblock = get_record('block', 'name', $block->name)) {
1253 if ($currblock->version == $block->version) {
1254 // do nothing
1255 } else if ($currblock->version < $block->version) {
1256 if (empty($updated_blocks)) {
1257 $strblocksetup = get_string('blocksetup');
1258 print_header($strblocksetup, $strblocksetup,
1259 build_navigation(array(array('name' => $strblocksetup, 'link' => null, 'type' => 'misc'))), '',
1260 upgrade_get_javascript(), false, '&nbsp;', '&nbsp;');
1262 $updated_blocks = true;
1263 upgrade_log_start();
1264 print_heading('New version of '.$blocktitle.' ('.$block->name.') exists');
1265 @set_time_limit(0); // To allow slow databases to complete the long SQL
1267 /// Run de old and new upgrade functions for the module
1268 $oldupgrade_function = $block->name .'_upgrade';
1269 $newupgrade_function = 'xmldb_block_' . $block->name .'_upgrade';
1271 /// First, the old function if exists
1272 $oldupgrade_status = true;
1273 if ($oldupgrade && function_exists($oldupgrade_function)) {
1274 $db->debug = true;
1275 $oldupgrade_status = $oldupgrade_function($currblock->version, $block);
1276 } else if ($oldupgrade) {
1277 notify ('Upgrade function ' . $oldupgrade_function . ' was not available in ' .
1278 $fullblock . '/db/' . $CFG->dbtype . '.php');
1281 /// Then, the new function if exists and the old one was ok
1282 $newupgrade_status = true;
1283 if ($newupgrade && function_exists($newupgrade_function) && $oldupgrade_status) {
1284 $db->debug = true;
1285 $newupgrade_status = $newupgrade_function($currblock->version, $block);
1286 } else if ($newupgrade) {
1287 notify ('Upgrade function ' . $newupgrade_function . ' was not available in ' .
1288 $fullblock . '/db/upgrade.php');
1291 $db->debug=false;
1292 /// Now analyze upgrade results
1293 if ($oldupgrade_status && $newupgrade_status) { // No upgrading failed
1295 // Set the block cron on upgrade
1296 $block->cron = !empty($blockobj->cron) ? $blockobj->cron : 0;
1298 // OK so far, now update the block record
1299 $block->id = $currblock->id;
1300 if (! update_record('block', $block)) {
1301 error('Could not update block '. $block->name .' record in block table!');
1303 $component = 'block/'.$block->name;
1304 if (!update_capabilities($component)) {
1305 error('Could not update '.$block->name.' capabilities!');
1308 events_update_definition($component);
1309 notify(get_string('blocksuccess', '', $blocktitle), 'notifysuccess');
1310 } else {
1311 notify('Upgrading block '. $block->name .' from '. $currblock->version .' to '. $block->version .' FAILED!');
1313 echo '<hr />';
1314 } else {
1315 upgrade_log_start();
1316 error('Version mismatch: block '. $block->name .' can\'t downgrade '. $currblock->version .' -> '. $block->version .'!');
1319 } else { // block not installed yet, so install it
1321 // If it allows multiples, start with it enabled
1322 $block->multiple = $blockobj->instance_allow_multiple();
1324 // Set the block cron on install
1325 $block->cron = !empty($blockobj->cron) ? $blockobj->cron : 0;
1327 // [pj] Normally this would be inline in the if, but we need to
1328 // check for NULL (necessary for 4.0.5 <= PHP < 4.2.0)
1329 $conflictblock = array_search($blocktitle, $blocktitles);
1330 if($conflictblock !== false && $conflictblock !== NULL) {
1331 // Duplicate block titles are not allowed, they confuse people
1332 // AND PHP's associative arrays ;)
1333 error('<strong>Naming conflict</strong>: block <strong>'.$block->name.'</strong> has the same title with an existing block, <strong>'.$conflictblock.'</strong>!');
1335 if (empty($updated_blocks)) {
1336 $strblocksetup = get_string('blocksetup');
1337 print_header($strblocksetup, $strblocksetup,
1338 build_navigation(array(array('name' => $strblocksetup, 'link' => null, 'type' => 'misc'))), '',
1339 upgrade_get_javascript(), false, '&nbsp;', '&nbsp;');
1341 $updated_blocks = true;
1342 upgrade_log_start();
1343 print_heading($block->name);
1344 $db->debug = true;
1345 @set_time_limit(0); // To allow slow databases to complete the long SQL
1347 /// Both old .sql files and new install.xml are supported
1348 /// but we priorize install.xml (XMLDB) if present
1349 $status = false;
1350 if (file_exists($fullblock . '/db/install.xml')) {
1351 $status = install_from_xmldb_file($fullblock . '/db/install.xml'); //New method
1352 } else if (file_exists($fullblock .'/db/'. $CFG->dbtype .'.sql')) {
1353 $status = modify_database($fullblock .'/db/'. $CFG->dbtype .'.sql'); //Old method
1354 } else {
1355 $status = true;
1358 $db->debug = false;
1359 if ($status) {
1360 if ($block->id = insert_record('block', $block)) {
1361 $blockobj->after_install();
1362 $component = 'block/'.$block->name;
1363 if (!update_capabilities($component)) {
1364 notify('Could not set up '.$block->name.' capabilities!');
1367 events_update_definition($component);
1368 notify(get_string('blocksuccess', '', $blocktitle), 'notifysuccess');
1369 echo '<hr />';
1370 } else {
1371 error($block->name .' block could not be added to the block list!');
1373 } else {
1374 error('Block '. $block->name .' tables could NOT be set up successfully!');
1378 $blocktitles[$block->name] = $blocktitle;
1381 if(!empty($notices)) {
1382 upgrade_log_start();
1383 foreach($notices as $notice) {
1384 notify($notice);
1388 // Finally, if we are in the first_install of BLOCKS (this means that we are
1389 // upgrading from Moodle < 1.3), put blocks in all existing courses.
1390 if ($first_install) {
1391 upgrade_log_start();
1392 //Iterate over each course
1393 if ($courses = get_records('course')) {
1394 foreach ($courses as $course) {
1395 $page = page_create_object(PAGE_COURSE_VIEW, $course->id);
1396 blocks_repopulate_page($page);
1401 if (!empty($CFG->siteblocksadded)) { /// This is a once-off hack to make a proper upgrade
1402 upgrade_log_start();
1403 $page = page_create_object(PAGE_COURSE_VIEW, SITEID);
1404 blocks_repopulate_page($page);
1405 delete_records('config', 'name', 'siteblocksadded');
1408 upgrade_log_finish();
1410 if (!empty($updated_blocks)) {
1411 print_continue($continueto);
1412 print_footer('none');
1413 die;