<!--#include file="dbinc/dbpath.asp" -->
<%
const MaxPrePage=30  '每页显示记录数

if (request.querystring("page")<>"") and (IsNumeric(request.querystring("page"))) then  '检查页号
  intPage=CLng(request.querystring("page"))
else
  intPage=1
end if

strSql="select * from zkpick where pickgrade=4 "
if (request.querystring("type")<>"") and (IsNumeric(request.querystring("type"))) then  '检查是否分类
  intType=CLng(request.querystring("type"))
  strSql=strSql& " and picktype="&CLng(request.querystring("type"))
else
  intType=0
end if

strSql=strSql&" order by pickvisitor desc,pickvote desc,pickid asc"
%>
<html>
<head>
<title>3鸟设社网站评测——推荐网站</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="link.css">
<script language="JavaScript">
<!--
function winpop(id)
{
  window.open('showinfo.asp?id='+id,'','toolbar=no,location=no,status=no,menubar=no,scrollbars=auto,resizable=yes,width=520,height=200,top=100,left=100');
}
// --> 
</script>
</head>

<body topmargin="4" marginheight="2" leftmargin="2" marginwidth="2" background="image/bj.gif">
<!--#include file="top.htm" -->
<table width="760" border="0" cellspacing="0" cellpadding="0" align="center" class="9p">
  <tr> 
    <td width="120" valign="top"> 
      <table width="125" border="0" cellspacing="0" cellpadding="0" bordercolorlight="#FF6633" bordercolordark="#FFFFFF" height="200">
        <tr valign="top"> 
          <td height="215"> 
            <table width="125" border="0" cellspacing="1"  class="9p" cellpadding="0" bgcolor="#0000FF">
              <tr> 
                <td> 
                  <div align="center"><font color="#FFFFFF">地域分类</font></div>
                </td>
              </tr>
              <tr> 
                <td bgcolor="#FFFFFF"> 
                  <table width="100%" border="0" cellspacing="0" cellpadding="3" class="9p" bgcolor="#CCFFFF" align="center">
                    <tr> 
                      <td width="53" height="17"> 
                        <div align="left"><img src="image/j1.gif" width="9" height="10"> 
                          <a href="listdiyu.asp?diyu=1">海口</a></div>
                      </td>
                      <td width="53" height="17"><img src="image/j1.gif" width="9" height="10"> 
                        <a href="listdiyu.asp?diyu=2">琼山</a></td>
                    </tr>
                    <tr> 
                      <td width="53"> 
                        <div align="left"><img src="image/j1.gif" width="9" height="10"> 
                          <a href="listdiyu.asp?diyu=3">澄迈</a></div>
                      </td>
                      <td width="53"><img src="image/j1.gif" width="9" height="10"> 
                        <a href="listdiyu.asp?diyu=4">临高</a></td>
                    </tr>
                    <tr> 
                      <td width="53"> 
                        <div align="left"><img src="image/j1.gif" width="9" height="10"> 
                          <a href="listdiyu.asp?diyu=5">儋州</a></div>
                      </td>
                      <td width="53"><img src="image/j1.gif" width="9" height="10"> 
                        <a href="listdiyu.asp?diyu=6">琼海</a></td>
                    </tr>
                    <tr> 
                      <td width="53"> 
                        <div align="left"><img src="image/j1.gif" width="9" height="10"> 
                          <a href="listdiyu.asp?diyu=7">定安</a></div>
                      </td>
                      <td width="53"><img src="image/j1.gif" width="9" height="10"><a href="listdiyu.asp?diyu=8"> 
                        万宁</a></td>
                    </tr>
                    <tr> 
                      <td width="53"> 
                        <div align="left"><img src="image/j1.gif" width="9" height="10"> 
                          <a href="listdiyu.asp?diyu=9">屯昌</a></div>
                      </td>
                      <td width="53"><img src="image/j1.gif" width="9" height="10"> 
                        <a href="listdiyu.asp?diyu=10">文昌</a></td>
                    </tr>
                    <tr> 
                      <td width="53"> 
                        <div align="left"><img src="image/j1.gif" width="9" height="10"> 
                          <a href="listdiyu.asp?diyu=11">昌江</a></div>
                      </td>
                      <td width="53"><img src="image/j1.gif" width="9" height="10"> 
                        <a href="listdiyu.asp?diyu=12">东方</a></td>
                    </tr>
                    <tr> 
                      <td width="53"> 
                        <div align="left"><img src="image/j1.gif" width="9" height="10"> 
                          <a href="listdiyu.asp?diyu=13">三亚</a></div>
                      </td>
                      <td width="53"><img src="image/j1.gif" width="9" height="10"> 
                        <a href="listdiyu.asp?diyu=14">陵水</a></td>
                    </tr>
                    <tr> 
                      <td width="53"> 
                        <div align="left"><img src="image/j1.gif" width="9" height="10"> 
                          <a href="listdiyu.asp?diyu=15">保亭</a></div>
                      </td>
                      <td width="53"><img src="image/j1.gif" width="9" height="10"> 
                        <a href="listdiyu.asp?diyu=16">琼中</a></td>
                    </tr>
                    <tr> 
                      <td width="53"> 
                        <div align="left"><img src="image/j1.gif" width="9" height="10"> 
                          <a href="listdiyu.asp?diyu=17">白沙</a></div>
                      </td>
                      <td width="53"><img src="image/j1.gif" width="9" height="10"> 
                        <a href="listdiyu.asp?diyu=18">乐东</a></td>
                    </tr>
                    <tr> 
                      <td width="53"> 
                        <div align="left"><img src="image/j1.gif" width="9" height="10"> 
                          <a href="listdiyu.asp?diyu=19">五指山</a></div>
                      </td>
                      <td width="53"><img src="image/j1.gif" width="9" height="10"> 
                        <a href="listdiyu.asp?diyu=20">其它</a></td>
                    </tr>
                  </table>
                </td>
              </tr>
            </table>
            <table width="125" border="0" cellspacing="1" class="9p" cellpadding="0" bgcolor="#0000FF">
              <tr> 
                <td> 
                  <div align="center"><font color="#FFFFFF">类型分类</font></div>
                </td>
              </tr>
              <tr> 
                <td bgcolor="#FFFFFF"> 
                  <table width="100%" border="0" cellspacing="0" cellpadding="2" class="9p" bgcolor="#CCFFFF" align="center">
                    <tr> 
                      <td> 
                        <div align="left"><img src="image/j1.gif" width="9" height="10"> 
                          <a href="listtype.asp?type=1">电脑网络</a></div>
                      </td>
                    </tr>
                    <tr> 
                      <td> 
                        <div align="left"><img src="image/j1.gif" width="9" height="10"> 
                          <a href="listtype.asp?type=2">免费资源</a></div>
                      </td>
                    </tr>
                    <tr> 
                      <td> 
                        <div align="left"><img src="image/j1.gif" width="9" height="10"> 
                          <a href="listtype.asp?type=3">休闲娱乐</a></div>
                      </td>
                    </tr>
                    <tr> 
                      <td> 
                        <div align="left"><img src="image/j1.gif" width="9" height="10"> 
                          <a href="listtype.asp?type=4">文学艺术</a></div>
                      </td>
                    </tr>
                    <tr> 
                      <td> 
                        <div align="left"><img src="image/j1.gif" width="9" height="10"> 
                          <a href="listtype.asp?type=5">游戏世界</a></div>
                      </td>
                    </tr>
                    <tr> 
                      <td> 
                        <div align="left"><img src="image/j1.gif" width="9" height="10"> 
                          <a href="listtype.asp?type=6">音乐天堂</a></div>
                      </td>
                    </tr>
                    <tr> 
                      <td> 
                        <div align="left"><img src="image/j1.gif" width="9" height="10"> 
                          <a href="listtype.asp?type=7">体育生活</a></div>
                      </td>
                    </tr>
                    <tr> 
                      <td> 
                        <div align="left"><img src="image/j1.gif" width="9" height="10"> 
                          <a href="listtype.asp?type=8">程序设计</a></div>
                      </td>
                    </tr>
                    <tr> 
                      <td> 
                        <div align="left"><img src="image/j1.gif" width="9" height="10"> 
                          <a href="listtype.asp?type=9">商贸金融</a></div>
                      </td>
                    </tr>
                    <tr> 
                      <td> 
                        <div align="left"><img src="image/j1.gif" width="9" height="10"> 
                          <a href="listtype.asp?type=10">科技咨讯</a></div>
                      </td>
                    </tr>
                    <tr> 
                      <td> <img src="image/j1.gif" width="9" height="10"> <a href="listtype.asp?type=11">社会公益</a></td>
                    </tr>
                    <tr> 
                      <td> 
                        <div align="left"><img src="image/j1.gif" width="9" height="10"> 
                          <a href="listtype.asp?type=12">另类其它</a></div>
                      </td>
                    </tr>
                    <tr> 
                      <td height="17"> 
                        <div align="center"></div>
                      </td>
                    </tr>
                  </table>
                </td>
              </tr>
            </table>
          </td>
        </tr>
      </table>
    </td>
    <td width="10">&nbsp;</td>
    <td width="620" valign="top"> 
      <% 
