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

Macindy · #22 01-21-2010, 03:19 PM

Hi dev!

Thanks for this great widget! I think I have found a bug: Also not published articles get catched up by the sql-query. This is not very good

Please check this ...

OcR Envy · #23 01-22-2010, 09:53 AM

Quote:

Originally Posted by Macindy

Hi dev!

Thanks for this great widget! I think I have found a bug: Also not published articles get catched up by the sql-query. This is not very good

Please check this ...

Hrmn ok thanks for the heads up I will look into it.

K20A2 · #24 01-22-2010, 02:12 PM

can this be modified to just show the latest article in each section? Right now it is show up double on my main page and I am looking to just have a different display for the newest article in each section.

http://www.k-series.com/forum/content.php

It is also showing up in the article itself so I might be doing something wrong. http://www.k-series.com/forum/conten...take-Manifolds

OcR Envy · #25 01-22-2010, 02:53 PM

Quote:

Originally Posted by K20A2

can this be modified to just show the latest article in each section? Right now it is show up double on my main page and I am looking to just have a different display for the newest article in each section.

http://www.k-series.com/forum/content.php

It is also showing up in the article itself so I might be doing something wrong. http://www.k-series.com/forum/conten...take-Manifolds

It's showing twice because you have the section set to your front page. I don't think it's possible to hide the front page section from appearing on the front page.

Maybe bit a bit more clear exactly what you want to show and not show.

K20A2 · #26 01-22-2010, 03:03 PM

I am trying to make the latest article in each section and the latest article on the main page show up different. I would like for them to have a larger image and have more a presense on the page than the typical 1x2 column that VB provides.

OcR Envy · #27 01-22-2010, 03:06 PM

Quote:

Originally Posted by K20A2

I am trying to make the latest article in each section and the latest article on the main page show up different. I would like for them to have a larger image and have more a presense on the page than the typical 1x2 column that VB provides.

This mod won't do that for you sorry

The front page will always show your most recent articles there's no way to turn that off as far as I know. This mod is meant to show latest articles in a section outside of the front page. You should be playing with the layout manager and your templates to accomplish what you want.

Updated to 1.5 It will no longer display unpublished articles.

K20A2 · #28 01-22-2010, 03:17 PM

been playing around with those without a lot of success, I will keep trying.

Demo16 · #29 02-04-2010, 11:35 AM

I like it very much, but I would like to put some div there to use some css in order to make some changes (like floating the img to the left and the text on the right).

There's a way to do this?

Neptun · #30 02-05-2010, 04:57 PM

i get the widget working now

but there are 2 things what i need to know:

1.) when i click on the "(more)" link in the widget - nothing is working i get nothing displayed ?! (i think the problem is with seo - how can i fix this in the widget in the rest of the cms everything is working with seo .. please help

)

2.) how can i display the showed articels side by side in one row ?!

this would be great if i get this things working

really a great hack

Demo16 · #31 02-06-2010, 07:43 AM

Quote:

Originally Posted by Demo16

I like it very much, but I would like to put some div there to use some css in order to make some changes (like floating the img to the left and the text on the right).

There's a way to do this?

no way to do it?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.08697 seconds Memory Usage 2,365KB 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_php (5)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 (4)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!