Web Wiz Forums Modifications - Mod: Google Sitemap Generator for WWF v9.x

Print Page | Close Window

Mod: Google Sitemap Generator for WWF v9.x

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums Modifications
Forum Description: Mod's and Add-on's for Web Wiz Forums.
URL: https://forums.webwiz.net/forum_posts.asp?TID=25060
Printed Date: 29 March 2026 at 1:09pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Mod: Google Sitemap Generator for WWF v9.x

Posted By: StarDust
Subject: Mod: Google Sitemap Generator for WWF v9.x
Date Posted: 25 December 2007 at 4:18pm

*Google Sitemap Generator for WWF v9.x*
Mod Version: 1.0
Compatibility: WWF v9.x
Tested With: WWF v9.05
Live Demo: http://board.ebizbd.net/sitemap.asp - http://board.ebizbd.net/sitemap.asp
Download: http://board.ebizbd.net/forum_posts.asp?TID=171 - http://board.ebizbd.net/forum_posts.asp?TID=171
Skin Author: Shahadat Hossen
Realease Date: December 25, 2007
Last Updated: not yet

About:
=====
For those who needs google site map for WWF v9.x.

Instructions:
=========
Unpack the zip file and upload sitemap.asp in the root of your forum directory.
Navigate to http://[forumurl]/sitemap.asp

-------------
http://board.ebizbd.net/">

Tips, mods and skins for WWF v9.x

Replies:

Posted By: MortiOli
Date Posted: 27 December 2007 at 4:39pm

As a note - sitemap.asp can be added to Google as a sitemap, and doesn't need re-running / saving as an XML file before adding to Google's Webmaster site.

Posted By: moec
Date Posted: 15 April 2008 at 8:50am

The link above is dead

-------------
Best,

Mikael :0)-

Posted By: StarDust
Date Posted: 15 April 2008 at 12:16pm

StarDust wrote:

That is true. I have shutdown the board. The link will be live again after release of WWF v10.

Meanwhile, PM me with your mail address to get the mod

Board is up and live. You can download the mods again

-------------
http://board.ebizbd.net/">

Tips, mods and skins for WWF v9.x

Posted By: billd3
Date Posted: 15 April 2008 at 1:38pm

What is the purpose of a Google site map??

-------------
BillD
http://theamcpages.com
http://theamcforum.com

Posted By: StarDust
Date Posted: 15 April 2008 at 1:41pm

It categorizes your site links like a site map on any site.

-------------
http://board.ebizbd.net/">

Tips, mods and skins for WWF v9.x

Posted By: billd3
Date Posted: 15 April 2008 at 2:22pm

Why would I not just use a generic free site map generator? Why google?
(I try to avoid their garbage any time I can, and refuse to install any of their spyware on my desktops, such as their IE add-ins, desktop search (which hammers domain controllers!) and so on)

-------------
BillD
http://theamcpages.com
http://theamcforum.com

Posted By: Scotty32
Date Posted: 15 April 2008 at 7:37pm

The Google Sitemap isnt BY google its FOR google.

If you dislike google and dont want any traffic from them you may not need this.

The mod (should) generate a dynamic XML file listing ALL of your threads for google (and other search engines that support it). you would then submit the location of the sitemap to google, yahoo and msn (the ones i currently know off that have control panels) also Ask.com accepts them but you have to add a tag to your robots.txt file for them to pick it up.

Its a great idea for websites so that the search engines can find all your pages and index them, rather than relying on links on your site (which may be quite long eg home page > products > category > product item) but i personally dont see much need on a forum.

for more information you can follow the links below:

http://www.sitemaps.org - Site for the people who started "sitemaps" (sitemap.org)
http://www.google.com/webmasters/tools/ - Google Webmaster Tools (site for submitting your sitemaps too)
http://siteexplorer.search.yahoo.com - Yahoos Site Explorer (same as googles link above)

-------------
S2H.co.uk - http://www.s2h.co.uk/wwf/" rel="nofollow - WebWiz Mods and Skins

For support on my mods + skins, please use http://www.s2h.co.uk/forum/" rel="nofollow - my forum .

Posted By: billd3
Date Posted: 15 April 2008 at 9:48pm

Ah - well, google has no trouble finding our topics!
In fact, a fellow posted a bit about having his car hauled by a trucking company just last night. I did a search on the info he gave me this AM in google - and that post turned up as the first hit! WOW

It would be interesting to see how many sites link TO us, though.... seems there is a tool for that. As far as being found, not a problem so far.

Just that I will never ever install "google software" on any of my computers after seeing what it does in a network environment - and to security/privacy. Nasty stuff, really set off the alarms of the network admins here when the google desktop search started hammering away at their domain controllers!

-------------
BillD
http://theamcpages.com
http://theamcforum.com

Posted By: StarDust
Date Posted: 16 April 2008 at 1:39am

Guys links to my mods are live now.

-------------
http://board.ebizbd.net/">

Tips, mods and skins for WWF v9.x

Posted By: MortiOli
Date Posted: 03 August 2009 at 2:50pm

I've had this mod for a while, but just checked it today, and I'm receiving an error:

http://www.ckyalliance.co.uk/sitemap.asp" rel="nofollow - http://www.ckyalliance.co.uk/sitemap.asp

This page contains the following errors:

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

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

Any ideas?

Posted By: 123Simples
Date Posted: 03 August 2009 at 4:12pm

Just a quick stab
You have
<priority>0.4</priority></url> 
should it not read
<priority>0.4</priority></url> with the speech marks?

-------------
http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design

Posted By: MortiOli
Date Posted: 03 August 2009 at 5:07pm

Looking at the source, I think that's the error message:

 <font face="Arial" size=2> <p>Microsoft OLE DB Provider for SQL Server</font> <font face="Arial" size=2>error '80040e14'</font> 
<p> 
<font face="Arial" size=2>Line 1: Incorrect syntax near ';'.</font> 
<p> 
<font face="Arial" size=2>/forum/sitemap.asp</font><font face="Arial" size=2>, line 75</font>

Posted By: 123Simples
Date 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> 

-------------
http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design

Posted By: 123Simples
Date 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

-------------
http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design

Posted By: Scotty32
Date 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.

-------------
S2H.co.uk - http://www.s2h.co.uk/wwf/" rel="nofollow - WebWiz Mods and Skins

For support on my mods + skins, please use http://www.s2h.co.uk/forum/" rel="nofollow - my forum .

Posted By: StarDust
Date Posted: 04 August 2009 at 5:02am

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.

-------------
http://board.ebizbd.net/">

Tips, mods and skins for WWF v9.x

Posted By: MortiOli
Date 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

' ---------- 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) & " ")

'Response.Write("0,intArrayPass: " & arCategories(0,intArrayPass) & " ")

'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

Posted By: MortiOli
Date Posted: 26 August 2009 at 5:03pm

StarDust wrote:

Scotty32 wrote:

I dont believe Stardust visits the forums any more

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

Cheers!

Posted By: Scotty32
Date 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 - http://www.s2h.co.uk/wwf/" rel="nofollow - WebWiz Mods and Skins

For support on my mods + skins, please use http://www.s2h.co.uk/forum/" rel="nofollow - my forum .

Posted By: MortiOli
Date Posted: 26 August 2009 at 6:25pm

Hi Scotty.

Just resynced, but still the same error unfortunately:

This page contains the following errors:

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