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
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 |
derekcohen wrote: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 |