"; printhtmlpageheader(); print "

録画ライブラリ表示

---

再生可能ライブラリを表示します。
"; } //新仕様 /* 2006/10/26 */ $query = " SELECT foltia_mp4files.tid,foltia_program.title , count(foltia_mp4files.mp4filename) FROM foltia_mp4files , foltia_program WHERE foltia_program.tid = foltia_mp4files.tid GROUP BY foltia_mp4files.tid ,foltia_program.title ORDER BY foltia_mp4files.tid DESC "; $rs = m_query($con, $query, "DBクエリに失敗しました"); $maxrows = pg_num_rows($rs); if ($maxrows > 0 ){ if(ereg("iPhone",$useragent)){ print "

"; }else{ print " "; } for ($row = 0; $row < $maxrows; $row++) { $rowdata = pg_fetch_row($rs, $row); $title = $rowdata[1]; $counts = $rowdata[2]; $tid = htmlspecialchars($rowdata[0]); $title = htmlspecialchars($title); $counts = htmlspecialchars($counts); if(ereg("iPhone",$useragent)){ print "
• $title
\n"; }else{ print " \n "; } }//for if(ereg("iPhone",$useragent)){ print "\n\n\n"; }else{ print "

TID	タイトル(内容リンク)	内容数	リンク
$tid	$title	$counts	しょぼかる-$tid

"; } }else{ print "録画ファイルが存在しません。"; }//end if /* //旧仕様 //ディレクトリからファイル一覧を取得 exec ("ls $recfolderpath | grep localized | sort -r", $libdir); //print "libdir:$libdir
\n"; foreach($libdir as $fName) { if(($fName == ".") or ($fName == "..") ){ continue; } if (ereg(".localized", $fName)){ $filesplit = split("\.",$fName); $query = " SELECT foltia_program.tid,foltia_program.title FROM foltia_program WHERE foltia_program.tid = $filesplit[0] "; $rs = m_query($con, $query, "DBクエリに失敗しました"); $rowdata = pg_fetch_row($rs, $row); //print" $fName./$rowdata[1]/$rowdata[2]/$rowdata[3]
\n"; $title = $rowdata[1]; $tid = htmlspecialchars($rowdata[0]); $title = htmlspecialchars($title); //-- print " $tid
$title "; //計数 $counts = system ("ls $recfolderpath/$fName/mp4/*.MP4 | wc -l"); print "
しょぼかる-$tid
\n "; }//end if ereg m2p }//end foreach //旧仕様ココまで */ //$d->close(); ?>