vBulletin CMS Widgets - [WIDGET] Recent Threads

In an attempt at mirroring an old ASP website I used to have, I modified the recent threads display to show a bit more information in a bit more compressed format.

Feel free to use/hack/slash this code for your own needs...

Navigate to AdminCP -> CMS -> Widgets.
Create a PHP Type Widget and paste the below code.

READ BELOW THE CODE FOR AN UPDATE

PHP Code:

ob_start();
global $vbulletin, $db;
//Begin Thread Counts 
$toutput=''; 
$recent_threads = $vbulletin->db->query_read(" 
SELECT thread.threadid, thread.title, thread.dateline, thread.lastpost, thread.lastposter, thread.lastposterid, thread.visible, thread.open, thread.postusername, thread.postuserid, thread.replycount, thread.views, forum.forumid, forum.title as forumtitle
FROM  " . TABLE_PREFIX . "thread AS thread 
LEFT JOIN  " . TABLE_PREFIX . "forum AS forum ON ( forum.forumid = thread.forumid ) 
WHERE NOT ISNULL(threadid) AND visible = '1' AND open!='10' 
ORDER BY lastpost DESC 
LIMIT 0, 10 
"); 
$i = 0; 
while ($recent_thread = $db->fetch_array($recent_threads)) 
{ 
$i++;
if (!in_array($recent_thread[forumid], array(105,83,121,110,82,112,109,101,102,72))) { 
if ($i & 1) {$class='alt1';} else {$class='alt2';} 
$recent_thread[title] = unhtmlspecialchars($recent_thread[title]); 
$recent_thread[lastpostdate] = vbdate('M jS', $recent_thread[lastpost], 1); 
$recent_thread[lastposttime] = vbdate($vbulletin->options['timeformat'], $recent_thread[lastpost]); 
$toutput .='<tr><td class="'.$class.'" align="left"><b><font color="#98B5E2" size="1" face="verdana,arial"><a href="showthread.php?t='.    $recent_thread[threadid].'">'.    $recent_thread[title].'</a></font></b><br/>'; 
$toutput .='<b><span style="color: #E1E1E2"><font size="1" face="verdana,arial">Last Post By: <a href="member.php?u='.$recent_thread[lastposterid].'">'.$recent_thread[lastposter].'</a></font><br/></span></b>'; 
$toutput .='<font size="1" face="verdana,arial">Forum: <a href="forumdisplay.php?f='.$recent_thread[forumid].'">'.$recent_thread[forumtitle].'</a> | Replies: '.$recent_thread[replycount].'</font><br/>'; 
$toutput .='<font size="1" face="verdana,arial">Posted: <strong>'.$recent_thread[lastpostdate].'</strong> at: <strong>'.    $recent_thread[lastposttime].'</strong></font><hr/></td></tr>'; 
} 
}
//End Thread Counts 

//Sidebar - Begin Forum Threads
$sb_threads = '
<table class="tborder" cellpadding="'.$stylevar[cellpadding].'" cellspacing="'.$stylevar[cellspacing].'" border="0" width="100%" align="center"> <thead> <tr> <td class="tcat"></td> </tr> </thead> <tbody> <div class="smallfont"> <tr> <td>
'.$toutput.'
</td> </tr> </div> </tbody> </table>
';
//Sidebar - End Forum Threads
echo $sb_threads;
$db->free_result($recent_threads);
$output=ob_get_contents();
ob_end_clean(); 


Updated to reflect contribution from Inflikted:
https://vborg.vbsupport.ru/showpost....7&postcount=25

Be SURE to update the following line:if (!in_array($recent_thread[forumid], array(105,83,121,110,82,112,109,101,102,72))), to group the forumids you wish to NOT have included in the query results.

[Videx]

Originally Posted by AnthemToGod

How to hide some forums id ?

widget displays all forum threads but I have some invisible area on my forum... how to except some id's ?

You have incorrectly used the code in the first post instead of reading through the thread and using the code in https://vborg.vbsupport.ru/showpost....7&postcount=25 that includes an exclusion array.

I have no idea why the author hasn't yet updated the first post or at least mentioned the exclusion option.

[cory_booth]

Originally Posted by Videx

You have incorrectly used the code in the first post instead of reading through the thread and using the code in https://vborg.vbsupport.ru/showpost....7&postcount=25 that includes an exclusion array.

I have no idea why the author hasn't yet updated the first post or at least mentioned the exclusion option.

Sorry ya'll...

I will get that updated... I am currently retiring from the military, establishing a new home, and looking for a J.O.B. while also trying to finish up my degree. LOL... I miss a lot of the posts sometimes.

[Videx]

Thanks! Yes, we all understand B.U.S.Y.! But while you're updating, you may also want to mention that removing the ! from that line will make it an inclusion list.

[Dr.osamA]

thanxx installed + 5 stars

[janaf]

Installed! Worknig out of the box!

(Yes, to use this widget, your create a new PHP direct execusion widget, save it, open Configure link for it, copy and past the code (may 13:th 2010) unchanged)

Someone with more vB knowledge than me could surely change the SQL query so that only the postings that the current user has rigts to see, will be displayed. Then members of restricted forums could also see those postings from those forums.

[Pangramma]

Hey, it's any way possible to show the "go to last post" button?

Great alternative for default VB widget, installed!

[Katoona]

I would also like "go to latest post" option, and I was also wondering if it is possible to change the code so that it shows recent threads from one spesific user (I really need this for some sub-pages I am making).

I would really appreciate any help making this possible.

[alfisti]

I have vb 4.0.3 and the vb_date is not working, only the time is working.

In the position of the date, it shows always M jS.

Any ideas??
Thanks

[Fixed]

[GONUMBER6]

It seems the widget is configured to pull out the last 24 hours of threads. My forum is not that busy yet (hopefully soon), can we pull 2 days worth instead? How do I change that?

Go to last post button would be nice too.

[wanno]

Originally Posted by alfisti

I have vb 4.0.3 and the vb_date is not working, only the time is working.

In the position of the date, it shows always M jS.

Any ideas??
Thanks

[Fixed]

Put the code in Configure.