WB 2.08.x

<?php

/**

 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.

 *

 * This program 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 3 of the License, or

 * (at your option) any later version.

 *

 * This program 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 this program.  If not, see <http://www.gnu.org/licenses/>.

 */

/**

 * 

 * 

 * @category     Core

 * @package      Core_package

 * @subpackage   upgrade-script

 * @author       Dietmar Wöllbrink <dietmar.woellbrink@websitebaker.org>

 * @author       Werner v.d.Decken <wkl@isteam.de>

 * @copyright    Werner v.d.Decken <wkl@isteam.de>

 * @license      http://www.gnu.org/licenses/gpl.html   GPL License

 * @version      0.0.1

 * @revision     $Revision: 1896 $

 * @link         $HeadURL: svn://isteam.dynxs.de/wb-archiv/branches/2.8.x/wb/upgrade-script.php $

 * @lastmodified $Date: 2013-03-20 23:04:14 +0100 (Wed, 20 Mar 2013) $

 * @since        File available since 17.01.2013

 * @deprecated   

 * @description  xyz

 */

// Include config file

$config_file = realpath('config.php');

if(file_exists($config_file) && !defined('WB_URL'))

{

	require($config_file);

}

// 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, '/');

$sTmp = ($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/class.admin.php');

if(!class_exists('admin', false)){ include(WB_PATH.'/framework/class.admin.php'); }

require_once(WB_PATH.'/framework/functions.php');

// require_once(WB_PATH.'/framework/Database.php');

$admin = new admin('Addons', 'modules', false, false);

$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            = ' <span class="ok">OK</span> ';

$FAIL          = ' <span class="error">FAILED</span> ';

$DEFAULT_THEME = 'wb_theme';

$stepID = 0;

$filesRemove = array();

$aFilesToRemove = array();

$dirRemove = array(

/*

			'[TEMPLATE]/allcss/',

			'[TEMPLATE]/blank/',

			'[TEMPLATE]/round/',

			'[TEMPLATE]/simple/',

*/

			'[ADMIN]/themes/',

		 );

//

	$filesRemove['0'] = 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',

			'[MODULES]/droplets/js/mdcr.js',

		 );

	$aFilesToRemove = array_merge($filesRemove['0']);

// deleting files below only from less 2.8.4 stable

if(version_compare(WB_VERSION, '2.8.4', '<'))

{

	$filesRemove['1'] = 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'

		 );

	$aFilesToRemove = array_merge($aFilesToRemove,$filesRemove['1']);

}

/* 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 .= '<strong>'.strtoupper(strtok($class, ' ')).'</strong>';

	$msg .= $message.'</'.$element.'>';

	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[] = "<span>Adding field $sField to $sTable table</span>";

		$aDebugMessage[] = ($database->field_add($sTable, $sField, $sDescription) ? " $OK<br />" : " $FAIL!<br />");

	} else {

		$aDebugMessage[] = "<span>Modify field $sField to $sTable table</span>";

		$aDebugMessage[] = ($database->field_modify($sTable, $sField, $sDescription) ? " $OK<br />" : " $FAIL!<br />");

	}

	if($bDebugModus) {

		echo implode(PHP_EOL,$aDebugMessage);

	}

return;

}

?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">

<head>

<title>Upgrade script</title>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<style type="text/css">

html { overflow-y: scroll; /* Force firefox to always show room for a vertical scrollbar */ }

body {

	margin:0;

	padding:0;

	border:0;

	background: #EBF7FC;

	color:#000;

	font-family: 'Trebuchet MS', Verdana, Arial, Helvetica, Sans-Serif;

	font-size: small;

	height:101%;

}

#container {

	min-width:48em;

    width: 70%;

	background: #A8BCCB url(<?php echo WB_URL; ?>/templates/wb_theme/images/background.png) repeat-x;

	border:1px solid #000;

	color:#000;

	margin:2em auto;

	padding:0 20px;

	min-height: 500px;

	text-align:left;

}

.page {

	width:100%;

    overflow: hidden;

}

.content {

    padding: 10px;

}

p { line-height:1.5em; }

form {

	display: inline-block;

	line-height: 20px;

	vertical-align: baseline;

}

input[type="submit"].restart {

	background-color: #FFDBDB;

	font-weight: bold;

}

