録画ライブラリ番組個別表示
再生可能ムービーを表示します。
.*<\/Title>/", $syobocaldb,$title);
$title = $title[0];
$title = strip_tags($title);
}else{
$rowdata = pg_fetch_row($rs, 0);
$title = $rowdata[0];
}
print "" .
htmlspecialchars($title) . " 【この番組のFolcast】
\n";
//確認
if (file_exists ("$recfolderpath/$tid.localized")){
// print "ディレクトリは存在します\n";
}else{
// print "ディレクトリはありません\n";
print "再生可能番組がありません
\n";
exit;
}
//新仕様/* 2006/10/26 */
if (file_exists("./selectcaptureimage.php") ) {
$sbpluginexist = 1;
}
$serverfqdn = getserverfqdn();
$query = "
SELECT
foltia_program.tid,
foltia_program.title,
foltia_subtitle.countno,
foltia_subtitle.subtitle,
foltia_subtitle.startdatetime ,
foltia_subtitle.m2pfilename ,
foltia_subtitle.pid ,
foltia_mp4files.mp4filename
FROM foltia_mp4files
LEFT JOIN foltia_subtitle
ON foltia_mp4files.mp4filename = foltia_subtitle.pspfilename
LEFT JOIN foltia_program
ON foltia_mp4files.tid = foltia_program.tid
WHERE foltia_mp4files.tid = $tid
ORDER BY \"startdatetime\" ASC
";
$rs = "";
$rs = m_query($con, $query, "DBクエリに失敗しました");
$maxrows = pg_num_rows($rs);
if ($maxrows > 0 ){
print "
";
for ($row = 0; $row < $maxrows; $row++) {
$rowdata = pg_fetch_row($rs, $row);
$title = $rowdata[1];
if ($rowdata[2]== "" ){
$count = "[話数]";
}else{
$count = $rowdata[2];
}
if ($rowdata[3]== "" ){
$subtitle = "[サブタイトル]";
}else{
$subtitle = $rowdata[3];
}
$onairdate = $rowdata[4];
$tid = htmlspecialchars($rowdata[0]);
$title = htmlspecialchars($title);
$count = htmlspecialchars($count);
$subtitle = htmlspecialchars($subtitle);
$onairdate = htmlspecialchars($onairdate);
$fName = htmlspecialchars($rowdata[7]);
if (ereg(".MP4", $fName)){
$thumbnail = $fName;
$thumbnail = ereg_replace(".MP4", ".THM", $thumbnail);
}
if ($onairdate == ""){
$onairdate = "[放送日]";
}else{
$day = substr($onairdate,0,4)."/".substr($onairdate,4,2)."/".substr($onairdate,6,2);
$time = substr($onairdate,8,2).":".substr($onairdate,10,2);
$onairdate = "$day $time";
}
//Starlight Breaker向け拡張
//$debug_pg_num_rows = pg_num_rows ($rs );
$caplink = "";
if (($sbpluginexist == 1) && (pg_num_rows ($rs ) > 0)){
$capimgpath = htmlspecialchars(preg_replace("/.m2p/", "", $rowdata[5]));
if (file_exists("$recfolderpath/$tid.localized/img/$capimgpath") ){
$caplink = " / キャプ";
}else{
$caplink = " / キャプなし";
}
}else{
$caplink = "";
}//end if sb
print "
![](\"$httpmediamappath/$tid.localized/mp4/$thumbnail\") |
$count |
| $subtitle |
| $onairdate |
| $fName / $caplink |
";
}//for
}else{
print "録画ファイルがありません
\n";
}//if
//旧仕様
/*
//ディレクトリからファイル一覧を取得
exec ("ls $recfolderpath/$tid.localized/mp4/*.MP4", $mp4files);
if (file_exists("./selectcaptureimage.php") ) {
$sbpluginexist = 1;
}
$serverfqdn = getserverfqdn();
foreach($mp4files as $pathfName) {
$fName = "";
$fNametmp = split("/",$pathfName);
$fName = array_pop($fNametmp);
if(($fName == ".") or ($fName == "..") ){ continue; }
if (ereg(".MP4", $fName)){
$thumbnail = $fName;
$thumbnail = ereg_replace(".MP4", ".THM", $thumbnail);
// $filesplit = split("-",$fName);
//print "\n";
$query = "";
$query = "
SELECT
foltia_program.tid,
foltia_program.title,
foltia_subtitle.countno,
foltia_subtitle.subtitle,
foltia_subtitle.startdatetime ,
foltia_subtitle.m2pfilename ,
foltia_subtitle.pid
FROM foltia_subtitle , foltia_program
WHERE foltia_subtitle.pspfilename = '$fName'
AND foltia_program.tid = foltia_subtitle.tid
AND foltia_program.tid = $tid
";
//print "\n";
$rs = "";
$rs = m_query($con, $query, "DBクエリに失敗しました");
if (pg_num_rows ($rs ) == 0){
$count = "[話数]";
$subtitle = "[サブタイトル]";
$onairdate = "[放映日]";
$caplink = "";
}else{
$rowdata = pg_fetch_row($rs, $row);
$title = $rowdata[1];
if ($rowdata[2]== "" ){
$count = "[話数]";
}else{
$count = $rowdata[2];
}
if ($rowdata[3]== "" ){
$subtitle = "[サブタイトル]";
}else{
$subtitle = $rowdata[3];
}
$onairdate = $rowdata[4];
$tid = htmlspecialchars($rowdata[0]);
$title = htmlspecialchars($title);
$count = htmlspecialchars($count);
$subtitle = htmlspecialchars($subtitle);
$onairdate = htmlspecialchars($onairdate);
$day = substr($onairdate,0,4)."/".substr($onairdate,4,2)."/".substr($onairdate,6,2);
$time = substr($onairdate,8,2).":".substr($onairdate,10,2);
$onairdate = "$day $time";
//Starlight Breaker向け拡張
//$debug_pg_num_rows = pg_num_rows ($rs );
$caplink = "";
if (($sbpluginexist == 1) && (pg_num_rows ($rs ) > 0)){
$capimgpath = htmlspecialchars(preg_replace("/.m2p/", "", $rowdata[5]));
if (file_exists("$recfolderpath/$tid.localized/img/$capimgpath") ){
$caplink = " / キャプ";
}else{
$caplink = " / キャプなし";
}
}else{
$caplink = "";
}//end if sb
} //end if 検索件数が0のとき
//--
print "
|
$count |
| $subtitle |
| $onairdate |
| $fName / $caplink |
";
}//end if ereg m2p
}//end foreach
*/
//旧仕様ココまで
?>