<!--#include file="../Include/Conn.asp" -->
<!--#include file="../Include/const.asp" -->
<!--#include file="../Include/char.asp" -->
<%
					dim PerPage
					set rs_c=server.createobject("adodb.recordset")
					select case request("kind")
					case "1"  '名气最大
					top_name="名气最大"
					sql_c="select top 20 f_id,f_name,f_regtime,f_manage_username,f_hit,f_usercount,f_clubactive,f_clubbook,f_clubphoto from t_club order by f_hit desc"
					case "2"  '成员最多
					top_name="成员最多"
					sql_c="select top 20 f_id,f_name,f_regtime,f_manage_username,f_hit,f_usercount,f_clubactive,f_clubbook,f_clubphoto from t_club order by f_usercount desc"
					case "3"  '活动最多
					top_name="活动最多"
					sql_c="select top 20 f_id,f_name,f_regtime,f_manage_username,f_hit,f_usercount,f_clubactive,f_clubbook,f_clubphoto from t_club order by f_clubactive desc"
					case "4"    '照片最多
					top_name="照片最多"
					sql_c="select top 20 f_id,f_name,f_regtime,f_manage_username,f_hit,f_usercount,f_clubactive,f_clubbook,f_clubphoto from t_club order by f_clubphoto desc"
					case "5"   '人气
					top_name="最有人气"
					sql_c="select top 20 f_id,f_name,f_regtime,f_manage_username,f_hit,f_usercount,f_clubactive,f_clubbook,f_clubphoto from t_club order by f_clubbook desc"
					case else  '最新创建
					top_name="最新创建"
					sql_c="select top 20 f_id,f_name,f_regtime,f_manage_username,f_hit,f_usercount,f_clubactive,f_clubbook,f_clubphoto from t_club order by f_regtime desc"
					end select					
					rs_c.open sql_c,conn,1,1
				'					
				%>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>子俱乐部</title>
<link href="../css/member.css" rel="stylesheet" type="text/css">
<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">
  <tr>
    <td width="223"><img src="images/tt_01.gif" width="223" height="121"></td>
    <td width="557" background="images/tt_02.gif"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td width="3%" height="80">&nbsp;</td>
        <td width="97%">&nbsp;</td>
      </tr>
      <tr align="center">
        <td colspan="2"> <strong class="p4"><%=top_name%>的前二十家子俱乐部</strong> </td>
        </tr>
    </table></td>
  </tr>
</table>
<table width="780" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  <tr>
    <td width="180" height="40" valign="top" bgcolor="f4f4f4"><table width="180" border="0" cellspacing="0" cellpadding="0">
      <tr>
          <td height="40" align="center" background="images/tt_ba_bj.gif"><a href="club_subtop.asp?kind=1">名气最大的子俱乐部</a></td>
      </tr>
      <tr>
          <td height="40" align="center" background="images/tt_ba_bj.gif"><a href="club_subtop.asp?kind=2">成员最多的子俱乐部</a></td>
      </tr>
      <tr>
          <td height="40" align="center" background="images/tt_ba_bj.gif"><a href="club_subtop.asp?kind=3">活动最多的子俱乐部</a></td>
      </tr>
      <tr>
          <td height="40" align="center" background="images/tt_ba_bj.gif"><a href="club_subtop.asp?kind=4">照片最多的子俱乐部</a></td>
      </tr>
      <tr>
          <td height="40" align="center" background="images/tt_ba_bj.gif"><a href="club_subtop.asp?kind=5">最有人气的子俱乐部</a></td>
      </tr>
      <tr>
          <td height="40" align="center" background="images/tt_ba_bj.gif"><a href="club_subtop.asp?kind=6">最新创建的子俱乐部</a></td>
      </tr>
    </table></td>
    <td width="600" align="center" valign="top"><table width="580" border="0" cellpadding="0" cellspacing="1" bgcolor="c7c7c7">
        <tr align="center" bgcolor="#E9FF9D"> 
          <td width="115" height="25">子俱乐部名称</td>
          <td width="75"> 主席 </td>
          <td width="55">成员数</td>
          <td width="55">活动数</td>
          <td width="55">留言数</td>
          <td width="55">照片数</td>
          <td width="55">名气度</td>
          <td width="106">创建时间</td>
        </tr>
        <% do while not rs_c.eof %>
        <tr align="center" bgcolor="#FFFFFF"> 
          <td height="25"><a href="club_viewsub.asp?id=<%=rs_c("f_id")%>"><%=rs_c("f_name")%></a></td>
          <td> <a href="club_member.asp?username=<%=rs_c("f_manage_username")%>" target="_blank"><%=rs_c("f_manage_username")%></a> 
          </td>
          <td><%=rs_c("f_usercount")%></td>
          <td><%=rs_c("f_clubactive")%></td>
          <td><%=rs_c("f_clubbook")%></td>
          <td><%=rs_c("f_clubphoto")%></td>
          <td><%=rs_c("f_hit")%></td>
          <td><%=datevalue(rs_c("f_regtime"))%></td>
        </tr>
        <% 
	  rs_c.movenext
	  loop
	  rs_c.close
	  set rs_c=nothing
	  %>
        
        
      </table>
      <table width="580" border="0" cellspacing="1" cellpadding="0">
        <tr>
          <td height="16">&nbsp;</td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
      </table></td>
  </tr>
</table>
<!--#include file="../Include/Bottom.asp" -->
</body>
</html>
