[DoumDoum5058]

Hi,

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

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 :



Thanks
Best regards