<!--#include file="conn.asp"-->

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title><%=bbsinfo("bbsname")%></title>
<LINK 
href="css.css" type=text/css rel=stylesheet>
</head>
<body>
<!--#include file="top.asp"-->
<table width="780" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr> 
    <td width="8" background="images/left.gif">&nbsp;</td>
    <td valign="top" bgcolor="#FFFFFF"><table width="100%" border="0" cellspacing="1" cellpadding="0">
        <tr> 
          <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td height=6></td>
              </tr>
            </table>
            <table width="754" border="0" align="center" cellpadding="0" cellspacing="0">
              <tr> 
                <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
                    <tr> 
                      <td width=6 height=6><img src="images/index_2.gif" width="6" height="6"></td>
                      <td width="742" background="images/index_3.gif"></td>
                      <td width=6> <div align="right"><img src="images/index_1.gif" width="6" height="6"></div></td>
                    </tr>
                  </table>
                  <table width="100%" border="0" cellspacing="0" cellpadding="0">
                    <tr> 
                      <td width=1 bgcolor="C6C3C4"></td>
                      <td height=6 bgcolor="FFFFFF"> <table width="100%" border="0" cellspacing="0" cellpadding="8">
                          <tr>
                            <td><img src="images/Order_26.gif" width="10" height="10"> 
                              <a href=index.asp><%=bbsinfo("bbsname")%></a> <%if request.querystring("action")="mypost" then%>→我发表的主题<%else%>→我参与的主题<%end if%></td>                                                
                            <td>                                                   
 </td>                                            
                          </tr>                                               
                        </table></td>                                                                           
                      <td width=1 bgcolor="C6C3C4"></td>                                                                           
                    </tr>                                                                           
                  </table>                                                                           
                  <table width="100%" border="0" cellspacing="0" cellpadding="0">                                                                           
                    <tr>                                                                            
                      <td width=5 height=5><img src="images/left_data_4.gif" width="5" height="5"></td>                                                                           
                      <td width="742" background="images/left_data_6.gif"></td>                                                                           
                      <td width=5> <div align="right"><img src="images/left_data_5.gif" width="5" height="5"></div></td>                                                                           
                    </tr>                                                                           
                  </table></td>                                                                           
              </tr>                                                                           
            </table>                                                                           
            <br>                                                                           
            <table width="100%" border="0" cellspacing="0" cellpadding="0">                                                                          
              <tr>                                                                           
                <td width="55%"></td>                                                                            
                <td width="45%">                                  
                                                      
                  <p align="right"> </p>                                              
                </td>                                                                            
              </tr>                                                                            
            </table>                                                                            
            <table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="494949" class="listcontents3">                                                                            
              <tr>                                                                             
                <td width="7%"> <div align="center"><strong><font color="#FFFFFF">状态</font></strong></div></td>                                                                            
                <td width="46%"><div align="center"><strong><font color="#FFFFFF">主题</font></strong></div></td>                                                                            
                <td width="11%"><div align="center"><strong><font color="#FFFFFF">作者</font></strong></div></td>                                                                            
                <td width="11%"><div align="center"><strong><font color="#FFFFFF">回复/点击</font></strong></div></td>                                                                            
                <td width="25%"><div align="center"><strong><font color="#FFFFFF">最后更新|回复人</font></strong></div></td>                                                                            
              </tr>                                                                         
