boardstatus.jsp

jsp bbs源代码

<%
/*##################################################################**
**#  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://[e-mail]/        凌云论坛支持信箱    #**
**#                                                                #**
**##################################################################*/
%>
<%
number=connect.getRowNum("author where online='1'");
dbusernumber=connect.getRowNum("author where online='1' and db="+db);
if(db==0) {
  registernumber=connect.getRowNum("author where usermode!='1' and online='1'");
  visitnumber=number-registernumber;
}
else {
  registernumber=connect.getRowNum("author where usermode!='1' and online='1' and db="+db);
  visitnumber=dbusernumber-registernumber;
}
rs=connect.executeQuery("select maxonlinenumber,date_format(recordat,'%Y-%m-%d %H:%i') as recordat,visittimes,clicktimes from boardstatus where id=1");
if(rs.next()) {
  maxonlinenumber=rs.getInt(1);
  recordat=rs.getString(2);
  visittimes=rs.getInt(3);
  clicktimes=rs.getInt(4);
}
if(number>maxonlinenumber) {
  connect.executeUpdate("delete from maxonlinerecord");
  connect.executeUpdate("update boardstatus set maxonlinenumber="+number+",recordat=now() where id=1");
  rs=connect.executeQuery("select id,username from author where online='1' order by usermode desc,id");
  while(rs.next()) {
     connect.executeUpdate("insert into maxonlinerecord (authorid,username,recordat) values ("+rs.getInt(1)+",'"+rs.getString(2)+"',now())");
  }
  rs=connect.executeQuery("select maxonlinenumber,date_format(recordat,'%Y-%m-%d %H:%i') as recordat from boardstatus where id=1");
  if(rs.next()) {
    maxonlinenumber=rs.getInt(1);
    recordat=rs.getString(2);
  }
}
//更新是否显示用户列表选项
if(action.equals("onlineview")) {
  if(onlineview.equals("1"))
     onlineview="0";
  else
     onlineview="1";
  connect.executeQuery("update author set onlineview='"+onlineview+"' where id="+cookieid);
}
%>
<table cellpadding=0 cellspacing=0 width=<%=tablewidth%> bgcolor=<%=tablebordercolor%> align=center>
 <tr>
  <td>
   <table cellpadding=6 cellspacing=1 width=100%>
    <tr>
