OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	11/28/2024 11:03:35 AM	rwxrwxr-x
📄 .browserslistrc	208 bytes	08/16/2024 08:23:43 AM	rw-r--r--
📄 .gitignore	42 bytes	08/16/2024 08:23:43 AM	rw-r--r--
📄 .htaccess	803 bytes	08/16/2024 08:23:43 AM	rw-r--r--
📄 .htaccess.swp	12 KB	08/16/2024 08:23:43 AM	rw-r--r--
📄 .travis.yml	199 bytes	08/16/2024 08:23:43 AM	rw-r--r--
📄 addList.php	4.7 KB	08/16/2024 08:23:43 AM	rw-r--r--
📄 allTemplates.php	5 KB	08/16/2024 08:23:44 AM	rw-r--r--
📄 bbsns_subscribe.php	5.14 KB	08/16/2024 08:23:44 AM	rw-r--r--
📄 bcreateList.php	9.61 KB	08/16/2024 08:23:44 AM	rw-r--r--
📄 blacklist.php	14.09 KB	08/16/2024 08:23:44 AM	rw-r--r--
📄 bounceViewList.php	5.86 KB	08/16/2024 08:23:44 AM	rw-r--r--
📄 bounce_handler.php	9.87 KB	08/16/2024 08:23:44 AM	rw-r--r--
📄 bprocess_emails.php	6.73 KB	08/16/2024 08:23:44 AM	rw-r--r--
📄 checkNotificationTopics.php	5.11 KB	08/16/2024 08:23:44 AM	rw-r--r--
📁 check_identity	-	08/16/2024 08:23:47 AM	rwxr-xr-x
📄 checknotif.php	1.01 KB	08/16/2024 08:23:44 AM	rw-r--r--
📄 ckeditor.php	2.14 KB	08/16/2024 08:23:44 AM	rw-r--r--
📄 click_handler.php	1.75 KB	08/16/2024 08:23:44 AM	rw-r--r--
📄 combined.php	11.28 KB	08/16/2024 08:23:44 AM	rw-r--r--
📄 complaintsViewList.php	5.72 KB	08/16/2024 08:23:45 AM	rw-r--r--
📄 complaints_handler.php	2.89 KB	08/16/2024 08:23:45 AM	rw-r--r--
📄 composer.json	200 bytes	08/16/2024 08:23:45 AM	rw-r--r--
📄 composer.lock	39.12 KB	08/16/2024 08:23:45 AM	rw-r--r--
📄 createList.php	10.05 KB	08/16/2024 08:23:45 AM	rw-r--r--
📁 credentials	-	08/16/2024 08:23:47 AM	rwxr-xr-x
📄 csv.php	10.1 KB	08/16/2024 08:23:45 AM	rw-r--r--
📄 db.php	1000 bytes	08/16/2024 08:23:45 AM	rw-r--r--
📄 delete_list.php	565 bytes	08/16/2024 08:23:45 AM	rw-r--r--
📄 deliveryViewList.php	5.71 KB	08/16/2024 08:23:45 AM	rw-r--r--
📄 delivery_handler.php	3.25 KB	08/16/2024 08:23:45 AM	rw-r--r--
📄 download_Complaints.php	974 bytes	08/16/2024 08:23:45 AM	rw-r--r--
📄 download_bounces.php	1007 bytes	08/16/2024 08:23:45 AM	rw-r--r--
📄 download_delivered.php	971 bytes	08/16/2024 08:23:45 AM	rw-r--r--
📄 download_unique_open.php	1.6 KB	08/16/2024 08:23:45 AM	rw-r--r--
📄 edit_list.php	8.45 KB	08/16/2024 08:23:45 AM	rw-r--r--
📄 feedback.php	1.71 KB	08/16/2024 08:23:45 AM	rw-r--r--
📄 footer.php	4.71 KB	08/16/2024 08:23:45 AM	rw-r--r--
📄 housekeeping.php	10.03 KB	08/16/2024 08:23:45 AM	rw-r--r--
📄 index.php	8.12 KB	08/16/2024 08:23:45 AM	rw-r--r--
📄 insert_list.php	2.64 KB	08/16/2024 08:23:45 AM	rw-r--r--
📁 log	-	08/16/2024 08:23:52 AM	rwxr-xr-x
📄 navbar.php	1.64 KB	08/16/2024 08:23:45 AM	rw-r--r--
📄 newCompaign.php	5.94 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 open_handler.php	1.75 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 process_emails.php	10.21 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 real-recipients.csv	39.48 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 sample.csv	55 bytes	08/16/2024 08:23:46 AM	rw-r--r--
📄 send_email.php	987 bytes	08/16/2024 08:23:46 AM	rw-r--r--
📄 send_email_campaignGraph.php	2.24 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 sendgrid.php	3.62 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 showListMembers.php	4.59 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 showcase.php	7.93 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 sidebar.php	3.11 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 sns_subscribe.php	5.25 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 submit_form.php	2.48 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 test-mail.csv	337 bytes	08/16/2024 08:23:46 AM	rw-r--r--
📄 test.php	969 bytes	08/16/2024 08:23:46 AM	rw-r--r--
📄 test_process_emails.php	1.91 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 upload_image.php	606 bytes	08/16/2024 08:23:46 AM	rw-r--r--
📁 uploads	-	08/16/2024 08:24:03 AM	rwxr-xr-x
📁 vendor	-	08/16/2024 08:24:30 AM	rwxr-xr-x
📄 verify.html	486 bytes	08/16/2024 08:23:46 AM	rw-r--r--
📄 verify.php	3.12 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 verify_email.php	5.12 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 viewCampaign.php	13.05 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 viewList.php	8.53 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 zsidebar.php	3.27 KB	08/16/2024 08:23:47 AM	rw-r--r--
📄 zviewCampaign.php	8.94 KB	08/16/2024 08:23:47 AM	rw-r--r--
📄 zzprocess_emails.php	10.07 KB	08/16/2024 08:23:47 AM	rw-r--r--

