System Message

This script upgrades an existing WebsiteBaker installation to the .
The upgrade script alters the existing WB database to reflect the changes introduced with WB 2.8.x

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.

Step '.(++$stepID).' Your database '.DB_NAME.' has '.sizeof($all_tables).' '.$check_text.' tables from '.sizeof($table_list).' included in package '.$OK.'

Missing required tables. You can install them in backend->addons->modules->advanced. Then again run upgrade-script.php

'; while ( list ( $key, $val ) = each ( $result ) ) { echo TABLE_PREFIX.$val.' '.$FAIL.'
'; } echo '

Step '.(++$stepID).' : clear Translate cache if exists

Step '.(++$stepID).' : Adding/Updating settings table

The upgrade-script has be run properly, therefore the property Debug was set to the value false.

Step '.(++$stepID).' : Adding/Updating database tables

'; echo $database->get_error(). $FAIL.'(Index already exists)
'; echo '

'; echo 'Upgrade Core Tables '. $OK.'
'; echo '

Step '.(++$stepID).' Clear default title value in sections table

'; $sDescription = 'UPDATE `'.TABLE_PREFIX.'sections` SET `title` = REPLACE(`title`,\'Section-ID 0\',\'\') WHERE `title` LIKE \'%Section-ID%\''; if (!$database->query($sDescription)){ echo 'Upgrading sections Table (empty title field) '. $FAIL.'
'; } else { echo 'Upgrade sections Table '. $OK.'
'; } echo '

Check if the install folder exist.
Please upload install folder using FTP and restart upgrade-script!

Step '.(++$stepID).' : Modify PRIMARY KEY in settings table and add missing entries

'; $msg = MigrateSettingsTable($database, TABLE_PREFIX, $aDefaultSettings); echo ($msg!=''?$msg.' '.$FAIL:'Modify settings table '.$OK).'
'; echo '

Step '.(++$stepID).' : Updating default_theme/default_template in settings table

'; echo "Adding default_theme to settings table
"; db_update_key_value('settings', 'default_theme', $DEFAULT_THEME); echo "Adding default_template to settings table
"; db_update_key_value('settings', 'default_template', $DEFAULT_TEMPLATE); echo '

Step '.(++$stepID).' : checking database entries

Step '.(++$stepID).' : checking table droplets

'; $drops = (!in_array ( TABLE_PREFIX."mod_droplets", $check_tables)) ? "Install droplets" : "Upgrade droplets"; echo ''.$drops.'
'; $file_name = (!in_array ( TABLE_PREFIX."mod_droplets", $check_tables) ? "install.php" : "upgrade.php"); require_once (WB_PATH."/modules/droplets/".$file_name); echo '

Step '.(++$stepID).' : Adding/Updating settings table

'; echo "
Adding string_dir_mode and string_file_mode to settings table
"; $cfg = array( 'confirmed_registration' => (defined('CONFIRMED_REGISTRATION')?CONFIRMED_REGISTRATION:'0'), 'groups_updated' => (defined('GROUPS_UPDATED')?GROUPS_UPDATED:''), 'page_icon_dir' => (defined('PAGE_ICON_DIR')?PAGE_ICON_DIR:'/templates/*/title_images'), 'system_locked' => (defined('SYSTEM_LOCKED')?SYSTEM_LOCKED:'0'), 'string_dir_mode' => (defined('STRING_DIR_MODE')?STRING_DIR_MODE:'0755'), 'string_file_mode' => (defined('STRING_FILE_MODE')?STRING_FILE_MODE:'0644') ); foreach($cfg as $key=>$value) { db_add_key_value($key, $value); } /********************************************************** * - Adding field sec_anchor to settings table */ echo '

Step '.(++$stepID).' : Adding/Updating settings table

'; echo '

'; echo "
Adding sec_anchor and website_signature to settings table
"; $cfg = array( 'sec_anchor' => (defined('SEC_ANCHOR')?SEC_ANCHOR:'wb_'), 'website_signature' => (defined('WEBSITE_SIGNATURE')?WEBSITE_SIGNATURE:'') ); 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' => (defined('REDIRECT_TIMER')?REDIRECT_TIMER:'1500') ); foreach($cfg as $key=>$value) { db_add_key_value($key, $value); } /********************************************************** * - Adding rename_files_on_upload to settings table */ echo "
Updating rename_files_on_upload to settings table
"; $cfg = array( 'rename_files_on_upload' => (defined(RENAME_FILES_ON_UPLOAD)?RENAME_FILES_ON_UPLOAD:'ph.*?,cgi,pl,pm,exe,com,bat,pif,cmd,src,asp,aspx,js') ); db_add_key_value( 'rename_files_on_upload', $cfg['rename_files_on_upload']); /********************************************************** * - Adding mediasettings to settings table */ echo "
Adding mediasettings and debug to settings table
"; $cfg = array( 'debug' => (defined('DEBUG')?DEBUG:'false'), 'mediasettings' => (defined('MEDIASETTINGS') ?MEDIASETTINGS:''), ); foreach($cfg as $key=>$value) { db_add_key_value($key, $value); } /********************************************************** * - Set wysiwyg_editor to settings table */ echo "
Set wysiwyg_editor to ckeditor
"; db_update_key_value('settings', 'wysiwyg_editor', 'ckeditor'); /********************************************************** * - Adding fingerprint_with_ip_octets to settings table */ echo "
Adding fingerprint_with_ip_octets to settings table
"; $cfg = array( 'sec_token_fingerprint' => (defined('SEC_TOKEN_FINGERPRINT') ?SEC_TOKEN_FINGERPRINT:'true'), 'sec_token_netmask4' => (defined('SEC_TOKEN_NETMASK4') ?SEC_TOKEN_NETMASK4:'24'), 'sec_token_netmask6' => (defined('SEC_TOKEN_NETMASK6') ?SEC_TOKEN_NETMASK6:'64'), 'sec_token_life_time' => (defined('SEC_TOKEN_LIFE_TIME') ?SEC_TOKEN_LIFE_TIME:'180'), 'wbmailer_smtp_port' => (defined('WBMAILER_SMTP_PORT') ?WBMAILER_SMTP_PORT:'25'), 'wbmailer_smtp_secure' => (defined('WBMAILER_SMTP_SECURE') ?WBMAILER_SMTP_SECURE:'TLS') ); 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('mod_menu_link', 'redirect_type', "INT NOT NULL DEFAULT '301' AFTER `target_page_id`"); echo '

'; /********************************************************** * - Update search no results database filed to create * valid XHTML if search is empty */ if (version_compare(WB_VERSION, '2.8', '<')) { echo "
Updating database field `no_results` of search table: "; $search_no_results = addslashes('

[TEXT_NO_RESULTS]

'); $sql = 'UPDATE `'.TABLE_PREFIX.'search` '; $sql .= 'SET `value`=\''.$search_no_results.'\' '; $sql .= 'WHERE `name`=\'no_results\''; echo ($database->query($sql)) ? ' $OK
' : ' $FAIL
'; } /* ***************************************************************************** * - check for deprecated / never needed files */ if(sizeof($filesRemove)) { echo '

Step '.(++$stepID).': Remove deprecated and old files

'; } $searches = array( '[ROOT]', '[ACCOUNT]', '[ADMIN]', '[INCLUDE]', '[INSTALL]', '[FRAMEWORK]', '[MEDIA]', '[MODULES]', '[PAGES]', '[TEMP]', '[TEMPLATE]', '[DOCU]' ); $replacements = array( '/', '/account/', '/'.substr(ADMIN_PATH, strlen(WB_PATH)+1).'/', '/include/', '/install/', '/framework/', MEDIA_DIRECTORY.'/', '/modules/', PAGES_DIRECTORY.'/', '/temp/', '/templates/', '/DOCU/' ); $aMsg = array(); array_walk( $filesRemove, function (&$sFile) use($searches, $replacements) { $sFile = str_replace( '\\', '/', WB_PATH.str_replace($searches, $replacements, $sFile) ); } ); foreach ( $filesRemove as $sFileToDelete ) { if (false !== ($aExistingFiles = glob(dirname($sFileToDelete).'/*', GLOB_MARK)) ) { if ( in_array($sFileToDelete, $aExistingFiles) ) { if ( is_writable($sFileToDelete) && unlink($sFileToDelete) ) { print 'Remove '.$sFileToDelete.''." $OK
"; } else { $aMsg[] = $sFileToDelete; } } } } unset($aExistingFiles); if( sizeof($aMsg) ) { $sWbPath = str_replace('\\', '/', WB_PATH ); array_walk($aMsg, function(&$sMsg) use ($sWbPath) { $sMsg = str_replace($sWbPath, '', $sMsg); }); $msg = implode('
', $aMsg).'
'; $msg = '

Following files are deprecated, outdated or a security risk and can not be removed automatically.

Please delete them using FTP and restart upgrade-script!

'.$msg.'
'; status_msg($msg, 'error warning', 'div'); echo '

WARNING: The upgrade script failed ...

'; echo ''; echo '

Step '.(++$stepID).': Remove deprecated and old folders

Step '.(++$stepID).' : Checking all addons with a newer version (upgrade)

'; $aModuleDirList = glob(WB_PATH.'/modules/*', GLOB_ONLYDIR|GLOB_ONLYDIR ); $i = $upgradeID = 0; # $aModuleWhiteList = array_flip($aModuleWhiteList); foreach($aModuleDirList as $sModul) { $sModulName = basename($sModul); $i++; if (in_array($sModulName, $aModuleWhiteList) && file_exists($sModul.'/upgrade.php')) { $currModulVersion = get_modul_version ($sModulName, false); $newModulVersion = get_modul_version ($sModulName, true); if((version_compare($currModulVersion, $newModulVersion, '<' ) )) { require($sModul.'/upgrade.php'); load_module($sModul); echo '

'.sprintf("[%2s]", (++$upgradeID)).' : Upgrade module \''.$sModulName.'\' from version '.$currModulVersion.' to version'.$newModulVersion.'

'; } else { echo '

'.sprintf("[%2s]", (++$upgradeID)).' : Module \''.$sModulName.'\' - Your current version is '.$currModulVersion.'

'; } } else { echo '

'.sprintf("[%2s]", (++$upgradeID)).' : Unchecked Module \''.$sModulName.'\' is not registered in /install/ModuleWhiteList

'; } } echo '

Step '.(++$stepID).' : Reload all addons database entry (no upgrade)

'; echo '
Modules will be reloaded
'; /* */ ////delete modules $sql = 'DELETE FROM `'.TABLE_PREFIX.'addons` ' . 'WHERE `type` = \'module\''; $database->query($sql); // 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 ); // upgrade_module($file, true); } } closedir($handle); } ////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 */ // require(WB_PATH.'/framework/initialize.php'); if(!defined('DEFAULT_THEME')) { define('DEFAULT_THEME', $DEFAULT_THEME); } if(!defined('THEME_PATH')) { define('THEME_PATH', WB_PATH.'/templates/'.DEFAULT_THEME);} if(!defined('THEME_URL')) { define('THEME_URL', WB_URL.'/templates/'.DEFAULT_THEME);} if(!defined('DEFAULT_TEMPLATE')) { define('DEFAULT_TEMPLATE', $DEFAULT_TEMPLATE); } if(!defined('TEMPLATE_PATH')) { define('TEMPLATE_PATH', WB_PATH.'/templates/'.DEFAULT_TEMPLATE);} if(!defined('TEMPLATE_DIR')) { define('TEMPLATE_DIR', WB_URL.'/templates/'.DEFAULT_TEMPLATE);} /********************************************************** * - Set Version to new Version */ echo '
Reload all addons database entry (no upgrade)
'; echo '

WebsiteBaker - System Message

'.strtoupper(strtok($class, ' ')).'

WebsiteBaker Upgrade

WebsiteBaker upgrading is not possible!
Before upgrading ' .'to Revision '.REVISION.' you have to login as System-Administrator!

You have to login as System-Adminstrator start ' .'upgrade-script.php again!

Step 1: Backup your files

Step '.(++$stepID).' Your database '.DB_NAME.' has '.sizeof($all_tables).' '.$check_text.' tables from '.sizeof($table_list).' included in package '.$OK.'

Missing required tables. You can install them in backend->addons->modules->advanced. Then again run upgrade-script.php

'; while ( list ( $key, $val ) = each ( $result ) ) { echo TABLE_PREFIX.$val.' '.$FAIL.'
'; } echo '

Step '.(++$stepID).' : clear Translate cache if exists

Step '.(++$stepID).' : Adding/Updating settings table

Step '.(++$stepID).' : Adding/Updating database tables

Step '.(++$stepID).' Clear default title value in sections table

Step '.(++$stepID).' : Modify PRIMARY KEY in settings table and add missing entries

Step '.(++$stepID).' : Updating default_theme/default_template in settings table

Step '.(++$stepID).' : checking database entries

Step '.(++$stepID).' : checking table droplets

Step '.(++$stepID).' : Adding/Updating settings table

Step '.(++$stepID).' : Adding/Updating settings table

Step '.(++$stepID).': Remove deprecated and old files

Step '.(++$stepID).': Remove deprecated and old folders

Step '.(++$stepID).' : Checking all addons with a newer version (upgrade)

'.sprintf("[%2s]", (++$upgradeID)).' : Upgrade module \''.$sModulName.'\' from version '.$currModulVersion.' to version'.$newModulVersion.'

'.sprintf("[%2s]", (++$upgradeID)).' : Module \''.$sModulName.'\' - Your current version is '.$currModulVersion.'

'.sprintf("[%2s]", (++$upgradeID)).' : Unchecked Module \''.$sModulName.'\' is not registered in /install/ModuleWhiteList

Step '.(++$stepID).' : Reload all addons database entry (no upgrade)

Step '.(++$stepID).' : Update WebsiteBaker version number to '.VERSION.' '.SP.' '.' Revision ['.REVISION.']

Congratulations: The upgrade script is finished ...

WebsiteBaker - System Message

'.strtoupper(strtok($class, ' ')).'

WebsiteBaker Upgrade

WebsiteBaker upgrading is not possible!Before upgrading ' .'to Revision '.REVISION.' you have to login as System-Administrator!

You have to login as System-Adminstrator start ' .'upgrade-script.php again!

Step 1: Backup your files

Step '.(++$stepID).' Your database '.DB_NAME.' has '.sizeof($all_tables).' '.$check_text.' tables from '.sizeof($table_list).' included in package '.$OK.'

Missing required tables. You can install them in backend->addons->modules->advanced. Then again run upgrade-script.php

'; while ( list ( $key, $val ) = each ( $result ) ) { echo TABLE_PREFIX.$val.' '.$FAIL.''; } echo '

Step '.(++$stepID).' : clear Translate cache if exists

Step '.(++$stepID).' : Adding/Updating settings table

Step '.(++$stepID).' : Adding/Updating database tables

Step '.(++$stepID).' Clear default title value in sections table

Step '.(++$stepID).' : Modify PRIMARY KEY in settings table and add missing entries

Step '.(++$stepID).' : Updating default_theme/default_template in settings table

Step '.(++$stepID).' : checking database entries

Step '.(++$stepID).' : checking table droplets

Step '.(++$stepID).' : Adding/Updating settings table

Step '.(++$stepID).' : Adding/Updating settings table

Step '.(++$stepID).': Remove deprecated and old files

Step '.(++$stepID).': Remove deprecated and old folders

Step '.(++$stepID).' : Checking all addons with a newer version (upgrade)

'.sprintf("[%2s]", (++$upgradeID)).' : Upgrade module \''.$sModulName.'\' from version '.$currModulVersion.' to version'.$newModulVersion.'

'.sprintf("[%2s]", (++$upgradeID)).' : Module \''.$sModulName.'\' - Your current version is '.$currModulVersion.'

'.sprintf("[%2s]", (++$upgradeID)).' : Unchecked Module \''.$sModulName.'\' is not registered in /install/ModuleWhiteList

Step '.(++$stepID).' : Reload all addons database entry (no upgrade)

Step '.(++$stepID).' : Update WebsiteBaker version number to '.VERSION.' '.SP.' '.' Revision ['.REVISION.']

Congratulations: The upgrade script is finished ...

WebsiteBaker upgrading is not possible!
Before upgrading ' .'to Revision '.REVISION.' you have to login as System-Administrator!

'; while ( list ( $key, $val ) = each ( $result ) ) { echo TABLE_PREFIX.$val.' '.$FAIL.'
'; } echo '