h1,h2,h3,h4,h5,h6 {

	font-family: Verdana, Arial, Helvetica, sans-serif;

	color: #26527D;

	margin-top: 1.0em;

	margin-bottom: 0.1em;

}

h1 { font-size:150%; }

h2 { font-size: 130%; border-bottom: 1px #CCC solid; }

h3 { font-size: 110%; font-weight: bold; }

textarea {

	width:100%;

	border: 2px groove #0F1D44;

	padding: 2px;

	color: #000;

	font-weight: normal;

}

.ok, .error { font-weight:bold; }

.ok { color:green; }

.error { color:red; }

.check { color:#555; }

span.ok,

span.error {

    margin-left: 0em;

}

.warning {

	background:#FFDBDB;

	padding:1em;

	margin-top:0.5em;

	border: 1px solid #DB0909;

}

.info {

	background:#C7F4C7;

	padding:1em;

	margin-top:0.5em;

	border: 1px solid #277A29;

}

</style>

</head>

<body>

<div id="container">

<div class="page">

<img src="<?php echo WB_URL; ?>/templates/wb_theme/images/logo.png" alt="WebsiteBaker Project" />

<div class="content">

<h1>WebsiteBaker Upgrade</h1>

<?php

	if( version_compare( WB_VERSION, '2.7', '<' )) {

		status_msg('<strong>Warning:</strong><br />It is not possible to upgrade from WebsiteBaker Versions before 2.7.<br />For upgrading to version '.VERSION.' you must upgrade first to v.2.7 at least!!!', 'warning', 'div');

		echo '<br /><br />';

		echo "</div>

		</div>

		</div>

		</body>

		</html>

		";

		exit();

	}

?>

<p class="info">This script upgrades an existing WebsiteBaker <strong> <?php echo $oldRevision; ?></strong> installation to the <strong> <?php echo $newRevision ?> </strong>.<br />The upgrade script alters the existing WB database to reflect the changes introduced with WB 2.8.x</p>

<?php

/**

 * Check if disclaimer was accepted

 */

$bDebugModus = false;

$bDebugModus = ( (isset($_POST['debug_confirmed']) && $_POST['debug_confirmed'] == 'debug') ? true : false);

if (!(isset($_POST['backup_confirmed']) && $_POST['backup_confirmed'] == 'confirmed')) { ?>

<h2>Step 1: Backup your files</h2>

<h5 class="warning">It is highly recommended to <strong>create a manual backup</strong> of the entire <strong class="error"><?php echo  PAGES_DIRECTORY ?>/</strong> folder and the <strong>MySQL database</strong> before proceeding.</h5>

<p><strong class="error">Note: </strong>The upgrade script alters some settings of your existing database!!! You need to confirm the disclaimer before proceeding.</p>

<form action="<?php echo $_SERVER['SCRIPT_NAME'];?>" method="post">

<textarea cols="92" rows="5">DISCLAIMER: The WebsiteBaker upgrade script 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. One needs to confirm that a manual backup of the <?php echo  PAGES_DIRECTORY ?>/ folder (including all files and subfolders contained in it) and backup of the entire WebsiteBaker MySQL database was created before you can proceed.</textarea>

<br /><br /><input name="backup_confirmed" type="checkbox" value="confirmed" />&nbsp;<strong>I confirm that a manual backup of the <?php echo  PAGES_DIRECTORY ?>/ folder and the MySQL database was created.</strong>

<br /><br /><input name="debug_confirmed" type="checkbox" value="debug" />&nbsp;<strong>Here you can get more details during running upgrade.</strong>

<br /><br /><input name="send" type="submit" value="Start upgrade script" />

</form>

<br />

<?php

	status_msg('<strong> Notice:</strong><br />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 "<br /><br /></div>

	</div>

	</div>

	</body>

	</html>";

	exit();

}

/**********************************************************

 *  - check tables coming with WebsiteBaker

 */

	$aMissingTables = UpgradeHelper::existsAllTables($aPackage);

	if( sizeof($aMissingTables) == 0){

        echo '<h4 style="margin-left:0;">NOTICE: '.sizeof($aPackage).' total tables included in package are successfully installed into your database `'.$database->DbName.'` '.$OK.'</h4>';

    } else {

        status_msg('<strong>:</strong><br />can\'t run Upgrade, missing tables', 'warning', 'div');

        echo '<h4>Missing required tables. You can install them in backend->addons->modules.<br />';

        echo 'Or if you uploaded per FTP install possible by backend->addons->modules->advanced.<br />';

        echo 'First rename or delete the upgrade-script.php, so the script can\'t start automatically by backend<br />';

        echo 'After installing missing tables upload and run again upgrade-script.php<br /><br /></h4>';

        echo '<h4 class="warning">';

        echo 'Missing required tables.<br /><br />';

        echo 'TABLE `'.implode('` missing! '.$FAIL.'<br />TABLE `',$aMissingTables).'` missing! '.$FAIL;

        echo '<br /><br /></h4>';

        echo '<br /><br />';

        if(isset($_SERVER['SCRIPT_NAME'])) {

        	echo '<form action="'.$_SERVER['SCRIPT_NAME'].'/">';

        	echo '&nbsp;<input type="submit" value="Start upgrade again" />';

        	echo '</form>';

        }

        if(defined('ADMIN_URL')) {

        	echo '<form action="'.ADMIN_URL.'/index.php" method="post">';

        	echo '&nbsp;<input name="backend_send" type="submit" value="kick me to the Backend" />';

        	echo '</form>';

        }

        echo "<br /><br /></div>

        </div>

        </div>

        </body>

        </html>";

		exit();

	}

echo '<h3>Step '.(++$stepID).': Setting default_theme</h3>';

$aDebugMessage = array();

	/**********************************************************

	 *  - Adding field default_theme to settings table

	 */

	$aDebugMessage[] = '<div style="margin-left:2em;">';

	$aDebugMessage[] = "<br /><span><strong>Adding default_theme to settings table</strong></span>";

	// db_update_key_value('settings', 'default_theme', $DEFAULT_THEME);

	$cfg = array(

		'default_theme' => defined('DEFAULT_THEME')&& (DEFAULT_THEME!='') ? DEFAULT_THEME : $DEFAULT_THEME

	);

	$aDebugMessage[] = (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");

	$aDebugMessage[] = '</div>';

if($bDebugModus) {

	echo implode(PHP_EOL,$aDebugMessage);

}

$aDebugMessage = array();

echo'<h3>Step '.(++$stepID).': Updating core table included in package</h3>';

	/**********************************************************

	 *  - Adding field sec_anchor to settings table

	 */

	echo '<div style="margin-left:2em;">';

	echo "<h4>Adding/updating entries on table settings</h4>";

	$aDebugMessage[] = "<span>Adding/updating sec_anchor to settings table</span>";

	$cfg = array(

		'sec_anchor' => defined('SEC_ANCHOR')&& (SEC_ANCHOR!='') ? SEC_ANCHOR : 'section_'

	);

	$aDebugMessage[] = (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");

	/**********************************************************

	 *  - Adding redirect timer to settings table

	 */

	$aDebugMessage[] = "<span>Adding/updating redirect timer to settings table</span>";

	$cfg = array(

		'redirect_timer' => defined('REDIRECT_TIMER')&& (REDIRECT_TIMER!='') ? REDIRECT_TIMER : '1500'

	);

	$aDebugMessage[] = (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");

	/**********************************************************

	 *  - Adding default_time_formatr to settings table

	 */

	$aDebugMessage[] = "<span>Adding/updating default_time_format to settings table</span>";

	$cfg = array(

		'default_time_format' => defined('DEFAULT_TIME_FORMAT')&& (DEFAULT_TIME_FORMAT!='') ? DEFAULT_TIME_FORMAT : 'h:i A'

	);

	$aDebugMessage[] = (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");

	/**********************************************************

	 *  - Adding rename_files_on_upload to settings table

	 */

	$aDebugMessage[] = "<span>Adding/Updating rename_files_on_upload to settings table</span>";

	$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'

		);

	}

	$aDebugMessage[] = (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");

	/**********************************************************

	 *  - Adding mediasettings to settings table

	 */

	$aDebugMessage[] = "<span>Adding/updating mediasettings to settings table</span>";

	$cfg = array(

		'mediasettings' => (defined('MEDIASETTINGS')&& (MEDIASETTINGS!='') ? MEDIASETTINGS : ''),

	);

	$aDebugMessage[] = (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");

	/**********************************************************

	 *  - Adding fingerprint_with_ip_octets to settings table

	 */

	$aDebugMessage[] = "<span>Adding/updating fingerprint_with_ip_octets to settings table</span>";

	$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 : '')

	);

	$aDebugMessage[] = (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");

	/**********************************************************

	 *  - Adding page_icon_dir to settings table

	 */

	$aDebugMessage[] = "<span>Adding/updating page_icon_dir to settings table</span>";

	$cfg = array(

		'page_icon_dir' => (defined('PAGE_ICON_DIR')&& (PAGE_ICON_DIR!='') ? PAGE_ICON_DIR : '/templates/*/title_images'),

	);

	$aDebugMessage[] = (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");

	/**********************************************************

	 *  - Adding page_extended to settings table

	 */

	$aDebugMessage[] = "<span>Adding/updating page_extendet to settings table</span>";

	$cfg = array(

		'page_extendet' => (defined('PAGE_EXTENDET') ? PAGE_EXTENDET : 'true'),

	);

	$aDebugMessage[] = (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");

	/**********************************************************

	 *  - Adding wbmail_signature to settings table

	 */

	$aDebugMessage[] = "<span>Adding/updating wbmail_signature to settings table</span>";

	$cfg = array(

		'wbmail_signature' => (defined('WBMAIL_SIGNATURE')&& (WBMAIL_SIGNATURE!='') ? WBMAIL_SIGNATURE : '')

	);

	$aDebugMessage[] = (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");

	/**********************************************************

	 *  - Adding confirmed_registration to settings table

	 */

	$aDebugMessage[] = "<span>Adding/updating confirmed_registration to settings table</span>";

	$cfg = array(

		'confirmed_registration' => (defined('CONFIRMED_REGISTRATION') ? CONFIRMED_REGISTRATION : '0')

	);

	$aDebugMessage[] = (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");

	/**********************************************************

	 *  - Adding dev_infos to settings table

	 */

	$aDebugMessage[] = "<span>Adding/updating dev_infos to settings table</span>";

	$cfg = array(

		'dev_infos' => (defined('DEV_INFOS') ? DEV_INFOS : 'false')

	);

    $aDebugMessage[] = (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");

if($bDebugModus) {

    echo implode(PHP_EOL,$aDebugMessage);

}

echo '</div>';

$aDebugMessage = array();

if(version_compare(WB_REVISION, REVISION, '<='))

{

	echo '<div style="margin-left:2em;">';

	/**********************************************************

	 *  - Update search no results database filed to create

	 *  valid XHTML if search is empty

	 */

	if (version_compare(WB_VERSION, '2.8', '<'))

	{

		echo "<h4>Adding/updating fields on table search</h4>";

		echo "Updating database field `no_results` on search table: ";

		$search_no_results = addslashes('<tr><td><p>[TEXT_NO_RESULTS]</p></td></tr>');

		$sql  = 'UPDATE `'.TABLE_PREFIX.'search` ';

		$sql .= 'SET `value`=\''.$search_no_results.'\' ';

		$sql .= 'WHERE `name`=\'no_results\'';

		echo ($database->query($sql)) ? " $OK<br />" : " $FAIL!<br />";

	}

	$aDebugMessage = array();

	echo "<h4>Adding/updating field on table pages</h4>";

	/**********************************************************

	 *  - 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 "page_code" to table "pages"

	 */

	$table_name = TABLE_PREFIX.'pages';

	$field_name = 'page_code';

	$description = "INT NOT NULL DEFAULT '0' AFTER `language`";

	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);

	}

	$aDebugMessage = array();

	/**********************************************************

	 * modify wrong strucre on table sections

	 * wrong structure let crash wb

	 */

	echo "<h4>Change field structure on table sections</h4>";

	$table_name = TABLE_PREFIX.'sections';

	$description = "VARCHAR( 255 ) NOT NULL DEFAULT ''";

	$aDebugMessage[] = "<span>Modify field module on sections table</span>";

	$aDebugMessage[] = ($database->field_modify($table_name, 'module', $description) ? " $OK<br />" : " $FAIL!<br />");

	$aDebugMessage[] = "<span>Modify field block on sections table</span>";

	$description = "int(11) NOT NULL DEFAULT '1'";

	$aDebugMessage[] = ($database->field_modify($table_name, 'block', $description) ? " $OK<br />" : " $FAIL!<br />");

	$description = "int(11) NOT NULL DEFAULT '0'";

	$aDebugMessage[] = "<span>Modify field publ_start on sections table</span>";

	$aDebugMessage[] = ($database->field_modify($table_name, 'publ_start', $description) ? " $OK<br />" : " $FAIL!<br />");

	$aDebugMessage[] = "<span>Modify field publ_end on sections table</span>";

	$aDebugMessage[] = ($database->field_modify($table_name, 'publ_end', $description) ? " $OK<br />" : " $FAIL!<br />");

	if($bDebugModus) {

		echo implode(PHP_EOL,$aDebugMessage);

	}

	echo '</div>';

}

if(version_compare(WB_REVISION, REVISION, '<='))

{

	$aDebugMessage = array();

	echo '<h3>Step '.(++$stepID).': Updating structure in table users/groups</h3>';

	/**********************************************************

	 * Modify Administrator on groups table

	 */

	echo '<div style="margin-left:2em;">';

	echo "<h4>Updating Administrator group permissions on table groups</h4>";

	$aDebugMessage[] = "<span>Modify Administrator on groups table</span>";

	$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<br />" : " $FAIL!<br />";

	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);

	}

	echo '</div>';

	$aDebugMessage = array();

	/**********************************************************

	 *   `confirm_code` VARCHAR(32) NOT NULL DEFAULT '',

	 *   `confirm_timeout` INT(11) NOT NULL DEFAULT '0',

	 */

	echo '<div style="margin-left:2em;">';

	echo "<h4>Change field structure on table users</h4>";

	$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);

	}

	echo '</div>';

	$aDebugMessage = array();

	/**********************************************************

	* Updating group_id in table users

	*/

	echo '<div style="margin-left:2em;">';

	echo "<h4>Updating users groups permissions on table groups</h4>";

	    $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<br />" : " $FAIL!<br />";

        }

        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 = "<span>Updating group_id ".$TEXT['DISPLAY_NAME']." " .$aUsers[$user_id]['display_name']."</span>";

                $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<br />" : $sMessage." $FAIL!<br />";

        }

        unset($aUsers);

	$aDebugMessage[] = '</div>';

	if($bDebugModus) {

	// $aDebugMessage[] =

	    echo implode(PHP_EOL,$aDebugMessage);

	}else {

	    echo '<span><strong>'.$iTotalUsers.' users updating the groups</strong></span>'." $OK<br />";

	    echo '</div>';

	}

}

$aDebugMessage = array();

echo '<h3>Step '.(++$stepID).': Updating access and protected files in folders</h3>';

echo '<div style="margin-left:2em;">';

	/**********************************************************

	* upgrade media directory index protect files

	*/

	$dir = (WB_PATH.MEDIA_DIRECTORY);

	echo '<h4>Upgrade media directory '.MEDIA_DIRECTORY.'/ index.php protect files</h4>';

	$aDebugMessage = rebuildFolderProtectFile($dir);

	if( sizeof( $aDebugMessage ) ){

		echo '<span><strong>Upgrade '.sizeof( $aDebugMessage ).' directory '.MEDIA_DIRECTORY.'/ protect files</strong></span>'." $OK<br />";

	} else {

		echo '<span><strong>Upgrade directory '.MEDIA_DIRECTORY.'/ protect files</strong></span>'." $FAIL!<br />";

		echo implode ('<br />',$aDebugMessage);

	}

    $aDebugMessage = array();

    /**********************************************************

     * upgrade pages directory index access files

     */

	echo '<h4>Upgrade pages directory '.PAGES_DIRECTORY.'/  protect and access files</h4>';

    /**********************************************************

     *  - Reformat/rebuild all existing access files

     */

    $sPagePath = (defined('PAGES_DIRECTORY') && (PAGES_DIRECTORY != '') ? PAGES_DIRECTORY : '');

    $msg = rebuild_all_accessfiles();

	echo '<strong>'.implode ('<br />',$msg).'</strong>';

    echo '</div>';

	/* *****************************************************************************

	 * - check for deprecated / never needed files

	 */

	$iLoaded = sizeof($aFilesToRemove);

	if($iLoaded) {

		echo '<h3>Step '.(++$stepID).': Remove deprecated and outdated files</h3>';

		$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 '<div style="margin-left:2em;">';

		echo '<h4>Search '.$iLoaded.' deprecated and outdated files</h4>';

		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.'<br />';

			}

		}

		$iRemove = $iFound-$iFailed;