Index: trunk/install/php/deletemovie.php
===================================================================
--- trunk/install/php/deletemovie.php (リビジョン 76)
+++ trunk/install/php/deletemovie.php (リビジョン 94)
@@ -88,8 +88,10 @@
FROM foltia_subtitle , foltia_program
WHERE foltia_program.tid = foltia_subtitle.tid
- AND foltia_subtitle.tid = $filesplit[0]
+ AND foltia_subtitle.tid = ?
";
-$rs = m_query($con, $query, "DBクエリに失敗しました");
-$rowdata = pg_fetch_row($rs, $row);
+//$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";
$title = $rowdata[1];
@@ -103,9 +105,11 @@
FROM foltia_subtitle , foltia_program
WHERE foltia_program.tid = foltia_subtitle.tid
- AND foltia_subtitle.tid = $filesplit[0]
- AND foltia_subtitle.countno = $filesplit[1]
+ AND foltia_subtitle.tid = ?
+ AND foltia_subtitle.countno = ?
";
-$rs = m_query($con, $query, "DBクエリに失敗しました");
-$rowdata = pg_fetch_row($rs, $row);
+//$rs = m_query($con, $query, "DBクエリに失敗しました");
+$rs = sql_query($con, $query, "DBクエリに失敗しました",array($filesplit[0] ,$filesplit[1]));
+ $rall = $rs->fetchAll();
+ $rowdata = $rall[$row];
//print" $fName./$rowdata[1]/$rowdata[2]/$rowdata[3]
\n";
$title = $rowdata[1];
@@ -119,7 +123,4 @@
$count = htmlspecialchars($count);
$subtitle = htmlspecialchars($subtitle);
-
-//--
-
print "
@@ -138,7 +139,8 @@
$query = "
DELETE FROM foltia_m2pfiles
-WHERE m2pfilename = '$fName'
+WHERE m2pfilename = ?
";
-$rs = m_query($con, $query, "DBクエリに失敗しました");
+//$rs = m_query($con, $query, "DBクエリに失敗しました");
+$rs = sql_query($con, $query, "DBクエリに失敗しました",array($fName));
//削除処理