Forum v2 - "Left menu"

Posted on 28/06/2010 14:15:15

I have a page with the forum v2 - it seems to be working nicely ;)

However the client has requested the a block on the lefthand side of the page displays a list of categories, a list of the latest postings...

I thought that a could just insert a new page with the forum module and some other templates, but of course that page follows the main page, so any ideas??

Replies

Posted on 28/06/2010 15:05:17

Hi Martin

I would suggest to use the Data List module.
With this module you can use this SQL, which returns the last 15 threads:

select top (15) forumv2threadid, forumv2threadcategoryid, forumv2threadvoteid, forumv2threaduserid, forumv2threadheadline, forumv2threaddescription, forumv2threadtext, forumv2threaddate, forumv2threadclosed, forumv2threadsticky

from forumv2thread

where forumv2threadclosed = 0

order by forumv2threaddate desc

The output can then be styled with HTML or XSLT to suite your needs.

// Dammark

Posted on 28/06/2010 15:18:17

Damn... ;)

Thanx for the fast reply - was hoping to use it right out of the box ;)

You must be logged in to post in the forum

Developer forum

Forum v2 - "Left menu"

Replies