Mercurial > hgrepos > hgweb.cgi > s4
changeset 367:037b514bb6ae
Include localpart of username into lshandout() table.
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Fri, 25 Nov 2016 09:37:29 +0859 |
parents | 884cd7c66917 |
children | aba7076b6ea6 |
files | s4-blog.sh |
diffstat | 1 files changed, 1 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- a/s4-blog.sh Wed Nov 23 15:54:05 2016 +0859 +++ b/s4-blog.sh Fri Nov 25 09:37:29 2016 +0859 @@ -321,6 +321,7 @@ where blogid=(select id from blog where rowid=$2))\ select (select rowid from user where name=c0.user)||' '|| \ (select gecos from gecoses where name=c0.user) as 'メンバー',\ + (select substr(c0.user, 1, instr(c0.user, '@')-1)) 'uname',\ sum(case when c1.key is not null then 1 else 0 end)\ as 'コメント記入',\ sum(case when c2.key is not null then 1 else 0 end)\