Mercurial > hgrepos > hgweb.cgi > s4
changeset 272:6a548c4ab437
Add POST count in member list of grpaction.
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Mon, 01 Aug 2016 18:06:37 +0859 |
parents | a8bb72580c91 |
children | 31fbfcd4fc25 |
files | s4-funcs.sh |
diffstat | 1 files changed, 8 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- a/s4-funcs.sh Thu Jul 28 23:08:56 2016 +0859 +++ b/s4-funcs.sh Mon Aug 01 18:06:37 2016 +0859 @@ -2073,6 +2073,14 @@ else '' end || a.rowid|| ','||coalesce(val,a.name) as name, + (SELECT count(author) /* Put post count for scoring 2016-08-01 */ + FROM article NATURAL JOIN article_s + WHERE blogid IN + (SELECT id FROM blog_s + WHERE key='owner' + AND val=(SELECT gname FROM grp where rowid=$grid)) + AND author=a.name) + as POST, (SELECT group_concat(val, ',') FROM grp_mem_m WHERE gname='$grp' AND user=a.name AND key='team') as TEAM