s4

changeset 257:5d0dbbf9310c

find changesets by author, revision, files, or words in the commit message
Show text in the table of recent writing articles
author HIROSE Yuuji <yuuji@gentei.org>
date Mon, 18 Jul 2016 19:52:41 +0859
parents e9b33033d95f
children a967788f7ad8
files s4-funcs.sh
diffstat 1 files changed, 2 insertions(+), 1 deletions(-) [+]
line diff
     1.1 --- a/s4-funcs.sh	Mon Jul 18 19:52:13 2016 +0859
     1.2 +++ b/s4-funcs.sh	Mon Jul 18 19:52:41 2016 +0859
     1.3 @@ -1502,7 +1502,8 @@
     1.4         (SELECT $shortval FROM blog_s WHERE key='title' AND id=b.id) title,
     1.5         (SELECT gecos FROM gecoses
     1.6          WHERE name=(SELECT val FROM blog_s
     1.7 -                   WHERE key='owner' AND id=b.id)) owner
     1.8 +                   WHERE key='owner' AND id=b.id)) owner,
     1.9 +       (SELECT $shortval val FROM article_s WHERE id=m.aid AND key='text') text
    1.10      FROM blog b
    1.11       JOIN
    1.12       (SELECT distinct blogid, a.id aid, max(val) ctime