s4
changeset 345:8134b548b385
Taking default access time broken, fixed
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Tue, 25 Oct 2016 13:11:26 +0859 |
parents | 7ff49d1c2987 |
children | 4f06842488d3 |
files | s4-funcs.sh |
diffstat | 1 files changed, 4 insertions(+), 2 deletions(-) [+] |
line diff
1.1 --- a/s4-funcs.sh Tue Oct 25 13:04:49 2016 +0859 1.2 +++ b/s4-funcs.sh Tue Oct 25 13:11:26 2016 +0859 1.3 @@ -1465,8 +1465,10 @@ 1.4 EOF 1.5 } 1.6 listnewblogsql() { # $1=user 1.7 - deftime=`query "SELECT coalesce((SELECT time FROM acclog_user 1.8 - WHERE tblrowid=$blogreadflagrowid), "0");"` 1.9 + deftime=`query "SELECT coalesce((SELECT time FROM acclog 1.10 + WHERE user='$user' 1.11 + AND tblrowid=$blogreadflagrowid), 1.12 + "0");"` 1.13 cat<<EOF # | tee tmp/sql.out 1.14 `sql4interestblogs` 1.15 WITH article_ctime as (