From: Mischa POSLAWSKY <perl@shiar.org>
Date: Sun, 20 Oct 2019 03:49:22 +0000 (+0200)
Subject: issue: append and ignore page titles in links
X-Git-Tag: v4.2~33
X-Git-Url: http://git.shiar.net/minimedit.git/commitdiff_plain/55cb3025c5506ec7faaa1818a4d8161aaad19c27

issue: append and ignore page titles in links

Preserve names of replaced files, and improve recognition of sent targets
as well as seo score.
---

diff --git a/issue/index.php b/issue/index.php
index 3d62ced..d8f9c26 100644
--- a/issue/index.php
+++ b/issue/index.php
@@ -1,7 +1,7 @@
 <?php
 global $User, $Db;
 require_once 'database.inc.php';
-$id = trim($Args, '/');
+@list ($id, $title) = explode('/', ltrim($Args, '/'));
 
 if ($id) {
 	$Article->title = "Issue #$id";
@@ -19,6 +19,7 @@ if ($id) {
 			'Opgelost', showdate(preg_split('/\D/', $row->closed))
 		);
 	}
+	$Args = "/$id";  # minimal reference
 	print placeholder_include('reply');
 	return;
 }
@@ -44,7 +45,7 @@ ob_start();
 print '<ul>';
 while ($row = $query->fetch()) {
 	printf('<li><a href="%s">%s <small class="date">%s</small></a>',
-		"/$Page/{$row->id}",
+		"/$Page/{$row->id}/{$row->link}",
 		sprintf($row->closed ? '<strike>%s</strike>' : '%s',
 			htmlspecialchars($row->subject)),
 		showdate(array_slice(preg_split('/\D/', $row->created), 0, 3))
diff --git a/widget/comments.sql b/widget/comments.sql
index 5408877..5e33716 100644
--- a/widget/comments.sql
+++ b/widget/comments.sql
@@ -1,5 +1,6 @@
 CREATE TABLE issues (
 	page       text        NOT NULL DEFAULT 'issue',
+	link       text,
 	subject    text,
 	body       text,
 	created    timestamptz          DEFAULT now(),