. */ /** * * * @category Core * @package Core_service * @subpackage upgrade-script * @author Dietmar Wöllbrink * @author Werner v.d.Decken * @copyright Werner v.d.Decken * @license http://www.gnu.org/licenses/gpl.html GPL License * @version 0.0.1 * @revision $Revision: 2003 $ * @link $HeadURL: svn://isteam.dynxs.de/wb-archiv/branches/2.8.x/wb/upgrade-script.php $ * @lastmodified $Date: 2013-11-14 04:47:21 +0100 (Thu, 14 Nov 2013) $ * @since File available since 17.01.2013 * @deprecated * @description xyz */ // --- delete fatal disturbing files before upgrade starts ------------------------------- $aPreDeleteFiles = array( // list of files dirname(__FILE__).'/framework/PasswordHash.php' ); if(sizeof($aPreDeleteFiles > 0)) { // if there are files defined $sMsg = ''; foreach($aPreDeleteFiles as $sFileToDelete) { // iterate the list if(file_exists($sFileToDelete)) { if(!is_writeable($sFileToDelete) || !@unlink($sFileToDelete)) { // notice if deleting fails $sMsg .= 'FAILED deleting: ' . $sFileToDelete.'
'.PHP_EOL; } } } if($sMsg) { // stop script if there's an error occured $sMsg = 'Fatal error occured during initial startup.

'.PHP_EOL.$sMsg . '
'.PHP_EOL.'Please delete all of the files above manually and ' . 'then klick here to restart the upgrade-script.
'.PHP_EOL; die($sMsg); } } unset($aPreDeleteFiles); $sMsg = ''; // --------------------------------------------------------------------------------------- // Include config file $config_file = dirname(__FILE__).'/config.php'; if(file_exists($config_file) && !defined('WB_URL')) { require($config_file); } if(!class_exists('admin', false)) { include(WB_PATH.'/framework/class.admin.php'); } $admin = new admin('Addons', 'modules', false, false); // solved wrong pages_directory value before creating access files $sql = 'SELECT `value` FROM `'.TABLE_PREFIX.'settings` ' . 'WHERE `name`=\'pages_directory\''; $sPagesDirectory = WbDatabase::getInstance()->get_one($sql); $sTmp = trim($sPagesDirectory, '/'); $sTmpDir = ($sTmp == '' ? '' : '/'.$sTmp); if($sTmp != $sPagesDirectory) { $sql = 'UPDATE `'.TABLE_PREFIX.'settings` ' . 'SET `value` = \''.$sTmpDir.'\' ' . 'WHERE `name`=\'pages_directory\' '; WbDatabase::getInstance()->query($sql); } require_once(WB_PATH.'/framework/functions.php'); // require_once(WB_PATH.'/framework/Database.php'); $oldVersion = 'Version '.WB_VERSION; $oldVersion .= (defined('WB_SP') ? WB_SP : ''); $oldRevision = (defined('WB_REVISION') ? ' Revision ['.WB_REVISION.'] ' : '') ; $newVersion = 'Version '.VERSION; $newVersion .= (defined('SP') ? SP : ''); $newRevision = (defined('REVISION') ? ' Revision ['.REVISION.'] ' : ''); $bDebugModus = false; // set addition settings if not exists, otherwise upgrade will be breaks if(!defined('WB_SP')) { define('WB_SP',''); } if(!defined('WB_REVISION')) { define('WB_REVISION',''); } // database tables including in WB package $aPackage = array ( 'settings','groups','addons','pages','sections','search','users', 'mod_captcha_control','mod_jsadmin','mod_menu_link','mod_output_filter','mod_wrapper','mod_wysiwyg' ); $OK = ' OK '; $FAIL = ' FAILED '; $DEFAULT_THEME = 'wb_theme'; $stepID = 1; $dirRemove = array( /* '[TEMPLATE]/allcss/', '[TEMPLATE]/blank/', '[TEMPLATE]/round/', '[TEMPLATE]/simple/', */ '[ADMIN]/themes/', ); // $aRemoveSingleFiles = array( '[ADMIN]/preferences/details.php', '[ADMIN]/preferences/email.php', '[ADMIN]/preferences/password.php', '[ADMIN]/pages/settings2.php', '[ADMIN]/users/users.php', '[ADMIN]/groups/add.php', '[ADMIN]/groups/groups.php', '[ADMIN]/groups/save.php', '[ADMIN]/skel/themes/htt/groups.htt', '[FRAMEWORK]/class.msg_queue.php', '[FRAMEWORK]/class.logfile.php', '[FRAMEWORK]/PasswordHash.php', '[MODULES]/droplets/js/mdcr.js', ); // deleting files below only from less 2.8.4 stable if(version_compare(WB_VERSION, '2.8.4', '<')) { $aRemoveOldTemplates = array( '[TEMPLATE]/argos_theme/templates/access.htt', '[TEMPLATE]/argos_theme/templates/addons.htt', '[TEMPLATE]/argos_theme/templates/admintools.htt', '[TEMPLATE]/argos_theme/templates/error.htt', '[TEMPLATE]/argos_theme/templates/groups.htt', '[TEMPLATE]/argos_theme/templates/groups_form.htt', '[TEMPLATE]/argos_theme/templates/languages.htt', '[TEMPLATE]/argos_theme/templates/languages_details.htt', '[TEMPLATE]/argos_theme/templates/login.htt', '[TEMPLATE]/argos_theme/templates/login_forgot.htt', '[TEMPLATE]/argos_theme/templates/media.htt', '[TEMPLATE]/argos_theme/templates/media_browse.htt', '[TEMPLATE]/argos_theme/templates/media_rename.htt', '[TEMPLATE]/argos_theme/templates/modules.htt', '[TEMPLATE]/argos_theme/templates/modules_details.htt', '[TEMPLATE]/argos_theme/templates/pages.htt', '[TEMPLATE]/argos_theme/templates/pages_modify.htt', '[TEMPLATE]/argos_theme/templates/pages_sections.htt', '[TEMPLATE]/argos_theme/templates/pages_settings.htt', '[TEMPLATE]/argos_theme/templates/preferences.htt', '[TEMPLATE]/argos_theme/templates/setparameter.htt', '[TEMPLATE]/argos_theme/templates/settings.htt', '[TEMPLATE]/argos_theme/templates/start.htt', '[TEMPLATE]/argos_theme/templates/success.htt', '[TEMPLATE]/argos_theme/templates/templates.htt', '[TEMPLATE]/argos_theme/templates/templates_details.htt', '[TEMPLATE]/argos_theme/templates/users.htt', '[TEMPLATE]/argos_theme/templates/users_form.htt', '[TEMPLATE]/wb_theme/templates/access.htt', '[TEMPLATE]/wb_theme/templates/addons.htt', '[TEMPLATE]/wb_theme/templates/admintools.htt', '[TEMPLATE]/wb_theme/templates/error.htt', '[TEMPLATE]/wb_theme/templates/groups.htt', '[TEMPLATE]/wb_theme/templates/groups_form.htt', '[TEMPLATE]/wb_theme/templates/languages.htt', '[TEMPLATE]/wb_theme/templates/languages_details.htt', '[TEMPLATE]/wb_theme/templates/login.htt', '[TEMPLATE]/wb_theme/templates/login_forgot.htt', '[TEMPLATE]/wb_theme/templates/media.htt', '[TEMPLATE]/wb_theme/templates/media_browse.htt', '[TEMPLATE]/wb_theme/templates/media_rename.htt', '[TEMPLATE]/wb_theme/templates/modules.htt', '[TEMPLATE]/wb_theme/templates/modules_details.htt', '[TEMPLATE]/wb_theme/templates/pages.htt', '[TEMPLATE]/wb_theme/templates/pages_modify.htt', '[TEMPLATE]/wb_theme/templates/pages_sections.htt', '[TEMPLATE]/wb_theme/templates/pages_settings.htt', '[TEMPLATE]/wb_theme/templates/preferences.htt', '[TEMPLATE]/wb_theme/templates/setparameter.htt', '[TEMPLATE]/wb_theme/templates/settings.htt', '[TEMPLATE]/wb_theme/templates/start.htt', '[TEMPLATE]/wb_theme/templates/success.htt', '[TEMPLATE]/wb_theme/templates/templates.htt', '[TEMPLATE]/wb_theme/templates/templates_details.htt', '[TEMPLATE]/wb_theme/templates/users.htt', '[TEMPLATE]/wb_theme/templates/users_form.htt' ); }else { $aRemoveOldTemplates = array(); } $aFilesToRemove = array_merge($aRemoveSingleFiles, $aRemoveOldTemplates); unset($aRemoveSingleFiles); unset($aRemoveOldTemplates); /* display a status message on the screen ************************************** * @param string $message: the message to show * @param string $class: kind of message as a css-class * @param string $element: witch HTML-tag use to cover the message * @return void */ function status_msg($message, $class='check', $element='div') { // returns a status message $msg = '<'.$element.' class="'.$class.'">'; $msg .= ''.strtoupper(strtok($class, ' ')).''; $msg .= $message.''; echo $msg; } /** * add_modify_field_in_database() * * @param mixed $sTable * @param mixed $sField * @param mixed $sDescription * @return */ function add_modify_field_in_database($sTable,$sField,$sDescription){ global $OK,$FAIL,$bDebugModus; $database=WbDatabase::getInstance(); $aDebugMessage = array(); if(!$database->field_exists($sTable,$sField)) { $aDebugMessage[] = "Adding field $sField to $sTable table"; $aDebugMessage[] = ($database->field_add($sTable, $sField, $sDescription) ? " $OK
" : " $FAIL!
"); } else { $aDebugMessage[] = "Modify field $sField to $sTable table"; $aDebugMessage[] = ($database->field_modify($sTable, $sField, $sDescription) ? " $OK
" : " $FAIL!
"); } if($bDebugModus) { echo implode(PHP_EOL,$aDebugMessage); } return; } ?> Upgrade script

WebsiteBaker Upgrade

It is not possible to upgrade from WebsiteBaker Versions before 2.7.
For upgrading to version '.VERSION.' you must upgrade first to v.2.7 at least!!!', 'warning', 'div'); echo "

"; exit(); } if($admin->get_user_id()!=1){ status_msg('

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

', 'warning', 'div'); echo '

'; // delete remember key of current user from database //if (isset($_SESSION['USER_ID']) && isset($database)) { // $table = TABLE_PREFIX . 'users'; // $sql = "UPDATE `$table` SET `remember_key` = '' WHERE `user_id` = '" . (int) $_SESSION['USER_ID'] . "'"; // $database->query($sql); //} // delete remember key cookie if set if (isset($_COOKIE['REMEMBER_KEY']) && !headers_sent() ) { setcookie('REMEMBER_KEY', '', time() - 3600, '/'); } // delete most critical session variables manually $_SESSION['USER_ID'] = null; $_SESSION['GROUP_ID'] = null; $_SESSION['GROUPS_ID'] = null; $_SESSION['USERNAME'] = null; $_SESSION['PAGE_PERMISSIONS'] = null; $_SESSION['SYSTEM_PERMISSIONS'] = null; // overwrite session array $_SESSION = array(); // delete session cookie if set if (isset($_COOKIE[session_name()]) && !headers_sent()) { setcookie(session_name(), '', time() - 42000, '/'); } // delete the session itself session_destroy(); status_msg('

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

', 'info', 'div'); echo '

'; if(defined('ADMIN_URL')) { echo ''; } echo '

' .'' .'' .'' .''; exit(); } ?>

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 / 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.

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

' .'' .'' .'' .''; exit(); } /********************************************************** * - check tables coming with WebsiteBaker */ $aMissingTables = UpgradeHelper::getMissingTables($aPackage); if( sizeof($aMissingTables) == 0){ echo '

NOTICE: '.sizeof($aPackage).' total tables ' .'included in package are successfully installed into your database `' .$database->DbName.'` '.$OK.'

'; } else { status_msg(':
can\'t run Upgrade, missing tables', 'warning', 'div'); echo '

Missing required tables. You can install them in backend->addons->modules.
' .'Or if you uploaded per FTP install possible by backend->addons->modules->advanced.
' .'First rename or delete the upgrade-script.php, so the script can\'t start automatically by backend
' .'After installing missing tables upload and run again upgrade-script.php

' .'

' .'Missing required tables.

' .'TABLE `'.implode('` missing! '.$FAIL.'
TABLE `',$aMissingTables).'` missing! '.$FAIL .'

' .'

'; if(isset($_SERVER['SCRIPT_NAME'])) { echo ''; } if(defined('ADMIN_URL')) { echo ''; } echo '

' .'' .'' .'' .''; exit(); } echo '

Step '.(++$stepID).': Setting default_theme

'; $aDebugMessage = array(); /********************************************************** * - Adding field default_theme to settings table */ $aDebugMessage[] = '

'; $aDebugMessage[] = "Adding default_theme to table settings"; // db_update_key_value('settings', 'default_theme', $DEFAULT_THEME); $cfg = array( 'default_theme' => $DEFAULT_THEME ); $aDebugMessage[] = (db_update_key_value( 'settings', $cfg ) ? " $OK
" : " $FAIL!
"); $aDebugMessage[] = '

'; echo implode(PHP_EOL,$aDebugMessage); $aDebugMessage = array(); echo'

Step '.(++$stepID).': Updating core table included in package

'; /********************************************************** * - Adding field sec_anchor to settings table */ echo '

'; echo "

Adding/updating entries on table settings

"; $aDebugMessage[] = "Adding/updating sec_anchor to settings table"; $cfg = array( 'sec_anchor' => defined( 'SEC_ANCHOR' )&& (SEC_ANCHOR!='') ? SEC_ANCHOR : 'Sec' ); $bLogStatus = (db_update_key_value( 'settings', $cfg ) ? true : false ); $aDebugMessage[] = ( ($bLogStatus==true ) ? " $OK
" : " $FAIL!
"); /********************************************************** * - Adding redirect timer to settings table */ $aDebugMessage[] = "Adding/updating redirect timer to settings table"; $cfg = array( 'redirect_timer' => defined('REDIRECT_TIMER')&& (REDIRECT_TIMER!='') ? REDIRECT_TIMER : '1500' ); $bLogStatus = (db_update_key_value( 'settings', $cfg ) ? true : false ); $aDebugMessage[] = ( ($bLogStatus==true ) ? " $OK
" : " $FAIL!
"); /********************************************************** * - Adding default_time_formatr to settings table */ $aDebugMessage[] = "Adding/updating default_time_format to settings table"; $cfg = array( 'default_time_format' => defined('DEFAULT_TIME_FORMAT')&& (DEFAULT_TIME_FORMAT!='') ? DEFAULT_TIME_FORMAT : 'h:i A' ); $bLogStatus = (db_update_key_value( 'settings', $cfg ) ? true : false ); $aDebugMessage[] = ( ($bLogStatus==true ) ? " $OK
" : " $FAIL!
"); /********************************************************** * - Adding rename_files_on_upload to settings table */ $aDebugMessage[] = "Adding/Updating rename_files_on_upload to settings table"; $cfg = array( 'rename_files_on_upload' => (defined('RENAME_FILES_ON_UPLOAD')&& (RENAME_FILES_ON_UPLOAD!='') ? RENAME_FILES_ON_UPLOAD : 'ph.*?,cgi,pl,pm,exe,com,bat,pif,cmd,src,asp,aspx,js') ); if( version_compare( WB_VERSION, '2.8.2', '<' )) { $cfg = array( 'rename_files_on_upload' => 'ph.*?,cgi,pl,pm,exe,com,bat,pif,cmd,src,asp,aspx,js' ); } $bLogStatus = (db_update_key_value( 'settings', $cfg ) ? true : false ); $aDebugMessage[] = ( ($bLogStatus==true ) ? " $OK
" : " $FAIL!
"); /********************************************************** * - Adding mediasettings to settings table */ $aDebugMessage[] = "Adding/updating mediasettings to settings table"; $cfg = array( 'mediasettings' => (defined('MEDIASETTINGS')&& (MEDIASETTINGS!='') ? MEDIASETTINGS : ''), ); $bLogStatus = (db_update_key_value( 'settings', $cfg ) ? true : false ); $aDebugMessage[] = ( ($bLogStatus==true ) ? " $OK
" : " $FAIL!
"); /********************************************************** * - Adding fingerprint_with_ip_octets to settings table */ $aDebugMessage[] = "Adding/updating fingerprint_with_ip_octets to settings table"; $cfg = array( 'fingerprint_with_ip_octets' => (defined('FINGERPRINT_WITH_IP_OCTETS') ? FINGERPRINT_WITH_IP_OCTETS : '2'), 'secure_form_module' => (defined('SECURE_FORM_MODULE') ? SECURE_FORM_MODULE : '') ); $bLogStatus = (db_update_key_value( 'settings', $cfg ) ? true : false ); $aDebugMessage[] = ( ($bLogStatus==true ) ? " $OK
" : " $FAIL!
"); /********************************************************** * - Adding page_icon_dir to settings table */ $aDebugMessage[] = "Adding/updating page_icon_dir to settings table"; $cfg = array( 'page_icon_dir' => (defined('PAGE_ICON_DIR')&& (PAGE_ICON_DIR!='') ? PAGE_ICON_DIR : '/templates/*/title_images'), ); $bLogStatus = (db_update_key_value( 'settings', $cfg ) ? true : false ); $aDebugMessage[] = ( ($bLogStatus==true ) ? " $OK
" : " $FAIL!
"); /********************************************************** * - Adding page_extended to settings table */ $aDebugMessage[] = "Adding/updating page_extendet to settings table"; $cfg = array( 'page_extendet' => (defined('PAGE_EXTENDET') ? PAGE_EXTENDET : 'true'), ); $bLogStatus = (db_update_key_value( 'settings', $cfg ) ? true : false ); $aDebugMessage[] = ( ($bLogStatus==true ) ? " $OK
" : " $FAIL!
"); /********************************************************** * - Adding wbmail_signature to settings table */ $aDebugMessage[] = "Adding/updating wbmail_signature to settings table"; $cfg = array( 'wbmail_signature' => (defined('WBMAIL_SIGNATURE')&& (WBMAIL_SIGNATURE!='') ? WBMAIL_SIGNATURE : '') ); $bLogStatus = (db_update_key_value( 'settings', $cfg ) ? true : false ); $aDebugMessage[] = ( ($bLogStatus==true ) ? " $OK
" : " $FAIL!
"); /********************************************************** * - Adding confirmed_registration to settings table */ $aDebugMessage[] = "Adding/updating confirmed_registration to settings table"; $cfg = array( 'confirmed_registration' => (defined('CONFIRMED_REGISTRATION') ? CONFIRMED_REGISTRATION : '0') ); $bLogStatus = (db_update_key_value( 'settings', $cfg ) ? true : false ); $aDebugMessage[] = ( ($bLogStatus==true ) ? " $OK
" : " $FAIL!
"); /********************************************************** * - Adding dev_infos to settings table */ $aDebugMessage[] = "Adding/updating dev_infos to settings table"; $cfg = array( 'dev_infos' => (defined('DEV_INFOS') ? DEV_INFOS : 'false') ); $bLogStatus = (db_update_key_value( 'settings', $cfg ) ? true : false ); $aDebugMessage[] = ( ($bLogStatus==true ) ? " $OK
" : " $FAIL!
"); /********************************************************** * - Adding server_timezone to settings table */ $aDebugMessage[] = "Adding/updating server_timezone to settings table"; $cfg = array( 'server_timezone' => (defined('SERVER_TIMEZONE') ? SERVER_TIMEZONE : 'UTC') ); $bLogStatus = (db_update_key_value( 'settings', $cfg ) ? true : false ); $aDebugMessage[] = ( ($bLogStatus==true ) ? " $OK
" : " $FAIL!
"); /********************************************************** * - Adding password settings to table settings */ $aDebugMessage[] = "Adding/updating password settings to settings table"; $cfg = array(); $cfg['password_crypt_loops'] = (defined('PASSWORD_CRYPT_LOOPS') ? PASSWORD_CRYPT_LOOPS : '12'); $cfg['password_hash_type'] = (defined('PASSWORD_HASH_TYPES') ? PASSWORD_HASH_TYPES : 'false'); $cfg['password_length'] = (defined('PASSWORD_LENGTH') ? PASSWORD_LENGTH : '10'); $cfg['password_use_types'] = (defined('PASSWORD_USE_TYPES') ? PASSWORD_USE_TYPES : (int)0xFFFF); $bLogStatus = (db_update_key_value( 'settings', $cfg ) ? true : false ); $aDebugMessage[] = ( ($bLogStatus==true ) ? " $OK
" : " $FAIL!
"); if($bDebugModus) { echo implode(PHP_EOL,$aDebugMessage); } else { echo 'Successfully upgraded'." $OK
"; } echo '

