Index: trunk/install/php/deletemovie.php
===================================================================
--- trunk/install/php/deletemovie.php (リビジョン 94)
+++ trunk/install/php/deletemovie.php (リビジョン 97)
@@ -82,4 +82,5 @@
$filesplit = split("-",$fName);
+/*
if ($filesplit[1] == ""){
$query = "
@@ -90,26 +91,27 @@
AND foltia_subtitle.tid = ?
";
-//$rs = m_query($con, $query, "DBクエリに失敗しました");
$rs = sql_query($con, $query, "DBクエリに失敗しました",array($filesplit[0]));
$rall = $rs->fetchAll();
- $rowdata = $rall[$row];
-//print" $fName./$rowdata[1]//$rowdata[2]
\n";
+ //$rowdata = $rall[$row];
+ $rowdata = $rall[0];
$title = $rowdata[1];
$subtitle = "";
$count = "";
-}else{
+*/
+//}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 = ?
+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.m2pfilename = ?
";
+
//$rs = m_query($con, $query, "DBクエリに失敗しました");
-$rs = sql_query($con, $query, "DBクエリに失敗しました",array($filesplit[0] ,$filesplit[1]));
+//$rs = sql_query($con, $query, "DBクエリに失敗しました",array($filesplit[0] ,$filesplit[1]));
+$rs = sql_query($con, $query, "DBクエリに失敗しました",array($fName));
$rall = $rs->fetchAll();
- $rowdata = $rall[$row];
+ //$rowdata = $rall[$row];
+ $rowdata = $rall[0];
//print" $fName./$rowdata[1]/$rowdata[2]/$rowdata[3]
\n";
$title = $rowdata[1];
@@ -117,5 +119,5 @@
$subtitle = $rowdata[3];
-}//end if 話数がNULL
+//}//end if 話数がNULL
$tid = htmlspecialchars($rowdata[0]);
@@ -127,5 +129,13 @@