prepare('SELECT f.id FROM files f WHERE f.id = ? AND f.extension = ? AND f.id NOT IN (SELECT id FROM file_bans) '); $stmt->execute([$file_id, $file_ext]); $file = $stmt->fetch(PDO::FETCH_ASSOC) ?: null; if (!$file) { generate_alert( "/", "File not found", 404 ); exit(); } $file_sha = hash_file('sha256', $file_path); if (!delete_file($file_id, $file_ext)) { generate_alert( "/$file_id.$file_ext", 'Failed to remove files. Try again later', 500 ); exit(); } $db->prepare('INSERT IGNORE INTO hash_bans(sha256, reason) VALUES (?,?)') ->execute([$file_sha, $reason]); $db->prepare('INSERT INTO file_bans(id, hash_ban) VALUES (?,?)') ->execute([$file_id, $file_sha]); generate_alert( $_GET['r'] ?? '/', 'Successfully banned the file', 200, [ 'id' => $file_id, 'extension' => $file_ext, 'sha256' => $file_sha, 'reason' => $reason ] );