Skip to content

Instantly share code, notes, and snippets.

@markjaquith
Created July 25, 2011 16:08
Show Gist options
  • Star 9 You must be signed in to star a gist
  • Fork 2 You must be signed in to fork a gist
  • Save markjaquith/1104477 to your computer and use it in GitHub Desktop.
Save markjaquith/1104477 to your computer and use it in GitHub Desktop.
Disable comments query plugin
<?php
/*
Plugin Name: Disable Comment Querying
Description: Disables comment queries
Version: 0.1
License: GPL version 2 or any later version
Author: Mark Jaquith
Author URI: http://coveredwebservices.com/
*/
class CWS_Disable_Comments_Query_Plugin {
static $instance;
private $already_ran = false;
public function __construct() {
self::$instance = $this;
add_action( 'template_redirect', array( $this, 'template_redirect' ) );
}
public function template_redirect() {
add_filter( 'option_require_name_email', array( $this, 'require_name_email' ) );
}
/*
This filter is fired in the comments_template() function,
which lacks a suitable way of hooking in early and aborting the comments query
*/
public function require_name_email( $value ) {
if ( !defined( 'DOING_AJAX' ) || !DOING_AJAX )
add_filter( 'query', array( $this, 'comments_query_filter' ) );
return $value;
}
/*
Neuter the comments query, to prevent doing double work.
*/
public function comments_query_filter( $query ) {
if ( $this->already_ran )
return $query;
global $wpdb;
$pattern = '#^\s*SELECT\s*\*\s*FROM\s*' . preg_quote( $wpdb->comments, '#' ) .'\s*WHERE\s*comment_post_ID\s*=\s*([0-9]+)\s*#i';
if ( preg_match( $pattern, $query ) ) {
// Neuter the query, while leaving a clue as to what happened
$query = preg_replace( $pattern, 'SELECT * FROM ' . $wpdb->comments . ' WHERE \'neutered\' = \'by CWS Disable Comments Query Plugin\' AND comment_post_ID = $1 ', $query );
$this->already_ran = true;
}
return $query;
}
}
new CWS_Disable_Comments_Query_Plugin;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment