📄 matrix3_uploadfiles.asp
字号:
<td width="70" height="18" align="center" nowrap background="images/bg4.gif" bgcolor="#ECE9D9"><a href="matrix3_uploadfiles.asp?keyword=<%=keyword%>&type=<%=type1%>&px=3&page=<%=page%>">↑</a>类型<a href="matrix3_uploadfiles.asp?keyword=<%=keyword%>&type=<%=type1%>&px=4&page=<%=page%>">↓</a></td>
<td width="75" height="18" align="center" nowrap background="images/bg4.gif" bgcolor="#ECE9D9"><a href="matrix3_uploadfiles.asp?keyword=<%=keyword%>&type=<%=type1%>&px=5&page=<%=page%>">↑</a>大小<a href="matrix3_uploadfiles.asp?keyword=<%=keyword%>&type=<%=type1%>&px=6&page=<%=page%>">↓</a></td>
<td width="86" height="18" align="center" nowrap background="images/bg4.gif" bgcolor="#ECE9D9"><a href="matrix3_uploadfiles.asp?keyword=<%=keyword%>&type=<%=type1%>&px=7&page=<%=page%>">↑</a>作者<a href="matrix3_uploadfiles.asp?keyword=<%=keyword%>&type=<%=type1%>&px=8&page=<%=page%>">↓</a></td>
<td width="56" height="18" align="center" nowrap background="images/bg4.gif" bgcolor="#ECE9D9">帖子</td>
<td width="63" height="18" align="center" nowrap background="images/bg4.gif" bgcolor="#ECE9D9"><a href="matrix3_uploadfiles.asp?keyword=<%=keyword%>&type=<%=type1%>&px=9&page=<%=page%>">↑</a>下载<a href="matrix3_uploadfiles.asp?keyword=<%=keyword%>&type=<%=type1%>&px=10&page=<%=page%>">↓</a></td>
<td width="120" height="18" align="center" nowrap background="images/bg4.gif" bgcolor="#ECE9D9"><a href="matrix3_uploadfiles.asp?keyword=<%=keyword%>&type=<%=type1%>&px=11&page=<%=page%>">↑</a>上传时间<a href="matrix3_uploadfiles.asp?keyword=<%=keyword%>&type=<%=type1%>&px=12&page=<%=page%>">↓</a></td>
<td width="50" height="18" align="center" nowrap background="images/bg4.gif" bgcolor="#ECE9D9">管理</td>
</tr>
<%
totalsize=0
dim filename,filesize,filepath,filetype,username,downloadtimes,uploadtime,bbsid
set rs=server.CreateObject("ADODB.RecordSet")
rs.open sql,conn,1,1
if not (rs.bof and rs.eof) then
rs.pagesize=psize
rs.cachesize=rs.pagesize
totalpages=rs.pagecount
if page>rs.pagecount then page=rs.pagecount
rs.absolutepage=page
totalcount=int(rs.recordcount)
i=0
'do while (not rs.eof) and (i<psize)
if psize>totalcount then psize=totalcount
do while (not rs.eof) and (i<psize)
i=i+1
id=rs("FileID")
bbsid=rs("bbsid")
filepath=rs("filepath")
filename=rs("filename")
filesize=rs("filesize")
filetype=rs("filetype")
username=rs("username")
uploadtime=rs("uploadtime")
downloadtimes=rs("downloadtimes")
if isnumeric(filesize) then
totalsize=totalsize+clng(filesize)
end if
%>
<tr bgcolor="#FFFFFF" height="20">
<td height="24" align="center" nowrap><%=psize*(page-1)+i%></td>
<td height="24" align="center"><a href="<%=filepath%>" target="_blank" <%if filetype="jpg" or filetype="gif" or filetype="jpeg" then response.write("title=""<img src='"&filepath&"' border=0>""")%>><%=filename%></a></td>
<td height="24" align="center" nowrap><%=filetype%></td>
<td height="24" align="center" nowrap><%=FormatNumber(filesize,0)%> 字节</td>
<td height="24" align="center" nowrap bgcolor="#F1F3D6">
<a href='profile.asp?name=<%=username%>' target="_blank"><%=username%></a></td>
<td height="24" align="center" nowrap bgcolor="#FFFFFF">
<%if bbsid=0 then
response.write("-----")
else
response.write("<a href=""treelist.asp?id="&bbsid&""" target=_blank>相关帖子</a>")
end if%></td>
<td height="24" align="center" nowrap bgcolor="#FFFFFF"><%=downloadtimes%></td>
<td height="24" align="center" nowrap bgcolor="#FFFFFF"><%=uploadtime%></td>
<td align="center" nowrap bgcolor="#FFFFFF"> <a href="javascript:alertwin('matrix3_file_del.asp?id=<%=id%>&keyword=<%=keyword%>&type=<%=type1%>&px=<%=px%>&page=<%=page%>')">删除</a></td>
</tr>
<%
rs.movenext
loop
else
response.Write("<tr><td colspan=9 bgcolor=#FFFFFF height=30> 没有文件 ... </td></tr>")
end if
rs.close
set rs=nothing
call closedb()
%>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="2" bgcolor="#ECE9D9"></td>
</tr>
</table></td>
</tr>
</table>
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><img src="images/blank.gif" width="1" height="2"></td>
</tr>
</table>
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> <table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr bgcolor="#FFFFFF">
<td valign="top" class="v7"><table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#F1F0E4">
<form name="pageform" method="post" action="matrix3_uploadfiles.asp">
<tr>
<td width="74%"><span class="v7"> 总文件数： <%=totalcount%>
，总页数： <%=totalpages%>
|
<%if page>1 then
response.write("<a href='matrix3_uploadfiles.asp?keyword="&keyword&"&type="&type1&"&px="&px&"'>首页</a>")
else
response.write("首页")
end if
%>
|
<%if page>1 then
response.write("<a href='matrix3_uploadfiles.asp?keyword="&keyword&"&type="&type1&"&px="&px&"&page="&page-1&"'>前一页</a>")
else
response.write("前一页")
end if
%>
|
<%if page<totalpages then
response.write("<a href='matrix3_uploadfiles.asp?keyword="&keyword&"&type="&type1&"&px="&px&"&page="&page+1&"'>下一页</a>")
else
response.write("下一页")
end if
%>
|
<%if page<totalpages then
response.write("<a href='matrix3_uploadfiles.asp?keyword="&keyword&"&type="&type1&"&px="&px&"&page="&totalpages&"'>末页</a>")
else
response.write("末页")
end if
%>
|
<%if totalpages>3 then%>
跳到：第
<select name="page" class="input1" id="page" onChange="this.form.submit()">
<%for i=1 to totalpages
response.write "<option value="&i&""
if i=page then response.write" selected"
response.write">"&i&"</option>"&chr(13)
next
%>
</select>
页
<%end if%>
</span></td>
<td width="26%"> 本页文件总大小：<%=FormatNumber(totalsize,0)%> 字节</td>
</tr>
</form>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="2" bgcolor="#ECE9D9"></td>
</tr>
</table></td>
</tr>
</table></td>
<td width="10"> </td>
<td width="1" bgcolor="#E8BC3C"></td>
<td width="100" bgcolor="#ECE9D9" valign="top"> <!-- #include file="matrix3_right.asp" --></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="10" align="center" valign="bottom">
<!-- #include file="bottombar.asp" -->
</td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -