new.asp

完美政府版,正版网站解决方案

<!--#include file="conn.asp"-->
<!--#include file="inc/fun.asp"-->
<%
dim bbsurl,topicnum,tsql,topnew,i,topicinfo
bbsurl="http://127.0.0.1/bbs"		'论坛地址绝对路径，末尾不能加上 /	
topicnum=5			'显示最新帖数目
%>
document.write("<style type='text/css'><!--.css {  font-size: 9pt}--></style><table class=css border='0' cellpadding='0' cellspacing='0' style='border-collapse: collapse' width='100%'>");
document.write("<%
tsql="select top "&topicnum&" id,userid,topicinfo,bd,edittime,totable from topic where type<>3 and bd not in(select id from bdinfo where type=3 or type=4) order by id desc"
set topnew=conn.execute(tsql)
i=0
do while not topnew.eof
topicinfo=topnew("topicinfo")
topicinfo=split(topicinfo,"|")
i=i+1
response.write"<tr height='24'><td align=center width=40><img src="&bbsurl&"/images/face/"&topicinfo(0)&".gif align='absmiddle'></td>"
response.write"<td width=*>&nbsp;<a href="&bbsurl&"/showbbs.asp?bd="&topnew("bd")&"&id="&topnew("id")&"&totable="&topnew("totable")&">"&lefttrue(RemoveHTML(topicinfo(1)),30)&"</a></td>"
response.write"<td width=110>&nbsp;<a href="&bbsurl&"/userinfo.asp?userid="&topnew("userid")&">"&topicinfo(2)&"</a></td></tr>"

topnew.movenext
if i=topicnum then exit do
loop
topnew.close
set topnew=nothing
%>");
document.write("</table>");