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: download_unique_open.php

<?php
include 'db.php';
include '../inc/config.php';
include '../inc/validate.logged.php';

$campaignId = isset($_GET['id']) ? intval($_GET['id']) : 0;

// function fetch_unique_opens($conn, $campaignId)
// {
//     $campaignsSql = "SELECT eo.email AS 'From Email', COUNT(*) AS 'Email Open' 
//                      FROM email_opens eo 
//                      INNER JOIN messages m ON eo.message_id = m.message_id 
//                      WHERE m.campaign_id = ?";
//     $stmt = $conn->prepare($campaignsSql);
//     $stmt->bind_param("i", $campaignId);
//     $stmt->execute();
//     $result = $stmt->get_result();
//     $stmt->close();
//     return $result;
// }

// $result = fetch_unique_opens($conn, $campaignId);
$sql = "SELECT from_email, to_email, COUNT(*) AS email_open
        FROM email_opens 
         WHERE from_email = '$gUserEmail'
        GROUP BY to_email";

$result = mysqli_query($conn, $sql);

if ($result) {
    // Output headers to download file
    header('Content-Type: text/csv');
    header('Content-Disposition: attachment;filename="unique_open.csv"');

// Open the output stream
    $output = fopen('php://output', 'w');
    
    // Write the column headers
    fputcsv($output, array('From Email', 'Email Open'));

// Write the rows
    while ($row = $result->fetch_assoc()) {
        fputcsv($output, $row);
    }

// Close the output stream
    fclose($output);

// Close database connection
    $conn->close();
    exit;
} else {
    echo 'Error: ' . htmlspecialchars(mysqli_error($conn));
    $conn->close();
    exit;
}
?>