[
MAINHACK
]
Mail Test
BC
Config Scan
HOME
Create...
New File
New Folder
Viewing / Editing File: view_results.php
<?php require_once '../config/database.php'; requireRole('teacher'); $teacher_id = getUserId(); $competition_id = $_GET['id'] ?? null; if (!$competition_id) { header('Location: my_competitions.php'); exit; } // Verify teacher owns this competition $stmt = $pdo->prepare(" SELECT c.*, g.name as grade_name, s.name as subject_name, st.name as stage_name FROM competitions c JOIN grades g ON c.grade_id = g.id JOIN subjects s ON c.subject_id = s.id JOIN stages st ON g.stage_id = st.id WHERE c.id = ? AND c.teacher_id = ? "); $stmt->execute([$competition_id, $teacher_id]); $competition = $stmt->fetch(); if (!$competition) { header('Location: my_competitions.php'); exit; } // Get results for this competition $results_stmt = $pdo->prepare(" SELECT * FROM game_results WHERE competition_id = ? ORDER BY final_score DESC, completed_at ASC "); $results_stmt->execute([$competition_id]); $results = $results_stmt->fetchAll(); // Calculate statistics $total_games = count($results); $avg_score = $total_games > 0 ? array_sum(array_column($results, 'final_score')) / $total_games : 0; $max_score = $total_games > 0 ? max(array_column($results, 'final_score')) : 0; ?> <!DOCTYPE html> <html lang="ar" dir="rtl"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>نتائج المسابقة - منصة المسابقات التعليمية</title> <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet"> <link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css" rel="stylesheet"> <link href="../assets/css/style.css" rel="stylesheet"> </head> <body> <!-- Navigation --> <nav class="navbar navbar-expand-lg navbar-dark bg-success"> <div class="container-fluid"> <a class="navbar-brand" href="../index.php"> <i class="fas fa-trophy me-2"></i> منصة المسابقات التعليمية </a> <div class="navbar-nav me-auto"> <span class="navbar-text"> <i class="fas fa-chalkboard-teacher me-1"></i> مرحباً، <?= sanitize($_SESSION['user_name']) ?> </span> </div> <div class="navbar-nav"> <a class="nav-link" href="../auth/logout.php"> <i class="fas fa-sign-out-alt me-1"></i> تسجيل الخروج </a> </div> </div> </nav> <div class="container-fluid"> <div class="row"> <!-- Sidebar --> <div class="col-md-3 col-lg-2 bg-light sidebar py-4"> <ul class="nav nav-pills flex-column"> <li class="nav-item"> <a class="nav-link" href="dashboard.php"> <i class="fas fa-tachometer-alt me-2"></i> الرئيسية </a> </li> <li class="nav-item"> <a class="nav-link" href="manage_students.php"> <i class="fas fa-users me-2"></i> إدارة الطلاب </a> </li> <li class="nav-item"> <a class="nav-link" href="create_competition.php"> <i class="fas fa-plus-circle me-2"></i> إنشاء مسابقة </a> </li> <li class="nav-item"> <a class="nav-link" href="my_competitions.php"> <i class="fas fa-trophy me-2"></i> مسابقاتي </a> </li> <li class="nav-item"> <a class="nav-link" href="results.php"> <i class="fas fa-chart-bar me-2"></i> النتائج </a> </li> </ul> </div> <!-- Main Content --> <div class="col-md-9 col-lg-10 py-4"> <div class="d-flex justify-content-between align-items-center mb-4"> <h1 class="h3">نتائج المسابقة</h1> <a href="my_competitions.php" class="btn btn-outline-secondary"> <i class="fas fa-arrow-right me-1"></i> العودة للمسابقات </a> </div> <!-- Competition Info --> <div class="card mb-4"> <div class="card-body"> <h5><?= sanitize($competition['title']) ?></h5> <div class="row"> <div class="col-md-3"> <small class="text-muted">المرحلة:</small> <p><?= sanitize($competition['stage_name']) ?></p> </div> <div class="col-md-3"> <small class="text-muted">الصف:</small> <p><?= sanitize($competition['grade_name']) ?></p> </div> <div class="col-md-3"> <small class="text-muted">المادة:</small> <p><?= sanitize($competition['subject_name']) ?></p> </div> <div class="col-md-3"> <small class="text-muted">نوع المسابقة:</small> <p> <span class="badge bg-<?= $competition['competition_type'] == 'group' ? 'primary' : 'warning' ?>"> <?= $competition['competition_type'] == 'group' ? 'مسابقة المجموعات' : 'من سيربح المليون' ?> </span> </p> </div> </div> </div> </div> <!-- Statistics --> <div class="row mb-4"> <div class="col-md-4"> <div class="card bg-primary text-white"> <div class="card-body text-center"> <h3><?= $total_games ?></h3> <p class="mb-0">إجمالي الألعاب</p> </div> </div> </div> <div class="col-md-4"> <div class="card bg-success text-white"> <div class="card-body text-center"> <h3><?= number_format($avg_score, 1) ?></h3> <p class="mb-0">متوسط النقاط</p> </div> </div> </div> <div class="col-md-4"> <div class="card bg-warning text-white"> <div class="card-body text-center"> <h3><?= number_format($max_score) ?></h3> <p class="mb-0">أعلى نتيجة</p> </div> </div> </div> </div> <!-- Results Table --> <div class="card"> <div class="card-header"> <h5 class="mb-0"> <i class="fas fa-list me-2"></i> تفاصيل النتائج </h5> </div> <div class="card-body"> <?php if (empty($results)): ?> <div class="alert alert-info text-center"> <i class="fas fa-info-circle me-2"></i> لا توجد نتائج لهذه المسابقة بعد </div> <?php else: ?> <div class="table-responsive"> <table class="table table-hover"> <thead> <tr> <th>الترتيب</th> <th>اسم الطالب/المجموعة</th> <th>النقاط</th> <th>تاريخ اللعب</th> </tr> </thead> <tbody> <?php foreach ($results as $index => $result): ?> <tr> <td> <?php if ($index < 3): ?> <i class="fas fa-medal text-<?= $index == 0 ? 'warning' : ($index == 1 ? 'secondary' : 'warning') ?>"></i> <?php endif; ?> #<?= $index + 1 ?> </td> <td> <?= sanitize($result['student_name']) ?> <?php if ($result['group_name']): ?> <br><small class="text-muted"><?= sanitize($result['group_name']) ?></small> <?php endif; ?> </td> <td> <span class="badge bg-primary fs-6"><?= number_format($result['final_score']) ?></span> </td> <td><?= date('Y-m-d H:i', strtotime($result['completed_at'])) ?></td> </tr> <?php endforeach; ?> </tbody> </table> </div> <?php endif; ?> </div> </div> </div> </div> </div> <script src="https://cdn.jsdelivr.net/npm/jquery@3.6.0/dist/jquery.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script> <script src="../assets/js/main.js"></script> </body> </html>
Save Changes
Cancel / Back
Close ×
Server Info
Hostname: premium320.web-hosting.com
Server IP: 66.29.153.54
PHP Version: 8.2.29
Server Software: LiteSpeed
System: Linux premium320.web-hosting.com 4.18.0-553.50.1.lve.el8.x86_64 #1 SMP Thu Apr 17 19:10:24 UTC 2025 x86_64
HDD Total: 97.87 GB
HDD Free: 76.87 GB
Domains on IP: N/A (Requires external lookup)
System Features
Safe Mode:
Off
disable_functions:
None
allow_url_fopen:
On
allow_url_include:
Off
magic_quotes_gpc:
Off
register_globals:
Off
open_basedir:
None
cURL:
Enabled
ZipArchive:
Enabled
MySQLi:
Enabled
PDO:
Enabled
wget:
Yes
curl (cmd):
Yes
perl:
Yes
python:
Yes (py3)
gcc:
Yes
pkexec:
No
git:
Yes
User Info
Username: aoneqssk
User ID (UID): 1285
Group ID (GID): 1290
Script Owner UID: 1285
Current Dir Owner: 1285