Make the Link header give URI for WebFinger lookup

[quix0rs-gnu-social.git] / scripts / delete_orphan_files.php

diff --git a/scripts/delete_orphan_files.php b/scripts/delete_orphan_files.php
index aa3046855f4255287fc541f79787b0254678aba1..2c49c10a508d468f5e859df0a437bf789d5b63d7 100755 (executable)
--- a/scripts/delete_orphan_files.php
+++ b/scripts/delete_orphan_files.php
@@ -33,17 +33,21 @@ attached files weren't removed as well.
 
 Will print '.' for each deleted File entry and 'x' if it also had a locally stored file.
 
+WARNING WARNING WARNING, this will also delete Qvitter files such as background etc. since
+they are not linked to notices (yet anyway).
+
 END_OF_HELP;
 
 require_once INSTALLDIR.'/scripts/commandline.inc';
 
 print "Finding File entries that are not related to a Notice (or the notice has been deleted)...";
 $file = new File();
-$sql = 'SELECT file.id FROM file'.
-        ' JOIN file_to_post ON file_to_post.file_id=file.id'.
+$sql = 'SELECT file.* FROM file'.
+        ' LEFT JOIN file_to_post ON file_to_post.file_id=file.id'.
         ' WHERE'.
             ' NOT EXISTS (SELECT file_to_post.file_id FROM file_to_post WHERE file.id=file_to_post.file_id)'.
-            ' OR NOT EXISTS (SELECT notice.id FROM notice WHERE notice.id=file_to_post.post_id);';
+            ' OR NOT EXISTS (SELECT notice.id FROM notice WHERE notice.id=file_to_post.post_id)'.
+            ' GROUP BY file.id;';
 
 if ($file->query($sql) !== false) {
     print " {$file->N} found.\n";