openside("Ergo Café");



$result = dbquery("

SELECT tt.thread_id, tt.thread_subject, tp.post_message, tp.post_datestamp, tf.forum_name

FROM ".DB_FORUMS." tf

JOIN ".DB_THREADS." tt ON tf.forum_id = tt.forum_id

JOIN ".DB_POSTS." tp ON tt.thread_id = tp.thread_id

WHERE tf.forum_id = 34

ORDER BY tp.post_datestamp 

DESC LIMIT 0,".$settings['numofthreads']);



if (dbrows($result)) {

	while($data = dbarray($result)) {



		$itemname = $data['forum_name'];

		$itemsubject = trimlink($data['thread_subject'], 30);

		$itemmessage = trimlink($data['post_message'], 250);

		$itemmessage = nl2br(parseubb($data['post_message'], "b|u|i|quote|img|url|small|code|list|mail|font|center|color|list|"));

		if ($data['post_message']) { 

		$itemmessage = parsesmileys($data['post_message']); }

		echo "$itemname: <a href='".FORUM."viewthread.php?thread_id=".$data['thread_id']."' title='".$data['thread_subject']."' class='side'><br /><strong><span style='color:#990000'>$itemsubject</span></strong></a><br />$itemmessage 

<a href='".FORUM."viewthread.php?thread_id=".$data['thread_id']."' title='".$data['thread_subject']."' class='side'><em>L&aelig;s mere</em>...</a><br /><br /><hr /><br />\n";

	}

} else {

	echo "<div style='text-align:center'>".$locale['global_023']."</div>\n";

}



closeside();?>