📄 admin_list_true.asp
字号:
<!--#include file="conn.asp"-->
<!--#include file="const.asp"-->
<%
if session("admin")="" then
response.redirect "admin_login.asp"
else
if session("flag")>2 then
response.write "<br><p align=center>您没有操作的权限</p>"
response.end
end if
end if
%>
<%
action=request("action")
set rs=server.createobject("adodb.recordset")
if action="text" then
sql="select * from data where audit=1 and logo='' and vouch=6 order by id desc"
elseif action="logo" then
sql="select * from data where audit=1 and logo<>'' and vouch=6 order by id desc"
elseif action="neiye" then
sql="select * from data where audit=1 and logo<>'' and vouch=7 order by id desc"
else
sql="select * from data where audit=1 order by id desc"
end if
rs.open sql,conn,1,3
rs.pagesize=pagesize_1
page=request("page")
if not rs.eof then
if page="" or page<1 then page=1
rs.absolutepage=page
end if
%>
<html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><title></title>
<link href="css/css.css" rel="stylesheet" type="text/css">
</head>
<body leftmargin="0" topmargin="0" bgcolor="#FFFFFF">
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#999999" width="600">
<tr>
<td height="24" bgcolor="#CCCCCC">
<p align="center"><b><font color="#FF0000">已验证通过站点列表</font></b></td>
<td width="100" bgcolor="#CCCCCC">
<div align="center"><a href="admin_list_true.asp?action=logo"><font color="#FF0000">首页LOGO</font></a></div></td>
<td width="100" bgcolor="#CCCCCC">
<div align="center"><a href="admin_list_true.asp?action=text"><font color="#FF0000">首页文本</font></a></div></td>
<td width="100" align="center" bgcolor="#CCCCCC"><a href="admin_list_true.asp?action=neiye"><font color="#FF0000">内页LOGO</font></a></td>
</tr>
</table>
<%
if not rs.eof then
for i=1 to rs.pagesize
if rs.eof then exit for %>
<table border="1" cellpadding="2" cellspacing="0" style="border-collapse: collapse" bordercolor="#999999" width="600">
<tr>
<td width="90" align="center" bgcolor="#EFEFEF">网站LOGO</td>
<td width="110" align="center" bgcolor="#EFEFEF">网站名称</td>
<td width="80" align="center" bgcolor="#EFEFEF">
<p align="center">站 长</td>
<td width="80" align="center" bgcolor="#EFEFEF">网站类型</td>
<td width="120" align="center" bgcolor="#EFEFEF">所属地区</td>
<td width="30" align="center" bgcolor="#EFEFEF">推荐</td>
<td align="center" bgcolor="#EFEFEF">
<p align="center">验 证</td>
<td align="center" bgcolor="#EFEFEF">
<div align="center">修 改</div></td>
<td align="center" bgcolor="#EFEFEF">删 除</td>
</tr>
<tr>
<td align="center"><a href="open.asp?id=<%=rs("id")%>&url=<%=rs("url")%>" target="_blank">
<%if rs("logo")="" then%>
<%=rs("webname")%>
<%else%>
<img src=<%=rs("logo")%> border=0 width=88 height=31 alt="<%=rs("webname")%>">
<%end if%>
</a></td>
<td align="center"><a href="open.asp?id=<%=rs("id")%>&url=<%=rs("url")%>" target="_blank"><%=rs("webname")%></a> </td>
<td align="center"> <%=rs("name")%></td>
<td align="center">
<%
sql = "select * from type where t_id="& rs("t_id") &""
set Rs1 = Server.CreateObject("ADODB.Recordset")
Rs1.open sql,conn,1,1
do while not Rs1.eof
%>
<%=Rs1("type")%>
<%
Rs1.movenext
loop
Rs1.close
set Rs1 = nothing
%>
</td>
<td align="center">
<%
sql = "select * from area where a_id="& rs("a_id") &""
set Rs2 = Server.CreateObject("ADODB.Recordset")
Rs2.open sql,conn,1,1
do while not Rs2.eof
%>
<%=Rs2("area")%>·
<%
Rs2.movenext
loop
Rs2.close
set Rs2 = nothing
%>
<%
sql = "select * from city where c_id="& rs("c_id") &""
set Rs3 = Server.CreateObject("ADODB.Recordset")
Rs3.open sql,conn,1,1
do while not Rs3.eof
%>
<%=Rs3("city")%>
<%
Rs3.movenext
loop
Rs3.close
set Rs3 = nothing
%>
</td>
<td align="center"><%=rs("vouch")%></td>
<td align="center"><a href="audit_false.asp?id=<%=rs("id")%>"><img border="0" src="images/button_pass.gif"></a></td>
<td align="center"><a href="modify.asp?id=<%=rs("id")%>"><img border="0" src="images/button_edit.gif"></a></td>
<td align="center"><a href="deldata.asp?id=<%=rs("id")%>"><img border="0" src="images/button_del.gif"></a></td>
</tr>
<tr>
<td colspan="9"><font color="#FF6600">网站介绍：</font><%=rs("intro")%></td>
</tr>
</table>
<br>
<% rs.movenext
next
if rs.pagecount>0 then rs.moveprevious
end if
%>
<table width="600" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center"><%=rs.pagesize%>条/页 第<%=page%>页
<% if rs.absolutepage>1 then response.write("<a href='?action=" & action & "&"&page=1&"'>")%>
首页</a>
<% if rs.absolutepage>1 then response.write("<a href='?action=" & action & "&page="&rs.absolutepage-1&"'>")%>
上一页</a>
<% if rs.absolutepage<rs.pagecount then response.write("<a href='?action=" & action & "&page="&rs.absolutepage+1&"'>")%>
下一页</a>
<% if rs.absolutepage<rs.pagecount then response.write("<a href='?action=" & action & "&page="&rs.pagecount&"'>")%>
尾页</a> </div></td>
</tr>
</table></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -