<!--#include file="login/0.asp"-->
<!--#include file="../mycartconn/conn.asp"-->

<!--#include file="login/menu.asp"-->
<%
'删除超过20分钟的SQL入侵记录
conn.execute("Delete nosql where (datediff(n,sj,getdate())>js*6 or datediff(n,sj,getdate())>20) and js<>999")
'删除过期的登陆记录
conn.execute("Delete ip where datediff(d,sj,getdate())>30")
'显示登陆信息
Set rs= Server.CreateObject("ADODB.Recordset")
sql="select * from ip  order by id DESC"
rs.open sql,conn,1,1
%>
<html>
<link href="../mycartconn/admin.css" rel="stylesheet" type="text/css">
<body>
<meta http-equiv='refresh' content='60'>
<table width="100%" height="100%" align="center" cellpadding="0" cellspacing="0">
  <tr> 
    <td align="center" valign="middle"> 
      <table width="650" align="center" cellpadding="0" cellspacing="0">
        <tr> 
          <td valign="top">您的登陆名称<%= rs("name") %>，IP地址<%= rs("ip") %>，所用浏览器<%= rs("win") %>，登陆时间<%= rs("sj") %>。网站信息如下：<br>
            <br>
          </td>
        </tr>
      </table>
<%rs.close
set rs=nothing%>
		<table width="450" border="0" align="center" cellpadding="0" cellspacing="0">
		  <tr valign="middle"> 
			<td height="20" colspan="4">今日新增数据：</td>
		  </tr>
		  <tr valign="middle"> 
			<td width="25%" height="20"><a href="guestbook/guanli.asp">咨询信息<font color="#FF3333"><%=conn.execute("select count(id) from guestbook where datediff(d,sj,getdate())<1")(0)%></font>条</a></td>
			<td width="25%" height="20"><a href="admin_bbs/admin.asp">社区贴子<font color="#FF3333"><%=conn.execute("select count(id) from bbs where datediff(d,sj,getdate())<1")(0)%></font>篇</a></td>
			<td width="25%" height="20"><a href="huiyuan/huiyuan.asp">注册会员<font color="#FF3333"><%=conn.execute("select count(id) from huiyuan where datediff(d,sj,getdate())<1")(0)%></font>位</a></td>
			<td width="25%" height="20"><a href="shangchuan/index.asp">上传图片<font color="#FF3333"><%=conn.execute("select count(id) from shangchuan where datediff(d,sj,getdate())<1")(0)%></font>个</a></td>
		  </tr>
		</table>
		<br>

	  </td>
  </tr>
</table>
</body></html>
<%conn.close
set conn=nothing
conn.close
set conn=nothing%>