<!--#include file="../Include/Conn.asp" -->
<!--#include file="../sql/Neeao_SqlIn.Asp" -->
<!--#include file="../Include/const.asp" -->
<!--#include file="../Include/char.asp" -->
<!--#include file="IsLogin.asp" -->
<%
f_id=clng(checkStr(request("id")))
p_id=clng(checkStr(request("p_id")))
 if f_id="" or p_id="" or IsNumeric(f_id)=false or isnumeric(p_id)=false then
 Call Msgbox("对不起，ID号错误！",1)
 Response.end
 end if
 m_ID = Session("CurUserID")
 m_username= Session("CurUsername")

set rs_a=server.createobject("adodb.recordset")
sql_a="select * from t_club where F_id="&f_id
rs_a.open sql_a,conn,1,3

if rs_a.eof then
 Call Msgbox("对不起，该俱乐部已经不存在！",1)
 Response.end
end if
'判别身份，是否有权限发布活动
set rs_user=server.createobject("adodb.recordset")
sql_user="select f_ischeck,f_identity,f_grade from t_club_member where F_club_id="&f_id&" and f_username='"&m_username&"'"
rs_user.open sql_user,conn
if rs_user.eof and rs_user.bof then
 Call Msgbox("对不起,您还未加入本俱乐部！",1)
 Response.end
 else
 if rs_user("f_ischeck")=false then
 Call Msgbox("对不起,您还未通过审核加入本俱乐部，请耐心等待！",1)
 Response.end
 end if
end if
if rs_user("f_identity")="初级会员" then    '初级会员无权上传照片
 Call Msgbox("对不起,您是本俱乐部[初级会员]暂无发布公布权限！",1)
 Response.end
end if
set rs_c=server.createobject("adodb.recordset")
if rs_a("f_manage_username")=m_username then
sql_c="select * from t_club_board where F_club_id="&f_id&" and f_id="&p_id
else
sql_c="select * from t_club_board where F_club_id="&f_id&" and f_id="&p_id&" and f_username='"&m_username&"'"
end if
rs_c.open sql_c,conn
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>子俱乐部:</title>
<link href="../Files/Style.css" rel="stylesheet" type="text/css">
<SCRIPT language=javascript>
var subNo=0;

function formCheck()
{

	if (document.theform.content.value == "")
	{
		alert("请填写具体说明！")
		document.theform.content.focus()
		return false
	}
	
	
subNo=1;
return true;
}
</SCRIPT>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
//-->
</script>
<style type="text/css"></style>
</head>

<body onLoad="MM_preloadImages('images/hy_b_1b.gif','images/hy_b_3b.gif')">
<!--#include file="../include/top.asp" -->
<!--#include file="../include/member_top.asp" -->
<!--#include file="club_top.asp" -->
<table width="780" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  <tr>
    <td width="600" align="center" valign="top"><table width="600" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td><img src="images/xxclub_01.gif" width="600" height="154"></td>
      </tr>
    </table>
      <table width="580" border="0" cellpadding="0" cellspacing="5" bgcolor="f4f4f4">
        <tr>
          <td bgcolor="#FFFFFF"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
            <tr>
                <td width="100" align="center"><a href="<%=rs_a("f_photo")%>" target="_blank"><img src="<%=rs_a("f_photo")%>" width="80" height="80" border="0"></a></td>
              <td width="81%"><table width="100%"  border="0" cellspacing="3" cellpadding="0">
                <tr>
                  <td width="68" align="left" class="p1">名　　称：</td>
                  <td colspan="4" align="left"><strong><%=rs_a("f_name")%></strong></td>
                  </tr>
                <tr>
                  <td height="1" colspan="5" align="left" background="images/line.gif"></td>
                </tr>
                <tr>
                  <td align="left" class="p1">创 始 人：</td>
                  <td align="left"><a href="club_member.asp?username=<%=rs_a("f_username")%>" target="_blank"><%=rs_a("f_username")%></a></td>
                  <td align="left"><span class="p1">现任主席：</span></td>
                  <td width="156" align="left"><a href="club_member.asp?username=<%=rs_a("f_manage_username")%>" target="_blank"><%=rs_a("f_manage_username")%></a></td>
                </tr>
                <tr>
                  <td height="1" colspan="5" align="left" background="images/line.gif"></td>
                </tr>
                <tr>
                  <td width="68" align="left" class="p1">创立时间：</td>
                  <td width="146" align="left"><%=rs_a("f_regtime")%></td>
                  <td width="76" align="left" class="p1">所在城市：</td>
                  <td colspan="2" align="left"><%=rs_a("f_area")%></td>
                </tr>
                <tr>
                  <td height="1" colspan="5" align="left" background="images/line.gif"></td>
                </tr>
                <tr>
                  <td height="25" colspan="5" align="left">名气度：<%=rs_a("f_hit")%>　　成员数：<%=rs_a("f_usercount")%>　　活动数：<%=rs_a("f_clubactive")%>　　留言数：<%=rs_a("f_clubbook")%>　　照片数：<%=rs_a("f_clubphoto")%></td>
                  </tr>
              </table></td>
            </tr>
          </table></td>
        </tr>
      </table>
      <br>
      <TABLE cellSpacing=1 cellPadding=5 width=580 align=center 
            bgColor=#ececec border=0>
        <FORM method="post" onsubmit="return formCheck();" name=theform  action="club_boardmanagesave.asp">
          <TBODY>
            <TR align="center" bgColor=#f2f2f2> 
              <TD colSpan=3>修改本俱乐部公告</TD>
            </TR>
            
            <TR bgColor=#ffffff> 
              <TD align=right valign="top">公告内容：</TD>
              <TD colSpan=2><textarea name="content" cols="60" rows="5" id="content"><%=rs_c("f_content")%></textarea></TD>
            </TR>
            <TR align="center" bgColor=#f2f2f2> 
              <TD colSpan=3> <input name="id" type="hidden" id="id" value="<%=rs_a("f_id")%>"> 
                <input name="p_id" type="hidden" id="p_id" value="<%=rs_c("f_id")%>"> 
                <INPUT type=submit value="确定修改此公告" name=submit> </TD>
            </TR>
        </FORM>
      </TABLE>
      <br>
    </td>
    <td valign="top" bgcolor="f4f4f4"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td><img src="images/xxclub_02.gif" width="180" height="79"></td>
      </tr>
      <tr>
         <td style="PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-BOTTOM: 10px; LINE-HEIGHT: 140%; PADDING-TOP: 10px" height="100"> 
            <MARQUEE onmouseover=this.stop(); onmouseout=this.start(); 
            scrollAmount=1 scrollDelay=50 direction=up width=160 
            height=140>
			<%
			set rs_g=server.createobject("adodb.recordset")
			sql_g="select f_username,f_content,f_regtime from t_club_board where f_club_id="&rs_a("f_id")&" order by f_regtime desc"
			rs_g.open sql_g,conn
			if not rs_g.eof then
			do while not rs_g.eof			
			%>
			<B>时间：</B><%=rs_g("f_regtime")%><BR><B>发布者：</B><A 
            href="club_member.asp?username=<%=rs_g("f_username")%>"><U><%=rs_g("f_username")%></U></A><BR>
            <%=rs_g("f_content")%><BR>
            <FONT color=#666666>--------------------------</FONT>
			<%
			rs_g.movenext
			loop
			end if
			rs_g.close
			set rs_g=nothing
			%>
			</MARQUEE>
		</td>
      </tr>
      <tr>
        <td height="70" align="center"><a href="club_addmember.asp?id=<%=rs_a("f_id")%>" onclick="return confirm('您确定要加入这个子俱乐部吗？')" ><img src="images/xxclub_login.gif" width="136" height="62" border="0"></a></td>
      </tr>
    </table>
      <!--#include file="club_manage.asp" --></td>
  </tr>
</table>
<!--#include file="../Include/Bottom.asp" -->
</body>
</html>
<%
rs_user.close
set rs_user=nothing
rs_a.close
rs_c.close
set rs_c=nothing
set rs_a=nothing
%>
