<?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 unknown

 *

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

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

 */

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

	global $wp_rewrite;

	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);

	if ( !$user_id ) {

		$random_password = wp_generate_password();

		$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, $random_password, $user_email);

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

	} else {

		$random_password = '';

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

	}

	$user = new WP_User($user_id);

	$user->set_role('administrator');

	wp_install_defaults($user_id);

	$wp_rewrite->flush_rules();

	wp_new_blog_notification($blog_title, $guessurl, $user_id, $random_password);

	wp_cache_flush();

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

}

endif;

if ( !function_exists('wp_install_defaults') ) :

/**

 * {@internal Missing Short Description}}

 *

 * {@internal Missing Long Description}}

 *

 * @since unknown

 *

 * @param int $user_id User ID.

 */

function wp_install_defaults($user_id) {

	global $wpdb;

	// Default category

	$cat_name = __('Uncategorized');

	/* translators: Default category slug */

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

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

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

	// Default link category

	$cat_name = __('Blogroll');

	/* translators: Default link category slug */

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

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

	$wpdb->insert( $wpdb->term_taxonomy, array('term_id' => '2', 'taxonomy' => 'link_category', 'description' => '', 'parent' => 0, 'count' => 7));

	// Now drop in some default links

	$default_links = array();

	$default_links[] = array(	'link_url' => 'http://codex.wordpress.org/',

								'link_name' => 'Documentation',

								'link_rss' => '',

								'link_notes' => '');

	$default_links[] = array(	'link_url' => 'http://wordpress.org/development/',

								'link_name' => 'Development Blog',

								'link_rss' => 'http://wordpress.org/development/feed/',

								'link_notes' => '');

	$default_links[] = array(	'link_url' => 'http://wordpress.org/extend/ideas/',

								'link_name' => 'Suggest Ideas',

								'link_rss' => '',

								'link_notes' =>'');

	$default_links[] = array(	'link_url' => 'http://wordpress.org/support/',

								'link_name' => 'Support Forum',

								'link_rss' => '',

								'link_notes' =>'');

	$default_links[] = array(	'link_url' => 'http://wordpress.org/extend/plugins/',

								'link_name' => 'Plugins',

								'link_rss' => '',

								'link_notes' =>'');

	$default_links[] = array(	'link_url' => 'http://wordpress.org/extend/themes/',

								'link_name' => 'Themes',

								'link_rss' => '',

								'link_notes' =>'');

	$default_links[] = array(	'link_url' => 'http://planet.wordpress.org/',

								'link_name' => 'WordPress Planet',

								'link_rss' => '',

								'link_notes' =>'');

	foreach ( $default_links as $link ) {

		$wpdb->insert( $wpdb->links, $link);

		$wpdb->insert( $wpdb->term_relationships, array('term_taxonomy_id' => 2, 'object_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';

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

								'post_author' => $user_id,

								'post_date' => $now,

								'post_date_gmt' => $now_gmt,

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

								'post_excerpt' => '',

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

								/* translators: Default post slug */

								'post_name' => _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' => 1, 'object_id' => 1) );

	// Default comment

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

								'comment_post_ID' => 1,

								'comment_author' => __('Mr WordPress'),

								'comment_author_email' => '',

								'comment_author_url' => 'http://wordpress.org/',

								'comment_date' => $now,

								'comment_date_gmt' => $now_gmt,

								'comment_content' => __('Hi, this is a comment.<br />To delete a comment, just log in and view the post&#039;s comments. There you will have the option to edit or delete them.')

								));

	// 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' => __('This is an example of a WordPress page, you could edit this to put information about yourself or your site so readers know where you are coming from. You can create as many pages like this one or sub-pages as you like and manage all of your content inside of WordPress.'),

								'post_excerpt' => '',

								'post_title' => __('About'),

								/* translators: Default page slug */

								'post_name' => _x('about', 'Default page slug'),

								'post_modified' => $now,

								'post_modified_gmt' => $now_gmt,

								'guid' => $first_post_guid,

								'post_type' => 'page',

								'to_ping' => '',

								'pinged' => '',

								'post_content_filtered' => ''

								));

}

