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 【この番組のFolcastiTunesに登録]】
\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 "
"; +?> + +
+

+ + +$subtitle"; }//if + + print " @@ -276,7 +293,11 @@ - $fName / Player / $caplink + 削除 / + $fName / + Player / + $caplink "; + }//endif iPhone @@ -301,4 +322,5 @@ ////////////////////////////////////////////// ?> +