Changeset 290
- Timestamp:
- 08/03/2003 11:46:20 PM (21 years ago)
- Location:
- trunk/wp-admin
- Files:
-
- 6 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/wp-admin/b2-2-wp.php
r265 r290 69 69 <p>Okay first we’re going to set up the links database. This will allow you to host your own blogroll, complete with Weblogs.com updates.</p> 70 70 <?php 71 require_once('../wp-links/links.config.php');72 71 73 72 $got_links = false; -
trunk/wp-admin/linkcategories.php
r280 r290 28 28 // ***************************************************************** 29 29 30 include_once('../wp-links/links.config.php');31 30 include_once('../wp-links/links.php'); 32 31 … … 55 54 include_once("./b2header.php"); 56 55 57 if ($user_level < $minadminlevel)56 if ($user_level < get_settings('links_minadminlevel')) 58 57 die ("Cheatin' uh ?"); 59 58 … … 119 118 die("Can't delete the <b>$cat_name</b> link category: this is the default one"); 120 119 121 if ($user_level < $minadminlevel)120 if ($user_level < get_settings('links_minadminlevel')) 122 121 die ("Cheatin' uh ?"); 123 122 … … 214 213 include_once("./b2header.php"); 215 214 216 if ($user_level < $minadminlevel)215 if ($user_level < get_settings('links_minadminlevel')) 217 216 die ("Cheatin' uh ?"); 218 217 … … 286 285 $standalone=0; 287 286 include_once ("./b2header.php"); 288 if ($user_level < $minadminlevel) {287 if ($user_level < get_settings('links_minadminlevel')) { 289 288 die("You have no right to edit the link categories for this blog.<br>Ask for a promotion to your <a href=\"mailto:$admin_email\">blog admin</a> :)"); 290 289 } -
trunk/wp-admin/linkmanager.php
r280 r290 28 28 // ***************************************************************** 29 29 require_once('../wp-config.php'); 30 require_once('../wp-links/links.config.php');31 30 require_once("../wp-links/links.php"); 32 31 … … 99 98 100 99 // check the current user's level first. 101 if ($user_level < $minadminlevel)100 if ($user_level < get_settings('links_minadminlevel')) 102 101 die ("Cheatin' uh ?"); 103 102 … … 112 111 $results = $wpdb->get_results("SELECT link_id, link_owner, user_level FROM $tablelinks LEFT JOIN $tableusers ON link_owner = ID WHERE link_id in ($all_links)"); 113 112 foreach ($results as $row) { 114 if (! $use_adminlevels|| ($user_level >= $row->user_level)) { // ok to proceed113 if (!get_settings('links_use_adminlevels') || ($user_level >= $row->user_level)) { // ok to proceed 115 114 $ids_to_change[] = $row->link_id; 116 115 } … … 130 129 131 130 // check the current user's level first. 132 if ($user_level < $minadminlevel)131 if ($user_level < get_settings('links_minadminlevel')) 133 132 die ("Cheatin' uh ?"); 134 133 … … 167 166 include_once('b2header.php'); 168 167 // check the current user's level first. 169 if ($user_level < $minadminlevel)168 if ($user_level < get_settings('links_minadminlevel')) 170 169 die ("Cheatin' uh ?"); 171 170 … … 200 199 $auto_toggle = get_autotoggle($link_category); 201 200 202 if ($user_level < $minadminlevel)201 if ($user_level < get_settings('links_minadminlevel')) 203 202 die ("Cheatin' uh ?"); 204 203 … … 247 246 $auto_toggle = get_autotoggle($link_category); 248 247 249 if ($user_level < $minadminlevel)248 if ($user_level < get_settings('links_minadminlevel')) 250 249 die ("Cheatin' uh ?"); 251 250 … … 277 276 $link_id = $HTTP_POST_VARS["link_id"]; 278 277 279 if ($user_level < $minadminlevel)278 if ($user_level < get_settings('links_minadminlevel')) 280 279 die ("Cheatin' uh ?"); 281 280 … … 299 298 $standalone=0; 300 299 include_once ('b2header.php'); 301 if ($user_level < $minadminlevel) {300 if ($user_level < get_settings('links_minadminlevel')) { 302 301 die("You have no right to edit the links for this blog.<br />Ask for a promotion to your <a href=\"mailto:$admin_email\">blog admin</a>. :)"); 303 302 } … … 447 446 $standalone=0; 448 447 include_once ("./b2header.php"); 449 if ($user_level < $minadminlevel) {448 if ($user_level < get_settings('links_minadminlevel')) { 450 449 die("You have no right to edit the links for this blog.<br>Ask for a promotion to your <a href=\"mailto:$admin_email\">blog admin</a> :)"); 451 450 } … … 599 598 $show_buttons = 1; // default 600 599 601 if ( $use_adminlevels&& ($link->user_level > $user_level)) {600 if (get_settings('links_use_adminlevels') && ($link->user_level > $user_level)) { 602 601 $show_buttons = 0; 603 602 } -
trunk/wp-admin/links.import.php
r212 r290 28 28 // ***************************************************************** 29 29 require_once('../wp-config.php'); 30 include_once('../wp-links/links.config.php');31 30 include_once("../wp-links/links.php"); 32 31 … … 42 41 $standalone = 0; 43 42 include_once('b2header.php'); 44 if ($user_level < $minadminlevel)43 if ($user_level < get_settings('links_minadminlevel')) 45 44 die ("Cheatin’ uh?"); 46 45 ?> … … 86 85 $standalone = 0; 87 86 include_once('b2header.php'); 88 if ($user_level < $minadminlevel)87 if ($user_level < get_settings('links_minadminlevel')) 89 88 die ("Cheatin' uh ?"); 90 89 ?> -
trunk/wp-admin/upgrade-071-to-072.php
r280 r290 83 83 maybe_add_column($tablename, 'link_notes', $ddl); 84 84 if (check_column($tablename, 'link_notes', 'mediumtext')) { 85 $res .= $tablename . ' - ok <br />' ;86 } else { 87 $res .= 'There was a problem with ' . $tablename . '<br />' ;85 $res .= $tablename . ' - ok <br />'."\n"; 86 } else { 87 $res .= 'There was a problem with ' . $tablename . '<br />'."\n"; 88 88 ++$error_count; 89 89 } … … 93 93 maybe_add_column($tablename, 'show_images', $ddl); 94 94 if (check_column($tablename, 'show_images', "enum('Y','N')")) { 95 $res .= $tablename . ' - ok <br />' ;96 } else { 97 $res .= 'There was a problem with ' . $tablename . '<br />' ;95 $res .= $tablename . ' - ok <br />'."\n"; 96 } else { 97 $res .= 'There was a problem with ' . $tablename . '<br />'."\n"; 98 98 ++$error_count; 99 99 } … … 103 103 maybe_add_column($tablename, 'show_description', $ddl); 104 104 if (check_column($tablename, 'show_description', "enum('Y','N')")) { 105 $res .= $tablename . ' - ok <br />' ;106 } else { 107 $res .= 'There was a problem with ' . $tablename . '<br />' ;105 $res .= $tablename . ' - ok <br />'."\n"; 106 } else { 107 $res .= 'There was a problem with ' . $tablename . '<br />'."\n"; 108 108 ++$error_count; 109 109 } … … 113 113 maybe_add_column($tablename, 'show_rating', $ddl); 114 114 if (check_column($tablename, 'show_rating', "enum('Y','N')")) { 115 $res .= $tablename . ' - ok <br />' ;116 } else { 117 $res .= 'There was a problem with ' . $tablename . '<br />' ;115 $res .= $tablename . ' - ok <br />'."\n"; 116 } else { 117 $res .= 'There was a problem with ' . $tablename . '<br />'."\n"; 118 118 ++$error_count; 119 119 } … … 123 123 maybe_add_column($tablename, 'show_updated', $ddl); 124 124 if (check_column($tablename, 'show_updated', "enum('Y','N')")) { 125 $res .= $tablename . ' - ok <br />' ;126 } else { 127 $res .= 'There was a problem with ' . $tablename . '<br />' ;125 $res .= $tablename . ' - ok <br />'."\n"; 126 } else { 127 $res .= 'There was a problem with ' . $tablename . '<br />'."\n"; 128 128 ++$error_count; 129 129 } … … 133 133 maybe_add_column($tablename, 'sort_order', $ddl); 134 134 if (check_column($tablename, 'sort_order', "varchar(64)")) { 135 $res .= $tablename . ' - ok <br />' ;136 } else { 137 $res .= 'There was a problem with ' . $tablename . '<br />' ;135 $res .= $tablename . ' - ok <br />'."\n"; 136 } else { 137 $res .= 'There was a problem with ' . $tablename . '<br />'."\n"; 138 138 ++$error_count; 139 139 } … … 142 142 $ddl = "ALTER TABLE $tablelinkcategories ADD COLUMN sort_desc enum('Y','N') NOT NULL default 'N'"; 143 143 maybe_add_column($tablename, 'sort_desc', $ddl); 144 if (check_column($tablename, 'sort_ Desc', "enum('Y','N')")) {145 $res .= $tablename . ' - ok <br />' ;146 } else { 147 $res .= ' There was a problem with ' . $tablename . '<br />';144 if (check_column($tablename, 'sort_desc', "enum('Y','N')")) { 145 $res .= $tablename . ' - ok <br />'."\n"; 146 } else { 147 $res .= 'AAA There was a problem with ' . $tablename . '<br />'."\n"; 148 148 ++$error_count; 149 149 } … … 153 153 maybe_add_column($tablename, 'text_before_link', $ddl); 154 154 if (check_column($tablename, 'text_before_link', 'varchar(128)')) { 155 $res .= $tablename . ' - ok <br />' ;156 } else { 157 $res .= 'There was a problem with ' . $tablename . '<br />' ;155 $res .= $tablename . ' - ok <br />'."\n"; 156 } else { 157 $res .= 'There was a problem with ' . $tablename . '<br />'."\n"; 158 158 ++$error_count; 159 159 } … … 163 163 maybe_add_column($tablename, 'text_after_link', $ddl); 164 164 if (check_column($tablename, 'text_after_link', 'varchar(128)')) { 165 $res .= $tablename . ' - ok <br />' ;166 } else { 167 $res .= 'There was a problem with ' . $tablename . '<br />' ;165 $res .= $tablename . ' - ok <br />'."\n"; 166 } else { 167 $res .= 'There was a problem with ' . $tablename . '<br />'."\n"; 168 168 ++$error_count; 169 169 } … … 173 173 maybe_add_column($tablename, 'text_after_all', $ddl); 174 174 if (check_column($tablename, 'text_after_all', 'varchar(128)')) { 175 $res .= $tablename . ' - ok <br />' ;176 } else { 177 $res .= 'There was a problem with ' . $tablename . '<br />' ;175 $res .= $tablename . ' - ok <br />'."\n"; 176 } else { 177 $res .= 'There was a problem with ' . $tablename . '<br />'."\n"; 178 178 ++$error_count; 179 179 } … … 183 183 maybe_add_column($tablename, 'list_limit', $ddl); 184 184 if (check_column($tablename, 'list_limit', 'int(11)')) { 185 $res .= $tablename . ' - ok <br />' ;186 } else { 187 $res .= 'There was a problem with ' . $tablename . '<br />' ;185 $res .= $tablename . ' - ok <br />'."\n"; 186 } else { 187 $res .= 'There was a problem with ' . $tablename . '<br />'."\n"; 188 188 ++$error_count; 189 189 } 190 190 191 191 if ($error_count > 0) { 192 echo("<p>$res</p>"); 192 193 ?> 193 194 <p>Hmmm... there was some kind of error. If you cannot figure out … … 227 228 228 229 if (maybe_create_table($tablename, $ddl) == true) { 229 $res .= $tablename . ' - ok <br />' ;230 } else { 231 $res .= 'There was a problem with ' . $tablename . '<br />' ;230 $res .= $tablename . ' - ok <br />'."\n"; 231 } else { 232 $res .= 'There was a problem with ' . $tablename . '<br />'."\n"; 232 233 ++$error_count; 233 234 } … … 243 244 244 245 if (maybe_create_table($tablename, $ddl) == true) { 245 $res .= $tablename . ' - ok <br />' ;246 } else { 247 $res .= 'There was a problem with ' . $tablename . '<br />' ;246 $res .= $tablename . ' - ok <br />'."\n"; 247 } else { 248 $res .= 'There was a problem with ' . $tablename . '<br />'."\n"; 248 249 ++$error_count; 249 250 } … … 261 262 262 263 if (maybe_create_table($tablename, $ddl) == true) { 263 $res .= $tablename . ' - ok <br />' ;264 } else { 265 $res .= 'There was a problem with ' . $tablename . '<br />' ;264 $res .= $tablename . ' - ok <br />'."\n"; 265 } else { 266 $res .= 'There was a problem with ' . $tablename . '<br />'."\n"; 266 267 ++$error_count; 267 268 } … … 278 279 279 280 if (maybe_create_table($tablename, $ddl) == true) { 280 $res .= $tablename . ' - ok <br />' ;281 } else { 282 $res .= 'There was a problem with ' . $tablename . '<br />' ;281 $res .= $tablename . ' - ok <br />'."\n"; 282 } else { 283 $res .= 'There was a problem with ' . $tablename . '<br />'."\n"; 283 284 ++$error_count; 284 285 } … … 299 300 300 301 if (maybe_create_table($tablename, $ddl) == true) { 301 $res .= $tablename . ' - ok <br />' ;302 } else { 303 $res .= 'There was a problem with ' . $tablename . '<br />' ;302 $res .= $tablename . ' - ok <br />'."\n"; 303 } else { 304 $res .= 'There was a problem with ' . $tablename . '<br />'."\n"; 304 305 ++$error_count; 305 306 } … … 324 325 325 326 $option_data = array( 326 " REPLACEINTO $tableoptiontypes (optiontype_id, optiontype_name) VALUES (1, 'integer')",327 " REPLACEINTO $tableoptiontypes (optiontype_id, optiontype_name) VALUES (2, 'boolean')",328 " REPLACEINTO $tableoptiontypes (optiontype_id, optiontype_name) VALUES (3, 'string')",329 " REPLACEINTO $tableoptiontypes (optiontype_id, optiontype_name) VALUES (4, 'date')",330 " REPLACEINTO $tableoptiontypes (optiontype_id, optiontype_name) VALUES (5, 'select')",331 " REPLACEINTO $tableoptiontypes (optiontype_id, optiontype_name) VALUES (6, 'range')",332 " REPLACEINTO $tableoptiontypes (optiontype_id, optiontype_name) VALUES (7, 'sqlselect')",327 "INSERT INTO $tableoptiontypes (optiontype_id, optiontype_name) VALUES (1, 'integer')", 328 "INSERT INTO $tableoptiontypes (optiontype_id, optiontype_name) VALUES (2, 'boolean')", 329 "INSERT INTO $tableoptiontypes (optiontype_id, optiontype_name) VALUES (3, 'string')", 330 "INSERT INTO $tableoptiontypes (optiontype_id, optiontype_name) VALUES (4, 'date')", 331 "INSERT INTO $tableoptiontypes (optiontype_id, optiontype_name) VALUES (5, 'select')", 332 "INSERT INTO $tableoptiontypes (optiontype_id, optiontype_name) VALUES (6, 'range')", 333 "INSERT INTO $tableoptiontypes (optiontype_id, optiontype_name) VALUES (7, 'sqlselect')", 333 334 //base options from b2cofig 334 " REPLACEINTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(1,'siteurl', 3, 'http://example.com', 'siteurl is your blog\'s URL: for example, \'http://example.com/wordpress\' (no trailing slash !)', 8, 30)",335 " REPLACEINTO $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)",336 " REPLACEINTO $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)",337 " REPLACEINTO $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)",338 " REPLACEINTO $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)",339 " REPLACEINTO $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)",340 " REPLACEINTO $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)",341 " REPLACEINTO $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)",335 "INSERT INTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(1,'siteurl', 3, 'http://example.com', 'siteurl is your blog\'s URL: for example, \'http://example.com/wordpress\' (no trailing slash !)', 8, 30)", 336 "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)", 337 "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)", 338 "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)", 339 "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)", 340 "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)", 341 "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)", 342 "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)", 342 343 // general blog setup 343 " REPLACEINTO $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)",344 " REPLACEINTO $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)",345 " REPLACEINTO $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)",346 " REPLACEINTO $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)",347 " REPLACEINTO $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)",348 " REPLACEINTO $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)",349 " REPLACEINTO $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)",350 " REPLACEINTO $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 true to enable smiley conversion in posts (note: this makes smiley conversion in ALL posts)', 8, 20)",351 " REPLACEINTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(17,'smilies_directory', 3, 'http://example.com/b2-img/smilies', 'the directory where your smilies are (no trailing slash)', 8, 40)",352 " REPLACEINTO $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)",353 " REPLACEINTO $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 \'<a>\' instead of \'<a href=\"\"></a>\'', 8, 40)",354 " REPLACEINTO $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)",344 "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)", 345 "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)", 346 "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)", 347 "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)", 348 "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)", 349 "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)", 350 "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)", 351 "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 true to enable smiley conversion in posts (note: this makes smiley conversion in ALL posts)', 8, 20)", 352 "INSERT INTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(17,'smilies_directory', 3, 'http://example.com/b2-img/smilies', 'the directory where your smilies are (no trailing slash)', 8, 40)", 353 "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)", 354 "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 \'<a>\' instead of \'<a href=\"\"></a>\'', 8, 40)", 355 "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)", 355 356 //rss/rdf feeds 356 " REPLACEINTO $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)",357 " REPLACEINTO $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)",358 " REPLACEINTO $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 <description> tag?', 8, 20)",359 " REPLACEINTO $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)",360 " REPLACEINTO $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)",361 " REPLACEINTO $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)",362 " REPLACEINTO $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)",363 " REPLACEINTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(28,'blodotgsping_url', 3, 'http://example.com', 'You shouldn\'t need to change this.', 8, 30)",364 " REPLACEINTO $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 false or true, whether you want to allow your posts to be trackback\'able or not note: setting it to false would also disable sending trackbacks', 8, 20)",365 " REPLACEINTO $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 false or true, whether you want to allow your posts to be pingback\'able or not note: setting it to false would also disable sending pingbacks', 8, 20)",357 "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)", 358 "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)", 359 "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 <description> tag?', 8, 20)", 360 "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)", 361 "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)", 362 "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)", 363 "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)", 364 "INSERT INTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(28,'blodotgsping_url', 3, 'http://example.com', 'You shouldn\'t need to change this.', 8, 30)", 365 "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 false or true, whether you want to allow your posts to be trackback\'able or not note: setting it to false would also disable sending trackbacks', 8, 20)", 366 "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 false or true, whether you want to allow your posts to be pingback\'able or not note: setting it to false would also disable sending pingbacks', 8, 20)", 366 367 //file upload 367 " REPLACEINTO $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)",368 " REPLACEINTO $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)",369 " REPLACEINTO $tableoptions (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)",370 " REPLACEINTO $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)",371 " REPLACEINTO $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)",372 " REPLACEINTO $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)",373 " REPLACEINTO $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)",368 "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)", 369 "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)", 370 "INSERT INTO $tableoptions (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)", 371 "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)", 372 "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)", 373 "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)", 374 "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)", 374 375 // email settings 375 " REPLACEINTO $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)",376 " REPLACEINTO $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)",377 " REPLACEINTO $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)",378 " REPLACEINTO $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)",379 " REPLACEINTO $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)",380 " REPLACEINTO $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)",381 " REPLACEINTO $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)",382 " REPLACEINTO $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)",383 " REPLACEINTO $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)",384 " REPLACEINTO $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)",376 "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)", 377 "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)", 378 "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)", 379 "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)", 380 "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)", 381 "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)", 382 "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)", 383 "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)", 384 "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)", 385 "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)", 385 386 // original options from options page 386 " REPLACEINTO $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)",387 " REPLACEINTO $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)",388 " REPLACEINTO $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)",389 " REPLACEINTO $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)",390 " REPLACEINTO $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)",391 " REPLACEINTO $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)",387 "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)", 388 "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)", 389 "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)", 390 "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)", 391 "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)", 392 "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)", 392 393 393 394 //'pages' of options 394 " REPLACEINTO $tableoptiongroups (group_id, group_name, group_desc) VALUES(1, 'Other Options', 'Posts per page etc. Original options page')",395 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(1,48,1 )",396 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(1,49,2 )",397 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(1,50,3 )",398 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(1,51,4 )",399 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(1,52,5 )",400 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(1,53,6 )",401 402 " REPLACEINTO $tableoptiongroups (group_id, group_name, group_desc) VALUES(2, 'General blog settings', 'Things you\'ll probably want to tweak')",403 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,9 ,1 )",404 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,10,2 )",405 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,11,3 )",406 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,12,4 )",407 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,13,5 )",408 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,14,6 )",409 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,15,7 )",410 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,16,8 )",411 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,17,9 )",412 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,18,10)",413 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,19,11)",414 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,20,12)",415 416 " REPLACEINTO $tableoptiongroups (group_id, group_name, group_desc) VALUES(3, 'RSS/RDF Feeds, Track/Ping-backs', 'Settings for RSS/RDF Feeds, Track/ping-backs')",417 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(3,21,1 )",418 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(3,22,2 )",419 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(3,23,3 )",420 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(3,24,4 )",421 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(3,25,5 )",422 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(3,26,6 )",423 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(3,27,7 )",424 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(3,28,8 )",425 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(3,29,9 )",426 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(3,30,10)",427 428 " REPLACEINTO $tableoptiongroups (group_id, group_name, group_desc) VALUES(4, 'File uploads', 'Settings for file uploads')",429 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(4,31,1 )",430 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(4,32,2 )",431 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(4,33,3 )",432 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(4,34,4 )",433 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(4,35,5 )",434 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(4,36,6 )",435 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(4,37,7 )",436 437 " REPLACEINTO $tableoptiongroups (group_id, group_name, group_desc) VALUES(5, 'Blog-by-Email settings', 'Settings for blogging via email')",438 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(5,38,1 )",439 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(5,39,2 )",440 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(5,40,3 )",441 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(5,41,4 )",442 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(5,42,5 )",443 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(5,43,6 )",444 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(5,44,7 )",445 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(5,45,8 )",446 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(5,46,9 )",447 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(5,47,10)",448 449 " REPLACEINTO $tableoptiongroups (group_id, group_name, group_desc) VALUES(6, 'Base settings', 'Basic settings required to get your blog working')",450 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(6,1,1)",451 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(6,2,2)",452 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(6,3,3)",453 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(6,4,4)",454 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(6,6,5)",455 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(6,7,6)",456 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(6,8,7)",457 " REPLACEINTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(6,54,8)",395 "INSERT INTO $tableoptiongroups (group_id, group_name, group_desc) VALUES(1, 'Other Options', 'Posts per page etc. Original options page')", 396 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(1,48,1 )", 397 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(1,49,2 )", 398 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(1,50,3 )", 399 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(1,51,4 )", 400 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(1,52,5 )", 401 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(1,53,6 )", 402 403 "INSERT INTO $tableoptiongroups (group_id, group_name, group_desc) VALUES(2, 'General blog settings', 'Things you\'ll probably want to tweak')", 404 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,9 ,1 )", 405 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,10,2 )", 406 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,11,3 )", 407 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,12,4 )", 408 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,13,5 )", 409 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,14,6 )", 410 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,15,7 )", 411 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,16,8 )", 412 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,17,9 )", 413 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,18,10)", 414 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,19,11)", 415 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(2,20,12)", 416 417 "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')", 418 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(3,21,1 )", 419 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(3,22,2 )", 420 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(3,23,3 )", 421 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(3,24,4 )", 422 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(3,25,5 )", 423 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(3,26,6 )", 424 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(3,27,7 )", 425 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(3,28,8 )", 426 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(3,29,9 )", 427 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(3,30,10)", 428 429 "INSERT INTO $tableoptiongroups (group_id, group_name, group_desc) VALUES(4, 'File uploads', 'Settings for file uploads')", 430 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(4,31,1 )", 431 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(4,32,2 )", 432 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(4,33,3 )", 433 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(4,34,4 )", 434 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(4,35,5 )", 435 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(4,36,6 )", 436 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(4,37,7 )", 437 438 "INSERT INTO $tableoptiongroups (group_id, group_name, group_desc) VALUES(5, 'Blog-by-Email settings', 'Settings for blogging via email')", 439 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(5,38,1 )", 440 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(5,39,2 )", 441 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(5,40,3 )", 442 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(5,41,4 )", 443 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(5,42,5 )", 444 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(5,43,6 )", 445 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(5,44,7 )", 446 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(5,45,8 )", 447 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(5,46,9 )", 448 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(5,47,10)", 449 450 "INSERT INTO $tableoptiongroups (group_id, group_name, group_desc) VALUES(6, 'Base settings', 'Basic settings required to get your blog working')", 451 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(6,1,1)", 452 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(6,2,2)", 453 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(6,3,3)", 454 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(6,4,4)", 455 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(6,6,5)", 456 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(6,7,6)", 457 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(6,8,7)", 458 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(6,54,8)", 458 459 459 460 // select data for what to show 460 " REPLACEINTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (49, 'days', 'days', null,null,1)",461 " REPLACEINTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (49, 'posts', 'posts', null,null,2)",462 " REPLACEINTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (49, 'paged', 'posts paged', null,null,3)",461 "INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (49, 'days', 'days', null,null,1)", 462 "INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (49, 'posts', 'posts', null,null,2)", 463 "INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (49, 'paged', 'posts paged', null,null,3)", 463 464 // select data for archive mode 464 " REPLACEINTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (50, 'daily', 'daily', null,null,1)",465 " REPLACEINTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (50, 'weekly', 'weekly', null,null,2)",466 " REPLACEINTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (50, 'monthly', 'monthly', null,null,3)",467 " REPLACEINTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (50, 'postbypost','post by post',null,null,4)",465 "INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (50, 'daily', 'daily', null,null,1)", 466 "INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (50, 'weekly', 'weekly', null,null,2)", 467 "INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (50, 'monthly', 'monthly', null,null,3)", 468 "INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (50, 'postbypost','post by post',null,null,4)", 468 469 // select data for time diff 469 " REPLACEINTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (51, null, null, 13, -13, null)",470 "INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (51, null, null, 13, -13, null)", 470 471 // select data for start of week 471 " REPLACEINTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (9, '0', 'Sunday', null,null,1)",472 " REPLACEINTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (9, '1', 'Monday', null,null,2)",473 " REPLACEINTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (9, '6', 'Saturday', null,null,3)",472 "INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (9, '0', 'Sunday', null,null,1)", 473 "INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (9, '1', 'Monday', null,null,2)", 474 "INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (9, '6', 'Saturday', null,null,3)", 474 475 475 476 … … 482 483 // default_post_category sql_select "SELECT cat_id AS value, cat_name AS label FROM $tablecategories order by cat_name" 483 484 484 "REPLACE 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)", 485 "REPLACE 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)", 486 "REPLACE 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)", 487 "REPLACE 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)", 488 "REPLACE 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)", 489 490 "REPLACE INTO $tableoptiongroups (group_id, group_name, group_desc) VALUES(7, 'Default post options', 'Default settings for new posts.')", 491 "REPLACE INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(7,55,1 )", 492 "REPLACE INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(7,56,2 )", 493 "REPLACE INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(7,57,3 )", 494 "REPLACE INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(7,58,4 )", 495 "REPLACE INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(7,59,5 )", 485 "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)", 486 "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)", 487 "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)", 488 "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)", 489 "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)", 490 "INSERT INTO $tableoptions (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)", 491 492 "INSERT INTO $tableoptiongroups (group_id, group_name, group_desc) VALUES(7, 'Default post options', 'Default settings for new posts.')", 493 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(7,55,1 )", 494 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(7,56,2 )", 495 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(7,57,3 )", 496 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(7,58,4 )", 497 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(7,59,5 )", 498 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(7,83,5 )", 496 499 497 500 // select data for post_status 498 " REPLACEINTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (55, 'publish', 'Publish', null,null,1)",499 " REPLACEINTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (55, 'draft', 'Draft', null,null,2)",500 " REPLACEINTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (55, 'private', 'Private', null,null,3)",501 "INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (55, 'publish', 'Publish', null,null,1)", 502 "INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (55, 'draft', 'Draft', null,null,2)", 503 "INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (55, 'private', 'Private', null,null,3)", 501 504 502 505 // select data for comment_status 503 " REPLACEINTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (56, 'open', 'Open', null,null,1)",504 " REPLACEINTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (56, 'closed', 'Closed', null,null,2)",506 "INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (56, 'open', 'Open', null,null,1)", 507 "INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (56, 'closed', 'Closed', null,null,2)", 505 508 506 509 // select data for ping_status (aargh duplication!) 507 " REPLACEINTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (57, 'open', 'Open', null,null,1)",508 " REPLACEINTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (57, 'closed', 'Closed', null,null,2)",510 "INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (57, 'open', 'Open', null,null,1)", 511 "INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (57, 'closed', 'Closed', null,null,2)", 509 512 510 513 // select data for pingback flag 511 " REPLACEINTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (58, '1', 'Checked', null,null,1)",512 " REPLACEINTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (58, '0', 'Unchecked', null,null,2)",514 "INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (58, '1', 'Checked', null,null,1)", 515 "INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (58, '0', 'Unchecked', null,null,2)", 513 516 514 517 // sql select data for default 515 " REPLACEINTO $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)",518 "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)", 516 519 ); 517 520 518 foreach ($option_data as $query) { 521 //foreach ($option_data as $query) { 522 // $q = $wpdb->query($query); 523 //} 524 525 ?> 526 527 <p>Good, the option data was inserted okay.</p> 528 529 <?php 530 $links_option_data = array( 531 "INSERT INTO $tableoptions (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)", 532 "INSERT INTO $tableoptions (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)", 533 "INSERT INTO $tableoptions (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)", 534 "INSERT INTO $tableoptions (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)", 535 "INSERT INTO $tableoptions (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)", 536 "INSERT INTO $tableoptions (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)", 537 "INSERT INTO $tableoptions (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)", 538 "INSERT INTO $tableoptions (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)", 539 "INSERT INTO $tableoptions (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)", 540 "INSERT INTO $tableoptions (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)", 541 "INSERT INTO $tableoptions (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)", 542 "INSERT INTO $tableoptions (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)", 543 "INSERT INTO $tableoptions (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)", 544 "INSERT INTO $tableoptions (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)", 545 "INSERT INTO $tableoptions (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)", 546 "INSERT INTO $tableoptions (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)", 547 "INSERT INTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(76,'weblogs_cache_file', 3, 'weblogs.com.changes.cache', 'path/to/cachefile needs to be writable by web server', 8, 40)", 548 "INSERT INTO $tableoptions (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)", 549 "INSERT INTO $tableoptions (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)", 550 "INSERT INTO $tableoptions (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)", 551 "INSERT INTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(80,'links_recently_updated_prepend', 3, '>>', 'The text to prepend to a recently updated link', 8, 10)", 552 "INSERT INTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(81,'links_recently_updated_append', 3, '<<', 'The text to append to a recently updated link', 8, 20)", 553 "INSERT INTO $tableoptions (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)", 554 555 //group them together 556 "INSERT INTO $tableoptiongroups (group_id, group_name, group_desc) VALUES(8, 'Link Manager Settings', 'Various settings for the link manager.')", 557 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,60,1 )", 558 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,61,2 )", 559 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,62,3 )", 560 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,63,4 )", 561 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,64,5 )", 562 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,65,6 )", 563 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,66,7 )", 564 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,67,8 )", 565 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,68,9 )", 566 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,69,10)", 567 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,70,11)", 568 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,71,12)", 569 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,72,13)", 570 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,73,14)", 571 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,74,15)", 572 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,75,16)", 573 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,76,17)", 574 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,77,18)", 575 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,78,19)", 576 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,79,20)", 577 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,80,21)", 578 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,81,22)", 579 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,82,23)", 580 581 // select data for rating_type 582 "INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (62, 'number', 'Number', null,null,1)", 583 "INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (62, 'char', 'Character', null,null,2)", 584 "INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (62, 'image', 'Image', null,null,3)", 585 ); 586 587 foreach ($links_option_data as $query) { 519 588 $q = $wpdb->query($query); 520 589 } 521 590 522 591 ?> 523 524 <p>Good, the option data was inserted okay.</p> 592 <p>Links option data inserted okay.</p> 593 <p>Now to grab your settings from links.config.php</p> 594 <?php 595 // pull in the old settings to define them globally 596 if (file_exists('../wp-links/links.config.php')) { 597 include('../wp-links/links.config.php'); 598 599 // now update the database with those settings 600 $query = "UPDATE $tableoptions SET option_value='".addslashes($links_minadminlevel )."' WHERE option_id=60"; $q = $wpdb->query($query); 601 $query = "UPDATE $tableoptions SET option_value='".addslashes($links_use_adminlevels )."' WHERE option_id=61"; $q = $wpdb->query($query); 602 $query = "UPDATE $tableoptions SET option_value='".addslashes($links_rating_type )."' WHERE option_id=62"; $q = $wpdb->query($query); 603 $query = "UPDATE $tableoptions SET option_value='".addslashes($links_rating_char )."' WHERE option_id=63"; $q = $wpdb->query($query); 604 $query = "UPDATE $tableoptions SET option_value='".addslashes($links_rating_ignore_zero )."' WHERE option_id=64"; $q = $wpdb->query($query); 605 $query = "UPDATE $tableoptions SET option_value='".addslashes($links_rating_single_image )."' WHERE option_id=65"; $q = $wpdb->query($query); 606 $query = "UPDATE $tableoptions SET option_value='".addslashes($links_rating_image0 )."' WHERE option_id=66"; $q = $wpdb->query($query); 607 $query = "UPDATE $tableoptions SET option_value='".addslashes($links_rating_image1 )."' WHERE option_id=67"; $q = $wpdb->query($query); 608 $query = "UPDATE $tableoptions SET option_value='".addslashes($links_rating_image2 )."' WHERE option_id=68"; $q = $wpdb->query($query); 609 $query = "UPDATE $tableoptions SET option_value='".addslashes($links_rating_image3 )."' WHERE option_id=69"; $q = $wpdb->query($query); 610 $query = "UPDATE $tableoptions SET option_value='".addslashes($links_rating_image4 )."' WHERE option_id=70"; $q = $wpdb->query($query); 611 $query = "UPDATE $tableoptions SET option_value='".addslashes($links_rating_image5 )."' WHERE option_id=71"; $q = $wpdb->query($query); 612 $query = "UPDATE $tableoptions SET option_value='".addslashes($links_rating_image6 )."' WHERE option_id=72"; $q = $wpdb->query($query); 613 $query = "UPDATE $tableoptions SET option_value='".addslashes($links_rating_image7 )."' WHERE option_id=73"; $q = $wpdb->query($query); 614 $query = "UPDATE $tableoptions SET option_value='".addslashes($links_rating_image8 )."' WHERE option_id=74"; $q = $wpdb->query($query); 615 $query = "UPDATE $tableoptions SET option_value='".addslashes($links_rating_image9 )."' WHERE option_id=75"; $q = $wpdb->query($query); 616 $query = "UPDATE $tableoptions SET option_value='".addslashes($weblogs_cache_file )."' WHERE option_id=76"; $q = $wpdb->query($query); 617 $query = "UPDATE $tableoptions SET option_value='".addslashes($weblogs_xml_url )."' WHERE option_id=77"; $q = $wpdb->query($query); 618 $query = "UPDATE $tableoptions SET option_value='".addslashes($weblogs_cacheminutes )."' WHERE option_id=78"; $q = $wpdb->query($query); 619 $query = "UPDATE $tableoptions SET option_value='".addslashes($links_updated_date_format )."' WHERE option_id=79"; $q = $wpdb->query($query); 620 $query = "UPDATE $tableoptions SET option_value='".addslashes($links_recently_updated_prepend)."' WHERE option_id=80"; $q = $wpdb->query($query); 621 $query = "UPDATE $tableoptions SET option_value='".addslashes($links_recently_updated_append )."' WHERE option_id=81"; $q = $wpdb->query($query); 622 $query = "UPDATE $tableoptions SET option_value='".addslashes($links_recently_updated_time )."' WHERE option_id=82"; $q = $wpdb->query($query); 623 ?> 624 <p>OK. All settings transferred. You can now delete <strong>wp-links/links.config.php</strong></p> 625 <?php 626 // end if links.config.php exists 627 } else { 628 ?> 629 <p>Hmm... I couldn't find links.config.php so I couldn't transfer all your settings. 630 You need to check them on the <a href="wp-options.php?option_group_id=8">admin options page</a>.</p> 631 <?php 632 } // end else no links.config 633 ?> 634 525 635 <p>Now to grab your settings from b2config</p> 526 636 … … 529 639 if (file_exists('../b2config.php')) { 530 640 include('../b2config.php'); 531 641 532 642 // now update the database with those settings 533 643 $query = "UPDATE $tableoptions SET option_value='".addslashes($siteurl )."' WHERE option_id=1"; $q = $wpdb->query($query); -
trunk/wp-admin/wp-install.php
r280 r290 46 46 case 0: 47 47 ?> 48 <p>Welcome to WordPress. We’re now going to go through a few steps to get 49 you up and running with the latest in personal publishing platforms. Before 50 we get started, remember that we require a PHP version of at least 4.0.6, you 51 have <?php echo phpversion(); ?>. Look good? You also need to set up the database 52 connection information in <code>wp-config.php</code>. Have you looked at the 53 <a href="../readme.html">readme</a>? If you’re all ready, <a href="wp-install.php?step=1">let's 48 <p>Welcome to WordPress. We’re now going to go through a few steps to get 49 you up and running with the latest in personal publishing platforms. Before 50 we get started, remember that we require a PHP version of at least 4.0.6, you 51 have <?php echo phpversion(); ?>. Look good? You also need to set up the database 52 connection information in <code>wp-config.php</code>. Have you looked at the 53 <a href="../readme.html">readme</a>? If you’re all ready, <a href="wp-install.php?step=1">let's 54 54 go</a>! </p> 55 55 <?php 56 56 break; 57 57 58 58 case 1: 59 59 ?> … … 61 61 <p>Okay first we’re going to set up the links database. This will allow you to host your own blogroll, complete with Weblogs.com updates.</p> 62 62 <?php 63 require_once('../wp-links/links.config.php');64 63 65 64 $got_links = false; … … 170 169 } 171 170 ?> 172 <p>Did you defeat the boss monster at the end? Great! You’re ready for <a href="wp-install.php?step=2">Step 171 <p>Did you defeat the boss monster at the end? Great! You’re ready for <a href="wp-install.php?step=2">Step 173 172 2</a>.</p> 174 173 <?php … … 516 515 "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)", 517 516 "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)", 517 "INSERT INTO $tableoptions (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)", 518 518 519 519 "INSERT INTO $tableoptiongroups (group_id, group_name, group_desc) VALUES(7, 'Default post options', 'Default settings for new posts.')", … … 523 523 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(7,58,4 )", 524 524 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(7,59,5 )", 525 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(7,83,5 )", 525 526 526 527 // select data for post_status … … 551 552 552 553 <p>Option Data inserted okay.</p> 554 555 556 <?php 557 $links_option_data = array( 558 "INSERT INTO $tableoptions (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)", 559 "INSERT INTO $tableoptions (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)", 560 "INSERT INTO $tableoptions (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)", 561 "INSERT INTO $tableoptions (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)", 562 "INSERT INTO $tableoptions (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)", 563 "INSERT INTO $tableoptions (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)", 564 "INSERT INTO $tableoptions (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)", 565 "INSERT INTO $tableoptions (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)", 566 "INSERT INTO $tableoptions (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)", 567 "INSERT INTO $tableoptions (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)", 568 "INSERT INTO $tableoptions (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)", 569 "INSERT INTO $tableoptions (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)", 570 "INSERT INTO $tableoptions (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)", 571 "INSERT INTO $tableoptions (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)", 572 "INSERT INTO $tableoptions (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)", 573 "INSERT INTO $tableoptions (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)", 574 "INSERT INTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(76,'weblogs_cache_file', 3, 'weblogs.com.changes.cache', 'path/to/cachefile needs to be writable by web server', 8, 40)", 575 "INSERT INTO $tableoptions (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)", 576 "INSERT INTO $tableoptions (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)", 577 "INSERT INTO $tableoptions (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)", 578 "INSERT INTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(80,'links_recently_updated_prepend', 3, '>>', 'The text to prepend to a recently updated link', 8, 10)", 579 "INSERT INTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(81,'links_recently_updated_append', 3, '<<', 'The text to append to a recently updated link', 8, 20)", 580 "INSERT INTO $tableoptions (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)", 581 582 //group them together 583 "INSERT INTO $tableoptiongroups (group_id, group_name, group_desc) VALUES(8, 'Link Manager Settings', 'Various settings for the link manager.')", 584 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,60,1 )", 585 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,61,2 )", 586 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,62,3 )", 587 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,63,4 )", 588 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,64,5 )", 589 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,65,6 )", 590 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,66,7 )", 591 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,67,8 )", 592 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,68,9 )", 593 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,69,10)", 594 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,70,11)", 595 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,71,12)", 596 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,72,13)", 597 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,73,14)", 598 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,74,15)", 599 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,75,16)", 600 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,76,17)", 601 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,77,18)", 602 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,78,19)", 603 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,79,20)", 604 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,80,21)", 605 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,81,22)", 606 "INSERT INTO $tableoptiongroup_options (group_id, option_id, seq) VALUES(8,82,23)", 607 608 // select data for rating_type 609 "INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (62, 'number', 'Number', null,null,1)", 610 "INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (62, 'char', 'Character', null,null,2)", 611 "INSERT INTO $tableoptionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (62, 'image', 'Image', null,null,3)", 612 ); 613 614 foreach ($links_option_data as $query) { 615 $q = $wpdb->query($query); 616 } 617 ?> 618 619 <p>Links option data inserted okay.</p> 553 620 554 621 <p>OK. We're nearly done now. We just need to ask you a couple of things:</p> … … 575 642 $q = $wpdb->query($query); 576 643 } 577 644 578 645 // $query = "DROP TABLE IF EXISTS $tableusers"; 579 646 // $q = mysql_query($query) or mysql_doh("doh, can't drop the table \"$tableusers\" in the database."); … … 614 681 <p>User setup successful!</p> 615 682 616 <p>Now you can <a href="../b2login.php">log in</a> with the <strong>login</strong> 683 <p>Now you can <a href="../b2login.php">log in</a> with the <strong>login</strong> 617 684 "admin" and <strong>password</strong> "<?php echo $random_password; ?>".</p> 618 <p><strong><em>Note that password</em></strong> carefully! It is a <em>random</em> 619 password that was generated just for you. If you lose it, you 685 <p><strong><em>Note that password</em></strong> carefully! It is a <em>random</em> 686 password that was generated just for you. If you lose it, you 620 687 will have to delete the tables from the database yourself, and re-install WordPress. 621 688 </p>
Note: See TracChangeset
for help on using the changeset viewer.