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.

adreen · #32 03-04-2010, 05:56 AM

where is CMS in admincp?

Videx · #33 03-04-2010, 12:40 PM

Quote:

Originally Posted by adreen

where is CMS in admincp?

It should appear in the left menu. Mine is just below blogs and just above advertising.

alkrida · #34 03-04-2010, 01:51 PM

the arabic for it is :

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, 15 

"); 

$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="right"><font color="#CC0000" size="2" face="Tahoma"><a href="showthread.php?t='.    $recent_thread[threadid].'">'.    $recent_thread[title].'</a></font><br/>'; 

$toutput .='<font size="1" face="Tahoma">آخر مشاركة بواسطة: <a href="member.php?u='.$recent_thread[lastposterid].'">'.$recent_thread[lastposter].'</a></font><br/>'; 

$toutput .='<font size="1" face="Tahoma">قسم: <a href="forumdisplay.php?f='.$recent_thread[forumid].'">'.$recent_thread[forumtitle].'</a> | الردود: '.$recent_thread[replycount].'</font><br/>'; 

$toutput .='<font size="1" face="Tahoma">بتاريخ: <strong>'.$recent_thread[lastpostdate].'</strong> في: <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();

Videx · #35 03-04-2010, 03:16 PM

Quote:

Originally Posted by alkrida

the arabic for it is :

Be very careful. You have translated the broken one. This one will show ALL forums, regardless of a user's permissions. Better to use the second one which gives you an exclusion array.

Inflikted · #36 03-04-2010, 03:34 PM

im going to try my luck with vbadvanced for vbulletin 4.0. it seems there is alot more support and actual useful modules for it. buying the CMS package for vbulletin was a waste of money considering the lack of support for it.

RedHacker · #37 03-06-2010, 05:09 PM

Show the hidden threads... Can show the Unregisters\Registers usergroups....

Burnt · #38 03-07-2010, 05:20 PM

What if I wanted this to just take from one forum? What would I add/change to get that done?

Videx · #39 03-07-2010, 05:32 PM

It only has an exclusion array, so you would have to list all your other forums. Or just edit it and make the list inclusive. Take out the ! in "if (!in_array".

Fifth Dimension · #40 03-07-2010, 08:51 PM

This isn't working on my site. What I have done wrong? I copied and pasted the info into a new PHP widget, but all I see on the webpage is the text "03-07-2010" in the widget box.

Any ideas?

Videx · #41 03-08-2010, 12:33 AM

Quote:

Originally Posted by Fifth Dimension

This isn't working on my site. What I have done wrong? I copied and pasted the info into a new PHP widget, but all I see on the webpage is the text "03-07-2010" in the widget box.

Any ideas?

There's nothing in this code that should print a date without printing the hard coded word "Replies:". But who knows - you haven't even given us a link to look at. Can we assume you have no trouble putting up the default "Recent Posts" widget?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04704 seconds Memory Usage 2,376KB 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 (2)bbcode_php (3)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 (4)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 (1)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!