[ Index ]

PHP Cross Reference of WordPress

title

Body

[close]

/wp-admin/includes/ -> schema.php (source)

   1  <?php
   2  /**
   3   * WordPress Administration Scheme API
   4   *
   5   * Here we keep the DB structure and option values.
   6   *
   7   * @package WordPress
   8   * @subpackage Administration
   9   */
  10  
  11  /**
  12   * Declare these as global in case schema.php is included from a function.
  13   *
  14   * @global wpdb   $wpdb            WordPress database abstraction object.
  15   * @global array  $wp_queries
  16   * @global string $charset_collate
  17   */
  18  global $wpdb, $wp_queries, $charset_collate;
  19  
  20  /**
  21   * The database character collate.
  22   */
  23  $charset_collate = $wpdb->get_charset_collate();
  24  
  25  /**
  26   * Retrieve the SQL for creating database tables.
  27   *
  28   * @since 3.3.0
  29   *
  30   * @global wpdb $wpdb WordPress database abstraction object.
  31   *
  32   * @param string $scope   Optional. The tables for which to retrieve SQL. Can be all, global, ms_global, or blog tables. Defaults to all.
  33   * @param int    $blog_id Optional. The site ID for which to retrieve SQL. Default is the current site ID.
  34   * @return string The SQL needed to create the requested tables.
  35   */
  36  function wp_get_db_schema( $scope = 'all', $blog_id = null ) {
  37      global $wpdb;
  38  
  39      $charset_collate = $wpdb->get_charset_collate();
  40  
  41      if ( $blog_id && $blog_id != $wpdb->blogid ) {
  42          $old_blog_id = $wpdb->set_blog_id( $blog_id );
  43      }
  44  
  45      // Engage multisite if in the middle of turning it on from network.php.
  46      $is_multisite = is_multisite() || ( defined( 'WP_INSTALLING_NETWORK' ) && WP_INSTALLING_NETWORK );
  47  
  48      /*
  49       * Indexes have a maximum size of 767 bytes. Historically, we haven't need to be concerned about that.
  50       * As of 4.2, however, we moved to utf8mb4, which uses 4 bytes per character. This means that an index which
  51       * used to have room for floor(767/3) = 255 characters, now only has room for floor(767/4) = 191 characters.
  52       */
  53      $max_index_length = 191;
  54  
  55      // Blog-specific tables.
  56      $blog_tables = "CREATE TABLE $wpdb->termmeta (
  57      meta_id bigint(20) unsigned NOT NULL auto_increment,
  58      term_id bigint(20) unsigned NOT NULL default '0',
  59      meta_key varchar(255) default NULL,
  60      meta_value longtext,
  61      PRIMARY KEY  (meta_id),
  62      KEY term_id (term_id),
  63      KEY meta_key (meta_key($max_index_length))
  64  ) $charset_collate;
  65  CREATE TABLE $wpdb->terms (
  66   term_id bigint(20) unsigned NOT NULL auto_increment,
  67   name varchar(200) NOT NULL default '',
  68   slug varchar(200) NOT NULL default '',
  69   term_group bigint(10) NOT NULL default 0,
  70   PRIMARY KEY  (term_id),
  71   KEY slug (slug($max_index_length)),
  72   KEY name (name($max_index_length))
  73  ) $charset_collate;
  74  CREATE TABLE $wpdb->term_taxonomy (
  75   term_taxonomy_id bigint(20) unsigned NOT NULL auto_increment,
  76   term_id bigint(20) unsigned NOT NULL default 0,
  77   taxonomy varchar(32) NOT NULL default '',
  78   description longtext NOT NULL,
  79   parent bigint(20) unsigned NOT NULL default 0,
  80   count bigint(20) NOT NULL default 0,
  81   PRIMARY KEY  (term_taxonomy_id),
  82   UNIQUE KEY term_id_taxonomy (term_id,taxonomy),
  83   KEY taxonomy (taxonomy)
  84  ) $charset_collate;
  85  CREATE TABLE $wpdb->term_relationships (
  86   object_id bigint(20) unsigned NOT NULL default 0,
  87   term_taxonomy_id bigint(20) unsigned NOT NULL default 0,
  88   term_order int(11) NOT NULL default 0,
  89   PRIMARY KEY  (object_id,term_taxonomy_id),
  90   KEY term_taxonomy_id (term_taxonomy_id)
  91  ) $charset_collate;
  92  CREATE TABLE $wpdb->commentmeta (
  93      meta_id bigint(20) unsigned NOT NULL auto_increment,
  94      comment_id bigint(20) unsigned NOT NULL default '0',
  95      meta_key varchar(255) default NULL,
  96      meta_value longtext,
  97      PRIMARY KEY  (meta_id),
  98      KEY comment_id (comment_id),
  99      KEY meta_key (meta_key($max_index_length))
 100  ) $charset_collate;
 101  CREATE TABLE $wpdb->comments (
 102      comment_ID bigint(20) unsigned NOT NULL auto_increment,
 103      comment_post_ID bigint(20) unsigned NOT NULL default '0',
 104      comment_author tinytext NOT NULL,
 105      comment_author_email varchar(100) NOT NULL default '',
 106      comment_author_url varchar(200) NOT NULL default '',
 107      comment_author_IP varchar(100) NOT NULL default '',
 108      comment_date datetime NOT NULL default '0000-00-00 00:00:00',
 109      comment_date_gmt datetime NOT NULL default '0000-00-00 00:00:00',
 110      comment_content text NOT NULL,
 111      comment_karma int(11) NOT NULL default '0',
 112      comment_approved varchar(20) NOT NULL default '1',
 113      comment_agent varchar(255) NOT NULL default '',
 114      comment_type varchar(20) NOT NULL default 'comment',
 115      comment_parent bigint(20) unsigned NOT NULL default '0',
 116      user_id bigint(20) unsigned NOT NULL default '0',
 117      PRIMARY KEY  (comment_ID),
 118      KEY comment_post_ID (comment_post_ID),
 119      KEY comment_approved_date_gmt (comment_approved,comment_date_gmt),
 120      KEY comment_date_gmt (comment_date_gmt),
 121      KEY comment_parent (comment_parent),
 122      KEY comment_author_email (comment_author_email(10))
 123  ) $charset_collate;
 124  CREATE TABLE $wpdb->links (
 125      link_id bigint(20) unsigned NOT NULL auto_increment,
 126      link_url varchar(255) NOT NULL default '',
 127      link_name varchar(255) NOT NULL default '',
 128      link_image varchar(255) NOT NULL default '',
 129      link_target varchar(25) NOT NULL default '',
 130      link_description varchar(255) NOT NULL default '',
 131      link_visible varchar(20) NOT NULL default 'Y',
 132      link_owner bigint(20) unsigned NOT NULL default '1',
 133      link_rating int(11) NOT NULL default '0',
 134      link_updated datetime NOT NULL default '0000-00-00 00:00:00',
 135      link_rel varchar(255) NOT NULL default '',
 136      link_notes mediumtext NOT NULL,
 137      link_rss varchar(255) NOT NULL default '',
 138      PRIMARY KEY  (link_id),
 139      KEY link_visible (link_visible)
 140  ) $charset_collate;
 141  CREATE TABLE $wpdb->options (
 142      option_id bigint(20) unsigned NOT NULL auto_increment,
 143      option_name varchar(191) NOT NULL default '',
 144      option_value longtext NOT NULL,
 145      autoload varchar(20) NOT NULL default 'yes',
 146      PRIMARY KEY  (option_id),
 147      UNIQUE KEY option_name (option_name),
 148      KEY autoload (autoload)
 149  ) $charset_collate;
 150  CREATE TABLE $wpdb->postmeta (
 151      meta_id bigint(20) unsigned NOT NULL auto_increment,
 152      post_id bigint(20) unsigned NOT NULL default '0',
 153      meta_key varchar(255) default NULL,
 154      meta_value longtext,
 155      PRIMARY KEY  (meta_id),
 156      KEY post_id (post_id),
 157      KEY meta_key (meta_key($max_index_length))
 158  ) $charset_collate;
 159  CREATE TABLE $wpdb->posts (
 160      ID bigint(20) unsigned NOT NULL auto_increment,
 161      post_author bigint(20) unsigned NOT NULL default '0',
 162      post_date datetime NOT NULL default '0000-00-00 00:00:00',
 163      post_date_gmt datetime NOT NULL default '0000-00-00 00:00:00',
 164      post_content longtext NOT NULL,
 165      post_title text NOT NULL,
 166      post_excerpt text NOT NULL,
 167      post_status varchar(20) NOT NULL default 'publish',
 168      comment_status varchar(20) NOT NULL default 'open',
 169      ping_status varchar(20) NOT NULL default 'open',
 170      post_password varchar(255) NOT NULL default '',
 171      post_name varchar(200) NOT NULL default '',
 172      to_ping text NOT NULL,
 173      pinged text NOT NULL,
 174      post_modified datetime NOT NULL default '0000-00-00 00:00:00',
 175      post_modified_gmt datetime NOT NULL default '0000-00-00 00:00:00',
 176      post_content_filtered longtext NOT NULL,
 177      post_parent bigint(20) unsigned NOT NULL default '0',
 178      guid varchar(255) NOT NULL default '',
 179      menu_order int(11) NOT NULL default '0',
 180      post_type varchar(20) NOT NULL default 'post',
 181      post_mime_type varchar(100) NOT NULL default '',
 182      comment_count bigint(20) NOT NULL default '0',
 183      PRIMARY KEY  (ID),
 184      KEY post_name (post_name($max_index_length)),
 185      KEY type_status_date (post_type,post_status,post_date,ID),
 186      KEY post_parent (post_parent),
 187      KEY post_author (post_author)
 188  ) $charset_collate;\n";
 189  
 190      // Single site users table. The multisite flavor of the users table is handled below.
 191      $users_single_table = "CREATE TABLE $wpdb->users (
 192      ID bigint(20) unsigned NOT NULL auto_increment,
 193      user_login varchar(60) NOT NULL default '',
 194      user_pass varchar(255) NOT NULL default '',
 195      user_nicename varchar(50) NOT NULL default '',
 196      user_email varchar(100) NOT NULL default '',
 197      user_url varchar(100) NOT NULL default '',
 198      user_registered datetime NOT NULL default '0000-00-00 00:00:00',
 199      user_activation_key varchar(255) NOT NULL default '',
 200      user_status int(11) NOT NULL default '0',
 201      display_name varchar(250) NOT NULL default '',
 202      PRIMARY KEY  (ID),
 203      KEY user_login_key (user_login),
 204      KEY user_nicename (user_nicename),
 205      KEY user_email (user_email)
 206  ) $charset_collate;\n";
 207  
 208      // Multisite users table.
 209      $users_multi_table = "CREATE TABLE $wpdb->users (
 210      ID bigint(20) unsigned NOT NULL auto_increment,
 211      user_login varchar(60) NOT NULL default '',
 212      user_pass varchar(255) NOT NULL default '',
 213      user_nicename varchar(50) NOT NULL default '',
 214      user_email varchar(100) NOT NULL default '',
 215      user_url varchar(100) NOT NULL default '',
 216      user_registered datetime NOT NULL default '0000-00-00 00:00:00',
 217      user_activation_key varchar(255) NOT NULL default '',
 218      user_status int(11) NOT NULL default '0',
 219      display_name varchar(250) NOT NULL default '',
 220      spam tinyint(2) NOT NULL default '0',
 221      deleted tinyint(2) NOT NULL default '0',
 222      PRIMARY KEY  (ID),
 223      KEY user_login_key (user_login),
 224      KEY user_nicename (user_nicename),
 225      KEY user_email (user_email)
 226  ) $charset_collate;\n";
 227  
 228      // Usermeta.
 229      $usermeta_table = "CREATE TABLE $wpdb->usermeta (
 230      umeta_id bigint(20) unsigned NOT NULL auto_increment,
 231      user_id bigint(20) unsigned NOT NULL default '0',
 232      meta_key varchar(255) default NULL,
 233      meta_value longtext,
 234      PRIMARY KEY  (umeta_id),
 235      KEY user_id (user_id),
 236      KEY meta_key (meta_key($max_index_length))
 237  ) $charset_collate;\n";
 238  
 239      // Global tables.
 240      if ( $is_multisite ) {
 241          $global_tables = $users_multi_table . $usermeta_table;
 242      } else {
 243          $global_tables = $users_single_table . $usermeta_table;
 244      }
 245  
 246      // Multisite global tables.
 247      $ms_global_tables = "CREATE TABLE $wpdb->blogs (
 248      blog_id bigint(20) NOT NULL auto_increment,
 249      site_id bigint(20) NOT NULL default '0',
 250      domain varchar(200) NOT NULL default '',
 251      path varchar(100) NOT NULL default '',
 252      registered datetime NOT NULL default '0000-00-00 00:00:00',
 253      last_updated datetime NOT NULL default '0000-00-00 00:00:00',
 254      public tinyint(2) NOT NULL default '1',
 255      archived tinyint(2) NOT NULL default '0',
 256      mature tinyint(2) NOT NULL default '0',
 257      spam tinyint(2) NOT NULL default '0',
 258      deleted tinyint(2) NOT NULL default '0',
 259      lang_id int(11) NOT NULL default '0',
 260      PRIMARY KEY  (blog_id),
 261      KEY domain (domain(50),path(5)),
 262      KEY lang_id (lang_id)
 263  ) $charset_collate;
 264  CREATE TABLE $wpdb->blogmeta (
 265      meta_id bigint(20) unsigned NOT NULL auto_increment,
 266      blog_id bigint(20) NOT NULL default '0',
 267      meta_key varchar(255) default NULL,
 268      meta_value longtext,
 269      PRIMARY KEY  (meta_id),
 270      KEY meta_key (meta_key($max_index_length)),
 271      KEY blog_id (blog_id)
 272  ) $charset_collate;
 273  CREATE TABLE $wpdb->registration_log (
 274      ID bigint(20) NOT NULL auto_increment,
 275      email varchar(255) NOT NULL default '',
 276      IP varchar(30) NOT NULL default '',
 277      blog_id bigint(20) NOT NULL default '0',
 278      date_registered datetime NOT NULL default '0000-00-00 00:00:00',
 279      PRIMARY KEY  (ID),
 280      KEY IP (IP)
 281  ) $charset_collate;
 282  CREATE TABLE $wpdb->site (
 283      id bigint(20) NOT NULL auto_increment,
 284      domain varchar(200) NOT NULL default '',
 285      path varchar(100) NOT NULL default '',
 286      PRIMARY KEY  (id),
 287      KEY domain (domain(140),path(51))
 288  ) $charset_collate;
 289  CREATE TABLE $wpdb->sitemeta (
 290      meta_id bigint(20) NOT NULL auto_increment,
 291      site_id bigint(20) NOT NULL default '0',
 292      meta_key varchar(255) default NULL,
 293      meta_value longtext,
 294      PRIMARY KEY  (meta_id),
 295      KEY meta_key (meta_key($max_index_length)),
 296      KEY site_id (site_id)
 297  ) $charset_collate;
 298  CREATE TABLE $wpdb->signups (
 299      signup_id bigint(20) NOT NULL auto_increment,
 300      domain varchar(200) NOT NULL default '',
 301      path varchar(100) NOT NULL default '',
 302      title longtext NOT NULL,
 303      user_login varchar(60) NOT NULL default '',
 304      user_email varchar(100) NOT NULL default '',
 305      registered datetime NOT NULL default '0000-00-00 00:00:00',
 306      activated datetime NOT NULL default '0000-00-00 00:00:00',
 307      active tinyint(1) NOT NULL default '0',
 308      activation_key varchar(50) NOT NULL default '',
 309      meta longtext,
 310      PRIMARY KEY  (signup_id),
 311      KEY activation_key (activation_key),
 312      KEY user_email (user_email),
 313      KEY user_login_email (user_login,user_email),
 314      KEY domain_path (domain(140),path(51))
 315  ) $charset_collate;";
 316  
 317      switch ( $scope ) {
 318          case 'blog':
 319              $queries = $blog_tables;
 320              break;
 321          case 'global':
 322              $queries = $global_tables;
 323              if ( $is_multisite ) {
 324                  $queries .= $ms_global_tables;
 325              }
 326              break;
 327          case 'ms_global':
 328              $queries = $ms_global_tables;
 329              break;
 330          case 'all':
 331          default:
 332              $queries = $global_tables . $blog_tables;
 333              if ( $is_multisite ) {
 334                  $queries .= $ms_global_tables;
 335              }
 336              break;
 337      }
 338  
 339      if ( isset( $old_blog_id ) ) {
 340          $wpdb->set_blog_id( $old_blog_id );
 341      }
 342  
 343      return $queries;
 344  }
 345  
 346  // Populate for back compat.
 347  $wp_queries = wp_get_db_schema( 'all' );
 348  
 349  /**
 350   * Create WordPress options and set the default values.
 351   *
 352   * @since 1.5.0
 353   * @since 5.1.0 The $options parameter has been added.
 354   *
 355   * @global wpdb $wpdb                  WordPress database abstraction object.
 356   * @global int  $wp_db_version         WordPress database version.
 357   * @global int  $wp_current_db_version The old (current) database version.
 358   *
 359   * @param array $options Optional. Custom option $key => $value pairs to use. Default empty array.
 360   */
 361  function populate_options( array $options = array() ) {
 362      global $wpdb, $wp_db_version, $wp_current_db_version;
 363  
 364      $guessurl = wp_guess_url();
 365      /**
 366       * Fires before creating WordPress options and populating their default values.
 367       *
 368       * @since 2.6.0
 369       */
 370      do_action( 'populate_options' );
 371  
 372      // If WP_DEFAULT_THEME doesn't exist, fall back to the latest core default theme.
 373      $stylesheet = WP_DEFAULT_THEME;
 374      $template   = WP_DEFAULT_THEME;
 375      $theme      = wp_get_theme( WP_DEFAULT_THEME );
 376      if ( ! $theme->exists() ) {
 377          $theme = WP_Theme::get_core_default_theme();
 378      }
 379  
 380      // If we can't find a core default theme, WP_DEFAULT_THEME is the best we can do.
 381      if ( $theme ) {
 382          $stylesheet = $theme->get_stylesheet();
 383          $template   = $theme->get_template();
 384      }
 385  
 386      $timezone_string = '';
 387      $gmt_offset      = 0;
 388      /*
 389       * translators: default GMT offset or timezone string. Must be either a valid offset (-12 to 14)
 390       * or a valid timezone string (America/New_York). See https://www.php.net/manual/en/timezones.php
 391       * for all timezone strings supported by PHP.
 392       */
 393      $offset_or_tz = _x( '0', 'default GMT offset or timezone string' ); // phpcs:ignore WordPress.WP.I18n.NoEmptyStrings
 394      if ( is_numeric( $offset_or_tz ) ) {
 395          $gmt_offset = $offset_or_tz;
 396      } elseif ( $offset_or_tz && in_array( $offset_or_tz, timezone_identifiers_list(), true ) ) {
 397              $timezone_string = $offset_or_tz;
 398      }
 399  
 400      $defaults = array(
 401          'siteurl'                         => $guessurl,
 402          'home'                            => $guessurl,
 403          'blogname'                        => __( 'My Site' ),
 404          /* translators: Site tagline. */
 405          'blogdescription'                 => __( 'Just another WordPress site' ),
 406          'users_can_register'              => 0,
 407          'admin_email'                     => 'you@example.com',
 408          /* translators: Default start of the week. 0 = Sunday, 1 = Monday. */
 409          'start_of_week'                   => _x( '1', 'start of week' ),
 410          'use_balanceTags'                 => 0,
 411          'use_smilies'                     => 1,
 412          'require_name_email'              => 1,
 413          'comments_notify'                 => 1,
 414          'posts_per_rss'                   => 10,
 415          'rss_use_excerpt'                 => 0,
 416          'mailserver_url'                  => 'mail.example.com',
 417          'mailserver_login'                => 'login@example.com',
 418          'mailserver_pass'                 => 'password',
 419          'mailserver_port'                 => 110,
 420          'default_category'                => 1,
 421          'default_comment_status'          => 'open',
 422          'default_ping_status'             => 'open',
 423          'default_pingback_flag'           => 1,
 424          'posts_per_page'                  => 10,
 425          /* translators: Default date format, see https://www.php.net/manual/datetime.format.php */
 426          'date_format'                     => __( 'F j, Y' ),
 427          /* translators: Default time format, see https://www.php.net/manual/datetime.format.php */
 428          'time_format'                     => __( 'g:i a' ),
 429          /* translators: Links last updated date format, see https://www.php.net/manual/datetime.format.php */
 430          'links_updated_date_format'       => __( 'F j, Y g:i a' ),
 431          'comment_moderation'              => 0,
 432          'moderation_notify'               => 1,
 433          'permalink_structure'             => '',
 434          'rewrite_rules'                   => '',
 435          'hack_file'                       => 0,
 436          'blog_charset'                    => 'UTF-8',
 437          'moderation_keys'                 => '',
 438          'active_plugins'                  => array(),
 439          'category_base'                   => '',
 440          'ping_sites'                      => 'http://rpc.pingomatic.com/',
 441          'comment_max_links'               => 2,
 442          'gmt_offset'                      => $gmt_offset,
 443  
 444          // 1.5.0
 445          'default_email_category'          => 1,
 446          'recently_edited'                 => '',
 447          'template'                        => $template,
 448          'stylesheet'                      => $stylesheet,
 449          'comment_registration'            => 0,
 450          'html_type'                       => 'text/html',
 451  
 452          // 1.5.1
 453          'use_trackback'                   => 0,
 454  
 455          // 2.0.0
 456          'default_role'                    => 'subscriber',
 457          'db_version'                      => $wp_db_version,
 458  
 459          // 2.0.1
 460          'uploads_use_yearmonth_folders'   => 1,
 461          'upload_path'                     => '',
 462  
 463          // 2.1.0
 464          'blog_public'                     => '1',
 465          'default_link_category'           => 2,
 466          'show_on_front'                   => 'posts',
 467  
 468          // 2.2.0
 469          'tag_base'                        => '',
 470  
 471          // 2.5.0
 472          'show_avatars'                    => '1',
 473          'avatar_rating'                   => 'G',
 474          'upload_url_path'                 => '',
 475          'thumbnail_size_w'                => 150,
 476          'thumbnail_size_h'                => 150,
 477          'thumbnail_crop'                  => 1,
 478          'medium_size_w'                   => 300,
 479          'medium_size_h'                   => 300,
 480  
 481          // 2.6.0
 482          'avatar_default'                  => 'mystery',
 483  
 484          // 2.7.0
 485          'large_size_w'                    => 1024,
 486          'large_size_h'                    => 1024,
 487          'image_default_link_type'         => 'none',
 488          'image_default_size'              => '',
 489          'image_default_align'             => '',
 490          'close_comments_for_old_posts'    => 0,
 491          'close_comments_days_old'         => 14,
 492          'thread_comments'                 => 1,
 493          'thread_comments_depth'           => 5,
 494          'page_comments'                   => 0,
 495          'comments_per_page'               => 50,
 496          'default_comments_page'           => 'newest',
 497          'comment_order'                   => 'asc',
 498          'sticky_posts'                    => array(),
 499          'widget_categories'               => array(),
 500          'widget_text'                     => array(),
 501          'widget_rss'                      => array(),
 502          'uninstall_plugins'               => array(),
 503  
 504          // 2.8.0
 505          'timezone_string'                 => $timezone_string,
 506  
 507          // 3.0.0
 508          'page_for_posts'                  => 0,
 509          'page_on_front'                   => 0,
 510  
 511          // 3.1.0
 512          'default_post_format'             => 0,
 513  
 514          // 3.5.0
 515          'link_manager_enabled'            => 0,
 516  
 517          // 4.3.0
 518          'finished_splitting_shared_terms' => 1,
 519          'site_icon'                       => 0,
 520  
 521          // 4.4.0
 522          'medium_large_size_w'             => 768,
 523          'medium_large_size_h'             => 0,
 524  
 525          // 4.9.6
 526          'wp_page_for_privacy_policy'      => 0,
 527  
 528          // 4.9.8
 529          'show_comments_cookies_opt_in'    => 1,
 530  
 531          // 5.3.0
 532          'admin_email_lifespan'            => ( time() + 6 * MONTH_IN_SECONDS ),
 533  
 534          // 5.5.0
 535          'disallowed_keys'                 => '',
 536          'comment_previously_approved'     => 1,
 537          'auto_plugin_theme_update_emails' => array(),
 538  
 539          // 5.6.0
 540          'auto_update_core_dev'            => 'enabled',
 541          'auto_update_core_minor'          => 'enabled',
 542          // Default to enabled for new installs.
 543          // See https://core.trac.wordpress.org/ticket/51742.
 544          'auto_update_core_major'          => 'enabled',
 545      );
 546  
 547      // 3.3.0
 548      if ( ! is_multisite() ) {
 549          $defaults['initial_db_version'] = ! empty( $wp_current_db_version ) && $wp_current_db_version < $wp_db_version
 550              ? $wp_current_db_version : $wp_db_version;
 551      }
 552  
 553      // 3.0.0 multisite.
 554      if ( is_multisite() ) {
 555          /* translators: %s: Network title. */
 556          $defaults['blogdescription']     = sprintf( __( 'Just another %s site' ), get_network()->site_name );
 557          $defaults['permalink_structure'] = '/%year%/%monthnum%/%day%/%postname%/';
 558      }
 559  
 560      $options = wp_parse_args( $options, $defaults );
 561  
 562      // Set autoload to no for these options.
 563      $fat_options = array(
 564          'moderation_keys',
 565          'recently_edited',
 566          'disallowed_keys',
 567          'uninstall_plugins',
 568          'auto_plugin_theme_update_emails',
 569      );
 570  
 571      $keys             = "'" . implode( "', '", array_keys( $options ) ) . "'";
 572      $existing_options = $wpdb->get_col( "SELECT option_name FROM $wpdb->options WHERE option_name in ( $keys )" ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
 573  
 574      $insert = '';
 575  
 576      foreach ( $options as $option => $value ) {
 577          if ( in_array( $option, $existing_options, true ) ) {
 578              continue;
 579          }
 580  
 581          if ( in_array( $option, $fat_options, true ) ) {
 582              $autoload = 'no';
 583          } else {
 584              $autoload = 'yes';
 585          }
 586  
 587          if ( is_array( $value ) ) {
 588              $value = serialize( $value );
 589          }
 590  
 591          if ( ! empty( $insert ) ) {
 592              $insert .= ', ';
 593          }
 594  
 595          $insert .= $wpdb->prepare( '(%s, %s, %s)', $option, $value, $autoload );
 596      }
 597  
 598      if ( ! empty( $insert ) ) {
 599          $wpdb->query( "INSERT INTO $wpdb->options (option_name, option_value, autoload) VALUES " . $insert ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
 600      }
 601  
 602      // In case it is set, but blank, update "home".
 603      if ( ! __get_option( 'home' ) ) {
 604          update_option( 'home', $guessurl );
 605      }
 606  
 607      // Delete unused options.
 608      $unusedoptions = array(
 609          'blodotgsping_url',
 610          'bodyterminator',
 611          'emailtestonly',
 612          'phoneemail_separator',
 613          'smilies_directory',
 614          'subjectprefix',
 615          'use_bbcode',
 616          'use_blodotgsping',
 617          'use_phoneemail',
 618          'use_quicktags',
 619          'use_weblogsping',
 620          'weblogs_cache_file',
 621          'use_preview',
 622          'use_htmltrans',
 623          'smilies_directory',
 624          'fileupload_allowedusers',
 625          'use_phoneemail',
 626          'default_post_status',
 627          'default_post_category',
 628          'archive_mode',
 629          'time_difference',
 630          'links_minadminlevel',
 631          'links_use_adminlevels',
 632          'links_rating_type',
 633          'links_rating_char',
 634          'links_rating_ignore_zero',
 635          'links_rating_single_image',
 636          'links_rating_image0',
 637          'links_rating_image1',
 638          'links_rating_image2',
 639          'links_rating_image3',
 640          'links_rating_image4',
 641          'links_rating_image5',
 642          'links_rating_image6',
 643          'links_rating_image7',
 644          'links_rating_image8',
 645          'links_rating_image9',
 646          'links_recently_updated_time',
 647          'links_recently_updated_prepend',
 648          'links_recently_updated_append',
 649          'weblogs_cacheminutes',
 650          'comment_allowed_tags',
 651          'search_engine_friendly_urls',
 652          'default_geourl_lat',
 653          'default_geourl_lon',
 654          'use_default_geourl',
 655          'weblogs_xml_url',
 656          'new_users_can_blog',
 657          '_wpnonce',
 658          '_wp_http_referer',
 659          'Update',
 660          'action',
 661          'rich_editing',
 662          'autosave_interval',
 663          'deactivated_plugins',
 664          'can_compress_scripts',
 665          'page_uris',
 666          'update_core',
 667          'update_plugins',
 668          'update_themes',
 669          'doing_cron',
 670          'random_seed',
 671          'rss_excerpt_length',
 672          'secret',
 673          'use_linksupdate',
 674          'default_comment_status_page',
 675          'wporg_popular_tags',
 676          'what_to_show',
 677          'rss_language',
 678          'language',
 679          'enable_xmlrpc',
 680          'enable_app',
 681          'embed_autourls',
 682          'default_post_edit_rows',
 683          'gzipcompression',
 684          'advanced_edit',
 685      );
 686      foreach ( $unusedoptions as $option ) {
 687          delete_option( $option );
 688      }
 689  
 690      // Delete obsolete magpie stuff.
 691      $wpdb->query( "DELETE FROM $wpdb->options WHERE option_name REGEXP '^rss_[0-9a-f]{32}(_ts)?$'" );
 692  
 693      // Clear expired transients.
 694      delete_expired_transients( true );
 695  }
 696  
 697  /**
 698   * Execute WordPress role creation for the various WordPress versions.
 699   *
 700   * @since 2.0.0
 701   */
 702  function populate_roles() {
 703      populate_roles_160();
 704      populate_roles_210();
 705      populate_roles_230();
 706      populate_roles_250();
 707      populate_roles_260();
 708      populate_roles_270();
 709      populate_roles_280();
 710      populate_roles_300();
 711  }
 712  
 713  /**
 714   * Create the roles for WordPress 2.0
 715   *
 716   * @since 2.0.0
 717   */
 718  function populate_roles_160() {
 719      // Add roles.
 720      add_role( 'administrator', 'Administrator' );
 721      add_role( 'editor', 'Editor' );
 722      add_role( 'author', 'Author' );
 723      add_role( 'contributor', 'Contributor' );
 724      add_role( 'subscriber', 'Subscriber' );
 725  
 726      // Add caps for Administrator role.
 727      $role = get_role( 'administrator' );
 728      $role->add_cap( 'switch_themes' );
 729      $role->add_cap( 'edit_themes' );
 730      $role->add_cap( 'activate_plugins' );
 731      $role->add_cap( 'edit_plugins' );
 732      $role->add_cap( 'edit_users' );
 733      $role->add_cap( 'edit_files' );
 734      $role->add_cap( 'manage_options' );
 735      $role->add_cap( 'moderate_comments' );
 736      $role->add_cap( 'manage_categories' );
 737      $role->add_cap( 'manage_links' );
 738      $role->add_cap( 'upload_files' );
 739      $role->add_cap( 'import' );
 740      $role->add_cap( 'unfiltered_html' );
 741      $role->add_cap( 'edit_posts' );
 742      $role->add_cap( 'edit_others_posts' );
 743      $role->add_cap( 'edit_published_posts' );
 744      $role->add_cap( 'publish_posts' );
 745      $role->add_cap( 'edit_pages' );
 746      $role->add_cap( 'read' );
 747      $role->add_cap( 'level_10' );
 748      $role->add_cap( 'level_9' );
 749      $role->add_cap( 'level_8' );
 750      $role->add_cap( 'level_7' );
 751      $role->add_cap( 'level_6' );
 752      $role->add_cap( 'level_5' );
 753      $role->add_cap( 'level_4' );
 754      $role->add_cap( 'level_3' );
 755      $role->add_cap( 'level_2' );
 756      $role->add_cap( 'level_1' );
 757      $role->add_cap( 'level_0' );
 758  
 759      // Add caps for Editor role.
 760      $role = get_role( 'editor' );
 761      $role->add_cap( 'moderate_comments' );
 762      $role->add_cap( 'manage_categories' );
 763      $role->add_cap( 'manage_links' );
 764      $role->add_cap( 'upload_files' );
 765      $role->add_cap( 'unfiltered_html' );
 766      $role->add_cap( 'edit_posts' );
 767      $role->add_cap( 'edit_others_posts' );
 768      $role->add_cap( 'edit_published_posts' );
 769      $role->add_cap( 'publish_posts' );
 770      $role->add_cap( 'edit_pages' );
 771      $role->add_cap( 'read' );
 772      $role->add_cap( 'level_7' );
 773      $role->add_cap( 'level_6' );
 774      $role->add_cap( 'level_5' );
 775      $role->add_cap( 'level_4' );
 776      $role->add_cap( 'level_3' );
 777      $role->add_cap( 'level_2' );
 778      $role->add_cap( 'level_1' );
 779      $role->add_cap( 'level_0' );
 780  
 781      // Add caps for Author role.
 782      $role = get_role( 'author' );
 783      $role->add_cap( 'upload_files' );
 784      $role->add_cap( 'edit_posts' );
 785      $role->add_cap( 'edit_published_posts' );
 786      $role->add_cap( 'publish_posts' );
 787      $role->add_cap( 'read' );
 788      $role->add_cap( 'level_2' );
 789      $role->add_cap( 'level_1' );
 790      $role->add_cap( 'level_0' );
 791  
 792      // Add caps for Contributor role.
 793      $role = get_role( 'contributor' );
 794      $role->add_cap( 'edit_posts' );
 795      $role->add_cap( 'read' );
 796      $role->add_cap( 'level_1' );
 797      $role->add_cap( 'level_0' );
 798  
 799      // Add caps for Subscriber role.
 800      $role = get_role( 'subscriber' );
 801      $role->add_cap( 'read' );
 802      $role->add_cap( 'level_0' );
 803  }
 804  
 805  /**
 806   * Create and modify WordPress roles for WordPress 2.1.
 807   *
 808   * @since 2.1.0
 809   */
 810  function populate_roles_210() {
 811      $roles = array( 'administrator', 'editor' );
 812      foreach ( $roles as $role ) {
 813          $role = get_role( $role );
 814          if ( empty( $role ) ) {
 815              continue;
 816          }
 817  
 818          $role->add_cap( 'edit_others_pages' );
 819          $role->add_cap( 'edit_published_pages' );
 820          $role->add_cap( 'publish_pages' );
 821          $role->add_cap( 'delete_pages' );
 822          $role->add_cap( 'delete_others_pages' );
 823          $role->add_cap( 'delete_published_pages' );
 824          $role->add_cap( 'delete_posts' );
 825          $role->add_cap( 'delete_others_posts' );
 826          $role->add_cap( 'delete_published_posts' );
 827          $role->add_cap( 'delete_private_posts' );
 828          $role->add_cap( 'edit_private_posts' );
 829          $role->add_cap( 'read_private_posts' );
 830          $role->add_cap( 'delete_private_pages' );
 831          $role->add_cap( 'edit_private_pages' );
 832          $role->add_cap( 'read_private_pages' );
 833      }
 834  
 835      $role = get_role( 'administrator' );
 836      if ( ! empty( $role ) ) {
 837          $role->add_cap( 'delete_users' );
 838          $role->add_cap( 'create_users' );
 839      }
 840  
 841      $role = get_role( 'author' );
 842      if ( ! empty( $role ) ) {
 843          $role->add_cap( 'delete_posts' );
 844          $role->add_cap( 'delete_published_posts' );
 845      }
 846  
 847      $role = get_role( 'contributor' );
 848      if ( ! empty( $role ) ) {
 849          $role->add_cap( 'delete_posts' );
 850      }
 851  }
 852  
 853  /**
 854   * Create and modify WordPress roles for WordPress 2.3.
 855   *
 856   * @since 2.3.0
 857   */
 858  function populate_roles_230() {
 859      $role = get_role( 'administrator' );
 860  
 861      if ( ! empty( $role ) ) {
 862          $role->add_cap( 'unfiltered_upload' );
 863      }
 864  }
 865  
 866  /**
 867   * Create and modify WordPress roles for WordPress 2.5.
 868   *
 869   * @since 2.5.0
 870   */
 871  function populate_roles_250() {
 872      $role = get_role( 'administrator' );
 873  
 874      if ( ! empty( $role ) ) {
 875          $role->add_cap( 'edit_dashboard' );
 876      }
 877  }
 878  
 879  /**
 880   * Create and modify WordPress roles for WordPress 2.6.
 881   *
 882   * @since 2.6.0
 883   */
 884  function populate_roles_260() {
 885      $role = get_role( 'administrator' );
 886  
 887      if ( ! empty( $role ) ) {
 888          $role->add_cap( 'update_plugins' );
 889          $role->add_cap( 'delete_plugins' );
 890      }
 891  }
 892  
 893  /**
 894   * Create and modify WordPress roles for WordPress 2.7.
 895   *
 896   * @since 2.7.0
 897   */
 898  function populate_roles_270() {
 899      $role = get_role( 'administrator' );
 900  
 901      if ( ! empty( $role ) ) {
 902          $role->add_cap( 'install_plugins' );
 903          $role->add_cap( 'update_themes' );
 904      }
 905  }
 906  
 907  /**
 908   * Create and modify WordPress roles for WordPress 2.8.
 909   *
 910   * @since 2.8.0
 911   */
 912  function populate_roles_280() {
 913      $role = get_role( 'administrator' );
 914  
 915      if ( ! empty( $role ) ) {
 916          $role->add_cap( 'install_themes' );
 917      }
 918  }
 919  
 920  /**
 921   * Create and modify WordPress roles for WordPress 3.0.
 922   *
 923   * @since 3.0.0
 924   */
 925  function populate_roles_300() {
 926      $role = get_role( 'administrator' );
 927  
 928      if ( ! empty( $role ) ) {
 929          $role->add_cap( 'update_core' );
 930          $role->add_cap( 'list_users' );
 931          $role->add_cap( 'remove_users' );
 932          $role->add_cap( 'promote_users' );
 933          $role->add_cap( 'edit_theme_options' );
 934          $role->add_cap( 'delete_themes' );
 935          $role->add_cap( 'export' );
 936      }
 937  }
 938  
 939  if ( ! function_exists( 'install_network' ) ) :
 940      /**
 941       * Install Network.
 942       *
 943       * @since 3.0.0
 944       */
 945  	function install_network() {
 946          if ( ! defined( 'WP_INSTALLING_NETWORK' ) ) {
 947              define( 'WP_INSTALLING_NETWORK', true );
 948          }
 949  
 950          dbDelta( wp_get_db_schema( 'global' ) );
 951      }
 952  endif;
 953  
 954  /**
 955   * Populate network settings.
 956   *
 957   * @since 3.0.0
 958   *
 959   * @global wpdb       $wpdb         WordPress database abstraction object.
 960   * @global object     $current_site
 961   * @global WP_Rewrite $wp_rewrite   WordPress rewrite component.
 962   *
 963   * @param int    $network_id        ID of network to populate.
 964   * @param string $domain            The domain name for the network (eg. "example.com").
 965   * @param string $email             Email address for the network administrator.
 966   * @param string $site_name         The name of the network.
 967   * @param string $path              Optional. The path to append to the network's domain name. Default '/'.
 968   * @param bool   $subdomain_install Optional. Whether the network is a subdomain installation or a subdirectory installation.
 969   *                                  Default false, meaning the network is a subdirectory installation.
 970   * @return bool|WP_Error True on success, or WP_Error on warning (with the installation otherwise successful,
 971   *                       so the error code must be checked) or failure.
 972   */
 973  function populate_network( $network_id = 1, $domain = '', $email = '', $site_name = '', $path = '/', $subdomain_install = false ) {
 974      global $wpdb, $current_site, $wp_rewrite;
 975  
 976      $errors = new WP_Error();
 977      if ( '' === $domain ) {
 978          $errors->add( 'empty_domain', __( 'You must provide a domain name.' ) );
 979      }
 980      if ( '' === $site_name ) {
 981          $errors->add( 'empty_sitename', __( 'You must provide a name for your network of sites.' ) );
 982      }
 983  
 984      // Check for network collision.
 985      $network_exists = false;
 986      if ( is_multisite() ) {
 987          if ( get_network( (int) $network_id ) ) {
 988              $errors->add( 'siteid_exists', __( 'The network already exists.' ) );
 989          }
 990      } else {
 991          if ( $network_id == $wpdb->get_var( $wpdb->prepare( "SELECT id FROM $wpdb->site WHERE id = %d", $network_id ) ) ) {
 992              $errors->add( 'siteid_exists', __( 'The network already exists.' ) );
 993          }
 994      }
 995  
 996      if ( ! is_email( $email ) ) {
 997          $errors->add( 'invalid_email', __( 'You must provide a valid email address.' ) );
 998      }
 999  
1000      if ( $errors->has_errors() ) {
1001          return $errors;
1002      }
1003  
1004      if ( 1 == $network_id ) {
1005          $wpdb->insert(
1006              $wpdb->site,
1007              array(
1008                  'domain' => $domain,
1009                  'path'   => $path,
1010              )
1011          );
1012          $network_id = $wpdb->insert_id;
1013      } else {
1014          $wpdb->insert(
1015              $wpdb->site,
1016              array(
1017                  'domain' => $domain,
1018                  'path'   => $path,
1019                  'id'     => $network_id,
1020              )
1021          );
1022      }
1023  
1024      populate_network_meta(
1025          $network_id,
1026          array(
1027              'admin_email'       => $email,
1028              'site_name'         => $site_name,
1029              'subdomain_install' => $subdomain_install,
1030          )
1031      );
1032  
1033      $site_user = get_userdata( (int) $wpdb->get_var( $wpdb->prepare( "SELECT meta_value FROM $wpdb->sitemeta WHERE meta_key = %s AND site_id = %d", 'admin_user_id', $network_id ) ) );
1034  
1035      /*
1036       * When upgrading from single to multisite, assume the current site will
1037       * become the main site of the network. When using populate_network()
1038       * to create another network in an existing multisite environment, skip
1039       * these steps since the main site of the new network has not yet been
1040       * created.
1041       */
1042      if ( ! is_multisite() ) {
1043          $current_site            = new stdClass;
1044          $current_site->domain    = $domain;
1045          $current_site->path      = $path;
1046          $current_site->site_name = ucfirst( $domain );
1047          $wpdb->insert(
1048              $wpdb->blogs,
1049              array(
1050                  'site_id'    => $network_id,
1051                  'blog_id'    => 1,
1052                  'domain'     => $domain,
1053                  'path'       => $path,
1054                  'registered' => current_time( 'mysql' ),
1055              )
1056          );
1057          $current_site->blog_id = $wpdb->insert_id;
1058          update_user_meta( $site_user->ID, 'source_domain', $domain );
1059          update_user_meta( $site_user->ID, 'primary_blog', $current_site->blog_id );
1060  
1061          if ( $subdomain_install ) {
1062              $wp_rewrite->set_permalink_structure( '/%year%/%monthnum%/%day%/%postname%/' );
1063          } else {
1064              $wp_rewrite->set_permalink_structure( '/blog/%year%/%monthnum%/%day%/%postname%/' );
1065          }
1066  
1067          flush_rewrite_rules();
1068  
1069          if ( ! $subdomain_install ) {
1070              return true;
1071          }
1072  
1073          $vhost_ok = false;
1074          $errstr   = '';
1075          $hostname = substr( md5( time() ), 0, 6 ) . '.' . $domain; // Very random hostname!
1076          $page     = wp_remote_get(
1077              'http://' . $hostname,
1078              array(
1079                  'timeout'     => 5,
1080                  'httpversion' => '1.1',
1081              )
1082          );
1083          if ( is_wp_error( $page ) ) {
1084              $errstr = $page->get_error_message();
1085          } elseif ( 200 == wp_remote_retrieve_response_code( $page ) ) {
1086                  $vhost_ok = true;
1087          }
1088  
1089          if ( ! $vhost_ok ) {
1090              $msg = '<p><strong>' . __( 'Warning! Wildcard DNS may not be configured correctly!' ) . '</strong></p>';
1091  
1092              $msg .= '<p>' . sprintf(
1093                  /* translators: %s: Host name. */
1094                  __( 'The installer attempted to contact a random hostname (%s) on your domain.' ),
1095                  '<code>' . $hostname . '</code>'
1096              );
1097              if ( ! empty( $errstr ) ) {
1098                  /* translators: %s: Error message. */
1099                  $msg .= ' ' . sprintf( __( 'This resulted in an error message: %s' ), '<code>' . $errstr . '</code>' );
1100              }
1101              $msg .= '</p>';
1102  
1103              $msg .= '<p>' . sprintf(
1104                  /* translators: %s: Asterisk symbol (*). */
1105                  __( 'To use a subdomain configuration, you must have a wildcard entry in your DNS. This usually means adding a %s hostname record pointing at your web server in your DNS configuration tool.' ),
1106                  '<code>*</code>'
1107              ) . '</p>';
1108  
1109              $msg .= '<p>' . __( 'You can still use your site but any subdomain you create may not be accessible. If you know your DNS is correct, ignore this message.' ) . '</p>';
1110  
1111              return new WP_Error( 'no_wildcard_dns', $msg );
1112          }
1113      }
1114  
1115      return true;
1116  }
1117  
1118  /**
1119   * Creates WordPress network meta and sets the default values.
1120   *
1121   * @since 5.1.0
1122   *
1123   * @global wpdb $wpdb          WordPress database abstraction object.
1124   * @global int  $wp_db_version WordPress database version.
1125   *
1126   * @param int   $network_id Network ID to populate meta for.
1127   * @param array $meta       Optional. Custom meta $key => $value pairs to use. Default empty array.
1128   */
1129  function populate_network_meta( $network_id, array $meta = array() ) {
1130      global $wpdb, $wp_db_version;
1131  
1132      $network_id = (int) $network_id;
1133  
1134      $email             = ! empty( $meta['admin_email'] ) ? $meta['admin_email'] : '';
1135      $subdomain_install = isset( $meta['subdomain_install'] ) ? (int) $meta['subdomain_install'] : 0;
1136  
1137      // If a user with the provided email does not exist, default to the current user as the new network admin.
1138      $site_user = ! empty( $email ) ? get_user_by( 'email', $email ) : false;
1139      if ( false === $site_user ) {
1140          $site_user = wp_get_current_user();
1141      }
1142  
1143      if ( empty( $email ) ) {
1144          $email = $site_user->user_email;
1145      }
1146  
1147      $template       = get_option( 'template' );
1148      $stylesheet     = get_option( 'stylesheet' );
1149      $allowed_themes = array( $stylesheet => true );
1150  
1151      if ( $template != $stylesheet ) {
1152          $allowed_themes[ $template ] = true;
1153      }
1154  
1155      if ( WP_DEFAULT_THEME != $stylesheet && WP_DEFAULT_THEME != $template ) {
1156          $allowed_themes[ WP_DEFAULT_THEME ] = true;
1157      }
1158  
1159      // If WP_DEFAULT_THEME doesn't exist, also include the latest core default theme.
1160      if ( ! wp_get_theme( WP_DEFAULT_THEME )->exists() ) {
1161          $core_default = WP_Theme::get_core_default_theme();
1162          if ( $core_default ) {
1163              $allowed_themes[ $core_default->get_stylesheet() ] = true;
1164          }
1165      }
1166  
1167      if ( function_exists( 'clean_network_cache' ) ) {
1168          clean_network_cache( $network_id );
1169      } else {
1170          wp_cache_delete( $network_id, 'networks' );
1171      }
1172  
1173      wp_cache_delete( 'networks_have_paths', 'site-options' );
1174  
1175      if ( ! is_multisite() ) {
1176          $site_admins = array( $site_user->user_login );
1177          $users       = get_users(
1178              array(
1179                  'fields' => array( 'user_login' ),
1180                  'role'   => 'administrator',
1181              )
1182          );
1183          if ( $users ) {
1184              foreach ( $users as $user ) {
1185                  $site_admins[] = $user->user_login;
1186              }
1187  
1188              $site_admins = array_unique( $site_admins );
1189          }
1190      } else {
1191          $site_admins = get_site_option( 'site_admins' );
1192      }
1193  
1194      /* translators: Do not translate USERNAME, SITE_NAME, BLOG_URL, PASSWORD: those are placeholders. */
1195      $welcome_email = __(
1196          'Howdy USERNAME,
1197  
1198  Your new SITE_NAME site has been successfully set up at:
1199  BLOG_URL
1200  
1201  You can log in to the administrator account with the following information:
1202  
1203  Username: USERNAME
1204  Password: PASSWORD
1205  Log in here: BLOG_URLwp-login.php
1206  
1207  We hope you enjoy your new site. Thanks!
1208  
1209  --The Team @ SITE_NAME'
1210      );
1211  
1212      $misc_exts        = array(
1213          // Images.
1214          'jpg',
1215          'jpeg',
1216          'png',
1217          'gif',
1218          // Video.
1219          'mov',
1220          'avi',
1221          'mpg',
1222          '3gp',
1223          '3g2',
1224          // "audio".
1225          'midi',
1226          'mid',
1227          // Miscellaneous.
1228          'pdf',
1229          'doc',
1230          'ppt',
1231          'odt',
1232          'pptx',
1233          'docx',
1234          'pps',
1235          'ppsx',
1236          'xls',
1237          'xlsx',
1238          'key',
1239      );
1240      $audio_exts       = wp_get_audio_extensions();
1241      $video_exts       = wp_get_video_extensions();
1242      $upload_filetypes = array_unique( array_merge( $misc_exts, $audio_exts, $video_exts ) );
1243  
1244      $sitemeta = array(
1245          'site_name'                   => __( 'My Network' ),
1246          'admin_email'                 => $email,
1247          'admin_user_id'               => $site_user->ID,
1248          'registration'                => 'none',
1249          'upload_filetypes'            => implode( ' ', $upload_filetypes ),
1250          'blog_upload_space'           => 100,
1251          'fileupload_maxk'             => 1500,
1252          'site_admins'                 => $site_admins,
1253          'allowedthemes'               => $allowed_themes,
1254          'illegal_names'               => array( 'www', 'web', 'root', 'admin', 'main', 'invite', 'administrator', 'files' ),
1255          'wpmu_upgrade_site'           => $wp_db_version,
1256          'welcome_email'               => $welcome_email,
1257          /* translators: %s: Site link. */
1258          'first_post'                  => __( 'Welcome to %s. This is your first post. Edit or delete it, then start writing!' ),
1259          // @todo - Network admins should have a method of editing the network siteurl (used for cookie hash).
1260          'siteurl'                     => get_option( 'siteurl' ) . '/',
1261          'add_new_users'               => '0',
1262          'upload_space_check_disabled' => is_multisite() ? get_site_option( 'upload_space_check_disabled' ) : '1',
1263          'subdomain_install'           => $subdomain_install,
1264          'global_terms_enabled'        => global_terms_enabled() ? '1' : '0',
1265          'ms_files_rewriting'          => is_multisite() ? get_site_option( 'ms_files_rewriting' ) : '0',
1266          'initial_db_version'          => get_option( 'initial_db_version' ),
1267          'active_sitewide_plugins'     => array(),
1268          'WPLANG'                      => get_locale(),
1269      );
1270      if ( ! $subdomain_install ) {
1271          $sitemeta['illegal_names'][] = 'blog';
1272      }
1273  
1274      $sitemeta = wp_parse_args( $meta, $sitemeta );
1275  
1276      /**
1277       * Filters meta for a network on creation.
1278       *
1279       * @since 3.7.0
1280       *
1281       * @param array $sitemeta   Associative array of network meta keys and values to be inserted.
1282       * @param int   $network_id ID of network to populate.
1283       */
1284      $sitemeta = apply_filters( 'populate_network_meta', $sitemeta, $network_id );
1285  
1286      $insert = '';
1287      foreach ( $sitemeta as $meta_key => $meta_value ) {
1288          if ( is_array( $meta_value ) ) {
1289              $meta_value = serialize( $meta_value );
1290          }
1291          if ( ! empty( $insert ) ) {
1292              $insert .= ', ';
1293          }
1294          $insert .= $wpdb->prepare( '( %d, %s, %s)', $network_id, $meta_key, $meta_value );
1295      }
1296      $wpdb->query( "INSERT INTO $wpdb->sitemeta ( site_id, meta_key, meta_value ) VALUES " . $insert ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
1297  }
1298  
1299  /**
1300   * Creates WordPress site meta and sets the default values.
1301   *
1302   * @since 5.1.0
1303   *
1304   * @global wpdb $wpdb WordPress database abstraction object.
1305   *
1306   * @param int   $site_id Site ID to populate meta for.
1307   * @param array $meta    Optional. Custom meta $key => $value pairs to use. Default empty array.
1308   */
1309  function populate_site_meta( $site_id, array $meta = array() ) {
1310      global $wpdb;
1311  
1312      $site_id = (int) $site_id;
1313  
1314      if ( ! is_site_meta_supported() ) {
1315          return;
1316      }
1317  
1318      if ( empty( $meta ) ) {
1319          return;
1320      }
1321  
1322      /**
1323       * Filters meta for a site on creation.
1324       *
1325       * @since 5.2.0
1326       *
1327       * @param array $meta    Associative array of site meta keys and values to be inserted.
1328       * @param int   $site_id ID of site to populate.
1329       */
1330      $site_meta = apply_filters( 'populate_site_meta', $meta, $site_id );
1331  
1332      $insert = '';
1333      foreach ( $site_meta as $meta_key => $meta_value ) {
1334          if ( is_array( $meta_value ) ) {
1335              $meta_value = serialize( $meta_value );
1336          }
1337          if ( ! empty( $insert ) ) {
1338              $insert .= ', ';
1339          }
1340          $insert .= $wpdb->prepare( '( %d, %s, %s)', $site_id, $meta_key, $meta_value );
1341      }
1342  
1343      $wpdb->query( "INSERT INTO $wpdb->blogmeta ( blog_id, meta_key, meta_value ) VALUES " . $insert ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
1344  
1345      wp_cache_delete( $site_id, 'blog_meta' );
1346      wp_cache_set_sites_last_changed();
1347  }


Generated: Fri Nov 27 01:00:04 2020 Cross-referenced by PHPXref 0.7.1