109 lines
5.9 KiB
PHP
109 lines
5.9 KiB
PHP
<?php
|
|
require_once '../includes/db.php';
|
|
require_once '../includes/auth.php';
|
|
requireEditor();
|
|
|
|
// Handle deletion
|
|
if (isset($_GET['delete'])) {
|
|
$id = (int)$_GET['delete'];
|
|
// Optional: Delete physical file if it was an upload
|
|
$stmt = $pdo->prepare("SELECT video_url, source_type FROM videos WHERE id = ?");
|
|
$stmt->execute([$id]);
|
|
$v = $stmt->fetch();
|
|
if ($v && $v['source_type'] === 'upload') {
|
|
@unlink('../' . $v['video_url']);
|
|
}
|
|
|
|
$pdo->prepare("DELETE FROM videos WHERE id = ?")->execute([$id]);
|
|
cleanupTags();
|
|
header('Location: index.php?msg=deleted');
|
|
exit;
|
|
}
|
|
|
|
$stmt = $pdo->prepare("SELECT v.*, u.username FROM videos v JOIN users u ON v.uploader_id = u.id ORDER BY v.created_at DESC");
|
|
$stmt->execute();
|
|
$videos = $stmt->fetchAll();
|
|
|
|
// Get reported comments count
|
|
$reported_count = $pdo->query("SELECT COUNT(*) FROM comments WHERE is_reported = TRUE")->fetchColumn();
|
|
|
|
// Reuse header
|
|
ob_start();
|
|
require_once '../includes/header.php';
|
|
$header = ob_get_clean();
|
|
echo str_replace(['assets/', 'index.php', 'login.php', 'logout.php', 'admin/'], ['../assets/', '../index.php', '../login.php', '../logout.php', './'], $header);
|
|
?>
|
|
|
|
<div style="padding: 40px 24px; max-width: 1200px; margin: 0 auto;">
|
|
|
|
<div style="display: grid; grid-template-columns: repeat(auto-fit, minmax(200px, 1fr)); gap: 20px; margin-bottom: 40px;">
|
|
<a href="settings.php" class="btn" style="background: var(--bg-card); border: 1px solid var(--glass-border); flex-direction: column; padding: 20px;">
|
|
<i class="fas fa-palette" style="font-size: 1.5rem; margin-bottom: 10px;"></i>
|
|
Branding & Site
|
|
</a>
|
|
<a href="users.php" class="btn" style="background: var(--bg-card); border: 1px solid var(--glass-border); flex-direction: column; padding: 20px;">
|
|
<i class="fas fa-users" style="font-size: 1.5rem; margin-bottom: 10px;"></i>
|
|
Manage Users
|
|
</a>
|
|
<a href="reports.php" class="btn" style="background: var(--bg-card); border: 1px solid var(--glass-border); flex-direction: column; padding: 20px; position: relative; display: flex; text-decoration: none; color: inherit;">
|
|
<i class="fas fa-flag" style="font-size: 1.5rem; margin-bottom: 10px; color: <?= $reported_count > 0 ? '#ff4081' : 'inherit' ?>;"></i>
|
|
<span>Reports (<?= $reported_count ?>)</span>
|
|
<?php if ($reported_count > 0): ?>
|
|
<span style="position: absolute; top: -5px; right: -5px; background: #ff4081; width: 20px; height: 20px; border-radius: 50%; font-size: 0.7rem; display: flex; align-items: center; justify-content: center; color: white;">!</span>
|
|
<?php endif; ?>
|
|
</a>
|
|
<a href="logs.php" class="btn" style="background: var(--bg-card); border: 1px solid var(--glass-border); flex-direction: column; padding: 20px;">
|
|
<i class="fas fa-list-ul" style="font-size: 1.5rem; margin-bottom: 10px;"></i>
|
|
System Logs
|
|
</a>
|
|
</div>
|
|
|
|
<div style="display: flex; justify-content: space-between; align-items: center; margin-bottom: 32px;">
|
|
<h1>Manage Sermons</h1>
|
|
<a href="add_video.php" class="btn btn-primary"><i class="fas fa-plus"></i> Add New Video</a>
|
|
</div>
|
|
|
|
<div style="background: var(--bg-card); border-radius: 16px; border: 1px solid var(--glass-border); overflow: hidden;">
|
|
<table style="width: 100%; border-collapse: collapse; text-align: left;">
|
|
<thead>
|
|
<tr style="background: var(--glass); color: var(--text-muted); font-size: 0.85rem; text-transform: uppercase; letter-spacing: 1px;">
|
|
<th style="padding: 16px;">Video</th>
|
|
<th style="padding: 16px;">Uploader</th>
|
|
<th style="padding: 16px;">Date</th>
|
|
<th style="padding: 16px;">Views</th>
|
|
<th style="padding: 16px;">Actions</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<?php foreach ($videos as $v): ?>
|
|
<tr style="border-bottom: 1px solid var(--glass-border);">
|
|
<td style="padding: 16px;">
|
|
<div style="display: flex; gap: 12px; align-items: center;">
|
|
<div style="width: 80px; aspect-ratio: 16/9; background: #333; border-radius: 4px; background-image: url('../<?= $v['thumbnail_url'] ?: 'assets/images/default_thumb.png' ?>'); background-size: cover;"></div>
|
|
<span style="font-weight: 500;"><?= htmlspecialchars($v['title']) ?></span>
|
|
</div>
|
|
</td>
|
|
<td style="padding: 16px; color: var(--text-muted);"><?= htmlspecialchars($v['username']) ?></td>
|
|
<td style="padding: 16px; color: var(--text-muted);"><?= date('Y-m-d', strtotime($v['release_date'])) ?></td>
|
|
<td style="padding: 16px;"><?= number_format($v['views']) ?></td>
|
|
<td style="padding: 16px;">
|
|
<div style="display: flex; gap: 12px;">
|
|
<a href="../watch.php?id=<?= $v['id'] ?>" title="View" style="color: var(--primary-color);"><i class="fas fa-eye"></i></a>
|
|
<a href="edit_video.php?id=<?= $v['id'] ?>" title="Edit" style="color: var(--accent);"><i class="fas fa-edit"></i></a>
|
|
<a href="?delete=<?= $v['id'] ?>" title="Delete" style="color: #ff4081;" onclick="return confirm('Are you sure?')"><i class="fas fa-trash"></i></a>
|
|
</div>
|
|
</td>
|
|
</tr>
|
|
<?php endforeach; ?>
|
|
<?php if (empty($videos)): ?>
|
|
<tr>
|
|
<td colspan="5" style="padding: 40px; text-align: center; color: var(--text-muted);">No videos uploaded yet.</td>
|
|
</tr>
|
|
<?php endif; ?>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
|
|
<?php require_once '../includes/footer.php'; ?>
|