OXIESEC PANEL
- Current Dir:
/
/
var
/
www
/
cream
/
Xpress_backup
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/06/2025 07:58:55 AM
rw-r--r--
📄
.gitignore
42 bytes
01/06/2025 07:58:55 AM
rw-r--r--
📄
.htaccess
803 bytes
01/06/2025 07:58:55 AM
rw-r--r--
📄
.htaccess.swp
12 KB
01/06/2025 07:58:56 AM
rw-r--r--
📄
.travis.yml
199 bytes
01/06/2025 07:58:56 AM
rw-r--r--
📄
09-01-25navbar.php
23.78 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
15-02-25viewList.php
15.21 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
17-02-25newCompaign.php
13.09 KB
05/19/2025 10:07:17 AM
rw-r--r--
📁
NLEditor
-
05/19/2025 10:07:19 AM
rwxr-xr-x
📄
addList.php
5.65 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
adi_deliveryViewList.php
11.25 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
aditya_choose.php
6.13 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
aditya_viewCampaign.php
25.53 KB
05/19/2025 10:07:19 AM
rwxrwxrwx
📁
assets
-
01/06/2025 08:00:13 AM
rwxr-xr-x
📄
back_choose_template.php
8.12 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
blacklist.php
13.47 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
bounceViewList.php
13.28 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
bounce_handler.php
5.05 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
checkNotificationTopics.php
5.11 KB
05/19/2025 10:07:19 AM
rw-r--r--
📁
check_identity
-
05/19/2025 10:07:17 AM
rwxr-xr-x
📄
checknotif.php
1.01 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
choose_template.php
9.73 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
clickViewList.php
11.72 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
click_handler.php
1.75 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
complaintsViewList.php
7.43 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
complaints_handler.php
2.89 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
composer.json
200 bytes
01/06/2025 07:59:01 AM
rw-r--r--
📄
composer.lock
39.12 KB
01/06/2025 07:59:01 AM
rw-r--r--
📄
createList.php
17.48 KB
05/19/2025 10:07:19 AM
rw-r--r--
📁
credentials
-
01/06/2025 08:01:45 AM
rwxr-xr-x
📄
csv.php
11.8 KB
05/19/2025 10:07:17 AM
rw-r--r--
📁
data
-
03/03/2025 11:56:59 AM
rwxrwxrwx
📄
db.php
1000 bytes
05/19/2025 10:07:17 AM
rw-r--r--
📄
deleteCampaign.php
966 bytes
05/19/2025 10:07:19 AM
rw-r--r--
📄
delete_list.php
903 bytes
05/19/2025 10:07:17 AM
rw-r--r--
📄
delete_users.php
435 bytes
05/19/2025 10:07:17 AM
rw-r--r--
📄
deliveryViewList.php
11.45 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
delivery_handler.php
3.25 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
download_Complaints.php
1.16 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
download_bounces.php
1.18 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
download_clicked.php
1.23 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
download_delivered.php
1.12 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
download_open.php
1.22 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
download_report.php
3.33 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
download_unique_open.php
1.6 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
duplicate_campaign.php
1.62 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
edit_campaign.php
1.45 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
edit_list.php
9.99 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
feedback.php
1.66 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
fetch_template.php
493 bytes
05/19/2025 10:07:17 AM
rw-r--r--
📄
footer.php
1.7 KB
05/19/2025 10:07:17 AM
rw-r--r--
📁
grfx
-
01/06/2025 08:01:47 AM
rwxrwxrwx
📄
himanshu_index.php
6.66 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
himanshu_newCompaign.php
11.92 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
housekeeping.php
23.07 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
index.php
7.95 KB
05/19/2025 10:07:17 AM
rwxrwxrwx
📄
insert_list.php
2.64 KB
05/19/2025 10:07:17 AM
rw-r--r--
📁
js
-
01/06/2025 08:01:49 AM
rwxr-xr-x
📄
load.php
159 bytes
05/19/2025 10:07:19 AM
rw-r--r--
📁
log
-
01/07/2025 07:47:04 AM
rwxrwxrwx
📄
main.css
1.32 KB
01/09/2025 10:38:27 AM
rw-r--r--
📄
navbar.php
22.64 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
navbar_menu.php
1.65 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
newCompaign.php
14.61 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
obc_cards.php
8.25 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
openViewList.php
13.25 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
open_handler.php
1.75 KB
05/19/2025 10:07:19 AM
rw-r--r--
📁
process
-
05/19/2025 10:07:17 AM
rwxrwxrwx
📄
process_emails.php
11.96 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
real-recipients.csv
39.48 KB
01/06/2025 07:59:07 AM
rw-r--r--
📄
resubscribe.php
5.61 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
sample.csv
55 bytes
01/06/2025 07:59:08 AM
rw-r--r--
📄
save.php
252 bytes
05/19/2025 10:07:17 AM
rw-r--r--
📄
save_campaign.php
612 bytes
05/19/2025 10:07:17 AM
rw-r--r--
📄
saved_content.html
6.48 KB
01/07/2025 11:02:10 AM
rw-r--r--
📄
send_email.php
987 bytes
05/19/2025 10:07:17 AM
rwxrwxrwx
📄
send_email_campaignGraph.php
2.24 KB
05/19/2025 10:07:19 AM
rwxrwxrwx
📄
sendgrid.php
3.62 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
showListMembers.php
10.69 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
showcase.php
7.93 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
sidebar.php
0 bytes
05/19/2025 10:07:17 AM
rw-r--r--
📄
sns_subscribe.php
5.25 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
submit_form.php
2.48 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
template_index.php
7.37 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
test-mail.csv
337 bytes
01/06/2025 07:59:10 AM
rw-r--r--
📄
test.php
969 bytes
05/19/2025 10:07:17 AM
rw-r--r--
📄
test_process_emails.php
1.91 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
unsubscribe.php
7.63 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
upload_image.php
606 bytes
05/19/2025 10:07:17 AM
rw-r--r--
📁
uploads
-
03/03/2025 01:00:59 PM
rwxrwxrwx
📁
vendor
-
05/19/2025 10:07:19 AM
rwxr-xr-x
📄
verify.html
486 bytes
01/06/2025 07:59:11 AM
rw-r--r--
📄
verify.php
3.12 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
verify_email.php
5.12 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
viewCampaign.php
25.37 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
viewList.php
16.51 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
xpress_handler.php
10.38 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
znewCompaign.php
11.22 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
zunsubscribe.php
6.02 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
zzindex.php
6.89 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
zzzzindex.php
6.76 KB
05/19/2025 10:07:17 AM
rw-r--r--
📄
zzzzzindex.php
6.88 KB
05/19/2025 10:07:19 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="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css"> <!-- Font Awesome CSS --> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.4/css/all.min.css"> <!-- Additional Stylesheets --> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/animate.css/4.0.0/animate.min.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="https://code.jquery.com/jquery-3.6.0.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.5.3/dist/umd/popper.min.js"></script> <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.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>