Widget: CMS Most Viewed Articles This Week

[reefland]

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.

[RedHacker]

Please one screenshot or demo....?

[reefland]

PHP Code updated and screen shot attached.

[blue6995]

When does it get populated with the names of the Articles? I have installed and carried out the instructions above, but the 'This Week's Most Popular Article Box is empty!

Thanks

[giorgino]

Same for me. Empty

[vbgser]

Same for me

[reefland]

ob_start();

// 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_bits = '';
while($article = vB::$db->fetch_array($mostpopularweek_get))
{

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

}
$output = $output_bits;
ob_end_clean();


Can one of you copy and paste this code and see if it populates? It should show immediately.

[blue6995]

Can one of you copy and paste this code and see if it populates? It should show immediately.

When I cut and paste that in I get the following error message at the top of the Home Page


Parse error: syntax error, unexpected T_STRING in /home2/rwfforum/public_html/vBulletin/packages/vbcms/widget/execphp.php(177) : eval()'d code on line 43

[reefland]

can you post your code for me?

[blue6995]

can you post your code for me?

It is working now, using the new code. Thanks

[giorgino]

Not for me.
This is the code I've inserted:

ob_start();

// 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_bits = '';
while($article = vB::$db->fetch_array($mostpopularweek_get))
{

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

}
$output = $output_bits;
ob_end_clean();

[betts02]

Any chance to make this work for a forum block ?

Cheers

[g10net]

it works,thanks. How can be done by daily?

[reefland]

g10net,

You could just change the $starttime to:

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

[uaewebmaster]

Installed, Working 100%, Thanks :)

[funmasti]

can u make a XML? i mean installation file

[g10net]

g10net,

You could just change the $starttime to:

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


does'nt work :(

[reefland]

Make sure that the starttime line looks just like the above post. Alternatively you can use:

$starttime = time() - 86400;

[reefland]

can u make a XML? i mean installation file

I am not aware of how to make an XML for a php direct execution widget.

[BadgerDog]

Installed on 4.0.4pl1 and works fine ... :)

Thanks ...

Regards,
Badger

[sticky]

I'm on 4.0.2, doesn't work.

[BadgerDog]

Perhaps there's something else interfering?

Regards,
Badger

[vivamexico55]

Doesn't work on 4.04, only displays:

%24-%b-%2010

[mgcom]

comes up blank on 4.0.5

[BryceW]

Second that it comes up blank on 4.0.5

[magmf]

I changed the code and now it's working for me


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 = vbcms_nodeinfo.nodeid AND ".TABLE_PREFIX."cms_node.setpublish = 1 AND ".TABLE_PREFIX."cms_nodeinfo.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 let me know if worked for you

[BadgerDog]

I changed the code and now it's working for me


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 = vbcms_nodeinfo.nodeid AND ".TABLE_PREFIX."cms_node.setpublish = 1 AND ".TABLE_PREFIX."cms_nodeinfo.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 let me know if worked for you

Tried this and just ended up with a major SQL database error ....

Regards,
Badger

[magmf]

My fault


try this


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

[BadgerDog]

Nope, that doesn't work either ... thanks anyway...

Database error in vBulletin 4.0.4:

Invalid SQL:

select cms_node.nodeid as nodeid, cms_nodeinfo.title as title FROM cms_node, cms_nodeinfo where cms_node.nodeid = vbcms_nodeinfo.nodeid AND cms_node.setpublish = 1 AND cms_node.publishdate >'1284671090' ORDER BY cms_nodeinfo.viewcount desc LIMIT 5;;

MySQL Error : Unknown column 'vbcms_nodeinfo.nodeid' in 'where clause'
Error Number : 1054
Request Date : Thursday, September 23rd 2010 @ 05:04:50 PM
Error Date : Thursday, September 23rd 2010 @ 05:04:50 PM
Script : http://www.xxxxxx.com/content.php
Referrer : http://www.xxxxxx.com/index.php
IP Address : xx.xx.xxx.xxxx
Username : Tester
Classname : vB_Database
MySQL Version : 5.0.77

[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... :)

