- コミット日時:
- 2010/10/20 18:05:32 (14 年前)
- ファイル:
凡例:
- 変更無し
- 追加
- 削除
- 更新
- コピー
- 移動
trunk/install/php/selectcaptureimage.php
r94 r126 59 59 } 60 60 61 62 61 $query = " 63 62 SELECT … … 74 73 FROM foltia_subtitle , foltia_program ,foltia_station 75 74 WHERE foltia_program.tid = foltia_subtitle.tid AND foltia_station.stationid = foltia_subtitle.stationid 76 AND foltia_subtitle.pid = ? 77 78 "; 79 // $rs = m_query($con, $query, "DBクエリに失敗しました"); 75 AND foltia_subtitle.pid = ? 76 "; 80 77 $rs = sql_query($con, $query, "DBクエリに失敗しました",array($pid)); 81 78 $rowdata = $rs->fetch(); 79 82 80 if (! $rowdata) { 83 print " <p align=\"left\"><font color=\"#494949\" size=\"6\">キャプチャ画像</font></p> 84 <hr size=\"4\"> 85 <p align=\"left\"> 86 録画記録がありません。<br> 81 $query = " 82 SELECT 83 foltia_program.tid, 84 foltia_program.tid, 85 foltia_program.title, 86 foltia_subtitle.countno, 87 foltia_subtitle.subtitle, 88 foltia_subtitle.startdatetime , 89 foltia_subtitle.lengthmin , 90 foltia_subtitle.pid , 91 foltia_subtitle.m2pfilename , 92 foltia_subtitle.pspfilename 93 FROM foltia_subtitle , foltia_program 94 WHERE foltia_program.tid = foltia_subtitle.tid 95 AND foltia_subtitle.pid = ? 87 96 "; 88 97 89 }else{ 98 $rs = sql_query($con, $query, "DBクエリに失敗しました",array($pid)); 99 $rowdata = $rs->fetch(); 100 if (! $rowdata) { 101 print " <p align=\"left\"><font color=\"#494949\" size=\"6\">キャプチャ画像</font></p> 102 <hr size=\"4\"> 103 <p align=\"left\"> 104 録画記録がありません。<br></body></html>"; 105 exit ; 106 } 107 $rowdata[1] = ""; 108 }//end if (! $rowdata) 109 90 110 print " <p align=\"left\"><font color=\"#494949\" size=\"6\">キャプチャ画像</font></p> 91 111 <hr size=\"4\"> … … 108 128 $serverfqdn = getserverfqdn(); 109 129 110 print " 再生:<A HREF=\"$httpmediamappath/$tid.localized/mp4/$mp4filename\" target=\"_blank\">$mp4filename</A> / <script language=\"JavaScript\" type=\"text/javascript\">QT_WriteOBJECT_XHTML('http://g.hatena.ne.jp/images/podcasting.gif','16','16','','controller','FALSE','href','http://$serverfqdn/$httpmediamappath/$tid.localized/mp4/$mp4filename','target','QuickTimePlayer','type','video/mp4');</script> <br>";130 print " 再生:<A HREF=\"$httpmediamappath/$tid.localized/mp4/$mp4filename\" target=\"_blank\">$mp4filename</A> / <script language=\"JavaScript\" type=\"text/javascript\">QT_WriteOBJECT_XHTML('http://g.hatena.ne.jp/images/podcasting.gif','16','16','','controller','FALSE','href','http://$serverfqdn/$httpmediamappath/$tid.localized/mp4/$mp4filename','target','QuickTimePlayer','type','video/mp4');</script> / <a href=\"./mp4player.php?p=$pid\" target=\"_blank\">Player</a><br>"; 111 131 112 132 $m2pfilename = $rowdata[8]; 113 133 114 134 list($tid,$countno,$date,$time)= split ("-", $m2pfilename ); 115 $tid = ereg_replace("[^0-9]", "", $tid); 116 135 // $tid = ereg_replace("[^0-9]", "", $tid); 136 $tid = $rowdata[0]; 137 $countno = $rowdata[3] ; 117 138 $path = ereg_replace("\.m2p$|\.m2t$", "", $m2pfilename); 118 139 $serveruri = getserverfqdn (); 119 140 120 exec ("ls 141 exec ("ls $recfolderpath/$tid.localized/img/$path/", $tids); 121 142 //$timecount = 1; 122 143 foreach($tids as $filetid) { … … 129 150 }//foreach 130 151 // タイトル一覧 ここまで 131 }//if rowdata == 0 152 132 153 133 154 ?>