?? 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>
<p align="center"><img border="0" src="img/list_bo.gif" width="600" height="12">
</p>
<div align="center">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#CCCCCC" width="71%" height="49">
<tr>
<td width="55%" height="20" 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" 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">
<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 border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#FF9900" width="85%" height="30">
<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>
<td width="4%" height="30" bgcolor="#FEEEBC" bordercolor="#CC9900">
<p align="center">編號</td>
<td width="12%" height="30" bgcolor="#FEEEBC" bordercolor="#CC9900">
<p align="center">姓名</td>
<td width="11%" height="30" bgcolor="#FEEEBC" bordercolor="#CC9900">
<p align="center">登陸帳號</td>
<td width="7%" height="30" bgcolor="#FEEEBC" bordercolor="#CC9900">
<p align="center">登陸次數</td>
<td width="7%" height="30" bgcolor="#FEEEBC" bordercolor="#CC9900">
<p align="center">積分</td>
<td width="7%" height="30" bgcolor="#FEEEBC" bordercolor="#CC9900">
<p align="center">貨幣</td>
<td width="9%" height="30" bgcolor="#FEEEBC" bordercolor="#CC9900">
<p align="center">最后登陸</td>
<td width="4%" height="30" bgcolor="#FEEEBC" bordercolor="#CC9900">
<p align="center">道具</td>
<td width="5%" height="30" align="center" bgcolor="#FEEEBC" bordercolor="#CC9900">
顏色</td>
<td width="4%" height="30" align="center" bgcolor="#FEEEBC" bordercolor="#CC9900">
置頂</td>
<td width="5%" height="30" align="center" bgcolor="#FEEEBC" bordercolor="#CC9900">
圖片</td>
<td width="5%" height="30" align="center" bgcolor="#FEEEBC" bordercolor="#CC9900">
驗證</td>
<td width="6%" height="30" align="center" bgcolor="#FEEEBC" bordercolor="#CC9900">
操作</td>
<td width="4%" height="30" align="center" bgcolor="#FEEEBC" bordercolor="#CC9900">
選擇</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="4%" height="25" bordercolor="#CC9900">
<p align="center"><%=k+1%></td>
<td width="12%" height="25" bordercolor="#CC9900">
<p align="center"><%=rs("name")%><%if rs("vip")=1 then%><font color="#0000FF">[VIP]</font><%end if%></td>
<td width="11%" height="25" bordercolor="#CC9900">
<p align="center"><%=rs("username")%></td>
<td width="7%" height="25" bordercolor="#CC9900">
<p align="center"><%=rs("dlcs")%></td>
<td width="7%" height="25" bordercolor="#CC9900">
<p align="center"><%=rs("jf")%></td>
<td width="7%" height="25" bordercolor="#CC9900">
<p align="center"><%=rs("hb")%></td>
<td width="9%" height="25" bordercolor="#CC9900">
<p align="center"><%=datevalue(rs("zcdata"))%></td>
<td width="4%" height="25" bordercolor="#CC9900">
<p align="center">
<img border="0" src="img/r3.gif"></td>
<td width="5%" height="25" align="center" bordercolor="#CC9900">
<%=rs("a")%></td>
<td width="4%" height="25" align="center" bordercolor="#CC9900">
<%=rs("b")%></td>
<td width="5%" height="25" align="center" bordercolor="#CC9900">
<%=rs("c")%></td>
<td width="5%" height="25" align="center" bordercolor="#CC9900">
<%=rs("d")%></td>
<td width="6%" height="25" align="center" bordercolor="#CC9900">
<font color="#FF0000">
<span id="followImg<%=k%>" style="CURSOR: hand" onclick="loadThreadFollow(<%=k%>,5)">
面版</span></font></td>
<td width="4%" height="25" align="center" bordercolor="#CC9900">
<input type="checkbox" name="selectedid" value="<%=trim(rs("username"))%>"></td>
</tr>
<tr style="display:none" id="follow<%=k%>">
<td width="96%" height="25" colspan="14">
<table border="0" cellpadding="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" height="100%">
<tr>
<td bgcolor="#FFF5E8">
<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="#FFF5E8"><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="#FFF5E8"><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="#FFF5E8"><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="#FFF5E8"><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="#FFF5E8"><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="#FFF5E8">
<a target="_blank" title="查看最后登陸IP" href="http://ip.wisa.com.cn/ipsearch.php?textfield=<%=rs("ip")%>">
<font color="#FF0000">最后登陸IP:<%=rs("ip")%></font></a></td>
<td bgcolor="#FFF5E8"><font color="#0000FF">
<a href="user_del.asp?selectedid=<%=trim(rs("username"))%>"><font color="#0000FF">直接刪除</font></a></font></td>
<td bgcolor="#FFF5E8"><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 width="96%" height="30" colspan="14">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" height="67">
<tr>
<td height="50" colspan="4" align="center">
<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>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -