hot.asp

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

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