There is a posted comment policy for this blog. Please respect the rules.

17 Responses to “Popularity Contest Hacked”

Comment Permalink
1. tiltededge on March 3rd, 2007 11:54 am

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

Comment Permalink
2. Leo Maia on March 12th, 2007 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!

Comment Permalink
3. dave on March 12th, 2007 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);
}