[BadgerDog]

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]

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]

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

[dnk.it]

this work great for vbulletin 4.1.1, thanks

My fault


try this


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

[Anopheles]

Works on 4.1.4 THANX!

[romaszek]

Hey.
Why there are no separators ?

Thanks.

[doctorsexy]

not working on my 4.1.5.... sql errors

[jGas]

It's not working on 4.1.6 .

This version of the code is working for me: https://vborg.vbsupport.ru/showpost.php?p=2127479&postcount=5

[dang3rzon3]

it is possible to add image's article?

[mircea1st]

I have this code:

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

Can we add a bullet at the begining of each article title ?
Thay are not separated at all .

[sspeed]

Sooo... I think I'm noticing a discrepancy... the link has it go to the article plus nodeid, for instance, on my site it's:

http://www.homenetworkenabled.com/content.php?r=129

The actual article address is:

http://www.homenetworkenabled.com/content.php?129-Building-a-Vortexbox-media-appliance

Which includes the "SEO URL Alias"... both get there, but it appears to be making the viewcount inconsistent... Any way to include the SEO URL Alias so it goes to the correct URL?

[sspeed]

I think I've done what I've mentioned in the post above, who knows if it's right though... you can see it http://www.homenetworkenabled.com

// Most popular articles
$starttime = time() - (3600*24*18250);
$mostpopularweek_get = vB::$db->query_read("
SELECT DISTINCT
ca.contentid,
cn.publishdate,
cn.url,
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 6
");
$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?'.$article[nodeid].'-'.$article[url].'">'.$article[title].'</a> ('.$article[viewcount].' views) </h4></div><br>';
}

[sspeed]

Can we add a bullet at the begining of each article title ?
Thay are not separated at all .

I noticed that as well, it was pretty gross looking, I just added a <br>, check out my site above and the code I posted..

[Wizza]

This is my edited code, it has bullet point at the start and seperated with lines:


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><hr>';
}
$output = $outputbits;
ob_end_clean();

[The Rocketeer]

any ideas on getting it to pull x number of articles from a specific category instead of view count?

[BirdOPrey5]

any ideas on getting it to pull x number of articles from a specific category instead of view count?

I don't know about category but if you check the database you can see the column for parentnode in the cms_node table. On my site the parentnode seems to be numerical number consistent with a category...

Then change the PHP code to:


$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 = X
ORDER BY
cn.publishdate desc
LIMIT Y
");
$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>';
}


Look at the 2 lines in red-
X = the parentnode you want (this will be a number)
Y = The max number of articles you want to pull from that parentnome (also a number.)

That *should* work, I haven't tested it at all but it is basic MySQL. I didn't change any of the php code.

[The Rocketeer]

I don't know about category but if you check the database you can see the column for parentnode in the cms_node table. On my site the parentnode seems to be numerical number consistent with a category...

Then change the PHP code to:


$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 = X
ORDER BY
cni.publishdate desc
LIMIT Y
");
$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>';
}


Look at the 2 lines in red-
X = the parentnode you want (this will be a number)
Y = The max number of articles you want to pull from that parentnome (also a number.)

That *should* work, I haven't tested it at all but it is basic MySQL. I didn't change any of the php code.

Thanks Joe.. :) But its throwing a Database error, something to do with the cni.publishdate I think :confused:

Database error in vBulletin 4.1.12:

Invalid SQL:

SELECT DISTINCT
ca.contentid,
cn.publishdate,
cn.nodeid,
cni.title,
cni.viewcount
FROM
cms_nodecategory cnc
JOIN
cms_node cn
ON
cnc.nodeid = cn.nodeid
JOIN
cms_article ca
ON
cn.contentid = ca.contentid
JOIN
cms_nodeinfo cni
ON
cn.nodeid = cni.nodeid
WHERE
cn.parentnode = 4
ORDER BY
cni.publishdate desc
LIMIT 5;

