<?php

/**

 * WordPress DB 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', true );

/**

 * @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 Object

 *

 * 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 http://codex.wordpress.org/Function_Reference/wpdb_Class

 *

 * @package WordPress

 * @subpackage Database

 * @since 0.71

 */

class wpdb {

	/**

	 * Whether to show SQL/DB errors

	 *

	 * @since 0.71

	 * @access private

	 * @var bool

	 */

	var $show_errors = false;

	/**

	 * Whether to suppress errors during the DB bootstrapping.

	 *

	 * @access private

	 * @since 2.5.0

	 * @var bool

	 */

	var $suppress_errors = false;

	/**

	 * The last error during query.

	 *

	 * @since 2.5.0

	 * @var string

	 */

	var $last_error = '';

	/**

	 * Amount of queries made

	 *

	 * @since 1.2.0

	 * @access private

	 * @var int

	 */

	var $num_queries = 0;

	/**

	 * Count of rows returned by previous query

	 *

	 * @since 0.71

	 * @access private

	 * @var int

	 */

	var $num_rows = 0;

	/**

	 * Count of affected rows by previous query

	 *

	 * @since 0.71

	 * @access private

	 * @var int

	 */

	var $rows_affected = 0;

	/**

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

	 *

	 * @since 0.71

	 * @access public

	 * @var int

	 */

	var $insert_id = 0;

	/**

	 * Last query made

	 *

	 * @since 0.71

	 * @access private

	 * @var array

	 */

	var $last_query;

	/**

	 * Results of the last query made

	 *

	 * @since 0.71

	 * @access private

	 * @var array|null

	 */

	var $last_result;

	/**

	 * MySQL result, which is either a resource or boolean.

	 *

	 * @since 0.71

	 * @access protected

	 * @var mixed

	 */

	protected $result;

	/**

	 * Saved info on the table column

	 *

	 * @since 0.71

	 * @access protected

	 * @var array

	 */

	protected $col_info;

	/**

	 * Saved queries that were executed

	 *

	 * @since 1.5.0

	 * @access private

	 * @var array

	 */

	var $queries;

	/**

	 * 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

	 * @access private

	 * @var string

	 */

	var $prefix = '';

	/**

	 * Whether the database queries are ready to start executing.

	 *

	 * @since 2.3.2

	 * @access private

	 * @var bool

	 */

	var $ready = false;

	/**

	 * {@internal Missing Description}}

	 *

	 * @since 3.0.0

	 * @access public

	 * @var int

	 */

	var $blogid = 0;

	/**

	 * {@internal Missing Description}}

	 *

	 * @since 3.0.0

	 * @access public

	 * @var int

	 */

	var $siteid = 0;

	/**

	 * List of WordPress per-blog tables

	 *

	 * @since 2.5.0

	 * @access private

	 * @see wpdb::tables()

	 * @var array

	 */

	var $tables = array( 'posts', 'comments', 'links', 'options', 'postmeta',

		'terms', 'term_taxonomy', 'term_relationships', 'commentmeta' );

	/**

	 * List of deprecated WordPress tables

	 *

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

	 *

	 * @since 2.9.0

	 * @access private

	 * @see wpdb::tables()

	 * @var array

	 */

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

	/**

	 * List of WordPress global tables

	 *

	 * @since 3.0.0

	 * @access private

	 * @see wpdb::tables()

	 * @var array

	 */

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

	/**

	 * List of Multisite global tables

	 *

	 * @since 3.0.0

	 * @access private

	 * @see wpdb::tables()

	 * @var array

	 */

	var $ms_global_tables = array( 'blogs', 'signups', 'site', 'sitemeta',

		'sitecategories', 'registration_log', 'blog_versions' );

	/**

	 * WordPress Comments table

	 *

	 * @since 1.5.0

	 * @access public

	 * @var string

	 */

	var $comments;

	/**

	 * WordPress Comment Metadata table

	 *

	 * @since 2.9.0

	 * @access public

	 * @var string

	 */

	var $commentmeta;

	/**

	 * WordPress Links table

	 *

	 * @since 1.5.0

	 * @access public

	 * @var string

	 */

	var $links;

	/**

	 * WordPress Options table

	 *

	 * @since 1.5.0

	 * @access public

	 * @var string

	 */

	var $options;

	/**

	 * WordPress Post Metadata table

	 *

	 * @since 1.5.0

	 * @access public

	 * @var string

	 */

	var $postmeta;

	/**

	 * WordPress Posts table

	 *

	 * @since 1.5.0

	 * @access public

	 * @var string

	 */

	var $posts;

	/**

	 * WordPress Terms table

	 *

	 * @since 2.3.0

	 * @access public

	 * @var string

	 */

	var $terms;

	/**

	 * WordPress Term Relationships table

	 *

	 * @since 2.3.0

	 * @access public

	 * @var string

	 */

	var $term_relationships;

	/**

	 * WordPress Term Taxonomy table

	 *

	 * @since 2.3.0

	 * @access public

	 * @var string

	 */

	var $term_taxonomy;

	/*

	 * Global and Multisite tables

	 */

	/**

	 * WordPress User Metadata table

	 *

	 * @since 2.3.0

	 * @access public

	 * @var string

	 */

	var $usermeta;

	/**

	 * WordPress Users table

	 *

	 * @since 1.5.0

	 * @access public

	 * @var string

	 */

	var $users;

	/**

	 * Multisite Blogs table

	 *

	 * @since 3.0.0

	 * @access public

	 * @var string

	 */

	var $blogs;

	/**

	 * Multisite Blog Versions table

	 *

	 * @since 3.0.0

	 * @access public

	 * @var string

	 */

	var $blog_versions;

	/**

	 * Multisite Registration Log table

	 *

	 * @since 3.0.0

	 * @access public

	 * @var string

	 */

	var $registration_log;

	/**

	 * Multisite Signups table

	 *

	 * @since 3.0.0

	 * @access public

	 * @var string

	 */

	var $signups;

	/**

	 * Multisite Sites table

	 *

	 * @since 3.0.0

	 * @access public

	 * @var string

	 */

	var $site;

	/**

	 * Multisite Sitewide Terms table

	 *

	 * @since 3.0.0

	 * @access public

	 * @var string

	 */

	var $sitecategories;

	/**

	 * Multisite Site Metadata table

	 *

	 * @since 3.0.0

	 * @access public

	 * @var string

	 */

	var $sitemeta;

	/**

	 * Format specifiers for DB columns. Columns not listed here default to %s. Initialized during WP load.

	 *

	 * Keys are column names, values are format types: 'ID' => '%d'

	 *

	 * @since 2.8.0

	 * @see wpdb::prepare()

	 * @see wpdb::insert()

	 * @see wpdb::update()

	 * @see wpdb::delete()

	 * @see wp_set_wpdb_vars()

	 * @access public

	 * @var array

	 */

	var $field_types = array();

	/**

	 * Database table columns charset

	 *

	 * @since 2.2.0

	 * @access public

	 * @var string

	 */

	var $charset;

	/**

	 * Database table columns collate

	 *

	 * @since 2.2.0

	 * @access public

	 * @var string

	 */

	var $collate;

	/**

	 * Whether to use mysql_real_escape_string

	 *

	 * @since 2.8.0

	 * @access public

	 * @var bool

	 */

	var $real_escape = false;

	/**

	 * Database Username

	 *

	 * @since 2.9.0

	 * @access protected

	 * @var string

	 */

	protected $dbuser;

	/**

	 * Database Password

	 *

	 * @since 3.1.0

	 * @access protected

	 * @var string