Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 Google Sitemaps Mini-mod (Beta)
 New Topic  Reply to Topic
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 9

jeffery
Junior Member

USA
176 Posts

Posted - 27 July 2005 :  20:39:13  Show Profile  Reply with Quote
Ok, thanks Podge!<

www.thomasforum.com
Go to Top of Page

Podge
Support Moderator

Ireland
3775 Posts

Posted - 28 July 2005 :  16:58:05  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message  Reply with Quote
Link to code should be working now.

Must do some more work on it when I get a chance.<

Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

jeffery
Junior Member

USA
176 Posts

Posted - 28 July 2005 :  19:20:48  Show Profile  Reply with Quote
Hi Podge,

I ran it but strangely had some topics forums without dates?? and Google threw up an error about dates.

So I modified the ISO8601Date() function as follows.
Function ISO8601Date(Date2Convert)
		isoYear = left(Date2Convert, 4)
		if isoYear = "" then isoYear = "2005"
		isoMonth = mid(Date2Convert, 5, 2)
		if isoMonth = "" then isoMonth = "01"
		isoDay = mid(Date2Convert, 7, 2)
		if isoDay = "" then isoDay = "01"
		isoHour = mid(Date2Convert, 9, 2)
		if isoHour = "" then isoHour = "12"
		isoMinute = mid(Date2Convert, 11, 2)
		if isoMinute = "" then isoMinute = "00"
		isoSecond = mid(Date2Convert, 13, 2)
		if isoSecond = "" then isoSecond = "00"
		ISO8601Date = isoYear & "-" & isoMonth & "-" & isoDay & "T" & isoHour & ":" & isoMinute & ":" & isoSecond & "+00:00"
end Function


I resubmitted the sitemap to Google and am waiting for a response.
<

www.thomasforum.com

Edited by - jeffery on 05 August 2005 15:30:07
Go to Top of Page

Podge
Support Moderator

Ireland
3775 Posts

Posted - 29 July 2005 :  04:36:09  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message  Reply with Quote
Do you know which topics did not have dates? or why?

Are you sure it was topics and not forums without dates?<

Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

jeffery
Junior Member

USA
176 Posts

Posted - 29 July 2005 :  08:33:41  Show Profile  Reply with Quote
Yes, of course it was Forums, not Topics. They were just some topics I created a while back. There are two of them I see now without dates. The forum is rather unorganized but you can see which topics are without dates here http://www.thomasforum.com/home_default.asp

I will probably remove those topics within a day or two.<

www.thomasforum.com
Go to Top of Page

wildfiction
Junior Member

167 Posts

Posted - 04 August 2005 :  06:27:58  Show Profile  Visit wildfiction's Homepage  Reply with Quote
I've noticed that a few people misunderstand the use of this mod - from the comments that I see. This mod that Podge wrote does not create a sitemap that resides on disk but rather dynamically builds one and gives this to Google. This means that you don't kneed to have write access to that part of the forum. It also means that the sitemap will always be up-to-date with the latest info without you having to do anything else - thanks Podge.
<
Go to Top of Page

Podge
Support Moderator

Ireland
3775 Posts

Posted - 04 August 2005 :  07:33:16  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message  Reply with Quote
It really needs both options. If you have a really large forum you do not want to be running a large query every time someone views the sitemap. Instead you would run the weekly (for example) and submit the generated "static" text file to Google instead of the asp file.

Is there a template for an "admin area" page anywhere?<

Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

Podge
Support Moderator

Ireland
3775 Posts

Posted - 13 September 2005 :  17:43:06  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message  Reply with Quote
A little update on this. Its been a while since I used XSLT but I threw together a stylesheet which makes the sitemap a little easier to read for us humans.

This is what the sitemap looks like with the stylesheet added -

Stylised Sitemap
You can change the blatant logo and link at the top by editing the lines just after the <body> tag.
Do not edit the links at the bottom of the page or I will be very very cross

This is the stylesheet which performs the transformation
http://demo.forumco.com/sitemap.xsl

Save this file and upload it to your forum directory.

The code which generates the sitemaps has been updated to use the stylesheet

Download Code Here

I built the stylesheet using examples from http://www.marrowsoft.com

Its also worth noting that there is a rather nifty stylesheet for Google Sitemaps available here - http://sourceforge.net/projects/gstoolbox/

In other news....

Its been two months since I first submitted a sitemap and Google has been downloading them a few times a day since. Do they work? Yes. Google has indexed at least four times as many pages as before for me.<

Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

muzishun
Senior Member

United States
1079 Posts

Posted - 13 September 2005 :  23:46:03  Show Profile  Visit muzishun's Homepage  Reply with Quote
Now that's high quality. Good job, Podge.

