The Arcive of Official vBulletin Modifications Site.

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

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:

Quote:

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

OcR Envy · #12 01-22-2010, 03:24 PM

Quote:

Originally Posted by Datenpapst

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

Comments: (1)

while the (1) is a link to the comments

Haha Daten you always want something more don't you?

Kidding of course. I will work on that now.

Datenpapst · #13 01-22-2010, 03:39 PM

there is always something to do

OcR Envy · #14 01-22-2010, 03:49 PM

Quote:

Originally Posted by Datenpapst

there is always something to do

Comments are way more complicated then I thought. I'll have to put it on the back burner for the time being but eventually I'll get to it.

Datenpapst · #15 01-22-2010, 04:13 PM

maybe take the code from the recent article widget?

Naidoo · #16 01-28-2010, 02:24 PM

Nice widget ..

I have one question.
This widget is perfect for VB4 without VBSEO

How about VBSEO installed VB4 forum ..
It dont work out for me, since I have installed VBSEO

Can you help me out how to work it out

1) Changing output code ? (or)
2) Additional Custom Rewrite Code is needed in vbseo ?

Thanks in advance ..

OcR Envy · #17 02-02-2010, 03:30 PM

Quote:

Originally Posted by Naidoo

Nice widget ..

I have one question.
This widget is perfect for VB4 without VBSEO

How about VBSEO installed VB4 forum ..
It dont work out for me, since I have installed VBSEO

Can you help me out how to work it out

1) Changing output code ? (or)
2) Additional Custom Rewrite Code is needed in vbseo ?

Thanks in advance ..

What do you have your vbSEO CMS urls looking like?

OcR Envy · #18 02-26-2010, 11:40 AM

Updated to 1.6
- 4.0.2 started inserting [ATTACH] into the text fields. Simply add:

Code:

    $text =  preg_replace('/\[ATTACH\=CONFIG\]\d\d\[\/ATTACH\]/', '', $text);
    $text = strip_bbcode($text);

Before:

Code:

if($text == '') $text = substr($fulltext,  0,150);

And you should be good to go.

ahmedipa · #19 03-10-2010, 03:57 AM

so nice

Wild Bronco · #20 04-12-2010, 10:50 PM

Verry nice but I can not find a way to translate months? june etc ...

and if Image would take you to the article that would be nice-er

360themes · #21 05-17-2010, 09:51 PM

I can't make it work. Here is the error

Quote:

Parse error: syntax error, unexpected $end in /home/pandatec/public_html/packages/vbcms/widget/execphp.php(177) : eval()'d code on line 65

My code here:

Code:

// Set Your Category ID Here
$category = '48';
// Set The Number of Articles To Display
$limit = '2';
// Set The Height of The Thumbnail Image
$height = '50';
// Set The Width of The Thumbnail Image
$width = '50';


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

$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 />";

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06947 seconds Memory Usage 2,367KB 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 (3)bbcode_code (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 (2)pagenav_pagelink (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (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 post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername 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:

The Arcive of Official vBulletin Modifications Site.

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