vb.org Archive - vBulletin CMS Widgets - Widget: CMS Most Viewed Articles This Week

Page 7 of 8

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: CMS Most Viewed Articles This Week (https://vborg.vbsupport.ru/showthread.php?t=240904)

The Rocketeer

05-19-2012 01:09 AM

It's not updating, Joe. something is wrong, it also displays nothing if i change the category id from 4 to 2. at category id 4 it shows only 7 articles, but doesn't show anything newly added to that category. i cleared the cache, set the times to 5 min, 20 min, 1 hr. nothing worked :confused:

here's my code

Code:

$mostpopularweek_get = vB::$db->query_read("

  SELECT DISTINCT

                 ca.contentid,

                 cn.publishdate,

                 cn.nodeid,

                 cni.title,

                 cni.viewcount

  FROM

   ".TABLE_PREFIX."cms_nodecategory cnc

  JOIN

   ".TABLE_PREFIX."cms_node cn

  ON 

  cnc.nodeid = cn.nodeid

  JOIN

   ".TABLE_PREFIX."cms_article ca

  ON

   cn.contentid = ca.contentid

  JOIN

   ".TABLE_PREFIX."cms_nodeinfo cni 

  ON

  cn.nodeid = cni.nodeid

  WHERE

  cn.parentnode = 4

  ORDER BY

  cn.publishdate desc

  LIMIT 20

     ");

  $output = '';

  while($article = vB::$db->fetch_array($mostpopularweek_get))

  {

            $output .='<div class = "cms_widget_post_bit"><h4 class="cms_widget_post_header"><a href="content.php?r='.$article[nodeid].'">'.$article[title].'</a> </h4></div>';

  }

BirdOPrey5

05-19-2012 10:17 AM

You should NOT be using the category ID...

You need to view the database and use the parentnode number- They aren't the same number as the categoryid but on my forum they seemed to follow (be unique) with the categoryid.

That is to say the categoryid might be 3 and the parentnode might be 5... categoryid 4 might have a parentnode of 7.

Make sure you are checking the parennode from the database.

If you want/need to pull from multiple parentnode numbers then change the line to:

Code:

WHERE

  cn.parentnode IN (4,5,6)

That would be where parentnode = 4, 5, or 6.

The Rocketeer

05-19-2012 11:40 AM

That might be it, thanks but how do you get the parent node number off the database?

BirdOPrey5

05-19-2012 03:08 PM

You need to view the table cms_node table in something like phpmyadmin.

DoumDoum5058

05-27-2012 04:09 PM

Hi,

For this Widget, the PHP code for VBulletin CMS 4.1.12 on my portal is :

Code:

ob_start();

  // Current Week Most Viewed

  $starttime = time() - (3600*24*31);

  $mostpopularweekget = vB::$db->query_read("

select 

".TABLE_PREFIX."cms_node.nodeid as nodeid, 

".TABLE_PREFIX."cms_nodeinfo.title as title 

FROM 

".TABLE_PREFIX."cms_node, 

".TABLE_PREFIX."cms_nodeinfo 

where 

".TABLE_PREFIX."cms_node.nodeid = 

".TABLE_PREFIX."cms_nodeinfo.nodeid 

AND 

".TABLE_PREFIX."cms_node.setpublish = 1 

AND 

".TABLE_PREFIX."cms_node.publishdate >'".$starttime."' ORDER BY ".TABLE_PREFIX."cms_nodeinfo.viewcount desc LIMIT 5;

     ");

  $outputbits = '';

  while($article = vB::$db->fetch_array($mostpopularweekget))

  {



           $outputbits .='<div class = "cms_widget_post_bit"><h4 class = "cms_widget_post_header">

                           <a rel="nofollow" href="content.php?r='.$article[nodeid].'">'.$article[title].'</a> → </h4>                      </div><br>';

  }

  $output = $outputbits;

  ob_end_clean();

Screenshout :

http://soudeurs.com/piece-jointe/dis...s_plus_lus.jpg

Thanks
Best regards

ar15dcm

07-05-2012 05:20 PM

Not working for me on v4.2 is there an update?

DoumDoum5058

11-18-2012 12:29 PM

Sorry but it is working correctly on V4.2
Using this code.

PHP Code:


		
			
ob_start();
  // Current Week Most Viewed
  $starttime = time() - (3600*24*31);
  $mostpopularweekget = vB::$db->query_read("
select ".TABLE_PREFIX."cms_node.nodeid as nodeid, ".TABLE_PREFIX."cms_nodeinfo.title as title FROM ".TABLE_PREFIX."cms_node, ".TABLE_PREFIX."cms_nodeinfo where ".TABLE_PREFIX."cms_node.nodeid = ".TABLE_PREFIX."cms_nodeinfo.nodeid AND ".TABLE_PREFIX."cms_node.setpublish = 1 AND ".TABLE_PREFIX."cms_node.publishdate >'".$starttime."' ORDER BY ".TABLE_PREFIX."cms_nodeinfo.viewcount desc LIMIT 10;
     ");
  $outputbits = '';
  while($article = vB::$db->fetch_array($mostpopularweekget))
  {

           $outputbits .='<div class = "cms_widget_post_bit"><h4 class = "cms_widget_post_header">
                           <a rel="nofollow" href="content.php?r='.$article[nodeid].'">'.$article[title].'</a> → </h4>                      </div><br>';
  }
  $output = $outputbits;
  ob_end_clean();

Thanks

Budget101

10-07-2014 06:03 PM

Quote:

Originally Posted by The Rocketeer (Post 2330473)

Sorry, I meant this https://vborg.vbsupport.ru/showpost....1&postcount=43

https://vborg.vbsupport.ru/attachmen...1&d=1316160231 https://vborg.vbsupport.ru/attachmen...2&d=1316160376

I wasn''t too sure what its called, breadcrumb separators maybe?

Just change the div class from cms_widget_post_bit to

cms_widget_post_bit widget_post_bit and you'll get the lines you want

ozzy47

10-07-2014 06:50 PM

This thread is two years old. :confused:

Budget101

10-09-2014 08:40 AM

Quote:

Originally Posted by ozzy47 (Post 2518056)

This thread is two years old. :confused:

Yes, but there are a number of people that are still using the mod & others who are just now installing it and having similar issues. Sometimes after an upgrade you have to reinstall mods or start all over with new mods & you can't recall how you tweaked them to begin with.

Hehe, bumping an old mod with info is better than replying, "never mind - I fixed it" and then not explaining how. ;-)

All times are GMT. The time now is 09:45 AM.

Page 7 of 8

« First

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01205 seconds Memory Usage 1,759KB 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 (3)bbcode_code_printable (1)bbcode_php_printable (2)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
Messages: