Feature #33064
list latest posts from configured forum only
| Status: | Needs Feedback | Start date: | 2012-01-09 | |
|---|---|---|---|---|
| Priority: | Should have | Due date: | ||
| Assignee: | - | % Done: | 0% |
|
| Category: | Forum | |||
| Target version: | 1.10.0 | |||
| Votes: | 0 |
Description
i want to show the latest posts of a selected forum only, not from all forums. this should be quite easy to implement as it is just a typoscript configuration and extending the SQL for f.uid=x
History
Updated by Simon Schaufelberger over 1 year ago
here an example patch:
//patch start
$forum_id = (isset($this->conf['listLatest.']['forum_id'])) ? ' AND f.uid = '.intval($this->conf['listLatest.']['forum_id']).' ' : '';
//patch end
$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
't.topic_last_post_id as post_id, t.uid as topic_id, t.*,
f.uid as forum_id, f.forum_name as forum_name,
c.forum_name as category_name,
p.poster_id as author, p.post_time',
'tx_mmforum_posts p, tx_mmforum_forums f, tx_mmforum_forums c, tx_mmforum_topics t',
't.uid = p.topic_id AND
p.uid = t.topic_last_post_id AND
f.uid = p.forum_id AND
c.uid = f.parentID AND
p.deleted = 0 AND t.deleted = 0 AND f.deleted = 0 AND c.deleted = 0 AND
p.hidden = 0 AND t.hidden = 0 AND f.hidden = 0 AND c.hidden = 0 '.
//patch start
$forum_id.
//patch end
$this->getMayRead_forum_query('f').
$this->getMayRead_forum_query('c').
$this->getCategoryLimit_query('c'),
'p.topic_id',
'p.post_time DESC',
$limit
);
but a comma separated list would even be better.
Updated by Ines Willenbrock 10 months ago
- Status changed from New to Needs Feedback
Hi Simon,
have you done anything about this?
I'd like to see that configuration in the content element, maybe similar to the topic selection?
regards - Ines
Updated by Ines Willenbrock 9 months ago
- Target version set to 1.10.0
I'd like to postphone this until 1.10.
regards - Ines