OXIESEC PANEL

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--

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: 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;
}
?>