WB 2.08.x

20 Nov-2012 Build 1822 Dietmar Woellbrink (Luisehahne)

! update installer, strict difference between table structure and data 

# fixed wrong constant for settings table

! update redirct to upgrade-script in /admin/start(index.php

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

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

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

{

    $aDebugMessage = array();

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

     * 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) {

    // $aDebugMessage[] =

        echo implode(PHP_EOL,$aDebugMessage);

    }

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

{

    $aDebugMessage = array();

    echo '<h3>Step '.(++$stepID).': Updating group_id in table users</h3>';

    if($bDebugModus) {

    // $aDebugMessage[] =

        echo implode(PHP_EOL,$aDebugMessage);

    }else {

        echo '<span><strong>'.$iTotalUsers.' users updating the group_id</strong></span>'." $OK<br />";

        echo '</div>';

    }

echo "<p style=\"text-align:center;\"> If the <strong>upgrade script</strong> could not be start automatically.\n" .

     "Please click <a style=\"font-weight:bold;\" " .

     "href=\"".WB_URL."/upgrade-script.php\">on this link</a> to start the script!</p>\n";

echo "<script type=\"text/javascript\">

<!--

// Get the location object

var locationObj = document.location;

// Set the value of the location object

document.location = '".WB_URL."/upgrade-script.php';

-->

</script>";

//		if(!headers_sent()) {

//			header('Location: '.WB_URL.'/upgrade-script.php');

//		    exit;

//		} else {

//		    echo "<p style=\"text-align:center;\"> The <strong>upgrade script</strong> could not be start automatically.\n" .

//		         "Please click <a style=\"font-weight:bold;\" " .

//		         "href=\"".WB_URL."/upgrade-script.php\">on this link</a> to start the script!</p>\n";

//		    exit;

//		}

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

-- phpMyAdmin SQL Dump

-- Date of creation: 2012-11-17 12:37am

-- Server Version: 5.1.41

--

-- initial data for table `{TABLE_PREFIX}search`

--

INSERT INTO `{TABLE_PREFIX}search` VALUES(1, 'header', '<h1>[TEXT_SEARCH]</h1>\r\n<form name="searchpage" action="[WB_URL]/search/index.php" method="get">\r\n<table cellpadding="3" cellspacing="0" border="0" style="width:100%; max-width:500px">\r\n<tr>\r\n<td>\r\n<input type="hidden" name="search_path" value="[SEARCH_PATH]" />\r\n<input type="hidden" name="referrer" value="[REFERRER]" />\r\n<input type="text" name="string" value="[SEARCH_STRING]" style="width: 100%;" />\r\n</td>\r\n<td width="100">\r\n<input type="submit" value="[TEXT_SEARCH]" style="width: 100%;" />\r\n</td>\r\n</tr>\r\n<tr>\r\n<td colspan="2">\r\n<input type="radio" name="match" id="match_all" value="all"[ALL_CHECKED] />\r\n<label for="match_all">[TEXT_ALL_WORDS]</label>\r\n<input type="radio" name="match" id="match_any" value="any"[ANY_CHECKED] />\r\n<label for="match_any">[TEXT_ANY_WORDS]</label>\r\n<input type="radio" name="match" id="match_exact" value="exact"[EXACT_CHECKED] />\r\n<label for="match_exact">[TEXT_EXACT_MATCH]</label>\r\n</td>\r\n</tr>\r\n</table>\r\n</form>\r\n<hr />', '');

INSERT INTO `{TABLE_PREFIX}search` VALUES(2, 'footer', '', '');

INSERT INTO `{TABLE_PREFIX}search` VALUES(3, 'results_header', '<p>[TEXT_RESULTS_FOR] "<strong>[SEARCH_STRING]</strong>":</p>\r\n<div class="searchresults">', '');

INSERT INTO `{TABLE_PREFIX}search` VALUES(4, 'results_loop', '<h3 style="margin:10px 0 3px 0;"><a href="[LINK]">[TITLE]</a></h3>\r\n<div style="font-size:0.8em;">[TEXT_LAST_UPDATED_BY] [DISPLAY_NAME] [TEXT_ON] [DATE]</div>\r\n<p style="padding: 0 0 5px 0; margin: 2px 0 10px 0; border-bottom: 1px solid #777;">[DESCRIPTION].. [EXCERPT]</p>', '');

INSERT INTO `{TABLE_PREFIX}search` VALUES(5, 'results_footer', '</div>', '');

INSERT INTO `{TABLE_PREFIX}search` VALUES(6, 'no_results', '<p>[TEXT_NO_RESULTS]</p>', '');

INSERT INTO `{TABLE_PREFIX}search` VALUES(7, 'module_order', 'faqbaker,manual,wysiwyg', '');

INSERT INTO `{TABLE_PREFIX}search` VALUES(8, 'max_excerpt', '5', '');

INSERT INTO `{TABLE_PREFIX}search` VALUES(9, 'time_limit', '0', '');

INSERT INTO `{TABLE_PREFIX}search` VALUES(10, 'cfg_enable_old_search', 'true', '');

INSERT INTO `{TABLE_PREFIX}search` VALUES(11, 'cfg_search_keywords', 'true', '');

INSERT INTO `{TABLE_PREFIX}search` VALUES(12, 'cfg_search_description', 'true', '');

INSERT INTO `{TABLE_PREFIX}search` VALUES(13, 'cfg_show_description', 'true', '');

INSERT INTO `{TABLE_PREFIX}search` VALUES(14, 'cfg_enable_flush', 'true', '');

INSERT INTO `{TABLE_PREFIX}search` VALUES(15, 'template', '', '');

-- End of file

-- phpMyAdmin SQL Dump

-- Date of creation: 2012-11-17 12:37am

-- Server Version: 5.1.41

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- --------------------------------------------------------

-- Database structure for WebsiteBaker core

-- Replacements: {TABLE_PREFIX}, {TABLE_ENGINE}, {TABLE_COLLATION}

-- --------------------------------------------------------

--

-- Structure of table  '{TABLE_PREFIX}addons'

--

DROP TABLE IF EXISTS `{TABLE_PREFIX}addons`;

CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}addons` (

  `addon_id` int(11) NOT NULL AUTO_INCREMENT,

  `type` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',

  `directory` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',

  `name` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',

  `description` text{TABLE_COLLATION} NOT NULL,

  `function` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',

  `version` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',

  `platform` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',

  `author` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',

  `license` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',

){TABLE_ENGINE};

-- Structure of table  '{TABLE_PREFIX}groups'

  `name` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',

  `system_permissions` text{TABLE_COLLATION} NOT NULL,

  `module_permissions` text{TABLE_COLLATION} NOT NULL,

  `template_permissions` text{TABLE_COLLATION} NOT NULL,

){TABLE_ENGINE};

-- Structure of table  '{TABLE_PREFIX}pages'

  `link` varchar(255){TABLE_COLLATION} NOT NULL,

  `target` varchar(7){TABLE_COLLATION} NOT NULL DEFAULT '',

  `page_title` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',

  `page_icon` varchar(512){TABLE_COLLATION} NOT NULL DEFAULT '',

  `menu_title` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',

  `menu_icon_0` varchar(512){TABLE_COLLATION} NOT NULL DEFAULT '',

  `menu_icon_1` varchar(512){TABLE_COLLATION} NOT NULL DEFAULT '',

  `tooltip` varchar(512){TABLE_COLLATION} NOT NULL DEFAULT '',

  `description` text{TABLE_COLLATION} NOT NULL,

  `keywords` text{TABLE_COLLATION} NOT NULL,

  `page_trail` varchar(255){TABLE_COLLATION} NOT NULL,

  `template` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',

  `visibility` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',

  `language` varchar(5){TABLE_COLLATION} NOT NULL DEFAULT '',

  `admin_groups` varchar(512){TABLE_COLLATION} NOT NULL DEFAULT '1',

  `admin_users` varchar(512){TABLE_COLLATION} NOT NULL,

  `viewing_groups` varchar(512){TABLE_COLLATION} NOT NULL DEFAULT '1',

  `viewing_users` varchar(512){TABLE_COLLATION} NOT NULL,

  `custom01` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',

  `custom02` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',

-- Structure of table  '{TABLE_PREFIX}sections'

  `module` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',

  `block` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',

  `publ_start` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '0',

  `publ_end` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '0',

-- Structure of table  '{TABLE_PREFIX}users'

  `groups_id` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '0',

  `username` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',

  `password` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',

  `confirm_code` varchar(32){TABLE_COLLATION} NOT NULL DEFAULT '',

  `remember_key` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',

  `display_name` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',

  `email` text{TABLE_COLLATION} NOT NULL,

  `date_format` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',

  `time_format` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',

  `language` varchar(5){TABLE_COLLATION} NOT NULL DEFAULT 'EN',

  `home_folder` text{TABLE_COLLATION} NOT NULL,

  `login_ip` varchar(15){TABLE_COLLATION} NOT NULL DEFAULT '',

){TABLE_ENGINE};

-- Structure of table  '{TABLE_PREFIX}settings'

  `name` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',

  `value` text{TABLE_COLLATION} NOT NULL,

){TABLE_ENGINE};

--

-- Structure of table `{TABLE_PREFIX}search`

--

DROP TABLE IF EXISTS `{TABLE_PREFIX}search`;

CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}search` (

  `search_id` int(11) NOT NULL AUTO_INCREMENT,

  `name` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '',

  `value` text{TABLE_COLLATION} NOT NULL,

  `extra` text{TABLE_COLLATION} NOT NULL,

  PRIMARY KEY (`search_id`)

){TABLE_ENGINE};

-- EndOfFile

//  core tables only structure

	// Admin group

	$full_system_permissions  = 'access,addons,admintools,admintools_view,groups,groups_add,groups_delete,groups_modify,groups_view,';

	$full_system_permissions .= 'languages,languages_install,languages_uninstall,languages_view,media,media_create,media_delete,media_rename,media_upload,media_view,';

	$full_system_permissions .= 'modules,modules_advanced,modules_install,modules_uninstall,modules_view,pages,pages_add,pages_add_l0,pages_delete,pages_intro,pages_modify,pages_settings,pages_view,';

	$full_system_permissions .= 'preferences,preferences_view,settings,settings_advanced,settings_basic,settings_view,templates,templates_install,templates_uninstall,templates_view,users,users_add,users_delete,users_modify,users_view';

	$insert_admin_group = "INSERT INTO `".TABLE_PREFIX."groups` VALUES ('1', 'Administrators', '$full_system_permissions', '', '')";

	if(!$database->query($insert_admin_group)) { set_error($database->get_error()); }

// Search layout default data

    $sSqlFileName = dirname(__FILE__).'/sql/wb_search_data.sql';