vb.org Archive
Page 11 of 12 « First 910 11 12
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   vBulletin CMS Widgets - Widget: Latest Articles In Section (https://vborg.vbsupport.ru/showthread.php?t=232443)

inigo 12-12-2011 07:11 AM
I have another important question:

How can I take the category name over all the articles listed?

For random categories (the widget title is not a solution)

Thanks!

romaszek 02-11-2012 06:36 PM
Sorry, I don′t get the idea as to connect this code:


Quote:
Originally Posted by XManuX (Post 2000458)
Note that you can "easily" modify it to have the "best rated articles of this month"

1?) Add this in the SELECTed fields :
Code:
, ".TABLE_PREFIX."cms_nodeinfo.ratingtotal
2?) Add this condition in your request to limit results to the current month (and year) :
Code:
AND (MONTH(FROM_UNIXTIME(".TABLE_PREFIX."cms_node.publishdate))=MONTH(NOW()) AND YEAR(FROM_UNIXTIME(".TABLE_PREFIX."cms_node.publishdate))=YEAR(NOW()))
3?) Replace the ORDER part :
Code:
ORDER BY ".TABLE_PREFIX."cms_node.publishdate DESC LIMIT $limit
with:
Code:
ORDER BY ".TABLE_PREFIX."cms_nodeinfo.ratingtotal DESC LIMIT $limit
4?) In the While (where all variables are initialized) :
Code:
$rating = $articleinfo['ratingtotal'];
5?) Add somewhere in the $output string definition:
Code:
<span class=\"cmsrating rating{$rating}\"></span>
Regards.
With this code, please for the help.

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 />";
} 
This works for 4.1.10

Very Thanks :)
Somebody will help?

Preech 03-09-2012 11:21 AM
I figured out how to get the image on the left, and text on the right. It looks better if your title isn't to long.

PHP Code:
 $output .= '<div align="center">';
    if($image != '') $output .= "<p><img src='".$image."' align=\"left\" margin-top: 3px margin-bottom: 3px width='".$width."px' height='".$height."px'  style=\"border: solid 3px #DADFCB /><br />";
    
    $output .= "<span style=\"font-size:11px\"> <a href='content.php?".$nodeid."-".$url."'>".$title."</a></span></p></br><br /><hr class='vbt_line' /></div>"; 

monoco 06-05-2012 06:10 PM
I had this mod working fine before the upgrade to 4.1.11 and now the widgets will not show the previewtext.

It will show title, image and if set to the pagetext.

Any idea what the problem could be ?

mmacrypt 06-21-2012 06:48 PM
anybody know if this would work with a Group ID, I think I'm going to give it a try but I'm running 4.2 so we shall see what happens.

Preech 06-22-2012 04:07 AM
It still works on 4.2 I have changed my code of how it looks. Maybe I'll post it. It helped me alot with longer titles. I just haven't figured out how to get the preview text to show on 4.2.

Preech 01-11-2013 02:30 AM
I was having issues with vbseo, than I just did this.

PHP Code:
<a href='content.php?".$nodeid."-".$url."'> 
and changed it to this.

PHP Code:
<a href='/content.php?r=".$nodeid."-".$url."'> 
Clicking the links seemed to work. Also I am getting my preview text to work as well. There is no demo as of now, because I am still redesigning the look of my website. Sorry and I apologize.

case-dk 01-26-2013 09:17 AM
Thanks to OcR Envy. Works in 4.2.
Just had to insert a piece of code: $fulltext=$articleinfo['pagetext'];
I have my category-ID in the URL and read the string into the widget.
Then i dont have to make a Widget for every category i use.
Greetings

goxy63 02-18-2013 11:08 PM
Most of my articles have video instead of image, that is there is no images just youtube video, and with this widget there is no preview of youtube video [scaled] as under primary content I got now in CMS

This widget would be great if I will be able to show scaled youtube video

Thanks

stefano9lli 06-19-2013 08:18 AM
Fix for VBSeo

Into FTP duplicate content.php (rename it as contents.php) and link it to the new structure

Code:
contents.php?$nodeid
it results like

contents.php?512 => i.e. http://www.inforge.net/community/contentsp.php?518



###########


For previewtext i'm searching for a tweak ;)


All times are GMT. The time now is 10:17 PM.
Page 11 of 12 « First 910 11 12
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01158 seconds
  • Memory Usage 1,775KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (7)bbcode_code_printable
  • (4)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete