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

[Mark4865]

does anyone know how I could use this to display recent videos which I created by putting embed code into static pages in sections.

what would I need to change in the code, all help appreciated

[Mark4865]

Using code below I managed to move image to the left and tried to move text to the right but it still appears underneath image instead of next to it, how do I fix this

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

$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.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.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'];
$nodeid = $articleinfo['nodeid'];
$url = $articleinfo['url'];
$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 .= '<left>';
if($image != '') $output .= "<img src='".$image."' width='".$width."px' height='".$height."px' /><br />";

$output .= "<a href='content.php?".$nodeid."-".$url."'>".$title."</a><br /></br></right><p>".$text." </p><br />";
}

[sandyss]

HI Guys. I'm New and I'm looking for a plugin that show the lastest article insert into a section.
I tried to use this, but it doesn't go. I want to ask where is the number of section?
I have at the moment 2 section. I must to put the number or the name of my section in "// Set Your Section ID Here $section = '28';"
I want to put this widget in my home page. And I would like to put this widget in orizontal, like it is a footer.
May you help me? Thanks a lot.

[Mark4865]

Hello Sandyss,

to find your section id go to the section and look at the url see below

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'

[sandyss]

Hi Mark!!!
I have antoher problem because I cannot insert php code in a wdiget.
Because when I open agai the widget i see that the code isn't saved.
Why?
I cannt save php code? But I can't understand why!!!

[Mark4865]

Hello,

I am no expert so you are really asking advice from the wrong person but here goes.

When you create a widget you need to then save it and go to configure widget on the right hand side. Remove the exsisting code in the widget that is already in there when you create a new widget and just copy and paste in the new code and save that should be perfect.

[sandyss]

HI Mark. I asked to vbullettin.com directly.
I hope to resolve the problem. This widget is important for my web site

Thaks a lot!!!v

[sandyss]

Hi guys. I need help
FInally i can put php code in my widjet.
I want to know how can i do to see section article divided i three column.
In this moment i see the artcles section in row and not in column.
I attach the screenshot

[Mark4865]

Originally Posted by sandyss

Hi guys. I need help
FInally i can put php code in my widjet.
I want to know how can i do to see section article divided i three column.
In this moment i see the artcles section in row and not in column.
I attach the screenshot

Hello,

Using your layout manager where have you place the widget, I could be wrong here but it looks like you have it under the main content block instead of on the sidebar. If I am right move it to the sidebar section and see if that fixes your problem.

[sandyss]

Hi Mark.
Exactly, I placed it under the main content, bacause I need an horizontal widget:
I nees this widget because it reas lastes artcile section.
But graphically I wolud like to be appear like this screenshot I have made with photoshop.
Take a look, please.
May you help me to create one like ths?