📄 whosonline.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="",action="";
//用户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="";
%>
<%@ include file="include/boardprepare.jsp"%>
<%@ include file="include/style.jsp"%>
<%
int onlinedb=0,number=0,userimagewidth=0,userimageheight=0;
String onlineimage="",onlinename="",onlinelogintime="",onlinelastactivetime="",onlinelocation="",userimageurl="";
ResultSet rs2;
int infosopen=0;
String errorinfo="";
rs=connect.executeQuery("select infosopen from style where adminselected='1'");
if(rs.next())
infosopen=rs.getInt(1);
%>
<!--//html from here-->
<%@ include file="include/head.jsp"%>
<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 {
number=connect.getRowNum("author where online='1'");
%>
<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%> valign=middle colspan=7 align=center><font face="宋体" color=<%=fontcolormisc%>><b>在线用户列表</b> (共 <%=number%> 人)</font>
</td>
</tr>
<tr>
<td bgcolor=<%=miscbackone%> align=center><font face="宋体" color=<%=fontcolormisc%>><b>头像</b></font></td>
<td bgcolor=<%=miscbackone%> align=center><font face="宋体" color=<%=fontcolormisc%>><b>用户名</b></font></td>
<td bgcolor=<%=miscbackone%> align=center><font face="宋体" color=<%=fontcolormisc%>><b>当前位置</b></font></td>
<td bgcolor=<%=miscbackone%> align=center ><font face="宋体" color=<%=fontcolormisc%>><b>最后动作</b></font></td>
<td bgcolor=<%=miscbackone%> align=center ><font face="宋体" color=<%=fontcolormisc%>><b>登陆时间</b></font></td>
<td bgcolor=<%=miscbackone%> align=center ><font face="宋体" color=<%=fontcolormisc%>><b>最近活动时间</b></font></td>
</tr>
<%
rs=connect.executeQuery("select imagename,username,db,date_format(logintime,'%Y-%m-%d %H:%i') as logintime,date_format(lastactivetime,'%Y-%m-%d %H:%i') as lastactivetime,imageurl,imagewidth,imageheight from author where online='1' order by usermode desc,id");
while(rs.next()) {
onlineimage=rs.getString(1);
onlinename=rs.getString(2);
onlinedb=rs.getInt(3);
onlinelogintime=rs.getString(4);
onlinelastactivetime=rs.getString(5);
userimageurl=rs.getString(6);
userimagewidth=rs.getInt(7);
userimageheight=rs.getInt(8);
if(onlinedb==0)
onlinelocation="论坛首页";
else {
rs2=connect.executeQuery2("select dbname from db where id="+onlinedb);
if(rs2.next())
onlinelocation=rs2.getString(1);
}
%>
<tr>
<td bgcolor=<%=miscbackone%> nowrap align=center><%if(!userimageurl.equals("")) out.println("<img src=\""+userimageurl+"\" width="+userimagewidth+" height="+userimageheight+">");else if(onlineimage.equals("")) out.println("没有");else out.println("<img src=avatars/"+onlineimage+">");%></td>
<td bgcolor=<%=miscbackone%> nowrap align=center><a href="profile.jsp?action=show&member=<%=onlinename%>" target=_blank><font face="宋体" color=<%=fontcolormisc%>><b><%=onlinename%></b></font></a></td>
<td bgcolor=<%=miscbackone%> nowrap><font face="宋体" color=<%=fontcolormisc%>><%=onlinelocation%></font></td>
<td bgcolor=<%=miscbackone%>><font face="宋体" color=<%=fontcolormisc%>>查看论坛信息</font></td>
<td bgcolor=<%=miscbackone%> nowrap align=center><font face="宋体" color=<%=fontcolormisc%>><%=onlinelogintime%></font></td>
<td bgcolor=<%=miscbackone%> nowrap align=center><font face="宋体" color=<%=fontcolormisc%>><%=onlinelastactivetime%></font></td>
</tr>
<%
}
%>
</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 + -