set rs=createobject("adodb.recordset") 
rs.open strSql,conn,1,3 
if rs.eof and rs.bof then 
  response.write "<div align='center'><br><font color='#000000'>对不起，暂时还没有相关推荐网站，欢迎您的加入！</font></div>" 
else 
 
rs.pagesize=MaxPrePage 
if intPage>rs.pagecount then  
  intPage=rs.pagecount 
end if  
%>
      <table width="630" border="0" cellspacing="0" cellpadding="0" class="9p" bgcolor="#FFFFFF">
        <tr bgcolor="#FFCC99" valign="bottom"> 
          <td height="18" bgcolor="#99CCFF"> 
            <div align="right"><font color="#FFFFFF"> 
              <% displayPagelinks rs,intPage,intType %>
              &nbsp;</font></div>
          </td>
        </tr>
        <tr> 
          <td class="4p">&nbsp;</td>
        </tr>
        <tr> 
          <td> 
            <table width="620" border="0" cellspacing="1" cellpadding="2" bordercolorlight="#999999" bordercolordark="#FFFFFF" class="9p" bgcolor="#009966" align="center">
              <tr bgcolor="#DDFFE8"> 
                <td width="144"> 
                  <div align="center"><font color="#999999">网站名称</font></div>
                </td>
                <td width="70"> 
                  <div align="center"><font color="#999999">站长</font></div>
                </td>
                <td width="52"> 
                  <div align="center"><font color="#999999">地域</font></div>
                </td>
                <td width="68"> 
                  <div align="center"><font color="#999999">类型</font></div>
                </td>
                <td width="27"> 
                  <div align="center"><font color="#999999">内容</font></div>
                </td>
                <td width="25"> 
                  <div align="center"><font color="#999999">排版</font></div>
                </td>
                <td width="27"> 
                  <div align="center"><font color="#999999">美工</font></div>
                </td>
                <td width="25"> 
                  <div align="center"><font color="#999999">速度</font></div>
                </td>
                <td width="26"> 
                  <div align="center"><font color="#999999">创意</font></div>
                </td>
                <td width="26"> 
                  <div align="center"><font color="#999999">综合</font></div>
                </td>
                <td width="47"> 
                  <div align="center"><font color="#999999">得票数</font></div>
                </td>
                <td width="57"> 
                  <div align="center"><font color="#999999">浏览数</font></div>
                </td>
              </tr>
              <%  
