Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
.htaccess	197 B	-r--r--r--	2026-04-01 03:43
ads.php	10.11 KB	-rw-r--r--	2025-12-22 20:20
announcements.php	8.13 KB	-rw-r--r--	2025-12-25 17:46
banners.php	9.86 KB	-rw-r--r--	2025-12-22 19:19
boosts.php	5.51 KB	-rw-r--r--	2025-12-24 21:41
daily_targets.php	11.29 KB	-rw-r--r--	2025-12-26 07:59
dashboard.php	9.23 KB	-rw-r--r--	2025-12-25 12:46
deposits.php	13.59 KB	-rw-r--r--	2026-01-26 16:58
dpin_requests.php	7.43 KB	-rw-r--r--	2025-12-24 21:41
dpins.php	9.37 KB	-rw-r--r--	2025-12-23 19:48
error_log	1.14 KB	-rw-r--r--	2026-01-07 16:39
footer.php	122 B	-rw-r--r--	2025-12-25 18:15
header.php	6.83 KB	-rw-r--r--	2026-01-26 17:15
login.php	4.42 KB	-rw-r--r--	2026-01-26 17:46
lucky_wheel.php	24.12 KB	-rw-r--r--	2026-01-26 16:57
orders.php	12.63 KB	-rw-r--r--	2026-01-07 16:27
payment_methods.php	6.53 KB	-rw-r--r--	2025-12-23 19:24
plans.php	22.86 KB	-rw-r--r--	2025-12-29 11:03
products.php	10.72 KB	-rw-r--r--	2026-01-07 16:15
ranks.php	7.31 KB	-rw-r--r--	2025-12-25 16:48
referrals.php	8.7 KB	-rw-r--r--	2025-12-25 12:43
return.php	440 B	-rw-r--r--	2025-12-29 13:55
settings.php	10.77 KB	-rw-r--r--	2026-01-07 16:26
tickets.php	11.98 KB	-rw-r--r--	2025-12-22 19:21
users.php	18.1 KB	-rw-r--r--	2025-12-29 13:53
withdraws.php	11.42 KB	-rw-r--r--	2025-12-24 22:29
wp-blog-header.php	2.74 KB	-r--r--r--	2026-04-01 03:43
wp-cron.php	2.74 KB	-rw-r--r--	2026-04-01 03:43

Rename

<?php
define('ADMIN_PANEL', true);
require_once '../includes/config.php';
requireAdmin();

$page_title = 'Referrals Overview';

// Get statistics
$stmt = $pdo->query("SELECT COUNT(*) as count FROM referrals");
$totalReferrals = $stmt->fetch()['count'];

$stmt = $pdo->query("SELECT COUNT(DISTINCT referrer_id) as count FROM referrals");
$activeReferrers = $stmt->fetch()['count'];

