Mercurial > hgrepos > hgweb.cgi > s4
changeset 181:fcfed35ca6d8
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 wrap: on
line diff
--- a/s4-funcs.sh Fri Feb 26 22:36:04 2016 +0859 +++ b/s4-funcs.sh Fri Feb 26 23:12:16 2016 +0859 @@ -1370,7 +1370,8 @@ else 0 end) "新着", count(id) "総数", ctime, title, - owner gecos -- (select gecos from gecoses where name=bl.owner) gecos + /* owner gecos */ + (select gecos from gecoses where name=bl.owner) gecos from blogall bl left join acclog_user l on bl.rowid=round(l.tblrowid) where case when (select name from user where owner=name) is not null