diff --git a/comp_files.php b/comp_files.php
new file mode 100644
index 0000000..47b7552
--- /dev/null
+++ b/comp_files.php
@@ -0,0 +1,32 @@
+<?php
+
+$found = array();
+$not_found = array();
+
+$db =  new mysqli ( "SPBX-DB002.SpherePBX.com", "tuve", "5558585", "tuve" );
+
+$query = "SELECT file,vid FROM videos";
+
+$res = $db->query($query);
+
+while ($qData = $res->fetch_row()) {
+    if (file_exists("/usr/home/reddawg/r5/red5-server/webapps/oflaDemo/streams/" . $qData[0]))
+      $found[] = $qData[0];
+    else {
+      $query = "UPDATE videos SET status = -1 WHERE vid = " . $qData[1];
+      $db->query($query);
+      $not_found[] = $qData[0];
+    }
+}
+
+
+
+
+print "STATS<br />\n";
+print "Matched: " . count($found) . "<br />\n";
+print "Not Matched: " . count($not_found) . "<br />\n";
+print "END STATS<br />\n<br />\n";
+
+foreach ($not_found as $file)
+  print $file . "<br />\n";
+?>