s4

changeset 253:a40d258cc5aa

find changesets by author, revision, files, or words in the commit message
SQL last modifed is TOO slow. Revert once to previous one.
author HIROSE Yuuji <yuuji@gentei.org>
date Mon, 18 Jul 2016 00:10:44 +0859
parents 75dfaceac01f
children 8a0cf46afb0a
files s4-funcs.sh
diffstat 1 files changed, 15 insertions(+), 0 deletions(-) [+]
line diff
     1.1 --- a/s4-funcs.sh	Sun Jul 17 23:59:37 2016 +0859
     1.2 +++ b/s4-funcs.sh	Mon Jul 18 00:10:44 2016 +0859
     1.3 @@ -1514,6 +1514,21 @@
     1.4  	WHERE a1.ctime = (SELECT max(ctime) FROM arts WHERE blogid=a1.blogid)
     1.5  	GROUP BY a1.brid ORDER by a1.ctime DESC LIMIT 50;"
     1.6  
     1.7 +    DT_SQL="SELECT b.rowid LINK,
     1.8 +       ctime,
     1.9 +       (SELECT $shortval FROM blog_s WHERE key='title' AND id=b.id) title,
    1.10 +       (SELECT gecos FROM gecoses
    1.11 +        WHERE name=(SELECT val FROM blog_s
    1.12 +                   WHERE key='owner' AND id=b.id)) owner
    1.13 +    FROM blog b
    1.14 +     JOIN
    1.15 +     (SELECT distinct blogid, max(val) ctime
    1.16 +      FROM article a, article_s s
    1.17 +      ON a.id=s.id AND a.author='$user' AND s.key='ctime'
    1.18 +      GROUP BY blogid ORDER BY val DESC LIMIT 50
    1.19 +     ) m
    1.20 +     ON b.id=m.blogid;"
    1.21 +
    1.22      cat<<-EOF
    1.23  	<div class="fold">
    1.24  	`cgi_checkbox mrd yes id="mre"`<label