OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	03/31/2025 06:36:42 AM	rwxr-xr-x
📄 .browserslistrc	208 bytes	03/26/2025 04:06:47 AM	rw-r--r--
📄 .gitignore	42 bytes	03/26/2025 04:06:47 AM	rw-r--r--
📄 .htaccess	803 bytes	03/26/2025 04:06:47 AM	rw-r--r--
📄 .htaccess.swp	12 KB	03/26/2025 04:06:47 AM	rw-r--r--
📄 .travis.yml	199 bytes	03/26/2025 04:06:47 AM	rw-r--r--
📄 09-01-25navbar.php	30.59 KB	03/26/2025 04:06:47 AM	rw-r--r--
📄 15-02-25viewList.php	14.86 KB	03/26/2025 04:06:47 AM	rw-r--r--
📄 17-02-25newCompaign.php	12.43 KB	03/26/2025 04:06:47 AM	rw-r--r--
📁 NLEditor	-	03/26/2025 04:21:24 AM	rwxr-xr-x
📄 addList.php	6.06 KB	03/26/2025 04:06:47 AM	rw-r--r--
📄 adi_deliveryViewList.php	11.13 KB	03/26/2025 04:06:47 AM	rw-r--r--
📄 aditya_choose.php	6 KB	03/26/2025 04:06:47 AM	rw-r--r--
📄 aditya_choose_template.php	7.52 KB	03/26/2025 04:06:47 AM	rw-r--r--
📄 aditya_viewCampaign.php	24.73 KB	03/26/2025 04:06:47 AM	rw-r--r--
📄 arvind_choose_templates.php	10.83 KB	03/26/2025 04:06:47 AM	rw-r--r--
📁 assets	-	03/26/2025 04:20:38 AM	rwxr-xr-x
📄 back_choose_template.php	7.52 KB	03/26/2025 04:06:47 AM	rw-r--r--
📄 blacklist.php	13.06 KB	03/26/2025 04:06:47 AM	rw-r--r--
📄 bounceViewList.php	14.63 KB	03/26/2025 04:06:47 AM	rw-r--r--
📄 bounce_handler.php	5.05 KB	03/26/2025 04:06:47 AM	rw-r--r--
📄 checkNotificationTopics.php	5.11 KB	03/26/2025 04:06:47 AM	rw-r--r--
📁 check_identity	-	03/26/2025 04:16:12 AM	rwxr-xr-x
📄 checknotif.php	1020 bytes	03/26/2025 04:06:47 AM	rw-r--r--
📄 choose_template.php	6.74 KB	03/26/2025 04:06:47 AM	rw-r--r--
📄 clickViewList.php	13.01 KB	03/26/2025 04:06:47 AM	rw-r--r--
📄 click_handler.php	1.75 KB	03/26/2025 04:06:47 AM	rw-r--r--
📄 complaintsViewList.php	8.41 KB	03/26/2025 04:06:48 AM	rw-r--r--
📄 complaints_handler.php	2.89 KB	03/26/2025 04:06:48 AM	rw-r--r--
📄 composer.json	200 bytes	03/26/2025 04:06:48 AM	rw-r--r--
📄 composer.lock	39.12 KB	03/26/2025 04:06:48 AM	rw-r--r--
📄 createList.php	19.13 KB	03/26/2025 04:06:48 AM	rw-r--r--
📁 credentials	-	03/26/2025 04:16:13 AM	rwxr-xr-x
📄 csv.php	12.33 KB	03/26/2025 04:06:48 AM	rw-r--r--
📁 data	-	03/26/2025 04:21:24 AM	rwxr-xr-x
📄 db.php	991 bytes	03/26/2025 04:06:48 AM	rw-r--r--
📄 deleteCampaign.php	966 bytes	03/26/2025 04:06:48 AM	rw-r--r--
📄 deleteTemplate.php	1.55 KB	03/26/2025 04:06:48 AM	rw-r--r--
📄 delete_list.php	959 bytes	03/26/2025 04:06:48 AM	rw-r--r--
📄 delete_users.php	435 bytes	03/26/2025 04:06:48 AM	rw-r--r--
📄 deliveryViewList.php	12.9 KB	03/26/2025 04:06:49 AM	rw-r--r--
📄 delivery_handler.php	3.25 KB	03/26/2025 04:06:49 AM	rw-r--r--
📄 download_Complaints.php	1.16 KB	03/26/2025 04:06:49 AM	rw-r--r--
📄 download_bounces.php	1.18 KB	03/26/2025 04:06:49 AM	rw-r--r--
📄 download_clicked.php	1.23 KB	03/26/2025 04:06:49 AM	rw-r--r--
📄 download_delivered.php	1.12 KB	03/26/2025 04:06:49 AM	rw-r--r--
📄 download_open.php	1.22 KB	03/26/2025 04:06:49 AM	rw-r--r--
📄 download_report.php	3.33 KB	03/26/2025 04:06:49 AM	rw-r--r--
📄 download_unique_open.php	1.6 KB	03/26/2025 04:06:49 AM	rw-r--r--
📄 duplicate_campaign.php	1.67 KB	03/26/2025 04:06:49 AM	rw-r--r--
📄 edit_campaign.php	1.45 KB	03/26/2025 04:06:49 AM	rw-r--r--
📄 edit_list.php	11.69 KB	03/26/2025 04:06:50 AM	rw-r--r--
📄 feedback.php	1.71 KB	03/26/2025 04:06:50 AM	rw-r--r--
📄 fetch_template.php	493 bytes	03/26/2025 04:06:50 AM	rw-r--r--
📄 footer.php	1.35 KB	03/26/2025 04:06:50 AM	rw-r--r--
📁 grfx	-	03/26/2025 04:16:13 AM	rwxr-xr-x
📄 himanshu_index.php	6.58 KB	03/26/2025 04:06:50 AM	rw-r--r--
📄 himanshu_newCompaign.php	11.25 KB	03/26/2025 04:06:50 AM	rw-r--r--
📄 housekeeping.php	24.85 KB	03/26/2025 04:06:50 AM	rw-r--r--
📄 index.php	9.9 KB	03/26/2025 04:06:50 AM	rw-r--r--
📄 insert_list.php	2.64 KB	03/26/2025 04:06:50 AM	rw-r--r--
📁 js	-	03/26/2025 04:16:13 AM	rwxr-xr-x
📄 load.php	159 bytes	03/26/2025 04:06:50 AM	rw-r--r--
📁 log	-	03/26/2025 04:16:25 AM	rwxr-xr-x
📄 main.css	1.3 KB	03/26/2025 04:06:50 AM	rw-r--r--
📄 navbar.php	22.54 KB	03/26/2025 04:06:50 AM	rw-r--r--
📄 navbar_menu.php	1.94 KB	03/26/2025 04:06:50 AM	rw-r--r--
📄 newCompaign.php	16.25 KB	03/26/2025 04:06:50 AM	rw-r--r--
📄 obc_cards.php	7.58 KB	03/26/2025 04:06:50 AM	rw-r--r--
📄 openViewList.php	14.4 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 open_handler.php	1.75 KB	03/26/2025 04:06:51 AM	rw-r--r--
📁 process	-	03/26/2025 04:16:33 AM	rwxr-xr-x
📄 process_emails.php	12.53 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 real-recipients.csv	39.48 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 resubscribe.php	6.41 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 sample.csv	55 bytes	03/26/2025 04:06:51 AM	rw-r--r--
📄 save.php	252 bytes	03/26/2025 04:06:51 AM	rw-r--r--
📄 save_campaign.php	612 bytes	03/26/2025 04:06:51 AM	rw-r--r--
📄 saved_content.html	6.48 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 send_email.php	987 bytes	03/26/2025 04:06:51 AM	rw-r--r--
📄 send_email_campaignGraph.php	2.24 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 sendgrid.php	3.62 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 showListMembers.php	11.44 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 showcase.php	7.79 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 sidebar.php	0 bytes	03/26/2025 04:06:51 AM	rw-r--r--
📄 sns_subscribe.php	5.25 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 submit_form.php	2.48 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 template_index.php	10.08 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 test-mail.csv	337 bytes	03/26/2025 04:06:51 AM	rw-r--r--
📄 test.php	969 bytes	03/26/2025 04:06:51 AM	rw-r--r--
📄 test_choose_template.php	6.51 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 test_process_emails.php	1.91 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 unsubscribe.php	6.87 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 upload_image.php	606 bytes	03/26/2025 04:06:51 AM	rw-r--r--
📁 uploads	-	03/26/2025 04:16:39 AM	rwxr-xr-x
📁 vendor	-	03/26/2025 04:21:35 AM	rwxr-xr-x
📄 verify.html	486 bytes	03/26/2025 04:06:51 AM	rw-r--r--
📄 verify.php	2.54 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 verify_email.php	5.03 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 viewCampaign.php	26.94 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 viewList.php	17.65 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 xpress_handler.php	10.51 KB	03/26/2025 04:06:51 AM	rw-r--r--
📄 znewCompaign.php	10.52 KB	03/26/2025 04:06:52 AM	rw-r--r--
📄 zunsubscribe.php	5.82 KB	03/26/2025 04:06:52 AM	rw-r--r--
📄 zzindex.php	6.8 KB	03/26/2025 04:06:52 AM	rw-r--r--
📄 zzzzindex.php	6.68 KB	03/26/2025 04:06:52 AM	rw-r--r--
📄 zzzzzindex.php	55.73 KB	03/26/2025 04:06:52 AM	rw-r--r--

