postings.jsp

jsp bbs源代码

      <form action="postings.jsp" method=post name=delreply>
       <input type=hidden name="action" value="<%=action%>">
       <input type=hidden name="topic" value="<%=topic%>">
       <input type=hidden name="db" value="<%=db%>">
       <input type=hidden name="postid" value="<%=postid%>">
       <input type=hidden name="request" value="提 交">
      </form>
      <script>
       delreply("<%=postid%>");
      </script>
<%
      errortitle="删除回复帖失败";
      errorinfo="您已经取消了删除回复帖的操作！";
    }
    else if(submit.equals("提 交")){
      int postparentauthorid=0;
      String postparentauthor="";
      rs=connect.executeQuery("select authorid,author from posts where id="+postid);
      if(rs.next()) {
        postparentauthorid=rs.getInt(1);
        postparentauthor=rs.getString(2);
      }
      if(postparentauthorid!=0) {
        //减去用户货币值
        int delmoney=0,delexperience=0,delcharm=0,authormoney=0,authorexperience=0,authorcharm=0;
        rs=connect.executeQuery("select delmoney,delexperience,delcharm from encourage where id=1");
        if(rs.next()) {
          delmoney=rs.getInt(1);
          delexperience=rs.getInt(2);
          delcharm=rs.getInt(3);
          rs=connect.executeQuery("select money,experience,charm from author where id="+postparentauthorid);
          if(rs.next()) {
            authormoney=rs.getInt(1);
            authorexperience=rs.getInt(2);
            authorcharm=rs.getInt(3);
            if(authormoney<delmoney) delmoney=0;
            else delmoney=authormoney-delmoney;
            if(authorexperience<delexperience) delexperience=0;
            else delexperience=authorexperience-delexperience;
            if(authorcharm<delcharm) delcharm=0;
            else delcharm=authorcharm-delcharm;
            connect.executeUpdate("update author set money="+delmoney+",experience="+delexperience+",charm="+delcharm+",ndelete=ndelete+1 where id="+postparentauthorid);
          }
        }
      }
      postok=connect.executeUpdate("delete from posts where id="+postid);
      if(postok) {
        righttitle="删除回复帖成功";
        rightinfo="您已经成功的删除您选择的回复帖！";
      }
    }
  }
  else {
    errortitle="删除回复帖失败";
    errorinfo="这个操作必须由这个版的斑竹或副斑竹或发帖人完成并且只能删除回复帖！";
  }
}
else if(action.equals("movetopic")) {
  if(submit.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%>
    <form action="postings.jsp" method="post">
    <input type=hidden name="action" value="movetopic">
    <input type=hidden name="db" value="<%=db%>">
    <input type=hidden name="topic" value="<%=topic%>">
    <tr>
     <td bgcolor=<%=miscbacktwo%> align=center colspan=2>
      <font color=<%=fontcolormisc%>><b>移动主题</b></font>
     </td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%>><font color=<%=fontcolormisc%>><b>移动选项</b></font></td>
     <td bgcolor=<%=miscbackone%>>
      <font color=<%=fontcolormisc%>>
       <input name="leavemessage" type="radio" value="1" checked> 移动并保留一个已经锁定的主题在原论坛
       <br><input name="leavemessage" type="radio" value="0"> 移动并将此主题从原论坛中删除
      </font>
     </td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=top>
      <font color=<%=fontcolormisc%>><b>信息：</b>
        <p>这个是可选的，可以填入一些说明信息。
        <p>移动后的目标地址会自动输入在主题中。
      </font>
     </td>
     <td bgcolor=<%=miscbackone%>><textarea cols=80 rows=9 name="admincontent"></textarea></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=top><font color=<%=fontcolormisc%>><b>转移至：</b></font></td>
     <td bgcolor=<%=miscbackone%> valign=top>
      <select name="movetodb">
       <option value=0>选择一个论坛</option>
<%
rs=connect.executeQuery("select id,forumname from forum order by id");
  while(rs.next()) {
    out.println("<option value=0 style=background-color:"+titlecolor+">&gt;&gt;&gt; "+rs.getString(2)+" &lt;&lt;&lt;</option>");
    rs2=connect.executeQuery2("select id,dbname from db where forum="+rs.getInt(1)+" order by id");
    while(rs2.next()) {
      if(db!=rs2.getInt(1))
        out.println("<option value="+rs2.getInt(1)+">"+rs2.getString(2)+"</option>");
      else
        out.println("<option value=0>"+rs2.getString(2)+"</option>");
    }
  }
%>
      </select>
     </td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbacktwo%> colspan=2 align=center>
       <input type=submit name="request" value="提 交">
     </td>
    </tr>
    </form>
   </table>
  </td>
 </tr>
</table>
<%
  }
  else if(submit.equals("提 交")) {
    tempSTR=request.getParameter("movetodb");
    if(tempSTR!=null && !tempSTR.equals(""))
      movetodb=Integer.parseInt(tempSTR);
    tempSTR=request.getParameter("leavemessage");
    if(tempSTR!=null && !tempSTR.equals(""))
      leavemessage=tempSTR;
    tempSTR=request.getParameter("admincontent");
    if(tempSTR!=null && !tempSTR.equals(""))
      admincontent=togb.equals("1")?connect.toGB(tempSTR):tempSTR;
    if(!admincontent.equals(""))
      admincontent=connect.toHtml(admincontent);
    if(isadmin>0) {
      if(movetodb==0) {
        errortitle="移动帖子失败";
        errorinfo="您选择了错误的目标论坛！(请不要选择帖子所在的论坛和论坛的总分类！)";
      }
      else {
        rs=connect.executeQuery("select max(groupid) from posts where db="+movetodb);
        if(rs.next())
          maxtopic=rs.getInt(1);
        rs=connect.executeQuery("select dbname from db where id="+db);
        if(rs.next())
          movefromdbname=rs.getString(1);
        if(leavemessage.equals("0")) {
          rs=connect.executeQuery("select title from posts where db="+db+" and groupid="+topic+" and parentid=0");
          if(rs.next()) {
            movetitle=rs.getString(1);
            if(!movetitle.equals(""))
              movetitle=connect.toHtml(movetitle);//去除无用的链接信息
          }
          postok=connect.executeUpdate("update posts set db="+movetodb+",groupid="+(maxtopic+1)+",title='"+movetitle+"(==>转移自："+movefromdbname+")' where db="+db+" and groupid="+topic+" and parentid=0");
          if(postok) {
            //移动所有的回复帖
            connect.executeUpdate("update posts set db="+movetodb+",groupid="+(maxtopic+1)+" where db="+db+" and groupid="+topic+" and parentid!=0");
            //加入管理员的解释
            if(!admincontent.trim().equals("")) {
               rs=connect.executeQuery("select id from posts where db="+movetodb+" and groupid="+(maxtopic+1)+" and parentid=0");
               if(rs.next())
                 adminparentid=rs.getInt(1);
               connect.executeUpdate("insert into posts (db,groupid,parentid,authorid,author,content,postat,ipfrom) values ("+movetodb+","+(maxtopic+1)+","+adminparentid+","+cookieid+",'"+cookiename+"','"+admincontent+"',now(),'"+request.getRemoteAddr()+"')");
            }
          }
        }
        else {
          int clicktimes=0,parentid=0,authorid=0;
          String hotpost="",top="",titlelock="",titleimage="",author="",content="",postat="",ipfrom="",accessary="",accessaryname="",vote="",jinghua="";
          rs=connect.executeQuery("select clicktimes,hotpost,top,titlelock,titleimage,authorid,author,title,content,postat,ipfrom,accessary,accessaryname,vote,jinghua,parentid from posts where db="+db+" and groupid="+topic+" order by parentid,postat");
          if(rs.next()) {
            clicktimes=rs.getInt(1);
            hotpost=rs.getString(2);
            top=rs.getString(3);
            titlelock=rs.getString(4);
            titleimage=rs.getString(5);
            authorid=rs.getInt(6);
            author=rs.getString(7);
            movetitle=rs.getString(8);
            content=rs.getString(9);
            postat=rs.getString(10);
            ipfrom=rs.getString(11);
            accessary=rs.getString(12);
            accessaryname=rs.getString(13);
            vote=rs.getString(14);
            jinghua=rs.getString(15);
            if(!movetitle.equals(""))
              movetitle=connect.toHtml(movetitle);//去除无用的链接信息
            if(!content.equals(""))
              content=connect.toBr(content);//把\n换br
            postok=connect.executeUpdate("insert into posts (db,groupid,parentid,clicktimes,hotpost,top,titlelock,titleimage,authorid,author,title,content,postat,ipfrom,accessary,accessaryname,vote,jinghua) values ("+movetodb+","+(maxtopic+1)+",0,"+clicktimes+",'"+hotpost+"','"+top+"','"+titlelock+"','"+titleimage+"',"+authorid+",'"+author+"','"+movetitle+"(==>转移自："+movefromdbname+")','"+content+"','"+postat+"','"+ipfrom+"','"+accessary+"','"+accessaryname+"','"+vote+"','"+jinghua+"')");
          }
          while(rs.next()) {
            clicktimes=rs.getInt(1);
            hotpost=rs.getString(2);
            top=rs.getString(3);
            titlelock=rs.getString(4);
            titleimage=rs.getString(5);
            authorid=rs.getInt(6);
            author=rs.getString(7);
            content=rs.getString(9);
            postat=rs.getString(10);
            ipfrom=rs.getString(11);
            accessary=rs.getString(12);
            accessaryname=rs.getString(13);
            vote=rs.getString(14);
            jinghua=rs.getString(15);
            parentid=rs.getInt(16);
            if(!content.equals(""))
              content=connect.toBr(content);//把\n换br
            connect.executeUpdate("insert into posts (db,groupid,parentid,clicktimes,hotpost,top,titlelock,titleimage,authorid,author,content,postat,ipfrom,accessary,accessaryname,vote,jinghua) values ("+movetodb+","+(maxtopic+1)+","+parentid+","+clicktimes+",'"+hotpost+"','"+top+"','"+titlelock+"','"+titleimage+"',"+authorid+",'"+author+"','"+content+"','"+postat+"','"+ipfrom+"','"+accessary+"','"+accessaryname+"','"+vote+"','"+jinghua+"')");
          }
          if(postok) {
             rs=connect.executeQuery("select dbname from db where id="+movetodb);
             if(rs.next())
               movetodbname=rs.getString(1);
             connect.executeUpdate("update posts set title='"+movetitle+"(==>转移到："+movetodbname+")',titlelock='1' where db="+db+" and groupid="+topic+" and parentid=0");
             //加入管理员的解释
             if(!admincontent.trim().equals("")) {
               rs=connect.executeQuery("select id from posts where db="+movetodb+" and groupid="+(maxtopic+1)+" and parentid=0");
               if(rs.next())
                 adminparentid=rs.getInt(1);
               connect.executeUpdate("insert into posts (db,groupid,parentid,authorid,author,content,postat,ipfrom) values ("+movetodb+","+(maxtopic+1)+","+adminparentid+","+cookieid+",'"+cookiename+"','"+admincontent+"',now(),'"+request.getRemoteAddr()+"')");
               rs=connect.executeQuery("select id from posts where db="+db+" and groupid="+topic+" and parent=0");
               if(rs.next())
                 adminparentid=rs.getInt(1);
               connect.executeUpdate("insert into posts (db,groupid,parentid,authorid,author,content,postat,ipfrom) values ("+db+","+topic+","+adminparentid+","+cookieid+",'"+cookiename+"','"+admincontent+"',now(),'"+request.getRemoteAddr()+"')");
             }
          }
        }
        if(postok) {
          righttitle="移动帖子成功";
          rightinfo="您已经成功的把您选择的帖子移到您选择的论坛！";
        }
        else {
         errortitle="移动帖子失败";
         errorinfo="这个操作必须由这个版的斑竹或副斑竹完成！";
        }
      }
    }
    else {
      errortitle="移动帖子失败";
      errorinfo="这个操作必须由这个版的斑竹或副斑竹完成！";
    }
  }
}
//显示最后操作信息
if(!action.equals("movetopic") || (action.equals("movetopic") && submit.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><%if(postok) out.print(righttitle); else out.print(errortitle);%></b></font></td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%>>
      <font color=<%=fontcolormisc%>>
<%
  if(postok) {
%>
       具体情况：
       <ul>
        <li><b><%=rightinfo%></b>
        <li><a href="db.jsp?db=<%=db%>">返回论坛</a>
        <li><a href="index.jsp">返回论坛首页</a>
       </ul>
       <meta http-equiv="refresh" content="3; url=db.jsp?db=<%=db%>">
<%
  }
  else {
%>
       <b>关于出现错误的详细原因：</b>
       <ul>
        <li><b><%=errorinfo%></b>
        <li>您是否需要查看<a href="javascript:openScript('help.jsp',500,400)">帮助文件</a>?
       </ul>
       <br><br>
       <center>&lt;&lt; <a href="javascript:history.go(-1)">返回上一页</a></center>
<%
  }
%>
      </font>
     </td>
    </tr>
   </table>
  </td>
 </tr>
</table>
<%
}
%>
<%@ include file="include/foot.jsp"%>
<%
rs.close();
connect.close();
%>
</body>
</html>