foltia:recorded file list "; $now = date("YmdHi"); ?>

録画一覧表示


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

キャプ\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 ?>