1 <?php

     2 /**

     3  * WordPress Upgrade API

     4  *

     5  * Most of the functions are pluggable and can be overwritten

     6  *

     7  * @package WordPress

     8  * @subpackage Administration

     9  */

    10 

    11 /** Include user install customize script. */

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

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

    14 

    15 /** WordPress Administration API */

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

    17 

    18 /** WordPress Schema API */

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

    20 

    21 if ( !function_exists('wp_install') ) :

    22 /**

    23  * Installs the blog

    24  *

    25  * {@internal Missing Long Description}}

    26  *

    27  * @since unknown

    28  *

    29  * @param string $blog_title Blog title.

    30  * @param string $user_name User's username.

    31  * @param string $user_email User's email.

    32  * @param bool $public Whether blog is public.

    33  * @param null $deprecated Optional. Not used.

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

    35  */

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

    37 	global $wp_rewrite;

    38 

    39 	wp_check_mysql_version();

    40 	wp_cache_flush();

    41 	make_db_current_silent();

    42 	populate_options();

    43 	populate_roles();

    44 

    45 	update_option('blogname', $blog_title);

    46 	update_option('admin_email', $user_email);

    47 	update_option('blog_public', $public);

    48 

    49 	$guessurl = wp_guess_url();

    50 

    51 	update_option('siteurl', $guessurl);

    52 

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

    54 	if ( ! $public )

    55 		update_option('default_pingback_flag', 0);

    56 

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

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

    59 	$user_id = username_exists($user_name);

    60 	if ( !$user_id ) {

    61 		$random_password = wp_generate_password();

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

    63 		$user_id = wp_create_user($user_name, $random_password, $user_email);

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

    65 	} else {

    66 		$random_password = '';

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

    68 	}

    69 

    70 	$user = new WP_User($user_id);

    71 	$user->set_role('administrator');

    72 

    73 	wp_install_defaults($user_id);

    74 

    75 	$wp_rewrite->flush_rules();

    76 

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

    78 

    79 	wp_cache_flush();

    80 

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

    82 }

    83 endif;

    84 

    85 if ( !function_exists('wp_install_defaults') ) :

    86 /**

    87  * {@internal Missing Short Description}}

    88  *

    89  * {@internal Missing Long Description}}

    90  *

    91  * @since unknown

    92  *

    93  * @param int $user_id User ID.

    94  */

    95 function wp_install_defaults($user_id) {

    96 	global $wpdb;

    97 

    98 	// Default category

    99 	$cat_name = __('Uncategorized');

   100 	/* translators: Default category slug */

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

   102 

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

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

   105 

   106 	// Default link category

   107 	$cat_name = __('Blogroll');

   108 	/* translators: Default link category slug */

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

   110 

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

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

   113 

   114 	// Now drop in some default links

   115 	$default_links = array();

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

   117 								'link_name' => 'Documentation',

   118 								'link_rss' => '',

   119 								'link_notes' => '');

   120 

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

   122 								'link_name' => 'Development Blog',

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

   124 								'link_notes' => '');

   125 

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

   127 								'link_name' => 'Suggest Ideas',

   128 								'link_rss' => '',

   129 								'link_notes' =>'');

   130 

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

   132 								'link_name' => 'Support Forum',

   133 								'link_rss' => '',

   134 								'link_notes' =>'');

   135 

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

   137 								'link_name' => 'Plugins',

   138 								'link_rss' => '',

   139 								'link_notes' =>'');

   140 

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

   142 								'link_name' => 'Themes',

   143 								'link_rss' => '',

   144 								'link_notes' =>'');

   145 

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

   147 								'link_name' => 'WordPress Planet',

   148 								'link_rss' => '',

   149 								'link_notes' =>'');

   150 

   151 	foreach ( $default_links as $link ) {

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

   153 		$wpdb->insert( $wpdb->term_relationships, array('term_taxonomy_id' => 2, 'object_id' => $wpdb->insert_id) );

   154 	}

   155 

   156 	// First post

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

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

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

   160 

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

   162 								'post_author' => $user_id,

   163 								'post_date' => $now,

   164 								'post_date_gmt' => $now_gmt,

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

   166 								'post_excerpt' => '',

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

   168 								/* translators: Default post slug */

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

   170 								'post_modified' => $now,

   171 								'post_modified_gmt' => $now_gmt,

   172 								'guid' => $first_post_guid,

   173 								'comment_count' => 1,

   174 								'to_ping' => '',

   175 								'pinged' => '',

   176 								'post_content_filtered' => ''

   177 								));

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

   179 

   180 	// Default comment

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

   182 								'comment_post_ID' => 1,

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

   184 								'comment_author_email' => '',

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

   186 								'comment_date' => $now,

   187 								'comment_date_gmt' => $now_gmt,

   188 								'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.')

   189 								));

   190 	// First Page

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

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

   193 								'post_author' => $user_id,

   194 								'post_date' => $now,

   195 								'post_date_gmt' => $now_gmt,

   196 								'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.'),

   197 								'post_excerpt' => '',

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

   199 								/* translators: Default page slug */

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

   201 								'post_modified' => $now,

   202 								'post_modified_gmt' => $now_gmt,

   203 								'guid' => $first_post_guid,

   204 								'post_type' => 'page',

   205 								'to_ping' => '',

   206 								'pinged' => '',

   207 								'post_content_filtered' => ''

   208 								));

   209 }

   210 endif;

   211 

   212 if ( !function_exists('wp_new_blog_notification') ) :

   213 /**

   214  * {@internal Missing Short Description}}

   215  *

   216  * {@internal Missing Long Description}}

   217  *

   218  * @since unknown

   219  *

   220  * @param string $blog_title Blog title.

   221  * @param string $blog_url Blog url.

   222  * @param int $user_id User ID.

   223  * @param string $password User's Password.

   224  */

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

   226 	$user = new WP_User($user_id);

   227 	$email = $user->user_email;

   228 	$name = $user->user_login;

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

   230 

   231 %1\$s

   232 

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

   234 

   235 Username: %2\$s

   236 Password: %3\$s

   237 

   238 We hope you enjoy your new blog. Thanks!

   239 

   240 --The WordPress Team

   241 http://wordpress.org/

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

   243 

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

   245 }

   246 endif;

   247 

   248 if ( !function_exists('wp_upgrade') ) :

   249 /**

   250  * Run WordPress Upgrade functions.

   251  *

   252  * {@internal Missing Long Description}}

   253  *

   254  * @since unknown

   255  *

   256  * @return null

   257  */

   258 function wp_upgrade() {

   259 	global $wp_current_db_version, $wp_db_version;

   260 

   261 	$wp_current_db_version = __get_option('db_version');

   262 

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

   264 	if ( $wp_db_version == $wp_current_db_version )

   265 		return;

   266 

   267 	if( ! is_blog_installed() )

   268 		return;

   269 

   270 	wp_check_mysql_version();

   271 	wp_cache_flush();

   272 	pre_schema_upgrade();

   273 	make_db_current_silent();

   274 	upgrade_all();

   275 	wp_cache_flush();

   276 }

   277 endif;

   278 

   279 /**

   280  * Functions to be called in install and upgrade scripts.

   281  *

   282  * {@internal Missing Long Description}}

   283  *

   284  * @since unknown

   285  */

   286 function upgrade_all() {

   287 	global $wp_current_db_version, $wp_db_version, $wp_rewrite;

   288 	$wp_current_db_version = __get_option('db_version');

   289 

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

   291 	if ( $wp_db_version == $wp_current_db_version )

   292 		return;

   293 

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

   295 	if ( empty($wp_current_db_version) ) {

   296 		$wp_current_db_version = 0;

   297 

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

   299 		$template = __get_option('template');

   300 		if ( !empty($template) )

   301 			$wp_current_db_version = 2541;

   302 	}

   303 

   304 	if ( $wp_current_db_version < 6039 )

   305 		upgrade_230_options_table();

   306 

   307 	populate_options();

   308 

   309 	if ( $wp_current_db_version < 2541 ) {

   310 		upgrade_100();

   311 		upgrade_101();

   312 		upgrade_110();

   313 		upgrade_130();

   314 	}

   315 

   316 	if ( $wp_current_db_version < 3308 )

   317 		upgrade_160();

   318 

   319 	if ( $wp_current_db_version < 4772 )

   320 		upgrade_210();

   321 

   322 	if ( $wp_current_db_version < 4351 )

   323 		upgrade_old_slugs();

   324 

   325 	if ( $wp_current_db_version < 5539 )

   326 		upgrade_230();

   327 

   328 	if ( $wp_current_db_version < 6124 )

   329 		upgrade_230_old_tables();

   330 

   331 	if ( $wp_current_db_version < 7499 )

   332 		upgrade_250();

   333 

   334 	if ( $wp_current_db_version < 7796 )

   335 		upgrade_251();

   336 

   337 	if ( $wp_current_db_version < 7935 )

   338 		upgrade_252();

   339 

   340 	if ( $wp_current_db_version < 8201 )

   341 		upgrade_260();

   342 

   343 	if ( $wp_current_db_version < 8989 )

   344 		upgrade_270();

   345 

   346 	if ( $wp_current_db_version < 10360 )

   347 		upgrade_280();

   348 

   349 	if ( $wp_current_db_version < 11958 )

   350 		upgrade_290();

   351 

   352 	maybe_disable_automattic_widgets();

   353 

   354 	update_option( 'db_version', $wp_db_version );

   355 	update_option( 'db_upgraded', true );

   356 }

   357 

   358 /**

   359  * Execute changes made in WordPress 1.0.

   360  *

   361  * @since 1.0.0

   362  */

   363 function upgrade_100() {

   364 	global $wpdb;

   365 

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

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

   368 	if ($posts) {

   369 		foreach($posts as $post) {

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

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

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

   373 			}

   374 		}

   375 	}

   376 

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

   378 	foreach ($categories as $category) {

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

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

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

   382 		}

   383 	}

   384 

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

   386 	WHERE option_name LIKE 'links_rating_image%'

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

   388 

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

   390 	if ($done_ids) :

   391 		foreach ($done_ids as $done_id) :

   392 			$done_posts[] = $done_id->post_id;

   393 		endforeach;

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

   395 	else:

   396 		$catwhere = '';

   397 	endif;

   398 

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

   400 	if ($allposts) :

   401 		foreach ($allposts as $post) {

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

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

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

   405 				$wpdb->insert( $wpdb->post2cat, array('post_id' => $post->ID, 'category_id' => $post->post_category) );

   406 			}

   407 		}

   408 	endif;

   409 }

   410 

   411 /**

   412  * Execute changes made in WordPress 1.0.1.

   413  *

   414  * @since 1.0.1

   415  */

   416 function upgrade_101() {

   417 	global $wpdb;

   418 

   419 	// Clean up indices, add a few

   420 	add_clean_index($wpdb->posts, 'post_name');

   421 	add_clean_index($wpdb->posts, 'post_status');

   422 	add_clean_index($wpdb->categories, 'category_nicename');

   423 	add_clean_index($wpdb->comments, 'comment_approved');

   424 	add_clean_index($wpdb->comments, 'comment_post_ID');

   425 	add_clean_index($wpdb->links , 'link_category');

   426 	add_clean_index($wpdb->links , 'link_visible');

   427 }

   428 

   429 /**

   430  * Execute changes made in WordPress 1.2.

   431  *

   432  * @since 1.2.0

   433  */

   434 function upgrade_110() {

   435 	global $wpdb;

   436 

   437 	// Set user_nicename.

   438 	$users = $wpdb->get_results("SELECT ID, user_nickname, user_nicename FROM $wpdb->users");

   439 	foreach ($users as $user) {

   440 		if ('' == $user->user_nicename) {

   441 			$newname = sanitize_title($user->user_nickname);

   442 			$wpdb->update( $wpdb->users, array('user_nicename' => $newname), array('ID' => $user->ID) );

   443 		}

   444 	}

   445 

   446 	$users = $wpdb->get_results("SELECT ID, user_pass from $wpdb->users");

   447 	foreach ($users as $row) {

   448 		if (!preg_match('/^[A-Fa-f0-9]{32}$/', $row->user_pass)) {

   449 			$wpdb->update( $wpdb->users, array('user_pass' => md5($row->user_pass)), array('ID' => $row->ID) );

   450 		}

   451 	}

   452 

   453 	// Get the GMT offset, we'll use that later on

   454 	$all_options = get_alloptions_110();

   455 

   456 	$time_difference = $all_options->time_difference;

   457 

   458 	$server_time = time()+date('Z');

   459 	$weblogger_time = $server_time + $time_difference*3600;

   460 	$gmt_time = time();

   461 

   462 	$diff_gmt_server = ($gmt_time - $server_time) / 3600;

   463 	$diff_weblogger_server = ($weblogger_time - $server_time) / 3600;

   464 	$diff_gmt_weblogger = $diff_gmt_server - $diff_weblogger_server;

   465 	$gmt_offset = -$diff_gmt_weblogger;

   466 

   467 	// Add a gmt_offset option, with value $gmt_offset

   468 	add_option('gmt_offset', $gmt_offset);

   469 

   470 	// Check if we already set the GMT fields (if we did, then

   471 	// MAX(post_date_gmt) can't be '0000-00-00 00:00:00'

   472 	// <michel_v> I just slapped myself silly for not thinking about it earlier

   473 	$got_gmt_fields = ($wpdb->get_var("SELECT MAX(post_date_gmt) FROM $wpdb->posts") == '0000-00-00 00:00:00') ? false : true;

   474 

   475 	if (!$got_gmt_fields) {

   476 

   477 		// Add or substract time to all dates, to get GMT dates

   478 		$add_hours = intval($diff_gmt_weblogger);

   479 		$add_minutes = intval(60 * ($diff_gmt_weblogger - $add_hours));

   480 		$wpdb->query("UPDATE $wpdb->posts SET post_date_gmt = DATE_ADD(post_date, INTERVAL '$add_hours:$add_minutes' HOUR_MINUTE)");

   481 		$wpdb->query("UPDATE $wpdb->posts SET post_modified = post_date");

   482 		$wpdb->query("UPDATE $wpdb->posts SET post_modified_gmt = DATE_ADD(post_modified, INTERVAL '$add_hours:$add_minutes' HOUR_MINUTE) WHERE post_modified != '0000-00-00 00:00:00'");

   483 		$wpdb->query("UPDATE $wpdb->comments SET comment_date_gmt = DATE_ADD(comment_date, INTERVAL '$add_hours:$add_minutes' HOUR_MINUTE)");

   484 		$wpdb->query("UPDATE $wpdb->users SET user_registered = DATE_ADD(user_registered, INTERVAL '$add_hours:$add_minutes' HOUR_MINUTE)");

   485 	}

   486 

   487 }

   488 

   489 /**

   490  * Execute changes made in WordPress 1.5.

   491  *

   492  * @since 1.5.0

   493  */

   494 function upgrade_130() {

   495 	global $wpdb;

   496 

   497 	// Remove extraneous backslashes.

   498 	$posts = $wpdb->get_results("SELECT ID, post_title, post_content, post_excerpt, guid, post_date, post_name, post_status, post_author FROM $wpdb->posts");

   499 	if ($posts) {

   500 		foreach($posts as $post) {

   501 			$post_content = addslashes(deslash($post->post_content));

   502 			$post_title = addslashes(deslash($post->post_title));

   503 			$post_excerpt = addslashes(deslash($post->post_excerpt));

   504 			if ( empty($post->guid) )

   505 				$guid = get_permalink($post->ID);

   506 			else

   507 				$guid = $post->guid;

   508 

   509 			$wpdb->update( $wpdb->posts, compact('post_title', 'post_content', 'post_excerpt', 'guid'), array('ID' => $post->ID) );

   510 

   511 		}

   512 	}

   513 

   514 	// Remove extraneous backslashes.

   515 	$comments = $wpdb->get_results("SELECT comment_ID, comment_author, comment_content FROM $wpdb->comments");

   516 	if ($comments) {

   517 		foreach($comments as $comment) {

   518 			$comment_content = deslash($comment->comment_content);

   519 			$comment_author = deslash($comment->comment_author);

   520 

   521 			$wpdb->update($wpdb->comments, compact('comment_content', 'comment_author'), array('comment_ID' => $comment->comment_ID) );

   522 		}

   523 	}

   524 

   525 	// Remove extraneous backslashes.

   526 	$links = $wpdb->get_results("SELECT link_id, link_name, link_description FROM $wpdb->links");

   527 	if ($links) {

   528 		foreach($links as $link) {

   529 			$link_name = deslash($link->link_name);

   530 			$link_description = deslash($link->link_description);

   531 

   532 			$wpdb->update( $wpdb->links, compact('link_name', 'link_description'), array('link_id' => $link->link_id) );

   533 		}

   534 	}

   535 

   536 	$active_plugins = __get_option('active_plugins');

   537 

   538 	// If plugins are not stored in an array, they're stored in the old

   539 	// newline separated format.  Convert to new format.

   540 	if ( !is_array( $active_plugins ) ) {

   541 		$active_plugins = explode("\n", trim($active_plugins));

   542 		update_option('active_plugins', $active_plugins);

   543 	}

   544 

   545 	// Obsolete tables

   546 	$wpdb->query('DROP TABLE IF EXISTS ' . $wpdb->prefix . 'optionvalues');

   547 	$wpdb->query('DROP TABLE IF EXISTS ' . $wpdb->prefix . 'optiontypes');

   548 	$wpdb->query('DROP TABLE IF EXISTS ' . $wpdb->prefix . 'optiongroups');

   549 	$wpdb->query('DROP TABLE IF EXISTS ' . $wpdb->prefix . 'optiongroup_options');

   550 

   551 	// Update comments table to use comment_type

   552 	$wpdb->query("UPDATE $wpdb->comments SET comment_type='trackback', comment_content = REPLACE(comment_content, '<trackback />', '') WHERE comment_content LIKE '<trackback />%'");

   553 	$wpdb->query("UPDATE $wpdb->comments SET comment_type='pingback', comment_content = REPLACE(comment_content, '<pingback />', '') WHERE comment_content LIKE '<pingback />%'");

   554 

   555 	// Some versions have multiple duplicate option_name rows with the same values

   556 	$options = $wpdb->get_results("SELECT option_name, COUNT(option_name) AS dupes FROM `$wpdb->options` GROUP BY option_name");

   557 	foreach ( $options as $option ) {

   558 		if ( 1 != $option->dupes ) { // Could this be done in the query?

   559 			$limit = $option->dupes - 1;

   560 			$dupe_ids = $wpdb->get_col( $wpdb->prepare("SELECT option_id FROM $wpdb->options WHERE option_name = %s LIMIT %d", $option->option_name, $limit) );

   561 			if ( $dupe_ids ) {

   562 				$dupe_ids = join($dupe_ids, ',');

   563 				$wpdb->query("DELETE FROM $wpdb->options WHERE option_id IN ($dupe_ids)");

   564 			}

   565 		}

   566 	}

   567 

   568 	make_site_theme();

   569 }

   570 

   571 /**

   572  * Execute changes made in WordPress 2.0.

   573  *

   574  * @since 2.0.0

   575  */

   576 function upgrade_160() {

   577 	global $wpdb, $wp_current_db_version;

   578 

   579 	populate_roles_160();

   580 

   581 	$users = $wpdb->get_results("SELECT * FROM $wpdb->users");

   582 	foreach ( $users as $user ) :

   583 		if ( !empty( $user->user_firstname ) )

   584 			update_usermeta( $user->ID, 'first_name', $wpdb->escape($user->user_firstname) );

   585 		if ( !empty( $user->user_lastname ) )

   586 			update_usermeta( $user->ID, 'last_name', $wpdb->escape($user->user_lastname) );

   587 		if ( !empty( $user->user_nickname ) )

   588 			update_usermeta( $user->ID, 'nickname', $wpdb->escape($user->user_nickname) );

   589 		if ( !empty( $user->user_level ) )

   590 			update_usermeta( $user->ID, $wpdb->prefix . 'user_level', $user->user_level );

   591 		if ( !empty( $user->user_icq ) )

   592 			update_usermeta( $user->ID, 'icq', $wpdb->escape($user->user_icq) );

   593 		if ( !empty( $user->user_aim ) )

   594 			update_usermeta( $user->ID, 'aim', $wpdb->escape($user->user_aim) );

   595 		if ( !empty( $user->user_msn ) )

   596 			update_usermeta( $user->ID, 'msn', $wpdb->escape($user->user_msn) );

   597 		if ( !empty( $user->user_yim ) )

   598 			update_usermeta( $user->ID, 'yim', $wpdb->escape($user->user_icq) );

   599 		if ( !empty( $user->user_description ) )

   600 			update_usermeta( $user->ID, 'description', $wpdb->escape($user->user_description) );

   601 

   602 		if ( isset( $user->user_idmode ) ):

   603 			$idmode = $user->user_idmode;

   604 			if ($idmode == 'nickname') $id = $user->user_nickname;

   605 			if ($idmode == 'login') $id = $user->user_login;

   606 			if ($idmode == 'firstname') $id = $user->user_firstname;

   607 			if ($idmode == 'lastname') $id = $user->user_lastname;

   608 			if ($idmode == 'namefl') $id = $user->user_firstname.' '.$user->user_lastname;

   609 			if ($idmode == 'namelf') $id = $user->user_lastname.' '.$user->user_firstname;

   610 			if (!$idmode) $id = $user->user_nickname;

   611 			$wpdb->update( $wpdb->users, array('display_name' => $id), array('ID' => $user->ID) );

   612 		endif;

   613 

   614 		// FIXME: RESET_CAPS is temporary code to reset roles and caps if flag is set.

   615 		$caps = get_usermeta( $user->ID, $wpdb->prefix . 'capabilities');

   616 		if ( empty($caps) || defined('RESET_CAPS') ) {

   617 			$level = get_usermeta($user->ID, $wpdb->prefix . 'user_level');

   618 			$role = translate_level_to_role($level);

   619 			update_usermeta( $user->ID, $wpdb->prefix . 'capabilities', array($role => true) );

   620 		}

   621 

   622 	endforeach;

   623 	$old_user_fields = array( 'user_firstname', 'user_lastname', 'user_icq', 'user_aim', 'user_msn', 'user_yim', 'user_idmode', 'user_ip', 'user_domain', 'user_browser', 'user_description', 'user_nickname', 'user_level' );

   624 	$wpdb->hide_errors();

   625 	foreach ( $old_user_fields as $old )

   626 		$wpdb->query("ALTER TABLE $wpdb->users DROP $old");

   627 	$wpdb->show_errors();

   628 

   629 	// populate comment_count field of posts table

   630 	$comments = $wpdb->get_results( "SELECT comment_post_ID, COUNT(*) as c FROM $wpdb->comments WHERE comment_approved = '1' GROUP BY comment_post_ID" );

   631 	if( is_array( $comments ) )

   632 		foreach ($comments as $comment)

   633 			$wpdb->update( $wpdb->posts, array('comment_count' => $comment->c), array('ID' => $comment->comment_post_ID) );

   634 

   635 	// Some alpha versions used a post status of object instead of attachment and put

   636 	// the mime type in post_type instead of post_mime_type.

   637 	if ( $wp_current_db_version > 2541 && $wp_current_db_version <= 3091 ) {

   638 		$objects = $wpdb->get_results("SELECT ID, post_type FROM $wpdb->posts WHERE post_status = 'object'");

   639 		foreach ($objects as $object) {

   640 			$wpdb->update( $wpdb->posts, array(	'post_status' => 'attachment',

   641 												'post_mime_type' => $object->post_type,

   642 												'post_type' => ''),

   643 										 array( 'ID' => $object->ID ) );

   644 

   645 			$meta = get_post_meta($object->ID, 'imagedata', true);

   646 			if ( ! empty($meta['file']) )

   647 				update_attached_file( $object->ID, $meta['file'] );

   648 		}

   649 	}

   650 }

   651 

   652 /**

   653  * Execute changes made in WordPress 2.1.

   654  *

   655  * @since 2.1.0

   656  */

   657 function upgrade_210() {

   658 	global $wpdb, $wp_current_db_version;

   659 

   660 	if ( $wp_current_db_version < 3506 ) {

   661 		// Update status and type.

   662 		$posts = $wpdb->get_results("SELECT ID, post_status FROM $wpdb->posts");

   663 

   664 		if ( ! empty($posts) ) foreach ($posts as $post) {

   665 			$status = $post->post_status;

   666 			$type = 'post';

   667 

   668 			if ( 'static' == $status ) {

   669 				$status = 'publish';

   670 				$type = 'page';

   671 			} else if ( 'attachment' == $status ) {

   672 				$status = 'inherit';

   673 				$type = 'attachment';

   674 			}

   675 

   676 			$wpdb->query( $wpdb->prepare("UPDATE $wpdb->posts SET post_status = %s, post_type = %s WHERE ID = %d", $status, $type, $post->ID) );

   677 		}

   678 	}

   679 

   680 	if ( $wp_current_db_version < 3845 ) {

   681 		populate_roles_210();

   682 	}

   683 

   684 	if ( $wp_current_db_version < 3531 ) {

   685 		// Give future posts a post_status of future.

   686 		$now = gmdate('Y-m-d H:i:59');

   687 		$wpdb->query ("UPDATE $wpdb->posts SET post_status = 'future' WHERE post_status = 'publish' AND post_date_gmt > '$now'");

   688 

   689 		$posts = $wpdb->get_results("SELECT ID, post_date FROM $wpdb->posts WHERE post_status ='future'");

   690 		if ( !empty($posts) )

   691 			foreach ( $posts as $post )

   692 				wp_schedule_single_event(mysql2date('U', $post->post_date, false), 'publish_future_post', array($post->ID));

   693 	}

   694 }

   695 

   696 /**

   697  * Execute changes made in WordPress 2.3.

   698  *

   699  * @since 2.3.0

   700  */

   701 function upgrade_230() {

   702 	global $wp_current_db_version, $wpdb;

   703 

   704 	if ( $wp_current_db_version < 5200 ) {

   705 		populate_roles_230();

   706 	}

   707 

   708 	// Convert categories to terms.

   709 	$tt_ids = array();

   710 	$have_tags = false;

   711 	$categories = $wpdb->get_results("SELECT * FROM $wpdb->categories ORDER BY cat_ID");

   712 	foreach ($categories as $category) {

   713 		$term_id = (int) $category->cat_ID;

   714 		$name = $category->cat_name;

   715 		$description = $category->category_description;

   716 		$slug = $category->category_nicename;

   717 		$parent = $category->category_parent;

   718 		$term_group = 0;

   719 

   720 		// Associate terms with the same slug in a term group and make slugs unique.

   721 		if ( $exists = $wpdb->get_results( $wpdb->prepare("SELECT term_id, term_group FROM $wpdb->terms WHERE slug = %s", $slug) ) ) {

   722 			$term_group = $exists[0]->term_group;

   723 			$id = $exists[0]->term_id;

   724 			$num = 2;

   725 			do {

   726 				$alt_slug = $slug . "-$num";

   727 				$num++;

   728 				$slug_check = $wpdb->get_var( $wpdb->prepare("SELECT slug FROM $wpdb->terms WHERE slug = %s", $alt_slug) );

   729 			} while ( $slug_check );

   730 

   731 			$slug = $alt_slug;

   732 

   733 			if ( empty( $term_group ) ) {

   734 				$term_group = $wpdb->get_var("SELECT MAX(term_group) FROM $wpdb->terms GROUP BY term_group") + 1;

   735 				$wpdb->query( $wpdb->prepare("UPDATE $wpdb->terms SET term_group = %d WHERE term_id = %d", $term_group, $id) );

   736 			}

   737 		}

   738 

   739 		$wpdb->query( $wpdb->prepare("INSERT INTO $wpdb->terms (term_id, name, slug, term_group) VALUES

   740 		(%d, %s, %s, %d)", $term_id, $name, $slug, $term_group) );

   741 

   742 		$count = 0;

   743 		if ( !empty($category->category_count) ) {

   744 			$count = (int) $category->category_count;

   745 			$taxonomy = 'category';

   746 			$wpdb->query( $wpdb->prepare("INSERT INTO $wpdb->term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ( %d, %s, %s, %d, %d)", $term_id, $taxonomy, $description, $parent, $count) );

   747 			$tt_ids[$term_id][$taxonomy] = (int) $wpdb->insert_id;

   748 		}

   749 

   750 		if ( !empty($category->link_count) ) {

   751 			$count = (int) $category->link_count;

   752 			$taxonomy = 'link_category';

   753 			$wpdb->query( $wpdb->prepare("INSERT INTO $wpdb->term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ( %d, %s, %s, %d, %d)", $term_id, $taxonomy, $description, $parent, $count) );

   754 			$tt_ids[$term_id][$taxonomy] = (int) $wpdb->insert_id;

   755 		}

   756 

   757 		if ( !empty($category->tag_count) ) {

   758 			$have_tags = true;

   759 			$count = (int) $category->tag_count;

   760 			$taxonomy = 'post_tag';

   761 			$wpdb->insert( $wpdb->term_taxonomy, compact('term_id', 'taxonomy', 'description', 'parent', 'count') );

   762 			$tt_ids[$term_id][$taxonomy] = (int) $wpdb->insert_id;

   763 		}

   764 

   765 		if ( empty($count) ) {

   766 			$count = 0;

   767 			$taxonomy = 'category';

   768 			$wpdb->insert( $wpdb->term_taxonomy, compact('term_id', 'taxonomy', 'description', 'parent', 'count') );

   769 			$tt_ids[$term_id][$taxonomy] = (int) $wpdb->insert_id;

   770 		}

   771 	}

   772 

   773 	$select = 'post_id, category_id';

   774 	if ( $have_tags )

   775 		$select .= ', rel_type';

   776 

   777 	$posts = $wpdb->get_results("SELECT $select FROM $wpdb->post2cat GROUP BY post_id, category_id");

   778 	foreach ( $posts as $post ) {

   779 		$post_id = (int) $post->post_id;

   780 		$term_id = (int) $post->category_id;

   781 		$taxonomy = 'category';

   782 		if ( !empty($post->rel_type) && 'tag' == $post->rel_type)

   783 			$taxonomy = 'tag';

   784 		$tt_id = $tt_ids[$term_id][$taxonomy];

   785 		if ( empty($tt_id) )

   786 			continue;

   787 

   788 		$wpdb->insert( $wpdb->term_relationships, array('object_id' => $post_id, 'term_taxonomy_id' => $tt_id) );

   789 	}

   790 

   791 	// < 3570 we used linkcategories.  >= 3570 we used categories and link2cat.

   792 	if ( $wp_current_db_version < 3570 ) {

   793 		// Create link_category terms for link categories.  Create a map of link cat IDs

   794 		// to link_category terms.

   795 		$link_cat_id_map = array();

   796 		$default_link_cat = 0;

   797 		$tt_ids = array();

   798 		$link_cats = $wpdb->get_results("SELECT cat_id, cat_name FROM " . $wpdb->prefix . 'linkcategories');

   799 		foreach ( $link_cats as $category) {

   800 			$cat_id = (int) $category->cat_id;

   801 			$term_id = 0;

   802 			$name = $wpdb->escape($category->cat_name);

   803 			$slug = sanitize_title($name);

   804 			$term_group = 0;

   805 

   806 			// Associate terms with the same slug in a term group and make slugs unique.

   807 			if ( $exists = $wpdb->get_results( $wpdb->prepare("SELECT term_id, term_group FROM $wpdb->terms WHERE slug = %s", $slug) ) ) {

   808 				$term_group = $exists[0]->term_group;

   809 				$term_id = $exists[0]->term_id;

   810 			}

   811 

   812 			if ( empty($term_id) ) {

   813 				$wpdb->insert( $wpdb->terms, compact('name', 'slug', 'term_group') );

   814 				$term_id = (int) $wpdb->insert_id;

   815 			}

   816 

   817 			$link_cat_id_map[$cat_id] = $term_id;

   818 			$default_link_cat = $term_id;

   819 

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

   821 			$tt_ids[$term_id] = (int) $wpdb->insert_id;

   822 		}

   823 

   824 		// Associate links to cats.

   825 		$links = $wpdb->get_results("SELECT link_id, link_category FROM $wpdb->links");

   826 		if ( !empty($links) ) foreach ( $links as $link ) {

   827 			if ( 0 == $link->link_category )

   828 				continue;

   829 			if ( ! isset($link_cat_id_map[$link->link_category]) )

   830 				continue;

   831 			$term_id = $link_cat_id_map[$link->link_category];

   832 			$tt_id = $tt_ids[$term_id];

   833 			if ( empty($tt_id) )

   834 				continue;

   835 

   836 			$wpdb->insert( $wpdb->term_relationships, array('object_id' => $link->link_id, 'term_taxonomy_id' => $tt_id) );

   837 		}

   838 

   839 		// Set default to the last category we grabbed during the upgrade loop.

   840 		update_option('default_link_category', $default_link_cat);

   841 	} else {

   842 		$links = $wpdb->get_results("SELECT link_id, category_id FROM $wpdb->link2cat GROUP BY link_id, category_id");

   843 		foreach ( $links as $link ) {

   844 			$link_id = (int) $link->link_id;

   845 			$term_id = (int) $link->category_id;

   846 			$taxonomy = 'link_category';

   847 			$tt_id = $tt_ids[$term_id][$taxonomy];

   848 			if ( empty($tt_id) )

   849 				continue;

   850 			$wpdb->insert( $wpdb->term_relationships, array('object_id' => $link_id, 'term_taxonomy_id' => $tt_id) );

   851 		}

   852 	}

   853 

   854 	if ( $wp_current_db_version < 4772 ) {

   855 		// Obsolete linkcategories table

   856 		$wpdb->query('DROP TABLE IF EXISTS ' . $wpdb->prefix . 'linkcategories');

   857 	}

   858 

   859 	// Recalculate all counts

   860 	$terms = $wpdb->get_results("SELECT term_taxonomy_id, taxonomy FROM $wpdb->term_taxonomy");

   861 	foreach ( (array) $terms as $term ) {

   862 		if ( ('post_tag' == $term->taxonomy) || ('category' == $term->taxonomy) )

   863 			$count = $wpdb->get_var( $wpdb->prepare("SELECT COUNT(*) FROM $wpdb->term_relationships, $wpdb->posts WHERE $wpdb->posts.ID = $wpdb->term_relationships.object_id AND post_status = 'publish' AND post_type = 'post' AND term_taxonomy_id = %d", $term->term_taxonomy_id) );

   864 		else

   865 			$count = $wpdb->get_var( $wpdb->prepare("SELECT COUNT(*) FROM $wpdb->term_relationships WHERE term_taxonomy_id = %d", $term->term_taxonomy_id) );

   866 		$wpdb->update( $wpdb->term_taxonomy, array('count' => $count), array('term_taxonomy_id' => $term->term_taxonomy_id) );

   867 	}

   868 }

   869 

   870 /**

   871  * Remove old options from the database.

   872  *

   873  * @since 2.3.0

   874  */

   875 function upgrade_230_options_table() {

   876 	global $wpdb;

   877 	$old_options_fields = array( 'option_can_override', 'option_type', 'option_width', 'option_height', 'option_description', 'option_admin_level' );

   878 	$wpdb->hide_errors();

   879 	foreach ( $old_options_fields as $old )

   880 		$wpdb->query("ALTER TABLE $wpdb->options DROP $old");

   881 	$wpdb->show_errors();

   882 }

   883 

   884 /**

   885  * Remove old categories, link2cat, and post2cat database tables.

   886  *

   887  * @since 2.3.0

   888  */

   889 function upgrade_230_old_tables() {

   890 	global $wpdb;

   891 	$wpdb->query('DROP TABLE IF EXISTS ' . $wpdb->prefix . 'categories');

   892 	$wpdb->query('DROP TABLE IF EXISTS ' . $wpdb->prefix . 'link2cat');

   893 	$wpdb->query('DROP TABLE IF EXISTS ' . $wpdb->prefix . 'post2cat');

   894 }

   895 

   896 /**

   897  * Upgrade old slugs made in version 2.2.

   898  *

   899  * @since 2.2.0

   900  */

   901 function upgrade_old_slugs() {

   902 	// upgrade people who were using the Redirect Old Slugs plugin

   903 	global $wpdb;

   904 	$wpdb->query("UPDATE $wpdb->postmeta SET meta_key = '_wp_old_slug' WHERE meta_key = 'old_slug'");

   905 }

   906 

   907 /**

   908  * Execute changes made in WordPress 2.5.0.

   909  *

   910  * @since 2.5.0

   911  */

   912 function upgrade_250() {

   913 	global $wp_current_db_version;

   914 

   915 	if ( $wp_current_db_version < 6689 ) {

   916 		populate_roles_250();

   917 	}

   918 

   919 }

   920 

   921 /**

   922  * Execute changes made in WordPress 2.5.1.

   923  *

   924  * @since 2.5.1

   925  */

   926 function upgrade_251() {

   927 	global $wp_current_db_version;

   928 

   929 	// Make the secret longer

   930 	update_option('secret', wp_generate_password(64));

   931 }

   932 

   933 /**

   934  * Execute changes made in WordPress 2.5.2.

   935  *

   936  * @since 2.5.2

   937  */

   938 function upgrade_252() {

   939 	global $wpdb;

   940 

   941 	$wpdb->query("UPDATE $wpdb->users SET user_activation_key = ''");

   942 }

   943 

   944 /**

   945  * Execute changes made in WordPress 2.6.

   946  *

   947  * @since 2.6.0

   948  */

   949 function upgrade_260() {

   950 	global $wp_current_db_version;

   951 

   952 	if ( $wp_current_db_version < 8000 )

   953 		populate_roles_260();

   954 

   955 	if ( $wp_current_db_version < 8201 ) {

   956 		update_option('enable_app', 1);

   957 		update_option('enable_xmlrpc', 1);

   958 	}

   959 }

   960 

   961 /**

   962  * Execute changes made in WordPress 2.7.

   963  *

   964  * @since 2.7.0

   965  */

   966 function upgrade_270() {

   967 	global $wpdb, $wp_current_db_version;

   968 

   969 	if ( $wp_current_db_version < 8980 )

   970 		populate_roles_270();

   971 

   972 	// Update post_date for unpublished posts with empty timestamp

   973 	if ( $wp_current_db_version < 8921 )

   974 		$wpdb->query( "UPDATE $wpdb->posts SET post_date = post_modified WHERE post_date = '0000-00-00 00:00:00'" );

   975 }

   976 

   977 /**

   978  * Execute changes made in WordPress 2.8.

   979  *

   980  * @since 2.8.0

   981  */

   982 function upgrade_280() {

   983 	global $wp_current_db_version;

   984 

   985 	if ( $wp_current_db_version < 10360 )

   986 		populate_roles_280();

   987 }

   988 

   989 /**

   990  * Execute changes made in WordPress 2.9.

   991  *

   992  * @since 2.9.0

   993  */

   994 function upgrade_290() {

   995 	global $wp_current_db_version;

   996 

   997 	if ( $wp_current_db_version < 11958 ) {

   998 		// Previously, setting depth to 1 would redundantly disable threading, but now 2 is the minimum depth to avoid confusion

   999 		if ( get_option( 'thread_comments_depth' ) == '1' ) {

  1000 			update_option( 'thread_comments_depth', 2 );

  1001 			update_option( 'thread_comments', 0 );

  1002 		}

  1003 	}

  1004 }

  1005 

  1006 

  1007 // The functions we use to actually do stuff

  1008 

  1009 // General

  1010 

  1011 /**

  1012  * {@internal Missing Short Description}}

  1013  *

  1014  * {@internal Missing Long Description}}

  1015  *

  1016  * @since unknown

  1017  *

  1018  * @param string $table_name Database table name to create.

  1019  * @param string $create_ddl SQL statement to create table.

  1020  * @return bool If table already exists or was created by function.

  1021  */

  1022 function maybe_create_table($table_name, $create_ddl) {

  1023 	global $wpdb;

  1024 	if ( $wpdb->get_var("SHOW TABLES LIKE '$table_name'") == $table_name )

  1025 		return true;

  1026 	//didn't find it try to create it.

  1027 	$q = $wpdb->query($create_ddl);

  1028 	// we cannot directly tell that whether this succeeded!

  1029 	if ( $wpdb->get_var("SHOW TABLES LIKE '$table_name'") == $table_name )

  1030 		return true;

  1031 	return false;

  1032 }

  1033 

  1034 /**

  1035  * {@internal Missing Short Description}}

  1036  *

  1037  * {@internal Missing Long Description}}

  1038  *

  1039  * @since unknown

  1040  *

  1041  * @param string $table Database table name.

  1042  * @param string $index Index name to drop.

  1043  * @return bool True, when finished.

  1044  */

  1045 function drop_index($table, $index) {

  1046 	global $wpdb;

  1047 	$wpdb->hide_errors();

  1048 	$wpdb->query("ALTER TABLE `$table` DROP INDEX `$index`");

  1049 	// Now we need to take out all the extra ones we may have created

  1050 	for ($i = 0; $i < 25; $i++) {

  1051 		$wpdb->query("ALTER TABLE `$table` DROP INDEX `{$index}_$i`");

  1052 	}

  1053 	$wpdb->show_errors();

  1054 	return true;

  1055 }

  1056 

  1057 /**

  1058  * {@internal Missing Short Description}}

  1059  *

  1060  * {@internal Missing Long Description}}

  1061  *

  1062  * @since unknown

  1063  *

  1064  * @param string $table Database table name.

  1065  * @param string $index Database table index column.

  1066  * @return bool True, when done with execution.

  1067  */

  1068 function add_clean_index($table, $index) {

  1069 	global $wpdb;

  1070 	drop_index($table, $index);

  1071 	$wpdb->query("ALTER TABLE `$table` ADD INDEX ( `$index` )");

  1072 	return true;

  1073 }

  1074 

  1075 /**

  1076  ** maybe_add_column()

  1077  ** Add column to db table if it doesn't exist.

  1078  ** Returns:  true if already exists or on successful completion

  1079  **           false on error

  1080  */

  1081 function maybe_add_column($table_name, $column_name, $create_ddl) {

  1082 	global $wpdb, $debug;

  1083 	foreach ($wpdb->get_col("DESC $table_name", 0) as $column ) {

  1084 		if ($debug) echo("checking $column == $column_name<br />");

  1085 		if ($column == $column_name) {

  1086 			return true;

  1087 		}

  1088 	}

  1089 	//didn't find it try to create it.

  1090 	$q = $wpdb->query($create_ddl);

  1091 	// we cannot directly tell that whether this succeeded!

  1092 	foreach ($wpdb->get_col("DESC $table_name", 0) as $column ) {

  1093 		if ($column == $column_name) {

  1094 			return true;

  1095 		}

  1096 	}

  1097 	return false;

  1098 }

  1099 

  1100 /**

  1101  * Retrieve all options as it was for 1.2.

  1102  *

  1103  * @since 1.2.0

  1104  *

  1105  * @return array List of options.

  1106  */

  1107 function get_alloptions_110() {

  1108 	global $wpdb;

  1109 	if ($options = $wpdb->get_results("SELECT option_name, option_value FROM $wpdb->options")) {

  1110 		foreach ($options as $option) {

  1111 			// "When trying to design a foolproof system,

  1112 			//  never underestimate the ingenuity of the fools :)" -- Dougal

  1113 			if ('siteurl' == $option->option_name) $option->option_value = preg_replace('|/+$|', '', $option->option_value);

  1114 			if ('home' == $option->option_name) $option->option_value = preg_replace('|/+$|', '', $option->option_value);

  1115 			if ('category_base' == $option->option_name) $option->option_value = preg_replace('|/+$|', '', $option->option_value);

  1116 			$all_options->{$option->option_name} = stripslashes($option->option_value);

  1117 		}

  1118 	}

  1119 	return $all_options;

  1120 }

  1121 

  1122 /**

  1123  * Version of get_option that is private to install/upgrade.

  1124  *

  1125  * @since unknown

  1126  * @access private

  1127  *

  1128  * @param string $setting Option name.

  1129  * @return mixed

  1130  */

  1131 function __get_option($setting) {

  1132 	global $wpdb;

  1133 

  1134 	if ( $setting == 'home' && defined( 'WP_HOME' ) ) {

  1135 		return preg_replace( '|/+$|', '', constant( 'WP_HOME' ) );