Mercurial > hgrepos > hgweb.cgi > s4

changeset 338:291a3eeed05e

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Show author in search result
author HIROSE Yuuji <yuuji@gentei.org>
date Sun, 23 Oct 2016 23:11:56 +0859
parents 48d0b6c4de65
children 47d83939666b
files s4-blog.sh
diffstat 1 files changed, 3 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/s4-blog.sh	Sat Oct 22 22:58:10 2016 +0859
+++ b/s4-blog.sh	Sun Oct 23 23:11:56 2016 +0859
@@ -532,8 +532,8 @@
      ) ar
    ON a.id=ar.id
 ), ar AS (
- SELECT article.rowid, article.blogid, article.id, ctime, content
- FROM	article JOIN artsm ON article.id=artsm.id
+ SELECT a.rowid, a.blogid, a.id, a.author, ctime, content
+ FROM	article a JOIN artsm ON a.id=artsm.id
  $authcond
 ), bl AS (
  SELECT blg.rid, blg.*, blog_s.val TITLE
@@ -541,6 +541,7 @@
 )
 SELECT	bl.rid||'#'||ar.id '',
 	bl.title TITLE,
+	(SELECT gecos FROM gecoses WHERE name=ar.author) AUTHOR,
 	substr(ctime, 0, 11) DATE,
 	substr(content, 0, 78) TEXT
 FROM ar JOIN bl

yatex.org