3.1中修改幻燈新聞和圖片新聞可以調(diào)用子欄目的方法_風(fēng)訊Cms教程
幻燈新聞修改方法,在RefreshFunction.asp文件中找到:
if ClassListStr <> "" then
FilterSql = "Select Top " & NewsNumberStr & " *,FS_NewsClass.FileExtName as ClassFileExtName,FS_News.FileExtName as NewsFileExtName from FS_News,FS_NewsClass where FS_News.Classid=FS_NewsClass.Classid and FS_News.DelTF=0 and FS_News.FilterNews=1 and FS_News.AuditTF=1 and FS_NewsClass.ClassEName='" & ClassListStr & "' order by FS_News.ID Desc"
else
FilterSql = "Select Top " & NewsNumberStr & " *,FS_NewsClass.FileExtName as ClassFileExtName,FS_News.FileExtName as NewsFileExtName from FS_News,FS_NewsClass where FS_News.Classid=FS_NewsClass.Classid and FS_News.DelTF=0 and FS_News.FilterNews=1 and FS_News.AuditTF=1 order by FS_News.ID Desc"
end if
Set RsFilterObj = Conn.Execute(FilterSql)
修改為:
dim TemppID,TemppSql,EndClassIDList
if ClassListStr <> "" then
TemppSql="select ClassID from FS_NewsClass where ClassEName='" & ClassListStr & "'"
Set TemppID=conn.execute(TemppSql)
EndClassIDList= "'" & TemppID(0) & "'" & AllChildClassIDStrList(TemppID(0))
FilterSql = "Select Top " & NewsNumberStr & " *,FS_NewsClass.FileExtName as ClassFileExtName,FS_News.FileExtName as NewsFileExtName from FS_News,FS_NewsClass where FS_News.Classid=FS_NewsClass.Classid and FS_News.DelTF=0 and FS_News.FilterNews=1 and FS_News.AuditTF=1 and FS_NewsClass.ClassID in (" & EndClassIDList & ") order by FS_News.ID Desc"
else
FilterSql = "Select Top " & NewsNumberStr & " *,FS_NewsClass.FileExtName as ClassFileExtName,FS_News.FileExtName as NewsFileExtName from FS_News,FS_NewsClass where FS_News.Classid=FS_NewsClass.Classid and FS_News.DelTF=0 and FS_News.FilterNews=1 and FS_News.AuditTF=1 order by FS_News.ID Desc"
end if
Set RsFilterObj = Conn.Execute(FilterSql)
圖片新聞修改方法:
在RefreshFunction.asp文件中找到:
if ClassListStr = "" then
if RefreshType = "Index" then
PicSql = "Select Top " & NewsNumberStr & " *,FS_NewsClass.FileExtName as ClassFileExtName,FS_News.FileExtName as NewsFileExtName from FS_News,FS_NewsClass Where FS_News.ClassID=FS_NewsClass.ClassID and FS_News.DelTF=0 and FS_News.PicNewsTF=1 and FS_News.AuditTF=1 order by FS_News.ID Desc"
elseif RefreshType = "Class" then
PicSql = "Select Top " & NewsNumberStr & " *,FS_NewsClass.FileExtName as ClassFileExtName,FS_News.FileExtName as NewsFileExtName from FS_News,FS_NewsClass Where FS_News.ClassID=FS_NewsClass.ClassID and FS_News.ClassID='" & RefreshID & "' and FS_News.DelTF=0 and FS_News.PicNewsTF=1 and FS_News.AuditTF=1 order by FS_News.ID Desc"
elseif RefreshType = "News" then
TempSql = "Select ClassID from FS_News where NewsID='" & RefreshID & "' order by ID desc"
Set RsTempObj = Conn.Execute(TempSql)
if Not RsTempobj.Eof then
PicSql = "Select Top " & NewsNumberStr & " *,FS_NewsClass.FileExtName as ClassFileExtName,FS_News.FileExtName as NewsFileExtName from FS_News,FS_NewsClass Where FS_News.ClassID=FS_NewsClass.ClassID and FS_News.ClassID='" & RsTempobj("ClassID") & "' and FS_News.DelTF=0 and FS_News.PicNewsTF=1 and FS_News.AuditTF=1 order by FS_News.ID Desc"
- 最簡(jiǎn)單的欄目切換方法(樣式系列之欄目切換篇2)
- 我也放個(gè)欄目切換代碼,簡(jiǎn)簡(jiǎn)單單的。
- 搜狐女性頻道幻燈效果(幻燈系列之flash特效篇)
- 有效控制新聞內(nèi)容的圖片的尺寸
- 現(xiàn)提供增加<目錄生成規(guī)則>的方法!
- 風(fēng)訊里面上下篇標(biāo)簽DIV模式下浮動(dòng)的解決方法!
- 風(fēng)訊目錄路徑自由選擇的實(shí)現(xiàn)方法
- 新聞列表讀取內(nèi)容時(shí)去掉html代碼
- 添加文字廣告的解決方案!
- 發(fā)些滾動(dòng)的代碼
- 標(biāo)題下的分隔線在4.0中如何設(shè)置,還有標(biāo)題的行間距
- 隨時(shí)更換模版、廣告等,無(wú)須重新生成整站,共享出來(lái)供討論
風(fēng)訊Cms教程教程Rss訂閱Cms教程搜索
風(fēng)訊Cms教程推薦
猜你也喜歡看這些
- OBLOG博客網(wǎng) 下載欄目模板發(fā)布
- 教學(xué)網(wǎng)首頁(yè)+大類頁(yè)+新聞頁(yè)P(yáng)NG原文件下載
- 簡(jiǎn)單素雅的個(gè)人網(wǎng)站模板
- 一文化公司模板。。。天逸書(shū)畫(huà)藝術(shù)網(wǎng)
- 黃山大型門戶網(wǎng)站(2006)版模板下載
- 重慶青年網(wǎng)模版首頁(yè)+9個(gè)頻道的首頁(yè) 子頁(yè) 詳細(xì)頁(yè)
- 寧夏社區(qū)模板提供下載-信息港類型
- 藝域設(shè)計(jì)〓〓模板資源站
- 企業(yè)網(wǎng)站模版
- 11K模板(小豬在線收集)DIV+CSS提供下載(有演示)
- 相關(guān)鏈接:
- 教程說(shuō)明:
風(fēng)訊Cms教程-3.1中修改幻燈新聞和圖片新聞可以調(diào)用子欄目的方法
。