s4

changeset 345:8134b548b385

find changesets by author, revision, files, or words in the commit message
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 (