Commit Diff


commit - a364f4a20c938e57ad4df30b7ceeca0ed06519ab
commit + 0f25f8ec93a197c98f796dbafa12597f31344926
blob - 80a5fbfdb5ab8cf1a50e9baa72835a7a2d63ac8b (mode 755)
blob + /dev/null
--- scripts/member_check.php	
+++ /dev/null	
@@ -1,32 +0,0 @@
-<?php
-$twenty_four = time() - 86400;
-$thirty = time() - (86400 * 30);
-$path = "/var/www/securitx/data/downloads/";
-
-$conn = new PDO('sqlite:/var/www/securitx/data/securitx.db');
-
-/* 24 hour */
-$query = "delete from members where verified = 0 and is_admin = 0 and is_editor = 0 moddate <= $twenty_four";
-$conn->exec($query);
-
-/* 30 days */
-$query = $conn->prepare("select u_key from members where verified = 1 and is_admin = 0 and is_editor = 0 and moddate <= ?");
-$query->execute([$thirty]);
-$results = $query->fetchAll();
-foreach ($results as $result)
-	rm_dir($path . $result['u_key']);
-
-$query = "delete from members where verified = 1 and is_admin = 0 and is_editor = 0 and moddate <= $thirty";
-$conn->exec($query);
-
-function rm_dir($dir) {
-	foreach(scandir($dir) as $file) {
-		if ('.' === $file || '..' === $file)
-			continue;
-		if (is_dir("$dir/$file"))
-		  	rm_dir("$dir/$file");
-		else
-			unlink("$dir/$file");
-	}
-	rmdir($dir);
-}
blob - /dev/null
blob + dd542470914e92f054146b2e8417776a7499f635 (mode 755)
--- /dev/null	
+++ scripts/process_cleanup.php	
@@ -0,0 +1,59 @@
+<?php
+$twenty_four = time() - 86400;
+$five = time() - (86400 * 5);
+$thirty = time() - (86400 * 30);
+$downloads_path = "/var/www/securitx/data/downloads/";
+$uploads_path = "/var/www/securitx/data/uploads/";
+
+$conn = new PDO('sqlite:/var/www/securitx/data/securitx.db');
+
+/* member cleanup */
+/* 24 hour */
+$query = "delete from members where verified = 0 and is_admin = 0 and " .
+    "is_editor = 0 moddate <= $twenty_four";
+$conn->exec($query);
+
+/* 30 days */
+$query = $conn->prepare("select u_key from members where verified = 1 and " .
+    "is_admin = 0 and is_editor = 0 and moddate <= ?");
+$query->execute([$thirty]);
+$results = $query->fetchAll();
+foreach ($results as $result)
+	rm_dir($downloads_path . $result['u_key']);
+
+$query = "delete from members where verified = 1 and is_admin = 0 and " .
+    "is_editor = 0 and moddate <= $thirty";
+$conn->exec($query);
+
+function rm_dir($dir) {
+	foreach(scandir($dir) as $file) {
+		if ('.' === $file || '..' === $file)
+			continue;
+		if (is_dir("$dir/$file"))
+		  	rm_dir("$dir/$file");
+		else
+			unlink("$dir/$file");
+	}
+	rmdir($dir);
+}
+
+/* downloads cleanup */
+$query = $conn->prepare("select * from downloads where moddate <= ?");
+$query->execute([$five]);
+$results = $query->fetchAll();
+foreach ($results as $result) {
+	if ($result['company_id'] != 0) {
+		$query_2 = $conn->prepare("select short from companies where " .
+		    "company_id = ?");
+		$query_2->execute([$result['company_id']]);
+		$fd = $query_2->fetch();
+		unlink($uploads_path . $fd['short'] . "/" . $result['id_key'] .
+		    ".pdf");
+	} else {
+		unlink($downloads_path . $result['u_key'] . "/" .
+		    $result['id_key'] . ".pdf");
+	}
+}
+
+$query = "delete from downloads where moddate <= $five";
+$conn->exec($query);