OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	06/17/2025 10:17:24 AM	rwxrwxr-x
📄 .browserslistrc	208 bytes	11/13/2024 01:46:20 PM	rw-r--r--
📄 .gitignore	42 bytes	11/13/2024 01:46:20 PM	rw-r--r--
📄 .htaccess	803 bytes	11/13/2024 01:46:21 PM	rw-r--r--
📄 .htaccess.swp	12 KB	11/13/2024 01:46:21 PM	rw-r--r--
📄 .travis.yml	199 bytes	11/13/2024 01:46:21 PM	rw-r--r--
📄 addList.php	5.23 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 aditya_navbar.php	23.72 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 allTemplates.php	5 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 b_navbar.php	7.84 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 bbsns_subscribe.php	5.14 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 bcreateList.php	9.61 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 blacklist.php	13.36 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 bounceViewList.php	8.39 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 bounce_handler.php	4.99 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 bprocess_emails.php	6.73 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 checkNotificationTopics.php	5.11 KB	05/19/2025 10:07:21 AM	rw-r--r--
📁 check_identity	-	05/19/2025 10:07:19 AM	rwxr-xr-x
📄 checknotif.php	1.01 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 ckeditor.php	2.14 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 clickViewList.php	5.13 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 click_handler.php	1.75 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 combined.php	11.23 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 complaintsViewList.php	6.78 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 complaints_handler.php	2.89 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 composer.json	200 bytes	11/15/2024 04:46:27 AM	rw-r--r--
📄 composer.lock	39.12 KB	11/15/2024 04:46:27 AM	rw-r--r--
📄 createList.php	17.4 KB	05/19/2025 10:07:21 AM	rw-r--r--
📁 credentials	-	11/13/2024 01:46:39 PM	rwxr-xr-x
📄 csv.php	11.75 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 db.php	1000 bytes	05/19/2025 10:07:19 AM	rw-r--r--
📄 deleteCampaign.php	966 bytes	05/19/2025 10:07:21 AM	rw-r--r--
📄 delete_list.php	509 bytes	05/19/2025 10:07:19 AM	rw-r--r--
📄 delete_users.php	435 bytes	05/19/2025 10:07:19 AM	rw-r--r--
📄 deliveryViewList.php	6.87 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 delivery_handler.php	3.25 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 download_Complaints.php	974 bytes	05/19/2025 10:07:19 AM	rw-r--r--
📄 download_bounces.php	1.18 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 download_clicked.php	1.23 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 download_delivered.php	1.12 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 download_open.php	1.22 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 download_report.php	3.33 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 download_unique_open.php	1.6 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 duplicate_campaign.php	1.62 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 edit_campaign.php	1.45 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 edit_list.php	9.89 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 feedback.php	1.66 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 footer.php	1.7 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 groupchatnavbar.php	607 bytes	05/19/2025 10:07:19 AM	rw-r--r--
📄 himanshu_navbar.php	7.84 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 housekeeping.php	13.27 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 index.php	8.57 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 insert_list.php	2.64 KB	05/19/2025 10:07:19 AM	rw-r--r--
📁 js	-	11/28/2024 08:16:19 AM	rwxr-xr-x
📄 load.php	159 bytes	05/19/2025 10:07:21 AM	rw-r--r--
📁 log	-	01/07/2025 11:58:15 AM	rwxr-xr-x
📄 main.css	1.3 KB	01/10/2025 10:12:55 AM	rw-r--r--
📄 navbar.php	23.77 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 newCompaign.php	11.12 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 openViewList.php	8.48 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 open_handler.php	1.75 KB	05/19/2025 10:07:21 AM	rw-r--r--
📁 process	-	05/19/2025 10:07:19 AM	rwxr-xr-x
📄 process_emails.php	11.31 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 real-recipients.csv	39.48 KB	11/15/2024 04:46:32 AM	rw-r--r--
📄 resubscribe.php	5.51 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 sample.csv	55 bytes	12/26/2024 07:07:48 AM	rw-r--r--
📄 save.php	252 bytes	05/19/2025 10:07:19 AM	rw-r--r--
📄 save_campaign.php	612 bytes	05/19/2025 10:07:19 AM	rw-r--r--
📄 saved_content.html	6.48 KB	11/28/2024 09:08:17 AM	rw-r--r--
📄 send_email.php	987 bytes	05/19/2025 10:07:19 AM	rw-r--r--
📄 send_email_campaignGraph.php	2.24 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 sendgrid.php	3.62 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 showListMembers.php	13.98 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 showcase.php	7.93 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 sidebar.php	0 bytes	05/19/2025 10:07:19 AM	rw-r--r--
📄 sns_subscribe.php	5.25 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 submit_form.php	2.48 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 test-mail.csv	337 bytes	11/15/2024 04:46:34 AM	rw-r--r--
📄 test.php	969 bytes	05/19/2025 10:07:19 AM	rw-r--r--
📄 test_process_emails.php	1.91 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 unsubscribe.php	3.8 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 upload_image.php	606 bytes	05/19/2025 10:07:19 AM	rw-r--r--
📁 uploads	-	01/06/2025 11:23:50 AM	rwxrwxrwx
📁 vendor	-	05/19/2025 10:07:21 AM	rwxr-xr-x
📄 verify.html	486 bytes	11/15/2024 04:46:35 AM	rw-r--r--
📄 verify.php	3.12 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 verify_email.php	5.12 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 viewCampaign.php	23.92 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 viewList.php	15.04 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 xpress_handler.php	9.79 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 zcreateList.php	13.51 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 znewCompaign.php	8.29 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 zprocess_emails.php	10.19 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 zviewList.php	14.63 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 zzindex.php	10.24 KB	05/19/2025 10:07:21 AM	rw-r--r--
📁 zzlog	-	05/19/2025 10:07:21 AM	rwxr-xr-x
📄 zzviewCampaign.php	22.42 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 zzviewList.php	14.63 KB	05/19/2025 10:07:19 AM	rw-r--r--

Editing: zcreateList.php

<?
include '../inc/validate.logged.php';
include '../inc/config.php';
include 'db.php';
include '../assets/php/function.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>

<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>

/* Dark Mode Styling */
        body.dark-mode {
            background-color: #121212;
            /* Dark background for the body */
            color: white;
            /* Light text color for general content */
        }

body.dark-mode .breadcrumb {
            background-color: #333;
            /* Darker breadcrumb background */
            color: white;
        }

body.dark-mode .table {
            background-color: #1e1e1e;
            /* Dark table background */
            color: white;
            /* Default white text color for the table */
        }

body.dark-mode .table th,
        body.dark-mode .table td {
            border-color: #444;
            /* Lighter borders for the table in dark mode */
        }

body.dark-mode .table-striped tbody tr:nth-of-type(odd) {
            background-color: #333;
            /* Darker odd rows */
        }

body.dark-mode .table-striped tbody tr:nth-of-type(even) {
            background-color: #2b2b2b;
            /* Even darker even rows */
        }

/* Specific text color for headings in dark mode */
        body.dark-mode .table th {
            color: white;
            /* Ensure table headers are white in dark mode */
        }

/* Adjust text color on links for better contrast */
        body.dark-mode .table a {
            color: #4fa3f7;
            /* Light blue link color for visibility */
        }

/* 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'; ?>
    <?php include '../assets/php/go_backbar.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>

</div>
                            </li>
                        </ol>

<div class="row mt-3">
                            <div class="col">
                                <div class="table-responsive">
                                    <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>
                </div>
                <?php include 'footer.php'; ?>
            </main>

</div>
    </div>

</body>

</html>