From bb300c5d38285ea54a0d898023f24ca5d180ea9b Mon Sep 17 00:00:00 2001
From: Michael Foster <savetheinternet@tinyboard.org>
Date: Mon, 19 Aug 2013 01:33:30 +1000
Subject: tools/delete-stray-images.php

---
 tools/delete-stray-images.php | 61 +++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 61 insertions(+)
 create mode 100644 tools/delete-stray-images.php

(limited to 'tools/delete-stray-images.php')

diff --git a/tools/delete-stray-images.php b/tools/delete-stray-images.php
new file mode 100644
index 00000000..cf0dff46
--- /dev/null
+++ b/tools/delete-stray-images.php
@@ -0,0 +1,61 @@
+#!/usr/bin/php
+<?php
+/*
+ *  delete-stray-images.php - there was a period when undoImage() was not working at all. This meant that
+ *  if an error occured while uploading an image, the uploaded images might not have been deleted.
+ *
+ *  This script iterates through every board and deletes any stray files in src/ or thumb/ that don't
+ *  exist in the database.
+ *
+ */
+
+require dirname(__FILE__) . '/inc/cli.php';
+
+
+$boards = listBoards();
+
+foreach ($boards as $board) {
+	echo "/{$board['uri']}/... ";
+	
+	openBoard($board['uri']);
+	
+	$query = query(sprintf("SELECT `file`, `thumb` FROM ``posts_%s`` WHERE `file` IS NOT NULL", $board['uri']));
+	$valid_src = array();
+	$valid_thumb = array();
+	
+	while ($post = $query->fetch(PDO::FETCH_ASSOC)) {
+		$valid_src[] = $post['file'];
+		$valid_thumb[] = $post['thumb'];
+	}
+	
+	$files_src = array_map('basename', glob($board['dir'] . $config['dir']['img'] . '*'));
+	$files_thumb = array_map('basename', glob($board['dir'] . $config['dir']['thumb'] . '*'));
+	
+	$stray_src = array_diff($files_src, $valid_src);
+	$stray_thumb = array_diff($files_thumb, $valid_thumb);
+	
+	$stats = array(
+		'deleted' => 0,
+		'size' => 0
+	);
+	
+	foreach ($stray_src as $src) {
+		$stats['deleted']++;
+		$stats['size'] = filesize($board['dir'] . $config['dir']['img'] . $src);
+		if (!file_unlink($board['dir'] . $config['dir']['img'] . $src)) {
+			$er = error_get_last();
+			die("error: " . $er['message'] . "\n");
+		}
+	}
+		
+	foreach ($stray_src as $thumb) {
+		$stats['deleted']++;
+		$stats['size'] = filesize($board['dir'] . $config['dir']['thumb'] . $thumb);
+		if (!file_unlink($board['dir'] . $config['dir']['thumb'] . $src)) {
+			$er = error_get_last();
+			die("error: " . $er['message'] . "\n");
+		}
+	}
+	
+	echo sprintf("deleted %s files (%s)\n", $stats['deleted'], format_bytes($stats['size']));
+}
-- 
cgit v1.3


From 0e89d39e67ded72bc33552cf692df439b8e963cb Mon Sep 17 00:00:00 2001
From: Michael Foster <savetheinternet@tinyboard.org>
Date: Mon, 19 Aug 2013 01:36:38 +1000
Subject: +x

---
 tools/delete-stray-images.php | 1 -
 1 file changed, 1 deletion(-)
 mode change 100644 => 100755 tools/delete-stray-images.php

(limited to 'tools/delete-stray-images.php')

diff --git a/tools/delete-stray-images.php b/tools/delete-stray-images.php
old mode 100644
new mode 100755
index cf0dff46..a2718dff
--- a/tools/delete-stray-images.php
+++ b/tools/delete-stray-images.php
@@ -11,7 +11,6 @@
 
 require dirname(__FILE__) . '/inc/cli.php';
 
-
 $boards = listBoards();
 
 foreach ($boards as $board) {
-- 
cgit v1.3


From 4562457de7a63b33ca6abb7504161b5a63b3aac9 Mon Sep 17 00:00:00 2001
From: Michael Foster <savetheinternet@tinyboard.org>
Date: Mon, 19 Aug 2013 01:48:40 +1000
Subject: typo

---
 tools/delete-stray-images.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'tools/delete-stray-images.php')

diff --git a/tools/delete-stray-images.php b/tools/delete-stray-images.php
index a2718dff..cf94dfe5 100755
--- a/tools/delete-stray-images.php
+++ b/tools/delete-stray-images.php
@@ -47,10 +47,10 @@ foreach ($boards as $board) {
 		}
 	}
 		
-	foreach ($stray_src as $thumb) {
+	foreach ($stray_thumb as $thumb) {
 		$stats['deleted']++;
 		$stats['size'] = filesize($board['dir'] . $config['dir']['thumb'] . $thumb);
-		if (!file_unlink($board['dir'] . $config['dir']['thumb'] . $src)) {
+		if (!file_unlink($board['dir'] . $config['dir']['thumb'] . $thumb)) {
 			$er = error_get_last();
 			die("error: " . $er['message'] . "\n");
 		}
-- 
cgit v1.3