";
printhtmlpageheader();
print "
録画ライブラリ番組個別表示
再生可能ムービーを表示します。
";
if ($tid == 0){
print "$title 【この番組のFolcast [iTunesに登録】
\n";
}else{
print "$title 【この番組のFolcast [iTunesに登録]】
\n";
}
}// endif if(ereg("iPhone",$useragent))
//確認
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();
//Autopager
echo "
";
/////////////////////////////////////////////////////////
//レコード総数取得
$query = "
SELECT
COUNT(*) AS cnt
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 = ?
";
$rs = sql_query($con, $query, "DBクエリに失敗しました",array($tid));
$rowdata = $rs->fetch();
$dtcnt = htmlspecialchars($rowdata[0]);
//echo $dtcnt;
//
if (! $rowdata) {
die_exit("番組データがありません。
");
}//endif
//////////////////////////////////////////////////////////
//レコード表示
$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 = ?
ORDER BY \"startdatetime\" ASC
LIMIT $lim OFFSET $st
";
$rs = "";
//$rs = m_query($con, $query, "DBクエリに失敗しました");
$rs = sql_query($con, $query, "DBクエリに失敗しました",array($tid));
$rowdata = $rs->fetch();
if ($rowdata) {
if(ereg("iPhone",$useragent)){
print "
";
}else{
print "
";
}
do {
$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);
$pid = htmlspecialchars($rowdata[6]);
$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 = $rs ->rowCount();
$caplink = "";
if ($sbpluginexist == 1) {
//$capimgpath = htmlspecialchars(preg_replace("/.m2p/", "", $rowdata[5]));
$capimgpath = htmlspecialchars(preg_replace("/.m2./", "", $rowdata[5]));
if (($capimgpath != "") && (file_exists("$recfolderpath/$tid.localized/img/$capimgpath") )){
$caplink = " / キャプ";
}else{
$caplink = " / キャプなし";
}
}else{
$caplink = "";
}//end if sb
if (file_exists("$recfolderpath/$tid.localized/mp4/$thumbnail") ){
$imgsrcuri = "$httpmediamappath/$tid.localized/mp4/$thumbnail\" alt=\"$title $count $subtitle";
}else{
$imgsrcuri = "./img/no-thumbnail-img.png\" alt=\"NO IMAGE";
}
if(ereg("iPhone",$useragent)){
print "- $count $subtitle $onairdate
\n";
}else{
print "
![](\"$imgsrcuri\") |
$count |
";
if ($tid == 0){
print "\n | $subtitle | ";
}else{
print "\n $subtitle | ";
}//if
print "
| $onairdate |
| $fName / Player / $caplink |
";
}//endif iPhone
} while ($rowdata = $rs->fetch());
}else{
print "録画ファイルがありません
\n";
}//if
if(ereg("iPhone",$useragent)){
print "- 一覧へ戻る
\n";
print "\n";
}else{
print "
\n";
}
//////////////////////////////////////////////
//クエリ代入
$query_st = $tid;
//Autopager処理とページのリンク表示
page_display($query_st,$p,$p2,$lim,$dtcnt,"");
//////////////////////////////////////////////
?>