| Server IP : 147.93.80.58 / Your IP : 216.73.216.195 Web Server : LiteSpeed System : Linux id-dci-web1866.main-hosting.eu 5.14.0-503.38.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Apr 18 08:52:10 EDT 2025 x86_64 User : u939086737 ( 939086737) PHP Version : 8.2.28 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/u939086737/domains/chocolate-mouse-719686.hostingersite.com/public_html/admin/ |
Upload File : |
<!-- <script>
window.location.href = "login";
</script> -->
<?php require_once 'header.php'; ?>
<div class="page-wrapper">
<div class="page-content">
<div class="row row-cols-1 row-cols-md-2 row-cols-xl-2 row-cols-xxl-4">
<div class="col">
<div class="card radius-10 bg-gradient-blues">
<div class="card-body">
<div class="d-flex align-items-center">
<div class="me-auto">
<p class="mb-0 text-white">New Activation Request</p>
<h4 class="my-1 text-white">
<?php
// Total users (excluding admin maybe, hence -1)
$res = mysqli_query($conn, "SELECT * FROM `payment_requests` WHERE status != 1");
echo $total_users = mysqli_num_rows($res);
?>
</h4>
<p class="mb-0 font-13 text-white">
<a class="badge py-1 bg-primary" href="activation-request">Check Now <i class="bx bxs-share-alt"></i> </a>
</p>
</div>
<div id="chart1"></div>
</div>
</div>
</div>
</div>
<div class="col">
<div class="card radius-10 bg-gradient-cosmic">
<div class="card-body">
<div class="d-flex align-items-center">
<div class="me-auto">
<p class="mb-0 text-white">Total Member</p>
<h4 class="my-1 text-white">
<?php
// Total users (excluding admin maybe, hence -1)
$res = mysqli_query($conn, "SELECT * FROM `users` WHERE id != 1");
echo $total_users = mysqli_num_rows($res);
// Users added in the last 7 days
$last_week_date = date('Y-m-d H:i:s', strtotime('-7 days'));
$last_week_users = mysqli_num_rows(mysqli_query($conn, "SELECT * FROM `users` WHERE id != 1 AND created_at >= '$last_week_date'"));
?>
</h4>
<p class="mb-0 font-13 text-white">
<?php echo $last_week_users . ' from last week'; ?>
</p>
</div>
<div id="chart1"></div>
</div>
</div>
</div>
</div>
<div class="col">
<div class="card radius-10 bg-gradient-ohhappiness">
<div class="card-body">
<div class="d-flex align-items-center">
<div class="me-auto">
<p class="mb-0 text-white">Active Member</p>
<h4 class="my-1 text-white">
<?php
// Total users (excluding admin maybe, hence -1)
$res = mysqli_query($conn, "SELECT * FROM `users` WHERE id != 1 AND active_status = 1");
echo $total_users = mysqli_num_rows($res);
// Users added in the last 7 days
$last_week_date = date('Y-m-d H:i:s', strtotime('-7 days'));
$last_week_users = mysqli_num_rows(mysqli_query($conn, "SELECT * FROM `users` WHERE id != 1 AND active_status = 1 AND created_at >= '$last_week_date'"));
?>
</h4>
<p class="mb-0 font-13 text-white">
<?php echo $last_week_users . ' from last week'; ?>
</p>
</div>
<div id="chart2"></div>
</div>
</div>
</div>
</div>
<div class="col">
<div class="card radius-10 bg-gradient-ibiza">
<div class="card-body">
<div class="d-flex align-items-center">
<div class="me-auto">
<p class="mb-0 text-white">In-Active Member</p>
<h4 class="my-1 text-white">
<?php
// Total users (excluding admin maybe, hence -1)
$res = mysqli_query($conn, "SELECT * FROM `users` WHERE id != 1 AND active_status = 0");
echo $total_users = mysqli_num_rows($res);
// Users added in the last 7 days
$last_week_date = date('Y-m-d H:i:s', strtotime('-7 days'));
$last_week_users = mysqli_num_rows(mysqli_query($conn, "SELECT * FROM `users` WHERE id != 1 AND active_status = 0 AND created_at >= '$last_week_date'"));
?>
</h4>
<p class="mb-0 font-13 text-white">
<?php echo $last_week_users . ' from last week'; ?>
</p>
</div>
<div id="chart3"></div>
</div>
</div>
</div>
</div>
<div class="col">
<div class="card radius-10 bg-gradient-kyoto">
<div class="card-body">
<div class="d-flex align-items-center">
<div class="me-auto">
<p class="mb-0 text-white">Suspend Member</p>
<h4 class="my-1 text-white">
<?php
// Total users (excluding admin maybe, hence -1)
$res = mysqli_query($conn, "SELECT * FROM `users` WHERE id != 1 AND active_status = 2");
echo $total_users = mysqli_num_rows($res);
// Users added in the last 7 days
$last_week_date = date('Y-m-d H:i:s', strtotime('-7 days'));
$last_week_users = mysqli_num_rows(mysqli_query($conn, "SELECT * FROM `users` WHERE id != 1 AND active_status = 2 AND created_at >= '$last_week_date'"));
?>
</h4>
<p class="mb-0 font-13 text-white">
<?php echo $last_week_users . ' from last week'; ?>
</p>
</div>
<div id="chart4"></div>
</div>
</div>
</div>
</div>
</div>
<hr />
<div class="row row-cols-1 row-cols-md-2 row-cols-xl-4">
<div class="col">
<div class="card radius-10">
<div class="card-body">
<div class="d-flex align-items-center">
<div>
<p class="mb-0 text-secondary">Total Business</p>
<h4 class="my-1">0</h4>
</div>
<div class="widgets-icons bg-light-primary text-primary ms-auto"><i class="bx bxs-wallet"></i>
</div>
</div>
</div>
</div>
</div>
<div class="col">
<div class="card radius-10">
<div class="card-body">
<div class="d-flex align-items-center">
<div>
<p class="mb-0 text-secondary">Member Income</p>
<h4 class="my-1">0</h4>
</div>
<div class="widgets-icons bg-light-info text-info ms-auto"><i class="bx bxs-wallet"></i>
</div>
</div>
</div>
</div>
</div>
<div class="col">
<div class="card radius-10">
<div class="card-body">
<div class="d-flex align-items-center">
<div>
<p class="mb-0 text-secondary">Paid Payout</p>
<h4 class="my-1">0</h4>
</div>
<div class="widgets-icons bg-light-danger text-danger ms-auto"><i class="bx bxs-wallet"></i>
</div>
</div>
</div>
</div>
</div>
<div class="col">
<div class="card radius-10">
<div class="card-body">
<div class="d-flex align-items-center">
<div>
<p class="mb-0 text-secondary">Pending Withdrawals</p>
<h4 class="my-1">0</h4>
</div>
<div class="widgets-icons bg-light-warning text-warning ms-auto"><i class="bx bxs-wallet"></i>
</div>
</div>
</div>
</div>
</div>
</div>
<hr>
<div class="row row-cols-1 row-cols-md-2 row-cols-xl-4">
<div class="col">
<div class="card radius-10 border-start border-0 border-4 border-info">
<div class="card-body">
<div class="d-flex align-items-center">
<div>
<p class="mb-0 text-secondary">Admin Income</p>
<h4 class="my-1 text-info">0</h4>
<p class="mb-0 font-13">0 from last week</p>
</div>
<div class="widgets-icons-2 rounded-circle bg-gradient-blues text-white ms-auto"><i class="bx bxs-wallet"></i>
</div>
</div>
</div>
</div>
</div>
<div class="col">
<div class="card radius-10 border-start border-0 border-4 border-danger">
<div class="card-body">
<div class="d-flex align-items-center">
<div>
<p class="mb-0 text-secondary">Referral Paid</p>
<h4 class="my-1 text-danger">0</h4>
<p class="mb-0 font-13">0 from last week</p>
</div>
<div class="widgets-icons-2 rounded-circle bg-gradient-burning text-white ms-auto"><i class='bx bxs-wallet'></i>
</div>
</div>
</div>
</div>
</div>
</div>
<hr>
<div class="row">
<div class="col-12 col-lg-7 col-xl-8 d-flex">
<div class="card radius-10 w-100">
<div class="card-header bg-transparent">
<div class="d-flex align-items-center">
<div>
<h6 class="mb-0">Recent Members</h6>
</div>
</div>
</div>
<div class="card-body">
<div class="table-responsive">
<table class="table align-middle mb-0">
<thead class="table-light">
<tr>
<th>#</th>
<th>User ID</th>
<th>Name</th>
<th>Email</th>
<th>Mobile</th>
<th>Joined</th>
</tr>
</thead>
<tbody>
<?php
function mask_email($email)
{
$parts = explode("@", $email);
$name = substr($parts[0], 0, 2) . str_repeat("*", strlen($parts[0]) - 2);
return $name . "@" . $parts[1];
}
function mask_mobile($mobile)
{
return substr($mobile, 0, 2) . str_repeat("*", strlen($mobile) - 4) . substr($mobile, -2);
}
$i = 1;
$q = mysqli_query($conn, "SELECT id, username, name, email, mobile_number, created_at FROM users WHERE id != 1 ORDER BY id DESC");
while ($user = mysqli_fetch_assoc($q)) :
?>
<tr>
<td><?= $i++; ?></td>
<td><?= $user['username']; ?></td>
<td><?= $user['name']; ?></td>
<td><?= mask_email($user['email']); ?></td>
<td><?= mask_mobile($user['mobile_number']); ?></td>
<td><?= date('d M Y', strtotime($user['created_at'])); ?></td>
</tr>
<?php endwhile; ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<div class="col-12 col-lg-5 col-xl-4 d-flex">
<div class="card w-100 radius-10">
<div class="card-body">
<div class="card radius-10 border shadow-none">
<div class="card-body">
<div class="d-flex align-items-center">
<div>
<a href="./plans">
<p class="mb-0 text-primary">Total Plans</p>
<h4 class="my-1 text-primary">
<?php
$res = mysqli_query($conn, "SELECT * FROM `plans`");
$rows = mysqli_num_rows($res);
echo $rows;
?>
</h4>
</a>
</div>
<div class="widgets-icons-2 bg-gradient-cosmic text-white ms-auto"><i class='bx bxs-heart'></i>
</div>
</div>
</div>
</div>
<div class="card radius-10 border shadow-none">
<div class="card-body">
<div class="d-flex align-items-center">
<div>
<p class="mb-0 text-secondary">Pending Withdrawals</p>
<h4 class="my-1">
0
</h4>
</div>
<div class="widgets-icons-2 bg-gradient-kyoto text-white ms-auto"><i class='bx bx-rupee'></i>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!--end page wrapper -->
<?php require_once 'footer.php'; ?>