s4

changeset 274:0f7bc60985d6

find changesets by author, revision, files, or words in the commit message
Count only text in grpaction list
author HIROSE Yuuji <yuuji@gentei.org>
date Mon, 01 Aug 2016 22:30:02 +0859
parents 31fbfcd4fc25
children b82007959b54
files s4-funcs.sh
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line diff
     1.1 --- a/s4-funcs.sh	Mon Aug 01 18:14:27 2016 +0859
     1.2 +++ b/s4-funcs.sh	Mon Aug 01 22:30:02 2016 +0859
     1.3 @@ -2079,7 +2079,7 @@
     1.4  		      (SELECT id FROM blog_s
     1.5  		       WHERE key='owner'
     1.6  			 AND val=(SELECT gname FROM grp where rowid=$grid))
     1.7 -		 AND author=a.name)
     1.8 +		 AND author=a.name AND key='text')
     1.9  	    as POST,
    1.10  	 (SELECT group_concat(val, ',')
    1.11  	  FROM	 grp_mem_m