Mercurial > hgrepos > hgweb.cgi > s4
diff s4-funcs.sh @ 345:8134b548b385
Taking default access time broken, fixed
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Tue, 25 Oct 2016 13:11:26 +0859 |
parents | c3311da3f059 |
children | 4f06842488d3 |
line wrap: on
line diff
--- a/s4-funcs.sh Tue Oct 25 13:04:49 2016 +0859 +++ b/s4-funcs.sh Tue Oct 25 13:11:26 2016 +0859 @@ -1465,8 +1465,10 @@ EOF } listnewblogsql() { # $1=user - deftime=`query "SELECT coalesce((SELECT time FROM acclog_user - WHERE tblrowid=$blogreadflagrowid), "0");"` + deftime=`query "SELECT coalesce((SELECT time FROM acclog + WHERE user='$user' + AND tblrowid=$blogreadflagrowid), + "0");"` cat<<EOF # | tee tmp/sql.out `sql4interestblogs` WITH article_ctime as (