📄 admin_createother.asp
字号:
If rsArticle(1) <> oldChannelID Then
Set rsChannel = Conn.Execute("select Top 1 ChannelID,ChannelDir,ChannelType,LinkUrl,UseCreateHTML,StructureType,FileNameType,FileExt_Item 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")
End If
rsChannel.Close
If LinkUrl <> "" Then
preurl = LinkUrl
Else
preurl = SiteUrl & iChannelDir
End If
End If
iAuthor = rsArticle(4)
If UseCreateHTML > 0 Then
strHTML = strHTML & "<li><a href='" & preurl & GetItemPath(StructureType, ParentDir, ClassDir, rsArticle(5)) & GetItemFileName(FileNameType, iChannelDir, rsArticle(5), rsArticle(0)) & arrFileExt(FileExt_Item) & "'>" & rsArticle(3) & "</a> - [" & iAuthor & "]</li>" & vbCrLf
Else
strHTML = strHTML & "<li><a href='" & preurl & "/ShowProduct.asp?ProductID=" & rsArticle(0) & "'>" & rsArticle(3) & "</a> - [" & iAuthor & "]</li>" & vbCrLf
End If
i = i + 1
If i > MaxPerPage Then
strtmp = "<html>" & vbCrLf
strtmp = strtmp & "<head>" & vbCrLf
strtmp = strtmp & "<title>" & SiteName & "-SiteMap</title>" & vbCrLf
strtmp = strtmp & "<meta http-equiv=""Content-Type"" content=""text/html; charset=gb2312"">" & vbCrLf
strtmp = strtmp & "<link href='" & InstallDir & "Skin/DefaultSkin.css' rel='stylesheet' type='text/css'>" & vbCrLf
strtmp = strtmp & "</head>" & vbCrLf
strtmp = strtmp & "<body><table width='760' align='center'><tr><td>" & vbCrLf
strtmp = strtmp & "<a href='" & SiteUrl & "'>" & SiteName & "</a> >> 网站地图 >> 第" & CurrentPage & "页:<br>" & vbCrLf
strtmp = strtmp & strHTML & "<br><br>分页:"
For j = 1 To totalPage
If CurrentPage = j Then
If (j Mod MaxPageCol) = 0 Then
strtmp = strtmp & " [" & j & "]<br>"
Else
strtmp = strtmp & " [" & j & "] "
End If
Else
If (j Mod MaxPageCol) = 0 Then
strtmp = strtmp & " <a href='" & InstallDir & "SiteMap/Product" & j & ".htm'>" & j & "</a><br>"
Else
strtmp = strtmp & " <a href='" & InstallDir & "SiteMap/Product" & j & ".htm'>" & j & "</a> "
End If
End If
Next
strtmp = strtmp & "</td></tr></table></body>" & vbCrLf
strtmp = strtmp & "</html>" & vbCrLf
Call WriteToFile(InstallDir & "SiteMap/Product" & CurrentPage & ".htm", strtmp)
Response.Write "<br> 生成页面（<a href='" & InstallDir & "SiteMap/Product" & CurrentPage & ".htm' target='_blank'>" & SiteUrl & "SiteMap/Product" & CurrentPage & ".htm</a>）<font color=red>成功!</font>"
CurrentPage = CurrentPage + 1
i = 1
strHTML = ""
End If
oldChannelID = rsArticle(1)
rsArticle.movenext
Loop
Set rsChannel = Nothing
strtmp = "<html>" & vbCrLf
strtmp = strtmp & "<head>" & vbCrLf
strtmp = strtmp & "<title>" & SiteName & "-SiteMap</title>" & vbCrLf
strtmp = strtmp & "<meta http-equiv=""Content-Type"" content=""text/html; charset=gb2312"">" & vbCrLf
strtmp = strtmp & "<link href='" & InstallDir & "Skin/DefaultSkin.css' rel='stylesheet' type='text/css'>" & vbCrLf
strtmp = strtmp & "</head>" & vbCrLf
strtmp = strtmp & "<body><table width='760' align='center'><tr><td>" & vbCrLf
strtmp = strtmp & "<a href='" & SiteUrl & "'>" & SiteName & "</a> >> 网站地图 >> 第" & CurrentPage & "页:<br>" & vbCrLf
strtmp = strtmp & strHTML & "<br><br>分页:"
For j = 1 To totalPage
If CurrentPage = j Then
If (j Mod MaxPageCol) = 0 Then
strtmp = strtmp & " [" & j & "]<br>"
Else
strtmp = strtmp & " [" & j & "] "
End If
Else
If (j Mod MaxPageCol) = 0 Then
strtmp = strtmp & " <a href='" & InstallDir & "SiteMap/Product" & j & ".htm'>" & j & "</a><br>"
Else
strtmp = strtmp & " <a href='" & InstallDir & "SiteMap/Product" & j & ".htm'>" & j & "</a> "
End If
End If
Next
strtmp = strtmp & "</td></tr></table></body>" & vbCrLf
strtmp = strtmp & "</html>" & vbCrLf
Call WriteToFile(InstallDir & "SiteMap/Product" & CurrentPage & ".htm", strtmp)
Response.Write "<br> 生成页面（<a href='" & InstallDir & "SiteMap/Product" & CurrentPage & ".htm' target='_blank'>" & SiteUrl & "SiteMap/Product" & CurrentPage & ".htm</a>）<font color=red>成功!</font>"
strHTML = strHTML & "<br>" & vbCrLf
End If
rsArticle.Close
Set rsArticle = Nothing
End Sub
Sub OutXmlMap(OutType)
Dim rsArticle, sqlArticle, rsChannel, strHTML, totalPut, totalPage, CurrentPage, i, j
Dim iChannelDir, ChannelType, LinkUrl, preurl, UseCreateHTML, StructureType, FileNameType, FileExt_Item, 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 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 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 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 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
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 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")
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 = "sitemap_article_"
Case 2
AspName = "/ShowSoft.asp?SoftID="
OutFileName = "sitemap_Soft_"
Case 3
AspName = "/ShowPhoto.asp?PhotoID="
OutFileName = "sitemap_Photo_"
Case 5
AspName = "/ShowProduct.asp?ProductID="
OutFileName = "sitemap_Product_"
End Select
strHTML = strHTML & "<url>" & vbCrLf
If OutType < 4 Then
If UseCreateHTML > 0 And (ClassPurview = 0 Or rsArticle(2) = -1) And rsArticle(5) = 0 Then
strHTML = strHTML & "<loc>" & preurl & GetItemPath(StructureType, ParentDir, ClassDir, rsArticle(3)) & GetItemFileName(FileNameType, iChannelDir, rsArticle(3), rsArticle(0)) & arrFileExt(FileExt_Item) & "</loc>" & vbCrLf
Else
strHTML = strHTML & "<loc>" & preurl & AspName & rsArticle(0) & "</loc>" & vbCrLf
End If
ElseIf OutType = 5 Then
If UseCreateHTML > 0 Then
strHTML = strHTML & "<loc>" & preurl & GetItemPath(StructureType, ParentDir, ClassDir, rsArticle(3)) & GetItemFileName(FileNameType, iChannelDir, rsArticle(3), rsArticle(0)) & arrFileExt(FileExt_Item) & "</loc>" & vbCrLf
Else
strHTML = strHTML & "<loc>" & preurl & AspName & rsArticle(0) & "</loc>" & vbCrLf
End If
End If
strHTML = strHTML & "<lastmod>" & iso8601date(rsArticle(3), UOffset) & "</lastmod>" & vbCrLf
strHTML = strHTML & "<changefreq>" & frequency & "</changefreq>" & vbCrLf
strHTML = strHTML & "<priority>" & Priority & "</priority>" & vbCrLf
strHTML = strHTML & "</url>" & vbCrLf
i = i + 1
If i > XmlMaxPerPage Then
strtmp = "<?xml version=""1.0"" encoding=""UTF-8""?>" & vbCrLf
strtmp = strtmp & "<urlset xmlns=""http://www.google.com/schemas/sitemap/0.84"">" & vbCrLf
strtmp = strtmp & strHTML
strtmp = strtmp & "</urlset>" & 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)
rsArticle.movenext
Loop
Set rsChannel = Nothing
strtmp = "<?xml version=""1.0"" encoding=""UTF-8""?>" & vbCrLf
strtmp = strtmp & "<urlset xmlns=""http://www.google.com/schemas/sitemap/0.84"">" & vbCrLf
strtmp = strtmp & strHTML
strtmp = strtmp & "</urlset>" & 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
Sub OutXmlIndexMap()
Dim strtmp, j
strtmp = "<?xml version=""1.0"" encoding=""UTF-8""?>" & vbCrLf
strtmp = strtmp & "<sitemapindex xmlns=""http://www.google.com/schemas/sitemap/0.84"">" & vbCrLf
If ArtPage > 0 Then
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -