s4

changeset 364:05641ff595f6

find changesets by author, revision, files, or words in the commit message
Remove inactive sql
author HIROSE Yuuji <yuuji@gentei.org>
date Tue, 22 Nov 2016 08:25:49 +0859
parents e25b701dac6c
children be652501ca71
files s4-blog.sh
diffstat 1 files changed, 0 insertions(+), 22 deletions(-) [+]
line diff
     1.1 --- a/s4-blog.sh	Sun Nov 13 22:51:37 2016 +0859
     1.2 +++ b/s4-blog.sh	Tue Nov 22 08:25:49 2016 +0859
     1.3 @@ -192,7 +192,6 @@
     1.4      nt="<label style=\"font-size: 70%;\"><input type=\"checkbox\"
     1.5  	 name=\"notifyto\" value=\"$uid\">返信通知送信</label>"
     1.6      tdcls="repatt${new:+ new}"
     1.7 -    imgdir=`getcachedir home/"$uid"`/main
     1.8      if [ -n "$icon" -a -s "$icon" ]; then
     1.9        icfn=`echo "$icon"|htmlescape`
    1.10        picon="<p class=\"proficon\"><a href=\"$hlink+$uid\"><img src=\"$icfn\"></a></p>"
    1.11 @@ -218,7 +217,6 @@
    1.12        mrid=${i%%:*}; i=${i#*:}; sz=`size_h ${i%%:*}`
    1.13        fn=`echo "${i#*:}"|unhexize`
    1.14        fnb=$fn"(${sz})"
    1.15 -      # echo r=$mrid fn=$fn
    1.16        case "$fn" in
    1.17  	*.[Pp][Nn][Gg]|*.[Jj][Pp][Gg]|*.[Jj][Pp][Ee][Gg]|*.[Gg][Ii][Ff])
    1.18  	  #  fmt=${fn##*.}	# convert - jpg:- is slow...why
    1.19 @@ -236,7 +234,6 @@
    1.20  		 { [ "$usecache" ] ||	# And usecache flag is true, or...
    1.21  		       { [ -s "$tsfile" ] && [ x"`cat $tsfile`" = x"$tm" ]
    1.22  		       };}; then
    1.23 -	    # err Set usecache=1
    1.24  	    usecache=1		# Set usecache flag on
    1.25  	    cat<<-EOF
    1.26  		<a href="$catlink+$mrid"><img src="$outfile">
    1.27 @@ -281,25 +278,6 @@
    1.28  	 href="?reload/$rowid" accesskey="r" title="R">再読込</a> / <a
    1.29  	 href="#title" accesskey="t" title="T">先頭へ</a></p>
    1.30  	EOF
    1.31 -  query<<-EOF
    1.32 -	WITH mrt AS (
    1.33 -	 SELECT max(val) maxtime FROM article_s
    1.34 -	 WHERE key='ctime' AND id IN
    1.35 -		 (SELECT id FROM article
    1.36 -		  WHERE blogid=(select id from blog where rowid=$id))
    1.37 -	)
    1.38 -	SELECT 'A:'||
    1.39 -		(SELECT count(*) FROM tblaccesses
    1.40 -		 WHERE tbl='blog' AND tblrowid=$id) access,
    1.41 -	       'C:'||
    1.42 -	        (SELECT count(distinct user) FROM acclog
    1.43 -		 WHERE tbl='blog' AND tblrowid=$id
    1.44 -		       AND time > (SELECT maxtime from mrt)
    1.45 -		       AND user IN 
    1.46 -			  (SELECT user FROM grp_mem
    1.47 -			   WHERE gname = $(sqlquote "$blogowner")))
    1.48 -	       ;
    1.49 -	EOF
    1.50    $iswritable && cat<<-EOF
    1.51  	<div class="blogcomment">
    1.52  	<input type="hidden" name="blogid" value="$id">