announcement.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]/        凌云论坛支持信箱    #**
**#                                                                #**
**##################################################################*/
%>
<table cellpadding=1 cellspacing=0 width=<%=tablewidth%> align=center>
 <tr>
<%
String announcementclue="";
if(announcement.equals("1")) {
  number=connect.getRowNum("announcement where db="+db);
  if(number!=0) {
    rs=connect.executeQuery("select id,title,date_format(postat,'%Y年%m月%d日') as postat from announcement where db="+db+" order by postat desc,id desc limit 1");
    if(rs.next()) {
      announcementid=rs.getInt(1);
      announcementtitle=rs.getString(2);
      announcementpostat=rs.getString(3);
    }
    if(db==0)
      announcementclue="总";
    else
      announcementclue="本分";
    announcementclue+="论坛的公告！共有 "+number+" 条！";
  }
  else {
    if(db==0) {
      announcementtitle="总论坛暂时无公告！";
      announcementclue="总论坛暂时无公告！";
    }
    else {
      announcementtitle="现在没有公告";
      announcementclue="本分论坛暂时无公告！";
    }
    announcementpostat=now_date;
 }
%>
  <td align=center width=2></td>
  <td align=center width=34>
    <img src="images/announce.gif" border=0 alt="<%=announcementclue%>" width=18 height=18>
  </td>
  <td align=left>
<%
      if(announcemove.equals("1")) {
         out.print("<marquee scrollamount=3><b><a href=announcement.jsp");
         if(db!=0) out.print("?db="+db);
         out.println(" target=_blank><font color="+forumfontcolor+">"+announcementtitle+"</font></a></b>　["+announcementpostat+"]</marquee>");
      }
      else {
         out.print("<b><a href=announcement.jsp");
         if(db!=0) out.print("?db="+db);
         out.println(" target=_blank><font color="+forumfontcolor+">"+announcementtitle+"</font></a></b>　["+announcementpostat+"]");
      }
%>
  </td>
  <td width=20>&nbsp;
  </td>
<%
}
else out.println("<td>&nbsp;</td>");
%>
  <td width=200 align=right>&nbsp;</td>
</form>
<%
if(db==0) {
%>
  <td width=90 align=right>
    <img src=images/team.gif border=0 width=16 height=16 alt="显示管理团队" align=absmiddle><font color=<%=forumfontcolor%>><a href=team.jsp target=_blank>管理团队</a>
  </td>
  <td width=90 align=right>
    <img src=images/userlist.gif border=0 width=16 height=16 alt="显示用户列表" align=absmiddle><font color=<%=forumfontcolor%>><a href=memberlist.jsp?a=4 target=_blank>用户列表</a>
  </td>
  <td width=90 align=right>
     <img src=images/top.gif border=0 width=16 height=16 alt="显示发贴量排名" align=absmiddle><font color=<%=forumfontcolor%>><a href=memberlist.jsp?a=1 target=_blank>发贴排名</a>
  </td>
<%
}
else {
%>
  <form action="db.jsp" method=post name="jump1">
   <td align=right width=270>
    <input type=hidden name=db value=<%=db%>>
    <select name="threadages">
     <option value="all">查看所有的主题</option>
     <option value="1">查看一天内的主题</option>
     <option value="2">查看两天内的主题</option>
     <option value="7">查看一星期内的主题</option>
     <option value="15">查看半个月内的主题</option>
     <option value="30">查看一个月内的主题</option>
     <option value="61">查看两个月内的主题</option>
     <option value="182">查看半年内的主题</option>
     <option value="255">查看一年内的主题</option>
    </select>
    <input type=submit name=submit value="查看">
   </td>
  </form>
<%
}
%>
 </tr>
</table>