The Arcive of Official vBulletin Modifications Site.

Widget: Latest Articles In Section · **Released**: 01-06-2010

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:

Quote:

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

OcR Envy · #12 01-19-2010, 09:15 AM

Quote:

Originally Posted by Datenpapst

Hi,
whats the 150px image for?
It also seems like that the preview text code does not work

Preview Text works fine for me on two of my test boards. Check your source and see paste the HTML the widget enters so I can look at it closer please. The 150px image is the preview image for the article. If you insert and image into the article it will display a thumbnail view of the image. You can change the dimensions if you'd like. 150px just worked for what I was trying to do.

Quote:

Originally Posted by kingMOB

OcR Envy, there's a way to print the section, subsection and/or categories from the article in the widget?

Thanks =)

No king not currently.

Quote:

Originally Posted by tazattitude

I also got an error.
I changed the section to one of my sections

HTML Code:

Parse error: syntax error, unexpected $end in /usr/www/users/saj716/a_customxxxxxxxxx/forum/packages/vbcms/widget/execphp.php(171) : eval()'d code on line 44

Also, to add, I do have a prefix "vbull"

You must change the sections to match your own section numbers. Make sure you have the number reading like this $section = '115'; 115 would be your own section id but you must have the surrounding ' '; for it to work.

Quote:

Originally Posted by Spiritvn

Could u make it automatically get the section ID from the section clicked?

I'm not sure what you mean? Explain more please.

Neptun · #13 01-19-2010, 09:59 AM

what section id if have to put in when i want to have articles from the main section - for example at vbulletin.com it is called "the Front page" ? that i get a lot of articles - because i tried the section id and i get nothing displayed ?!

tazattitude · #14 01-19-2010, 10:03 AM

Quote:

Originally Posted by OcR Envy

You must change the sections to match your own section numbers. Make sure you have the number reading like this $section = '115'; 115 would be your own section id but you must have the surrounding ' '; for it to work.

That's what I mean by
"I changed the section to one of my sections"

PHP Code:


			
// Set Your Section ID Here

$section = '28'; // This is a live section on my website (id: 28). Permissions to view granted to all usergroups

// Set The Number of Articles To Display

$limit = '3';



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

  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))

  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);  



    $output .= "<div align='center'>";



    if($image != '') {

        $output .= "<img src='" . $image . "' width='150px' height='150px' /><br />";

    }



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

    $output .= "<p>Publish Date: " . $date . "</p></br>";

    $output .= "<p>" . $text . " <a href='content.php?" . $nodeid . "-" . $url . "'>(more)</a></p></div><br />";

tazattitude · #15 01-19-2010, 10:10 AM

Quote:

Originally Posted by Neptun

what section id if have to put in when i want to have articles from the main section - for example at vbulletin.com it is called "the Front page" ? that i get a lot of articles - because i tried the section id and i get nothing displayed ?!

You can do this by default...

Admin Panel
Widgets>>Create New Widget >>Choose "General Search" (also name your widget)
Then "save"
Then you need to configure. Choose "Article". Then choose the rest how many days and how many you want to show up.

OcR Envy · #16 01-19-2010, 10:43 AM

Quote:

Originally Posted by tazattitude

That's what I mean by
"I changed the section to one of my sections"

PHP Code:


			
// Set Your Section ID Here
$section = '28'; // This is a live section on my website (id: 28). Permissions to view granted to all usergroups
// Set The Number of Articles To Display
$limit = '3';

$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.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
  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))
  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);  

    $output .= "<div align='center'>";

    if($image != '') {
        $output .= "<img src='" . $image . "' width='150px' height='150px' /><br />";
    }

    $output .= "<a href='content.php?" . $nodeid . "-" . $url . "'>" . $title . "</a><br />";
    $output .= "<p>Publish Date: " . $date . "</p></br>";
    $output .= "<p>" . $text . " <a href='content.php?" . $nodeid . "-" . $url . "'>(more)</a></p></div><br />";

And you are getting an error with this code?

Quote:

Originally Posted by tazattitude

You can do this by default...

Admin Panel
Widgets>>Create New Widget >>Choose "General Search" (also name your widget)
Then "save"
Then you need to configure. Choose "Article". Then choose the rest how many days and how many you want to show up.

This will show every section though. To show just the front page set $section = '1';

tazattitude · #17 01-19-2010, 12:01 PM

Got it to work. No more error
I put in an incorrect section number

Great job!

OcR Envy · #18 01-19-2010, 02:58 PM

Quote:

Originally Posted by tazattitude

Got it to work. No more error
I put in an incorrect section number

Great job!

Glad to hear it, thanks for marking as installed too!

CMerritt · #19 01-19-2010, 07:57 PM

I know this isn't available currently, but any thought to setting it up so that individual users could choose the section they want to appear by default? In other words, setting up a widget on the front page that would show articles by section based on their selection?

OcR Envy · #20 01-20-2010, 09:14 AM

Quote:

Originally Posted by CMerritt

I know this isn't available currently, but any thought to setting it up so that individual users could choose the section they want to appear by default? In other words, setting up a widget on the front page that would show articles by section based on their selection?

Not something I'm going to work on but that's fairly easily done on your end.

Create a User Profile Field, Single Line Textbox.
In the UsersCP have the user enter the Section ID they want to display.
In the widget change $section = ' '; to $section = $bbuserinfo['fieldX']

X would be the Profile Field #. I believe this will work I obviously haven't tested it.

OcR Envy · #21 01-20-2010, 11:45 AM

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04800 seconds Memory Usage 2,430KB 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 (1)bbcode_html (3)bbcode_php (11)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 (3)pagenav_pagelink (11)post_thanks_box (3)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:

3 благодарности(ей) от:
case-dk, Oxylis, Toorak Times

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!