online.asp
上传用户:maming258
上传日期:2022-01-28
资源大小:283k
文件大小:4k
源码类别:

WEB源码(ASP,PHP,...)

开发平台:

HTML/CSS

  1. <!--#include file="inc/conn.asp" -->
  2. <!--Powered by flymorn,www.cn-pn.com-->
  3. <%
  4. Response.Expires = 0 '立即过时,防漏统计
  5. '判断是否清空昨天的IP数据,保留当天数据
  6. sql="Select top 1 thisdate from ip"
  7. set rs=conn.execute(sql)
  8. If rs.eof and rs.bof Then                   
  9. Else
  10. date1=rs(0)
  11. if cstr(date1)<>cstr(date) then
  12. '取值
  13. sql1="select * from cnt where id =1"                 
  14. set rs1=server.createobject("adodb.recordset")                  
  15. rs1.open sql1,conn,1,1
  16. day2ip=rs1("yesdayip")
  17. day2pv=rs1("yesdaypv")
  18. rs1.close
  19. set rs1=nothing
  20. yesdayip=todayip() '函数取值
  21. yesdaypv=todaypv() '函数取值
  22. '更新
  23. sql2="update cnt set day2ip="&day2ip&",day2pv="&day2pv&",yesdayip="&yesdayip&",yesdaypv="&yesdaypv&",totalip=totalip+"&yesdayip&",totalpv=totalpv+"&yesdaypv&" where id = 1"
  24. conn.execute(sql2)
  25. '删除昨天数据
  26. sqlip="Delete FROM ip"
  27. Conn.Execute sqlip
  28. sqlurl="Delete FROM urls"
  29. Conn.Execute sqlurl
  30. sqlcome="Delete FROM comes"
  31. Conn.Execute sqlcome
  32. end if
  33. end if
  34. rs.close
  35. set rs=nothing
  36. 'IP在线列表统计
  37. dim id
  38. id=replace(Request.ServerVariables("REMOTE_HOST"),".","")
  39. if Request.ServerVariables("HTTP_X_FORWARDED_FOR")<>"" then
  40. id=replace(Request.ServerVariables("HTTP_X_FORWARDED_FOR"),".","")
  41. end if
  42. sql="select id from ip where id='"&id&"'"
  43. set rs=conn.execute(sql)
  44. if rs.eof and rs.bof then
  45. sql="insert into ip(id,ip,dlip,startime,lastime,browser,url) values ('"&id&"','"&Request.ServerVariables("REMOTE_HOST")&"','"&Request.ServerVariables("HTTP_X_FORWARDED_FOR")&"',now(),now(),'"&Request.ServerVariables("HTTP_USER_AGENT")&"','"&Request.ServerVariables("HTTP_REFERER")&"')"
  46. else
  47. sql="update ip set lastime=now(),url='"&Request.ServerVariables("HTTP_REFERER")&"',n=n+1 where id='"&id&"'"
  48. end if
  49. conn.execute(sql)
  50. rs.close
  51. set rs=nothing
  52. '页面点击排行
  53. dim url
  54. url=Request.ServerVariables("HTTP_REFERER")
  55. if url="" then
  56. url="直接输入访问"
  57. end if
  58. if len(url)>240 then
  59. url=left(url,240)
  60. end if
  61. sql="select url from urls where url='"&url&"'"
  62. set rs=conn.execute(sql)
  63. if rs.eof and rs.bof then
  64. sql="insert into urls(url) values ('"&url&"')"
  65. else
  66. sql="update urls set n=n+1 where url='"&url&"'"
  67. end if
  68. conn.execute(sql)
  69. rs.close
  70. set rs=nothing
  71. '在线IP
  72. function online()
  73. sql="Select count(id) from ip WHERE DATEDIFF('s', lastime, now()) < "&kicktime&"*60"
  74. set ips=conn.execute(sql) 
  75. online=ips(0)
  76. ips.close
  77. set ips=nothing 
  78. if isnull(online) then 
  79. online=0
  80. end if
  81. end function 
  82. '今日IP
  83. function todayip()
  84. sql="Select count(id) from ip"
  85. set ipss=conn.execute(sql) 
  86. todayip=ipss(0)
  87. ipss.close 
  88. set ipss=nothing 
  89. if isnull(todayip) then 
  90. todayip=0
  91. end if
  92. end function
  93.  
  94. '今日PV
  95. function todaypv()
  96. sql="Select sum(n) from ip"
  97. set rs=conn.execute(sql)
  98. If rs.eof and rs.bof Then 
  99. todaypv=0                    
  100. Else
  101. todaypv=rs(0)
  102. end if
  103. rs.close
  104. set rs=nothing 
  105. end function 
  106. '来路
  107. Function finddir(filepath)
  108. finddir=""
  109. for i=1 to len(filepath)
  110. if left(right(filepath,i),1)="/" or left(right(filepath,i),1)="" then
  111.   abc=i
  112.   exit for
  113. end if
  114. next
  115. if abc <> 1 then
  116. finddir=left(filepath,len(filepath)-abc+1)
  117. end if
  118. end Function
  119. theurl="http://" & Request.ServerVariables("http_host") & finddir(Request.ServerVariables("url"))
  120. Response.Write "document.write('<a href=/mycount/index.asp target=_blank title=飘易统计>[在线<strong>"& online() &"</strong>人]</a>')"
  121. '关闭数据库
  122. conn.close
  123. set conn=nothing
  124. %>
  125. document.write("<script>var url='<%=theurl%>';</script>")
  126. document.write("<script language=javascript src="+url+"/stat.asp?referer="+escape(document.referrer)+"></script>");