📄 admin_detail_verity.asp

📁 网吧使用的导航web站点
💻 ASP
字号:
<!--#include file="mdb.asp"-->
<%
if session("adminlogin")<>sessionvar then
Response.Write("<script language=javascript>alert('你尚未登录，或者超时了！请重新登录');this.location.href='index.asp';</script>")
Response.End
End if
%>
<HTML>
<HEAD>
<TITLE>网站审核管理</TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"> 
<LINK REL="stylesheet" HREF="css.css" TYPE="text/css">
</HEAD>
<%
dim pn
pn=request("pn")
dim rs(5)
function listunder(i)
	set rs(i)=server.createobject("adodb.recordset")
	rs(i).open "select classid,classname from feilei where topclass="&rs(i-1)("classid"),conn,1,3
	while not rs(i).eof
		dim topclassname
		topclassname=""
		for x=0 to i-1
			topclassname=topclassname&rs(x)("classname")&"＞"
		next
		response.write "<option value='"&rs(i)("classid")&"'>"&topclassname&rs(i)("classname")&"</option>"&vbCrLf
		if i<Ubound(rs) then
			call listunder(i+1)
		end if
		rs(i).movenext
	wend
end function
%>
<BODY>
<table width="96%" border="0" cellspacing="1" cellpadding="8" align="center" bgcolor="#999999">
  <tr> 
    <td bgcolor="#cccccc" align="center">未审核网站列表</td>
  </tr>
  <tr> 
    <td bgcolor="#eeeeee"><br>
<%
dim delete,verity
delete=request("delete")
verity=request("verity")
if delete<>"" and session("lastdeleted")<>delete then
conn.execute "delete from detail where id="&delete
response.write "<big><big><font color='red'>已删除一条编号为"&delete&"的网站记录!</font></big></big><br><br>"
session("lastdeleted")=delete
end if
if verity<>"" and session("lastverityed")<>verity then
conn.execute "update detail set verity=1 where id="&verity
response.write "<big><big><font color='red'>已审核通过一条编号为"&verity&"的网站记录!</font></big></big><br><br>"
session("lastverityed")=verity
end if
%>
<%
if pn="" then pn=1
set r=server.createobject("adodb.recordset")
r.open "select * from detail where verity=0",conn,1,3
if r.bof or r.eof then
	Response.write "没有找到相关记录！<br>"
else
	Call listit()
end if
function listit()
%>
<table border="1" bordercolor="black" cellspacing="0">
<tr>
<td nowrap>编号</td>
<td>网站名称</td>
<td>网站url</td>
<td nowrap>所属分类</td>
<td>其他信息</td>
<td>审核</td>
<td>删除</td>
</tr>
<%
r.pagesize=100
r.absolutepage=pn
rowcount=r.pagesize
do while not r.eof and rowcount>0
set rr=server.createobject("adodb.recordset")
rr.open "select * from feilei where classid="&r("classid"),conn,1,3
if rr.eof then
	classname=""
else
	classname=rr("classname")
end if
response.write "<td nowrap>"&r("id")&"</td>"
response.write "<td nowrap>"&r("title")&"</td>"
response.write "<td nowrap><a href='"&r("url")&"' target='_blank'>"&r("url")&"</td>"
response.write "<td nowrap>"&classname&"</td>"
response.write "<td nowrap>"&r("memo")&"</td>"
response.write "<td nowrap><a href='"&request.servervariables("script_name")&"?pn="&pn&"&verity="&r("id")&"'>通过</a></td>"
response.write "<td nowrap><a href='"&request.servervariables("script_name")&"?pn="&pn&"&delete="&r("id")&"'>删除</a></td></tr>"
rr.close
set rr=nothing
rowcount=rowcount-1
r.movenext
loop
%>
</table>
<%
ppage=pn-1
npage=pn+1
if pn=1 then
%>
<a href='<%=request.servervariables("script_name")%>?pn=1'>首页</a>
<a href='<%=request.servervariables("script_name")%>?pn=<%=r.pagecount%>'>最后一页</a> 
<a href='<%=request.servervariables("script_name")%>?pn=<%=npage%>'>下一页</a> 
每页显示<%=r.pagesize%>个网站，当前第<%=pn%>页，总共<%=r.pagecount%>页 
<% 
elseif pn<r.pagecount then 
%> 
<a href='<%=request.servervariables("script_name")%>?pn=1'>首页</a> 
<a href='<%=request.servervariables("script_name")%>?pn=<%=r.pagecount%>'>最后一页</a> 
<a href='<%=request.servervariables("script_name")%>?pn=<%=ppage%>'>上一页</a> 
<a href='<%=request.servervariables("script_name")%>?pn=<%=npage%>'>下一页</a> 
每页显示<%=r.pagesize%>个网站，当前第<%=pn%>页，总共<%=r.pagecount%>页 
<% 
else 
%> 
<a href='<%=request.servervariables("script_name")%>?pn=1'>首页</a> 
<a href='<%=request.servervariables("script_name")%>?pn=<%=r.pagecount%>'>最后一页</a> 
<a href='<%=request.servervariables("script_name")%>?pn=<%=ppage%>'>上一页</a> 
每页显示<%=r.pagesize%>个网站，当前第<%=pn%>页，总共<%=r.pagecount%>页 
<% 
end if 
end function 
%> 
<br> 
    <br></td> 
  </tr> 
  <tr> 
    <td align="center" bgcolor="#eeeeee">[<font color="#002288"> <a href="http://www.HOTwz.com" target="_blank">热门网址</a> 
      </font>]</td>
  </tr>
</table>
</BODY>
</HTML>
⌨️ 快捷键说明

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