OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	11/28/2024 11:03:35 AM	rwxrwxr-x
📄 .browserslistrc	208 bytes	08/14/2024 10:49:55 AM	rw-r--r--
📄 .gitignore	42 bytes	08/14/2024 10:49:55 AM	rw-r--r--
📄 .htaccess	803 bytes	08/14/2024 10:49:55 AM	rw-r--r--
📄 .htaccess.swp	12 KB	08/14/2024 10:49:55 AM	rw-r--r--
📄 .travis.yml	199 bytes	08/14/2024 10:49:55 AM	rw-r--r--
📄 addList.php	4.7 KB	08/14/2024 10:49:55 AM	rw-r--r--
📄 allTemplates.php	5 KB	08/14/2024 10:49:55 AM	rw-r--r--
📄 bbsns_subscribe.php	5.14 KB	08/14/2024 10:49:55 AM	rw-r--r--
📄 bcreateList.php	9.61 KB	08/14/2024 10:49:56 AM	rw-r--r--
📄 blacklist.php	14.07 KB	08/22/2024 05:43:02 AM	rw-r--r--
📄 bounceViewList.php	7.67 KB	08/22/2024 05:07:15 AM	rw-r--r--
📄 bounce_handler.php	5 KB	08/23/2024 09:54:48 AM	rw-rw-rw-
📄 bprocess_emails.php	6.73 KB	08/14/2024 10:49:56 AM	rw-r--r--
📄 checkNotificationTopics.php	5.11 KB	08/14/2024 10:49:56 AM	rw-r--r--
📁 check_identity	-	08/14/2024 10:49:58 AM	rwxr-xr-x
📄 checknotif.php	1.01 KB	08/14/2024 10:49:56 AM	rw-r--r--
📄 ckeditor.php	2.14 KB	08/14/2024 10:49:56 AM	rw-r--r--
📄 click_handler.php	1.75 KB	08/14/2024 10:49:56 AM	rw-r--r--
📄 combined.php	11.28 KB	08/14/2024 10:49:56 AM	rw-r--r--
📄 complaintsViewList.php	6.8 KB	08/22/2024 05:20:43 AM	rw-r--r--
📄 complaints_handler.php	2.89 KB	08/14/2024 10:49:56 AM	rw-r--r--
📄 composer.json	200 bytes	08/14/2024 10:49:56 AM	rw-r--r--
📄 composer.lock	39.12 KB	08/14/2024 10:49:56 AM	rw-r--r--
📄 createList.php	11.23 KB	08/21/2024 11:56:25 AM	rw-r--r--
📁 credentials	-	08/14/2024 10:49:58 AM	rwxr-xr-x
📄 csv.php	10.1 KB	08/14/2024 10:49:56 AM	rw-r--r--
📄 db.php	1000 bytes	08/14/2024 10:49:56 AM	rw-r--r--
📄 delete_list.php	565 bytes	08/14/2024 10:49:56 AM	rw-r--r--
📄 delete_users.php	435 bytes	08/20/2024 04:49:00 AM	rw-r--r--
📄 deliveryViewList.php	6.6 KB	08/22/2024 05:16:19 AM	rw-r--r--
📄 delivery_handler.php	3.25 KB	08/14/2024 10:49:56 AM	rw-r--r--
📄 download_Complaints.php	974 bytes	08/14/2024 10:49:57 AM	rw-r--r--
📄 download_bounces.php	1007 bytes	08/14/2024 10:49:57 AM	rw-r--r--
📄 download_delivered.php	971 bytes	08/14/2024 10:49:57 AM	rw-r--r--
📄 download_unique_open.php	1.6 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 edit_list.php	10.01 KB	11/11/2024 12:41:09 PM	rw-r--r--
📄 feedback.php	1.71 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 footer.php	4.2 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 groupchatnavbar.php	607 bytes	09/01/2024 07:28:02 AM	rw-r--r--
📄 housekeeping.php	10.6 KB	08/20/2024 06:05:30 AM	rw-r--r--
📄 index.php	8.12 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 insert_list.php	2.64 KB	08/14/2024 10:49:57 AM	rw-r--r--
📁 log	-	08/14/2024 10:50:00 AM	rwxr-xr-x
📄 navbar.php	1.63 KB	08/20/2024 04:55:53 AM	rw-r--r--
📄 newCompaign.php	7.59 KB	08/21/2024 11:50:50 AM	rw-r--r--
📄 new_table.php	13.36 KB	10/07/2024 11:02:11 AM	rw-r--r--
📄 open_handler.php	1.75 KB	08/14/2024 10:49:57 AM	rw-r--r--
📁 process	-	08/20/2024 05:01:41 AM	rwxr-xr-x
📄 process_emails.php	10.36 KB	08/22/2024 05:44:39 AM	rw-r--r--
📄 real-recipients.csv	39.48 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 resubscribe.php	5.38 KB	08/19/2024 11:32:36 AM	rw-r--r--
📄 sample.csv	55 bytes	08/14/2024 10:49:57 AM	rw-r--r--
📄 send_email.php	987 bytes	08/14/2024 10:49:57 AM	rw-r--r--
📄 send_email_campaignGraph.php	2.24 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 sendgrid.php	3.62 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 showListMembers.php	12.44 KB	08/22/2024 05:39:43 AM	rw-r--r--
📄 showcase.php	7.93 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 sidebar.php	3.12 KB	09/01/2024 07:23:43 AM	rw-r--r--
📄 sns_subscribe.php	5.25 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 submit_form.php	2.48 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 test-mail.csv	337 bytes	08/14/2024 10:49:58 AM	rw-r--r--
📄 test.php	969 bytes	08/14/2024 10:49:58 AM	rw-r--r--
📄 test_process_emails.php	1.91 KB	08/14/2024 10:49:58 AM	rw-r--r--
📄 unsubscribe.php	3.36 KB	08/19/2024 11:32:22 AM	rw-r--r--
📄 upload_image.php	606 bytes	08/14/2024 10:49:58 AM	rw-r--r--
📁 uploads	-	03/20/2025 06:55:44 AM	rwxrwxrwx
📁 vendor	-	08/14/2024 11:08:43 AM	rwxr-xr-x
📄 verify.html	486 bytes	08/14/2024 10:49:58 AM	rw-r--r--
📄 verify.php	3.12 KB	08/14/2024 10:49:58 AM	rw-r--r--
📄 verify_email.php	5.12 KB	08/14/2024 10:49:58 AM	rw-r--r--
📄 viewCampaign.php	13.05 KB	08/21/2024 11:46:34 AM	rw-r--r--
📄 viewList.php	9.82 KB	08/21/2024 12:24:20 PM	rw-r--r--
📄 zprocess_emails.php	10.21 KB	08/14/2024 11:34:54 AM	rw-r--r--
📄 zshowListMembers.php	4.59 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 zsidebar.php	3.27 KB	08/14/2024 10:49:58 AM	rw-r--r--
📄 zviewCampaign.php	8.94 KB	08/14/2024 10:49:58 AM	rw-r--r--
📄 zzedit_list.php	8.42 KB	08/22/2024 05:34:33 AM	rw-r--r--
📄 zzprocess_emails.php	10.07 KB	08/14/2024 10:49:58 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/animate.css/4.0.0/animate.min.css" />
    <link rel="stylesheet" href="../inc/style.css" />
    <link rel="stylesheet" href="../inc/genai_style.css" />
    <style>
        /* Mobile Responsive Styles */
        /* General Styling */
        .breadcrumb {
            padding: 0.75rem 1rem;
        }