<% action=request.querystring("action")        
username=Request.Cookies("esung")("username")       
Set rs = Server.CreateObject("ADODB.Recordset")         
if action="mypost" then                                                        
sql = "SELECT top 25 * FROM  book  where username='"&username&"' and type=0  order by gd desc,ldate desc"         
elseif action="withpost" then        
sql = "SELECT top 25 * FROM  book  where username='"&username&"' and type<>0 order by gd desc,ldate desc"         
end if                                                          
rs.open sql, conn, 1, 3%>                                                                          
<% do while not rs.eof %>                                                              
                                                             
               <%set u3=conn.execute("select bidname from board where bid="&rs("bid")&"")%>                                                           
              <tr bgcolor="F3F3F3">                                                          
                                                          
                <td> <div align="center"><img src=images/<%=rs("faceimg")%>.gif>	</div></td>                                                                           
                <td> <a href="show.asp?id=<%=rs("id")%>&bid=<%=rs("bid")%>&name=<%=u3("bidname")%>"><%=rs("title")%></a></td>                                                                         
                <td> <div align="center"><a href=Userlist_data.asp?username=<%=rs("username")%>><%=rs("username")%></a></div></td>                                                                         
                <td> <div align="center"><%=rs("reply")%>/<%=rs("hits")%></div></td>                                                                        
                <td> <div align="center"><%=rs("ldate")%>|<%set u2=conn.execute("select reply,username from book  order by id desc")%><%if rs("reply")=0 then%> ---<%else%><a href=Userlist_data.asp?username=<%=u2("username")%>><%=u2("username")%><%end if                                                     
                 u2.Close                                                                   
set u2=nothing  %></a>                                                           
<img src="images/ " width="9" height="14">                                                          
                                                          
</div></td>                                                                         
              </tr>     
 <%   
rs.movenext                    
loop %>                                                                       
            </table>                                                                         
            <br> <table width="754" border="0" align="center" cellpadding="0" cellspacing="0">                                                                          
              <tr>                                                                           
                <td><table width="100%" border="0" cellspacing="0" cellpadding="0">                                                                          
                    <tr>                                                                           
                      <td width=6 height=6><img src="images/index_2.gif" width="6" height="6"></td>                                                                          
                      <td width="742" background="images/index_3.gif"></td>                                                                          
                      <td width=6> <div align="right"><img src="images/index_1.gif" width="6" height="6"></div></td>                                                                          
                    </tr>                                                                          
                  </table>                                                                          
                  <table width="100%" border="0" cellspacing="0" cellpadding="0">                                                                          
                    <tr>                                                                           
                      <td width=1 bgcolor="C6C3C4"></td>                                                                          
                      <td height=6 bgcolor="FFFFFF"> <table width="100%" border="0" cellspacing="0" cellpadding="3">                                                                          
                          <tr>                                                                           
                            <td>&nbsp;<img src="images/index_7.gif" width="13" height="13" align="absmiddle"><font color="666666">                                                                           
                              栏目图例</font></td>                                                                             
                          </tr>                                                                             
                          <tr>                                                                              
                            <td>&nbsp; <img src="images/Order_16.gif" width="17" height="17">固顶主题                                                                              
                              ‖ <img src="images/Order_18.gif" width="11" height="15">精华帖子                                                                              
                              ‖ <img src="images/Order_19.gif" width="13" height="12">投票贴子                                                                              
                              ‖ <img src="images/Order_15.gif" width="26" height="15">锁定的主题                          
                              ‖  <img src="images/Order_13.gif" width="26" height="15">开放的主题                                                              
                            </td>                                                                             
                          </tr>                                                                           
                        </table></td>                                                                           
                      <td width=1 bgcolor="C6C3C4"></td>                                                                           
                    </tr>                                                                           
                  </table>                                                                           
                  <table width="100%" border="0" cellspacing="0" cellpadding="0">                                                                           
                    <tr>                                                                            
                      <td width=5 height=5><img src="images/left_data_4.gif" width="5" height="5"></td>                                                                           
                      <td width="742" background="images/left_data_6.gif"></td>                                                                           
                      <td width=5> <div align="right"><img src="images/left_data_5.gif" width="5" height="5"></div></td>                                                                           
                    </tr>                                                                           
                  </table></td>                                                                           
              </tr>                                                                           
            </table></td>                                                                           
        </tr>                                                                           
      </table>                                                                            
      <!--#include file="down.asp"-->                                                                           
    </td>                                                                           
    <td width="8" background="images/right.gif">&nbsp;</td>                                                                           
  </tr>                                                                           
</table>                                                                           
</body>                                                                           
</html>                                                                           
