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

📄 linkmanage.asp

📁 社区天地图文系统(核心:尘缘雅境图文系统) 版本: 1.0 本系统是ASP+ACCESS环境下开发成功
💻 ASP
字号:
<!--#include file=conn.asp --><!--#include file="char.inc"--><!--#include file="chkuser.asp" --><!--#include file=../include/config.asp -->
<%
IF not(request.cookies("KEY")="super") THEN
response.redirect "index_face.asp"
response.end
else
usernamecookie=CheckStr(request.cookies("UserName"))
passwdcookie=replace(trim(Request.cookies("passwd")),"'","''")
KEYcookie=replace(trim(request.cookies("KEY")),"'","''")
if usernamecookie="" or passwdcookie="" then
response.redirect "login.asp"
response.end
else
'判断用户的合法性
  set rs=server.createobject("adodb.recordset")
  sql="select * from admin where username='"&usernamecookie&"'"
  rs.open sql,conn,1,1
  if rs.eof and rs.bof then
             response.redirect "login.asp"
            response.end
         end if
  IF passwdcookie<>rs("passwd") THEN
          response.redirect "login.asp"
           response.end
      END IF
   '下面判断用户级别实际在有用户级别是都应该判断
   if KEYcookie<>rs("OSKEY") then
      response.redirect "index_face.asp"
      response.end
    end if
           rs.close
           set rs=nothing
END IF
END IF
if votemana="1" or request.cookies("purview")="99999" then

PageShowSize = 10            '每页显示多少个页
MyPageSize   = 10           '每页显示多少条文章
	
If Not IsNumeric(Request("page")) Or IsEmpty(Request("page")) Or Request("page") <=0 Then
MyPage=1
Else
MyPage=Int(Abs(Request("page")))
End if

set rs=server.CreateObject("ADODB.RecordSet")
if linkpass="1" then
rs.Source="select * from link order by ID desc"
else
rs.Source="select * from link where pass=0 order by ID desc"
end if
rs.Open rs.Source,conn,1,1

If Not rs.eof then
rs.PageSize     = MyPageSize
MaxPages         = rs.PageCount
rs.absolutepage = MyPage
total            = rs.RecordCount

%>

<html>

<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href=site.css rel=stylesheet>
<title><%=copyright%><%=version%>&nbsp;<%=ver%> - 友情链接管理</title>
</head>

<body topmargin="0"><!--#include file=top.asp-->
<br>
<table border="1" width="750" cellspacing="0" cellpadding="0" style="border-collapse: collapse" bordercolor="<%=border%>" align=center>
<tr>
    <td width="100%" bgcolor="<%=m_top%>" height="24" align="center"><b>友情链接管理</b></td>
</tr>

<tr>
    <td colspan=2 bgcolor="<%=m_top%>" align=center height=25>共 <%=total%> 条,当前第 <%=Mypage%>/<%=Maxpages%> 
            页,每页 <%=MyPageSize%> 条       <a href="linkreg.asp">添加链接</a></td>
</tr>
<tr>
<td colspan=2 bgcolor="<%=m_top%>" align=center height=25>
<table width="100%" border="0" cellspacing="1" cellpadding="0" height="25">
<tr align="center" bgcolor="<%=m_top%>">
<td width="6%">ID号</td>
<td width="6%">类型</td>
<td width="20%">网站名称</td>
<td width="20%">网站LOGO</td>
<td width="14%">站长</td>
<td width="12%">执行</td>
<td width="6%">编辑</td>
<td width="6%">删除</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="100%" bgcolor="#abb8d6">
<table border="0" cellspacing="1" width="100%" cellpadding="0">
<%
for i=1 to rs.PageSize
if not rs.EOF then
%>
<form method="POST" action="<%if rs("pass")="0" then%>linkpass.asp<%else%>linkunpass.asp<%end if%>?id=<%=rs("ID")%>">
<tr bgcolor=ffffff>
<td width=6% align=center ><%=rs("ID")%></td>
<td width=6% align=center ><%if rs("linktype")="1" then%>LOGO<%else%>文字<%end if%></td>
<td width=20% align=center ><a href="<%=rs("weburl")%>" title="<%=rs("content")%>" target="_blank"><%=rs("webname")%></a></td>
<td width=20% align=center ><%if rs("linktype")="1" then%><a target="_blank" title="点击查看原图" href="<%=rs("logo")%>"><img src="<%=rs("logo")%>" border=0 width=150 height=20></a><%else%>文字链接需要图吗<%end if%></td>
<td width=14% align=center ><a href="mailto:<%=rs("email")%>"><%=rs("webmaster")%></a></td>
<td width=12% align=center ><input type=hidden name=ID value="<%=rs("ID")%>">
<input type=submit value="<%if rs("pass")="0" then%>通过<%else%>取消<%end if%>审核" class=button onMouseOver="window.status='按这个按钮<%if rs("pass")="0" then%>通过<%else%>取消<%end if%>审核该网站';return true;" onMouseOut="window.status='';return true;"target=_blank title="按这个按钮<%if rs("pass")="0" then%>通过<%else%>取消<%end if%>审核该网站"></td>
<td width="6%" align="center"><input type=button class=button value="编辑" onclick="javascript:window.open('linkedit.asp?id=<%=rs("ID")%>','_self','')"></td>
<td width=6% align=center><input type=button class=button value="删除" onclick="javascript:window.open('linkdel.asp?id=<%=rs("ID")%>','_self','')"></td>	
</form>
<%

rs.MoveNext
end if
next
%>

</table>
</td>
<tr>
    <td colspan=2 bgcolor="<%=m_top%>" align=center height=25>共 <%=total%> 条,当前第 <%=Mypage%>/<%=Maxpages%> 
            页,每页 <%=MyPageSize%> 条 
            <%
if request.cookies("KEY")="super" then			
url="linkmanage.asp?" 
else
url="linkmanage.asp?"
end if									
PageNextSize=int((MyPage-1)/PageShowSize)+1
Pagetpage=int((total-1)/rs.PageSize)+1

if PageNextSize >1 then
PagePrev=PageShowSize*(PageNextSize-1)
Response.write "<a class=black href='" & Url & "page=" & PagePrev & "' title='上" & PageShowSize & "页'>上一翻页</a> "
Response.write "<a class=black href='" & Url & "page=1' title='第1页'>页首</a> "
end if
if MyPage-1 > 0 then
Prev_Page = MyPage - 1
Response.write "<a class=black href='" & Url & "page=" & Prev_Page & "' title='第" & Prev_Page & "页'>上一页</a> "
end if

if Maxpages>=PageNextSize*PageShowSize then
PageSizeShow = PageShowSize
Else
PageSizeShow = Maxpages-PageShowSize*(PageNextSize-1)
End if
If PageSizeShow < 1 Then PageSizeShow = 1
for PageCounterSize=1 to PageSizeShow
PageLink = (PageCounterSize+PageNextSize*PageShowSize)-PageShowSize
if PageLink <> MyPage Then
Response.write "<a class=black href='" & Url & "page=" & PageLink & "'>[" & PageLink & "]</a> "
else
Response.Write "<B>["& PageLink &"]</B> "
end if
If PageLink = MaxPages Then Exit for
Next

if Mypage+1 <=Pagetpage  then
Next_Page = MyPage + 1
Response.write "<a class=black href='" & Url & "page=" & Next_Page & "' title='第" & Next_Page & "页'>下一页</A>"
end if

if MaxPages > PageShowSize*PageNextSize then
PageNext = PageShowSize * PageNextSize + 1
Response.write " <A class=black href='" & Url & "page=" & Pagetpage & "' title='第"& Pagetpage &"页'>页尾</A>"
Response.write " <a class=black href='" & Url & "page=" & PageNext & "' title='下" & PageShowSize & "页'>下一翻页</a>"
End if
%>
</td>
  </tr>
</table>
<br>
<%
else
%><meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href=site.css rel=stylesheet>
<title><%=copyright%><%=version%>&nbsp;<%=ver%> - 友情链接管理</title>
<body topmargin="0"><!--#include file=top.asp--><br>
<table border="1" width="750" cellspacing="0" cellpadding="0" style="border-collapse: collapse" bordercolor="<%=border%>" align=center>
  <tr> 
    <td colspan=2 align="center" bgcolor="ffffff"> 
      <p>&nbsp;</p>
      <p>没有要申请链接的网站</p><a href="linkreg.asp">添加链接</a>
      <p>&nbsp;</p>
    </td>
  </tr>
</table>
<%				
End If
%>
</body>
</html>
<%
rs.close
set rs=nothing
conn.close
set conn=nothing

%>
<%else
response.redirect "index_face.asp"
response.end
end if
%>

⌨️ 快捷键说明

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