📄 admin_createother.asp
字号:
For j = 1 To ArtPage
strtmp = strtmp & "<sitemap>" & vbCrLf
strtmp = strtmp & "<loc>" & SiteUrl & "sitemap_article_" & j & ".xml</loc>" & vbCrLf
strtmp = strtmp & "<lastmod>" & iso8601date(Now(), UOffset) & "</lastmod>" & vbCrLf
strtmp = strtmp & "</sitemap>" & vbCrLf
Next
End If
If SoftPage > 0 Then
For j = 1 To SoftPage
strtmp = strtmp & "<sitemap>" & vbCrLf
strtmp = strtmp & "<loc>" & SiteUrl & "sitemap_Soft_" & j & ".xml</loc>" & vbCrLf
strtmp = strtmp & "<lastmod>" & iso8601date(Now(), UOffset) & "</lastmod>" & vbCrLf
strtmp = strtmp & "</sitemap>" & vbCrLf
Next
End If
If PhotoPage > 0 Then
For j = 1 To PhotoPage
strtmp = strtmp & "<sitemap>" & vbCrLf
strtmp = strtmp & "<loc>" & SiteUrl & "sitemap_Photo_" & j & ".xml</loc>" & vbCrLf
strtmp = strtmp & "<lastmod>" & iso8601date(Now(), UOffset) & "</lastmod>" & vbCrLf
strtmp = strtmp & "</sitemap>" & vbCrLf
Next
End If
If ProductPage > 0 Then
For j = 1 To ProductPage
strtmp = strtmp & "<sitemap>" & vbCrLf
strtmp = strtmp & "<loc>" & SiteUrl & "sitemap_Product_" & j & ".xml</loc>" & vbCrLf
strtmp = strtmp & "<lastmod>" & iso8601date(Now(), UOffset) & "</lastmod>" & vbCrLf
strtmp = strtmp & "</sitemap>" & vbCrLf
Next
End If
strtmp = strtmp & "</sitemapindex>" & vbCrLf
Call WriteToFile(InstallDir & "sitemap_index.xml", strtmp)
Response.Write "<br> 生成页面（<a href='" & InstallDir & "sitemap_index.xml' target='_blank'>" & InstallDir & "sitemap_index.xml</a>）<font color=red>成功!</font>， [<a href='http://www.google.com/webmasters/sitemaps/ping?sitemap=" & SiteUrl & "sitemap_index.xml' target='_blank'>点击这里提交到Google</a>]"
End Sub
Sub OutBaiDuMap(OutType)
Dim rsArticle, sqlArticle, rsChannel, strHTML, totalPut, totalPage, CurrentPage, i, j
Dim iChannelDir, ChannelType, LinkUrl, preurl, UseCreateHTML, StructureType, FileNameType, FileExt_Item, CUploadDir, ClassDir, ParentDir, ClassPurview, AspName, OutFileName
Dim oldChannelID: oldChannelID = 0
Select Case OutType
Case 1
sqlArticle = "select top " & XmlOutNum & " A.ArticleID,A.ChannelID,A.ClassID,A.UpdateTime,A.Status,A.InfoPoint,A.Deleted,A.LinkUrl,C.ClassDir,C.ParentDir,C.ClassPurview,A.Title,A.Author,A.CopyFrom,A.Keyword,A.Content,A.DefaultPicUrl from PE_Article A left join PE_Class C on A.ClassID=C.ClassID Where A.Status=3 and A.Deleted=" & PE_False & " order by A.ArticleID Desc"
Case 2
sqlArticle = "select top " & XmlOutNum & " A.SoftID,A.ChannelID,A.ClassID,A.UpdateTime,A.Status,A.InfoPoint,A.Deleted,A.Hits,C.ClassDir,C.ParentDir,C.ClassPurview,A.SoftName,A.Author,A.CopyFrom,A.Keyword,A.SoftIntro,A.SoftPicUrl from PE_Soft A left join PE_Class C on A.ClassID=C.ClassID Where A.Status=3 and A.Deleted=" & PE_False & " order by A.SoftID Desc"
Case 3
sqlArticle = "select top " & XmlOutNum & " A.PhotoID,A.ChannelID,A.ClassID,A.UpdateTime,A.Status,A.InfoPoint,A.Deleted,A.Hits,C.ClassDir,C.ParentDir,C.ClassPurview,A.PhotoName,A.Author,A.CopyFrom,A.Keyword,A.PhotoIntro,A.PhotoThumb from PE_Photo A left join PE_Class C on A.ClassID=C.ClassID Where A.Status=3 and A.Deleted=" & PE_False & " order by A.PhotoID Desc"
Case 5
sqlArticle = "select top " & XmlOutNum & " A.ProductID,A.ChannelID,A.ClassID,A.UpdateTime,A.EnableSale,A.Stocks,A.Deleted,A.Hits,C.ClassDir,C.ParentDir,C.ClassPurview,A.ProductName,A.ProducerName,A.TrademarkName,A.Keyword,A.ProductIntro,A.ProductThumb from PE_Product A left join PE_Class C on A.ClassID=C.ClassID Where A.Deleted=" & PE_False & " and A.EnableSale=" & PE_True & " order by A.ProductID Desc"
End Select
Set rsArticle = Server.CreateObject("adodb.recordset")
rsArticle.Open sqlArticle, Conn, 1, 1
If rsArticle.bof And rsArticle.EOF Then
Response.Write "尚无内容!暂不生成页面!<br>"
Else
totalPut = rsArticle.recordcount
If (totalPut Mod XmlMaxPerPage) = 0 Then
totalPage = totalPut \ XmlMaxPerPage
Else
totalPage = totalPut \ XmlMaxPerPage + 1
End If
i = 1
j = 1
CurrentPage = 1
Do While Not rsArticle.EOF
ClassDir = rsArticle(8)
ParentDir = rsArticle(9)
ClassPurview = rsArticle(10)
If rsArticle(1) <> oldChannelID Then
Set rsChannel = Conn.Execute("select Top 1 ChannelID,ChannelDir,ChannelType,LinkUrl,UseCreateHTML,StructureType,FileNameType,FileExt_Item,UploadDir from PE_Channel where ChannelID=" & rsArticle(1))
If Not (rsChannel.bof And rsChannel.EOF) Then
iChannelDir = rsChannel("ChannelDir")
UseCreateHTML = rsChannel("UseCreateHTML")
StructureType = PE_CLng(rsChannel("StructureType"))
FileNameType = rsChannel("FileNameType")
FileExt_Item = rsChannel("FileExt_Item")
ChannelType = rsChannel("ChannelType")
LinkUrl = rsChannel("LinkUrl")
CUploadDir = rsChannel("UploadDir")
End If
rsChannel.Close
If LinkUrl <> "" Then
preurl = LinkUrl
Else
preurl = SiteUrl & iChannelDir
End If
End If
Select Case OutType
Case 1
AspName = "/ShowArticle.asp?ArticleID="
OutFileName = "baidumap_article_"
Case 2
AspName = "/ShowSoft.asp?SoftID="
OutFileName = "baidumap_Soft_"
Case 3
AspName = "/ShowPhoto.asp?PhotoID="
OutFileName = "baidumap_Photo_"
Case 5
AspName = "/ShowProduct.asp?ProductID="
OutFileName = "baidumap_Product_"
End Select
strHTML = strHTML & "<item>" & vbCrLf
strHTML = strHTML & "<title>" & fhtml(rsArticle(11)) & "</title>" & vbCrLf
If OutType < 4 Then
If UseCreateHTML > 0 And (ClassPurview = 0 Or rsArticle(2) = -1) And rsArticle(5) = 0 Then
strHTML = strHTML & "<link>" & preurl & GetItemPath(StructureType, ParentDir, ClassDir, rsArticle(3)) & GetItemFileName(FileNameType, iChannelDir, rsArticle(3), rsArticle(0)) & arrFileExt(FileExt_Item) & "</link>" & vbCrLf
Else
strHTML = strHTML & "<link>" & preurl & AspName & rsArticle(0) & "</link>" & vbCrLf
End If
ElseIf OutType = 5 Then
If UseCreateHTML > 0 Then
strHTML = strHTML & "<link>" & preurl & GetItemPath(StructureType, ParentDir, ClassDir, rsArticle(3)) & GetItemFileName(FileNameType, iChannelDir, rsArticle(3), rsArticle(0)) & arrFileExt(FileExt_Item) & "</link>" & vbCrLf
Else
strHTML = strHTML & "<link>" & preurl & AspName & rsArticle(0) & "</link>" & vbCrLf
End If
End If
strHTML = strHTML & "<text>" & GetSubStr(fhtml(rsArticle(15)), 600, "") & "</text>" & vbCrLf
If rsArticle(16) <> "" Then
strHTML = strHTML & "<image>" & preurl & "/" & CUploadDir & "/" & rsArticle(16) & "</image>" & vbCrLf
Else
strHTML = strHTML & "<image/>" & vbCrLf
End If
strHTML = strHTML & "<keywords>" & fhtml(Replace(rsArticle(14), "|", " ")) & "</keywords>" & vbCrLf
strHTML = strHTML & "<author>" & fhtml(rsArticle(12)) & "</author>" & vbCrLf
strHTML = strHTML & "<source>" & fhtml(rsArticle(13)) & "</source>" & vbCrLf
strHTML = strHTML & "<pubDate>" & rsArticle(3) & "</pubDate>" & vbCrLf
strHTML = strHTML & "</item>" & vbCrLf
i = i + 1
j = j + 1
If i > XmlMaxPerPage Then
strtmp = "<?xml version=""1.0"" encoding=""GB2312""?>" & vbCrLf
strtmp = strtmp & "<document>" & vbCrLf
strtmp = strtmp & "<webSite>" & SiteUrl & "</webSite>" & vbCrLf
strtmp = strtmp & "<webMaster>" & WebmasterEmail & "</webMaster>" & vbCrLf
strtmp = strtmp & "<updatePeri>" & frequency & "</updatePeri>" & vbCrLf
strtmp = strtmp & strHTML
strtmp = strtmp & "</document>" & vbCrLf
Call WriteToFile(InstallDir & OutFileName & CurrentPage & ".xml", strtmp)
Response.Write "<br> 生成页面（<a href='" & InstallDir & OutFileName & CurrentPage & ".xml' target='_blank'>" & SiteUrl & OutFileName & CurrentPage & ".xml</a>）<font color=red>成功!</font>"
CurrentPage = CurrentPage + 1
i = 1
strHTML = ""
End If
oldChannelID = rsArticle(1)
If j > XmlOutNum Then
Exit Do
End If
rsArticle.movenext
Loop
Set rsChannel = Nothing
strtmp = "<?xml version=""1.0"" encoding=""GB2312""?>" & vbCrLf
strtmp = strtmp & "<document>" & vbCrLf
strtmp = strtmp & "<webSite>" & SiteUrl & "</webSite>" & vbCrLf
strtmp = strtmp & "<webMaster>" & WebmasterEmail & "</webMaster>" & vbCrLf
strtmp = strtmp & "<updatePeri>" & frequency & "</updatePeri>" & vbCrLf
strtmp = strtmp & strHTML
strtmp = strtmp & "</document>" & vbCrLf
Call WriteToFile(InstallDir & OutFileName & CurrentPage & ".xml", strtmp)
Response.Write "<br> 生成页面（<a href='" & InstallDir & OutFileName & CurrentPage & ".xml' target='_blank'>" & SiteUrl & OutFileName & CurrentPage & ".xml</a>)<font color=red>成功!</font>"
strHTML = strHTML & "<br>" & vbCrLf
End If
Select Case OutType
Case 1
ArtPage = totalPage
Case 2
SoftPage = totalPage
Case 3
PhotoPage = totalPage
Case 5
ProductPage = totalPage
End Select
rsArticle.Close
Set rsArticle = Nothing
End Sub
'**************************************************
'函数名：iso8601date
'作 用：时间格式转换
'**************************************************
Function iso8601date(dLocal, utcOffset)
Dim d, d1
d = DateAdd("H", -1 * utcOffset, dLocal)
If Len(utcOffset) < 2 Then
d1 = "0" & utcOffset
Else
d1 = utcOffset
End If
iso8601date = Year(d) & "-" & Right("0" & Month(d), 2) & "-" & Right("0" & Day(d), 2) & "T"
iso8601date = iso8601date & (Right("0" & Hour(d), 2) & ":" & Right("0" & Minute(d), 2) & ":" & Right("0" & Second(d), 2))
If utcOffset < 0 Then
iso8601date = iso8601date & ("-" & d1 & ":00")
Else
iso8601date = iso8601date & ("+" & d1 & ":00")
End If
End Function
'**************************************************
'函数名：fhtml
'作 用：强化过滤HTML标记
'**************************************************
Function fhtml(istr)
istr = cuthtml(istr)
fhtml = Replace(Replace(Replace(Replace(Replace(Replace(istr, " ", ""), "'", "'"), """", """), ">", ">"), "<", "<"), "&", "&")
End Function
Function cuthtml(ByVal str)
If IsNull(str) Or Trim(str) = "" Then
cuthtml = ""
Exit Function
End If
regEx.Pattern = "(\<.[^\<]*\>)"
str = regEx.Replace(str, " ")
regEx.Pattern = "(\<\/[^\<]*\>)"
str = regEx.Replace(str, "")
str = Replace(str, "'", "")
str = Replace(str, Chr(34), "")
cuthtml = str
End Function
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -