changeset 274:0f7bc60985d6

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 wrap: on
line diff
--- a/s4-funcs.sh	Mon Aug 01 18:14:27 2016 +0859
+++ b/s4-funcs.sh	Mon Aug 01 22:30:02 2016 +0859
@@ -2079,7 +2079,7 @@
 		      (SELECT id FROM blog_s
 		       WHERE key='owner'
 			 AND val=(SELECT gname FROM grp where rowid=$grid))
-		 AND author=a.name)
+		 AND author=a.name AND key='text')
 	    as POST,
 	 (SELECT group_concat(val, ',')
 	  FROM	 grp_mem_m

yatex.org