Mercurial > hgrepos > hgweb.cgi > s4
annotate s4-blog.sh @ 337:48d0b6c4de65
Revise SQL for article search drastically for speed.
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Sat, 22 Oct 2016 22:58:10 +0859 |
parents | 08165f6b7828 |
children | 291a3eeed05e |
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_]*} |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
73 err rowid=$rowid, '$2'=$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
|
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 |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
115 href="<a href=\"?editheading+$rowid\"> 編集 </a>" |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
116 if $iswritable; then |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
117 href2="<a href=\"?lshandout+$rowid\"> 提出状況 </a>" |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
118 href3="(<a href=\"?gethandout+$rowid\">ファイル取得</a>)" |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
119 fi |
156
d46bce9072cd
Add link to '#bottom', recover function of auto href at the
HIROSE Yuuji <yuuji@gentei.org>
parents:
155
diff
changeset
|
120 href4='<a href="#bottom"> 末尾へ</a>' |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
121 |
293
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
122 query<<-EOF | |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
123 SELECT coalesce((SELECT "yes" FROM blog |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
124 WHERE rowid=$rowid AND author='$user'), |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
125 ''), |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
126 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
|
127 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
|
128 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
|
129 WHEN 'report-closed' THEN 'レポート提出用(closed)' |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
130 WHEN 'report-open' THEN 'レポート提出用(open)' |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
131 ELSE '' |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
132 END |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
133 FROM $ts WHERE id='$id' GROUP BY id; |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
134 EOF |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
135 { IFS='|' read edit ctime hexhead blogtype |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
136 cat<<-EOF |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
137 <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
|
138 <tr class="preface"> |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
139 <td>`echo "$hexhead"|unhexize|hreflink|minitbl`</td></tr> |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
140 </table> |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
141 |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
142 <table class="blog_replies"> |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
143 EOF |
6c281c9899e5
Allow WikiStyle notation in blog heading
HIROSE Yuuji <yuuji@gentei.org>
parents:
291
diff
changeset
|
144 } |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
145 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
|
146 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
|
147 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
|
148 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
|
149 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
|
150 # 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
|
151 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
|
152 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
|
153 iconcleaner=$tmpd/iconcleaner.$$ |
263
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
154 sq $db<<EOF | |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
155 WITH a_s AS ( |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
156 SELECT id, |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
157 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
|
158 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
|
159 FROM article_s |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
160 GROUP by id |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
161 ) |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
162 SELECT a.id, |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
163 CASE author |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
164 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
|
165 ELSE '' |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
166 END edit, |
170
45d6954af516
TEST: notifyto button added for evaluation
HIROSE Yuuji <yuuji@gentei.org>
parents:
168
diff
changeset
|
167 CASE -- 「通知送信」ボタンの有無 |
45d6954af516
TEST: notifyto button added for evaluation
HIROSE Yuuji <yuuji@gentei.org>
parents:
168
diff
changeset
|
168 WHEN '$notifyto' = '' THEN '' -- 不要モードならなし |
45d6954af516
TEST: notifyto button added for evaluation
HIROSE Yuuji <yuuji@gentei.org>
parents:
168
diff
changeset
|
169 WHEN '$user' = author THEN '' -- 筆者自身ならなし |
45d6954af516
TEST: notifyto button added for evaluation
HIROSE Yuuji <yuuji@gentei.org>
parents:
168
diff
changeset
|
170 ELSE "yes" |
45d6954af516
TEST: notifyto button added for evaluation
HIROSE Yuuji <yuuji@gentei.org>
parents:
168
diff
changeset
|
171 END notify, |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
172 (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
|
173 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
|
174 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
|
175 author) uname, |
322
18be0c210dc8
First implementation of icon display in blog_replies.
HIROSE Yuuji <yuuji@gentei.org>
parents:
304
diff
changeset
|
176 (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
|
177 icon, |
183
b641b5393c40
TEST: Put rowid of article for convenience to reference
HIROSE Yuuji <yuuji@gentei.org>
parents:
170
diff
changeset
|
178 a.rowid, |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
179 s.TIME, |
286
1c4f13f0813e
Add newer article flag representing by time string decoration.
HIROSE Yuuji <yuuji@gentei.org>
parents:
283
diff
changeset
|
180 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
|
181 hex(s.TEXT), |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
182 (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
|
183 FROM article_m |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
184 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
|
185 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
|
186 (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
|
187 LEFT JOIN |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
188 a_s s |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
189 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
|
190 EOF |
322
18be0c210dc8
First implementation of icon display in blog_replies.
HIROSE Yuuji <yuuji@gentei.org>
parents:
304
diff
changeset
|
191 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
|
192 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
|
193 name=\"notifyto\" value=\"$uid\">返信通知送信</label>" |
322
18be0c210dc8
First implementation of icon display in blog_replies.
HIROSE Yuuji <yuuji@gentei.org>
parents:
304
diff
changeset
|
194 tdcls="repatt${new:+ new}" |
18be0c210dc8
First implementation of icon display in blog_replies.
HIROSE Yuuji <yuuji@gentei.org>
parents:
304
diff
changeset
|
195 imgdir=`getcachedir home/"$uid"`/main |
18be0c210dc8
First implementation of icon display in blog_replies.
HIROSE Yuuji <yuuji@gentei.org>
parents:
304
diff
changeset
|
196 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
|
197 icfn=`echo "$icon"|htmlescape` |
d19e85a72a29
Allow spaces and special characters in filenames(tentative).
HIROSE Yuuji <yuuji@gentei.org>
parents:
322
diff
changeset
|
198 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
|
199 else |
18be0c210dc8
First implementation of icon display in blog_replies.
HIROSE Yuuji <yuuji@gentei.org>
parents:
304
diff
changeset
|
200 picon="" |
333
002cc900200a
Nonexistent Icon cleaning is too heavy, put it after loop
HIROSE Yuuji <yuuji@gentei.org>
parents:
331
diff
changeset
|
201 if [ -n "$icon" ]; then |
002cc900200a
Nonexistent Icon cleaning is too heavy, put it after loop
HIROSE Yuuji <yuuji@gentei.org>
parents:
331
diff
changeset
|
202 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
|
203 val=`sqlquotestr \"$icon\"`;" >> $iconcleaner |
002cc900200a
Nonexistent Icon cleaning is too heavy, put it after loop
HIROSE Yuuji <yuuji@gentei.org>
parents:
331
diff
changeset
|
204 fi |
322
18be0c210dc8
First implementation of icon display in blog_replies.
HIROSE Yuuji <yuuji@gentei.org>
parents:
304
diff
changeset
|
205 fi |
18be0c210dc8
First implementation of icon display in blog_replies.
HIROSE Yuuji <yuuji@gentei.org>
parents:
304
diff
changeset
|
206 |
291
1df64f0490ca
`|col|col|...' like table conversion enabled
HIROSE Yuuji <yuuji@gentei.org>
parents:
288
diff
changeset
|
207 cat<<EOF |
283 | 208 <tr id="$id"> |
322
18be0c210dc8
First implementation of icon display in blog_replies.
HIROSE Yuuji <yuuji@gentei.org>
parents:
304
diff
changeset
|
209 <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
|
210 <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
|
211 $tm |
291
1df64f0490ca
`|col|col|...' like table conversion enabled
HIROSE Yuuji <yuuji@gentei.org>
parents:
288
diff
changeset
|
212 ${notify:+$nt}</td> |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
213 EOF |
291
1df64f0490ca
`|col|col|...' like table conversion enabled
HIROSE Yuuji <yuuji@gentei.org>
parents:
288
diff
changeset
|
214 echo -n "<td id=\"$aid\" class=\"repl\">" |
1df64f0490ca
`|col|col|...' like table conversion enabled
HIROSE Yuuji <yuuji@gentei.org>
parents:
288
diff
changeset
|
215 echo "$hte"|unhexize|htmlescape|hreflink|minitbl |
264
9131c7e09112
Use cache file for article images.
HIROSE Yuuji <yuuji@gentei.org>
parents:
263
diff
changeset
|
216 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
|
217 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
|
218 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
|
219 fn=`echo "${i#*:}"|unhexize` |
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
220 fnb=$fn"(${sz})" |
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
221 # echo r=$mrid fn=$fn |
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
222 case "$fn" in |
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
223 *.[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
|
224 # 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
|
225 case "$fn" in |
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
226 *.[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
|
227 *.[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
|
228 *) fmt=jpeg ;; |
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
229 esac |
268
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
230 outfile=$td/$mrid-${fn%.*}.$fmt |
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
231 #err fn=$fn outfile=$outfile |
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
232 #err "usecache=$usecache `ls -l $outfile`" |
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
233 #err tm=$tm |
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
234 #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
|
235 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
|
236 { [ "$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
|
237 { [ -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
|
238 };}; then |
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
239 # err Set usecache=1 |
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
240 usecache=1 # Set usecache flag on |
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
241 cat<<-EOF |
264
9131c7e09112
Use cache file for article images.
HIROSE Yuuji <yuuji@gentei.org>
parents:
263
diff
changeset
|
242 <a href="$catlink+$mrid"><img src="$outfile"> |
9131c7e09112
Use cache file for article images.
HIROSE Yuuji <yuuji@gentei.org>
parents:
263
diff
changeset
|
243 $fnb</a> |
9131c7e09112
Use cache file for article images.
HIROSE Yuuji <yuuji@gentei.org>
parents:
263
diff
changeset
|
244 EOF |
268
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
245 else |
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
246 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
|
247 | unhexize \ |
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
248 | 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
|
249 - ${fmt}:- \ |
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
250 | tee "$outfile" \ |
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
251 | hexize \ |
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
252 | sed -e 's/\(..\)/%\1/g' \ |
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
253 -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
|
254 -e "s|\$|\">$fnb</a>|" |
291
1df64f0490ca
`|col|col|...' like table conversion enabled
HIROSE Yuuji <yuuji@gentei.org>
parents:
288
diff
changeset
|
255 # [ -d $td ] || mkdir -p "$td" |
268
138da0f3a2e5
Duplicate post by reloading or back+submit, dissolved
HIROSE Yuuji <yuuji@gentei.org>
parents:
264
diff
changeset
|
256 echo $tm > $tsfile |
264
9131c7e09112
Use cache file for article images.
HIROSE Yuuji <yuuji@gentei.org>
parents:
263
diff
changeset
|
257 fi |
263
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
258 ;; |
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
259 *) |
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
260 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
|
261 ;; |
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
262 esac |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
263 done |
263
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
264 echo "</td></tr>" |
ebd4af16c493
Old blog dumping code based on sq -html, removed entirely
HIROSE Yuuji <yuuji@gentei.org>
parents:
261
diff
changeset
|
265 done |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
266 |
193 | 267 textform='<div class="fold"> |
268 <input type="checkbox" id="cmt" checked><label for="cmt" | |
269 >コメントする</label><div> | |
270 <table class="b"> | |
271 <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
|
272 <tr><td>添付ファイル: |
206 | 273 <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
|
274 </table> |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
275 <input type="submit" value="送信"> |
193 | 276 <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
|
277 ' |
219
e2dea2f63a69
Duplicate posting by reload avoided
HIROSE Yuuji <yuuji@gentei.org>
parents:
208
diff
changeset
|
278 cat<<-EOF |
239
25e0b1eaf04d
Degrade fixed: Explicit notify works again.
HIROSE Yuuji <yuuji@gentei.org>
parents:
238
diff
changeset
|
279 </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
|
280 <p class="update_link"><a |
335
a120ba2d719b
Show link to the beginning of page at the bottom of page.
HIROSE Yuuji <yuuji@gentei.org>
parents:
333
diff
changeset
|
281 href="?reload/$rowid">再読込</a> / <a |
a120ba2d719b
Show link to the beginning of page at the bottom of page.
HIROSE Yuuji <yuuji@gentei.org>
parents:
333
diff
changeset
|
282 href="#title">先頭へ</a></p> |
219
e2dea2f63a69
Duplicate posting by reload avoided
HIROSE Yuuji <yuuji@gentei.org>
parents:
208
diff
changeset
|
283 EOF |
282
e6c1cbe4ffcc
Add article-rowid to id of tr(article list)
HIROSE Yuuji <yuuji@gentei.org>
parents:
269
diff
changeset
|
284 query<<-EOF |
e6c1cbe4ffcc
Add article-rowid to id of tr(article list)
HIROSE Yuuji <yuuji@gentei.org>
parents:
269
diff
changeset
|
285 WITH mrt AS ( |
e6c1cbe4ffcc
Add article-rowid to id of tr(article list)
HIROSE Yuuji <yuuji@gentei.org>
parents:
269
diff
changeset
|
286 SELECT max(val) maxtime FROM article_s |
e6c1cbe4ffcc
Add article-rowid to id of tr(article list)
HIROSE Yuuji <yuuji@gentei.org>
parents:
269
diff
changeset
|
287 WHERE key='ctime' AND id IN |
e6c1cbe4ffcc
Add article-rowid to id of tr(article list)
HIROSE Yuuji <yuuji@gentei.org>
parents:
269
diff
changeset
|
288 (SELECT id FROM article |
e6c1cbe4ffcc
Add article-rowid to id of tr(article list)
HIROSE Yuuji <yuuji@gentei.org>
parents:
269
diff
changeset
|
289 WHERE blogid=(select id from blog where rowid=$id)) |
e6c1cbe4ffcc
Add article-rowid to id of tr(article list)
HIROSE Yuuji <yuuji@gentei.org>
parents:
269
diff
changeset
|
290 ) |
e6c1cbe4ffcc
Add article-rowid to id of tr(article list)
HIROSE Yuuji <yuuji@gentei.org>
parents:
269
diff
changeset
|
291 SELECT 'A:'|| |
e6c1cbe4ffcc
Add article-rowid to id of tr(article list)
HIROSE Yuuji <yuuji@gentei.org>
parents:
269
diff
changeset
|
292 (SELECT count(*) FROM tblaccesses |
e6c1cbe4ffcc
Add article-rowid to id of tr(article list)
HIROSE Yuuji <yuuji@gentei.org>
parents:
269
diff
changeset
|
293 WHERE tbl='blog' AND tblrowid=$id) access, |
e6c1cbe4ffcc
Add article-rowid to id of tr(article list)
HIROSE Yuuji <yuuji@gentei.org>
parents:
269
diff
changeset
|
294 'C:'|| |
e6c1cbe4ffcc
Add article-rowid to id of tr(article list)
HIROSE Yuuji <yuuji@gentei.org>
parents:
269
diff
changeset
|
295 (SELECT count(distinct user) FROM acclog |
e6c1cbe4ffcc
Add article-rowid to id of tr(article list)
HIROSE Yuuji <yuuji@gentei.org>
parents:
269
diff
changeset
|
296 WHERE tbl='blog' AND tblrowid=$id |
e6c1cbe4ffcc
Add article-rowid to id of tr(article list)
HIROSE Yuuji <yuuji@gentei.org>
parents:
269
diff
changeset
|
297 AND time > (SELECT maxtime from mrt) |
e6c1cbe4ffcc
Add article-rowid to id of tr(article list)
HIROSE Yuuji <yuuji@gentei.org>
parents:
269
diff
changeset
|
298 AND user IN |
e6c1cbe4ffcc
Add article-rowid to id of tr(article list)
HIROSE Yuuji <yuuji@gentei.org>
parents:
269
diff
changeset
|
299 (SELECT user FROM grp_mem |
e6c1cbe4ffcc
Add article-rowid to id of tr(article list)
HIROSE Yuuji <yuuji@gentei.org>
parents:
269
diff
changeset
|
300 WHERE gname = $(sqlquote "$blogowner"))) |
e6c1cbe4ffcc
Add article-rowid to id of tr(article list)
HIROSE Yuuji <yuuji@gentei.org>
parents:
269
diff
changeset
|
301 ; |
e6c1cbe4ffcc
Add article-rowid to id of tr(article list)
HIROSE Yuuji <yuuji@gentei.org>
parents:
269
diff
changeset
|
302 EOF |
219
e2dea2f63a69
Duplicate posting by reload avoided
HIROSE Yuuji <yuuji@gentei.org>
parents:
208
diff
changeset
|
303 $iswritable && cat<<-EOF |
e2dea2f63a69
Duplicate posting by reload avoided
HIROSE Yuuji <yuuji@gentei.org>
parents:
208
diff
changeset
|
304 <div class="blogcomment"> |
239
25e0b1eaf04d
Degrade fixed: Explicit notify works again.
HIROSE Yuuji <yuuji@gentei.org>
parents:
238
diff
changeset
|
305 <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
|
306 <input type="hidden" name="id" value="`genserial`"> |
239
25e0b1eaf04d
Degrade fixed: Explicit notify works again.
HIROSE Yuuji <yuuji@gentei.org>
parents:
238
diff
changeset
|
307 <input type="hidden" name="stage" value="replyblog"> |
25e0b1eaf04d
Degrade fixed: Explicit notify works again.
HIROSE Yuuji <yuuji@gentei.org>
parents:
238
diff
changeset
|
308 $textform |
25e0b1eaf04d
Degrade fixed: Explicit notify works again.
HIROSE Yuuji <yuuji@gentei.org>
parents:
238
diff
changeset
|
309 </div> |
25e0b1eaf04d
Degrade fixed: Explicit notify works again.
HIROSE Yuuji <yuuji@gentei.org>
parents:
238
diff
changeset
|
310 </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
|
311 <p id="bottom"> </p> |
25e0b1eaf04d
Degrade fixed: Explicit notify works again.
HIROSE Yuuji <yuuji@gentei.org>
parents:
238
diff
changeset
|
312 EOF |
333
002cc900200a
Nonexistent Icon cleaning is too heavy, put it after loop
HIROSE Yuuji <yuuji@gentei.org>
parents:
331
diff
changeset
|
313 # 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
|
314 [ -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
|
315 # Record access log |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
316 acclog blog $rowid |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
317 } |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
318 |
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
|
319 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
|
320 # $1=rowid of blog |
64
54bbd7ce3766
Inhibit non-group-member from *handout
HIROSE Yuuji <yuuji@gentei.org>
parents:
63
diff
changeset
|
321 if ! blog_writable $1 $user; then |
54bbd7ce3766
Inhibit non-group-member from *handout
HIROSE Yuuji <yuuji@gentei.org>
parents:
63
diff
changeset
|
322 echo "メンバー以外は利用できません。" | html p; return |
54bbd7ce3766
Inhibit non-group-member from *handout
HIROSE Yuuji <yuuji@gentei.org>
parents:
63
diff
changeset
|
323 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
|
324 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
|
325 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
|
326 title=`getvalbyid blog title $1` |
2 | 327 ge=`gecos $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
|
328 lshandoutsub $owner "$@" \ |
189 | 329 |_m4 -D_TITLE_="提出状況" \ |
330 -D_FORMHEAD_="$time [$title]@${ge:-$owner}" \ | |
331 -D_FORM_="syscmd(cat)" -D_DUMPHEAD_= -D_DUMPTABLE_= \ | |
332 $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
|
333 } |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
334 lshandoutsub() { |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
335 # $1=owner $2=rowid of blog |
2 | 336 if isgroup $1; then |
337 sample="(select user from grp_mem where gname='$1')" | |
338 else | |
339 sample="(select distinct author as user from arts)" | |
67 | 340 echo "(集計は板への投稿者のみ)" | html p |
2 | 341 fi |
342 sql="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
|
343 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
|
344 select (select rowid from user where name=c0.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
|
345 coalesce((select val from user_s where name=c0.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
|
346 and key='gecos'),\ |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
347 c0.user) as 'メンバー',\ |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
348 sum(case when c1.key is not null then 1 else 0 end)\ |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
349 as 'コメント記入',\ |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
350 sum(case when c2.key is not null then 1 else 0 end)\ |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
351 as 'ファイルの提出'\ |
2 | 352 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
|
353 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
|
354 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
|
355 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
|
356 on a.id=c1.id left join (select id,key from article_m ) c2\ |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
357 on c1.id=c2.id group by c0.user order by c0.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
|
358 err ishandoutsub: sql="$sql" |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
359 echo '<table class="b td2r td3r">' |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
360 hrb="<a href=\"?home+" |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
361 echo "$sql" | sq -header -html $db \ |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
362 | sed -e "s,\(<TR><TD>\)\([^ ]*\) \(.*\)</TD>,\1$hrb\2\">\3</TD>," -e 's,<TD>0</TD>,<TD class="warn">0</TD>,' |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
363 echo '</table>' |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
364 } |
2 | 365 gethandout() { |
366 # $1=rowid of blog | |
64
54bbd7ce3766
Inhibit non-group-member from *handout
HIROSE Yuuji <yuuji@gentei.org>
parents:
63
diff
changeset
|
367 if ! blog_writable $1 $user; then |
54bbd7ce3766
Inhibit non-group-member from *handout
HIROSE Yuuji <yuuji@gentei.org>
parents:
63
diff
changeset
|
368 echo "メンバー以外は利用できません。" | html p; return |
54bbd7ce3766
Inhibit non-group-member from *handout
HIROSE Yuuji <yuuji@gentei.org>
parents:
63
diff
changeset
|
369 fi |
2 | 370 i=0 |
371 bd=$tmpd/archive.$$ | |
372 mkdir $bd | |
373 query "select m.rowid,author,m.val from article a join article_m m\ | |
374 on a.id=m.id where blogid=(select id from blog where rowid=$1)\ | |
375 and m.key in ('image', 'document', 'binary');" \ | |
376 | while IFS='|' read rowid author filename; do | |
63 | 377 # err isfilereadable $user article_m $rowid |
378 isfilereadable $user article_m $rowid || continue | |
379 # err ok | |
2 | 380 i=$((i+1)) |
381 dir=`printf $bd/%03d $i` | |
382 mkdir $dir | |
383 query "select quote(bin) from article_m where rowid=$rowid;" \ | |
8 | 384 | unhexize > $dir/$filename |
2 | 385 done |
386 if [ ! -d $bd/001 ]; then | |
387 contenttype; echo | |
67 | 388 echo "取得できるファイルがありませんでした。" | html p |
2 | 389 return |
390 fi | |
391 (cd $bd | |
392 err cdto$bd; (pwd; ls -lFa) 1>&3 | |
393 tar zcf .archive.tar.gz * && mv .archive.tar.gz archive.tar.gz | |
394 ) | |
395 arc=$bd/archive.tar.gz | |
396 echo "Content-type: application/x-gzip" | |
397 echo "Content-Length: `cat $arc|wc -c`" | |
398 echo "Content-Disposition: filename=\"archive.tar.gz\"" | |
399 echo | |
400 cat $arc | |
401 } | |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
402 lsmyfile() { # $1(optional)=SortBy |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
403 case "$1" in |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
404 ""|CTIME-DESC) |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
405 by="CTIME" ord="DESC" ;; |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
406 CTIME*) by="CTIME" ;; |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
407 FILE*) by="FILE" ;; |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
408 OWNER*) by="OWNER" ;; |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
409 TITLE*) by="TITLE" ;; |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
410 esac |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
411 case "$1" in |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
412 *DESC) ord="DESC" ;; |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
413 esac |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
414 case "$ord" in |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
415 DESC) lkod="" jord="降順" ;; |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
416 *) lkod="-DESC" jord="昇順" ;; |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
417 esac |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
418 sql="select m.val||'/'||m.rowid FILE, |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
419 coalesce( |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
420 case when (select name from user where name=bs.owner) |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
421 is not null |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
422 then (select val from user_s where name=bs.owner |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
423 and key='gecos') |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
424 when (select gname from grp where gname=bs.owner) |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
425 is not null |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
426 then (select val from grp_s where gname=bs.owner |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
427 and key='gecos') |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
428 else |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
429 null |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
430 end, |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
431 bs.owner |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
432 ) OWNER, |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
433 a_s.val CTIME, |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
434 ',t,'||bs.title||':'||b.rowid||'#'||a.id TITLE |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
435 from (select rowid,id,val from article_m where id |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
436 in (select id from article where author='$user') |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
437 and type like 'file:%') |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
438 m left join article a on m.id=a.id |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
439 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
|
440 left join (select id, |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
441 max(case key when 'owner' then val end) as owner, |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
442 max(case key when 'title' then val end) as title |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
443 from blog_s group by id) |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
444 bs on a.blogid=bs.id |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
445 left join blog b on bs.id=b.id |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
446 where m.val is not null order by $by $ord;" |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
447 err lshandoutbyauthor: sql=`echo "$sql"` |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
448 title="個人提出ファイル" |
189 | 449 _m4 -D_TITLE_=$title $layout/html.m4.html |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
450 hra="<a href=\"?lsmyfile+" |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
451 hrb="<a href=\"?showattc+article_m+" |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
452 hrc="<a href=\"?replyblog+" |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
453 (echo '<table class="b">' |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
454 echo "$sql"|sq -html -header $db ) \ |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
455 | 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
|
456 -e "s|,t,\(.*\):\([^<]*\)\(</TD>\)|$hrc\2\">\1</a>\3|" \ |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
457 -e "s|\(<TH>\)\([A-Z]*\)\(</TH>\)|\1$hra\2$lkod\">\2</a>|" \ |
189 | 458 | _m4 -D_TITLE_=$title -D_FORM_="<p>($by$jord)</p>" \ |
459 -D_DUMPTABLE_="syscmd(cat)" $layout/form+dump.m4.html | |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
460 echo '</table>' |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
461 } |
78 | 462 searchart() { |
301
ba0730073d6f
Add (1)article-ID search, (2)DATE search
HIROSE Yuuji <yuuji@gentei.org>
parents:
293
diff
changeset
|
463 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
|
464 kwdgrp="" |
337
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
465 authcond="" |
78 | 466 if [ -z "$kwd" ]; then |
467 echo "検索語を指定してください" | html p; return | |
468 fi | |
301
ba0730073d6f
Add (1)article-ID search, (2)DATE search
HIROSE Yuuji <yuuji@gentei.org>
parents:
293
diff
changeset
|
469 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
|
470 # Like '#1234', assume as artID |
ba0730073d6f
Add (1)article-ID search, (2)DATE search
HIROSE Yuuji <yuuji@gentei.org>
parents:
293
diff
changeset
|
471 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
|
472 kc="ar.rowid = $rowid" |
301
ba0730073d6f
Add (1)article-ID search, (2)DATE search
HIROSE Yuuji <yuuji@gentei.org>
parents:
293
diff
changeset
|
473 else |
ba0730073d6f
Add (1)article-ID search, (2)DATE search
HIROSE Yuuji <yuuji@gentei.org>
parents:
293
diff
changeset
|
474 for k in `echo "$kwd" | sed "s/'/''/g"`; do |
ba0730073d6f
Add (1)article-ID search, (2)DATE search
HIROSE Yuuji <yuuji@gentei.org>
parents:
293
diff
changeset
|
475 if expr x"$k" : 'x@[1-9][][0-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
|
476 # Like '@2016-10-10', expands to "s.ctime GLOB '@2016-10-10'" |
ba0730073d6f
Add (1)article-ID search, (2)DATE search
HIROSE Yuuji <yuuji@gentei.org>
parents:
293
diff
changeset
|
477 ctime=${k#@} |
ba0730073d6f
Add (1)article-ID search, (2)DATE search
HIROSE Yuuji <yuuji@gentei.org>
parents:
293
diff
changeset
|
478 # Not sure GROUP BY a.blogid is comfortable for searchers...? |
337
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
479 kc=$kc${kc:+" AND "}"ctime GLOB '${ctime}*'" |
331
1a60dfc56bb0
Search form in other user's home restrict author to that one.
HIROSE Yuuji <yuuji@gentei.org>
parents:
326
diff
changeset
|
480 ##### 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
|
481 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
|
482 ctime=`date +%F` |
337
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
483 kc=$kc${kc:+" AND "}"ctime GLOB '${ctime}*'" |
301
ba0730073d6f
Add (1)article-ID search, (2)DATE search
HIROSE Yuuji <yuuji@gentei.org>
parents:
293
diff
changeset
|
484 else |
333
002cc900200a
Nonexistent Icon cleaning is too heavy, put it after loop
HIROSE Yuuji <yuuji@gentei.org>
parents:
331
diff
changeset
|
485 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
|
486 fi |
ba0730073d6f
Add (1)article-ID search, (2)DATE search
HIROSE Yuuji <yuuji@gentei.org>
parents:
293
diff
changeset
|
487 done |
ba0730073d6f
Add (1)article-ID search, (2)DATE search
HIROSE Yuuji <yuuji@gentei.org>
parents:
293
diff
changeset
|
488 fi |
165
4040bb8b2038
quote search kwd. $SMAIL_TO controls To: header value.
HIROSE Yuuji <yuuji@gentei.org>
parents:
162
diff
changeset
|
489 kwd=`echo "$kwd"|htmlescape` |
78 | 490 owner=`getpar owner` |
491 owner=${owner:-$1} | |
492 echo "「$kwd」による検索結果" | html p | |
493 if [ -n "$owner" ]; then | |
494 cond="where key='owner' and val='$owner'" | |
495 if isuser $owner; then | |
496 echo "(`linkhome $owner` さんの記録からの検索)" | html p | |
497 else | |
498 linkhome $owner 1>&3 | |
499 echo "(`linkhome $owner` グループからの検索)" | html p | |
500 fi | |
331
1a60dfc56bb0
Search form in other user's home restrict author to that one.
HIROSE Yuuji <yuuji@gentei.org>
parents:
326
diff
changeset
|
501 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
|
502 atptn=`sqlquotestr $author` |
337
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
503 #kc="$kc${kc:+ AND }author=$atptn" |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
504 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
|
505 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
|
506 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
|
507 fi |
78 | 508 fi |
509 # article_s: id=article-id, key='text', val='TEXT' | |
510 # article: id=article-id, blogid=blogkd | |
511 # blog: id=blog-id, author=LeaderAuthor | |
512 # blog_s: id=blog-id, key='title', val='BLOG-TITLE' | |
513 # 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
|
514 sql2="`sql4readableblogs` -- Extract user-readable blogs |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
515 -- 0.3sec |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
516 WITH artsm AS ( |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
517 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
|
518 FROM article a |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
519 LEFT JOIN |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
520 (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
|
521 FROM (SELECT id, |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
522 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
|
523 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
|
524 FROM article_s |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
525 GROUP BY id) ars |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
526 LEFT JOIN |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
527 (SELECT id, group_concat(val) files |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
528 FROM article_m |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
529 WHERE type LIKE 'file:%' |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
530 GROUP BY id) arm |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
531 ON ars.id=arm.id |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
532 ) ar |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
533 ON a.id=ar.id |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
534 ), ar AS ( |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
535 SELECT article.rowid, article.blogid, article.id, ctime, content |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
536 FROM article JOIN artsm ON article.id=artsm.id |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
537 $authcond |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
538 ), bl AS ( |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
539 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
|
540 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
|
541 ) |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
542 SELECT bl.rid||'#'||ar.id '', |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
543 bl.title TITLE, |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
544 substr(ctime, 0, 11) DATE, |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
545 substr(content, 0, 78) TEXT |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
546 FROM ar JOIN bl |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
547 ON ar.blogid=bl.id |
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
548 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
|
549 ORDER by DATE DESC, TITLE, ctime;" |
78 | 550 sedopt="s,<TR><TD>\([^<]*\)</TD>,<TR><TD><a\ |
551 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
|
552 # echo "$sql2" > tmp/sql.out |
78 | 553 cat<<EOF |
554 <table class="b searchart"> | |
337
48d0b6c4de65
Revise SQL for article search drastically for speed.
HIROSE Yuuji <yuuji@gentei.org>
parents:
336
diff
changeset
|
555 `sq -header -html $db "$sql2"|sed "$sedopt"` |
78 | 556 </table> |
557 EOF | |
558 } | |
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
|
559 listblog() ( |
67 | 560 # $1={user,group} |
561 qow=`sqlquote $1` | |
562 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
|
563 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
|
564 cgi_form searchart<<EOF |
128 | 565 <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
|
566 `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
|
567 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
|
568 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
|
569 ) |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
570 |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
571 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
|
572 # $1=GRPname(if it is a group) |
16
636df1c1bdf2
Track group by rowid in URLs
HIROSE Yuuji <yuuji@gentei.org>
parents:
13
diff
changeset
|
573 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
|
574 rowid=`getpar rowid` |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
575 err blog_addentry0: rowid=$rowid |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
576 if [ -n "$grprowid" ]; then |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
577 owner=`getgroupbyid $grprowid` |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
578 else |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
579 owner=`getpar owner` |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
580 fi |
122
0681534f9451
When deleting group, remove all blos that belong it.
HIROSE Yuuji <yuuji@gentei.org>
parents:
117
diff
changeset
|
581 err blog-add: \$1=$1 rowid=$rowid owner=$owner |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
582 if isgroup $owner; then |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
583 groupmode=1 listing=$owner guide="[${owner}]" GF_OWNER=$owner |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
584 else |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
585 usermode=1 listing=$user guide="[個人]" |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
586 fi |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
587 |
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
|
588 if [ -n "`getpar title`" ]; then |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
589 if [ "$usermode" ]; then |
122
0681534f9451
When deleting group, remove all blos that belong it.
HIROSE Yuuji <yuuji@gentei.org>
parents:
117
diff
changeset
|
590 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
|
591 if [ x"$user" != x"$owner" ]; then |
67 | 592 echo "他人の日記は書けません" | html p |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
593 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
|
594 fi |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
595 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
|
596 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
|
597 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
|
598 if ! ismember "$user" "$grp"; then |
67 | 599 echo "(話題作成はこのグループに加入してから)" | html p |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
600 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
|
601 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
|
602 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
|
603 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
|
604 serial=`getpar serial` |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
605 err SERIAL: $serial ROWID=$rowid listing=$listing |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
606 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
|
607 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
|
608 # 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
|
609 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
|
610 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
|
611 # 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
|
612 id=`query "select rowid from blog where id='$serial';"` |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
613 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
|
614 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
|
615 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
|
616 ## 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
|
617 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
|
618 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
|
619 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
|
620 fi |
81
ddc8a4c0b8d9
All macro-expanding by m4 bypassed via syscmd or spaste
HIROSE Yuuji <yuuji@gentei.org>
parents:
80
diff
changeset
|
621 echo "${guide}新規話題作成" > $tmpd/title.$$ |
ddc8a4c0b8d9
All macro-expanding by m4 bypassed via syscmd or spaste
HIROSE Yuuji <yuuji@gentei.org>
parents:
80
diff
changeset
|
622 listblog $listing > $tmpd/listblog.$$ |
ddc8a4c0b8d9
All macro-expanding by m4 bypassed via syscmd or spaste
HIROSE Yuuji <yuuji@gentei.org>
parents:
80
diff
changeset
|
623 genform $formdir/blog.def \ |
189 | 624 | _m4 -D_TITLE_="spaste(\`$tmpd/title.$$')" \ |
625 -D_FORMHEAD_="序文は簡単に詳しくはコメントに" \ | |
626 -D_DUMPHEAD_="これまでの蓄積" \ | |
627 -D_FORM_="syscmd(\`cat')" \ | |
628 -D_DUMPTABLE_="spaste(\`$tmpd/listblog.$$')" \ | |
629 $layout/html.m4.html \ | |
630 $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
|
631 } |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
632 |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
633 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
|
634 rowid=$1 |
222
d320c73bf16f
Add "team" attributes in groups.
HIROSE Yuuji <yuuji@gentei.org>
parents:
219
diff
changeset
|
635 err rowid=$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
|
636 |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
637 if [ -z "$rowid" ]; then |
67 | 638 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
|
639 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
|
640 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
|
641 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
|
642 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
|
643 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
|
644 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
|
645 else |
16
636df1c1bdf2
Track group by rowid in URLs
HIROSE Yuuji <yuuji@gentei.org>
parents:
13
diff
changeset
|
646 grprowid=`query "select rowid from grp where gname=\"$owner\";"` |
222
d320c73bf16f
Add "team" attributes in groups.
HIROSE Yuuji <yuuji@gentei.org>
parents:
219
diff
changeset
|
647 subtitle="グループ <a href=\"?grp+$grprowid\">$owner</a> での話題 |
d320c73bf16f
Add "team" attributes in groups.
HIROSE Yuuji <yuuji@gentei.org>
parents:
219
diff
changeset
|
648 `query \"SELECT printf('(チーム:%s)', val)\ |
d320c73bf16f
Add "team" attributes in groups.
HIROSE Yuuji <yuuji@gentei.org>
parents:
219
diff
changeset
|
649 FROM blog_s |
d320c73bf16f
Add "team" attributes in groups.
HIROSE Yuuji <yuuji@gentei.org>
parents:
219
diff
changeset
|
650 WHERE id=(SELECT id FROM blog WHERE rowid=$rowid) |
d320c73bf16f
Add "team" attributes in groups.
HIROSE Yuuji <yuuji@gentei.org>
parents:
219
diff
changeset
|
651 AND key='team'; |
d320c73bf16f
Add "team" attributes in groups.
HIROSE Yuuji <yuuji@gentei.org>
parents:
219
diff
changeset
|
652 \"|htmlescape`" |
288
d50996dc2664
Function `grpaction' should be provided with moderated/ismember class
HIROSE Yuuji <yuuji@gentei.org>
parents:
287
diff
changeset
|
653 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
|
654 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
|
655 if [ -z "$title" ]; then |
67 | 656 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
|
657 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
|
658 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
|
659 |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
660 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
|
661 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
|
662 if blog_writable $rowid $user; then |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
663 par2table $formdir/article.def |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
664 st=$? # ; err par2t-st=$st |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
665 case $st in |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
666 0|4) |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
667 [ "$st" = "4" ] && act="書込削除" |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
668 blog_notify_reply $rowid $user "$text" $act ;; |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
669 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
|
670 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
|
671 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
|
672 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
|
673 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
|
674 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
|
675 echo "$title" > $tmpd/title.$$ |
ddc8a4c0b8d9
All macro-expanding by m4 bypassed via syscmd or spaste
HIROSE Yuuji <yuuji@gentei.org>
parents:
80
diff
changeset
|
676 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
|
677 ${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
|
678 | _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
|
679 -D_BODYCLASS_=general"${memclass:+ $memclass}" \ |
189 | 680 -D_FORMHEAD_="spaste(\`$tmpd/subtitle.$$')" \ |
681 -D_FORM_='' \ | |
682 -D_DUMPTABLE_="syscmd(cat)" -D_DUMPHEAD_="" \ | |
683 $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
|
684 } |