Index: branches/2.8.x/wb/upgrade-script.php =================================================================== --- branches/2.8.x/wb/upgrade-script.php (revision 1225) +++ branches/2.8.x/wb/upgrade-script.php (revision 1226) @@ -1,458 +1,556 @@ - -* Copyright (C) 2009, Website Baker Org. e.V. -* http://start.websitebaker2.org/impressum-datenschutz.php -* Copyright (C) 2004-2009, Ryan Djurovich -* -* About WebsiteBaker -* -* Website Baker is a PHP-based Content Management System (CMS) -* designed with one goal in mind: to enable its users to produce websites -* with ease. -* -***************************************************************************** -* -***************************************************************************** -* WebsiteBaker Extra Information -* -* @author : thorn, Matthias Gallas, doc, Dietrich Roland Pehlke, Manuel Lang -* @platform : WebsiteBaker 2.8 -* -***************************************************************************** -* -***************************************************************************** -* LICENSE INFORMATION -* -* WebsiteBaker 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 2 -* of the License, or (at your option) any later version. -* -* WebsiteBaker 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, write to the Free Software -* Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. -*****************************************************************************/ - -@include_once('config.php'); - -// this function checks the basic configurations of an existing WB intallation -function status_msg($message, $class='check', $element='span') { - // returns a status message - echo '<'.$element .' class="' .$class .'">' .$message .''; -} - - -?> - - - -Upgrade script - - - - -
-Website Baker Logo - -

Website Baker Upgrade

-

This script upgrades an existing Website Baker Version 2.7 installation to the Version 2.8. The upgrade script alters the existing WB database to reflect the changes introduced with WB 2.8.

- - -

Step 1: Backup your files

-

It is highly recommended to create a manual backup of the entire /pages 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.

- -
- -

 I confirm that a manual backup of the /pages folder and the MySQL database was created. -

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

'; - exit; -} - -echo '

Step 2: Updating database entries

'; -define ("DEFAULT_THEME", "wb_theme"); -require_once('config.php'); -require_once(WB_PATH.'/framework/functions.php'); - -$OK = 'OK'; -$FAIL = 'FAILED'; - -// function to add a var/value-pair into settings-table -function db_add_key_value($key, $value) { - global $database; global $OK; global $FAIL; - $table = TABLE_PREFIX.'settings'; - $query = $database->query("SELECT value FROM $table WHERE name = '$key' LIMIT 1"); - if($query->numRows() > 0) { - echo "$key: already exists. $OK.
"; - return true; - } else { - $database->query("INSERT INTO $table (name,value) VALUES ('$key', '$value')"); - echo (mysql_error()?mysql_error().'
':''); - $query = $database->query("SELECT value FROM $table WHERE name = '$key' LIMIT 1"); - if($query->numRows() > 0) { - echo "$key: $OK.
"; - return true; - } else { - echo "$key: $FAIL!
"; - return false; - } - } -} - -// function to add a new field into a table -function db_add_field($field, $table, $desc) { - global $database; global $OK; global $FAIL; - $table = TABLE_PREFIX.$table; - $query = $database->query("DESCRIBE $table '$field'"); - if($query->numRows() == 0) { // add field - $query = $database->query("ALTER TABLE $table ADD $field $desc"); - echo (mysql_error()?mysql_error().'
':''); - $query = $database->query("DESCRIBE $table '$field'"); - echo (mysql_error()?mysql_error().'
':''); - if($query->numRows() > 0) { - echo "'$field' added. $OK.
"; - } else { - echo "adding '$field' $FAIL!
"; - } - } else { - echo "'$field' already exists. $OK.
"; - } -} - - -/********************************************************** - * - Adding field sec_anchor to settings table - */ -echo "
Adding sec_anchor to settings table
"; -$cfg = array( - 'sec_anchor' => 'wb_' -); -foreach($cfg as $key=>$value) { - db_add_key_value($key, $value); -} - - -/********************************************************** - * - Adding field default_theme to settings table - */ -echo "
Adding default_theme to settings table
"; -$cfg = array( - 'default_theme' => 'wb_theme' -); -foreach($cfg as $key=>$value) { - db_add_key_value($key, $value); -} - - -/********************************************************** - * - Adding redirect timer to settings table - */ -echo "
Adding redirect timer to settings table
"; -$cfg = array( - 'redirect_timer' => '1500' -); -foreach($cfg as $key=>$value) { - db_add_key_value($key, $value); -} - - -/********************************************************** - * - Adding mediasettings to settings table - */ -echo "
Adding mediasettings to settings table
"; -$cfg = array( - 'mediasettings' => '' -); -foreach($cfg as $key=>$value) { - db_add_key_value($key, $value); -} - - -/********************************************************** - * - Add field "redirect_type" to table "mod_menu_link" - */ -echo "
Adding field redirect_type to mod_menu_link table
"; -db_add_field('redirect_type', 'mod_menu_link', "INT NOT NULL DEFAULT '302' AFTER `target_page_id`"); - - -/********************************************************** - * - Update search no results database filed to create - * valid XHTML if search is empty - */ -echo "
Updating database field `no_results` of search table: "; -$search_no_results = addslashes('