.breadcrumb-item {
            display: flex;
            align-items: center;
            justify-content: space-between;
        }

.breadcrumb-item .text-left {
            display: block;
        }

.breadcrumb-item form input[type="text"] {
            max-width: 100%;
        }

/* Mobile (up to 375px) */
        @media (max-width: 375px) {
            .breadcrumb-item h4 {
                font-size: 1.25rem;
            }

.breadcrumb-item .btn {
                font-size: 0.875rem;
                padding: 0.5rem 0.75rem;
            }

.breadcrumb-item .form-inline {
                display: block;
                width: 100%;
            }

.breadcrumb-item .form-inline input,
            .breadcrumb-item .form-inline button {
                width: 100%;
                margin: 0.25rem 0;
            }

.breadcrumb-item a.btn {
                width: 100%;
                margin-top: 0.25rem;
            }
        }

/* Tablet (375px to 768px) */
        @media (min-width: 376px) and (max-width: 768px) {
            .breadcrumb-item h4 {
                font-size: 1.5rem;
            }

.breadcrumb-item .btn {
                font-size: 1rem;
            }

.breadcrumb-item .form-inline {
                display: block;
                width: 100%;
            }

.breadcrumb-item .form-inline input {
                width: 80%;
            }

.breadcrumb-item .form-inline button {
                width: 20%;
            }

.breadcrumb-item a.btn {
                width: 100%;
                margin-top: 0.5rem;
            }
        }

/* Laptops (768px to 1024px) */
        @media (min-width: 769px) and (max-width: 1024px) {
            .breadcrumb-item h4 {
                font-size: 1.75rem;
            }

.breadcrumb-item .form-inline input {
                max-width: 250px;
            }

.breadcrumb-item a.btn {
                width: auto;
                margin-top: 0;
            }

.breadcrumb-item .btn {
                padding: 0.75rem 1.25rem;
            }
        }

/* Desktop (1024px and above) */
        @media (min-width: 1025px) {
            .breadcrumb-item h4 {
                font-size: 2rem;
            }

.breadcrumb-item .form-inline input {
                max-width: 300px;
            }

.breadcrumb-item a.btn {
                width: auto;
            }
        }
    </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">
                        <ol class="breadcrumb my-3">
                            <li class="breadcrumb-item w-100 d-flex justify-content-between align-items-center flex-wrap">
                                <div class="text-left mb-2 mb-md-0">
                                    <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 ml-auto mt-2 mt-md-0 flex-wrap justify-content-end">
                                    <form class="form-inline d-flex flex-nowrap mr-2 mb-2 mb-md-0" 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) ?>" style="max-width: 200px;">
                                        <button type="submit" class="btn btn-primary"><i class="fas fa-search"></i> Search</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>";
                                                echo "<td>" . fetch_unique_clicks($conn, htmlspecialchars($campaign['id'])) . "</td>";
                                                echo "</tr>";
                                            }
                                        } else {
                                            echo "<tr><td colspan='8'>No matching campaigns found.</td></tr>";
                                        }
                                        ?>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
                <footer class="py-2 bg-light">
                <div class="container-fluid" style="display: flex; justify-content: right;">
                    <div class="text-muted text-right small">&copy; <?= date('Y') ?>, Knobly Consulting</div>
                    
                </div>
            </footer>
            </main>
            
        </div>
    </div>

</body>

</html>