📄 memberlist.jsp
字号:
<%
/*##################################################################**
**# LyBBS ver 1.2.b2 (1.2.beta-2版) / 凌云论坛 ver 1.2.b2 #**
**# #**
**# 版权所有: 凌云工作室 (原流星电脑工作室) #**
**# #**
**# 制作人 : 星语凌 『teddy (Yongshan Ye)』 #**
**# #**
**# 主页地址: http://www.unix-now.com/lybbs 凌云论坛主页 #**
**# http://www.ierp.info/lybbs 凌云论坛镜像站 #**
**# http://horseye@sina.com/ 凌云论坛支持信箱 #**
**# #**
**##################################################################*/
%>
<%@ include file="include/config.jsp"%>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="include/connect.jsp"%>
<%
int db=0;
String tempSTR="",a="";
//用户cookie变量声明
int id=0,styleid=0,membergone=0;
String cookieid="",cookiename="",usermode="",cookiemode="";
//日期定义
int now_year=0,now_month=0,now_day=0,now_hour=0,now_minute=0,now_second=0;
String now_date="",now_time="";
//定义boardprepare.jsp中的变量
String onlineview="",dispview="",boardtitle="",boardname="",title="",version="",copyright="",support="",programmer="",programemail="",homename="",homeurl="",togb="1",status="",maintainreason="",announcement="1",boardurl="",showfastlogin="",dispborn="",styleQuery="";
//定义本页变量
int membergrade=0,lastpostdb=0,lastposttopic=0,allregisternumber=0,allpostnumber=0,memberpostnumber=0;
String query="",membername="",memberemail="",membericq="",memberqq="",memberregistertime="",memberhomepage="",membergradetitle="",lastposttitle="";
ResultSet rs2;
int infosopen=0;
String errorinfo="";
%>
<%@ include file="include/boardprepare.jsp"%>
<%@ include file="include/style.jsp"%>
<%
rs=connect.executeQuery("select infosopen from style where adminselected='1'");
if(rs.next())
infosopen=rs.getInt(1);
tempSTR=request.getParameter("a");
if(tempSTR!=null && !tempSTR.equals(""))
a=tempSTR;
else a="1";
allregisternumber=connect.getRowNum("author where usermode!=1");
allpostnumber=connect.getRowNum("posts");
//分页变量定义
int e=20; //'每页显示的记录数
int totalpage=0; //'页面总数
int pages=1; //'显示的当前页面
int count=0; //'库中数据的总记录数
int from=0,to=0; //'从from篇到to篇
int p=0; //'数据库查询从p开始
//取页数
tempSTR=request.getParameter("pages");
if(tempSTR!=null && !tempSTR.equals(""))
pages=Integer.parseInt(tempSTR);
//分页预备
count=allregisternumber;
totalpage=((count%e==0)?(count/e):(count/e+1));
if(totalpage==0) totalpage=1;
if(pages>totalpage) pages=totalpage;
else if(pages<1) pages=1;
if(count!=0)
from=(pages-1)*e+1;
if(totalpage==pages)
to=count;
else if(count!=0)
to=from+e-1;
p= (pages-1)*e;
%>
<!--//html from here-->
<%@ include file="include/head.jsp"%>
<script language="JavaScript">
function changePages(){
var URL = document.changepages.pages.options[document.changepages.pages.selectedIndex].value;
location.href = URL; target = '_self';
}
</script>
<body <%=lbbody%>>
<%@ include file="include/userheader.jsp"%>
<br>
<table cellpadding=0 cellspacing=0 border=0 width=<%=tablewidth%> align=center>
<tr>
<td width=30% rowspan=2 valign=top>
<%@ include file="include/viceadbanner.jsp"%>
</td>
<td valign=top align=left>
<font face="宋体" color=<%=fontcolormisc%>>
<img src="images/closedfold.gif" border=0> <a href="index.jsp"><%=boardname%></a><br>
<img src="images/bar.gif" border=0><img src="images/openfold.gif" border=0> 用户列表
</font>
</td>
</tr>
</table>
<br>
<%
if(infosopen==2 && (cookiemode.equals("0") || cookiemode.equals("1")))
errorinfo="管理员设置了这个页面只有版主或副版主可以查看";
else if(infosopen==1 && cookiemode.equals("1"))
errorinfo="管理员设置了这个页面只有注册用户可以查看";
if(!errorinfo.equals("")) {
%>
<table cellpadding=0 cellspacing=0 border=0 width=<%=tablewidth%> bgcolor=<%=tablebordercolor%> align=center>
<tr>
<td>
<table cellpadding=6 cellspacing=1 border=0 width=100%>
<tr>
<td bgcolor=<%=miscbacktwo%> align=center><font color=<%=fontcolormisc%>><b>用户列表查看错误</b></font></td>
</tr>
<tr>
<td bgcolor=<%=miscbackone%>>
<font color=<%=fontcolormisc%>>
<b>关于查看资料出错的可能原因：</b>
<ul>
<li><b><%=errorinfo%></b>
</ul>
</font>
</td>
</tr>
</table>
</td>
</tr>
</table>
<%
}
else {
%>
<table width=<%=tablewidth%> align=center cellspacing=0 cellpadding=1 border=0 bgcolor=<%=tablebordercolor%>>
<tr>
<td>
<table cellpadding=6 cellspacing=1 border=0 width=100%>
<tr bgcolor=<%=forumcolorone%>>
<td colspan=5 valign=top>
>> <B>
<%
if(a.equals("2"))
out.print("发贴总数前 15 名");
else if(a.equals("5"))
out.print("最新 15 名注册用户");
else if(a.equals("3"))
out.print("以用户名排序");
else if(a.equals("1"))
out.print("以发贴总数排序");
else if(a.equals("4"))
out.print("以注册时间排序");
else if(a.equals("6"))
out.print("监狱中的犯人");
%>
</B> <<<BR><BR>
总注册用户数： <%=allregisternumber%> 人 发贴总数： <%=allpostnumber%> 篇</font>
</td>
<td colspan=5 align=right>
<form method=get action=memberlist.jsp>
<select name=a>
<option value=2 <%if(a.equals("2")) out.print("selected");%>>发贴总数前 15 名</option>
<option value=5 <%if(a.equals("5")) out.print("selected");%>>最新 15 名注册用户</option>
<option value=3 <%if(a.equals("3")) out.print("selected");%>>以用户名排序</option>
<option value=1 <%if(a.equals("1")) out.print("selected");%>>以发贴总数排序</option>
<option value=4 <%if(a.equals("4")) out.print("selected");%>>以注册时间排序</option>
<option value=6 <%if(a.equals("6")) out.print("selected");%>>监狱中的犯人</option>
</select>
<input type=submit value="排 序"><br>
</td>
</form>
</tr>
<tr bgcolor=<%=titlecolor%>>
<td align=center><b>用户名</b></td>
<td align=center><b>Email</b></td>
<td align=center><b>ICQ</b></td>
<td align=center><b>OICQ</b></td>
<td align=center><b>主页</b></td>
<td align=center><b>短消息</td>
<td align=center><b>最后发贴</td>
<td align=center><b>注册时间</b></td>
<td align=center><b>等级状态</b></td>
<td align=center><b>发贴总数</b></td>
</tr>
<%
query="select username,email,icq,qq,homepage,date_format(registertime,'%Y年%m月%d日 %H:%i') as registertime,grade,nposts from author where usermode!=1 and usermode!=4";
if(a.equals("1"))
query+=" order by nposts desc limit "+p+","+e;
else if(a.equals("2"))
query+=" order by nposts desc limit 15";
else if(a.equals("3"))
query+=" order by username limit "+p+","+e;
else if(a.equals("4"))
query+=" order by registertime desc limit "+p+","+e;
else if(a.equals("5"))
query+=" order by registertime desc limit 15";
else if(a.equals("6"))
query+=" and status='1' order by id limit "+p+","+e;
rs=connect.executeQuery(query);
while(rs.next()) {
membername=rs.getString(1);
memberemail=rs.getString(2);
membericq=rs.getString(3);
memberqq=rs.getString(4);
memberhomepage=rs.getString(5);
memberregistertime=rs.getString(6);
membergrade=rs.getInt(7);
memberpostnumber=rs.getInt(8);
if(memberhomepage.equals("http://"))
memberhomepage="";
rs2=connect.executeQuery2("select mname from grade where grade="+membergrade);
if(rs2.next())
membergradetitle=rs2.getString(1);
rs2=connect.executeQuery2("select db,groupid,title from posts where author='"+membername+"' and parentid=0 order by id desc limit 1");
if(rs2.next()) {
lastpostdb=rs2.getInt(1);
lastposttopic=rs2.getInt(2);
lastposttitle=rs2.getString(3);
}
else
lastpostdb=0;
%>
<tr bgcolor=<%=forumcolortwo%>>
<td> <a href=profile.jsp?action=show&member=<%=membername%>><%=membername%></a></td>
<td align=center><%if(memberemail.equals("")) out.println("没有"); else {%><a href=mailto:<%=memberemail%>><img border=0 src=images/email.gif></a><%}%></td>
<td align=center><%if(membericq.equals("")) out.println("没有"); else {%><a href="javascript:openScript('misc.jsp?action=icq&UIN=<%=membericq%>',450,300)"><img src=images/icq.bmp border=0 width=16 height=16></a><%}%></td>
<td align=center><%if(memberqq.equals("")) out.println("没有"); else {%><a href=http://search.tencent.com/cgi-bin/friend/user_show_info?ln=<%=memberqq%> target=_blank><img src=images/oicq.gif alt="查看 OICQ:<%=memberqq%> 的资料" border=0 width=16 height=16></a><%}%></td>
<td align=center><%if(memberhomepage.equals("")) out.println("没有"); else {%><a href=<%=memberhomepage%> target=_blank><img border=0 src=images/homepage.gif></a><%}%></td>
<td align=center><a href=javascript:openScript('messanger.jsp?action=msgsend&toname=<%=membername%>',420,320)><img src=images/message.gif border=0></a></td>
<td align=center>
<%if(lastpostdb!=0) {%><a href="topic.jsp?db=<%=lastpostdb%>&topic=<%=lastposttopic%>"><img border=0 src=images/openfold.gif alt="<%=lastposttitle%>"></a><%} else out.println("没有");%>
</td>
<td align=center><%=memberregistertime%></td>
<td align=center><a href="lookinfo.jsp?action=style" target="_blank"><%=membergradetitle%></a></td>
<td align=center><%=memberpostnumber%></td>
</tr>
<%
}
%>
</table>
</td>
</tr>
</table>
<%
if(!a.equals("2") && !a.equals("5")) {
%>
<br>
<table width=<%=tablewidth%> align=center cellspacing=0 cellpadding=1 border=0 bgcolor=<%=tablebordercolor%>>
<tr>
<td>
<table cellpadding=0 cellspacing=0 border=0 width=100%>
<form name=changepages>
<tr bgcolor=<%=menubackground%>>
<td>
<font face=宋体 color=<%=fontcolormisc%>>
共<b><%=totalpage%></b>页
当前第<b><%out.print(from+"-"+to);%></b>个
第<b><%=pages%></b>页
</font>
</td>
<%
if(totalpage!=1) {
%>
<td>
<A href=memberlist.jsp?a=<%=a%>&pages=1><IMG alt=首页 border=0 src=images/first.gif width=11 height=10></A>
<A href=memberlist.jsp?a=<%=a%>&pages=<%=(pages<2)?pages:(pages-1)%>><IMG alt=上一页 border=0 src=images/previous.gif width=11 height=10></A>
<A href=memberlist.jsp?a=<%=a%>&pages=<%=(pages>totalpage-1)?totalpage:(pages+1)%>><IMG alt=下一页 border=0 src=images/next.gif width=11 height=10></A>
<A href=memberlist.jsp?a=<%=a%>&pages=<%=totalpage%>><IMG alt=末页 border=0 src=images/last.gif width=11 height=10></A>
</td>
<td align=right>
转到：
<SELECT name=pages size=1 onchange="changePages()">
<%
for(int i=1;i<=totalpage;i++) {
if(i==pages) {
out.println("<OPTION value='memberlist.jsp?a="+a+"&pages="+i+"' selected>第"+i+"页</OPTION>");
}
else
out.println("<OPTION value='memberlist.jsp?a="+a+"&pages="+i+"'>第"+i+"页</OPTION>");
}
%>
</SELECT>
</td>
<%
}
%>
</tr>
</form>
</table>
</td>
</tr>
</table>
<%
}
}
%>
<br>
<%@ include file="include/foot.jsp"%>
<%
rs.close();
connect.close();
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -