General help

Please see:

https://docs.moodle.org/35/en/Recycle_bin

and it has carried forward to 3.9/3.10 so

https://docs.moodle.org/310/en/Recycle_bin

Have been bit by recyclebin ... so now I have it displayed by default in course (course admin menu) and set time to keep to lowest (least time) values.

As far as I know, there is no admin tool to show orphaned files ... exist in moodledata/filedir/ but not in mdl_files table ... nor vice versa ... so you might need to use moosh (even if you don't like it) cause it does have a command to find orphaned files.

Yeah, I know ... with the new file system since version 2.0 of Moodle, such things are not supposed to happen ... but ... things happen! :|

'SoS', Ken

Update 1

The delete_course function actually makes the course go to the trash-bin. And the cron functions i listed run once a day, not once a week. So, cleaning the trash-bin did nothing, because it uses the trash-bin config to know the time the files are on the trash-bin. (Ashamed of missing this part)

I updated the script on the post to empty the category trash-bin and then run the cron function to clear the trashdir. 

<?php
define('CLI_SCRIPT', true);

//Load required files
require_once(__DIR__.'/../../../config.php');
require_once($CFG->libdir . '/filelib.php');
require_once($CFG->libdir . '/filestorage/file_system.php');
require_once($CFG->libdir . '/filestorage/file_system_filedir.php');

// Define cliscript user -- Required to empty the bin

\core\session\manager::init_empty_session();
\core\session\manager::set_user($DB->get_record('user', ['id' => 2]));
$categories = [...];
//Prepare and load courses
$categories_list = implode(', ', $categories);
$courses = $DB->get_records_sql("SELECT mco.id, mco.fullname, mcc.name
                                   FROM {course} mco, {course_categories} mcc
                                   WHERE mcc.id = mco.category AND category IN ($categories_list)");
$ammount = sizeof($courses);
$item = 1;

//Do the stuff
foreach($courses as $key => $course){
    try{
        echo "Category $course->name -- Course $course->fullname $item / $ammount \n";
        delete_course($course->id);
        $item++;
    } catch(Exception $e) { }
}

//Clear the category trash
foreach($categories as $category){
    try{
        $context = context_coursecat::instance($category);
        $recyclebin = new \tool_recyclebin\category_bin($context->instanceid);
        $recyclebin->delete_all_items();
    } catch(Exception $e) { }
}

//Delete files on the dir
$fs = new file_system_filedir();
$fs->cron();

----------------

I also wrote a script to search an delete files that exist on disk and do not exist on the files table on the database. Somehow i had more than a hundred files on this state.

<?php

define('CLI_SCRIPT', true);

require_once(__DIR__.'/../../../config.php');

$first_level_flders = glob($CFG->dataroot . '/filedir/*' );

foreach($first_level_flders as $firstlevel){
    $second_level_folders = glob("$firstlevel/*");
    $x16sequence_first = end(explode('/', $firstlevel));
    
    foreach($second_level_folders as $secondlevel){
        $x16sequence_last = end(explode('/', $secondlevel));
        
        // Remove the path of the files
        $files = array_map(
            function($file){
                return end(explode('/', $file));
            }, glob("$secondlevel/*"));

        //Load files from database
        $filepaths = "'" . rtrim( implode("', '", $files), ", '" ) . "'";
        $files_on_database = array_keys(
            $DB->get_records_sql( "SELECT contenthash
            FROM {files}
            WHERE contenthash IN ($filepaths)" ) );

        $orphans =  array_diff($files, $files_on_database);

        foreach($orphans as $orphan){
            echo "Removing Orphan:\n   ".$CFG->dataroot . "/filedir/$x16sequence_first/$x16sequence_last/$orphan \n";
            unlink($CFG->dataroot . "/filedir/$x16sequence_first/$x16sequence_last/$orphan");
        }

    }
}