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.

[tort]

Where do you put this in?

[cory_booth]

PHP Widget in the CMS

[zbosskiller]

Create a new CMS PHP Widget mate.

[zbosskiller]

Great little widget Cody, thx.

Any chance you could make this so it works as a centre widget? i.e. above the Articles?

At the moment it is all right sided, which is correct for a sideblock.

If you have any time to do it I'd appreciate it.

Thx

Z

[cory_booth]

Originally Posted by zbosskiller

Great little widget Cody, thx.

Any chance you could make this so it works as a centre widget? i.e. above the Articles?

At the moment it is all right sided, which is correct for a sideblock.

If you have any time to do it I'd appreciate it.

Thx

Z

Hmmm....
You mean just center all the text?

PHP Code:

$toutput .='<tr><td class="'.$class.'" align="left"> 


PHP Code:

$toutput .='<tr><td class="'.$class.'" align="center"> 


[zbosskiller]

It more so something like a block that has a header, in the header it shows

'Thread' | 'Posted By' | 'Views' | 'Last Post''

This is probably a lot of work but thought I would ask as its what I was used to with VB 3.8.4

[cory_booth]

Oh, gotcha - I know what you mean...

And believe it or not, I had something like that running but dumped it a long time ago.
(just experimenting)...

I'll see what I can scratch up...

[zbosskiller]

Thx, really appreciate it!

[cory_booth]

Hey I was thinking....
What if you put this in as a Widget...

https://vborg.vbsupport.ru/showthread.php?t=235841

You could turn off some of the areas and it would act as a threads module...

I don't have it installed, but try making a JS Enhanced Widget
Make a new template and insert:

{vb:raw vsatopstats}