OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	06/17/2025 10:17:24 AM	rwxrwxr-x
📄 .browserslistrc	208 bytes	01/04/2025 01:08:16 PM	rw-r--r--
📄 .gitignore	42 bytes	01/04/2025 01:08:16 PM	rw-r--r--
📄 .htaccess	803 bytes	01/04/2025 01:08:16 PM	rw-r--r--
📄 .htaccess.swp	12 KB	01/04/2025 01:08:16 PM	rw-r--r--
📄 .travis.yml	199 bytes	01/04/2025 01:08:17 PM	rw-r--r--
📄 03-01-25index.php	8.44 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 04-01-25navbar.php	23.27 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 addList.php	6.67 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 aditya_navbar.php	23.72 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 allTemplates.php	5 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 b_navbar.php	7.84 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 bbsns_subscribe.php	5.14 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 bcreateList.php	9.61 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 blacklist.php	14.78 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 bounceViewList.php	7.25 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 bounce_handler.php	5 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 bprocess_emails.php	6.73 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 checkNotificationTopics.php	5.11 KB	05/19/2025 10:07:22 AM	rw-r--r--
📁 check_identity	-	05/19/2025 10:07:21 AM	rwxr-xr-x
📄 checknotif.php	1.01 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 ckeditor.php	2.14 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 click_handler.php	1.75 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 combined.php	11.23 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 complaintsViewList.php	6.34 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 complaints_handler.php	2.89 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 composer.json	200 bytes	01/04/2025 01:08:17 PM	rw-r--r--
📄 composer.lock	39.12 KB	01/04/2025 01:08:17 PM	rw-r--r--
📄 createList.php	18.26 KB	05/19/2025 10:07:22 AM	rw-r--r--
📁 credentials	-	01/04/2025 01:08:19 PM	rwxr-xr-x
📄 csv.php	13.16 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 db.php	1000 bytes	05/19/2025 10:07:21 AM	rw-r--r--
📄 deleteCampaign.php	966 bytes	05/19/2025 10:07:22 AM	rw-r--r--
📄 delete_list.php	509 bytes	05/19/2025 10:07:21 AM	rw-r--r--
📄 delete_users.php	435 bytes	05/19/2025 10:07:21 AM	rw-r--r--
📄 deliveryViewList.php	6.15 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 delivery_handler.php	3.25 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 download_Complaints.php	974 bytes	05/19/2025 10:07:21 AM	rw-r--r--
📄 download_bounces.php	1007 bytes	05/19/2025 10:07:21 AM	rw-r--r--
📄 download_delivered.php	971 bytes	05/19/2025 10:07:22 AM	rw-r--r--
📄 download_unique_open.php	1.6 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 duplicate_campaign.php	1.62 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 edit_campaign.php	1.45 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 edit_list.php	9.89 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 feedback.php	1.66 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 footer.php	1.7 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 groupchatnavbar.php	607 bytes	05/19/2025 10:07:21 AM	rw-r--r--
📄 himanshu_navbar.php	7.84 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 housekeeping.php	15.37 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 index.php	10.79 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 insert_list.php	2.64 KB	05/19/2025 10:07:21 AM	rw-r--r--
📁 js	-	01/04/2025 01:08:19 PM	rwxr-xr-x
📄 load.php	159 bytes	05/19/2025 10:07:22 AM	rw-r--r--
📁 log	-	05/19/2025 10:07:21 AM	rwxr-xr-x
📄 main.css	1.3 KB	01/04/2025 01:08:18 PM	rw-r--r--
📄 navbar.php	22.59 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 newCompaign.php	13.16 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 open_handler.php	1.75 KB	05/19/2025 10:07:22 AM	rw-r--r--
📁 process	-	05/19/2025 10:07:21 AM	rwxr-xr-x
📄 process_emails.php	11.3 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 real-recipients.csv	39.48 KB	01/04/2025 01:08:18 PM	rw-r--r--
📄 resubscribe.php	5.51 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 sample.csv	55 bytes	01/04/2025 01:08:18 PM	rw-r--r--
📄 save.php	252 bytes	05/19/2025 10:07:21 AM	rw-r--r--
📄 save_campaign.php	612 bytes	05/19/2025 10:07:21 AM	rw-r--r--
📄 saved_content.html	6.48 KB	01/04/2025 01:08:18 PM	rw-r--r--
📄 send_email.php	987 bytes	05/19/2025 10:07:21 AM	rw-r--r--
📄 send_email_campaignGraph.php	2.24 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 sendgrid.php	3.62 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 showListMembers.php	13.98 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 showcase.php	7.93 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 sidebar.php	0 bytes	05/19/2025 10:07:21 AM	rw-r--r--
📄 sns_subscribe.php	5.25 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 submit_form.php	2.48 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 test-mail.csv	337 bytes	01/04/2025 01:08:19 PM	rw-r--r--
📄 test.php	969 bytes	05/19/2025 10:07:21 AM	rw-r--r--
📄 test_process_emails.php	1.91 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 unsubscribe.php	3.8 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 upload_image.php	606 bytes	05/19/2025 10:07:21 AM	rw-r--r--
📁 uploads	-	01/04/2025 01:08:31 PM	rwxr-xr-x
📁 vendor	-	05/19/2025 10:07:22 AM	rwxr-xr-x
📄 verify.html	486 bytes	01/04/2025 01:08:19 PM	rw-r--r--
📄 verify.php	3.12 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 verify_email.php	5.12 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 viewCampaign.php	16.58 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 viewList.php	13.77 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 zcreateList.php	13.51 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 znewCompaign.php	8.29 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 zprocess_emails.php	10.19 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 zviewList.php	14.63 KB	05/19/2025 10:07:21 AM	rw-r--r--
📄 zzindex.php	10.24 KB	05/19/2025 10:07:22 AM	rw-r--r--
📄 zzviewList.php	14.63 KB	05/19/2025 10:07:21 AM	rw-r--r--

