announcementedit.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]/        凌云论坛支持信箱    #**
**#                                                                #**
**##################################################################*/
%>
<%
if(submit.equals("提 交")) {
  if(cookiemode.equals("1")) {
    tempSTR=request.getParameter("postusername");
    if(tempSTR!=null)
      postusername=togb.equals("1")?connect.toGB(tempSTR):tempSTR;
    tempSTR=request.getParameter("postpassword");
    if(tempSTR!=null)
      postpassword=togb.equals("1")?connect.toGB(tempSTR):tempSTR;
  }
  tempSTR=request.getParameter("announceid");
  if(tempSTR!=null && !tempSTR.equals(""))
    announceid=Integer.parseInt(tempSTR);
  tempSTR=request.getParameter("announcetitle");
  if(tempSTR!=null)
    announcetitle=togb.equals("1")?connect.toGB(tempSTR):tempSTR;
  if(!announcetitle.equals(""))
    announcetitle=connect.toHtml(announcetitle);//去除无用的html链接
  tempSTR=request.getParameter("announcecontent");
  if(tempSTR!=null)
    announcecontent=togb.equals("1")?connect.toGB(tempSTR):tempSTR;
  if(!announcecontent.equals(""))
    announcecontent=connect.toBr(announcecontent);//把\n换br
  if(!announcetitle.equals("")) {
    if(cookiemode.equals("1")) {
      isadmin=connect.getRowNum("author where usermode=4 and username='"+postusername+"' and password='"+postpassword+"'");
      if(isadmin==0)
        isadmin=connect.getRowNum("admin where db="+db+" and authorname='"+postusername+"'");
      if(isadmin>0) {
        if(announceid!=0)
          postok=connect.executeUpdate("update announcement set author='"+postusername+"',title='"+announcetitle+"',content='"+announcecontent+"',postat=now() where id="+announceid);
        else
          postok=connect.executeUpdate("insert into announcement (db,author,title,content,postat) values ("+db+",'"+postusername+"','"+announcetitle+"','"+announcecontent+"',now())");
      }
      else {
        errorinfo="用户名或密码不正确！请重新输入！";
      }
    }
    else if(isadmin>0) {
      if(announceid!=0)
         postok=connect.executeUpdate("update announcement set author='"+cookiename+"',title='"+announcetitle+"',content='"+announcecontent+"',postat=now() where id="+announceid);
      else
         postok=connect.executeUpdate("insert into announcement (db,author,title,content,postat) values ("+db+",'"+cookiename+"','"+announcetitle+"','"+announcecontent+"',now())");
    }
    else {
      errorinfo="不是管理员！不能发布公告！";
    }
  }
  else {
    errorinfo="必须输入标题！";
  }
%>
  <table cellpadding=0 cellspacing=0 border=0 width=<%=tablewidth%> bgcolor=<%=tablebordercolor%> align=center>
   <tr>
    <td>
     <table cellpadding=3 cellspacing=1 border=0 width=100% style="TABLE-LAYOUT: fixed">
      <tr>
       <td bgcolor=<%=miscbacktwo%> valign=middle align=center>
         <font face="宋体" color=<%=fontcolormisc%>><b><%if(postok) out.println("论坛公告");else out.println("错误： 使用公告");%></b></font>
       </td>
      </tr>
      <tr>
       <td bgcolor=<%=miscbackone%> valign=middle>
        <font face="宋体" color=<%=fontcolormisc%>>
<%
if(postok) {
%>
         如果你的浏览器没有自动返回论坛，请点击下面的链接直接返回。
         <ul>
          <li><b>论坛公告已经发表。</b>
          <li><a href="announcement.jsp?db=<%=db%>">返回论坛公告</a>
          <li><a href="index.jsp">返回论坛首页</a>
         </ul>
         <meta http-equiv="refresh" content="5; url=announcement.jsp?db=<%=db%>">
<%
}
else {
%>
          <b>关于使用公告错误的详细原因：</b>
          <ul>
           <li><b><%=errorinfo%></b>
           <li>您是否需要查看<a href="javascript:openScript('help.jsp',500,400)">帮助文件</a>?
          </ul>
          <b>产生使用公告错误的可能原因：</b>
          <ul>
           <li>密码错误
           <li>用户名错误
           <li>您不是<a href="register.jsp" >注册</a>用户
          </ul>
          <br><br>
          <center>&lt;&lt; <a href="javascript:history.go(-1)">返回上一页</a></center>
<%
}
%>
        </font>
       </td>
      </tr>
     </table>
    </td>
   </tr>
  </table>
<%
}
else {
  if(announceid!=0) {
    rs=connect.executeQuery("select title,content from announcement where id="+announceid);
    if(rs.next()) {
      announcetitle=rs.getString(1);
      announcecontent=rs.getString(2);
    }
  }
%>
<table cellpadding=0 cellspacing=0 border=0 width=<%=tablewidth%> bgcolor=<%=tablebordercolor%> align=center>
 <tr>
  <td>
   <table cellpadding=3 cellspacing=1 border=0 width=100%>
    <form action="announcement.jsp" method=post>
    <input type=hidden name="action" value="<%=action%>">
    <input type=hidden name="announceid" value="<%=announceid%>">
    <input type=hidden name="db" value="<%=db%>">
    <tr>
     <td bgcolor=<%=miscbacktwo%> colspan=2 align=center>
      <font face="宋体" color=<%=fontcolormisc%>><b>发表论坛公告</b></font>
     </td>
    </tr>
<%
if(cookiemode.equals("1")) {
%>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font face="宋体" color=<%=fontcolormisc%>>请输入您的用户名</font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><input type=text name="postusername" value="<%=cookiename%>"></a></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle><font face="宋体" color=<%=fontcolormisc%>>请输入您的密码</font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><input type=password name="postpassword" value=""></td>
    </tr>
<%
}
%>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=top width=40%><font face="宋体" color=<%=fontcolormisc%>><b>论坛公告标题</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=middle><input type=text name="announcetitle" size=60 maxlength=80 value="<%=announcetitle%>"></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=top>
       <font face="宋体" color=<%=fontcolormisc%>>
       <b>论坛公告内容</b><br>
        请输入您的论坛公告内容。
        <p>如果使用了表情字符转换，<br>LyBBS 将自动在公告中转换表情字符。
       </font>
     </td>
     <td bgcolor=<%=miscbackone%> valign=middle><textarea cols=60 rows=10 name="announcecontent"><%=announcecontent%></textarea></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbacktwo%> valign=middle colspan=2 align=center>
      <input type=submit value="提 交" name=submit> &nbsp; <input type="reset" name="Clear">
     </td>
    </tr>
    </form>
   </table>
  </td>
 </tr>
</table>
<%
}
%>