<?php

/**

 * WordPress database access abstraction class.

 *

 * Original code from {@link http://php.justinvincent.com Justin Vincent (justin@visunet.ie)}

 *

 * @package WordPress

 * @subpackage Database

 * @since 0.71

 */

/**

 * @since 0.71

 */

define( 'EZSQL_VERSION', 'WP1.25' );

/**

 * @since 0.71

 */

define( 'OBJECT', 'OBJECT' );

// phpcs:ignore Generic.NamingConventions.UpperCaseConstantName.ConstantNotUpperCase

define( 'object', 'OBJECT' ); // Back compat.

/**

 * @since 2.5.0

 */

define( 'OBJECT_K', 'OBJECT_K' );

/**

 * @since 0.71

 */

define( 'ARRAY_A', 'ARRAY_A' );

/**

 * @since 0.71

 */

define( 'ARRAY_N', 'ARRAY_N' );

/**

 * WordPress database access abstraction class.

 *

 * This class is used to interact with a database without needing to use raw SQL statements.

 * By default, WordPress uses this class to instantiate the global $wpdb object, providing

 * access to the WordPress database.

 *

 * It is possible to replace this class with your own by setting the $wpdb global variable

 * in wp-content/db.php file to your class. The wpdb class will still be included, so you can

 * extend it or simply use your own.

 *

 * @link https://developer.wordpress.org/reference/classes/wpdb/

 *

 * @since 0.71

 */

#[AllowDynamicProperties]

class wpdb {

	/**

	 * Whether to show SQL/DB errors.

	 *

	 * Default is to show errors if both WP_DEBUG and WP_DEBUG_DISPLAY evaluate to true.

	 *

	 * @since 0.71

	 *

	 * @var bool

	 */

	public $show_errors = false;

	/**

	 * Whether to suppress errors during the DB bootstrapping. Default false.

	 *

	 * @since 2.5.0

	 *

	 * @var bool

	 */

	public $suppress_errors = false;

	/**

	 * The error encountered during the last query.

	 *

	 * @since 2.5.0

	 *

	 * @var string

	 */

	public $last_error = '';

	/**

	 * The number of queries made.

	 *

	 * @since 1.2.0

	 *

	 * @var int

	 */

	public $num_queries = 0;

	/**

	 * Count of rows returned by the last query.

	 *

	 * @since 0.71

	 *

	 * @var int

	 */

	public $num_rows = 0;

	/**

	 * Count of rows affected by the last query.

	 *

	 * @since 0.71

	 *

	 * @var int

	 */

	public $rows_affected = 0;

	/**

	 * The ID generated for an AUTO_INCREMENT column by the last query (usually INSERT).

	 *

	 * @since 0.71

	 *

	 * @var int

	 */

	public $insert_id = 0;

	/**

	 * The last query made.

	 *

	 * @since 0.71

	 *

	 * @var string

	 */

	public $last_query;

	/**

	 * Results of the last query.

	 *

	 * @since 0.71

	 *

	 * @var stdClass[]|null

	 */

	public $last_result;

	/**

	 * Database query result.

	 *

	 * Possible values:

	 *

	 * - `mysqli_result` instance for successful SELECT, SHOW, DESCRIBE, or EXPLAIN queries

	 * - `true` for other query types that were successful

	 * - `null` if a query is yet to be made or if the result has since been flushed

	 * - `false` if the query returned an error

	 *

	 * @since 0.71

	 *

	 * @var mysqli_result|bool|null

	 */

	protected $result;

	/**

	 * Cached column info, for confidence checking data before inserting.

	 *

	 * @since 4.2.0

	 *

	 * @var array

	 */

	protected $col_meta = array();

	/**

	 * Calculated character sets keyed by table name.

	 *

	 * @since 4.2.0

	 *

	 * @var string[]

	 */

	protected $table_charset = array();

	/**

	 * Whether text fields in the current query need to be confidence checked.

	 *

	 * @since 4.2.0

	 *

	 * @var bool

	 */

	protected $check_current_query = true;

	/**

	 * Flag to ensure we don't run into recursion problems when checking the collation.

	 *

	 * @since 4.2.0

	 *

	 * @see wpdb::check_safe_collation()

	 * @var bool

	 */

	private $checking_collation = false;

	/**

	 * Saved info on the table column.

	 *

	 * @since 0.71

	 *

	 * @var array

	 */

	protected $col_info;

	/**

	 * Log of queries that were executed, for debugging purposes.

	 *

	 * @since 1.5.0

	 * @since 2.5.0 The third element in each query log was added to record the calling functions.

	 * @since 5.1.0 The fourth element in each query log was added to record the start time.

	 * @since 5.3.0 The fifth element in each query log was added to record custom data.

	 *

	 * @var array[] {

	 *     Array of arrays containing information about queries that were executed.

	 *

	 *     @type array ...$0 {

	 *         Data for each query.

	 *

	 *         @type string $0 The query's SQL.

	 *         @type float  $1 Total time spent on the query, in seconds.

	 *         @type string $2 Comma-separated list of the calling functions.

	 *         @type float  $3 Unix timestamp of the time at the start of the query.

	 *         @type array  $4 Custom query data.

	 *     }

	 * }

	 */

	public $queries;

	/**

	 * The number of times to retry reconnecting before dying. Default 5.

	 *

	 * @since 3.9.0

	 *

	 * @see wpdb::check_connection()

	 * @var int

	 */

