Copyright (C) 2004-2008, Ryan Djurovich
Website Baker 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.
Website Baker 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 Website Baker; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
//
// upgrade-script for Website Baker from version 2.6.7 to 2.7
//
require('config.php');
require(WB_PATH.'/framework/functions.php');
?>
Upgrade-Script
Upgrade-script
will upgrade Website Baker 2.6.5 / 2.6.7 to version 2.7
OK';
$FAIL = 'failed';
/**********************************************************
* - modules-based search
*/
function db_add_search_key_value($key, $value) {
global $database; global $OK; global $FAIL;
$query = $database->query("SELECT value FROM ".TABLE_PREFIX."search WHERE name = '$key' LIMIT 1");
if($query->numRows() > 0) {
echo "$key: allready there. $OK. ";
return true;
} else {
$database->query("INSERT INTO D".TABLE_PREFIX."search (name,value,extra) VALUES ('$key', '$value', '')");
echo mysql_error()?' ':'';
$query = $database->query("SELECT value FROM ".TABLE_PREFIX."search WHERE name = '$key' LIMIT 1");
if($query->numRows() > 0) {
echo "$key: $OK. ";
return true;
} else {
echo "$key: $FAIL! ";
return false;
}
}
}
echo " Adding module_order and max_excerpt to search-table ";
// module_order - in which order to show the search-results
// max_excerpt - how many lines of excerpt to print per matching page
$cfg = array(
'module_order' => 'faqbaker,manual,wysiwyg',
'max_excerpt' => '15'
);
foreach($cfg as $key=>$value) {
db_add_search_key_value($key, $value);
}
echo " Changing results_loop in search-table ";
// adding [EXCERPT]
$query = $database->query("SELECT value FROM ".TABLE_PREFIX."search WHERE name = 'results_loop' LIMIT 1");
if($query->numRows() > 0) {
$fetch_results_loop = $query->fetchRow();
$string = $fetch_results_loop['value'];
if(preg_match("/\[EXCERPT\]/", $string)) {
echo "[EXCERPT] is allready there. $OK. ";
} else {
$string = preg_replace("/10px;\">\[DESCRIPTION\]/", "5px;\">[DESCRIPTION]", $string);
$string .= "
[EXCERPT]
";
$string = addslashes($string);
$database->query("UPDATE ".TABLE_PREFIX."search SET name='results_loop',value='".$string."',extra='' WHERE name = 'results_loop' LIMIT 1");
echo mysql_error().' ';
$query = $database->query("SELECT value FROM ".TABLE_PREFIX."search WHERE name = 'results_loop' LIMIT 1");
if($query->numRows() > 0) {
$fetch_results_loop = $query->fetchRow();
$string = $fetch_results_loop['value'];
if(preg_match("/\[EXCERPT\]/", $string)) {
echo "[EXCERPT] added. $OK. ";
} else {
echo "adding [EXCERPT] $FAIL! ";
}
}
}
}
echo " Changing \"Header:\" in search-table ";
// adding [SEARCH_PATH]
$query = $database->query("SELECT value FROM ".TABLE_PREFIX."search WHERE name = 'header' LIMIT 1");
if($query->numRows() > 0) {
$fetch_header = $query->fetchRow();
$string = $fetch_header['value'];
if(preg_match("/\[SEARCH_PATH\]/", $string)) {
echo "[SEARCH_PATH] is allready there. $OK. ";
} else {
$string = preg_replace("//", "", $string);
$string = addslashes($string);
$database->query("UPDATE ".TABLE_PREFIX."search SET name='header',value='".$string."',extra='' WHERE name = 'header' LIMIT 1");
echo mysql_error().' ';
$query = $database->query("SELECT value FROM ".TABLE_PREFIX."search WHERE name = 'header' LIMIT 1");
if($query->numRows() > 0) {
$fetch_header = $query->fetchRow();
$string = $fetch_header['value'];
if(preg_match("/\[SEARCH_PATH\]/", $string)) {
echo "[SEARCH_PATH] added. $OK. ";
} else {
echo "adding [SEARCH_PATH] $FAIL! ";
}
}
}
}
echo " Adding some internal config-elements to search-table ";
// These are global config-elements which don't appear in settings-page. Change them in the database if needed.
// cfg_show_description - whether to show page-description on the results page (true/false), def: true
// cfg_search_description - whether to search in page-description (true/false), def: true [only used while searching title/link/description/keywords]
// cfg_search_keywords - whether to search in page-keywords (true/false), def: true [only used while searching title/link/description/keywords]
// cfg_enable_old_search - use old search-method, too (true/false), def: true [use old method as fallback]
$cfg = array(
'cfg_show_description' => 'true',
'cfg_search_description' => 'true',
'cfg_search_keywords' => 'true',
'cfg_enable_old_search' => 'true'
);
foreach($cfg as $key=>$value) {
db_add_search_key_value($key, $value);
}
/**********************************************************
* - publish-by-date
*/
echo " Adding fields 'publ_start' and 'publ_end' to table 'sections' ";
// Add fields "publ_start" and "publ_end" to table "sections"
// check if fields are present
$table = TABLE_PREFIX."sections";
$query = $database->query("DESCRIBE $table 'publ_start'");
if($query->numRows() == 0) { // add field
$query = $database->query("ALTER TABLE $table ADD publ_start INT NOT NULL DEFAULT '0'");
$query = $database->query("DESCRIBE $table 'publ_start'");
if($query->numRows() > 0) {
echo "'publ_start' added. $OK. ";
} else {
echo "adding 'publ_start' $FAIL! ";
}
} else {
echo "'publ_start' allready there. $OK. ";
}
$query = $database->query("DESCRIBE $table 'publ_end'");
if($query->numRows() == 0) { // add field
$query = $database->query("ALTER TABLE $table ADD publ_end INT NOT NULL DEFAULT '0'");
$query = $database->query("DESCRIBE $table 'publ_end'");
if($query->numRows() > 0) {
echo "'publ_end' added. $OK. ";
} else {
echo "adding 'publ_end' $FAIL! ";
}
} else {
echo "'publ_end' allready there. $OK ";
}
/**********************************************************
* - core-module menu_link
*/
// create table
$table = TABLE_PREFIX ."mod_menu_link";
$database->query("DROP TABLE IF EXISTS `$table`");
$database->query("
CREATE TABLE `$table` (
`section_id` INT(11) NOT NULL DEFAULT '0',
`page_id` INT(11) NOT NULL DEFAULT '0',
`target_page_id` INT(11) NOT NULL DEFAULT '0',
`anchor` VARCHAR(255) NOT NULL DEFAULT '' ,
PRIMARY KEY (`section_id`)
)
");
// fetch all menu_link-pages in $pages
$pages = array();
$table_p = TABLE_PREFIX.'pages';
$table_s = TABLE_PREFIX.'sections';
$query_page = $database->query("SELECT p.* FROM $table_p AS p, $table_s AS s WHERE p.page_id=s.page_id AND s.module = 'menu_link'");
if($query_page->numRows() > 0) {
while($page = $query_page->fetchRow()) {
$pages[$page['page_id']]['page_details'] = $page;
}
}
// get all related files with content from pages/ in $pages, too
function list_files_dirs($dir, $depth=true, $files=array(), $dirs=array()) {
$dh=opendir($dir);
while(($file = readdir($dh)) !== false) {
if($file == '.' || $file == '..') {
continue;
}
if(is_dir($dir.'/'.$file)) {
if($depth) {
$dirs[] = $dir.'/'.$file;
list($files, $dirs) = list_files_dirs($dir.'/'.$file, $depth, $files, $dirs);
}
} else {
$files[] = $dir.'/'.$file;
}
}
closedir($dh);
natcasesort($files);
natcasesort($dirs);
return(array($files, $dirs));
}
list($files, $dirs) = list_files_dirs(WB_PATH.PAGES_DIRECTORY);
foreach($files as $file) {
if(($content = implode('', file($file))) !== FALSE) {
if(preg_match('/\$page_id = (\d+)/', $content, $matches)) {
if(array_key_exists($matches[1], $pages)) {
$pages[$matches[1]]['file_content'] = $content;
$pages[$matches[1]]['filename'] = $file;
}
}
}
}
// try to convert old menu_links to new ones
foreach($pages as $p) {
$page = $p['page_details'];
$file_content = $p['file_content'];
$filename = $p['filename'];
$link = $p['page_details']['link'];
//var_dump($page);var_dump($file_content);var_dump($filename);var_dump($link);
// This part is still missing
}
//******************************************************************************
//Start of upgrade script for the form modul
//******************************************************************************
echo " Adding new field to database table mod_form_settings ";
if($database->query("ALTER TABLE `".TABLE_PREFIX."mod_form_settings` ADD `success_email_subject` VARCHAR(255) NOT NULL AFTER `success_message`")) {
echo 'Database Field success_email_subject added successfully ';
}
echo mysql_error().' ';
if($database->query("ALTER TABLE `".TABLE_PREFIX."mod_form_settings` ADD `success_email_text` TEXT NOT NULL AFTER `success_message`")) {
echo 'Database Field success_email_text added successfully ';
}
echo mysql_error().' ';
if($database->query("ALTER TABLE `".TABLE_PREFIX."mod_form_settings` ADD `success_email_from` VARCHAR(255) NOT NULL AFTER `success_message`")) {
echo 'Database Field success_email_from added successfully ';
}
echo mysql_error().' ';
if($database->query("ALTER TABLE `".TABLE_PREFIX."mod_form_settings` ADD `success_email_to` TEXT NOT NULL AFTER `success_message`")) {
echo 'Database Field success_email_to added successfully ';
}
echo mysql_error().' ';
if($database->query("ALTER TABLE `".TABLE_PREFIX."mod_form_settings` ADD `success_page` TEXT NOT NULL AFTER `success_message`")) {
echo 'Database Field success_page added successfully ';
}
echo mysql_error().' ';
echo " Deleting field success_message from table mod_form_settings ";
if($database->query("ALTER TABLE `".TABLE_PREFIX."mod_form_settings` DROP `success_message`")) {
echo 'Database field success_message droped successfully ';
}
echo mysql_error().' ';
// UPDATING DATA INTO FIELDS
echo " ";
// These are the default setting
$success_page = 'none';
$success_email_to = '';
$success_email_text = 'Thank you for submitting your form on '.WEBSITE_TITLE;
$success_email_text = addslashes($success_email_text);
$success_email_subject = 'You have submitted a form';
// Insert default settings into database
$query_dates = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_form_settings where section_id != 0 and page_id != 0");
while($result = $query_dates->fetchRow()) {
echo "Add default settings data to database for form section_id= ".$result['section_id']." ";
$section_id = $result['section_id'];
if($database->query("UPDATE `".TABLE_PREFIX."mod_form_settings` SET `success_page` = '$success_page' WHERE `section_id` = $section_id")) {
echo 'Database data success_page added successfully ';
}
echo mysql_error().' ';
if($database->query("UPDATE `".TABLE_PREFIX."mod_form_settings` SET `success_email_to` = '$success_email_to' WHERE `section_id` = $section_id")) {
echo 'Database data success_email_to added successfully ';
}
echo mysql_error().' ';
if($database->query("UPDATE `".TABLE_PREFIX."mod_form_settings` SET `success_email_text` = '$success_email_text' WHERE `section_id` = $section_id")) {
echo 'Database data success_email_text added successfully ';
}
echo mysql_error().' ';
if($database->query("UPDATE `".TABLE_PREFIX."mod_form_settings` SET `success_email_subject` = '$success_email_subject' WHERE `section_id` = $section_id")) {
echo 'Database data success_email_subject added successfully ';
}
echo mysql_error().' ';
}
// copy field email_to to success_email_from
$query_dates = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_form_settings where section_id != 0 and page_id != 0");
while($result = $query_dates->fetchRow()) {
echo "Copying field email_to to success_email_from for form section_id= ".$result['section_id']." ";
$section_id = $result['section_id'];
$success_email_from = $result['email_to'];
if($database->query("UPDATE `".TABLE_PREFIX."mod_form_settings` SET `success_email_from` = '$success_email_from' WHERE `section_id` = $section_id")) {
echo 'Copyied field email_to to success_email_from successfully ';
}
echo mysql_error().' ';
}
//******************************************************************************
//End of upgrade script for the form modul
//******************************************************************************
//******************************************************************************
//Start of upgrade script for the news modul
//******************************************************************************
echo " Adding new field to database table mod_news_posts ";
if($database->query("ALTER TABLE `".TABLE_PREFIX."mod_news_posts` ADD `published_when` INT NOT NULL AFTER `commenting`")) {
echo 'Database Field published_when added successfully ';
}
echo mysql_error().' ';
// UPDATING DATA INTO FIELDS
echo " ";
// These are the default setting
$header = '