diff options
author | Andreas Unterkircher <unki@netshadow.at> | 2008-01-13 15:28:45 +0100 |
---|---|---|
committer | Andreas Unterkircher <unki@netshadow.at> | 2008-01-13 15:28:45 +0100 |
commit | c1820df7b1f282211fc6554190b0aab600001ced (patch) | |
tree | 57521db26f083bf67d56749eaf1cf580ad18e2a6 /find_dups.php | |
parent | 71a8a6ede751e757c8ef205d8d7c87f8d8fb391c (diff) |
issue98, php script to locate duplicate images
Signed-off-by: Andreas Unterkircher <unki@netshadow.at>
Diffstat (limited to 'find_dups.php')
-rwxr-xr-x | find_dups.php | 56 |
1 files changed, 56 insertions, 0 deletions
diff --git a/find_dups.php b/find_dups.php new file mode 100755 index 0000000..32b95f4 --- /dev/null +++ b/find_dups.php @@ -0,0 +1,56 @@ +#!/usr/bin/php +<?php + +/*************************************************************************** + * + * Copyright (c) by Andreas Unterkircher, unki@netshadow.at + * All rights reserved + * + * This program is free software; you can redistribute it and/or modify + * it under the terms of the GNU General Public License as published by + * the Free Software Foundation; either version 2 of the License, or + * any later version. + * + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU General Public License for more details. + * + * You should have received a copy of the GNU General Public License + * along with this program; if not, write to the Free Software + * Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA. + * + ***************************************************************************/ + +if(!isset($_SERVER["TERM"])) { + print "<br /><br />This script should only be invoked from command line!<br />\n"; + die; +} + +require_once "phpfspot.class.php"; + +$fspot = new PHPFSPOT; +$fspot->fromcmd = true; + +$all_dups = $fspot->cfg_db->db_query(" + SELECT i1.img_idx as i1, i2.img_idx as i2 + FROM images i1 + INNER JOIN images i2 + ON ( + i1.img_md5=i2.img_md5 + AND + i1.img_idx!=i2.img_idx + ) + ORDER BY i1.img_idx ASC +"); + +while($row = $fspot->cfg_db->db_fetch_object($all_dups)) { + if($photo1 = $fspot->getphotoname($row['i1'])) { + print "Dups for ". $photo1 ."\n"; + if($photo2 = $fspot->getphotoname($row['i2'])) { + print "\t". $photo2 ."\n"; + } + } +} + +?> |