OXIESEC PANEL
- Current Dir:
/
/
var
/
www
/
cream
/
zzXpress
Server IP: 139.59.38.164
Upload:
Create Dir:
Name
Size
Modified
Perms
📁
..
-
06/17/2025 10:17:24 AM
rwxrwxr-x
📄
.browserslistrc
208 bytes
01/07/2025 11:52:51 AM
rw-r--r--
📄
.gitignore
42 bytes
01/07/2025 11:52:51 AM
rw-r--r--
📄
.htaccess
803 bytes
01/07/2025 11:52:51 AM
rw-r--r--
📄
.htaccess.swp
12 KB
01/07/2025 11:52:52 AM
rw-r--r--
📄
.travis.yml
199 bytes
01/07/2025 11:52:52 AM
rw-r--r--
📄
addList.php
5.23 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
aditya_navbar.php
23.72 KB
05/19/2025 10:07:24 AM
rw-r--r--
📄
allTemplates.php
5 KB
05/19/2025 10:07:24 AM
rw-r--r--
📁
assets
-
01/07/2025 11:50:15 AM
rwxr-xr-x
📄
b_navbar.php
7.84 KB
05/19/2025 10:07:24 AM
rw-r--r--
📄
bbsns_subscribe.php
5.14 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
bcreateList.php
9.61 KB
05/19/2025 10:07:24 AM
rw-r--r--
📄
blacklist.php
13.36 KB
05/19/2025 10:07:24 AM
rw-r--r--
📄
bounceViewList.php
8.39 KB
05/19/2025 10:07:24 AM
rw-r--r--
📄
bounce_handler.php
4.99 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
bprocess_emails.php
6.73 KB
05/19/2025 10:07:24 AM
rw-r--r--
📄
checkNotificationTopics.php
5.11 KB
05/19/2025 10:07:24 AM
rw-r--r--
📁
check_identity
-
05/19/2025 10:07:22 AM
rwxr-xr-x
📄
checknotif.php
1.01 KB
05/19/2025 10:07:24 AM
rw-r--r--
📄
ckeditor.php
2.14 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
clickViewList.php
5.13 KB
05/19/2025 10:07:24 AM
rw-r--r--
📄
click_handler.php
1.75 KB
05/19/2025 10:07:24 AM
rw-r--r--
📄
combined.php
11.23 KB
05/19/2025 10:07:24 AM
rw-r--r--
📄
complaintsViewList.php
6.78 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
complaints_handler.php
2.89 KB
05/19/2025 10:07:24 AM
rw-r--r--
📄
composer.json
200 bytes
01/07/2025 11:52:56 AM
rw-r--r--
📄
composer.lock
39.12 KB
01/07/2025 11:52:56 AM
rw-r--r--
📄
createList.php
17.4 KB
05/19/2025 10:07:24 AM
rw-r--r--
📁
credentials
-
01/07/2025 11:52:11 AM
rwxr-xr-x
📄
csv.php
11.75 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
db.php
1000 bytes
05/19/2025 10:07:22 AM
rw-r--r--
📄
deleteCampaign.php
966 bytes
05/19/2025 10:07:24 AM
rw-r--r--
📄
delete_list.php
509 bytes
05/19/2025 10:07:22 AM
rw-r--r--
📄
delete_users.php
435 bytes
05/19/2025 10:07:22 AM
rw-r--r--
📄
deliveryViewList.php
6.87 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
delivery_handler.php
3.25 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
download_Complaints.php
974 bytes
05/19/2025 10:07:22 AM
rw-r--r--
📄
download_bounces.php
1.18 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
download_clicked.php
1.23 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
download_delivered.php
1.12 KB
05/19/2025 10:07:24 AM
rw-r--r--
📄
download_open.php
1.22 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
download_report.php
3.33 KB
05/19/2025 10:07:24 AM
rw-r--r--
📄
download_unique_open.php
1.6 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
duplicate_campaign.php
1.62 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
edit_campaign.php
1.45 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
edit_list.php
9.89 KB
05/19/2025 10:07:24 AM
rw-r--r--
📄
feedback.php
1.66 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
footer.php
1.7 KB
05/19/2025 10:07:22 AM
rw-r--r--
📁
grfx
-
01/07/2025 11:52:13 AM
rwxr-xr-x
📄
groupchatnavbar.php
607 bytes
05/19/2025 10:07:22 AM
rw-r--r--
📄
himanshu_navbar.php
7.84 KB
05/19/2025 10:07:24 AM
rw-r--r--
📄
housekeeping.php
13.27 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
index.php
8.57 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
insert_list.php
2.64 KB
05/19/2025 10:07:22 AM
rw-r--r--
📁
js
-
01/07/2025 11:52:15 AM
rwxr-xr-x
📄
load.php
159 bytes
05/19/2025 10:07:24 AM
rw-r--r--
📁
log
-
01/07/2025 11:52:18 AM
rwxr-xr-x
📄
main.css
413 bytes
01/07/2025 11:53:01 AM
rw-r--r--
📄
navbar.php
23.77 KB
05/19/2025 10:07:24 AM
rw-r--r--
📄
newCompaign.php
11.12 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
openViewList.php
8.48 KB
05/19/2025 10:07:24 AM
rw-r--r--
📄
open_handler.php
1.75 KB
05/19/2025 10:07:24 AM
rw-r--r--
📁
process
-
05/19/2025 10:07:22 AM
rwxr-xr-x
📄
process_emails.php
11.31 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
real-recipients.csv
39.48 KB
01/07/2025 11:53:03 AM
rw-r--r--
📄
resubscribe.php
5.51 KB
05/19/2025 10:07:24 AM
rw-r--r--
📄
sample.csv
55 bytes
01/07/2025 11:53:03 AM
rw-r--r--
📄
save.php
252 bytes
05/19/2025 10:07:22 AM
rw-r--r--
📄
save_campaign.php
612 bytes
05/19/2025 10:07:22 AM
rw-r--r--
📄
saved_content.html
6.48 KB
01/07/2025 11:53:03 AM
rw-r--r--
📄
send_email.php
987 bytes
05/19/2025 10:07:22 AM
rw-r--r--
📄
send_email_campaignGraph.php
2.24 KB
05/19/2025 10:07:24 AM
rw-r--r--
📄
sendgrid.php
3.62 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
showListMembers.php
13.98 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
showcase.php
7.93 KB
05/19/2025 10:07:24 AM
rw-r--r--
📄
sidebar.php
0 bytes
05/19/2025 10:07:22 AM
rw-r--r--
📄
sns_subscribe.php
5.25 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
submit_form.php
2.48 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
test-mail.csv
337 bytes
01/07/2025 11:53:05 AM
rw-r--r--
📄
test.php
969 bytes
05/19/2025 10:07:22 AM
rw-r--r--
📄
test_process_emails.php
1.91 KB
05/19/2025 10:07:24 AM
rw-r--r--
📄
unsubscribe.php
3.8 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
upload_image.php
606 bytes
05/19/2025 10:07:22 AM
rw-r--r--
📁
uploads
-
01/07/2025 11:52:34 AM
rwxr-xr-x
📁
vendor
-
05/19/2025 10:07:24 AM
rwxr-xr-x
📄
verify.html
486 bytes
01/07/2025 11:53:06 AM
rw-r--r--
📄
verify.php
3.12 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
verify_email.php
5.12 KB
05/19/2025 10:07:24 AM
rw-r--r--
📄
viewCampaign.php
23.92 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
viewList.php
15.04 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
xpress_handler.php
9.79 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
zcreateList.php
13.51 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
znewCompaign.php
8.29 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
zprocess_emails.php
10.19 KB
05/19/2025 10:07:24 AM
rw-r--r--
📄
zviewList.php
14.63 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
zzindex.php
10.24 KB
05/19/2025 10:07:24 AM
rw-r--r--
📄
zzviewCampaign.php
22.42 KB
05/19/2025 10:07:22 AM
rw-r--r--
📄
zzviewList.php
14.63 KB
05/19/2025 10:07:22 AM
rw-r--r--
Editing: openViewList.php
Close
<?php include '../assets/php/validate.logged.php'; include 'db.php'; include '../assets/php/config.php'; include '../assets/php/function.php'; // Modified SQL query to group emails by campaign and concatenate them $sql = "SELECT c.campaign_name, GROUP_CONCAT(e.to_email SEPARATOR ', ') AS emails FROM email_opens e INNER JOIN messages m ON m.message_id = e.message_id INNER JOIN campaigns c ON c.id = m.campaign_id WHERE e.from_email = '$gUserEmail' GROUP BY c.campaign_name"; $result = mysqli_query($conn, $sql); ?> <!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 • Reach • Measure</title> <!-- Bootstrap CSS --> <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css" crossorigin="anonymous" /> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.3/css/all.min.css"> <!-- jQuery --> <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script> <!-- Font Awesome CSS --> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/animate.css/4.0.0/animate.min.css" /> <script src="https://code.jquery.com/jquery-3.5.1.min.js" integrity="sha256-9/aliU8dGd2tb6OSsuzixeV4y/faTqgFtohetphbbj0=" crossorigin="anonymous"></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> <link href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-icons/1.10.5/font/bootstrap-icons.min.css" rel="stylesheet"> <script src="../inc/common.js"></script> <!-- Custom CSS for Cards --> <style> .campaign-group { background-color: #f8f9fa; margin-top: 15px; padding: 10px; border-radius: 8px; box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1); } .campaign-name { font-weight: bold; font-size: 1.1rem; color: #333; } .email-list { margin-top: 10px; padding-left: 20px; } .email-item { font-size: 0.9rem; color: #555; padding: 5px 0; border-bottom: 1px solid #ddd; } .email-item:last-child { border-bottom: none; } .email-item a { color: #007bff; text-decoration: none; } .email-item a:hover { text-decoration: underline; } .table-responsive { margin-top: 20px; } /* Card layout for the table */ .card { margin: 10px 0; border: 1px solid #ddd; border-radius: 5px; box-shadow: 0 4px 8px rgba(0, 0, 0, 0.1); transition: box-shadow 0.3s ease-in-out; height: 100%; /* Ensures all cards are the same height */ } .card:hover { box-shadow: 0 8px 16px rgba(0, 0, 0, 0.2); } .card-header { background-color: #007bff; color: #fff; padding: 12px; font-size: 1.2rem; } .card-body { padding: 12px; height: 100%; /* Ensures equal card height */ } .email-list { list-style-type: none; padding: 0; } .email-list li { margin: 8px 0; font-size: 1rem; color: #333; } /* Centering content */ .container { max-width: 1200px; } .table-responsive { padding: 0; } /* Flexbox layout for equal card sizes */ .row { display: flex; flex-wrap: wrap; justify-content: space-between; } .col-md-4 { flex: 1 1 30%; /* Ensures three equal-width columns */ margin: 10px; } .btn-outline-success { background-color: #db5919; color: #fafafa; border-color: #db5919; } .btn-outline-success:hover { color: #fff; background-color: #db5919; border-color: #db5919; box-shadow: 0 0 0 0.2rem rgba(219, 89, 25, 0.5); } .btn-outline-success:focus { box-shadow: 0 0 0 0.2rem rgba(219, 89, 25, 0.5); } /* Responsive card sizes */ @media (max-width: 768px) { .col-md-4 { max-width: 100%; } .card { margin: 10px; } } </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="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">Email Open Details</h4> <div class="d-flex flex-column flex-sm-row mt-2 mt-sm-0"> <a href="download_open.php" class="btn btn-outline-success mb-2 mb-sm-0"> <i class="fas fa-paper-plane"></i> Download Email Opens </a> </div> </li> </ol> <!-- Card-based structure for campaigns and emails --> <div class="row"> <?php if ($result) { if (mysqli_num_rows($result) > 0) { // Display each campaign in a card while ($row = mysqli_fetch_assoc($result)) { echo '<div class="col-md-4">'; echo '<div class="card">'; echo '<div class="card-header">' . htmlspecialchars($row['campaign_name']) . '</div>'; echo '<div class="card-body">'; echo '<ul class="email-list">'; // Display emails for each campaign $emails = explode(', ', $row['emails']); foreach ($emails as $email) { echo '<li>' . htmlspecialchars($email) . '</li>'; } echo '</ul>'; echo '</div>'; echo '</div>'; echo '</div>'; } } else { echo '<div class="col-12"><div class="alert alert-info">No Opened email found</div></div>'; } } else { echo '<div class="col-12"><div class="alert alert-danger">Error: ' . htmlspecialchars(mysqli_error($conn)) . '</div></div>'; } mysqli_close($conn); ?> </div> </div> </div> </main> </div> </div> <!-- Bootstrap JS and dependencies --> <script src="https://code.jquery.com/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="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script> </body> </html>