📄 usertop.asp
字号:
<!--#include file="conn.asp"-->
<!--#include file="top.asp"-->
<html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>会员排行TOP10</title>
</head>
<style>
a:link { color: #EEEEEE; text-decoration: none }
a:visited { color: #EEEEEE; text-decoration: none }
a:active { color: #EEEEEE; text-decoration: none }
a:hover { color: #c0c0c0; text-decoration: none; position: relative; right: 0px; top: 1px }
body { color: #EEEEEE; font-family: 宋体; font-size: 9pt; line-height: 150%; scrollbar-highlight-color: #1A3042; scrollbar-darkshadow-color: #ffffff; scrollbar-shadow-color: #ffffff; scrollbar-3dlight-color: #ffffff; scrollbar-track-color: #ffffff; scrollbar-arrow-color: #eeeeee; scrollbar-base-color: #1A3042 }
td { color: #eeeeee; font-family: 宋体; font-size: 9pt; line-height: 150% }
td.left { color: #eeeeee; font-family: 宋体; font-size: 9pt; line-height: 150% }
td.tilte { color: #eeeeee; font-family: 宋体; font-size: 9pt; line-height: 13pt }
</style>
<body bgcolor="#1A4051">
<div align="center">
<center>
<table border="1" width="773" cellspacing="1" cellpadding="0" style="border-collapse: collapse" bordercolor="#111111">
<TR>
<TD width=107 bgcolor="#2E5667">
<p align="center">会员</TD>
<TD width=56 align="center" bgcolor="#2E5667">
积分</TD>
<td width=123 bgcolor="#2E5667">
<p align="center">真实姓名</td>
<td width=36 bgcolor="#2E5667">
<p align="center">性别</td>
<td width=129 bgcolor="#2E5667">
<p align="center">OICQ</td>
</TR>
<%
m=0
set rs=conn.execute("SELECT top 10 points,id,username,truename,sex,oicq FROM user order by points desc")
if not Rs.eof then
do while not rs.eof
m=m+1
%>
<TR>
<TD width=107 bgcolor="#30393D"> <%=m%>.<a href="userinf.asp?id=<%=rs("id")%>"><%=rs("UserName")%></a></TD>
<TD width=56 align="center" bgcolor="#30393D"><%=rs("points")%> </TD>
<td width=123 align="center" bgcolor="#30393D"><%=rs("truename")%> </td>
<td width=36 align="center" bgcolor="#30393D"><% if rs("sex")=1 then%>男<%else%>女<%end if%> </td>
<td width=129 align="center" bgcolor="#30393D"><%=rs("oicq")%> </td>
</TR>
<%
rs.movenext
loop
else
response.write "尚无收录"
end if
rs.close
%>
</table>
</center>
</div>
<div align="center">
<!--#include file="friendsite.asp"-->
</div>
<br>
</body>
</html>
<%
set rs=nothing
conn.close
set conn=nothing%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -