<?php

	include $_SERVER['DOCUMENT_ROOT']."/conf/conf_dir.php";

		$META_AUTHOR 					= "KIM JAE JOONG";
		$META_KEYWORD					= "KIM JAE JOONG,	C-jes Ent";
		$META_DISCRIPTION	= "KIM JAE JOONG JAPAN OFFICIAL WEB SITE";
		$PAGE_TITLE							= "KIM JAE JOONG JAPAN OFFICAL WEB SITE | ホ・ヨンセン";

	$PAGE_GUBUN =	"3";

	include $_SERVER['DOCUMENT_ROOT']."/pages/inc_top.php";
	if($sessionLevel != 15 && $_SERVER['REMOTE_ADDR'] != $remoteAddr){
			$userhitpage ="movie";
			$hitcount = Get_db("select hit from user_hit where name = '$userhitpage' and startDay = '$today'");
			if(!$hitcount){
				$queryhit = "INSERT INTO user_hit ( id, name, hit, startDay) VALUES ( '', '$userhitpage', '1', '$today')";
			}else{
				$queryhit = "update user_hit set hit = hit+1 where name='$userhitpage' and startDay = '$today'";
			}
			$hitresult = mysql_query($queryhit, $db_con);
	}
?>
<script>
function video_play(ttype,tmpUrl,video_title,dataOption,video_uploader,val,tval){

	if(ttype==1){
		document.getElementById("movLink").src =tmpUrl;
		document.getElementById("movLink").style.display ="";
		document.getElementById("movLink2").style.display ="none";

	}else if(ttype==3){
		document.getElementById("movLink2").src =tmpUrl;
		document.getElementById("movLink").style.display ="none";
		document.getElementById("movLink2").style.display ="";

	}else{
		document.getElementById("movLink").src =tmpUrl+"?autoplay=1";
		document.getElementById("movLink").style.display ="";
		document.getElementById("movLink2").style.display ="none";
	}

	var shin_video_name = video_title.substring(0,28);

	document.getElementById('movieform'+val).className ="mov_list_thumb_on";
	for(var k=0;k < tval;k++){
		if(val != k){
			document.getElementById('movieform'+k).className ="mov_list_thumb_off";
		}
	}
}
</script>
<?
	// =============================================== Query
	$tableName = "movie";

	if(!$pageCount) $pageCount = 9;

	$show_one_page			= $pageCount;
	$show_view_page			= 10;

	$page     = ( $page ) ? $page : 1;
	$offset   = ($page-1)*$show_one_page;

	if($key_word) {
		$key_word = str_replace(" ","",$key_word);
		$where = "AND $key LIKE '%$key_word%'";
	}

	$order_by = ' ORDER BY reg_date DESC';
	$url_tail = "&tab=$tab&tabs=$tabs&key=$key&order_by=$order_by";

	$query_limit  = "limit $offset,$show_one_page";

	if($sessionLevel !='15'){
		$where .=" and is_secret='N' ";
	}

	//$where .=" and is_secret='N' ";
	if($MG==7){
		if($sessionLevel < 10){
		//echo "<script>alert('準備中です.');history.back();</script>";
		echo "<script>parent.location.href = './guide.php'</script>";
		exit;
		}
		$where .=" and general_setting ='1' ";
	}else{
		$where .=" and general_setting ='0' ";
	}
	$url_tail = "&MG=$MG";

	$QUERY_TOTAL = "SELECT count(*) FROM photo_$tableName where original_no=0  $where $order_by";
	$QUERY_PAGE  = "SELECT * FROM photo_$tableName where original_no=0  $where $order_by $query_limit";

	$total_count  = get_db($QUERY_TOTAL);
	$Num = $total_count - $offset;
	$total_page   = ceil( $total_count / $show_one_page);
	$start_num    = $total_count - $offset;  //
	$viewlist     = ( !$total_count ) ? "" : Get_viewpage($page,$total_count,$show_one_page,$show_view_page,$url_tail);

	$result= mysql_query($QUERY_PAGE,$db_con);
	if(!$result) {
		error("DB_ERROR");
		exit;
	}
	$total = mysql_affected_rows();

	$res = Get_dbres("select * from photo_$tableName where original_no=0 $where order by start_date desc");
	$rowU = mysql_fetch_array($res);
	if($rowU[inputtype]==1){
		//echo "$rowU[contentUrl]";
		$tmp_movieUrl = explode(".", $rowU[contentUrl]);

		if($tmp_movieUrl[1] == "mp4"){
			$contentsURL = "/files/muti/video/".$row[contentUrl];
			echo "<script>function initialize(){document.getElementById('movLink2').style.display ='';}window.onload = function() {initialize();}</script>";
		}else{
			$cURL = "./movieflv.html?fileUrl=".$rowU[contentUrl];
			echo "<script>function initialize(){document.getElementById('movLink').style.display ='';}window.onload = function() {initialize();}</script>";
		}
	}else{
		$cURL = $rowU[contentUrl];
		echo "<script>function initialize(){document.getElementById('movLink').style.display ='';}window.onload = function() {initialize();}</script>";
	}
	$subjectU= stripslashes($rowU[subject]);
?>

 <div id="page_index">
  <a href="default.php">HOME</a> > MOVIE
 </div>

 <div id="sub_content_box">
		<div class="board_area4">
			<div class="movLink">
		<video id='movLink2' src='/files/muti/video/<?=$rowU[contentUrl]?>' width='540' height="303" autoplay controls style="display:none;">このブラウザでは再生できません.</video>
		<iframe id="movLink" width='540' height="303"  src="<?=$cURL?>" allowscriptaccess="always"  frameborder="0" allowTransparency="true" scrolling='no' allowfullscreen  style="display:none;"></iframe></li>
   </div>
		</div>

  <ul class="gal_list_area">
    <li class="result">MOVIE LIST (全<?=$total_count?>件)</li>
  </ul>
 </div>

	 <div id="sub_content_box">
   <?

	if(!$total){

		echo "登録された情報がございません";
	}else{
      $kk = 0;
      for($i=0; $i<$total; $i++) {
							unset($New_icon);
       $row = mysql_fetch_array($result);
       //$contents = explode("",$row[contents]);
       $regdate = substr($row[reg_date],0,10);
       $imgName = get_db("select file_name from files where module_no = '$row[no]' and module_name='$tableName' order by no");
       $Num = $total_count - $kk;
       //$doY = $kk%3;
       $subject	= stripslashes($row[subject]);
	   //$subject = utf8_cutstr($subject,'50','..');

					if($row[inputtype]==1){

						$tmp_movieUrl_list = explode(".", $row[contentUrl]);

						if($tmp_movieUrl_list[1] == "mp4"){
							$contentsURL_list = "/files/muti/video/".$row[contentUrl];
							$inputtype = 3; //mp4
						}else{
							$contentsURL_list = "./movieflv.html?fileUrl=".$row[contentUrl];
							$inputtype=1;
						}
					}else{
						$contentsURL_list = $row[contentUrl];
						$inputtype=2;
					}
					if($row[start_date] == $today){$New_icon="<font color=orange><b>NEW</b></font>";}
					if($row[is_secret] == 'Y'){$New_secret="<font color='red'>[SECRET]</font>";}else{
					$New_secret="";
					}
    ?>
			<div id='img_312x390'>
				<p id="movieform<?=$i?>" class="mov_list_thumb_off" style="margin:0 7px 0; cursor:pointer;" onclick="video_play('<?=$inputtype?>','<?=$contentsURL_list?>','<?=$subject?>','<?=$row[start_date]?>','<?=$row[user_name]?>','<?=$i?>',<?=$total?>)" mouserollover="">
				<img src="/files/muti/thump/<?=$imgName?>" width="312" height="170"/></p>
				<dl>
					<dt><b><?=$subject?></b><br><?=$row[start_date]?><?=$New_icon?><?=$New_secret?></dt>
				</dl>
			</div>
			<?
				//$kk++;
				//$Num--;
					}
				}
			?>





 </div>

 	<div id="sub_content_box">
  <ul class="gal_list_area">
   <li class="result">(全<?=$total_count?>件)</li>
   <?=$viewlist?>
	 </ul>
	</div>



<?
  include"inc_footer.php";
?>

</body>
</html>