The Arcive of Official vBulletin Modifications Site.

[WIDGET] Recent Threads · **Released**: 02-19-2010

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.

ibwt · #**132** 02-12-2012, 02:08 AM

how to do it to show for specific forums only ?

PowerboatNation · #**133** 03-29-2012, 09:52 PM

I apologize for bumping this but does anyone know if it would be possible to pull off showing the forums instead of the threads? I've provided a roughly photoshoped image to explain.

John Lester · #**134** 08-03-2012, 05:11 AM

Works for me on 4.1.12

barnsi · #**135** 08-08-2012, 02:15 PM

Great Work, thank you!

To get the prefix to be shown to the recent thread add:

PHP Code:


			
$recent_thread[prefix_rich] = $vbphrase["prefix_$recent_thread[prefixid]_title_rich"];

$toutput .=''.$recent_thread[prefix_rich].' ';

Widget new:

PHP Code:


			
ob_start(); 

global $vbulletin, $db, $vbphrase; 

//Begin Thread Counts  

$toutput='';  

$recent_threads = $vbulletin->db->query_read("  

SELECT thread.threadid, thread.prefixid, 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, 20  

");  

$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('j. F Y', $recent_thread[lastpost], 1);  

$recent_thread[lastposttime] = vbdate($vbulletin->options['timeformat'], $recent_thread[lastpost]);

$recent_thread[prefix_rich] = $vbphrase["prefix_$recent_thread[prefixid]_title_rich"];



$toutput .='<tr><td class="'.$class.'" align="left"><font size="2" face="verdana,arial"><a href="forumdisplay.php?f='.$recent_thread[forumid].'">'.$recent_thread[forumtitle].'</a></font><br/>';  



if('.$recent_thread[prefixid].' <> '')

$toutput .=''.$recent_thread[prefix_rich].' ';



$toutput .='<b><font color="#98B5E2" size="2" face="verdana,arial"><a href="showthread.php?t='.    $recent_thread[threadid].'">'.    $recent_thread[title].'</a></font></b><br/>';  

$toutput .='<font size="1" face="verdana,arial">letzter Eintrag von: <a href="member.php?u='.$recent_thread[lastposterid].'">'.$recent_thread[lastposter].'</a></font><br/>';  

$toutput .='<font size="1" face="verdana,arial">am <strong>'.$recent_thread[lastpostdate].'</strong> um <strong>'.    $recent_thread[lastposttime].'</strong> Uhr</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();

Draffi · #**136** 10-24-2012, 09:16 PM

Please, have somebody an idea how to put the last posts (not topics) inside this widget and have somebody a version what shows the avatars?

Thank you in advance

John Lester · #**137** 10-31-2012, 07:08 PM

Ok so it turns out that none of the forums in the array are being excluded, anyone know why?

Here's my widget code;

<snip> see reply

John Lester · #**138** 10-31-2012, 09:02 PM

Ok so I missed a page while reading through the thread and found the fix

My widget code looks like this (for those that still have the same issue) ...

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 forum.forumid not in(4,5,6,7,8,126,127,128,129,132,133) 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 ($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();

fungku · #**139** 12-30-2012, 06:52 PM

Quote:

Originally Posted by GONUMBER6

Can this widget be placed on a regular site page (not in vb)? I would like a widget of recent threads on my home page at www.englishbulldognews.com

Thanks!

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

RichieBoy67 · #**140** 01-17-2013, 04:55 PM

I would like to display this widget in the center with a large portion of the posts showing. Is this possible?

t18ftw · #**141** 04-15-2013, 01:40 AM

thank you for this widget

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05124 seconds Memory Usage 2,390KB Queries Executed 26 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)bbcode_code (3)bbcode_php (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (4)navbar_link (120)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)pagenav_pagelinkrel (11)post_thanks_box (1)post_thanks_box_bit (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit (11)post_thanks_postbit_info (10)postbit (2)postbit_attachment (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start fetch_musername post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end post_thanks_function_fetch_thanks_bit_start post_thanks_function_show_thanks_date_start post_thanks_function_show_thanks_date_end post_thanks_function_fetch_thanks_bit_end post_thanks_function_fetch_post_thanks_template_start post_thanks_function_fetch_post_thanks_template_end postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_attachment postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

Благодарность от:
psd_hunter

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!