[
MAINHACK
]
Mail Test
BC
Config Scan
HOME
Create...
New File
New Folder
Viewing / Editing File: dashboard.php
<?php require_once '../config/database.php'; requireRole('admin'); // Get statistics $stats = []; $stats['users'] = $pdo->query("SELECT COUNT(*) FROM users")->fetchColumn(); $stats['teachers'] = $pdo->query("SELECT COUNT(*) FROM users WHERE role = 'teacher'")->fetchColumn(); $stats['competitions'] = $pdo->query("SELECT COUNT(*) FROM competitions")->fetchColumn(); $stats['active_competitions'] = $pdo->query("SELECT COUNT(*) FROM competitions WHERE status = 'active'")->fetchColumn(); // Get recent activities $recent_competitions = $pdo->query(" SELECT c.*, u.full_name as teacher_name, g.name as grade_name, s.name as subject_name FROM competitions c JOIN users u ON c.teacher_id = u.id JOIN grades g ON c.grade_id = g.id JOIN subjects s ON c.subject_id = s.id ORDER BY c.created_at DESC LIMIT 5 ")->fetchAll(); ?> <!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-primary"> <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-user-shield 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 active" href="dashboard.php"> <i class="fas fa-tachometer-alt me-2"></i> الرئيسية </a> </li> <li class="nav-item"> <a class="nav-link" href="manage_stages.php"> <i class="fas fa-layer-group me-2"></i> إدارة المراحل </a> </li> <li class="nav-item"> <a class="nav-link" href="manage_grades.php"> <i class="fas fa-graduation-cap me-2"></i> إدارة الصفوف </a> </li> <li class="nav-item"> <a class="nav-link" href="manage_subjects.php"> <i class="fas fa-book me-2"></i> إدارة المواد </a> </li> <li class="nav-item"> <a class="nav-link" href="manage_teachers.php"> <i class="fas fa-chalkboard-teacher me-2"></i> إدارة المعلمين </a> </li> <li class="nav-item"> <a class="nav-link" href="manage_competitions.php"> <i class="fas fa-trophy me-2"></i> إدارة المسابقات </a> </li> <li class="nav-item"> <a class="nav-link" href="settings.php"> <i class="fas fa-cog 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 class="btn-group"> <a href="../index.php" class="btn btn-outline-primary"> <i class="fas fa-home me-1"></i> الموقع الرئيسي </a> </div> </div> <!-- Statistics Cards --> <div class="row mb-4"> <div class="col-lg-3 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['users'] ?></h4> <p class="mb-0">إجمالي المستخدمين</p> </div> <div class="align-self-center"> <i class="fas fa-users fa-2x"></i> </div> </div> </div> </div> </div> <div class="col-lg-3 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['teachers'] ?></h4> <p class="mb-0">المعلمين</p> </div> <div class="align-self-center"> <i class="fas fa-chalkboard-teacher fa-2x"></i> </div> </div> </div> </div> </div> <div class="col-lg-3 col-md-6 mb-3"> <div class="card bg-info text-white"> <div class="card-body"> <div class="d-flex justify-content-between"> <div> <h4><?= $stats['competitions'] ?></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 class="col-lg-3 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['active_competitions'] ?></h4> <p class="mb-0">المسابقات النشطة</p> </div> <div class="align-self-center"> <i class="fas fa-play fa-2x"></i> </div> </div> </div> </div> </div> </div> <!-- Recent Activities --> <div class="card"> <div class="card-header"> <h5 class="mb-0"> <i class="fas fa-clock me-2"></i> المسابقات الحديثة </h5> </div> <div class="card-body"> <?php if (empty($recent_competitions)): ?> <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 ($recent_competitions as $comp): ?> <tr> <td><?= sanitize($comp['title']) ?></td> <td><?= sanitize($comp['teacher_name']) ?></td> <td><?= sanitize($comp['subject_name']) ?></td> <td><?= sanitize($comp['grade_name']) ?></td> <td> <span class="badge bg-<?= $comp['competition_type'] == 'group' ? 'primary' : 'success' ?>"> <?= $comp['competition_type'] == 'group' ? 'مسابقة المجموعات' : 'من سيربح المليون' ?> </span> </td> <td> <span class="badge bg-<?= $comp['status'] == 'active' ? 'success' : ($comp['status'] == 'draft' ? 'warning' : 'secondary') ?>"> <?= $comp['status'] == 'active' ? 'نشطة' : ($comp['status'] == 'draft' ? 'مسودة' : 'مكتملة') ?> </span> </td> <td><?= date('Y-m-d H:i', strtotime($comp['created_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