<?include $_SERVER['DOCUMENT_ROOT']."/admin/adminTopMenu.html";?>
<?
$time_start = microtime(true);
?>
<script type="text/JavaScript"> 
function goPage(page)
{
	var f = document.form;
	f.page.value = page;
	f.action = '/admin/memberlist.php';
	f.submit();
}
function StatusScript(status,id) {
		var choose = confirm("修正しましょうか?");
		if(choose){
			document.form.idx.value = id;
			document.form.mode.value = status;
			document.form.action = "/admin/Proc/authcode_proc.php";
			document.form.submit();
		}
	}
</script>
<script type="text/javascript"> 
	function openWin() {
		window.open( './blackform.html', '_blank', 'width=450, height=300, top=0, left=200, scrollbars=no, resizable=no' );
	}
</script>
<?
	if(!$pageCount) $pageCount = 25;

	$show_one_page			= $pageCount;
	$show_view_page			= 10;   

	$page     = ( $page ) ? $page : 1;
	$offset   = ($page-1)*$show_one_page;
		  
	if($key_word) {
		if($key == "username" || $key == "jname" || $key == "jname2" || $key == "nickname"){
			//$key_word = str_replace(" ","",$key_word);
			$where = "AND $key like '%".$key_word."%' ";
		}else{
			$key_word = str_replace(" ","",$key_word);
			$where = "AND UPPER(".$key.") like '%".strtoupper($key_word)."%' ";
		}
	}

	$url_tail = "&act=$act&key=$key&key_word=$key_word&order_by=$order_by&LK=$LK&sort=$sort";
	//총 회원;
	$total_count  = get_db("SELECT count(*) FROM blacklist where 1=1 $where $CoWhere $order_by");

	$query_limit  = "limit $offset,$show_one_page";
	
	$QUERY_PAGE  = "SELECT * FROM blacklist where 1=1 $where $CoWhere $order_by $query_limit";
	if($_SERVER["REMOTE_ADDR"] == "115.90.174.51"){
	
	echo $QUERY_PAGE."<br>";
	//echo $HTTP_SESSION_VARS[S_ID];
	}
	$total_page   = ceil( $total_count / $show_one_page);
	$viewlist2     = ( !$total_count ) ? "" : Get_viewpage2($page,$total_count,$show_one_page,$show_view_page,$url_tail);
   $start_num    = $total_count - $offset;  // 
	$result= mysql_query($QUERY_PAGE,$db_con);
	if(!$result) {
		error("DB_ERROR");
		exit;
	}
	$total = mysql_affected_rows();
?>
<div id="contents">
 
	<h2>블랙리스트</h2>
	<div id="content">
		<?include "./membertab.html"?>
		<form name="form" method="post" target="_self" onsubmit="return false;" >
		<input type="hidden" name="idx">
		<input type="hidden" name="mode">
		<input type="hidden" name="act" value="<?=$act?>">
		<fieldset>
			
			<input type="button" value="등록"class="btn_blue" onClick="openWin();" />
			*여기에 등록된 회원은 정회원정보에 블랙리스트 아이콘이 있습니다.
		</fieldset>
		</form>
		<table class="member" summary="관리자모드 게시판입니다" cellspacing="0" >
			<colgroup>
				<col width="30"/>
				<col width="100" />
				<col width="80" />
				<col />
			</colgroup>
			<thead>
				<tr>
					<th>No</th>
					<th>아이디</th>
					<th>등록일</th>
					<th>메모</th>
				</tr>
			</thead>
			<tbody>
			
				<?
				if(!$total){
					echo "<tr><td colspan='4' align=center  height='50px'>登録された情報がございません</td></tr>";
				}else if(($sessionLevel == 3 || $sessionLevel == "") && ($tabs==4 || $tabs==6 || $tabs==7)){

					//echo "<tr><td colspan='3' align=center  height='50px'>유료회원 페이지 입니다.</td></tr>";
					echo "<tr><td colspan='4' align=center  height='50px'>$membersJapansName</td></tr>";
				}else{
					for($i=0; $i<$total; $i++) {
						$Num = $start_num - $i;
						$row = mysql_fetch_array($result);
						$created = substr($row[created],0,10);
						if($row[auth_code] == '10'){
							$stateColor ="#FF0099";
						}else{
							$stateColor ="#ffffff";
						}
				?>
				<tr bgcolor="<?=$bgColor?>">
					<td><?=$Num?></td>
					<td><?=$row[id]?></td>
					<td><?=$row[regdate]?></td>
					<td><?=$row[memo]?></td>
				</tr>
				<?
					$Num--;
					}
				}
				?>
			</tbody>
		</table>
		<div class="page_list">
		<!--  prev/next_std -->
		<?=$viewlist2?>
		<!--  prev/next_end -->
		</div>
	</div>
</div>
<p></p>
</body>
</html>
<?
$time_end = microtime(true);
		$time = sprintf("%0.2f",$time_end - $time_start);
		//echo "<center><br><br>$time sec<br><br>";
?>