"; exit; } $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クエリに失敗しました"); $rows = pg_num_rows($rs); if ($rows == 0){ print "

キャプチャ画像


録画記録がありません。
"; }else{ $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); $path = ereg_replace("\.m2p$", "", $m2pfilename); $serveruri = getserverfqdn (); exec ("ls $recfolderpath/$tid.localized/img/$path/", $tids); //$timecount = 1; foreach($tids as $filetid) { if (file_exists("./sb-edit.php") ) { print "$tid:$countno:$filetid\n"; }else{ print "$tid:$countno:$filetid\n"; } }//foreach // タイトル一覧 ここまで }//if rowdata == 0 ?>