Changeset 949 for trunk/wp-admin/upgrade-functions.php

Timestamp:

02/27/2004 05:48:00 AM (21 years ago)

Author:

saxmatt

Message:

Some new options and an option cleanup.

File:

• trunk/wp-admin/upgrade-functions.php (modified) (4 diffs)

trunk/wp-admin/upgrade-functions.php

@@ -652 +652 @@
 function upgrade_101() {
     global $wpdb, $tableoptionvalues, $tablelinkcategories, $tableposts, $tablecategories, $tablecomments, $tablelinks;
-    // Fix possible duplicate problem from CVS
+    // Fix possible duplicate problem from CVS, we can REMOVE this later
     $option59 = $wpdb->get_results("SELECT * FROM $tableoptionvalues WHERE option_id  = '59'");
     if (1 < count($option59)) {
@@ -673 +673 @@
 }
 
+
 function upgrade_110() {
   global $wpdb, $tableusers, $tablecomments, $tableposts, $tableoptiongroups, $tableoptiongroup_options, $tableoptions, $tablepostmeta;
@@ -709 +710 @@
 
     // Add blog_charset option
-    if(!$wpdb->get_var("SELECT * FROM $tableoptions WHERE option_id = '93'")) {
-        $wpdb->query("INSERT INTO $tableoptions (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)");
+    if(!$wpdb->get_var("SELECT option_id FROM $tableoptions WHERE option_name = 'blog_charset'")) {
+        $wpdb->query("INSERT INTO $tableoptions (option_name, option_type, option_value, option_admin_level) VALUES ('blog_charset', 3, 'utf-8', 8)");
     }
 
@@ -768 +769 @@
     ");
 
+    // First we need to enlarge option_value so it can hold larger values:
+    $wpdb->query("ALTER TABLE `$tableoptions` CHANGE `option_value` `option_value` TEXT NOT NULL");
+    
+    // Now an option for blog pinging
+    if(!$wpdb->get_var("SELECT option_id FROM $tableoptions WHERE option_name = 'ping_sites'")) {
+        $wpdb->query("INSERT INTO $tableoptions (option_name, option_type, option_value, option_admin_level) VALUES ('ping_sites', 3, '', 8)");
+    }
+    
+    // Option for using the advanced edit screen by default
+    if(!$wpdb->get_var("SELECT option_id FROM $tableoptions WHERE option_name = 'advanced_edit'")) {
+        $wpdb->query("INSERT INTO $tableoptions (option_name, option_type, option_value, option_admin_level) VALUES ('advanced_edit', 3, '0', 8)");
+    }
 }