OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	11/28/2024 11:03:35 AM	rwxrwxr-x
📄 .browserslistrc	208 bytes	08/14/2024 10:49:55 AM	rw-r--r--
📄 .gitignore	42 bytes	08/14/2024 10:49:55 AM	rw-r--r--
📄 .htaccess	803 bytes	08/14/2024 10:49:55 AM	rw-r--r--
📄 .htaccess.swp	12 KB	08/14/2024 10:49:55 AM	rw-r--r--
📄 .travis.yml	199 bytes	08/14/2024 10:49:55 AM	rw-r--r--
📄 addList.php	4.7 KB	08/14/2024 10:49:55 AM	rw-r--r--
📄 allTemplates.php	5 KB	08/14/2024 10:49:55 AM	rw-r--r--
📄 bbsns_subscribe.php	5.14 KB	08/14/2024 10:49:55 AM	rw-r--r--
📄 bcreateList.php	9.61 KB	08/14/2024 10:49:56 AM	rw-r--r--
📄 blacklist.php	14.07 KB	08/22/2024 05:43:02 AM	rw-r--r--
📄 bounceViewList.php	7.67 KB	08/22/2024 05:07:15 AM	rw-r--r--
📄 bounce_handler.php	5 KB	08/23/2024 09:54:48 AM	rw-rw-rw-
📄 bprocess_emails.php	6.73 KB	08/14/2024 10:49:56 AM	rw-r--r--
📄 checkNotificationTopics.php	5.11 KB	08/14/2024 10:49:56 AM	rw-r--r--
📁 check_identity	-	08/14/2024 10:49:58 AM	rwxr-xr-x
📄 checknotif.php	1.01 KB	08/14/2024 10:49:56 AM	rw-r--r--
📄 ckeditor.php	2.14 KB	08/14/2024 10:49:56 AM	rw-r--r--
📄 click_handler.php	1.75 KB	08/14/2024 10:49:56 AM	rw-r--r--
📄 combined.php	11.28 KB	08/14/2024 10:49:56 AM	rw-r--r--
📄 complaintsViewList.php	6.8 KB	08/22/2024 05:20:43 AM	rw-r--r--
📄 complaints_handler.php	2.89 KB	08/14/2024 10:49:56 AM	rw-r--r--
📄 composer.json	200 bytes	08/14/2024 10:49:56 AM	rw-r--r--
📄 composer.lock	39.12 KB	08/14/2024 10:49:56 AM	rw-r--r--
📄 createList.php	11.23 KB	08/21/2024 11:56:25 AM	rw-r--r--
📁 credentials	-	08/14/2024 10:49:58 AM	rwxr-xr-x
📄 csv.php	10.1 KB	08/14/2024 10:49:56 AM	rw-r--r--
📄 db.php	1000 bytes	08/14/2024 10:49:56 AM	rw-r--r--
📄 delete_list.php	565 bytes	08/14/2024 10:49:56 AM	rw-r--r--
📄 delete_users.php	435 bytes	08/20/2024 04:49:00 AM	rw-r--r--
📄 deliveryViewList.php	6.6 KB	08/22/2024 05:16:19 AM	rw-r--r--
📄 delivery_handler.php	3.25 KB	08/14/2024 10:49:56 AM	rw-r--r--
📄 download_Complaints.php	974 bytes	08/14/2024 10:49:57 AM	rw-r--r--
📄 download_bounces.php	1007 bytes	08/14/2024 10:49:57 AM	rw-r--r--
📄 download_delivered.php	971 bytes	08/14/2024 10:49:57 AM	rw-r--r--
📄 download_unique_open.php	1.6 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 edit_list.php	10.01 KB	11/11/2024 12:41:09 PM	rw-r--r--
📄 feedback.php	1.71 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 footer.php	4.2 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 groupchatnavbar.php	607 bytes	09/01/2024 07:28:02 AM	rw-r--r--
📄 housekeeping.php	10.6 KB	08/20/2024 06:05:30 AM	rw-r--r--
📄 index.php	8.12 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 insert_list.php	2.64 KB	08/14/2024 10:49:57 AM	rw-r--r--
📁 log	-	08/14/2024 10:50:00 AM	rwxr-xr-x
📄 navbar.php	1.63 KB	08/20/2024 04:55:53 AM	rw-r--r--
📄 newCompaign.php	7.59 KB	08/21/2024 11:50:50 AM	rw-r--r--
📄 new_table.php	13.36 KB	10/07/2024 11:02:11 AM	rw-r--r--
📄 open_handler.php	1.75 KB	08/14/2024 10:49:57 AM	rw-r--r--
📁 process	-	08/20/2024 05:01:41 AM	rwxr-xr-x
📄 process_emails.php	10.36 KB	08/22/2024 05:44:39 AM	rw-r--r--
📄 real-recipients.csv	39.48 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 resubscribe.php	5.38 KB	08/19/2024 11:32:36 AM	rw-r--r--
📄 sample.csv	55 bytes	08/14/2024 10:49:57 AM	rw-r--r--
📄 send_email.php	987 bytes	08/14/2024 10:49:57 AM	rw-r--r--
📄 send_email_campaignGraph.php	2.24 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 sendgrid.php	3.62 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 showListMembers.php	12.44 KB	08/22/2024 05:39:43 AM	rw-r--r--
📄 showcase.php	7.93 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 sidebar.php	3.12 KB	09/01/2024 07:23:43 AM	rw-r--r--
📄 sns_subscribe.php	5.25 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 submit_form.php	2.48 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 test-mail.csv	337 bytes	08/14/2024 10:49:58 AM	rw-r--r--
📄 test.php	969 bytes	08/14/2024 10:49:58 AM	rw-r--r--
📄 test_process_emails.php	1.91 KB	08/14/2024 10:49:58 AM	rw-r--r--
📄 unsubscribe.php	3.36 KB	08/19/2024 11:32:22 AM	rw-r--r--
📄 upload_image.php	606 bytes	08/14/2024 10:49:58 AM	rw-r--r--
📁 uploads	-	03/20/2025 06:55:44 AM	rwxrwxrwx
📁 vendor	-	08/14/2024 11:08:43 AM	rwxr-xr-x
📄 verify.html	486 bytes	08/14/2024 10:49:58 AM	rw-r--r--
📄 verify.php	3.12 KB	08/14/2024 10:49:58 AM	rw-r--r--
📄 verify_email.php	5.12 KB	08/14/2024 10:49:58 AM	rw-r--r--
📄 viewCampaign.php	13.05 KB	08/21/2024 11:46:34 AM	rw-r--r--
📄 viewList.php	9.82 KB	08/21/2024 12:24:20 PM	rw-r--r--
📄 zprocess_emails.php	10.21 KB	08/14/2024 11:34:54 AM	rw-r--r--
📄 zshowListMembers.php	4.59 KB	08/14/2024 10:49:57 AM	rw-r--r--
📄 zsidebar.php	3.27 KB	08/14/2024 10:49:58 AM	rw-r--r--
📄 zviewCampaign.php	8.94 KB	08/14/2024 10:49:58 AM	rw-r--r--
📄 zzedit_list.php	8.42 KB	08/22/2024 05:34:33 AM	rw-r--r--
📄 zzprocess_emails.php	10.07 KB	08/14/2024 10:49:58 AM	rw-r--r--

