録画一覧表示

---

再生可能番組リストを表示します。
"; ////////////////////////////////////////// ?>

キャプ\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 LIMIT $lim OFFSET $st "; }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 LIMIT $lim OFFSET $st "; } //$rs = m_query($con, $query, "DBクエリに失敗しました"); $rs = sql_query($con, $query, "DBクエリに失敗しました"); $rowdata = $rs->fetch(); ///////////////////////////////////////// //テーブルの総数取得 $query2 = " SELECT COUNT(*) AS cnt FROM foltia_subtitle , foltia_program , foltia_m2pfiles WHERE foltia_program.tid = foltia_subtitle.tid AND foltia_subtitle.m2pfilename = foltia_m2pfiles.m2pfilename "; $rs2 = sql_query($con, $query2, "DB\?\ｨ\e?E?oCO???T????"); $rowdata2 = $rs2->fetch(); if (! $rowdata2) { die_exit("番組データがありません
"); } //1O?o?eAA $dtcnt = $rowdata2[0]; ///////////////////////////////////////// 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"; ////////////////////////////////////////////////////////////////////// //クエリ代入 $query_st = $list; //Autopageing処理とページのリンクを表示 list($p2,$page) = page_display($query_st,$p,$p2,$lim,$dtcnt,""); ////////////////////////////////////////////////////////////////////// print "