nickbudden

Here is a function to do this without breaking admin-ajax

function my_admin_init(){
if( !defined(‘DOING_AJAX’) && !current_user_can(‘administrator’) ){
wp_redirect( home_url() );
exit();
}
}
add_action(‘admin_init’,’my_admin_init’);

This function was provided by Milo on Stack Overflow.

Any ideas on getting pagination working?

Sorry…nevermind my question, figured it out as well. In case anyone has trouble with this I’ll explain a few things you need to change in the given example, and a thanks to vertaxe for sharing.

1. ‘yourkey’ and ‘yourvalue’ are examples added to the query in case you decide to querya custom field…they are not required to query by your votes. Pretty much everything in the following code can be customized to your own query….which was explained already, but I didn’t really get so am re-sharing.

$query = "
	SELECT wposts.*
	FROM wp_posts wposts, wp_postmeta wpostmeta
	WHERE wposts.ID = wpostmeta.post_id
	AND wpostmeta.meta_key = 'yourkey'
	AND wpostmeta.meta_value = 'yourvalue'
	AND wposts.post_status = 'publish'
	AND wposts.post_type = 'yourtype'
	ORDER BY wposts.post_date DESC
	";

2. Watch for the include. Here, you’ll have to include your own loop. Again pretty simple but for some reason I looked over this as well the first time through.

$pageposts = ShowPostByVotes($query);
if ($pageposts):
	foreach ($pageposts as $post):
		setup_postdata($post);
                // loop content goes here
		include 'yourloopcontent.php';
	endforeach;
endif;