s4
changeset 183:b641b5393c40
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>|"