질문입니다... P.S(아래 잘못쓴거 "d" 관리자님 지워주세요) 정보
질문입니다... P.S(아래 잘못쓴거 "d" 관리자님 지워주세요)본문
페이징처리인데요..그누보드는 아니구요..
보시면 한페이지당 25명씩 목록에 보이게끔했놨는데요..
근데 이상하게 100명을 등록하면 100모두 한페이지 보여집니다..
25명씩 4페이지에 보여져야 정상인데... 뭐가 잘못된건지 아무리 봐도
모르겠네요..근데 이상한게 페이지는 정상적으로 4페이지가 뜨는데..
페이지마다 100명명단이 똑같이 뜨는겁니다..
1페이지에도 100명 2페이지에도 100명... 똑같이..
모자란 저에게 조금이나 도움을 주시면 감사하겠습니다.
--------------------------------------------------------------------------------------------------------------------------
<?
session_start();
include "cy_dbcon.php";
if ( $_GET["mode"] == "logout" )
{
$_SESSION["adminid"] = "";
}
if ( $_SESSION["adminid"] == "" && $_GET['mode'] != 'login')
{
?>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=euc-kr">
<title></title>
<meta name="generator" content="Namo WebEditor v6.0">
</head>
<body bgcolor="white" text="black" link="blue" vlink="purple" alink="red" leftmargin="0" marginwidth="0" topmargin="0" marginheight="0">
<p style="line-height:150%; margin-top:0; margin-bottom:0;"> </p>
<p style="line-height:150%; margin-top:0; margin-bottom:0;"> </p>
<p style="line-height:150%; margin-top:0; margin-bottom:0;"> </p>
<TABLE cellSpacing=0 cellPadding=0 width="100%" align=center border=0>
<TBODY>
<TR>
<TD width="28%"> </TD>
<TD width="391"><IMG height=60 src="img/login_top.gif" width=400></TD>
<TD width="33%"> </TD>
</TR>
<TR>
<TD width="28%" bgColor=#2db3cb> </TD>
<TD width="391">
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="400" height="250">
<param name="movie" value="img/login.swf">
<param name="play" value="true">
<param name="loop" value="true">
<param name="quality" value="high">
<embed width="400" height="250" src="img/login.swf" play="true" loop="true" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash"></embed></object>
</TD>
<TD width="33%" bgColor=#2db3cb> </TD>
</TR>
<TR>
<TD width="28%"> </TD>
<TD vAlign=top width="391" background="img/login_bottom.gif" height=90>
<TABLE cellSpacing=0 cellPadding=0 align=center border=0>
<form method=post action="?mode=login" name=frmlogin onsubmit="return frmcheck(this);" autocomplete="off">
<TBODY>
<TR>
<TD width=30><IMG height=20 src="img/login_id.gif" width=30></TD>
<TD width=100><INPUT class=login_box size=13 name=userid> </TD>
<TD width=30><IMG height=20 src="img/login_pw.gif" width=30></TD>
<TD width=100><INPUT class=login_box type=password size=13 name=passwd> </TD>
<TD width=5> </TD>
<TD><INPUT type=image height=30 width=30 src="img/login_button.gif" onfocus=blur() border=0 name=imageField> </TD>
</TR>
</FORM></TBODY>
</TABLE>
</TD>
<TD width="33%"><IMG height=90 src="img/login_bg.gif" width=30></TD>
</TR>
</TBODY>
</TABLE>
<SCRIPT Language="javascript">
document.frmlogin.userid.focus();
function frmcheck(f)
{
if (f.userid.value == '') {
alert("관리자 ID를 입력하세요.");
f.admin_id.focus();
return false;
} else if (f.passwd.value == '') {
alert("관리자 비밀번호를 입력하세요.");
f.mb_password.focus();
return false;
}
return true;
}
</SCRIPT>
</body>
</html>
<?
exit;
}
if ( $_GET['mode'] == 'login' )
{
$userid = addslashes(trim($_POST["userid"]));
$passwd = addslashes(trim($_POST["passwd"]));
if ( $admin_id == $userid && $admin_pass == $passwd )
{
$_SESSION["adminid"] = $userid;
echo "<script>window.location.href='cy_admin.php'</script>";
exit;
}
else
{
echo "<script>alert('일치하는 아이디와 비밀번호가 존재하지 않습니다.');history.go(-1);</script>";
exit;
}
}
if ( $_GET["mode"] == "newadd" )
{
$userid = addslashes($_POST["userid"]);
$passwd = addslashes($_POST["passwd"]);
$maxSize = addslashes($_POST["maxSize"]);
$tid = addslashes($_POST["tid"]);
$enddate = addslashes($_POST["enddate"]);
$Sql = "
INSERT INTO
cyworld_admin
SET
userid = '$userid',
passwd = '$passwd',
maxSize = '$maxSize',
tid = '$tid',
regdate = now(),
enddate = '$enddate'
";
mysql_query($Sql,$conn);
@mkdir("images/$tid", 0777);
@exec("cp main.jpg images/$tid/main.jpg");
echo "<script>alert('등록되었습니다.');</script>";
echo "<script>window.location.href='?';</script>";exit;
}
if ( $_GET["mode"] == "edit" )
{
$idx = addslashes($_POST["idx"]);
$userid = addslashes($_POST["userid"]);
$passwd = addslashes($_POST["passwd"]);
$maxSize = addslashes($_POST["maxSize"]);
$tid = addslashes($_POST["tid"]);
$enddate = addslashes($_POST["enddate"]);
$Sql = "
UPDATE
cyworld_admin
SET
userid = '$userid',
passwd = '$passwd',
maxSize = '$maxSize',
tid = '$tid',
enddate = '$enddate'
WHERE
idx = '$idx'
";
mysql_query($Sql,$conn);
echo "<script>alert('수정되었습니다.');</script>";
echo "<script>window.location.href='?';</script>";exit;
}
if ( $_GET["mode"] == "delete" )
{
$idx = addslashes($_GET["idx"]);
$Sql = "
DELETE FROM
cyworld_admin
WHERE
idx = '$idx'
";
mysql_query($Sql,$conn);
echo "<script>alert('삭제되었습니다.');</script>";
echo "<script>window.location.href='?';</script>";exit;
}
if ( $_GET["mode"] == "dbclear" )
{
$id = addslashes($_GET["id"]);
$maxSize = addslashes($_GET["maxSize"]);
$Tmp = mysql_fetch_array(mysql_query("SELECT tid FROM cyworld_admin WHERE userid='$id'",$conn));
$id = $Tmp["tid"];
echo $Sql = "SELECT idx FROM cyworld_visited WHERE userid='$id' ORDER BY idx desc LIMIT $maxSize,100000 ";
exit;
$Record = mysql_query($Sql,$conn);
while ( $Data = mysql_fetch_array($Record) )
{
$Sql = "DELETE FROM cyworld_visited WHERE idx = '$Data[idx]' ";
mysql_query($Sql,$conn);
}
echo "<script>alert('[${id}] 회원님의 로그가 정리되었습니다.');</script>";
echo "<script>window.location.href='?';</script>";exit;
}
if ( $_GET["mode"] == "alldbclear" )
{
$Sql = "SELECT tid,maxSize FROM cyworld_admin ";
$Record = mysql_query($Sql,$conn);
while ( $User = mysql_fetch_array($Record) )
{
$id = $User["tid"];
$maxSize = $User["maxSize"];
$Sql = "SELECT idx FROM cyworld_visited WHERE userid='$id' ORDER BY idx desc LIMIT $maxSize,100000 ";
$Record = mysql_query($Sql,$conn);
while ( $Data = mysql_fetch_array($Record) )
{
$Sql = "DELETE FROM cyworld_visited WHERE idx = '$Data[idx]' ";
mysql_query($Sql,$conn);
}
flush();
}
echo "<script>alert('모든회원의 로그가 정리되었습니다.');</script>";
echo "<script>window.location.href='?';</script>";exit;
}
if ( $_GET["kwak"] != "" )
{
$_SESSION["userid"] = $_GET["kwak"];
echo "<script>window.open('cy_list.php');</script>";
}
?>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=euc-kr">
<title></title>
<meta name="generator" content="Namo WebEditor v6.0">
<script>
function goEdit( useridx, userid, userpw, usersize, tid, enddate )
{
var frm = document.forms["edit_frm"];
frm.idx.value = useridx;
frm.userid.value = userid;
frm.passwd.value = userpw;
frm.maxSize.value = usersize;
frm.tid.value = tid;
frm.enddate.value = enddate;
document.getElementById('edit_layer').innerHTML = "<b>"+userid+"</b> 회원 정보수정";
frm.userid.focus();
}
function goDelete( useridx, userid )
{
if ( confirm( "\n ["+userid+"] 회원을 삭제하시겟습니까? \n\n 삭제후 복구는 불가능합니다. ") )
{
window.location.href = '?mode=delete&idx='+useridx;
}
}
function dbClear( userid , maxs)
{
if ( confirm( "\n ["+userid+"] 회원의 로그를 정리하시겟습니까? \n\n 정리시 로그들은 삭제됩니다. ") )
{
window.location.href = '?mode=dbclear&id='+ userid +'&maxSize='+maxs;
}
}
</script>
</head>
<body bgcolor="white" text="black" link="blue" vlink="purple" alink="red" leftmargin="0" marginwidth="0" topmargin="0" marginheight="0">
<table BORDER="0" CELLSPACING="0" CELLPADDING="0" WIDTH="100%" HEIGHT="70">
<tr>
<td align="center" background="img/bg_top.gif" width="200">
<a href="../Admin/main.asp" target="_top"><img src="img/logo.gif" border="0" align="absmiddle"></a>
</td>
<td background="img/bg_top.gif">
<table BORDER="0" CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<tr>
<td><a href="?mode=logout"><img src="img/logout.gif" border="0" align="absmiddle"></a></td>
</tr>
</table>
</td>
</tr>
</table>
<table width='100%' style="font-size:9pt">
<tr>
<td valign='top' width='35%'>
<!-- 신규회원등록 -->
<table width='300' cellspacing='1' cellpadding='0' bgcolor='gray' style="font-size:9pt">
<form action="?mode=newadd" method="post">
<tr bgcolor='white' height='23'>
<td align=center colspan=2 > <b>신규회원등록 </td>
</tr>
<tr bgcolor='white'>
<td width='100' align='center'>아이디</td>
<td width='200' style='padding-left:5px'>
<input type='text' name='userid' >
</td>
</tr>
<tr bgcolor='white'>
<td width='100' align='center'>패스워드</td>
<td width='200' style='padding-left:5px'>
<input type='text' name='passwd' >
</td>
</tr>
<tr bgcolor='white'>
<td width='100' align='center'>값</td>
<td width='200' style='padding-left:5px'>
<input type='text' name='tid' >
</td>
</tr>
<tr bgcolor='white'>
<td width='100' align='center'>최대수</td>
<td width='200' style='padding-left:5px'>
<input type='text' name='maxSize' size='10'>
</td>
</tr>
<tr bgcolor='white'>
<td width='100' align='center'>만료기간</td>
<td width='200' style='padding-left:5px'>
<input type='text' name='enddate' size='10'> ex) 2007-05-28
</td>
</tr>
<tr bgcolor='white'>
<td align=center colspan=2 ><input type='submit' value='등록하기'></td>
</tr>
</form>
</table><br>
<!-- 신규회원등록 -->
</td>
<td rowspan='4' valign='top' width='65%'>
<!-- 컨테츠 시작 -->
<table align="center" cellspacing="1" cellpadding="0" bgcolor="black" style="font-size:9pt">
<tr bgcolor="EFEFEF" height="20">
<td width="50" align="center"><font color="black"><b>No.</td>
<td width="100" align="center"><font color="black"><b>아이디</td>
<td width="100" align="center"><font color="black"><b>패스워드</td>
<td width="100" align="center"><font color="black"><b>값</td>
<td width="100" align="center"><font color="black"><b>최대수</td>
<td width="100" align="center"><font color="black"><b>가입일자</td>
<td width="100" align="center"><font color="black"><b>만료기간</td>
<td width="120" align="center"><font color="black"><b>관리</td>
</tr>
<?
$userid = $_SESSION["userid"];
$field = ( $_GET["field"] == "" )?"userid":$_GET["field"];
$keyword = $_GET["keyword"];
if ( $field != "" && $keyword != "" )
{
$WHERE = " WHERE $field like '%${keyword}%' ";
}
####################### 페이징처리 ########################
$start = $_GET["start"];
$scale = 25;
$Sql = "select count(*) from cyworld_admin $WHERE ";
$Temp = mysql_fetch_array(mysql_query($Sql,$conn));
$Total = $Count = $Temp[0];
if( $start ) { $listNo = $Total - $start; } else { $listNo = $Total; $start = 0; }
$pageScale = 6;
$searchMethod = "&field=$field&keyword=$keyword";
$paging = newPaging( $Total, $scale, $pageScale, $start, "<img src='images/prev.gif' border='0' align='absmiddle'>", "<img src='images/next.gif' border='0' align='absmiddle'>", $searchMethod);
###################### 페이징처리 끝 #######################
$Sql = "SELECT * FROM cyworld_admin $WHERE ORDER BY idx desc ";
$Record = mysql_query($Sql,$conn);
while ( $Data = mysql_fetch_array($Record) )
{
//$Sql = "SELECT Count(*) FROM cyworld_visited WHERE userid='$Data[tid]' ";
//$Tmp = mysql_fetch_array(mysql_query($Sql,$conn));
?>
<tr bgcolor="white" height="18">
<td align="center"><?=$Data["idx"]?></td>
<td align="center"><a href='?kwak=<?=$Data["userid"]?>'><?=$Data["userid"]?></a></td>
<td align="center"><?=$Data["passwd"]?></td>
<td align="center"><?=$Data["tid"]?></td>
<td align="center"><?=$Data["maxSize"]?></td>
<td align="center"><?=substr($Data["regdate"],0,10)?></td>
<td align="center"><?=substr($Data["enddate"],0,10)?></td>
<td align="center">
[
<a href='#1' onClick="goEdit('<?=$Data["idx"]?>','<?=$Data["userid"]?>','<?=$Data["passwd"]?>','<?=$Data["maxSize"]?>','<?=$Data["tid"]?>','<?=substr($Data["enddate"],0,10)?>');">수정</a>
/
<a href='#1' onClick="goDelete('<?=$Data["idx"]?>','<?=$Data["userid"]?>')">삭제</a>
]
</td>
</tr>
<?
}
?>
</table><br>
<center><?=$paging?></center>
<table width='100%'>
<form name='search_frm'>
<tr>
<td align='right'>
<select name='field'>
<option value='userid'>아이디검색</option>
<option value='tid'>검색</option>
<option value='regdate'>가입일자검색</option>
<option value='enddate'>만료일자검색</option>
</select>
<input type='text' name='keyword' value='<?=$_GET[keyword]?>'>
<input type='submit' value='검색'>
<script>
document.search_frm.field.value = '<?=$field?>';
document.search_frm.keyword.focus();
</script>
</td>
</tr>
</form>
</table>
<!-- 컨테츠 종료 -->
</td>
</tr>
<tr>
<td valign='top' >
<!-- 회원정보수정 -->
<table width='300' cellspacing='1' cellpadding='0' bgcolor='gray' style="font-size:9pt">
<form name='edit_frm' action="?mode=edit" method="post">
<input type='hidden' name='idx' value=''>
<tr bgcolor='white' height='23'>
<td align=center colspan=2 ><div id='edit_layer'>수정하실 회원을 선택하세요.</div></td>
</tr>
<tr bgcolor='white'>
<td width='100' align='center'>아이디</td>
<td width='200' style='padding-left:5px'>
<input type='text' name='userid' >
</td>
</tr>
<tr bgcolor='white'>
<td width='100' align='center'>패스워드</td>
<td width='200' style='padding-left:5px'>
<input type='text' name='passwd' >
</td>
</tr>
<tr bgcolor='white'>
<td width='100' align='center'>값</td>
<td width='200' style='padding-left:5px'>
<input type='text' name='tid' >
</td>
</tr>
<tr bgcolor='white'>
<td width='100' align='center'>최대수</td>
<td width='200' style='padding-left:5px'>
<input type='text' name='maxSize' size='10'>
</td>
</tr>
<tr bgcolor='white'>
<td width='100' align='center'>만료기간</td>
<td width='200' style='padding-left:5px'>
<input type='text' name='enddate' size='10'> ex) 2007-05-28
</td>
</tr>
<tr bgcolor='white'>
<td align=center colspan=2 ><input type='submit' value='수정하기'></td>
</tr>
</form>
</table><br>
<!-- 회원정보수정 -->
</td>
</tr>
</table>
보시면 한페이지당 25명씩 목록에 보이게끔했놨는데요..
근데 이상하게 100명을 등록하면 100모두 한페이지 보여집니다..
25명씩 4페이지에 보여져야 정상인데... 뭐가 잘못된건지 아무리 봐도
모르겠네요..근데 이상한게 페이지는 정상적으로 4페이지가 뜨는데..
페이지마다 100명명단이 똑같이 뜨는겁니다..
1페이지에도 100명 2페이지에도 100명... 똑같이..
모자란 저에게 조금이나 도움을 주시면 감사하겠습니다.
--------------------------------------------------------------------------------------------------------------------------
<?
session_start();
include "cy_dbcon.php";
if ( $_GET["mode"] == "logout" )
{
$_SESSION["adminid"] = "";
}
if ( $_SESSION["adminid"] == "" && $_GET['mode'] != 'login')
{
?>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=euc-kr">
<title></title>
<meta name="generator" content="Namo WebEditor v6.0">
</head>
<body bgcolor="white" text="black" link="blue" vlink="purple" alink="red" leftmargin="0" marginwidth="0" topmargin="0" marginheight="0">
<p style="line-height:150%; margin-top:0; margin-bottom:0;"> </p>
<p style="line-height:150%; margin-top:0; margin-bottom:0;"> </p>
<p style="line-height:150%; margin-top:0; margin-bottom:0;"> </p>
<TABLE cellSpacing=0 cellPadding=0 width="100%" align=center border=0>
<TBODY>
<TR>
<TD width="28%"> </TD>
<TD width="391"><IMG height=60 src="img/login_top.gif" width=400></TD>
<TD width="33%"> </TD>
</TR>
<TR>
<TD width="28%" bgColor=#2db3cb> </TD>
<TD width="391">
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="400" height="250">
<param name="movie" value="img/login.swf">
<param name="play" value="true">
<param name="loop" value="true">
<param name="quality" value="high">
<embed width="400" height="250" src="img/login.swf" play="true" loop="true" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash"></embed></object>
</TD>
<TD width="33%" bgColor=#2db3cb> </TD>
</TR>
<TR>
<TD width="28%"> </TD>
<TD vAlign=top width="391" background="img/login_bottom.gif" height=90>
<TABLE cellSpacing=0 cellPadding=0 align=center border=0>
<form method=post action="?mode=login" name=frmlogin onsubmit="return frmcheck(this);" autocomplete="off">
<TBODY>
<TR>
<TD width=30><IMG height=20 src="img/login_id.gif" width=30></TD>
<TD width=100><INPUT class=login_box size=13 name=userid> </TD>
<TD width=30><IMG height=20 src="img/login_pw.gif" width=30></TD>
<TD width=100><INPUT class=login_box type=password size=13 name=passwd> </TD>
<TD width=5> </TD>
<TD><INPUT type=image height=30 width=30 src="img/login_button.gif" onfocus=blur() border=0 name=imageField> </TD>
</TR>
</FORM></TBODY>
</TABLE>
</TD>
<TD width="33%"><IMG height=90 src="img/login_bg.gif" width=30></TD>
</TR>
</TBODY>
</TABLE>
<SCRIPT Language="javascript">
document.frmlogin.userid.focus();
function frmcheck(f)
{
if (f.userid.value == '') {
alert("관리자 ID를 입력하세요.");
f.admin_id.focus();
return false;
} else if (f.passwd.value == '') {
alert("관리자 비밀번호를 입력하세요.");
f.mb_password.focus();
return false;
}
return true;
}
</SCRIPT>
</body>
</html>
<?
exit;
}
if ( $_GET['mode'] == 'login' )
{
$userid = addslashes(trim($_POST["userid"]));
$passwd = addslashes(trim($_POST["passwd"]));
if ( $admin_id == $userid && $admin_pass == $passwd )
{
$_SESSION["adminid"] = $userid;
echo "<script>window.location.href='cy_admin.php'</script>";
exit;
}
else
{
echo "<script>alert('일치하는 아이디와 비밀번호가 존재하지 않습니다.');history.go(-1);</script>";
exit;
}
}
if ( $_GET["mode"] == "newadd" )
{
$userid = addslashes($_POST["userid"]);
$passwd = addslashes($_POST["passwd"]);
$maxSize = addslashes($_POST["maxSize"]);
$tid = addslashes($_POST["tid"]);
$enddate = addslashes($_POST["enddate"]);
$Sql = "
INSERT INTO
cyworld_admin
SET
userid = '$userid',
passwd = '$passwd',
maxSize = '$maxSize',
tid = '$tid',
regdate = now(),
enddate = '$enddate'
";
mysql_query($Sql,$conn);
@mkdir("images/$tid", 0777);
@exec("cp main.jpg images/$tid/main.jpg");
echo "<script>alert('등록되었습니다.');</script>";
echo "<script>window.location.href='?';</script>";exit;
}
if ( $_GET["mode"] == "edit" )
{
$idx = addslashes($_POST["idx"]);
$userid = addslashes($_POST["userid"]);
$passwd = addslashes($_POST["passwd"]);
$maxSize = addslashes($_POST["maxSize"]);
$tid = addslashes($_POST["tid"]);
$enddate = addslashes($_POST["enddate"]);
$Sql = "
UPDATE
cyworld_admin
SET
userid = '$userid',
passwd = '$passwd',
maxSize = '$maxSize',
tid = '$tid',
enddate = '$enddate'
WHERE
idx = '$idx'
";
mysql_query($Sql,$conn);
echo "<script>alert('수정되었습니다.');</script>";
echo "<script>window.location.href='?';</script>";exit;
}
if ( $_GET["mode"] == "delete" )
{
$idx = addslashes($_GET["idx"]);
$Sql = "
DELETE FROM
cyworld_admin
WHERE
idx = '$idx'
";
mysql_query($Sql,$conn);
echo "<script>alert('삭제되었습니다.');</script>";
echo "<script>window.location.href='?';</script>";exit;
}
if ( $_GET["mode"] == "dbclear" )
{
$id = addslashes($_GET["id"]);
$maxSize = addslashes($_GET["maxSize"]);
$Tmp = mysql_fetch_array(mysql_query("SELECT tid FROM cyworld_admin WHERE userid='$id'",$conn));
$id = $Tmp["tid"];
echo $Sql = "SELECT idx FROM cyworld_visited WHERE userid='$id' ORDER BY idx desc LIMIT $maxSize,100000 ";
exit;
$Record = mysql_query($Sql,$conn);
while ( $Data = mysql_fetch_array($Record) )
{
$Sql = "DELETE FROM cyworld_visited WHERE idx = '$Data[idx]' ";
mysql_query($Sql,$conn);
}
echo "<script>alert('[${id}] 회원님의 로그가 정리되었습니다.');</script>";
echo "<script>window.location.href='?';</script>";exit;
}
if ( $_GET["mode"] == "alldbclear" )
{
$Sql = "SELECT tid,maxSize FROM cyworld_admin ";
$Record = mysql_query($Sql,$conn);
while ( $User = mysql_fetch_array($Record) )
{
$id = $User["tid"];
$maxSize = $User["maxSize"];
$Sql = "SELECT idx FROM cyworld_visited WHERE userid='$id' ORDER BY idx desc LIMIT $maxSize,100000 ";
$Record = mysql_query($Sql,$conn);
while ( $Data = mysql_fetch_array($Record) )
{
$Sql = "DELETE FROM cyworld_visited WHERE idx = '$Data[idx]' ";
mysql_query($Sql,$conn);
}
flush();
}
echo "<script>alert('모든회원의 로그가 정리되었습니다.');</script>";
echo "<script>window.location.href='?';</script>";exit;
}
if ( $_GET["kwak"] != "" )
{
$_SESSION["userid"] = $_GET["kwak"];
echo "<script>window.open('cy_list.php');</script>";
}
?>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=euc-kr">
<title></title>
<meta name="generator" content="Namo WebEditor v6.0">
<script>
function goEdit( useridx, userid, userpw, usersize, tid, enddate )
{
var frm = document.forms["edit_frm"];
frm.idx.value = useridx;
frm.userid.value = userid;
frm.passwd.value = userpw;
frm.maxSize.value = usersize;
frm.tid.value = tid;
frm.enddate.value = enddate;
document.getElementById('edit_layer').innerHTML = "<b>"+userid+"</b> 회원 정보수정";
frm.userid.focus();
}
function goDelete( useridx, userid )
{
if ( confirm( "\n ["+userid+"] 회원을 삭제하시겟습니까? \n\n 삭제후 복구는 불가능합니다. ") )
{
window.location.href = '?mode=delete&idx='+useridx;
}
}
function dbClear( userid , maxs)
{
if ( confirm( "\n ["+userid+"] 회원의 로그를 정리하시겟습니까? \n\n 정리시 로그들은 삭제됩니다. ") )
{
window.location.href = '?mode=dbclear&id='+ userid +'&maxSize='+maxs;
}
}
</script>
</head>
<body bgcolor="white" text="black" link="blue" vlink="purple" alink="red" leftmargin="0" marginwidth="0" topmargin="0" marginheight="0">
<table BORDER="0" CELLSPACING="0" CELLPADDING="0" WIDTH="100%" HEIGHT="70">
<tr>
<td align="center" background="img/bg_top.gif" width="200">
<a href="../Admin/main.asp" target="_top"><img src="img/logo.gif" border="0" align="absmiddle"></a>
</td>
<td background="img/bg_top.gif">
<table BORDER="0" CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<tr>
<td><a href="?mode=logout"><img src="img/logout.gif" border="0" align="absmiddle"></a></td>
</tr>
</table>
</td>
</tr>
</table>
<table width='100%' style="font-size:9pt">
<tr>
<td valign='top' width='35%'>
<!-- 신규회원등록 -->
<table width='300' cellspacing='1' cellpadding='0' bgcolor='gray' style="font-size:9pt">
<form action="?mode=newadd" method="post">
<tr bgcolor='white' height='23'>
<td align=center colspan=2 > <b>신규회원등록 </td>
</tr>
<tr bgcolor='white'>
<td width='100' align='center'>아이디</td>
<td width='200' style='padding-left:5px'>
<input type='text' name='userid' >
</td>
</tr>
<tr bgcolor='white'>
<td width='100' align='center'>패스워드</td>
<td width='200' style='padding-left:5px'>
<input type='text' name='passwd' >
</td>
</tr>
<tr bgcolor='white'>
<td width='100' align='center'>값</td>
<td width='200' style='padding-left:5px'>
<input type='text' name='tid' >
</td>
</tr>
<tr bgcolor='white'>
<td width='100' align='center'>최대수</td>
<td width='200' style='padding-left:5px'>
<input type='text' name='maxSize' size='10'>
</td>
</tr>
<tr bgcolor='white'>
<td width='100' align='center'>만료기간</td>
<td width='200' style='padding-left:5px'>
<input type='text' name='enddate' size='10'> ex) 2007-05-28
</td>
</tr>
<tr bgcolor='white'>
<td align=center colspan=2 ><input type='submit' value='등록하기'></td>
</tr>
</form>
</table><br>
<!-- 신규회원등록 -->
</td>
<td rowspan='4' valign='top' width='65%'>
<!-- 컨테츠 시작 -->
<table align="center" cellspacing="1" cellpadding="0" bgcolor="black" style="font-size:9pt">
<tr bgcolor="EFEFEF" height="20">
<td width="50" align="center"><font color="black"><b>No.</td>
<td width="100" align="center"><font color="black"><b>아이디</td>
<td width="100" align="center"><font color="black"><b>패스워드</td>
<td width="100" align="center"><font color="black"><b>값</td>
<td width="100" align="center"><font color="black"><b>최대수</td>
<td width="100" align="center"><font color="black"><b>가입일자</td>
<td width="100" align="center"><font color="black"><b>만료기간</td>
<td width="120" align="center"><font color="black"><b>관리</td>
</tr>
<?
$userid = $_SESSION["userid"];
$field = ( $_GET["field"] == "" )?"userid":$_GET["field"];
$keyword = $_GET["keyword"];
if ( $field != "" && $keyword != "" )
{
$WHERE = " WHERE $field like '%${keyword}%' ";
}
####################### 페이징처리 ########################
$start = $_GET["start"];
$scale = 25;
$Sql = "select count(*) from cyworld_admin $WHERE ";
$Temp = mysql_fetch_array(mysql_query($Sql,$conn));
$Total = $Count = $Temp[0];
if( $start ) { $listNo = $Total - $start; } else { $listNo = $Total; $start = 0; }
$pageScale = 6;
$searchMethod = "&field=$field&keyword=$keyword";
$paging = newPaging( $Total, $scale, $pageScale, $start, "<img src='images/prev.gif' border='0' align='absmiddle'>", "<img src='images/next.gif' border='0' align='absmiddle'>", $searchMethod);
###################### 페이징처리 끝 #######################
$Sql = "SELECT * FROM cyworld_admin $WHERE ORDER BY idx desc ";
$Record = mysql_query($Sql,$conn);
while ( $Data = mysql_fetch_array($Record) )
{
//$Sql = "SELECT Count(*) FROM cyworld_visited WHERE userid='$Data[tid]' ";
//$Tmp = mysql_fetch_array(mysql_query($Sql,$conn));
?>
<tr bgcolor="white" height="18">
<td align="center"><?=$Data["idx"]?></td>
<td align="center"><a href='?kwak=<?=$Data["userid"]?>'><?=$Data["userid"]?></a></td>
<td align="center"><?=$Data["passwd"]?></td>
<td align="center"><?=$Data["tid"]?></td>
<td align="center"><?=$Data["maxSize"]?></td>
<td align="center"><?=substr($Data["regdate"],0,10)?></td>
<td align="center"><?=substr($Data["enddate"],0,10)?></td>
<td align="center">
[
<a href='#1' onClick="goEdit('<?=$Data["idx"]?>','<?=$Data["userid"]?>','<?=$Data["passwd"]?>','<?=$Data["maxSize"]?>','<?=$Data["tid"]?>','<?=substr($Data["enddate"],0,10)?>');">수정</a>
/
<a href='#1' onClick="goDelete('<?=$Data["idx"]?>','<?=$Data["userid"]?>')">삭제</a>
]
</td>
</tr>
<?
}
?>
</table><br>
<center><?=$paging?></center>
<table width='100%'>
<form name='search_frm'>
<tr>
<td align='right'>
<select name='field'>
<option value='userid'>아이디검색</option>
<option value='tid'>검색</option>
<option value='regdate'>가입일자검색</option>
<option value='enddate'>만료일자검색</option>
</select>
<input type='text' name='keyword' value='<?=$_GET[keyword]?>'>
<input type='submit' value='검색'>
<script>
document.search_frm.field.value = '<?=$field?>';
document.search_frm.keyword.focus();
</script>
</td>
</tr>
</form>
</table>
<!-- 컨테츠 종료 -->
</td>
</tr>
<tr>
<td valign='top' >
<!-- 회원정보수정 -->
<table width='300' cellspacing='1' cellpadding='0' bgcolor='gray' style="font-size:9pt">
<form name='edit_frm' action="?mode=edit" method="post">
<input type='hidden' name='idx' value=''>
<tr bgcolor='white' height='23'>
<td align=center colspan=2 ><div id='edit_layer'>수정하실 회원을 선택하세요.</div></td>
</tr>
<tr bgcolor='white'>
<td width='100' align='center'>아이디</td>
<td width='200' style='padding-left:5px'>
<input type='text' name='userid' >
</td>
</tr>
<tr bgcolor='white'>
<td width='100' align='center'>패스워드</td>
<td width='200' style='padding-left:5px'>
<input type='text' name='passwd' >
</td>
</tr>
<tr bgcolor='white'>
<td width='100' align='center'>값</td>
<td width='200' style='padding-left:5px'>
<input type='text' name='tid' >
</td>
</tr>
<tr bgcolor='white'>
<td width='100' align='center'>최대수</td>
<td width='200' style='padding-left:5px'>
<input type='text' name='maxSize' size='10'>
</td>
</tr>
<tr bgcolor='white'>
<td width='100' align='center'>만료기간</td>
<td width='200' style='padding-left:5px'>
<input type='text' name='enddate' size='10'> ex) 2007-05-28
</td>
</tr>
<tr bgcolor='white'>
<td align=center colspan=2 ><input type='submit' value='수정하기'></td>
</tr>
</form>
</table><br>
<!-- 회원정보수정 -->
</td>
</tr>
</table>
댓글 전체