WordPress.org
Get WordPress

Make WordPress Core

Changeset 230


Ignore:
Timestamp:
06/15/2003 11:18:33 PM (21 years ago)
Author:
mikelittle
Message:

Install now does new options tables.

Location:
trunk
Files:
3 edited

Legend:

Unmodified
Added
Removed

  • trunk/wp-admin/temp-options-update.sql

    r223 r230  
    3939--//base options from b2cofig
    4040INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(1,'siteurl', 3, 'http://mydomain.com', 'siteurl is your blog\'s URL: for example, \'http://mydomain.com/wordpress\' (no trailing slash !)', 8, 30);
    41 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level)               VALUES(2,'blogfilename', 3, 'index.php', 'blogfilename is the name of the default file for your blog', 8);
    42 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level)               VALUES(3,'blogname', 3, 'my weblog', 'blogname is the name of your blog', 8);
     41INSERT INTO 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);
     42INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(3,'blogname', 3, 'my weblog', 'blogname is the name of your blog', 8, 20);
    4343INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(4,'blogdescription', 3, 'babblings!', 'blogdescription is the description of your blog', 8, 40);
    44 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level)               VALUES(6,'search_engine_friendly_urls', 2, 'false', 'Querystring Configuration ** (don\'t change if you don\'t know what you\'re doing)', 8);
    45 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level)               VALUES(7,'new_users_can_blog', 2, '0', 'whether you want new users to be able to post entries once they have registered', 8);
    46 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level)               VALUES(8,'users_can_register', 2, '1', 'whether you want to allow users to register on your blog', 8);
    47 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level)               VALUES(54,'admin_email', 3, 'you@example.com', 'Your email (obvious eh?)', 8);
     44INSERT INTO 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);
     45INSERT INTO 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);
     46INSERT INTO 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);
     47INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(54,'admin_email', 3, 'you@example.com', 'Your email (obvious eh?)', 8, 20);
    4848
    4949--// general blog setup
    50 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level)               VALUES(9 ,'start_of_week', 5, '1', 'day at the start of the week', 8);
    51 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level)               VALUES(10,'use_preview', 2, '1', 'Do you want to use the \'preview\' function', 8);
    52 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level)               VALUES(11,'use_bbcode', 2, '0', 'use BBCode, like [b]bold[/b]', 8);
    53 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level)               VALUES(12,'use_gmcode', 2, '0', 'use GreyMatter-styles: **bold** \\\\italic\\\\ __underline__', 8);
    54 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level)               VALUES(13,'use_quicktags', 2, '1', 'buttons for HTML tags (they won\'t work on IE Mac yet)', 8);
    55 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level)               VALUES(14,'use_htmltrans', 2, '1', 'IMPORTANT! set this to false if you are using Chinese, Japanese, Korean, or other double-bytes languages', 8);
    56 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level)               VALUES(15,'use_balanceTags', 2, '1', 'this could help balance your HTML code. if it gives bad results, set it to false', 8);
    57 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level)               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);
     50INSERT INTO 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);
     51INSERT INTO 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);
     52INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(11,'use_bbcode', 2, '0', 'use BBCode, like [b]bold[/b]', 8, 20);
     53INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(12,'use_gmcode', 2, '0', 'use GreyMatter-styles: **bold** \\\\italic\\\\ __underline__', 8, 20);
     54INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(13,'use_quicktags', 2, '1', 'buttons for HTML tags (they won\'t work on IE Mac yet)', 8, 20);
     55INSERT INTO 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);
     56INSERT INTO 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);
     57INSERT INTO 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);
    5858INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(17,'smilies_directory', 3, 'http://mydomain.com/b2-img/smilies', 'the directory where your smilies are (no trailing slash)', 8, 40);
    59 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level)               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);
     59INSERT INTO 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);
    6060INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(19,'comment_allowed_tags', 3, '<b><i><strong><em><code><blockquote><p><br><strike><a>', 'here is a list of the tags that are allowed in the comments. You can add tags to the list, just add them in the string, add only the opening tag: for example, only \'&lt;a>\' instead of \'&lt;a href="">&lt;/a>\'', 8, 40);
    61 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level)               VALUES(20,'comments_notify', 2, '1', 'set this to true to let every author be notified about comments on their posts', 8);
     61INSERT INTO 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);
    6262
    6363--//rss/rdf feeds
    64 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level)               VALUES(21,'posts_per_rss', 1, '10', 'number of last posts to syndicate', 8);
    65 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level)               VALUES(22,'rss_language', 3, 'en', 'the language of your blog ( see this: http://backend.userland.com/stories/storyReader$16 )', 8);
    66 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level)               VALUES(23,'rss_encoded_html', 2, '0', 'for b2rss.php: allow encoded HTML in &lt;description> tag?', 8);
    67 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level)               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);
    68 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level)               VALUES(25,'rss_use_excerpt', 2, '1', 'use the excerpt field for rss feed.', 8);
    69 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level)               VALUES(26,'use_weblogsping', 2, '0', 'set this to true if you want your site to be listed on http://weblogs.com when you add a new post', 8);
    70 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level)               VALUES(27,'use_blodotgsping', 2, '0', 'set this to true if you want your site to be listed on http://blo.gs when you add a new post', 8);
     64INSERT INTO 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);
     65INSERT INTO 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);
     66INSERT INTO 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);
     67INSERT INTO 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);
     68INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(25,'rss_use_excerpt', 2, '1', 'use the excerpt field for rss feed.', 8, 20);
     69INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(26,'use_weblogsping', 2, '0', 'set this to true if you want your site to be listed on http://weblogs.com when you add a new post', 8, 20);
     70INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(27,'use_blodotgsping', 2, '0', 'set this to true if you want your site to be listed on http://blo.gs when you add a new post', 8, 20);
    7171INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(28,'blodotgsping_url', 3, 'http://mydomain.com', 'You shouldn\'t need to change this.', 8, 30);
    72 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level)               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);
    73 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level)               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);
     72INSERT INTO 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);
     73INSERT INTO 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);
    7474
    7575--//file upload
    76 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level)               VALUES(31,'use_fileupload', 2, '0', 'set this to false to disable file upload, or true to enable it', 8);
     76INSERT INTO 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);
    7777INSERT INTO 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);
    7878INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(33,'fileupload_url', 3, 'http://mydomain.com/images', 'enter the URL of that directory (it\'s used to generate the links to the uploded files)', 8, 40);
    79 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level)               VALUES(34,'fileupload_allowedtypes', 3, ' jpg gif png ', 'accepted file types, you can add to that list if you want. note: add a space before and after each file type. example: \' jpg gif png \'', 8);
    80 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level)               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);
    81 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level)               VALUES(36,'fileupload_minlevel', 1, '1', 'you may not want all users to upload pictures/files, so you can set a minimum level for this', 8);
     79INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(34,'fileupload_allowedtypes', 3, ' jpg gif png ', 'accepted file types, you can add to that list if you want. note: add a space before and after each file type. example: \' jpg gif png \'', 8, 20);
     80INSERT INTO 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);
     81INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(36,'fileupload_minlevel', 1, '1', 'you may not want all users to upload pictures/files, so you can set a minimum level for this', 8, 20);
    8282INSERT INTO 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 that variable blank, all users who have the minimum level are authorized to upload note: add a space before and after each login name example: \' barbara anne \'', 8, 30);
    8383
    8484-- // email settings
    85 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level) VALUES(38,'mailserver_url', 3, 'mail.example.com', 'mailserver settings', 8);
    86 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level) VALUES(39,'mailserver_login', 3, 'login@example.com', 'mailserver settings', 8);
    87 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level) VALUES(40,'mailserver_pass', 3, 'password', 'mailserver settings', 8);
    88 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level) VALUES(41,'mailserver_port', 1, '110', 'mailserver settings', 8);
    89 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level) VALUES(42,'default_category', 1, '1', 'by default posts will have this category', 8);
    90 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level) VALUES(43,'subjectprefix', 3, 'blog:', 'subject prefix', 8);
    91 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level) VALUES(44,'bodyterminator', 3, '___', 'body terminator string (starting from this string, everything will be ignored, including this string)', 8);
    92 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level) VALUES(45,'emailtestonly', 2, '0', 'set this to true to run in test mode', 8);
    93 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level) 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);
    94 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level) VALUES(47,'phoneemail_separator', 3, ':::', 'when you compose your message, you\'ll type your subject then the separator string then you type your login:password, then the separator, then content', 8);
    95 
    96 --// original options from options page
    97 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level) VALUES(48,'posts_per_page', 1, '10','How many posts/days to show on the index page.', 4);
    98 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level) VALUES(49,'what_to_show', 5, 'posts','Posts, days, or posts paged', 4);
    99 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level) VALUES(50,'archive_mode', 5, 'monthly','Which \'unit\' to use for archives.', 4);
    100 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level) VALUES(51,'time_difference', 6, '0', 'if you\'re not on the timezone of your server', 4);
    101 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level) VALUES(52,'date_format', 3, 'd/m/Y', 'see note for format characters', 4);
    102 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level) VALUES(53,'time_format', 3, 'g:i a', 'see note for format characters', 4);
     85INSERT INTO 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);
     86INSERT INTO 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);
     87INSERT INTO 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);
     88INSERT INTO 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);
     89INSERT INTO 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);
     90INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(43,'subjectprefix', 3, 'blog:', 'subject prefix', 8, 20);
     91INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(44,'bodyterminator', 3, '___', 'body terminator string (starting from this string, everything will be ignored, including this string)', 8, 20);
     92INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(45,'emailtestonly', 2, '0', 'set this to true to run in test mode', 8, 20);
     93INSERT INTO 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);
     94INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(47,'phoneemail_separator', 3, ':::', 'when you compose your message, you\'ll type your subject then the separator string then you type your login:password, then the separator, then content', 8, 20);
     95                                                                                                                           
     96--// original options from options page                                                                                     
     97INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(48,'posts_per_page', 1, '20','How many posts/days to show on the index page.', 4);
     98INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(49,'what_to_show', 5, 'posts','Posts, days, or posts paged', 4);
     99INSERT INTO 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);
     100INSERT INTO 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);
     101INSERT INTO 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);
     102INSERT INTO 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);
    103103
    104104
    … …  
    222222--// default_post_category sql_select "SELECT cat_id AS value, cat_name AS label FROM $tablecategories order by cat_name"
    223223
    224 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level) VALUES(55,'default_post_status',    5, 'publish', 'The default state of each new post', 8);
    225 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level) VALUES(56,'default_comment_status', 5, 'open', 'The default state of comments for each new post', 8);
    226 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level) VALUES(57,'default_ping_status',    5, 'open', 'The default ping state for each new post', 8);
    227 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level) VALUES(58,'default_pingback_flag',  5, '1', 'Whether the \'PingBack the URLs in this post\' checkbox should be checked by default', 8);
    228 INSERT INTO options (option_id, option_name, option_type, option_value, option_description, option_admin_level) VALUES(59,'default_post_category',  7, '1', 'The default category for each new post', 8);
     224INSERT INTO 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);
     225INSERT INTO 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);
     226INSERT INTO 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);
     227INSERT INTO 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);
     228INSERT INTO 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);
    229229
    230230INSERT INTO optiongroups (group_id,  group_name, group_desc) VALUES(7, 'Default post options', 'Default settings for new posts.');
    … …  
    254254-- sql select data for default
    255255INSERT INTO optionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (59, 'SELECT cat_id AS value, cat_name AS label FROM $tablecategories order by cat_name', '', null,null,1);
     256
     257
     258
     259-----------
     260-- upgrade to delete tablesettings after granbbing values.

  • trunk/wp-admin/wp-install.php

    r224 r230  
    11<?php
     2$_wp_installing = 1;
    23require_once('../wp-config.php');
    34
    … …  
    252253
    253254<?php
    254 // $query = "DROP TABLE IF EXISTS $tablesettings";
    255 // $q = mysql_query($query) or mysql_doh("doh, can't drop the table \"$tablesettings\" in the database.");
    256 
    257 $query = "
    258 CREATE TABLE $tablesettings (
    259   ID tinyint(3) NOT NULL default '1',
    260   posts_per_page int(4) unsigned NOT NULL default '7',
    261   what_to_show varchar(5) NOT NULL default 'days',
    262   archive_mode varchar(10) NOT NULL default 'weekly',
    263   time_difference tinyint(4) NOT NULL default '0',
    264   AutoBR tinyint(1) NOT NULL default '1',
    265   time_format varchar(20) NOT NULL default 'H:i:s',
    266   date_format varchar(20) NOT NULL default 'd.m.y',
    267   PRIMARY KEY  (ID)
    268 )
    269 ";
    270 $q = $wpdb->query($query);
    271 
    272 $query = "INSERT INTO $tablesettings ( ID, posts_per_page, what_to_show, archive_mode, time_difference, AutoBR, time_format, date_format) VALUES ( '1', '20', 'posts', 'monthly', '0', '1', 'g:i a', 'n/j/Y')";
    273 $q = $wpdb->query($query);
    274 ?>
    275 
    276 <p>Settings are okay.</p>
    277 
    278 <?php
     255// $query = "DROP TABLE IF EXISTS $tableoptions";
     256// $q = mysql_query($query) or mysql_doh("doh, can't drop the table \"$tableoptions\" in the database.");
     257
     258$query = "
     259CREATE TABLE $tableoptions (
     260  option_id int(11) NOT NULL auto_increment,
     261  option_name varchar(64) UNIQUE NOT NULL default '',
     262  option_type int(11) NOT NULL default 1,
     263  option_value varchar(255) NOT NULL default '',
     264  option_width int NOT NULL default 20,
     265  option_height int NOT NULL default 8,
     266  option_description tinytext NOT NULL default '',
     267  option_admin_level int NOT NULL DEFAULT '1',
     268  PRIMARY KEY (option_id)
     269)
     270";
     271$q = $wpdb->query($query);
     272
     273// $query = "DROP TABLE IF EXISTS $tableoptiontypes";
     274// $q = mysql_query($query) or mysql_doh("doh, can't drop the table \"$tableoptiontypes\" in the database.");
     275
     276$query = "
     277CREATE TABLE $tableoptiontypes (
     278  optiontype_id int(11) NOT NULL auto_increment,
     279  optiontype_name varchar(64) NOT NULL,
     280  PRIMARY KEY (optiontype_id)
     281)
     282";
     283$q = $wpdb->query($query);
     284
     285
     286// $query = "DROP TABLE IF EXISTS $tableoptiongroups";
     287// $q = mysql_query($query) or mysql_doh("doh, can't drop the table \"$tableoptiongroups\" in the database.");
     288
     289$query = "
     290CREATE TABLE $tableoptiongroups (
     291  group_id int(11) NOT NULL auto_increment,
     292  group_name varchar(64) not null,
     293  group_desc varchar(255),
     294  group_longdesc tinytext,
     295  PRIMARY KEY (group_id)
     296)
     297";
     298$q = $wpdb->query($query);
     299
     300
     301// $query = "DROP TABLE IF EXISTS $tableoptiongroup_options";
     302// $q = mysql_query($query) or mysql_doh("doh, can't drop the table \"$tableoptiongroup_options\" in the database.");
     303
     304$query = "
     305CREATE TABLE $tableoptiongroup_options (
     306  group_id int(11) NOT NULL,
     307  option_id int(11) NOT NULL,
     308  seq int(11) NOT NULL,
     309  PRIMARY KEY (group_id, option_id)
     310)
     311";
     312$q = $wpdb->query($query);
     313
     314
     315// $query = "DROP TABLE IF EXISTS $tableoptionvalues";
     316// $q = mysql_query($query) or mysql_doh("doh, can't drop the table \"$tableoptionvalues\" in the database.");
     317
     318$query = "
     319CREATE TABLE $tableoptionvalues (
     320  option_id int(11) NOT NULL,
     321  optionvalue tinytext,
     322  optionvalue_desc varchar(255),
     323  optionvalue_max int(11),
     324  optionvalue_min int(11),
     325  optionvalue_seq int(11),
     326  KEY (option_id),
     327  INDEX (option_id, optionvalue_seq)
     328)
     329";
     330$q = $wpdb->query($query);
     331
     332?>
     333
     334<p>Option Tables created okay.</p>
     335
     336<?php
     337
     338$option_data = array(
     339"INSERT INTO $tableoptiontypes (optiontype_id, optiontype_name) VALUES (1, 'integer')",
     340"INSERT INTO $tableoptiontypes (optiontype_id, optiontype_name) VALUES (2, 'boolean')",
     341"INSERT INTO $tableoptiontypes (optiontype_id, optiontype_name) VALUES (3, 'string')",
     342"INSERT INTO $tableoptiontypes (optiontype_id, optiontype_name) VALUES (4, 'date')",
     343"INSERT INTO $tableoptiontypes (optiontype_id, optiontype_name) VALUES (5, 'select')",
     344"INSERT INTO $tableoptiontypes (optiontype_id, optiontype_name) VALUES (6, 'range')",
     345"INSERT INTO $tableoptiontypes (optiontype_id, optiontype_name) VALUES (7, 'sqlselect')",
     346//base options from b2cofig
     347"INSERT INTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(1,'siteurl', 3, 'http://mydomain.com', 'siteurl is your blog\'s URL: for example, \'http://mydomain.com/wordpress\' (no trailing slash !)', 8, 30)",
     348"INSERT INTO $tableoptions (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 $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(3,'blogname', 3, 'my weblog', 'blogname is the name of your blog', 8, 20)",
     350"INSERT INTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(4,'blogdescription', 3, 'babblings!', 'blogdescription is the description of your blog', 8, 40)",
     351"INSERT INTO $tableoptions (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 $tableoptions (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 $tableoptions (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 $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(54,'admin_email', 3, 'you@example.com', 'Your email (obvious eh?)', 8, 20)",
     355// general blog setup
     356"INSERT INTO $tableoptions (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)",
     357"INSERT INTO $tableoptions (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)",
     358"INSERT INTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(11,'use_bbcode', 2, '0', 'use BBCode, like [b]bold[/b]', 8, 20)",
     359"INSERT INTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(12,'use_gmcode', 2, '0', 'use GreyMatter-styles: **bold** \\\\italic\\\\ __underline__', 8, 20)",
     360"INSERT INTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(13,'use_quicktags', 2, '1', 'buttons for HTML tags (they won\'t work on IE Mac yet)', 8, 20)",
     361"INSERT INTO $tableoptions (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)",
     362"INSERT INTO $tableoptions (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)",
     363"INSERT INTO $tableoptions (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)",
     364"INSERT INTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(17,'smilies_directory', 3, 'http://mydomain.com/b2-img/smilies', 'the directory where your smilies are (no trailing slash)', 8, 40)",
     365"INSERT INTO $tableoptions (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)",
     366"INSERT INTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(19,'comment_allowed_tags', 3, '<b><i><strong><em><code><blockquote><p><br><strike><a>', 'here is a list of the tags that are allowed in the comments. You can add tags to the list, just add them in the string, add only the opening tag: for example, only \'&lt;a>\' instead of \'&lt;a href=\"\">&lt;/a>\'', 8, 40)",
     367"INSERT INTO $tableoptions (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)",
     368//rss/rdf feeds
     369"INSERT INTO $tableoptions (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)",
     370"INSERT INTO $tableoptions (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)",
     371"INSERT INTO $tableoptions (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)",
     372"INSERT INTO $tableoptions (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)",
     373"INSERT INTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(25,'rss_use_excerpt', 2, '1', 'use the excerpt field for rss feed.', 8, 20)",
     374"INSERT INTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(26,'use_weblogsping', 2, '0', 'set this to true if you want your site to be listed on http://weblogs.com when you add a new post', 8, 20)",
     375"INSERT INTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(27,'use_blodotgsping', 2, '0', 'set this to true if you want your site to be listed on http://blo.gs when you add a new post', 8, 20)",
     376"INSERT INTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(28,'blodotgsping_url', 3, 'http://mydomain.com', 'You shouldn\'t need to change this.', 8, 30)",
     377"INSERT INTO $tableoptions (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)",
     378"INSERT INTO $tableoptions (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)",
     379//file upload
     380"INSERT INTO $tableoptions (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)",
     381"INSERT INTO $tableoptions (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)",
     382"INSERT INTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(33,'fileupload_url', 3, 'http://mydomain.com/images', 'enter the URL of that directory (it\'s used to generate the links to the uploded files)', 8, 40)",
     383"INSERT INTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(34,'fileupload_allowedtypes', 3, ' jpg gif png ', 'accepted file types, you can add to that list if you want. note: add a space before and after each file type. example: \' jpg gif png \'', 8, 20)",
     384"INSERT INTO $tableoptions (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)",
     385"INSERT INTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(36,'fileupload_minlevel', 1, '1', 'you may not want all users to upload pictures/files, so you can set a minimum level for this', 8, 20)",
     386"INSERT INTO $tableoptions (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 that variable blank, all users who have the minimum level are authorized to upload note: add a space before and after each login name example: \' barbara anne \'', 8, 30)",
     387// email settings
     388"INSERT INTO $tableoptions (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)",
     389"INSERT INTO $tableoptions (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)",
     390"INSERT INTO $tableoptions (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)",
     391"INSERT INTO $tableoptions (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)",
     392"INSERT INTO $tableoptions (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)",
     393"INSERT INTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(43,'subjectprefix', 3, 'blog:', 'subject prefix', 8, 20)",
     394"INSERT INTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(44,'bodyterminator', 3, '___', 'body terminator string (starting from this string, everything will be ignored, including this string)', 8, 20)",
     395"INSERT INTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(45,'emailtestonly', 2, '0', 'set this to true to run in test mode', 8, 20)",
     396"INSERT INTO $tableoptions (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)",
     397"INSERT INTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(47,'phoneemail_separator', 3, ':::', 'when you compose your message, you\'ll type your subject then the separator string then you type your login:password, then the separator, then content', 8, 20)",
     398// original options from options page
     399"INSERT INTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(48,'posts_per_page', 1, '20','How many posts/days to show on the index page.', 4, 20)",
     400"INSERT INTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(49,'what_to_show', 5, 'posts','Posts, days, or posts paged', 4, 20)",
     401"INSERT INTO $tableoptions (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)",
     402"INSERT INTO $tableoptions (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)",
     403"INSERT INTO $tableoptions (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)",
     404"INSERT INTO $tableoptions (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)",
     405
     406//'pages' of options
     407"INSERT INTO $tableoptiongroups (group_id,  group_name, group_desc) VALUES(1, 'Other Options', 'Posts per page etc. Original options page')",
     408"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(1,48,1 )",
     409"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(1,49,2 )",
     410"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(1,50,3 )",
     411"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(1,51,4 )",
     412"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(1,52,5 )",
     413"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(1,53,6 )",
     414
     415"INSERT INTO $tableoptiongroups (group_id,  group_name, group_desc) VALUES(2, 'General blog settings', 'Things you\'ll probably want to tweak')",
     416"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,9 ,1 )",
     417"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,10,2 )",
     418"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,11,3 )",
     419"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,12,4 )",
     420"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,13,5 )",
     421"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,14,6 )",
     422"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,15,7 )",
     423"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,16,8 )",
     424"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,17,9 )",
     425"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,18,10)",
     426"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,19,11)",
     427"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,20,12)",
     428
     429"INSERT INTO $tableoptiongroups (group_id,  group_name, group_desc) VALUES(3, 'RSS/RDF Feeds, Track/Ping-backs', 'Settings for RSS/RDF Feeds, Track/ping-backs')",
     430"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(3,21,1 )",
     431"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(3,22,2 )",
     432"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(3,23,3 )",
     433"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(3,24,4 )",
     434"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(3,25,5 )",
     435"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(3,26,6 )",
     436"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(3,27,7 )",
     437"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(3,28,8 )",
     438"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(3,29,9 )",
     439"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(3,30,10)",
     440
     441"INSERT INTO $tableoptiongroups (group_id,  group_name, group_desc) VALUES(4, 'File uploads', 'Settings for file uploads')",
     442"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(4,31,1 )",
     443"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(4,32,2 )",
     444"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(4,33,3 )",
     445"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(4,34,4 )",
     446"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(4,35,5 )",
     447"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(4,36,6 )",
     448"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(4,37,7 )",
     449
     450"INSERT INTO $tableoptiongroups (group_id,  group_name, group_desc) VALUES(5, 'Blog-by-Email settings', 'Settings for blogging via email')",
     451"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(5,38,1 )",
     452"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(5,39,2 )",
     453"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(5,40,3 )",
     454"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(5,41,4 )",
     455"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(5,42,5 )",
     456"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(5,43,6 )",
     457"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(5,44,7 )",
     458"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(5,45,8 )",
     459"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(5,46,9 )",
     460"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(5,47,10)",
     461
     462"INSERT INTO $tableoptiongroups (group_id,  group_name, group_desc) VALUES(6, 'Base settings', 'Basic settings required to get your blog working')",
     463"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(6,1,1)",
     464"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(6,2,2)",
     465"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(6,3,3)",
     466"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(6,4,4)",
     467"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(6,6,5)",
     468"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(6,7,6)",
     469"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(6,8,7)",
     470"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(6,54,8)",
     471
     472// select data for what to show
     473"INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (49, 'days',  'days',        null,null,1)",
     474"INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (49, 'posts', 'posts',       null,null,2)",
     475"INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (49, 'paged', 'posts paged', null,null,3)",
     476// select data for archive mode
     477"INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (50, 'daily',     'daily',       null,null,1)",
     478"INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (50, 'weekly',    'weekly',      null,null,2)",
     479"INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (50, 'monthly',   'monthly',     null,null,3)",
     480"INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (50, 'postbypost','post by post',null,null,4)",
     481// select data for time diff
     482"INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (51, null, null, 13, 0, null)",
     483// select data for start of week
     484"INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (9, '0', 'Sunday',   null,null,1)",
     485"INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (9, '1', 'Monday',   null,null,2)",
     486"INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (9, '6', 'Saturday', null,null,3)",
     487
     488
     489// Add in a new page for POST DEFAULTS
     490
     491// default_post_status  select one of publish draft private
     492// default_comment_status select one of open closed
     493// default_ping_status select one of open closed
     494// default_pingback_flag select one of checked unchecked
     495// default_post_category sql_select "SELECT cat_id AS value, cat_name AS label FROM $tablecategories order by cat_name"
     496
     497"INSERT INTO $tableoptions (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)",
     498"INSERT INTO $tableoptions (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)",
     499"INSERT INTO $tableoptions (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)",
     500"INSERT INTO $tableoptions (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)",
     501"INSERT INTO $tableoptions (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)",
     502
     503"INSERT INTO $tableoptiongroups (group_id,  group_name, group_desc) VALUES(7, 'Default post options', 'Default settings for new posts.')",
     504"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(7,55,1 )",
     505"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(7,56,2 )",
     506"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(7,57,3 )",
     507"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(7,58,4 )",
     508"INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(7,59,5 )",
     509
     510// select data for post_status
     511"INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (55, 'publish', 'Publish', null,null,1)",
     512"INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (55, 'draft',   'Draft',   null,null,2)",
     513"INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (55, 'private', 'Private', null,null,3)",
     514
     515// select data for comment_status
     516"INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (56, 'open', 'Open',   null,null,1)",
     517"INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (56, 'closed', 'Closed', null,null,2)",
     518
     519// select data for ping_status (aargh duplication!)
     520"INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (57, 'open', 'Open',   null,null,1)",
     521"INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (57, 'closed', 'Closed', null,null,2)",
     522
     523// select data for pingback flag
     524"INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (58, '1', 'Checked',   null,null,1)",
     525"INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (58, '0', 'Unchecked', null,null,2)",
     526
     527// sql select data for default
     528"INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (59, 'SELECT cat_id AS value, cat_name AS label FROM $tablecategories order by cat_name', '', null,null,1)",
     529);
     530
     531foreach ($option_data as $query) {
     532    $q = $wpdb->query($query);
     533}
     534?>
     535
     536<p>Option Data inserted okay.</p>
     537
     538<p>OK. We're nearly done now. We just need to ask you a couple of things:</p>
     539<form action="wp-install.php?step=3" method="post">
     540<input type="hidden" name="step" value="3" />
     541What is the url for your blog? <input type="text" name="url" length="50" />.
     542OK on to <input type="submit" value="Step 3" >
     543</form>
     544
     545<?php
     546    break;
     547    case 3:
     548?>
     549<h1>Step 3</h1>
     550
     551
     552<?php
     553$url = $HTTP_POST_VARS['url'];
     554if (isset($url)) {
     555    $query= "UPDATE $tableoptions set option_value='$url' where option_id=1"; //siteurl
     556    $q = $wpdb->query($query);
     557    $query= "UPDATE $tableoptions set option_value='$url' where option_id=28"; //blodotgsping_url
     558    $q = $wpdb->query($query);
     559    $query= "UPDATE $tableoptions set option_value='$url' where option_id=17"; //smilies_directory
     560    $q = $wpdb->query($query);
     561}
     562   
    279563// $query = "DROP TABLE IF EXISTS $tableusers";
    280564// $q = mysql_query($query) or mysql_doh("doh, can't drop the table \"$tableusers\" in the database.");

  • trunk/wp-settings.php

    r215 r230  
    55// get_settings() wherever these are needed OR
    66// accessing a single global $all_settings var
     7if (!$_wp_installing) {
     8    $siteurl = get_settings('siteurl');
     9    $blogfilename = get_settings('blogfilename');
     10    $blogname = get_settings('blogname');
     11    $blogdescription = get_settings('blogdescription');
     12    $admin_email = get_settings('admin_email');
     13    $new_users_can_blog = get_settings('new_users_can_blog');
     14    $users_can_register = get_settings('users_can_register');
     15    $start_of_week = get_settings('start_of_week');
     16    $use_preview = get_settings('use_preview');
     17    $use_bbcode = get_settings('use_bbcode');
     18    $use_gmcode = get_settings('use_gmcode');
     19    $use_quicktags = get_settings('use_quicktags');
     20    $use_htmltrans = get_settings('use_htmltrans');
     21    $use_balanceTags = get_settings('use_balanceTags');
     22    $use_fileupload = get_settings('use_fileupload');
     23    $fileupload_realpath = get_settings('fileupload_realpath');
     24    $fileupload_url = get_settings('fileupload_url');
     25    $fileupload_allowedtypes = get_settings('fileupload_allowedtypes');
     26    $fileupload_maxk = get_settings('fileupload_maxk');
     27    $fileupload_minlevel = get_settings('fileupload_minlevel');
     28    $fileupload_allowedusers = get_settings('fileupload_allowedusers');
     29    $posts_per_rss = get_settings('posts_per_rss');
     30    $rss_language = get_settings('rss_language');
     31    $rss_encoded_html = get_settings('rss_encoded_html');
     32    $rss_excerpt_length = get_settings('rss_excerpt_length');
     33    $rss_use_excerpt = get_settings('rss_use_excerpt');
     34    $use_weblogsping = get_settings('use_weblogsping');
     35    $use_blodotgsping = get_settings('use_blodotgsping');
     36    $blodotgsping_url = get_settings('blodotgsping_url');
     37    $use_trackback = get_settings('use_trackback');
     38    $use_pingback = get_settings('use_pingback');
     39    $require_name_email = get_settings('require_name_email');
     40    $comment_allowed_tags = get_settings('comment_allowed_tags');
     41    $comments_notify = get_settings('comments_notify');
     42    $use_smilies = get_settings('use_smilies');
     43    $smilies_directory = get_settings('smilies_directory');
     44    $mailserver_url = get_settings('mailserver_url');
     45    $mailserver_login = get_settings('mailserver_login');
     46    $mailserver_pass = get_settings('mailserver_pass');
     47    $mailserver_port = get_settings('mailserver_port');
     48    $default_category = get_settings('default_category');
     49    $subjectprefix = get_settings('subjectprefix');
     50    $bodyterminator = get_settings('bodyterminator');
     51    $emailtestonly = get_settings('emailtestonly');
     52    $use_phoneemail = get_settings('use_phoneemail');
     53    $phoneemail_separator = get_settings('phoneemail_separator');
    754
    8 $siteurl = get_settings('siteurl');
    9 $blogfilename = get_settings('blogfilename');
    10 $blogname = get_settings('blogname');
    11 $blogdescription = get_settings('blogdescription');
    12 $admin_email = get_settings('admin_email');
    13 $new_users_can_blog = get_settings('new_users_can_blog');
    14 $users_can_register = get_settings('users_can_register');
    15 $start_of_week = get_settings('start_of_week');
    16 $use_preview = get_settings('use_preview');
    17 $use_bbcode = get_settings('use_bbcode');
    18 $use_gmcode = get_settings('use_gmcode');
    19 $use_quicktags = get_settings('use_quicktags');
    20 $use_htmltrans = get_settings('use_htmltrans');
    21 $use_balanceTags = get_settings('use_balanceTags');
    22 $use_fileupload = get_settings('use_fileupload');
    23 $fileupload_realpath = get_settings('fileupload_realpath');
    24 $fileupload_url = get_settings('fileupload_url');
    25 $fileupload_allowedtypes = get_settings('fileupload_allowedtypes');
    26 $fileupload_maxk = get_settings('fileupload_maxk');
    27 $fileupload_minlevel = get_settings('fileupload_minlevel');
    28 $fileupload_allowedusers = get_settings('fileupload_allowedusers');
    29 $posts_per_rss = get_settings('posts_per_rss');
    30 $rss_language = get_settings('rss_language');
    31 $rss_encoded_html = get_settings('rss_encoded_html');
    32 $rss_excerpt_length = get_settings('rss_excerpt_length');
    33 $rss_use_excerpt = get_settings('rss_use_excerpt');
    34 $use_weblogsping = get_settings('use_weblogsping');
    35 $use_blodotgsping = get_settings('use_blodotgsping');
    36 $blodotgsping_url = get_settings('blodotgsping_url');
    37 $use_trackback = get_settings('use_trackback');
    38 $use_pingback = get_settings('use_pingback');
    39 $require_name_email = get_settings('require_name_email');
    40 $comment_allowed_tags = get_settings('comment_allowed_tags');
    41 $comments_notify = get_settings('comments_notify');
    42 $use_smilies = get_settings('use_smilies');
    43 $smilies_directory = get_settings('smilies_directory');
    44 $mailserver_url = get_settings('mailserver_url');
    45 $mailserver_login = get_settings('mailserver_login');
    46 $mailserver_pass = get_settings('mailserver_pass');
    47 $mailserver_port = get_settings('mailserver_port');
    48 $default_category = get_settings('default_category');
    49 $subjectprefix = get_settings('subjectprefix');
    50 $bodyterminator = get_settings('bodyterminator');
    51 $emailtestonly = get_settings('emailtestonly');
    52 $use_phoneemail = get_settings('use_phoneemail');
    53 $phoneemail_separator = get_settings('phoneemail_separator');
    54 
    55 if (get_settings('search_engine_friendly_urls')) {
    56     $querystring_start = '/';
    57     $querystring_equal = '/';
    58     $querystring_separator = '/';
    59 } else {
    60     $querystring_start = '?';
    61     $querystring_equal = '=';
    62     $querystring_separator = '&amp;';
    63 }
     55    if (get_settings('search_engine_friendly_urls')) {
     56        $querystring_start = '/';
     57        $querystring_equal = '/';
     58        $querystring_separator = '/';
     59    } else {
     60        $querystring_start = '?';
     61        $querystring_equal = '=';
     62        $querystring_separator = '&amp;';
     63    }
     64} //end !$_wp_installing
    6465?>
Note: See TracChangeset for help on using the changeset viewer.