Mercurial > hgrepos > hgweb.cgi > s4

changeset 364:05641ff595f6

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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 wrap: on
line diff
--- a/s4-blog.sh	Sun Nov 13 22:51:37 2016 +0859
+++ b/s4-blog.sh	Tue Nov 22 08:25:49 2016 +0859
@@ -192,7 +192,6 @@
     nt="<label style=\"font-size: 70%;\"><input type=\"checkbox\"
 	 name=\"notifyto\" value=\"$uid\">返信通知送信</label>"
     tdcls="repatt${new:+ new}"
-    imgdir=`getcachedir home/"$uid"`/main
     if [ -n "$icon" -a -s "$icon" ]; then
       icfn=`echo "$icon"|htmlescape`
       picon="<p class=\"proficon\"><a href=\"$hlink+$uid\"><img src=\"$icfn\"></a></p>"
@@ -218,7 +217,6 @@
       mrid=${i%%:*}; i=${i#*:}; sz=`size_h ${i%%:*}`
       fn=`echo "${i#*:}"|unhexize`
       fnb=$fn"(${sz})"
-      # echo r=$mrid fn=$fn
       case "$fn" in
 	*.[Pp][Nn][Gg]|*.[Jj][Pp][Gg]|*.[Jj][Pp][Ee][Gg]|*.[Gg][Ii][Ff])
 	  #  fmt=${fn##*.}	# convert - jpg:- is slow...why
@@ -236,7 +234,6 @@
 		 { [ "$usecache" ] ||	# And usecache flag is true, or...
 		       { [ -s "$tsfile" ] && [ x"`cat $tsfile`" = x"$tm" ]
 		       };}; then
-	    # err Set usecache=1
 	    usecache=1		# Set usecache flag on
 	    cat<<-EOF
 		<a href="$catlink+$mrid"><img src="$outfile">
@@ -281,25 +278,6 @@
 	 href="?reload/$rowid" accesskey="r" title="R">再読込</a> / <a
 	 href="#title" accesskey="t" title="T">先頭へ</a></p>
 	EOF
-  query<<-EOF
-	WITH mrt AS (
-	 SELECT max(val) maxtime FROM article_s
-	 WHERE key='ctime' AND id IN
-		 (SELECT id FROM article
-		  WHERE blogid=(select id from blog where rowid=$id))
-	)
-	SELECT 'A:'||
-		(SELECT count(*) FROM tblaccesses
-		 WHERE tbl='blog' AND tblrowid=$id) access,
-	       'C:'||
-	        (SELECT count(distinct user) FROM acclog
-		 WHERE tbl='blog' AND tblrowid=$id
-		       AND time > (SELECT maxtime from mrt)
-		       AND user IN 
-			  (SELECT user FROM grp_mem
-			   WHERE gname = $(sqlquote "$blogowner")))
-	       ;
-	EOF
   $iswritable && cat<<-EOF
 	<div class="blogcomment">
 	<input type="hidden" name="blogid" value="$id">

yatex.org