s4

changeset 181:fcfed35ca6d8

find changesets by author, revision, files, or words in the commit message
Gecos column of NEWS table switched to gecos instead of id
author HIROSE Yuuji <yuuji@gentei.org>
date Fri, 26 Feb 2016 23:12:16 +0859
parents 59bd085848ec
children 5ba50e0850c9
files s4-funcs.sh
diffstat 1 files changed, 2 insertions(+), 1 deletions(-) [+]
line diff
     1.1 --- a/s4-funcs.sh	Fri Feb 26 22:36:04 2016 +0859
     1.2 +++ b/s4-funcs.sh	Fri Feb 26 23:12:16 2016 +0859
     1.3 @@ -1370,7 +1370,8 @@
     1.4                   else 0
     1.5              end) "新着",
     1.6   count(id) "総数", ctime, title,
     1.7 - owner gecos -- (select gecos from gecoses where name=bl.owner) gecos
     1.8 + /* owner gecos */
     1.9 + (select gecos from gecoses where name=bl.owner) gecos
    1.10   from blogall bl left join acclog_user l
    1.11        on bl.rowid=round(l.tblrowid)
    1.12   where case when (select name from user where owner=name) is not null