prefix . 'admin_search__searches'; // Only create `searches` table if it doesn't exist if ( $wpdb -> get_var( $wpdb -> prepare( "SHOW TABLES LIKE %s", $table_name ) ) != $table_name ) { $charset_collate = $wpdb -> get_charset_collate(); $sql = "CREATE TABLE $table_name ( id mediumint(9) NOT NULL AUTO_INCREMENT, query tinytext NOT NULL, results mediumint(9) NOT NULL, occurrences mediumint(9) DEFAULT 1 NOT NULL, PRIMARY KEY (id) ) $charset_collate;"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql ); } } } add_action( 'admin_init', 'admin_search_setup' ); register_activation_hook( __FILE__, 'admin_search_setup' ); function admin_search_add_query_vars_filter( $vars ) { $vars[] = 'admin_search_preview'; return $vars; } add_filter( 'query_vars', 'admin_search_add_query_vars_filter' );