File Manager

X7ROOT File Manager

Current Path: /home/cbholdings/pasukulu/lib/classes/task

home / cbholdings / pasukulu / lib / classes / task /

📁 ..
📄 adhoc_task.php(4.81 KB)
📄 analytics_cleanup_task.php(1.73 KB)
📄 antivirus_cleanup_task.php(1.91 KB)
📄 asynchronous_backup_task.php(3.45 KB)
📄 asynchronous_copy_task.php(9.07 KB)
📄 asynchronous_restore_task.php(3.63 KB)
📄 automated_backup_task.php(1.65 KB)
📄 backup_cleanup_task.php(3.01 KB)
📄 badges_cron_task.php(3.14 KB)
📄 badges_message_task.php(2.17 KB)
📄 blog_cron_task.php(2.16 KB)
📄 build_installed_themes_task.php(1.73 KB)
📄 cache_cleanup_task.php(1.38 KB)
📄 cache_cron_task.php(1.33 KB)
📄 calendar_cron_task.php(2.67 KB)
📄 calendar_fix_orphaned_events.php(2.63 KB)
📄 check_for_updates_task.php(1.6 KB)
📄 clean_up_deleted_search_area_task.php(1.71 KB)
📄 complete_plans_task.php(1.89 KB)
📄 completion_daily_task.php(8.03 KB)
📄 completion_regular_task.php(2.21 KB)
📄 context_cleanup_task.php(1.64 KB)
📄 course_backup_task.php(4.05 KB)
📄 create_contexts_task.php(1.54 KB)
📄 database_logger.php(5.55 KB)
📄 delete_incomplete_users_task.php(2.58 KB)
📄 delete_unconfirmed_users_task.php(2.12 KB)
📄 file_temp_cleanup_task.php(4.36 KB)
📄 file_trash_cleanup_task.php(1.44 KB)
📄 fix_file_timestamps_task.php(1.26 KB)
📄 grade_cron_task.php(3.15 KB)
📄 grade_history_cleanup_task.php(2.09 KB)
📄 h5p_clean_orphaned_records_task.php(2.44 KB)
📄 h5p_get_content_types_task.php(2.21 KB)
📄 legacy_plugin_cron_task.php(7.59 KB)
📄 logging_trait.php(3.13 KB)
📄 logmanager.php(9.82 KB)
📄 manager.php(60.63 KB)
📄 messaging_cleanup_task.php(2.72 KB)
📄 password_reset_cleanup_task.php(1.95 KB)
📄 plagiarism_cron_task.php(2.26 KB)
📄 portfolio_cron_task.php(2.91 KB)
📄 question_preview_cleanup_task.php(2.83 KB)
📄 question_stats_cleanup_task.php(1.9 KB)
📄 refresh_mod_calendar_events_task.php(2.74 KB)
📄 registration_cron_task.php(1.37 KB)
📄 scheduled_task.php(16.4 KB)
📄 search_index_task.php(2.27 KB)
📄 search_optimize_task.php(1.76 KB)
📄 send_failed_login_notifications_task.php(8.11 KB)
📄 send_login_notifications.php(4.22 KB)
📄 send_new_user_passwords_task.php(3.33 KB)
📄 session_cleanup_task.php(1.76 KB)
📄 stats_cron_task.php(2 KB)
📄 sync_plans_from_template_cohorts_task.php(2.24 KB)
📄 tag_cron_task.php(11.28 KB)
📄 task_base.php(7.8 KB)
📄 task_lock_cleanup_task.php(1.53 KB)
📄 task_log_cleanup_task.php(1.64 KB)
📄 task_logger.php(2.36 KB)

Editing: h5p_clean_orphaned_records_task.php

<?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/>.

namespace core\task;

/**
 * A schedule task to clean orphaned h5p records (for example for deleted activity).
 *
 * @package    core_h5p
 * @copyright  2021 Ilya Tregubov <ilya@moodle.com>
 * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 */
class h5p_clean_orphaned_records_task extends scheduled_task {

/**
     * Get a descriptive name for this task (shown to admins).
     *
     * @return string
     */
    public function get_name() {
        return get_string('taskh5pcleanup', 'admin');
    }

/**
     * Execute the task.
     */
    public function execute() {
        global $DB;

$sql = "SELECT h5p.id
                  FROM {h5p} h5p
             LEFT JOIN {files} f
                    ON f.pathnamehash = h5p.pathnamehash
                 WHERE f.pathnamehash IS NULL";

$orphanedrecords = $DB->get_recordset_sql($sql);

foreach ($orphanedrecords as $orphanedrecord) {

$sql = "SELECT f.id, f.pathnamehash
                      FROM {files} f
                     WHERE f.itemid = :itemid
                       AND f.filearea = :filearea
                       AND f.component = :component";
            $params = ['itemid' => $orphanedrecord->id, 'filearea' => 'content', 'component' => 'core_h5p'];
            $filerecords = $DB->get_recordset_sql($sql, $params);

foreach ($filerecords as $filerecord) {
                $fs = get_file_storage();
                $file = $fs->get_file_by_hash($filerecord->pathnamehash);
                if ($file) {
                    $file->delete();
                }
            }

$DB->delete_records('h5p', ['id' => $orphanedrecord->id]);
            $DB->delete_records('h5p_contents_libraries', ['h5pid' => $orphanedrecord->id]);
        }

}
}

X7ROOT File Manager

Editing: h5p_clean_orphaned_records_task.php

Upload File

Create Folder