I also went and downloaded the Source Forge project. Looks like it could be pretty useful.<

Bill Parrott
Senior Web Programmer, University of Kansas
Co-Owner and Code Monkey, Eternal Second Designs (www.eternalsecond.com)
Personal Website (www.chimericdream.com)
Go to Top of Page

Podge
Support Moderator

Ireland
3775 Posts

Posted - 14 September 2005 :  04:35:44  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message  Reply with Quote
Any suggestions for improvements? I'm tempted to include some configuration in the admin area but I'm not sure about it yet.

One thing I notice is that it works ok on IE6 & Firefox but even the latest version of Opera does not support XSL transformations.<

Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

muzishun
Senior Member

United States
1079 Posts

Posted - 14 September 2005 :  10:18:50  Show Profile  Visit muzishun's Homepage  Reply with Quote
Well, I've got my entire site running off the forum database now. It would be nice to be able to add pages that aren't actually forum pages into the sitemap automatically. Maybe just have some fields where you can add the absolute path to specific files.

I'd also like to see you take advantage of the priority system. I put it into my sitemap, and I think it helps a little bit. I think it gives us the ability to draw Google to the more important parts of our site more often.<

Bill Parrott
Senior Web Programmer, University of Kansas
Co-Owner and Code Monkey, Eternal Second Designs (www.eternalsecond.com)
Personal Website (www.chimericdream.com)
Go to Top of Page

Podge
Support Moderator

Ireland
3775 Posts

Posted - 14 September 2005 :  11:50:13  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message  Reply with Quote
I see that your sitemap is in the root of your website.
You can manually add your other pages by adding somthing
like the following for each link.

xml=xml & "<url><loc>http://www.genuineimitation.org</loc><lastmod>2005-09-14T03:49:53+00:00</lastmod><changefreq>daily</changefreq></url>"

(I'll add some commented out example ones to the code in the future)

You can find out more about the correct values for changefreq here if they don't change daily

http://www.google.com/webmasters/sitemaps/docs/en/protocol.html

You could also write code to extract the pages from your db and do it automatically.

Regarding Priority...

I think Google will index all pages on the sitemap regardless of priority. I could include it rather easily
in the code but how would you judge which pages are more important than the others? Personally I think that
topic.asp should be the most important as it carries the bulk of text. How about

default.asp 1.0
topic.asp 1.0
forum.asp 0.75
active.asp 0.75
pop_printer_friendly.asp 0.5
policy.asp 0.5
faq.asp 0.5
members.asp 0.1 (its restricted to logged in members)
search.asp 0.1 (virtually no text)

Whaddya think ?<

Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

muzishun
Senior Member

United States
1079 Posts

Posted - 14 September 2005 :  20:35:03  Show Profile  Visit muzishun's Homepage  Reply with Quote
I've actually already got the links added for the pages I wanted and some priorities set, but I was just offering suggestions for what to do if you decide to make it an official MOD and add Admin features to it. Maybe store additional pages in a table in the database. It's a thought.<

Bill Parrott
Senior Web Programmer, University of Kansas
Co-Owner and Code Monkey, Eternal Second Designs (www.eternalsecond.com)
Personal Website (www.chimericdream.com)
Go to Top of Page

Massimo
Junior Member

Italy
125 Posts

Posted - 03 October 2005 :  07:48:51  Show Profile  Visit Massimo's Homepage  Reply with Quote
Microsoft OLE DB Provider for ODBC Drivers error '80040e09'

[TCX][MyODBC]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '500 T.TOPIC_ID, T.T_LAST_POST FROM FORUM_TOPICS T, FORUM_FORUM

/forum/sitemap.xml.asp, line 79<

Massimo Farieri
Snitz Italian Community
===============
http://www.snitz.it
http://www.superdeejay.net/forum/

Go to Top of Page

NiteOwl
Junior Member

Canada
403 Posts

Posted - 13 October 2005 :  14:52:06  Show Profile  Visit NiteOwl's Homepage  Reply with Quote
Hi, I am using mySQL as database, as well as the latest snitz code and the latest code from Podge. When I accss my sitemap.xml.asp I receive this error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[MySQL][ODBC 3.51 Driver][mysqld-4.0.15-nt]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '500 T.TOPIC_ID, T.T_LAST_POST FROM FORUM_TOPICS T, FORUM_FORUM

/cimare/forum/sitemap.xml.asp, line 79

Marine Engineering Forum
<

-=NiteOwl=-

Edited by - NiteOwl on 13 October 2005 14:53:55
Go to Top of Page
Page: of 9 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000 Version 3.4.07