録画番組削除


削除番組はありません。

\n"; }else{ $userclass = getuserclass($con); if ( $userclass <= 1){ print "

次の番組を削除しました。

"; foreach ($delete as $fName) { $filesplit = split("-",$fName); if ($filesplit[1] == ""){ $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 = ? "; //$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]; $subtitle = ""; $count = ""; }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 = ? "; //$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]; $count = $rowdata[2]; $subtitle = $rowdata[3]; }//end if 話数がNULL $tid = htmlspecialchars($rowdata[0]); $title = htmlspecialchars($title); $count = htmlspecialchars($count); $subtitle = htmlspecialchars($subtitle); print " \n "; //DBから削除 if ($demomode){ }else{ $query = " DELETE FROM foltia_m2pfiles WHERE m2pfilename = ? "; //$rs = m_query($con, $query, "DBクエリに失敗しました"); $rs = sql_query($con, $query, "DBクエリに失敗しました",array($fName)); //削除処理 $oserr = system("$toolpath/perl/deletemovie.pl $fName"); }//end if demomode }//foreach print "
ファイル名 タイトル 話数 サブタイ
$fName
$title $count
$subtitle
\n"; }else{//権限なし print "

ファイル削除権限がありません。

"; } }//if $delete == "" ?>