OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	03/31/2025 06:36:42 AM	rwxr-xr-x
📁 PHPMailer	-	03/26/2025 04:07:42 AM	rwxr-xr-x
📄 addPro.php	800 bytes	03/26/2025 03:48:03 AM	rw-r--r--
📄 dash.php	0 bytes	03/26/2025 03:48:03 AM	rw-r--r--
📄 dashboard.php	8.86 KB	03/26/2025 03:48:03 AM	rw-r--r--
📄 db_connect.php	292 bytes	03/26/2025 03:48:03 AM	rw-r--r--
📄 mail.php	2.01 KB	03/26/2025 03:48:03 AM	rw-r--r--
📄 proUsers.php	8.8 KB	03/26/2025 03:48:03 AM	rw-r--r--
📄 send_otp.php	1.38 KB	03/26/2025 03:48:03 AM	rw-r--r--
📄 userActivity.php	9.79 KB	03/26/2025 03:48:03 AM	rw-r--r--
📄 verification.php	4.71 KB	03/26/2025 03:48:03 AM	rw-r--r--
📄 verify_otp.php	644 bytes	03/26/2025 03:48:03 AM	rw-r--r--

Editing: proUsers.php

<?
include 'db_connect.php';
include '../assets/php/validate.logged.php';

$expiration_time = 15 * 60;
if (isset($_SESSION['admin_set_time']) && (time() - $_SESSION['admin_set_time']) > $expiration_time) {
    unset($_SESSION['admin']); 
    unset($_SESSION['admin_set_time']);
}