[TEXT_NO_RESULTS]

'); -$sql = "UPDATE `" . TABLE_PREFIX . "search` SET `value` = '$search_no_results' WHERE `name`= 'no_results'"; -$database->query($sql); -echo ($database->query($sql)) ? " $OK
" : " $FAIL
"; - - -/********************************************************** - * - Update settings of News Modul - */ - -// These are the default setting -$header = ''."\n"; -$post_loop = ' - - - - - -'; -$footer = '
[TITLE][PUBLISHED_TIME], [PUBLISHED_DATE]
-[SHORT] -[TEXT_READ_MORE] -
- - - - - - -
[PREVIOUS_PAGE_LINK][OF][NEXT_PAGE_LINK]
'; -$post_header = addslashes(' - - - - - - - - - - -

[TITLE]

[GROUP_IMAGE]
[TEXT_POSTED_BY] [DISPLAY_NAME] ([USERNAME]) [TEXT_ON] [PUBLISHED_DATE]
[PAGE_TITLE] >> [GROUP_TITLE]
'); -$post_footer = '

[TEXT_LAST_CHANGED]: [MODI_DATE] [TEXT_AT] [MODI_TIME]

-[TEXT_BACK]'; -$comments_header = addslashes('

-

[TEXT_COMMENTS]

-'); -$comments_loop = addslashes(' - - - - - -'); -$comments_footer = '
[TITLE][TEXT_BY] [DISPLAY_NAME] [TEXT_ON] [DATE] [TEXT_AT] [TIME]
[COMMENT]
-
[TEXT_ADD_COMMENT]'; -$comments_page = '

[TEXT_COMMENT]

-

[POST_TITLE]