'; $aDebugMessage = array(); if(version_compare(WB_REVISION, REVISION, '<=')) { echo '

'; /********************************************************** * - Update search no results database filed to create * valid XHTML if search is empty */ if (version_compare(WB_VERSION, '2.8', '<')) { echo "

Adding/updating fields on table search

"; echo "Updating database field `no_results` on 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!
"; } $aDebugMessage = array(); echo "

Adding/updating field on table pages

"; /********************************************************** * - Add field "page_trail" to table "pages" */ $table_name = TABLE_PREFIX.'pages'; $field_name = 'page_trail'; $description = "VARCHAR( 255 ) NOT NULL DEFAULT ''"; add_modify_field_in_database($table_name,$field_name,$description); /********************************************************** * - Add field "page_icon" to table "pages" */ $table_name = TABLE_PREFIX.'pages'; $field_name = 'page_icon'; $description = "VARCHAR( 512 ) NOT NULL DEFAULT '' AFTER `page_title`"; add_modify_field_in_database($table_name,$field_name,$description); /********************************************************** * - Add field "menu_icon_0" to table "pages" */ $table_name = TABLE_PREFIX.'pages'; $field_name = 'menu_icon_0'; $description = "VARCHAR( 512 ) NOT NULL DEFAULT '' AFTER `menu_title`"; add_modify_field_in_database($table_name,$field_name,$description); /********************************************************** * - Add field "menu_icon_1" to table "pages" */ $table_name = TABLE_PREFIX.'pages'; $field_name = 'menu_icon_1'; $description = "VARCHAR( 512 ) NOT NULL DEFAULT '' AFTER `menu_icon_0`"; add_modify_field_in_database($table_name,$field_name,$description); /********************************************************** * - Add field "tooltip" to table "pages" */ $table_name = TABLE_PREFIX.'pages'; $field_name = 'tooltip'; $description = "VARCHAR( 512 ) NOT NULL DEFAULT '' AFTER `menu_icon_1`"; add_modify_field_in_database($table_name,$field_name,$description); /********************************************************** * - Add field "admin_groups" to table "pages" */ $table_name = TABLE_PREFIX.'pages'; $field_name = 'admin_groups'; $description = "VARCHAR( 512 ) NOT NULL DEFAULT '1'"; add_modify_field_in_database($table_name,$field_name,$description); /********************************************************** * - Add field "admin_users" to table "pages" */ $table_name = TABLE_PREFIX.'pages'; $field_name = 'admin_users'; $description = "VARCHAR( 512 ) NOT NULL DEFAULT ''"; add_modify_field_in_database($table_name,$field_name,$description); /********************************************************** * - Add field "viewing_groups" to table "pages" */ $table_name = TABLE_PREFIX.'pages'; $field_name = 'viewing_groups'; $description = "VARCHAR( 512 ) NOT NULL DEFAULT '1'"; add_modify_field_in_database($table_name,$field_name,$description); /********************************************************** * - Add field "viewing_users" to table "pages" */ $table_name = TABLE_PREFIX.'pages'; $field_name = 'viewing_users'; $description = "VARCHAR( 512 ) NOT NULL DEFAULT ''"; add_modify_field_in_database($table_name,$field_name,$description); /********************************************************** * - Add field "custom01" to table "pages" */ $table_name = TABLE_PREFIX.'pages'; $field_name = 'custom01'; $description = "VARCHAR( 255 ) NOT NULL DEFAULT '' "; add_modify_field_in_database($table_name,$field_name,$description); /********************************************************** * - Add field "custom02" to table "pages" */ $table_name = TABLE_PREFIX.'pages'; $field_name = 'custom02'; $description = "VARCHAR( 255 ) NOT NULL DEFAULT '' "; add_modify_field_in_database($table_name,$field_name,$description); if($bDebugModus) { echo implode(PHP_EOL,$aDebugMessage); } else { echo 'Successfully upgraded'." $OK
"; } $aDebugMessage = array(); /********************************************************** * modify wrong strucre on table sections * wrong structure let crash wb */ echo "

Change field structure on table sections

"; $table_name = TABLE_PREFIX.'sections'; $description = "VARCHAR( 255 ) NOT NULL DEFAULT ''"; $aDebugMessage[] = "Modify field module on sections table"; $aDebugMessage[] = ($database->field_modify($table_name, 'module', $description) ? " $OK
" : " $FAIL!
"); $aDebugMessage[] = "Modify field block on sections table"; $description = "int(11) NOT NULL DEFAULT '1'"; $aDebugMessage[] = ($database->field_modify($table_name, 'block', $description) ? " $OK
" : " $FAIL!
"); $description = "int(11) NOT NULL DEFAULT '0'"; $aDebugMessage[] = "Modify field publ_start on sections table"; $aDebugMessage[] = ($database->field_modify($table_name, 'publ_start', $description) ? " $OK
" : " $FAIL!
"); $aDebugMessage[] = "Modify field publ_end on sections table"; $aDebugMessage[] = ($database->field_modify($table_name, 'publ_end', $description) ? " $OK
" : " $FAIL!
"); if($bDebugModus) { echo implode(PHP_EOL,$aDebugMessage); } else { echo 'Successfully upgraded'." $OK
"; } echo '

