s4

changeset 272:6a548c4ab437

find changesets by author, revision, files, or words in the commit message
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 diff
     1.1 --- a/s4-funcs.sh	Thu Jul 28 23:08:56 2016 +0859
     1.2 +++ b/s4-funcs.sh	Mon Aug 01 18:06:37 2016 +0859
     1.3 @@ -2073,6 +2073,14 @@
     1.4  	 else ''
     1.5  	 end || a.rowid||
     1.6  	 ','||coalesce(val,a.name) as name,
     1.7 +	 (SELECT count(author)  /* Put post count for scoring 2016-08-01 */
     1.8 +		 FROM article NATURAL JOIN article_s
     1.9 +		 WHERE blogid IN
    1.10 +		      (SELECT id FROM blog_s
    1.11 +		       WHERE key='owner'
    1.12 +			 AND val=(SELECT gname FROM grp where rowid=$grid))
    1.13 +		 AND author=a.name)
    1.14 +	    as POST,
    1.15  	 (SELECT group_concat(val, ',')
    1.16  	  FROM	 grp_mem_m
    1.17  	  WHERE	 gname='$grp' AND user=a.name AND key='team') as TEAM