-
'; - - -// Insert default settings into database -$query_dates = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_news_settings where section_id != 0 and page_id != 0"); -while($result = $query_dates->fetchRow()) { - - echo "
Add default settings to database for news section_id= ".$result['section_id']."
"; - $section_id = $result['section_id']; - - if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `header` = '$header' WHERE `section_id` = $section_id")) { - echo 'Database data header added successfully'; - } - echo mysql_error().'
'; - - if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `post_loop` = '$post_loop' WHERE `section_id` = $section_id")) { - echo 'Database data post_loop added successfully'; - } - echo mysql_error().'
'; - - if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `footer` = '$footer' WHERE `section_id` = $section_id")) { - echo 'Database data footer added successfully'; - } - echo mysql_error().'
'; - - if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `post_header` = '$post_header' WHERE `section_id` = $section_id")) { - echo 'Database data post_header added successfully'; - } - echo mysql_error().'
'; - - if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `post_footer` = '$post_footer' WHERE `section_id` = $section_id")) { - echo 'Database data post_footer added successfully'; - } - echo mysql_error().'
'; - - if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `comments_header` = '$comments_header' WHERE `section_id` = $section_id")) { - echo 'Database data comments_header added successfully'; - } - echo mysql_error().'
'; - - if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `comments_loop` = '$comments_loop' WHERE `section_id` = $section_id")) { - echo 'Database data comments_loop added successfully'; - } - echo mysql_error().'
'; - - if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `comments_footer` = '$comments_footer' WHERE `section_id` = $section_id")) { - echo 'Database data comments_footer added successfully'; - } - echo mysql_error().'
'; - - if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `comments_page` = '$comments_page' WHERE `section_id` = $section_id")) { - echo 'Database data comments_page added successfully'; - } - echo mysql_error().'
'; - -} - -/********************************************************** - * - Set Version to WB 2.8 - */ -echo "
Update database version number to 2.8 : "; -$version = '2.8'; -echo ($database->query("UPDATE `".TABLE_PREFIX."settings` SET `value` = '$version' WHERE `name` = 'wb_version'")) ? " $OK
" : " $FAIL
"; - - -/********************************************************** - * - install droplets - */ -echo "
Install droplets
"; - -$result = $database->query( "SHOW TABLES FROM ".DB_NAME); -$all_tables = array(); -while ($data = $result->fetchRow()) $all_tables[] = $data[0]; - - $file_name = (!in_array ( TABLE_PREFIX."mod_droplets", $all_tables)) ? "install.php" : "upgrade.php"; - require_once (WB_PATH."/modules/droplets/".$file_name); - -/********************************************************** - * - Reload all addons - */ - -//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 != '' AND substr($file, 0, 1) != '.' AND $file != 'admin.php' AND $file != 'index.php') { - load_module(WB_PATH.'/modules/'.$file); - } - } - closedir($handle); -} -echo '
Modules reloaded
'; - -//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') { - load_template(WB_PATH.'/templates/'.$file); - } - } - closedir($handle); -} -echo '
Templates reloaded
'; - -//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 substr($file, 0, 1) != '.' AND $file != 'index.php') { - load_language(WB_PATH.'/languages/'.$file); - } - } - closedir($handle); -} -echo '
Languages reloaded
'; - - -/********************************************************** - * - End of upgrade script - */ -echo '

Congratulations: The upgrade script is finished ...

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

 

