Excluding pages from popularity contest

*bump*

I found this part of code in the popularity contest coding:

function recount_feedback() {
global $wpdb;
$posts = mysql_query(“
SELECT ID
FROM $wpdb->posts
WHERE post_status = ‘publish’
OR post_status = ‘static’
“) or die(mysql_error().’ on line: ‘.__LINE__);

I think if i remove the ‘static’ part it should stop showing pages but i’m not sure how to it.

Has anyone figured this out yet?

I am also looking for an answer to this.

I would also like to know the answer to this…I hope Alex King can help us out here!

Well if anyone is still puzzled over this you can change it by making sure it’s a post before it gets indexed, in the latest version change all references of:

WHERE post_status = 'publish'
AND post_date < NOW()

to

WHERE post_status = 'publish'
AND post_type = 'post'
AND post_date < NOW()

and

AND post_status = 'publish'
AND post_date < NOW()

to

AND post_status = 'publish'
AND post_type = 'post'
AND post_date < NOW()

(specifically lines 1383-1384 and 1493-1494).