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: sns_subscribe.php
Close
<?php // Define the path to the log file $logFilePath = 'log/sns_bounces.log'; // Update this path as needed // Capture the raw POST data $postData = file_get_contents('php://input'); $message = json_decode($postData, true); // $jsonData = json_encode($message, JSON_PRETTY_PRINT); // // Define the path for the JSON file // $filePath = 'log/data.json'; // // Write the JSON data to the file (creating it if it doesn’t exist) // file_put_contents($filePath, $jsonData); // Log the incoming message for debugging file_put_contents($logFilePath, date('Y-m-d H:i:s') . " - Received message: " . print_r($message, true), FILE_APPEND); // Verify the message type if (isset($message['Type'])) { if ($message['Type'] === 'SubscriptionConfirmation') { // Handle subscription confirmation $subscribeUrl = $message['SubscribeURL']; $response = file_get_contents($subscribeUrl); file_put_contents($logFilePath, date('Y-m-d H:i:s') . " - Subscription confirmed: " . print_r($response, true), FILE_APPEND); } elseif ($message['Type'] === 'Notification') { $notification = json_decode($message['Message'], true); // Handle bounce notification if (isset($notification['notificationType']) && $notification['notificationType'] === 'Bounce') { $bounce = $notification['bounce']; $bouncedRecipients = $bounce['bouncedRecipients']; foreach ($bouncedRecipients as $recipient) { $sourceEmail = $notification['mail']['source']; $emailAddress = $recipient['emailAddress']; $bounceType = $bounce['bounceType']; $bounceSubType = $bounce['bounceSubType']; $timestamp = $bounce['timestamp']; $feedbackId = $bounce['feedbackId']; $remoteMtaIp = $recipient['remoteMtaIp'] ?? ''; $diagnosticCode = $recipient['diagnosticCode'] ?? ''; $messageId = $notification['mail']['messageId']; // Save bounce information to your database saveBounce($sourceEmail, $emailAddress, $bounceType, $bounceSubType, $timestamp, $feedbackId, $remoteMtaIp, $diagnosticCode, $messageId); add_suppression_list($emailAddress, $diagnosticCode); // deleteEmailFromAllLists($emailAddress); } } } } // Respond with 200 OK http_response_code(200); // Function to save bounce information to the database using MySQLi function saveBounce($sourceEmail, $email, $type, $subType, $timestamp, $feedbackId, $remoteMtaIp, $diagnosticCode, $messageId) { include 'db.php'; // Convert ISO 8601 timestamp to MySQL DATETIME format $dateTime = new DateTime($timestamp); $formattedTimestamp = $dateTime->format('Y-m-d H:i:s'); // Check connection if ($conn->connect_error) { file_put_contents('log/sns_bounces.log', date('Y-m-d H:i:s') . " - Database connection error: " . $conn->connect_error, FILE_APPEND); return; } // Prepare and bind $stmt = $conn->prepare("INSERT INTO bounces(from_email, email, bounce_type, bounce_sub_type, timestamp, feedback_id, remote_mta_ip, diagnostic_code, message_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"); $stmt->bind_param("sssssssss", $sourceEmail, $email, $type, $subType, $formattedTimestamp, $feedbackId, $remoteMtaIp, $diagnosticCode, $messageId); // Execute the statement if ($stmt->execute() === FALSE) { file_put_contents('log/sns_bounces.log', date('Y-m-d H:i:s') . " - Database insert error: " . $stmt->error, FILE_APPEND); } // Close the statement and connection $stmt->close(); $conn->close(); } function add_suppression_list($email, $reason) { include 'db.php'; mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT); try { $stmt = $conn->prepare("INSERT INTO suppression_list(email, reason) VALUES (?,?)"); $stmt->bind_param("ss", $email, $reason); if ($stmt->execute() === FALSE) { file_put_contents('log/sns_bounces.log', date('Y-m-d H:i:s') . " - Database insert error: " . $stmt->error, FILE_APPEND); } } catch (mysqli_sql_exception $e) { if ($e->getCode() == 1062) { // 1062 is the error code for duplicate entry http_response_code(409); // HTTP status code for conflict echo 'Duplicate entry detected'; file_put_contents('log/sns_bounces.log', date('Y-m-d H:i:s') . " - Database insert error: Duplicate entry detected", FILE_APPEND); } else { // Other MySQL errors http_response_code(500); echo 'Failed to add to collection: ' . $e->getMessage(); file_put_contents('log/sns_bounces.log', date('Y-m-d H:i:s') . " - Database insert error: Failed to add to collection:" . $e->getMessage(), FILE_APPEND); } // Close the statement and connection $stmt->close(); $conn->close(); } } // function deleteEmailFromAllLists($email){ // include 'db.php'; // $stmt = $conn->prepare("DELETE FROM subscribers WHERE email = ?"); // $stmt->bind_param("s",$email); // $stmt->execute(); // $stmt->close(); // $conn->close(); // } ?>