Editing: clickViewList.php

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

// Query to get bounce count
$sql = "SELECT ec.to_email, c.campaign_name 
        FROM email_clicks ec
        INNER JOIN messages m ON m.message_id = ec.message_id
        INNER JOIN campaigns c ON c.id = m.campaign_id 
        WHERE ec.from_email = '$gUserEmail'";

$result = mysqli_query($conn, $sql);

// Prepare the data
$campaigns = [];
if ($result) {
    if (mysqli_num_rows($result) > 0) {
        while ($row = mysqli_fetch_assoc($result)) {
            $campaigns[$row['campaign_name']][] = $row['to_email'];
        }
    }
} else {
    echo '<p>Error: ' . htmlspecialchars(mysqli_error($conn)) . '</p>';
}

mysqli_close($conn);
?>

<!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>
    
    <link rel="stylesheet" href="../assets/css/bootstrap.min.4.5.0.css
    <link rel="stylesheet" href="../assets/css/all.min.5.15.3.css">
    <link rel="stylesheet" href="../assets/css/styles.css">

.email-list {
            padding-left: 20px;
        }

.email-list li {
            list-style-type: none;
        }

.btn-outline-success {
            color: #fafafa;
            border-color: #db5919;
            background-color: #db5919;
        }

.btn-outline-success:hover {
            color: #fafafa;
            border-color: #db5919;
            background-color: #db5919;
        }

