vBulletin CMS Widgets - Widget: Latest Articles In Category

Latest Articles In Category

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 category.

Change Log:
1.0 - Initial Release
1.1 - Updated to allow more than one category & 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 display unpublished articles.
1.5 - Updated read more link to be more vBulletin like.
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 Category Name Here)"
  
• Click Save
• Click Configure
  
• Remove all the default code.
  
• Copy and Paste the code below first editing $category 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 category id?
When in your article you should see something like this:

www.domain.comlist.php?category/11-MyCategory

The number after / in this case 11 is your category id.

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

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

PHP Code:

// Set Your Category ID Here
$category = '47';
// 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_category.category
     , ".TABLE_PREFIX."cms_category.categoryid 
    , ".TABLE_PREFIX."cms_node.setpublish
  FROM ".TABLE_PREFIX."cms_node
INNER
  JOIN ".TABLE_PREFIX."cms_article
    ON ".TABLE_PREFIX."cms_article.contentid = ".TABLE_PREFIX."cms_node.contentid
INNER
  JOIN ".TABLE_PREFIX."cms_nodeinfo
    ON ".TABLE_PREFIX."cms_nodeinfo.nodeid = ".TABLE_PREFIX."cms_node.nodeid
INNER
  JOIN ".TABLE_PREFIX."cms_nodecategory
    ON ".TABLE_PREFIX."cms_nodecategory.nodeid = ".TABLE_PREFIX."cms_node.nodeid
INNER
  JOIN ".TABLE_PREFIX."cms_category
    ON ".TABLE_PREFIX."cms_category.categoryid = ".TABLE_PREFIX."cms_nodecategory.categoryid
 WHERE ".TABLE_PREFIX."cms_category.categoryid IN ($category)
   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."'>Read More <img alt='Read More' src='images/cms/read_more-right.png' title='Read More' border='0'></a></a></p><br />";
} 


Preview:


For Section Mod See Here:
https://vborg.vbsupport.ru/showthread.php?p=1949493

[kingMOB]

Thank you very much OcR Envy, this should be a default widget for VB4.

I'm changing the output layout, how can I put the publishing date of the article?

Can more than one category be used in on single widget?

The widget could be modified to work with sections and sub-sections?

[OcR Envy]

There ya go king update to allow for published date & more than one category

For sections see my other mod here: https://vborg.vbsupport.ru/showthread.php?t=232443

1.2 Updated - Small update for users who have a table prefix should resolve any database errors. No need to update otherwise.

[saYRam]

good widget. can we do this?

i have a Section named Columnist. And there are a lot of Categories.

how can i display "Only first article" from every categories?.

i mean only one (Latest) article must listed from every cats i specified?

if there are 10 categories widget must display 10 articles from each categories.

[OcR Envy]

Sayram,

It isn't setup like that currently. You could try modifying the code a bit yourself but I don't think many people would use something like that.

[Datenpapst]

Hi,
I took the whole code you said just removed the align center and the hight and width of the image but still no preview text

I am using vb 4.0.1

[OcR Envy]

Originally Posted by Datenpapst

Hi,
I took the whole code you said just removed the align center and the hight and width of the image but still no preview text

I am using vb 4.0.1

Are you willing to run some test queries for me? Or possibly give me AdminCP access to your forum?

[Datenpapst]

you got mail

[OcR Envy]

Updated to 1.3 no need to update unless previewtext was not appearing for you.

For some reason Daten(and I assume others) had no previewtext row in some articles. The update will pull from the full text, strip bbcode and then limit the text to 150 characters.

[Datenpapst]

possible to add the number of comments given? ^^ like:

Comments: (1)

while the (1) is a link to the comments