commit 0f25f8ec93a197c98f796dbafa12597f31344926 from: Tracey Emery date: Wed May 11 16:29:31 2022 UTC update cleanup script to include files commit - a364f4a20c938e57ad4df30b7ceeca0ed06519ab commit + 0f25f8ec93a197c98f796dbafa12597f31344926 blob - 80a5fbfdb5ab8cf1a50e9baa72835a7a2d63ac8b (mode 755) blob + /dev/null --- scripts/member_check.php +++ /dev/null @@ -1,32 +0,0 @@ -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 @@ +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);