%
IF Session("KEY")>"2" THEN
response.write ""
response.end
END IF
%>
*
生成文章列表
<%
dim title
dim content
dim sql
dim rs
dim articleid
dim classid,Nclassid,typeid
dim from
dim sqln
dim rsn
dim typename1
sqlconfig="select * from config"
set rsconfig=server.createobject("adodb.recordset")
rsconfig.open sqlconfig,conn,1,1
sqln="SELECT * FROM article inner join type on article.typeid = type.typeid"
set rsn=server.createobject("adodb.recordset")
rsn.open sqln,conn,1,1
if not rsn.eof then
while not rsn.EOF
title=rsn("title")
content=rsn("content")
articleid=rsn("newsid")
from=rsn("Nfrom")
author=rsn("author")
picurl=rsn("picurl")
picchk=rsn("picchk")
tjnews=rsn("tjnews")
selectpic=rsn("selectpic")
check=rsn("check")
modeid=rsn("modeid")
filepath=rsn("typedir")
filen=rsn("N_Fname")
cmsdate=rsn("date")
typeid=rsn("typeid")
thistype=""
thistype=thistype&" 当前位置 : 首 页 >> "&rsn("typename")&""
thistype=thistype&" >> 正文阅读"
''########获取站内搜索和文章页面底部版权信息
sqlconfig="select * from config"
set rsconfig=server.createobject("adodb.recordset")
rsconfig.open sqlconfig,conn,1,1
sousuo=""
sousuo=sousuo&""
bottomnavi=""
footer=""
footer=footer&"
"
''########读取相关评论
sqlreply="select * from reply where newsid="&articleid&" order by rdate desc"
Set rsreply= Server.CreateObject("ADODB.Recordset")
rsreply.open sqlreply,conn,1,1
rcontent=""
if not rsreply.eof then
while not rsreply.EOF
rcontent=rcontent&"
<%
set rsconfig=nothing
rsconfig.close
set rs=nothing
rstypeid.close
set rstypeid=nothing
rsn.close
set rsn=nothing
set rsreply=nothing
conn.close
set conn=nothing
%>