OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	06/17/2025 10:17:24 AM	rwxrwxr-x
📄 .browserslistrc	208 bytes	03/05/2025 10:49:45 AM	rw-r--r--
📄 .gitignore	42 bytes	03/05/2025 10:49:45 AM	rw-r--r--
📄 .htaccess	803 bytes	03/05/2025 10:49:45 AM	rw-r--r--
📄 .htaccess.swp	12 KB	03/05/2025 10:49:45 AM	rw-r--r--
📄 .travis.yml	199 bytes	03/05/2025 10:49:45 AM	rw-r--r--
📄 09-01-25navbar.php	23.78 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 15-02-25viewList.php	15.21 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 17-02-25newCompaign.php	13.09 KB	05/19/2025 10:07:16 AM	rw-r--r--
📁 NLEditor	-	05/28/2025 07:37:39 AM	rwxrwxrwx
📄 addList.php	6.89 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 adi_deliveryViewList.php	11.25 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 aditya_choose.php	6.13 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 aditya_choose_template.php	7.73 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 aditya_viewCampaign.php	25.53 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 adityanewCompaign.php	18.61 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 adityaprocess_emails.php	12.93 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 arvind_choose_templates.php	11.17 KB	05/19/2025 10:07:16 AM	rw-r--r--
📁 assets	-	03/05/2025 10:50:21 AM	rwxr-xr-x
📄 back_choose_template.php	8.12 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 blacklist.php	13.47 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 bounceViewList.php	15.04 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 bounce_handler.php	5.05 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 checkNotificationTopics.php	5.11 KB	05/19/2025 10:07:17 AM	rw-r--r--
📁 check_identity	-	05/19/2025 10:07:16 AM	rwxr-xr-x
📄 checknotif.php	1.01 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 choose_template.php	9.2 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 clickViewList.php	13.34 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 click_handler.php	1.75 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 complaintsViewList.php	8.78 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 complaints_handler.php	2.89 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 composer.json	200 bytes	03/05/2025 10:49:45 AM	rw-r--r--
📄 composer.lock	39.12 KB	03/05/2025 10:49:45 AM	rw-r--r--
📄 createList.php	19.88 KB	05/19/2025 10:07:17 AM	rw-r--r--
📁 credentials	-	03/05/2025 10:49:47 AM	rwxr-xr-x
📄 csv.php	13.12 KB	05/19/2025 10:07:16 AM	rw-r--r--
📁 data	-	03/05/2025 10:50:45 AM	rwxr-xr-x
📄 db.php	1000 bytes	05/19/2025 10:07:16 AM	rw-r--r--
📄 deleteCampaign.php	966 bytes	05/19/2025 10:07:17 AM	rw-r--r--
📄 deleteTemplate.php	1.55 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 delete_list.php	903 bytes	05/19/2025 10:07:16 AM	rw-r--r--
📄 delete_users.php	435 bytes	05/19/2025 10:07:16 AM	rw-r--r--
📄 deliveryViewList.php	13.13 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 delivery_handler.php	3.25 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 download_Complaints.php	1.16 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 download_bounces.php	1.18 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 download_clicked.php	1.23 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 download_delivered.php	1.12 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 download_open.php	1.22 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 download_report.php	3.33 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 download_unique_open.php	1.6 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 duplicate_campaign.php	1.62 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 edit_campaign.php	1.45 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 edit_list.php	11.92 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 feedback.php	1.66 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 fetch_template.php	493 bytes	05/19/2025 10:07:16 AM	rw-r--r--
📄 footer.php	1.36 KB	05/19/2025 10:07:16 AM	rw-r--r--
📁 grfx	-	03/05/2025 10:49:48 AM	rwxr-xr-x
📄 himanshu_index.php	6.66 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 himanshu_newCompaign.php	11.92 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 housekeeping.php	25.61 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 index.php	10.15 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 insert_list.php	2.64 KB	05/19/2025 10:07:16 AM	rw-r--r--
📁 js	-	03/05/2025 10:49:48 AM	rwxr-xr-x
📄 load.php	159 bytes	05/19/2025 10:07:17 AM	rw-r--r--
📁 log	-	03/05/2025 10:49:56 AM	rwxr-xr-x
📄 main.css	1.3 KB	03/05/2025 11:02:42 AM	rw-r--r--
📄 navbar.php	22.64 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 navbar_menu.php	1.89 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 newCompaign.php	16.72 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 obc_cards.php	8.25 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 openViewList.php	14.75 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 open_handler.php	1.75 KB	05/19/2025 10:07:17 AM	rw-r--r--
📁 process	-	05/19/2025 10:07:16 AM	rwxr-xr-x
📄 process_emails.php	13.27 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 real-recipients.csv	39.48 KB	03/05/2025 10:49:46 AM	rw-r--r--
📄 resubscribe.php	7.17 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 sample.csv	55 bytes	03/05/2025 10:49:46 AM	rw-r--r--
📄 save.php	252 bytes	05/19/2025 10:07:16 AM	rw-r--r--
📄 save_campaign.php	612 bytes	05/19/2025 10:07:16 AM	rw-r--r--
📄 saved_content.html	8 bytes	05/14/2025 08:36:09 AM	rw-r--r--
📄 send_email.php	987 bytes	05/19/2025 10:07:16 AM	rw-r--r--
📄 send_email_campaignGraph.php	2.24 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 sendgrid.php	3.62 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 showListMembers.php	12.16 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 showcase.php	7.93 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 sidebar.php	0 bytes	05/19/2025 10:07:16 AM	rw-r--r--
📄 sns_subscribe.php	5.25 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 submit_form.php	2.48 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 template_index.php	10.29 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 test-mail.csv	337 bytes	03/05/2025 10:49:47 AM	rw-r--r--
📄 test.php	969 bytes	05/19/2025 10:07:16 AM	rw-r--r--
📄 test_choose_template.php	6.85 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 test_process_emails.php	1.91 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 unsubscribe.php	7.63 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 upload_image.php	606 bytes	05/19/2025 10:07:16 AM	rw-r--r--
📁 uploads	-	05/23/2025 09:06:53 AM	rwxrwxrwx
📁 vendor	-	05/19/2025 10:07:17 AM	rwxr-xr-x
📄 verify.html	486 bytes	03/05/2025 10:49:47 AM	rw-r--r--
📄 verify.php	3.12 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 verify_email.php	5.12 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 viewCampaign.php	27.83 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 viewList.php	18.1 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 xpress_handler.php	10.38 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 znewCompaign.php	11.22 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 zunsubscribe.php	6.02 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 zzindex.php	6.89 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 zzzzindex.php	6.76 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 zzzzzindex.php	6.88 KB	05/19/2025 10:07:17 AM	rw-r--r--

Editing: showListMembers.php

<?php
ini_set('display_startup_errors', 1);
include '../assets/php/validate.logged.php';
include 'db.php';
include '../assets/php/config.php';
include '../assets/php/function.php';

$list_name = '';
if (isset($_GET['id'])) {
    $list_id = $_GET['id'];
}

// Function to check and get list name
function check_list($conn, $user_id, $list_id)
{
    $list_name = '';
    $sql = "SELECT list_name FROM list WHERE id = ? AND user_id = ?";
    if ($stmt = $conn->prepare($sql)) {
        $stmt->bind_param("ii", $list_id, $user_id);
        $stmt->execute();
        $stmt->store_result();
        if ($stmt->num_rows > 0) {
            $stmt->bind_result($list_name);
            if ($stmt->fetch()) {
                return $list_name;
            }
        }
        $stmt->close();
    }
    return null;
}

$list_name = check_list($conn, $gUserId, $list_id);

if ($list_name === null) {
    die("Error!!!!.. List not found");
}

// Export to CSV functionality
if (isset($_GET['export']) && $_GET['export'] === 'csv') {
    $filename = 'subscribers_list_' . $list_id . '.csv';
    header('Content-Type: text/csv');
    header('Content-Disposition: attachment;filename="' . $filename . '"');

$output = fopen('php://output', 'w');

// Set CSV column headers
    fputcsv($output, ['ID', 'Name', 'Email', 'Status', 'Last Activity']);

$sql = "SELECT id, name, email, status, last_activity FROM subscribers WHERE list_id = ?";
    if ($stmt = $conn->prepare($sql)) {
        $stmt->bind_param("i", $list_id);
        $stmt->execute();
        $result = $stmt->get_result();

while ($data = $result->fetch_assoc()) {
            fputcsv($output, [$data['id'], $data['name'], $data['email'], $data['status'], $data['last_activity']]);
        }
        $stmt->close();
    }

fclose($output);
    exit;
}

// Initialize status counters
$activity_counts = ['Bounced' => 0, 'Subscribed' => 0, 'Unsubscribed' => 0];

// Fetch subscriber details
$sql = "SELECT id, name, email, status, last_activity FROM subscribers WHERE list_id = ?";
if ($stmt = $conn->prepare($sql)) {
    $stmt->bind_param("i", $list_id);
    $stmt->execute();
    $result = $stmt->get_result();

while ($row = $result->fetch_assoc()) {
        $status = $row['status'] ?? 'Unknown';

// Count statuses
        if ($status === 'bounced') {
            $activity_counts['Bounced']++;
        } elseif ($status === 'unsubscribed') {
            $activity_counts['Unsubscribed']++;
        } else {
            $activity_counts['Subscribed']++;
        }
    }
    $stmt->close();
}

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Knobly Cream: Create &bull; Reach &bull; Measure</title>
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.4/css/all.min.css">
    <link rel="stylesheet" href="../inc/style.css">
    <link href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-icons/1.10.5/font/bootstrap-icons.min.css" rel="stylesheet">
    <script src="https://cdn.jsdelivr.net/npm/chart.js"></script>

.btn-group {
            margin-right: 10px;
        }

.btn {
            margin-right: 10px;
        }

.btn-outline-danger,
        .btn-outline-success,
        .btn-outline-warning {
            border-width: 2px;
        }

.btn-outline-danger {
            color: #dc3545;
            border-color: #dc3545;
        }

.btn-outline-success {
            color: #28a745;
            border-color: #28a745;
        }

.btn-outline-warning {
            color: #ffc107;
            border-color: #ffc107;
        }

.btn-success {
            background-color: #28a745;
            border-color: #28a745;
        }

.btn-primary {
            background-color: #007bff;
            border-color: #007bff;
        }

.btn-outline-danger:hover {
            background-color: #dc3545;
            color: #fff;
        }

.btn-outline-success:hover {
            background-color: #28a745;
            color: #fff;
        }

.btn-outline-warning:hover {
            background-color: #ffc107;
            color: #212529;
        }

.btn-success:hover {
            background-color: #218838;
            border-color: #1e7e34;
        }

.btn-primary:hover {
            background-color: #0056b3;
            border-color: #004085;
        }

.graph-container {
            position: relative;
            max-width: 100%;
            height: 300px;
        }

.table-responsive {
            display: block;
            overflow-x: auto;
            white-space: nowrap;
        }

@media (max-width: 768px) {
            .breadcrumb-item h4 {
                font-size: 18px;
            }

.btn-group {
                flex-wrap: wrap;
            }

.btn {
                width: 100%;
                margin-bottom: 10px;
            }

.graph-container {
                height: auto;
            }
        }
    </style>
    <style>
        .sideWithMainContainer {
            display: flex;
            flex-direction: row;
            gap: 10px;
            overflow-x: hidden;

}

.sideMaincontent {
            height: 100vh;
            overflow-y: scroll;
            padding: 30px 0;
        }

@media (min-width: 768px) {
            .col-md-2 {
                padding: 0px !important;
            }

}

@media (max-width: 768px) {
            .col-md-2 {
                display: none !important;
            }

}

.panelContent {
            height: 80% !important;
            overflow-y: auto !important;

}
    </style>
</head>

</li>
                                    </ol>

<div class="table-responsive mt-4">
                                        <table class="table table-striped">
                                            <thead>
                                                <tr>
                                                    <th>Name</th>
                                                    <th>Email</th>

<th>Status</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php
                                                // Re-fetch subscriber details for table display
                                                $sql_table = "SELECT id, name, email, last_activity, status FROM subscribers WHERE list_id = ?";
                                                if ($stmt_table = $conn->prepare($sql_table)) {
                                                    $stmt_table->bind_param("i", $list_id);
                                                    $stmt_table->execute();
                                                    $result_table = $stmt_table->get_result();

if ($result_table->num_rows > 0) {
                                                        while ($row = $result_table->fetch_assoc()) {
                                                            echo "<tr>";
                                                            echo "<td>" . htmlspecialchars($row['name'] ?? 'N/A') . "</td>";
                                                            echo "<td>" . htmlspecialchars($row['email'] ?? 'N/A') . "</td>";

echo "<td>" . htmlspecialchars($row['status'] ?? 'Unknown') . "</td>";
                                                            echo "</tr>";
                                                        }
                                                    } else {
                                                        echo "<tr><td colspan='4'>No subscribers found</td></tr>";
                                                    }
                                                }
                                                ?>
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </main>
                </div>
            </div>

</div>
        <?php include 'footer.php'; ?>
        <?php include '../assets/php/bottom_navbar.php'; ?>

</div>

</body>

</html>