WB 2.08.x

20-Feb-2008 Thomas Hornik

!	added workaround for language sorting-problem

20-Feb-2008	Christian Sommer

!	modified upgrade script and suppressed headers already send message (avoid issues with error reporting E_ALL)

#	added the FCKEditor module PHP connector fix found by the forum member Luisehahne (thanks man)

!	Updated upgrade script (added WB2.7 basic styles, pre-checks and disclaimer)

.error { color:red; }

.check { color:#555; }

.warning {

	width: 98%;

	background:#FFDBDB;

<p>will upgrade Website Baker 2.6.5 / 2.6.7 to version 2.7</p>

<?php

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

");

global $database;

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

 *  - Output Filter

 */

$table = TABLE_PREFIX .'mod_output_filter';

$database->query("DROP TABLE IF EXISTS `$table`");

);

// add default values to the module table

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

 *  - Form Modul

 */

db_add_field('success_email_subject', 'mod_form_settings', "VARCHAR(255) NOT NULL AFTER `email_subject`");

db_add_field('success_email_text', 'mod_form_settings', "TEXT NOT NULL AFTER `email_subject`");

db_add_field('success_email_from', 'mod_form_settings', "VARCHAR(255) NOT NULL AFTER `email_subject`");

db_add_field('success_email_to', 'mod_form_settings', "TEXT NOT NULL AFTER `email_subject`");

db_add_field('success_page', 'mod_form_settings', "TEXT NOT NULL AFTER `email_subject`");

db_add_field('email_fromname', 'mod_form_settings', "VARCHAR( 255 ) NOT NULL AFTER email_from");

db_add_field('success_email_fromname', 'mod_form_settings', "VARCHAR( 255 ) NOT NULL AFTER success_email_from");

if($database->query("ALTER TABLE `".TABLE_PREFIX."mod_form_settings` DROP `success_message`")) {

	echo 'Database field success_message droped successfully<br>';

	echo mysql_error().'<br />';

}

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

 *  - Add Admintools to Administrator group

 */

$full_system_permissions = 'pages,pages_view,pages_add,pages_add_l0,pages_settings,pages_modify,pages_intro,pages_delete,media,media_view,media_upload,media_rename,media_delete,media_create,addons,modules,modules_view,modules_install,modules_uninstall,templates,templates_view,templates_install,templates_uninstall,languages,languages_view,languages_install,languages_uninstall,settings,settings_basic,settings_advanced,access,users,users_view,users_add,users_modify,users_delete,groups,groups_view,groups_add,groups_modify,groups_delete,admintools';

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

 *  - Add Mailer Settings to settings table

 */

//delete rows to prevent double entries

$database->query("DELETE FROM ".TABLE_PREFIX."settings WHERE name = 'wbmailer_routine'");

$database->query("DELETE FROM ".TABLE_PREFIX."settings WHERE name = 'server_email'");

$database->query("DELETE FROM ".TABLE_PREFIX."settings WHERE name = 'wbmailer_smtp_username'");

$database->query("DELETE FROM ".TABLE_PREFIX."settings WHERE name = 'wbmailer_smtp_password'");

//add new rows with default values

$settings_rows=	"INSERT INTO `".TABLE_PREFIX."settings` "

." (name, value) VALUES "

." ('server_email', 'admin@yourdomain.com'),"		// avoid that mail provider (e.g. mail.com) reject mails like yourname@mail.com

." ('wbmailer_default_sendername', 'WB Mailer'),"

." ('wbmailer_smtp_auth', ''),"

." ('wbmailer_smtp_username', ''),"

." ('wbmailer_smtp_password', '')";

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

 *  - Reload all addons

echo '<br />Languages reloaded<br />';

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

 *  - End of upgrade script

 */

}

?>