C:/xampp/htdocs/moodle/blocks/navigation/db/upgrade.php

Go to the documentation of this file.

<?php

// This file is part of Moodle - http://moodle.org/
//
// Moodle is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
//
// Moodle is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with Moodle.  If not, see <http://www.gnu.org/licenses/>.

function xmldb_block_navigation_upgrade($oldversion, $block) {
    global $DB;
    // Implemented at 2009082800

    if ($oldversion < 2010091400) {

        $sql = "SELECT bp.id FROM {block_instances} bi 
                LEFT JOIN {block_positions} bp ON bp.blockinstanceid=bi.id
                WHERE bi.blockname='navigation' AND bp.visible=0";
        $blockpositions = $DB->get_records_sql($sql);
        if ($blockpositions) {
            foreach ($blockpositions as $bp) {
                $bp->visible = 1;
                $DB->update_record('block_positions', $bp);
            }
        }

        upgrade_block_savepoint(true, 2010091400, 'navigation');
    }

    // Moodle v2.1.0 release upgrade line
    // Put any upgrade step following this

    // Moodle v2.2.0 release upgrade line
    // Put any upgrade step following this

    return true;
}