From: Ben Sherratt <redacted>
Date: Sat, 4 Jul 2026 11:33:52 +0000 (+0100)
Subject: Admin fixes
X-Git-Url: https://git.bts.cx/cx.git/commitdiff_plain/b767acc63bfe4ecd297d6961d8187532f0759d56

Admin fixes
---

diff --git a/cx/lib/posts.php b/cx/lib/posts.php
index d8f056d..e46aa28 100644
--- a/cx/lib/posts.php
+++ b/cx/lib/posts.php
@@ -237,7 +237,7 @@ function cx_posts_find_page_id($post_slug) {
 	return null;
 }
 
-function cx_pages_get() {
+function cx_pages_get(bool $include_drafts = false) {
 	$sql = 'SELECT
 		post_id,
 		post_slug,
@@ -247,9 +247,15 @@ function cx_pages_get() {
 		post_title,
 		post_data
 		FROM posts
-		WHERE post_is_page == TRUE
-		AND post_is_draft == FALSE
-		ORDER BY post_creation_time ASC;';
+		WHERE post_is_page == TRUE';
+
+	if ($include_drafts == false) {
+		$sql .= ' AND post_is_draft == FALSE';
+	}
+
+	$sql .= ' ORDER BY post_date ASC';
+
+	$sql .= ';';
 
 	foreach (cx_db_query($sql) as $post) {
 		$p = new Post($post);
diff --git a/cx/templates/admin/main.php b/cx/templates/admin/main.php
index 799db88..c0da49a 100644
--- a/cx/templates/admin/main.php
+++ b/cx/templates/admin/main.php
@@ -1,22 +1,34 @@
 <?php cx_template_base('base'); ?>
 
 <h2>Posts</h2>
-<ul role="list">
+<table>
 <?php foreach (cx_posts_get(include_drafts: true) as $post): ?>
-<li><a href="<?= cx_url_admin('/posts/edit?id=' . $post->id); ?>"><?= $post->title ?></a> <a href="<?= cx_url_admin('/posts/delete?id=' . $post->id); ?>">🚮</a></li>
+<tr>
+ <td class="fill"><a href="<?= cx_url_admin('/posts/edit?id=' . $post->id); ?>"><?= $post->title ?></a></td>
+ <td class="hug"><a href="<?= cx_url_admin('/posts/edit?id=' . $post->id); ?>">Edit</a></td>
+ <td class="hug"><a href="<?= cx_url_admin('/posts/delete?id=' . $post->id); ?>">Delete</a></td>
+</tr>
 <?php endforeach; ?>
-</ul>
+</table>
 
 <h2>Pages</h2>
-<ul role="list">
-<?php foreach (cx_pages_get() as $post): ?>
-<li><a href="<?= cx_url_admin('/posts/edit?id=' . $post->id); ?>"><?= $post->title ?></a> <a href="<?= cx_url_admin('/posts/delete?id=' . $post->id); ?>">🚮</a></li>
+<table>
+<?php foreach (cx_pages_get(include_drafts: true) as $post): ?>
+<tr>
+ <td class="fill"><a href="<?= cx_url_admin('/posts/edit?id=' . $post->id); ?>"><?= $post->title ?></a></td>
+ <td class="hug"><a href="<?= cx_url_admin('/posts/edit?id=' . $post->id); ?>">Edit</a></td>
+ <td class="hug"><a href="<?= cx_url_admin('/posts/delete?id=' . $post->id); ?>">Delete</a></td>
+</tr>
 <?php endforeach; ?>
-</ul>
+</table>
 
 <h2>Images</h2>
-<ul role="list">
+<table>
 <?php foreach (cx_images_get() as $image): ?>
-<li><a href="<?= cx_url_admin('/images/edit?id=' . $image->id); ?>"><?= $image->url ?></a> <a href="<?= cx_url_admin('/images/delete?id=' . $image->id); ?>">🚮</a></li>
+<tr>
+ <td class="fill"><a href="<?= $image->url ?>"><?= $image->url ?></a></td>
+ <td class="hug"><a href="<?= cx_url_admin('/images/edit?id=' . $image->id); ?>">Edit</a></td>
+ <td class="hug"><a href="<?= cx_url_admin('/images/delete?id=' . $image->id); ?>">Delete</a></td>
+</tr>
 <?php endforeach; ?>
-</ul>
+</table>
diff --git a/public/design/css/cx.css b/public/design/css/cx.css
index b920c7e..eb2b1ba 100644
--- a/public/design/css/cx.css
+++ b/public/design/css/cx.css
@@ -82,6 +82,7 @@ nav [aria-current="page"] {
 }
 
 main {
+	margin: 50px 100px;
 	margin-left: calc(var(--sidebar-width) + 50px);
 }
 
@@ -213,7 +214,26 @@ blockquote {
 }
 
 
+table {
+	width: 100%;
+}
+
+tr:nth-child(even) {
+	background-color: #f2f2f2;
+}
+
+tr:hover {
+	background-color: #f2f2ff;
+}
 
+td.fill {
+	width: 100%;
+}
+
+td a {
+	display: block;
+	padding: 2px;
+}
 
 input, textarea {
 	font-size: 1em;