"; exit; } $query = " SELECT foltia_program.tid, stationname, foltia_program.title, foltia_subtitle.countno, foltia_subtitle.subtitle, foltia_subtitle.startdatetime , foltia_subtitle.lengthmin , foltia_subtitle.pid , foltia_subtitle.m2pfilename , foltia_subtitle.pspfilename FROM foltia_subtitle , foltia_program ,foltia_station WHERE foltia_program.tid = foltia_subtitle.tid AND foltia_station.stationid = foltia_subtitle.stationid AND foltia_subtitle.pid = ? "; // $rs = m_query($con, $query, "DBクエリに失敗しました"); $rs = sql_query($con, $query, "DBクエリに失敗しました",array($pid)); $rows = pg_num_rows($rs); if ($rows == 0){ print "

書き込み編集

録画記録がありません。
"; }else{ $rowdata = pg_fetch_row($rs, 0); print "

書き込み編集

"; print ""; $title = htmlspecialchars($rowdata[2]); $countno = htmlspecialchars($rowdata[3]); print "$title $countno " ; $tid = $rowdata[0]; $subtitle = htmlspecialchars($rowdata[4]) ; if ($tid > 0){ print "$subtitle "; }else{ print "$subtitle "; } print htmlspecialchars($rowdata[1]) . " "; print htmlspecialchars($rowdata[6]) . "分 "; print htmlspecialchars(foldate2print($rowdata[5])); print "

"; $mp4filename = $rowdata[9]; $serverfqdn = getserverfqdn(); $m2pfilename = $rowdata[8]; list($tid,$countno,$date,$time)= split ("-", $m2pfilename ); $tid = ereg_replace("[^0-9]", "", $tid); $path = ereg_replace("\.m2p$", "", $m2pfilename); $serveruri = getserverfqdn (); print "

\n"; //画像 print "$tid:$countno:$filetid\n"; if (getform(preview) == 1){ //プレビュー表示 // htmlspecialchars(stripslashes( )) $subject = getform(subject); $maintext = $_POST["textarea"]; $maintext = pg_escape_string($maintext); //$maintext = mbereg_replace("\n","
\n", $maintext); $rate = getform(rank4); switch ($rate) { case -2: $ratechara = "× "; break; case -1: $ratechara = "▲ "; break; case 0: $ratechara = "− "; break; case 1: $ratechara = "★ "; break; case 2: $ratechara = "★★ "; break; case 3: $ratechara = "★★★ "; break; case 4: $ratechara = "★★★★ "; break; default: $ratechara = "− "; } $subject = $ratechara . $subject; print "". htmlspecialchars(stripslashes( $subject)) ."\n"; print "". stripslashes( $maintext) ."
\n"; print "
\n"; print "本文(source view):
". htmlspecialchars(stripslashes( $maintext)) ."



\n"; print "
[ Send Picture Only ] [ ]
"; }else{//編集書き込みモード //タイトル if ($tid == 0){ $subjects = "「".$subtitle."」"; }else{ if ($countno == ""){ $subjects = "$title 「".$subtitle."」"; }else{ $subjects = "$title ＃". $countno ." 「".$subtitle."」"; } } print "




"; }//プレビュー表示かどうか /* ToDo ・Formプレビュー ・パブリッシュボタン ・ */ // タイトル一覧　ここまで }//if rowdata == 0 ?>