OXIESEC PANEL
- Current Dir:
/
/
var
/
www
/
cream
/
aws-ses
Server IP: 139.59.38.164
Upload:
Create Dir:
Name
Size
Modified
Perms
📁
..
-
06/17/2025 10:17:24 AM
rwxrwxr-x
📄
.browserslistrc
208 bytes
11/13/2024 01:46:20 PM
rw-r--r--
📄
.gitignore
42 bytes
11/13/2024 01:46:20 PM
rw-r--r--
📄
.htaccess
803 bytes
11/13/2024 01:46:21 PM
rw-r--r--
📄
.htaccess.swp
12 KB
11/13/2024 01:46:21 PM
rw-r--r--
📄
.travis.yml
199 bytes
11/13/2024 01:46:21 PM
rw-r--r--
📄
addList.php
5.23 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
aditya_navbar.php
23.72 KB
05/19/2025 10:07:21 AM
rw-r--r--
📄
allTemplates.php
5 KB
05/19/2025 10:07:21 AM
rw-r--r--
📄
b_navbar.php
7.84 KB
05/19/2025 10:07:21 AM
rw-r--r--
📄
bbsns_subscribe.php
5.14 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
bcreateList.php
9.61 KB
05/19/2025 10:07:21 AM
rw-r--r--
📄
blacklist.php
13.36 KB
05/19/2025 10:07:21 AM
rw-r--r--
📄
bounceViewList.php
8.39 KB
05/19/2025 10:07:21 AM
rw-r--r--
📄
bounce_handler.php
4.99 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
bprocess_emails.php
6.73 KB
05/19/2025 10:07:21 AM
rw-r--r--
📄
checkNotificationTopics.php
5.11 KB
05/19/2025 10:07:21 AM
rw-r--r--
📁
check_identity
-
05/19/2025 10:07:19 AM
rwxr-xr-x
📄
checknotif.php
1.01 KB
05/19/2025 10:07:21 AM
rw-r--r--
📄
ckeditor.php
2.14 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
clickViewList.php
5.13 KB
05/19/2025 10:07:21 AM
rw-r--r--
📄
click_handler.php
1.75 KB
05/19/2025 10:07:21 AM
rw-r--r--
📄
combined.php
11.23 KB
05/19/2025 10:07:21 AM
rw-r--r--
📄
complaintsViewList.php
6.78 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
complaints_handler.php
2.89 KB
05/19/2025 10:07:21 AM
rw-r--r--
📄
composer.json
200 bytes
11/15/2024 04:46:27 AM
rw-r--r--
📄
composer.lock
39.12 KB
11/15/2024 04:46:27 AM
rw-r--r--
📄
createList.php
17.4 KB
05/19/2025 10:07:21 AM
rw-r--r--
📁
credentials
-
11/13/2024 01:46:39 PM
rwxr-xr-x
📄
csv.php
11.75 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
db.php
1000 bytes
05/19/2025 10:07:19 AM
rw-r--r--
📄
deleteCampaign.php
966 bytes
05/19/2025 10:07:21 AM
rw-r--r--
📄
delete_list.php
509 bytes
05/19/2025 10:07:19 AM
rw-r--r--
📄
delete_users.php
435 bytes
05/19/2025 10:07:19 AM
rw-r--r--
📄
deliveryViewList.php
6.87 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
delivery_handler.php
3.25 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
download_Complaints.php
974 bytes
05/19/2025 10:07:19 AM
rw-r--r--
📄
download_bounces.php
1.18 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
download_clicked.php
1.23 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
download_delivered.php
1.12 KB
05/19/2025 10:07:21 AM
rw-r--r--
📄
download_open.php
1.22 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
download_report.php
3.33 KB
05/19/2025 10:07:21 AM
rw-r--r--
📄
download_unique_open.php
1.6 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
duplicate_campaign.php
1.62 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
edit_campaign.php
1.45 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
edit_list.php
9.89 KB
05/19/2025 10:07:21 AM
rw-r--r--
📄
feedback.php
1.66 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
footer.php
1.7 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
groupchatnavbar.php
607 bytes
05/19/2025 10:07:19 AM
rw-r--r--
📄
himanshu_navbar.php
7.84 KB
05/19/2025 10:07:21 AM
rw-r--r--
📄
housekeeping.php
13.27 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
index.php
8.57 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
insert_list.php
2.64 KB
05/19/2025 10:07:19 AM
rw-r--r--
📁
js
-
11/28/2024 08:16:19 AM
rwxr-xr-x
📄
load.php
159 bytes
05/19/2025 10:07:21 AM
rw-r--r--
📁
log
-
01/07/2025 11:58:15 AM
rwxr-xr-x
📄
main.css
1.3 KB
01/10/2025 10:12:55 AM
rw-r--r--
📄
navbar.php
23.77 KB
05/19/2025 10:07:21 AM
rw-r--r--
📄
newCompaign.php
11.12 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
openViewList.php
8.48 KB
05/19/2025 10:07:21 AM
rw-r--r--
📄
open_handler.php
1.75 KB
05/19/2025 10:07:21 AM
rw-r--r--
📁
process
-
05/19/2025 10:07:19 AM
rwxr-xr-x
📄
process_emails.php
11.31 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
real-recipients.csv
39.48 KB
11/15/2024 04:46:32 AM
rw-r--r--
📄
resubscribe.php
5.51 KB
05/19/2025 10:07:21 AM
rw-r--r--
📄
sample.csv
55 bytes
12/26/2024 07:07:48 AM
rw-r--r--
📄
save.php
252 bytes
05/19/2025 10:07:19 AM
rw-r--r--
📄
save_campaign.php
612 bytes
05/19/2025 10:07:19 AM
rw-r--r--
📄
saved_content.html
6.48 KB
11/28/2024 09:08:17 AM
rw-r--r--
📄
send_email.php
987 bytes
05/19/2025 10:07:19 AM
rw-r--r--
📄
send_email_campaignGraph.php
2.24 KB
05/19/2025 10:07:21 AM
rw-r--r--
📄
sendgrid.php
3.62 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
showListMembers.php
13.98 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
showcase.php
7.93 KB
05/19/2025 10:07:21 AM
rw-r--r--
📄
sidebar.php
0 bytes
05/19/2025 10:07:19 AM
rw-r--r--
📄
sns_subscribe.php
5.25 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
submit_form.php
2.48 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
test-mail.csv
337 bytes
11/15/2024 04:46:34 AM
rw-r--r--
📄
test.php
969 bytes
05/19/2025 10:07:19 AM
rw-r--r--
📄
test_process_emails.php
1.91 KB
05/19/2025 10:07:21 AM
rw-r--r--
📄
unsubscribe.php
3.8 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
upload_image.php
606 bytes
05/19/2025 10:07:19 AM
rw-r--r--
📁
uploads
-
01/06/2025 11:23:50 AM
rwxrwxrwx
📁
vendor
-
05/19/2025 10:07:21 AM
rwxr-xr-x
📄
verify.html
486 bytes
11/15/2024 04:46:35 AM
rw-r--r--
📄
verify.php
3.12 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
verify_email.php
5.12 KB
05/19/2025 10:07:21 AM
rw-r--r--
📄
viewCampaign.php
23.92 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
viewList.php
15.04 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
xpress_handler.php
9.79 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
zcreateList.php
13.51 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
znewCompaign.php
8.29 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
zprocess_emails.php
10.19 KB
05/19/2025 10:07:21 AM
rw-r--r--
📄
zviewList.php
14.63 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
zzindex.php
10.24 KB
05/19/2025 10:07:21 AM
rw-r--r--
📁
zzlog
-
05/19/2025 10:07:21 AM
rwxr-xr-x
📄
zzviewCampaign.php
22.42 KB
05/19/2025 10:07:19 AM
rw-r--r--
📄
zzviewList.php
14.63 KB
05/19/2025 10:07:19 AM
rw-r--r--
Editing: download_report.php
Close
<?php include 'db.php'; if (isset($_GET['type'], $_GET['campaignId'])) { $type = $_GET['type']; $campaignId = $_GET['campaignId']; // Define the query based on report type $queries = [ "deliveries" => " SELECT d.email, COUNT(*) AS count FROM deliveries d INNER JOIN messages m ON m.message_id = d.message_id WHERE m.campaign_id = ? GROUP BY d.email", "bounces" => " SELECT b.email, COUNT(*) AS count FROM bounces b INNER JOIN messages m ON m.message_id = b.message_id WHERE m.campaign_id = ? GROUP BY b.email", "opens" => " SELECT o.to_email AS email, COUNT(*) AS count FROM email_opens o INNER JOIN messages m ON m.message_id = o.message_id WHERE m.campaign_id = ? GROUP BY o.to_email", "clicks" => " SELECT c.to_email AS email, COUNT(*) AS count FROM email_clicks c INNER JOIN messages m ON m.message_id = c.message_id WHERE m.campaign_id = ? GROUP BY c.to_email", "not opened" => " SELECT d.email, COUNT(*) AS not_opened_count FROM deliveries d INNER JOIN messages m ON m.message_id = d.message_id LEFT JOIN email_opens o ON o.to_email = d.email AND o.message_id = m.message_id WHERE m.campaign_id = ? AND o.to_email IS NULL GROUP BY d.email" ]; if (array_key_exists($type, $queries)) { // Prepare the query and execute $query = $queries[$type]; $stmt = $conn->prepare($query); $stmt->bind_param("i", $campaignId); $stmt->execute(); $result = $stmt->get_result(); // Set headers to download the file as an Excel file header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="' . $type . '_report.xls"'); header('Cache-Control: max-age=0'); // Open PHP output stream $fp = fopen('php://output', 'w'); // Write the column headings in the first row fputcsv($fp, ['Email', 'Count']); // Ensure this header matches the columns // Check if there are any rows in the result and write them to Excel if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { // Use 'not_opened_count' for the 'not opened' report; otherwise, use 'count' $countColumn = ($type === 'not opened') ? 'not_opened_count' : 'count'; fputcsv($fp, [$row['email'], $row[$countColumn]]); } } else { // If no rows are returned, output an empty row fputcsv($fp, ['No data available', '']); } fclose($fp); // Close the output stream exit; } else { // Handle invalid 'type' values echo "Invalid report type."; } } ?>