[Summary view]

Differences Between: [Versions 310 and 400] [Versions 311 and 400] [Versions 39 and 400] [Versions 400 and 401] [Versions 400 and 402] [Versions 400 and 403]

   1  <?php
   2  // This file is part of Moodle - http://moodle.org/
   3  //
   4  // Moodle is free software: you can redistribute it and/or modify
   5  // it under the terms of the GNU General Public License as published by
   6  // the Free Software Foundation, either version 3 of the License, or
   7  // (at your option) any later version.
   8  //
   9  // Moodle is distributed in the hope that it will be useful,
  10  // but WITHOUT ANY WARRANTY; without even the implied warranty of
  11  // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  12  // GNU General Public License for more details.
  13  //
  14  // You should have received a copy of the GNU General Public License
  15  // along with Moodle.  If not, see <http://www.gnu.org/licenses/>.
  16  
  17  /**
  18   * This file keeps track of upgrades to the recentlyaccesseditems block
  19   *
  20   * Sometimes, changes between versions involve alterations to database structures
  21   * and other major things that may break installations.
  22   *
  23   * The upgrade function in this file will attempt to perform all the necessary
  24   * actions to upgrade your older installation to the current version.
  25   *
  26   * If there's something it cannot do itself, it will tell you what you need to do.
  27   *
  28   * The commands in here will all be database-neutral, using the methods of
  29   * database_manager class
  30   *
  31   * Please do not forget to use upgrade_set_timeout()
  32   * before any action that may take longer time to finish.
  33   *
  34   * @package block_recentlyaccesseditems
  35   * @copyright 2019 Peter Dias
  36   * @license   http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  37   */
  38  
  39  defined('MOODLE_INTERNAL') || die();
  40  
  41  require_once("{$CFG->libdir}/db/upgradelib.php");
  42  
  43  /**
  44   * Upgrade the recentlyaccesseditems db table.
  45   *
  46   * @param $oldversion
  47   * @return bool
  48   */
  49  function xmldb_block_recentlyaccesseditems_upgrade($oldversion, $block) {
  50      global $DB;
  51  
  52      // Automatically generated Moodle v3.7.0 release upgrade line.
  53      // Put any upgrade step following this.
  54      if ($oldversion < 2019052001) {
  55          // Query the items to be deleted as a list of IDs. We cannot delete directly from this as a
  56          // subquery because MySQL does not support delete with subqueries.
  57          $fordeletion = $DB->get_fieldset_sql("
  58                  SELECT rai.id
  59                    FROM {block_recentlyaccesseditems} rai
  60               LEFT JOIN {course} c ON c.id = rai.courseid
  61               LEFT JOIN {course_modules} cm ON cm.id = rai.cmid
  62                   WHERE c.id IS NULL OR cm.id IS NULL");
  63  
  64          // Delete the array in chunks of 500 (Oracle does not support more than 1000 parameters,
  65          // let's leave some leeway, there are likely only one chunk anyway).
  66          $chunks = array_chunk($fordeletion, 500);
  67          foreach ($chunks as $chunk) {
  68              $DB->delete_records_list('block_recentlyaccesseditems', 'id', $chunk);
  69          }
  70  
  71          upgrade_block_savepoint(true, 2019052001, 'recentlyaccesseditems', false);
  72      }
  73  
  74      // Automatically generated Moodle v3.8.0 release upgrade line.
  75      // Put any upgrade step following this.
  76  
  77      // Automatically generated Moodle v3.9.0 release upgrade line.
  78      // Put any upgrade step following this.
  79  
  80      if ($oldversion < 2022030200) {
  81          // Update all recentlyaccesseditems blocks in the my-index to be in the main side-post region.
  82          upgrade_block_set_defaultregion('recentlyaccesseditems', '__default', 'my-index', 'side-post');
  83          upgrade_block_savepoint(true, 2022030200, 'recentlyaccesseditems', false);
  84      }
  85  
  86      if ($oldversion < 2022041901) {
  87          upgrade_block_set_my_user_parent_context('recentlyaccesseditems', '__default', 'my-index');
  88          upgrade_block_savepoint(true, 2022041901, 'recentlyaccesseditems', false);
  89      }
  90  
  91      // Automatically generated Moodle v4.0.0 release upgrade line.
  92      // Put any upgrade step following this.
  93  
  94      return true;
  95  }