'; - -?> - -
- + +* Copyright (C) 2009, Website Baker Org. e.V. +* http://start.websitebaker2.org/impressum-datenschutz.php +* Copyright (C) 2004-2009, Ryan Djurovich +* +* About WebsiteBaker +* +* Website Baker is a PHP-based Content Management System (CMS) +* designed with one goal in mind: to enable its users to produce websites +* with ease. +* +***************************************************************************** + +***************************************************************************** +* LICENSE INFORMATION +* +* WebsiteBaker 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 2 +* of the License, or (at your option) any later version. +* +* WebsiteBaker 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, write to the Free Software +* Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. +**************************************************************************** + +***************************************************************************** +* WebsiteBaker Extra Information +* +* added line 385-386 update postfiles to new format +* +* +*****************************************************************************/ + +/** + * + * @category backend + * @package installation + * @author Ryan Djurovich + * @copyright 2004-2009, Ryan Djurovich + * @copyright 2009, Website Baker Org. e.V. + * @version $Id$ + * @platform WebsiteBaker 2.8.x + * @requirements >= PHP 4.3.4 + * @license http://www.gnu.org/licenses/gpl.html + * + * + */ + +@require_once('config.php'); + +// this function checks the basic configurations of an existing WB intallation +function status_msg($message, $class='check', $element='span') { + // returns a status message + echo '<'.$element .' class="' .$class .'">' .$message .''; +} + +$version = '2.8.1'; +// database tables including in WB package +$table_list = array ( + 'settings','groups','addons','pages','sections','search','users', + 'mod_captcha_control','mod_code','mod_droplets','mod_form_fields', + 'mod_form_settings','mod_form_submissions','mod_jsadmin','mod_menu_link', + 'mod_news_comments','mod_news_groups','mod_news_posts','mod_news_settings', + 'mod_output_filter','mod_wrapper','mod_wysiwyg' +); + +// analyze/check database tables +function mysqlCheckTables( $dbName ) +{ + global $table_list; + $table_prefix = TABLE_PREFIX; + $sql = "SHOW TABLES FROM " . $dbName; + $result = @mysql_query( $sql ); + $data = array(); + $x = 0; + + while( ( $row = @mysql_fetch_array( $result, MYSQL_NUM ) ) == true ) + { + $tmp = str_replace($table_prefix, '', $row[0]); + + if( stristr( $row[0], $table_prefix )&& in_array($tmp,$table_list) ) + { + $sql = "CHECK TABLE " . $dbName . '.' . $row[0]; + $analyze = @mysql_query( $sql ); + $rowFetch = @mysql_fetch_array( $analyze, MYSQL_ASSOC ); + $data[$x]['Op'] = $rowFetch["Op"]; + $data[$x]['Msg_type'] = $rowFetch["Msg_type"]; + $msgColor = ''; + $data[$x]['Table'] = $row[0]; + // print " "; + $msgColor = ($rowFetch["Msg_text"] == 'OK') ? '' : ''; + $data[$x]['Msg_text'] = $msgColor.$rowFetch["Msg_text"].''; + // print "
"; + $x++; + } + } + return $data; +} + +// check existings tables for upgrade or install +$result = $database->query( "SHOW TABLES FROM ".DB_NAME); +$all_tables = array(); +while ($data = $result->fetchRow()) +{ + $tmp = str_replace(TABLE_PREFIX, '', $data[0]); + if(in_array($tmp,$table_list)) + { + $all_tables[] = $tmp; + } +} + +function show_array($array=array()) +{ + print '
';
+    print_r ($array);
+    print '
'; +} + +?> + + + +Upgrade script + + + + +
+Website Baker Logo + +

Website Baker Upgrade

+

This script upgrades an existing Website Baker Version 2.7 installation to the Version . 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 /pages 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.

+ +
+ +

 I confirm that a manual backup of the /pages folder and the MySQL database was created. +

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

'; + exit; +} + +echo '

Step 2: Updating database entries

'; +if(!defined('DEFAULT_THEME')) { define('DEFAULT_THEME', 'wb_theme'); } + +require_once(WB_PATH.'/framework/functions.php'); +require_once(WB_PATH.'/framework/class.admin.php'); +$admin = new admin('Addons', 'modules', false, false); + +$OK = 'OK'; +$FAIL = 'FAILED'; +$check_text = 'total '; +$check_tables = mysqlCheckTables( DB_NAME ) ; +if(sizeof($check_tables) == 22) +{ + echo '

NOTICE: Your database '.DB_NAME.' has '.sizeof($check_tables).' '.$check_text.' tables from 22 included in package

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

List missing tables, please check

'; + $result = array_diff ( $table_list, $all_tables ); + while ( list ( $key, $val ) = each ( $result ) ) + { + echo TABLE_PREFIX.$val.' '.$FAIL.'
'; + } + + echo '
'; + echo ''; + echo '


'; + exit; +} + +// function to add a var/value-pair into settings-table +function db_add_key_value($key, $value) { + global $database; global $OK; global $FAIL; + $table = TABLE_PREFIX.'settings'; + $query = $database->query("SELECT value FROM $table WHERE name = '$key' LIMIT 1"); + if($query->numRows() > 0) { + echo "$key: already exists. $OK.
"; + return true; + } else { + $database->query("INSERT INTO $table (name,value) VALUES ('$key', '$value')"); + echo (mysql_error()?mysql_error().'
':''); + $query = $database->query("SELECT value FROM $table WHERE name = '$key' LIMIT 1"); + if($query->numRows() > 0) { + echo "$key: $OK.
"; + return true; + } else { + echo "$key: $FAIL!
"; + return false; + } + } +} + +// function to add a new field into a table +function db_add_field($field, $table, $desc) { + global $database; global $OK; global $FAIL; + $table = TABLE_PREFIX.$table; + $query = $database->query("DESCRIBE $table '$field'"); + if($query->numRows() == 0) { // add field + $query = $database->query("ALTER TABLE $table ADD $field $desc"); + echo (mysql_error()?mysql_error().'
':''); + $query = $database->query("DESCRIBE $table '$field'"); + echo (mysql_error()?mysql_error().'
':''); + if($query->numRows() > 0) { + echo "'$field' added. $OK.
"; + } else { + echo "adding '$field' $FAIL!
"; + } + } else { + echo "'$field' already exists. $OK.
"; + } +} + +/********************************************************** + * - Adding field sec_anchor to settings table + */ + +echo "
Adding sec_anchor to settings table
"; +$cfg = array( + 'sec_anchor' => 'wb_' +); +foreach($cfg as $key=>$value) { + db_add_key_value($key, $value); +} + +/********************************************************** + * - Adding field default_theme to settings table + */ +echo "
Adding default_theme to settings table
"; +$cfg = array( + 'default_theme' => 'wb_theme' +); +foreach($cfg as $key=>$value) { + db_add_key_value($key, $value); +} + +/********************************************************** + * - Adding redirect timer to settings table + */ +echo "
Adding redirect timer to settings table
"; +$cfg = array( + 'redirect_timer' => '1500' +); +foreach($cfg as $key=>$value) { + db_add_key_value($key, $value); +} + +/********************************************************** + * - Adding mediasettings to settings table + */ +echo "
Adding mediasettings to settings table
"; +$cfg = array( + 'mediasettings' => '' +); +foreach($cfg as $key=>$value) { + db_add_key_value($key, $value); +} + +/********************************************************** + * - Add field "redirect_type" to table "mod_menu_link" + */ +echo "
Adding field redirect_type to mod_menu_link table
"; +db_add_field('redirect_type', 'mod_menu_link', "INT NOT NULL DEFAULT '302' AFTER `target_page_id`"); + +/********************************************************** + * - Update search no results database filed to create + * valid XHTML if search is empty + */ +echo "
Updating database field `no_results` of search table: "; +$search_no_results = addslashes('

[TEXT_NO_RESULTS]

'); +$sql = "UPDATE `" . TABLE_PREFIX . "search` SET `value` = '$search_no_results' WHERE `name`= 'no_results'"; +$database->query($sql); +echo ($database->query($sql)) ? " $OK
" : " $FAIL
"; + +/********************************************************** + * - Update settings of News Modul + */ + +// These are the default setting +$header = ''."\n"; +$post_loop = ' + + + + + +'; +$footer = '
[TITLE][PUBLISHED_TIME], [PUBLISHED_DATE]
+[SHORT] +[TEXT_READ_MORE] +
+ + + + + + +
[PREVIOUS_PAGE_LINK][OF][NEXT_PAGE_LINK]
'; +$post_header = addslashes(' + + + + + + + + + + +

[TITLE]

[GROUP_IMAGE]
[TEXT_POSTED_BY] [DISPLAY_NAME] ([USERNAME]) [TEXT_ON] [PUBLISHED_DATE]
[PAGE_TITLE] >> [GROUP_TITLE]
'); +$post_footer = '

[TEXT_LAST_CHANGED]: [MODI_DATE] [TEXT_AT] [MODI_TIME]

+[TEXT_BACK]'; +$comments_header = addslashes('

+

[TEXT_COMMENTS]