Name

Size

Modified

Perms

📁 ..

11/28/2024 11:03:35 AM

rwxrwxr-x

📄 .browserslistrc

208 bytes

08/14/2024 10:49:55 AM

rw-r--r--

📄 .gitignore

42 bytes

08/14/2024 10:49:55 AM

rw-r--r--

📄 .htaccess

803 bytes

08/14/2024 10:49:55 AM

rw-r--r--

📄 .htaccess.swp

12 KB

08/14/2024 10:49:55 AM

rw-r--r--

📄 .travis.yml

199 bytes

08/14/2024 10:49:55 AM

rw-r--r--

📄 addList.php

4.7 KB

08/14/2024 10:49:55 AM

rw-r--r--

📄 allTemplates.php

5 KB

08/14/2024 10:49:55 AM

rw-r--r--

📄 bbsns_subscribe.php

5.14 KB

08/14/2024 10:49:55 AM

rw-r--r--

📄 bcreateList.php

9.61 KB

08/14/2024 10:49:56 AM

rw-r--r--

📄 blacklist.php

14.07 KB

08/22/2024 05:43:02 AM

rw-r--r--

📄 bounceViewList.php

7.67 KB

08/22/2024 05:07:15 AM

rw-r--r--

📄 bounce_handler.php

5 KB

08/23/2024 09:54:48 AM

rw-rw-rw-

