<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="java.sql.*"%> 
<%@ page import="java.util.*"%>
<%@ page import="java.util.Date"%>
<%@ page import="java.text.*"%>
<%@ include file="../inc/conn.jsp"%>
<%!String tlk1,alk,blk,BBS_Cate_Name_1,BBS_Cate_Name_2,BBS_Cate_Manager_Name,searchcontent;%>
<%
String layer_1 = request.getParameter("layer_1");
String layer_2 = request.getParameter("layer_2");
String sign = request.getParameter("sign");
String huati = request.getParameter("huati");
String order_key = request.getParameter("order_key");String searchkind = request.getParameter("searchkind");
//String searchcontent = request.getParameter("searchcontent");
if(searchkind!=null){
searchcontent =new String(request.getParameter("searchcontent").getBytes("iso-8859-1"));
}String sql,lk1,lk2,signstr,huatistr,searchkindstr;
ResultSet rs1,rs2,rs3;
String ext = request.getParameter("ext");if(searchkind!=null&&searchcontent!=null){
searchkindstr="and " +searchkind+ " like '%"+searchcontent+"%'";
}
else{
searchkindstr="";
}if(order_key==null){
   order_key="bbstop desc,redate desc";
}
else{
   order_key=order_key+" desc";
}
//out.print(order_key);
//out.close();if(sign!=null){
signstr="and sign=1";
}
else{
signstr="";
}
if(huati!=null){
huatistr="and huati=1";
}
else{
huatistr="";
}if(ext==null){
ext="n";
}
if (ext.equals("y"))
//if (ext=="y")
   {
   //String bbsuser = (String)session.getAttribute("name"); 
   session.setAttribute("name","");
   session.setAttribute("bz","");
   session.setAttribute("bbsadmin","");
   session.setAttribute("payuser","");
   
   out.print("<script language='javascript'>");
   out.print("window.location.href='main.jsp';");
   out.print("parent.left.document.location.reload();");
   out.print("</script>");
  }
//  
if(layer_1!=null)
{
String str="select BBS_Cate_Name,BBS_Cate_Manager_Name,BBS_Cate_Manager_Email,BBS_Cate_Topic,BBS_Cate_Reply from BBS_Cate where BBS_Cate_ID='"+layer_1+"' and deleted=0";
Statement stmt1=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs1=stmt1.executeQuery(str);
rs1.next();
BBS_Cate_Name_1=rs1.getString("BBS_Cate_Name");
BBS_Cate_Manager_Name=rs1.getString("BBS_Cate_Manager_Name");
}
else
{
BBS_Cate_Name_1="";
BBS_Cate_Manager_Name="";
}
if(layer_2!=null)
{
String sqlstr="select BBS_Cate_Name,BBS_Cate_Manager_Name from BBS_Cate where BBS_Cate_ID='"+layer_2+"'";
Statement stmt2=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs2=stmt2.executeQuery(sqlstr);
rs2.next();
BBS_Cate_Name_2=rs2.getString("BBS_Cate_Name");
BBS_Cate_Manager_Name=rs2.getString("BBS_Cate_Manager_Name");
}
else
{
BBS_Cate_Name_2="";
BBS_Cate_Manager_Name="";
}if(layer_1!=null)
{
lk1="&layer_1="+layer_1;
tlk1="?layer_1="+layer_1;
//alk="?sign=1";
//blk="?huati=1";
}
else
{
lk1="";
tlk1="";
}if(layer_2!=null)
{
lk2="&layer_2="+layer_2;
}
else
{
lk2="";
}
if(layer_1!=null||layer_2!=null)
{
alk="&sign=1";
blk="&huati=1";
}
else
{
alk="?sign=1";
blk="?huati=1";
}
%>
<HTML><HEAD>
<title>博为华晨</title>
<META http-equiv=Content-Type content=text/html;charset=gb2312>
<link href="../css/news2.css" rel="stylesheet" type="text/css">
<STYLE type=text/css>
BODY {
BACKGROUND: #ffffff; MARGIN: 5px
}
.sec_menu {
BORDER-RIGHT: white 1px solid; BACKGROUND: #d6dff7; OVERFLOW: hidden; BORDER-LEFT: white 1px solid; BORDER-BOTTOM: white 1px solid
}
.menu_title SPAN {
FONT-WEIGHT: bold; LEFT: 10px; COLOR: #215dc6; POSITION: relative; TOP: 2px
}
.menu_title2 SPAN {
FONT-WEIGHT: bold; LEFT: 10px; COLOR: #428eff; POSITION: relative; TOP: 2px
}
</STYLE>
</HEAD>
<script language=javascript src="../inc/wyjs.js"></script><script language="javascript">
function check_search(form)
{
if (form.searchcontent.value=="")
{
alert("请输入搜索内容!");
form.searchcontent.focus();
return false;
}
return true;
}
</script>
<script language="javascript">function check(form)
{
    if (form.bbsuser.value=="")
     {
     alert("请填写用户名!");
     form.bbsuser.focus();
     return false;
   }
    if (form.password.value=="")
     {
     alert("请填写密码!");
     form.password.focus();
     return false;
   }
return true;
}
</script>
<script language="JavaScript" type="text/JavaScript">
function MM_jumpMenu(targ,selObj,restore){ 
  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  if (restore) selObj.selectedIndex=0;
}
</script>
<table width="99%" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr>
    <td> 
      <table width="100%" border=0 cellpadding=2 cellspacing=1 bgcolor="#A4B6D7">
        <tbody>
          <tr> 
            <td width="51%" background="../images/bbs_bg1.gif" ><img src="../images/bbs_t1.gif" align="absmiddle"> 
              <a href="../bbs/main.jsp">论坛首页</a>>><a href="main.jsp<%=tlk1%>"><%=BBS_Cate_Name_1%></a>>><a href="main.jsp<%=tlk1%><%=lk2%>"><%=BBS_Cate_Name_2%></a></td>
            <td align=right background="../images/bbs_bg1.gif" > <div align="center"><a href="main.jsp<%=tlk1%><%=lk2%><%=blk%>">精华贴</a> 
                <a href="main.jsp<%=tlk1%><%=lk2%><%=alk%>">推荐贴</a> 
                总版主:xmfangzi</div></td>
          </tr>
        </tbody>
      </table>