www.gusucode.com > 盐城分类信息网asp源码程序 > admin/userlist.asp
<!--#include file=conn.asp--> <!--#include file=cookies.asp--> <meta http-equiv="Content-Language" content="zh-cn"> <link href="inc_style.css" rel="stylesheet" type="text/css"> <script> function loadThreadFollow(t_id,b_id){ var targetImg =eval("document.all.followImg" + t_id); var targetDiv =eval("document.all.follow" + t_id); if ("object"==typeof(targetImg)){ if (targetDiv.style.display!='block'){ targetDiv.style.display="block"; }else{ targetDiv.style.display="none"; } } } </script> <SCRIPT language=JavaScript> function showoperatealert(id) { if (id==1) { { thisForm.target='_self'; thisForm.action="user_del.asp"; thisForm.submit(); } } if (id==2) { { thisForm.target='_self'; thisForm.action="user_vip.asp"; thisForm.submit(); } } if (id==3) { { thisForm.target='_self'; thisForm.action="user_vipdel.asp"; thisForm.submit(); } } } function CheckAll(form) { for (var i=0;i<form.elements.length;i++) { var e = form.elements[i]; if (e.name != 'chkall' ) e.checked = form.chkall.checked; } } //--> </SCRIPT> <style type="text/css"> <!-- body { background-color: #E7EEF5; margin-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; } --> </style><div align="center"> <table width="100%" border="1" align="center" cellpadding="3" cellspacing="0" bordercolorlight="#335078" bordercolordark="#FFFFFF" bgcolor="#C5D5E4" style="font-size:12px; letter-spacing:1px;"> <tr bgcolor="#B6EBC4"> <td width="55%" height="20" bgcolor="#E8EEF4" style="margin-top: 0; margin-bottom: 0"> <FORM name=sou1 action="?cnmai=1" method=POST style="line-height: 100%; margin-top: 0; margin-bottom: 0"> <p align="center">用户名: <input type="text" name="T1" size="10"> <input type="submit" value="查找" name="B1"> </form> </td> <td width="45%" height="20" bgcolor="#E8EEF4" style="margin-top: 0; margin-bottom: 0"> <FORM name=sou2 action="?cnmai=2" method=POST style="line-height: 100%; margin-top: 0; margin-bottom: 0"> <p align="center">姓名: <input type="text" name="T2" size="10"> <input type="submit" value="查找" name="B1"> </form> </td> </tr> <tr> <td width="88%" height="29" colspan="2" bgcolor="#C5D5E4"> <p align="center"><font color="#0000FF"><a href="?cnmai=3"> <font color="#0000FF">VIP会员</font></a></font>---<a href="?cnmai=4">非VIP会员</a>---<a href="?">全部会员</a></td> </tr> </table> </div> <div align="center"> <center> <table width="100%" border="1" align="center" cellpadding="3" cellspacing="0" bordercolorlight="#335078" bordercolordark="#FFFFFF" bgcolor="#C5D5E4" style="font-size:12px; letter-spacing:1px;"> <FORM name=thisForm action="" method=POST style="line-height: 100%; margin-top: 0; margin-bottom: 0"> <% dim rs,sql,k,cnmai,rs1 dim ThisPage,Pagesize,Allrecord,Allpage if request("page")="" then ThisPage=1 else ThisPage=request("page") end if cnmai=request("cnmai") set rs = Server.CreateObject("ADODB.RecordSet") set rs1 = Server.CreateObject("ADODB.RecordSet") Select Case cnmai Case "1" sql = "select * from [user] where username like '%"&trim(request("T1"))&"%' order by zcdata desc,id desc" Case "2" sql = "select * from [user] where name like '%"&trim(request("T2"))&"%' order by zcdata desc,id desc" Case "3" sql = "select * from [user] where vip=1 order by zcdata desc,id desc" Case "4" sql = "select * from [user] where vip<>1 order by zcdata desc,id desc" Case Else sql="select * from [user] order by zcdata desc,id desc" End Select rs.open sql,conn,1,1 if rs.eof then response.write "<li>还没有用户数据!" response.end end if rs.Pagesize=20 Pagesize=rs.Pagesize Allrecord=rs.Recordcount Allpage=rs.Pagecount if ThisPage<1 then ThisPage=1 end if On Error Resume Next rs.move (ThisPage-1)*Pagesize k=0 %> <tr bgcolor="#B6EBC4"> <td width="5%" height="30" bgcolor="#C5D5E4" > <p align="center">编号</td> <td width="15%" height="30" bgcolor="#C5D5E4" > <p align="center">姓名</td> <td width="11%" height="30" bgcolor="#C5D5E4" > <p align="center">登陆帐号</td> <td width="9%" height="30" bgcolor="#C5D5E4" > <p align="center">登陆次数</td> <td width="7%" height="30" bgcolor="#C5D5E4" > <p align="center">积分</td> <td width="7%" height="30" bgcolor="#C5D5E4"> <p align="center">货币</td> <td width="9%" height="30" bgcolor="#C5D5E4" > <p align="center">最后登陆</td> <td width="7%" height="30" bgcolor="#C5D5E4" > <p align="center">道具</td> <td width="4%" height="30" align="center" bgcolor="#C5D5E4"> 颜色</td> <td width="5%" height="30" align="center" bgcolor="#C5D5E4" > 置顶</td> <td width="5%" height="30" align="center" bgcolor="#C5D5E4" > 图片</td> <td width="5%" height="30" align="center" bgcolor="#C5D5E4" > 验证</td> <td width="6%" height="30" align="center" bgcolor="#C5D5E4" > 操作</td> <td width="5%" height="30" align="center" bgcolor="#C5D5E4" > 选择</td> </tr> <% dim id do while not rs.eof id=rs("id") %> <tr onmouseover="this.style.backgroundColor='#EFE8D6';return true;" onmouseout="this.style.backgroundColor='#FFFFFF';"> <td width="5%" height="25" bgcolor="#E3EBF2" > <p align="center"><%=k+1%></td> <td width="15%" height="25" bgcolor="#E3EBF2" > <p align="center"><%=rs("name")%><%if rs("vip")=1 then%><font color="#0000FF">[VIP]</font><%end if%></td> <td width="11%" height="25" bgcolor="#E3EBF2" > <p align="center"><%=rs("username")%></td> <td width="9%" height="25" bgcolor="#E3EBF2" > <p align="center"><%=rs("dlcs")%></td> <td width="7%" height="25" bgcolor="#E3EBF2" > <p align="center"><%=rs("jf")%></td> <td width="7%" height="25" bgcolor="#E3EBF2" > <p align="center"><%=rs("hb")%></td> <td width="9%" height="25" bgcolor="#E3EBF2" > <p align="center"><%=datevalue(rs("zcdata"))%></td> <td width="7%" height="25" bgcolor="#E3EBF2" > <p align="center"> <img border="0" src="img/r3.gif"></td> <td width="4%" height="25" align="center" bgcolor="#E3EBF2" > <%=rs("a")%></td> <td width="5%" height="25" align="center" bgcolor="#E3EBF2" > <%=rs("b")%></td> <td width="5%" height="25" align="center" bgcolor="#E3EBF2" > <%=rs("c")%></td> <td width="5%" height="25" align="center" bgcolor="#E3EBF2" > <%=rs("d")%></td> <td width="6%" height="25" align="center" bgcolor="#E3EBF2" > <font color="#FF0000"> <span id="followImg<%=k%>" style="CURSOR: hand" onclick="loadThreadFollow(<%=k%>,5)"> 面版</span></font></td> <td width="5%" height="25" align="center" bgcolor="#E3EBF2" > <input type="checkbox" name="selectedid" value="<%=trim(rs("username"))%>"></td> </tr> <tr style="display:none" id="follow<%=k%>"> <td height="25" colspan="14" bgcolor="#E3EBF2"> <table width="98%" border="1" align="center" cellpadding="3" cellspacing="0" bordercolorlight="#335078" bordercolordark="#FFFFFF" bgcolor="#C5D5E4" style="font-size:12px; letter-spacing:1px;"> <tr bgcolor="#B6EBC4"> <td bgcolor="#C5D5E4"> <p align="center"><%if rs("vip")=0 then%><a href="user_vip.asp?selectedid=<%=trim(rs("username"))%>"><font color="#0000FF">设为VIP会员</font></a><%else%><a href="user_vipdel.asp?selectedid=<%=trim(rs("username"))%>"><font color="#FF0000">取消VIP</font></a><%end if%></td> <td bgcolor="#C5D5E4"><font color="#666666"><a href="#" ONCLICK="window.open('user_editzj.asp?id=<%=id%>','Sample','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=no,copyhistory=no,width=489,height=330,left=300,top=100')">修改资料</a></font></td> <td bgcolor="#C5D5E4"><font color="#666666"><a href="#" ONCLICK="window.open('user_editpass.asp?id=<%=id%>','Sample','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=no,copyhistory=no,width=180,height=35,left=300,top=100')">修改密码</a></font></td> <td bgcolor="#C5D5E4"><font color="#666666"><a href="#" ONCLICK="window.open('user_edithb.asp?id=<%=id%>','Sample','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=no,copyhistory=no,width=180,height=35,left=300,top=100')">修改货币</a></font></td> <td bgcolor="#C5D5E4"><font color="#666666"><a href="#" ONCLICK="window.open('user_editdj.asp?id=<%=id%>','Sample','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=no,copyhistory=no,width=200,height=150,left=300,top=100')">修改道具</a></font></td> <td bgcolor="#C5D5E4"><font color="#666666"><a href="#" ONCLICK="window.open('user_editmail.asp?id=<%=id%>','Sample','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=no,copyhistory=no,width=355,height=328,left=300,top=100')">发送邮件</a></font></td> <td bgcolor="#C5D5E4"> <a target="_blank" title="查看最后登陆IP" href="http://www.52.la/Sub/IP/ListAddress.asp?ip=<%=rs("ip")%>"> <font color="#FF0000">最后登陆IP:<%=rs("ip")%></font></a></td> <td bgcolor="#C5D5E4"><font color="#0000FF"> <a href="user_del.asp?selectedid=<%=trim(rs("username"))%>"><font color="#0000FF">直接删除</font></a></font></td> <td bgcolor="#C5D5E4"><font color="#666666"> <% dim m set rs1=conn.execute("select count(id) from [xinxi] where username='"&rs("username")&"'") m=rs1(0) rs1.close %> <a target="_blank" href="user_gl.asp?id=<%=id%>">用户管理区域</a>[<%=m%>条]</font></td> </tr> </table> </td> </tr> <% k=k+1 rs.movenext if k>=Pagesize then exit do loop rs.close set rs=nothing set rs1=nothing closedb %> <tr> <td height="30" colspan="14" bgcolor="#E3EBF2"> <table width="98%" border="1" align="center" cellpadding="3" cellspacing="0" bordercolorlight="#335078" bordercolordark="#FFFFFF" bgcolor="#C5D5E4" style="font-size:12px; letter-spacing:1px;"> <tr bgcolor="#B6EBC4"> <td height="31" colspan="4" align="center" bgcolor="#DBE4EE"> <p align="center"> <INPUT onclick=CheckAll(this.form) type=checkbox value=on name=chkall>选中所有记录 <input onclick=javascript:showoperatealert(1) type="submit" value="删除用户" name="B1"> <input onclick=javascript:showoperatealert(2) type="submit" value="设为VIP" name="B2" style="color: #0000FF"> <input onclick=javascript:showoperatealert(3) type="submit" value="取消VIP" name="B3"></td> </tr> <tr> <td height="17" width="151" align="center"> 共有 <font color="#CC5200"><%=Allrecord%></font> 条记录</td> <td height="17" width="181" align="center"> 共 <font color="#CC5200"><%=Allpage%></font> 页</td> <td height="17" width="237" align="center"> 现在是第 <font color="#CC5200"><%=ThisPage%></font> 页</td> <td height="17" width="200" align="center"> <% if ThisPage<2 then response.write "<font color=""#808080"">首页</font> " response.write "<font color=""#808080"">上一页</font> " else response.write "<a href=?page=1&t1="&trim(request("t1"))&">首页</a> " response.write "<a href=?page="&ThisPage-1&"&t1="&trim(request("t1"))&">上一页</a> " end if if Allpage-ThisPage<1 then response.write "<font color=""#808080"">下一页</font> " response.write "<font color=""#808080"">尾页</font> " else response.write "<a href=?page="&(ThisPage+1)&"&t1="&trim(request("t1"))&">下一页</a> " response.write "<a href=?page="&Allpage&"&t1="&trim(request("t1"))&">尾页</a> " end if %></td> </tr> </table> </td> </tr> </form> </table></center> </div>