if(isset($_SESSION['admin'])&&( $gUserId==23 && $_SESSION['admin']=="verified" )){

$sql = "SELECT c.full_name,q.userId,q.start_date,q.end_date,q.plan_type FROM user c 
JOIN cream_subscription q where c.id=q.userId";
    // $sql = "SELECT * FROM user WHERE date_created BETWEEN ? AND ?";
    $stmt = $conn->prepare($sql);
    $stmt->execute();
    $result = $stmt->get_result();

if ($result->num_rows > 0) {
        while ($row = $result->fetch_assoc()) {
            $users[] = $row;
        }
    } else {
        $users = ["message" => "No records found in the given date range"];
    }

$stmt->close();

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

<head>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <title>Pro users</title>
        <style>
            body {
                font-family: 'Roboto', sans-serif;
                /* Modern font */
                background-color: #f4f4f4;
                margin: 0;
                padding: 0;
                display: flex;
                justify-content: center;
                align-items: center;
                min-height: 100vh;
                color: #333;
                /* Darker default text color */
            }

.container {
                background-color: #fff;
                padding: 30px;
                /* Increased padding */
                border-radius: 10px;
                /* More rounded corners */
                box-shadow: 0 4px 8px rgba(0, 0, 0, 0.1);
                /* More prominent shadow */
                width: 90%;
                max-width: 960px;
            }

h1 {
                color: #2c3e50;
                /* Darker heading color */
                margin-bottom: 25px;
                /* Increased margin */
                text-align: center;
                /* Centered heading */
            }

.form-group {
                margin-bottom: 20px;
                /* Increased margin */
            }

label {
                display: block;
                margin-bottom: 8px;
                /* Increased margin */
                color: #7f8c8d;
                /* Lighter label color */
                font-weight: 500;
                /* Slightly bolder labels */
            }

input[type="number"],
            input[type="datetime-local"] {
                width: calc(50% - 22px);
                padding: 12px;
                /* Increased padding */
                border: 1px solid #bdc3c7;
                /* Lighter border color */
                border-radius: 6px;
                /* More rounded corners */
                box-sizing: border-box;
                font-size: 16px;
                /* Increased font size */
                transition: border-color 0.3s ease;
                /* Smooth border transition */
            }

input[type="number"]:focus,
            input[type="datetime-local"]:focus {
                border-color: #3498db;
                /* Highlight on focus */
                outline: none;
                box-shadow: 0 0 5px rgba(52, 152, 219, 0.2);
                /* Subtle shadow on focus */
            }

button {
                background-color: #3498db;
                /* Modern blue */
                color: #fff;
                padding: 12px 20px;
                /* Increased padding */
                border: none;
                border-radius: 6px;
                /* More rounded corners */
                cursor: pointer;
                font-size: 16px;
                /* Increased font size */
                transition: background-color 0.3s ease;
                /* Smooth hover transition */
            }

button:hover {
                background-color: #2980b9;
                /* Darker blue on hover */
            }

.filter-buttons {
                margin-bottom: 25px;
                /* Increased margin */
            }

table {
                width: 100%;
                border-collapse: collapse;
                margin-top: 25px;
                /* Increased margin */
                box-shadow: 0 2px 4px rgba(0, 0, 0, 0.1);
                /* Table shadow */
                border-radius: 8px;
                overflow: hidden;
                /* Prevents border radius from being cut off */
            }

th,
            td {
                padding: 15px;
                /* Increased padding */
                border: none;
                /* Removed default borders */
                text-align: left;
                background-color: #fff;
                /* White background for cells */
            }

th {
                background-color: #ecf0f1;
                /* Light gray for header */
                font-weight: 600;
                /* Slightly bolder header */
                color: #7f8c8d;
                /* Lighter header text */
                padding: 18px;
                /* Increased header padding */
            }

tr:nth-child(even) {
                background-color: #f9f9f9;
                /* Subtle row background */
            }

p {
                color: #7f8c8d;
                /* Lighter paragraph color */
                margin-top: 10px;
                /* Added margin */
            }

.table-container {
                overflow-x: auto;
            }

.set-date {
                display: none;
                flex-direction: column;
                /* Stack form elements vertically */
                gap: 15px;
                /* Space between form elements */
                margin-top: 20px;
            }

.set-date label {
                margin-bottom: 5px;
            }

.set-date input[type="number"],
            .set-date input[type="datetime-local"] {
                width: 100%;
                /* Make inputs full width in the form */
                padding: 10px;
            }
        </style>
        <link href="https://fonts.googleapis.com/css2?family=Roboto:wght@400;500;700&display=swap" rel="stylesheet">

function displayForm() {
                const addpro = document.getElementById("set-date");
                addpro.style.display = "block";
            }
        </script>
    </head>

<body>
        <div class="container">
            <h1>Pro Users</h1>
            <button onclick="displayForm()">Add Pro</button>
            <form method="POST" action="addPro.php" class="set-date" id="set-date">
                <label for="userId">Id</label>
                <input type="number" id="userId" name="userId" placeholder="enter user's ID">
                <label for="end_date">End Date:</label>
                <input type="datetime-local" id="end_date" name="end_date">
                <button type="submit">Submit</button>
            </form>
            <div>Count-<?= sizeof($users) ?></div>
            <div class="table-container">
                <table>
                    <thead>
                        <tr>
                            <th>ID</th>
                            <th>Name</th>
                            <th>Plan Type</th>
                            <th>End Date</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php foreach ($users as $user): ?>
                            <tr>
                                <td><?php echo htmlspecialchars($user['userId']); ?></td>
                                <td><?php echo htmlspecialchars($user['full_name'] ?? 'N/A'); ?></td>
                                <td><?php echo htmlspecialchars($user['plan_type'] ?? 'N/A'); ?></td>
                                <td><?php echo htmlspecialchars($user['end_date'] ?? 'N/A'); ?></td>
                            </tr>
                        <?php endforeach; ?>
                    </tbody>
                </table>
            </div>
        </div>
    </body>

</html>
<?
} else {
    // If the request is not from verify_payment.php, throw an HTTP 500 error.
    header('HTTP/1.1 500 Internal Server Error');
    exit();
}
?>