Name

Size

Modified

Perms

📁 ..

11/28/2024 11:03:35 AM

rwxrwxr-x

📄 .browserslistrc

208 bytes

08/16/2024 08:23:43 AM

rw-r--r--

📄 .gitignore

42 bytes

08/16/2024 08:23:43 AM

rw-r--r--

📄 .htaccess

803 bytes

08/16/2024 08:23:43 AM

rw-r--r--

📄 .htaccess.swp

12 KB

08/16/2024 08:23:43 AM

rw-r--r--

📄 .travis.yml

199 bytes

08/16/2024 08:23:43 AM

rw-r--r--

📄 addList.php

4.7 KB

08/16/2024 08:23:43 AM

rw-r--r--

📄 allTemplates.php

5 KB

08/16/2024 08:23:44 AM

rw-r--r--

📄 bbsns_subscribe.php

5.14 KB

08/16/2024 08:23:44 AM

rw-r--r--

📄 bcreateList.php

9.61 KB

08/16/2024 08:23:44 AM

rw-r--r--

📄 blacklist.php

14.09 KB

08/16/2024 08:23:44 AM

rw-r--r--

📄 bounceViewList.php

5.86 KB

08/16/2024 08:23:44 AM

rw-r--r--

📄 bounce_handler.php

9.87 KB

08/16/2024 08:23:44 AM

rw-r--r--

📄 bprocess_emails.php

6.73 KB

08/16/2024 08:23:44 AM

rw-r--r--

📄 checkNotificationTopics.php

5.11 KB

08/16/2024 08:23:44 AM

rw-r--r--

📁 check_identity

08/16/2024 08:23:47 AM

rwxr-xr-x

📄 checknotif.php

1.01 KB

08/16/2024 08:23:44 AM

rw-r--r--

📄 ckeditor.php

2.14 KB

08/16/2024 08:23:44 AM

rw-r--r--

📄 click_handler.php

1.75 KB

08/16/2024 08:23:44 AM

rw-r--r--

📄 combined.php

11.28 KB

08/16/2024 08:23:44 AM

rw-r--r--

📄 complaintsViewList.php

5.72 KB

08/16/2024 08:23:45 AM

rw-r--r--

📄 complaints_handler.php

2.89 KB

08/16/2024 08:23:45 AM

rw-r--r--

📄 composer.json

200 bytes

08/16/2024 08:23:45 AM

rw-r--r--

📄 composer.lock

39.12 KB

08/16/2024 08:23:45 AM

rw-r--r--

📄 createList.php

10.05 KB

08/16/2024 08:23:45 AM

rw-r--r--

📁 credentials

08/16/2024 08:23:47 AM

rwxr-xr-x

📄 csv.php

10.1 KB

08/16/2024 08:23:45 AM

rw-r--r--

📄 db.php

1000 bytes

08/16/2024 08:23:45 AM

rw-r--r--

📄 delete_list.php

565 bytes

08/16/2024 08:23:45 AM

rw-r--r--

