[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   * Plugin upgrade code
  19   *
  20   * @package    tool_cohortroles
  21   * @copyright  2020 Paul Holden <paulh@moodle.com>
  22   * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  23   */
  24  
  25  defined('MOODLE_INTERNAL') || die();
  26  
  27  /**
  28   * Function to upgrade tool_cohortroles.
  29   *
  30   * @param int $oldversion the version we are upgrading from
  31   * @return bool result
  32   */
  33  function xmldb_tool_cohortroles_upgrade($oldversion) {
  34      global $DB;
  35  
  36      if ($oldversion < 2020020600) {
  37          // Delete any tool_cohortroles mappings for roles which no longer exist.
  38          $DB->delete_records_select('tool_cohortroles', 'roleid NOT IN (SELECT id FROM {role})');
  39  
  40          // Cohortroles savepoint reached.
  41          upgrade_plugin_savepoint(true, 2020020600, 'tool', 'cohortroles');
  42      }
  43  
  44      // Automatically generated Moodle v3.9.0 release upgrade line.
  45      // Put any upgrade step following this.
  46  
  47      // Automatically generated Moodle v4.0.0 release upgrade line.
  48      // Put any upgrade step following this.
  49  
  50      if ($oldversion < 2022041901) {
  51          // Delete any tool_cohortroles mappings for users who no longer exist.
  52          $DB->delete_records_select('tool_cohortroles', 'userid NOT IN (SELECT id FROM {user} WHERE deleted = 0)');
  53  
  54          // Cohortroles savepoint reached.
  55          upgrade_plugin_savepoint(true, 2022041901, 'tool', 'cohortroles');
  56      }
  57  
  58      return true;
  59  }