'; } if(version_compare(WB_REVISION, REVISION, '<=')) { $aDebugMessage = array(); echo '

Step '.(++$stepID).': Updating structure in table users/groups

'; /********************************************************** * Modify Administrator on groups table */ echo '

'; echo "

Updating Administrator group permissions on table groups

"; $aDebugMessage[] = "Modify Administrator on groups table"; $sModulePermissions = ''; $sTemplatePermissions = ''; $sSystemPermissions = 'access,addons,admintools,admintools_view,groups,groups_add,groups_delete,groups_modify,groups_view,'; $sSystemPermissions .= 'languages,languages_install,languages_uninstall,languages_view,media,media_create,media_delete,media_rename,media_upload,media_view,'; $sSystemPermissions .= 'modules,modules_advanced,modules_install,modules_uninstall,modules_view,pages,pages_add,pages_add_l0,pages_delete,pages_intro,pages_modify,pages_settings,pages_view,'; $sSystemPermissions .= 'preferences,preferences_view,settings,settings_advanced,settings_basic,settings_view,templates,templates_install,templates_uninstall,templates_view,users,users_add,users_delete,users_modify,users_view'; $sql = 'UPDATE `'.TABLE_PREFIX.'groups` '; $sql .= 'SET `name` = \'Administrators\', '; $sql .= '`system_permissions` = \''.$sSystemPermissions.'\', '; $sql .= '`module_permissions` = \''.$sModulePermissions.'\', '; $sql .= '`template_permissions` = \''.$sTemplatePermissions.'\' '; $sql .= 'WHERE `group_id` = \'1\' '; $aDebugMessage[] = ($database->query($sql)) ? " $OK
" : " $FAIL!
"; if( ($admin->is_authenticated() == true) && ($admin->ami_group_member('1') ) ) { $_SESSION['SYSTEM_PERMISSIONS'] = array_merge($_SESSION['SYSTEM_PERMISSIONS'], explode(',', $sSystemPermissions)); } if($bDebugModus) { echo implode(PHP_EOL,$aDebugMessage); } else { echo 'Successfully upgraded'." $OK
"; } echo '

'; $aDebugMessage = array(); /********************************************************** * `confirm_code` VARCHAR(32) NOT NULL DEFAULT '', * `confirm_timeout` INT(11) NOT NULL DEFAULT '0', */ echo '

'; echo "

Change field structure on table users

"; $table_name = TABLE_PREFIX.'users'; $field_name = 'confirm_code'; $description = "VARCHAR( 32 ) NOT NULL DEFAULT '' AFTER `password` "; add_modify_field_in_database($table_name,$field_name,$description); $table_name = TABLE_PREFIX.'users'; $field_name = 'confirm_timeout'; $description = "INT(11) NOT NULL DEFAULT '0' AFTER `confirm_code` "; add_modify_field_in_database($table_name,$field_name,$description); if($bDebugModus) { echo implode(PHP_EOL,$aDebugMessage); } else { echo 'Successfully upgraded'." $OK
"; } echo '

'; $aDebugMessage = array(); /********************************************************** * Updating group_id in table users */ echo '

'; echo "

Updating users groups permissions on table groups

"; $aUsers = array(); // Get existing values $sql = 'SELECT * FROM `'.TABLE_PREFIX.'users` ' ; $sql .= 'WHERE `user_id` != 1 '; if($oUser = $database->query($sql)){ $iTotalUsers = $oUser->numRows(); while($Users = $oUser->fetchRow(MYSQL_ASSOC)) { $aUsers[$Users['user_id']]['groups_id'] = $Users['groups_id']; $aUsers[$Users['user_id']]['display_name'] = $Users['display_name']; } } else { $aDebugMessage[] = $database->is_error()==false ? " $OK
" : " $FAIL!
"; } foreach($aUsers AS $user_id => $value){ // choose group_id from groups_id - workaround for still remaining calls to group_id (to be cleaned-up) $aGroups_id = explode(',', $aUsers[$user_id]['groups_id']); $groups_id = $aUsers[$user_id]['groups_id']; $group_id = 0; //if user is in administrator-group, get this group else just get the first one if($admin->is_group_match($aGroups_id,'1')) { $group_id = 1; $groups_id = '1'; } else { $group_id = intval($aGroups_id[0]); } $sMessage = "Updating group_id ".$TEXT['DISPLAY_NAME']." " .$aUsers[$user_id]['display_name'].""; $sql = 'UPDATE `'.TABLE_PREFIX.'users` '; $sql .= 'SET `group_id` = '.$group_id.', '; $sql .= '`groups_id` = \''.$groups_id.'\' '; $sql .= 'WHERE `user_id` = '.intval($user_id); if($oRes = $database->query($sql)){ } $aDebugMessage[] = $database->is_error()==false ? $sMessage." $OK
" : $sMessage." $FAIL!
"; } unset($aUsers); $aDebugMessage[] = '

