[Plugin: WordPress Popular Posts] popular by day posts published

Hi there,

At the moment, no. WordPress Popular Posts lists all posts that have been viewed or commented in the selected time range – it doesn’t matter when they were first published.

However, you could change the plugin’s code to limit the popular lists only to those posts published within the specified time range. For that, you need to change this:

$query = "SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' {$fields} FROM {$wpdb->posts} p {$join} WHERE p.post_status = 'publish' AND p.post_password = '' {$where} GROUP BY p.ID {$having} ORDER BY {$orderby} DESC LIMIT " . $instance['limit'] . ";";

…into this:

$post_interval = "";

if ($instance['range'] == "daily") {
	$post_interval = " AND post_date_gmt > DATE_SUB('".$this->now()."', INTERVAL 1 DAY) ";
} else if ($instance['range'] == "weekly") {
	$post_interval = " AND post_date_gmt > DATE_SUB('".$this->now()."', INTERVAL 1 WEEK) ";
} else if ($instance['range'] == "monthly") {
	$post_interval = " AND post_date_gmt > DATE_SUB('".$this->now()."', INTERVAL 1 MONTH) ";
}

$query = "SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' {$fields} FROM {$wpdb->posts} p {$join} WHERE p.post_status = 'publish' AND p.post_password = '' {$where} {$post_interval} GROUP BY p.ID {$having} ORDER BY {$orderby} DESC LIMIT " . $instance['limit'] . ";";

And save changes.

Please note that I didn’t test the code as I’m a bit busy now, so you’ll have to do it yourself. Also, you’ll need to add this change each time the plugin gets updated and probably change a few things as this code might be obsolete in future releases.

Hi medraka,

Yes, it’s already on the ToDo list (see issue).