$_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';
}
sprintf($row->closed ? '<strike>%s</strike>' : '%s',
htmlspecialchars($row->subject)),
showdate(array_slice(preg_split('/\D/', $row->updated), 0, 3)),
- isset($row->assign) ? ' <em class="right">'.$row->assign.'</em>' : ''
+ implode(' ', [
+ $row->replycount ? sprintf('<span class=right>+%d</span>', $row->replycount) : '',
+ isset($row->assign) ? ' <em class="right">'.$row->assign.'</em>' : '',
+ ])
);
print "</li>\n";
}