s4
changeset 282:e6c1cbe4ffcc
Add article-rowid to id of tr(article list)
| author | HIROSE Yuuji <yuuji@gentei.org> |
|---|---|
| date | Sat, 06 Aug 2016 12:18:03 +0859 |
| parents | dd8629e6d67e |
| children | fe73fb3f9f35 |
| files | s4-blog.sh |
| diffstat | 1 files changed, 20 insertions(+), 1 deletions(-) [+] |
line diff
1.1 --- a/s4-blog.sh Tue Aug 02 22:09:06 2016 +0859 1.2 +++ b/s4-blog.sh Sat Aug 06 12:18:03 2016 +0859 1.3 @@ -181,7 +181,7 @@ 1.4 nt="<label style=\"font-size: 70%;\"><input type=\"checkbox\" 1.5 name=\"notifyto\" value=\"$uid\">返信通知送信</label>" 1.6 cat<<EOF | 1.7 -<tr id="$id"> 1.8 +<tr id="$id" id="$aid"> 1.9 <td>${edit:+<a href="$elink+$edit">編集</a> }#$aid 1.10 <a href="$hlink+$uid">$uname</a> 1.11 $tm 1.12 @@ -255,6 +255,25 @@ 1.13 <p class="update_link"><a 1.14 href="?reload/$rowid">再読込</a></p> 1.15 EOF 1.16 + query<<-EOF 1.17 + WITH mrt AS ( 1.18 + SELECT max(val) maxtime FROM article_s 1.19 + WHERE key='ctime' AND id IN 1.20 + (SELECT id FROM article 1.21 + WHERE blogid=(select id from blog where rowid=$id)) 1.22 + ) 1.23 + SELECT 'A:'|| 1.24 + (SELECT count(*) FROM tblaccesses 1.25 + WHERE tbl='blog' AND tblrowid=$id) access, 1.26 + 'C:'|| 1.27 + (SELECT count(distinct user) FROM acclog 1.28 + WHERE tbl='blog' AND tblrowid=$id 1.29 + AND time > (SELECT maxtime from mrt) 1.30 + AND user IN 1.31 + (SELECT user FROM grp_mem 1.32 + WHERE gname = $(sqlquote "$blogowner"))) 1.33 + ; 1.34 + EOF 1.35 $iswritable && cat<<-EOF 1.36 <div class="blogcomment"> 1.37 <input type="hidden" name="blogid" value="$id">