From 359a097cb7c6db8bde320fdfd95e81c62424efb7 Mon Sep 17 00:00:00 2001
From: Tim Starling <tstarling@users.mediawiki.org>
Date: Thu, 9 Oct 2008 02:26:49 +0000
Subject: [PATCH] Image integrity checker

---
 maintenance/checkImages.php | 45 +++++++++++++++++++++++++++++++++++++
 1 file changed, 45 insertions(+)
 create mode 100644 maintenance/checkImages.php

diff --git a/maintenance/checkImages.php b/maintenance/checkImages.php
new file mode 100644
index 0000000000..534c5c28e3
--- /dev/null
+++ b/maintenance/checkImages.php
@@ -0,0 +1,45 @@
+<?php
+
+require( 'commandLine.inc' );
+
+$batchSize = 1000;
+$start = '';
+$dbr = wfGetDB( DB_SLAVE );
+$localRepo = RepoGroup::singleton()->getLocalRepo();
+
+$numImages = 0;
+$numGood = 0;
+
+do {
+	$res = $dbr->select( 'image', '*', array( 'img_name > ' . $dbr->addQuotes( $start ) ) );
+	foreach ( $res as $row ) {
+		$numImages++;
+		$start = $row->img_name;
+		$file = $localRepo->newFileFromRow( $row );
+		$path = $file->getPath();
+		if ( !$path ) {
+			echo "{$row->img_name}: not locally accessible\n";
+			continue;
+		}
+		$stat = @stat( $file->getPath() );
+		if ( !$stat ) {
+			echo "{$row->img_name}: missing\n";
+			continue;
+		}
+
+		if ( $stat['size'] == 0 && $row->img_size != 0 ) {
+			echo "{$row->img_name}: truncated, was {$row->img_size}\n";
+			continue;
+		}
+
+		if ( $stat['size'] != $row->img_size ) {
+			echo "{$row->img_name}: size mismatch DB={$row->img_size}, actual={$row->img_size}\n";
+			continue;
+		}
+
+		$numGood++;
+	}
+
+} while ( $res->numRows() );
+
+echo "Good images: $numGood/$numImages\n";
-- 
2.20.1