Na}{

File Content: `class-database-proxy.php`

<?php
/**
 * WPSEO plugin file.
 *
 * @package WPSEO\Admin
 */

/**
 * Represents the proxy for communicating with the database.
 */
class WPSEO_Database_Proxy {

	/**
	 * Holds the table name.
	 *
	 * @var string
	 */
	protected $table_name;

	/**
	 * Determines whether to suppress errors or not.
	 *
	 * @var bool
	 */
	protected $suppress_errors = true;

	/**
	 * Determines if this table is multisite.
	 *
	 * @var bool
	 */
	protected $is_multisite_table = false;

	/**
	 * Holds the last suppressed state.
	 *
	 * @var bool
	 */
	protected $last_suppressed_state;

	/**
	 * Holds the WordPress database object.
	 *
	 * @var wpdb
	 */
	protected $database;

	/**
	 * Holds the table prefix.
	 *
	 * @var string
	 */
	protected $table_prefix;

	/**
	 * Sets the class attributes and registers the table.
	 *
	 * @param wpdb   $database           The database object.
	 * @param string $table_name         The table name that is represented.
	 * @param bool   $suppress_errors    Should the errors be suppressed.
	 * @param bool   $is_multisite_table Should the table be global in multisite.
	 */
	public function __construct( $database, $table_name, $suppress_errors = true, $is_multisite_table = false ) {
		$this->table_name         = $table_name;
		$this->suppress_errors    = (bool) $suppress_errors;
		$this->is_multisite_table = (bool) $is_multisite_table;
		$this->database           = $database;

		// If the table prefix was provided, strip it as it's handled automatically.
		$table_prefix = $this->get_table_prefix();
		if ( ! empty( $table_prefix ) && strpos( $this->table_name, $table_prefix ) === 0 ) {
			$this->table_prefix = substr( $this->table_name, strlen( $table_prefix ) );
		}

		if ( ! $this->is_table_registered() ) {
			$this->register_table();
		}
	}

	/**
	 * Inserts data into the database.
	 *
	 * @param array             $data   Data to insert.
	 * @param array|string|null $format Formats for the data.
	 *
	 * @return false|int Total amount of inserted rows or false on error.
	 */
	public function insert( array $data, $format = null ) {
		$this->pre_execution();

		$result = $this->database->insert( $this->get_table_name(), $data, $format );

		$this->post_execution();

		return $result;
	}

	/**
	 * Updates data in the database.
	 *
	 * @param array             $data         Data to update on the table.
	 * @param array             $where        Where condition as key => value array.
	 * @param array|string|null $format       Optional. Data prepare format.
	 * @param array|string|null $where_format Optional. Where prepare format.
	 *
	 * @return false|int False when the update request is invalid, int on number of rows changed.
	 */
	public function update( array $data, array $where, $format = null, $where_format = null ) {
		$this->pre_execution();

		$result = $this->database->update( $this->get_table_name(), $data, $where, $format, $where_format );

		$this->post_execution();

		return $result;
	}

	/**
	 * Upserts data in the database.
	 *
	 * Performs an insert into and if key is duplicate it will update the existing record.
	 *
	 * @param array             $data         Data to update on the table.
	 * @param array|null        $where        Unused. Where condition as key => value array.
	 * @param array|string|null $format       Optional. Data prepare format.
	 * @param array|string|null $where_format Optional. Where prepare format.
	 *
	 * @return false|int False when the upsert request is invalid, int on number of rows changed.
	 */
	public function upsert( array $data, ?array $where = null, $format = null, $where_format = null ) {
		if ( $where_format !== null ) {
			_deprecated_argument( __METHOD__, '7.7.0', 'The where_format argument is deprecated' );
		}

		$this->pre_execution();

		$update  = [];
		$keys    = [];
		$columns = array_keys( $data );
		foreach ( $columns as $column ) {
			$keys[]   = '`' . $column . '`';
			$update[] = sprintf( '`%1$s` = VALUES(`%1$s`)', $column );
		}

		$query = sprintf(
			'INSERT INTO `%1$s` (%2$s) VALUES ( %3$s ) ON DUPLICATE KEY UPDATE %4$s',
			$this->get_table_name(),
			implode( ', ', $keys ),
			implode( ', ', array_fill( 0, count( $data ), '%s' ) ),
			implode( ', ', $update )
		);

		$result = $this->database->query(
			$this->database->prepare(
				$query,
				array_values( $data )
			)
		);

		$this->post_execution();

		return $result;
	}

	/**
	 * Deletes a record from the database.
	 *
	 * @param array             $where  Where clauses for the query.
	 * @param array|string|null $format Formats for the data.
	 *
	 * @return false|int
	 */
	public function delete( array $where, $format = null ) {
		$this->pre_execution();

		$result = $this->database->delete( $this->get_table_name(), $where, $format );

		$this->post_execution();

		return $result;
	}

	/**
	 * Executes the given query and returns the results.
	 *
	 * @param string $query The query to execute.
	 *
	 * @return array|object|null The resultset
	 */
	public function get_results( $query ) {
		$this->pre_execution();

		$results = $this->database->get_results( $query );

		$this->post_execution();

		return $results;
	}

	/**
	 * Creates a table to the database.
	 *
	 * @param array $columns The columns to create.
	 * @param array $indexes The indexes to use.
	 *
	 * @return bool True when creation is successful.
	 */
	public function create_table( array $columns, array $indexes = [] ) {
		$create_table = sprintf(
			'CREATE TABLE IF NOT EXISTS %1$s ( %2$s ) %3$s',
			$this->get_table_name(),
			implode( ',', array_merge( $columns, $indexes ) ),
			$this->database->get_charset_collate()
		);

		$this->pre_execution();

		$is_created = (bool) $this->database->query( $create_table );

		$this->post_execution();

		return $is_created;
	}

	/**
	 * Checks if there is an error.
	 *
	 * @return bool Returns true when there is an error.
	 */
	public function has_error() {
		return ( $this->database->last_error !== '' );
	}

	/**
	 * Executed before a query will be ran.
	 *
	 * @return void
	 */
	protected function pre_execution() {
		if ( $this->suppress_errors ) {
			$this->last_suppressed_state = $this->database->suppress_errors();
		}
	}

	/**
	 * Executed after a query has been ran.
	 *
	 * @return void
	 */
	protected function post_execution() {
		if ( $this->suppress_errors ) {
			$this->database->suppress_errors( $this->last_suppressed_state );
		}
	}

	/**
	 * Returns the full table name.
	 *
	 * @return string Full table name including prefix.
	 */
	public function get_table_name() {
		return $this->get_table_prefix() . $this->table_name;
	}

	/**
	 * Returns the prefix to use for the table.
	 *
	 * @return string The table prefix depending on the database context.
	 */
	protected function get_table_prefix() {
		if ( $this->is_multisite_table ) {
			return $this->database->base_prefix;
		}

		return $this->database->get_blog_prefix();
	}

	/**
	 * Registers the table with WordPress.
	 *
	 * @return void
	 */
	protected function register_table() {
		$table_name      = $this->table_name;
		$full_table_name = $this->get_table_name();

		$this->database->$table_name = $full_table_name;

		if ( $this->is_multisite_table ) {
			$this->database->ms_global_tables[] = $table_name;
			return;
		}

		$this->database->tables[] = $table_name;
	}

	/**
	 * Checks if the table has been registered with WordPress.
	 *
	 * @return bool True if the table is registered, false otherwise.
	 */
	protected function is_table_registered() {
		if ( $this->is_multisite_table ) {
			return in_array( $this->table_name, $this->database->ms_global_tables, true );
		}

		return in_array( $this->table_name, $this->database->tables, true );
	}
}

Name	Size	Permission
ajax	---	0755
capabilities	---	0755
endpoints	---	0755
exceptions	---	0755
filters	---	0755
formatter	---	0755
google_search_console	---	0755
import	---	0755
listeners	---	0755
menu	---	0755
metabox	---	0755
notifiers	---	0755
pages	---	0755
roles	---	0755
services	---	0755
statistics	---	0755
taxonomy	---	0755
tracking	---	0755
views	---	0755
watchers	---	0755
admin-settings-changed-listener.php	2445 bytes	0644
ajax.php	11509 bytes	0644
class-admin-asset-analysis-worker-location.php	1849 bytes	0644
class-admin-asset-dev-server-location.php	1672 bytes	0644
class-admin-asset-location.php	488 bytes	0644
class-admin-asset-manager.php	19272 bytes	0644
class-admin-asset-seo-location.php	2126 bytes	0644
class-admin-editor-specific-replace-vars.php	6495 bytes	0644
class-admin-gutenberg-compatibility-notification.php	2610 bytes	0644
class-admin-help-panel.php	2760 bytes	0644
class-admin-init.php	10957 bytes	0644
class-admin-recommended-replace-vars.php	6128 bytes	0644
class-admin-user-profile.php	3347 bytes	0644
class-admin-utils.php	2196 bytes	0644
class-admin.php	13729 bytes	0644
class-asset.php	4079 bytes	0644
class-bulk-description-editor-list-table.php	2100 bytes	0644
class-bulk-editor-list-table.php	30105 bytes	0644
class-bulk-title-editor-list-table.php	2286 bytes	0644
class-collector.php	1005 bytes	0644
class-config.php	5417 bytes	0644
class-database-proxy.php	7684 bytes	0644
class-export.php	3541 bytes	0644
class-expose-shortlinks.php	8791 bytes	0644
class-gutenberg-compatibility.php	2529 bytes	0644
class-meta-columns.php	25474 bytes	0644
class-my-yoast-proxy.php	6287 bytes	0644
class-option-tab.php	2268 bytes	0644
class-option-tabs-formatter.php	2905 bytes	0644
class-option-tabs.php	2311 bytes	0644
class-paper-presenter.php	3600 bytes	0644
class-plugin-availability.php	9186 bytes	0644
class-plugin-conflict.php	4141 bytes	0644
class-premium-popup.php	2874 bytes	0644
class-premium-upsell-admin-block.php	5248 bytes	0644
class-primary-term-admin.php	7524 bytes	0644
class-remote-request.php	3203 bytes	0644
class-schema-person-upgrade-notification.php	2284 bytes	0644
class-suggested-plugins.php	4429 bytes	0644
class-wincher-dashboard-widget.php	3615 bytes	0644
class-yoast-columns.php	3602 bytes	0644
class-yoast-dashboard-widget.php	4055 bytes	0644
class-yoast-form.php	37590 bytes	0644
class-yoast-input-validation.php	10741 bytes	0644
class-yoast-network-admin.php	10208 bytes	0644
class-yoast-network-settings-api.php	4276 bytes	0644
class-yoast-notification-center.php	26418 bytes	0644
class-yoast-notification.php	9893 bytes	0644
class-yoast-notifications.php	7812 bytes	0644
class-yoast-plugin-conflict.php	10576 bytes	0644
index.php	38 bytes	0644
interface-collection.php	257 bytes	0644
interface-installable.php	254 bytes	0644

File Content: class-database-proxy.php

File Content: `class-database-proxy.php`