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 diff
1.1 --- a/s4-blog.sh Wed Nov 23 15:54:05 2016 +0859 1.2 +++ b/s4-blog.sh Fri Nov 25 09:37:29 2016 +0859 1.3 @@ -321,6 +321,7 @@ 1.4 where blogid=(select id from blog where rowid=$2))\ 1.5 select (select rowid from user where name=c0.user)||' '|| \ 1.6 (select gecos from gecoses where name=c0.user) as 'メンバー',\ 1.7 + (select substr(c0.user, 1, instr(c0.user, '@')-1)) 'uname',\ 1.8 sum(case when c1.key is not null then 1 else 0 end)\ 1.9 as 'コメント記入',\ 1.10 sum(case when c2.key is not null then 1 else 0 end)\