s4

changeset 195:40bef4883664

find changesets by author, revision, files, or words in the commit message
Most Recent table limits to 50 entries
author HIROSE Yuuji <yuuji@gentei.org>
date Sun, 24 Apr 2016 16:49:15 +0859
parents b1847cc3912a
children 146f12edc26b
files s4-funcs.sh
diffstat 1 files changed, 5 insertions(+), 3 deletions(-) [+]
line diff
     1.1 --- a/s4-funcs.sh	Sun Apr 24 16:38:59 2016 +0859
     1.2 +++ b/s4-funcs.sh	Sun Apr 24 16:49:15 2016 +0859
     1.3 @@ -1452,17 +1452,19 @@
     1.4      # Display Most Recent Entry
     1.5      DT_SQL="SELECT b.rowid, ctime,
     1.6         (SELECT val FROM blog_s WHERE key='title' AND id=b.id) title,
     1.7 -       (SELECT val FROM blog_s WHERE key='owner' AND id=b.id) owner
     1.8 +       (SELECT gecos FROM gecoses
     1.9 +        WHERE name=(SELECT val FROM blog_s
    1.10 +                   WHERE key='owner' AND id=b.id)) owner
    1.11      FROM blog b
    1.12       JOIN
    1.13       (SELECT distinct blogid, max(val) ctime
    1.14        FROM article a, article_s s
    1.15        ON a.id=s.id AND a.author='$user' AND s.key='ctime'
    1.16 -      GROUP BY blogid ORDER BY val DESC LIMIT 5
    1.17 +      GROUP BY blogid ORDER BY val DESC LIMIT 50
    1.18       ) m
    1.19       ON b.id=m.blogid;"
    1.20      cat<<-EOF
    1.21 -	<div class="fold">
    1.22 +	<div class="fold dumptable">
    1.23  	`cgi_checkbox mrd yes id="mre"`<label for="mre">
    1.24  	最近書き込んだ場所一覧</label>
    1.25  	`DT_VIEW=replyblog dumptable html blog`