MAINHACK

Viewing / Editing File: delete_competition.php

<?php
require_once '../config/database.php';
requireRole('teacher');

$teacher_id = getUserId();
$competition_id = $_POST['competition_id'] ?? null;

if (!$competition_id) {
    echo json_encode(['success' => false, 'message' => 'معرف المسابقة مطلوب']);
    exit;
}

// Verify teacher owns this competition
$stmt = $pdo->prepare("SELECT id FROM competitions WHERE id = ? AND teacher_id = ?");
$stmt->execute([$competition_id, $teacher_id]);

if (!$stmt->fetch()) {
    echo json_encode(['success' => false, 'message' => 'ليس لديك صلاحية لحذف هذه المسابقة']);
    exit;
}

try {
    $pdo->beginTransaction();
    
    // Delete related data first
    $pdo->prepare("DELETE FROM game_results WHERE competition_id = ?")->execute([$competition_id]);
    $pdo->prepare("DELETE FROM group_questions WHERE competition_id = ?")->execute([$competition_id]);
    $pdo->prepare("DELETE FROM millionaire_questions WHERE competition_id = ?")->execute([$competition_id]);
    
    // Delete competition
    $pdo->prepare("DELETE FROM competitions WHERE id = ?")->execute([$competition_id]);
    
    $pdo->commit();
    echo json_encode(['success' => true, 'message' => 'تم حذف المسابقة بنجاح']);
    
} catch (Exception $e) {
    $pdo->rollBack();
    echo json_encode(['success' => false, 'message' => 'حدث خطأ في حذف المسابقة']);
}
?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: delete_competition.php

Server Info

System Features

User Info