s4: s4-blog.sh annotate

annotate s4-blog.sh @ 67:3b70f847277e

Rearrangement

author	HIROSE Yuuji <yuuji@gentei.org>
date	Fri, 31 Jul 2015 10:04:14 +0900
parents	54bbd7ce3766
children	7380bcf19078

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 01f579d2c889 Rename to s4 HIROSE Yuuji <yuuji@gentei.org> parents: 16 diff changeset	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 )
50 13f9b5e5df85 subshellize blog_notify_reply HIROSE Yuuji <yuuji@gentei.org> parents: 48 diff changeset	14 blog_notify_reply() (
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	15 # $1=articleid $2=ReplyingUser $3=WrittenText
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	16 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	17 [ 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	18 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	19 blogurl="$urlbase?replyblog+$1"
50 13f9b5e5df85 subshellize blog_notify_reply HIROSE Yuuji <yuuji@gentei.org> parents: 48 diff changeset	20 mode=`getvalbyid blog notify "$1"`
13f9b5e5df85 subshellize blog_notify_reply HIROSE Yuuji <yuuji@gentei.org> parents: 48 diff changeset	21 case $mode in
48 837c9a6bec02 Add notification modes HIROSE Yuuji <yuuji@gentei.org> parents: 42 diff changeset	22 admin)
55 7f9f7e898986 Do not send notification to the person-self HIROSE Yuuji <yuuji@gentei.org> parents: 54 diff changeset	23 if isgroup "$blogowner"; then
7f9f7e898986 Do not send notification to the person-self HIROSE Yuuji <yuuji@gentei.org> parents: 54 diff changeset	24 emails=`for i in $(getgroupadmins $blogowner); do\
7f9f7e898986 Do not send notification to the person-self HIROSE Yuuji <yuuji@gentei.org> parents: 54 diff changeset	25 [ x"$i" = x"$user" ] && continue;\
58 ccd0c6736215 Argument order reversed on email4group HIROSE Yuuji <yuuji@gentei.org> parents: 57 diff changeset	26 email4group "$blogowner" "$i" ;\
55 7f9f7e898986 Do not send notification to the person-self HIROSE Yuuji <yuuji@gentei.org> parents: 54 diff changeset	27 done`
48 837c9a6bec02 Add notification modes HIROSE Yuuji <yuuji@gentei.org> parents: 42 diff changeset	28 else
837c9a6bec02 Add notification modes HIROSE Yuuji <yuuji@gentei.org> parents: 42 diff changeset	29 emails=`collectemail $blogowner`
837c9a6bec02 Add notification modes HIROSE Yuuji <yuuji@gentei.org> parents: 42 diff changeset	30 fi
837c9a6bec02 Add notification modes HIROSE Yuuji <yuuji@gentei.org> parents: 42 diff changeset	31 ;;
837c9a6bec02 Add notification modes HIROSE Yuuji <yuuji@gentei.org> parents: 42 diff changeset	32 no) return ;;
837c9a6bec02 Add notification modes HIROSE Yuuji <yuuji@gentei.org> parents: 42 diff changeset	33 *) emails=`collectemail $blogowner` ;;
837c9a6bec02 Add notification modes HIROSE Yuuji <yuuji@gentei.org> parents: 42 diff changeset	34 esac
57 7c61a80051f5 debug code on HIROSE Yuuji <yuuji@gentei.org> parents: 55 diff changeset	35 err notify: user=$user Admins=`getgroupadmins $blogowner` Mode=$mode Emails="[$emails]"
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	36 smail "$emails" "書込通知 $urlbase"<<EOF
48 837c9a6bec02 Add notification modes HIROSE Yuuji <yuuji@gentei.org> parents: 42 diff changeset	37 [$blogtitle]板に書き込みがありました。
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	38 場所: $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	39 題目: $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	40 筆者: `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	41 内容:
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	42 `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	43 EOF
50 13f9b5e5df85 subshellize blog_notify_reply HIROSE Yuuji <yuuji@gentei.org> parents: 48 diff changeset	44 )
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	45 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	46 # $1=table $2=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	47 if [ -n "$2" ]; 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	48 if [ -n "$imgcached" ]; then
42 0e3164b11ec0 Illegal use of $tmpd fixed in blog_showentry HIROSE Yuuji <yuuji@gentei.org> parents: 41 diff changeset	49 bstmpdir=$tmpdir/$imgcached/$thumbxy
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	50 else
42 0e3164b11ec0 Illegal use of $tmpd fixed in blog_showentry HIROSE Yuuji <yuuji@gentei.org> parents: 41 diff changeset	51 bstmpdir=$tmpd
0e3164b11ec0 Illegal use of $tmpd fixed in blog_showentry HIROSE Yuuji <yuuji@gentei.org> parents: 41 diff changeset	52 # tmpd=`mktempd`
0e3164b11ec0 Illegal use of $tmpd fixed in blog_showentry HIROSE Yuuji <yuuji@gentei.org> parents: 41 diff changeset	53 # tmpfiles=$tmpfiles" $tmpd"
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	54 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	55 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	56 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	57 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	58 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	59 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	60 serial=$(($(date +%s)-1420038000))s$$
64 54bbd7ce3766 Inhibit non-group-member from handout HIROSE Yuuji <yuuji@gentei.org>* parents: 63 diff changeset	61 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	62 # 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	63 # 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	64 # 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	65 # 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	66
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	67 err "SELECT id from $tbl where rowid=$rowid"
2 7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	68 id=`query "select id from $tbl where rowid=$rowid;"`
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	69 err id=$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	70 err "select val from $ts where key='title' and id='$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	71
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
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 #(1)Display root 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	74 cat<<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	75 <form class="replyblog" action="$myname?replyblog+$rowid" method="POST" enctype="multipart/form-data">
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 <table class="bloghead">
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 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	78
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 href="<a href=\"?editheading+$rowid\"> 編集 </a>"
64 54bbd7ce3766 Inhibit non-group-member from handout HIROSE Yuuji <yuuji@gentei.org>* parents: 63 diff changeset	80 if $iswritable; then
54bbd7ce3766 Inhibit non-group-member from handout HIROSE Yuuji <yuuji@gentei.org>* parents: 63 diff changeset	81 href2="<a href=\"?lshandout+$rowid\"> 提出状況 </a>"
54bbd7ce3766 Inhibit non-group-member from handout HIROSE Yuuji <yuuji@gentei.org>* parents: 63 diff changeset	82 href3="(<a href=\"?gethandout+$rowid\">ファイル取得</a>)"
54bbd7ce3766 Inhibit non-group-member from handout HIROSE Yuuji <yuuji@gentei.org>* parents: 63 diff changeset	83 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	84 cat<<EOF \| sq -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	85 \| sed -e "s\|$<TR><TD>$,e,\|\1 $href \|" \
2 7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	86 -e "s\|,s,$</TD>$\|$href2$href3\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	87 -- select val from $ts where key="title" and id="$id";
2 7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	88 select
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	89 coalesce((select ",e," from blog where rowid=$rowid and author='$user'),'')
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	90 \|\|val\|\|" "
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	91 \|\|case (select val from $ts where key="mode" and id="$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	92 when 'report-closed' then "レポート提出用(自身のファイルのみ参照可),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	93 when 'report-open' then "レポート提出用,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	94 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	95 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	96 from $ts where key="ctime" and id="$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	97 select val from $ts where key="heading" and id="$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	98 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	99 cat<<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	100 </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	101 <table class="blog_replies">
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	102 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	103
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	104 #(2)Display following articles
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	105 textform='<div><table class="b">
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	106 <tr><td><textarea name="text" cols="40" rows="4"></textarea></td></tr>
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	107 <tr><td>添付ファイル: <input type="file" name="image" multiple></td></tr>
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	108 </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	109 <input type="submit" value="送信">
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	110 <input type="reset" value="リセット"></div>
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	111 '
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	112 ## 6/11の次: 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	113 : <<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	114 シリアル:id:p: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	115 blogID:blogid:f: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	116 筆者:author:s: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	117 時刻:ctime:s:stamp:
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	118 参照元:parent:s:parent:
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	119 パス:path:s:path:
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	120 本文:text:s:textarea:cols="60" rows="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	121 画像:image:m:image:
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	122 stage:stage:x:hidden:value="replyblog"
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	123
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	124 article(id, blogid, 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	125 article_s: Visible = ctime, text Invisible = parent, path
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	126 article_m: image
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	127
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	128 article = hoge\|1433812374x20849\|yuuji@gentei.org
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	129 article_s = hoge\|ctime\|string\|2015-06-13 12:27:34\|
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	130 hoge\|text\|string\|Shall we dance?\|
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	131 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	132 ##
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	133 ##
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	134 err "select id from $at where blogid='$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	135 # arts=`sq $db "select a.rowid,a.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	136 #-- coalesce(b.gecos, 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	137 # a.author from $at 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	138 # LEFT JOIN (select name,val as gecos from user_s where key='gecos') b
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	139 # on a.author=b.name where blogid='$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	140 arts=`query "select rowid,id,author from $at where blogid='$id';"`
34 77e2aeb2d7ad autolink by "href=..." HIROSE Yuuji <yuuji@gentei.org> parents: 28 diff changeset	141 # err arts="[$arts]"
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	142 number=0
2 7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	143 hrefhome0="<a href=\"?home"
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	144 for a in $arts; do
59 916d81b9c4fc Selection from group member HIROSE Yuuji <yuuji@gentei.org> parents: 58 diff changeset	145 arid=${a%%\\|} aid=`echo "$a"\|cut -d'\|' -f2` author=${a##\\|} imgs=""
41 ce13cad6b99d Trim newline for sed argument HIROSE Yuuji <yuuji@gentei.org> parents: 35 diff changeset	146 err a=$a, aid=$aid, author=$author
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	147 # name='' # Get gecos??
42 0e3164b11ec0 Illegal use of $tmpd fixed in blog_showentry HIROSE Yuuji <yuuji@gentei.org> parents: 41 diff changeset	148 td=$(echo $bstmpdir/`echo $a\|md5`)
59 916d81b9c4fc Selection from group member HIROSE Yuuji <yuuji@gentei.org> parents: 58 diff changeset	149 val=`getvalbyid article image "$arid" "$td"`
41 ce13cad6b99d Trim newline for sed argument HIROSE Yuuji <yuuji@gentei.org> parents: 35 diff changeset	150 err val="[$val]" and td as follows:
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	151
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	152 if true; 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	153 if [ -n "$val" ]; 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	154 hrfb="$myname?showattc+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	155 imgs="<br>"$(echo "$val"\
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	156 \|while read fn; do
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	157
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	158 #data=`percenthex $td/$fn`
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	159 #ct=`cat $td/$fn.content-type`
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	160 ri=`cat $td/$fn.rowid`
41 ce13cad6b99d Trim newline for sed argument HIROSE Yuuji <yuuji@gentei.org> parents: 35 diff changeset	161 err fn=$fn ct=$ct ri=$ri; ls -lF $td/ 1>&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	162 iconhref $td/$fn "$hrfb+$ri" "$fn" "$fn"
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	163 done)
41 ce13cad6b99d Trim newline for sed argument HIROSE Yuuji <yuuji@gentei.org> parents: 35 diff changeset	164 imgs=`echo "$imgs"\|tr -d '\n'` # kill newlines for sed
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	165 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	166 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	167
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	168 ### number=$((number+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	169 # reply="<input type=\"radio\" name=\"parent\" class=\"replybtn\" \
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	170 # value=\"$number\">"
2 7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	171 getgecos="(select rowid from user where name='$author')\|\|':'\|\|\
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	172 coalesce((select val from user_s \
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	173 where name='$author' and key='gecos'), '$author')\|\|',[/a],'"
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	174 href="$myname?editart+$arid+$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	175 link="<a href=\"$href\">編集</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	176 cat<<EOF \| sq -html $db \
2 7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	177 \| sed -e "s\|,n,$[0-9]*$:\|,n,$hrefhome0+\1\">\|" \
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	178 -e 's\|,\[/a\],\|</a>\|' \
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	179 -e 's/,n,/<br>/g' -e "s\|,i,\|$imgs\|" \
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	180 -e "s\|<TR>$<TD>$\|<TR id=\"$aid\">\1\|" \
35 894f93ef24fe g flag is meaningless because regexp is anchored at the bol HIROSE Yuuji <yuuji@gentei.org> parents: 34 diff changeset	181 -e "s\|^href=$[-A-Za-z0-9,.:/~_%#&+?]*$\|<a &>\1</a>\|" \
2 7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	182 -e "s\|$<TR.*>$$<TD>$,e,\|\1\2$link\|"
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	183 select
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	184 coalesce((select ",e," from article where id='$aid' and author='$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	185 \|\|
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	186 max(case key when 'ctime' then ",n,"\|\|val\|\|
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	187 ",n,"\|\|$getgecos end) as TIME,
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	188 -- max(case key when 'parent' then val\|\|"への返信" end) as REPLYTO,
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	189 max(case key when 'text' then val\|\|",i," end) as 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	190 from article_s where id = '$aid'
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	191 group by id order by TIME;
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	192 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	193 done
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	194 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	195
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	196
64 54bbd7ce3766 Inhibit non-group-member from handout HIROSE Yuuji <yuuji@gentei.org>* parents: 63 diff changeset	197 $iswritable && cat<<EOF
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	198 <div class="blogcomment">
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	199 <p>コメント記入</p>
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	200 <input type="hidden" name="blogid" value="$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	201 <input type="hidden" name="stage" value="replyblog">
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	202 <input type="hidden" name="serial" value="$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	203 $textform
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	204 </div>
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	205 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	206 echo "</form>"
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	207
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	208 # Record access log
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	209 acclog blog $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	210 }
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	211
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	212 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	213 # $1=rowid of blog
64 54bbd7ce3766 Inhibit non-group-member from handout HIROSE Yuuji <yuuji@gentei.org>* parents: 63 diff changeset	214 if ! blog_writable $1 $user; then
54bbd7ce3766 Inhibit non-group-member from handout HIROSE Yuuji <yuuji@gentei.org>* parents: 63 diff changeset	215 echo "メンバー以外は利用できません。" \| html p; return
54bbd7ce3766 Inhibit non-group-member from handout HIROSE Yuuji <yuuji@gentei.org>* parents: 63 diff changeset	216 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	217 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	218 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	219 title=`getvalbyid blog title $1`
2 7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	220 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	221 lshandoutsub $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	222 \|m4 -D_TITLE_="提出状況" \
67 3b70f847277e Rearrangement HIROSE Yuuji <yuuji@gentei.org> parents: 64 diff changeset	223 -D_FORMHEAD_="$time [$title]@${ge:-$owner}" \
3b70f847277e Rearrangement HIROSE Yuuji <yuuji@gentei.org> parents: 64 diff changeset	224 -D_FORM_="syscmd(cat)" -D_DUMPHEAD_= -D_DUMPTABLE_= \
3b70f847277e Rearrangement HIROSE Yuuji <yuuji@gentei.org> parents: 64 diff changeset	225 $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	226 }
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	227 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	228 # $1=owner $2=rowid of blog
2 7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	229 if isgroup $1; then
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	230 sample="(select user from grp_mem where gname='$1')"
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	231 else
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	232 sample="(select distinct author as user from arts)"
67 3b70f847277e Rearrangement HIROSE Yuuji <yuuji@gentei.org> parents: 64 diff changeset	233 echo "(集計は板への投稿者のみ)" \| html p
2 7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	234 fi
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	235 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	236 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	237 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	238 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	239 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	240 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	241 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	242 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	243 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	244 as 'ファイルの提出'\
2 7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	245 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	246 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	247 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	248 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	249 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	250 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	251 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	252 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	253 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	254 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	255 \| 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	256 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	257 }
2 7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	258 gethandout() {
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	259 # $1=rowid of blog
64 54bbd7ce3766 Inhibit non-group-member from handout HIROSE Yuuji <yuuji@gentei.org>* parents: 63 diff changeset	260 if ! blog_writable $1 $user; then
54bbd7ce3766 Inhibit non-group-member from handout HIROSE Yuuji <yuuji@gentei.org>* parents: 63 diff changeset	261 echo "メンバー以外は利用できません。" \| html p; return
54bbd7ce3766 Inhibit non-group-member from handout HIROSE Yuuji <yuuji@gentei.org>* parents: 63 diff changeset	262 fi
2 7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	263 i=0
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	264 bd=$tmpd/archive.$$
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	265 mkdir $bd
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	266 query "select m.rowid,author,m.val from article a join article_m m\
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	267 on a.id=m.id where blogid=(select id from blog where rowid=$1)\
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	268 and m.key in ('image', 'document', 'binary');" \
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	269 \| while IFS='\|' read rowid author filename; do
63 da23cad20e4a Permission check fixed HIROSE Yuuji <yuuji@gentei.org> parents: 59 diff changeset	270 # err isfilereadable $user article_m $rowid
da23cad20e4a Permission check fixed HIROSE Yuuji <yuuji@gentei.org> parents: 59 diff changeset	271 isfilereadable $user article_m $rowid \|\| continue
da23cad20e4a Permission check fixed HIROSE Yuuji <yuuji@gentei.org> parents: 59 diff changeset	272 # err ok
2 7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	273 i=$((i+1))
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	274 dir=`printf $bd/%03d $i`
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	275 mkdir $dir
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	276 query "select quote(bin) from article_m where rowid=$rowid;" \
8 3db7524d3dea Add default images HIROSE Yuuji <yuuji@gentei.org> parents: 4 diff changeset	277 \| unhexize > $dir/$filename
2 7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	278 done
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	279 if [ ! -d $bd/001 ]; then
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	280 contenttype; echo
67 3b70f847277e Rearrangement HIROSE Yuuji <yuuji@gentei.org> parents: 64 diff changeset	281 echo "取得できるファイルがありませんでした。" \| html p
2 7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	282 return
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	283 fi
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	284 (cd $bd
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	285 err cdto$bd; (pwd; ls -lFa) 1>&3
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	286 tar zcf .archive.tar.gz * && mv .archive.tar.gz archive.tar.gz
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	287 )
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	288 arc=$bd/archive.tar.gz
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	289 echo "Content-type: application/x-gzip"
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	290 echo "Content-Length: `cat $arc\|wc -c`"
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	291 echo "Content-Disposition: filename=\"archive.tar.gz\""
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	292 echo
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	293 cat $arc
7aa52f9874ae .hgignore added HIROSE Yuuji <yuuji@gentei.org> parents: 0 diff changeset	294 }
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	295
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	296 listblog() (
67 3b70f847277e Rearrangement HIROSE Yuuji <yuuji@gentei.org> parents: 64 diff changeset	297 # $1={user,group}
3b70f847277e Rearrangement HIROSE Yuuji <yuuji@gentei.org> parents: 64 diff changeset	298 qow=`sqlquote $1`
3b70f847277e Rearrangement HIROSE Yuuji <yuuji@gentei.org> parents: 64 diff changeset	299 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	300 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	301 cgi_form searchart<<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	302 <label>`cgi_text kwd`という語を含む記事を検索</label>
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 `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	304 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	305 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	306 )
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	307
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	308 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	309 # $1=GRPname(if it is a group)
16 636df1c1bdf2 Track group by rowid in URLs HIROSE Yuuji <yuuji@gentei.org> parents: 13 diff changeset	310 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	311 rowid=`getpar 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	312 err ba: 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	313 #if [ -z "$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	314 # When rowid is SET, it is updation of existing entry
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	315 if [ -z "$1" ]; 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	316 listing=$user guide="[個人]"
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	317 #listing代入は 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	318 else
16 636df1c1bdf2 Track group by rowid in URLs HIROSE Yuuji <yuuji@gentei.org> parents: 13 diff changeset	319 grp=`getgroupbyid $grprowid`
636df1c1bdf2 Track group by rowid in URLs HIROSE Yuuji <yuuji@gentei.org> parents: 13 diff changeset	320 if [ -n "$grp" ]; then
67 3b70f847277e Rearrangement HIROSE Yuuji <yuuji@gentei.org> parents: 64 diff changeset	321 listing=$grp guide="[${grp}]" GF_OWNER=$grp
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	322 else
67 3b70f847277e Rearrangement HIROSE Yuuji <yuuji@gentei.org> parents: 64 diff changeset	323 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	324 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	325 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	326 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	327 #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	328 if [ -n "`getpar title`" ]; 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	329 owner=`getpar 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	330 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	331 if [ x"$user" != x"$owner" ]; then
67 3b70f847277e Rearrangement HIROSE Yuuji <yuuji@gentei.org> parents: 64 diff changeset	332 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	333 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	334 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	335 elif isgroup $owner; then # if write to group log
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 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	337 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	338 if ! ismember "$user" "$grp"; then
67 3b70f847277e Rearrangement HIROSE Yuuji <yuuji@gentei.org> parents: 64 diff changeset	339 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	340 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	341 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	342 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	343 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	344 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	345 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	346 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	347 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	348 # 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	349 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	350 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	351 # 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	352 id=`query "select rowid from blog where id='$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	353 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	354 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	355 ## 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	356 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	357 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	358 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	359 fi
67 3b70f847277e Rearrangement HIROSE Yuuji <yuuji@gentei.org> parents: 64 diff changeset	360 m4 -D_TITLE_="${guide}新規話題作成" \
3b70f847277e Rearrangement HIROSE Yuuji <yuuji@gentei.org> parents: 64 diff changeset	361 -D_FORMHEAD_="序文は簡単に詳しくはコメントに" \
3b70f847277e Rearrangement HIROSE Yuuji <yuuji@gentei.org> parents: 64 diff changeset	362 -D_DUMPHEAD_="これまでの蓄積" \
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	363 -D_FORM_="`genform $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	364 -D_DUMPTABLE_="`listblog $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	365 $layout/html.m4.html \
67 3b70f847277e Rearrangement HIROSE Yuuji <yuuji@gentei.org> parents: 64 diff changeset	366 $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	367 }
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	368
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	369 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	370 rowid=$1
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	371 err rowid=$1
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	372
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	373 if [ -z "$rowid" ]; then
67 3b70f847277e Rearrangement HIROSE Yuuji <yuuji@gentei.org> parents: 64 diff changeset	374 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	375 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	376 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	377 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	378 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	379 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	380 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	381 else
16 636df1c1bdf2 Track group by rowid in URLs HIROSE Yuuji <yuuji@gentei.org> parents: 13 diff changeset	382 grprowid=`query "select rowid from grp where gname=\"$owner\";"`
54 d08e556f3462 In group mode, link anchor changed from gecos to gname HIROSE Yuuji <yuuji@gentei.org> parents: 50 diff changeset	383 subtitle="グループ <a href=\"?grp+$grprowid\">$owner</a> での話題"
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	384 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	385 if [ -z "$title" ]; then
67 3b70f847277e Rearrangement HIROSE Yuuji <yuuji@gentei.org> parents: 64 diff changeset	386 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	387 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	388 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	389
b8a890828283 add se-blog.sh se-cgi.sh se-funcs.sh se-init.sh mpsplit.rb HIROSE Yuuji <yuuji@gentei.org> parents: diff changeset	390 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	391 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	392 if blog_writable $rowid $user; 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	393 if par2table $formdir/article.def; 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	394 blog_notify_reply $rowid $user "$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	395 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	396 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	397 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	398 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	399 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	400 def=$formdir/article.def
67 3b70f847277e Rearrangement HIROSE Yuuji <yuuji@gentei.org> parents: 64 diff changeset	401 blog_showentry blog $rowid \
3b70f847277e Rearrangement HIROSE Yuuji <yuuji@gentei.org> parents: 64 diff changeset	402 \| m4 -D_TITLE_="$title" -D_BODYCLASS_=general \
3b70f847277e Rearrangement HIROSE Yuuji <yuuji@gentei.org> parents: 64 diff changeset	403 -D_FORMHEAD_="$subtitle" -D_FORM_="" \
3b70f847277e Rearrangement HIROSE Yuuji <yuuji@gentei.org> parents: 64 diff changeset	404 -D_DUMPTABLE_="syscmd(cat)" -D_DUMPHEAD_="" \
3b70f847277e Rearrangement HIROSE Yuuji <yuuji@gentei.org> parents: 64 diff changeset	405 $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	406 }

Mercurial > hgrepos > hgweb.cgi > s4

annotate s4-blog.sh @ 67:3b70f847277e