OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	03/04/2025 08:32:49 AM	rwxr-xr-x
📄 .browserslistrc	208 bytes	03/03/2025 08:18:55 AM	rw-r--r--
📄 .gitignore	42 bytes	03/03/2025 08:18:55 AM	rw-r--r--
📄 .htaccess	803 bytes	03/03/2025 08:18:55 AM	rw-r--r--
📄 .htaccess.swp	12 KB	03/03/2025 08:18:55 AM	rw-r--r--
📄 .travis.yml	199 bytes	03/03/2025 08:18:55 AM	rw-r--r--
📄 addList.php	4.7 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 allTemplates.php	5 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 bbsns_subscribe.php	5.14 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 bcreateList.php	9.61 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 blacklist.php	14.09 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 bounceViewList.php	5.86 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 bounce_handler.php	9.87 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 bprocess_emails.php	6.73 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 checkNotificationTopics.php	5.11 KB	05/19/2025 10:07:15 AM	rw-r--r--
📁 check_identity	-	05/19/2025 10:07:15 AM	rwxr-xr-x
📄 checknotif.php	1.01 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 ckeditor.php	2.14 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 click_handler.php	1.75 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 combined.php	11.23 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 complaintsViewList.php	5.72 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 complaints_handler.php	2.89 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 composer.json	200 bytes	03/03/2025 08:18:56 AM	rw-r--r--
📄 composer.lock	39.12 KB	03/03/2025 08:18:56 AM	rw-r--r--
📄 createList.php	10.05 KB	05/19/2025 10:07:15 AM	rw-r--r--
📁 credentials	-	03/03/2025 08:25:28 AM	rwxr-xr-x
📄 csv.php	10.1 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 db.php	1000 bytes	05/19/2025 10:07:15 AM	rw-r--r--
📄 delete_list.php	509 bytes	05/19/2025 10:07:15 AM	rw-r--r--
📄 deliveryViewList.php	5.71 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 delivery_handler.php	3.25 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 download_Complaints.php	974 bytes	05/19/2025 10:07:15 AM	rw-r--r--
📄 download_bounces.php	1007 bytes	05/19/2025 10:07:15 AM	rw-r--r--
📄 download_delivered.php	971 bytes	05/19/2025 10:07:15 AM	rw-r--r--
📄 download_unique_open.php	1.6 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 edit_list.php	8.39 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 feedback.php	1.66 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 footer.php	4.71 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 housekeeping.php	9.97 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 index.php	8.12 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 insert_list.php	2.64 KB	05/19/2025 10:07:15 AM	rw-r--r--
📁 log	-	05/19/2025 10:07:15 AM	rwxr-xr-x
📄 navbar.php	1.64 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 newCompaign.php	5.94 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 open_handler.php	1.75 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 process_emails.php	10.21 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 real-recipients.csv	39.48 KB	03/03/2025 08:18:56 AM	rw-r--r--
📄 sample.csv	55 bytes	03/03/2025 08:18:56 AM	rw-r--r--
📄 send_email.php	987 bytes	05/19/2025 10:07:15 AM	rw-r--r--
📄 send_email_campaignGraph.php	2.24 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 sendgrid.php	3.62 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 showListMembers.php	4.54 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 showcase.php	7.93 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 sidebar.php	3.11 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 sns_subscribe.php	5.25 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 submit_form.php	2.48 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 test-mail.csv	337 bytes	03/03/2025 08:18:56 AM	rw-r--r--
📄 test.php	969 bytes	05/19/2025 10:07:15 AM	rw-r--r--
📄 test_process_emails.php	1.91 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 upload_image.php	606 bytes	05/19/2025 10:07:15 AM	rw-r--r--
📁 uploads	-	03/03/2025 08:25:38 AM	rwxr-xr-x
📁 vendor	-	05/19/2025 10:07:15 AM	rwxr-xr-x
📄 verify.html	486 bytes	03/03/2025 08:18:56 AM	rw-r--r--
📄 verify.php	3.12 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 verify_email.php	5.12 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 viewCampaign.php	13.05 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 viewList.php	8.47 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 zsidebar.php	3.27 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 zviewCampaign.php	8.94 KB	05/19/2025 10:07:15 AM	rw-r--r--
📄 zzprocess_emails.php	10.07 KB	05/19/2025 10:07:15 AM	rw-r--r--

