<%if Session("weight")<>5 then 
Response.Redirect "error.asp?cause=4"
 end if
%>

<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<LINK 
href="css/default.css" rel=stylesheet>

</HEAD>
<BODY>
<object runat=server id=conn1 progid="adodb.connection"></object>
<%application.Lock
conn1.Open Application("p_jyzx")
Application.UnLock
%>

<table align="center" bgColor=#FFCC33 border="0" cellPadding="10" cellSpacing="1" height="100%" width="100%">
                    <tbody>
                    <tr>
                     
                      <td bgColor="#FFFBE7" vAlign="top">	

<br>
<TABLE cellSpacing=0 cellPadding=0 width=100% align=center border=0>
  <TBODY>
  <TR>
    <TD>　
     网友聚会管理-&gt; 聚会报名和讨论管理</TD><td align=left><a href="party_show.asp?id=<%=Request("id")%>">返回上一页</a></td></TR></TBODY></TABLE>
 <TABLE cellSpacing=1 cellPadding=0 width="100%" align=center border=0 bgColor=#FFCC33>
        <TBODY>
        <%set rs5=server.CreateObject ("ADODB.recordset")
		sql="select * from join_party where id="&Request("id")
		sql=sql&" order by time desc"
		rs5.Open sql,conn1,3
		rows=1
		 %> 
        <TR bgColor=#ffffff>
          <TD align=middle colSpan=6 height=25>最 新 报 名 名 单 &nbsp; <IMG 
            height=15 src="images/star1.gif" width=15 
            align=absBottom>表示有照片 <BR>（共计<%=rs5.RecordCount%>人） </TD></TR>
        <TR bgColor="#FFE28C">
          <TD align=middle height=23><b>编号</b></TD>
          <TD align=middle height=23><b>用户名</b></TD>
          <TD align=middle height=23><b>性别</b></TD>
          <TD align=middle height=23><b>年龄</b></TD>
          <TD align=middle height=23><b>昵称</b></TD>
          <TD align=middle height=23><b>操作</b></TD></TR>
    
    <%while not(rs5.eof)
			
          %>   
        <TR bgColor=#FFFBE7>
          <TD align=middle height=23><%=rows%>.</TD>
          <TD align=middle height=23>
        <%if rs5("photo")>0 then%>
          <IMG height=15 
            src="images/star1.gif" width=15 align=absBottom>
         <%else
         %>  &nbsp; <%end if%> 
            <%=rs5("user_name")%> </TD>
          <TD align=middle height=23><%=rs5("sex")%></TD>
          <TD align=middle height=23><%=rs5("age")%></TD>
          <TD align=middle height=23><A 
            href="../love/show_user.asp?user_name=<%=rs5("user_name")%>"
            target=_blank><%=rs5("nickname")%></A></TD>
           <td width="10%" align="center" ><FONT color=#d2691e><A 
            href="del_party_join.asp?id=<%=rs5("id")%>&join_id=<%=rs5("join_id")%>" >删除</A></FONT></td> 
            </TR>
     <%rows=rows+1
		rs5.movenext
      wend%>    
        </TBODY></TABLE><BR>


<%set rs8=server.CreateObject ("ADODB.recordset")
			sql="select * from party_discuss where id="&Request("id")
			sql=sql&" order by time desc"
 			rs8.Open sql,conn1,3
%>
<table bgColor=#FFCC33 border="0" cellPadding=3 cellSpacing=1 width="100%">
          <tr bgColor=#FFFBE7>
            <td width="522" colspan="4"><b><font color="#008000"><u>有聚会讨论<%=rs8.recordcount%>条</u></font></b></td>
          </tr>
          <tr bgColor=#FFE28C>
            <td width="15%" align="center" >时间</td>
            <td width="15%" align="center" >姓名：</td>
            <td width="60%" align="center" >内容</td>
            <td width="10%" align="center" >操作</td>
          </tr>

<%		 
         while not(rs8.eof)
			
			discuss_content=replace(rs8("discuss_content"),"~"," ",1,-1,1)
          %>   
            <tr bgColor=#FFFBE7>
            <td width="15%" align="center" ><%=rs8("time")%></td>
             <td width="15%" align="center" ><FONT color=#d2691e><A 
            href="../love/show_user.asp?user_name=<%=rs8("user_name")%>" 
            target=_blank><%=rs8("user_name")%></A></FONT></td>
            <td width="60%" align="center" ><%=discuss_content%></td>
           <td width="10%" align="center" ><FONT color=#d2691e><A 
            href="del_party_discuss.asp?id=<%=rs8("id")%>&discuss_id=<%=rs8("discuss_id")%>" >删除</A></FONT></td>
          </tr>   
          <%
          rs8.movenext
         wend
          %>  
 </tbody></table>
 
 
  </td></tr></tbody></table>

</BODY>
</HTML>