📄 bprocess_emails.php

6.73 KB

08/14/2024 10:49:56 AM

rw-r--r--

📄 checkNotificationTopics.php

5.11 KB

08/14/2024 10:49:56 AM

rw-r--r--

📁 check_identity

08/14/2024 10:49:58 AM

rwxr-xr-x

📄 checknotif.php

1.01 KB

08/14/2024 10:49:56 AM

rw-r--r--

📄 ckeditor.php

2.14 KB

08/14/2024 10:49:56 AM

rw-r--r--

📄 click_handler.php

1.75 KB

08/14/2024 10:49:56 AM

rw-r--r--

📄 combined.php

11.28 KB

08/14/2024 10:49:56 AM

rw-r--r--

📄 complaintsViewList.php

6.8 KB

08/22/2024 05:20:43 AM

rw-r--r--

📄 complaints_handler.php

2.89 KB

08/14/2024 10:49:56 AM

rw-r--r--

📄 composer.json

200 bytes

08/14/2024 10:49:56 AM

rw-r--r--

📄 composer.lock

39.12 KB

08/14/2024 10:49:56 AM

rw-r--r--

📄 createList.php

11.23 KB

08/21/2024 11:56:25 AM

rw-r--r--

📁 credentials

08/14/2024 10:49:58 AM

rwxr-xr-x

📄 csv.php

10.1 KB

08/14/2024 10:49:56 AM

rw-r--r--

📄 db.php

1000 bytes

08/14/2024 10:49:56 AM

rw-r--r--

📄 delete_list.php

565 bytes

08/14/2024 10:49:56 AM

rw-r--r--

📄 delete_users.php

435 bytes

08/20/2024 04:49:00 AM

rw-r--r--

📄 deliveryViewList.php

6.6 KB

08/22/2024 05:16:19 AM

rw-r--r--

📄 delivery_handler.php

3.25 KB

08/14/2024 10:49:56 AM

rw-r--r--

📄 download_Complaints.php

974 bytes

08/14/2024 10:49:57 AM

rw-r--r--

📄 download_bounces.php

1007 bytes

08/14/2024 10:49:57 AM

rw-r--r--

📄 download_delivered.php

971 bytes

08/14/2024 10:49:57 AM

rw-r--r--

📄 download_unique_open.php

1.6 KB

08/14/2024 10:49:57 AM

rw-r--r--

📄 edit_list.php

10.01 KB

11/11/2024 12:41:09 PM

rw-r--r--

📄 feedback.php

1.71 KB

08/14/2024 10:49:57 AM

rw-r--r--

📄 footer.php

4.2 KB

08/14/2024 10:49:57 AM

rw-r--r--

📄 groupchatnavbar.php

607 bytes

09/01/2024 07:28:02 AM

rw-r--r--

📄 housekeeping.php

10.6 KB

08/20/2024 06:05:30 AM

rw-r--r--

📄 index.php

8.12 KB

08/14/2024 10:49:57 AM

rw-r--r--

📄 insert_list.php

2.64 KB

08/14/2024 10:49:57 AM

rw-r--r--

📁 log

08/14/2024 10:50:00 AM

rwxr-xr-x

📄 navbar.php

1.63 KB

08/20/2024 04:55:53 AM

rw-r--r--

📄 newCompaign.php

7.59 KB

08/21/2024 11:50:50 AM

rw-r--r--

📄 new_table.php

13.36 KB

10/07/2024 11:02:11 AM

rw-r--r--

📄 open_handler.php

1.75 KB

08/14/2024 10:49:57 AM

rw-r--r--

📁 process

08/20/2024 05:01:41 AM

rwxr-xr-x

📄 process_emails.php

10.36 KB

08/22/2024 05:44:39 AM

rw-r--r--

📄 real-recipients.csv

39.48 KB

08/14/2024 10:49:57 AM

rw-r--r--

📄 resubscribe.php

5.38 KB

08/19/2024 11:32:36 AM

rw-r--r--

📄 sample.csv

55 bytes

08/14/2024 10:49:57 AM

rw-r--r--

📄 send_email.php

987 bytes

08/14/2024 10:49:57 AM

rw-r--r--

📄 send_email_campaignGraph.php

2.24 KB

08/14/2024 10:49:57 AM

rw-r--r--

📄 sendgrid.php

3.62 KB

08/14/2024 10:49:57 AM

