prepare("
SELECT u.username, u.profile_pic, IFNULL(w.coins, 0) as coins
FROM users u
LEFT JOIN wallets w ON u.id = w.user_id
WHERE u.id = ?
LIMIT 1
");
$stmt->execute([$_SESSION['user_id']]);
$userData = $stmt->fetch();
if ($userData) {
$displayName = $userData['username'];
$userCoins = $userData['coins'];
$profilePic = $userData['profile_pic'];
}
} catch (PDOException $e) {
// If there's an error, we keep the defaults to prevent a 500 crash
// error_log("Topbar DB Error: " . $e->getMessage());
}
}
// 3. Logic for the Profile Image
$avatarSource = !empty($profilePic) ? $profilePic : "https://ui-avatars.com/api/?name=" . urlencode($displayName) . "&background=D91A2A&color=fff";
?>