WB 2.08.x

08-Feb-2010 Dietmar Woellbrink (Luisehahne)

#	Droplet emailfilter fixed search mdcr.js

!	some little fixes in upgrade-script

+	new WebsiteBaker Logo in themes

05-Feb-2010 Dietmar Woellbrink (Luisehahne)

// check existings tables for upgrade or install

function check_wb_tables()

    global $database,$table_list;

        $get_result = $database->query( "SHOW TABLES FROM ".DB_NAME);

        $all_tables = array();

        if($get_result->numRows() > 0)

            while ($data = $get_result->fetchRow())

            {

                $tmp = str_replace(TABLE_PREFIX, '', $data[0]);

                if(in_array($tmp,$table_list))

                {

                    $all_tables[] = $tmp;

                }

            }

     return $all_tables;

}

// check existing tables

$all_tables = check_wb_tables();

// only for array tests

html { overflow: -moz-scrollbars-vertical; /* Force firefox to always show room for a vertical scrollbar */ }

.info {

	width: 98%;

	background:#99CC99;

	padding:0.2em;

	margin-top:0.5em;

	border: 1px solid black;

}

<img src="templates/wb_theme/images/logo.png" alt="WebsiteBaker Project" />

<h1>WebsiteBaker Upgrade</h1>

<p>This script upgrades an existing WebsiteBaker <strong>Version 2.7 and higher</strong> installation to the <strong>Version <?php echo $version ?></strong>. The upgrade script alters the existing WB database to reflect the changes introduced with WB 2.8.x</p>

<textarea cols="80" 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 /pages folder (including all files and subfolders contained in it) and backup of the entire WebsiteBaker MySQL database was created before you can proceed.</textarea>

 *  - Adding field default_theme to settings table

echo "<br />Adding default_theme to settings table<br />";

	'default_theme' => 'wb_theme'

 *  - install droplets

    $drops = (!in_array ( "mod_droplets", $all_tables)) ? "<br />Install droplets<br />" : "<br />Upgrade droplets<br />";

    echo $drops;

     $file_name = (!in_array ( "mod_droplets", $all_tables)) ? "install.php" : "upgrade.php";

     require_once (WB_PATH."/modules/droplets/".$file_name);

// check again all tables, to get a new array

 if(sizeof($all_tables) < 22) { $all_tables = check_wb_tables(); }

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

 *  - check tables comin with WebsiteBaker

 */

    $check_text = 'total ';

    // $check_tables = mysqlCheckTables( DB_NAME ) ;

    if(sizeof($all_tables) == 22)

    {

        echo '<h4>NOTICE: Your database '.DB_NAME.' has '.sizeof($all_tables).' '.$check_text.' tables from '.sizeof($table_list).' included in package '.$OK.'</h4>';

    }

    else

    {

        status_msg('<strong>WARNING:</strong><br />can\'t run Upgrade, missing tables', 'warning', 'div');

    	echo '<h4>Install missing tables, you can install them in backend->addons->modules->advanced. Then again run upgrade-script.php</h4>';

        $result = array_diff ( $table_list, $all_tables );

        echo '<h4 class="warning">';

        while ( list ( $key, $val ) = each ( $result ) )

        {

            echo TABLE_PREFIX.$val.' '.$FAIL.'<br>';

        }

        echo '</h4>';

    	echo '<br /><form action="'. $_SERVER['PHP_SELF'] .'">';

    	echo '<input type="submit" value="kick me back" style="float:left;" />';

    	echo '</form>';

        if(defined('ADMIN_URL'))

        {

        	echo '<form action="'.ADMIN_URL.'" target="_self">';

        	echo '&nbsp;<input type="submit" value="kick me to the Backend" />';

        	echo '</form>';

        }

        echo "<br /><br /></div>

        </body>

        </html>

        ";

        exit();

    }

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

 *  - Adding field sec_anchor to settings table

 */

echo "<br />Adding sec_anchor to settings table<br />";

	'sec_anchor' => 'wb_'

if (version_compare(WB_VERSION, '2.8.0') < 0)

     *  - Update search no results database filed to create

     *  valid XHTML if search is empty

     */

    echo "<br />Updating database field `no_results` of search table: ";

    $search_no_results = addslashes('<tr><td><p>[TEXT_NO_RESULTS]</p></td></tr>');

    $sql = "UPDATE `" . TABLE_PREFIX . "search` SET `value` = '$search_no_results' WHERE `name`= 'no_results'";

    $database->query($sql);

    echo ($database->query($sql)) ? " $OK<br />" : " $FAIL<br />";

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

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");

   if($query_dates->numRows() > 1)

   {

      if ((version_compare(WB_VERSION, '2.8.0') <= 0) && file_exists(WB_PATH."/modules/news/upgrade.php"))

      {

              echo '<h4>Upgrade existings postfiles to new format</h4><br />';

              // change old postfiles to new postfiles

              require_once(WB_PATH."/modules/news/upgrade.php");

      }

   }

// require(WB_PATH.'/framework/initialize.php');

if(!defined('DEFAULT_THEME')) { define('DEFAULT_THEME', 'wb_theme'); }

if(!defined('THEME_PATH')) { define('THEME_PATH', WB_PATH.'/templates/'.DEFAULT_THEME);}

	echo '<form action="'.WB_URL.'">';

	echo '<form action="'.ADMIN_URL.'">';

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

//:usage:  [[EmailFilter]] 

	$search = '<script src="' .WB_URL .'/modules/droplets/js/mdcr.js" type="text/javascript"></script>';