Print Page | Close Window

Recent topics

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=27617
Printed Date: 02 April 2026 at 2:16pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Recent topics
Posted By: derekcohen
Subject: Recent topics
Date Posted: 25 July 2009 at 6:44am
On the home page of my site I'd like to place a summary of the ten most recent active topics in the forum with the links taking people to the relevant topic displayed in a new window.

Is there an easy way of doing this? I supose what I need is the sql query and the format of the URL for each topic.

It would be good if the forum window showed the last posting in the topic rather than the first but that is a "nice to have" rather than essential.

thanks

Derek



Replies:
Posted By: WebWiz-Bruce
Date Posted: 25 July 2009 at 9:07am
Copy and paste the code from the file extras/recent_forum_posts.asp into the homepage of your website.

The only thing you will need to change in the code you copy and paste is to change the link to your own forums RSS Feed, but it should be fairly straight forward.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: Scotty32
Date Posted: 25 July 2009 at 12:04pm
There is also my http://www.s2h.co.uk/wwf/mods/latest-topics/" rel="nofollow - Latest Topics modification.

The difference between the 'extras' and my mod is that the 'extras' shows a topic multiple times for each post, where as my modification will only show a topic once, based on the last post to the topic.

You can see a demo on http://www.s2h.co.uk/forum/default.asp" rel="nofollow - my forum here
(The 'Powered By' link is not on the mod)


-------------
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: derekcohen
Date Posted: 25 July 2009 at 12:06pm
Bruce

If I put the full URL in the file:
strWebWizForumsURL = "http://www.mydomain.net/forum/RSS_topic_feed.asp"

then I get

msxml3.dll error '80070005'

Access is denied.

/forum/extras/recent_forum_posts.asp, line 68

If I put a relative URL:
strWebWizForumsURL = "/forum/RSS_topic_feed.asp"

I get

Error:
The system cannot find the path specified.

Any ideas

Thanks

Derek



Posted By: derekcohen
Date Posted: 25 July 2009 at 12:09pm
Scotty

Yours won't work as all my forums are restricted to registered users and the latest topics will only be shown once they've logged in to the parent web site.

Thanks anyway.

Derek


Posted By: Scotty32
Date Posted: 25 July 2009 at 12:24pm
I believe the RSS feed works in exactly the same way.

Though the next version of my mod will hopefully show based on permissions.


-------------
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: WebWiz-Bruce
Date Posted: 27 July 2009 at 8:52am
Originally posted by derekcohen derekcohen wrote:

Bruce

If I put the full URL in the file:
strWebWizForumsURL = "http://www.mydomain.net/forum/RSS_topic_feed.asp"

then I get

msxml3.dll error '80070005'

Access is denied.

/forum/extras/recent_forum_posts.asp, line 68

If I put a relative URL:
strWebWizForumsURL = "/forum/RSS_topic_feed.asp"

I get

Error:
The system cannot find the path specified.

Any ideas

Thanks

Derek



The error means that you do not have permission to use the MS HTTP XML Object. You should contact your web host about this error.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: derekcohen
Date Posted: 27 July 2009 at 9:06am
I do have access to the MS HTTP XML Object (if I understand you correctly) as I use Ajax extensively


Posted By: WebWiz-Bruce
Date Posted: 27 July 2009 at 9:27am
AJAX is done by JavaScript on the client side. This is done using ASP on the server side. The error message for the msxml3.dll of access denied means that you do not have the correct permissions on the server to use this object.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: derekcohen
Date Posted: 27 July 2009 at 9:42am
Bruce

thanks for the explanation.

As it will only show public threads anyway I may hand roll my own query/page. What's the easiest way of finding the most recently active ten topics?

thanks

Derek



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net