Index: trunk/install/php/selectcaptureimage.php
===================================================================
--- trunk/install/php/selectcaptureimage.php (リビジョン 126)
+++ trunk/install/php/selectcaptureimage.php (リビジョン 1)
@@ -13,4 +13,8 @@
 mplayer -ss 00:00:10 -vo jpeg:outdir=/home/foltia/php/tv/691.localized/img/6/ -vf crop=702:468:6:6,scale=160:120,pp=lb  -ao null -sstep 14  -v 3 /home/foltia/php/tv/691-6-20060216-0130.m2p
 
+旧仕様
+mplayer -ss 00:0:10 -vo jpeg:outdir=./ -ao null -sstep 14  -v 3 ../665-13-20051230-0145.m2p 
+convert -verbose  -crop 160x120+1+3 -resize 165x126\!  ../*.jpg 
+
  DCC-JPL Japan/foltia project
 
@@ -18,19 +22,8 @@
 
 include("./foltialib.php");
-$con = m_connect();
 
-if ($useenvironmentpolicy == 1){
-	if (!isset($_SERVER['PHP_AUTH_USER'])) {
-	    header("WWW-Authenticate: Basic realm=\"foltia\"");
-	    header("HTTP/1.0 401 Unauthorized");
-		redirectlogin();
-	    exit;
-	} else {
-	login($con,$_SERVER['PHP_AUTH_USER'],$_SERVER['PHP_AUTH_PW']);
-	}
-}//end if login
-
-
-$pid = getgetnumform(pid);
+//$tid = getgetnumform(tid);
+//$path = getgetform(d);
+$pid = getgetform(pid);
 
 if ($pid == "") {
@@ -59,4 +52,6 @@
 }
 
+
+$con = m_connect();
 $query = "
 SELECT 
@@ -73,52 +68,17 @@
 FROM foltia_subtitle , foltia_program ,foltia_station  
 WHERE foltia_program.tid = foltia_subtitle.tid AND foltia_station.stationid = foltia_subtitle.stationid 
-AND foltia_subtitle.pid = ?  
-";
-$rs = sql_query($con, $query, "DBクエリに失敗しました",array($pid));
-$rowdata = $rs->fetch();
-
-if (! $rowdata) {
-$query = "
-SELECT 
-foltia_program.tid,
-foltia_program.tid,
-foltia_program.title,
-foltia_subtitle.countno,
-foltia_subtitle.subtitle,
-foltia_subtitle.startdatetime ,
-foltia_subtitle.lengthmin  , 
-foltia_subtitle.pid ,
-foltia_subtitle.m2pfilename , 
-foltia_subtitle.pspfilename 
-FROM foltia_subtitle , foltia_program  
-WHERE foltia_program.tid = foltia_subtitle.tid 
-AND foltia_subtitle.pid = ?  
-";
-
-$rs = sql_query($con, $query, "DBクエリに失敗しました",array($pid));
-$rowdata = $rs->fetch();
-	if (! $rowdata) {
-		print "  <p align=\"left\"><font color=\"#494949\" size=\"6\">キャプチャ画像</font></p>
-	  <hr size=\"4\">
-	<p align=\"left\">
-	録画記録がありません。<br></body></html>";
-	exit ;
-	}
-$rowdata[1] = "";
-}//end if (! $rowdata) 
+ AND foltia_subtitle.pid = '$pid'  
+ 
+	";
+	$rs = m_query($con, $query, "DBクエリに失敗しました");
+	$rowdata = pg_fetch_row($rs, 0);
 
 print "  <p align=\"left\"><font color=\"#494949\" size=\"6\">キャプチャ画像</font></p>
   <hr size=\"4\">
 <p align=\"left\">";
-print "<a href = \"http://cal.syoboi.jp/tid/$rowdata[0]/\" target=\"_blank\">";
+print "<a href = \"http://cal.syoboi.jp/tid/$rowdata[0]/time#$pid\" target=\"_blank\">";
 print htmlspecialchars($rowdata[2]) . "</a> " ;
 print htmlspecialchars($rowdata[3]) . " ";
-$tid = $rowdata[0];
-if ($tid > 0){
-print "<a href = \"http://cal.syoboi.jp/tid/$tid/time#$pid\" target=\"_blank\">";
-print htmlspecialchars($rowdata[4]) . "</a> ";
-}else{
 print htmlspecialchars($rowdata[4]) . " ";
-}
 print htmlspecialchars($rowdata[1]) . " ";
 print htmlspecialchars($rowdata[6]) . "分 ";
@@ -126,33 +86,44 @@
 
 $mp4filename = $rowdata[9];
+$tid = $rowdata[0];
 $serverfqdn = getserverfqdn();
 
-print "　　再生:<A HREF=\"$httpmediamappath/$tid.localized/mp4/$mp4filename\" target=\"_blank\">$mp4filename</A> / <script language=\"JavaScript\" type=\"text/javascript\">QT_WriteOBJECT_XHTML('http://g.hatena.ne.jp/images/podcasting.gif','16','16','','controller','FALSE','href','http://$serverfqdn/$httpmediamappath/$tid.localized/mp4/$mp4filename','target','QuickTimePlayer','type','video/mp4');</script> / <a href=\"./mp4player.php?p=$pid\" target=\"_blank\">Player</a><br>";
+print "　　再生:<A HREF=\"$httpmediamappath/$tid.localized/mp4/$mp4filename\" target=\"_blank\">$mp4filename</A> / <script language=\"JavaScript\" type=\"text/javascript\">QT_WriteOBJECT_XHTML('http://g.hatena.ne.jp/images/podcasting.gif','16','16','','controller','FALSE','href','http://$serverfqdn/$httpmediamappath/$tid.localized/mp4/$mp4filename','target','QuickTimePlayer','type','video/mp4');</script><br>";
 
 $m2pfilename = $rowdata[8];
 
 list($tid,$countno,$date,$time)= split ("-", $m2pfilename );
-//	$tid = ereg_replace("[^0-9]", "", $tid);
-$tid = $rowdata[0];
-$countno = $rowdata[3] ;
-$path = ereg_replace("\.m2p$|\.m2t$", "", $m2pfilename);
+	$tid = ereg_replace("[^0-9]", "", $tid);
+//if ($countno == "x"){
+//}else{
+//	$countno = ereg_replace("[^0-9]", "", $countno);
+//}
+//	$date = ereg_replace("[^0-9]", "", $date);
+//	$time = ereg_replace("[^0-9]", "", $time);
+//$path = $tid."-".$countno."-".$date."-".$time ;
+$path = ereg_replace("\.m2p$", "", $m2pfilename);
 $serveruri = getserverfqdn ();
 
-exec ("ls $recfolderpath/$tid.localized/img/$path/", $tids);
+exec ("ls   $recfolderpath/$tid.localized/img/$path/", $tids);
 //$timecount = 1;
 foreach($tids as $filetid) {
-
-if (file_exists("./sb-edit.php") ) {
-print "<a href=\"./sb-edit.php?pid=$pid&f=$filetid\"><img src='http://$serveruri$httpmediamappath/$tid.localized/img/$path/$filetid' alt='$tid:$countno:$filetid'></a>\n";
-}else{
-print "<img src='http://$serveruri$httpmediamappath/$tid.localized/img/$path/$filetid'  alt='$tid:$countno:$filetid'>\n";
+print "<IMG SRC='http://$serveruri$httpmediamappath/$tid.localized/img/$path/$filetid' WIDTH='160' HEIGHT='120'  ALT='$tid:$countno:$filetid'>\n";
+/*
+$i++ ;
+if ($i > 3){
+ print "<br>\n";
+$i = 0;
+//$timecount++ ;
 }
+*/
 }//foreach
 // タイトル一覧　ここまで
 
+// ファイル一覧　ここから
+?>
 
-?>
+
+
 
 </body>
 </html>
-