<?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 {@internal Version Unknown}}

 */

define('OBJECT_K', 'OBJECT_K', false);

/**

 * @since 0.71

 */

define('ARRAY_A', 'ARRAY_A', false);

/**

 * @since 0.71

 */

define('ARRAY_N', 'ARRAY_N', false);

/**

 * 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 with your class. You can name it wpdb also, since

 * this file will not be included, if the other file is

 * available.

 *

 * @link http://codex.wordpress.org/Function_Reference/wpdb_Class

 *

 * @package WordPress

 * @subpackage Database

 * @since 0.71

 * @final

 */

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 {@internal Version Unknown}}

	 * @var bool

	 */

	var $suppress_errors = false;

	/**

	 * The last error during query.

	 *

	 * @since {@internal Version Unknown}}

	 * @var string

	 */

	var $last_error = '';

	/**

	 * Amount of queries made

	 *

	 * @since 1.2.0

	 * @access private

	 * @var int

	 */

	var $num_queries = 0;

	/**

	 * Saved result of the last query made

	 *

	 * @since 1.2.0

	 * @access private

	 * @var array

	 */

	var $last_query;

	/**

	 * Saved info on the table column

	 *

	 * @since 1.2.0

	 * @access private

	 * @var array

	 */

	var $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 0.71

	 * @access private

	 * @var string

	 */

	var $prefix = '';

	/**

	 * Whether the database queries are ready to start executing.

	 *

	 * @since 2.5.0

	 * @access private

	 * @var bool

	 */

	var $ready = false;

	/**

	 * WordPress Posts table

	 *

	 * @since 1.5.0

	 * @access public

	 * @var string

	 */

	var $posts;

	/**

	 * WordPress Users table

	 *

	 * @since 1.5.0

	 * @access public

	 * @var string

	 */

	var $users;

	/**

	 * WordPress Categories table

	 *

	 * @since 1.5.0

	 * @access public

	 * @var string

	 */

	var $categories;

	/**

	 * WordPress Post to Category table

	 *

	 * @since 1.5.0

	 * @access public

	 * @var string

	 */

	var $post2cat;

	/**

	 * WordPress Comments table

	 *

	 * @since 1.5.0

	 * @access public

	 * @var string

	 */

	var $comments;

	/**

	 * 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 {@internal Version Unknown}}

	 * @access public

	 * @var string

	 */

	var $postmeta;

	/**

	 * WordPress User Metadata table

	 *

	 * @since 2.3.0

	 * @access public

	 * @var string

	 */

	var $usermeta;

	/**

	 * WordPress Terms table

	 *

	 * @since 2.3.0

	 * @access public

	 * @var string

	 */

	var $terms;

	/**

	 * WordPress Term Taxonomy table

	 *

	 * @since 2.3.0

	 * @access public

	 * @var string

	 */

	var $term_taxonomy;

	/**

	 * WordPress Term Relationships table

	 *

	 * @since 2.3.0

	 * @access public

	 * @var string

	 */

	var $term_relationships;

	/**

	 * List of WordPress tables

	 *

	 * @since {@internal Version Unknown}}

	 * @access private

	 * @var array

	 */

	var $tables = array('users', 'usermeta', 'posts', 'categories', 'post2cat', 'comments', 'links', 'link2cat', 'options',

			'postmeta', 'terms', 'term_taxonomy', 'term_relationships');

	/**

	 * Format specifiers for DB columns. Columns not listed here default to %s.  Initialized in wp-settings.php.

	 *

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

	 *

	 * @since 2.8.0

	 * @see wpdb:prepare()

	 * @see wpdb:insert()

	 * @see wpdb:update()

	 * @access public

	 * @war 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;

	/**

	 * Connects to the database server and selects a database

	 *

	 * PHP4 compatibility layer for calling the PHP5 constructor.

	 *

	 * @uses wpdb::__construct() Passes parameters and returns result

	 * @since 0.71

	 *

	 * @param string $dbuser MySQL database user

	 * @param string $dbpassword MySQL database password

	 * @param string $dbname MySQL database name

	 * @param string $dbhost MySQL database host

	 */

	function wpdb($dbuser, $dbpassword, $dbname, $dbhost) {

		return $this->__construct($dbuser, $dbpassword, $dbname, $dbhost);

	}

	/**

	 * Connects to the database server and selects a database

	 *

	 * PHP5 style constructor for compatibility with PHP5. Does

	 * the actual setting up of the class properties and connection

	 * to the database.

	 *

	 * @since 2.0.8

	 *

	 * @param string $dbuser MySQL database user

	 * @param string $dbpassword MySQL database password

	 * @param string $dbname MySQL database name

	 * @param string $dbhost MySQL database host

	 */

	function __construct($dbuser, $dbpassword, $dbname, $dbhost) {

		register_shutdown_function(array(&$this, "__destruct"));

		if ( defined('WP_DEBUG') and WP_DEBUG == true )

			$this->show_errors();

		if ( defined('DB_CHARSET') )

			$this->charset = DB_CHARSET;

		if ( defined('DB_COLLATE') )

			$this->collate = DB_COLLATE;

		$this->dbh = @mysql_connect($dbhost, $dbuser, $dbpassword, true);

		if (!$this->dbh) {

			$this->bail(sprintf(/*WP_I18N_DB_CONN_ERROR*/'

<h1>Erreur lors de l&rsquo;établissement de la connexion &agrave; la base de données</h1>

<p>Cela signifie soit que l&rsquo;identifiant et/ou le mot de passe indiqués dans votre fichier <code>wp-config.php</code> sont incorrects, ou que le serveur de base de données à l&rsquo;adresse <code>%s</code> est inaccessible - ce qui implique que le serveur de base de données de votre hébergeur est sans doute défaillant.</p>

<ul>

	<li>Êtes-vous certain(e) d&rsquo;avoir correctement indiqué votre identifiant et votre mot de passe&nbsp;?</li>

	<li>Êtes-vous certain(e) d&rsquo;avoir entré le bon serveur de base de données&nbsp;?</li>

	<li>Êtes-vous certain(e) que le serveur de base de données fonctionne correctement&nbsp;?</li>

</ul>

<p>Si vous n&rsquo;êtes pas sûr(e) de bien comprendre les mots de cette liste, vous devriez sans doute prendre contact avec votre hébergeur. Si malgré cela cette erreur s&rsquo;affiche toujours, indiquez votre problème au <a href=\'http://www.wordpress-fr.net/support/\'>forum d&rsquo;entraide en français</a>.</p>

'/*/WP_I18N_DB_CONN_ERROR*/, $dbhost));

			return;

		}

		$this->ready = true;

		if ( $this->has_cap( 'collation' ) ) {

			if ( !empty($this->charset) ) {

				if ( function_exists('mysql_set_charset') ) {

					mysql_set_charset($this->charset, $this->dbh);

					$this->real_escape = true;

				} else {

					$collation_query = "SET NAMES '{$this->charset}'";

					if ( !empty($this->collate) )

						$collation_query .= " COLLATE '{$this->collate}'";

					$this->query($collation_query);

				}

			}

		}

		$this->select($dbname);

	}

	/**

	 * PHP5 style destructor and will run when database object is destroyed.

	 *

	 * @since 2.0.8

	 *

	 * @return bool Always true

	 */

	function __destruct() {

		return true;

	}

	/**

	 * Sets the table prefix for the WordPress tables.

	 *

	 * Also allows for the CUSTOM_USER_TABLE and CUSTOM_USER_META_TABLE to

	 * override the WordPress users and usersmeta tables that would otherwise be determined by the $prefix.

	 *

	 * @since 2.5.0

	 *

	 * @param string $prefix Alphanumeric name for the new prefix.

	 * @return string|WP_Error Old prefix or WP_Error on error

	 */

	function set_prefix($prefix) {

		if ( preg_match('|[^a-z0-9_]|i', $prefix) )

			return new WP_Error('invalid_db_prefix', /*WP_I18N_DB_BAD_PREFIX*/'Préfixe de la base de données invalide'/*/WP_I18N_DB_BAD_PREFIX*/);

		$old_prefix = $this->prefix;

		$this->prefix = $prefix;

		foreach ( (array) $this->tables as $table )

			$this->$table = $this->prefix . $table;

		if ( defined('CUSTOM_USER_TABLE') )

			$this->users = CUSTOM_USER_TABLE;

		if ( defined('CUSTOM_USER_META_TABLE') )

			$this->usermeta = CUSTOM_USER_META_TABLE;

		return $old_prefix;

	}

	/**

	 * Selects a database using the current database connection.

	 *

	 * The database name will be changed based on the current database

	 * connection. On failure, the execution will bail and display an DB error.

	 *

	 * @since 0.71

	 *

	 * @param string $db MySQL database name

	 * @return null Always null.

	 */

	function select($db) {

		if (!@mysql_select_db($db, $this->dbh)) {

			$this->ready = false;

			$this->bail(sprintf(/*WP_I18N_DB_SELECT_DB*/'

<h1>Impossible de sélectionner la base de données</h1>

<p>La connexion au serveur de base de données s&rsquo;est bien faite (donc votre identifiant et votre mot de passe sont les bons), mais la base de données <code>%1$s</code> n&rsquo;a pas pu être sélectionnée.</p>

<ul>

<li>Êtes-vous certain(e) qu&rsquo;elle existe&nbsp;?</li>

<li>L&rsquo;utilisateur <code>%2$s</code> a-t-il les droits pour utiliser la base de donn&eacute; <code>%1$s</code>&nbsp;?</li>

<li>Sur certains systèmes, le nom de votre base de données est préfixée de votre identifiant, donc son nom complet peut être <code>identifiant_nomdelabase</code>. Cela peut-il être la cause du problème&nbps;?</li>

</ul>

<p>Si vous ne savez pas comment régler votre base de données, vous devriez <strong>prendre contact avec votre hébergeur</strong>. Si toutes vos tentatives échouent, peut-être trouverez-vous une réponse sur le <a href=\'http://www.wordpress-fr.net/support/\'>forum d&rsquo;entraide en français</a>.</p>'/*/WP_I18N_DB_SELECT_DB*/, $db, DB_USER));

			return;

		}

	}

	function _weak_escape($string) {

		return addslashes($string);

	}

	function _real_escape($string) {

		if ( $this->dbh && $this->real_escape )

			return mysql_real_escape_string( $string, $this->dbh );

		else

			return addslashes( $string );

	}

	function _escape($data) {

		if ( is_array($data) ) {

			foreach ( (array) $data as $k => $v ) {

				if ( is_array($v) )

					$data[$k] = $this->_escape( $v );

				else

					$data[$k] = $this->_real_escape( $v );

			}

		} else {

			$data = $this->_real_escape( $data );

		}