// В блоке if ($section==='dashboard') {
$total_users = getCount($conn, 'users');
$total_connections = getCount($conn, 'connections');
$total_logs = getCount($conn, 'logs');
$total_support = getCount($conn, 'support_messages');

// Дополнительно: сколько кошельков подключено?
$res = $conn->query("SELECT COUNT(*) as c FROM users WHERE wallet_connected=1");
$row = $res->fetch_assoc();
$wallet_connected_count = $row['c'];

// Сколько у нас реферальных связей?
$res = $conn->query("SELECT COUNT(*) as c FROM users WHERE referred_by IS NOT NULL");
$ref_count = $res->fetch_assoc()['c'];

echo "<h1>Dashboard</h1>
<div class='cards'>
    <div class='card'><h3>Total Users</h3><p>$total_users</p></div>
    <div class='card'><h3>Wallets Connected</h3><p>$wallet_connected_count</p></div>
    <div class='card'><h3>Total Referrals</h3><p>$ref_count</p></div>
    <div class='card'><h3>Total Connections</h3><p>$total_connections</p></div>
    <div class='card'><h3>Total Logs</h3><p>$total_logs</p></div>
    <div class='card'><h3>Support Messages</h3><p>$total_support</p></div>
</div>
<p>Welcome to the Admin Panel. Use the sidebar to navigate.</p>";