';


$sql = "SELECT * FROM ".DB_PREPEND."phpwcms_file WHERE f_hash='' AND f_kid=1";
$result = mysql_query($sql, $db);
$total = mysql_num_rows($result);

echo 'TOTAL: '.$total." ENTRIES\n";
echo '=================================================================

If last line number is  < '.$total.'  click here'."\n\n";

$linenumber = 1;
$format     = '%0'.(strlen(strval($total))).'d: ';

while($row = mysql_fetch_assoc($result)) {
	
	$error = false;
	
	echo sprintf($format, $linenumber);

	$fileHash = md5( $row['f_name'] . microtime() );
	$fileOld  = PHPWCMS_ROOT.$phpwcms["file_path"].$row['f_uid'].'/'.$row['f_uid'].'_'.$row['f_id'];
	$fileNew  = PHPWCMS_ROOT.$phpwcms["file_path"].$fileHash;
	if($row['f_ext'] != '') {
		$fileOld .=  '.'.$row['f_ext'];
		$fileNew .=  '.'.$row['f_ext'];
	}
	if(file_exists($fileOld)) {
		if(@copy($fileOld, $fileNew)) {
			$update  = "UPDATE ".DB_PREPEND."phpwcms_file SET ";
			$update .= "f_thumb_list = '', ";
			$update .= "f_thumb_preview = '', ";
			$update .= "f_hash = '".$fileHash."' ";
			$update .= "WHERE f_id=".$row['f_id'];
			if(mysql_query($update, $db)) {
				unlink($fileOld);
			} else {
				$error = 1;
			}
		} else {
			$error = 2;
		}
	
		if($error) {
			echo 'ERROR('.$error.'): ' .$fileOld .' -> ' . $fileNew ."\n";
		} else {
			echo 'SUCCESS: ' .$fileOld .' -> ' . $fileNew ."\n";
		}
	
	} else {
	
		@mysql_query("DELETE FROM ".DB_PREPEND."phpwcms_file WHERE f_kid=1 AND f_id=".$row['f_id']." LIMIT 1", $db);
		echo 'DELETED: ' . $fileOld ."\n";
	
	}
	
	flush();
	$linenumber++;

}

echo '