"; 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 = ? "; $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 "

キャプチャ画像

---

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