Editing: housekeeping.php

<?php
ini_set('display_startup_errors', 1);
include '../inc/validate.logged.php';
include 'db.php';

// Function to handle housekeeping tasks
function housekeepingTasks($conn) {
    // Archive unconfirmed subscribers (using assumed columns)
    $archiveQuery = "INSERT INTO archived_subscribers (email, subscribed_date)
                     SELECT email, subscribed_date
                     FROM unconfirmed_subscribers
                     WHERE subscribed_date < NOW() - INTERVAL 1 MONTH";
    
    if (!$conn->query($archiveQuery)) {
        echo "Error archiving subscribers: " . $conn->error;
    }

// Remove archived subscribers
    $deleteQuery = "DELETE FROM unconfirmed_subscribers
                    WHERE subscribed_date < NOW() - INTERVAL 1 MONTH";
    
    if (!$conn->query($deleteQuery)) {
        echo "Error deleting subscribers: " . $conn->error;
    }
}

// Call housekeeping function
housekeepingTasks($conn);

// Fetching data for display (update with your actual table name and columns)
$listsQuery = "SELECT * FROM list ";
$result = $conn->query($listsQuery);

if ($result) {
    while ($row = $result->fetch_assoc()) {
        $listId = $row['list_id'] ?? ''; // Adjust according to actual column names
        $listName = htmlspecialchars($row['list_name'] ?? ''); // Handle null values
        
        // Fetch unconfirmed subscribers for the list
        $subscribersQuery = "SELECT email, COUNT(*) as total
                             FROM unconfirmed_subscribers
                             GROUP BY email";

$stmt = $conn->prepare($subscribersQuery);
        $stmt->execute();
        $subscribersResult = $stmt->get_result();
        
        if ($subscribersResult) {
            while ($subscriber = $subscribersResult->fetch_assoc()) {
                $email = htmlspecialchars($subscriber['email'] ?? ''); // Handle null values
                $total = htmlspecialchars($subscriber['total'] ?? ''); // Handle null values
                
                // Output subscriber details
                echo "Email: $email, Total: $total<br>";
            }
        } else {
            echo "Error fetching subscribers: " . $conn->error;
        }
        
        $stmt->close();
    }
} else {
    echo "Error fetching lists: " . $conn->error;
}

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Knobly Cream: Create &bull; Reach &bull; Measure</title>
    
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
    
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.3/css/all.min.css">
    
    <link rel="stylesheet" href="../inc/style.css">
    <link rel="stylesheet" href="../inc/genai_style.css">
    
    <script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.8.0/Chart.min.js"></script>
    <script src="https://cdn.tiny.cloud/1/u5oz235qw5jiqww4udm90ocp9zg2rncblqo2ch0ym3twjgyt/tinymce/5/tinymce.min.js" referrerpolicy="origin"></script>
    <script src="https://js.zohostatic.com/books/zfwidgets/assets/js/zf-widget.js"></script>
    <script src="../inc/jquery.magnific-popup.min.js"></script>
    <script src="../inc/common.js"></script>
    <script>
        $(function() {
            $('[data-toggle="tooltip"]').tooltip()
        });
    </script>
    <style>
        body {
            font-family: Arial, sans-serif;
            background-color: #ffffff;
        }

.section-heading {
            color: #333333;
            padding: 10px 0;
            border-bottom: 1px solid #dddddd;
            margin-bottom: 20px;
        }

.section-content {
            padding: 20px;
            border-bottom: 1px solid #dddddd;
            margin-bottom: 20px;
        }

.btn-group .btn {
            margin-right: 10px;
        }

.alert-info {
            background-color: #e9f7fc;
            border-color: #bee5eb;
            color: #0c5460;
        }

