Copyright (C) 2004-2009, Ryan Djurovich Website Baker is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. Website Baker is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with Website Baker; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */ @include_once('config.php'); // this function checks the basic configurations of an existing WB intallation function status_msg($message, $class='check', $element='span') { // returns a status message echo '<'.$element .' class="' .$class .'">' .$message .''; } ?> Upgrade script
Website Baker Logo

Website Baker Upgrade

This script upgrades an existing Website Baker Version 2.7 installation to the Version 2.8. The upgrade script alters the existing WB database to reflect the changes introduced with WB 2.8.

Step 1: Backup your files

It is highly recommended to create a manual backup of the entire /pages folder and the MySQL database before proceeding.
Note: The upgrade script alters some settings of your existing database!!! You need to confirm the disclaimer before proceeding.



 I confirm that a manual backup of the /pages folder and the MySQL database was created.


Notice:
You need to confirm that you have created a manual backup of the /pages directory and the MySQL database before you can proceed.', 'warning', 'div'); echo '

'; exit; } echo '

Step 2: Updating database entries

'; require_once('config.php'); require_once(WB_PATH.'/framework/functions.php'); $OK = 'OK'; $FAIL = 'FAILED'; // function to add a var/value-pair into settings-table function db_add_key_value($key, $value) { global $database; global $OK; global $FAIL; $table = TABLE_PREFIX.'settings'; $query = $database->query("SELECT value FROM $table WHERE name = '$key' LIMIT 1"); if($query->numRows() > 0) { echo "$key: already exists. $OK.
"; return true; } else { $database->query("INSERT INTO $table (name,value) VALUES ('$key', '$value')"); echo (mysql_error()?mysql_error().'
':''); $query = $database->query("SELECT value FROM $table WHERE name = '$key' LIMIT 1"); if($query->numRows() > 0) { echo "$key: $OK.
"; return true; } else { echo "$key: $FAIL!
"; return false; } } } // function to add a new field into a table function db_add_field($field, $table, $desc) { global $database; global $OK; global $FAIL; $table = TABLE_PREFIX.$table; $query = $database->query("DESCRIBE $table '$field'"); if($query->numRows() == 0) { // add field $query = $database->query("ALTER TABLE $table ADD $field $desc"); echo (mysql_error()?mysql_error().'
':''); $query = $database->query("DESCRIBE $table '$field'"); echo (mysql_error()?mysql_error().'
':''); if($query->numRows() > 0) { echo "'$field' added. $OK.
"; } else { echo "adding '$field' $FAIL!
"; } } else { echo "'$field' already exists. $OK.
"; } } /********************************************************** * - Adding field sec_anchor to settings table */ echo "
Adding sec_anchor to settings table
"; $cfg = array( 'sec_anchor' => 'wb_' ); foreach($cfg as $key=>$value) { db_add_key_value($key, $value); } /********************************************************** * - Adding field default_theme to settings table */ echo "
Adding default_theme to settings table
"; $cfg = array( 'default_theme' => 'wb_theme' ); foreach($cfg as $key=>$value) { db_add_key_value($key, $value); } /********************************************************** * - Adding redirect timer to settings table */ echo "
Adding redirect timer to settings table
"; $cfg = array( 'redirect_timer' => '1500' ); foreach($cfg as $key=>$value) { db_add_key_value($key, $value); } /********************************************************** * - Adding mediasettings to settings table */ echo "
Adding mediasettings to settings table
"; $cfg = array( 'mediasettings' => '' ); foreach($cfg as $key=>$value) { db_add_key_value($key, $value); } /********************************************************** * - Add field "redirect_type" to table "mod_menu_link" */ echo "
Adding field redirect_type to mod_menu_link table
"; db_add_field('redirect_type', 'mod_menu_link', "INT NOT NULL DEFAULT '302' AFTER `target_page_id`"); /********************************************************** * - Update search no results database filed to create * valid XHTML if search is empty */ echo "
Updating database field `no_results` of search table: "; $search_no_results = addslashes('

[TEXT_NO_RESULTS]

'); $sql = "UPDATE `" . TABLE_PREFIX . "search` SET `value` = '$search_no_results' WHERE `name`= 'no_results'"; $database->query($sql); echo ($database->query($sql)) ? " $OK
" : " $FAIL
"; /********************************************************** * - Update settings of News Modul */ // These are the default setting $header = ''."\n"; $post_loop = ''; $footer = '
[TITLE] [PUBLISHED_TIME], [PUBLISHED_DATE]
[SHORT] [TEXT_READ_MORE]
[PREVIOUS_PAGE_LINK] [OF] [NEXT_PAGE_LINK]
'; $post_header = addslashes('

[TITLE]

 [GROUP_IMAGE]
[TEXT_POSTED_BY] [DISPLAY_NAME] ([USERNAME]) [TEXT_ON] [PUBLISHED_DATE]
[PAGE_TITLE] >> [GROUP_TITLE]
'); $post_footer = '

[TEXT_LAST_CHANGED]: [MODI_DATE] [TEXT_AT] [MODI_TIME]

[TEXT_BACK]'; $comments_header = addslashes('

[TEXT_COMMENTS]

'); $comments_loop = addslashes(''); $comments_footer = '
[TITLE] [TEXT_BY] [DISPLAY_NAME] [TEXT_ON] [DATE] [TEXT_AT] [TIME]
[COMMENT]

[TEXT_ADD_COMMENT]'; $comments_page = '

[TEXT_COMMENT]

[POST_TITLE]


'; // Insert default settings into database $query_dates = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_news_settings where section_id != 0 and page_id != 0"); while($result = $query_dates->fetchRow()) { echo "
Add default settings to database for news section_id= ".$result['section_id']."
"; $section_id = $result['section_id']; if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `header` = '$header' WHERE `section_id` = $section_id")) { echo 'Database data header added successfully'; } echo mysql_error().'
'; if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `post_loop` = '$post_loop' WHERE `section_id` = $section_id")) { echo 'Database data post_loop added successfully'; } echo mysql_error().'
'; if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `footer` = '$footer' WHERE `section_id` = $section_id")) { echo 'Database data footer added successfully'; } echo mysql_error().'
'; if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `post_header` = '$post_header' WHERE `section_id` = $section_id")) { echo 'Database data post_header added successfully'; } echo mysql_error().'
'; if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `post_footer` = '$post_footer' WHERE `section_id` = $section_id")) { echo 'Database data post_footer added successfully'; } echo mysql_error().'
'; if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `comments_header` = '$comments_header' WHERE `section_id` = $section_id")) { echo 'Database data comments_header added successfully'; } echo mysql_error().'
'; if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `comments_loop` = '$comments_loop' WHERE `section_id` = $section_id")) { echo 'Database data comments_loop added successfully'; } echo mysql_error().'
'; if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `comments_footer` = '$comments_footer' WHERE `section_id` = $section_id")) { echo 'Database data comments_footer added successfully'; } echo mysql_error().'
'; if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `comments_page` = '$comments_page' WHERE `section_id` = $section_id")) { echo 'Database data comments_page added successfully'; } echo mysql_error().'
'; } /********************************************************** * - Set Version to WB 2.8 */ echo "
Update database version number to 2.8 : "; $version = '2.8'; echo ($database->query("UPDATE `".TABLE_PREFIX."settings` SET `value` = '$version' WHERE `name` = 'wb_version'")) ? " $OK
" : " $FAIL
"; /********************************************************** * - install droplets */ echo "
Install droplets
"; $result = mysql_list_tables( DB_NAME ); $all_tables = array(); for($i=0; $i < mysql_num_rows($result); $i++) $all_tables[] = mysql_table_name($result, $i); $file_name = (!in_array ( TABLE_PREFIX."mod_droplets", $all_tables)) ? "install.php" : "upgrade.php"; require_once (WB_PATH."/modules/droplets/".$file_name); /********************************************************** * - Reload all addons */ //delete modules $database->query("DELETE FROM ".TABLE_PREFIX."addons WHERE type = 'module'"); // Load all modules if($handle = opendir(WB_PATH.'/modules/')) { while(false !== ($file = readdir($handle))) { if($file != '' AND substr($file, 0, 1) != '.' AND $file != 'admin.php' AND $file != 'index.php') { load_module(WB_PATH.'/modules/'.$file); } } closedir($handle); } echo '
Modules reloaded
'; //delete templates $database->query("DELETE FROM ".TABLE_PREFIX."addons WHERE type = 'template'"); // Load all templates if($handle = opendir(WB_PATH.'/templates/')) { while(false !== ($file = readdir($handle))) { if($file != '' AND substr($file, 0, 1) != '.' AND $file != 'index.php') { load_template(WB_PATH.'/templates/'.$file); } } closedir($handle); } echo '
Templates reloaded
'; //delete languages $database->query("DELETE FROM ".TABLE_PREFIX."addons WHERE type = 'language'"); // Load all languages if($handle = opendir(WB_PATH.'/languages/')) { while(false !== ($file = readdir($handle))) { if($file != '' AND substr($file, 0, 1) != '.' AND $file != 'index.php') { load_language(WB_PATH.'/languages/'.$file); } } closedir($handle); } echo '
Languages reloaded
'; /********************************************************** * - End of upgrade script */ echo '

Congratulations: The upgrade script is finished ...

'; status_msg('Warning:
Please delete the file upgrade-script.php via FTP before proceeding.', 'warning', 'div'); // show buttons to go to the backend or frontend echo '
'; if(defined('WB_URL')) { echo '
'; echo ''; echo '
'; } if(defined('ADMIN_URL')) { echo '
'; echo ' '; echo '
'; } echo '

 

'; ?>