123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990 |
- <?php
- define('INSTALLDIR', dirname(__DIR__, 3));
- define('PUBLICDIR', INSTALLDIR . DIRECTORY_SEPARATOR . 'public');
- $shortoptions = 'l::a::i';
- $longoptions = ['limit=', 'all', 'image'];
- $helptext = <<<END_OF_HELP
- remove_remote_media.php [options]
- Removes remote media. In most cases, (if not all), an URL will be kept for the original attachment.
- In case the attachment is an image its thumbs will be removed as well.
- -l --limit [date] This is a timestamp, format is: yyyy-mm-dd (optional time hh:mm:ss may be provided)
- -a --all By default only remote attachments will be deleted, by using this flag you will remove oembed previews and alike
- -i --image Remove image only attachments (will ignore oembed previews and alike)
- END_OF_HELP;
- require_once INSTALLDIR . '/scripts/commandline.inc';
- $quiet = have_option('q', 'quiet');
- $include_previews = have_option('a', 'all');
- $image_only = have_option('i', 'image');
- if (!have_option('l', 'limit')) {
- echo "You must provide a limit!\n\n";
- show_help();
- exit(1);
- }
- $max_date = get_option_value('l', 'limit');
- if (empty($max_date)) {
- echo "Invalid empty limit!";
- exit(1);
- }
- $query = "
- SELECT DISTINCT
- file_to_post.file_id
- FROM
- file_to_post
- INNER JOIN
- file ON file.id = file_to_post.file_id
- INNER JOIN
- notice ON notice.id = file_to_post.post_id
- WHERE
- notice.is_local = 0 ";
- $query .= $image_only ? " AND file.width IS NOT NULL AND file.height IS NOT NULL " : "";
- $query .= $include_previews ? "" : " AND file.filehash IS NOT NULL ";
- $query .= " AND notice.modified <= '{$max_date}' ORDER BY notice.modified ASC";
- $fn = new DB_DataObject();
- $fn->query($query);
- while ($fn->fetch()) {
- $file = File::getByID($fn->file_id);
- $file_info_id = $file->getID();
-
- $file->delete();
- if (!$quiet) {
- echo "Deleted file with id: {$file_info_id}\n";
- }
- }
|