Web Wiz - Solar Powered Eco Web Hosting

  New Posts New Posts RSS Feed - Mod: Google Sitemap Generator for WWF v9.x
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Mod: Google Sitemap Generator for WWF v9.x

 Post Reply Post Reply Page  123>
Author
MortiOli View Drop Down
Senior Member
Senior Member
Avatar

Joined: 26 May 2002
Location: United Kingdom
Status: Offline
Points: 514
Post Options Post Options   Thanks (0) Thanks(0)   Quote MortiOli Quote  Post ReplyReply Direct Link To This Post Topic: Mod: Google Sitemap Generator for WWF v9.x
    Posted: 26 August 2009 at 6:25pm
Hi Scotty.

Just resynced, but still the same error unfortunately:

Quote

This page contains the following errors:

error on line 3931 at column 47: AttValue: " or ' expected

Below is a rendering of the page up to the first error.

Back to Top
Scotty32 View Drop Down
Moderator Group
Moderator Group


Joined: 30 November 2002
Location: Manchester, UK
Status: Offline
Points: 1682
Post Options Post Options   Thanks (0) Thanks(0)   Quote Scotty32 Quote  Post ReplyReply Direct Link To This Post Posted: 26 August 2009 at 6:18pm
Sorry, I left this since Stardust returned.

I just tried the code you posted above on my forum and it worked fine.

The problem seems to relate to:

strSQL = "SELECT " & strDbTable & "Thread.Message_Date FROM " & strDbTable & "Thread WHERE " & strDbTable & "Thread.Thread_ID = " & lngThread & " ;"


Basically the Thread ID isnt getting passed through, not sure why.

Maybe you could try doing the "Re-sync Topic and Post Count" from the Admin area?
S2H.co.uk - WebWiz Mods and Skins

For support on my mods + skins, please use my forum.
Back to Top
MortiOli View Drop Down
Senior Member
Senior Member
Avatar

Joined: 26 May 2002
Location: United Kingdom
Status: Offline
Points: 514
Post Options Post Options   Thanks (0) Thanks(0)   Quote MortiOli Quote  Post ReplyReply Direct Link To This Post Posted: 26 August 2009 at 5:03pm
Originally posted by StarDust StarDust wrote:

Originally posted by Scotty32 Scotty32 wrote:

I dont believe Stardust visits the forums any more



Hey! Here I am :D

It's true that i do not visit this forum very often, that's why the mods are not updated. But man I tell you waht, I love this forum. Nobody can't imagine how much!

MortiOli, I'll look into the issue and post the updated mod tomorrow. Please allow me some time.

Hi StarDust - any luck with a fix for the issue?

Cheers!
Back to Top
MortiOli View Drop Down
Senior Member
Senior Member
Avatar

Joined: 26 May 2002
Location: United Kingdom
Status: Offline
Points: 514
Post Options Post Options   Thanks (0) Thanks(0)   Quote MortiOli Quote  Post ReplyReply Direct Link To This Post Posted: 04 August 2009 at 8:55am
Cheers StarDust, that's great!

Scotty, cheers for offering to look into it.  I've had it running on my forum for quite a while, but it's one of those things you never really check, and forget to check it works after a forum upgrade.

I'm running 9.60 and MS SQL Server.

If anyone requires it, this is the sitemap.asp code:

[code]<?xml version='1.0' encoding='UTF-8'?>
<urlset xmlns="http://www.google.com/schemas/sitemap/0.84" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.google.com/schemas/sitemap/0.84 http://www.google.com/schemas/sitemap/0.84/sitemap.xsd"><%
'

' ---------- About -------------------
' Google Sitemap Generator for Web Wiz Forums v9.x
' Tested with Web Wiz Forums v9.05
' Coded by: Shahadat Hossen
' Download: http://board.ebizbd.net
' Credits: Original Mod published by Murat Yavuz from http://www.mydesign.gen.tr for WWF v8.x
'
' Web Wiz Forum is an advanced forum system powered by Web Wiz Guide
' http://www.webwiz.net
'
'
' ---------- Instruction -------------
' Just upload this file into the forum directory
' Then type url [www.yoursite.com]/[forum-path]/sitemap.asp
' and save the xml file.
' You can upload this xml file to the root directory of your site.
'
Response.Buffer = True
Response.ContentType = "text/xml"
'On Error Resume Next
%>
<!--#include file="forum/common.asp"-->
<%
' ---------- Start Configuration --------
' Valid change frequency values: always, hourly, daily, weekly, monthly, yearly, never

Const txtCategoryChange = "weekly" 'Change frequency of category pages
Const dblCategoryPriority = "0.8" 'Priority of category pages

Const txtForumChange = "weekly" 'Change frequency of forums pages
Const dblForumPriority = "0.6" 'Priority of forum pages

Const txtTopicChange = "daily" 'Change frequency of topic pages
Const dblTopicPriority = "0.4" 'Priority of topic pages
'
' ---------- End Configuration ----------

'**********************************************
'***  Format ISO International Date/Time   ****
'**********************************************

'Function to format the present date and time into international formats to prevent systems crashes on foriegn servers
Private Function isoDate(dtmDate)

Dim strYear
Dim strMonth
Dim strDay
Dim strHour
Dim strMinute
Dim strSecound

