X-Git-Url: http://git.shiar.net/minimedit.git/blobdiff_plain/20554c40a0151bb22476a04e225c0167f22f436a..483761be2d405d4a69c005bd407f12e6d81445b1:/issue/index.php
diff --git a/issue/index.php b/issue/index.php
index e7c69bb..f950861 100644
--- a/issue/index.php
+++ b/issue/index.php
@@ -51,7 +51,9 @@ if ($_POST) {
$_POST = [];
}
-$sql = 'SELECT * FROM issues WHERE page = ?';
+$cols = "*, (SELECT count(*) FROM comments WHERE"
+ . " page=i.page||'/'||i.id AND message IS NOT NULL) AS replycount";
+$sql = "SELECT $cols FROM issues i WHERE page = ?";
if (isset($_GET['open'])) {
$sql .= ' AND closed IS NULL';
}
@@ -66,7 +68,10 @@ while ($row = $query->fetch()) {
sprintf($row->closed ? '%s' : '%s',
htmlspecialchars($row->subject)),
showdate(array_slice(preg_split('/\D/', $row->updated), 0, 3)),
- isset($row->assign) ? ' '.$row->assign.'' : ''
+ implode(' ', [
+ $row->replycount ? sprintf('+%d', $row->replycount) : '',
+ isset($row->assign) ? ' '.$row->assign.'' : '',
+ ])
);
print "\n";
}