.table-responsive {
            margin-top: 20px;
        }

footer {
            background-color: #f8f9fa;
            padding: 20px;
        }

.footer-text {
            text-align: right;
            color: #6c757d;
        }

.custom-tooltip {
            cursor: pointer;
        }

.btn-custom {
            background-color: #007bff;
            color: white;
            border-radius: 5px;
        }

.btn-custom:hover {
            background-color: #0056b3;
        }

.blacklist-alerts {
            list-style: none;
            padding: 0;
        }

.blacklist-alerts li {
            margin-bottom: 10px;
        }

.form-control {
            margin-bottom: 15px;
            border-radius: 5px;
        }

.form-group label {
            font-weight: bold;
            color: #495057;
        }
    </style>
</head>
<body class="sb-nav-fixed">
    <?php include "navbar.php"; ?>
    <div id="layoutSidenav">
        <?php include 'sidebar.php'; ?>
        <div id="layoutSidenav_content">
            <main>
                <div id="panelContent" class="container-fluid">
                    <div class="main-content">
                        
                        <div class="section-heading">
                            <h2>Housekeeping</h2>
                        </div>
                        <div class="section-content">
                            <div class="well">
                                <div class="btn-group" data-toggle="buttons-radio">
                                    <a href="javascript:void(0)" class="btn btn-custom active"><i class="fas fa-meh"></i> Unconfirmed subscribers</a>
                                    <a href="#" class="btn btn-custom"><i class="fas fa-moon"></i> Inactive subscribers</a>
                                </div>
                            </div>
                            <div class="alert alert-info">
                                <p><i class="fas fa-info-circle"></i> Housekeeping for 'Unconfirmed subscribers' allows you to bulk remove subscribers who signed up to double opt-in lists but did not click the confirmation link to confirm their subscription.</p>
                            </div>
                            <div class="table-responsive">
                                <h3>Unconfirmed subscribers</h3>
                                <hr>
                                <table class="table table-striped table-hover">
                                    <thead>
                                        <tr>
                                            <th>List</th>
                                            <th>Status</th>
                                            <th>1 week</th>
                                            <th>&gt; 1 week</th>
                                            <th>&gt; 2 weeks</th>
                                            <th>All</th>
                                            <th>Export</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <?php
                                        // Fetch unconfirmed subscribers data
                                        $query = "SELECT * FROM subscribers WHERE email NOT IN (SELECT email FROM confirmed_subscribers)";
                                        $result = mysqli_query($conn, $query);

while ($row = mysqli_fetch_assoc($result)) {
                                            echo '<tr id="uc-' . htmlspecialchars($row['id']) . '">
                                                    <td><a href="#" class="custom-tooltip" data-toggle="tooltip" title="List details">' . htmlspecialchars($row['email']) . ' <span class="badge badge-success">2</span></a></td>
                                                    <td><span class="badge badge-warning">Unconfirmed</span></td>
                                                    <td><span id="count-' . htmlspecialchars($row['id']) . '-1week">0</span></td>
                                                    <td><span id="count-' . htmlspecialchars($row['id']) . '-1weekmore">0</span></td>
                                                    <td><span id="count-' . htmlspecialchars($row['id']) . '-2weeks">0</span></td>
                                                    <td><span id="count-' . htmlspecialchars($row['id']) . '-all">0</span></td>
                                                    <td><a href="#" class="custom-tooltip" data-toggle="tooltip" title="Export all unconfirmed subscribers"><i class="fas fa-download"></i></a></td>
                                                </tr>';
                                        }
                                        ?>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </main>
            <footer class="py-4 bg-light mt-auto">
                <div class="container-fluid">
                    <div class="d-flex align-items-center justify-content-between small">
                        <div class="text-muted">&copy; Knobly Cream 2024</div>
                        <div class="footer-text">
                            <a href="#">Privacy Policy</a> &middot; <a href="#">Terms & Conditions</a>
                        </div>
                    </div>
                </div>
            </footer>
        </div>
    </div>
</body>
</html>