prepare("
SELECT p.*, u.username
FROM posts p
JOIN users u ON p.user_id = u.id
WHERE p.id = ?
");
$stmt->execute([$post_id]);
$post = $stmt->fetch(PDO::FETCH_ASSOC);
if (!$post) {
die("Post not found.");
}
if ($post['nsfw'] == 1 && !$isOver18) {
die("This content is restricted to 18+ users.");
}
/* ---------------------------------------------------------
TAGS
--------------------------------------------------------- */
$tagStmt = $pdo->prepare("
SELECT t.name
FROM post_tags pt
JOIN tags t ON pt.tag_id = t.id
WHERE pt.post_id = ?
");
$tagStmt->execute([$post_id]);
$tags = $tagStmt->fetchAll(PDO::FETCH_COLUMN);
/* ---------------------------------------------------------
COMMENTS
--------------------------------------------------------- */
$commentStmt = $pdo->prepare("
SELECT c.*, u.username
FROM comments c
JOIN users u ON c.user_id = u.id
WHERE c.post_id = ?
ORDER BY c.id DESC
");
$commentStmt->execute([$post_id]);
$comments = $commentStmt->fetchAll(PDO::FETCH_ASSOC);
/* ---------------------------------------------------------
RATING
--------------------------------------------------------- */
$ratingStmt = $pdo->prepare("SELECT COUNT(*) FROM ratings WHERE post_id = ?");
$ratingStmt->execute([$post_id]);
$rating_count = $ratingStmt->fetchColumn();
$hasVoted = false;
if ($user_id) {
$voteCheck = $pdo->prepare("SELECT id FROM ratings WHERE post_id = ? AND user_id = ?");
$voteCheck->execute([$post_id, $user_id]);
$hasVoted = $voteCheck->fetchColumn() ? true : false;
}
/* ---------------------------------------------------------
NEXT / PREVIOUS POSTS
--------------------------------------------------------- */
$prevStmt = $pdo->prepare("SELECT id FROM posts WHERE id < ? ORDER BY id DESC LIMIT 1");
$prevStmt->execute([$post_id]);
$prev_id = $prevStmt->fetchColumn();
$nextStmt = $pdo->prepare("SELECT id FROM posts WHERE id > ? ORDER BY id ASC LIMIT 1");
$nextStmt->execute([$post_id]);
$next_id = $nextStmt->fetchColumn();
/* ---------------------------------------------------------
EXIF JSON (admin only)
--------------------------------------------------------- */
$exif_data = null;
if ($isAdmin && !empty($post['exif_json'])) {
$exif_data = json_decode($post['exif_json'], true);
}
?>
<?= htmlspecialchars($post['title'] ?: 'Artwork') ?>
Uploaded:
#
votes
Login to vote
Admin Metadata
Show raw EXIF data
Comments
Login to comment
s