📄 deliveryViewList.php

5.71 KB

08/16/2024 08:23:45 AM

rw-r--r--

📄 delivery_handler.php

3.25 KB

08/16/2024 08:23:45 AM

rw-r--r--

📄 download_Complaints.php

974 bytes

08/16/2024 08:23:45 AM

rw-r--r--

📄 download_bounces.php

1007 bytes

08/16/2024 08:23:45 AM

rw-r--r--

📄 download_delivered.php

971 bytes

08/16/2024 08:23:45 AM

rw-r--r--

📄 download_unique_open.php

1.6 KB

08/16/2024 08:23:45 AM

rw-r--r--

📄 edit_list.php

8.45 KB

08/16/2024 08:23:45 AM

rw-r--r--

📄 feedback.php

1.71 KB

08/16/2024 08:23:45 AM

rw-r--r--

📄 footer.php

4.71 KB

08/16/2024 08:23:45 AM

rw-r--r--

📄 housekeeping.php

10.03 KB

08/16/2024 08:23:45 AM

rw-r--r--

📄 index.php

8.12 KB

08/16/2024 08:23:45 AM

rw-r--r--

📄 insert_list.php

2.64 KB

08/16/2024 08:23:45 AM

rw-r--r--

📁 log

08/16/2024 08:23:52 AM

rwxr-xr-x

📄 navbar.php

1.64 KB

08/16/2024 08:23:45 AM

rw-r--r--

📄 newCompaign.php

5.94 KB

08/16/2024 08:23:46 AM

rw-r--r--

📄 open_handler.php

1.75 KB

08/16/2024 08:23:46 AM

rw-r--r--

📄 process_emails.php

10.21 KB

08/16/2024 08:23:46 AM

rw-r--r--

📄 real-recipients.csv

39.48 KB

08/16/2024 08:23:46 AM

rw-r--r--

📄 sample.csv

55 bytes

08/16/2024 08:23:46 AM

rw-r--r--

📄 send_email.php

987 bytes

08/16/2024 08:23:46 AM

rw-r--r--

📄 send_email_campaignGraph.php

2.24 KB

08/16/2024 08:23:46 AM

rw-r--r--

📄 sendgrid.php

3.62 KB

08/16/2024 08:23:46 AM

rw-r--r--

📄 showListMembers.php

4.59 KB

08/16/2024 08:23:46 AM

rw-r--r--

📄 showcase.php

7.93 KB

08/16/2024 08:23:46 AM

rw-r--r--

📄 sidebar.php

3.11 KB

08/16/2024 08:23:46 AM

rw-r--r--

📄 sns_subscribe.php

5.25 KB

08/16/2024 08:23:46 AM

rw-r--r--

📄 submit_form.php

2.48 KB

08/16/2024 08:23:46 AM

rw-r--r--

📄 test-mail.csv

337 bytes

08/16/2024 08:23:46 AM

rw-r--r--

📄 test.php

969 bytes

08/16/2024 08:23:46 AM

rw-r--r--

📄 test_process_emails.php

1.91 KB

08/16/2024 08:23:46 AM

rw-r--r--

📄 upload_image.php

606 bytes

08/16/2024 08:23:46 AM

rw-r--r--

📁 uploads

08/16/2024 08:24:03 AM

rwxr-xr-x

📁 vendor

08/16/2024 08:24:30 AM

rwxr-xr-x

📄 verify.html

486 bytes

08/16/2024 08:23:46 AM

rw-r--r--

📄 verify.php

3.12 KB

08/16/2024 08:23:46 AM

rw-r--r--

📄 verify_email.php

5.12 KB

08/16/2024 08:23:46 AM

rw-r--r--

📄 viewCampaign.php

13.05 KB

08/16/2024 08:23:46 AM

rw-r--r--

📄 viewList.php

8.53 KB

08/16/2024 08:23:46 AM

rw-r--r--

📄 zsidebar.php

3.27 KB

08/16/2024 08:23:47 AM

rw-r--r--

📄 zviewCampaign.php

8.94 KB

08/16/2024 08:23:47 AM

rw-r--r--

📄 zzprocess_emails.php

10.07 KB

08/16/2024 08:23:47 AM

rw-r--r--

Editing: click_handler.php

<?php
include 'db.php'; // Include your database connection
$logFilePath = 'log/sns_click.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 === 'Click') {
        $stmt = $conn->prepare("INSERT INTO email_clicks (from_email, to_email, message_id, campaign_id, clicked_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();
    } 
}
?>