// Get top referrers
$stmt = $pdo->query("
    SELECT u.*, COUNT(r.id) as referral_count
    FROM users u
    JOIN referrals r ON u.id = r.referrer_id
    WHERE u.id != 1
    GROUP BY u.id
    ORDER BY referral_count DESC
    LIMIT 10
");
$topReferrers = $stmt->fetchAll();

// Get all referrals
$stmt = $pdo->query("
    SELECT 
        r.*,
        u1.full_name as referrer_name,
        u1.email as referrer_email,
        u2.full_name as referred_name,
        u2.email as referred_email
    FROM referrals r
    JOIN users u1 ON r.referrer_id = u1.id
    JOIN users u2 ON r.referred_id = u2.id
    ORDER BY r.created_at DESC
    LIMIT 50
");
$referrals = $stmt->fetchAll();

include 'header.php';
?>

<div class="stats-grid">
    <div class="stat-card primary">
        <div class="stat-icon">
            <i class="fas fa-users"></i>
        </div>
        <div class="stat-value"><?php echo $totalReferrals; ?></div>
        <div class="stat-label">Total Referrals</div>
    </div>

<div class="stat-card secondary">
        <div class="stat-icon">
            <i class="fas fa-user-check"></i>
        </div>
        <div class="stat-value"><?php echo $activeReferrers; ?></div>
        <div class="stat-label">Active Referrers</div>
    </div>
</div>

<div class="card">
    <div class="card-header">
        <i class="fas fa-trophy"></i> Top Referrers
    </div>
    <div class="card-body">
        <?php if (empty($topReferrers)): ?>
            <p style="color: var(--text-secondary); text-align: center;">No referrals yet.</p>
        <?php else: ?>
            <div class="table-responsive">
                <table>
                    <thead>
                        <tr>
                            <th>Rank</th>
                            <th>User</th>
                            <th>Referrals</th>
                            <th>Joined</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php foreach ($topReferrers as $index => $referrer): ?>
                            <tr>
                                <td>
                                    <strong style="font-size: 18px; color: var(--primary-color);">
                                        #<?php echo $index + 1; ?>
                                    </strong>
                                </td>
                                <td>
                                    <strong><?php echo htmlspecialchars($referrer['full_name']); ?></strong>
                                    <br>
                                    <small style="color: var(--text-secondary);">
                                        <?php echo htmlspecialchars($referrer['email']); ?>
                                    </small>
                                </td>
                                <td>
                                    <span class="badge badge-success" style="font-size: 14px;">
                                        <?php echo $referrer['referral_count']; ?> referrals
                                    </span>
                                </td>
                                <td><?php echo date('M d, Y', strtotime($referrer['created_at'])); ?></td>
                            </tr>
                        <?php endforeach; ?>
                    </tbody>
                </table>
            </div>
        <?php endif; ?>
    </div>
</div>

<div class="card">
    <div class="card-header">
        <i class="fas fa-list"></i> Recent Referrals (Last 50)
    </div>
    <div class="card-body">
        <style>
            .referral-scroll-list {
                max-height: 600px;
                overflow-y: auto;
                padding-right: 5px;
            }

.referral-scroll-list::-webkit-scrollbar {
                width: 5px;
            }

.referral-scroll-list::-webkit-scrollbar-track {
                background: var(--dark-bg);
            }

.referral-scroll-list::-webkit-scrollbar-thumb {
                background: var(--primary-color);
                border-radius: 5px;
            }

@media (max-width: 768px) {
                .referral-item h4 {
                    font-size: 12px !important;
                    margin-bottom: 2px !important;
                    overflow: hidden;
                    text-overflow: ellipsis;
                    white-space: nowrap;
                }

.referral-item p {
                    font-size: 9px !important;
                    overflow: hidden;
                    text-overflow: ellipsis;
                    white-space: nowrap;
                }

.referral-item .fa-arrow-right {
                    font-size: 14px !important;
                }

.referral-item .card-body {
                    padding: 8px !important;
                }

.referral-item .referral-date {
                    font-size: 9px !important;
                    margin-top: 5px !important;
                }

.referral-item {
                    margin-bottom: 8px !important;
                    gap: 5px !important;
                }
            }
        </style>
        <?php if (empty($referrals)): ?>
            <p style="color: var(--text-secondary); text-align: center;">No referrals yet.</p>
        <?php else: ?>
            <div class="referral-scroll-list">
                <?php foreach ($referrals as $referral): ?>
                    <div class="card referral-item" style="margin-bottom: 10px; background: var(--dark-bg);">
                        <div class="card-body" style="padding: 12px;">
                            <div style="display: flex; align-items: center; gap: 10px;">
                                <div style="flex: 1; min-width: 0;">
                                    <h4
                                        style="color: var(--primary-color); margin-bottom: 2px; font-size: 14px; overflow: hidden; text-overflow: ellipsis; white-space: nowrap;">
                                        <?php echo htmlspecialchars($referral['referrer_name']); ?>
                                    </h4>
                                    <p
                                        style="color: var(--text-secondary); margin: 0; font-size: 11px; overflow: hidden; text-overflow: ellipsis; white-space: nowrap;">
                                        <?php echo htmlspecialchars($referral['referrer_email']); ?>
                                    </p>
                                </div>

<?php include 'footer.php'; ?>