Index: trunk/install/php/deletemovie.php
===================================================================
--- trunk/install/php/deletemovie.php (リビジョン 97)
+++ trunk/install/php/deletemovie.php (リビジョン 124)
@@ -75,29 +75,58 @@
";
-
-
-
foreach ($delete as $fName) {
- $filesplit = split("-",$fName);
-
-/*
-if ($filesplit[1] == ""){
+if( preg_match('/.MP4$/',$fName)){ //拡張子がMP4なら録画ライブラリ番組個別表示での削除 (showlibc.php)
$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 = ?
+SELECT
+foltia_subtitle.pspfilename,
+foltia_program.title,
+foltia_subtitle.countno,
+foltia_subtitle.subtitle
+FROM foltia_subtitle,foltia_program
+WHERE foltia_subtitle.tid = foltia_program.tid AND foltia_subtitle.pspfilename = ?
+LIMIT 1";
+
+$rs = sql_query($con, $query, "DBクエリに失敗しました",array($fName));
+$rall = $rs->fetch();
+$rowdata = $rall[0];
+
+$title = htmlspecialchars($rall[1]);
+$count = htmlspecialchars($rall[2]);
+$subtitle = htmlspecialchars($rall[3]);
+
+print "
+
+$fName
|
+";
+
+if ($tid > 0 ){
+ print "$title";
+}else{
+ print "$title";
+}
+
+print " |
+$count
|
+$subtitle
|
+
\n
";
-$rs = sql_query($con, $query, "DBクエリに失敗しました",array($filesplit[0]));
- $rall = $rs->fetchAll();
- //$rowdata = $rall[$row];
- $rowdata = $rall[0];
-$title = $rowdata[1];
-$subtitle = "";
-$count = "";
-*/
-//}else{
+
+//DBから削除
+if ($demomode){
+}else{
+
+$query = "
+DELETE FROM foltia_mp4files
+WHERE mp4filename = ?
+";
+//$rs = m_query($con, $query, "DBクエリに失敗しました");
+$rs = sql_query($con, $query, "DBクエリに失敗しました",array($fName));
+
+//削除処理
+$oserr = system("$toolpath/perl/deletemovie.pl $fName");
+}//end if demomode
+
+}else{ //拡張子がMP4以外なら 録画一覧(録画順・番組順)の削除(showplaylist.php)
$query = "
@@ -112,12 +141,8 @@
$rs = sql_query($con, $query, "DBクエリに失敗しました",array($fName));
$rall = $rs->fetchAll();
- //$rowdata = $rall[$row];
$rowdata = $rall[0];
-//print" $fName./$rowdata[1]/$rowdata[2]/$rowdata[3]
\n";
$title = $rowdata[1];
$count = $rowdata[2];
$subtitle = $rowdata[3];
-
-//}//end if 話数がNULL
$tid = htmlspecialchars($rowdata[0]);
@@ -158,4 +183,6 @@
}//end if demomode
+}//end if .MP4拡張子分岐
+
}//foreach
Index: trunk/install/php/showlibc.php
===================================================================
--- trunk/install/php/showlibc.php (リビジョン 119)
+++ trunk/install/php/showlibc.php (リビジョン 124)
@@ -64,8 +64,11 @@
}
-
+?>
+
+
+再生可能ムービーを表示します。
";
if ($tid == 0){
-print "$title 【この番組のFolcast [iTunesに登録】
\n";
+print "$title 【この番組のFolcast [iTunesに登録]】
\n";
}else{
print "$title 【この番組のFolcast [iTunesに登録]】
\n";
+ htmlspecialchars($tid) . "\" target=\"_blank\">$title
+【この番組のFolcast
+[iTunesに登録]】
\n";
}
}// endif if(ereg("iPhone",$useragent))
@@ -139,6 +144,14 @@
$serverfqdn = getserverfqdn();
+
//Autopager
echo "";
+?>
+
+