<%Option Explicit%> <% '**************************************************** ' Software name:Kesion CMS 9.5 ' Email: service@kesion.com . 营销QQ:4000080263 Tel:400-008-0263 ' Web: http://www.kesion.com http://www.kesion.cn ' Copyright (C) Kesion Network All Rights Reserved. '**************************************************** Dim TCls Set TCls = New Tags TCls.Kesion() Set TCls = Nothing Const MaxPerPage=20 '每页显示条数 Const MaxTags=500 '默认显示tags个数 Class Tags Private KS,KMR,F_C,LoopContent,SearchResult,photourl Private ChannelID,ClassID,SearchType,TagsName,SearchForm Private I,TotalPut, RS Private Sub Class_Initialize() Set KS=New PublicCls Set KMR=New Refresh End Sub Private Sub Class_Terminate() closeconn Set KS=Nothing Set KMR=Nothing End Sub Sub Kesion() Dim templateFilePath : templateFilePath = KS.Setting(3) & KS.Setting(90) & "common/tags.html" If ( Not KS.CheckFile( templateFilePath ) ) Then templateFilePath = KS.Setting(3) & KS.Setting(90) & "tags.html" F_C = KMR.LoadTemplate( templateFilePath) If Trim(F_C) = "" Then F_C = "模板不存在!" FCls.RefreshType = "tags" '设置刷新类型，以便取得当前位置导航等 FCls.RefreshFolderID = "0" '设置当前刷新目录ID 为"0" 以取得通用标签 TagsName=KS.CheckXSS(KS.S("n")) If TagsName="" Then Call TagsMain() Else Call TagsList() End If F_C = KMR.KSLabelReplaceAll(F_C) Call TagsHits() Response.Write F_C End Sub Sub TagsMain() Dim TP:Tp=LFCls.GetConfigFromXML("tags","/labeltemplate/label","tags") Dim RS,SQL,K,str,Turl If InStr(tp,"{$ShowHotTags}")<>0 Then Set RS=Conn.Execute("Select top " & MaxTags & " KeyText,hits From KS_KeyWords order by hits desc,id desc") If Not RS.Eof Then SQL=RS.GetRows(-1) RS.Close:Set RS=Nothing If IsArray(SQL) Then For k=0 to Ubound(SQL,2) If KS.Setting(185)=1 Then turl=KS.GetDomain & "tags/" & server.URLEncode(SQL(0,K)) Else TUrl=KS.GetDomain & "plus/tags.asp?n=" & server.URLEncode(SQL(0,K)) str=str & "" & SQL(0,K) & " " Next End If Tp=Replace(Tp,"{$ShowHotTags}",str) End If If InStr(tp,"{$ShowNewTags}")<>0 Then str="" Set RS=Conn.Execute("Select top " & MaxTags & " KeyText,hits From KS_KeyWords order by adddate desc") If Not RS.Eof Then SQL=RS.GetRows(-1) RS.Close:Set RS=Nothing If IsArray(SQL) Then For k=0 to Ubound(SQL,2) If KS.Setting(185)="1" Then turl=KS.GetDomain & "tags/" & server.URLEncode(SQL(0,K)) Else TUrl=KS.GetDomain & "plus/tags.asp?n=" & server.URLEncode(SQL(0,K)) str=str & "" & SQL(0,K) & " " Next End If Tp=Replace(Tp,"{$ShowNewTags}",str) End If F_C=Replace(F_C,"{$ShowTags}",Tp) F_C=Replace(F_C,"{$TagsName}","关键字Tags") End Sub Sub TagsList() SearchTags() TagsHits() F_C=Replace(F_C,"{$ShowTags}",SearchResult) F_C=Replace(F_C,"{$PageStr}","" & ShowPagePara(totalput, MaxPerPage, "", true,"条记录", CurrentPage,KS.QueryParam("page,submit")) & "") F_C = Replace(F_C,"{$TagsName}",TagsName) F_C = Replace(F_C,"{$ShowTotal}",totalput) End Sub Sub TagsHits() If TagsName<>"" Then Conn.Execute("Update KS_KeyWords set hits=hits+1,lastusetime=" & SqlNowString & " where keytext='" & TagsName & "'") End IF End Sub Sub SearchTags() if instr(lcase(tagsname&""),"?page")<>0 then currentpage=split(lcase(tagsname&""),"?page=")(1) tagsname=split(lcase(tagsname&""),"?page=")(0) end if Dim SqlStr,Param,SQL,K Dim RSC:Set RSC=conn.execute("select ChannelID,ChannelTable From KS_Channel Where ChannelID<>6 And ChannelID<>8 And ChannelID<>9 and ChannelID<>10 and ChannelStatus=1 order by channelid") SQL=RSC.GetRows(-1):RSC.Close:Set RSC=Nothing For K=0 To Ubound(SQL,2) If SqlStr<>"" Then SqlStr=SqlStr & " Union All " Select Case KS.C_S(SQL(0,K),6) Case 1 '阿昌 2015-4-30 add Intro param SqlStr=SqlStr & "select ID,Title,Tid,ReadPoint,InfoPurview,Fname,Changes,AddDate,Popular," & SQL(0,K) & " as ChannelID,hits,Inputer As username,photourl,Intro From " & SQL(1,K) '阿昌 2015-4-30 add Intro param case 2 SqlStr=SqlStr & "select ID,Title,Tid,ReadPoint,InfoPurview,Fname,0 as Changes,AddDate,Popular," & SQL(0,K) & " as ChannelID,Hits,Inputer As username,photourl From " & SQL(1,K) case 3 SqlStr=SqlStr & "select ID,Title,Tid,ReadPoint,InfoPurview,Fname,0 as Changes,AddDate,Popular," & SQL(0,K) & " as ChannelID,Hits,Inputer As username,photourl From " & SQL(1,K) case 4 SqlStr=SqlStr & "select ID,Title,Tid,ReadPoint,InfoPurview,Fname,0 as Changes,AddDate,Popular," & SQL(0,K) & " as ChannelID,Hits,Inputer As username,photourl From " & SQL(1,K) Case 5 SqlStr=SqlStr & "select ID,Title,Tid,0 as ReadPoint,0 as InfoPurview,Fname,0 as Changes,AddDate,Popular," & SQL(0,K) & " as ChannelID,Hits,Inputer As username,photourl From " & SQL(1,K) Case 7 SqlStr=SqlStr & "select ID,Title,Tid,0 as ReadPoint,0 as InfoPurview,Fname,0 as Changes,AddDate,Popular," & SQL(0,K) & " as ChannelID,Hits,Inputer As username,photourl From " & SQL(1,K) End Select SqlStr=SqlStr & " Where DelTF=0 And Verific=1 And keywords like '%" & TagsName & "%'" Next '阿昌 2015-4-30 add Intro param SqlStr="Select ID,Title,Tid,ReadPoint,InfoPurview,Fname,Changes,AddDate,Popular,ChannelID,hits,username,photourl,Intro From (" & SQLStr & ") a ORDER BY ADDDATE DESC,ID Asc" '阿昌 2015-4-30 add Intro param Set RS=Server.CreateObject("ADODB.RECORDSET") RS.Open SqlStr,Conn,1,1 IF RS.Eof And RS.Bof Then totalput=0 SearchResult = "Tags:" & TagsName & ",没有找到任何相关信息!" exit sub Else TotalPut= RS.Recordcount If CurrentPage > 1 and (CurrentPage - 1) * MaxPerPage < totalPut Then RS.Move (CurrentPage - 1) * MaxPerPage End If Call GetSearchResult End IF RS.Close Set RS=Nothing End Sub Sub GetSearchResult() On Error Resume Next Dim LP:LP=LFCls.GetConfigFromXML("tags","/labeltemplate/label","listtp") LoopContent=KS.CutFixContent(LP, "[loop]", "[/loop]", 0) I=0 Dim LC Do While Not RS.Eof LC=LoopContent Dim PhotoUrl:PhotoUrl=rs(12) If KS.IsNul(PhotoUrl) Then PhotoUrl="../images/nopic.gif" LC=Replace(LC,"{$PhotoUrl}",PhotoUrl) LC=replace(LC,"{$Title}",rs(1)) If IsNull(rs(11)) or rs(11)="" Then LC=replace(LC,"{$UserName}","-") Else LC=replace(LC,"{$UserName}",rs(11)) End If LC=replace(LC,"{$Hits}",rs(10)) LC=replace(LC,"{$AddDate}",formatdatetime(rs(7),2)) LC=replace(LC,"{$ClassName}",KS.GetClassNP(rs(2))) LC=replace(LC,"{$Url}",KS.GetItemUrl(rs(9),rs(2),rs(0),rs(5))) '阿昌 2015-4-30 replace Intro LC=replace(LC,"{$Intro}", KS.GotTopic( rs(13), 200 ) ) '阿昌 2015-4-30 replace Intro SearchResult=SearchResult & LC I = I + 1 If I >= MaxPerPage Then Exit Do RS.MoveNext Loop LP=Replace(LP,KS.CutFixContent(LP, "[loop]", "[/loop]", 1),SearchResult) SearchResult=LP End Sub 'ShowPagePara(totalput, MaxPerPage, "", true,"条记录", CurrentPage,KS.QueryParam("page,submit")) & "") '显示伪静态分页 Function GetStaticPageList(FileName,PageStyle,CurrPage,TotalPage, ShowTurnToFlag,Extension) Dim PageStr, I, J, SelectStr If ChkClng(PageStyle)=0 Then PageStyle=1 Select Case PageStyle Case 1 If CurrPage = 1 And CurrPage <> TotalPage Then PageStr = "首页 上一页 下一页 尾页" ElseIf CurrPage = 1 And CurrPage = TotalPage Then PageStr = "首页 上一页 下一页 尾页" ElseIf CurrPage = TotalPage And CurrPage <> 2 Then '对于最后一页刚好是第二页的要做特殊处理 PageStr = "首页 上一页 下一页 尾页" ElseIf CurrPage = TotalPage And CurrPage = 2 Then PageStr = "首页 上一页 下一页 尾页" ElseIf CurrPage = 2 Then PageStr = "首页 上一页 下一页 尾页" Else PageStr = "首页 上一页 下一页 尾页" End If Case 2 If CurrPage=1 Then PageStr="9 7" 'ElseIf CurrPage=2 Then ' PageStr="9 7" Else PageStr="9 7 " End If dim startpage,n startpage=1 if (CurrPage>=10) then startpage=(CurrPage\10-1)*10+CurrPage mod 10+2 For J=startpage To TotalPage If J= CurrPage Then PageStr=PageStr & " " & J &"" Else PageStr=PageStr & " " & J &"" End If n=n+1 if n>=10 then exit for Next If CurrPage=TotalPage Then PageStr=PageStr & " 8 :" Else PageStr=PageStr & " 8 : " End If Case 3 If CurrPage=1 Then PageStr="9 7" ElseIf CurrPage=2 Then PageStr="9 7" Else PageStr="9 7 " End If If CurrPage=TotalPage Then PageStr=PageStr & " 8 :" Else PageStr=PageStr & " 8 : " End If Case 4 n=0:startpage=1 pageStr=pageStr & "

