userlist2.asp

庐江二中

<%PageName="UserList2"%>
<!--#include file="conn.asp"-->
<!--#include file="const.asp"-->
<!--#include file="INC/CHAR.INC"-->
<!--#include file=function.asp -->
<%
if not isempty(request("page")) then
currentPage=cint(request("page"))
else
currentPage=1
end if
%>
<!--#include file="top1.asp"-->

<table border="0" width="<%=TableWidth%>" cellspacing="0" cellpadding="0" bgcolor="<%=MainBgColor%>">
<tr>
<%=OutTable("left")%>
<td valign="top" align="center">
<%

sql="select * from Users order by UserPoint desc"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "<p align='center'>暂时没有会员注册</p>"
else
MaxPerPage=20
PageUrl="UserList2.asp"
totalPut=rs.recordcount
if currentpage<1 then currentpage=1
if (currentpage-1)*MaxPerPage>totalput then
if (totalPut mod MaxPerPage)=0 then
currentpage= totalPut \ MaxPerPage
else
currentpage= totalPut \ MaxPerPage + 1
end if
end if
if currentPage=1 then
showpage totalput,MaxPerPage,PageUrl
showContent
showpage totalput,MaxPerPage,PageUrl
else
if (currentPage-1)*MaxPerPage<totalPut then
rs.move  (currentPage-1)*MaxPerPage
dim bookmark
bookmark=rs.bookmark
showpage totalput,MaxPerPage,PageUrl
showContent
showpage totalput,MaxPerPage,PageUrl
else
currentPage=1
showpage totalput,MaxPerPage,PageUrl
showContent
showpage totalput,MaxPerPage,PageUrl
end if
end if
end if
rs.close
			
sub showContent
%>
<table border="1" width="90%" cellspacing="0" cellpadding="0" Class="TableLine" bordercolorlight="<%=MainBColor%>" bgcolor="<%=MainCColor%>">
<tr>
<td colspan=8 align=center height=20><a href=userlist.asp>==按时间排列==</a> <font color=<%=AlertFColor%>>==按积分排列==</font> <a href=userlistgirl.asp>===显示所有女会员===</a> <a href=userlistboy.asp>===显示所有男会员===</a></td>
</tr>
<tr>
<td width="7%" height=22 align=center bgcolor="<%=MainTColor%>">排名</td>
<td width="15%" height=22 align=center bgcolor="<%=MainTColor%>">会员</td>
<td width="10%" height=22 align=center bgcolor="<%=MainTColor%>">性别</td>
<td width="20%" height=22 align=center bgcolor="<%=MainTColor%>">信箱</td>
<td width="15%" height=22 align=center bgcolor="<%=MainTColor%>">主页</td>
<td width="10%" height=22 align=center bgcolor="<%=MainTColor%>">OICQ</td>
<td width="8%" height=22 align=center bgcolor="<%=MainTColor%>">积分</td>
<td width="15%" height=22 align=center bgcolor="<%=MainTColor%>">等级</td>
</tr>
<%
i=0
do while not rs.eof
i=i+1
%>
<tr>
<td width="7%" align=center><%=i+MaxPerPage*(currentpage-1)%>　</td>
<td width="15%" align=center><a style=cursr:hand title="会员资料：&#13;&#10;性别：<%if rs("Sex")=1 then%>男<%else%>女<%end if%>&#13;&#10;信箱：<%=rs("Email")%>&#13;&#10;OICQ：<%=rs("oicq")%>&#13;&#10;主页名称：<%=rs("UserWebName")%>&#13;&#10;主页地址：<%=rs("UserWebUrl")%>&#13;&#10;积分：<%=rs("UserPoint")%>&#13;&#10;等级：<%=Level(rs("UserLevel"))%>&#13;&#10;评论：<%=rs("WGBooks")%>&#13;&#10;回复：<%=rs("Replay")%>&#13;&#10;登陆：<%=rs("logins")%>&#13;&#10;登陆IP：<%=rs("LoginIP")%>&#13;&#10;最后登陆：<%=rs("lastlogin")%>&#13;&#10;注册时间：<%=rs("addDate")%>&#13;&#10;个人说明：&#13;&#10;<%if rs("sign")="" or isnull(rs("sign")) then%>无<%else%><%=htmlencode1(rs("sign"))%><%end if%>"><%=rs("username")%></a><%if DateValue(rs("addDate"))=date() then%> <img src="images/new.gif"><%end if%></td>
<td width="10%" align=center><%if rs("sex")=1 then%>男<%else%><font color="<%=AlertFColor%>">女</font><%end if%></td>
<td width="20%" align=center><%=rs("Email")%>　</td>
<td width="15%" align=center><a href="<%=rs("UserWebUrl")%>" target=_blank><%=rs("UserWebName")%></a>　</td>
<td width="10%" align=center><%=rs("oicq")%>　</td>
<td width="8%" align=center><%=rs("UserPoint")%>　</td>
<td width="15%" align=center><img src="images/level<%=rs("UserLevel")%>.gif" alt="<%=Level(rs("UserLevel"))%>" border=0></td>
</tr>
<%
if i>=MaxPerPage then exit do
rs.movenext
loop
%>
</table>
<%
end sub

function showpage(totalnumber,maxperpage,filename)
if totalnumber mod maxperpage=0 then
n= totalnumber \ maxperpage
else
n= totalnumber \ maxperpage+1
end if
%>
<form method=Post action="<%=filename%>">
<center>共<font color="<%=AlertFColor%>"><b><%=totalnumber%></b></font>位会员
<%if CurrentPage<2 then%>
&nbsp;首页 上一页&nbsp;
<%else%>
&nbsp<a href="<%=filename%>?page=1">首页</a>&nbsp;
<a href="<%=filename%>?page=<%=CurrentPage-1%>">上一页</a>&nbsp;
<%
end if
if n-currentpage<1 then
%>
下一页 末页
<%else%>
<a href="<%=filename%>?page=<%=CurrentPage+1%>">下一页</a>
<a href="<%=filename%>?page=<%=n%>">末页</a>
<%end if%>
&nbsp;页次:<strong><font color="<%=AlertFColor%>"><%=CurrentPage%>/<%=n%></font></strong>页
转到:<select name="page" size="1" onchange="javascript:submit()">
<%for i = 1 to n%>
<option value="<%=i%>" <%if cint(CurrentPage)=cint(i) then%> selected <%end if%>>第<%=i%>页</option>
<%next%>
</select>
</form>
<%end function%>
</td>
<%=OutTable("right")%>
</tr>
</table>
<%set rs=nothing%>
<!--#include file="copyright.asp"-->