Popularity Contest Hacked

17 thoughts on “Popularity Contest Hacked”

1. tiltededge says:

   March 3, 2007 at 11:54 am

   I predict the next most popular thread will be on talking urinal cakes.

2. Leo Maia says:

   March 12, 2007 at 10:18 pm

   Please tell me: how did you do it?

   I’ve been trying to the exact same thing for me. I can’t stand seeing my top post for the last 3 months every single day.

   Thank you in advance!

3. dave says:

   March 12, 2007 at 10:36 pm

   Add these to your popularity-contest.php

   Right before the end of the class, put this:
   

   function show_top_ranked_in_last_month($limit, $before, $after) {
   global $wpdb;
   $temp = $wpdb;

   $join = apply_filters('posts_join', '');
   $where = apply_filters('posts_where', '');
   $groupby = apply_filters('posts_groupby', '');
   if (!empty($groupby)) { $groupby = ' GROUP BY '.$groupby; }

   $posts = $wpdb->get_results("
   SELECT ID, post_title
   FROM $wpdb->posts
   LEFT JOIN $wpdb->ak_popularity pop
   ON $wpdb->posts.ID = pop.post_id
   $join
   WHERE post_date > (SUBDATE(CURDATE(), INTERVAL '30' DAY))
   AND post_status = 'publish'
   AND post_date < NOW() $where $groupby ORDER BY pop.total DESC LIMIT ".intval($limit) ); if ($posts) { foreach ($posts as $post) { print( $before.'ID).'">'
   .$post->post_title.''.$after
   );
   }
   }
   else {
   print($before.'(none)'.$after);
   }
   $wpdb = $temp;
   }
   Somewhere towards the bottom with the similar functions, add this:

   
function akpc_most_popular_in_last_month($limit = 10, $before = '

4. ', $after = '

') {
global $akpc;
$akpc->show_top_ranked_in_last_month($limit, $before, $after);
}