" & vbcrlf if (CurrPage>1) then pageStr=PageStr & "上一页" pageStr=pageStr & "首 页" if (CurrPage>=7) then startpage=CurrPage-5 if TotalPage-CurrPage<5 Then startpage=TotalPage-10 If startpage<=0 Then startpage=1 For J=startpage To TotalPage If J= CurrPage Then PageStr=PageStr & " " & J &"" Else PageStr=PageStr & " " & J &"" End If n=n+1 if n>=10 then exit for Next If TotalPage>10 Then If CurrPage=TotalPage Then pageStr=pageStr & "..." & TotalPage & "" Else pageStr=pageStr & "..." & TotalPage & "" End If End If if (CurrPage<>TotalPage) then pageStr=PageStr & "下一页" pageStr=PageStr & "

" End Select If CBool(ShowTurnToFlag) = True and pageStyle<>4 Then PageStr = PageStr & " 转到：" For J = 1 To TotalPage If J = CurrPage Then SelectStr = " selected" Else SelectStr = "" End If If J = 1 Then PageStr = PageStr & "第" & J & "页" Else PageStr = PageStr & "第" & J & "页" End If Next PageStr = PageStr & "" End If GetStaticPageList=PageStr End Function Public Function ShowPagePara(totalnumber, MaxPerPage, FileName, ShowAllPages, strUnit, CurrentPage, ParamterStr) If KS.Setting(185)="1" Then ParamterStr="" Dim N, I, PageStr Const Btn_First = "首页" '定义第一页按钮显示样式 Const Btn_Prev = "上一页" '定义前一页按钮显示样式 Const Btn_Next = "下一页" '定义下一页按钮显示样式 Const Btn_Last = "末页" '定义最后一页按钮显示样式 PageStr = "" If totalnumber Mod MaxPerPage = 0 Then N = totalnumber \ MaxPerPage Else N = totalnumber \ MaxPerPage + 1 End If PageStr = PageStr & ("

共 " & totalnumber & " " & strUnit & " 分 " & N & " 页 每页 " & MaxPerPage &" " & strUnit &" | 当前第 " & CurrentPage & " 页    ") If CurrentPage < 2 Then PageStr = PageStr & Btn_First & " " & Btn_Prev & " " Else PageStr = PageStr & ("" & Btn_First & " " & Btn_Prev & " ") End If If N - CurrentPage < 1 Then PageStr = PageStr & " " & Btn_Next & " " & Btn_Last & " " Else PageStr = PageStr & (" " & Btn_Next & " " & Btn_Last & " ") End If If ShowAllPages = True and KS.Setting(185)<>"1" Then PageStr = PageStr & ("转到: ") End If PageStr = PageStr & "

" ShowPagePara = PageStr End Function End Class %>