rs.absolutepage=intPage  
for i=1 to rs.pagesize  
%>
              <tr bgcolor="#FFFFFF"> 
                <td width="144">&nbsp; 
                  <% response.write ("<a href='showinfo.asp?id="&rs("pickid")&"'target='_blank'>"&rs("picksite")&"</a>")%>
                </td>
                <td width="70"> 
                  <div align="center"><font color="#FFFFFF"><font color="#000000"> 
                    <%=rs("pickname")%></font></font>&nbsp;</div>
                </td>
                <td width="52"> 
                  <div align="center"><font color="#FFFFFF"><font color="#000000"> 
                    <% 
typestr=rs("pickdiyu")   
select case typestr 
  case 1: typestr="海口" 
  case 2: typestr="琼山" 
  case 3: typestr="澄迈" 
  case 4: typestr="临高" 
  case 5: typestr="儋州" 
  case 6: typestr="琼海" 
  case 7: typestr="定安" 
  case 8: typestr="万宁" 
  case 9: typestr="屯昌" 
  case 10: typestr="文昌" 
  case 11: typestr="昌江" 
  case 12: typestr="东方"
  case 13: typestr="三亚" 
  case 14: typestr="陵水"
  case 15: typestr="保亭" 
  case 16: typestr="琼中" 
  case 17: typestr="白沙" 
  case 18: typestr="乐东"
  case 19: typestr="五指山" 
  case 20: typestr="其它"    
  case else: typestr="海口" 
end select 
response.write typestr 
%>
                    </font></font></div>
                </td>
                <td width="68"> 
                  <div align="center"><font color="#000000"> 
                    <%typestr=rs("picktype")   
select case typestr 
  case 1: typestr="电脑网络" 
  case 2: typestr="免费资源" 
  case 3: typestr="休闲娱乐" 
  case 4: typestr="文学艺术" 
  case 5: typestr="游戏世界" 
  case 6: typestr="音乐天堂" 
  case 7: typestr="体育生活" 
  case 8: typestr="程序设计" 
  case 9: typestr="商贸金融" 
  case 10: typestr="科技咨讯" 
  case 11: typestr="社会公益" 
  case 12: typestr="另类其它" 
  case else: typestr="电脑网络" 
end select 
response.write typestr 
%>
                    </font></div>
                </td>
                <td width="27"> 
                  <div align="center"><%=rs("pickcontext")%></div>
                </td>
                <td width="25"> 
                  <div align="center"><%=rs("pickprint")%></div>
                </td>
                <td width="27"> 
                  <div align="center"><%=rs("pickart")%></div>
                </td>
                <td width="25"> 
                  <div align="center"><%=rs("pickfast")%></div>
                </td>
                <td width="26"> 
                  <div align="center"><%=rs("pickidea")%></div>
                </td>
                <td width="26"> 
                  <div align="center"><%=rs("pickcount")%></div>
                </td>
                <td width="47"> 
                  <div align="center"><%=rs("pickvote")%></div>
                </td>
                <td width="57"> 
                  <div align="center"><%=rs("pickvisitor")%></div>
                </td>
              </tr>
              <%  
rs.movenext  
if rs.eof then exit for  
next %>
            </table>
          </td>
        </tr>
        <tr> 
          <td class="4p">&nbsp;</td>
        </tr>
        <tr bgcolor="#FFCC99" valign="bottom"> 
          <td height="18" bgcolor="#99CCFF"> 
            <div align="right"><font color="#FFFFFF"> 
              <% displayPagelinks rs,intPage,intType %>
              &nbsp;</font></div>
          </td>
        </tr>
      </table>
      <% end if %>
    </td>
  </tr>
</table>
<!--#include file="bottom.htm" -->
</body> 
</html> 
<% 
Sub DisplayPagelinks(rs,intPage,intType)   '页面导航条 
'------------------------------- 
response.write "共"&rs.RecordCount&"个推荐网站 " 
 
if  intPage>1 then 
  if intType<>0 then 
    response.write "<a href="""&request.ServerVariables("SCRIPT_NAME")&"?type="&intType&"&page=1""><font color='#666666'>首页</font></a> " 
    response.write "<a href="""&request.ServerVariables("SCRIPT_NAME")&"?type="&intType&"&page="&intPage-1&"""><font color='#666666'>上一页</font></a> "     
  else 
    response.write "<a href="""&request.ServerVariables("SCRIPT_NAME")&"?page=1""><font color='#666666'>首页</font></a> " 
    response.write "<a href="""&request.ServerVariables("SCRIPT_NAME")&"?page="&intPage-1&"""><font color='#666666'>上一页</font></a> " 
  end if 
else 
  response.write "首页 "   
  response.write "上一页 " 
end if 
 
if intPage < rs.PageCount then 
  if intType<>0 then 
    response.write "<a href="""&request.ServerVariables("SCRIPT_NAME")&"?type="&intType&"&page="&intPage+1&"""><font color='#666666'>下一页</font></a> " 
    response.write "<a href="""&request.ServerVariables("SCRIPT_NAME")&"?type="&intType&"&page="&rs.PageCount&"""><font color='#666666'>尾页</font></a> " 
  else 
    response.write "<a href="""&request.ServerVariables("SCRIPT_NAME")&"?page="&intPage+1&"""><font color='#666666'>下一页</font></a> " 
    response.write "<a href="""&request.ServerVariables("SCRIPT_NAME")&"?page="&rs.PageCount&"""><font color='#666666'>尾页</font></a> " 
  end if 
else 
  response.write "下一页 " 
  response.write "尾页 " 
end if 
 
'------------------------------- 
End Sub 
%> 
<% 
rs.close 
set rs=nothing 
conn.close 
set conn=nothing 
%> 

