<?
require $_SERVER['DOCUMENT_ROOT']."/conf/conf_dir.php";

	switch ($search_tb) {
		case 1:
				$tableName = "board_free";
				$tableTitle = "Board";
				$tableUrl="board_ls.php";
				break;
		case 2:
				$tableName = "photo_gallery";
				$tableTitle = "Gallery";
				$tableUrl="gallery.php";
				break;
		case 3:
				$tableName = "photo_movie";
				$tableTitle = "Movie";
				$tableUrl="movie.php";
				break;

	}
  if(!$pageCount) $pageCount = 5;
  $show_one_page      = $pageCount;
  $page     = ( $page ) ? $page : 1;
  $offset   = ($page-1)*$show_one_page;

  $total_count  = get_db("select count(c.idx) as cnt from (SELECT a.idx,count(a.module_no) FROM board_comment AS a JOIN $tableName AS b ON a.module_no = b.no 	WHERE a.user_no ='$sessionIDX'	AND a.module_name = '$tableName' 	GROUP BY a.module_no) as c");
  $query_limit  = "limit $offset,$show_one_page";

	$QUERY_PAGE  = "
	SELECT b.*
	FROM board_comment AS a
	 JOIN $tableName AS b
	ON a.module_no = b.no
	WHERE a.user_no ='$sessionIDX'
	AND a.module_name = '$tableName'
	GROUP BY a.module_no
	ORDER BY b.no desc, b.reg_date desc $query_limit";

  $total_page   = ceil( $total_count / $show_one_page);
  $more_next_page = $page+1;
	$viewMore     = ($pageCount > $total_count) ? "" : "<a href='javascript:fnMore(\"$search_tb\");' class='btn_cla' id='$more_next_page' data-total='$total_page'><div class='btn_myp_ls'><img src='../images/sub/sub_pagbar_more_02.png'></div></div></a>";
  $start_num    = $total_count - $offset;  //
  $result= mysql_query($QUERY_PAGE,$db_con);

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

  if(!$total)
  {
    $BRD_LIST = "<div class='post_board'>情報がありません。</div>";
  }
  else
  {
		$kk=0;
    for($i=0; $i<$total; $i++)
    {
      unset($New_icon,$comment_contents,$Cregdate,$CregdateArr);
      //$Num = ($total_count-$offset) - $i;
			//$list_number = ($total_count-$offset) - $i;
      $row = mysql_fetch_array($result);
      $Num = $row[no];
      $regdate = substr($row[reg_date],0,10);
      $regdateArr = explode("-",$regdate);

      if($regdate == $today){$New_icon="<font color=orange><b>NEW</b></font>";}

			$query_comment = "select * from board_comment where module_no = '$Num' and user_no='$sessionIDX' order by idx desc";
			$data = mysql_query($query_comment,$db_con);
			while ($rows = mysql_fetch_array($data)) {
				$Cregdate = substr($rows[reg_date],0,10);
				$CregdateArr = explode("-",$Cregdate);
				 $comment_contents .= "
				 <tr id='vi".$rows[idx]."'>
					<td class='txt_align_l font_bold vatical_top'>$CregdateArr[0]-$CregdateArr[1]-$CregdateArr[2]</td>
					<td class='txt_align_l vatical_top'>$rows[content] <a href='javascript: commnet_del($rows[idx]);'><img src='../images/sub/btn_del2.jpg' width='11' height='11' style='vertical-align:middle;' /></a></td>
					</tr>
				 ";
				 $kk++;
			}

			//글쓴이 이미지 색상
			$tmp_img= get_imgColor($row[user_no]);
			$m_img_big =$tmp_img[0];
			$m_color = $tmp_img[1];

    $BRD_LIST .="
		<!-- LS1 -->
		<div class='post_board'>
			<div class='mv_date_tit'>
				<div class='mvdate_tit_le nobody01' style='background-color:".$m_color.";overflow: hidden; position: relative;'>$m_img_big</div>
				<div class='mvdate_tit_ri '>
					$row[user_name] <span class='mvis_date'>$regdateArr[0].$regdateArr[1].$regdateArr[2]</span>
					<p class='font_bold'>$row[subject]</p>

					<div class='board_annotation'>
						<table width='100%'>
							<colgroup>
							<col width='75px' />
							<col width='*' />
							</colgroup>
							<tbody>
								$comment_contents
							</tbody>
						</table>
						<div style='position:absolute; top:-9px; left:0;'><img src='../images/sub/annotation_dir.png' width='14' height='9'  /></div>
					</div>
					</br>
					<p class='margin_t10'>
					<a href='./".$tableUrl."?tmp_no=$Num'><img src='../images/sub/btn_link.jpg'/></a>
					</p>
				</div>
			</div>
		</div>
		<!-- LS1 -->
    ";

  }
}
//페이지가 1일때만 나오는 폼
if($page ==1){
	$titleTop="
		<h2 class='font_blue'>$tableTitle 掲示板</h2>
    <p class='txt'><span class='font_bold'>‘".$sessionNickname."’</span>様は".$tableTitle."に合計 <span class='font_red font_bold'>".$kk."個</span>のコメントを作成しました。</p>
	";
	$viewMore = $viewMore;
}else{
	$titleTop="";
	$viewMore ="";
}
?>
			<?=$titleTop?>
			<div class='myp_right_content_area2'>
    	<?=$BRD_LIST?>
			<div id='moreList'></div>
     <!-- BTN -->
     <?=$viewMore?>
     <!-- BTN -->
    </div>
    <!-- mypage -->