"; exit; } $con = m_connect(); $query = " SELECT foltia_program.tid, stationname, 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 ,foltia_station WHERE foltia_program.tid = foltia_subtitle.tid AND foltia_station.stationid = foltia_subtitle.stationid AND foltia_subtitle.pid = '$pid' "; $rs = m_query($con, $query, "DBクエリに失敗しました"); $rowdata = pg_fetch_row($rs, 0); print "

キャプチャ画像


"; print ""; print htmlspecialchars($rowdata[2]) . " " ; print htmlspecialchars($rowdata[3]) . " "; $tid = $rowdata[0]; if ($tid > 0){ print ""; print htmlspecialchars($rowdata[4]) . " "; }else{ print htmlspecialchars($rowdata[4]) . " "; } print htmlspecialchars($rowdata[1]) . " "; print htmlspecialchars($rowdata[6]) . "分 "; print htmlspecialchars(foldate2print($rowdata[5])); $mp4filename = $rowdata[9]; $serverfqdn = getserverfqdn(); print "  再生:$mp4filename /
"; $m2pfilename = $rowdata[8]; list($tid,$countno,$date,$time)= split ("-", $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); //$timecount = 1; foreach($tids as $filetid) { print "$tid:$countno:$filetid\n"; /* $i++ ; if ($i > 3){ print "
\n"; $i = 0; //$timecount++ ; } */ }//foreach // タイトル一覧 ここまで // ファイル一覧 ここから ?>