vBulletin CMS Widgets - Widget: CMS Most Viewed Articles This Week

Most Viewed Articles This Week

1. Installation

1. Goto Admincp->vBullietin CMS->Widgets->Create New Widget
2. Choose PHP Direct Execution as Widget's Type
3. Insert a title. This Week's Most Popular for example.
4. Click Save
5. Click Configure on the right of the newly created widget.
6. Remove the default code that appears.
7. Copy and Paste the code in item 2 below.
8. Save
9. Goto Admincp->vBullietin CMS->Layout Manager
10. Add the Widget to your Layout
11. Click Save

2. PHP Code

      // Current Week Most Viewed
  $starttime = time() - (3600*24*7);
  $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.setpublish = 1
  AND
  cn.publishdate>'".$starttime."'
  ORDER BY
  cni.viewcount desc
  LIMIT 5
     ");
  $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>';
  }

3. Change Log

[Version 1.02 9-23-2010]
Removed unnecessary ob*() calls.
Changed output_bits to just output.

[Version 1.01 4-21-2010]
Fixed a bug show the correct URL was used for each article.

[BadgerDog]

Originally Posted by magmf

l
Please if you get another error paste the error here for me so i can check again... But i think now will work was a small issue related to my table names...

Good news.. the last version did not generate any SQL errors and the widget displays, however, there's no data within the widget box?

Does it need to run for a while to generate history before it displays anything?

Thanks ..

Regards,
Badger

[magmf]

BadgerDog this will display the content of your articles from last 7 days in order of biggest page views number to less pageviews... if you dont have any article published in last 7 days this will return nothing... So my suggestion to you is publish a new article and see if this new article will appear on this widget.

Let me know if worked for you

[BadgerDog]

Ok, sorry, I misunderstood what it did ...

I thought it displayed "Most Viewed Articles This Week", meaning which of the several thousand articles we already have in our research library have been the most viewed by members this week.

I guess I'll have to un-install this as it's always going to be blank ...

Thanks for your efforts ...

Regards,
Badger

[strudinox]

Installed on 4.0.7 and working great!

Is there any way to make it pull articles from a specific section?

[BioWaffen]

Where can I exchange the name of the widget? (I want to use another one than "5 Most viewed Article" )

[sticky]

Originally Posted by magmf

let me fix for you again.....

ob_start();
  // Current Week Most Viewed
  $starttime = time() - (3600*24*7);
  $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>';
  }
  $output = $outputbits;
  ob_end_clean();

Please if you get another error paste the error here for me so i can check again... But i think now will work was a small issue related to my table names...

Yes, this code worked for me! Any way to make the article text not bold like the title?

[mgcom]

how can i set this to be most viewed articles ever (not 7 days)

[TheAquanox]

Originally Posted by mgcom

how can i set this to be most viewed articles ever (not 7 days)

How about changing

(3600*24*7)

by

(3600*24*18250)

I don't think your forum is older than 50 year lol.

[Mark4865]

Any way to include thumbnail images with this

[project-Buckfas]

This code works in 4.1.0

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