?? default.asp
字號:
<%Option Explicit%><!--#include file="conn.asp"--><%
dim connpic
dim rs_user,rs_today,rs_lar,rs_new,rs_board,rs_boy,rs_girl
dim sql,records,today_records,rs_pic
dim i,j,k
if isempty(session("user_id")) then session("user_id")=1
'取得入會人數
Set rs_user = Server.CreateObject("ADODB.Recordset")
rs_user.open "user_reg",conn,1,1
records=rs_user.recordcount
rs_user.close:set rs_user=nothing
'取得當天入會人數
Set rs_today = Server.CreateObject("ADODB.Recordset")
rs_today.open "select * from user_reg where date=#" & cdate(date) & "#" ,conn,1,1
today_records=rs_today.recordcount
rs_today.close:set rs_today=nothing
'取得人氣最高的網友（10位）
Set rs_lar = Server.CreateObject("ADODB.Recordset")
rs_lar.open "select * from larchives order by renqi desc",conn,1,1
'取得人氣最高的男主角
Set rs_boy = Server.CreateObject("ADODB.Recordset")
sql="select * from larchives where photo>0 and sex like '" & "男" & "' order by renqi desc"
rs_boy.open sql,conn,1,1
'取得人氣最高的女主角
Set rs_girl = Server.CreateObject("ADODB.Recordset")
sql="select * from larchives where photo>0 and sex like '" & "女" & "' order by renqi desc"
rs_girl.open sql,conn,1,1
'取得最新加入的網友（10位）
Set rs_new = Server.CreateObject("ADODB.Recordset")
rs_new.open "select * from larchives order by lar_id desc",conn,1,1
'取得尋友啟事
Set rs_board = Server.CreateObject("ADODB.Recordset")
rs_board.open "select * from callboard order by id desc",conn,1,1
%>
<html>
<head>
<LINK href="pic/gufeng.css" rel=stylesheet>
<script language="JavaScript" src="pic/fade_image.js"></script>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>酒鄉網友聯盟</title>
<SCRIPT language=JavaScript>
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
if (theURL != "fuckyou")
{ window.open(theURL,winName,features);}
}
//-->
</SCRIPT>
</head>
<body topmargin="0" leftmargin="0">
<div align="center">
<center>
<TABLE align=center border=0 cellPadding=0 cellSpacing=0 height=20 width=777>
<tr>
<td width="100%"><table border="0" cellpadding="0" cellspacing="0" width="777" height="21" bgcolor="#FFF4C8" background="pic/di.GIF">
<tr>
<td width="23%" height="19"><img border="0" src="pic/htt.GIF" width="227" height="20"></td>
</center>
<td width="33%" height="19">
</td>
<center>
<td width="3%" height="19" align="center">□</td>
<td width="8%" height="19" align="center"><a href="my.asp">關于我們</a></td>
<td width="3%" height="19" align="center">□</td>
<td width="8%" height="19" align="center"><a href="../book">本站留言</a></td>
<td width="3%" height="19" align="center">□</td>
<td width="8%" height="19" align="center"><a href="javascript:window.external.AddFavorite('http://www.644000.net',%20'酒鄉網友聯盟')">添加收藏</a></td>
<td width="3%" height="19" align="center">□</td>
<td width="8%" height="19" align="center"><a href="#" onclick="this.style.behavior='url(#default#homepage)';this.setHomePage('http://www.644000.net');">設為首頁</a></td>
</tr>
</table>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" width="777" bgcolor="#000000" height="1">
<tr>
<td width="100%"></td>
</tr>
</table>
</center>
</div>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" width="777" height="90" bgcolor="#F9C700">
<tr>
<td width="100%" height="88">
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" width="777">
<tr>
<td width="243" align="left"><img border="0" src="pic/logo.GIF" width="240" height="70"></td>
<td width="12" align="left"></td>
</center>
</center>
</center>
<td width="500" align="center" valign="middle">
<p align="center"><!--Banner-->
<script src="http://www.644000.net/guanggao/banner.asp"></script>
<!--Banner --></p>
</td>
<center>
<center>
<center>
<td width="14" align="center"></td>
</tr>
</table>
</center>
</div>
</td>
</tr>
</table>
</center>
</div>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" width="777" height="1" bgcolor="#000000">
<tr>
<td width="100%"></td>
</tr>
</table>
</center>
</div>
<div align="center">
<center>
<table border="0" cellpadding="0" width="777" bgcolor="#FFF4C8" height="20" cellspacing="0">
<tr>
<td width="4%" align="center"><img border="0" src="pic/tou.GIF" width="28" height="20" style="filter:alpha(opacity=40)" onMouseOver="fade_in(this);" onMouseOut="fade_out(this);"></td>
<td width="10%" align="center"><a href="#"><img border="0" src="logo/1.gif"></a></td>
<td width="2%" align="center"><img border="0" src="pic/heng.gif" width="2" height="12"></td>
<td width="10%" align="center"><a href="reg.asp"><img border="0" src="logo/2.gif"></a></td>
<td width="2%" align="center"><img border="0" src="pic/heng.gif" width="2" height="12"></td>
<td width="10%" align="center"><a href="register.asp"><img border="0" src="logo/3.gif"></a></td>
<td width="2%" align="center"><img border="0" src="pic/heng.gif" width="2" height="12"></td>
<td width="10%" align="center"><a href="your.asp"><img border="0" src="logo/4.gif"></a></td>
<td width="2%" align="center"><img border="0" src="pic/heng.gif" width="2" height="12"></td>
<td width="10%" align="center"><a href="list.asp"><img border="0" src="logo/5.gif"></a></td>
<td width="2%" align="center"><img border="0" src="pic/heng.gif" width="2" height="12"></td>
<td width="10%" align="center"><a href="sendphoto.asp"><img border="0" src="logo/6.gif"></a></td>
<td width="2%" align="center"><img border="0" src="pic/heng.gif" width="2" height="12"></td>
<td width="10%" align="center"><a href="jh" target="_blank"><img border="0" src="logo/7.gif"></a></td>
<td width="2%" align="center"><img border="0" src="pic/heng.gif" width="2" height="12"></td>
<td width="10%" align="center"><a href="http://www.644000.net/bbs" target="_blank"><img border="0" src="logo/8.gif"></a></td>
</tr>
</table>
</center>
</div>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" width="100%" bgcolor="#000000" height="1">
<tr>
<td width="100%"></td>
</tr>
</table>
</center>
</div>
</td>
</tr>
</table>
</div>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" width="777" height="412">
<tr>
<td width="174" height="1" bgcolor="#FFFFFF"> </td>
<td width="425" height="1" colspan="4"></td>
<td width="171" height="1" bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td width="174" height="26" bgcolor="#FFFFFF">
<img border="0" src="pic/zuixinjia.GIF" width="150" height="22">
</td>
<td width="13" height="26"></td>
<td width="399" height="26" colspan="2"><img border="0" src="pic/changyuan.GIF" width="399" height="28"></td>
<td width="15" height="26"></td>
<td width="171" height="26" bgcolor="#FFFFFF" align="right"> <img border="0" src="pic/bbs.GIF" width="150" height="22"></td>
</tr>
<tr>
<td width="174" height="157" bgcolor="#FFFFFF">
<table border="1" cellpadding="0" cellspacing="0" width="87%" height="167" bgcolor="#FFF4C8" bordercolorlight="#000000" bordercolordark="#FFF4C8">
<tr>
<td width="100%" height="165" bgcolor="#FFF4C8" valign="top">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="20%" bgcolor="#FFF4C8">
<p align="center"><font color="#000000">性別</font></p>
</td>
<td width="61%" bgcolor="#FFF4C8">
<p align="center"><font color="#000000">網名</font></p>
</td>
<td width="19%" bgcolor="#FFF4C8"><font color="#000000">人氣</font></td>
</tr>
<%i=1%>
<%do while not(rs_new.eof) and i<11%>
<tr>
<td width="20%" align="center"><%=rs_new("sex")%></td>
<td width="63%" align="left">
<p align="center"><a href="read.asp?user_id=<%=rs_new("user_id")%>"><%=rs_new("netname")%></a></td>
<td width="17%" align="center"><%=rs_new("renqi")%></td>
</tr>
<%i=i+1%>
<%rs_new.movenext%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -