Widget: CMS Most Viewed Articles This Week
Mod Version: 1.02, by reefland
| vB Version: 4.0.6 | Rating:  (7 votes - 4.71 average) |
Installs: 83 |
| Released: 21 Apr 2010 | Last Update: Never | Downloads: 0 |
 Not Supported
 Re-usable Code
Translations
|
||
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
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.
Download
No files for download.
Screenshots