'; if($bDebugModus) { // $aDebugMessage[] = echo implode(PHP_EOL,$aDebugMessage); }else { echo ''.$iTotalUsers.' users updating the groups'." $OK
"; echo ''; } } $aDebugMessage = array(); echo '

Step '.(++$stepID).': Updating access files in folders

'; echo '

'; /********************************************************** * upgrade media directory index protect files */ // echo '

Upgrade media directory '.MEDIA_DIRECTORY.'/ index.php protect files

'; // $aDebugMessage = rebuildFolderProtectFile(); // if( sizeof( $aDebugMessage ) ){ // echo 'Upgrade '.sizeof( $aDebugMessage ).' directory '.MEDIA_DIRECTORY.'/ protect files'." $OK
"; // } else { // echo 'Upgrade directory '.MEDIA_DIRECTORY.'/ protect files'." $FAIL!
"; // echo implode ('
',$aDebugMessage); // } // // $aDebugMessage = array(); /********************************************************** * upgrade pages directory index access files */ echo '

Upgrade pages directory '.PAGES_DIRECTORY.'/ access files

'; /********************************************************** * - Reformat/rebuild all existing access files */ $msg = rebuild_all_accessfiles($bDebugModus); echo ''.implode ('
',$msg).''; echo '

'; /* ***************************************************************************** * - check for deprecated / never needed files */ $iLoaded = sizeof($aFilesToRemove); if($iLoaded) { echo '

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

'; $iFailed = 0; $iFound = 0; $searches = array( '[ADMIN]', '[MEDIA]', '[PAGES]', '[FRAMEWORK]', '[MODULES]', '[TEMPLATE]' ); $replacements = array( '/'.substr(ADMIN_PATH, strlen(WB_PATH)+1), MEDIA_DIRECTORY, PAGES_DIRECTORY, '/framework', '/modules', '/templates' ); $msg = ''; echo '

'; echo '

Search '.$iLoaded.' deprecated and outdated files

'; foreach( $aFilesToRemove as $file ) { $file = str_replace($searches, $replacements, $file); if( is_writable(WB_PATH.'/'.$file) ) { $iFound++; // try to unlink file if(!unlink(WB_PATH.$file)) { $iFailed++; } } if( is_readable(WB_PATH.'/'.$file) ) { // save in err-list, if failed $msg .= $file.'
'; } } $iRemove = $iFound-$iFailed; echo 'Remove '.$iRemove.' from '.$iFound.' founded '; echo ($iFailed == 0) ? $OK : $FAIL; echo '

'; if($msg != '') { $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 "

"; exit; } } /********************************************************** * - check for deprecated / never needed files */ $iLoaded = sizeof($dirRemove); if($iLoaded) { echo '

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

'; $iFailed = 0; $iFound = 0; $searches = array( '[ADMIN]', '[MEDIA]', '[PAGES]', '[TEMPLATE]' ); $replacements = array( substr(ADMIN_PATH, strlen(WB_PATH)+1), MEDIA_DIRECTORY, PAGES_DIRECTORY, '/templates', ); $msg = ''; echo '

'; echo '

Search '.$iLoaded.' deprecated and outdated folders

'; foreach( $dirRemove as $dir ) { $dir = str_replace($searches, $replacements, $dir); $dir = WB_PATH.'/'.$dir; if( is_dir( $dir )) { $iFound++; // try to delete dir if(!is_writable( $dir ) || !rm_full_dir($dir)) { // save in err-list, if failed $iFailed++; } } if( is_readable(WB_PATH.'/'.$dir) ) { $msg .= str_replace(WB_PATH,'',$dir).'
'; } } $iRemove = $iFound-$iFailed; echo 'Remove '.$iRemove.' from '.$iFound.' founded '; echo ($iFailed == 0) ? $OK : $FAIL; echo '

'; if($msg != '') { $msg = '

Following directories 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 "

"; exit; } } /********************************************************** * upgrade modules if newer version is available * $aModuleList list of proofed modules */ $aProofedModuleList = array( 'captcha_control','code','droplets','form','jsadmin', 'menu_link','news','output_filter','wrapper','wysiwyg','MultiLingual'); if(sizeof($aProofedModuleList)) { echo '

Step '.(++$stepID).': Upgrade proofed modules

'; foreach($aProofedModuleList as $sModul) { if(file_exists(WB_PATH.'/modules/'.$sModul.'/upgrade.php')) { $currModulVersion = get_modul_version ($sModul, false); $newModulVersion = get_modul_version ($sModul, true); if((version_compare($currModulVersion, $newModulVersion) <= 0)) { echo '

'; echo '

'.'Upgrade module \''.$sModul.'\' version '.$newModulVersion.'

'; require(WB_PATH.'/modules/'.$sModul.'/upgrade.php'); echo '

'; } } } } /********************************************************** * Reformat/rebuild all existing moules access files * $aModuleList list of modules */ $aModuleList = array('bakery','topics','news'); if(sizeof($aModuleList)) { echo '

Step '.(++$stepID).': Create/Reorg Accessfiles from modules

