⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 tj_all2.asp

📁 这是一款很好的SQL多用户版程序
💻 ASP
字号:
<%@ CODEPAGE = "936" %>
<!--#include file="inc_config.asp"-->
<%
'权限检查

if  whatcan<1 then Response.Redirect "help.asp?id=004&error=您没有查看详细记录的权限。"
pagesize=mPageSize
if request("page")="" then
  	curpage = 1
else
	curpage = clng(request("page"))
end if
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="refresh" content="60">
<title><%=countname%>-详细记录</title>
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body topmargin=5 rightmargin=0 leftmargin=0 vlink=#000000>
<!--#include file="inc_top.asp"-->
<br>
<table width=500 cellspacing=0 align=center>
  <tr><td>
    <p style="line-height: 100%; margin-left: 15; margin-top: 5; margin-bottom: 0">
    Tips: 用鼠标点指地区可看到IP地址及详细地区,点指访问日期可查看被访问页面。</p>
  </td></tr>
</table>
<br>
<table width="500" cellspacing="0" align="center" cellpadding="0" border="0">
  <tr><td colspan="3"><img src="images/photoup.gif"></td></tr>
  <tr height="30">
    <td width="1" class="backs"></td>
    <td width="498"class="backq">
		&nbsp; <img src="images/tb_title.gif" align=absmiddle> &nbsp;∷∷∷ 详 细 记 录 ∷∷∷<br>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#5EC707" width="480" align=center>
  <tr align=center height="25">
    <td width="90">时 &nbsp; 间</td><td width="40">地区</td><td width="40">屏宽</td><td width="55">操作系统</td><td width="55">浏览器</td><td width="200">被访问页面</td>
  </tr>
<%
set conn=server.createobject("adodb.connection")

conn.Open constr
Set rs = Server.CreateObject("ADODB.Recordset")
sql = "SELECT top 1000 * FROM views WHERE mem_id = " & uid & " ORDER BY id DESC"
rs.open sql,conn,1,1
if rs.bof and rs.eof then
	rs.close
	response.write "<tr><td colspan='6'><br><center>" & wherestr & "没有符合条件的记录</center><br></td></tr></table></td></tr></table>"
else
	dim i
	rs.pagesize = pagesize
	if rs.pagecount < curpage then
		rs.absolutepage=rs.pagecount
		curpage=rs.pagecount
	else
		rs.absolutepage = curpage
	end if
for i = 1 to rs.pagesize
rsvpage=rs("vpage")
thistime=rs("vtime")
thisip=rs("vIP")
thisvwheref=rs("vwhere")
thisvlang=rs("vlang")
vcome=rs("vcome")
	rsvpage2=rsvpage
	thelen=len(rsvpage)	
	rsvpage=findurl(rsvpage)
	if len(vcome) < 1 Then
	title1 = "时间:"&thistime & Vbcrlf &"被访页面:" & rsvpage2
	Else
	title1 = "时间:"&thistime & Vbcrlf &"被访页面:" & rsvpage2 & Vbcrlf &"来源网页:"& vcome
	end if		
	title2 = thisip & "." & thisvwheref & Vbcrlf& "浏览器语言:" & thisvlang & Vbcrlf& " 点击此处,以 http 方式访问该 IP 地址。" 

%>
  <tr height="1" bgcolor="#5EC707"><td colspan=6></td></tr>
  <tr height="18" title="<%=title1%>" >
	<td ><%= month(thistime) & "-" & day (thistime) & " " & formatdatetime(thistime,4)%></td>
	<td><a href = "<%="http://" & thisip %>" title="<%=title2%>"><%=thisvwheref%></a></td>
	<td align=center><%=rs("vwidth")%></td>
	<td align=center><%=rs("vOS")%></td>
	<td align=center><a href="<%=vcome%>" title ="访问来源页面:<%=vcome%>"><%=rs("vsoft")%></a></td>
	<td><a href ="<%=rsvpage2%>">&nbsp;<%=rsvpage%>...</td>
  </tr>
<%
  rs.movenext
    if rs.eof then
      i = i + 1
      exit for
    end if
  next
%>
</table>
	</td>
    <td width="1" class="backs"></td>
  </tr>
  <tr><td colspan="4"><img src="images/photodown.gif"></td></tr>
</table>

<br>
<table width=500 cellspacing=0 align=center cellpadding=0>
<form method=post action="tj_all2.asp" id=form2 name=form2>
  <tr><td colspan=3><img src=images/photoup.gif></td></tr>
  <tr height=65>
    <td width=1 class=backs></td>
    <td class=backq width="498">
		&nbsp; <img src="images/gb-search.gif" align=absmiddle> ∷∷∷ 翻 页 ∷∷∷ <a href="tj_all2.asp" title="原程序,使用数据库分页属性分页">tj_all2.asp </a> <a href="tj_all.asp" title="优化后的分页程序">tj_all.asp </a>  <br><br>
     &nbsp; 第<font class="fonts"><%=cstr(curpage)%></font>页 总<font class="fonts"><%=cstr(rs.pagecount)%></font>页 本页<font class="fonts"><%=cstr(i-1)%></font>条 总<font class="fonts"><%=cstr(rs.recordcount)%></font>条 &nbsp;
      <%
      wherestr=server.URLEncode(wherestr)
      if curpage <> 1 then%>
		<a href="tj_all2.asp?page=1&wherestr=<%=wherestr%>">&lt;&lt;首页 </a>
		<a href="tj_all2.asp?page=<%=cstr(curpage-1)%>&wherestr=<%=wherestr%>">&lt;上一页 </a>
      <%else%>
        <font color="#888888">&lt;&lt;首页 &lt;上一页</font>
      <%end if
      if curpage <> rs.pagecount then%>
		<a href="tj_all2.asp?page=<%=cstr(curpage+1)%>&wherestr=<%=wherestr%>"> 下一页&gt;</a>
		<a href="tj_all2.asp?page=<%=cstr(rs.pagecount)%>&wherestr=<%=wherestr%>"> 尾页&gt;&gt;</a>
      <%else%>
         <font color="#888888">下一页&gt; 尾页&gt;&gt;</font>
      <%end if%>
		<input type=hidden name=wherestr value="<%=wherestr%>">&nbsp;<input type=text name='page' size=9 class=input> <input type=submit value=' ' class="backc2">
	</td>
    <td width=1 class=backs></td>
  </tr>
  <tr><td colspan=3><img src=images/photodown.gif></td></tr>
</form>
</table>
<br>
<%
'如果是检索结果,则显示保存数据表单
wherestr=Request("wherestr")
if wherestr <> "" then
wherestr=Request("wherestr")
'保存数据表单
if session.Contents("masterlogin")=true or whatcan>=6 then

%>
<table width="500" cellspacing="0" align="center" cellpadding="0" border="0">
  <tr><td colspan="3"><img src="images/photoup.gif"></td></tr>
  <form action="tj_save.asp" method=post id=form1 name=form1>
  <tr height="30">
    <td width="1" class="backs"></td>
    <td width="498"class="backq">
		&nbsp; <img src="images/tb_save.gif" align=absmiddle><font style="font-size:16px">&nbsp;</font>∷∷∷ 保存这次检索条件 ∷∷∷<br>

	<p class="p1"><font class="fonts"><b>检索条件</b></font>&nbsp; <%if wherestr="" then%>没有检索条件<%else%><%=wherestr%><%end if%>。
	<p class="p1" style='margin-bottom: 0;margin-top: 0;'><font class="fonts"><b>查询项目</b></font>&nbsp; 详细。
	<p class="p1" style='line-height: 100%;margin-bottom: 0;margin-top: 0;'><font class="fonts"><b>取个名字</b></font>&nbsp; <input name="name" size="16" class="input">&nbsp;
	<INPUT type="radio" name="overwrite" value="0" checked> 同名时提示&nbsp;
	<INPUT type="radio" name="overwrite" value="1"> 同名时覆盖
	<p class="p1" style='line-height: 100%;margin-bottom: 0;margin-top: 0;'><font class="fonts"><b>加个介绍</b></font>&nbsp; <input name="content" size="50" class="input">
	<p class="p1" style='margin-top: 0;' align="right">
	<a href="help.asp?id=002">帮助</a>
	<a href='javascript:document.forms[0].submit();'>保存</a>
	<input type="hidden" name="wherestr" value="<%=wherestr%>"><input type="hidden" name="outtype" value="详细"><input type="submit" value=" " name="save" class="backc2"><font style="font-size:16px">&nbsp;</font>&nbsp;

	</td>
    <td width="1" class="backs"></td>
  </tr>
  </form>
  <tr><td colspan="4"><img src="images/photodown.gif"></td></tr>
</table>
<br>
<%
end if
end if
%>

<%
rs.close
end if

set rs=nothing
conn.Close
set conn=nothing

%>
<!--#include file="inc_bottom.asp"-->
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -