Mercurial > hgrepos > hgweb.cgi > s4
annotate s4-blog.sh @ 261:1a4df907ac87
Thumbnail image format follows original size
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Wed, 20 Jul 2016 15:31:11 +0859 |
parents | 85a001a9c7c5 |
children | ebd4af16c493 |
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"` |
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
|
71 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
|
72 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
|
73 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
|
74 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
|
75 serial=$(($(date +%s)-1420038000))s$$ |
64
54bbd7ce3766
Inhibit non-group-member from *handout
HIROSE Yuuji <yuuji@gentei.org>
parents:
63
diff
changeset
|
76 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
|
77 # 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
|
78 # 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
|
79 # 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
|
80 # 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
|
81 |
138
130114486d8c
Blog of moderated group cannot be read by outsider.
HIROSE Yuuji <yuuji@gentei.org>
parents:
134
diff
changeset
|
82 # 2015-10-05 check readable |
130114486d8c
Blog of moderated group cannot be read by outsider.
HIROSE Yuuji <yuuji@gentei.org>
parents:
134
diff
changeset
|
83 if ! $iswritable; then |
130114486d8c
Blog of moderated group cannot be read by outsider.
HIROSE Yuuji <yuuji@gentei.org>
parents:
134
diff
changeset
|
84 blogowner=`getvalbyid blog owner "$2"` |
130114486d8c
Blog of moderated group cannot be read by outsider.
HIROSE Yuuji <yuuji@gentei.org>
parents:
134
diff
changeset
|
85 # err blogowner=$blogowner |
130114486d8c
Blog of moderated group cannot be read by outsider.
HIROSE Yuuji <yuuji@gentei.org>
parents:
134
diff
changeset
|
86 if isgroup $blogowner; then |
130114486d8c
Blog of moderated group cannot be read by outsider.
HIROSE Yuuji <yuuji@gentei.org>
parents:
134
diff
changeset
|
87 regmode=`getgroupattr $blogowner regmode` |
130114486d8c
Blog of moderated group cannot be read by outsider.
HIROSE Yuuji <yuuji@gentei.org>
parents:
134
diff
changeset
|
88 # err regmode=$regmode |
130114486d8c
Blog of moderated group cannot be read by outsider.
HIROSE Yuuji <yuuji@gentei.org>
parents:
134
diff
changeset
|
89 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
|
90 if ! ismember $user $blogowner; then |
130114486d8c
Blog of moderated group cannot be read by outsider.
HIROSE Yuuji <yuuji@gentei.org>
parents:
134
diff
changeset
|
91 echo "加入してからどうぞ" | html p |
130114486d8c
Blog of moderated group cannot be read by outsider.
HIROSE Yuuji <yuuji@gentei.org>
parents:
134
diff
changeset
|
92 return |
130114486d8c
Blog of moderated group cannot be read by outsider.
HIROSE Yuuji <yuuji@gentei.org>
parents:
134
diff
changeset
|
93 fi |
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 |
170
45d6954af516
TEST: notifyto button added for evaluation
HIROSE Yuuji <yuuji@gentei.org>
parents:
168
diff
changeset
|
97 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
|
98 admin) notifyto=1 ;; |
45d6954af516
TEST: notifyto button added for evaluation
HIROSE Yuuji <yuuji@gentei.org>
parents:
168
diff
changeset
|
99 *) notifyto="" ;; |
45d6954af516
TEST: notifyto button added for evaluation
HIROSE Yuuji <yuuji@gentei.org>
parents:
168
diff
changeset
|
100 esac |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
101 |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
102 err "SELECT id from $tbl where rowid=$rowid" |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
103 id=`query "select id from $tbl where rowid=$rowid;"` |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
104 err id=$id |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
105 err "select val from $ts where key='title' and id='$id';" |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
106 |
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 #(1)Display root article |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
109 cat<<EOF |
239
25e0b1eaf04d
Degrade fixed: Explicit notify works again.
HIROSE Yuuji <yuuji@gentei.org>
parents:
238
diff
changeset
|
110 <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
|
111 <table class="bloghead"> |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
112 EOF |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
113 |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
114 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
|
115 if $iswritable; then |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
116 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
|
117 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
|
118 fi |
156
d46bce9072cd
Add link to '#bottom', recover function of auto href at the
HIROSE Yuuji <yuuji@gentei.org>
parents:
155
diff
changeset
|
119 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
|
120 cat<<EOF | sq -html $db \ |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
121 | sed -e "s|\(<TR><TD>\),e,|\1 $href |" \ |
161
1b9c98fe0a31
,s, pattern can be safely replaced
HIROSE Yuuji <yuuji@gentei.org>
parents:
160
diff
changeset
|
122 -e "s|,s,|$href2$href3|" \ |
204 | 123 -e "s|,t,\(</TD>\)|$href4\1|" |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
124 -- select val from $ts where key="title" and id="$id"; |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
125 select |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
126 coalesce((select ",e," from blog where rowid=$rowid and author='$user'),'') |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
127 ||val||" " |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
128 ||case (select val from $ts where key="mode" and id="$id") |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
129 when 'report-closed' then "レポート提出用(自身のファイルのみ参照可),s," |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
130 when 'report-open' then "レポート提出用,s," |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
131 else "" |
158
cad3915d4c74
Add mark of #bottom link position
HIROSE Yuuji <yuuji@gentei.org>
parents:
157
diff
changeset
|
132 end || ',t,' |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
133 from $ts where key="ctime" and id="$id"; |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
134 select val from $ts where key="heading" and id="$id"; |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
135 EOF |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
136 cat<<EOF |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
137 </table> |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
138 <table class="blog_replies"> |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
139 EOF |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
140 |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
141 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
|
142 lkedit="<a href=\"$myname?editart" |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
143 if false; then |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
144 sq -html $db<<EOF | |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
145 WITH a_s AS ( |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
146 SELECT id, |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
147 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
|
148 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
|
149 FROM article_s |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
150 GROUP by id |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
151 ) |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
152 SELECT 'id:'||a.id, |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
153 CASE author |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
154 WHEN '$user' THEN 'ed:'||a.rowid||':'||$rowid |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
155 ELSE 'e0:' |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
156 END edit, |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
157 'at:'||(SELECT rowid FROM user WHERE name=author)||':' |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
158 ||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
|
159 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
|
160 author), |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
161 'ti:'||s.TIME, |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
162 'te:'||s.TEXT, |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
163 'im:'||(SELECT group_concat(hex(bin) |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
164 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
|
165 (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
|
166 LEFT JOIN |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
167 a_s s |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
168 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
|
169 EOF |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
170 sed -e "s|^<TR><TD>id:\(.*\)</TD>|<TR id=\"\1\"><TD>|" \ |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
171 -e "/^<TR/N" -e 's/\n//' \ |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
172 -e "s|<TD>ed:\([0-9]*\):\(.*\)</TD>|$lkedit+\1+\2${lke}編集</a>|" \ |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
173 -e "s|<TD>e0:</TD>||" \ |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
174 -e "s|^<TD>at:\([0-9]*\):\(.*\)</TD>|$lkhome+\1$lke\2</a>|" \ |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
175 -e "s|^<TD>ti:\(.*\)</TD>|\1</TD>|" \ |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
176 -e "s|^<TD>te:\(.*\)|<TD>\1|" |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
177 else |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
178 hlink="$myname?home" elink="$myname?editart" |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
179 catlink="$myname?showattc+article_m" |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
180 deficon="img/file-icon.png" |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
181 sq $db<<EOF | |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
182 WITH a_s AS ( |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
183 SELECT id, |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
184 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
|
185 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
|
186 FROM article_s |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
187 GROUP by id |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
188 ) |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
189 SELECT a.id, |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
190 CASE author |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
191 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
|
192 ELSE '' |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
193 END edit, |
170
45d6954af516
TEST: notifyto button added for evaluation
HIROSE Yuuji <yuuji@gentei.org>
parents:
168
diff
changeset
|
194 CASE -- 「通知送信」ボタンの有無 |
45d6954af516
TEST: notifyto button added for evaluation
HIROSE Yuuji <yuuji@gentei.org>
parents:
168
diff
changeset
|
195 WHEN '$notifyto' = '' THEN '' -- 不要モードならなし |
45d6954af516
TEST: notifyto button added for evaluation
HIROSE Yuuji <yuuji@gentei.org>
parents:
168
diff
changeset
|
196 WHEN '$user' = author THEN '' -- 筆者自身ならなし |
45d6954af516
TEST: notifyto button added for evaluation
HIROSE Yuuji <yuuji@gentei.org>
parents:
168
diff
changeset
|
197 ELSE "yes" |
45d6954af516
TEST: notifyto button added for evaluation
HIROSE Yuuji <yuuji@gentei.org>
parents:
168
diff
changeset
|
198 END notify, |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
199 (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
|
200 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
|
201 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
|
202 author) uname, |
183
b641b5393c40
TEST: Put rowid of article for convenience to reference
HIROSE Yuuji <yuuji@gentei.org>
parents:
170
diff
changeset
|
203 a.rowid, |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
204 s.TIME, |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
205 hex(s.TEXT), |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
206 (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
|
207 FROM article_m |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
208 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
|
209 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
|
210 (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
|
211 LEFT JOIN |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
212 a_s s |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
213 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
|
214 EOF |
183
b641b5393c40
TEST: Put rowid of article for convenience to reference
HIROSE Yuuji <yuuji@gentei.org>
parents:
170
diff
changeset
|
215 while IFS='|' read id edit notify uid uname aid tm hte imgids; do |
170
45d6954af516
TEST: notifyto button added for evaluation
HIROSE Yuuji <yuuji@gentei.org>
parents:
168
diff
changeset
|
216 nt="<label style=\"font-size: 70%;\"><input type=\"checkbox\" |
45d6954af516
TEST: notifyto button added for evaluation
HIROSE Yuuji <yuuji@gentei.org>
parents:
168
diff
changeset
|
217 name=\"notifyto\" value=\"$uid\">返信通知送信</label>" |
156
d46bce9072cd
Add link to '#bottom', recover function of auto href at the
HIROSE Yuuji <yuuji@gentei.org>
parents:
155
diff
changeset
|
218 cat<<EOF | |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
219 <tr id="$id"> |
184
6f4fd4fadcfe
Move #$aid to the first line of left column
HIROSE Yuuji <yuuji@gentei.org>
parents:
183
diff
changeset
|
220 <td>${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
|
221 <a href="$hlink+$uid">$uname</a> |
184
6f4fd4fadcfe
Move #$aid to the first line of left column
HIROSE Yuuji <yuuji@gentei.org>
parents:
183
diff
changeset
|
222 $tm |
170
45d6954af516
TEST: notifyto button added for evaluation
HIROSE Yuuji <yuuji@gentei.org>
parents:
168
diff
changeset
|
223 ${notify:+$nt}</td><td>`echo "$hte"|unhexize|htmlescape` |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
224 EOF |
208
36b6354de5cb
Profile form should escape entities. Apply ^href conversion to Profile
HIROSE Yuuji <yuuji@gentei.org>
parents:
206
diff
changeset
|
225 hreflink |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
226 for i in $imgids; do |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
227 mrid=${i%%:*}; i=${i#*:}; sz=`size_h ${i%%:*}` |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
228 fn=`echo "${i#*:}"|unhexize` |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
229 fnb=$fn"(${sz})" |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
230 # echo r=$mrid fn=$fn |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
231 case "$fn" in |
261
1a4df907ac87
Thumbnail image format follows original size
HIROSE Yuuji <yuuji@gentei.org>
parents:
259
diff
changeset
|
232 *.[Pp][Nn][Gg]|*.[Jj][Pp][Gg]|*.[Jj][Pp][Ee][Gg]|*.[Gg][Ii][Ff]) |
1a4df907ac87
Thumbnail image format follows original size
HIROSE Yuuji <yuuji@gentei.org>
parents:
259
diff
changeset
|
233 # fmt=${fn##*.} # jpg:- is slow...why |
1a4df907ac87
Thumbnail image format follows original size
HIROSE Yuuji <yuuji@gentei.org>
parents:
259
diff
changeset
|
234 case "$fn" in |
1a4df907ac87
Thumbnail image format follows original size
HIROSE Yuuji <yuuji@gentei.org>
parents:
259
diff
changeset
|
235 *.[Pp][Nn][Gg]) fmt=png ;; |
1a4df907ac87
Thumbnail image format follows original size
HIROSE Yuuji <yuuji@gentei.org>
parents:
259
diff
changeset
|
236 *.[Gg][Ii][Ff]) fmt=gif ;; |
1a4df907ac87
Thumbnail image format follows original size
HIROSE Yuuji <yuuji@gentei.org>
parents:
259
diff
changeset
|
237 *) fmt=jpeg ;; |
1a4df907ac87
Thumbnail image format follows original size
HIROSE Yuuji <yuuji@gentei.org>
parents:
259
diff
changeset
|
238 esac |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
239 sq $db "SELECT hex(bin) FROM article_m WHERE rowid=$mrid" \ |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
240 | unhexize \ |
261
1a4df907ac87
Thumbnail image format follows original size
HIROSE Yuuji <yuuji@gentei.org>
parents:
259
diff
changeset
|
241 | convert -define ${fmt}:size=100x100 -resize 100x100'>' - ${fmt}:- \ |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
242 | hexize \ |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
243 | sed -e 's/\(..\)/%\1/g' \ |
261
1a4df907ac87
Thumbnail image format follows original size
HIROSE Yuuji <yuuji@gentei.org>
parents:
259
diff
changeset
|
244 -e "s|^|<a href=\"$catlink+$mrid\"><img src=\"data:image/$fmt,|" \ |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
245 -e "s|\$|\">$fnb</a>|" |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
246 ;; |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
247 *) |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
248 echo "<a href=\"$catlink+$mrid\"><img src=\"$deficon\">$fnb</a>" |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
249 ;; |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
250 esac |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
251 done |
250
b60ed19405c2
Allow iframe(w=400,h=300 fixed) in article and fix open td/tr.
HIROSE Yuuji <yuuji@gentei.org>
parents:
245
diff
changeset
|
252 echo "</td></tr>" |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
253 done |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
254 fi |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
255 |
193 | 256 textform='<div class="fold"> |
257 <input type="checkbox" id="cmt" checked><label for="cmt" | |
258 >コメントする</label><div> | |
259 <table class="b"> | |
260 <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
|
261 <tr><td>添付ファイル: |
206 | 262 <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
|
263 </table> |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
264 <input type="submit" value="送信"> |
193 | 265 <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
|
266 ' |
219
e2dea2f63a69
Duplicate posting by reload avoided
HIROSE Yuuji <yuuji@gentei.org>
parents:
208
diff
changeset
|
267 cat<<-EOF |
239
25e0b1eaf04d
Degrade fixed: Explicit notify works again.
HIROSE Yuuji <yuuji@gentei.org>
parents:
238
diff
changeset
|
268 </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
|
269 <p class="update_link"><a |
e2dea2f63a69
Duplicate posting by reload avoided
HIROSE Yuuji <yuuji@gentei.org>
parents:
208
diff
changeset
|
270 href="?reload/$rowid">再読込</a></p> |
e2dea2f63a69
Duplicate posting by reload avoided
HIROSE Yuuji <yuuji@gentei.org>
parents:
208
diff
changeset
|
271 EOF |
e2dea2f63a69
Duplicate posting by reload avoided
HIROSE Yuuji <yuuji@gentei.org>
parents:
208
diff
changeset
|
272 $iswritable && cat<<-EOF |
e2dea2f63a69
Duplicate posting by reload avoided
HIROSE Yuuji <yuuji@gentei.org>
parents:
208
diff
changeset
|
273 <div class="blogcomment"> |
239
25e0b1eaf04d
Degrade fixed: Explicit notify works again.
HIROSE Yuuji <yuuji@gentei.org>
parents:
238
diff
changeset
|
274 <input type="hidden" name="blogid" value="$id"> |
25e0b1eaf04d
Degrade fixed: Explicit notify works again.
HIROSE Yuuji <yuuji@gentei.org>
parents:
238
diff
changeset
|
275 <input type="hidden" name="stage" value="replyblog"> |
25e0b1eaf04d
Degrade fixed: Explicit notify works again.
HIROSE Yuuji <yuuji@gentei.org>
parents:
238
diff
changeset
|
276 $textform |
25e0b1eaf04d
Degrade fixed: Explicit notify works again.
HIROSE Yuuji <yuuji@gentei.org>
parents:
238
diff
changeset
|
277 </div> |
25e0b1eaf04d
Degrade fixed: Explicit notify works again.
HIROSE Yuuji <yuuji@gentei.org>
parents:
238
diff
changeset
|
278 </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
|
279 <p id="bottom"> </p> |
25e0b1eaf04d
Degrade fixed: Explicit notify works again.
HIROSE Yuuji <yuuji@gentei.org>
parents:
238
diff
changeset
|
280 EOF |
25e0b1eaf04d
Degrade fixed: Explicit notify works again.
HIROSE Yuuji <yuuji@gentei.org>
parents:
238
diff
changeset
|
281 : <<-EOF |
25e0b1eaf04d
Degrade fixed: Explicit notify works again.
HIROSE Yuuji <yuuji@gentei.org>
parents:
238
diff
changeset
|
282 <div class="blogcomment"> |
219
e2dea2f63a69
Duplicate posting by reload avoided
HIROSE Yuuji <yuuji@gentei.org>
parents:
208
diff
changeset
|
283 <div class="fold"> |
e2dea2f63a69
Duplicate posting by reload avoided
HIROSE Yuuji <yuuji@gentei.org>
parents:
208
diff
changeset
|
284 <input type="checkbox" id="cmt" checked><label for="cmt" |
e2dea2f63a69
Duplicate posting by reload avoided
HIROSE Yuuji <yuuji@gentei.org>
parents:
208
diff
changeset
|
285 >コメントする</label> |
e2dea2f63a69
Duplicate posting by reload avoided
HIROSE Yuuji <yuuji@gentei.org>
parents:
208
diff
changeset
|
286 <div> |
e2dea2f63a69
Duplicate posting by reload avoided
HIROSE Yuuji <yuuji@gentei.org>
parents:
208
diff
changeset
|
287 `GF_ACTION="?replyblog+${rowid}#bottom" \ |
e2dea2f63a69
Duplicate posting by reload avoided
HIROSE Yuuji <yuuji@gentei.org>
parents:
208
diff
changeset
|
288 GF_ARGS="<input type=\"hidden\" name=\"blogid\" value=\"$id\">" \ |
e2dea2f63a69
Duplicate posting by reload avoided
HIROSE Yuuji <yuuji@gentei.org>
parents:
208
diff
changeset
|
289 genform $formdir/article.def` |
e2dea2f63a69
Duplicate posting by reload avoided
HIROSE Yuuji <yuuji@gentei.org>
parents:
208
diff
changeset
|
290 </div></div></div> |
e2dea2f63a69
Duplicate posting by reload avoided
HIROSE Yuuji <yuuji@gentei.org>
parents:
208
diff
changeset
|
291 <p id="bottom"></p> |
e2dea2f63a69
Duplicate posting by reload avoided
HIROSE Yuuji <yuuji@gentei.org>
parents:
208
diff
changeset
|
292 EOF |
154
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
293 # Record access log |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
294 acclog blog $rowid |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
295 } |
75598f2d3118
TEST: blog_showentry2 - constructing loop by output from single SQL
HIROSE Yuuji <yuuji@gentei.org>
parents:
138
diff
changeset
|
296 |
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
|
297 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
|
298 # $1=rowid of blog |
64
54bbd7ce3766
Inhibit non-group-member from *handout
HIROSE Yuuji <yuuji@gentei.org>
parents:
63
diff
changeset
|
299 if ! blog_writable $1 $user; then |
54bbd7ce3766
Inhibit non-group-member from *handout
HIROSE Yuuji <yuuji@gentei.org>
parents:
63
diff
changeset
|
300 echo "メンバー以外は利用できません。" | html p; return |
54bbd7ce3766
Inhibit non-group-member from *handout
HIROSE Yuuji <yuuji@gentei.org>
parents:
63
diff
changeset
|
301 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
|
302 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
|
303 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
|
304 title=`getvalbyid blog title $1` |
2 | 305 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
|
306 lshandoutsub $owner "$@" \ |
189 | 307 |_m4 -D_TITLE_="提出状況" \ |
308 -D_FORMHEAD_="$time [$title]@${ge:-$owner}" \ | |
309 -D_FORM_="syscmd(cat)" -D_DUMPHEAD_= -D_DUMPTABLE_= \ | |
310 $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
|
311 } |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
312 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
|
313 # $1=owner $2=rowid of blog |
2 | 314 if isgroup $1; then |
315 sample="(select user from grp_mem where gname='$1')" | |
316 else | |
317 sample="(select distinct author as user from arts)" | |
67 | 318 echo "(集計は板への投稿者のみ)" | html p |
2 | 319 fi |
320 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
|
321 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
|
322 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
|
323 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
|
324 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
|
325 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
|
326 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
|
327 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
|
328 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
|
329 as 'ファイルの提出'\ |
2 | 330 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
|
331 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
|
332 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
|
333 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
|
334 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
|
335 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
|
336 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
|
337 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
|
338 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
|
339 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
|
340 | 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
|
341 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
|
342 } |
2 | 343 gethandout() { |
344 # $1=rowid of blog | |
64
54bbd7ce3766
Inhibit non-group-member from *handout
HIROSE Yuuji <yuuji@gentei.org>
parents:
63
diff
changeset
|
345 if ! blog_writable $1 $user; then |
54bbd7ce3766
Inhibit non-group-member from *handout
HIROSE Yuuji <yuuji@gentei.org>
parents:
63
diff
changeset
|
346 echo "メンバー以外は利用できません。" | html p; return |
54bbd7ce3766
Inhibit non-group-member from *handout
HIROSE Yuuji <yuuji@gentei.org>
parents:
63
diff
changeset
|
347 fi |
2 | 348 i=0 |
349 bd=$tmpd/archive.$$ | |
350 mkdir $bd | |
351 query "select m.rowid,author,m.val from article a join article_m m\ | |
352 on a.id=m.id where blogid=(select id from blog where rowid=$1)\ | |
353 and m.key in ('image', 'document', 'binary');" \ | |
354 | while IFS='|' read rowid author filename; do | |
63 | 355 # err isfilereadable $user article_m $rowid |
356 isfilereadable $user article_m $rowid || continue | |
357 # err ok | |
2 | 358 i=$((i+1)) |
359 dir=`printf $bd/%03d $i` | |
360 mkdir $dir | |
361 query "select quote(bin) from article_m where rowid=$rowid;" \ | |
8 | 362 | unhexize > $dir/$filename |
2 | 363 done |
364 if [ ! -d $bd/001 ]; then | |
365 contenttype; echo | |
67 | 366 echo "取得できるファイルがありませんでした。" | html p |
2 | 367 return |
368 fi | |
369 (cd $bd | |
370 err cdto$bd; (pwd; ls -lFa) 1>&3 | |
371 tar zcf .archive.tar.gz * && mv .archive.tar.gz archive.tar.gz | |
372 ) | |
373 arc=$bd/archive.tar.gz | |
374 echo "Content-type: application/x-gzip" | |
375 echo "Content-Length: `cat $arc|wc -c`" | |
376 echo "Content-Disposition: filename=\"archive.tar.gz\"" | |
377 echo | |
378 cat $arc | |
379 } | |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
380 lsmyfile() { # $1(optional)=SortBy |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
381 case "$1" in |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
382 ""|CTIME-DESC) |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
383 by="CTIME" ord="DESC" ;; |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
384 CTIME*) by="CTIME" ;; |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
385 FILE*) by="FILE" ;; |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
386 OWNER*) by="OWNER" ;; |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
387 TITLE*) by="TITLE" ;; |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
388 esac |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
389 case "$1" in |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
390 *DESC) ord="DESC" ;; |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
391 esac |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
392 case "$ord" in |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
393 DESC) lkod="" jord="降順" ;; |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
394 *) lkod="-DESC" jord="昇順" ;; |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
395 esac |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
396 sql="select m.val||'/'||m.rowid FILE, |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
397 coalesce( |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
398 case when (select name from user where name=bs.owner) |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
399 is not null |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
400 then (select val from user_s where name=bs.owner |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
401 and key='gecos') |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
402 when (select gname from grp where gname=bs.owner) |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
403 is not null |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
404 then (select val from grp_s where gname=bs.owner |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
405 and key='gecos') |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
406 else |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
407 null |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
408 end, |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
409 bs.owner |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
410 ) OWNER, |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
411 a_s.val CTIME, |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
412 ',t,'||bs.title||':'||b.rowid||'#'||a.id TITLE |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
413 from (select rowid,id,val from article_m where id |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
414 in (select id from article where author='$user') |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
415 and type like 'file:%') |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
416 m left join article a on m.id=a.id |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
417 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
|
418 left join (select id, |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
419 max(case key when 'owner' then val end) as owner, |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
420 max(case key when 'title' then val end) as title |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
421 from blog_s group by id) |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
422 bs on a.blogid=bs.id |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
423 left join blog b on bs.id=b.id |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
424 where m.val is not null order by $by $ord;" |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
425 err lshandoutbyauthor: sql=`echo "$sql"` |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
426 title="個人提出ファイル" |
189 | 427 _m4 -D_TITLE_=$title $layout/html.m4.html |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
428 hra="<a href=\"?lsmyfile+" |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
429 hrb="<a href=\"?showattc+article_m+" |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
430 hrc="<a href=\"?replyblog+" |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
431 (echo '<table class="b">' |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
432 echo "$sql"|sq -html -header $db ) \ |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
433 | 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
|
434 -e "s|,t,\(.*\):\([^<]*\)\(</TD>\)|$hrc\2\">\1</a>\3|" \ |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
435 -e "s|\(<TH>\)\([A-Z]*\)\(</TH>\)|\1$hra\2$lkod\">\2</a>|" \ |
189 | 436 | _m4 -D_TITLE_=$title -D_FORM_="<p>($by$jord)</p>" \ |
437 -D_DUMPTABLE_="syscmd(cat)" $layout/form+dump.m4.html | |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
438 echo '</table>' |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
439 } |
78 | 440 searchart() { |
441 kwd=`getpar kwd` | |
442 if [ -z "$kwd" ]; then | |
443 echo "検索語を指定してください" | html p; return | |
444 fi | |
165
4040bb8b2038
quote search kwd. $SMAIL_TO controls To: header value.
HIROSE Yuuji <yuuji@gentei.org>
parents:
162
diff
changeset
|
445 for k in `echo "$kwd" | sed "s/'/''/g"`; do |
245
b915381669d6
Do not search from unreadable blogs
HIROSE Yuuji <yuuji@gentei.org>
parents:
239
diff
changeset
|
446 kc=$kc${kc:+" AND "}"s.text LIKE '%$k%'" |
165
4040bb8b2038
quote search kwd. $SMAIL_TO controls To: header value.
HIROSE Yuuji <yuuji@gentei.org>
parents:
162
diff
changeset
|
447 done |
4040bb8b2038
quote search kwd. $SMAIL_TO controls To: header value.
HIROSE Yuuji <yuuji@gentei.org>
parents:
162
diff
changeset
|
448 kwd=`echo "$kwd"|htmlescape` |
78 | 449 owner=`getpar owner` |
450 owner=${owner:-$1} | |
451 echo "「$kwd」による検索結果" | html p | |
452 if [ -n "$owner" ]; then | |
453 cond="where key='owner' and val='$owner'" | |
454 if isuser $owner; then | |
455 echo "(`linkhome $owner` さんの記録からの検索)" | html p | |
456 else | |
457 linkhome $owner 1>&3 | |
458 echo "(`linkhome $owner` グループからの検索)" | html p | |
459 fi | |
460 fi | |
461 # article_s: id=article-id, key='text', val='TEXT' | |
462 # article: id=article-id, blogid=blogkd | |
463 # blog: id=blog-id, author=LeaderAuthor | |
464 # blog_s: id=blog-id, key='title', val='BLOG-TITLE' | |
465 # WANT: blog-ROWid,article-id,val(TEXT) | |
245
b915381669d6
Do not search from unreadable blogs
HIROSE Yuuji <yuuji@gentei.org>
parents:
239
diff
changeset
|
466 sql="`sql4readableblogs` -- Extract user-readable blogs |
b915381669d6
Do not search from unreadable blogs
HIROSE Yuuji <yuuji@gentei.org>
parents:
239
diff
changeset
|
467 SELECT b.rid||'#'||x.id as '', |
78 | 468 b.title as TITLE, |
245
b915381669d6
Do not search from unreadable blogs
HIROSE Yuuji <yuuji@gentei.org>
parents:
239
diff
changeset
|
469 substr(x.ctime, 0, 11) as DATE, |
b915381669d6
Do not search from unreadable blogs
HIROSE Yuuji <yuuji@gentei.org>
parents:
239
diff
changeset
|
470 substr(x.text, 0, 78) as TEXT |
b915381669d6
Do not search from unreadable blogs
HIROSE Yuuji <yuuji@gentei.org>
parents:
239
diff
changeset
|
471 FROM (SELECT blg.rid,blg.*,bs.val as title |
b915381669d6
Do not search from unreadable blogs
HIROSE Yuuji <yuuji@gentei.org>
parents:
239
diff
changeset
|
472 FROM readableblogs blg join blog_s bs |
b915381669d6
Do not search from unreadable blogs
HIROSE Yuuji <yuuji@gentei.org>
parents:
239
diff
changeset
|
473 ON blg.id=bs.id and bs.key='title') b |
78 | 474 join |
245
b915381669d6
Do not search from unreadable blogs
HIROSE Yuuji <yuuji@gentei.org>
parents:
239
diff
changeset
|
475 (SELECT a.id, |
b915381669d6
Do not search from unreadable blogs
HIROSE Yuuji <yuuji@gentei.org>
parents:
239
diff
changeset
|
476 a.blogid, |
b915381669d6
Do not search from unreadable blogs
HIROSE Yuuji <yuuji@gentei.org>
parents:
239
diff
changeset
|
477 s.ctime, |
b915381669d6
Do not search from unreadable blogs
HIROSE Yuuji <yuuji@gentei.org>
parents:
239
diff
changeset
|
478 s.text |
b915381669d6
Do not search from unreadable blogs
HIROSE Yuuji <yuuji@gentei.org>
parents:
239
diff
changeset
|
479 FROM article a |
b915381669d6
Do not search from unreadable blogs
HIROSE Yuuji <yuuji@gentei.org>
parents:
239
diff
changeset
|
480 JOIN |
b915381669d6
Do not search from unreadable blogs
HIROSE Yuuji <yuuji@gentei.org>
parents:
239
diff
changeset
|
481 (SELECT id, /* Create [id, ctime, text] from article_s */ |
b915381669d6
Do not search from unreadable blogs
HIROSE Yuuji <yuuji@gentei.org>
parents:
239
diff
changeset
|
482 max(CASE key WHEN 'ctime' THEN val END) ctime, |
b915381669d6
Do not search from unreadable blogs
HIROSE Yuuji <yuuji@gentei.org>
parents:
239
diff
changeset
|
483 max(CASE key WHEN 'text' THEN val END) text |
b915381669d6
Do not search from unreadable blogs
HIROSE Yuuji <yuuji@gentei.org>
parents:
239
diff
changeset
|
484 FROM article_s GROUP BY id) s |
b915381669d6
Do not search from unreadable blogs
HIROSE Yuuji <yuuji@gentei.org>
parents:
239
diff
changeset
|
485 ON a.id=s.id where $kc) |
78 | 486 x on b.id=x.blogid |
245
b915381669d6
Do not search from unreadable blogs
HIROSE Yuuji <yuuji@gentei.org>
parents:
239
diff
changeset
|
487 where b.id in (select id from blog_s $cond) |
b915381669d6
Do not search from unreadable blogs
HIROSE Yuuji <yuuji@gentei.org>
parents:
239
diff
changeset
|
488 ORDER by x.ctime DESC;" |
78 | 489 sedopt="s,<TR><TD>\([^<]*\)</TD>,<TR><TD><a\ |
490 href=\"?replyblog+\1\">VIEW</a></TD>," | |
245
b915381669d6
Do not search from unreadable blogs
HIROSE Yuuji <yuuji@gentei.org>
parents:
239
diff
changeset
|
491 |
78 | 492 cat<<EOF |
493 <table class="b searchart"> | |
494 `sq -header -html $db "$sql"|sed "$sedopt"` | |
495 </table> | |
496 EOF | |
497 } | |
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
|
498 listblog() ( |
67 | 499 # $1={user,group} |
500 qow=`sqlquote $1` | |
501 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
|
502 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
|
503 cgi_form searchart<<EOF |
128 | 504 <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
|
505 `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
|
506 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
|
507 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
|
508 ) |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
509 |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
510 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
|
511 # $1=GRPname(if it is a group) |
16
636df1c1bdf2
Track group by rowid in URLs
HIROSE Yuuji <yuuji@gentei.org>
parents:
13
diff
changeset
|
512 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
|
513 rowid=`getpar rowid` |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
514 err blog_addentry0: rowid=$rowid |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
515 if [ -n "$grprowid" ]; then |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
516 owner=`getgroupbyid $grprowid` |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
517 else |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
518 owner=`getpar owner` |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
519 fi |
122
0681534f9451
When deleting group, remove all blos that belong it.
HIROSE Yuuji <yuuji@gentei.org>
parents:
117
diff
changeset
|
520 err blog-add: \$1=$1 rowid=$rowid owner=$owner |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
521 if isgroup $owner; then |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
522 groupmode=1 listing=$owner guide="[${owner}]" GF_OWNER=$owner |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
523 else |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
524 usermode=1 listing=$user guide="[個人]" |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
525 fi |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
526 |
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
|
527 if [ -n "`getpar title`" ]; then |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
528 if [ "$usermode" ]; then |
122
0681534f9451
When deleting group, remove all blos that belong it.
HIROSE Yuuji <yuuji@gentei.org>
parents:
117
diff
changeset
|
529 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
|
530 if [ x"$user" != x"$owner" ]; then |
67 | 531 echo "他人の日記は書けません" | html p |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
532 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
|
533 fi |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
534 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
|
535 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
|
536 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
|
537 if ! ismember "$user" "$grp"; then |
67 | 538 echo "(話題作成はこのグループに加入してから)" | html p |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
539 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
|
540 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
|
541 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
|
542 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
|
543 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
|
544 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
|
545 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
|
546 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
|
547 # 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
|
548 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
|
549 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
|
550 # 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
|
551 id=`query "select rowid from blog where id='$serial';"` |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
552 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
|
553 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
|
554 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
|
555 ## 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
|
556 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
|
557 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
|
558 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
|
559 fi |
81
ddc8a4c0b8d9
All macro-expanding by m4 bypassed via syscmd or spaste
HIROSE Yuuji <yuuji@gentei.org>
parents:
80
diff
changeset
|
560 echo "${guide}新規話題作成" > $tmpd/title.$$ |
ddc8a4c0b8d9
All macro-expanding by m4 bypassed via syscmd or spaste
HIROSE Yuuji <yuuji@gentei.org>
parents:
80
diff
changeset
|
561 listblog $listing > $tmpd/listblog.$$ |
ddc8a4c0b8d9
All macro-expanding by m4 bypassed via syscmd or spaste
HIROSE Yuuji <yuuji@gentei.org>
parents:
80
diff
changeset
|
562 genform $formdir/blog.def \ |
189 | 563 | _m4 -D_TITLE_="spaste(\`$tmpd/title.$$')" \ |
564 -D_FORMHEAD_="序文は簡単に詳しくはコメントに" \ | |
565 -D_DUMPHEAD_="これまでの蓄積" \ | |
566 -D_FORM_="syscmd(\`cat')" \ | |
567 -D_DUMPTABLE_="spaste(\`$tmpd/listblog.$$')" \ | |
568 $layout/html.m4.html \ | |
569 $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
|
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 |
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 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
|
573 rowid=$1 |
222
d320c73bf16f
Add "team" attributes in groups.
HIROSE Yuuji <yuuji@gentei.org>
parents:
219
diff
changeset
|
574 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
|
575 |
b8a890828283
add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff
changeset
|
576 if [ -z "$rowid" ]; then |
67 | 577 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
|
578 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
|
579 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
|
580 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
|
581 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
|
582 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
|
583 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
|
584 else |
16
636df1c1bdf2
Track group by rowid in URLs
HIROSE Yuuji <yuuji@gentei.org>
parents:
13
diff
changeset
|
585 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
|
586 subtitle="グループ <a href=\"?grp+$grprowid\">$owner</a> での話題 |
d320c73bf16f
Add "team" attributes in groups.
HIROSE Yuuji <yuuji@gentei.org>
parents:
219
diff
changeset
|
587 `query \"SELECT printf('(チーム:%s)', val)\ |
d320c73bf16f
Add "team" attributes in groups.
HIROSE Yuuji <yuuji@gentei.org>
parents:
219
diff
changeset
|
588 FROM blog_s |
d320c73bf16f
Add "team" attributes in groups.
HIROSE Yuuji <yuuji@gentei.org>
parents:
219
diff
changeset
|
589 WHERE id=(SELECT id FROM blog WHERE rowid=$rowid) |
d320c73bf16f
Add "team" attributes in groups.
HIROSE Yuuji <yuuji@gentei.org>
parents:
219
diff
changeset
|
590 AND key='team'; |
d320c73bf16f
Add "team" attributes in groups.
HIROSE Yuuji <yuuji@gentei.org>
parents:
219
diff
changeset
|
591 \"|htmlescape`" |
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
|
592 qgrp=`sqlquote "$owner"` |
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
|
593 sql="SELECT coalesce( |
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
|
594 (SELECT val FROM grp_s WHERE gname=$qgrp AND key='regmode'), |
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
|
595 'open') |
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
|
596 || |
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
|
597 CASE WHEN '$user' |
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
|
598 IN (SELECT user FROM grp_mem WHERE gname=$qgrp) |
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
|
599 THEN ' ismember' |
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
|
600 ELSE '' |
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
|
601 END" |
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
|
602 memclass=`query "$sql;"` |
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
|
603 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
|
604 if [ -z "$title" ]; then |
67 | 605 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
|
606 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
|
607 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
|
608 |
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 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
|
610 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
|
611 if blog_writable $rowid $user; then |
80
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
612 par2table $formdir/article.def |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
613 st=$? # ; err par2t-st=$st |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
614 case $st in |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
615 0|4) |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
616 [ "$st" = "4" ] && act="書込削除" |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
617 blog_notify_reply $rowid $user "$text" $act ;; |
39e69daa2071
New feature "lsmyfile" added
HIROSE Yuuji <yuuji@gentei.org>
parents:
78
diff
changeset
|
618 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
|
619 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
|
620 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
|
621 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
|
622 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
|
623 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
|
624 echo "$title" > $tmpd/title.$$ |
ddc8a4c0b8d9
All macro-expanding by m4 bypassed via syscmd or spaste
HIROSE Yuuji <yuuji@gentei.org>
parents:
80
diff
changeset
|
625 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
|
626 ${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
|
627 | _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
|
628 -D_BODYCLASS_=general"${memclass:+ $memclass}" \ |
189 | 629 -D_FORMHEAD_="spaste(\`$tmpd/subtitle.$$')" \ |
630 -D_FORM_='' \ | |
631 -D_DUMPTABLE_="syscmd(cat)" -D_DUMPHEAD_="" \ | |
632 $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
|
633 } |