📄 list.asp
字号:
<!--#include file="../../Include/check.asp"-->
<!--#include file="Conn.asp"-->
<!--#include file="../../Include/check.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>广告发布系统_中国站长俱乐部Club.Cn0797.Cn</title>
<SCRIPT LANGUAGE="JavaScript">
function delad(){
if (confirm("确定要删除这则广告么?删除后不可以再恢复哦!?")){return true;}
return false;
}
</SCRIPT>
<link href="COAD.css" rel="stylesheet" type="text/css">
</head>
<body>
<map name="Map">
<area shape="rect" coords="10,4,62,19" href="add.asp" onFocus="if(this.blur)this.blur()">
<area shape="rect" coords="83,4,135,19" href="list.asp" onFocus="if(this.blur)this.blur()">
<area shape="rect" coords="155,3,206,20" href="list.asp?action=stop" onFocus="if(this.blur)this.blur()">
<area shape="rect" coords="227,3,279,19" href="code.asp" onFocus="if(this.blur)this.blur()">
<area shape="rect" coords="300,3,349,19" href="config.asp" onFocus="if(this.blur)this.blur()">
<area shape="rect" coords="371,3,398,19" href="index.asp" onFocus="if(this.blur)this.blur()">
</map>
<%
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="760" 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>
<%Else%><br>
<table width="760" 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>
<%
End If
Response.End
End If
rs.pagesize = pagesize
rs.absolutepage = curpage
%>
<br>
<table width='760' height="22" border=0 align=center cellpadding=0 cellspacing=0 bgcolor="#ff9900">
<tr>
<td width="60" height="22" align="center"><a href="?page=<%=cstr(curpage)%>&pagesize=<%=pagesize%>">[刷新]</a></td>
<td width="700" height="22" align=right style="color:#FFFFFF;">
<%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='760' 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="#e6e6e6">
<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="#ffffff">
<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="#ffffff">
<td height="25" colspan=2>链接地址：<a href=<%=ADLink%> target=_blank><font color="#000000"><%=ADLink%></a></td>
<td colspan=2>提示文字：<%=ADAlt%></td>
</tr>
<tr bgcolor="#ffffff">
<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="#e6e6e6">
<td height="25" colspan=6> <center> 第<%=cstr(curpage)%>页 总<%=cstr(rs.pagecount)%>页 本页<%=cstr(i-1)%>条 总<%=cstr(rs.recordcount)%>条 </td>
</tr>
</table>
<br>
<p></p>
</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 + -