OXIESEC PANEL
- Current Dir:
/
/
var
/
www
/
cream
/
reader
/
znew1aws-ses
Server IP: 139.59.38.164
Upload:
Create Dir:
Name
Size
Modified
Perms
📁
..
-
03/04/2025 08:32:49 AM
rwxr-xr-x
📄
.browserslistrc
208 bytes
03/03/2025 08:18:55 AM
rw-r--r--
📄
.gitignore
42 bytes
03/03/2025 08:18:55 AM
rw-r--r--
📄
.htaccess
803 bytes
03/03/2025 08:18:55 AM
rw-r--r--
📄
.htaccess.swp
12 KB
03/03/2025 08:18:55 AM
rw-r--r--
📄
.travis.yml
199 bytes
03/03/2025 08:18:55 AM
rw-r--r--
📄
addList.php
4.7 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
allTemplates.php
5 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
bbsns_subscribe.php
5.14 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
bcreateList.php
9.61 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
blacklist.php
14.09 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
bounceViewList.php
5.86 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
bounce_handler.php
9.87 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
bprocess_emails.php
6.73 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
checkNotificationTopics.php
5.11 KB
05/19/2025 10:07:15 AM
rw-r--r--
📁
check_identity
-
05/19/2025 10:07:15 AM
rwxr-xr-x
📄
checknotif.php
1.01 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
ckeditor.php
2.14 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
click_handler.php
1.75 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
combined.php
11.23 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
complaintsViewList.php
5.72 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
complaints_handler.php
2.89 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
composer.json
200 bytes
03/03/2025 08:18:56 AM
rw-r--r--
📄
composer.lock
39.12 KB
03/03/2025 08:18:56 AM
rw-r--r--
📄
createList.php
10.05 KB
05/19/2025 10:07:15 AM
rw-r--r--
📁
credentials
-
03/03/2025 08:25:28 AM
rwxr-xr-x
📄
csv.php
10.1 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
db.php
1000 bytes
05/19/2025 10:07:15 AM
rw-r--r--
📄
delete_list.php
509 bytes
05/19/2025 10:07:15 AM
rw-r--r--
📄
deliveryViewList.php
5.71 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
delivery_handler.php
3.25 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
download_Complaints.php
974 bytes
05/19/2025 10:07:15 AM
rw-r--r--
📄
download_bounces.php
1007 bytes
05/19/2025 10:07:15 AM
rw-r--r--
📄
download_delivered.php
971 bytes
05/19/2025 10:07:15 AM
rw-r--r--
📄
download_unique_open.php
1.6 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
edit_list.php
8.39 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
feedback.php
1.66 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
footer.php
4.71 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
housekeeping.php
9.97 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
index.php
8.12 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
insert_list.php
2.64 KB
05/19/2025 10:07:15 AM
rw-r--r--
📁
log
-
05/19/2025 10:07:15 AM
rwxr-xr-x
📄
navbar.php
1.64 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
newCompaign.php
5.94 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
open_handler.php
1.75 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
process_emails.php
10.21 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
real-recipients.csv
39.48 KB
03/03/2025 08:18:56 AM
rw-r--r--
📄
sample.csv
55 bytes
03/03/2025 08:18:56 AM
rw-r--r--
📄
send_email.php
987 bytes
05/19/2025 10:07:15 AM
rw-r--r--
📄
send_email_campaignGraph.php
2.24 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
sendgrid.php
3.62 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
showListMembers.php
4.54 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
showcase.php
7.93 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
sidebar.php
3.11 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
sns_subscribe.php
5.25 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
submit_form.php
2.48 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
test-mail.csv
337 bytes
03/03/2025 08:18:56 AM
rw-r--r--
📄
test.php
969 bytes
05/19/2025 10:07:15 AM
rw-r--r--
📄
test_process_emails.php
1.91 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
upload_image.php
606 bytes
05/19/2025 10:07:15 AM
rw-r--r--
📁
uploads
-
03/03/2025 08:25:38 AM
rwxr-xr-x
📁
vendor
-
05/19/2025 10:07:15 AM
rwxr-xr-x
📄
verify.html
486 bytes
03/03/2025 08:18:56 AM
rw-r--r--
📄
verify.php
3.12 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
verify_email.php
5.12 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
viewCampaign.php
13.05 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
viewList.php
8.47 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
zsidebar.php
3.27 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
zviewCampaign.php
8.94 KB
05/19/2025 10:07:15 AM
rw-r--r--
📄
zzprocess_emails.php
10.07 KB
05/19/2025 10:07:15 AM
rw-r--r--
Editing: delivery_handler.php
Close
<?php // Define the path to the log file $logFilePath = 'log/sns_deliveries.log'; // Update this path as needed // Capture the raw POST data $postData = file_get_contents('php://input'); $message = json_decode($postData, true); // 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 delivery notification if (isset($notification['notificationType']) && $notification['notificationType'] === 'Delivery') { $delivery = $notification['delivery']; $deliveryRecipients = $delivery['recipients']; foreach ($deliveryRecipients as $recipient) { $sourceEmail = $notification['mail']['source']; $timestamp = $delivery['timestamp']; $feedbackId = $delivery['feedbackId'] ?? ''; $remoteMtaIp = $delivery['remoteMtaIp'] ?? ''; $diagnosticCode = $recipient['diagnosticCode'] ?? ''; $emailAddress = $notification['mail']['destination']; $messageId = $notification['mail']['messageId']; foreach ($notification['mail']['destination'] as $emailAddress) { // Save delivery information to your database saveDelivery($sourceEmail, $emailAddress, $messageId, $timestamp, $feedbackId, $remoteMtaIp, $diagnosticCode); } } } } } // Respond with 200 OK http_response_code(200); // Function to save delivery information to the database using MySQLi function saveDelivery($sourceEmail, $email, $messageId, $timestamp, $feedbackId, $remoteMtaIp, $diagnosticCode) { 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_deliveries.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 deliveries(from_email, email, message_id, timestamp, feedback_id, remote_mta_ip, diagnostic_code) VALUES (?, ?, ?, ?, ?, ?, ?)"); $stmt->bind_param("sssssss", $sourceEmail, $email, $messageId, $formattedTimestamp, $feedbackId, $remoteMtaIp, $diagnosticCode); // Execute the statement if ($stmt->execute() === FALSE) { file_put_contents('log/sns_deliveries.log', date('Y-m-d H:i:s') . " - Database insert error: " . $stmt->error, FILE_APPEND); } // Close the statement and connection $stmt->close(); $conn->close(); }