<?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 =	"1";
	if($sessionLevel != 15 && $_SERVER['REMOTE_ADDR'] != $remoteAddr){
			$userhitpage ="news";
			$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);
	}


	include $_SERVER['DOCUMENT_ROOT']."/pages/inc_top.php";

		// =============================================== Query
		$tableName = "news";

		if(!$pageCount) $pageCount = 5;

		$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%'";
		}

		if($MG==5){ // member 회원 볼수있게함.
			if($sessionLevel < 10){
			echo "<script>parent.location.href = './guide.php'</script>";
			exit;
			}
			$where .= "AND general_setting = 'on'";
		}

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

		$order_by = ' ORDER BY no desc';
		$url_tail = "&tab=$tab&tabs=$tabs&MG=$MG&key=$key&order_by=$order_by";

		$query_limit  = "limit $offset,$show_one_page";
		$pcLang = substr($_SERVER[HTTP_ACCEPT_LANGUAGE],0,2);

		if($pcLang == "ja" || $sessionLevel == 15){
				$langChk .= '1,'; //japan

			if($sessionIDX){
				$langChk .= '3,'; //japan member
			}

		}

		if($sessionIDX){
				$langChk .= '2,'; //all member
		}
				$langChk .='0'; //all

			$where .= " and langChk in($langChk)";

		$QUERY_TOTAL = "SELECT count(*) FROM board_$tableName where (original_no=0 or original_no='')  and is_delete ='N'  $where $order_by";
		$QUERY_PAGE  = "SELECT * FROM board_$tableName where (original_no=0 or original_no='') and is_delete ='N' $where $order_by $query_limit";
		//echo $QUERY_PAGE;

		$total_count  = get_db($QUERY_TOTAL);
		$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();
	?>


 <div id="page_index">
  <a href="default.php">HOME</a> > NEWS&NOTICE
 </div>

 <div id="sub_content_box">

  <ul class="board_area2">
			<?
    if(!$total){
     //echo "<tr><td colspan='$colsNum' align=center  height='50px'>등록된 정보가 없습니다.</td></tr>";
     echo "<li><dl class='notice_dl' style='text-align:center;padding: 10px 10px;'>登録された情報がございません</dl></li>";

    }else{
     for($i=0; $i<$total; $i++) {
      $Num = $start_num - $i;
      $row = mysql_fetch_array($result);
      $regdate = substr($row[reg_date],0,10);
   ?>
   <li>
    <dl class="notice_dl">
    <dt>
					<? if($row[general_setting] == 'on'){echo "<p><img src='/images/sub/icon_khj.gif' /></p>";}?>
					<ol>
						<li class="art_ti"  id="<?=$row[no]?>">
      	<a href="javascript:chklist('<?=$Num?>');"><?=$Num?>.&nbsp;
							<?	if($sessionLevel == 15){?>
							<?	if($row[is_secret] == 'Y'){echo "<font color='red'>[SECRET]</font>";}?>
							<?	}	?>
							<?=stripslashes($row[subject])?>&nbsp;&nbsp;
       </a>
       <?	if($row[general_setting] == 'on'){echo "<font color='#639d24'>member only</font>";}?>
       <?	if($regdate == $today){echo" <font color=#8DC73D>NEW</font>";}?>
      </li>
      <li class="channel"><a href="javascript:chklist('<?=$Num?>');"><img id="listBtn<?=$Num?>"src="/images/sub/btn_fold_on.gif" /></a></li>
      <li class="date"><?=$regdate?></li>
					</ol>
				</dt>
				<dd id="list<?=$Num?>" style="padding: 20px 15px;">
				<?
					if(($sessionLevel == 3 || $sessionLevel == "") && $row[general_setting] == 'on'){
								echo $membersJapansName;
					}else{
								echo stripslashes($row[contents]);
					}
				?>
				</dd>
				</dl>
			</li>
			<?
   }
   }
   ?>
  </ul>

 </div>

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



<?php
  include"inc_footer.php";
?>
<script type="text/javascript">
	<!--
	function chklist(val){
		if(document.all("list"+val).style.display == "none"){
			$('#list'+val).fadeIn('slow');
			//document.all("list"+val).style.display='';
			//document.all("listBtn"+val).src='/images/sub/btn_fold_on.gif';
		}else{
			$('#list'+val).fadeOut('slow');
			//document.all("list"+val).style.display='none';
			//document.all("listBtn"+val).src='/images/sub/btn_fold_off.gif';
		}
	}
	function formChange(val,mode){
		if(mode == "del"){
			if(confirm("削除しましょうか？")){

			} else {
				return false;
			}

		}
		//내용변경
		document.form.idx.value = val;
		document.form.mode.value = mode;
		if(mode == 'write' || mode == 'proc'){
			document.form.method = "post";
		}else{
			document.form.method = "get";
		}
		document.form.action = "<?=$php_self?>";
		document.form.submit();

	}

	function board_proc(mode) {
		//document.form.idx.value = val;
		document.form.mode.value = mode;
		document.form.action = "<?=$php_self?>";
		document.form.submit();
	}
	-->
</script>
</body>
</html>