Latest Threads On Forum Home

[high]Installation Instructions[/high]

Step 1: Upload the .xml file to the Product Manager
Step 2: Modify the [high]FORUMHOME[/high] template
Find:

<td class="alt1" width="100%"><div class="smallfont">$upcomingevents</div></td>
	</tr>
</tbody>
</if>

Add below:

<!-- 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 -->

Step 3: Click [high]INSTALL[/high]

[high]Credits[/high]
NTLDR - For allowing me to port his vB3 hack of this

[high]Updates[/high]
Version 1.1.0: Simple update to make this work with vBulletin 3.5.0 Beta 2 - If you are installing for the first time, follow the installation instructions - If you are upgrading, please delete the previous plugin, and upload the new one - This new plugin also has the uncached template fix

Version 1.1.1: Simple update to fix a permissions bug - Wasn't showing on my board because I had already fixed it and forgot about it lol - To upgrade, simply replace the plugin with the one attached

Version 1.1.2: Simple update to fix a permissions bug again - To upgrade, simply replace the plugin with the one attached

Chris

[criscokid]

How can I get the usernames sisplayed in the 'Latest forum threads' section when clicked on to open in a new window?

[shaynehammy]

If i want to change the display name to "The latest 20 threads" or similar would i change the phrase after CDATA below?

<phrase name="latest_threads"><![CDATA[Latest Threads]]></phrase>
</phrasetype>
</phrases>
<options>
</options>
</product>

[Nick0r]

Unfortately Onkel_Tom, that made no difference. On 3.6 guests can still see private threads showing up in the 'Latest threads' section of the homepage.

[aveon]

does anybody know how to make this hack visible on all pages???

[Pathor]

<a href="http://www.vbulletin.com/forum/showthread.php?t=198968" target="_blank">http://www.vbulletin.com/forum/showthread.php?t=198968</a>

That´s also possible with this hack.

[aeroguy]

could some add a join table function as to also enable to show what forum the threads are in. The get thread function within the mod already sees the forum id just need a join to get the name from the id.

[Onkel_Tom]

Originally Posted by aeroguy

could some add a join table function as to also enable to show what forum the threads are in. The get thread function within the mod already sees the forum id just need a join to get the name from the id.

Should be done with:

PHP Code:

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


and to restrict the lenght add after:

PHP Code:

$thread['title'] = fetch_censored_text(fetch_trimmed_title(unhtmlspecialchars($thread['title']), 55)); 


PHP Code:

$thread['forumtitle'] = fetch_censored_text(fetch_trimmed_title(unhtmlspecialchars($thread['forumtitle']), 50)); 


To show the name of the forum you have to change the Template forumhome_latestthreadbit, add

PHP Code:

<a href="forumdisplay.php?$session[sessionurl]f=$thread[forumid]" title="go to $thread[forumtitle]">$thread[forumtitle] 


or something like that.

[aveon]

hey Tom it didnt work mate or did i do something wrong i added the codes where you wanted me to add them and the latest posts still only visible on forum home how can i set permissions and make it visivle on all pages helpme please and i will come up with a really good design for side column...

[putergirl]

Hello, I am having problems viewing the latest threads. Sometimes I can see it and sometimes I can't. I've tried clearing my cache and the cookies to no avail. Just when I give up, it will show again briefly, then poof, gone again. I mean, I had resined myself to not being able to see it, and it showed up an hour later after I did nothing. Any ideas what could be causing that? The same thing happens with my users, some can see it, some can't, and we didn't have this problem till I upgraded to 3.6. Thanks.

I have also tried re-importing the product and allowed overwrite.

[aeroguy]

i am too getting an mysql error

Invalid SQL:

## GET LATEST THREADS ##
SELECT thread.*,thread.iconid AS threadiconid , post.pagetext AS preview
FROM CT_thread AS thread
LEFT JOIN CT_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
LEFT JOIN CT_forum AS forum ON(forum.forumid = thread.forumid)
LEFT JOIN CT_post AS post ON(post.postid = thread.firstpostid)
WHERE open <> 10
AND forumid NOT IN (0)
AND thread.visible = '1'
AND deletionlog.primaryid IS NULL
ORDER BY lastpost