<%
if(db==0) {
%>
     <td bgcolor=<%=titlecolor%> colspan=2><font color=<%=titlefontcolor%>>
      <B>-=> 论坛在线统计 （同时在线峰值：<%=maxonlinenumber%> 人，发生时刻：<%=recordat%>）</B></font>
   　 [<a href=index.jsp?action=onlineview><font color=<%=fontcolormisc%>>
<%
if(onlineview.equals("1"))
  out.println("关闭详细列表");
else
  out.println("打开详细列表");
     out.println("</font></a>]</font><BR></td>");
}
else {
%>
     <td bgcolor=<%=titlecolor%>><font color=<%=titlefontcolor%>>
      目前论坛总在线 <b><%=number%></b> 人，本分论坛共有 <b><%=dbusernumber%></b> 人在线。其中注册用户 <b><%=registernumber%></b> 人，访客 <b><%=visitnumber%></b> 人。　 [<a href=db.jsp?action=onlineview&db=<%=db%> ><font color=<%=fontcolormisc%>>关闭详细列表</font>
      </a>]</font><BR>
     </td>
<%
}
%>
    </tr>
    <tr>
<%
if(db==0) {
%>
     <td bgcolor=<%=forumcolorone%> align=center width=26>
      <img src=images/online.gif alt="论坛在线人数" width=16 height=16>
     </td>
     <td bgcolor=<%=forumcolortwo%> background=images/<%=otherbackpic%>>
    　<font color=<%=forumfontcolor%>>目前论坛总共有 <a href=whosonline.jsp><B><%=number%></B></a> 人在线。其中注册用户 <B><%=registernumber%></B> 人，访客 <B><%=visitnumber%></B> 人。 论坛总共被访问 <b><%=visittimes%></b> 次，共被点击 <b><%=clicktimes%></b> 次。<BR></font>
    　<font color=<%=forumfontcolor%>>在线名单图例：　<img src=images/<%=onlineadmin%> width=11 height=12> 论坛坛主，
                                        　<img src=images/<%=onlinesmod%> width=12 height=11> 分论坛斑竹，
                                        　<img src=images/<%=onlinemod%> width=12 height=11> 分论坛副斑竹，
                                        　<img src=images/<%=onlinemember%> width=12 height=11> 普通会员，
                                        　<img src=images/<%=onlineguest%> width=12 height=11> 客人或隐身会员<br>
      </font>
      <hr size=1 width=98%>
      <img src="" width=1 height=4><BR>
<%
}
else {
   out.println("<td bgcolor="+forumcolortwo+" background=images/"+otherbackpic+">");
}
if(onlineview.equals("1")) {
  String usericon="";
  String query="select id,db,usermode,username,logintime,lastactivetime from author where online='1'";
  if(db!=0)
    query+=" and db="+db;
  query+=" order by usermode desc,id";
  rs=connect.executeQuery(query);
  while(rs.next()) {
    onlineid=rs.getInt(1);
    onlinedb=rs.getInt(2);
    onlineusermode=rs.getInt(3);
    onlineusername=rs.getString(4);
    logintime=rs.getString(5);
    lastactivetime=rs.getString(6);
    if(onlinedb==0)
      onlineuserlocation="论坛首页";
    else {
      rs2=connect.executeQuery2("select dbname from db where id="+onlinedb);
      if(rs2.next())
        onlineuserlocation=rs2.getString(1);
    }
    if(onlineusermode==0)
      usericon=onlinemember;
    else if(onlineusermode==1)
      usericon=onlineguest;
    else if(onlineusermode==2)
      usericon=onlinemod;
    else if(onlineusermode==3)
      usericon=onlinesmod;
    else if(onlineusermode==4)
      usericon=onlineadmin;
    if(onlineusermode!=1)
       out.println("<a href=\"javascript:openScript('messanger.jsp?action=new&touser="+onlineusername+"',420,320)\"><img src=images/"+usericon+" border=0 width=12 height=11 alt=\"给"+onlineusername+"发送一个短消息\"></a>");
    else
       out.println("<img src=images/"+usericon+" width=12 height=11 alt=快注册呀！>");
%>
       <a href="javascript:O9(<%=onlineid%>)" nowarp TITLE="目前位置：<%=onlineuserlocation%>
目前动作：查看论坛信息
来访时间：<%=logintime%>
活动时间：<%=lastactivetime%>">
<%
      if(String.valueOf(onlineid).equals(cookieid))
         out.println("<font color="+onlineselfcolor+">"+onlineusername+"</font>");
      else out.println("<font color=#000000>"+onlineusername+"</font>");
      out.println("</a>");
  }
}
%>
     </td>
    </tr>
   </table>
  </td>
 </tr>
</table>
<%--
/*
<table cellpadding=0 cellspacing=0 width=95% bgcolor=#000000 align=center>
<tr><td><table cellpadding=6 cellspacing=1 width=100%>
<tr><td bgcolor=#90c8ff width=92%><font color=#333333></td>
<td bgcolor=#90c8ff width=8% align=center><a href="javascript:this.location.reload()"><img src=http://itshow/lb5000ii/non-cgi/images/refresh.gif border=0 width=40 height=12></a></td>
</tr>
<tr><td colspan=2 bgcolor=#e8f4ff background=http://itshow/lb5000ii/non-cgi/images/2.gif>　<a href="javascript:openScript('messanger.cgi?action=new&touser=horseye',420,320)"><img src=http://itshow/lb5000ii/non-cgi/images/messages1.gif border=0 width=12 height=11 alt="给horseye发送一个短消息"></a><a href=javascript:O9('horseye') TITLE="目前动作：查看论坛上的主题
来访时间：2002/05/07 17:36
活动时间：2002/05/07 17:46
操作系统：Windows 2000
浏 览 器：Internet Explorer 5.01
ＩＰ地址：已设置保密
来源鉴定：已设置保密"><font color=#0000FF>horseye</font></a> 　　&nbsp;</td></tr></table></td></tr></table><br>
*/
--%>