📄 list.asp
字号:
<!--#Include File="conn.asp"-->
<!--#Include File="session.asp" -->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>Manage System V3.0</title>
<%if session("userkey")<>4 then%>
<script language=javascript>
alert( "错误：您无权进行版面管理！" );
location.href = "javascript:history.back()"
</script>
<%end if%>
<SCRIPT LANGUAGE="JavaScript">
function delad(){
if (confirm("确定要删除这则广告么?删除后不可以再恢复哦!?")){return true;}
return false;
}
</SCRIPT>
<link href="COAD.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="97%" border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#999999">
<tr>
<td height="25" bgcolor="#7C7CB5" ><div align="right"><A href="Admin_Exit.asp"><FONT color=#ffffff>退出网站</FONT></A> <A onclick="checkclick('您是否要打开本站首页？')" href="../index.asp" target=_blank><FONT color=#ffffff>网站首页</FONT></A></div></td>
</tr>
</table>
<table width="97%" bgcolor=#999999 cellspacing="1" cellpadding="5" align=center>
<tr bgcolor=#eeeeee>
<td colspan=2 align=right bgcolor="#eeeeee"><div align="center">┊ <a href="add.asp">添加广告</a> ┊ <a href="list.asp">广告列表</a> ┊ <a href="list.asp?action=stop">过期广告</a> ┊<a href="code.asp"> 广告代码</a> ┊ <a href="config.asp">广告设置</a> ┊</div></td>
</tr>
</table>
<%
Dim pagesize,rs,sql,curpage,strcate,i
Dim id,ADID,ADViews,ADHits,ADType,ADSrc,ADLink,ADAlt,ADWidth,ADHeight,ADNote,ADStopViews,ADStopHits,ADStopDate
pagesize=10 '设置每页显示广告树目
If Request.QueryString("page")="" Then
curpage = 1
Else
curpage = cint(Request.QueryString("page"))
End If
Set rs = Server.CreateObject("ADODB.Recordset")
if Request.QueryString("action")="stop" then
sql = "SELECT * FROM [ad] where ( ADStopViews <> 0 and ADViews > ADStopViews) or ( ADStopHits <> 0 and ADHits > ADStopHits) or ( DateDiff('d',Now(),ADStopDate)<1 ) ORDER BY id DESC"
Else
sql = "SELECT * FROM [ad] ORDER BY id DESC"
end If
rs.open sql, conn, 1, 1
'监测是否存在错误
If err.number <> 0 Then
Response.Write "打开数据库出错,请检查conn.asp中数据库地址是否正确"
Response.End
End If
If rs.bof or rs.eof Then
rs.Close
if Request.QueryString("action")="stop" Then
%><br>
<table width="97%" height="200" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="DDDDDD">
<tr>
<td align="center" bgcolor="f1f1f1"><font color="#990000">暂时没有过期广告！</font></td>
</tr>
</table>
<br>
<table width="97%" height="30" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="DDDDDD">
<tr>
<td align="center" bgcolor="f1f1f1"><div align="center"><!--#Include file="end.asp" -->
</div></td>
</tr>
</table>
<%Else%><br>
<table width="97%" height="200" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="DDDDDD">
<tr>
<td align="center" bgcolor="f1f1f1">暂时没有任何广告！-- <a href=add.asp>立即添加新广告</a></td>
</tr>
</table>
<br>
<table width="97%" height="30" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="DDDDDD">
<tr>
<td align="center" bgcolor="f1f1f1"><div align="center"><!--#Include file="end.asp" -->
</div> </td>
</tr>
</table>
<%
End If
Response.End
End If
rs.pagesize = pagesize
rs.absolutepage = curpage
%>
<br>
<table width='97%' height="22" border=0 align=center cellpadding=0 cellspacing=0 bgcolor="#999999">
<tr>
<td width="60" height="22" align="center"><a href="?page=<%=cstr(curpage)%>&pagesize=<%=pagesize%>">[刷新]</a></td>
<td width="700" height="22" align=right>
<%If curpage = 1 Then%>
[首页] [上一页]
<%Else%>
[<a href='?page=1'>首页</a>] [<a href='?page=<%=cstr(curpage-1)%>'>上一页</a>]
<%End If
If curpage = rs.pagecount Then%>
[下一页] [尾页]
<%Else%>
[<a href='?page=<%=cstr(curpage+1)%>'>下一页</a>] [<a href='?page=<%=cstr(rs.pagecount)%>'>尾页</a>]
<%End If%> </td>
</tr>
</table>
<table width='97%' border="0" align=center cellpadding=3 cellspacing=1 bgcolor="#999999">
<% Do While NOT rs.eof
id=rs("id")
ADID=rs("ADID")
ADViews=rs("ADViews")
ADHits=rs("ADHits")
ADType=rs("ADType")
ADSrc=rs("ADSrc")
ADLink=rs("ADLink")
ADAlt=rs("ADAlt")
ADSrc=rs("ADSrc")
ADWidth=rs("ADWidth")
ADHeight=rs("ADHeight")
ADNote=rs("ADNote")
ADStopViews=rs("ADStopViews")
ADStopHits=rs("ADStopHits")
ADStopDate=rs("ADStopDate")%>
<tr bgcolor="#c0c0c0">
<td width="25%" height="25">名称：<%=ADID%> <%if IsStop(ADViews,ADStopViews,ADStopHits,ADHits,ADStopDate) Then Response.Write(" <font color=yellow>(已过期)") End If%></td>
<td width="25%">显示：<%=ADViews%></td>
<td width="25%">点击：<%=ADHits%></td>
<td width="25%">管理：<a href="edit.asp?id=<%=id%>">编辑</a> <a href="createjs.asp?id=<%=ADID%>">生成JS</a> <a href="del.asp?id=<%=id%>" onclick='return delad();'>删除</a></td>
</tr>
<tr bgcolor="e6e6e6">
<td width="50%" height="25" colspan=2>广告类型：<%=ShowAdType(ADType,rs("ADSrc"))%></td>
<td colspan=2 width="50%">显示地址：
<%If ADType<>6 Then%><a href=<%=ADSrc%> target=_blank><font color="#000000"><%=ADSrc%></a><%else%>不显示<%end if%></td>
</tr>
<tr bgcolor="e6e6e6">
<td height="25" colspan=2>链接地址：<a href=<%=ADLink%> target=_blank><font color="#000000"><%=ADLink%></a></td>
<td colspan=2>提示文字：<%=ADAlt%></td>
</tr>
<tr bgcolor="e6e6e6">
<td height="25" colspan=2>广告规格：<%=ADWidth%>×<%=ADHeight%></td>
<td colspan=2>备 注：<%=ADNote%></td>
</tr>
<%
i=i+1
rs.movenext
If i>=rs.PageSize Then Exit Do
Loop
%>
<tr align="center" bgcolor="c0c0c0">
<td height="25" colspan=6> <center> 第<%=cstr(curpage)%>页 总<%=cstr(rs.pagecount)%>页 本页<%=cstr(i-1)%>条 总<%=cstr(rs.recordcount)%>条 </td>
</tr>
</table>
<br>
<table width="97%" height="30" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="DDDDDD">
<tr>
<td align="center" bgcolor="f1f1f1"><div align="center"><!--#Include file="end.asp" -->
</div> </td>
</tr>
</table>
</body>
</html>
<%
rs.close
set rs=nothing
conn.Close
set conn=nothing
'检测是否过期
function IsStop(ADViews,ADStopViews,ADStopHits,ADHits,ADStopDate)
IsStop=false
If ( ADStopViews <> 0 and ADViews > ADStopViews) Then
IsStop=true
Exit function
ElseIf ( ADStopHits <> 0 and ADHits > ADStopHits) Then
IsStop=true
Exit function
ElseIf ( DateDiff("d",Now(),ADStopDate)<1 ) Then
IsStop=true
Exit function
End If
end function
'判断广告类型
function ShowAdType(ADType,ADSrc)
Dim ADExt
ADExt="图片"
If InStr(1,ADSrc,".swf",1)>0 Then ADExt="FLASH"
Select Case ADType
Case 1
ShowAdType="普通"&ADExt
Case 2
ShowAdType="全屏浮动"&ADExt
Case 3
ShowAdType="上下浮动 - 右"&ADExt
Case 4
ShowAdType="上下浮动 - 左"&ADExt
Case 5
ShowAdType="渐隐消失"&ADExt
Case 6
ShowAdType="网页对话框"
Case 7
ShowAdType="移动透明对话框"
Case 8
ShowAdType="打开新窗口"
Case 9
ShowAdType="弹出新窗口"
Case 10
ShowAdType="对联式广告"
Case else
ShowAdType="<font color=red><b>错误!将不能正确显示</b>"
End Select
end function
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -