blob: 2149355d2210dbf6819275b6c2150d084a1405ce (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
|
<?php
$db = new SQLite3("../database/sqlite.db");
//$hash_db = $db->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... <br>";
for($i=0;$i<count($ar_key); $i++){
if(!in_array($file_name[$ar_key[$i]], $res)){
$file[$cnt] = $file_name[$ar_key[$i]];
$cnt++;
}
}
var_dump($file);
echo "<br><br> Checking for leftover hashs in database... <br>";
foreach($file_name as $file){
if(!in_array($res, $file)){
echo "<br>";
echo $file;
}
}
|