'; foreach($aModuleList as $sModul) { $aReturnMsg = array(); $sModulReorg = 'm_'.$sModul.'_Reorg'; if(class_exists($sModulReorg)) { $sModulVersion = get_modul_version ($sModul, true); echo '

'; echo '

'.'Create/Reorg Accessfiles for module \''.$sModul.'\' version '.$sModulVersion.'

'; $oReorg = new $sModulReorg(ModuleReorgAbstract::LOG_EXTENDED); $aReturnMsg = $oReorg->execute(); // show details $aReport = $oReorg->getReport(); unset($oReorg); if($bDebugModus) { foreach($aReport['Failed'] as $sValue) { echo $sValue.'
'; } foreach($aReport['Success'] as $sValue) { echo $sValue.'
'; } } // echo ''.$aReport['FilesDeleted'].' Files successful deleted
'; echo 'Number of new formated access files: '.$aReport['FilesCreated'].'
'; echo '

'; } } } /********************************************************** * - Reload all addons */ echo '

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

'; echo '

'; $iFound = 0; $iLoaded = 0; ////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 != '' && substr($file, 0, 1) != '.' && is_dir(WB_PATH.'/modules/'.$file) ) { $iFound++; $iLoaded = load_module(WB_PATH.'/modules/'.$file ) ? $iLoaded+1 : $iLoaded; // upgrade_module($file, true); } } closedir($handle); } echo ''.$iLoaded.' Modules reloaded, found '.$iFound.' directories in folder /modules/
'; $iFound = 0; $iLoaded = 0; ////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') { $iFound++; $iLoaded = (load_template(WB_PATH.'/templates/'.$file)==true) ? $iLoaded+1 : $iLoaded; } } closedir($handle); } echo ''.$iLoaded.' Templates reloaded, found '.$iFound.' directories in folder /templates/
'; $iFound = 0; $iLoaded = 0; ////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 (preg_match('#^([A-Z]{2}.php)#', basename($file)))) { $iFound++; $iLoaded = load_language(WB_PATH.'/languages/'.$file) ? $iLoaded+1 : $iLoaded; } } closedir($handle); } echo ''.$iLoaded.' Languages reloaded, found '.$iFound.' files in folder /languages/
'; echo '

'; /********************************************************** * - install new droplets $drops = (!in_array ( "mod_droplets", $all_tables)) ? "
Install droplets
" : "
Upgrade droplets
"; echo $drops; $file_name = (!in_array ( "mod_droplets", $all_tables) ? "install.php" : "upgrade.php"); require_once (WB_PATH."/modules/droplets/".$file_name); ********************************************************** */ /********************************************************** * - End of upgrade script */ if(!defined('DEFAULT_THEME')) { define('DEFAULT_THEME', $DEFAULT_THEME); } if(!defined('THEME_PATH')) { define('THEME_PATH', WB_PATH.'/templates/'.DEFAULT_THEME);} /********************************************************** * - Set Version to new Version */ echo '

Step '.(++$stepID).': Update database version number

'; echo '

'; $cfg = array( 'wb_version' => VERSION, 'wb_revision' => REVISION, 'wb_sp' => SP ); echo '
Set WebsiteBaker version number to '.VERSION.' '.SP.' '.' Revision ['.REVISION.'] : '; echo (db_update_key_value( 'settings', $cfg ) ? " $OK
" : " $FAIL!
"); echo '

'; echo '

Congratulations: The upgrade script is finished ...

'; status_msg(':
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 ''; } if(defined('ADMIN_URL')) { echo ''; } echo "

"; exit();

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

It is highly recommended to create a manual backup of the entire / folder and the MySQL database before proceeding.

NOTICE: '.sizeof($aPackage).' total tables ' .'included in package are successfully installed into your database `' .$database->DbName.'` '.$OK.'

' .'Missing required tables.' .'TABLE `'.implode('` missing! '.$FAIL.'TABLE `',$aMissingTables).'` missing! '.$FAIL .'

Step '.(++$stepID).': Setting default_theme

Step '.(++$stepID).': Updating core table included in package

Adding/updating entries on table settings

Adding/updating fields on table search

Adding/updating field on table pages

Change field structure on table sections

Step '.(++$stepID).': Updating structure in table users/groups

Updating Administrator group permissions on table groups

Change field structure on table users

Updating users groups permissions on table groups

Step '.(++$stepID).': Updating access files in folders

Upgrade media directory '.MEDIA_DIRECTORY.'/ index.php protect files

Upgrade pages directory '.PAGES_DIRECTORY.'/ access files

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

Search '.$iLoaded.' deprecated and outdated files

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

Search '.$iLoaded.' deprecated and outdated folders

Step '.(++$stepID).': Upgrade proofed modules

'.'Upgrade module \''.$sModul.'\' version '.$newModulVersion.'

Step '.(++$stepID).': Create/Reorg Accessfiles from modules

'.'Create/Reorg Accessfiles for module \''.$sModul.'\' version '.$sModulVersion.'

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

Step '.(++$stepID).': Update database version number

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

' .'Missing required tables.

' .'TABLE `'.implode('` missing! '.$FAIL.'
TABLE `',$aMissingTables).'` missing! '.$FAIL .'