prepare("SELECT * FROM admin_users WHERE username = ? AND status = 'active'");
$stmt->execute([$username]);
$user = $stmt->fetch();
if ($user && password_verify($password, $user['password'])) {
$_SESSION['admin_id'] = $user['id'];
$_SESSION['admin_username'] = $user['username'];
$_SESSION['admin_email'] = $user['email'];
$_SESSION['admin_role'] = $user['role'];
$_SESSION['admin_name'] = $user['full_name'];
$updateStmt = $pdo->prepare("UPDATE admin_users SET last_login = NOW() WHERE id = ?");
$updateStmt->execute([$user['id']]);
logActivity($user['id'], 'login', 'User logged in successfully');
header('Location: index.php');
exit;
} else {
$error = 'Invalid username or password';
}
} catch (Exception $e) {
error_log("Login error: " . $e->getMessage());
$error = 'An error occurred. Please try again.';
}
}
}
// ============ SHOW LOGIN FORM ============
?>
Login - Relevant Reflex Admin
RR
Welcome Back
Sign in to your admin account
⚠️
query("SELECT COUNT(*) as total FROM users");
$total_members = $memberStmt->fetchColumn();
// Active members
$activeStmt = $panelPdo->query("SELECT COUNT(*) as total FROM users WHERE status = 'active'");
$active_members = $activeStmt->fetchColumn();
// Email verified members
$verifiedStmt = $panelPdo->query("SELECT COUNT(*) as total FROM users WHERE email_verified = 1");
$verified_members = $verifiedStmt->fetchColumn();
// Total points in circulation
$pointsStmt = $panelPdo->query("SELECT SUM(points) as total FROM user_points");
$total_points = $pointsStmt->fetchColumn() ?? 0;
// Total points earned (lifetime)
$earnedStmt = $panelPdo->query("SELECT SUM(total_earned) as total FROM user_points");
$total_earned = $earnedStmt->fetchColumn() ?? 0;
// Total redemptions
$redeemedStmt = $panelPdo->query("SELECT SUM(total_redeemed) as total FROM user_points");
$total_redeemed = $redeemedStmt->fetchColumn() ?? 0;
// Pending redemption requests
$pendingRedemptionsStmt = $panelPdo->query("SELECT COUNT(*) as total FROM redemption_requests WHERE status = 'pending'");
$pending_redemptions = $pendingRedemptionsStmt->fetchColumn();
// Open support tickets
$openTicketsStmt = $panelPdo->query("SELECT COUNT(*) as total FROM support_tickets WHERE status IN ('open', 'pending')");
$open_tickets = $openTicketsStmt->fetchColumn();
// Admin users
$adminStmt = $pdo->query("SELECT COUNT(*) as total FROM admin_users WHERE status = 'active'");
$admin_count = $adminStmt->fetchColumn();
// Affiliates
$affiliateStmt = $pdo->query("SELECT COUNT(*) as total FROM affiliates WHERE status = 'active'");
$affiliate_count = $affiliateStmt->fetchColumn();
// Recent members (last 7 days)
$recentStmt = $panelPdo->query("SELECT COUNT(*) as total FROM users WHERE created_at >= DATE_SUB(NOW(), INTERVAL 7 DAY)");
$recent_members = $recentStmt->fetchColumn();
// Recent activities
$activitiesStmt = $pdo->query("
SELECT al.*, au.full_name, au.username
FROM admin_activity_log al
LEFT JOIN admin_users au ON al.admin_id = au.id
ORDER BY al.created_at DESC
LIMIT 10
");
$recent_activities = $activitiesStmt->fetchAll();
} catch (Exception $e) {
error_log("Dashboard error: " . $e->getMessage());
$total_members = $active_members = $verified_members = 0;
$total_points = $total_earned = $total_redeemed = 0;
$pending_redemptions = $open_tickets = 0;
$admin_count = $affiliate_count = $recent_members = 0;
$recent_activities = [];
}
include 'includes/header.php';
?>
👋 Welcome back, !
Here's what's happening with your panel today
📅 ⏰ 👤
👥
Total Members
0): ?>
↑ + this week
No new members
✅
Active Members
0 ? round(($active_members / $total_members) * 100) : 0; ?>% of total