録画一覧表示

---

再生可能番組リストを表示します。

キャプ\n"; } ?> \n"; if(($fName == ".") or ($fName == "..") ){ continue; } if (ereg(".m2p", $fName)){ $filesplit = split("-",$fName); if ($filesplit[1] == ""){ $query = " SELECT foltia_program.tid,foltia_program.title,foltia_subtitle.subtitle FROM foltia_subtitle , foltia_program WHERE foltia_program.tid = foltia_subtitle.tid AND foltia_subtitle.tid = $filesplit[0] "; $rs = m_query($con, $query, "DBクエリに失敗しました"); $rowdata = pg_fetch_row($rs, $row); //print" $fName./$rowdata[1]//$rowdata[2]
\n"; $title = $rowdata[1]; $subtitle = ""; $count = ""; }else{ $query = " SELECT foltia_program.tid,foltia_program.title,foltia_subtitle.countno,foltia_subtitle.subtitle FROM foltia_subtitle , foltia_program WHERE foltia_program.tid = foltia_subtitle.tid AND foltia_subtitle.tid = $filesplit[0] AND foltia_subtitle.countno = $filesplit[1] "; $rs = m_query($con, $query, "DBクエリに失敗しました"); $rowdata = pg_fetch_row($rs, $row); //print" $fName./$rowdata[1]/$rowdata[2]/$rowdata[3]
\n"; $title = $rowdata[1]; $count = $rowdata[2]; $subtitle = $rowdata[3]; }//if 話数あるかどうか $tid = htmlspecialchars($rowdata[0]); $title = htmlspecialchars($title); $count = htmlspecialchars($count); $subtitle = htmlspecialchars($subtitle); //-- print " "; if (file_exists("./selectcaptureimage.php") ) { // $capimgpath = preg_replace("/.m2p/", "", $fName); print " \n"; } print "\n "; }//ereg }//foreach print " \n

削除	ファイル名	タイトル	話数	サブタイ
	$fName	$title	$count	$subtitle	N/A

\n

\n\n\n"; exit; }elseif ($list== "title"){//新仕様 $query = " SELECT foltia_program.tid, foltia_program.title, foltia_subtitle.countno, foltia_subtitle.subtitle , foltia_m2pfiles.m2pfilename , foltia_subtitle.pid FROM foltia_subtitle , foltia_program , foltia_m2pfiles WHERE foltia_program.tid = foltia_subtitle.tid AND foltia_subtitle.m2pfilename = foltia_m2pfiles.m2pfilename ORDER BY foltia_subtitle.tid DESC , foltia_subtitle.startdatetime ASC "; }else{ $query = " SELECT foltia_program.tid, foltia_program.title, foltia_subtitle.countno, foltia_subtitle.subtitle , foltia_m2pfiles.m2pfilename , foltia_subtitle.pid FROM foltia_subtitle , foltia_program , foltia_m2pfiles WHERE foltia_program.tid = foltia_subtitle.tid AND foltia_subtitle.m2pfilename = foltia_m2pfiles.m2pfilename ORDER BY foltia_subtitle.startdatetime DESC "; } $rs = m_query($con, $query, "DBクエリに失敗しました"); $maxrows = pg_num_rows($rs); if ($maxrows > 0){ for ($row = 0; $row < $maxrows; $row++) { $rowdata = pg_fetch_row($rs, $row); $tid = htmlspecialchars($rowdata[0]); $title = htmlspecialchars($rowdata[1]); $count = htmlspecialchars($rowdata[2]); $subtitle = htmlspecialchars($rowdata[3]); $fName = htmlspecialchars($rowdata[4]); $pid = htmlspecialchars($rowdata[5]); //-- print "
$fName
"; if ($tid > 0){ print"$title $count
$subtitle
"; }else{ print"$title $count
$subtitle
"; } if (file_exists("./selectcaptureimage.php") ) { $capimgpath = preg_replace("/.m2p/", "", $fName); print " キャプ\n"; } print "\n "; }//for }else{ print " ファイルがありません "; }//end if print " \n"; //番組ソートの時、未読番組のタイトルだけ表示 if ($list== "title"){ $query = " SELECT distinct foltia_program.tid, foltia_program.title FROM foltia_subtitle , foltia_program , foltia_m2pfiles WHERE foltia_program.tid = foltia_subtitle.tid AND foltia_subtitle.m2pfilename = foltia_m2pfiles.m2pfilename ORDER BY foltia_program.tid DESC "; $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); $tid = htmlspecialchars($rowdata[0]); $title = htmlspecialchars($rowdata[1]); print "\n"; }//for print "

TID	タイトル
$tid	$title

\n"; }//if maxrows }//if title ?>