prepare(" SELECT u.*, up.points as current_points, up.total_earned, up.total_redeemed, mv.mobile_number, mv.is_verified as mobile_verified, mv.verified_at as mobile_verified_at FROM users u LEFT JOIN user_points up ON u.id = up.user_id LEFT JOIN mobile_verifications mv ON u.id = mv.user_id WHERE u.id = ? "); $stmt->execute([$member_id]); $member = $stmt->fetch(); if (!$member) { header('Location: panel.php'); exit; } // Fetch profiler completion $completionStmt = $panelPdo->prepare(" SELECT * FROM profiler_completion WHERE user_id = ? "); $completionStmt->execute([$member_id]); $completionData = $completionStmt->fetchAll(); // Fetch point transactions $transactionsStmt = $panelPdo->prepare(" SELECT * FROM point_transactions WHERE user_id = ? ORDER BY created_at DESC LIMIT 50 "); $transactionsStmt->execute([$member_id]); $transactions = $transactionsStmt->fetchAll(); // Fetch redemption requests $redemptionsStmt = $panelPdo->prepare(" SELECT * FROM redemption_requests WHERE user_id = ? ORDER BY created_at DESC "); $redemptionsStmt->execute([$member_id]); $redemptions = $redemptionsStmt->fetchAll(); // Fetch support tickets $ticketsStmt = $panelPdo->prepare(" SELECT * FROM support_tickets WHERE user_id = ? ORDER BY created_at DESC LIMIT 10 "); $ticketsStmt->execute([$member_id]); $tickets = $ticketsStmt->fetchAll(); } catch (Exception $e) { error_log("Member view error: " . $e->getMessage()); header('Location: panel.php'); exit; } include 'includes/header.php'; ?>

Member Details

Complete information for member #

✏️ Edit Member ← Back to List
💰
Current Points
Available Balance
📈
Total Earned
Lifetime Earnings
💳
Total Redeemed
Lifetime Redemptions
Account Status

Basic Information

📧 Email Address
✓ Verified ✗ Not Verified
👤 Gender
🎂 Date of Birth
diff($dob)->y; echo $dob->format('F j, Y'); ?>
years old
📍 Postcode
📱 Mobile Number
✓ Verified
🔒 Account Status
✅ Email Verified
✓ Yes' : '✗ No'; ?>
🎯 Onboarding Status
✓ Completed ⏳ Pending
📅 Member Since
🕐 Last Login

Profiler Completion

%
of questions answered • Completed on
📋
No profiler data available

Points Transaction History

💎
No transaction history available

Redemption Requests

Request ID Points Amount (₹) UPI ID Status Requested Processed
₹ Pending'; ?>
🎁
No redemption requests found

Support Tickets

#
Created:
🎫
No support tickets found