<?php

/**

 * WordPress Upgrade API

 *

 * Most of the functions are pluggable and can be overwritten

 *

 * @package WordPress

 * @subpackage Administration

 */

/** Include user install customize script. */

if ( file_exists(WP_CONTENT_DIR . '/install.php') )

	require (WP_CONTENT_DIR . '/install.php');

/** WordPress Administration API */

require_once(ABSPATH . 'wp-admin/includes/admin.php');

/** WordPress Schema API */

require_once(ABSPATH . 'wp-admin/includes/schema.php');

if ( !function_exists('wp_install') ) :

/**

 * Installs the blog

 *

 * {@internal Missing Long Description}}

 *

 * @since 2.1.0

 *

 * @param string $blog_title Blog title.

 * @param string $user_name User's username.

 * @param string $user_email User's email.

 * @param bool $public Whether blog is public.

 * @param null $deprecated Optional. Not used.

 * @param string $user_password Optional. User's chosen password. Will default to a random password.

 * @return array Array keys 'url', 'user_id', 'password', 'password_message'.

 */

function wp_install( $blog_title, $user_name, $user_email, $public, $deprecated = '', $user_password = '' ) {

	if ( !empty( $deprecated ) )

		_deprecated_argument( __FUNCTION__, '2.6' );

	wp_check_mysql_version();

	wp_cache_flush();

	make_db_current_silent();

	populate_options();

	populate_roles();

	update_option('blogname', $blog_title);

	update_option('admin_email', $user_email);

	update_option('blog_public', $public);

	$guessurl = wp_guess_url();

	update_option('siteurl', $guessurl);

	// If not a public blog, don't ping.

	if ( ! $public )

		update_option('default_pingback_flag', 0);

	// Create default user. If the user already exists, the user tables are

	// being shared among blogs. Just set the role in that case.

	$user_id = username_exists($user_name);

	$user_password = trim($user_password);

	$email_password = false;

	if ( !$user_id && empty($user_password) ) {

		$user_password = wp_generate_password( 12, false );

		$message = __('<strong><em>Note that password</em></strong> carefully! It is a <em>random</em> password that was generated just for you.');

		$user_id = wp_create_user($user_name, $user_password, $user_email);

		update_user_option($user_id, 'default_password_nag', true, true);

		$email_password = true;

	} else if ( !$user_id ) {

		// Password has been provided

		$message = '<em>'.__('Your chosen password.').'</em>';

		$user_id = wp_create_user($user_name, $user_password, $user_email);

	} else {

		$message = __('User already exists. Password inherited.');

	}

	$user = new WP_User($user_id);

	$user->set_role('administrator');

	wp_install_defaults($user_id);

	flush_rewrite_rules();

	wp_new_blog_notification($blog_title, $guessurl, $user_id, ($email_password ? $user_password : __('The password you chose during the install.') ) );

	wp_cache_flush();

	return array('url' => $guessurl, 'user_id' => $user_id, 'password' => $user_password, 'password_message' => $message);

}

endif;

if ( !function_exists('wp_install_defaults') ) :

/**

 * {@internal Missing Short Description}}

 *

 * {@internal Missing Long Description}}

 *

 * @since 2.1.0

 *

 * @param int $user_id User ID.

 */

function wp_install_defaults($user_id) {

	global $wpdb, $wp_rewrite, $current_site, $table_prefix;

	// Default category

	$cat_name = __('Uncategorized');

	/* translators: Default category slug */

	$cat_slug = sanitize_title(_x('Uncategorized', 'Default category slug'));

	if ( global_terms_enabled() ) {

		$cat_id = $wpdb->get_var( $wpdb->prepare( "SELECT cat_ID FROM {$wpdb->sitecategories} WHERE category_nicename = %s", $cat_slug ) );

		if ( $cat_id == null ) {

			$wpdb->insert( $wpdb->sitecategories, array('cat_ID' => 0, 'cat_name' => $cat_name, 'category_nicename' => $cat_slug, 'last_updated' => current_time('mysql', true)) );

			$cat_id = $wpdb->insert_id;

		}

		update_option('default_category', $cat_id);

	} else {

		$cat_id = 1;

	}

	$wpdb->insert( $wpdb->terms, array('term_id' => $cat_id, 'name' => $cat_name, 'slug' => $cat_slug, 'term_group' => 0) );

	$wpdb->insert( $wpdb->term_taxonomy, array('term_id' => $cat_id, 'taxonomy' => 'category', 'description' => '', 'parent' => 0, 'count' => 1));

	$cat_tt_id = $wpdb->insert_id;

	// First post

	$now = date('Y-m-d H:i:s');

	$now_gmt = gmdate('Y-m-d H:i:s');

	$first_post_guid = get_option('home') . '/?p=1';

	if ( is_multisite() ) {

		$first_post = get_site_option( 'first_post' );

		if ( empty($first_post) )

			$first_post = stripslashes( __( 'Welcome to <a href="SITE_URL">SITE_NAME</a>. This is your first post. Edit or delete it, then start blogging!' ) );

		$first_post = str_replace( "SITE_URL", esc_url( network_home_url() ), $first_post );

		$first_post = str_replace( "SITE_NAME", $current_site->site_name, $first_post );

	} else {

		$first_post = __('Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!');

	}

	$wpdb->insert( $wpdb->posts, array(

								'post_author' => $user_id,

								'post_date' => $now,

								'post_date_gmt' => $now_gmt,

								'post_content' => $first_post,

								'post_excerpt' => '',

								'post_title' => __('Hello world!'),

								/* translators: Default post slug */

								'post_name' => sanitize_title( _x('hello-world', 'Default post slug') ),

								'post_modified' => $now,

								'post_modified_gmt' => $now_gmt,

								'guid' => $first_post_guid,

								'comment_count' => 1,

								'to_ping' => '',

								'pinged' => '',

								'post_content_filtered' => ''

								));

	$wpdb->insert( $wpdb->term_relationships, array('term_taxonomy_id' => $cat_tt_id, 'object_id' => 1) );

	// Default comment

	$first_comment_author = __('Mr WordPress');

	$first_comment_url = 'http://wordpress.org/';

	if ( is_multisite() ) {

		$first_comment_author = get_site_option( 'first_comment_author', $first_comment_author );

		$first_comment_url = get_site_option( 'first_comment_url', network_home_url() );

		$first_comment = get_site_option( 'first_comment', $first_comment );

	}

	$wpdb->insert( $wpdb->comments, array(

								'comment_post_ID' => 1,

								'comment_author' => $first_comment_author,

								'comment_author_email' => '',

								'comment_author_url' => $first_comment_url,

								'comment_date' => $now,

								'comment_date_gmt' => $now_gmt,

								'comment_content' => $first_comment

								));

	// First Page

	$first_page = sprintf( __( "This is an example page. It's different from a blog post because it will stay in one place and will show up in your site navigation (in most themes). Most people start with an About page that introduces them to potential site visitors. It might say something like this:

<blockquote>Hi there! I'm a bike messenger by day, aspiring actor by night, and this is my blog. I live in Los Angeles, have a great dog named Jack, and I like pi&#241;a coladas. (And gettin' caught in the rain.)</blockquote>

...or something like this:

As a new WordPress user, you should go to <a href=\"%s\">your dashboard</a> to delete this page and create new pages for your content. Have fun!" ), admin_url() );

	if ( is_multisite() )

		$first_page = get_site_option( 'first_page', $first_page );

	$first_post_guid = get_option('home') . '/?page_id=2';

	$wpdb->insert( $wpdb->posts, array(

								'post_author' => $user_id,

								'post_date' => $now,

								'post_date_gmt' => $now_gmt,

								'post_content' => $first_page,

								'post_excerpt' => '',

								'post_title' => __( 'Sample Page' ),

								/* translators: Default page slug */

								'post_name' => __( 'sample-page' ),

								'post_modified' => $now,

								'post_modified_gmt' => $now_gmt,

								'guid' => $first_post_guid,

								'post_type' => 'page',

								'to_ping' => '',

								'pinged' => '',

								'post_content_filtered' => ''

								));

	$wpdb->insert( $wpdb->postmeta, array( 'post_id' => 2, 'meta_key' => '_wp_page_template', 'meta_value' => 'default' ) );

	// Set up default widgets for default theme.

	update_option( 'widget_search', array ( 2 => array ( 'title' => '' ), '_multiwidget' => 1 ) );

	update_option( 'widget_recent-posts', array ( 2 => array ( 'title' => '', 'number' => 5 ), '_multiwidget' => 1 ) );

	update_option( 'widget_recent-comments', array ( 2 => array ( 'title' => '', 'number' => 5 ), '_multiwidget' => 1 ) );

	update_option( 'widget_archives', array ( 2 => array ( 'title' => '', 'count' => 0, 'dropdown' => 0 ), '_multiwidget' => 1 ) );

	update_option( 'widget_categories', array ( 2 => array ( 'title' => '', 'count' => 0, 'hierarchical' => 0, 'dropdown' => 0 ), '_multiwidget' => 1 ) );

	update_option( 'widget_meta', array ( 2 => array ( 'title' => '' ), '_multiwidget' => 1 ) );

	if ( ! is_multisite() )

		update_user_meta( $user_id, 'show_welcome_panel', 1 );

	elseif ( ! is_super_admin( $user_id ) && ! metadata_exists( 'user', $user_id, 'show_welcome_panel' ) )

		update_user_meta( $user_id, 'show_welcome_panel', 2 );

	if ( is_multisite() ) {

		// Flush rules to pick up the new page.

		$wp_rewrite->init();

		$wp_rewrite->flush_rules();

		$user = new WP_User($user_id);

		$wpdb->update( $wpdb->options, array('option_value' => $user->user_email), array('option_name' => 'admin_email') );

		// Remove all perms except for the login user.

		$wpdb->query( $wpdb->prepare("DELETE FROM $wpdb->usermeta WHERE user_id != %d AND meta_key = %s", $user_id, $table_prefix.'user_level') );

		$wpdb->query( $wpdb->prepare("DELETE FROM $wpdb->usermeta WHERE user_id != %d AND meta_key = %s", $user_id, $table_prefix.'capabilities') );

		// Delete any caps that snuck into the previously active blog. (Hardcoded to blog 1 for now.) TODO: Get previous_blog_id.

		if ( !is_super_admin( $user_id ) && $user_id != 1 )

			$wpdb->delete( $wpdb->usermeta, array( 'user_id' => $user_id , 'meta_key' => $wpdb->base_prefix.'1_capabilities' ) );

	}

}

