OXIESEC PANEL
- Current Dir:
/
/
var
/
www
/
3-31-025chanakya
/
Xpress
Server IP: 139.59.38.164
Upload:
Create Dir:
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: zunsubscribe.php
Close
<?php include '../assets/php/db_config.php'; function handle_unsubscribe(&$message, &$messageType, &$suppressionMessage, &$suppressionMessageType) { global $mailerdb; mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT); $messageId = ""; if (isset($_GET['email'], $_GET['listId'], $_GET['campaignId'])) { $email = urldecode($_GET['email']); $listId = urldecode($_GET['listId']); $campaignId = urldecode($_GET['campaignId']); $reason = 'User unsubscribed via email link'; try { // Update the subscriber's status to 'unsubscribed' $stmt = $mailerdb->prepare("UPDATE subscribers SET status = 'unsubscribed', unsubscribed_at = NOW() WHERE email = ? AND list_id = ?"); $stmt->bind_param("si", $email, $listId); if ($stmt->execute()) { if ($stmt->affected_rows === 0) { throw new Exception("No emails found in the records ..."); return; } $message = "You have successfully unsubscribed."; $messageType = "success"; } else { $message = "There was an error processing your request."; $messageType = "danger"; } $stmt->close(); $subquery = "SELECT d.message_id FROM deliveries d INNER JOIN messages m ON d.message_id = m.message_id WHERE d.email = ? AND m.campaign_id = ?"; $stmt_subquery = $mailerdb->prepare($subquery); $stmt_subquery->bind_param("ss", $email, $campaignId); $stmt_subquery->execute(); $stmt_subquery->store_result(); // Check if the subquery returns a result if ($stmt_subquery->num_rows === 0) { // If no result was found, throw an exception throw new Exception("No records were found. It seems that wrong request is sent. Please contact <a href=\"mailto:support@knobly.com\">IT Support</a> for further support."); } // Fetch the message_id from the subquery $stmt_subquery->bind_result($messageId); $stmt_subquery->fetch(); $stmt = $mailerdb->prepare("INSERT INTO suppression_list (email, message_id, reason) VALUES (?, ?, ?)"); $stmt->bind_param("sss", $email, $messageId, $reason); if ($stmt->execute()) { $suppressionMessage = "Your email address has been added to our suppression list."; $suppressionMessageType = "success"; } else { $suppressionMessage = "Error: Could not add email to suppression list."; $suppressionMessageType = "warning"; } $stmt->close(); } catch (mysqli_sql_exception $e) { if ($mailerdb->errno == 1062) { // Duplicate entry (Suppression list or other duplicates) $message = "You have already unsubscribed."; $messageType = "warning"; $suppressionMessage = "Note: Your email is already in the suppression list. You won't be receiving any mails here on.."; $suppressionMessageType = "warning"; } else { // Generic error handling for other issues $suppressionMessage = "An error occurred: " . $e->getMessage(); $suppressionMessageType = "error"; } } catch (Exception $e) { $messageType = "danger"; $message = "There was an error processing your request."; $suppressionMessage = $e->getMessage(); $suppressionMessageType = "danger"; } } } // Initialize variables with default values $message = ""; $messageType = ""; $suppressionMessage = ""; $suppressionMessageType = ""; handle_unsubscribe($message, $messageType, $suppressionMessage, $suppressionMessageType); $mailerdb->close(); ?> <!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="../assets/css/bootstrap.min.4.5.css"> <!-- Font Awesome CSS --> <link rel="stylesheet" href="../assets/css/all.min.5.15.css"> <!-- Additional Stylesheets --> <link rel="stylesheet" href="../assets/css/animate.min.4.0.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"> <!-- Bootstrap JS and dependencies --> <script src="../assets/js/jquery-3.6.0.min.js"></script> <script src="../assets/css/popper.2.5.js"></script> <script src="../assets/js/bootstrap.bundle.min.4.5.js"></script> </head> <body class="sb-nav-fixed"> <nav class="navbar navbar-expand-lg navbar-dark"> <link rel="stylesheet" href="../assets/css/styles.css"> <div class="container"> <a class="navbar-brand" href="/stream.php"> <img src="../assets/img/logo.black.png" height="60px" alt="Logo"> </a> </div> </nav> <div id="layoutSidenav"> <div id="layoutSidenav_content"> <main class="container my-5"> <div class="alert alert-<?= $messageType; ?> text-center" role="alert"> <h4 class="alert-heading"><?= $message; ?></h4> <hr> <p class="mb-0"><?= $suppressionMessage; ?></p> </div> </main> </div> </div> </body> </html>