s4

changeset 183:b641b5393c40

find changesets by author, revision, files, or words in the commit message
TEST: Put rowid of article for convenience to reference
author HIROSE Yuuji <yuuji@gentei.org>
date Tue, 01 Mar 2016 18:55:57 +0900
parents 5ba50e0850c9
children 6f4fd4fadcfe
files s4-blog.sh
diffstat 1 files changed, 3 insertions(+), 2 deletions(-) [+]
line diff
     1.1 --- a/s4-blog.sh	Tue Mar 01 11:59:54 2016 +0859
     1.2 +++ b/s4-blog.sh	Tue Mar 01 18:55:57 2016 +0900
     1.3 @@ -375,6 +375,7 @@
     1.4  	coalesce((SELECT val FROM user_s
     1.5  			 WHERE name=author AND key='gecos'),
     1.6  			author) uname,
     1.7 +	a.rowid,
     1.8  	s.TIME,
     1.9  	hex(s.TEXT),
    1.10  	(SELECT group_concat(rowid||':'||length(bin)||':'||hex(val), ' ')
    1.11 @@ -386,14 +387,14 @@
    1.12       a_s s
    1.13    ON a.id=s.id;
    1.14  EOF
    1.15 -    while IFS='|' read id edit notify uid uname tm hte imgids; do
    1.16 +    while IFS='|' read id edit notify uid uname aid tm hte imgids; do
    1.17        nt="<label style=\"font-size: 70%;\"><input type=\"checkbox\"
    1.18  	 name=\"notifyto\" value=\"$uid\">返信通知送信</label>"
    1.19        cat<<EOF |
    1.20  <tr id="$id">
    1.21  <td>${edit:+<a href="$elink+$edit">編集</a>}
    1.22  <a href="$hlink+$uid">$uname</a>
    1.23 -$tm
    1.24 +$tm #$aid
    1.25  ${notify:+$nt}</td><td>`echo "$hte"|unhexize|htmlescape`
    1.26  EOF
    1.27        sed -e "s|^href=\([-A-Za-z0-9,.:/~_%#&+?]*\)|<a &>\1</a>|"