Index: trunk/install/php/listreserve.php =================================================================== --- trunk/install/php/listreserve.php (リビジョン 63) +++ trunk/install/php/listreserve.php (リビジョン 70) @@ -17,4 +17,20 @@ */ + +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 +$userclass = getuserclass($con); + ?> @@ -28,10 +44,7 @@ 200501010000){ }else{ @@ -49,5 +62,6 @@ foltia_tvrecord.bitrate , foltia_subtitle.startoffset , -foltia_subtitle.pid +foltia_subtitle.pid , +foltia_subtitle.epgaddedby FROM foltia_subtitle , foltia_program ,foltia_station ,foltia_tvrecord WHERE foltia_tvrecord.tid = foltia_program.tid AND foltia_tvrecord.stationid = foltia_station .stationid AND foltia_program.tid = foltia_subtitle.tid AND foltia_station.stationid = foltia_subtitle.stationid @@ -64,5 +78,6 @@ foltia_tvrecord.bitrate , foltia_subtitle.startoffset , -foltia_subtitle.pid +foltia_subtitle.pid , +foltia_subtitle.epgaddedby FROM foltia_tvrecord LEFT OUTER JOIN foltia_subtitle on (foltia_tvrecord.tid = foltia_subtitle.tid ) @@ -130,5 +145,7 @@ $tid = htmlspecialchars($rowdata[0]); $title = htmlspecialchars($rowdata[2]); -$subtitle = htmlspecialchars($rowdata[4]); +$subtitle = htmlspecialchars($rowdata[4]); +$dbepgaddedby = htmlspecialchars($rowdata[10]); + //重複検出 //開始時刻 $rowdata[5] @@ -268,8 +285,15 @@ print "