WB 2.08.x

$bDebugModus = false;

$aPackage = array (

$aFilesToRemove = array();

if(version_compare(WB_REVISION, '1762', '<'))

{

    $filesRemove['0'] = array(

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

function status_msg($message, $class='check', $element='div')

    global $database,$aPackage;

// if prefix inludes '_' or '%'

    $search_for = addcslashes ( TABLE_PREFIX, '%_' );

    $get_result = $database->query( 'SHOW TABLES LIKE "'.$search_for.'%"');

    // $get_result = $database->query( "SHOW TABLES FROM ".DB_NAME);

    $all_tables = array();

    $aTable = array();

    if($get_result->numRows() > 0)

    {

        while ($data = $get_result->fetchRow()) {

            $tmp = str_replace(TABLE_PREFIX, '', $data[0]);

            if(in_array($tmp,$aPackage)) {

                $all_tables[] = $tmp;

            } else {

                $aTable[] = $tmp;

    }

    return array_merge ( $all_tables, $aTable );

	min-width:48em;

    width: 70%;

	padding:0 20px;

.page {

	width:100%;

    overflow: hidden;

}

.content {

    padding: 10px;

}

	color: #26527D;

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

textarea {

	width:100%;

    border: 2px groove #0F1D44;

    padding: 2px;

    color: #000;

    font-weight: normal;

}

span.ok,

span.error {

    margin-left: 0em;

}

	padding:1em;

	border: 1px solid #DB0909;

	background:#C7F4C7;

	padding:1em;

	border: 1px solid #277A29;

<div class="page">

<div class="content">

        </div>

        </div>

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

$bDebugModus = false;

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

<p>It is highly recommended to <strong>create a manual backup</strong> of the entire <strong><?php echo  PAGES_DIRECTORY ?>/ folder</strong> and the <strong>MySQL database</strong> before proceeding.<br /><strong class="error">Note: </strong>The upgrade script alters some settings of your existing database!!! You need to confirm the disclaimer before proceeding.</p>

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

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

    </div>

    </div>

// if(sizeof($all_tables) < sizeof($aTable)) { $all_tables = check_wb_tables(); }

 *  - check tables coming with WebsiteBaker

    $aTable = array();

    foreach ($all_tables as $data) {

        $tmp = str_replace(TABLE_PREFIX, '', $data);

        if(in_array($tmp,$aPackage)) {

            $aTable[] = $tmp;

        }

    }

    if( (sizeof($all_tables) >= sizeof($aPackage)) && (sizeof($aTable) == sizeof($aPackage)) )

        echo '<h4 style="margin-left:0;">NOTICE: Your database '.DB_NAME.' has '.sizeof($all_tables).' '.$check_text.' tables from '.sizeof($aPackage).' included in package '.$OK.'</h4>';

        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 'After installingT again run upgrade-script.php</h4>';

        $result = array_diff ( $aPackage, $aTable );

            echo 'TABLE ´'.TABLE_PREFIX.$val.'´ '.$FAIL.'<br>';

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

        </div>

        </div>

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

if($bDebugModus) {

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

     *  - Adding field default_theme to settings table

     */

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

    echo "<br /><span><strong>Adding default_theme to settings table</strong></span>";

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

    echo (db_update_key_value( 'settings', 'default_theme', $DEFAULT_THEME ) ? " $OK<br />" : " $FAIL!<br />");

    echo '</div>';

}

    echo '<h3>Step '.(++$stepID).': Updating core tables</h3>';

if($bDebugModus) {

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

     *  - Adding field sec_anchor to settings table

     */

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

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

    echo "<span>Adding/updating sec_anchor to settings table</span>";

    $cfg = array(

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

    );

    echo (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");

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

     *  - Adding redirect timer to settings table

     */

    echo "<span>Adding/updating redirect timer to settings table</span>";

    $cfg = array(

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

    );

    echo (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");

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

     *  - Adding rename_files_on_upload to settings table

     */

    echo "<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 : 'ph.*?,cgi,pl,pm,exe,com,bat,pif,cmd,src,asp,aspx,js')

    );

    echo (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");

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

     *  - Adding mediasettings to settings table

     */

    echo "<span>Adding/updating mediasettings to settings table</span>";

    $cfg = array(

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

    );

    echo (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");

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

     *  - Adding fingerprint_with_ip_octets to settings table

     */

    echo "<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 : '')

    );

    echo (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");

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

     *  - Adding page_icon_dir to settings table

     */

    echo "<span>Adding/updating page_icon_dir to settings table</span>";

    $cfg = array(

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

    );

    echo (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");

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

     *  - Adding page_extended to settings table

     */

    echo "<span>Adding/updating page_extended to settings table</span>";

    $cfg = array(

    	'page_extended' => (defined('PAGE_EXTENDED') ? PAGE_EXTENDED : 'true'),

    );

    echo (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");

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

     *  - Adding website_signature to settings table

     */

    echo "<span>Adding/updating website_signature to settings table</span>";

    $cfg = array(

    	'website_signature' => (defined('WEBSITE_SIGNATURE') && (WEBSITE_SIGNATURE=='') ? '' : WEBSITE_SIGNATURE)

    );

    echo (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");

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

     *  - Adding confirmed_registration to settings table

     */

    echo "<span>Adding/updating confirmed_registration to settings table</span>";

    $cfg = array(

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

    );

    echo (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");

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

     *  - Adding dev_infos to settings table

     */

    echo "<span>Adding/updating dev_infos to settings table</span>";

    $cfg = array(

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

    );

    echo (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");

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

     *  - Adding dev_infos to settings table

     */

    echo "<span>Adding/updating modules_upgrade_list to settings table</span>";

    $cfg = array(

    	'modules_upgrade_list' => (defined('MODULES_UPGRADE_LIST') ? MODULES_UPGRADE_LIST : 'news')

    );

    echo (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");

    echo '</div>';

}

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

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

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

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

    echo "<h4>Adding/updating fiekds on table mod_menu_link</h4>";

		echo "<span>Adding field redirect_type to mod_menu_link table</span>";

		echo "<span>Modify field redirect_type to mod_menu_link table</span>";

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

	echo "<span>Modify field page_trail to pages table</span>";

		echo "<span>Adding field page_icon to pages table</span>";

		echo "<span>Modify field page_icon to pages table</span>";

		echo "<span>Adding field page_code to pages table</span>";

		echo "<span>Modify field page_code to pages table</span>";

		echo "<span>Adding field menu_icon_0 to pages table</span>";

		echo "<span>Modify field menu_icon_0 to pages table</span>";

		echo "<span>Adding field menu_icon_1 to pages table</span>";

		echo "<span>Modify field menu_icon_1 to pages table</span>";

		echo "<span>Adding field tooltip to pages table</span>";

		echo "<span>Modify field tooltip to pages table";

	echo "<span>Modify field admin_groups to pages table";

	echo "<span>Modify field admin_users to pages table</span>";

	echo "<span>Modify field viewing_groups to pages table</span>";

	echo "<span>Modify field viewing_users to pages table";

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

     * 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 ''";

	echo "<span>Modify field module on sections table</span>";

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

	echo "<span>Modify field block on sections table</span>";

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

	echo "<span>Modify field publ_start on sections table</span>";

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

	echo "<span>Modify field publ_end on sections table</span>";

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

    echo '</div>';

 * This part with changing in mod_wysiwyg will be removed in the final version

 * special workout for the tester

 *  - Remove/add PRIMARY KEY from/to "section_id" from table "mod_wysiwygs"

if($bDebugModus) {

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

    $sTable = TABLE_PREFIX.'mod_wysiwyg';

    $field_name = 'wysiwyg_id';

    if($database->field_exists($sTable, 'wysiwyg_id')) {

        if($database->index_exists($sTable, 'PRIMARY')) {

            echo "<span>Remove PRIMARY KEY from table mod_wysiwyg.wysiwyg_id</span>";

            echo $database->index_remove($sTable, 'PRIMARY') ? " $OK<br />" : " $FAIL!<br />";

        echo "<span>Remove field 'wysiwyg_id' from table mod_wysiwyg</span>";

        echo $database->field_remove($sTable, 'wysiwyg_id') ? " $OK<br />" : " $FAIL!<br />";

    }

    echo "<br /><span>Create PRIMARY KEY ( `section_id` ) on table mod_wysiwygs.</span>";

    echo $database->index_add($sTable, '', 'section_id', 'PRIMARY') ? " $OK<br />" : " $FAIL!<br />";

    echo '</div>';

}

echo '<h3>Step '.(++$stepID).': Updating acess 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>';

    $array = rebuildFolderProtectFile($dir);

    if( sizeof( $array ) ){

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

    } else {

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

    	print implode ('<br />',$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();

	print implode ('<br />',$msg);

    echo '</div>';

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

     * - check for deprecated / never needed files

     */

    if(sizeof($aFilesToRemove)) {

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

    	$searches = array(

    		'[ADMIN]',

    		'[MEDIA]',

    		'[PAGES]',

    		'[FRAMEWORK]',

    		'[MODULES]',

    		'[TEMPLATE]'

    	);

    	$replacements = array(

    		'/'.substr(ADMIN_PATH, strlen(WB_PATH)+1),

    		MEDIA_DIRECTORY,

    		PAGES_DIRECTORY,

    		'/framework',

    		'/modules',

    		'/templates'

    	);

    	foreach( $aFilesToRemove as $file )

    	{

			if( is_writable(WB_PATH.'/'.$file) ) {

				if(!unlink(WB_PATH.$file)) {

				} else {

					$msg .= $file.'<br />';

    			}

    	}

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

            </div>

            </div>

            </body>

            </html>

            ";

    }

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

            </div>

            </div>

            </body>

            </html>

            ";

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

     * upgrade modules if newer version is available

     * $aModuleList list of proofed modules

     */

    $sModuleList = 'news,wysiwyg,form';

    $aModuleList = explode(',', (defined('MODULES_UPGRADE_LIST') ? MODULES_UPGRADE_LIST : $sModuleList));

    echo '<h3>Step '.(++$stepID).': Upgrade proofed modules</h3>';

//	$aModuleList = array('news');

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

				echo '<h4>'.'Upgrade module \''.$sModul.'\' version '.$newModulVersion.'</h4>';

                echo '</div>';

	echo '<h3>Step '.(++$stepID).' : Reload all addons database entry (no upgrade)</h3><br />';

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

    $iFound = 0;

    $iLoaded = 0;

                $iFound++;

				$iLoaded = load_module(WB_PATH.'/modules/'.$file ) ? $iLoaded+1 : $iLoaded;

	echo '<span><strong>'.$iLoaded.' Modules reloaded,</span> found '.$iFound.' directories in folder /modules/</strong><br />';

    $iFound = 0;

    $iLoaded = 0;

                $iFound++;

				$iLoaded = (load_template(WB_PATH.'/templates/'.$file)==true) ? $iLoaded+1 : $iLoaded;

	echo '<span><strong>'.$iLoaded.' Templates reloaded,</span> found '.$iFound.' directories in folder /templates/</strong><br />';

    $iFound = 0;

    $iLoaded = 0;

                $iFound++;

				$iLoaded = load_language(WB_PATH.'/languages/'.$file) ? $iLoaded+1 : $iLoaded;

	echo '<span><strong>'.$iLoaded.' Languages reloaded,</span> found '.$iFound.' files in folder /languages/</strong><br />';

    echo '</div>';

echo '<h3>Step '.(++$stepID).': Update database version number </h3>';

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

echo '<br /><span><strong>Set database version number to '.VERSION.' '.SP.' '.' Revision ['.REVISION.'] : </strong></span>';

echo '</div>';

echo '<p style="font-size:140%;"><strong>Congratulations: The upgrade script is finished ...</strong></p>';

status_msg('<strong>:</strong><br />Please delete the file <strong>upgrade-script.php</strong> via FTP before proceeding.', 'warning', 'div');

// show buttons to go to the backend or frontend

echo '<br />';

if(defined('WB_URL')) {

	echo '<form action="'.WB_URL.'/">';

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

	echo '</form>';

}

if(defined('ADMIN_URL')) {

	echo '<form action="'.ADMIN_URL.'/">';

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

	echo '</form>';

}

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

</div>

</div>

</body>

</html>

";

exit();