[Tim Simms]

I needed to be able to see the names of the forums in the list, so I modified it a bit... Here's the XML code:

<?xml version="1.0" encoding="ISO-8859-1"?>

<product productid="chrism_latestthreads" active="1">
	<title>Latest Threads on Forum Home</title>
	<description>This product will show the Latest Threads posted (using permissions) on your forumhome</description>
	<version>1.1.2</version>
	<codes>
	</codes>
	<templates>
		<template name="forumhome_latestthreadbit" templatetype="template" date="1129992702" username="Chris M" version="3.5.0"><![CDATA[<div class="smallfont">
	<if condition="$show['firstnew']">
		<a href="showthread.php?t=$thread[threadid]&amp;goto=newpost"><img src="$stylevar[imgdir_button]/firstnew.gif" alt="$vbphrase[go_to_first_new_post]" border="0" /></a>
	</if>
	<if condition="$show['icon'] && !$show['firstnew']">
		<img src="$vboptions[bburl]/$thread[threadiconpath]" border="0" alt="$thread[threadicontitle]" title="$thread[threadicontitle]" style="vertical-align: text-middle" /> 
	</if>
	<a href="showthread.php?t=$thread[threadid]" title="$thread[preview]"><strong>$thread[title]</strong></a>
	<em>$vbphrase[last_post]:</em> $thread[date] <if condition="$vboptions['yestoday'] != 2"><span class="time">$thread[time]</span></if> <phrase 1="member.php?find=lastposter&amp;t=$thread[threadid]" 2="$thread[lastposter]">$vbphrase[by_x]</phrase>
	&raquo; $vbphrase[replies]: $thread[replycount]
	&raquo; $vbphrase[views]: $thread[views]
</div>]]></template>
	</templates>
	<plugins>
		<plugin active="1">
			<title>Latest Threads on Forum Home</title>
			<hookname>cache_templates</hookname>
			<phpcode><![CDATA[global $globaltemplates;

$globaltemplates = array_merge($globaltemplates, array('forumhome_latestthreadbit'));]]></phpcode>
		</plugin>
		<plugin active="1">
			<title>Latest Threads on Forum Home</title>
			<hookname>forumhome_complete</hookname>
			<phpcode><![CDATA[// #################### PROCESS LATEST THREADS #######################
// fetch the permissions for each forum
global $vbulletin;

$forumperms = array();
foreach($vbulletin->forumcache AS $forum) {

	$forumperms[$forum["forumid"]] = fetch_permissions($forum['forumid']);

	// ## HIDE FORUMS WITHOUT THE CANVIEW PERMISSION ##
	if (!($forumperms[$forum["forumid"]] & $vbulletin->bf_ugp_forumpermissions['canview']) AND !$vbulletin->options['showprivateforums']) {
		$limitfids .= ','.$forum['forumid'];
	}
}
unset($forum);

if ($vbulletin->options['threadpreview'] > 0) {
	$previewfield = ', post.pagetext AS preview';
	$previewjoin = 'LEFT JOIN '.TABLE_PREFIX.'post AS post ON(post.postid = thread.firstpostid)';
}

$getthreads = $db->query_read("
	## GET LATEST THREADS ##
	SELECT thread.*,forum.title AS forumtitle,thread.iconid AS threadiconid $previewfield
	FROM ".TABLE_PREFIX."thread AS thread
	LEFT JOIN ".TABLE_PREFIX."deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
	$previewjoin, 
	".TABLE_PREFIX."forum AS forum WHERE forum.forumid = thread.forumid
	AND open <> 10
	AND thread.forumid NOT IN (0$limitfids)
	AND thread.visible = '1'
	AND deletionlog.primaryid IS NULL
	ORDER BY lastpost
	DESC LIMIT 5");

while($thread = $db->fetch_array($getthreads)) {

	$threads = true;
	$thread['title'] = fetch_censored_text(fetch_trimmed_title(unhtmlspecialchars($thread['title']), 22));
	$thread['date'] = vbdate($vbulletin->options['dateformat'], $thread['lastpost'], 1);
	$thread['time'] = vbdate($vbulletin->options['timeformat'], $thread['lastpost']);
	$thread['preview'] = preg_replace('#\[quote(=(&quot;|"|\'|).*\\2)?\](.*)\[/quote\]#siU', '', $thread['preview']);
	$thread['preview'] = htmlspecialchars_uni(fetch_trimmed_title(strip_bbcode(fetch_censored_text($thread['preview']), false, true), $vbulletin->options['threadpreview']));
	$thread['replycount'] = vb_number_format($thread['replycount']);
	$thread['views'] = vb_number_format($thread['views']);

	// thread icon
	$show['icon'] = false;
  $icon = fetch_iconinfo($thread['iconid']);

  if (is_array($icon)) {
      $show['icon'] = true;
      $thread['threadiconpath'] = $icon['iconpath'];
      $thread['threadicontitle'] = $icon['title'];
  }

	// show goto new post
	$show['firstnew'] = false;
	$bbforumview = fetch_bbarray_cookie('forum_view', $thread['forumid']);

	if ($bbforumview > $vbulletin->userinfo['lastvisit']) {
		$lastread = $bbforumview;
	} else {
		$lastread = $vbulletin->userinfo['lastvisit'];
	}

	if ($thread['lastpost'] > $lastread) {

		$threadview = fetch_bbarray_cookie('thread_lastview', $thread['threadid']);

		if ($thread['lastpost'] > $threadview) {
			$show['firstnew'] = true;
			$show['icon'] = false;
		}
	}

	exec_switch_bg();

	eval("\$threadbits .= \"".fetch_template('forumhome_latestthreadbit')."\";");
}
if ($threads) {
	$show['latestthreads'] = true;
}
// memory saving
unset($thread, $threads);
$db->free_result($getthreads);]]></phpcode>
		</plugin>
	</plugins>
	<phrases>
		<phrasetype name="GLOBAL" fieldname="global">
			<phrase name="latest_threads"><![CDATA[Latest Threads]]></phrase>
		</phrasetype>
	</phrases>
	<options>
	</options>
</product>

Then, in the FORUMHOME, here's the Lastest Threads section:

PHP Code:

<!-- latest threads -->
<if condition="$show['latestthreads']">
<tbody>
    <tr>
        <td class="thead" colspan="2">
            <a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_latestthreads')"><img id="collapseimg_forumhome_latestthreads" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_forumhome_latestthreads].gif" alt="" border="0" /></a>
            $vbphrase[latest_threads]
        </td>
    </tr>
</tbody>
<tbody id="collapseobj_forumhome_latestthreads" style="$vbcollapse[collapseobj_forumhome_latestthreads]">
    <tr>
        <td class="alt2"><img src="$stylevar[imgdir_statusicon]/forum_new.gif" alt="$vbphrase[latest_threads]" /></td>
        <td class="alt1"><div class="smallfont">$threadbits</div></td>
    </tr>
</tbody>
</if>
<!-- /latest threads --> 


Worked like a charm!