+'); +$comments_loop = addslashes(' + + + + + +'); +$comments_footer = '
[TITLE][TEXT_BY] [DISPLAY_NAME] [TEXT_ON] [DATE] [TEXT_AT] [TIME]
[COMMENT]
+
[TEXT_ADD_COMMENT]'; +$comments_page = '

[TEXT_COMMENT]

+

[POST_TITLE]

+
'; + +if(in_array('mod_news_settings', $all_tables)) +{ + // Insert default settings into database + $query_dates = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_news_settings where section_id != 0 and page_id != 0"); + while($result = $query_dates->fetchRow()) + { + + echo "
Add default settings to database for news section_id= ".$result['section_id']."
"; + $section_id = $result['section_id']; + + if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `header` = '$header' WHERE `section_id` = $section_id")) { + echo 'Database data header added successfully'; + } + echo mysql_error().'
'; + + if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `post_loop` = '$post_loop' WHERE `section_id` = $section_id")) { + echo 'Database data post_loop added successfully'; + } + echo mysql_error().'
'; + + if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `footer` = '$footer' WHERE `section_id` = $section_id")) { + echo 'Database data footer added successfully'; + } + echo mysql_error().'
'; + + if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `post_header` = '$post_header' WHERE `section_id` = $section_id")) { + echo 'Database data post_header added successfully'; + } + echo mysql_error().'
'; + + if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `post_footer` = '$post_footer' WHERE `section_id` = $section_id")) { + echo 'Database data post_footer added successfully'; + } + echo mysql_error().'
'; + + if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `comments_header` = '$comments_header' WHERE `section_id` = $section_id")) { + echo 'Database data comments_header added successfully'; + } + echo mysql_error().'
'; + + if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `comments_loop` = '$comments_loop' WHERE `section_id` = $section_id")) { + echo 'Database data comments_loop added successfully'; + } + echo mysql_error().'
'; + + if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `comments_footer` = '$comments_footer' WHERE `section_id` = $section_id")) { + echo 'Database data comments_footer added successfully'; + } + echo mysql_error().'
'; + + if($database->query("UPDATE `".TABLE_PREFIX."mod_news_settings` SET `comments_page` = '$comments_page' WHERE `section_id` = $section_id")) { + echo 'Database data comments_page added successfully'; + } + echo mysql_error().'
'; + + } +} +else +{ + echo 'Missing database table '.TABLE_PREFIX.'mod_news_settings '.$FAIL.'
'; +} + +if(file_exists(WB_PATH."/modules/news/upgrade.php")) +{ + echo '

Upgrade existings postfiles to new format


'; + // change old postfiles to new postfiles + require_once(WB_PATH."/modules/news/upgrade.php"); +} +/********************************************************** + * - Set Version to WB 2.8.1 + */ +echo "
Update database version number to 2.8.1 : "; +echo ($database->query("UPDATE `".TABLE_PREFIX."settings` SET `value` = '$version' WHERE `name` = 'wb_version'")) ? " $OK
" : " $FAIL
"; + +/********************************************************** + * - install 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); + +/********************************************************** + * - Reload all addons + */ + +//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 != '' AND substr($file, 0, 1) != '.' AND $file != 'admin.php' AND $file != 'index.php') { + load_module(WB_PATH.'/modules/'.$file); + } + } + closedir($handle); +} +echo '
Modules reloaded
'; + +//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') { + load_template(WB_PATH.'/templates/'.$file); + } + } + closedir($handle); +} +echo '
Templates reloaded
'; + +//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 substr($file, 0, 1) != '.' AND $file != 'index.php') { + load_language(WB_PATH.'/languages/'.$file); + } + } + closedir($handle); +} +echo '
Languages reloaded
'; + + +/********************************************************** + * - End of upgrade script + */ +echo '

Congratulations: The upgrade script is finished ...

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

 

'; + +?> + +
+ \ No newline at end of file