File Manager

X7ROOT File Manager

Current Path: /home/cbholdings/pasukulu/mod/data/db

home / cbholdings / pasukulu / mod / data / db /

📁 ..
📄 access.php(6.83 KB)
📄 install.xml(8.02 KB)
📄 log.php(1.63 KB)
📄 services.php(5.58 KB)
📄 subplugins.json(114 B)
📄 tag.php(1.13 KB)
📄 upgrade.php(2.31 KB)

Editing: upgrade.php

<?php
// This file keeps track of upgrades to
// the data module
//
// Sometimes, changes between versions involve
// alterations to database structures and other
// major things that may break installations.
//
// The upgrade function in this file will attempt
// to perform all the necessary actions to upgrade
// your older installation to the current version.
//
// If there's something it cannot do itself, it
// will tell you what you need to do.
//
// The commands in here will all be database-neutral,
// using the methods of database_manager class
//
// Please do not forget to use upgrade_set_timeout()
// before any action that may take longer time to finish.

defined('MOODLE_INTERNAL') || die();

function xmldb_data_upgrade($oldversion) {
    global $DB;

$dbman = $DB->get_manager(); // Loads ddl manager and xmldb classes.

// Automatically generated Moodle v3.9.0 release upgrade line.
    // Put any upgrade step following this.

// Automatically generated Moodle v4.0.0 release upgrade line.
    // Put any upgrade step following this.
    if ($oldversion < 2022081600) {
        // Define key userid (foreign) to be added to data_records.
        $table = new xmldb_table('data_records');
        $key = new xmldb_key('userid', XMLDB_KEY_FOREIGN, ['userid'], 'user', ['id']);
        // Launch add key userid.
        $dbman->add_key($table, $key);

// Data savepoint reached.
        upgrade_mod_savepoint(true, 2022081600, 'data');
    }

// Automatically generated Moodle v4.1.0 release upgrade line.
    // Put any upgrade step following this.

// Automatically generated Moodle v4.2.0 release upgrade line.
    // Put any upgrade step following this.

if ($oldversion < 2023042401) {
        // Clean orphan data_records.
        $sql = "SELECT d.id FROM {data} d
            LEFT JOIN {data_fields} f ON d.id = f.dataid
            WHERE f.id IS NULL";
        $emptydatas = $DB->get_records_sql($sql);
        if (!empty($emptydatas)) {
            $dataids = array_keys($emptydatas);
            list($datainsql, $dataparams) = $DB->get_in_or_equal($dataids, SQL_PARAMS_NAMED, 'data');
            $DB->delete_records_select('data_records', "dataid $datainsql", $dataparams);
        }

// Data savepoint reached.
        upgrade_mod_savepoint(true, 2023042401, 'data');
    }

return true;
}

X7ROOT File Manager

Editing: upgrade.php

Upload File

Create Folder