endif;

if ( !function_exists('wp_new_blog_notification') ) :

/**

 * {@internal Missing Short Description}}

 *

 * {@internal Missing Long Description}}

 *

 * @since 2.1.0

 *

 * @param string $blog_title Blog title.

 * @param string $blog_url Blog url.

 * @param int $user_id User ID.

 * @param string $password User's Password.

 */

function wp_new_blog_notification($blog_title, $blog_url, $user_id, $password) {

	$email = $user->user_email;

	$name = $user->user_login;

	$message = sprintf(__("Your new WordPress site has been successfully set up at:

%1\$s

You can log in to the administrator account with the following information:

Username: %2\$s

Password: %3\$s

We hope you enjoy your new site. Thanks!

--The WordPress Team

http://wordpress.org/

"), $blog_url, $name, $password);

	@wp_mail($email, __('New WordPress Site'), $message);

}

endif;

if ( !function_exists('wp_upgrade') ) :

/**

 * Run WordPress Upgrade functions.

 *

 * {@internal Missing Long Description}}

 *

 * @since 2.1.0

 *

 * @return null

 */

function wp_upgrade() {

	global $wp_current_db_version, $wp_db_version, $wpdb;

	$wp_current_db_version = __get_option('db_version');

	// We are up-to-date. Nothing to do.

	if ( $wp_db_version == $wp_current_db_version )

		return;

	if ( ! is_blog_installed() )

		return;

	wp_check_mysql_version();

	wp_cache_flush();

	pre_schema_upgrade();

	make_db_current_silent();

	upgrade_all();

	if ( is_multisite() && is_main_site() )

		upgrade_network();

	wp_cache_flush();

	if ( is_multisite() ) {

		if ( $wpdb->get_row( "SELECT blog_id FROM {$wpdb->blog_versions} WHERE blog_id = '{$wpdb->blogid}'" ) )

			$wpdb->query( "UPDATE {$wpdb->blog_versions} SET db_version = '{$wp_db_version}' WHERE blog_id = '{$wpdb->blogid}'" );

		else

			$wpdb->query( "INSERT INTO {$wpdb->blog_versions} ( `blog_id` , `db_version` , `last_updated` ) VALUES ( '{$wpdb->blogid}', '{$wp_db_version}', NOW());" );

	}

}

endif;

/**

 * Functions to be called in install and upgrade scripts.

 *

 * {@internal Missing Long Description}}

 *

 * @since 1.0.1

 */

function upgrade_all() {

	global $wp_current_db_version, $wp_db_version;

	$wp_current_db_version = __get_option('db_version');

	// We are up-to-date. Nothing to do.

	if ( $wp_db_version == $wp_current_db_version )

		return;

	// If the version is not set in the DB, try to guess the version.

	if ( empty($wp_current_db_version) ) {

		$wp_current_db_version = 0;

		// If the template option exists, we have 1.5.

		$template = __get_option('template');

		if ( !empty($template) )

			$wp_current_db_version = 2541;

	}

	if ( $wp_current_db_version < 6039 )

		upgrade_230_options_table();

	populate_options();

	if ( $wp_current_db_version < 2541 ) {

		upgrade_100();

		upgrade_101();

		upgrade_110();

		upgrade_130();

	}

	if ( $wp_current_db_version < 3308 )

		upgrade_160();

	if ( $wp_current_db_version < 4772 )

		upgrade_210();

	if ( $wp_current_db_version < 4351 )

		upgrade_old_slugs();

	if ( $wp_current_db_version < 5539 )

		upgrade_230();

	if ( $wp_current_db_version < 6124 )

		upgrade_230_old_tables();

	if ( $wp_current_db_version < 7499 )

		upgrade_250();

	if ( $wp_current_db_version < 7935 )

		upgrade_252();

	if ( $wp_current_db_version < 8201 )

		upgrade_260();

	if ( $wp_current_db_version < 8989 )

		upgrade_270();

	if ( $wp_current_db_version < 10360 )

		upgrade_280();

	if ( $wp_current_db_version < 11958 )

		upgrade_290();

	if ( $wp_current_db_version < 15260 )

		upgrade_300();

	if ( $wp_current_db_version < 19389 )

		upgrade_330();

	if ( $wp_current_db_version < 20080 )