Popularity Contest Plugin (beta 3)

Hi Alex,

Thanks for this super plugin! Get a lot of nice comments on it.

I noticed posts with status “published” and a publish date in the future also show up. You can see this happening on https://www.jeugdsentimenten.net/2006/08/ – the 10 most popular articles are listed under “Populair in augustus 2006”. As you can see, “Falco – Jeanny” is in the list but the link doesn’t work: the article is to show up on the blog on the 6th of august 2006 (two days from now).

Is there a way to correct this?

tia,
Edde

The SQL probably just needs a date check clause. I’ll try to get this updated soon.

Updated, but untested:

https://dev.wp-plugins.org/changeset/6263

Thanks! I’ll give it a try.

Hi Alex,

I’ve included the three extra lines. Helas, it doesn’t do the trick. I also included
AND post_date > NOW()
after every instance of
WHERE post_status = 'publish'
I could find, but to no avail.

https://www.jeugdsentimenten.net/2006/08/ still shows a link to “Kinderversjes”, which is to be published on August 19th. You find the popularity lists in the right sidebar.

Hi Alex,

A bit off-topic _here_, but since you’re looking at this issues already: wp-mobile has the same problem. It gives away titles of new posts to pda-users.

People are very impressed by the fact the site has a pda version though. Love it!

Thanks,
Edde

More untested fixes committed.

Please open a new thread for mobile issues.

Thanks for the great plugin.

I have looked online, but can’t find a description for: feeds views and archive views. Can someone explain how those are counted, or point me to somewhere that does?

I believe home page views is a count of the times the that post was on the home page when the home page was viewed. I would imagine category views is similar. But I don’t understand what counts as a archive view or a feed view.

Alex,

I’m running the latest 1.2b3 (8/6/06 version) version of your plugin and I’m getting the following error when I try and save a post:

Invalid argument supplied for foreach() in /var/www/vhosts/mikekoepke.com/httpdocs/wp-content/plugins/popularity-contest.php on line 1298
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 3

I’m using PHP 5.0.4 and MySQL 4.1.14

Alex,

I did some troubleshooting and fixed the error and warning. Starting at line 1298 of the 1.2b3 file:

foreach ((array)$ak_posts as $post) {
$ids[] = $post->ID;
}

$result = mysql_query(“
SELECT post_id, total
FROM $wpdb->ak_popularity
WHERE post_id IN (‘”. implode(“‘,'”, $ids). “‘)
“) or die(mysql_error());

Basically the $ak_posts needed to be casted to an array and SQL syntax for the IN qualifier needed signle quotes added.

Mike

Great plugin Alex. Wish I could get it to play well with WP.

Running WP 2.0.4. On the Write Post page, I get this error in place of the image upload module:

Warning: Cannot modify header information – headers already sent by (output started at /homepages/8/d104609365/htdocs/savvysolo/wp-content/plugins/popularity-contest.php:2) in /homepages/8/d104609365/htdocs/savvysolo/wp-admin/inline-uploading.php on line 5

Warning: Cannot modify header information – headers already sent by (output started at /homepages/8/d104609365/htdocs/savvysolo/wp-content/plugins/popularity-contest.php:2) in /homepages/8/d104609365/htdocs/savvysolo/wp-includes/pluggable-functions.php on line 272

Also, can’t edit or delete posts with the plugin turned on.

Other plugins used:
Akismet
Get Recent Comments
Feedburner Feed Replacement
WP-Print
Page Navigation
Google Sitemaps
Translator
WP DB Backup
WP Email Notification

Thanks again – Michael

Correction.

Popularity Contest IS NOT the problem. The culprit is the Google Sitemaps plugin.

Pop Con working fine now.

Thanks again Alex.

Hello all,
hello Alex,

unfortunately after many months the conflict between PHPADS and Popularity Contest persists.
If Install the latest version on WordPress 2.02 I keep on getting this error:

Table ‘DATABASE_phpadsnew.wp2cgi_ak_popularity’ doesn’t exist

Did anybody face this problem?

Many thanks.
Max

It looks like PHP Ads whatever it is creates a connection to a different database, then Popularity Contest tries to connect to the WP database and finds itself talking to the Ads database instead. This isn’t something I’ll make changes to work-around in PC, it appears the the Ads plugin isn’t playing nicely with others.