s4

changeset 625:74c0c2ed8ff5

find changesets by author, revision, files, or words in the commit message
New variable WHATSNEWDAYS limits the number of days of new article.
author HIROSE Yuuji <yuuji@gentei.org>
date Wed, 22 Apr 2020 07:09:19 +0900
parents 64c84bc00700
children 99863f97dee6
files s4-funcs.sh
diffstat 1 files changed, 7 insertions(+), 1 deletions(-) [+]
line diff
     1.1 --- a/s4-funcs.sh	Tue Apr 21 12:27:02 2020 +0900
     1.2 +++ b/s4-funcs.sh	Wed Apr 22 07:09:19 2020 +0900
     1.3 @@ -48,6 +48,7 @@
     1.4  [編集]リンクから修正してください。"
     1.5  blogreadflagrowid=0
     1.6  blogcutoffflagrowid=-1
     1.7 +whatsnewdays=${WHATS_NEW_DAYS:-14}
     1.8  querylog=$tmpdir/query.log
     1.9  searchlog=$tmpdir/search.log
    1.10  
    1.11 @@ -1772,12 +1773,17 @@
    1.12  EOF
    1.13  }
    1.14  listnewblogsql() { # $1=user
    1.15 +  newdays=${WHATS_NEW_DAYS##*[!0-9]}	# Shave non-digits
    1.16 +  newdays=${newdays%%[!0-9]*}
    1.17 +  newdays=${newdays:-14}
    1.18 +  basetime="datetime('now', 'localtime', '-${newdays} days')"
    1.19    deftime=`query "SELECT coalesce((SELECT max(time) FROM acclog
    1.20  		  	 	   WHERE user='$user'
    1.21  				    AND tblrowid IN
    1.22  				      ($blogreadflagrowid,
    1.23  				       $blogcutoffflagrowid)),
    1.24 -				  "0");"`
    1.25 +				  $basetime		-- "0"
    1.26 +				  );"`
    1.27    cat<<EOF
    1.28  `sql4interestblogs`
    1.29  WITH article_ctime as (