| T O P I C R E V I E W |
| Podge |
Posted - 01 July 2005 : 17:57:12
This should plug and play into most Snitz forums. Tested on v3.4.05
Not fully finished but it works. Based on the original rssfeed.asp by Richard Kinser (uses getrows so its fast).
Demo here
Code here
Stylesheet here - http://demo.forumco.com/sitemap.xsl
MySql Verision here
Save the text file as sitemap.xml.asp and upload to your main forum directory.
Submit to Google here - https://www.google.com/webmasters/sitemaps/stats
I'm still waiting for Google to validate my sitemap but it validated ok with another validator so it should be ok.
Currently it lists all those topics not in private forums. I will add default.asp, forum.asp, etc. later
Should I add members.asp and all of the members pages? e.g. http://forum.snitz.com/forum/pop_profile.asp?mode=display&id=1049
For bugs, issues, feature requests, suggestions etc., please reply here.
< |
| 15 L A T E S T R E P L I E S (Newest First) |
| Podge |
Posted - 07 November 2012 : 14:35:38
You can change the order by or limit if that's what you want.
I'm not sure why you would want to "search by title" ? The sitemap if for search engines like google so that they index the topics you think are important. The link to the topic is what's important, the search engine will follow it and index it as normal. |
| sikandar |
Posted - 01 November 2012 : 00:42:17
One more thing I would like to know is that currently the query is picking 500 topics from the list which is sorted on topic ID descending means recently created topics,
strSql = "select T.TOPIC_ID, T.T_LAST_POST FROM " & strTablePrefix & "TOPICS T, " & strTablePrefix & "FORUM F WHERE T.FORUM_ID = F.FORUM_ID AND
F.F_PRIVATEFORUMS = 0"
strSql = strSql & " ORDER BY TOPIC_ID DESC LIMIT 0,500"
do you suggest we should change this limit and also if we should change on order by from topic_id to any other field like last_update_date or number of visits....etc
tks |
| sikandar |
Posted - 31 October 2012 : 23:57:50
Hi Podge,
Thanks for your kind efforts to make it happen. Just one thing I would like to know that sitemap is good with topic name/title or ID,
topic.asp?TOPIC_ID=9917
as in this case topics cannot be searched on subject of the title? Your input please...since I am using sitemap first time so might be not a valid question.
tks |
| Podge |
Posted - 12 February 2009 : 12:21:13
You could write a stored procedure. The best way would be to generate xml files and update them periodically. If you increase the time out on the asp page you could run the script, save the result as sitemap.xml. Then upload it to your server on a weekly basis and point google to it (as opposed to the sitemaps.xml.asp file).< |
| Lon2 |
Posted - 11 February 2009 : 20:38:50
Noob here. Not sure if this has been covered before but is there any way to run a TSQL or SQL Query directly on the database to avoid time-out issues with ASP and capture more URLs?< |
| bobby131313 |
Posted - 27 January 2007 : 12:47:38
Has anyone adjusted the code yet to include archived topics? It was discussed a little on this page, but I haven't seen that anyone actually did it.
< |
| Podge |
Posted - 26 January 2007 : 14:34:30
De nada, mate.< |
| borge |
Posted - 26 January 2007 : 14:32:07
quote:
Originally posted by Podge
Borge, change this line
strSql = "select top 500 T.TOPIC_ID, T.T_LAST_POST FROM <snipped>
to
strSql = "select T.TOPIC_ID, T.T_LAST_POST FROM <snipped>
That should return all topics, not just the top 500.
Thanks podge, I owe you a pint, slainte!  < |
| Podge |
Posted - 26 January 2007 : 08:28:32
Borge, change this line
strSql = "select top 500 T.TOPIC_ID, T.T_LAST_POST FROM <snipped>
to
strSql = "select T.TOPIC_ID, T.T_LAST_POST FROM <snipped>
That should return all topics, not just the top 500.< |
| bobby131313 |
Posted - 24 January 2007 : 19:06:11
Podge, thank you so much for this, it saves me a lot of work.
On broadband with IE7 I can generate a sitemap with all of my 10,000 plus topics in about 10 seconds then just File > Save as > and upload. It validates within minutes. I'll just do it every few days.
Thank you!
< |
| grazman |
Posted - 24 January 2007 : 16:41:30
A very interesting script. Has there been any thought given to topics that have multiple pages? Do we need to have each page listed in the site map?< |
| borge |
Posted - 22 January 2007 : 18:07:25
|
| SnapperL |
Posted - 02 August 2006 : 14:46:06
ahhh makes sense... ill try that< |
| Podge |
Posted - 02 August 2006 : 13:22:42
I cannot see anything wrong with most of the dates, but for forums with no posts, this is the time shown - --T::+00:00 (which is invalid)
Either make a post in each of the empty forums or change this
showForums = "true" ' set to true or false if you want forum.asp pages to be shown or not shown
to this
showForums = "false" ' set to true or false if you want forum.asp pages to be shown or not shown
< |
| SnapperL |
Posted - 02 August 2006 : 12:54:22
i'm getting an invalid time error from google....
quote:
Invalid date (Line 2) An invalid date was found. Please see How do I specify time? for more information before resubmitting. More
Invalid date (Line 3) An invalid date was found. Please see How do I specify time? for more information before resubmitting. More
Invalid date (Line 4) An invalid date was found. Please see How do I specify time? for more information before resubmitting. More
Invalid date (Line 6) An invalid date was found. Please see How do I specify time? for more information before resubmitting. More
Invalid date (Line 11) An invalid date was found. Please see How do I specify time? for more information before resubmitting. More
Invalid date (Line 14) An invalid date was found. Please see How do I specify time? for more information before resubmitting. More
Invalid date (Line 15) An invalid date was found. Please see How do I specify time? for more information before resubmitting. More
Invalid date (Line 19) An invalid date was found. Please see How do I specify time? for more information before resubmitting. More
Invalid date (Line 20) An invalid date was found. Please see How do I specify time? for more information before resubmitting. More
Invalid date (Line 29) An invalid date was found. Please see How do I specify time? for more information before resubmitting. More
This is happening on every instance of the time
any thoughts?< |
