<% '连接数据库: BBSDIR="chencao" Db = "../database/chencao.mdb" Set Conn=Server.CreateObject("ADODB.Connection") Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath(Db) SqlNowString="Now()" %>
●调用新发帖: <br> <% Sql="Select top 5 * From [CHC_Threads] Where IsDel=0 Order By ID Desc" TopicList %> <br>
●调用新回帖: <br> <% Sql="Select top 5 * From [CHC_Threads] Where IsDel=0 and Replies>0 Order By LastTime Desc" TopicList %> <br>
●调用热门帖: <br> <% Sql="Select top 5 * From [CHC_Threads] Where IsDel=0 and PostTime>"&SqlNowString&"-7 Order by Replies Desc,ID" TopicList %> <br>
●调用精华帖: <br> <% Sql="Select top 5 * From [CHC_Threads] Where IsDel=0 and IsGood>0 Order by LastTime Desc" TopicList %> <br>
●调用某个版块中的某个专题下的新帖: <br> <% Sql="Select top 5 * From [CHC_Threads] Where IsDel=0 and ForumID=12 and SpecialTopic='代码分析' Order by LastTime Desc" TopicList
<% '调帖显示子程序: Sub TopicList Set Rs=Conn.ExeCute(Sql) Do While Not Rs.Eof Response.Write "<a href="&BBSDIR&"/ShowPost.asp?ThreadID="&Rs("ID")&">★ "&Left(ReplaceText(Rs("Topic"),"<[^>]*>",""),15)&"</a><br>" Rs.MoveNext Loop Rs.Close End Sub %> <br>
●调用专题: <br> <% Sql="Select * From [CHC_Forums] Where TolSpecialTopic>''" Set Rs=Conn.ExeCute(Sql) Do While Not Rs.Eof ForumID=Rs("ID") Response.Write "<a href="&BBSDIR&"/ShowForum.asp?ForumID="&ForumID&">★"&Rs("ForumName")&"</a><br>" filtrate=split(Rs("TolSpecialTopic"),"|") for i = 0 to ubound(filtrate) Response.Write "[<a href="&BBSDIR&"/ShowForum.asp?ForumID="&ForumID&"&SpecialTopic="&filtrate(i)&">"&filtrate(i)&"</a>]<br>" next Rs.MoveNext Loop Rs.Close %> <br>
●调用新日志(博客):(适用于7.0) <br> <% Sql="Select top 5 * From [CHC_Blogs] Order By ID Desc" Set Rs=Conn.ExeCute(Sql) Do While Not Rs.Eof Response.Write "<a href="&BBSDIR&"/Blog.asp?BlogUserName="&Rs("UserName")&"&menu=ShowBlog&BlogID="&Rs("ID")&">★ "&Left(Rs("Subject"),15)&"</a><br>" Rs.MoveNext Loop Rs.Close %> <br>
●调用论坛公告: <br> <% Sql="Select top 5 * From [CHC_Affiche] Order By ID Desc" Set Rs=Conn.ExeCute(Sql) Do While Not Rs.Eof Response.write "<a href="&BBSDIR&"/Affiche.asp?ID="&Rs("ID")&">★ "&Left(Rs("title"),15)&"</a><br>" Rs.MoveNext Loop Rs.Close %> <br>
'自定义过滤函数 Function ReplaceText(fString,patrn,replStr) Set regEx = New RegExp regEx.Pattern = patrn regEx.IgnoreCase = True regEx.Global = True ReplaceText = regEx.Replace(""&fString&"",""&replStr&"") Set reg=nothing End Function