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: createList.php

<?
include '../inc/validate.logged.php';
include '../inc/config.php';
include 'db.php';

$search = '';
if (isset($_GET['s']) && !empty($_GET['s'])) {
    $search = mysqli_real_escape_string($conn, $_GET['s']);
}

$campaignsSql = "SELECT campaigns.id, campaigns.campaign_name, campaigns.action, list.list_name, campaigns.sent_date 
                 FROM campaigns 
                 JOIN list  ON campaigns.list_id = list.id WHERE list.user_id = $gUserId";

if ($search) {
    $campaignsSql .= " AND campaigns.campaign_name LIKE '%$search%'";
}

$campaignsResult = mysqli_query($conn, $campaignsSql);

function fetch_unique_clicks($conn, $campaignId)
{
    $campaignsSql = "SELECT COUNT(*) AS count FROM messages m INNER JOIN email_clicks ec ON ec.message_id = m.message_id WHERE m.campaign_id = ?";
    $stmt = $conn->prepare($campaignsSql);
    $stmt->bind_param("i", $campaignId);
    $stmt->execute();
    $result = $stmt->get_result();
    $data = $result->fetch_assoc();
    $stmt->close();
    return $data['count'];
}

function fetch_unique_opens($conn, $campaignId)
{
    $campaignsSql = "SELECT COUNT(*) AS count FROM messages m INNER JOIN email_opens eo ON eo.message_id = m.message_id WHERE m.campaign_id = ?";
    $stmt = $conn->prepare($campaignsSql);
    $stmt->bind_param("i", $campaignId);
    $stmt->execute();
    $result = $stmt->get_result();
    $data = $result->fetch_assoc();
    $stmt->close();
    return $data['count'];
}

function fetch_bounces($conn, $campaignId)
{
    $campaignsSql = "SELECT COUNT(*) AS count FROM bounces b INNER JOIN messages m ON m.message_id = b.message_id WHERE m.campaign_id = ?";
    $stmt = $conn->prepare($campaignsSql);
    $stmt->bind_param("i", $campaignId);
    $stmt->execute();
    $result = $stmt->get_result();
    $data = $result->fetch_assoc();
    $stmt->close();
    return $data['count'];
}

function fetch_deliveries($conn, $campaignId)
{
    $campaignsSql = "SELECT COUNT(*) AS count FROM deliveries d INNER JOIN messages m ON m.message_id = d.message_id WHERE m.campaign_id = ?";
    $stmt = $conn->prepare($campaignsSql);
    $stmt->bind_param("i", $campaignId);
    $stmt->execute();
    $result = $stmt->get_result();
    $data = $result->fetch_assoc();
    $stmt->close();
    return $data['count'];
}

<!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>
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script>
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    
    <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="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.4/css/all.min.css">
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css" integrity="sha384-9aIt2nRpC12Uk9gS9baDl411NQApFmC26EwAOH8WgZl5MYYxFfc+NcPb1dKGj7Sk" crossorigin="anonymous" />
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/animate.css/4.0.0/animate.min.css" />
    <link rel="stylesheet" href="../inc/fontawesome/css/all.min.css" />
    <link rel="stylesheet" href="../inc/magnific-popup.css" />
    <link rel="stylesheet" href="../inc/style.css" />
    <link rel="stylesheet" href="../inc/genai_style.css" />
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    <script src="https://code.jquery.com/jquery-3.5.1.min.js" integrity="sha256-9/aliU8dGd2tb6OSsuzixeV4y/faTqgFtohetphbbj0=" crossorigin="anonymous"></script>
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js" integrity="sha384-OgVRvuATP1z7JjHLkuOU7Xw704+h835Lr+6QL9UvYjZE3Ipu6Tp75j7Bh/kR0JKI" crossorigin="anonymous"></script>
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.8.0/Chart.min.js" crossorigin="anonymous"></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 type="text/javascript">
    </script>
    
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
</head>

<body class="sb-nav-fixed">
    <? 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">
                        <ol class="breadcrumb my-3">
                            <li class="breadcrumb-item w-100 d-flex justify-content-between align-items-center">
                                <div class="text-left">
                                    <h4 class="mt-1">All campaigns</h4>
                                    <a href="newCompaign.php" class="btn btn-primary mt-2"><i class="fas fa-plus"></i> Create &amp; send new campaign</a>
                                </div>
                                <div class="d-flex align-items-center">
                                    <form class="form-inline mr-3" action="" method="GET">
                                        <input type="hidden" name="i" value="16">
                                        <input type="text" class="form-control mr-2" name="s" placeholder="Search campaigns..." value="<?= htmlspecialchars($search) ?>">
                                        <button type="submit" class="btn btn-primary"><i class="fas fa-search"></i> Search campaigns</button>
                                    </form>
                                    <a href="../dashboard.php" class="btn btn-primary" style="background-color: #007bff; border-color: #007bff;">
                                        <i class="bi bi-arrow-left"></i> Back to Cream
                                    </a>
                                </div>
                            </li>

</ol>
                        <div class="row mt-3">
                            <div class="col">

<table class="table table-striped table-bordered">
                                    <thead>
                                        <tr>
                                            <th>Campaign Name</th>
                                            <th>Action Type</th>
                                            <th>Recipients</th>
                                            <th>Sent</th>
                                            <th>Delivered Mails</th>
                                            <th>Bounced Mails</th>
                                            <th>Unique Opens</th>
                                            <th>Unique Clicks</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <?php
                                        if ($campaignsResult && mysqli_num_rows($campaignsResult) > 0) {
                                            while ($campaign = mysqli_fetch_assoc($campaignsResult)) {
                                                echo "<tr>";
                                                echo "<td><a href = viewCampaign.php?id=" . $campaign['id'] . ">" . htmlspecialchars($campaign['campaign_name']) . "</a></td>";
                                                echo "<td>" . htmlspecialchars($campaign['action']) . "</td>";
                                                echo "<td>" . htmlspecialchars($campaign['list_name']) . "</td>";
                                                echo "<td>" . htmlspecialchars($campaign['sent_date']) . "</td>";
                                                echo "<td>" . fetch_deliveries($conn, htmlspecialchars($campaign['id'])) . "</td>";
                                                echo "<td>" . fetch_bounces($conn, htmlspecialchars($campaign['id'])) . "</td>";
                                                echo "<td>" . fetch_unique_opens($conn, htmlspecialchars($campaign['id'])) . "</td>"; // Placeholder for Unique Opens
                                                echo "<td>" . fetch_unique_clicks($conn, htmlspecialchars($campaign['id'])) . "</td>"; // Placeholder for Unique Clicks
                                                echo "</tr>";
                                            }
                                        } else {
                                            echo "<tr><td colspan='8'>No matching campaigns found.</td></tr>";
                                        }
                                        ?>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>

</div>
            </main>
            <?= include 'footer.php'; ?>
        </div>
    </div>
</body>

<script>
    function toggleMode() {
        document.body.classList.toggle('dark-mode');
        const btn = document.querySelector('.btn-toggle-mode');
        if (document.body.classList.contains('dark-mode')) {
            btn.innerHTML = 'Toggle Light Mode';
        } else {
            btn.innerHTML = 'Toggle Dark Mode';
        }
    }
</script>

</html>