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]

Hi OcR Envy,

is there a way to the widget show articles that only matchs two categories?

Something like $category = '17(but have to be in the category 49 as well),66(but have to be in the 49 category as well),67(but have to be in the 49 category as well)';

Thanks =)

[NJMane]

If i only want the TITLE of the article to show up in the widget how would i make that happen. I dont want any of the extra stuff (i.e. pictures, publish date, article text, etc.). Thanks.

[Macindy]

Hi there!

I want to show articles only which are not in a category, so I used NOT IN
But, what if the article have more categories, so now the query adds it so often how categories are there. e.g. the article have categorieids = 1,30,24
And now I say NOT IN 24 - now it shows two times, because it is not in 1 and not in 30.

Can somebody help me?

[dang3rzon3]

doesn't work with vbseo.

Exaple of link:

http://www.pianetagay.com/forum/cont...-pompieri.html
http://www.pianetagay.com/forum/cont...clericali.html

[BadGuy]

Till now still no preview text

[stopchan]

Originally Posted by BadGuy

Till now still no preview text

For me too

And thumbnail proportions (heigh to width) doesn't much original image proportions. Thumbnail fits to defined into widget thumbnail height/width.

[inigo]

I am using random category,

$category = rand(1,15);

Each time (impression) the first articles of one category will be printed.

but I would like to print at the top of the widget (before the articles) the name (title) of the category, do you know how to do this?

Thanks,

[S S0DEN]

does not work 4.1.7