.btn-outline-success:focus {
            box-shadow: 0 0 0 0.2rem rgba(219, 89, 25, 0.5);
        }

.btn-outline-success:not(:disabled):not(.disabled):active:focus {
            box-shadow: 0 0 0 0.2rem rgba(219, 89, 25, 0.5);
        }

.btn-outline-success:not(:disabled):not(.disabled):active {
            color: #fafafa;
            background-color: #db5919;
            border-color: #db5919;
        }

/* Campaign Table Styles */
        .campaign-table {
            width: 100%;
            border-collapse: collapse;
            margin-bottom: 16px;
            background-color: #f9f9f9;
            border: 1px solid #ddd;
            font-family: Arial, sans-serif;
        }

/* Header Styles for Campaign Name */

/* Table Body Styles */
        .campaign-table tbody tr {
            border-bottom: 1px solid #ddd;
        }

.campaign-table tbody tr:nth-child(even) {
            background-color: #f1f1f1;
            /* Alternate row background */
        }

.campaign-table tbody tr:nth-child(odd) {
            background-color: #fff;
        }

/* Table Data Cell Styles */
        .campaign-table td {
            font-size: 14px;
            color: #333;
            vertical-align: middle;
            border: 1px solid #ddd;
        }

/* Icon Styling */
        .email-icon {
            text-align: center;
            width: 40px;
        }

/* Email Address Styles */
        .email-address {
            color: #555;
        }

/* Responsive Design */

@media (max-width: 1024px) {
            .campaign-table-header {
                font-size: 16px;
                padding: 10px;
            }

.campaign-table td {
                font-size: 13px;
            }

.email-table-header {
                font-size: 16px;
                padding: 10px;
            }

.inner-email-table thead th {
                font-size: 13px;
                padding: 6px;
            }

.inner-email-table tbody td {
                font-size: 13px;
                padding: 6px;
            }

.col-md-4 {
                margin-left: 20px;
            }
        }

@media (max-width: 768px) {
            .campaign-table-header {
                font-size: 14px;
                padding: 8px;
            }

.campaign-table td {
                font-size: 12px;
            }

.email-table-header {
                font-size: 14px;
                padding: 8px;
            }

.inner-email-table thead th {
                font-size: 12px;
            }

.inner-email-table tbody td {
                font-size: 12px;
            }
        }

@media (max-width: 576px) {
            .campaign-table-header {
                font-size: 12px;
            }

.campaign-table td {
                font-size: 11px;
            }

.email-table-header {
                font-size: 12px;
                padding: 6px;
            }

.inner-email-table thead th {
                font-size: 11px;
                padding: 4px;
            }

.inner-email-table tbody td {
                font-size: 11px;
                padding: 4px;
            }

.col-md-4 {
                margin-left: 0;
                width: 100%;
            }
        }

/* Outer table styling */
        .email-table {
            width: 100%;
            border-collapse: collapse;
            margin-bottom: 16px;
            background-color: #f9f9f9;
            border: 1px solid #ddd;
        }

