<!--#include file="../conn.asp"-->
<!-- #include file="../admin/check_master.asp" -->
<!--#include file="../inc/publicfun.asp" -->
<link rel="stylesheet" href="../css/xmwuye.css">
<% 
dim sql
dim rs
seachstr=request("seachstr")
login_sort=request("login_sort")
tyname1="seachstr"
tyvalue1=seachstr
tyname2="kind"
tyvalue2=request("kind")
if login_sort="" then
	str_sort=""
else
	str_sort="logjs "&login_sort&","
end if
if request("seachstr")<>"" then
   sql="select clubuser_id,clubuser_name,clubuser_nickname,clubuser_password,clubuser_phone,clubuser_fax,clubuser_url,clubuser_email,clubuser_enter_count,clubuser_reg_date,clubuser_lasttime,clubuser_ip,payuser,bbsmanager,bbsadmin,jfmsign,bokeer from clubuser where "&request("kind")&" like '%"&seachstr&"%' order by "&str_sort&" clubuser_id desc"
else
   sql="select clubuser_id,clubuser_name,clubuser_nickname,clubuser_password,clubuser_phone,clubuser_fax,clubuser_url,clubuser_email,clubuser_enter_count,clubuser_reg_date,clubuser_lasttime,clubuser_ip,payuser,bbsmanager,bbsadmin,jfmsign,bokeer from clubuser order by "&str_sort&" clubuser_id desc"
end if
Set rs= Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,3,1
wzrep =30
wzpage = clng(request.querystring("page"))
if len(wzpage) = 0 or wzpage = 0 then wzpage = 1
rs.PageSize=wzrep
rs.AbsolutePage=wzpage
wzpagecount=rs.PageCount
wzcount=rs.RecordCount
%>
<body leftmargin="0" topmargin="5">
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
  <form name="form1" method="post" action="user_manage.asp">
      <tr bgcolor="#d6dff7"> 
        <td height="30" align="right" bgcolor="#f4f4f4"><div align="center">搜索用户： 
            <input name="seachstr" type="text" id="seachstr" size="20">
            <select name="kind">
              <option value="clubuser_id" selected>用户ID号</option>
              <option value="clubuser_name" >用户名</option>
              <option value="clubuser_nickname">昵称</option>
              <option value="clubuser_phone">电话</option>
              <option value="clubuser_ip">IP地址</option>
              <option value="clubuser_email">E-mail</option>
              <option value="clubuser_note">备注</option>
            </select>
            <input type="submit" name="Submit" value=" 搜 索 ">
          </div></td>
      </tr>
    </form>
  </table>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
      <td width="100%"> 
        <div align="center">
          <TABLE width=100% border=0 align=center>
		  <FORM METHOD=POST ACTION="user_manage.asp">
            <TR align=right>
	            <TD bgcolor="#FFFFFF"> 登录次数排序： 
                  <SELECT NAME="login_sort">
	               <option value="desc">降序
	               <option value="asc">升序
	              </SELECT>
	              <INPUT TYPE="submit" value="确定">
	            </TD>
             </TR>
         </FORM>
</TABLE>     
<table width="100%" border="0" cellpadding="0" cellspacing="1" bordercolorlight="#000000" bordercolordark="#FFFFFF" bgcolor="#666666">
          <tr bgcolor="#f4f4f4" height=22> 
            <td width="5%" align="center" height="20"><strong>ID号</strong></td>
            <td width="13%" align="center"><strong>用户名</strong></td>
            <td width="10%" align="center"><strong>博客</strong></td>
            <td  align="center"><strong>电子信箱</strong></td>
            <td width="8%" align="center"><strong>次数</strong></td>
            <td width="4%" align="center"><strong>IP</strong></td>
            
          <td width="10%" align="center"><strong>登记时间</strong></td>
            <td width="10%" align="center"><strong>最后登录</strong></td>
            
          <td width="7%" align="center"><strong>状态</strong></td>
            <td width="3%" align="center"><strong>总版主</strong></td>
			<td width="3%" align="center"><strong>分版主</strong></td>
            <td width="3%" align="center"><strong>认证用户</strong></td>
            <td width="3%" align="center"><strong>封锁</strong></td>
            <td width="3%" align="center"><strong>上传权限</strong></td>
            <td width="5%" align="center"><strong>修改</strong></td>
            <td width="5%" align="center"><strong>删除</strong></td>
          </tr>
<%
for i = 0 to wzrep-1
  if rs.eof then exit for
