📄 address.asp
字号:
<%@LANGUAGE="VBScript" CODEPAGE="936"%>
<!--#include file="SESSION.asp" -->
<!--#include file="CONN.asp" -->
<!--#include file="CHAR.asp" -->
<%
'=========================================================
' File: index.asp
' Version:1.1
' Date: 2003-8-3
' Script Written by allen
'Design by Fox
'=========================================================
' Copyright (C) CNMAYA.ORG. All rights reserved.
' Web: http://www.cnmaya.org,http://www.itmaya.com
' Email: allenzyk@cnmaya.org
'=========================================================
strsql="SELECT user.realname,user.email,user.username,user.regtime,user.usergroup,user.logno,user.isvalid,loginfo.logtime FROM [user] INNER JOIN loginfo ON user.username = loginfo.loguser where isvalid=true order by regtime desc"
set rs=server.CreateObject("adodb.recordset")
rs.open strsql,conn,1,1
if not rs.eof then
rs.PageSize =12 '每页记录条数
result_num=rs.RecordCount '记录总数
maxpage=rs.PageCount
page=request("page")
if Not IsNumeric(page) or page="" then
page=1
else
page=cint(page)
end if
if page<1 then
page=1
elseif page>maxpage then
page=maxpage
end if
rs.AbsolutePage=Page
else
result_num=0
maxpage=0
page=0
end if
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta http-equiv="Content-Language" content="zh-cn">
<title><%=classname%>同学录--成员列表</title>
<link href="css/class.css" type=text/css rel=stylesheet>
</head>
<body background="images/1.GIF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="776" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="3"><img src="images/top_t.gif" width="776" height="43"></td>
</tr>
<tr>
<td width="138"><img src="images/top_l.gif" width="138" height="39"></td>
<td width="584" align="right" bgcolor="#666B52"><a href="index.asp"><img src="images/toplogo.gif" alt="<%=classname%>同学录" width="200" height="39" border="0"></a></td>
<td width="54"><img src="images/top_r.gif" width="54" height="39"></td>
</tr>
<tr>
<td colspan="3"><table width="776" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="120" rowspan="2" valign="top" background="images/left_x.gif"><img src="images/left_img.gif" width="120" height="480"></td>
<td rowspan="2" valign="top" bgcolor="#F2F2EA"> <div align="center">
<!--#include file="top.asp" -->
</div>
<table width="618" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="189" valign="top"> <div align="center"><br>
<!--#include file="left.asp" -->
</div></td>
<td width="11"> </td>
<td width="418" valign="top"><table width="400" border="0" align="center" cellpadding="3" cellspacing="3" class="font1">
<tr>
<td>您的位置>成员列表</td>
</tr>
</table>
<div align="center">
<table width="400" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="400" border="0" cellpadding="0" cellspacing="0" background="images/gnymtbz.gif">
<tr>
<td width="135"><img src="images/cylb.gif" width="135" height="36"></td>
<td> </td>
<td width="100"><img src="images/gnymtyb.gif" width="100" height="36"></td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="400" border="0" cellpadding="0" cellspacing="0" background="images/n_bk.gif">
<tr>
<td align="center" class="information"><br> <table width="380" border="0" cellpadding="0" cellspacing="0" bgcolor="666b52">
<tr>
<td><table width="100%" border="0" cellpadding="2" cellspacing="1">
<tr align="center" bgcolor="E3E3CF" class="font1">
<td> <strong>状态</strong></td>
<td> <strong>姓名</strong></td>
<td> <strong>邮件地址</strong></td>
<td><strong>来访</strong></td>
<td> <strong>最后访问</strong></td>
</tr>
<% if not rs.eof then %>
<% for i=1 to rs.PageSize
usergroup=rs("usergroup")
select case usergroup
case 1'等待验证的班级成员
usergroup="验证中"
case 2 '班级成员
usergroup="成员"
case 3 '管理员
usergroup="<font color='#FF0000'>管理员</font>"
end select %>
<tr align="center" bgcolor="#FFFFFF" class="font1">
<td width="40" bgcolor="#f1f1eb"><%=usergroup%> </td>
<td width="44"> <a href="member.asp?id=<%=rs("username")%>"><%=rs("realname")%></a></td>
<td><a href="mailto:<%=rs("email")%>"><%=rs("email")%></a> </td>
<td width="27" bgcolor="#f1f1eb"><%=rs("logno")%></td>
<td><%=formatdate(rs("logtime"))%></td>
</tr>
<%rs.movenext:if rs.EOF then Exit For
next
end if%>
</table></td>
</tr>
</table>
<br>
<table width="380" border="0" cellpadding="0" cellspacing="1" bgcolor="#666B52">
<tr>
<td><table width="380" border="0" align="center" cellpadding="0" cellspacing="0" class="font1">
<tr>
<td align="center" bgcolor="#f1f1eb">
<% call LastNextPage(maxpage,page,result_num) %>
</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td><img src="images/n_foot.gif" width="400" height="10"></td>
</tr>
</table>
</div></td>
</tr>
</table></td>
<td width="38" valign="top" background="images/right_b.gif"><img src="images/right_b.gif" width="38" height="5"></td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="3"><img src="images/z_f.gif" width="776" height="26"></td>
</tr>
<tr>
<td colspan="3"> </td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -