query("SELECT count(hash) FROM (SELECT DISTINCT hash FROM files WHERE folder='FILE')");
$hash_db = $db->query("SELECT hash FROM (SELECT DISTINCT hash FROM files WHERE folder='FILE')");
$file_name = array_diff(scandir("../files/"), array(".", "..", "README"));
$ar_key = array_keys($file_name);
$file = array();
$cnt=0;
while($hash_ar = $hash_db->fetchArray(SQLITE3_NUM)){
$res[$count] = $hash_ar[0].".gz";
$count++;
}
echo "Checking for leftover hashs in dir...
";
for($i=0;$i
Checking for leftover hashs in database...
";
foreach($file_name as $file){
if(!in_array($res, $file)){
echo "
";
echo $file;
}
}