rw-r--r--

📄 showListMembers.php

12.44 KB

08/22/2024 05:39:43 AM

rw-r--r--

📄 showcase.php

7.93 KB

08/14/2024 10:49:57 AM

rw-r--r--

📄 sidebar.php

3.12 KB

09/01/2024 07:23:43 AM

rw-r--r--

📄 sns_subscribe.php

5.25 KB

08/14/2024 10:49:57 AM

rw-r--r--

📄 submit_form.php

2.48 KB

08/14/2024 10:49:57 AM

rw-r--r--

📄 test-mail.csv

337 bytes

08/14/2024 10:49:58 AM

rw-r--r--

📄 test.php

969 bytes

08/14/2024 10:49:58 AM

rw-r--r--

📄 test_process_emails.php

1.91 KB

08/14/2024 10:49:58 AM

rw-r--r--

📄 unsubscribe.php

3.36 KB

08/19/2024 11:32:22 AM

rw-r--r--

📄 upload_image.php

606 bytes

08/14/2024 10:49:58 AM

rw-r--r--

📁 uploads

03/20/2025 06:55:44 AM

rwxrwxrwx

📁 vendor

08/14/2024 11:08:43 AM

rwxr-xr-x

📄 verify.html

486 bytes

08/14/2024 10:49:58 AM

rw-r--r--

📄 verify.php

3.12 KB

08/14/2024 10:49:58 AM

rw-r--r--

📄 verify_email.php

5.12 KB

08/14/2024 10:49:58 AM

rw-r--r--

📄 viewCampaign.php

13.05 KB

08/21/2024 11:46:34 AM

rw-r--r--

📄 viewList.php

9.82 KB

08/21/2024 12:24:20 PM

rw-r--r--

📄 zprocess_emails.php

10.21 KB

08/14/2024 11:34:54 AM

rw-r--r--

📄 zshowListMembers.php

4.59 KB

08/14/2024 10:49:57 AM

rw-r--r--

📄 zsidebar.php

3.27 KB

08/14/2024 10:49:58 AM

rw-r--r--

📄 zviewCampaign.php

8.94 KB

08/14/2024 10:49:58 AM

rw-r--r--

📄 zzedit_list.php

8.42 KB

08/22/2024 05:34:33 AM

rw-r--r--

📄 zzprocess_emails.php

10.07 KB

08/14/2024 10:49:58 AM

rw-r--r--

Editing: open_handler.php

<?php
include 'db.php'; // Include your database connection
$logFilePath = 'log/sns_open.log'; // Update this path as needed
// Read and decode SNS message
$snsMessage = file_get_contents('php://input');
$snsMessage = json_decode($snsMessage, true);

file_put_contents($logFilePath, date('Y-m-d H:i:s') . " - Received message: " . print_r($snsMessage, true), FILE_APPEND);

if (isset($snsMessage['Type']) && $snsMessage['Type'] === 'SubscriptionConfirmation') {
    // Confirm the subscription
    $subscriptionUrl = $snsMessage['SubscribeURL'];
    file_get_contents($subscriptionUrl);
    file_put_contents($logFilePath, date('Y-m-d H:i:s') . " - Subscription confirmed: " . print_r($response, true), FILE_APPEND);
} elseif (isset($snsMessage['Type']) && $snsMessage['Type'] === 'Notification') {
    $message = json_decode($snsMessage['Message'], true);
    $eventType = $message['eventType'] ?? '';
    $fromEmail = $message['mail']['source'] ?? '';
    $toEmail = $message['mail']['destination'][0] ?? '';
    $campaignId = $message['mail']['tags']['campaign_id'] ?? null; // Ensure you tag the campaign ID when sending
    $messageId = $message['mail']['messageId'] ?? null;
    $timestamp = date('Y-m-d H:i:s');

// Process the notification based on event type
    if ($eventType === 'Open') {
        $stmt = $conn->prepare("INSERT INTO email_opens (from_email, to_email, message_id, campaign_id, opened_at) VALUES (?, ?, ?, ?, ?)");
        $stmt->bind_param("sssis",$fromEmail, $toEmail, $messageId, $campaignId, $timestamp);
        if ($stmt->execute() === FALSE) {
            file_put_contents($logFilePath, date('Y-m-d H:i:s') . " - Database insert error: " . $stmt->error, FILE_APPEND);
        }
        $stmt->close();
    }
}
?>