WordPress.org

Make WordPress Core

Changeset 1601


Ignore:
Timestamp:
09/05/2004 01:22:17 AM (14 years ago)
Author:
saxmatt
Message:

Install and upgrade refactoring complete.

Location:
trunk
Files:
1 added
4 edited

Legend:

Unmodified
Added
Removed
  • trunk/wp-admin/install.php

    r1597 r1601  
    55
    66require_once('../wp-config.php');
    7 require('upgrade-functions.php');
     7require('./upgrade-functions.php');
    88
    99$guessurl = str_replace('/wp-admin/install.php?step=2', '', 'http://' . $HTTP_HOST . $REQUEST_URI);
     
    6969<h1 id="logo"><img alt="WordPress" src="http://static.wordpress.org/logo.png" /></h1>
    7070<?php
    71 
    7271// Let's check to make sure WP isn't already installed.
    7372$wpdb->hide_errors();
     
    9089<p>Before we begin we need a little bit of information. Don't worry, you can always change these later. </p>
    9190
    92 <form name="form1" id="form1" method="post" action="install.php?step=2">
     91<form name="setup" id="setup" method="post" action="install.php?step=2">
    9392<table width="100%">
    9493<tr>
     
    110109    break;
    111110    case 2:
    112 $weblog_title = addslashes(stripslashes(stripslashes($_POST['weblog_title'])));
    113 $admin_email = addslashes(stripslashes(stripslashes($_POST['admin_email'])));
    114111?>
    115112<h1>Second Step</h1>
    116113<p>Now we&#8217;re going to create the database tables and fill them with some default data.</p>
    117114
    118 <?php
    119 
    120 $got_links = false;
    121 $got_cats = false;
    122 $got_row = false;
    123 ?>
    124 <?php
    125 $result = mysql_list_tables(DB_NAME);
    126 if (!$result) {
    127     print "DB Error, could not list tables\n";
    128     print 'MySQL Error: ' . mysql_error();
    129     exit;
    130 }
    131 
    132 while ($row = mysql_fetch_row($result)) {
    133     if ($row[0] == $wpdb->links)
    134         $got_links = true;
    135     if ($row[0] == $wpdb->linkcategories)
    136         $got_cats = true;
    137     //print "Table: $row[0]<br />\n";
    138 }
    139 if (!$got_cats) {
    140     $sql = "CREATE TABLE $wpdb->linkcategories ( " .
    141            " cat_id int(11) NOT NULL auto_increment, " .
    142            " cat_name tinytext NOT NULL, ".
    143            " auto_toggle enum ('Y','N') NOT NULL default 'N', ".
    144            " show_images enum ('Y','N') NOT NULL default 'Y',        " .
    145            " show_description enum ('Y','N') NOT NULL default 'Y',   " .
    146            " show_rating enum ('Y','N') NOT NULL default 'Y',        " .
    147            " show_updated enum ('Y','N') NOT NULL default 'Y',       " .
    148            " sort_order varchar(64) NOT NULL default 'name',         " .
    149            " sort_desc enum('Y','N') NOT NULL default 'N',           " .
    150            " text_before_link varchar(128) not null default '<li>',  " .
    151            " text_after_link  varchar(128) not null default '<br />'," .
    152            " text_after_all  varchar(128) not null default '</li>',  " .
    153            " list_limit int not null default '-1',                     " .
    154            " PRIMARY KEY (cat_id) ".
    155            ") ";
    156     $result = mysql_query($sql) or print ("Can't create the table '$wpdb->linkcategories' in the database.<br />" . $sql . "<br />" . mysql_error());
    157     if ($result != false) {
    158         $got_cats = true;
    159     }
    160 } else {
    161         $got_cats = true;
    162 }
    163 if (!$got_links) {
    164     $sql = "CREATE TABLE $wpdb->links ( " .
    165            " link_id int(11) NOT NULL auto_increment,           " .
    166            " link_url varchar(255) NOT NULL default '',         " .
    167            " link_name varchar(255) NOT NULL default '',        " .
    168            " link_image varchar(255) NOT NULL default '',       " .
    169            " link_target varchar(25) NOT NULL default '',       " .
    170            " link_category int(11) NOT NULL default 0,          " .
    171            " link_description varchar(255) NOT NULL default '', " .
    172            " link_visible enum ('Y','N') NOT NULL default 'Y',  " .
    173            " link_owner int NOT NULL DEFAULT '1',               " .
    174            " link_rating int NOT NULL DEFAULT '0',              " .
    175            " link_updated DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', " .
    176            " link_rel varchar(255) NOT NULL default '',         " .
    177            " link_notes MEDIUMTEXT NOT NULL default '',         " .
    178            " PRIMARY KEY (link_id)                              " .
    179            ") ";
    180     $result = mysql_query($sql) or print ("Can't create the table '$wpdb->links' in the database.<br />" . $sql . "<br />" . mysql_error());
    181     $links = mysql_query("INSERT INTO $wpdb->links VALUES ('', 'http://wordpress.org/', 'WordPress', '', '', 1, '', 'Y', 1, 0, '0000-00-00 00:00:00', '', '');");
    182     $links = mysql_query("INSERT INTO $wpdb->links VALUES ('', 'http://photomatt.net/', 'Matt', '', '', 1, '', 'Y', 1, 0, '0000-00-00 00:00:00', '', '');");
    183     $links = mysql_query("INSERT INTO $wpdb->links VALUES ('', 'http://zed1.com/journalized/', 'Mike', '', '', 1, '', 'Y', 1, 0, '0000-00-00 00:00:00', '', '');");
    184     $links = mysql_query("INSERT INTO $wpdb->links VALUES ('', 'http://www.alexking.org/', 'Alex', '', '', 1, '', 'Y', 1, 0, '0000-00-00 00:00:00', '', '');");
    185     $links = mysql_query("INSERT INTO $wpdb->links VALUES ('', 'http://dougal.gunters.org/', 'Dougal', '', '', 1, '', 'Y', 1, 0, '0000-00-00 00:00:00', '', '');");
    186 
    187 
    188     if ($result != false) {
    189         $got_links = true;
    190     }
    191 } else {
    192         $got_links = true;
    193 }
    194 
    195 if ($got_links && $got_cats) {
    196     $sql = "SELECT * FROM $wpdb->linkcategories WHERE cat_id=1 ";
    197     $result = mysql_query($sql) or print ("Can't query '$wpdb->linkcategories'.<br />" . $sql . "<br />" . mysql_error());
    198     if ($result != false) {
    199         if ($row = mysql_fetch_object($result)) {
    200             $got_row = true;
    201         } else {
    202             $sql = "INSERT INTO $wpdb->linkcategories (cat_id, cat_name) VALUES (1, 'Links')";
    203             $result = mysql_query($sql) or print ("Can't query insert category.<br />" . $sql . "<br />" . mysql_error());
    204             if ($result != false) {
    205                 $got_row = true;
    206             }
    207         }
    208     }
    209 }
    210 
    211 ?>
    212 <?php
    213 # Note: if you want to start again with a clean b2 database,
    214 #       just remove the // in this file
    215 
    216 // $query = "DROP TABLE IF EXISTS $wpdb->posts";
    217 // $q = mysql_query($query) or die ("doh, can't drop the table \"$wpdb->posts\" in the database.");
    218 
    219 $query = "CREATE TABLE $wpdb->posts (
    220   ID int(10) unsigned NOT NULL auto_increment,
    221   post_author int(4) NOT NULL default '0',
    222   post_date datetime NOT NULL default '0000-00-00 00:00:00',
    223   post_date_gmt datetime NOT NULL default '0000-00-00 00:00:00',
    224   post_content text NOT NULL,
    225   post_title text NOT NULL,
    226   post_category int(4) NOT NULL default '0',
    227   post_excerpt text NOT NULL,
    228   post_lat float,
    229   post_lon float,
    230   post_status enum('publish','draft','private') NOT NULL default 'publish',
    231   comment_status enum('open','closed') NOT NULL default 'open',
    232   ping_status enum('open','closed') NOT NULL default 'open',
    233   post_password varchar(20) NOT NULL default '',
    234   post_name varchar(200) NOT NULL default '',
    235   to_ping text NOT NULL,
    236   pinged text NOT NULL,
    237   post_modified datetime NOT NULL default '0000-00-00 00:00:00',
    238   post_modified_gmt datetime NOT NULL default '0000-00-00 00:00:00',
    239   post_content_filtered text NOT NULL,
    240   PRIMARY KEY  (ID),
    241   KEY post_date (post_date),
    242   KEY post_date_gmt (post_date_gmt),
    243   KEY post_name (post_name),
    244   KEY post_status (post_status)
    245 )
    246 ";
    247 $q = $wpdb->query($query);
    248 ?>
    249115
    250116<?php
     117flush();
     118
     119// Set everything up
     120make_db_current_silent();
     121populate_options();
     122
     123// Fill in the data we gathered
     124$weblog_title = addslashes(stripslashes(stripslashes($_POST['weblog_title'])));
     125$admin_email = addslashes(stripslashes(stripslashes($_POST['admin_email'])));
     126
     127$wpdb->query("UPDATE $wpdb->options SET option_value = '$weblog_title' WHERE option_name = 'blogname'");
     128$wpdb->query("UPDATE $wpdb->options SET option_value = '$admin_email' WHERE option_name = 'admin_email'");
     129
     130// Now drop in some default links
     131$wpdb->query("INSERT INTO $wpdb->linkcategories (cat_id, cat_name) VALUES (1, 'Blogroll')");
     132$wpdb->query("INSERT INTO $wpdb->links (link_url, link_name, link_category) VALUES ('http://photomatt.net/', 'Matt', 1);");
     133$wpdb->query("INSERT INTO $wpdb->links (link_url, link_name, link_category) VALUES ('http://zed1.com/journalized/', 'Mike', 1);");
     134$wpdb->query("INSERT INTO $wpdb->links (link_url, link_name, link_category) VALUES ('http://www.alexking.org/', 'Alex', 1);");
     135$wpdb->query("INSERT INTO $wpdb->links (link_url, link_name, link_category) VALUES ('http://dougal.gunters.org/', 'Dougal', 1);");
     136
     137// Default category
     138$wpdb->query("INSERT INTO $wpdb->categories (cat_ID, cat_name) VALUES ('0', 'Uncategorized')");
     139
     140// First post
    251141$now = date('Y-m-d H:i:s');
    252142$now_gmt = gmdate('Y-m-d H:i:s');
    253 $query = "INSERT INTO $wpdb->posts (post_author, post_date, post_date_gmt, post_content, post_title, post_modified, post_modified_gmt) VALUES ('1', '$now', '$now_gmt', 'Welcome to WordPress. This is the first post. Edit or delete it, then start blogging!', 'Hello world!', '$now', '$now_gmt')";
     143$wpdb->query("INSERT INTO $wpdb->posts (post_author, post_date, post_date_gmt, post_content, post_title, post_modified, post_modified_gmt) VALUES ('1', '$now', '$now_gmt', 'Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!', 'Hello world!', '$now', '$now_gmt')");
    254144
    255 $q = $wpdb->query($query);
    256 ?>
     145// Default comment
     146$wpdb->query("INSERT INTO $wpdb->comments (comment_post_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_date_gmt, comment_content) VALUES ('1', 'Mr WordPress', 'mr@wordpress.org', 'http://wordpress.org', '127.0.0.1', '$now', '$now_gmt', 'Hi, this is a comment.<br />To delete a comment, just log in, and view the posts\' comments, there you will have the option to edit or delete them.')");
    257147
    258 <?php
    259 // $query = "DROP TABLE IF EXISTS $wpdb->categories";
    260 // $q = mysql_query($query) or mysql_doh("doh, can't drop the table \"$wpdb->categories\" in the database.");
    261 
    262 $query = "
    263 CREATE TABLE $wpdb->categories (
    264   cat_ID int(4) NOT NULL auto_increment,
    265   cat_name varchar(55) NOT NULL default '',
    266   PRIMARY KEY  (cat_ID),
    267   UNIQUE (cat_name)
    268 )
    269 ";
    270 $q = $wpdb->query($query);
    271 
    272 $query = "INSERT INTO $wpdb->categories (cat_ID, cat_name) VALUES ('0', 'General')";
    273 $q = $wpdb->query($query);
    274 
    275 $query = "UPDATE $wpdb->posts SET post_category = 1";
    276 $result = $wpdb->query($query);
    277 ?>
    278 
    279 <?php
    280 // $query = "DROP TABLE IF EXISTS $wpdb->comments";
    281 // $q = mysql_query($query) or mysql_doh("doh, can't drop the table \"$wpdb->comments\" in the database.");
    282 
    283 $query = "
    284 CREATE TABLE $wpdb->comments (
    285   comment_ID int(11) unsigned NOT NULL auto_increment,
    286   comment_post_ID int(11) NOT NULL default '0',
    287   comment_author tinytext NOT NULL,
    288   comment_author_email varchar(100) NOT NULL default '',
    289   comment_author_url varchar(100) NOT NULL default '',
    290   comment_author_IP varchar(100) NOT NULL default '',
    291   comment_date datetime NOT NULL default '0000-00-00 00:00:00',
    292   comment_date_gmt datetime NOT NULL default '0000-00-00 00:00:00',
    293   comment_content text NOT NULL,
    294   comment_karma int(11) NOT NULL default '0',
    295   PRIMARY KEY  (comment_ID)
    296 )
    297 ";
    298 $q = $wpdb->query($query);
    299 
    300 $now = date('Y-m-d H:i:s');
    301 $now_gmt = gmdate('Y-m-d H:i:s');
    302 $query = "INSERT INTO $wpdb->comments (comment_post_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_date_gmt, comment_content) VALUES ('1', 'Mr WordPress', 'mr@wordpress.org', 'http://wordpress.org', '127.0.0.1', '$now', '$now_gmt', 'Hi, this is a comment.<br />To delete a comment, just log in, and view the posts\' comments, there you will have the option to edit or delete them.')";
    303 $q = $wpdb->query($query);
    304 ?>
    305 
    306 <?php
    307 $query = "
    308     CREATE TABLE $wpdb->postmeta (
    309       meta_id int(11) NOT NULL auto_increment,
    310       post_id int(11) NOT NULL default 0,
    311       meta_key varchar(255),
    312       meta_value text,
    313       PRIMARY KEY (meta_id),
    314       INDEX (post_id),
    315       INDEX (meta_key)
    316     )
    317     ";
    318 
    319 $q = $wpdb->query($query);
    320 
    321 
    322 ?>
    323 
    324 <?php
    325 // $query = "DROP TABLE IF EXISTS $wpdb->options";
    326 // $q = mysql_query($query) or mysql_doh("doh, can't drop the table \"$wpdb->options\" in the database.");
    327 
    328 $query = "
    329 CREATE TABLE $wpdb->options (
    330   option_id int(11) NOT NULL auto_increment,
    331   blog_id int(11) NOT NULL default 0,
    332   option_name varchar(64) NOT NULL default '',
    333   option_can_override enum ('Y','N') NOT NULL default 'Y',
    334   option_type int(11) NOT NULL default 1,
    335   option_value varchar(255) NOT NULL default '',
    336   option_width int NOT NULL default 20,
    337   option_height int NOT NULL default 8,
    338   option_description tinytext NOT NULL default '',
    339   option_admin_level int NOT NULL DEFAULT '1',
    340   PRIMARY KEY (option_id, blog_id, option_name)
    341 )
    342 ";
    343 $q = $wpdb->query($query);
    344 
    345 $option_data = array(
    346 //base options from b2cofig
    347 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(1,'siteurl', 3, '$guessurl', 'siteurl is your blog\'s URL: for example, \'http://example.com/wordpress\' (no trailing slash !)', 8, 30)",
    348 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(2,'blogfilename', 3, 'index.php', 'blogfilename is the name of the default file for your blog', 8, 20)",
    349 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(3,'blogname', 3, '$weblog_title', 'blogname is the name of your blog', 8, 20)",
    350 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(4,'blogdescription', 3, 'My WordPress weblog', 'blogdescription is the description of your blog', 8, 40)",
    351 //"INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(6,'search_engine_friendly_urls', 2, '0', 'Querystring Configuration ** (don\'t change if you don\'t know what you\'re doing)', 8, 20)",
    352 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(7,'new_users_can_blog', 2, '0', 'whether you want new users to be able to post entries once they have registered', 8, 20)",
    353 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(8,'users_can_register', 2, '1', 'whether you want to allow users to register on your blog', 8, 20)",
    354 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(54,'admin_email', 3, '$admin_email', 'Your email (obvious eh?)', 8, 20)",
    355 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level) VALUES (93, 'blog_charset', 3, 'utf-8', 'Your blog&#8217;s charset (here&#8217;s a <a href=\'http://developer.apple.com/documentation/macos8/TextIntlSvcs/TextEncodingConversionManager/TEC1.5/TEC.b0.html\'>list of possible charsets</a>)', 8)",
    356 // general blog setup
    357 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(9 ,'start_of_week', 5, '1', 'day at the start of the week', 8, 20)",
    358 //"INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(10,'use_preview', 2, '1', 'Do you want to use the \'preview\' function', 8, 20)",
    359 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(14,'use_htmltrans', 2, '1', 'IMPORTANT! set this to false if you are using Chinese, Japanese, Korean, or other double-bytes languages', 8, 20)",
    360 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(15,'use_balanceTags', 2, '1', 'this could help balance your HTML code. if it gives bad results, set it to false', 8, 20)",
    361 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(16,'use_smilies', 2, '1', 'set this to 1 to enable smiley conversion in posts (note: this makes smiley conversion in ALL posts)', 8, 20)",
    362 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(18,'require_name_email', 2, '0', 'set this to true to require e-mail and name, or false to allow comments without e-mail/name', 8, 20)",
    363 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(20,'comments_notify', 2, '1', 'set this to true to let every author be notified about comments on their posts', 8, 20)",
    364 //rss/rdf feeds
    365 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(21,'posts_per_rss', 1, '10', 'number of last posts to syndicate', 8, 20)",
    366 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(22,'rss_language', 3, 'en', 'the language of your blog ( see this: http://backend.userland.com/stories/storyReader$16 )', 8, 20)",
    367 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(23,'rss_encoded_html', 2, '0', 'for b2rss.php: allow encoded HTML in &lt;description> tag?', 8, 20)",
    368 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(24,'rss_excerpt_length', 1, '50', 'length (in words) of excerpts in the RSS feed? 0=unlimited note: in b2rss.php, this will be set to 0 if you use encoded HTML', 8, 20)",
    369 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(25,'rss_use_excerpt', 2, '0', 'use the excerpt field for rss feed.', 8, 20)",
    370 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(29,'use_trackback', 2, '1', 'set this to 0 or 1, whether you want to allow your posts to be trackback\'able or not note: setting it to zero would also disable sending trackbacks', 8, 20)",
    371 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(30,'use_pingback', 2, '1', 'set this to 0 or 1, whether you want to allow your posts to be pingback\'able or not note: setting it to zero would also disable sending pingbacks', 8, 20)",
    372 //file upload
    373 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(31,'use_fileupload', 2, '0', 'set this to false to disable file upload, or true to enable it', 8, 20)",
    374 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(32,'fileupload_realpath', 3, '/home/your/site/wordpress/images', 'enter the real path of the directory where you\'ll upload the pictures \nif you\'re unsure about what your real path is, please ask your host\'s support staff \nnote that the  directory must be writable by the webserver (chmod 766) \nnote for windows-servers users: use forwardslashes instead of backslashes', 8, 40)",
    375 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(33,'fileupload_url', 3, 'http://example.com/images', 'enter the URL of that directory (it\'s used to generate the links to the uploded files)', 8, 40)",
    376 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(34,'fileupload_allowedtypes', 3, 'jpg jpeg gif png', 'accepted file types, separated by spaces. example: \'jpg gif png\'', 8, 20)",
    377 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(35,'fileupload_maxk', 1, '96', 'by default, most servers limit the size of uploads to 2048 KB, if you want to set it to a lower value, here it is (you cannot set a higher value than your server limit)', 8, 20)",
    378 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(36,'fileupload_minlevel', 1, '4', 'you may not want all users to upload pictures/files, so you can set a minimum level for this', 8, 20)",
    379 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(37,'fileupload_allowedusers', 3, '', '...or you may authorize only some users. enter their logins here, separated by spaces. if you leave this variable blank, all users who have the minimum level are authorized to upload. example: \'barbara anne george\'', 8, 30)",
    380 // email settings
    381 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(38,'mailserver_url', 3, 'mail.example.com', 'mailserver settings', 8, 20)",
    382 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(39,'mailserver_login', 3, 'login@example.com', 'mailserver settings', 8, 20)",
    383 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(40,'mailserver_pass', 3, 'password', 'mailserver settings', 8, 20)",
    384 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(41,'mailserver_port', 1, '110', 'mailserver settings', 8, 20)",
    385 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(42,'default_category', 1, '1', 'by default posts will have this category', 8, 20)",
    386 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(46,'use_phoneemail', 2, '0', 'some mobile phone email services will send identical subject & content on the same line if you use such a service, set use_phoneemail to true, and indicate a separator string', 8, 20)",
    387 // original options from options page
    388 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(48,'posts_per_page', 1, '10','How many posts/days to show on the index page.', 4, 20)",
    389 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(49,'what_to_show', 5, 'posts','Posts or days', 4, 20)",
    390 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(50,'archive_mode', 5, 'monthly','Which \'unit\' to use for archives.', 4, 20)",
    391 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(51,'time_difference', 6, '0', 'if you\'re not on the timezone of your server', 4, 20)",
    392 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(52,'date_format', 3, 'n/j/Y', 'see note for format characters', 4, 20)",
    393 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(53,'time_format', 3, 'g:i a', 'see note for format characters', 4, 20)",
    394 
    395 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(55,'default_post_status',    5, 'publish', 'The default state of each new post', 8, 20)",
    396 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(56,'default_comment_status', 5, 'open', 'The default state of comments for each new post', 8, 20)",
    397 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(57,'default_ping_status',    5, 'open', 'The default ping state for each new post', 8, 20)",
    398 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(58,'default_pingback_flag',  5, '1', 'Whether the \'PingBack the URLs in this post\' checkbox should be checked by default', 8, 20)",
    399 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(59,'default_post_category',  7, '1', 'The default category for each new post', 8, 20)",
    400 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(83,'default_post_edit_rows', 1, '9', 'The number of rows in the edit post form (min 3, max 100)', 8, 5)",
    401 
    402 );
    403 
    404 foreach ($option_data as $query) {
    405     $q = $wpdb->query($query);
    406 }
    407 ?>
    408 
    409 
    410 
    411 <?php
    412 $links_option_data = array(
    413 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(60,'links_minadminlevel',    1, '5', 'The minimum admin level to edit links', 8, 10)",
    414 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(61,'links_use_adminlevels',  2, '1', 'set this to false to have all links visible and editable to everyone in the link manager', 8, 20)",
    415 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(62,'links_rating_type',      5, 'image', 'Set this to the type of rating indication you wish to use', 8, 10)",
    416 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(63,'links_rating_char',      3, '*', 'If we are set to \'char\' which char to use.', 8, 5)",
    417 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(64,'links_rating_ignore_zero', 2, '1', 'What do we do with a value of zero? set this to true to output nothing, 0 to output as normal (number/image)', 8, 20)",
    418 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(65,'links_rating_single_image',  2, '1', 'Use the same image for each rating point? (Uses links_rating_image[0])', 8, 20)",
    419 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(66,'links_rating_image0',  3, 'wp-links/links-images/tick.png', 'Image for rating 0 (and for single image)', 8, 40)",
    420 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(67,'links_rating_image1',  3, 'wp-links/links-images/rating-1.gif', 'Image for rating 1', 8, 40)",
    421 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(68,'links_rating_image2',  3, 'wp-links/links-images/rating-2.gif', 'Image for rating 2', 8, 40)",
    422 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(69,'links_rating_image3',  3, 'wp-links/links-images/rating-3.gif', 'Image for rating 3', 8, 40)",
    423 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(70,'links_rating_image4',  3, 'wp-links/links-images/rating-4.gif', 'Image for rating 4', 8, 40)",
    424 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(71,'links_rating_image5',  3, 'wp-links/links-images/rating-5.gif', 'Image for rating 5', 8, 40)",
    425 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(72,'links_rating_image6',  3, 'wp-links/links-images/rating-6.gif', 'Image for rating 6', 8, 40)",
    426 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(73,'links_rating_image7',  3, 'wp-links/links-images/rating-7.gif', 'Image for rating 7', 8, 40)",
    427 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(74,'links_rating_image8',  3, 'wp-links/links-images/rating-8.gif', 'Image for rating 8', 8, 40)",
    428 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(75,'links_rating_image9',  3, 'wp-links/links-images/rating-9.gif', 'Image for rating 9', 8, 40)",
    429 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(77,'weblogs_xml_url',      3, 'http://www.weblogs.com/changes.xml', 'Which file to grab from weblogs.com', 8, 40)",
    430 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(78,'weblogs_cacheminutes', 1, '60', 'cache time in minutes (if it is older than this get a new copy)', 8, 10)",
    431 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(79,'links_updated_date_format',  3, 'd/m/Y h:i', 'The date format for the updated tooltip', 8, 25)",
    432 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(80,'links_recently_updated_prepend',  3, '&gt;&gt;', 'The text to prepend to a recently updated link', 8, 10)",
    433 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(81,'links_recently_updated_append',  3, '&lt;&lt;', 'The text to append to a recently updated link', 8, 20)",
    434 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(82,'links_recently_updated_time',  1, '120', 'The time in minutes to consider a link recently updated', 8, 20)",
    435 );
    436 
    437 foreach ($links_option_data as $query) {
    438     $q = $wpdb->query($query);
    439 }
    440 ?>
    441 
    442 
    443 <?php
    444 $geo_option_data = array(
    445 // data for geo settings
    446 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(84,'use_geo_positions', 2, '0', 'Turns on the geo url features of WordPress', 8, 20)",
    447 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(85,'use_default_geourl', 2, '1','enables placement of default GeoURL ICBM location even when no other specified', 8, 20)",
    448 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(86,'default_geourl_lat ', 8, 0.0, 'The default Latitude ICBM value - <a href=\"http://www.geourl.org/resources.html\" target=\"_blank\">see here</a>', 8, 20)",
    449 "INSERT INTO $wpdb->options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(87,'default_geourl_lon', 8, 0.0, 'The default Longitude ICBM value', 8, 20)",
    450 );
    451 
    452 foreach ($geo_option_data as $query) {
    453     $q = $wpdb->query($query);
    454 }
    455 ?>
    456 
    457 <p>Groovy. We're almost done.</p>
    458 
    459 <h1>Third Step</h1>
    460 <?php
    461 // $query = "DROP TABLE IF EXISTS $wpdb->users";
    462 // $q = mysql_query($query) or mysql_doh("doh, can't drop the table \"$wpdb->users\" in the database.");
    463 
    464 $query = "
    465 CREATE TABLE $wpdb->users (
    466   ID int(10) unsigned NOT NULL auto_increment,
    467   user_login varchar(20) NOT NULL default '',
    468   user_pass varchar(64) NOT NULL default '',
    469   user_firstname varchar(50) NOT NULL default '',
    470   user_lastname varchar(50) NOT NULL default '',
    471   user_nickname varchar(50) NOT NULL default '',
    472   user_icq int(10) unsigned NOT NULL default '0',
    473   user_email varchar(100) NOT NULL default '',
    474   user_url varchar(100) NOT NULL default '',
    475   user_ip varchar(15) NOT NULL default '',
    476   user_domain varchar(200) NOT NULL default '',
    477   user_browser varchar(200) NOT NULL default '',
    478   dateYMDhour datetime NOT NULL default '0000-00-00 00:00:00',
    479   user_level int(2) unsigned NOT NULL default '0',
    480   user_aim varchar(50) NOT NULL default '',
    481   user_msn varchar(100) NOT NULL default '',
    482   user_yim varchar(50) NOT NULL default '',
    483   user_idmode varchar(20) NOT NULL default '',
    484   PRIMARY KEY  (ID),
    485   UNIQUE KEY (user_login)
    486 )
    487 ";
    488 $q = $wpdb->query($query);
    489 
    490 $random_password = substr(md5(uniqid(microtime())),0,6);
    491 
    492 $query = "INSERT INTO $wpdb->users (ID, user_login, user_pass, user_nickname, user_email, user_level, user_idmode) VALUES ( '1', 'admin', MD5('$random_password'), 'Administrator', '$admin_email', '10', 'nickname')";
    493 $q = $wpdb->query($query);
    494 
    495 // Do final updates
    496 upgrade_all();
     148// Set up admin user
     149$random_password = substr(md5(uniqid(microtime())), 0, 6);
     150$wpdb->query("INSERT INTO $wpdb->users (ID, user_login, user_pass, user_nickname, user_email, user_level, user_idmode) VALUES ( '1', 'admin', MD5('$random_password'), 'Administrator', '$admin_email', '10', 'nickname')");
    497151
    498152mail($admin_email, 'New WordPress Blog', "Your new WordPress blog has been sucessfully set up at:
     
    510164http://wordpress.org/
    511165");
     166
     167upgrade_all();
    512168?>
    513169
    514 <p>User setup successful!</p>
     170<p><em>Finished!</em></p>
    515171
    516172<p>Now you can <a href="../wp-login.php">log in</a> with the <strong>login</strong>
     
    525181<dt>Password</dt>
    526182<dd><code><?php echo $random_password; ?></code></dd>
     183<dt>Login address</dt>
     184<dd><a href="../wp-login.php">wp-login.php</a></dd>
    527185</dl>
    528 <p>Were you expecting more steps? Sorry to disappoint. All done!</p>
     186<p>Were you expecting more steps? Sorry to disappoint. All done! :)</p>
    529187<?php
    530188    break;
  • trunk/wp-admin/upgrade-functions.php

    r1599 r1601  
    11<?php
     2require_once('./upgrade-schema.php');
    23// Functions to be called in install and upgrade scripts
    3 
    4 // First let's set up the tables:
    5 
    6 $wp_queries="CREATE TABLE $wpdb->categories (
    7   cat_ID int(4) NOT NULL auto_increment,
    8   cat_name varchar(55) NOT NULL default '',
    9   category_nicename varchar(200) NOT NULL default '',
    10   category_description text NOT NULL,
    11   category_parent int(4) NOT NULL default '0',
    12   PRIMARY KEY  (cat_ID),
    13   UNIQUE KEY cat_name (cat_name),
    14   KEY category_nicename (category_nicename)
    15 );
    16 CREATE TABLE $wpdb->comments (
    17   comment_ID int(11) unsigned NOT NULL auto_increment,
    18   comment_post_ID int(11) NOT NULL default '0',
    19   comment_author tinytext NOT NULL,
    20   comment_author_email varchar(100) NOT NULL default '',
    21   comment_author_url varchar(200) NOT NULL default '',
    22   comment_author_IP varchar(100) NOT NULL default '',
    23   comment_date datetime NOT NULL default '0000-00-00 00:00:00',
    24   comment_date_gmt datetime NOT NULL default '0000-00-00 00:00:00',
    25   comment_content text NOT NULL,
    26   comment_karma int(11) NOT NULL default '0',
    27   comment_approved enum('0','1') NOT NULL default '1',
    28   user_id int(11) NOT NULL default '0',
    29   PRIMARY KEY  (comment_ID),
    30   KEY comment_approved (comment_approved),
    31   KEY comment_post_ID (comment_post_ID)
    32 );
    33 CREATE TABLE $wpdb->linkcategories (
    34   cat_id int(11) NOT NULL auto_increment,
    35   cat_name tinytext NOT NULL,
    36   auto_toggle enum('Y','N') NOT NULL default 'N',
    37   show_images enum('Y','N') NOT NULL default 'Y',
    38   show_description enum('Y','N') NOT NULL default 'N',
    39   show_rating enum('Y','N') NOT NULL default 'Y',
    40   show_updated enum('Y','N') NOT NULL default 'Y',
    41   sort_order varchar(64) NOT NULL default 'name',
    42   sort_desc enum('Y','N') NOT NULL default 'N',
    43   text_before_link varchar(128) NOT NULL default '<li>',
    44   text_after_link varchar(128) NOT NULL default '<br />',
    45   text_after_all varchar(128) NOT NULL default '</li>',
    46   list_limit int(11) NOT NULL default '-1',
    47   PRIMARY KEY  (cat_id)
    48 );
    49 CREATE TABLE $wpdb->links (
    50   link_id int(11) NOT NULL auto_increment,
    51   link_url varchar(255) NOT NULL default '',
    52   link_name varchar(255) NOT NULL default '',
    53   link_image varchar(255) NOT NULL default '',
    54   link_target varchar(25) NOT NULL default '',
    55   link_category int(11) NOT NULL default '0',
    56   link_description varchar(255) NOT NULL default '',
    57   link_visible enum('Y','N') NOT NULL default 'Y',
    58   link_owner int(11) NOT NULL default '1',
    59   link_rating int(11) NOT NULL default '0',
    60   link_updated datetime NOT NULL default '0000-00-00 00:00:00',
    61   link_rel varchar(255) NOT NULL default '',
    62   link_notes mediumtext NOT NULL,
    63   link_rss varchar(255) NOT NULL default '',
    64   PRIMARY KEY  (link_id),
    65   KEY link_category (link_category),
    66   KEY link_visible (link_visible)
    67 );
    68 CREATE TABLE $wpdb->options (
    69   option_id int(11) NOT NULL auto_increment,
    70   blog_id int(11) NOT NULL default '0',
    71   option_name varchar(64) NOT NULL default '',
    72   option_can_override enum('Y','N') NOT NULL default 'Y',
    73   option_type int(11) NOT NULL default '1',
    74   option_value text NOT NULL,
    75   option_width int(11) NOT NULL default '20',
    76   option_height int(11) NOT NULL default '8',
    77   option_description tinytext NOT NULL,
    78   option_admin_level int(11) NOT NULL default '1',
    79   autoload enum('yes','no') NOT NULL default 'yes',
    80   PRIMARY KEY  (option_id,blog_id,option_name)
    81 );
    82 CREATE TABLE $wpdb->post2cat (
    83   rel_id int(11) NOT NULL auto_increment,
    84   post_id int(11) NOT NULL default '0',
    85   category_id int(11) NOT NULL default '0',
    86   PRIMARY KEY  (rel_id),
    87   KEY post_id (post_id,category_id)
    88 );
    89 CREATE TABLE $wpdb->postmeta (
    90   meta_id int(11) NOT NULL auto_increment,
    91   post_id int(11) NOT NULL default '0',
    92   meta_key varchar(255) default NULL,
    93   meta_value text,
    94   PRIMARY KEY  (meta_id),
    95   KEY post_id (post_id),
    96   KEY meta_key (meta_key)
    97 );
    98 CREATE TABLE $wpdb->posts (
    99   ID int(10) unsigned NOT NULL auto_increment,
    100   post_author int(4) NOT NULL default '0',
    101   post_date datetime NOT NULL default '0000-00-00 00:00:00',
    102   post_date_gmt datetime NOT NULL default '0000-00-00 00:00:00',
    103   post_content text NOT NULL,
    104   post_title text NOT NULL,
    105   post_category int(4) NOT NULL default '0',
    106   post_excerpt text NOT NULL,
    107   post_lat float default NULL,
    108   post_lon float default NULL,
    109   post_status enum('publish','draft','private','static') NOT NULL default 'publish',
    110   comment_status enum('open','closed','registered_only') NOT NULL default 'open',
    111   ping_status enum('open','closed') NOT NULL default 'open',
    112   post_password varchar(20) NOT NULL default '',
    113   post_name varchar(200) NOT NULL default '',
    114   to_ping text NOT NULL,
    115   pinged text NOT NULL,
    116   post_modified datetime NOT NULL default '0000-00-00 00:00:00',
    117   post_modified_gmt datetime NOT NULL default '0000-00-00 00:00:00',
    118   post_content_filtered text NOT NULL,
    119   post_parent int(11) NOT NULL default '0',
    120   PRIMARY KEY  (ID),
    121   KEY post_date (post_date),
    122   KEY post_date_gmt (post_date_gmt),
    123   KEY post_name (post_name),
    124   KEY post_status (post_status)
    125 );
    126 CREATE TABLE $wpdb->users (
    127   ID int(10) unsigned NOT NULL auto_increment,
    128   user_login varchar(20) NOT NULL default '',
    129   user_pass varchar(64) NOT NULL default '',
    130   user_firstname varchar(50) NOT NULL default '',
    131   user_lastname varchar(50) NOT NULL default '',
    132   user_nickname varchar(50) NOT NULL default '',
    133   user_nicename varchar(50) NOT NULL default '',
    134   user_icq int(10) unsigned NOT NULL default '0',
    135   user_email varchar(100) NOT NULL default '',
    136   user_url varchar(100) NOT NULL default '',
    137   user_ip varchar(15) NOT NULL default '',
    138   user_domain varchar(200) NOT NULL default '',
    139   user_browser varchar(200) NOT NULL default '',
    140   dateYMDhour datetime NOT NULL default '0000-00-00 00:00:00',
    141   user_level int(2) unsigned NOT NULL default '0',
    142   user_aim varchar(50) NOT NULL default '',
    143   user_msn varchar(100) NOT NULL default '',
    144   user_yim varchar(50) NOT NULL default '',
    145   user_idmode varchar(20) NOT NULL default '',
    146   user_activation_key varchar(60) NOT NULL default '',
    147   user_status int(11) NOT NULL default '0',
    148   PRIMARY KEY  (ID),
    149   UNIQUE KEY user_login (user_login)
    150 );";
    151 
    152 
    153 
    1544function upgrade_all() {
    1555    populate_options();
    156     upgrade_071();
    157     upgrade_072();
    1586    upgrade_100();
    1597    upgrade_101();
     
    16210}
    16311
    164 function populate_options() {
    165 
    166     $guessurl = preg_replace('|/wp-admin/.*|i', '', 'http://' . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI']);
    167     add_option('siteurl', $guessurl, 'WordPress web address');
    168     add_option('blogfilename', '', 'Default file for blog');
    169     add_option('blogname', 'My Weblog', 'Blog title');
    170     add_option('blogdescription', '', 'Short tagline');
    171     add_option('new_users_can_blog', 0);
    172     add_option('users_can_register', 1);
    173     add_option('admin_email', 'you@example.com');
    174     add_option('start_of_week', 1);
    175     add_option('use_balanceTags', 1);
    176     add_option('use_smilies', 1);
    177     add_option('require_name_email', 1);
    178     add_option('comments_notify', 1);
    179     add_option('posts_per_rss', 10);
    180     add_option('rss_excerpt_length', 50);
    181     add_option('rss_use_excerpt', 0);
    182     add_option('use_fileupload', 0);
    183     add_option('fileupload_realpath', ABSPATH . 'wp-content');
    184     add_option('fileupload_url', get_option('siteurl') . '/wp-content');
    185     add_option('fileupload_allowedtypes', 'jpg jpeg gif png');
    186     add_option('fileupload_maxk', 300);
    187     add_option('fileupload_minlevel', 6);
    188     add_option('mailserver_url', 'mail.example.com');
    189     add_option('mailserver_login', 'login@example.com');
    190     add_option('mailserver_pass', 'password');
    191     add_option('mailserver_port', 110);
    192     add_option('default_category', 1);
    193     add_option('default_comment_status', 'open');
    194     add_option('default_ping_status', 'open');
    195     add_option('default_pingback_flag', 1);
    196     add_option('default_post_edit_rows', 9);
    197     add_option('posts_per_page', 10);
    198     add_option('what_to_show', 'posts');
    199     add_option('date_format', 'F j, Y');
    200     add_option('time_format', 'g:i a');
    201     add_option('use_geo_positions', 0);
    202     add_option('use_default_geourl', 0);
    203     add_option('default_geourl_lat', 0);
    204     add_option('default_geourl_lon', 0);
    205     add_option('weblogs_xml_url', 'http://static.wordpress.org/changes.xml');
    206     add_option('links_updated_date_format', 'F j, Y g:i a');
    207     add_option('links_recently_updated_prepend', '<em>');
    208     add_option('links_recently_updated_append', '</em>');
    209     add_option('links_recently_updated_time', 120);
    210     add_option('comment_moderation', 0);
    211     add_option('moderation_notify', 1);
    212     add_option('permalink_structure');
    213     add_option('gzipcompression', 0);
    214     add_option('hack_file', 0);
    215     add_option('blog_charset', 'utf-8');
    216     add_option('moderation_keys');
    217     add_option('active_plugins');
    218     add_option('home');
    219     add_option('category_base');
    220     add_option('ping_sites', 'http://rpc.pingomatic.com/');
    221     add_option('advanced_edit', 0);
    222     add_option('comment_max_links', 2);
    223 
    224     // Delete unused options
    225     $unusedoptions = array ('blodotgsping_url', 'bodyterminator', 'emailtestonly', 'phoneemail_separator', 'smilies_directory', 'subjectprefix', 'use_bbcode', 'use_blodotgsping', 'use_phoneemail', 'use_quicktags', 'use_weblogsping', 'weblogs_cache_file', 'use_preview', 'use_htmltrans', 'smilies_directory', 'rss_language', 'fileupload_allowedusers', 'use_phoneemail', 'default_post_status', 'default_post_category', 'archive_mode', 'time_difference', 'links_minadminlevel', 'links_use_adminlevels', 'links_rating_type', 'links_rating_char', 'links_rating_ignore_zero', 'links_rating_single_image', 'links_rating_image0', 'links_rating_image1', 'links_rating_image2', 'links_rating_image3', 'links_rating_image4', 'links_rating_image5', 'links_rating_image6', 'links_rating_image7', 'links_rating_image8', 'links_rating_image9', 'weblogs_cacheminutes', 'comment_allowed_tags', 'search_engine_friendly_urls');
    226     foreach ($unusedoptions as $option) :
    227         delete_option($option);
    228     endforeach;
    229 }
    230 
    231 function upgrade_071() {
    232     global $wpdb;
    233     maybe_add_column($wpdb->posts, 'post_status', "ALTER TABLE $wpdb->posts ADD `post_status` ENUM('publish','draft','private') NOT NULL");
    234     maybe_add_column($wpdb->posts, 'comment_status', "ALTER TABLE $wpdb->posts ADD `comment_status` ENUM('open','closed') NOT NULL");
    235     maybe_add_column($wpdb->posts, 'ping_status', "ALTER TABLE $wpdb->posts ADD `ping_status` ENUM('open','closed') NOT NULL");
    236     maybe_add_column($wpdb->posts, 'post_password', "ALTER TABLE $wpdb->posts ADD post_password varchar(20) NOT NULL");
    237 }
    238 
    239 function upgrade_072() {
    240     global $wpdb;
    241     maybe_add_column($wpdb->links, 'link_notes', "ALTER TABLE $wpdb->links ADD COLUMN link_notes MEDIUMTEXT NOT NULL DEFAULT '' ");
    242     maybe_add_column($wpdb->linkcategories, 'show_images', "ALTER TABLE $wpdb->linkcategories ADD COLUMN show_images enum('Y','N') NOT NULL default 'Y'");
    243     maybe_add_column($wpdb->linkcategories, 'show_description', "ALTER TABLE $wpdb->linkcategories ADD COLUMN show_description enum('Y','N') NOT NULL default 'Y'");
    244     maybe_add_column($wpdb->linkcategories, 'show_rating', "ALTER TABLE $wpdb->linkcategories ADD COLUMN show_rating enum('Y','N') NOT NULL default 'Y'");
    245     maybe_add_column($wpdb->linkcategories, 'show_updated', "ALTER TABLE $wpdb->linkcategories ADD COLUMN show_updated enum('Y','N') NOT NULL default 'Y'");
    246     maybe_add_column($wpdb->linkcategories, 'sort_order', "ALTER TABLE $wpdb->linkcategories ADD COLUMN sort_order varchar(64) NOT NULL default 'name'");
    247     maybe_add_column($wpdb->linkcategories, 'sort_desc', "ALTER TABLE $wpdb->linkcategories ADD COLUMN sort_desc enum('Y','N') NOT NULL default 'N'");
    248     maybe_add_column($wpdb->linkcategories, 'text_before_link', "ALTER TABLE $wpdb->linkcategories ADD COLUMN text_before_link varchar(128) not null default '<li>'");
    249     maybe_add_column($wpdb->linkcategories, 'text_after_link', "ALTER TABLE $wpdb->linkcategories ADD COLUMN text_after_link  varchar(128) not null default '<br />'");
    250     maybe_add_column($wpdb->linkcategories, 'text_after_all', "ALTER TABLE $wpdb->linkcategories ADD COLUMN text_after_all  varchar(128) not null default '</li>'");
    251     maybe_add_column($wpdb->linkcategories, 'list_limit', "ALTER TABLE $wpdb->linkcategories ADD COLUMN list_limit int not null default -1");
    252     maybe_add_column($wpdb->posts, 'post_lon', "ALTER TABLE $wpdb->posts ADD COLUMN post_lon float");
    253     maybe_add_column($wpdb->posts, 'post_lat', "ALTER TABLE $wpdb->posts ADD COLUMN post_lat float ");
    254     maybe_create_table($wpdb->options, "
    255     CREATE TABLE $wpdb->options (
    256       option_id int(11) NOT NULL auto_increment,
    257       blog_id int(11) NOT NULL default 0,
    258       option_name varchar(64) NOT NULL default '',
    259       option_can_override enum('Y','N') NOT NULL default 'Y',
    260       option_type int(11) NOT NULL default 1,
    261       option_value varchar(255) NOT NULL default '',
    262       option_width int NOT NULL default 20,
    263       option_height int NOT NULL default 8,
    264       option_description tinytext NOT NULL default '',
    265       option_admin_level int NOT NULL DEFAULT '1',
    266       PRIMARY KEY (option_id, blog_id, option_name)
    267     )
    268     ");
    269 }
    270 
    27112function upgrade_100() {
    27213    global $wpdb;
    273     maybe_add_column($wpdb->posts, 'post_name', "ALTER TABLE `$wpdb->posts` ADD `post_name` VARCHAR(200) NOT NULL");
    274     maybe_add_column($wpdb->posts, 'to_ping', "ALTER TABLE $wpdb->posts ADD `to_ping` TEXT NOT NULL");
    275     maybe_add_column($wpdb->posts, 'pinged', "ALTER TABLE $wpdb->posts ADD `pinged` TEXT NOT NULL");
    276     maybe_add_column($wpdb->posts, 'post_modified', "ALTER TABLE $wpdb->posts ADD `post_modified` DATETIME NOT NULL");
    277     maybe_add_column($wpdb->posts, 'post_content_filtered', "ALTER TABLE $wpdb->posts ADD `post_content_filtered` TEXT NOT NULL");
    278     maybe_add_column($wpdb->categories, 'category_nicename', "ALTER TABLE `$wpdb->categories` ADD `category_nicename` VARCHAR(200) NOT NULL"); 
    279     maybe_add_column($wpdb->categories, 'category_description', "ALTER TABLE `$wpdb->categories` ADD `category_description` TEXT NOT NULL");
    280     maybe_add_column($wpdb->categories, 'category_parent', "ALTER TABLE `$wpdb->categories` ADD `category_parent` INT(4) NOT NULL");
    281     maybe_add_column($wpdb->links, 'link_rss', "ALTER TABLE `$wpdb->links` ADD `link_rss` VARCHAR( 255 ) NOT NULL;");
    282     maybe_add_column($wpdb->users, 'user_description', "ALTER TABLE `$wpdb->users` ADD `user_description` TEXT NOT NULL");
    283     maybe_add_column($wpdb->comments, 'comment_approved', "ALTER TABLE $wpdb->comments ADD COLUMN comment_approved ENUM('0', '1') DEFAULT '1' NOT NULL");
    284 
    285     // Create indicies
    286     add_clean_index($wpdb->posts, 'post_name');
    287     add_clean_index($wpdb->categories, 'category_nicename');
    288     add_clean_index($wpdb->comments, 'comment_approved');
    28914
    29015    // Get the title and ID of every post, post_name to check if it already has a value
     
    31136                                                      WHERE option_name LIKE 'links_rating_image%'
    31237                                                      AND option_value LIKE 'wp-links/links-images/%'");
    313 
    314     // Multiple categories
    315     maybe_create_table($wpdb->post2cat, "
    316         CREATE TABLE `$wpdb->post2cat` (
    317         `rel_id` INT NOT NULL AUTO_INCREMENT ,
    318         `post_id` INT NOT NULL ,
    319         `category_id` INT NOT NULL ,
    320         PRIMARY KEY ( `rel_id` ) ,
    321         INDEX ( `post_id` , `category_id` )
    322         )
    323         ");
    32438
    32539    $done_ids = $wpdb->get_results("SELECT DISTINCT post_id FROM $wpdb->post2cat");
     
    35367    global $wpdb;
    35468
    355     // Less intrusive default
    356     $wpdb->query("ALTER TABLE `$wpdb->linkcategories` CHANGE `show_description` `show_description` ENUM( 'Y', 'N' ) DEFAULT 'N' NOT NULL");
    357    
    35869    // Clean up indices, add a few
    35970    add_clean_index($wpdb->posts, 'post_name');
     
    37081  global $wpdb;
    37182   
    372     maybe_add_column($wpdb->comments, 'user_id', "ALTER TABLE `$wpdb->comments` ADD `user_id` INT DEFAULT '0' NOT NULL ;");
    373     maybe_add_column($wpdb->users, 'user_activation_key', "ALTER TABLE `$wpdb->users` ADD `user_activation_key` VARCHAR( 60 ) NOT NULL ;");
    374     maybe_add_column($wpdb->users, 'user_status', "ALTER TABLE `$wpdb->users` ADD `user_status` INT DEFAULT '0' NOT NULL ;");
    375     $wpdb->query("ALTER TABLE `$wpdb->posts` CHANGE `comment_status` `comment_status` ENUM( 'open', 'closed', 'registered_only' ) DEFAULT 'open' NOT NULL");
    376 
    377     maybe_add_column($wpdb->users, 'user_nicename', "ALTER TABLE `$wpdb->users` ADD `user_nicename` VARCHAR(50) DEFAULT '' NOT NULL ;");
    378     maybe_add_column($wpdb->posts, 'post_date_gmt', "ALTER TABLE $wpdb->posts ADD post_date_gmt DATETIME NOT NULL AFTER post_date");
    379     maybe_add_column($wpdb->posts, 'post_modified_gmt', "ALTER TABLE $wpdb->posts ADD post_modified_gmt DATETIME NOT NULL AFTER post_modified");
    380     maybe_add_column($wpdb->comments, 'comment_date_gmt', "ALTER TABLE $wpdb->comments ADD comment_date_gmt DATETIME NOT NULL AFTER comment_date");
    381 
    38283    // Set user_nicename.
    38384    $users = $wpdb->get_results("SELECT ID, user_nickname, user_nicename FROM $wpdb->users");
     
    437138    }
    438139
    439     // post-meta
    440     maybe_create_table($wpdb->postmeta, "
    441     CREATE TABLE $wpdb->postmeta (
    442       meta_id int(11) NOT NULL auto_increment,
    443       post_id int(11) NOT NULL default 0,
    444       meta_key varchar(255),
    445       meta_value text,
    446       PRIMARY KEY (meta_id),
    447       INDEX (post_id),
    448       INDEX (meta_key)
    449     )
    450     ");
    451 
    452140    // First we need to enlarge option_value so it can hold larger values:
    453141    $wpdb->query("ALTER TABLE `$wpdb->options` CHANGE `option_value` `option_value` TEXT NOT NULL");
    454142
    455     // Fix for CVS versions
    456     $wpdb->query("UPDATE $wpdb->options SET option_type = '5' WHERE option_name = 'advanced_edit'");
    457 
    458     // Forward-thinking
    459     $wpdb->query("ALTER TABLE `$wpdb->posts` CHANGE `post_status` `post_status` ENUM( 'publish', 'draft', 'private', 'static' ) DEFAULT 'publish' NOT NULL");
    460     maybe_add_column($wpdb->posts, 'post_parent', "ALTER TABLE `$wpdb->posts` ADD `post_parent` INT NOT NULL ;");
    461 
    462 
    463143    $wpdb->query("ALTER TABLE `$wpdb->comments` CHANGE `comment_author_url` `comment_author_url` VARCHAR( 200 ) NOT NULL");
    464144}
     
    466146function upgrade_130() {
    467147    global $wpdb, $table_prefix;
    468 
    469     add_option('default_email_category', 1, 'Posts by email go to this category');
    470     add_option('recently_edited');
    471     add_option('use_linksupdate', 0);
    472 
    473     maybe_add_column($wpdb->options, 'autoload', "ALTER TABLE `$wpdb->options` ADD `autoload` ENUM( 'yes', 'no' ) NOT NULL ;");
    474 
    475     // Set up a few options not to load by default
    476     $fatoptions = array( 'moderation_keys', 'recently_edited' );
    477     foreach ($fatoptions as $fatoption) :
    478         $wpdb->query("UPDATE $wpdb->options SET `autoload` = 'no' WHERE option_name = '$fatoption'");
    479     endforeach;
    480148
    481149    // Remove extraneous backslashes.
     
    837505}
    838506
    839 function rename_field($table, $field, $new) {
    840 //  ALTER TABLE `wp_users` CHANGE `ID` `user_id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT
    841 }
    842 
    843 function remove_field($table, $field) {
    844     global $wpdb;
    845 // ALTER TABLE `wp_users` DROP `user_domain`
     507function make_db_current_silent() {
     508    global $wp_queries;
     509
     510    $alterations = dbDelta($wp_queries);
    846511}
    847512
  • trunk/wp-admin/upgrade.php

    r1575 r1601  
    1212<html xmlns="http://www.w3.org/1999/xhtml">
    1313<head>
    14 <title>WordPress &rsaquo; Upgrade WordPress</title>
    15 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    16 <style media="screen" type="text/css">
     14    <title>WordPress &rsaquo; Upgrade</title>
     15    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
     16    <style media="screen" type="text/css">
     17    <!--
     18    html {
     19        background: #eee;
     20    }
    1721    body {
    18         background-color: white;
    19         color: black;
     22        background: #fff;
     23        color: #000;
    2024        font-family: Georgia, "Times New Roman", Times, serif;
    21         margin-left: 15%;
    22         margin-right: 15%;
     25        margin-left: 20%;
     26        margin-right: 20%;
     27        padding: .2em 2em;
     28    }
     29   
     30    h1 {
     31        color: #006;
     32        font-size: 18px;
     33        font-weight: lighter;
     34    }
     35   
     36    h2 {
     37        font-size: 16px;
     38    }
     39   
     40    p, li, dt {
     41        line-height: 140%;
     42        padding-bottom: 2px;
     43    }
     44
     45    ul, ol {
     46        padding: 5px 5px 5px 20px;
    2347    }
    2448    #logo {
    25         margin: 0;
    26         padding: 0;
    27         background-image: url(http://wordpress.org/images/logo.png);
    28         background-repeat: no-repeat;
    29         height: 60px;
    30         border-bottom: 4px solid #333;
     49        margin-bottom: 2em;
    3150    }
    32     #logo a {
    33         display: block;
    34         text-decoration: none;
    35         text-indent: -100em;
    36         height: 60px;
    37     }
    38     p {
    39         line-height: 140%;
    40     }
     51.step a, .step input {
     52    font-size: 2em;
     53}
     54.step, th {
     55    text-align: right;
     56}
     57#footer {
     58text-align: center; border-top: 1px solid #ccc; padding-top: 1em; font-style: italic;
     59}
     60    -->
    4161    </style>
    42 </head><body>
    43 <h1 id="logo"><a href="http://wordpress.org">WordPress</a></h1>
     62</head>
     63<body>
     64<h1 id="logo"><img alt="WordPress" src="http://static.wordpress.org/logo.png" /></h1>
    4465<?php
    4566switch($step) {
     
    4768    case 0:
    4869?>
    49 <p>This file upgrades you from any previous version of WordPress to the latest. It may take a while though, so be patient. </p>
    50 <p>If you&#8217;re all ready, <a href="upgrade.php?step=1">let's go</a>! </p>
     70<p>This file upgrades you from any previous version of WordPress to the latest. It may take a while though, so be patient.</p>
     71<h2 class="step"><a href="upgrade.php?step=1">Upgrade WordPress &raquo;</a></h2>
    5172<?php
    5273    break;
    5374   
    5475    case 1:
     76    make_db_current_silent();
    5577    upgrade_all();
    5678?>
  • trunk/wp-includes/functions.php

    r1599 r1601  
    365365        $value = serialize($value);
    366366
    367     if(!get_settings($name)) {
     367    if( !$wpdb->get_var("SELECT option_name FROM $wpdb->options WHERE option_name = '$name'") ) {
    368368        $name = $wpdb->escape($name);
    369369        $value = $wpdb->escape($value);
Note: See TracChangeset for help on using the changeset viewer.