録画一覧表示

---

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

キャプ\n"; } ?> \n"; if(($fName == ".") or ($fName == "..") ){ continue; } if ((ereg(".m2.+", $fName))|| (ereg(".aac", $fName))){ $filesplit = split("-",$fName); if (preg_match("/^\d+$/", $filesplit[0])) {// print "File is looks like good:preg
\n"; 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 = ? "; //$rs = m_query($con, $query, "DBクエリに失敗しました"); $rs = sql_query($con, $query, "DBクエリに失敗しました",array($filesplit[0])); $rall = $rs->fetchAll(); $rowdata = $rall[0]; //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 = ? AND foltia_subtitle.countno = ? "; //$rs = m_query($con, $query, "DBクエリに失敗しました"); $rs = sql_query($con, $query, "DBクエリに失敗しました",array($filesplit[0],$filesplit[1])); $rall = $rs->fetchAll(); $rowdata = $rall[0]; //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 "; }else{ //print "File is looks like BAD:preg
\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クエリに失敗しました"); $rs = sql_query($con, $query, "DBクエリに失敗しました"); $rowdata = $rs->fetch(); if ($rowdata) { do { $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 "
"; if (ereg("syabas",$useragent)){ print "$fName"; } else{ print "$fName
"; } if ($tid > 0){ print"$title $count
$subtitle
"; }else{ print"$title $count
$subtitle
"; } if (file_exists("./selectcaptureimage.php") ) { $capimgpath = preg_replace("/.m2.+/", "", $fName); print " キャプ\n"; } print "\n "; } while ($rowdata = $rs->fetch()); }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クエリに失敗しました"); $rs = sql_query($con, $query, "DBクエリに失敗しました"); $rowdata = $rs->fetch(); if ($rowdata) { print "

---

未読タイトルを表示します。

"; do { $tid = htmlspecialchars($rowdata[0]); $title = htmlspecialchars($rowdata[1]); print "\n"; } while ($rowdata = $rs->fetch()); print "

TID	タイトル
$tid	$title

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