<%
'连接数据库
Dim conn,connstr
on error resume next
connstr="DBQ="+server.mappath("#Down1.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"'数据库连接地址
set conn=server.createobject("ADODB.CONNECTION")
conn.open connstr

dim mRs,Ip,Zday,Counter,CountemRs,Today,Daynum,Yesterday,Top,TopIp,Stats,Browser
	Ip = Request.ServerVariables("HTTP_X_FORWARDED_FOR")
	If Ip = "" Then Ip = Request.ServerVariables("REMOTE_ADDR")

Set mRs=Server.CreateObject("adodb.recordSet")
Sql="Select * from [Counter]"
mRs.open Sql,conn,1,3
'判断最高IP量是否大于数据库记录,如果大于替换为当前记录
If mRs("TopIp")<mRs("Today") then
	mRs("TopIp")=mRs("Today")
	mRs.update
End If

'判断最高浏览量是否大于数据库记录,如果大于替换为当前记录
If mRs("Top")<mRs("Browser") then
	mRs("Top")=mRs("Browser")
	mRs.update
End If

'判断日期是否为今天
If mRs("Oto")<>date() then
	'日期为当前时间-1
	Zday=date()-1

	'将今日IP,今日浏览改为0;日期改为当前日期,统计天数+1,昨日IP访问量改变
	conn.Execute"Update [Counter] Set Today=0,Browser=0,Oto=date(),Daynum=Daynum+1,YesterdayIp="& mRs("Today") &",Yesterday="& mRs("Browser") &""

	'新增总访问天数,每天的IP数,每天的访问量
	conn.Execute"Insert into [Day](Zday,Stats,Browser) values ('"& Zday &"',"& mRs("Today") &","& mRs("Browser") &")"

	'删除所有IP
	conn.Execute"delete from [Ip]"
Else
	'今日浏览量+1,总访问人数+1
	conn.Execute"Update [Counter] Set Browser=Browser+1,Counter=Counter+1"
End If


'关闭记录集
mRs.close
Set mRs=nothing

'打开IP数据库,将当前IP写入数据库
Set mRs=Server.CreateObject("adodb.recordSet")
Sql="Select * from [Ip] where IP='"& Ip &"' order by Id desc"
mRs.open Sql,conn,1,3
	If mRs.bof and mRs.eof then
		mRs.addnew
		mRs("IP")=Ip
		mRs.update
		'今日IP访问量+1
		conn.Execute"Update [Counter] Set Today=Today+1,CounterIp=CounterIp+1"
	End If

'关闭记录集和数据库
mRs.close
Set mRs=nothing
conn.close
Set conn=nothing
%>