| Author |
 Topic  |
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
borge
Junior Member
Norway
185 Posts |
 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!  < |
borge |
 |
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
bobby131313
Senior Member
USA
1163 Posts |
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.
< |
Switch the order of your title tags |
|
|
|
Lon2
Junior Member
USA
151 Posts |
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?< |
Edited by - Lon2 on 12 February 2009 11:50:19 |
|
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
sikandar
Junior Member
Pakistan
135 Posts |
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 |
|
|
|
sikandar
Junior Member
Pakistan
135 Posts |
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 |
|
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
Topic |
|
Google Sitemaps Mini-mod (Beta)
