<h2>File Contents: /home/planet5/www/wp-content/plugins/broken-link-checker/legacy/includes/copy_of_link-query.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/planet5/www/wp-content/plugins/broken-link-checker/legacy/includes/copy_of_link-query.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php

/**
 * Class for querying, sorting and filtering links.
 * Used as a singleton.
 *
 * @package Broken Link Checker
 * @access public
 */
class blcLinkQuery {

	var $native_filters;
	var $search_filter;
	var $custom_filters = array();

	var $valid_url_params = array();

	function __construct() {
		//Init. the available native filters.
		$this-&gt;native_filters = array(
			&#039;all&#039;       =&gt; array(
				&#039;params&#039;       =&gt; array(
					&#039;where_expr&#039; =&gt; &#039;1&#039;,
				),
				&#039;name&#039;         =&gt; __( &#039;All&#039;, &#039;broken-link-checker&#039; ),
				&#039;heading&#039;      =&gt; __( &#039;Detected Links&#039;, &#039;broken-link-checker&#039; ),
				&#039;heading_zero&#039; =&gt; __( &#039;No links found (yet)&#039;, &#039;broken-link-checker&#039; ),
				&#039;native&#039;       =&gt; true,
			),

			&#039;broken&#039;    =&gt; array(
				&#039;params&#039;       =&gt; array(
					&#039;where_expr&#039;          =&gt; &#039;( broken = 1 )&#039;,
					&#039;s_include_dismissed&#039; =&gt; false,
				),
				&#039;name&#039;         =&gt; __( &#039;Broken&#039;, &#039;broken-link-checker&#039; ),
				&#039;heading&#039;      =&gt; __( &#039;Broken Links&#039;, &#039;broken-link-checker&#039; ),
				&#039;heading_zero&#039; =&gt; __( &#039;No broken links found&#039;, &#039;broken-link-checker&#039; ),
				&#039;native&#039;       =&gt; true,
			),
			&#039;warnings&#039;  =&gt; array(
				&#039;params&#039;       =&gt; array(
					&#039;where_expr&#039;          =&gt; &#039;( warning = 1 )&#039;,
					&#039;s_include_dismissed&#039; =&gt; false,
				),
				&#039;name&#039;         =&gt; _x( &#039;Warnings&#039;, &#039;filter name&#039;, &#039;broken-link-checker&#039; ),
				&#039;heading&#039;      =&gt; _x( &#039;Warnings&#039;, &#039;filter heading&#039;, &#039;broken-link-checker&#039; ),
				&#039;heading_zero&#039; =&gt; __( &#039;No warnings found&#039;, &#039;broken-link-checker&#039; ),
				&#039;native&#039;       =&gt; true,
			),
			&#039;redirects&#039; =&gt; array(
				&#039;params&#039;       =&gt; array(
					&#039;where_expr&#039;          =&gt; &#039;( redirect_count &gt; 0 )&#039;,
					&#039;s_include_dismissed&#039; =&gt; false,
				),
				&#039;name&#039;         =&gt; __( &#039;Redirects&#039;, &#039;broken-link-checker&#039; ),
				&#039;heading&#039;      =&gt; __( &#039;Redirected Links&#039;, &#039;broken-link-checker&#039; ),
				&#039;heading_zero&#039; =&gt; __( &#039;No redirects found&#039;, &#039;broken-link-checker&#039; ),
				&#039;native&#039;       =&gt; true,
			),

			&#039;dismissed&#039; =&gt; array(
				&#039;params&#039;       =&gt; array(
					&#039;where_expr&#039; =&gt; &#039;( dismissed = 1 )&#039;,
				),
				&#039;name&#039;         =&gt; __( &#039;Dismissed&#039;, &#039;broken-link-checker&#039; ),
				&#039;heading&#039;      =&gt; __( &#039;Dismissed Links&#039;, &#039;broken-link-checker&#039; ),
				&#039;heading_zero&#039; =&gt; __( &#039;No dismissed links found&#039;, &#039;broken-link-checker&#039; ),
				&#039;native&#039;       =&gt; true,
			),
		);

		//The user can turn off warnings. In that case, all errors will show up in the &quot;broken&quot; filter instead.
		$conf = blc_get_configuration();
		if ( ! $conf-&gt;get( &#039;warnings_enabled&#039; ) ) {
			unset( $this-&gt;native_filters[&#039;warnings&#039;] );
		}

		//Create the special &quot;search&quot; filter
		$this-&gt;search_filter = array(
			&#039;name&#039;           =&gt; __( &#039;Search&#039;, &#039;broken-link-checker&#039; ),
			&#039;heading&#039;        =&gt; __( &#039;Search Results&#039;, &#039;broken-link-checker&#039; ),
			&#039;heading_zero&#039;   =&gt; __( &#039;No links found for your query&#039;, &#039;broken-link-checker&#039; ),
			&#039;params&#039;         =&gt; array(),
			&#039;use_url_params&#039; =&gt; true,
			&#039;hidden&#039;         =&gt; true,
		);

		//These search arguments may be passed via the URL if the filter&#039;s &#039;use_url_params&#039; field is set to True.
		//They map to the fields of the search form on the Tools -&gt; Broken Links page. Only these arguments
		//can be used in user-defined filters.
		$this-&gt;valid_url_params = array(
			&#039;s_link_text&#039;,
			&#039;s_link_url&#039;,
			&#039;s_parser_type&#039;,
			&#039;s_container_type&#039;,
			&#039;s_link_type&#039;,
			&#039;s_http_code&#039;,
			&#039;s_filter&#039;,
		);
	}

	//phpcs:ignore WordPress.NamingConventions.ValidFunctionName.MethodNameInvalid
	static function getInstance() {
		static $instance = null;
		if ( is_null( $instance ) ) {
			$instance = new blcLinkQuery;
		}
		return $instance;
	}

	/**
	 * Load and return the list of user-defined link filters.
	 *
	 * @return array An array of custom filter definitions. If there are no custom filters defined returns an empty array.
	 */
	function load_custom_filters() {
		global $wpdb; /** @var wpdb $wpdb */

		$filter_data = $wpdb-&gt;get_results( &quot;SELECT * FROM {$wpdb-&gt;prefix}blc_filters ORDER BY name ASC&quot;, ARRAY_A );
		$filters     = array();

		if ( ! empty( $filter_data ) ) {
			foreach ( $filter_data as $data ) {
				wp_parse_str( $data[&#039;params&#039;], $params );

				$params = array_intersect_key( $params, array_flip( $this-&gt;valid_url_params ) );

				$filters[ &#039;f&#039; . $data[&#039;id&#039;] ] = array(
					&#039;name&#039;         =&gt; $data[&#039;name&#039;],
					&#039;params&#039;       =&gt; $params,
					&#039;heading&#039;      =&gt; ucwords( $data[&#039;name&#039;] ),
					&#039;heading_zero&#039; =&gt; __( &#039;No links found for your query&#039;, &#039;broken-link-checker&#039; ),
					&#039;custom&#039;       =&gt; true,
				);
			}
		}

		$this-&gt;custom_filters = $filters;

		return $filters;
	}

	/**
	 * Add a custom link filter.
	 *
	 * @param string $name Filter name.
	 * @param string|array $params Filter params. Either as a query string, or an array.
	 * @return string|bool The ID of the newly added filter, or False.
	 */
	function create_custom_filter( $name, $params ) {
		global $wpdb; /** @var wpdb $wpdb */

		if ( is_array( $params ) ) {
			$params = http_build_query( $params, null, &#039;&amp;&#039; );
		}

		//Save the new filter
		$q = $wpdb-&gt;prepare(
			&quot;INSERT INTO {$wpdb-&gt;prefix}blc_filters(name, params) VALUES (%s, %s)&quot;,
			$name,
			$params
		);

		if ( $wpdb-&gt;query( $q ) !== false ) { //phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
			$filter_id = &#039;f&#039; . $wpdb-&gt;insert_id;
			return $filter_id;
		} else {
			return false;
		}
	}

	/**
	 * Delete a custom filter
	 *
	 * @param string $filter_id
	 * @return bool True on success, False if a database error occured.
	 */
	function delete_custom_filter( $filter_id ) {
		global $wpdb; /** @var wpdb $wpdb */

		if ( ! isset( $filter_id ) ) {
			$filter_id = $_POST[&#039;filter_id&#039;];
		}
		//Remove the &quot;f&quot; character from the filter ID to get its database key
		$filter_id = intval( ltrim( $filter_id, &#039;f&#039; ) );

		//Try to delete the filter
		$q = $wpdb-&gt;prepare( &quot;DELETE FROM {$wpdb-&gt;prefix}blc_filters WHERE id = %d&quot;, $filter_id );
		if ( false !== $wpdb-&gt;query( $q ) ) { //phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
			return true;
		} else {
			return false;
		}
	}

	function get_filters() {
		$filters           = array_merge( $this-&gt;native_filters, $this-&gt;custom_filters );
		$filters[&#039;search&#039;] = $this-&gt;search_filter;
		return $filters;
	}

	/**
	 * Get a link search filter by filter ID.
	 *
	 * @param string $filter_id
	 * @return array|null
	 */
	function get_filter( $filter_id ) {
		$filters = $this-&gt;get_filters();
		if ( isset( $filters[ $filter_id ] ) ) {
			return $filters[ $filter_id ];
		} else {
			return null;
		}
	}

	/**
	 * Get link search parameters from the specified filter.
	 *
	 * @param array $filter
	 * @return array An array of parameters suitable for use with blcLinkQuery::get_links()
	 */
	function get_search_params( $filter = null ) {
		//If present, the filter&#039;s parameters may be saved either as an array or a string.
		$params = array();
		if ( ! empty( $filter ) &amp;&amp; ! empty( $filter[&#039;params&#039;] ) ) {
			$params = $filter[&#039;params&#039;];
			if ( is_string( $params ) ) {
				wp_parse_str( $params, $params );
			}
		}

		//Merge in the parameters from the current request, if required
		if ( isset( $filter[&#039;use_url_params&#039;] ) &amp;&amp; $filter[&#039;use_url_params&#039;] ) {
			$params = array_merge( $params, $this-&gt;get_url_search_params() );
		}

		return $params;
	}

	/**
	 * Extract search query parameters from the current URL
	 *
	 * @return array
	 */
	function get_url_search_params() {
		$url_params = array();
		foreach ( $_GET as $param =&gt; $value ) {
			if ( in_array( $param, $this-&gt;valid_url_params ) ) {
				$url_params[ $param ] = esc_html( $value );
			}
		}
		return $url_params;
	}


	/**
	 * A helper method for parsing a list of search criteria and generating the parts of the SQL query.
	 *
	 * @see blcLinkQuery::get_links()
	 *
	 * @param array $params An array of search criteria.
	 * @return array &#039;where_exprs&#039; - an array of search expressions, &#039;join_instances&#039; - whether joining the instance table is required.
	 */
	function compile_search_params( $params ) {
		global $wpdb; /** @var wpdb $wpdb */

		//Track whether we&#039;ll need to left-join the instance table to run the query.
		$join_instances = false;

		//Generate the individual clauses of the WHERE expression and store them in an array.
		$pieces = array();

		//Convert parser and container type lists to arrays of valid values
		$s_parser_type = array();
		if ( ! empty( $params[&#039;s_parser_type&#039;] ) ) {
			$s_parser_type = $params[&#039;s_parser_type&#039;];
			if ( is_string( $s_parser_type ) ) {
				$s_parser_type = preg_split( &#039;/[,\s]+/&#039;, $s_parser_type );
			}
		}

		$s_container_type = array();
		if ( ! empty( $params[&#039;s_container_type&#039;] ) ) {
			$s_container_type = $params[&#039;s_container_type&#039;];
			if ( is_string( $s_container_type ) ) {
				$s_container_type = preg_split( &#039;/[,\s]+/&#039;, $s_container_type );
			}
		}

		//Don&#039;t include links with instances that reference invalid (not currently loaded)
		//containers and parsers (unless specifically told to also include invalid links).
		if ( empty( $params[&#039;include_invalid&#039;] ) ) {
			$join_instances = true;

			$module_manager    = blcModuleManager::getInstance();
			$loaded_containers = array_keys( $module_manager-&gt;get_active_by_category( &#039;container&#039; ) );
			$loaded_parsers    = array_keys( $module_manager-&gt;get_active_by_category( &#039;parser&#039; ) );

			if ( empty( $s_parser_type ) ) {
				$s_parser_type = $loaded_parsers;
			} else {
				$s_parser_type = array_intersect( $s_parser_type, $loaded_parsers );
			}

			if ( empty( $s_container_type ) ) {
				$s_container_type = $loaded_containers;
			} else {
				$s_container_type = array_intersect( $s_container_type, $loaded_containers );
			}
		}

		//Parser type should match the parser_type column in the instance table.
		if ( ! empty( $s_parser_type ) ) {
			$s_parser_type = array_map( &#039;trim&#039;, array_unique( $s_parser_type ) );
			$s_parser_type = array_map( &#039;esc_sql&#039;, $s_parser_type );

			if ( count( $s_parser_type ) == 1 ) {
				$pieces[] = sprintf( &quot;instances.parser_type = &#039;%s&#039;&quot;, reset( $s_parser_type ) );
			} else {
				$pieces[] = &quot;instances.parser_type IN (&#039;&quot; . implode( &quot;&#039;, &#039;&quot;, $s_parser_type ) . &quot;&#039;)&quot;;
			}

			$join_instances = true;
		}

		//Container type should match the container_type column in the instance table.
		if ( ! empty( $s_container_type ) ) {
			//Sanitize for use in SQL
			$s_container_type = array_map( &#039;trim&#039;, array_unique( $s_container_type ) );
			$s_container_type = array_map( &#039;esc_sql&#039;, $s_container_type );

			if ( count( $s_container_type ) == 1 ) {
				$pieces[] = sprintf( &quot;instances.container_type = &#039;%s&#039;&quot;, reset( $s_container_type ) );
			} else {
				$pieces[] = &quot;instances.container_type IN (&#039;&quot; . implode( &quot;&#039;, &#039;&quot;, $s_container_type ) . &quot;&#039;)&quot;;
			}

			$join_instances = true;
		}

		//A part of the WHERE expression can be specified explicitly
		if ( ! empty( $params[&#039;where_expr&#039;] ) ) {
			$pieces[]       = $params[&#039;where_expr&#039;];
			$join_instances = $join_instances || ( stripos( $params[&#039;where_expr&#039;], &#039;instances&#039; ) !== false );
		}

		//List of allowed link ids (either an array or comma-separated)
		if ( ! empty( $params[&#039;link_ids&#039;] ) ) {
			$link_ids = $params[&#039;link_ids&#039;];

			if ( is_string( $link_ids ) ) {
				$link_ids = preg_split( &#039;/[,\s]+/&#039;, $link_ids );
			}

			//Only accept non-zero integers
			$sanitized_link_ids = array();
			foreach ( $link_ids as $id ) {
				$id = intval( $id );
				if ( 0 !== $id ) {
					$sanitized_link_ids[] = $id;
				}
			}

			$pieces[] = &#039;links.link_id IN (&#039; . implode( &#039;, &#039;, $sanitized_link_ids ) . &#039;)&#039;;
		}

		//Anchor text - use LIKE search
		if ( ! empty( $params[&#039;s_link_text&#039;] ) ) {
			$s_link_text = esc_sql( $this-&gt;esc_like( $params[&#039;s_link_text&#039;] ) );
			$s_link_text = str_replace( &#039;*&#039;, &#039;%&#039;, $s_link_text );

			$pieces[]       = &#039;(instances.link_text LIKE &quot;%&#039; . $s_link_text . &#039;%&quot;)&#039;;
			$join_instances = true;
		}

		//URL - try to match both the initial URL and the final URL.
		//There is limited wildcard support, e.g. &quot;google.*/search&quot; will match both
		//&quot;google.com/search&quot; and &quot;google.lv/search&quot;
		if ( ! empty( $params[&#039;s_link_url&#039;] ) ) {
			$s_link_url = esc_sql( $this-&gt;esc_like( $params[&#039;s_link_url&#039;] ) );
			$s_link_url = str_replace( &#039;*&#039;, &#039;%&#039;, $s_link_url );

			$pieces[] = &#039;(links.url LIKE &quot;%&#039; . $s_link_url . &#039;%&quot;) OR &#039; .
						&#039;(links.final_url LIKE &quot;%&#039; . $s_link_url . &#039;%&quot;)&#039;;
		}

		//Container ID should match... you guessed it - container_id
		if ( ! empty( $params[&#039;s_container_id&#039;] ) ) {
			$s_container_id = intval( $params[&#039;s_container_id&#039;] );
			if ( 0 !== $s_container_id ) {
				$pieces[]       = &quot;instances.container_id = $s_container_id&quot;;
				$join_instances = true;
			}
		}

		//Link type can match either the the parser_type or the container_type.
		if ( ! empty( $params[&#039;s_link_type&#039;] ) ) {
			$s_link_type    = esc_sql( $params[&#039;s_link_type&#039;] );
			$pieces[]       = &quot;instances.parser_type = &#039;$s_link_type&#039; OR instances.container_type=&#039;$s_link_type&#039;&quot;;
			$join_instances = true;
		}

		//HTTP code - the user can provide a list of HTTP response codes and code ranges.
		//Example : 201,400-410,500
		if ( ! empty( $params[&#039;s_http_code&#039;] ) ) {
			//Strip spaces.
			$params[&#039;s_http_code&#039;] = str_replace( &#039; &#039;, &#039;&#039;, $params[&#039;s_http_code&#039;] );
			//Split by comma
			$codes = explode( &#039;,&#039;, $params[&#039;s_http_code&#039;] );

			$individual_codes = array();
			$ranges           = array();

			//Try to parse each response code or range. Invalid ones are simply ignored.
			foreach ( $codes as $code ) {
				if ( is_numeric( $code ) ) {
					//It&#039;s a single number
					$individual_codes[] = abs( intval( $code ) );
				} elseif ( strpos( $code, &#039;-&#039; ) !== false ) {
					//Try to parse it as a range
					$range = explode( &#039;-&#039;, $code, 2 );
					if ( ( count( $range ) == 2 ) &amp;&amp; is_numeric( $range[0] ) &amp;&amp; is_numeric( $range[0] ) ) {
						//Make sure the smaller code comes first
						$range    = array( intval( $range[0] ), intval( $range[1] ) );
						$ranges[] = array( min( $range ), max( $range ) );
					}
				}
			}

			$piece = array();

			//All individual response codes get one &quot;http_code IN (...)&quot; clause
			if ( ! empty( $individual_codes ) ) {
				$piece[] = &#039;(links.http_code IN (&#039; . implode( &#039;, &#039;, $individual_codes ) . &#039;))&#039;;
			}

			//Ranges get a &quot;http_code BETWEEN min AND max&quot; clause each
			if ( ! empty( $ranges ) ) {
				$range_strings = array();
				foreach ( $ranges as $range ) {
					$range_strings[] = &quot;(links.http_code BETWEEN $range[0] AND $range[1])&quot;;
				}
				$piece[] = &#039;( &#039; . implode( &#039; OR &#039;, $range_strings ) . &#039; )&#039;;
			}

			//Finally, generate a composite WHERE clause for both types of response code queries
			if ( ! empty( $piece ) ) {
				$pieces[] = implode( &#039; OR &#039;, $piece );
			}
		}

		//Dismissed links are included by default, but can explicitly included
		//or filtered out by passing a special param.
		if ( isset( $params[&#039;s_include_dismissed&#039;] ) ) {
			$s_include_dismissed        = ! empty( $params[&#039;s_include_dismissed&#039;] );
			$pieces[&#039;filter_dismissed&#039;] = $s_include_dismissed ? &#039;1&#039; : &#039;(dismissed = 0)&#039;;
		}

		//Optionally sorting is also possible
		$order_exprs = array();
		if ( ! empty( $params[&#039;orderby&#039;] ) ) {
			$allowed_columns = array(
				&#039;url&#039;          =&gt; &#039;links.url&#039;,
				&#039;link_text&#039;    =&gt; &#039;instances.link_text&#039;,
				&#039;redirect_url&#039; =&gt; &#039;links.final_url&#039;,
				&#039;status&#039;       =&gt; &#039;links.http_code&#039;,
			);
			$column          = $params[&#039;orderby&#039;];

			$direction = ! empty( $params[&#039;order&#039;] ) ? strtolower( $params[&#039;order&#039;] ) : &#039;asc&#039;;
			if ( ! in_array( $direction, array( &#039;asc&#039;, &#039;desc&#039; ) ) ) {
				$direction = &#039;asc&#039;;
			}

			if ( array_key_exists( $column, $allowed_columns ) ) {
				if ( &#039;redirect_url&#039; === $column ) {
					//Sort links that are not redirects last.
					$order_exprs[] = &#039;(links.redirect_count &gt; 0) DESC&#039;;
				}

				$order_exprs[] = $allowed_columns[ $column ] . &#039; &#039; . $direction;
			}
		}

		//Custom filters can optionally call one of the native filters
		//to narrow down the result set.
		if ( ! empty( $params[&#039;s_filter&#039;] ) &amp;&amp; isset( $this-&gt;native_filters[ $params[&#039;s_filter&#039;] ] ) ) {
			$the_filter     = $this-&gt;native_filters[ $params[&#039;s_filter&#039;] ];
			$extra_criteria = $this-&gt;compile_search_params( $the_filter[&#039;params&#039;] );

			$pieces         = array_merge( $extra_criteria[&#039;where_exprs&#039;], $pieces );
			$join_instances = $join_instances || $extra_criteria[&#039;join_instances&#039;];
		}

		return array(
			&#039;where_exprs&#039;    =&gt; $pieces,
			&#039;join_instances&#039; =&gt; $join_instances,
			&#039;order_exprs&#039;    =&gt; $order_exprs,
		);
	}

	private function esc_like( $input ) {
		global $wpdb; /** @var wpdb $wpdb */
		if ( method_exists( $wpdb, &#039;esc_like&#039; ) ) {
			return $wpdb-&gt;esc_like( $input );
		} else {
			return like_escape( $input );
		}
	}

	/**
	 * blcLinkQuery::get_links()
	 *
	 * @see blc_get_links()
	 *
	 * @param array $params
	 * @return array|int
	 */
	function get_links( $params = null ) {
		global $wpdb; /** @var wpdb $wpdb */

		if ( ! is_array( $params ) ) {
			$params = array();
		}

		$defaults = array(
			&#039;offset&#039;               =&gt; 0,
			&#039;max_results&#039;          =&gt; 0,
			&#039;load_instances&#039;       =&gt; false,
			&#039;load_containers&#039;      =&gt; false,
			&#039;load_wrapped_objects&#039; =&gt; false,
			&#039;count_only&#039;           =&gt; false,
			&#039;purpose&#039;              =&gt; &#039;&#039;,
			&#039;include_invalid&#039;      =&gt; false,
			&#039;orderby&#039;              =&gt; &#039;&#039;,
			&#039;order&#039;                =&gt; &#039;&#039;,
		);

		$params = array_merge( $defaults, $params );

		//Compile the search-related params into search expressions usable in a WHERE clause
		$criteria = $this-&gt;compile_search_params( $params );

		//Build the WHERE clause
		if ( ! empty( $criteria[&#039;where_exprs&#039;] ) ) {
			$where_expr = &quot;\t( &quot; . implode( &quot; ) AND\n\t( &quot;, $criteria[&#039;where_exprs&#039;] ) . &#039; ) &#039;;
		} else {
			$where_expr = &#039;1&#039;;
		}

		//Join the blc_instances table if it&#039;s required to perform the search.
		$joins = &#039;&#039;;
		if ( $criteria[&#039;join_instances&#039;] ) {
			$joins = &quot;JOIN {$wpdb-&gt;prefix}blc_instances AS instances ON links.link_id = instances.link_id&quot;;
		}

		//Optional sorting
		if ( ! empty( $criteria[&#039;order_exprs&#039;] ) ) {
			$order_clause = &#039;ORDER BY &#039; . implode( &#039;, &#039;, $criteria[&#039;order_exprs&#039;] );
		} else {
			$order_clause = &#039;&#039;;
		}

		if ( $params[&#039;count_only&#039;] ) {
			//Only get the number of matching links.
			$q = &quot;
				SELECT COUNT(*)
				FROM (
					SELECT 0

					FROM
						{$wpdb-&gt;prefix}blc_links AS links
						$joins

					WHERE
						$where_expr

				   GROUP BY links.link_id) AS foo&quot;;

			return $wpdb-&gt;get_var( $q ); //phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
		}

		//Select the required links.
		$q = &quot;SELECT
				 links.*

			  FROM
				 {$wpdb-&gt;prefix}blc_links AS links
				 $joins

			  WHERE
				 $where_expr

			   GROUP BY links.link_id

			   {$order_clause}&quot;; //Note: would be a lot faster without GROUP BY

		//Add the LIMIT clause
		if ( $params[&#039;max_results&#039;] || $params[&#039;offset&#039;] ) {
			$q .= sprintf( &quot;\nLIMIT %d, %d&quot;, $params[&#039;offset&#039;], $params[&#039;max_results&#039;] );
		}

		$results = $wpdb-&gt;get_results( $q, ARRAY_A ); //phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
		if ( empty( $results ) ) {
			return array();
		}

		//Create the link objects
		$links = array();

		foreach ( $results as $result ) {
			$link                    = new blcLink( $result );
			$links[ $link-&gt;link_id ] = $link;
		}

		$purpose = $params[&#039;purpose&#039;];
		/*
		Preload instances if :
			* It has been requested via the &#039;load_instances&#039; argument.
			* The links are going to be displayed or edited, which involves instances.
		*/
		$load_instances = $params[&#039;load_instances&#039;] || in_array( $purpose, array( BLC_FOR_DISPLAY, BLC_FOR_EDITING ) );

		if ( $load_instances ) {
			$link_ids      = array_keys( $links );
			$all_instances = blc_get_instances( $link_ids, $purpose, $params[&#039;load_containers&#039;], $params[&#039;load_wrapped_objects&#039;] );
			//Assign each batch of instances to the right link
			foreach ( $all_instances as $link_id =&gt; $instances ) {
				foreach ( $instances as $instance ) { /** @var blcLinkInstance $instance */
					$instance-&gt;_link = $links[ $link_id ];
				}
				$links[ $link_id ]-&gt;_instances = $instances;
			}
		}

		return $links;
	}

	/**
	 * Calculate the number of results for all known filters
	 *
	 * @return void
	 */
	function count_filter_results() {
		foreach ( $this-&gt;native_filters as $filter_id =&gt; $filter ) {
			$this-&gt;native_filters[ $filter_id ][&#039;count&#039;] = $this-&gt;get_filter_links(
				$filter,
				array( &#039;count_only&#039; =&gt; true )
			);
		}

		foreach ( $this-&gt;custom_filters as $filter_id =&gt; $filter ) {
			$this-&gt;custom_filters[ $filter_id ][&#039;count&#039;] = $this-&gt;get_filter_links(
				$filter,
				array( &#039;count_only&#039; =&gt; true )
			);
		}

		$this-&gt;search_filter[&#039;count&#039;] = $this-&gt;get_filter_links( $this-&gt;search_filter, array( &#039;count_only&#039; =&gt; true ) );
	}

	/**
	 * Retrieve a list of links matching a filter.
	 *
	 * @uses blcLinkQuery::get_links()
	 *
	 * @param string|array $filter Either a filter ID or an array containing filter data.
	 * @param array $extra_params Optional extra criteria that will override those set by the filter. See blc_get_links() for details.
	 * @return array|int Either an array of blcLink objects, or an integer indicating the number of links that match the filter.
	 */
	function get_filter_links( $filter, $extra_params = null ) {
		if ( is_string( $filter ) ) {
			$filter = $this-&gt;get_filter( $filter );
		}

		$params = $this-&gt;get_search_params( $filter );

		if ( ! empty( $extra_params ) ) {
			$params = array_merge( $params, $extra_params );
		}

		return $this-&gt;get_links( $params );
	}

	/**
	 * Print a menu of available filters, both native and user-created.
	 *
	 * @param string $current Current filter ID.
	 * @return void
	 */
	function print_filter_menu( $current = &#039;&#039; ) {
		$filters = $this-&gt;get_filters();

		echo &#039;&lt;ul class=&quot;subsubsub&quot;&gt;&#039;;

		//Construct a submenu of filter types
		$items = array();
		foreach ( $filters as $filter =&gt; $data ) {
			if ( ! empty( $data[&#039;hidden&#039;] ) ) {
				continue; //skip hidden filters
			}

			$class        = &#039;&#039;;
			$number_class = &#039;filter-&#039; . $filter . &#039;-link-count&#039;;

			if ( $current == $filter ) {
				$class         = &#039;class=&quot;current&quot;&#039;;
				$number_class .= &#039; current-link-count&#039;;
			}

			$items[] = sprintf(
				&quot;&lt;li&gt;&lt;a href=&#039;admin.php?page=blc_local&amp;filter_id=%s&#039; %s&gt;%s&lt;/a&gt; &lt;span class=&#039;count&#039;&gt;(&lt;span class=&#039;%s&#039;&gt;%d&lt;/span&gt;)&lt;/span&gt;&quot;,
				esc_attr( $filter ),
				$class,
				esc_html( $data[&#039;name&#039;] ),
				$number_class,
				$data[&#039;count&#039;]
			);
		}
		echo implode( &#039; |&lt;/li&gt;&#039;, $items );

		echo &#039;&lt;/ul&gt;&#039;;
	}

	/**
	 * Print the appropriate heading for the given filter.
	 *
	 * @param array $current_filter
	 * @return void
	 */
	function print_filter_heading( $current_filter ) {
		echo &#039;&lt;h2&gt;&#039;;
		//Output a header matching the current filter
		if ( $current_filter[&#039;count&#039;] &gt; 0 ) {
			echo $current_filter[&#039;heading&#039;] . &quot; (&lt;span class=&#039;current-link-count&#039;&gt;{$current_filter[&#039;count&#039;]}&lt;/span&gt;)&quot;;
		} else {
			echo $current_filter[&#039;heading_zero&#039;] . &quot;&lt;span class=&#039;current-link-count&#039;&gt;&lt;/span&gt;&quot;;
		}
		echo &#039;&lt;/h2&gt;&#039;;
	}

	/**
	 * Execute a filter.
	 *
	 * Gathers paging and search parameters from $_GET and executes the specified filter.
	 * The returned array contains standard filter data plus several additional fields :
	 *  &#039;filter_id&#039;     - Which filter was used. May differ from the specified $filter_id due to fallback settings.
	 *  &#039;per_page&#039;      - How many results per page the method tried to retrieve.
	 *  &#039;page&#039;          - Which page of results was retrieved.
	 *  &#039;max_pages&#039;     - The total number of results pages, calculated using the above &#039;per_page&#039; value.
	 *  &#039;links&#039;         - An array of retrieved links (blcLink objects).
	 *  &#039;search_params&#039; - An associative array of the current search parameters as extracted either from the current URL or the filter itself.
	 *  &#039;is_broken_filter&#039; - TRUE if the filter was set to retrieve only broken links, FALSE otherwise.
	 *
	 * @param string $filter_id Filter ID.
	 * @param int $page Optional. Which page of results to retrieve. Defaults to returning the first page of results.
	 * @param int $per_page Optional. The number of results per page. Defaults to 30.
	 * @param string $fallback Optional. Which filter to use if none match the specified $filter_id. Defaults to the native broken link filter.
	 * @param string $orderby Optional. Sort results by this column.
	 * @param string $order Optional. Sort direction (&#039;asc&#039; or &#039;desc&#039;).
	 * @return array Associative array of filter data and the results of its execution.
	 */
	function exec_filter( $filter_id, $page = 1, $per_page = 30, $fallback = &#039;broken&#039;, $orderby = &#039;&#039;, $order = &#039;asc&#039; ) {
		//The only valid sort directions are &#039;asc&#039; and &#039;desc&#039;.
		if ( ! in_array( $order, array( &#039;asc&#039;, &#039;desc&#039; ) ) ) {
			$order = &#039;asc&#039;;
		}

		//Get the selected filter (defaults to displaying broken links)
		$current_filter = $this-&gt;get_filter( $filter_id );
		if ( empty( $current_filter ) ) {
			$current_filter = $this-&gt;get_filter( $fallback );
			$filter_id      = $fallback;
		}

		//Page number must be &gt; 0
		if ( $page &lt; 1 ) {
			$page = 1;
		}

		//Links per page [1 - 500]
		if ( $per_page &lt; 1 ) {
			$per_page = 30;
		} elseif ( $per_page &gt; 500 ) {
			$per_page = 500;
		}

		//Calculate the maximum number of pages.
		$max_pages = ceil( $current_filter[&#039;count&#039;] / $per_page );

		//Select the required links
		$extra_params = array(
			&#039;offset&#039;      =&gt; ( ( $page - 1 ) * $per_page ),
			&#039;max_results&#039; =&gt; $per_page,
			&#039;purpose&#039;     =&gt; BLC_FOR_DISPLAY,
			&#039;orderby&#039;     =&gt; $orderby,
			&#039;order&#039;       =&gt; $order,
		);
		$links        = $this-&gt;get_filter_links( $current_filter, $extra_params );

		//If the current request is a user-initiated search query (either directly or
		//via a custom filter), save the search params. They can later be used to pre-fill
		//the search form or build a new/modified custom filter.
		$search_params = array();
		if ( ! empty( $current_filter[&#039;custom&#039;] ) || ( &#039;search&#039; == $filter_id ) ) {
			$search_params = $this-&gt;get_search_params( $current_filter );
		}

		$base_filter = &#039;&#039;;
		if ( array_key_exists( $filter_id, $this-&gt;native_filters ) ) {
			$base_filter = $filter_id;
		} elseif ( isset( $current_filter[&#039;params&#039;][&#039;s_filter&#039;] ) &amp;&amp; ! empty( $current_filter[&#039;params&#039;][&#039;s_filter&#039;] ) ) {
			$base_filter = $current_filter[&#039;params&#039;][&#039;s_filter&#039;];
		} elseif ( isset( $_GET[&#039;s_filter&#039;] ) &amp;&amp; ! empty( $_GET[&#039;s_filter&#039;] ) ) {
			if ( array_key_exists( $_GET[&#039;s_filter&#039;], $this-&gt;native_filters ) ) {
				$base_filter = esc_html( $_GET[&#039;s_filter&#039;] );
			} else {
				$base_filter = &#039;all&#039;;
			}
		}

		$is_broken_filter = ( &#039;broken&#039; == $base_filter );

		//Save the effective filter data in the filter array.
		//It can be used later to print the link table.
		$current_filter = array_merge(
			array(
				&#039;filter_id&#039;        =&gt; $filter_id,
				&#039;page&#039;             =&gt; $page,
				&#039;per_page&#039;         =&gt; $per_page,
				&#039;max_pages&#039;        =&gt; $max_pages,
				&#039;links&#039;            =&gt; $links,
				&#039;search_params&#039;    =&gt; $search_params,
				&#039;is_broken_filter&#039; =&gt; $is_broken_filter,
				&#039;base_filter&#039;      =&gt; $base_filter,
			),
			$current_filter
		);

		return $current_filter;
	}
}

/**
 * Retrieve a list of links matching some criteria.
 *
 * The function argument should be an associative array describing the criteria.
 * The supported keys are :
 *     &#039;offset&#039; - Skip the first X results. Default is 0.
 *     &#039;max_results&#039; - The maximum number of links to return. Defaults to returning all results.
 *     &#039;link_ids&#039; - Retrieve only links with these IDs. This should either be a comma-separated list or an array.
 *     &#039;s_link_text&#039; - Link text must match this keyphrase (performs a fulltext search).
 *     &#039;s_link_url&#039; - Link URL must contain this string. You can use &quot;*&quot; as a wildcard.
 *     &#039;s_parser_type&#039; - Filter links by the type of link parser that was used to find them.
 *     &#039;s_container_type&#039; - Filter links by where they were found, e.g. &#039;post&#039;.
 *     &#039;s_container_id&#039; - Find links that belong to a container with this ID (should be used together with s_container_type).
 *     &#039;s_link_type&#039; - Either parser type or container type must match this.
 *     &#039;s_http_code&#039; - Filter by HTTP code. Example : 201,400-410,500
 *     &#039;s_filter&#039; - Use a built-in filter. Available filters : &#039;broken&#039;, &#039;redirects&#039;, &#039;all&#039;
 *     &#039;where_expr&#039; - Advanced. Lets you directly specify a part of the WHERE clause.
 *     &#039;load_instances&#039; - Pre-load all link instance data for each link. Default is false.
 *     &#039;load_containers&#039; - Pre-load container data for each instance. Default is false.
 *     &#039;load_wrapped_objects&#039; - Pre-load wrapped object data (e.g. posts, comments, etc) for each container. Default is false.
 *     &#039;count_only&#039; - Only return the number of results (int), not the whole result set. &#039;offset&#039; and &#039;max_results&#039; will be ignored if this is set. Default is false.
 *     &#039;purpose&#039; -  An optional code indicating how the links will be used.
 *     &#039;include_invalid&#039; - Include links that have no instances and links that only have instances that reference not-loaded containers or parsers. Defaults to false.
 *
 * All keys are optional.
 *
 * @uses blcLinkQuery::get_links();
 *
 * @param array $params
 * @return int|blcLink[] Either an array of blcLink objects, or the number of results for the query.
 */
function blc_get_links( $params = null ) {
	$instance = blcLinkQuery::getInstance();
	return $instance-&gt;get_links( $params );
}

</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fplanet5%2Fwww%2Fwp-content%2Fplugins%2Fbroken-link-checker%2Flegacy%2Fincludes'>⬅ Back to Directory</a>