<?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";

	//counter
	if($sessionLevel != 15 && $_SERVER['REMOTE_ADDR'] != $remoteAddr){
			$userhitpage ="gallery";
			$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);
	}
	//model 추출
    $tableName="gallery";
		$colsNum                   = 6;
		if(!$pageCount) $pageCount =6;

		$show_one_page			= $pageCount;
		$show_view_page			= 10;

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

		if($MG==6){ // member 회원 볼수있게함.
			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_limit  = "limit $offset,$show_one_page";

		$QUERY_TOTAL = "SELECT count(*) FROM photo_$tableName WHERE is_delete='N'  $where";
  $QUERY  = "SELECT * FROM photo_$tableName WHERE is_delete='N'  $where ORDER BY no desc $query_limit";
	 $total_count  = get_db($QUERY_TOTAL);
  $result= mysql_query($QUERY,$db_con);
	 $total = mysql_affected_rows();

  $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);



    for($i=0;$i< $total;$i++){
      if($total_count==0){
        //$imgNames="<img src='../../images/academy/sample_img04.jpg'/>";
        //$subject ="모델 사진 준비중";
      }else{
        $row = mysql_fetch_array($result);
        $regDate = substr($row[reg_date],0,10);
				unset($imgNames,$New_icon,$New_secret);
       // if($row[files_count]){

					//echo "SELECT file_name FROM files where module_no = '$row[no]' and module_name='$tableName' and module_type='T' order by order_by";
           $imgfileName = get_db("SELECT file_name FROM files where module_no = '$row[no]' and module_name='$tableName' and module_type='T' order by order_by");
           $imgNames = "<img src='/files/muti/thump/$imgfileName' width='312px'/>";
        //}else{
				//	$imgNames = "<img src='/files/muti/thump/$imgfileName' width='312px'/>";
				//}
        $subject = $row[subject];
      }

			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>";}

			if($sessionIDX){

      $photoList .=
      "<div id='img_312x390'>
        <a href=\"javascript:openshow($row[no],'$tableName')\">$imgNames</a>
        <dl>
			<dt><a href=\"javascript:openshow($row[no],'$tableName')\"><b>$subject</b></a>
			<br/>$row[start_date] $New_icon $New_secret</dt>
		</dl>
       </div>
      ";
			}else{
				 $photoList .=
      "<div id='img_312x390'>
        <a href=\"javascript:alert('ログインしてください.'); location.href='./login.php'\">$imgNames</a>
        <dl>
			<dt><a href=\"javascript:alert('ログインしてください.'); location.href='./login.php'\"><b>$subject</b></a>
			<br/>$row[start_date] $New_icon</dt>
		</dl>
       </div>
      ";

			}
    }

?>
<script type="text/javascript" src="http://code.jquery.com/jquery-1.7.min.js"></script>
<script type="text/javascript" src="../css_js/jquery.smartPop.js"></script>
<link rel="stylesheet" href="../css_js/jquery.smartPop.css" />
<script type="text/javascript">
	function openshow(val,val2){
		$.smartPop.open({ background: "grey", width: 1000, height: 667,borderColor:"#000000", border: 1, url: 'gallery_view.php?no='+val+'&tableName='+val2 });
	}
</script>
 <div id="page_index">
  <a href="default.php">HOME</a> > GALLERY
 </div>

 <div id="sub_content_box">

  <div id="txt">
   本サイトで提供する情報、並びに本サイトに掲載されている全ての画像、映像、音楽、文章などに関する著作権その他一切の権利は、C-JeS Ent に帰属しています。<br />
   本サイトで掲載されている情報の全てについて、無断使用、無断複製を禁止いたします。<br />
   コンテンツの無断盗用を発見した場合、追跡が可能であり、違反者は民事上及び刑事上の責任を負い、処罰される可能性がございます。
  </div>

 </div>

 <div id="sub_content_box">
		<?=$photoList?>
 </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>