📄 team.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 number=0,admini=0,admingrade=0,adminmode=0,lastpostdb=0,lastposttopic=0,alladminnumber=0,admindb=0,adminforumid=0,userimagewidth=0,userimageheight=0;
String adminname="",adminemail="",adminicq="",adminqq="",adminregistertime="",adminhomepage="",admingradetitle="",admingradegraphic="",lastposttitle="",lastpostat="",adminonline="",adminmembertitle="",adminpart="",admindbname="",adminforumname="",adminimage="",userimageurl="";
int infosopen=0;
String errorinfo="";
ResultSet rs2,rs3;
%>
<%@ 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);
alladminnumber=connect.getRowNum("author where usermode!=1 and usermode!=0");
//分页变量定义
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=alladminnumber;
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=<%=titlecolor%>>
<td width=25% align=center><font face="宋体" color=<%=titlefontcolor%>><b>管 理 人 员</b></font></td>
<td width=75% align=center><font face="宋体" color=<%=titlefontcolor%>><b>详 细 信 息</b></font></td>
</tr>
<%
rs=connect.executeQuery("select username,email,icq,qq,homepage,date_format(registertime,'%Y年%m月%d日 %H:%i') as registertime,grade,usermode,online,newmembertitle,newsocialpart,imagename,imageurl,imagewidth,imageheight from author where usermode!=0 and usermode!=1 order by usermode desc limit "+p+","+e);
while(rs.next()) {
adminname=rs.getString(1);
adminemail=rs.getString(2);
adminicq=rs.getString(3);
adminqq=rs.getString(4);
adminhomepage=rs.getString(5);
adminregistertime=rs.getString(6);
admingrade=rs.getInt(7);
adminmode=rs.getInt(8);
adminonline=rs.getString(9);
adminmembertitle=rs.getString(10);
adminpart=rs.getString(11);
adminimage=rs.getString(12);
userimageurl=rs.getString(13);
userimagewidth=rs.getInt(14);
userimageheight=rs.getInt(15);
if(adminhomepage.equals("http://"))
adminhomepage="";
rs2=connect.executeQuery2("select mname,mgraphic from grade where usermode="+(adminmode-1));
if(rs2.next()) {
admingradetitle=rs2.getString(1);
admingradegraphic=rs2.getString(2);
}
rs2=connect.executeQuery2("select db,groupid,title,date_format(postat,'%Y年%m月%d日 %H:%i') as postat from posts where author='"+adminname+"' and parentid=0 order by id desc limit 1");
if(rs2.next()) {
lastpostdb=rs2.getInt(1);
lastposttopic=rs2.getInt(2);
lastposttitle=rs2.getString(3);
lastpostat=rs2.getString(4);
}
else
lastpostdb=0;
admini++;
%>
<tr bgcolor=<%if(admini%2!=0) out.print(postcolortwo); else out.print(postcolorone);%>>
<td valign=top>
<table style="filter:glow(color=<%=titlecolor%>,strength=2)">
<%
if(adminonline.equals("1"))
out.println("<IMG SRC='images/online1.gif' width=15 height=15 alt='该用户目前在线'>");
else
out.println("<IMG SRC='images/offline1.gif' width=15 height=15 alt='该用户目前不在线'>");
%>
<font face="宋体" color="<%=adminnamecolor%>"><b><%=adminname%></b>
<%
if(adminmode==4)
out.println("<img src='images/teamad.gif' border=0 alt=此人为坛主 width=16 height=16>");
else if(adminmode==3)
out.println("<img src='images/teamsmo.gif' border=0 alt=此人为斑竹 width=16 height=16>");
else if(adminmode==2)
out.println("<img src='images/teammo.gif' border=0 alt=此人为副斑竹 width=16 height=16>");
%>
</font>
</table>
头衔：<font face="宋体" color=<%=postfontcolortwo%>><%if(!adminmembertitle.equals("")) out.print(adminmembertitle); else out.print("没有头衔");%></font><br>
<%if(!userimageurl.equals("")) out.println("<img src=\""+userimageurl+"\" width="+userimagewidth+" height="+userimageheight+">");else if(!adminimage.equals("")) out.println("<img src=avatars/"+adminimage+"><br>");%>
<img src="images/<%=admingradegraphic%>" border="0" width=100 height=16><br>
级别：<a href="lookinfo.jsp?action=style" target="_blank"><%=admingradetitle%></a><br>
门派: <%if(!adminpart.equals("")) out.print(adminpart);else out.print("无门无派");%>
</td>
<td valign=top>
<table cellspacing=0 cellpadding=0 border=0 width=100%>
<tr>
<td width=25% valign=top><font face="宋体" color=<%=postfontcolortwo%>>注册日期：</font></td>
<td width=75% valign=top><font face="宋体" color=<%=postfontcolortwo%>><%=adminregistertime%></font></td>
</tr>
<tr>
<td width=25% valign=top><font face="宋体" color=<%=postfontcolortwo%>>最后发言：</font></td>
<td width=75% valign=top><font face="宋体" color=<%=postfontcolortwo%>>
<%if(lastpostdb!=0) {%><a href="topic.jsp?db=<%=lastpostdb%>&topic=<%=lastposttopic%>"><%=lastposttitle%></a> (<%=lastpostat%>)<%} else out.println("用户还没有发帖！");%>
</td>
</tr>
<tr><td colspan=2> </td></tr>
<tr>
<td width=25% valign=top><font face="宋体" color=<%=postfontcolortwo%>>电子邮件：</font></td>
<td width=75% valign=top><font face="宋体" color=<%=postfontcolortwo%>><%if(adminemail.equals("")) out.println("没有"); else {%><a href=mailto:<%=adminemail%>><%=adminemail%></a><%}%></font></td>
</tr>
<tr>
<td width=25% valign=top><font face="宋体" color=<%=postfontcolortwo%>>主页：</font></td>
<td width=75% valign=top><font face="宋体" color=<%=postfontcolortwo%>><%if(adminhomepage.equals("")) out.println("没有"); else {%><a href=<%=adminhomepage%> target=_blank><%=adminhomepage%></a><%}%></font></td>
</tr>
<tr><td colspan=2><font face="宋体"> </font></td></tr>
<tr>
<td width=25% valign=top><font face="宋体" color=<%=postfontcolortwo%>>OICQ 号码：</font></td>
<td width=75% valign=top><font face="宋体" color=<%=postfontcolortwo%>><%if(adminqq.equals("")) out.println("没有"); else {%><a href=http://search.tencent.com/cgi-bin/friend/user_show_info?ln=<%=adminqq%> target=_blank><%=adminqq%></a><%}%></font></td>
</tr>
<tr>
<td width=25% valign=top><font face="宋体" color=<%=postfontcolortwo%>>ICQ 号码：</font></td>
<td width=75% valign=top><font face="宋体" color=<%=postfontcolortwo%>><%if(adminicq.equals("")) out.println("没有"); else {%><a href="javascript:openScript('misc.jsp?action=icq&UIN=<%=adminicq%>',450,300)"><%=adminicq%></a><%}%></font></td>
</tr>
<tr><td colspan=2><font face="宋体"> </font></td></tr>
<tr>
<td width=25% valign=top><font face="宋体" color=<%=postfontcolortwo%>>主持板块：</font></td>
<td width=75% valign=top>
<font face="宋体" color=<%=postfontcolortwo%>>
<%
number=connect.getRowNum("admin where authorname='"+adminname+"'");
if(number==0)
out.println(adminname+" 没有主持任何版块");
else {
rs2=connect.executeQuery2("select db from admin where authorname='"+adminname+"' order by id");
while(rs2.next()) {
admindb=rs2.getInt(1);
rs3=connect.executeQuery3("select dbname,forum from db where id="+admindb);
if(rs3.next()) {
admindbname=rs3.getString(1);
adminforumid=rs3.getInt(2);
rs3=connect.executeQuery3("select forumname from forum where id="+adminforumid);
if(rs3.next())
adminforumname=rs3.getString(1);
%>
<a href="db.jsp?db=<%=admindb%>"><%=admindbname%></a> (<%=adminforumname%>)<br>
<%
}
}
}
%>
</font>
</td>
</tr>
</table>
</td>
</tr>
<%
}
%>
</table>
</td>
</tr>
</table>
<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=team.jsp?pages=1><IMG alt=首页 border=0 src=images/first.gif width=11 height=10></A>
<A href=team.jsp?pages=<%=(pages<2)?pages:(pages-1)%>><IMG alt=上一页 border=0 src=images/previous.gif width=11 height=10></A>
<A href=team.jsp?pages=<%=(pages>totalpage-1)?totalpage:(pages+1)%>><IMG alt=下一页 border=0 src=images/next.gif width=11 height=10></A>
<A href=team.jsp?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='team.jsp?pages="+i+"' selected>第"+i+"页</OPTION>");
}
else
out.println("<OPTION value='team.jsp?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 + -