[
MAINHACK
]
Mail Test
BC
Config Scan
HOME
Create...
New File
New Folder
Viewing / Editing File: results.php
<?php require_once '../config/database.php'; requireRole('teacher'); $teacher_id = getUserId(); // Get teacher's competition results $results = $pdo->prepare(" SELECT c.title, c.competition_type, gr.student_name, gr.group_name, gr.final_score, gr.completed_at, g.name as grade_name, s.name as subject_name FROM game_results gr JOIN competitions c ON gr.competition_id = c.id JOIN grades g ON c.grade_id = g.id JOIN subjects s ON c.subject_id = s.id WHERE c.teacher_id = ? ORDER BY gr.completed_at DESC LIMIT 100 "); $results->execute([$teacher_id]); $game_results = $results->fetchAll(); // Get statistics $stats = []; $stats['total_games'] = $pdo->prepare(" SELECT COUNT(*) FROM game_results gr JOIN competitions c ON gr.competition_id = c.id WHERE c.teacher_id = ? "); $stats['total_games']->execute([$teacher_id]); $stats['total_games'] = $stats['total_games']->fetchColumn(); $stats['avg_score'] = $pdo->prepare(" SELECT AVG(gr.final_score) FROM game_results gr JOIN competitions c ON gr.competition_id = c.id WHERE c.teacher_id = ? AND gr.final_score > 0 "); $stats['avg_score']->execute([$teacher_id]); $stats['avg_score'] = round($stats['avg_score']->fetchColumn(), 1); $stats['top_score'] = $pdo->prepare(" SELECT MAX(gr.final_score) FROM game_results gr JOIN competitions c ON gr.competition_id = c.id WHERE c.teacher_id = ? "); $stats['top_score']->execute([$teacher_id]); $stats['top_score'] = $stats['top_score']->fetchColumn(); ?> <!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 active" 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> </div> <!-- Statistics Cards --> <div class="row mb-4"> <div class="col-lg-4 col-md-6 mb-3"> <div class="card bg-primary text-white"> <div class="card-body"> <div class="d-flex justify-content-between"> <div> <h4><?= $stats['total_games'] ?></h4> <p class="mb-0">إجمالي الألعاب</p> </div> <div class="align-self-center"> <i class="fas fa-gamepad fa-2x"></i> </div> </div> </div> </div> </div> <div class="col-lg-4 col-md-6 mb-3"> <div class="card bg-success text-white"> <div class="card-body"> <div class="d-flex justify-content-between"> <div> <h4><?= $stats['avg_score'] ?></h4> <p class="mb-0">متوسط النقاط</p> </div> <div class="align-self-center"> <i class="fas fa-chart-line fa-2x"></i> </div> </div> </div> </div> </div> <div class="col-lg-4 col-md-6 mb-3"> <div class="card bg-warning text-white"> <div class="card-body"> <div class="d-flex justify-content-between"> <div> <h4><?= $stats['top_score'] ?></h4> <p class="mb-0">أعلى نتيجة</p> </div> <div class="align-self-center"> <i class="fas fa-trophy fa-2x"></i> </div> </div> </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($game_results)): ?> <div class="alert alert-info"> <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> <th>المادة</th> <th>الصف</th> <th>التاريخ</th> </tr> </thead> <tbody> <?php foreach ($game_results as $result): ?> <tr> <td><?= sanitize($result['title']) ?></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"><?= number_format($result['final_score']) ?></span> </td> <td> <span class="badge bg-<?= $result['competition_type'] == 'group' ? 'info' : 'warning' ?>"> <?= $result['competition_type'] == 'group' ? 'مجموعات' : 'مليونير' ?> </span> </td> <td><?= sanitize($result['subject_name']) ?></td> <td><?= sanitize($result['grade_name']) ?></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.86 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