Index: trunk/install/php/delepgp.php =================================================================== --- trunk/install/php/delepgp.php (リビジョン 107) +++ trunk/install/php/delepgp.php (リビジョン 1) @@ -16,20 +16,4 @@ */ - -include("./foltialib.php"); -$con = m_connect(); - -if ($useenvironmentpolicy == 1){ -if (!isset($_SERVER['PHP_AUTH_USER'])) { - header("WWW-Authenticate: Basic realm=\"foltia\""); - header("HTTP/1.0 401 Unauthorized"); - redirectlogin(); - exit; -} else { -login($con,$_SERVER['PHP_AUTH_USER'],$_SERVER['PHP_AUTH_PW']); -} -}//end if login - - ?> @@ -41,17 +25,21 @@ foltia:delete EPG Program - "); } +$con = m_connect(); $now = date("YmdHi"); +?> + +fetch(); - $rs->closeCursor(); - - if (!is_array($rowdata) || empty($rowdata)) { - die_exit("登録番組がありません
"); + $rs = m_query($con, $query, "DBクエリに失敗しました"); + $maxrows = pg_num_rows($rs); + + if ($maxrows == 0) { + die_exit("登録番組がありません
"); } + $rowdata = pg_fetch_row($rs, 0); $pid = htmlspecialchars($rowdata[0]); @@ -115,7 +102,6 @@ DELETE FROM foltia_subtitle - WHERE foltia_subtitle.pid = ? AND foltia_subtitle.tid = 0 "; -// $rs = m_query($con, $query, "DBクエリに失敗しました"); - $rs = sql_query($con, $query, "DBクエリに失敗しました",array($pid)); + WHERE foltia_subtitle.pid = $pid AND foltia_subtitle.tid = 0 "; + $rs = m_query($con, $query, "DBクエリに失敗しました"); } }else{