vBulletin CMS Widgets - Widget: Latest Articles In Section

Latest Articles In Section

What is does:
vBCMS only has one option for latest articles and that is all sections and categories. This widget will allow you to display the latest articles in a specific section.

Change Log:
1.0 - Initial Release
1.1 - Updated to allow more than one section & display published date.
1.2 - Small update, no need to update unless you are using a table prefix.
1.3 - Added full page text if no previewtext row exists.
1.4 - Updated to not show unpublished articles.
1.5 - Updated read more link to look more vBulletin related.
1.6 - Small change to fix 4.0.2 [ATTACH] showing in text.

Installation:

• Goto AdminCP-vBullietin CMS-Widgets->Create New Widget
• Choose PHP Direct Execution as Widget's Type
• Enter A Title IE: "Latest (Insert Your Section Name Here)"
  
• Click Save
• Click Configure
  
• Remove all the default code.
  
• Copy and Paste the code below first editing $section and $limit to your liking
  
• Click Save
• Goto AdminCP-vBullietin CMS-Layout Manager
• Add the Widget to your Layout
• Click Save

How do I find my section id?
When clicking on your section you should see something like this:

http://www.domain.com/content.php?11

The number after ? in this case 11 is your section id.

Can I enter more than one section id?
Yes simply change $section = '11' to something like $section='11, 12, 13'

Code to copy(make sure you change $section and $limit!)

PHP Code:

// Set Your Section ID Here
$section = '11';
// Set The Number of Articles To Display
$limit = '1';
// Set The Height of The Thumbnail Image
$height = '250';
// Set The Width of The Thumbnail Image
$width = '250';

$articlegrab = vB::$db->query_read("
SELECT ".TABLE_PREFIX."cms_nodeinfo.nodeid
    , ".TABLE_PREFIX."cms_nodeinfo.title
    , ".TABLE_PREFIX."cms_article.previewimage
    , ".TABLE_PREFIX."cms_article.previewtext
    , ".TABLE_PREFIX."cms_article.pagetext
    , ".TABLE_PREFIX."cms_article.contentid
    , ".TABLE_PREFIX."cms_node.nodeid 
    , ".TABLE_PREFIX."cms_node.parentnode
    , ".TABLE_PREFIX."cms_node.contentid
    , ".TABLE_PREFIX."cms_node.url
    , ".TABLE_PREFIX."cms_node.publishdate
    , ".TABLE_PREFIX."cms_node.setpublish
  FROM ".TABLE_PREFIX."cms_article
, ".TABLE_PREFIX."cms_nodeinfo
, ".TABLE_PREFIX."cms_node
  WHERE (".TABLE_PREFIX."cms_nodeinfo.nodeid = ".TABLE_PREFIX."cms_node.nodeid)
    AND (".TABLE_PREFIX."cms_article.contentid = ".TABLE_PREFIX."cms_node.contentid)
    AND (".TABLE_PREFIX."cms_node.parentnode IN ($section))
    AND (".TABLE_PREFIX."cms_node.setpublish != 0)
  ORDER BY ".TABLE_PREFIX."cms_node.publishdate DESC LIMIT $limit
");


while($articleinfo = vB::$db->fetch_array($articlegrab)) {

    $title = $articleinfo['title'];
    $image = $articleinfo['previewimage'];
    $text = $articleinfo['previewtext'];
    $nodeid = $articleinfo['nodeid'];
    $url = $articleinfo['url'];
    $unixdate = $articleinfo['publishdate']; 
    $date = date("F j, Y, g:i a", $unixdate);  
    $fulltext = strip_bbcode($fulltext);
    $text = preg_replace('/\[ATTACH\=CONFIG\]\d\d\[\/ATTACH\]/', '', $text);
    $text = strip_bbcode($text);


   if($text == '') $text = substr($fulltext, 0,150);
    
    $output .= '<center>';
    if($image != '') $output .= "<img src='".$image."' width='".$width."px' height='".$height."px' /><br />";
    
    $output .= "<a href='content.php?".$nodeid."-".$url."'>".$title."</a><br /><p>Publish Date: ".$date."</p></br></center><p>".$text." <a href='content.php?".$nodeid."-".$url."'> <img alt='Read More' src='images/cms/read_more-right.png' title='Read More' border='0'></a></p><br />";
} 


Preview:



For Category Mod See Here:
https://vborg.vbsupport.ru/showthread.php?t=232440

[kingMOB]

This is the code that prints the title and the link to the article:

PHP Code:

$output .= "<a href='content.php?".$nodeid."-".$url."'>".$title."</a> 


You just need to leave this in the end of the widget:

PHP Code:

   if($text == '') $text = substr($fulltext, 0,150);
    
    $output .= "<a href='content.php?".$nodeid."-".$url."'>".$title."</a><br />";
} 


[Wild Bronco]

This looks nice.

Could the photo be a link to the Article also?
I think most users would starte by clicking it to see more.

[OcR Envy]

Good stuff here guys. Thanks for supporting Manu and King, been a bit busy myself.

[novabandit]

I have this working on my homepage, and it's great!

However, is it possible for this to work in a forum sidebar block?

[GRE]

I removed "Publish Date" line and all text has a center alignment. How can that be fixed?

[Neptun]

i have a problem ...

i have no space between the pictures there is one directly next to the other and also with the text - there is no space between ....

thx for help

[L2V]

Maybe this will help somebody else (or me in case I made a mistake) but I like to set CMS articles to published at a future date/time and this widget code was still showing those even though they were not published yet. It checks for published but not WHEN it is published. Here is what I used to fix this:

Find:

// Set The Width of The Thumbnail Image
$width = '250';

Add below:

// Set the current day and time
$datenow = strtotime("now");

Find:

AND (".TABLE_PREFIX."cms_node.setpublish != 0)

Add below (before 'ORDER BY'):

AND (".TABLE_PREFIX."cms_node.publishdate < ($datenow))

Worked like a [S]champ[/S] boss.

[monoco]

Any way to make the image auto resize like the "cms article preview", instead of having to input the image size?

[Neptun]

is there a possiblity to link the pictures also to the articles with a hyperlink ?

thanks

[monoco]

Would like to be able to float the image to the left and have the text flow around the image like the way the primary content widget works.

Any suggestions??