Is their a way to get Recent Posts from specific boards?

[panesarv]

Guys, I would to use the Recent Posts block to show posts only from specific boards. Is it possible to do so?

[Zetan]

You are probably better off creating a custom block.
I posted a snippet a while ago. I'll see if I can find the topic.

[Zetan]

Here you go:
http://www.tinyportal.net/index.php?topic=20698.msg169956#msg169956

There are other posts in the topic that you should read too.

[falguni1]

I posted a snippet a while ago. I'll see if I can find the topic.

I cant find snippet for post from particular board.
there are for post from all boards.

[Zetan]

I just posted it

[falguni1]

it shows a link wot to do to directly show the topics.

[falguni1]

this is for topics

http://www.tinyportal.net/index.php?topic=21125.0

[panesarv]

Ok I want this code [Latest Topics Created]

Code Select Expand

global $scripturl, $settings, $db_prefix, $user_info, $modSettings;

$bullet = '<img src="'.$settings['images_url'].'/TPdivider.gif" alt="" border="0" style="margin:0 4px 0 0;" />';

$list_count = 5;

$request = db_query("
SELECT
ms.subject AS firstSubject, ms.posterTime AS firstPosterTime, ms.ID_TOPIC, t.ID_BOARD, b.name AS bname
FROM ({$db_prefix}messages AS ms, {$db_prefix}topics AS t, {$db_prefix}boards AS b)
WHERE   t.ID_TOPIC = ms.ID_TOPIC
AND b.ID_BOARD = t.ID_BOARD " . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? " AND b.ID_BOARD != $modSettings[recycle_board]" : '') . "
AND ms.ID_MSG = t.ID_FIRST_MSG
AND " . $user_info['query_see_board'] . "
ORDER BY t.ID_FIRST_MSG DESC LIMIT " . $list_count, __FILE__, __LINE__);

echo '

I would like to take posts from these boards - 23.0, 24.0, 25.0

What kind of block do I use? (SSI, HTML+BBC, Script??? )

[Zetan]

PHP

[panesarv]

ok.

I would like to take posts from these boards - 23.0, 24.0, 25.0

How do I do that?