	protected $reconnect_retries = 5;

	/**

	 * WordPress table prefix.

	 *

	 * You can set this to have multiple WordPress installations in a single database.

	 * The second reason is for possible security precautions.

	 *

	 * @since 2.5.0

	 *

	 * @var string

	 */

	public $prefix = '';

	/**

	 * WordPress base table prefix.

	 *

	 * @since 3.0.0

	 *

	 * @var string

	 */

	public $base_prefix;

	/**

	 * Whether the database queries are ready to start executing.

	 *

	 * @since 2.3.2

	 *

	 * @var bool

	 */

	public $ready = false;

	/**

	 * Blog ID.

	 *

	 * @since 3.0.0

	 *

	 * @var int

	 */

	public $blogid = 0;

	/**

	 * Site ID.

	 *

	 * @since 3.0.0

	 *

	 * @var int

	 */

	public $siteid = 0;

	/**

	 * List of WordPress per-site tables.

	 *

	 * @since 2.5.0

	 *

	 * @see wpdb::tables()

	 * @var string[]

	 */

	public $tables = array(

		'posts',

		'comments',

		'links',

		'options',

		'postmeta',

		'terms',

		'term_taxonomy',

		'term_relationships',

		'termmeta',

		'commentmeta',

	);

	/**

	 * List of deprecated WordPress tables.

	 *

	 * 'categories', 'post2cat', and 'link2cat' were deprecated in 2.3.0, db version 5539.

	 *

	 * @since 2.9.0

	 *

	 * @see wpdb::tables()

	 * @var string[]

	 */

	public $old_tables = array( 'categories', 'post2cat', 'link2cat' );

	/**

	 * List of WordPress global tables.

	 *

	 * @since 3.0.0

	 *

	 * @see wpdb::tables()

	 * @var string[]

	 */

	public $global_tables = array( 'users', 'usermeta' );

	/**

	 * List of Multisite global tables.

	 *

	 * @since 3.0.0

	 *

	 * @see wpdb::tables()

	 * @var string[]

	 */

	public $ms_global_tables = array(

		'blogs',

		'blogmeta',

		'signups',

		'site',

		'sitemeta',

		'registration_log',

	);

	/**

	 * List of deprecated WordPress Multisite global tables.

	 *

	 * @since 6.1.0

	 *

	 * @see wpdb::tables()

	 * @var string[]

	 */

	public $old_ms_global_tables = array( 'sitecategories' );

	/**

	 * WordPress Comments table.

	 *

	 * @since 1.5.0

	 *

	 * @var string

	 */

	public $comments;

	/**

	 * WordPress Comment Metadata table.

	 *

	 * @since 2.9.0

	 *

	 * @var string

	 */

	public $commentmeta;

	/**

	 * WordPress Links table.

	 *

	 * @since 1.5.0

	 *

	 * @var string

	 */

	public $links;

	/**

	 * WordPress Options table.

	 *

	 * @since 1.5.0

	 *

	 * @var string

	 */

	public $options;

	/**

	 * WordPress Post Metadata table.

	 *

	 * @since 1.5.0

	 *

	 * @var string

	 */

	public $postmeta;

	/**

	 * WordPress Posts table.

	 *

	 * @since 1.5.0

	 *

	 * @var string

	 */

	public $posts;

	/**

	 * WordPress Terms table.

	 *

	 * @since 2.3.0

	 *

	 * @var string

	 */

	public $terms;

	/**

	 * WordPress Term Relationships table.

	 *

	 * @since 2.3.0

	 *

	 * @var string

	 */

	public $term_relationships;

	/**

	 * WordPress Term Taxonomy table.

	 *

	 * @since 2.3.0

	 *

	 * @var string

	 */

	public $term_taxonomy;

	/**

	 * WordPress Term Meta table.

	 *

	 * @since 4.4.0

	 *

	 * @var string

	 */

	public $termmeta;

	//

	// Global and Multisite tables

	//

	/**

	 * WordPress User Metadata table.

	 *

	 * @since 2.3.0

	 *

	 * @var string

	 */

	public $usermeta;

	/**

	 * WordPress Users table.

	 *

	 * @since 1.5.0

	 *

	 * @var string

	 */

	public $users;

	/**

	 * Multisite Blogs table.

	 *

	 * @since 3.0.0

	 *

	 * @var string

	 */

	public $blogs;

	/**

	 * Multisite Blog Metadata table.

	 *

	 * @since 5.1.0

	 *

	 * @var string

	 */

	public $blogmeta;

	/**

	 * Multisite Registration Log table.

	 *

	 * @since 3.0.0

	 *

	 * @var string

	 */

	public $registration_log;

	/**

	 * Multisite Signups table.

	 *

	 * @since 3.0.0

	 *

	 * @var string

	 */

	public $signups;

	/**

	 * Multisite Sites table.

	 *

	 * @since 3.0.0

	 *

	 * @var string

	 */

	public $site;

	/**

	 * Multisite Sitewide Terms table.

	 *

	 * @since 3.0.0

	 *

	 * @var string

	 */

	public $sitecategories;

	/**

	 * Multisite Site Metadata table.

	 *

	 * @since 3.0.0

	 *

	 * @var string

	 */

	public $sitemeta;

	/**