s4

changeset 463:4f0314630559

find changesets by author, revision, files, or words in the commit message
debug code removed
author HIROSE Yuuji <yuuji@gentei.org>
date Mon, 21 Aug 2017 20:38:54 +0859
parents e8bde2d9cb0b
children 6591b5308ddd
files s4-blog.sh
diffstat 1 files changed, 2 insertions(+), 2 deletions(-) [+]
line diff
     1.1 --- a/s4-blog.sh	Mon Aug 21 20:05:37 2017 +0859
     1.2 +++ b/s4-blog.sh	Mon Aug 21 20:38:54 2017 +0859
     1.3 @@ -662,12 +662,12 @@
     1.4  	 SELECT user, (SELECT gecos FROM gecoses WHERE name=user) gecos
     1.5  	 FROM grp_mem
     1.6  	 WHERE gname=(SELECT val FROM blog_s
     1.7 -	              WHERE id=(select id from blog where rowid=16)
     1.8 +	              WHERE id=(select id from blog where rowid=$blogid)
     1.9  		      AND key='owner')
    1.10  	), acctime AS (
    1.11  	 SELECT user, max(time) atime
    1.12  	 FROM tblaccesses
    1.13 -	 WHERE tbl='blog' AND tblrowid=16
    1.14 +	 WHERE tbl='blog' AND tblrowid=$blogid
    1.15  	 GROUP BY user
    1.16  	)
    1.17  	SELECT g.user,