Mercurial > hgrepos > hgweb.cgi > s4
annotate s4-blog.sh @ 381:879d7f1cd676
More explanatory comment about previous commit.
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Mon, 28 Nov 2016 07:46:35 +0859 |
parents | b0d1b4914789 |
children | 606404fbb3d3 |
rev | line source |
---|---|
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
1 # |
17 | 2 type cgiinit >/dev/null 2>&1 || . ./s4-funcs.sh |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
3 |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
4 blog_genform() { |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
5 # |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
6 t=$1 |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
7 } |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
8 |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
9 blog_writable() ( |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
10 # $1=articleid $2=user |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
11 blogowner=`getvalbyid blog owner "$1"` |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
12 [ x"$blogowner" = x"$2" ] || isuser "$blogowner" || ismember "$2" "$blogowner" |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
13 ) |
138
130114486d8c
Blog of moderated group cannot be read by outsider.
HIROSE Yuuji <yuuji@gentei.org>
parents:
134
diff
changeset
|
14 blog_readable() { |
130114486d8c
Blog of moderated group cannot be read by outsider.
HIROSE Yuuji <yuuji@gentei.org>
parents:
134
diff
changeset
|
15 # $1=articleid $2=user |
130114486d8c
Blog of moderated group cannot be read by outsider.
HIROSE Yuuji <yuuji@gentei.org>
parents:
134
diff
changeset
|
16 mode=`getgroupattr $grp regmode` |
130114486d8c
Blog of moderated group cannot be read by outsider.
HIROSE Yuuji <yuuji@gentei.org>
parents:
134
diff
changeset
|
17 } |
50
13f9b5e5df85
subshellize blog_notify_reply
HIROSE Yuuji <yuuji@gentei.org>
parents:
48
diff
changeset
|
18 blog_notify_reply() ( |
222
d320c73bf16f
Add "team" attributes in groups.
HIROSE Yuuji <yuuji@gentei.org>
parents:
219
diff
changeset
|
19 # $1=blogid $2=ReplyingUser $3=WrittenText $4(optional)=Action |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
20 blogowner=`getvalbyid blog owner "$1"` |
28
7ae119a14613
Do not send comment notification when author is board owner
HIROSE Yuuji <yuuji@gentei.org>
parents:
17
diff
changeset
|
21 [ x"$2" = x"$blogowner" ] && return # If author=blogowner, unnecessary |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
22 blogtitle=`getvalbyid blog title "$1"` |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
23 blogurl="$urlbase?replyblog+$1" |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
24 action=${4:-書き込み} |
50
13f9b5e5df85
subshellize blog_notify_reply
HIROSE Yuuji <yuuji@gentei.org>
parents:
48
diff
changeset
|
25 mode=`getvalbyid blog notify "$1"` |
238
45b7facac49e
Do not exclude submitting user from new article notification.
HIROSE Yuuji <yuuji@gentei.org>
parents:
222
diff
changeset
|
26 ### EXCEPT=`sqlquote "$user"` ## User should receive to feal some annoyance |
50
13f9b5e5df85
subshellize blog_notify_reply
HIROSE Yuuji <yuuji@gentei.org>
parents:
48
diff
changeset
|
27 case $mode in |
48 | 28 admin) |
55
7f9f7e898986
Do not send notification to the person-self
HIROSE Yuuji <yuuji@gentei.org>
parents:
54
diff
changeset
|
29 if isgroup "$blogowner"; then |
117 | 30 emails=`getgroupadminmails $blogowner` |
48 | 31 else |
32 emails=`collectemail $blogowner` | |
33 fi | |
170
45d6954af516
TEST: notifyto button added for evaluation
HIROSE Yuuji <yuuji@gentei.org>
parents:
168
diff
changeset
|
34 notifyto=`getpar notifyto` |
191
24e0f2b4d51b
Variable name mistake fixed
HIROSE Yuuji <yuuji@gentei.org>
parents:
189
diff
changeset
|
35 if [ -n "$notifyto" ]; then |
170
45d6954af516
TEST: notifyto button added for evaluation
HIROSE Yuuji <yuuji@gentei.org>
parents:
168
diff
changeset
|
36 emails=$emails" `email4groupbyuid \"$blogowner\" $notifyto`" |
45d6954af516
TEST: notifyto button added for evaluation
HIROSE Yuuji <yuuji@gentei.org>
parents:
168
diff
changeset
|
37 fi |
48 | 38 ;; |
39 no) return ;; | |
222
d320c73bf16f
Add "team" attributes in groups.
HIROSE Yuuji <yuuji@gentei.org>
parents:
219
diff
changeset
|
40 *) team=`query "SELECT val FROM blog_s |
d320c73bf16f
Add "team" attributes in groups.
HIROSE Yuuji <yuuji@gentei.org>
parents:
219
diff
changeset
|
41 WHERE id=(SELECT id FROM blog WHERE rowid=$1) |
d320c73bf16f
Add "team" attributes in groups.
HIROSE Yuuji <yuuji@gentei.org>
parents:
219
diff
changeset
|
42 AND key='team';"` |
d320c73bf16f
Add "team" attributes in groups.
HIROSE Yuuji <yuuji@gentei.org>
parents:
219
diff
changeset
|
43 # team cannot get `getvalbyid blog team "$1"` because it's not |
d320c73bf16f
Add "team" attributes in groups.
HIROSE Yuuji <yuuji@gentei.org>
parents:
219
diff
changeset
|
44 # defined in blog.def. Yes, it is Illegal USE!! |
d320c73bf16f
Add "team" attributes in groups.
HIROSE Yuuji <yuuji@gentei.org>
parents:
219
diff
changeset
|
45 emails=`TEAM=$team collectemail $blogowner` ;; |
48 | 46 esac |
165
4040bb8b2038
quote search kwd. $SMAIL_TO controls To: header value.
HIROSE Yuuji <yuuji@gentei.org>
parents:
162
diff
changeset
|
47 err notify: user=$user Admins=`getgroupadmins $blogowner` Mode=$mode Emails="[$emails]" |
168 | 48 SMAIL_TO="`echo "$blogowner" | nkf -jM | tr -d '\n'` readers <$admin>" \ |
165
4040bb8b2038
quote search kwd. $SMAIL_TO controls To: header value.
HIROSE Yuuji <yuuji@gentei.org>
parents:
162
diff
changeset
|
49 smail "$emails" "${action}通知 $urlbase"<<EOF |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
50 [$blogtitle]板に${action}がありました。 |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
51 場所: $blogurl |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
52 題目: $blogtitle |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
53 筆者: `gecos $2` |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
54 内容: |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
55 `echo "$3"|sed 's/^/> /'` |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
56 EOF |
50
13f9b5e5df85
subshellize blog_notify_reply
HIROSE Yuuji <yuuji@gentei.org>
parents:
48
diff
changeset
|
57 ) |
192
50e6195130b3
blog_showentry2() is now blog_showentry() (Old code removed)
HIROSE Yuuji <yuuji@gentei.org>
parents:
191
diff
changeset
|
58 |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
59 blog_showentry() { |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
60 # $1=table $2=rowid |
69 | 61 # if [ -n "$2" ]; then |
62 # if [ -n "$imgcached" ]; then | |
63 # bstmpdir=$tmpdir/$imgcached/$thumbxy | |
64 # else | |
65 # bstmpdir=$tmpd | |
66 # # tmpd=`mktempd` | |
67 # # tmpfiles=$tmpfiles" $tmpd" | |
68 # fi | |
69 # fi | |
72
3dc3ddd2d3e5
getcachedir argument contains rowid
HIROSE Yuuji <yuuji@gentei.org>
parents:
69
diff
changeset
|
70 td=`getcachedir "article/$2"` |
291
1df64f0490ca
`|col|col|...' like table conversion enabled
HIROSE Yuuji <yuuji@gentei.org>
parents:
288
diff
changeset
|
71 [ -d "$td" ] || mkdir -p $td |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
72 tbl=${1%%[!A-Z0-9a-z_]*} rowid=${2%%[!A-Z0-9a-z_]*} |
356
c087423c8234
Most of debugging code deactivated
HIROSE Yuuji <yuuji@gentei.org>
parents:
352
diff
changeset
|
73 err blow_showentry: rowid=$rowid, '$2'=$2 user=$user |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
74 ts=${tbl}_s tm=${tbl}_m |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
75 at=article as=article_s am=article_m |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
76 serial=$(($(date +%s)-1420038000))s$$ |
64
54bbd7ce3766
Inhibit non-group-member from *handout
HIROSE Yuuji <yuuji@gentei.org>
parents:
63
diff
changeset
|
77 blog_writable $rowid $user && iswritable=true || iswritable=false |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
78 # This function grasps blog entry definiton directly. |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
79 # blog: id |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
80 # blog_s: title,ctime,heading |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
81 # blog_m: *article |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
82 |
138
130114486d8c
Blog of moderated group cannot be read by outsider.
HIROSE Yuuji <yuuji@gentei.org>
parents:
134
diff
changeset
|
83 # 2015-10-05 check readable |
130114486d8c
Blog of moderated group cannot be read by outsider.
HIROSE Yuuji <yuuji@gentei.org>
parents:
134
diff
changeset
|
84 if ! $iswritable; then |
130114486d8c
Blog of moderated group cannot be read by outsider.
HIROSE Yuuji <yuuji@gentei.org>
parents:
134
diff
changeset
|
85 blogowner=`getvalbyid blog owner "$2"` |
130114486d8c
Blog of moderated group cannot be read by outsider.
HIROSE Yuuji <yuuji@gentei.org>
parents:
134
diff
changeset
|
86 # err blogowner=$blogowner |
130114486d8c
Blog of moderated group cannot be read by outsider.
HIROSE Yuuji <yuuji@gentei.org>
parents:
134
diff
changeset
|
87 if isgroup $blogowner; then |
130114486d8c
Blog of moderated group cannot be read by outsider.
HIROSE Yuuji <yuuji@gentei.org>
parents:
134
diff
changeset
|
88 regmode=`getgroupattr $blogowner regmode` |
130114486d8c
Blog of moderated group cannot be read by outsider.
HIROSE Yuuji <yuuji@gentei.org>
parents:
134
diff
changeset
|
89 # err regmode=$regmode |
130114486d8c
Blog of moderated group cannot be read by outsider.
HIROSE Yuuji <yuuji@gentei.org>
parents:
134
diff
changeset
|
90 if [ x"$regmode" = x"moderated" ]; then |
130114486d8c
Blog of moderated group cannot be read by outsider.
HIROSE Yuuji <yuuji@gentei.org>
parents:
134
diff
changeset
|
91 if ! ismember $user $blogowner; then |
130114486d8c
Blog of moderated group cannot be read by outsider.
HIROSE Yuuji <yuuji@gentei.org>
parents:
134
diff
changeset
|
92 echo "加入してからどうぞ" | html p |
130114486d8c
Blog of moderated group cannot be read by outsider.
HIROSE Yuuji <yuuji@gentei.org>
parents:
134
diff
changeset
|
93 return |
130114486d8c
Blog of moderated group cannot be read by outsider.
HIROSE Yuuji <yuuji@gentei.org>
parents:
134
diff
changeset
|
94 fi |
130114486d8c
Blog of moderated group cannot be read by outsider.
HIROSE Yuuji <yuuji@gentei.org>
parents:
134
diff
changeset
|
95 fi |
130114486d8c
Blog of moderated group cannot be read by outsider.
HIROSE Yuuji <yuuji@gentei.org>
parents:
134
diff
changeset
|
96 fi |
130114486d8c
Blog of moderated group cannot be read by outsider.
HIROSE Yuuji <yuuji@gentei.org>
parents:
134
diff
changeset
|
97 fi |
170
45d6954af516
TEST: notifyto button added for evaluation
HIROSE Yuuji <yuuji@gentei.org>
parents:
168
diff
changeset
|
98 case `getvalbyid blog notify "$2"` in # "all", "admin" or "no" (or NULL) |
45d6954af516
TEST: notifyto button added for evaluation
HIROSE Yuuji <yuuji@gentei.org>
parents:
168
diff
changeset
|
99 admin) notifyto=1 ;; |
45d6954af516
TEST: notifyto button added for evaluation
HIROSE Yuuji <yuuji@gentei.org>
parents:
168
diff
changeset
|
100 *) notifyto="" ;; |
45d6954af516
TEST: notifyto button added for evaluation
HIROSE Yuuji <yuuji@gentei.org>
parents:
168
diff
changeset
|
101 esac |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
102 |
335
a120ba2d719b
Show link to the beginning of page at the bottom of page.
HIROSE Yuuji <yuuji@gentei.org>
parents:
333
diff
changeset
|
103 # err "SELECT id from $tbl where rowid=$rowid" |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
104 id=`query "select id from $tbl where rowid=$rowid;"` |
335
a120ba2d719b
Show link to the beginning of page at the bottom of page.
HIROSE Yuuji <yuuji@gentei.org>
parents:
333
diff
changeset
|
105 #err id=$id |
a120ba2d719b
Show link to the beginning of page at the bottom of page.
HIROSE Yuuji <yuuji@gentei.org>
parents:
333
diff
changeset
|
106 #err "select val from $ts where key='title' and id='$id';" |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
107 |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
108 |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
109 #(1)Display root article |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
110 cat<<EOF |
239
25e0b1eaf04d
Degrade fixed: Explicit notify works again.
HIROSE Yuuji <yuuji@gentei.org>
parents:
238
diff
changeset
|
111 <form class="replyblog" action="$myname?replyblog+${rowid}#bottom" method="POST" enctype="multipart/form-data"> |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
112 <table class="bloghead"> |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
113 EOF |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
114 |
341 | 115 href="<a href=\"?editheading+$rowid\" accesskey=\"e\" title=\"E\"> 編集 </a>" |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
116 if $iswritable; then |
369
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
117 case `getvalbyid blog mode $rowid` in |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
118 *report*) |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
119 href2="<a href=\"?lshandout+$rowid\" accesskey=\"l\" title=\"L\"> 提出状況 </a>" |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
120 ;; |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
121 esac |
341 | 122 href3="(<a href=\"?gethandout+$rowid\" accesskey=\"f\" title=\"F\">ファイル取得</a>)" |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
123 fi |
341 | 124 href4='<a href="#bottom" accesskey="b" title="B"> 末尾へ</a>' |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
125 |
293
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
126 query<<-EOF | |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
127 SELECT coalesce((SELECT "yes" FROM blog |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
128 WHERE rowid=$rowid AND author='$user'), |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
129 ''), |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
130 max(CASE key WHEN 'ctime' THEN val END) ctime, |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
131 max(CASE key WHEN 'heading' THEN hex(val) END) heading, |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
132 CASE (SELECT val FROM $ts WHERE key="mode" AND id="$id") |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
133 WHEN 'report-closed' THEN 'レポート提出用(closed)' |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
134 WHEN 'report-open' THEN 'レポート提出用(open)' |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
135 ELSE '' |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
136 END |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
137 FROM $ts WHERE id='$id' GROUP BY id; |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
138 EOF |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
139 { IFS='|' read edit ctime hexhead blogtype |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
140 cat<<-EOF |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
141 <tr><td>${edit:+$href }$ctime $blogtype $href2$href3 $href4</td></tr> |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
142 <tr class="preface"> |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
143 <td>`echo "$hexhead"|unhexize|hreflink|minitbl`</td></tr> |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
144 </table> |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
145 |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
146 <table class="blog_replies"> |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
147 EOF |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
148 } |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
149 lkhome="<a href=\"$myname?home" lke='">' |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
150 lkedit="<a href=\"$myname?editart" |
263
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
151 hlink="$myname?home" elink="$myname?editart" |
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
152 catlink="$myname?showattc+article_m" |
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
153 deficon="img/file-icon.png" |
286
1c4f13f0813e
Add newer article flag representing by time string decoration.
HIROSE Yuuji <yuuji@gentei.org>
parents:
283
diff
changeset
|
154 # 2016-08-15 Newer flag introduced |
1c4f13f0813e
Add newer article flag representing by time string decoration.
HIROSE Yuuji <yuuji@gentei.org>
parents:
283
diff
changeset
|
155 atime=`query "SELECT time FROM acclog |
1c4f13f0813e
Add newer article flag representing by time string decoration.
HIROSE Yuuji <yuuji@gentei.org>
parents:
283
diff
changeset
|
156 WHERE tbl='blog' AND tblrowid=$rowid AND user='$user';"` |
333
002cc900200a
Nonexistent Icon cleaning is too heavy, put it after loop
HIROSE Yuuji <yuuji@gentei.org>
parents:
331
diff
changeset
|
157 iconcleaner=$tmpd/iconcleaner.$$ |
381
879d7f1cd676
More explanatory comment about previous commit.
HIROSE Yuuji <yuuji@gentei.org>
parents:
380
diff
changeset
|
158 # *** DO NOT USE query() and use "sq $db" here *** |
879d7f1cd676
More explanatory comment about previous commit.
HIROSE Yuuji <yuuji@gentei.org>
parents:
380
diff
changeset
|
159 # because the next block in pipe line uses query() repeatedly. |
380
b0d1b4914789
Revert to call "sq $db" instead of query() because of pipe error
HIROSE Yuuji <yuuji@gentei.org>
parents:
379
diff
changeset
|
160 sq $db<<EOF | |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
161 WITH a_s AS ( |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
162 SELECT id, |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
163 max(CASE key WHEN 'ctime' THEN val END) TIME, |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
164 max(CASE key WHEN 'text' THEN val END) TEXT |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
165 FROM article_s |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
166 GROUP by id |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
167 ) |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
168 SELECT a.id, |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
169 CASE author |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
170 WHEN '$user' THEN a.rowid||'+'||$rowid |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
171 ELSE '' |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
172 END edit, |
170
45d6954af516
TEST: notifyto button added for evaluation
HIROSE Yuuji <yuuji@gentei.org>
parents:
168
diff
changeset
|
173 CASE -- 「通知送信」ボタンの有無 |
45d6954af516
TEST: notifyto button added for evaluation
HIROSE Yuuji <yuuji@gentei.org>
parents:
168
diff
changeset
|
174 WHEN '$notifyto' = '' THEN '' -- 不要モードならなし |
45d6954af516
TEST: notifyto button added for evaluation
HIROSE Yuuji <yuuji@gentei.org>
parents:
168
diff
changeset
|
175 WHEN '$user' = author THEN '' -- 筆者自身ならなし |
45d6954af516
TEST: notifyto button added for evaluation
HIROSE Yuuji <yuuji@gentei.org>
parents:
168
diff
changeset
|
176 ELSE "yes" |
45d6954af516
TEST: notifyto button added for evaluation
HIROSE Yuuji <yuuji@gentei.org>
parents:
168
diff
changeset
|
177 END notify, |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
178 (SELECT rowid FROM user WHERE name=author) user_rid, |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
179 coalesce((SELECT val FROM user_s |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
180 WHERE name=author AND key='gecos'), |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
181 author) uname, |
322
18be0c210dc8
First implementation of icon display in blog_replies.
HIROSE Yuuji <yuuji@gentei.org>
parents:
304
diff
changeset
|
182 (SELECT val FROM user_s WHERE name=author AND key='$iconcachekey') |
18be0c210dc8
First implementation of icon display in blog_replies.
HIROSE Yuuji <yuuji@gentei.org>
parents:
304
diff
changeset
|
183 icon, |
183
b641b5393c40
TEST: Put rowid of article for convenience to reference
HIROSE Yuuji <yuuji@gentei.org>
parents:
170
diff
changeset
|
184 a.rowid, |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
185 s.TIME, |
286
1c4f13f0813e
Add newer article flag representing by time string decoration.
HIROSE Yuuji <yuuji@gentei.org>
parents:
283
diff
changeset
|
186 CASE WHEN s.TIME > '$atime' THEN 'new' ELSE '' END newer, |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
187 hex(s.TEXT), |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
188 (SELECT group_concat(rowid||':'||length(bin)||':'||hex(val), ' ') |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
189 FROM article_m |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
190 WHERE id=a.id AND key='image') imxgids |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
191 FROM (select rowid,id,author from article where blogid in |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
192 (select id from blog where rowid=$rowid)) a |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
193 LEFT JOIN |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
194 a_s s |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
195 ON a.id=s.id; |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
196 EOF |
322
18be0c210dc8
First implementation of icon display in blog_replies.
HIROSE Yuuji <yuuji@gentei.org>
parents:
304
diff
changeset
|
197 while IFS='|' read id edit notify uid uname icon aid tm new hte imgids; do |
263
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
198 nt="<label style=\"font-size: 70%;\"><input type=\"checkbox\" |
170
45d6954af516
TEST: notifyto button added for evaluation
HIROSE Yuuji <yuuji@gentei.org>
parents:
168
diff
changeset
|
199 name=\"notifyto\" value=\"$uid\">返信通知送信</label>" |
322
18be0c210dc8
First implementation of icon display in blog_replies.
HIROSE Yuuji <yuuji@gentei.org>
parents:
304
diff
changeset
|
200 tdcls="repatt${new:+ new}" |
18be0c210dc8
First implementation of icon display in blog_replies.
HIROSE Yuuji <yuuji@gentei.org>
parents:
304
diff
changeset
|
201 if [ -n "$icon" -a -s "$icon" ]; then |
326
d19e85a72a29
Allow spaces and special characters in filenames(tentative).
HIROSE Yuuji <yuuji@gentei.org>
parents:
322
diff
changeset
|
202 icfn=`echo "$icon"|htmlescape` |
d19e85a72a29
Allow spaces and special characters in filenames(tentative).
HIROSE Yuuji <yuuji@gentei.org>
parents:
322
diff
changeset
|
203 picon="<p class=\"proficon\"><a href=\"$hlink+$uid\"><img src=\"$icfn\"></a></p>" |
322
18be0c210dc8
First implementation of icon display in blog_replies.
HIROSE Yuuji <yuuji@gentei.org>
parents:
304
diff
changeset
|
204 else |
18be0c210dc8
First implementation of icon display in blog_replies.
HIROSE Yuuji <yuuji@gentei.org>
parents:
304
diff
changeset
|
205 picon="" |
333
002cc900200a
Nonexistent Icon cleaning is too heavy, put it after loop
HIROSE Yuuji <yuuji@gentei.org>
parents:
331
diff
changeset
|
206 if [ -n "$icon" ]; then |
002cc900200a
Nonexistent Icon cleaning is too heavy, put it after loop
HIROSE Yuuji <yuuji@gentei.org>
parents:
331
diff
changeset
|
207 echo "DELETE FROM user_s WHERE key='$iconcachekey' AND |
002cc900200a
Nonexistent Icon cleaning is too heavy, put it after loop
HIROSE Yuuji <yuuji@gentei.org>
parents:
331
diff
changeset
|
208 val=`sqlquotestr \"$icon\"`;" >> $iconcleaner |
002cc900200a
Nonexistent Icon cleaning is too heavy, put it after loop
HIROSE Yuuji <yuuji@gentei.org>
parents:
331
diff
changeset
|
209 fi |
322
18be0c210dc8
First implementation of icon display in blog_replies.
HIROSE Yuuji <yuuji@gentei.org>
parents:
304
diff
changeset
|
210 fi |
18be0c210dc8
First implementation of icon display in blog_replies.
HIROSE Yuuji <yuuji@gentei.org>
parents:
304
diff
changeset
|
211 |
291
1df64f0490ca
`|col|col|...' like table conversion enabled
HIROSE Yuuji <yuuji@gentei.org>
parents:
288
diff
changeset
|
212 cat<<EOF |
283 | 213 <tr id="$id"> |
322
18be0c210dc8
First implementation of icon display in blog_replies.
HIROSE Yuuji <yuuji@gentei.org>
parents:
304
diff
changeset
|
214 <td class="$tdcls">$picon${edit:+<a href="$elink+$edit">編集</a> }#$aid |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
215 <a href="$hlink+$uid">$uname</a> |
287
422270e94adc
New flag attached to `time' has low visibility. Attached to `td'.
HIROSE Yuuji <yuuji@gentei.org>
parents:
286
diff
changeset
|
216 $tm |
291
1df64f0490ca
`|col|col|...' like table conversion enabled
HIROSE Yuuji <yuuji@gentei.org>
parents:
288
diff
changeset
|
217 ${notify:+$nt}</td> |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
218 EOF |
291
1df64f0490ca
`|col|col|...' like table conversion enabled
HIROSE Yuuji <yuuji@gentei.org>
parents:
288
diff
changeset
|
219 echo -n "<td id=\"$aid\" class=\"repl\">" |
1df64f0490ca
`|col|col|...' like table conversion enabled
HIROSE Yuuji <yuuji@gentei.org>
parents:
288
diff
changeset
|
220 echo "$hte"|unhexize|htmlescape|hreflink|minitbl |
264
9131c7e09112
Use cache file for article images.
HIROSE Yuuji <yuuji@gentei.org>
parents:
263
diff
changeset
|
221 usecache='' tsfile=$td/$id.stamp |
263
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
222 for i in $imgids; do |
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
223 mrid=${i%%:*}; i=${i#*:}; sz=`size_h ${i%%:*}` |
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
224 fn=`echo "${i#*:}"|unhexize` |
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
225 fnb=$fn"(${sz})" |
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
226 case "$fn" in |
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
227 *.[Pp][Nn][Gg]|*.[Jj][Pp][Gg]|*.[Jj][Pp][Ee][Gg]|*.[Gg][Ii][Ff]) |
268
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
228 # fmt=${fn##*.} # convert - jpg:- is slow...why |
263
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
229 case "$fn" in |
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
230 *.[Pp][Nn][Gg]) fmt=png ;; |
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
231 *.[Gg][Ii][Ff]) fmt=gif ;; |
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
232 *) fmt=jpeg ;; |
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
233 esac |
268
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
234 outfile=$td/$mrid-${fn%.*}.$fmt |
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
235 #err fn=$fn outfile=$outfile |
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
236 #err "usecache=$usecache `ls -l $outfile`" |
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
237 #err tm=$tm |
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
238 #err tsfile=$tsfile=`cat $tsfile` |
331
1a60dfc56bb0
Search form in other user's home restrict author to that one.
HIROSE Yuuji <yuuji@gentei.org>
parents:
326
diff
changeset
|
239 if [ -s "$outfile" ] && # $outfile should be > 0 |
268
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
240 { [ "$usecache" ] || # And usecache flag is true, or... |
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
241 { [ -s "$tsfile" ] && [ x"`cat $tsfile`" = x"$tm" ] |
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
242 };}; then |
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
243 usecache=1 # Set usecache flag on |
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
244 cat<<-EOF |
264
9131c7e09112
Use cache file for article images.
HIROSE Yuuji <yuuji@gentei.org>
parents:
263
diff
changeset
|
245 <a href="$catlink+$mrid"><img src="$outfile"> |
9131c7e09112
Use cache file for article images.
HIROSE Yuuji <yuuji@gentei.org>
parents:
263
diff
changeset
|
246 $fnb</a> |
9131c7e09112
Use cache file for article images.
HIROSE Yuuji <yuuji@gentei.org>
parents:
263
diff
changeset
|
247 EOF |
268
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
248 else |
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
249 query "SELECT hex(bin) FROM article_m WHERE rowid=$mrid;" \ |
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
250 | unhexize \ |
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
251 | convert -define ${fmt}:size=100x100 -resize 100x100'>' \ |
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
252 - ${fmt}:- \ |
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
253 | tee "$outfile" \ |
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
254 | hexize \ |
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
255 | sed -e 's/\(..\)/%\1/g' \ |
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
256 -e "s|^|<a href=\"$catlink+$mrid\"><img src=\"data:image/$fmt,|" \ |
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
257 -e "s|\$|\">$fnb</a>|" |
291
1df64f0490ca
`|col|col|...' like table conversion enabled
HIROSE Yuuji <yuuji@gentei.org>
parents:
288
diff
changeset
|
258 # [ -d $td ] || mkdir -p "$td" |
268
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
259 echo $tm > $tsfile |
264
9131c7e09112
Use cache file for article images.
HIROSE Yuuji <yuuji@gentei.org>
parents:
263
diff
changeset
|
260 fi |
263
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
261 ;; |
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
262 *) |
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
263 echo "<a href=\"$catlink+$mrid\"><img src=\"$deficon\">$fnb</a>" |
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
264 ;; |
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
265 esac |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
266 done |
263
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
267 echo "</td></tr>" |
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
268 done |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
269 |
193 | 270 textform='<div class="fold"> |
341 | 271 <input type="checkbox" id="cmt" checked><label |
272 accesskey="c" title="C" for="cmt">コメントする</label><div> | |
193 | 273 <table class="b"> |
274 <tr><td><textarea name="text" cols="72" rows="4"></textarea></td></tr> | |
205
6c63ea1b65d5
Add "accept" attribute to input:type="file"
HIROSE Yuuji <yuuji@gentei.org>
parents:
204
diff
changeset
|
275 <tr><td>添付ファイル: |
206 | 276 <input type="file" name="image"'" $file_accept multiple></td></tr>"' |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
277 </table> |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
278 <input type="submit" value="送信"> |
193 | 279 <input type="reset" value="リセット"></div></div> |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
280 ' |
219
e2dea2f63a69
Duplicate posting by reload avoided
HIROSE Yuuji <yuuji@gentei.org>
parents:
208
diff
changeset
|
281 cat<<-EOF |
239
25e0b1eaf04d
Degrade fixed: Explicit notify works again.
HIROSE Yuuji <yuuji@gentei.org>
parents:
238
diff
changeset
|
282 </table> <!-- end of s4-blog:blog_showentry() main table --> |
219
e2dea2f63a69
Duplicate posting by reload avoided
HIROSE Yuuji <yuuji@gentei.org>
parents:
208
diff
changeset
|
283 <p class="update_link"><a |
341 | 284 href="?reload/$rowid" accesskey="r" title="R">再読込</a> / <a |
285 href="#title" accesskey="t" title="T">先頭へ</a></p> | |
219
e2dea2f63a69
Duplicate posting by reload avoided
HIROSE Yuuji <yuuji@gentei.org>
parents:
208
diff
changeset
|
286 EOF |
e2dea2f63a69
Duplicate posting by reload avoided
HIROSE Yuuji <yuuji@gentei.org>
parents:
208
diff
changeset
|
287 $iswritable && cat<<-EOF |
e2dea2f63a69
Duplicate posting by reload avoided
HIROSE Yuuji <yuuji@gentei.org>
parents:
208
diff
changeset
|
288 <div class="blogcomment"> |
239
25e0b1eaf04d
Degrade fixed: Explicit notify works again.
HIROSE Yuuji <yuuji@gentei.org>
parents:
238
diff
changeset
|
289 <input type="hidden" name="blogid" value="$id"> |
268
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
290 <input type="hidden" name="id" value="`genserial`"> |
239
25e0b1eaf04d
Degrade fixed: Explicit notify works again.
HIROSE Yuuji <yuuji@gentei.org>
parents:
238
diff
changeset
|
291 <input type="hidden" name="stage" value="replyblog"> |
25e0b1eaf04d
Degrade fixed: Explicit notify works again.
HIROSE Yuuji <yuuji@gentei.org>
parents:
238
diff
changeset
|
292 $textform |
25e0b1eaf04d
Degrade fixed: Explicit notify works again.
HIROSE Yuuji <yuuji@gentei.org>
parents:
238
diff
changeset
|
293 </div> |
25e0b1eaf04d
Degrade fixed: Explicit notify works again.
HIROSE Yuuji <yuuji@gentei.org>
parents:
238
diff
changeset
|
294 </form> <!-- End of s4-blog:blog_showentry() main form --> |
25e0b1eaf04d
Degrade fixed: Explicit notify works again.
HIROSE Yuuji <yuuji@gentei.org>
parents:
238
diff
changeset
|
295 <p id="bottom"> </p> |
25e0b1eaf04d
Degrade fixed: Explicit notify works again.
HIROSE Yuuji <yuuji@gentei.org>
parents:
238
diff
changeset
|
296 EOF |
333
002cc900200a
Nonexistent Icon cleaning is too heavy, put it after loop
HIROSE Yuuji <yuuji@gentei.org>
parents:
331
diff
changeset
|
297 # Clean up orphaned icon cache |
002cc900200a
Nonexistent Icon cleaning is too heavy, put it after loop
HIROSE Yuuji <yuuji@gentei.org>
parents:
331
diff
changeset
|
298 [ -s $iconcleaner ] && query < $iconcleaner |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
299 # Record access log |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
300 acclog blog $rowid |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
301 } |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
302 |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
303 lshandout() { |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
304 # $1=rowid of blog |
64
54bbd7ce3766
Inhibit non-group-member from *handout
HIROSE Yuuji <yuuji@gentei.org>
parents:
63
diff
changeset
|
305 if ! blog_writable $1 $user; then |
54bbd7ce3766
Inhibit non-group-member from *handout
HIROSE Yuuji <yuuji@gentei.org>
parents:
63
diff
changeset
|
306 echo "メンバー以外は利用できません。" | html p; return |
54bbd7ce3766
Inhibit non-group-member from *handout
HIROSE Yuuji <yuuji@gentei.org>
parents:
63
diff
changeset
|
307 fi |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
308 time=`getvalbyid blog ctime $1|colrm 11` |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
309 owner=`getvalbyid blog owner $1` |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
310 title=`getvalbyid blog title $1` |
2 | 311 ge=`gecos $owner` |
369
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
312 fh=$tmpd/formhead |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
313 echo "$time [$title]@${ge:-$owner}" > $fh |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
314 lshandoutsub $owner "$@" \ |
189 | 315 |_m4 -D_TITLE_="提出状況" \ |
369
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
316 -D_FORMHEAD_="syscmd(cat $fh)" \ |
189 | 317 -D_FORM_="syscmd(cat)" -D_DUMPHEAD_= -D_DUMPTABLE_= \ |
318 $layout/html.m4.html $layout/form+dump-whead.m4.html | |
369
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
319 gn=`echo $owner|htmlescape` |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
320 echo "<p><a href=\"?lshandoutall+$1\">グループ $gn すべてのレポート板集計</a></p>" |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
321 } |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
322 gethandoutcsv() { |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
323 # contenttype; echo |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
324 CATCSV=1 lshandoutall "$1" |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
325 } |
373
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
326 gethandoutcsv2() { |
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
327 # contenttype; echo |
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
328 SQL=$(cat<<-EOF) gethandoutcsv "$1" |
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
329 WITH this_blog_articles AS ( |
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
330 SELECT rtb.id bid, rtb.brid, a.id aid, author, title, ctime |
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
331 FROM report_type_blogs rtb JOIN article a ON rtb.id=a.blogid |
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
332 ), text_or_file AS ( |
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
333 SELECT bid, author, title, ctime, 'text' shu, count(val) cnt |
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
334 FROM this_blog_articles tba, article_s s |
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
335 ON tba.aid=s.id |
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
336 WHERE key='text' |
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
337 GROUP by bid, author |
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
338 UNION |
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
339 SELECT bid, author, title, ctime, 'file' shu, count(val) cnt |
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
340 FROM this_blog_articles tba, article_m m |
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
341 ON tba.aid=m.id |
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
342 WHERE key='image' |
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
343 GROUP by bid, author |
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
344 ), count_list AS ( |
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
345 SELECT author, |
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
346 substr(ctime, 1, 10)||upper(substr(shu, 1, 1)) unit, |
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
347 cnt |
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
348 FROM text_or_file |
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
349 ) |
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
350 SELECT gecos "名前", |
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
351 substr(author, 1, instr(author, '@')-1) "uname", |
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
352 unit, |
374
59e31510f574
Avoid to use "count" as column name(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
373
diff
changeset
|
353 cnt "post" |
373
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
354 FROM count_list cl JOIN gecoses g ON cl.author=g.name; |
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
355 EOF |
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
356 } |
369
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
357 lshandout_ulink_table() { |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
358 # NO Args. Read stdin as SQL |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
359 echo '<table class="b td3rr td3evw">' |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
360 hrb="<a href=\"?home+" |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
361 # echo "$sql" | sq -header -html $db \ # Formerly, this is called via sq() |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
362 |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
363 printf ".mode html\n.header ON\n" | query |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
364 cat | query \ |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
365 | sed -e "s,\(<TR><TD>\)\([^ ]*\) \(.*\)</TD>,\1$hrb\2\">\3</TD>," -e 's,<TD>0</TD>,<TD class="warn">0</TD>,' |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
366 echo '</table>' |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
367 printf ".mode list\n.header OFF\n" | query |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
368 } |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
369 lshandoutall() { |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
370 # $1=rowid of blog |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
371 if ! blog_writable $1 $user; then |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
372 echo "メンバー以外は利用できません。" | html p; return |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
373 fi |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
374 rowid=$(($1 + 0)) |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
375 owner=`getvalbyid blog owner $1` |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
376 qowner=`sqlquotestr "$owner"` |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
377 |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
378 query<<-EOF |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
379 CREATE TEMPORARY TABLE IF NOT EXISTS report_type_blogs AS |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
380 WITH blog_owner_mode AS ( |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
381 SELECT id, |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
382 blog.rowid brid, |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
383 max(CASE key WHEN 'owner' THEN val END) owner, |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
384 max(CASE key WHEN 'mode' THEN val END) mode, |
373
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
385 max(CASE key WHEN 'title' THEN val END) title, |
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
386 max(CASE key WHEN 'ctime' THEN val END) ctime |
369
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
387 FROM blog NATURAL JOIN blog_s |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
388 GROUP BY id |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
389 ) |
373
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
390 SELECT id, brid, title, ctime FROM blog_owner_mode |
369
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
391 WHERE owner=$qowner AND mode LIKE '%report%'; |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
392 /* ↑これでレポート形式の blogid 一覧を得る */ |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
393 EOF |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
394 if [ -z "$CATCSV" ]; then |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
395 _m4 -D_TITLE_="提出状況" $layout/html.m4.html |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
396 ge=`gecos "$owner"` |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
397 tbls="" |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
398 grptxt=`echo "${ge:-$owner}"|htmlescape` |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
399 echo "<h1>$grptxt 書き込み状況一覧</h1>" |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
400 fi |
375
b971fa6ebcb1
Do not call lshandoutsub if $SQL set(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
374
diff
changeset
|
401 if [ -z "$SQL" ]; then |
b971fa6ebcb1
Do not call lshandoutsub if $SQL set(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
374
diff
changeset
|
402 bridlist=`query "SELECT brid FROM report_type_blogs;"` |
b971fa6ebcb1
Do not call lshandoutsub if $SQL set(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
374
diff
changeset
|
403 for brid in $bridlist; do # Skip this loop if $SQL set |
b971fa6ebcb1
Do not call lshandoutsub if $SQL set(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
374
diff
changeset
|
404 brid=$(($brid + 0)) # Ensure to be a number |
b971fa6ebcb1
Do not call lshandoutsub if $SQL set(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
374
diff
changeset
|
405 [ $brid = 0 ] && continue |
b971fa6ebcb1
Do not call lshandoutsub if $SQL set(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
374
diff
changeset
|
406 time=`getvalbyid blog ctime $brid|colrm 11` |
b971fa6ebcb1
Do not call lshandoutsub if $SQL set(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
374
diff
changeset
|
407 title=`getvalbyid blog title $brid|htmlescape` |
b971fa6ebcb1
Do not call lshandoutsub if $SQL set(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
374
diff
changeset
|
408 tt="handout_$brid" |
b971fa6ebcb1
Do not call lshandoutsub if $SQL set(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
374
diff
changeset
|
409 if [ -z "$CATCSV" ]; then |
b971fa6ebcb1
Do not call lshandoutsub if $SQL set(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
374
diff
changeset
|
410 echo "<h2>$time - <a href=\"?replyblog+$brid\">$title</a></h2>" |
b971fa6ebcb1
Do not call lshandoutsub if $SQL set(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
374
diff
changeset
|
411 lshandoutsub "$owner" $brid "$tt" |
b971fa6ebcb1
Do not call lshandoutsub if $SQL set(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
374
diff
changeset
|
412 else |
b971fa6ebcb1
Do not call lshandoutsub if $SQL set(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
374
diff
changeset
|
413 lshandoutsub "$owner" $brid "$tt" >/dev/null # Only create temp.table |
b971fa6ebcb1
Do not call lshandoutsub if $SQL set(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
374
diff
changeset
|
414 fi |
b971fa6ebcb1
Do not call lshandoutsub if $SQL set(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
374
diff
changeset
|
415 tbls="$tbls${tbls:+ NATURAL JOIN }$tt" |
b971fa6ebcb1
Do not call lshandoutsub if $SQL set(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
374
diff
changeset
|
416 done |
b971fa6ebcb1
Do not call lshandoutsub if $SQL set(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
374
diff
changeset
|
417 fi |
373
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
418 sql=${SQL:-"SELECT * FROM $tbls;"} |
369
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
419 if [ -z "$CATCSV" ]; then |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
420 echo "<hr><h2>総合</h2>" |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
421 echo "$sql" | lshandout_ulink_table |
373
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
422 echo "<h2>総合(<a href=\"?gethandoutcsv+$rowid\">CSV</a>)</h2>" |
369
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
423 printf ".mode csv\n.header ON\n" | query |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
424 echo '<pre class="list">' |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
425 echo "$sql" | query | sed 's/^"[0-9]* /"/' |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
426 echo "</pre>" |
373
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
427 echo "<pre><a href=\"?gethandoutcsv2+$rowid\">縦持ちCSV</a></pre>" |
369
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
428 else |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
429 contenttype "Application/CSV" |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
430 printf ".mode csv\n.header ON\n" | query >/dev/null |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
431 fn=report-count.csv |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
432 printf 'Content-Disposition: filename="%s"\n' "$fn" |
379 | 433 outfile=$tmpd/out-$$.csv |
369
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
434 echo "$sql" | query | sed 's/^"[0-9]* /"/' > $outfile |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
435 echo "Content-Length: " `cat $outfile | wc -c`; echo |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
436 |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
437 cat $outfile |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
438 exit 0 |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
439 fi |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
440 printf ".mode list\n.header OFF\n.separator |\n" | query |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
441 } |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
442 lshandoutsub() { |
369
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
443 # $1=owner $2=rowid of blog &optional $3=temp_table name |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
444 qgname=`sqlquote "$1"` |
2 | 445 if isgroup $1; then |
369
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
446 sample="(select user from grp_mem where gname=$qgname)" |
2 | 447 else |
448 sample="(select distinct author as user from arts)" | |
67 | 449 echo "(集計は板への投稿者のみ)" | html p |
2 | 450 fi |
369
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
451 tmpname="${3:-handout_$2}" |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
452 sql="CREATE TEMPORARY TABLE IF NOT EXISTS $tmpname AS |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
453 with arts as (select id,author from article \ |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
454 where blogid=(select id from blog where rowid=$2))\ |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
455 select (select rowid from user where name=c0.user)||' '|| \ |
366
884cd7c66917
Use gecoses table instead of coalesce().
HIROSE Yuuji <yuuji@gentei.org>
parents:
365
diff
changeset
|
456 (select gecos from gecoses where name=c0.user) as 'メンバー',\ |
373
57a2e6acf005
Add link to creating normalized csv(gethandoutcsv2)
HIROSE Yuuji <yuuji@gentei.org>
parents:
369
diff
changeset
|
457 substr(c0.user, 1, instr(c0.user, '@')-1) 'uname',\ |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
458 sum(case when c1.key is not null then 1 else 0 end)\ |
369
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
459 as '[$title] コメント記入',\ |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
460 sum(case when c2.key is not null then 1 else 0 end)\ |
369
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
461 as '[$title] ファイルの提出'\ |
2 | 462 from $sample c0 \ |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
463 left join (select id,author from arts) a\ |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
464 on c0.user=a.author\ |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
465 left join (select id,key from article_s where key='text') c1\ |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
466 on a.id=c1.id left join (select id,key from article_m ) c2\ |
369
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
467 on c1.id=c2.id group by c0.user order by c0.user;\ |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
468 \ |
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
469 SELECT * FROM $tmpname;" |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
470 err ishandoutsub: sql="$sql" |
369
5f01ead0174f
Add feature of scoring up all report-style blogs.
HIROSE Yuuji <yuuji@gentei.org>
parents:
367
diff
changeset
|
471 echo "$sql" | lshandout_ulink_table |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
472 } |
2 | 473 gethandout() { |
474 # $1=rowid of blog | |
64
54bbd7ce3766
Inhibit non-group-member from *handout
HIROSE Yuuji <yuuji@gentei.org>
parents:
63
diff
changeset
|
475 if ! blog_writable $1 $user; then |
54bbd7ce3766
Inhibit non-group-member from *handout
HIROSE Yuuji <yuuji@gentei.org>
parents:
63
diff
changeset
|
476 echo "メンバー以外は利用できません。" | html p; return |
54bbd7ce3766
Inhibit non-group-member from *handout
HIROSE Yuuji <yuuji@gentei.org>
parents:
63
diff
changeset
|
477 fi |
2 | 478 i=0 |
479 bd=$tmpd/archive.$$ | |
480 mkdir $bd | |
481 query "select m.rowid,author,m.val from article a join article_m m\ | |
482 on a.id=m.id where blogid=(select id from blog where rowid=$1)\ | |
483 and m.key in ('image', 'document', 'binary');" \ | |
484 | while IFS='|' read rowid author filename; do | |
356
c087423c8234
Most of debugging code deactivated
HIROSE Yuuji <yuuji@gentei.org>
parents:
352
diff
changeset
|
485 err isfilereadable $user article_m $rowid |
63 | 486 isfilereadable $user article_m $rowid || continue |
356
c087423c8234
Most of debugging code deactivated
HIROSE Yuuji <yuuji@gentei.org>
parents:
352
diff
changeset
|
487 err ok |
2 | 488 i=$((i+1)) |
489 dir=`printf $bd/%03d $i` | |
490 mkdir $dir | |
491 query "select quote(bin) from article_m where rowid=$rowid;" \ | |
8 | 492 | unhexize > $dir/$filename |
2 | 493 done |
494 if [ ! -d $bd/001 ]; then | |
495 contenttype; echo | |
67 | 496 echo "取得できるファイルがありませんでした。" | html p |
2 | 497 return |
498 fi | |
499 (cd $bd | |
356
c087423c8234
Most of debugging code deactivated
HIROSE Yuuji <yuuji@gentei.org>
parents:
352
diff
changeset
|
500 ## err cdto$bd; (pwd; ls -lFa) 1>&3 |
2 | 501 tar zcf .archive.tar.gz * && mv .archive.tar.gz archive.tar.gz |
356
c087423c8234
Most of debugging code deactivated
HIROSE Yuuji <yuuji@gentei.org>
parents:
352
diff
changeset
|
502 err Creating tar archive "`ls -l archive.tar.gz`" |
2 | 503 ) |
504 arc=$bd/archive.tar.gz | |
505 echo "Content-type: application/x-gzip" | |
506 echo "Content-Length: `cat $arc|wc -c`" | |
507 echo "Content-Disposition: filename=\"archive.tar.gz\"" | |
508 echo | |
509 cat $arc | |
510 } | |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
511 lsmyfile() { # $1(optional)=SortBy |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
512 case "$1" in |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
513 ""|CTIME-DESC) |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
514 by="CTIME" ord="DESC" ;; |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
515 CTIME*) by="CTIME" ;; |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
516 FILE*) by="FILE" ;; |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
517 OWNER*) by="OWNER" ;; |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
518 TITLE*) by="TITLE" ;; |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
519 esac |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
520 case "$1" in |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
521 *DESC) ord="DESC" ;; |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
522 esac |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
523 case "$ord" in |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
524 DESC) lkod="" jord="降順" ;; |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
525 *) lkod="-DESC" jord="昇順" ;; |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
526 esac |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
527 sql="select m.val||'/'||m.rowid FILE, |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
528 coalesce( |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
529 case when (select name from user where name=bs.owner) |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
530 is not null |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
531 then (select val from user_s where name=bs.owner |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
532 and key='gecos') |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
533 when (select gname from grp where gname=bs.owner) |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
534 is not null |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
535 then (select val from grp_s where gname=bs.owner |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
536 and key='gecos') |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
537 else |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
538 null |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
539 end, |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
540 bs.owner |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
541 ) OWNER, |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
542 a_s.val CTIME, |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
543 ',t,'||bs.title||':'||b.rowid||'#'||a.id TITLE |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
544 from (select rowid,id,val from article_m where id |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
545 in (select id from article where author='$user') |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
546 and type like 'file:%') |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
547 m left join article a on m.id=a.id |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
548 left join article_s a_s on a.id=a_s.id and a_s.key='ctime' |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
549 left join (select id, |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
550 max(case key when 'owner' then val end) as owner, |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
551 max(case key when 'title' then val end) as title |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
552 from blog_s group by id) |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
553 bs on a.blogid=bs.id |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
554 left join blog b on bs.id=b.id |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
555 where m.val is not null order by $by $ord;" |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
556 err lshandoutbyauthor: sql=`echo "$sql"` |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
557 title="個人提出ファイル" |
189 | 558 _m4 -D_TITLE_=$title $layout/html.m4.html |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
559 hra="<a href=\"?lsmyfile+" |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
560 hrb="<a href=\"?showattc+article_m+" |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
561 hrc="<a href=\"?replyblog+" |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
562 (echo '<table class="b">' |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
563 echo "$sql"|sq -html -header $db ) \ |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
564 | sed -e "s|\(<TR><TD>\)\([^/]*\)/\([0-9]*\)|\1$hrb\3\">\2</a>|" \ |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
565 -e "s|,t,\(.*\):\([^<]*\)\(</TD>\)|$hrc\2\">\1</a>\3|" \ |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
566 -e "s|\(<TH>\)\([A-Z]*\)\(</TH>\)|\1$hra\2$lkod\">\2</a>|" \ |
189 | 567 | _m4 -D_TITLE_=$title -D_FORM_="<p>($by$jord)</p>" \ |
568 -D_DUMPTABLE_="syscmd(cat)" $layout/form+dump.m4.html | |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
569 echo '</table>' |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
570 } |
78 | 571 searchart() { |
301
ba0730073d6f
Add (1)article-ID search, (2)DATE search
HIROSE Yuuji <yuuji@gentei.org>
parents:
293
diff
changeset
|
572 kwd=`getpar kwd|nkf -wZ1` # Convert Zenkaku-SPC to ASCII-SPC |
ba0730073d6f
Add (1)article-ID search, (2)DATE search
HIROSE Yuuji <yuuji@gentei.org>
parents:
293
diff
changeset
|
573 kwdgrp="" |
337
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
574 authcond="" |
78 | 575 if [ -z "$kwd" ]; then |
576 echo "検索語を指定してください" | html p; return | |
577 fi | |
301
ba0730073d6f
Add (1)article-ID search, (2)DATE search
HIROSE Yuuji <yuuji@gentei.org>
parents:
293
diff
changeset
|
578 if expr x"$kwd" : 'x#[1-9][0-9]*$' >/dev/null 1>&2; then |
ba0730073d6f
Add (1)article-ID search, (2)DATE search
HIROSE Yuuji <yuuji@gentei.org>
parents:
293
diff
changeset
|
579 # Like '#1234', assume as artID |
ba0730073d6f
Add (1)article-ID search, (2)DATE search
HIROSE Yuuji <yuuji@gentei.org>
parents:
293
diff
changeset
|
580 rowid=$((${kwd#\#} + 0)) # Force to be a number |
337
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
581 kc="ar.rowid = $rowid" |
301
ba0730073d6f
Add (1)article-ID search, (2)DATE search
HIROSE Yuuji <yuuji@gentei.org>
parents:
293
diff
changeset
|
582 else |
344
7ff49d1c2987
Support '<', '>' for date search keyword
HIROSE Yuuji <yuuji@gentei.org>
parents:
341
diff
changeset
|
583 for k in `echo "$kwd" | sed "s/'/''/g"`; do # With wrap quotes |
7ff49d1c2987
Support '<', '>' for date search keyword
HIROSE Yuuji <yuuji@gentei.org>
parents:
341
diff
changeset
|
584 if expr x"$k" : 'x@[><= ]*[1-9][][0-9]*-[][0-9:-]*$' >/dev/null >&2; then |
7ff49d1c2987
Support '<', '>' for date search keyword
HIROSE Yuuji <yuuji@gentei.org>
parents:
341
diff
changeset
|
585 # '@<2016-10-10' -> ctime < '2016-10-10' |
7ff49d1c2987
Support '<', '>' for date search keyword
HIROSE Yuuji <yuuji@gentei.org>
parents:
341
diff
changeset
|
586 # '@>=2016-10-10' -> ctime >= '2016-10-10' |
7ff49d1c2987
Support '<', '>' for date search keyword
HIROSE Yuuji <yuuji@gentei.org>
parents:
341
diff
changeset
|
587 # '@2016-10-10' -> ctime GLOB '@2016-10-10' |
7ff49d1c2987
Support '<', '>' for date search keyword
HIROSE Yuuji <yuuji@gentei.org>
parents:
341
diff
changeset
|
588 k=${k#@} |
7ff49d1c2987
Support '<', '>' for date search keyword
HIROSE Yuuji <yuuji@gentei.org>
parents:
341
diff
changeset
|
589 case "$k" in |
7ff49d1c2987
Support '<', '>' for date search keyword
HIROSE Yuuji <yuuji@gentei.org>
parents:
341
diff
changeset
|
590 [\<\>]*) op=${k%%[!<>=]*}; ctime=${k##*[><= ]} ;; |
7ff49d1c2987
Support '<', '>' for date search keyword
HIROSE Yuuji <yuuji@gentei.org>
parents:
341
diff
changeset
|
591 *) op='GLOB'; ctime="${k##*[><= ]}*" ;; |
7ff49d1c2987
Support '<', '>' for date search keyword
HIROSE Yuuji <yuuji@gentei.org>
parents:
341
diff
changeset
|
592 esac |
7ff49d1c2987
Support '<', '>' for date search keyword
HIROSE Yuuji <yuuji@gentei.org>
parents:
341
diff
changeset
|
593 kc=$kc${kc:+" AND "}"ctime $op '${ctime}'" |
301
ba0730073d6f
Add (1)article-ID search, (2)DATE search
HIROSE Yuuji <yuuji@gentei.org>
parents:
293
diff
changeset
|
594 # Not sure GROUP BY a.blogid is comfortable for searchers...? |
331
1a60dfc56bb0
Search form in other user's home restrict author to that one.
HIROSE Yuuji <yuuji@gentei.org>
parents:
326
diff
changeset
|
595 ##### kwdgrp=" GROUP BY a.blogid" ## Add this to lessen results |
304
ab11a49bd64e
Sort search result by "DATE DESC, TITLE, x.ctime"
HIROSE Yuuji <yuuji@gentei.org>
parents:
303
diff
changeset
|
596 elif [ x"$k" = x"@today" -o x"$k" = x"@今日" ]; then |
ab11a49bd64e
Sort search result by "DATE DESC, TITLE, x.ctime"
HIROSE Yuuji <yuuji@gentei.org>
parents:
303
diff
changeset
|
597 ctime=`date +%F` |
337
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
598 kc=$kc${kc:+" AND "}"ctime GLOB '${ctime}*'" |
344
7ff49d1c2987
Support '<', '>' for date search keyword
HIROSE Yuuji <yuuji@gentei.org>
parents:
341
diff
changeset
|
599 elif [ x"$k" = x"@week" ]; then |
7ff49d1c2987
Support '<', '>' for date search keyword
HIROSE Yuuji <yuuji@gentei.org>
parents:
341
diff
changeset
|
600 ctime=`query "SELECT datetime('now', 'localtime', '-7 days');"` |
7ff49d1c2987
Support '<', '>' for date search keyword
HIROSE Yuuji <yuuji@gentei.org>
parents:
341
diff
changeset
|
601 kc=$kc${kc:+" AND "}"ctime > '${ctime}'" |
352
dd0c70353869
More HELP text for search form. Add search result report.
HIROSE Yuuji <yuuji@gentei.org>
parents:
344
diff
changeset
|
602 elif [ x"$k" = x"@month" ]; then |
dd0c70353869
More HELP text for search form. Add search result report.
HIROSE Yuuji <yuuji@gentei.org>
parents:
344
diff
changeset
|
603 ctime=`query "SELECT datetime('now', 'localtime', '-1 month');"` |
dd0c70353869
More HELP text for search form. Add search result report.
HIROSE Yuuji <yuuji@gentei.org>
parents:
344
diff
changeset
|
604 kc=$kc${kc:+" AND "}"ctime > '${ctime}'" |
dd0c70353869
More HELP text for search form. Add search result report.
HIROSE Yuuji <yuuji@gentei.org>
parents:
344
diff
changeset
|
605 elif [ x"$k" = x"@year" ]; then |
dd0c70353869
More HELP text for search form. Add search result report.
HIROSE Yuuji <yuuji@gentei.org>
parents:
344
diff
changeset
|
606 ctime=`query "SELECT datetime('now', 'localtime', '-1 year');"` |
dd0c70353869
More HELP text for search form. Add search result report.
HIROSE Yuuji <yuuji@gentei.org>
parents:
344
diff
changeset
|
607 kc=$kc${kc:+" AND "}"ctime > '${ctime}'" |
301
ba0730073d6f
Add (1)article-ID search, (2)DATE search
HIROSE Yuuji <yuuji@gentei.org>
parents:
293
diff
changeset
|
608 else |
333
002cc900200a
Nonexistent Icon cleaning is too heavy, put it after loop
HIROSE Yuuji <yuuji@gentei.org>
parents:
331
diff
changeset
|
609 kc=$kc${kc:+" AND "}"content LIKE '%$k%'" |
301
ba0730073d6f
Add (1)article-ID search, (2)DATE search
HIROSE Yuuji <yuuji@gentei.org>
parents:
293
diff
changeset
|
610 fi |
ba0730073d6f
Add (1)article-ID search, (2)DATE search
HIROSE Yuuji <yuuji@gentei.org>
parents:
293
diff
changeset
|
611 done |
ba0730073d6f
Add (1)article-ID search, (2)DATE search
HIROSE Yuuji <yuuji@gentei.org>
parents:
293
diff
changeset
|
612 fi |
165
4040bb8b2038
quote search kwd. $SMAIL_TO controls To: header value.
HIROSE Yuuji <yuuji@gentei.org>
parents:
162
diff
changeset
|
613 kwd=`echo "$kwd"|htmlescape` |
78 | 614 owner=`getpar owner` |
615 owner=${owner:-$1} | |
616 echo "「$kwd」による検索結果" | html p | |
617 if [ -n "$owner" ]; then | |
618 cond="where key='owner' and val='$owner'" | |
619 if isuser $owner; then | |
620 echo "(`linkhome $owner` さんの記録からの検索)" | html p | |
621 else | |
622 linkhome $owner 1>&3 | |
623 echo "(`linkhome $owner` グループからの検索)" | html p | |
624 fi | |
331
1a60dfc56bb0
Search form in other user's home restrict author to that one.
HIROSE Yuuji <yuuji@gentei.org>
parents:
326
diff
changeset
|
625 elif { author=`getpar author`; test -n "$author"; }; then |
1a60dfc56bb0
Search form in other user's home restrict author to that one.
HIROSE Yuuji <yuuji@gentei.org>
parents:
326
diff
changeset
|
626 atptn=`sqlquotestr $author` |
337
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
627 #kc="$kc${kc:+ AND }author=$atptn" |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
628 authcond="WHERE author=$atptn" |
331
1a60dfc56bb0
Search form in other user's home restrict author to that one.
HIROSE Yuuji <yuuji@gentei.org>
parents:
326
diff
changeset
|
629 if isuser $author; then |
1a60dfc56bb0
Search form in other user's home restrict author to that one.
HIROSE Yuuji <yuuji@gentei.org>
parents:
326
diff
changeset
|
630 echo "(`linkhome $author` さんの書き込みからの検索)" | html p |
1a60dfc56bb0
Search form in other user's home restrict author to that one.
HIROSE Yuuji <yuuji@gentei.org>
parents:
326
diff
changeset
|
631 fi |
78 | 632 fi |
633 # article_s: id=article-id, key='text', val='TEXT' | |
634 # article: id=article-id, blogid=blogkd | |
635 # blog: id=blog-id, author=LeaderAuthor | |
636 # blog_s: id=blog-id, key='title', val='BLOG-TITLE' | |
637 # WANT: blog-ROWid,article-id,val(TEXT) | |
337
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
638 sql2="`sql4readableblogs` -- Extract user-readable blogs |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
639 -- 0.3sec |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
640 WITH artsm AS ( |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
641 SELECT a.id,ctime, text || ' ' || coalesce(files, '') content |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
642 FROM article a |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
643 LEFT JOIN |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
644 (SELECT ars.id, ctime, text, coalesce(files, '') files |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
645 FROM (SELECT id, |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
646 max(CASE key WHEN 'ctime' THEN val END) ctime, |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
647 max(CASE key WHEN 'text' THEN val END) text |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
648 FROM article_s |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
649 GROUP BY id) ars |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
650 LEFT JOIN |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
651 (SELECT id, group_concat(val) files |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
652 FROM article_m |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
653 WHERE type LIKE 'file:%' |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
654 GROUP BY id) arm |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
655 ON ars.id=arm.id |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
656 ) ar |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
657 ON a.id=ar.id |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
658 ), ar AS ( |
338
291a3eeed05e
Show author in search result
HIROSE Yuuji <yuuji@gentei.org>
parents:
337
diff
changeset
|
659 SELECT a.rowid, a.blogid, a.id, a.author, ctime, content |
291a3eeed05e
Show author in search result
HIROSE Yuuji <yuuji@gentei.org>
parents:
337
diff
changeset
|
660 FROM article a JOIN artsm ON a.id=artsm.id |
337
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
661 $authcond |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
662 ), bl AS ( |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
663 SELECT blg.rid, blg.*, blog_s.val TITLE |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
664 FROM readableblogs blg JOIN blog_s ON blg.id=blog_s.id AND blog_s.key='title' |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
665 ) |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
666 SELECT bl.rid||'#'||ar.id '', |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
667 bl.title TITLE, |
338
291a3eeed05e
Show author in search result
HIROSE Yuuji <yuuji@gentei.org>
parents:
337
diff
changeset
|
668 (SELECT gecos FROM gecoses WHERE name=ar.author) AUTHOR, |
337
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
669 substr(ctime, 0, 11) DATE, |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
670 substr(content, 0, 78) TEXT |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
671 FROM ar JOIN bl |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
672 ON ar.blogid=bl.id |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
673 WHERE $kc AND bl.id IN (SELECT id FROM blog_s $cond) |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
674 ORDER by DATE DESC, TITLE, ctime;" |
78 | 675 sedopt="s,<TR><TD>\([^<]*\)</TD>,<TR><TD><a\ |
676 href=\"?replyblog+\1\">VIEW</a></TD>," | |
337
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
677 # echo "$sql2" > tmp/sql.out |
352
dd0c70353869
More HELP text for search form. Add search result report.
HIROSE Yuuji <yuuji@gentei.org>
parents:
344
diff
changeset
|
678 result=$tmpd/result.$$ |
78 | 679 cat<<EOF |
680 <table class="b searchart"> | |
352
dd0c70353869
More HELP text for search form. Add search result report.
HIROSE Yuuji <yuuji@gentei.org>
parents:
344
diff
changeset
|
681 `sq -header -html $db "$sql2"|sed "$sedopt"|tee $result` |
78 | 682 </table> |
683 EOF | |
352
dd0c70353869
More HELP text for search form. Add search result report.
HIROSE Yuuji <yuuji@gentei.org>
parents:
344
diff
changeset
|
684 if [ -s "$result" ]; then |
356
c087423c8234
Most of debugging code deactivated
HIROSE Yuuji <yuuji@gentei.org>
parents:
352
diff
changeset
|
685 found=$((`grep "^<TR><TD>" $result | wc -l` + 0)) # Cast to INT |
352
dd0c70353869
More HELP text for search form. Add search result report.
HIROSE Yuuji <yuuji@gentei.org>
parents:
344
diff
changeset
|
686 one=${found%1} |
dd0c70353869
More HELP text for search form. Add search result report.
HIROSE Yuuji <yuuji@gentei.org>
parents:
344
diff
changeset
|
687 echo "$found match${one:+es} found" |
dd0c70353869
More HELP text for search form. Add search result report.
HIROSE Yuuji <yuuji@gentei.org>
parents:
344
diff
changeset
|
688 else |
dd0c70353869
More HELP text for search form. Add search result report.
HIROSE Yuuji <yuuji@gentei.org>
parents:
344
diff
changeset
|
689 echo orz... |
dd0c70353869
More HELP text for search form. Add search result report.
HIROSE Yuuji <yuuji@gentei.org>
parents:
344
diff
changeset
|
690 fi |
78 | 691 } |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
692 listblog() ( |
67 | 693 # $1={user,group} |
694 qow=`sqlquote $1` | |
695 cond="where a.id in (select id from blog_s where key='owner' and val=$qow) order by ctime desc" | |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
696 DT_CHLD=article:blogid |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
697 cgi_form searchart<<EOF |
128 | 698 <label>`cgi_text kwd`という語を含む記事をこの一覧から検索</label> |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
699 `cgi_hidden owner $user` |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
700 EOF |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
701 dumptable html blog 'ctime title heading' "$cond" |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
702 ) |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
703 |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
704 blog_addentry() { |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
705 # $1=GRPname(if it is a group) |
16
636df1c1bdf2
Track group by rowid in URLs
HIROSE Yuuji <yuuji@gentei.org>
parents:
13
diff
changeset
|
706 grprowid=$1 |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
707 rowid=`getpar rowid` |
356
c087423c8234
Most of debugging code deactivated
HIROSE Yuuji <yuuji@gentei.org>
parents:
352
diff
changeset
|
708 ## err blog_addentry0: rowid=$rowid |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
709 if [ -n "$grprowid" ]; then |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
710 owner=`getgroupbyid $grprowid` |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
711 else |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
712 owner=`getpar owner` |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
713 fi |
122
0681534f9451
When deleting group, remove all blos that belong it.
HIROSE Yuuji <yuuji@gentei.org>
parents:
117
diff
changeset
|
714 err blog-add: \$1=$1 rowid=$rowid owner=$owner |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
715 if isgroup $owner; then |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
716 groupmode=1 listing=$owner guide="[${owner}]" GF_OWNER=$owner |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
717 else |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
718 usermode=1 listing=$user guide="[個人]" |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
719 fi |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
720 |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
721 if [ -n "`getpar title`" ]; then |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
722 if [ "$usermode" ]; then |
122
0681534f9451
When deleting group, remove all blos that belong it.
HIROSE Yuuji <yuuji@gentei.org>
parents:
117
diff
changeset
|
723 err usermode: user=$user owner=$owner |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
724 if [ x"$user" != x"$owner" ]; then |
67 | 725 echo "他人の日記は書けません" | html p |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
726 return 2 |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
727 fi |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
728 elif [ "$groupmode" ]; then # if write to group log |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
729 grp=$owner #\`getpar grp\` |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
730 err ismember: $user $grp |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
731 if ! ismember "$user" "$grp"; then |
67 | 732 echo "(話題作成はこのグループに加入してから)" | html p |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
733 return 3 |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
734 fi |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
735 fi |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
736 par2table $formdir/blog.def |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
737 serial=`getpar serial` |
356
c087423c8234
Most of debugging code deactivated
HIROSE Yuuji <yuuji@gentei.org>
parents:
352
diff
changeset
|
738 ## err SERIAL: $serial ROWID=$rowid listing=$listing |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
739 id="" |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
740 if [ -n "$rowid" ]; then |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
741 # Here, id becomes NULL when removal of entries at par2table |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
742 id=`query "select rowid from blog where rowid=$rowid;"` |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
743 elif [ -n "$serial" ]; then |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
744 # If new blog leader created, traverse to its head. |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
745 id=`query "select rowid from blog where id='$serial';"` |
356
c087423c8234
Most of debugging code deactivated
HIROSE Yuuji <yuuji@gentei.org>
parents:
352
diff
changeset
|
746 ## err new-Leader: "select rowid from blog where id='$serial';" id=$id |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
747 fi |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
748 if [ -n "$id" ]; then |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
749 ## If new aritcle is entered, JUMP to blog_reply |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
750 blog_reply $id |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
751 return |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
752 fi |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
753 fi |
81
ddc8a4c0b8d9
All macro-expanding by m4 bypassed via syscmd or spaste
HIROSE Yuuji <yuuji@gentei.org>
parents:
80
diff
changeset
|
754 echo "${guide}新規話題作成" > $tmpd/title.$$ |
ddc8a4c0b8d9
All macro-expanding by m4 bypassed via syscmd or spaste
HIROSE Yuuji <yuuji@gentei.org>
parents:
80
diff
changeset
|
755 listblog $listing > $tmpd/listblog.$$ |
ddc8a4c0b8d9
All macro-expanding by m4 bypassed via syscmd or spaste
HIROSE Yuuji <yuuji@gentei.org>
parents:
80
diff
changeset
|
756 genform $formdir/blog.def \ |
189 | 757 | _m4 -D_TITLE_="spaste(\`$tmpd/title.$$')" \ |
758 -D_FORMHEAD_="序文は簡単に詳しくはコメントに" \ | |
759 -D_DUMPHEAD_="これまでの蓄積" \ | |
760 -D_FORM_="syscmd(\`cat')" \ | |
761 -D_DUMPTABLE_="spaste(\`$tmpd/listblog.$$')" \ | |
762 $layout/html.m4.html \ | |
763 $layout/form+dump-whead.m4.html | |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
764 } |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
765 |
379 | 766 blog_reply() { # Posting to blog article |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
767 rowid=$1 |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
768 |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
769 if [ -z "$rowid" ]; then |
67 | 770 echo "表示する日記番号が未指定です。" | html p |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
771 return |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
772 fi |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
773 title=`getvalbyid blog title $rowid` |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
774 owner=`getvalbyid blog owner $rowid` |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
775 if isuser "$owner"; then |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
776 subtitle="`gecos $owner` さんの話題" |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
777 else |
16
636df1c1bdf2
Track group by rowid in URLs
HIROSE Yuuji <yuuji@gentei.org>
parents:
13
diff
changeset
|
778 grprowid=`query "select rowid from grp where gname=\"$owner\";"` |
341 | 779 subtitle="グループ |
780 <a href=\"?grp+$grprowid\" accesskey=\"h\" title=\"H\">$owner</a> での話題 | |
222
d320c73bf16f
Add "team" attributes in groups.
HIROSE Yuuji <yuuji@gentei.org>
parents:
219
diff
changeset
|
781 `query \"SELECT printf('(チーム:%s)', val)\ |
d320c73bf16f
Add "team" attributes in groups.
HIROSE Yuuji <yuuji@gentei.org>
parents:
219
diff
changeset
|
782 FROM blog_s |
d320c73bf16f
Add "team" attributes in groups.
HIROSE Yuuji <yuuji@gentei.org>
parents:
219
diff
changeset
|
783 WHERE id=(SELECT id FROM blog WHERE rowid=$rowid) |
d320c73bf16f
Add "team" attributes in groups.
HIROSE Yuuji <yuuji@gentei.org>
parents:
219
diff
changeset
|
784 AND key='team'; |
d320c73bf16f
Add "team" attributes in groups.
HIROSE Yuuji <yuuji@gentei.org>
parents:
219
diff
changeset
|
785 \"|htmlescape`" |
288
d50996dc2664
Function `grpaction' should be provided with moderated/ismember class
HIROSE Yuuji <yuuji@gentei.org>
parents:
287
diff
changeset
|
786 memclass=`grp_getbodyclass "$owner"` |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
787 fi |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
788 if [ -z "$title" ]; then |
67 | 789 echo "日記番号指定が無効です。" | html p |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
790 return |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
791 fi |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
792 |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
793 text=`getpar text` |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
794 if [ -n "$text" ]; then |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
795 if blog_writable $rowid $user; then |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
796 par2table $formdir/article.def |
356
c087423c8234
Most of debugging code deactivated
HIROSE Yuuji <yuuji@gentei.org>
parents:
352
diff
changeset
|
797 st=$? |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
798 case $st in |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
799 0|4) |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
800 [ "$st" = "4" ] && act="書込削除" |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
801 blog_notify_reply $rowid $user "$text" $act ;; |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
802 esac |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
803 else |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
804 title="$title(加入してないので書き込み不可)" |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
805 fi |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
806 fi |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
807 def=$formdir/article.def |
81
ddc8a4c0b8d9
All macro-expanding by m4 bypassed via syscmd or spaste
HIROSE Yuuji <yuuji@gentei.org>
parents:
80
diff
changeset
|
808 echo "$title" > $tmpd/title.$$ |
ddc8a4c0b8d9
All macro-expanding by m4 bypassed via syscmd or spaste
HIROSE Yuuji <yuuji@gentei.org>
parents:
80
diff
changeset
|
809 echo "$subtitle" > $tmpd/subtitle.$$ |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
810 ${BLOG_SHOW:-blog_showentry} blog $rowid \ |
259
85a001a9c7c5
Make it visible: the group is moderated; the user is a member of the group
HIROSE Yuuji <yuuji@gentei.org>
parents:
250
diff
changeset
|
811 | _m4 -D_TITLE_="spaste(\`$tmpd/title.$$')" \ |
85a001a9c7c5
Make it visible: the group is moderated; the user is a member of the group
HIROSE Yuuji <yuuji@gentei.org>
parents:
250
diff
changeset
|
812 -D_BODYCLASS_=general"${memclass:+ $memclass}" \ |
189 | 813 -D_FORMHEAD_="spaste(\`$tmpd/subtitle.$$')" \ |
814 -D_FORM_='' \ | |
815 -D_DUMPTABLE_="syscmd(cat)" -D_DUMPHEAD_="" \ | |
816 $layout/html.m4.html $layout/form+dump-whead.m4.html | |
0
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
817 } |