%>
          <tr bgcolor="#FFFFFF"> 
            <td  height=22 align="center"><FONT COLOR="blue"><%=rs("clubuser_id")%></FONT></td>
            <td align="center"><%=rs("clubuser_name")%></td>
            <td align="center">
                <%if rs("bokeer")=1 then%>
                <a href="user_delete.asp?id=<%=rs("clubuser_id")%>&m=3&bbsmanager=0"><font color=red>是</font></a> 
                <%else%>
                <a href="user_delete.asp?id=<%=rs("clubuser_id")%>&m=3&bbsmanager=1">否</a> 
                <%end if%>
            </td>
            <td align="center"><%=rs("clubuser_email")%></td>
            <td align="center"><%=rs("clubuser_enter_count")%></td>
            <td align="center"> <%=rs("clubuser_ip")%>&nbsp; </td >
            <td align="center"><%=year(rs("clubuser_reg_date"))%>/<%=month(rs("clubuser_reg_date"))%>/<%=day(rs("clubuser_reg_date"))%></td>
            <td align="center"><%=year(rs("clubuser_lasttime"))%>/<%=month(rs("clubuser_lasttime"))%>/<%=day(rs("clubuser_lasttime"))%></td>
            <td align="center">
                <%if rs("jfmsign")=1 then%>
                <a href="jfuser.asp?id=<%=rs("clubuser_id")%>&jfm=0"><font color=red>未激活</font></a> 
                <%else%>
                <a href="jfuser.asp?id=<%=rs("clubuser_id")%>&jfm=1">已激活</a> 
                <%end if%>
            </td>
            <td align="center">
                <%if rs("bbsmanager")=1 then%>
                <a href="user_delete.asp?id=<%=rs("clubuser_id")%>&m=1&bbsmanager=0"><font color=red>是</font></a> 
                <%else%>
                <a href="user_delete.asp?id=<%=rs("clubuser_id")%>&m=1&bbsmanager=1">否</a> 
                <%end if%>
            </td>
            <td align="center">
                <%if rs("bbsadmin")=1 then%>
                <a href="user_delete.asp?id=<%=rs("clubuser_id")%>&m=4&bbsmanager=0"><font color=red>是</font></a> 
                <%else%>
                <a href="user_delete.asp?id=<%=rs("clubuser_id")%>&m=4&bbsmanager=1">否</a> 
                <%end if%>
            </td>
            <td align="center">
                <%if rs("payuser")=1 then%>
                <a href="payusersign.asp?id=<%=rs("clubuser_id")%>&a=1&payuser=0"><font color=red>是</font></a> 
                <%else%>
                <a href="payusersign.asp?id=<%=rs("clubuser_id")%>&a=1&payuser=1">否</a> 
                <%end if%>
            </td>
            <td align="center">
                <%if rs("payuser")=3 then%>
                <a href="payusersign.asp?id=<%=rs("clubuser_id")%>&a=3&payuser=0"><font color=red>是</font></a> 
                <%else%>
                <a href="payusersign.asp?id=<%=rs("clubuser_id")%>&a=3&payuser=3">否</a> 
                <%end if%>
            </td>
            <td align="center">
                <%if rs("payuser")=2 then%>
                <a href="payusersign.asp?id=<%=rs("clubuser_id")%>&a=2&payuser=0"><font color=red>关</font></a> 
                <%else%>
                <a href="payusersign.asp?id=<%=rs("clubuser_id")%>&a=2&payuser=2">开</a> 
                <%end if%>
            </td>
            <td align="center">
                <%if instr(session("admin_qs"),2)>0 then%>
                <a href="user_edit.asp?id=<%=rs("clubuser_id")%>">修改</a> 
                <%end if%>
            </td>
            <td align="center">
                <%if instr(session("admin_qs"),3)>0 then%>
                <a href="user_delete.asp?id=<%=rs("clubuser_id")%>&m=2">删除</a> 
                <%end if%>
             </td>
          </tr>
        <%
 rs.movenext
 next
rs.close
set rs=nothing
%>
        <tr bgcolor="#f4f4f4" height=22> 
          <td height="25" colspan="16" align="right">&nbsp;共<font color=red><%= wzcount%></font>个用户<font color=red><%= wzrep%></font>/页 共<font color=red><%= wzpagecount%></font>页
		  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<%= FtbbsPage(wzpagecount,tyname1,tyvalue1,tyname2,tyvalue2)%>&nbsp;</td>
        </tr>
</table>
</td>
  </tr>
</table>
</body>
</html>
<%closedb%>
