📄 admin_url.asp
字号:
<!--#include file="mdb.asp"-->
<%
if session("adminlogin")<>sessionvar then
Response.Write("<script language=javascript>alert('你尚未登录，或者超时了！请重新登录');this.location.href='admin_login.asp';</script>")
Response.End
End if
dim pn,sql
dim Wrong,recommend,link,verity,by,word
dim userid,classid
if not request("pn")="" then pn=ReplaceBadChar(Trim(request("pn")))
if not request("recommend")="" then recommend=ReplaceBadChar(Trim(request("recommend")))
if not request("link")="" then link=ReplaceBadChar(Trim(request("link")))
if not request("verity")="" then verity=ReplaceBadChar(Trim(request("verity")))
if not request("by")="" then by=ReplaceBadChar(Trim(request("by")))
if not request("word")="" then word=ReplaceBadChar(Trim(request("word")))
if not request("userid")="" then userid=ReplaceBadChar(Trim(request("userid")))
if not request("classid")="" then classid=ReplaceBadChar(Trim(request("classid")))
if not request("wrong")="" then wrong=ReplaceBadChar(Trim(request("wrong")))
sql="select * from O3888_website order by [id] desc"
list=""
if recommend=1 then
sql="select * from O3888_website where recommend=1 order by [id] desc"
list="&recommend=1"
end if
if link=1 then
sql="select * from O3888_website where link=1 order by [id] desc"
list="&link=1"
end if
if verity=1 then
sql="select * from O3888_website where verity=-1 order by [id] desc"
list="&verity=1"
end if
if verity=2 then
sql="select * from O3888_website where verity=0 order by [id] desc"
list="&verity=2"
end if
if verity=3 then
sql="select * from O3888_website where verity=1 order by [id] desc"
list="&verity=2"
end if
if userid<>"" then
sql="select * from O3888_website where userid="&userid&" order by [id] desc"
list="&userid="&userid&""
end if
if classid<>"" then
sql="select * from O3888_website where classid="&classid&" order by [id] desc"
list="&classid="&classid&""
end if
if wrong<>"" then
sql="select * from O3888_website where wrong="&wrong&" order by [id] desc"
list="&wrong="&wrong&""
end if
if by="url" then
sql="select * from O3888_website where url like '%"&word&"%' order by [id] desc"
list="&word="&word&"&by="&by&""
end if
if by="title" then
sql="select * from O3888_website where title like '%"&word&"%' order by [id] desc"
list="&word="&word&"&by="&by&""
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>
<BODY>
<table width="96%" border="0" cellspacing="1" cellpadding="8" align="center" class="b">
<tr>
<td align="center">网站列表</td>
</tr></table>
<table width="96%" border="0" cellspacing="1" cellpadding="8" align="center" class="a">
<tr>
<td colspan="12">
<table border="0" cellspacing="1" cellpadding="8" width=100% class="a">
<tr>
<td align=center width=20%><a href='<%=request.servervariables("script_name")%>?recommend=1'>推荐网站</a></td>
<td align=center width=20%><a href='<%=request.servervariables("script_name")%>?link=1'>友情连接</a></td>
<td align=center width=20%><a href='<%=request.servervariables("script_name")%>?wrong=1'>报错网站</a></td>
<td align=center width=20%><a href='<%=request.servervariables("script_name")%>?verity=3'>已通过审核</a></td>
<td align=center width=20%><a href='<%=request.servervariables("script_name")%>?verity=1'>未通过审核</a></td>
</tr>
</table>
</td>
</tr>
<tr>
<td>编号</td>
<td>网站名称</td>
<td>网站url</td>
<td>所属分类</td>
<td>所属会员</td>
<td>友情连接</td>
<td>网址推荐</td>
<td>审核情况</td>
<td>去路</td>
<td>编辑</td>
<td>删除</td>
</tr>
<%
if pn="" then pn=1
set r=server.createobject("adodb.recordset")
r.open sql,conn,1,3
if r.bof or r.eof then
Response.write "<tr><td colspan='12'>没有找到相关记录</td></tr>"
else
r.pagesize=50
r.absolutepage=pn
rowcount=r.pagesize
do while not r.eof and rowcount>0
response.write "<tr><td>"&r("id")&"</td>"
response.write "<td><font color='"&r("color")&"'>"&r("title")&"</font></td>"
response.write "<td><a href='"&r("url")&"' target='_blank' title='查看站点'>"&cut(r("url"),26)&"</a></td>"
set rr=server.createobject("adodb.recordset")
rr.open "select * from O3888_class where classid="&r("classid"),conn,1,3
if rr.eof then
classname=""
else
classname=rr("classname")
end if
rr.close
set rr=nothing
response.write "<td>"&classname&"</td>"
set rrr=server.createobject("adodb.recordset")
rrr.open "select * from O3888_user where id="&r("userid"),conn,1,3
if rrr.eof then
username="<font color=#941AE6>管理员</font>"
else
username="<font color=red>"&rrr("username")&"</font>"
end if
rrr.close
set rrr=nothing
response.write "<td>"&username&"</td>"
if r("link")=1 then
response.write "<td><font color='#FF0000'>是</font></td>"
else
response.write "<td>否</td>"
end if
if r("recommend")=1 then
response.write "<td><font color='#FF0000'>已推荐</font></a></td>"
else
response.write "<td>未推荐</td>"
end if
if r("verity")=1 then
response.write "<td>已经审核</td>"
else
if r("verity")=-1 then
response.write "<td><font color=#941AE6>未通过审核</font></td>"
else
response.write "<td><font color=red>还未审核</font></td>"
end if
end if
response.write "<td>"&r("Exits")&"</td>"
response.write "<td><a href='admin_url_edit.asp?id="&r("id")&"' title='编辑站点信息'>编辑</a></td>"
response.write "<td><a href='admin_url_delete.asp?id="&r("id")&"' title='删除站点'>删除</a></td></tr>"
rowcount=rowcount-1
r.movenext
loop
end if
%>
<tr>
<td bgcolor="#eeeeee" colspan="12">
<%
ppage=pn-1
npage=pn+1
totalpage=r.pagecount
if pn=1 then ppage=1
if pn=totalpage then npage=1
if cint(totalpage)>cint(pn) then
%>
<a href='<%=request.servervariables("script_name")%>?pn=1<%=list%>'>首页</a>
<a href='<%=request.servervariables("script_name")%>?pn=<%=totalpage%><%=list%>'>最后一页</a>
<a href='<%=request.servervariables("script_name")%>?pn=<%=ppage%><%=list%>'>上一页</a>
<a href='<%=request.servervariables("script_name")%>?pn=<%=npage%><%=list%>'>下一页</a>
每页显示<%=r.pagesize%>个网站，当前第<%=pn%>页，总共<%=totalpage%>页
<%
else
if pn=1 then
%>
<a href='<%=request.servervariables("script_name")%>?pn=1<%=list%>'>首页</a>
<a href='<%=request.servervariables("script_name")%>?pn=<%=totalpage%><%=list%>'>最后一页</a>
<a href='<%=request.servervariables("script_name")%>?pn=<%=npage%><%=list%>'>下一页</a>
每页显示<%=r.pagesize%>个网站，当前第<%=pn%>页，总共<%=totalpage%>页
<%
else
%>
<a href='<%=request.servervariables("script_name")%>?pn=1<%=list%>'>首页</a>
<a href='<%=request.servervariables("script_name")%>?pn=<%=totalpage%><%=list%>'>最后一页</a>
<a href='<%=request.servervariables("script_name")%>?pn=<%=ppage%><%=list%>'>上一页</a>
每页显示<%=r.pagesize%>个网站，当前第<%=pn%>页，总共<%=totalpage%>页
<%
end if
end if
%>
</td></tr>
<tr>
<td align="center" colspan="12">[<A href='http://www.03888.com/' target=_blank>03888网址大全</A>]</td>
</tr>
</table>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -