WB 2.08.x

22 Sep-2012 Build 1765 Dietmar Woellbrink (Luisehahne)

! recoded module news,form,wysiwyg upgrade to work with upgrade-script

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

if(!defined('REVISION')) define('REVISION', '1765');

    $iErrorReporting = error_reporting(0);

        $retval = unlink($directory);

        clearstatcache();

        error_reporting($iErrorReporting);

        return $retval;

        error_reporting($iErrorReporting);

        error_reporting($iErrorReporting);

                $retval = rmdir($directory);

                error_reporting($iErrorReporting);

                return $retval;

                error_reporting($iErrorReporting);

        error_reporting($iErrorReporting);

	$retVal = is_dir($dir_name);

		$retVal = mkdir($dir_name, $dir_mode, $recursive);

		      } else {

	$retVal = array();

//					$admin->print_error($MESSAGE['PAGES_CANNOT_CREATE_ACCESS_FILE_FOLDER']);

                    $retVal[] = $MESSAGE['MEDIA_DIR_ACCESS_DENIED'];

//		$admin->print_error($MESSAGE['PAGES_CANNOT_CREATE_ACCESS_FILE']);

        $retVal[] = $MESSAGE['PAGES_CANNOT_CREATE_ACCESS_FILE'];

	return $retVal;

			$retVal = intval($database->query($sql) ? true : false);

        return $retVal;

			$retVal = intval($database->query($sql) ? true : false);

			$retVal = intval($database->query($sql) ? true : false);

if(!function_exists('rebuild_all_accessfiles')){

	function rebuild_all_accessfiles() {

        global $database;

    	$retVal = array();

    	/**

    	 * try to remove access files and build new folder protect files

    	 */

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

    	if(($sTempDir!='') && is_writeable(WB_PATH.$sTempDir)==true) {

    	 	if(rm_full_dir (WB_PATH.$sTempDir, true )==false) {

    			$retVal[] = '<span><strong>Could not delete existing access files</strong></span>';

    	 	}

    	}

		$retVal[] = createFolderProtectFile(rtrim( WB_PATH.PAGES_DIRECTORY,'/') );

    	/**

    	 * Reformat/rebuild all existing access files

    	 */

        $sql = 'SELECT `page_id`,`root_parent`,`link`, `level` FROM `'.TABLE_PREFIX.'pages` ORDER BY `link`';

        if (($oPage = $database->query($sql)))

        {

            $x = 0;

            while (($page = $oPage->fetchRow(MYSQL_ASSOC)))

            {

                // Work out level

                $level = level_count($page['page_id']);

                // Work out root parent

                $root_parent = root_parent($page['page_id']);

                // Work out page trail

                $page_trail = get_page_trail($page['page_id']);

                // Update page with new level and link

                $sql  = 'UPDATE `'.TABLE_PREFIX.'pages` SET ';

                $sql .= '`root_parent` = '.$root_parent.', ';

                $sql .= '`level` = '.$level.', ';

                $sql .= '`page_trail` = "'.$page_trail.'" ';

                $sql .= 'WHERE `page_id` = '.$page['page_id'];

                if(!$database->query($sql)) {}

                $filename = WB_PATH.PAGES_DIRECTORY.$page['link'].PAGE_EXTENSION;

                $retVal = create_access_file($filename, $page['page_id'], $page['level']);

                $x++;

            }

            $retVal[] = '<span><strong>Number of new formated access files: '.$x.'</strong></span>';

        }

    return $retVal;

	}

}

if(!function_exists('upgrade_modules')){

	function upgrade_modules($aModuleList) {

        global $database;

    	foreach($aModuleList 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)) {

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

    			}

    		}

    	}

    }

}

if(!function_exists('mod_wysiwyg_upgrade'))

{

    function mod_wysiwyg_upgrade () {

        global $database,$bDebugModus;

        $callingScript = $_SERVER["SCRIPT_NAME"];

        // check if upgrade startet by upgrade-script to echo a message

        $tmp = 'upgrade-script.php';

        $globalStarted = substr_compare($callingScript, $tmp,(0-strlen($tmp)),strlen($tmp)) === 0;

        $msg = array();

        $aTable = array('mod_wysiwyg');

        for($x=0; $x<sizeof($aTable);$x++) {

        	if(($sOldType = $database->getTableEngine(TABLE_PREFIX.$aTable[$x]))) {

        		if(('myisam' != strtolower($sOldType))) {

        			if(!$database->query('ALTER TABLE `'.TABLE_PREFIX.$aTable[$x].'` Engine = \'MyISAM\' ')) {

        				$msg[] = $database->get_error();

        			} else{

                        $msg[] = 'TABLE `'.TABLE_PREFIX.$aTable[$x].'` changed to Engine = \'MyISAM\'';

        			}

        		} else {

                 $msg[] = 'TABLE `'.TABLE_PREFIX.$aTable[$x].'` has Engine = \'MyISAM\'';

        		}

        	} else {

        		$msg[] = $database->get_error();

        	}

        }

        $sTable = TABLE_PREFIX.'mod_wysiwyg';

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

            $sql = 'ALTER TABLE `'.DB_NAME.'`.`'.$sTable.'` DROP PRIMARY KEY';

            if(!$database->query($sql)) {

                $msg[] = ''.$database->get_error().'';

            }

        }

        if(!$database->index_add($sTable, '', 'section_id', 'PRIMARY')) {

        	$msg[] = ''.$database->get_error().'';

        } else {

            $msg[] = 'Create PRIMARY KEY ( `section_id` )';

        }

        // change internal absolute links into relative links

        $sTable = TABLE_PREFIX.'mod_wysiwyg';

        $sql  = 'UPDATE `'.$sTable.'` ';

        $sql .= 'SET `content` = REPLACE(`content`, \'"'.WB_URL.MEDIA_DIRECTORY.'\', \'"{SYSVAR:MEDIA_REL}\')';

        if (!$database->query($sql)) {

        	$msg[] = ''.$database->get_error().'';

        } else {

            $msg[] = 'Change internal absolute links into relative links';

        }

        // only for upgrade-script

        if($globalStarted) {

            if($bDebugModus) {

                foreach($msg as $title) {

                    echo '<strong>'.$title.'</strong><br />';

                }

            }

        }

        return $msg;

    }

// ------------------------------------

$msg = mod_wysiwyg_upgrade();

// Must include code to stop this file being accessed directly

if(!defined('WB_PATH')) {

	require_once(dirname(dirname(dirname(__FILE__))).'/framework/globalExceptionHandler.php');

	throw new IllegalFileException();

if(!function_exists('mod_form_upgrade'))

{

    function mod_form_upgrade() {

        $msg = array();

        global $database,$bDebugModus;

        $callingScript = $_SERVER["SCRIPT_NAME"];

        // check if upgrade startet by upgrade-script to echo a message

        $tmp = 'upgrade-script.php';

        $globalStarted = substr_compare($callingScript, $tmp,(0-strlen($tmp)),strlen($tmp)) === 0;

        $aTable = array('mod_form_fields','mod_form_settings','mod_form_submissions');

        for($x=0; $x<sizeof($aTable);$x++) {