Author |
Topic |
jeffery
Junior Member
USA
176 Posts |
|
Podge
Support Moderator
Ireland
3775 Posts |
|
jeffery
Junior Member
USA
176 Posts |
Posted - 28 July 2005 : 19:20:48
|
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 |
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
jeffery
Junior Member
USA
176 Posts |
Posted - 29 July 2005 : 08:33:41
|
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 |
|
|
wildfiction
Junior Member
167 Posts |
Posted - 04 August 2005 : 06:27:58
|
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. < |
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
Podge
Support Moderator
Ireland
3775 Posts |
|
muzishun
Senior Member
United States
1079 Posts |
Posted - 13 September 2005 : 23:46:03
|
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) |
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
muzishun
Senior Member
United States
1079 Posts |
Posted - 14 September 2005 : 10:18:50
|
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) |
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
muzishun
Senior Member
United States
1079 Posts |
Posted - 14 September 2005 : 20:35:03
|
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) |
|
|
Massimo
Junior Member
Italy
125 Posts |
Posted - 03 October 2005 : 07:48:51
|
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/
|
|
|
NiteOwl
Junior Member
Canada
403 Posts |
Posted - 13 October 2005 : 14:52:06
|
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 |
|
|
Topic |
|