strYear = Year(dtmDate)
strMonth = Month(dtmDate)
strDay = Day(dtmDate)

'Place 0 infront of minutes under 10
If strMonth < 10 then strMonth = "0" & strMonth
If strDay < 10 then strDay = "0" & strDay

'This function returns the ISO internation date and time formats:- yyyy-mm-dd hh:mm:ss
'Dashes prevent systems that use periods etc. from crashing
isoDate = strYear & "-" & strMonth & "-" & strDay
End Function

Private Function printLastThreadDate(ByVal lngThread)
printLastThreadDate=""

strSQL = "SELECT " & strDbTable & "Thread.Message_Date FROM " & strDbTable & "Thread WHERE " & strDbTable & "Thread.Thread_ID = " & lngThread & " ;"

rsCommon.Open strSQL, adoCon

If Not rsCommon.Eof Then
printLastThreadDate=CDate(rsCommon.Fields("Message_Date").value)
printLastThreadDate=isoDate(printLastThreadDate)
End If

rsCommon.Close
End Function


'Declare variables
Dim intArrayPass
Dim intLoopX
Dim intLoopY
Dim arCategories '(0,intArrayPass): Category ID
Dim arForums '(0,intArrayPass): Forum ID; (1,intArrayPass): Category ID; (2,intArrayPass): Last Post Date
Dim arTopics

Dim rsCategory
Dim rsForums
Dim rsTopics
Dim dtmLastPostCategory

'------------------------
'List Forum Categories
'------------------------
strSQL = "SELECT " & strDbTable & "Category.Cat_ID FROM " & strDbTable & "Category ORDER BY " & strDbTable & "Category.Cat_order ASC ;"
rsCommon.Open strSQL, adoCon

If Not rsCommon.Eof Then arCategories = rsCommon.GetRows()

rsCommon.Close

'Debug
'If isArray(arCategories) Then Response.Write("OK")
'If isArray(arCategories) Then Response.Write(UBound(arCategories,2))

'For intArrayPass=0 to UBound(arCategories,2)
'Response.Write("0,0: " & arCategories(0,0) & "<br />")
'Response.Write("0,intArrayPass: " & arCategories(0,intArrayPass) & "<br />")
'Next
'------------------------
'List All Forums
'------------------------
strSQL = "SELECT " & strDbTable & "Forum.Forum_ID, " & strDbTable & "Forum.Cat_ID, " & strDbTable & "Forum.Last_post_date FROM " & strDbTable & "Forum ORDER BY " & strDbTable & "Forum.Forum_Order ASC"

rsCommon.Open strSQL, adoCon

If Not rsCommon.Eof Then arForums = rsCommon.GetRows()

rsCommon.Close

'Debug
'For intArrayPass=0 to
Back to Top
StarDust View Drop Down
Senior Member
Senior Member


Joined: 14 May 2007
Location: Bangladesh
Status: Offline
Points: 310
Post Options Post Options   Thanks (0) Thanks(0)   Quote StarDust Quote  Post ReplyReply Direct Link To This Post Posted: 04 August 2009 at 5:02am
Originally posted by Scotty32 Scotty32 wrote:

I dont believe Stardust visits the forums any more



Hey! Here I am :D

It's true that i do not visit this forum very often, that's why the mods are not updated. But man I tell you waht, I love this forum. Nobody can't imagine how much!

MortiOli, I'll look into the issue and post the updated mod tomorrow. Please allow me some time.
Back to Top
Scotty32 View Drop Down
Moderator Group
Moderator Group


Joined: 30 November 2002
Location: Manchester, UK
Status: Offline
Points: 1682
Post Options Post Options   Thanks (0) Thanks(0)   Quote Scotty32 Quote  Post ReplyReply Direct Link To This Post Posted: 03 August 2009 at 9:25pm
I dont believe Stardust visits the forums any more but if you could post the SQL statement and the spec of your forum (eg version and DB type) I will try to help.

Also, has this mod been running successfully before? or have you just installed it?


As MrTWS, this mod was built for an older forum version and may not be compatible with newer releases.


For TWS, Firefox displays that error because is because the file has a XML mime type and so is trying to load it as an XML file, but the font tag is coursing an XML error.

The font tag is from an ASP error which Morti posted.


Edited by Scotty32 - 03 August 2009 at 9:29pm
S2H.co.uk - WebWiz Mods and Skins

For support on my mods + skins, please use my forum.
Back to Top
123Simples View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192
Post Options Post Options   Thanks (0) Thanks(0)   Quote 123Simples Quote  Post ReplyReply Direct Link To This Post Posted: 03 August 2009 at 5:20pm
Also check out Scottys comments on page 1 of this topic which lend some more information. Plus third party mods like this one may have issues running on version 9.60 which you are now using
Back to Top
123Simples View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192
Post Options Post Options   Thanks (0) Thanks(0)   Quote 123Simples Quote  Post ReplyReply Direct Link To This Post Posted: 03 August 2009 at 5:17pm
On Firefox it renders this error:

XML Parsing Error: not well-formed
Location: http://www.ckyalliance.co.uk/sitemap.asp
Line Number 3926, Column 56:<priority>0.4</priority></url> <font face="Arial" size=2>
Back to Top
 Post Reply Post Reply Page  123>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.07
Copyright ©2001-2024 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Policy

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2024 Web Wiz Ltd. All rights reserved.