Editing: housekeeping.php

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

// Pagination
$items_per_page = 50;
$current_page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$offset = ($current_page - 1) * $items_per_page;

// Fetch unsubscribed
$unsubscribedResult = $conn->query("SELECT s.name, s.email, s.status FROM subscribers s INNER JOIN list l ON s.list_id = l.id WHERE s.status='unsubscribed' AND l.user_id = $gUserId LIMIT $offset, $items_per_page");
$total_unsubscribed = $conn->query("SELECT COUNT(*) as count FROM subscribers WHERE status='unsubscribed'")->fetch_assoc()['count'];
$total_unsubscribed_pages = ceil($total_unsubscribed / $items_per_page);

// Fetch subscribed
$subscribedResult = $conn->query("SELECT s.name, s.email, s.status FROM subscribers s INNER JOIN list l ON s.list_id = l.id WHERE s.status = 'subscribed' AND l.user_id = $gUserId LIMIT $offset, $items_per_page");
$total_subscribed = $conn->query("SELECT COUNT(*) as count FROM subscribers WHERE status='subscribed'")->fetch_assoc()['count'];
$total_subscribed_pages = ceil($total_subscribed / $items_per_page);
?>

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

<title>Knobly Cream: Create &bull; Reach &bull; Measure</title>
    
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script>

<style>
        .table td,
        .table th {
            vertical-align: middle;
            color: #333;
        }

/* Custom Sidebar Styling */
        #layoutSidenav {
            display: flex;
            min-height: 100vh;
        }

#layoutSidenav_content {
            flex-grow: 1;
            padding-left: 0;
            /* Removed unnecessary padding */
        }

.sb-nav-fixed #layoutSidenav_content {
            padding-top: 56px;
        }

.page-link {
            border-radius: 0.25rem;
            color: white;
            /* Ensure white text for pagination in dark mode */
        }

.btn-group button,
        .btn-group a {
            margin: 0 5px;
        }

.table-responsive {
            margin-bottom: 20px;
            overflow-x: auto;
            /* Added horizontal scroll */
        }

.table thead th {
            background-color: #343a40;
            color: white;
            text-align: center;
        }

body.dark-mode .table td,
        .table th {
            vertical-align: middle;
            color: white;
        }

body.light-mode .table td,
        .table th {
            vertical-align: middle;
            Color: black;
        }

/* Pagination styling for dark mode */
        .pagination .page-item.active .page-link {
            background-color: #007bff;
            border-color: #007bff;
            color: white;
            /* White text for active page */
        }

.pagination .page-link {
            background-color: #343a40;
            border: 1px solid #343a40;
            color: white;
            /* White text for links */
        }

/* Mobile-friendly tweaks */
        @media (max-width: 768px) {
            #layoutSidenav {
                flex-direction: column;
            }

#layoutSidenav_content {
                padding-left: 15px;
            }

.pagination {
                font-size: 14px;
                /* Smaller pagination for mobile */
            }
        }

#layoutSidenav {
            max-width: 100%;
            width: 100%;
            display: flex;
            justify-content: center;
        }

.breadcrumb {
            display: -ms-flexbox;
            display: flex;
            -ms-flex-wrap: wrap;
            flex-wrap: wrap;
            padding: .75rem 0rem;
            margin-bottom: 1rem;
            list-style: none;
            background-color: transparent;
            border-radius: .25rem;
        }
    </style>
</head>

<body class="sb-nav-fixed">
    <?php include "navbar.php"; ?>
    <?php include "../assets/php/go_backbar.php"; ?>
    <div id="layoutSidenav">
        <?php include 'sidebar.php'; ?>
        <div class=" navbar-collapse " id="navbarNav">
            <ul class="navbar-nav">
                <li class="nav-item">
                    <a class="nav-link" href="createList.php"><i class="fas fa-clipboard-list"></i> All Campaigns</a>
                </li>
                <li class="nav-item">
                    <a class="nav-link" href="newCompaign.php"><i class="fas fa-calendar-plus"></i> New Campaign</a>
                </li>
                <li class="nav-item">
                    <a class="nav-link" href="addList.php"><i class="fas fa-list-alt"></i> Add List</a>
                </li>
                <li class="nav-item">
                    <a class="nav-link" href="viewList.php"><i class="fas fa-th-large"></i> View All Lists</a>
                </li>
                <li class="nav-item">
                    <a class="nav-link" href="housekeeping.php"><i class="fas fa-briefcase"></i> Housekeeping</a>
                </li>
                <li class="nav-item">
                    <a class="nav-link" href="blacklist.php"><i class="fas fa-user-times"></i> Blacklist</a>
                </li>
                <li class="nav-item">
                    <a class="nav-link" href="index.php"><i class="fas fa-mail-bulk"></i> Mail</a>
                </li>
            </ul>
        </div>
        <div id="layoutSidenav_content">
            <main>
                <div id="panelContent" class="container-fluid container-fluids col-md-8 " style="flex-direction: column;">
                    
                    <ol class="breadcrumb my-4">
                        <li class="breadcrumb-item d-flex justify-content-between align-items-center w-100">
                            <h4>Unsubscribed Users</h4>
                            <div class="btn-group" role="group">
                                <a href="resubscribe.php" class="btn btn-primary"><i class="fas fa-check"></i> Resubscribe Selected</a>