.email-table-header {
            background-color: #343a40;
            color: #fff;
            text-align: left;
            padding: 12px;
            font-size: 18px;
            font-weight: bold;
        }

/* Inner table styling */
        .inner-email-table {
            width: 100%;
            border-collapse: collapse;
            margin-top: 8px;
        }

.inner-email-table thead th {
            background-color: #f1f1f1;
            text-align: left;
            padding: 8px;
            font-size: 16px;
            font-weight: bold;
            border-bottom: 1px solid #ddd;
        }

.inner-email-table tbody tr td {
            padding: 8px;
            border-bottom: 1px solid #ddd;
            font-size: 14px;
            color: #333;
        }

/* Alternate row colors for the inner table */
        .inner-email-table tbody tr:nth-child(even) {
            background-color: #f9f9f9;
        }

.inner-email-table tbody tr:nth-child(odd) {
            background-color: #fff;
        }

.row {
            display: block;
            /* Flexbox layout for responsiveness */
            flex-wrap: wrap;
            /* Allow wrapping for smaller screens */
            margin-right: -15px;
            margin-left: -15px;
        }

.campaign-table-header {
            background-color: #343a40;
            color: #fff;
            text-align: center;
            padding: 12px;
            font-size: 18px;
            font-weight: bold;
        }

.campaign-table {
            width: 100%;
            border-collapse: collapse;
            margin-bottom: 16px;
            background-color: #f9f9f9;
            border: 1px solid #ddd;
        }

.col-md-4 {
            min-width: 95%;
        }
    </style>
    <style>
        .sideWithMainContainer {
            display: flex;
            flex-direction: row;
            gap: 10px;
            overflow-x: hidden;

}

.sideMaincontent {
            height: 100vh;
            overflow-y: scroll;
            padding: 30px 0;
        }

@media (min-width: 768px) {
            .col-md-2 {
                padding: 0px !important;
            }

}

@media (max-width: 768px) {
            .col-md-2 {
                display: none !important;
            }

}

.panelContent {
            height: 80% !important;
            overflow-y: auto !important;

}
    </style>

</head>

<div class="xpressMainConatiner" style="display: flex; flex-direction:column">
        <div class="sideWithMainContainer">
            <div class="col-md-2">
                <? include 'assets/php/sidebar.php' ?>
            </div>
            <div id="layoutSidenav" class="col-sm-12 col-md-10 sideMaincontent">
                <? include 'navbar_menu.php' ?>
                <div id="layoutSidenav_content">
                    <main>
                        <div id="panelContent" class="container-fluid">
                            <div class="container mt-5">
                                <ol class="breadcrumb my-3">
                                    <li class="breadcrumb-item w-100 d-flex flex-column flex-sm-row justify-content-between align-items-center">
                                        <h4 class="mt-1 text-center">Clicked Emails</h4>
                                        <div class="d-flex flex-column flex-sm-row mt-2 mt-sm-0">
                                            <a href="download_clicked.php" class="btn btn-outline-success ">
                                                <i class="fas fa-paper-plane"></i> Download Clicked Emails
                                            </a>
                                        </div>
                                    </li>
                                </ol>

<div class="row">
                                    <?php
                                    // Loop through campaigns and display each in a card
                                    foreach ($campaigns as $campaign_name => $emails) {
                                    ?>
                                        <div class="col-md-4">
                                            <table class="campaign-table">
                                                <thead>
                                                    <tr>
                                                        <th class="campaign-table-header">Campaign Name - <?= htmlspecialchars($campaign_name) ?> </th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    <tr>
                                                        <td class="email-table-body">
                                                            <table class="inner-email-table">
                                                                <thead>
                                                                    <tr>
                                                                        <th><i class="bi bi-envelope-fill"></i> Email Addresses</th>
                                                                    </tr>
                                                                </thead>
                                                                <tbody>
                                                                    <?php foreach ($emails as $email) { ?>
                                                                        <tr>
                                                                            <td class="email-address"><?= htmlspecialchars($email) ?></td>
                                                                        </tr>
                                                                    <?php } ?>
                                                                </tbody>
                                                            </table>
                                                        </td>
                                                    </tr>
                                                </tbody>
                                            </table>
                                        </div>

<? } ?>
                                </div>
                            </div>
                        </div>
                    </main>
                </div>
            </div>
        </div>
    </div>
    
    <script src="../assets/js/jquery-3.5.1.slim.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@1.16.1/dist/umd/popper.min.js"></script>
    <script src="../assets/js/bootstrap.bundle.min.4.5.js"></script>
</body>

</html>