Create a task to clean up unused H5P content

Create a label in a course Upload an H5P file using the Atto button Save the label Access to the course to view the H5P content inside the label. Remove the label. Run cron php admin cli/cron.php Ensure you can find H5PID of activity to be deleted by running SELECT h5p.id, h5p.pathnamehash FROM mdl_h5p h5p LEFT JOIN mdl_files f on f.pathnamehash = h5p.pathnamehash WHERE f.pathnamehash is null ; Ensure you can find files that will be deleted by running (compose comma separated list COMMASEPARATEDIDLIST from result like 3,5,56 etc) SELECT id from mdl_files WHERE itemid = H5PID and filearea = 'content' AND component = 'core_h5p' ; Run cleanup cron task php admin/cli/scheduled_task.php --execute= '\core\task\h5p_clean_orphaned_records_task' Ensure this sql returns no records: SELECT h5p.id, h5p.pathnamehash FROM mdl_h5p h5p LEFT JOIN mdl_files f on f.pathnamehash = h5p.pathnamehash WHERE f.pathnamehash is null ; Ensure that files are actually deleted so the following query return empty set SELECT * FROM mdl_files WHERE id IN [COMMASEPARATEDIDLIST]; Go to course recycle bin (click cog on course page, then Recycle bin) Restore your label Ensure restored label has h5p content Delete the course Run cron php admin cli/cron.php Run cleanup cron task php admin/cli/scheduled_task.php --execute= '\core\task\h5p_clean_orphaned_records_task' Restore the course from recycle bin (in category administration) Ensure label is still available and shows h5p content