</div>
                        </li>
                    </ol>
                    <div class="table-responsive">
                        <div class="d-flex justify-content-between mb-3">
                            <input type="text" id="search-unsubscribed" class="form-control" placeholder="Search Unsubscribed Users...">
                        </div>
                        <table class="table table-bordered table-striped">
                            <thead class="thead-dark">
                                <tr>
                                    <th>Select</th>
                                    <th>Name</th>
                                    <th>Email</th>
                                    <th>Status</th>
                                    <th>Action</th>
                                </tr>
                            </thead>
                            <tbody id="unsubscribed-table-body">
                                <?php while ($row = $unsubscribedResult->fetch_assoc()): ?>
                                    <tr>
                                        <td><input type="checkbox" class="select-user" data-email="<?php echo htmlspecialchars($row['email']); ?>"></td>
                                        <td><?php echo htmlspecialchars($row['name']); ?></td>
                                        <td><?php echo htmlspecialchars($row['email']); ?></td>
                                        <td><?php echo htmlspecialchars($row['status']); ?></td>
                                        <td>
                                            <a href="delete_users.php?email=<?php echo urlencode($row['email']); ?>" class="btn btn-danger btn-sm" onclick="return confirm('Are you sure you want to remove this user?');">Remove</a>
                                        </td>
                                    </tr>
                                <?php endwhile; ?>
                            </tbody>
                        </table>
                        
                        <nav aria-label="Page navigation">
                            <ul class="pagination justify-content-center">
                                <?php for ($page = 1; $page <= $total_unsubscribed_pages; $page++): ?>
                                    <li class="page-item <?php if ($page == $current_page) echo 'active'; ?>">
                                        <a class="page-link" href="?page=<?php echo $page; ?>"><?php echo $page; ?></a>
                                    </li>
                                <?php endfor; ?>
                            </ul>
                        </nav>
                    </div>

<ol class="breadcrumb my-4">
                        <li class="breadcrumb-item d-flex justify-content-between align-items-center w-100">
                            <h4>Subscribed Users</h4>
                            <div class="btn-group" role="group">

</div>
                        </li>
                    </ol>
                    <div class="table-responsive">
                        <div class="d-flex justify-content-between mb-3">
                            <input type="text" id="search-subscribed" class="form-control" placeholder="Search Subscribed Users...">
                        </div>
                        <table class="table table-bordered table-striped">
                            <thead class="thead-dark">
                                <tr>
                                    <th>Select</th>
                                    <th>Name</th>
                                    <th>Email</th>
                                    <th>Status</th>
                                    <th>Action</th>
                                </tr>
                            </thead>
                            <tbody id="subscribed-table-body">
                                <?php while ($row = $subscribedResult->fetch_assoc()): ?>
                                    <tr>
                                        <td><input type="checkbox" class="select-user" data-email="<?php echo htmlspecialchars($row['email']); ?>"></td>
                                        <td><?php echo htmlspecialchars($row['name']); ?></td>
                                        <td><?php echo htmlspecialchars($row['email']); ?></td>
                                        <td><?php echo htmlspecialchars($row['status']); ?></td>
                                        <td>
                                            <a href="unsubscribe.php?email=<?php echo urlencode($row['email']); ?>" class="btn btn-warning btn-sm" onclick="return confirm('Are you sure you want to unsubscribe this user?');">Unsubscribe</a>
                                        </td>
                                    </tr>
                                <?php endwhile; ?>
                            </tbody>
                        </table>
                        
                        
                    </div>
                </div>
            </main>
        </div>
    </div>

// Search functionality
        $('#search-unsubscribed').on('keyup', function() {
            var searchTerm = $(this).val().toLowerCase();
            $('#unsubscribed-table-body tr').each(function() {
                var rowText = $(this).text().toLowerCase();
                $(this).toggle(rowText.indexOf(searchTerm) > -1);
            });
        });

$('#search-subscribed').on('keyup', function() {
            var searchTerm = $(this).val().toLowerCase();
            $('#subscribed-table-body tr').each(function() {
                var rowText = $(this).text().toLowerCase();
                $(this).toggle(rowText.indexOf(searchTerm) > -1);
            });
        });
    </script>

</body>

</html>