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.

[peterkohar]

why i have space above my first post in this widget ?
how to remove that.




thanks for the help, will appreciate it much

[Wordplay]

how do you change how old the threads can be before they stop showing there, and the number of threads to show in this widget?

[Wordplay]

Originally Posted by Wordplay

how do you change how old the threads can be before they stop showing there, and the number of threads to show in this widget?

anything anybody?

[Videx]

Originally Posted by Wordplay

how do you change how old the threads can be before they stop showing there, and the number of threads to show in this widget?

Did you look at the code? It's been a while for me, but there's a line "LIMIT 0, 10" that sure sounds like it's setting the output to 10; just lower it.

I don't think you can set a cutoff date easily. If you set the output to 5, it will get 5 regardless of dates.

[bada_bing]

anyway to make this ajax ?

[Videx]

Originally Posted by bada_bing

anyway to make this ajax ?

Depends on how skillful you are. Let us know if you manage it.

[Lazorbeam]

Originally Posted by peterkohar

why i have space above my first post in this widget ?
how to remove that.




thanks for the help, will appreciate it much

Link me to your forum and I can fix this. I had the same issue and resolved it, but I can't remember what I had to change. I will have to inspect your page.

[tonjohn]

The exclusion list should simply be added to the query, no?

Just move the line where you build the list before the query and add it to the WHERE clause.

[pportuese]

This work on 4.1.10?

[tsac]

Originally Posted by pportuese

This work on 4.1.10?

I'm running 4.1.10 and It's working just fine for Me.