endif;

if ( !function_exists('wp_new_blog_notification') ) :

/**

 * {@internal Missing Short Description}}

 *

 * {@internal Missing Long Description}}

 *

 * @since unknown

 *

 * @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) {

	$user = new WP_User($user_id);

	$email = $user->user_email;

	$name = $user->user_login;

	$message = sprintf(__("Your new WordPress blog 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 blog. Thanks!

--The WordPress Team

http://wordpress.org/

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

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

}

endif;

if ( !function_exists('wp_upgrade') ) :

/**

 * Run WordPress Upgrade functions.

 *

 * {@internal Missing Long Description}}

 *

 * @since unknown

 *

 * @return null

 */

function wp_upgrade() {

	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( ! is_blog_installed() )

		return;

	wp_check_mysql_version();

	wp_cache_flush();

	pre_schema_upgrade();

	make_db_current_silent();

	upgrade_all();

	wp_cache_flush();

}

endif;

/**

 * Functions to be called in install and upgrade scripts.

 *

 * {@internal Missing Long Description}}

 *

 * @since unknown

 */

function upgrade_all() {

	global $wp_current_db_version, $wp_db_version, $wp_rewrite;

	$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 < 7796 )

		upgrade_251();

	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();

	maybe_disable_automattic_widgets();

	update_option( 'db_version', $wp_db_version );

	update_option( 'db_upgraded', true );

}

/**

 * Execute changes made in WordPress 1.0.

 *

 * @since 1.0.0

 */

function upgrade_100() {

	global $wpdb;

	// Get the title and ID of every post, post_name to check if it already has a value

	$posts = $wpdb->get_results("SELECT ID, post_title, post_name FROM $wpdb->posts WHERE post_name = ''");

	if ($posts) {

		foreach($posts as $post) {

			if ('' == $post->post_name) {

				$newtitle = sanitize_title($post->post_title);

				$wpdb->query( $wpdb->prepare("UPDATE $wpdb->posts SET post_name = %s WHERE ID = %d", $newtitle, $post->ID) );

			}

		}

	}

	$categories = $wpdb->get_results("SELECT cat_ID, cat_name, category_nicename FROM $wpdb->categories");

	foreach ($categories as $category) {

		if ('' == $category->category_nicename) {

			$newtitle = sanitize_title($category->cat_name);

			$wpdb>update( $wpdb->categories, array('category_nicename' => $newtitle), array('cat_ID' => $category->cat_ID) );

		}

	}

	$wpdb->query("UPDATE $wpdb->options SET option_value = REPLACE(option_value, 'wp-links/links-images/', 'wp-images/links/')

	WHERE option_name LIKE 'links_rating_image%'

	AND option_value LIKE 'wp-links/links-images/%'");

	$done_ids = $wpdb->get_results("SELECT DISTINCT post_id FROM $wpdb->post2cat");

	if ($done_ids) :

		foreach ($done_ids as $done_id) :

			$done_posts[] = $done_id->post_id;

		endforeach;

		$catwhere = ' AND ID NOT IN (' . implode(',', $done_posts) . ')';

	else:

		$catwhere = '';

	endif;

	$allposts = $wpdb->get_results("SELECT ID, post_category FROM $wpdb->posts WHERE post_category != '0' $catwhere");

	if ($allposts) :

		foreach ($allposts as $post) {

			// Check to see if it's already been imported

			$cat = $wpdb->get_row( $wpdb->prepare("SELECT * FROM $wpdb->post2cat WHERE post_id = %d AND category_id = %d", $post->ID, $post->post_category) );

			if (!$cat && 0 != $post->post_category) { // If there's no result