was renamed for security reasons

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

diff --git a/scripts/delete_orphan_files.php b/scripts/delete_orphan_files.php
index 5e6c2633a8510553d35cd7c5b23a748d3ec70ec8..861e958fb544d7e90ddb89692465d3d76e0ff3b6 100755 (executable)
--- a/scripts/delete_orphan_files.php
+++ b/scripts/delete_orphan_files.php
@@ -18,7 +18,8 @@
  * along with this program.  If not, see <http://www.gnu.org/licenses/>.
  */
 
-define('INSTALLDIR', realpath(dirname(__FILE__) . '/..'));
+define('INSTALLDIR', dirname(__DIR__));
+define('PUBLICDIR', INSTALLDIR . DIRECTORY_SEPARATOR . 'public');
 
 $shortoptions = 'y';
 $longoptions = array('yes');
@@ -33,22 +34,32 @@ 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';
+require_once INSTALLDIR.'/scripts/commandline.inc.php';
 
 print "Finding File entries that are not related to a Notice (or the notice has been deleted)...";
 $file = new File();
-$sql = 'SELECT 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_id)'.
-            ' OR NOT EXISTS (SELECT notice.id FROM notice WHERE notice.id=post_id);';
+            ' 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)'.
+            ' GROUP BY file.id;';
 
-print " {$file->N} found.\n";
-if ($file->N == 0) {
-    exit(0);
+if ($file->query($sql) !== false) {
+    print " {$file->N} found.\n";
+    if ($file->N == 0) {
+        exit(0);
+    }
+} else {
+    print "FAILED";
+    exit(1);
 }
+
 if (!have_option('y', 'yes')) {
     print "About to delete the entries along with locally stored files. Are you sure? [y/N] ";
     $response = fgets(STDIN);
@@ -57,18 +68,17 @@ if (!have_option('y', 'yes')) {
         exit(0);
     }
 }
-if ($file->query($sql) !== false) {
-    print "\nDeleting: ";
-    while ($file->fetch()) {
-        try {
-            $file->getPath();
-            $file->delete();
-            print 'x';
-        } catch (Exception $e) {
-            // either FileNotFound exception or ClientException
-            $file->delete();
-            print '.';
-        }
+
+print "\nDeleting: ";
+while ($file->fetch()) {
+    try {
+        $file->getPath();
+        $file->delete();
+        print 'x';
+    } catch (Exception $e) {
+        // either FileNotFound exception or ClientException
+        $file->delete();
+        print '.';
     }
 }
 print "\nDONE.\n";