📄 templinklist.asp
字号:
<%Server.ScriptTimeout=500%>
<%
id=1
%>
<!-- #include file=../database.asp -->
<%
Set rs = Server.CreateObject("ADODB.Recordset")
function CheckPassword()
sql="select * from ourusers where Ltrim(Rtrim(username))='supervisor'"
rs.open sql,conn,1,1
if not rs.eof then
if trim(rs("pass"))<>session("pass") then
response.write "<br>错误的密码!"
rs.close
set rs=nothing
conn.close
set conn=nothing
response.end
else
rs.close
end if
else
response.write "错误:用户不存在!"
rs.close
set rs=nothing
conn.close
set conn=nothing
response.end
end if
end function
checkPassword()
%>
<!-- Design and Edit By QianFengyun 2000-5-20 -->
<!-- #include file=../change.asp -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0041)http://www.china114net.com 中国114网 -->
<html>
<head>
<title><%=titlename%></title>
<meta http-equiv='Content-Type' content='text/html; charset=gb2312'>
<link rel="stylesheet" type="text/css" href="../html/style.css">
<script language="javascript">
function singleDelete(id){
if (confirm('真的要删除吗?'))
this.location.href="deljoin.asp?id=<%=id%>&page=&submitType=0&fid="+id
}
function singleAdd2Essence(id){
if (confirm('Sure to add?'))
this.location.href="manage.asp?page=&submitType=1&selAnnounce="+id
}
function submitIt(t,theForm){
theForm.submitType.value=t
if (t==0){
if (confirm('真的要删除吗?'))
theForm.submit()
}
else{
if (confirm('Sure to add?'))
theForm.submit()
}
}
</script>
</HEAD>
<BODY topmargin=10 bgcolor=ccbbaa>
<%
pagen=50
page=request("page")
if isNumeric(page)=0 then
page=1
else
if page<1 then
page=1
else
page=int(page)
end if
end if
Set rs = Server.CreateObject("ADODB.Recordset")
Sql="select * from templink order by id"
Rs.open Sql,conn,1,1
dim flag
flag=0
if not Rs.eof then
flag=1
response.write "<form ACTION=deleteuser.asp?page=1 METHOD=POST NAME=frmManage>"
response.write "<input type=hidden name=submitType value=0>"
else
response.write "还没有用户"
Rs.close
set Rs=nothing
conn.close
set conn=nothing
response.end
end if
num=Rs.recordcount
maxpage=int(num/pagen)+1
if (num mod pagen)=0 then maxpage=maxpage-1
if int(page)>maxpage then page=maxpage
if int(page)>99999999 then page=int(num/pagen)+1
Rs.pagesize=pagen
Rs.absolutepage=page
Response.Write "<table width='100%' cellpadding='2' cellspacing='2'>"
Response.Write "<tr><td bgcolor='#cccccc'>共有网站: <strong>"&num&"</strong>"
if page>1 then
Response.Write " <a href=templinklist.asp?id="&id&"&page=1>首页</a> "
else
Response.Write " <font color=888888>首页</font> "
end if
if page>1 then
Response.Write " <a href=templinklist.asp?id="&id&"&page="&page-1&">前页</a> "
else
Response.Write " <font color=888888>前页</font> "
end if
if page<maxpage then
Response.Write " <a href=templinklist.asp?id="&id&"&page="&page+1&">后页</a> "
else
Response.Write " <font color=888888>后页</font> "
end if
if page<maxpage then
Response.Write " <a href=templinklist.asp?id="&id&"&page="&maxpage&">尾页</a> "
else
Response.Write " <font color=888888>尾页</font> "
end if
response.write " <strong>"&page&"</strong>/<strong>"&maxpage&"</strong> 每页<strong>"&pagen&"</strong>条记录 <a href=joinall.asp>全部加入</a> <a href=joinall.asp?flag=1>全部加入并删除</a> <a href=dellall.asp?flag=1>全部删除</a>"
response.write "</td></tr></table>"
Response.Write "<table width='100%' cellpadding='0' cellspacing='1'>"
Response.Write "<tr><td bgcolor='#cccccc' width=50>ID</td>"
Response.Write "<td bgcolor='#cccccc'>网站名称</td>"
Response.Write "<td bgcolor='#cccccc'>网站地址</td>"
Response.Write "<td bgcolor='#cccccc' width=70>时间</td>"
Response.Write "<td bgcolor='#cccccc' width=30>分类</td>"
Response.Write "<td bgcolor='#cccccc' width=30>加入</td>"
Response.Write "<td bgcolor='#cccccc' width=40>加&删</td>"
Response.Write "<td bgcolor='#cccccc' width=30>修改</td>"
Response.Write "<td bgcolor='#cccccc' width=30>删除</td></tr>"
n=0
Do While Not Rs.eof and n<pagen
n=n+1
Response.Write "<tr>"
Response.Write "<td><input TYPE='checkbox' VALUE='"&rs("id")&"' NAME='selAnnounce'>"&rs("id")&"</td>"
Response.Write "<td><font title='"&server.htmlencode(trim(rs("sitename")))&"'>"&left(server.htmlencode(trim(rs("sitename"))),10)&"</td>"
Response.Write "<td><font title='"&server.htmlencode(trim(rs("url")))&"'>"&left(server.htmlencode(trim(rs("url"))),10)&"</td>"
Response.Write "<td>"&rs("ndatetime")&"</td>"
Response.Write "<td><a href=../join/chooseassort.asp?fid="&rs("fenleiid")&">分类</a></td>"
Response.Write "<td><a href=join.asp?id="&rs("id")&">加入</a></td>"
Response.Write "<td><a href=join.asp?id="&rs("id")&"&flag=1>加&删</a></td>"
Response.Write "<td><a href=editjoin.asp?id="&id&"&editid="&rs("id")&">修改</a></td>"
Response.Write "<td><a href='javascript:singleDelete("&rs("id")&")'>删除</a></td>"
Response.Write "</tr>"
Rs.MoveNext
Loop
Rs.close
set Rs=nothing
conn.close
set conn=nothing
response.write "</table>"
if flag=1 then%>
<!--
<hr>
<p><input class="buttonface" TYPE="button" VALUE=" 删 除 " NAME="cmdDel" language="javascript" onclick="submitIt(0,document.frmManage)">
<input class="buttonface" TYPE="button" VALUE=" 加入精华区 " NAME="cmdAdd2Essence" language="javascript" onclick="submitIt(1,document.frmManage)"></p>
-->
<hr>
</form>
<%
end if
%>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -