getConnection();
$message = '';
// التحقق من وجود الجدول
try {
$check = $db->query("SHOW TABLES LIKE 'stories'");
if ($check->rowCount() == 0) {
$message = '';
$stories = [];
} else {
// معالجة الإضافة/الحذف
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
try {
if (isset($_POST['add_story']) && isset($_FILES['image'])) {
$title = $_POST['title'];
$link = $_POST['link'] ?? '';
$duration = $_POST['duration'] ?? 5;
if ($_FILES['image']['error'] === 0) {
$upload_dir = '../../uploads/stories/';
if (!file_exists($upload_dir)) mkdir($upload_dir, 0777, true);
$ext = pathinfo($_FILES['image']['name'], PATHINFO_EXTENSION);
$filename = 'story_' . time() . '.' . $ext;
if (move_uploaded_file($_FILES['image']['tmp_name'], $upload_dir . $filename)) {
// حفظ المسار فقط بدون ../
$image_path = 'uploads/stories/' . $filename;
$query = "INSERT INTO stories (title, image, link, duration, created_by) VALUES (?, ?, ?, ?, ?)";
$stmt = $db->prepare($query);
$stmt->execute([$title, $image_path, $link, $duration, $_SESSION['user_id']]);
$message = '';
}
}
} elseif (isset($_POST['delete_story'])) {
$id = $_POST['story_id'];
$query = "DELETE FROM stories WHERE id = ?";
$stmt = $db->prepare($query);
$stmt->execute([$id]);
$message = '';
} elseif (isset($_POST['toggle_status'])) {
$id = $_POST['story_id'];
$query = "UPDATE stories SET is_active = NOT is_active WHERE id = ?";
$stmt = $db->prepare($query);
$stmt->execute([$id]);
$message = '';
}
} catch (Exception $e) {
$message = '
خطأ: ' . $e->getMessage() . '
';
}
}
// جلب الاستوريز
$query = "SELECT * FROM stories ORDER BY created_at DESC";
$stmt = $db->prepare($query);
$stmt->execute();
$stories = $stmt->fetchAll(PDO::FETCH_ASSOC);
}
} catch (Exception $e) {
$message = '
خطأ: ' . $e->getMessage() . '
';
$stories = [];
}
?>
إدارة الاستوريز
لا توجد استوريز
ابدأ بإضافة أول استوري
نشط
معطل