MySQL Error : Unknown column 'cni.publishdate' in 'order clause'
Error Number : 1054
Request Date : Thursday, May 17th 2012 @ 07:31:24 PM
Error Date : Thursday, May 17th 2012 @ 07:31:25 PM
Script : http://tomorrowsgaming.com/
Referrer : http://tomorrowsgaming.com/
IP Address : 122.61.154.171
Username : xxxxx
Classname : vB_Database
MySQL Version : 5.1.61-cll

[BirdOPrey5]

Sorry it should be ORDER BY cn.publishdate desc... I will edit the original code I posted.

[The Rocketeer]

:) Thanks Joe its working now! :up:

by the way, is there anyway to get the breadcrumbs working like the original one below?
https://vborg.vbsupport.ru/attachment.php?attachmentid=116124&d=1271855308


again thanks a lot, really appreciate it. :)

[BirdOPrey5]

Sorry I don't know what you mean by breadcrumbs? To me breadcrumbs were what is under the navbar saying where you are in a forum, it wouldn't have anything to do with a widget... ?

[The Rocketeer]

Sorry, I meant this https://vborg.vbsupport.ru/showpost.php?p=2246651&postcount=43

https://vborg.vbsupport.ru/attachment.php?attachmentid=133031&d=1316160231https://vborg.vbsupport.ru/attachment.php?attachmentid=133032&d=1316160376

I wasn''t too sure what its called, breadcrumb separators maybe? :erm:
See how the original has those small dots after each title, I think the original had these separators(?) but they disappeared or stopped working due to a vBulletin upgrade version incompatibility :confused:

by the way, how often will it refresh and add more new articles added in the category to the list? currently I have set it to display 12, and have since added a few articles to the category, but it's only showing 7 and hasn't updated the list with the other articles yet. if i added the cache time to say a few hrs or even a few days (in mins) will it auto refresh every few day or so?

[Kraxell]

Hey :)

is it possible to change the url?
<a href="content.php?r='.$article[nodeid].'">

The ID is not good for social-plugins. A foll url (/content/753-Sorcery) were better....

[BirdOPrey5]

Sorry, I meant this https://vborg.vbsupport.ru/showpost.php?p=2246651&postcount=43

https://vborg.vbsupport.ru/attachment.php?attachmentid=133031&d=1316160231https://vborg.vbsupport.ru/attachment.php?attachmentid=133032&d=1316160376

I wasn''t too sure what its called, breadcrumb separators maybe? :erm:
See how the original has those small dots after each title, I think the original had these separators(?) but they disappeared or stopped working due to a vBulletin upgrade version incompatibility :confused:

by the way, how often will it refresh and add more new articles added in the category to the list? currently I have set it to display 12, and have since added a few articles to the category, but it's only showing 7 and hasn't updated the list with the other articles yet. if i added the cache time to say a few hrs or even a few days (in mins) will it auto refresh every few day or so?

Those lines look like <hr> elements maybe... that's either a change you need to make to the template or a function of the style you are using- I'm not sure, styling isn't my strong point.

As for how often it refreshes there should be a cache time in the widget settings/configuration in the admin cp. It *should* refresh as often as you have it set.

You can go to Admin CP -> Maintenance -> Clear System Cache to force the refresh.

[The Rocketeer]

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

$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]

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:


WHERE
cn.parentnode IN (4,5,6)


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

[The Rocketeer]

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

[BirdOPrey5]

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

[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 :

http://soudeurs.com/piece-jointe/discussions/2976d1338128017-effectue-les-articles-les-plus-lus-sur-le-site-copie_ecran_widget_articles_plus_lus.jpg

Thanks
Best regards

[ar15dcm]

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

[DoumDoum5058]

Sorry but it is working correctly on V4.2
Using this 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]

Sorry, I meant this https://vborg.vbsupport.ru/showpost.php?p=2246651&postcount=43

https://vborg.vbsupport.ru/attachment.php?attachmentid=133031&d=1316160231https://vborg.vbsupport.ru/attachment.php?attachmentid=133032&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]

This thread is two years old. :confused:

[Budget101]

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

[tbworld]

We all appreciate the sharing, that is what makes the community. :)

[concepts]

We all appreciate the sharing, that is what makes the community. :)

Exactly!!! and thanks for this mod!