s4

changeset 304:ab11a49bd64e

find changesets by author, revision, files, or words in the commit message
Sort search result by "DATE DESC, TITLE, x.ctime"
author HIROSE Yuuji <yuuji@gentei.org>
date Thu, 13 Oct 2016 23:04:33 +0859
parents 170fd6b81a95
children e751156de740
files s4-blog.sh
diffstat 1 files changed, 4 insertions(+), 1 deletions(-) [+]
line diff
     1.1 --- a/s4-blog.sh	Thu Oct 13 12:18:07 2016 +0859
     1.2 +++ b/s4-blog.sh	Thu Oct 13 23:04:33 2016 +0859
     1.3 @@ -458,6 +458,9 @@
     1.4  	# Not sure GROUP BY a.blogid is comfortable for searchers...?
     1.5  	kc=$kc${kc:+" AND "}"s.ctime GLOB '${ctime}*'"
     1.6  	##### kwdgrp=" GROUP BY a.blogid"
     1.7 +      elif [ x"$k" = x"@today" -o x"$k" = x"@今日" ]; then
     1.8 +	ctime=`date +%F`
     1.9 +	kc=$kc${kc:+" AND "}"s.ctime GLOB '${ctime}*'"
    1.10        else
    1.11  	kc=$kc${kc:+" AND "}"s.text LIKE '%$k%'"
    1.12        fi
    1.13 @@ -503,7 +506,7 @@
    1.14  	       ON a.id=s.id WHERE $kc$kwdgrp)
    1.15  	     x ON b.id=x.blogid
    1.16  	 WHERE b.id IN (SELECT id FROM blog_s $cond)
    1.17 -       ORDER by x.ctime DESC;"
    1.18 +       ORDER by DATE DESC, TITLE, x.ctime;"
    1.19    sedopt="s,<TR><TD>\([^<]*\)</TD>,<TR><TD><a\
    1.20   href=\"?replyblog+\1\">VIEW</a></TD>,"
    1.21