|0|0|http://servername/foltia/tv/filename.m2p| 参考URL http://www.geocities.co.jp/SiliconValley-Cupertino/2647/tec.html */ 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 $pid = getgetnumform(pid); if ($pid == "") { 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)); $rowdata = $rs->fetch(); if (! $rowdata) { print ""; exit; }else{ $title = $rowdata[2]; $episode = $rowdata[3]; $subtitle = $rowdata[4]; $m2pfilename = $rowdata[8]; $serveruri = getserveruri(); } print "\n"; print "\n"; print "$title"; print " 第". "$episode" . "話 "; print "$subtitle"; print "|0|0|"; print "http://$serveruri$httpmediamappath/$m2pfilename"; print "|"; ?>