Topic: Put last 5 posts off a certain topic in the First Page

[CarpoPT]

Hi!

I'm running SMF 1.1.11 and SP 2.3.1 and I wanted to add a block to show 200 characters off 5 recent posts off a certain topic.

As a news feed but I just can't find where can I use a block just for 1 topic...

Can you help me please?

Best Regards and a really happy new year for all of you 

[Nathaniel]

Sorry for the wait on this request.

Moved to the Custom Coding board.

Here is some simple code for a Custom PHP block that will do what you want, although its not very complicated and may not be exactly what you want.

Code: [Select]

global $db_prefix;

$topic = 2;
$limit = 5;

$request = db_query("
SELECT
m.body
FROM {$db_prefix}messages AS m
WHERE m.ID_TOPIC = $topic
ORDER BY m.ID_MSG
LIMIT " . $limit);
$posts = array();
while ($row = mysql_fetch_assoc($request))
{
$posts[]['body'] = parse_bbc($row['body']);
}
mysql_free_result($request);

$num_posts = count($posts);
foreach ($posts as $i => $post)
{
echo '
', $post['body'], '<br />', $i == $num_posts - 1 ? '' : '<hr />';
}