Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Recent topics
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Recent topics

 Post Reply Post Reply Page  12>
Author
derekcohen View Drop Down
Groupie
Groupie


Joined: 25 July 2009
Status: Offline
Points: 25
Post Options Post Options   Thanks (0) Thanks(0)   Quote derekcohen Quote  Post ReplyReply Direct Link To This Post Topic: Recent topics
    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
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
Scotty32 View Drop Down
Moderator Group
Moderator Group


Joined: 30 November 2002
Location: Manchester, UK
Status: Offline
Points: 1682
Post Options Post Options   Thanks (0) Thanks(0)   Quote Scotty32 Quote  Post ReplyReply Direct Link To This Post Posted: 25 July 2009 at 12:04pm
There is also my 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 my forum here
(The 'Powered By' link is not on the mod)
S2H.co.uk - WebWiz Mods and Skins

For support on my mods + skins, please use my forum.
Back to Top
derekcohen View Drop Down
Groupie
Groupie


Joined: 25 July 2009
Status: Offline
Points: 25
Post Options Post Options   Thanks (0) Thanks(0)   Quote derekcohen Quote  Post ReplyReply Direct Link To This Post 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



Edited by derekcohen - 25 July 2009 at 12:09pm
Back to Top
derekcohen View Drop Down
Groupie
Groupie


Joined: 25 July 2009
Status: Offline
Points: 25
Post Options Post Options   Thanks (0) Thanks(0)   Quote derekcohen Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
Scotty32 View Drop Down
Moderator Group
Moderator Group


Joined: 30 November 2002
Location: Manchester, UK
Status: Offline
Points: 1682
Post Options Post Options   Thanks (0) Thanks(0)   Quote Scotty32 Quote  Post ReplyReply Direct Link To This Post 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 - WebWiz Mods and Skins

For support on my mods + skins, please use my forum.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
derekcohen View Drop Down
Groupie
Groupie


Joined: 25 July 2009
Status: Offline
Points: 25
Post Options Post Options   Thanks (0) Thanks(0)   Quote derekcohen Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.