From d0857bc2803f3c223d7331c8770aedcbc4b310a2 Mon Sep 17 00:00:00 2001
From: root
Date: Mon, 28 Apr 2014 10:12:33 +0200
Subject: Unimportant changes #1

---
 www/check.hash.php | 35 +++++++++++++++++++++++++++++++++++
 1 file changed, 35 insertions(+)
 create mode 100644 www/check.hash.php

(limited to 'www/check.hash.php')

diff --git a/www/check.hash.php b/www/check.hash.php
new file mode 100644
index 0000000..2149355
--- /dev/null
+++ b/www/check.hash.php
@@ -0,0 +1,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;
+	}
+}
-- 
cgit v1.2.3