WB 2.08.x

19 Mar-2013 Build 1892 Dietmar Woellbrink (Luisehahne)

! update output_filter module set version to 0.4.1 

	$aModuleList = array('wysiwyg','form','code','captcha_control','output_filter');

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

-- phpMyAdmin SQL Dump

-- Erstellungszeit: 15. Mrz 2013 um 18:21

-- Server-Version: 5.5.27

--

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

SET time_zone = "+00:00";

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

-- Database structure for WebsiteBaker core

--

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

--

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

--

-- Tabellenstruktur für Tabelle `{TABLE_PREFIX}mod_output_filter`

--

DROP TABLE IF EXISTS `{TABLE_PREFIX}mod_output_filter`;

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

  `sys_rel` int(11) NOT NULL DEFAULT '0',

  `email_filter` int(11) NOT NULL DEFAULT '1',

  `mailto_filter` int(11) NOT NULL DEFAULT '1',

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

  `dot_replacement` varchar(255){TABLE_COLLATION} NOT NULL DEFAULT '(dot)'

){TABLE_ENGINE};

-- EndOfFile

-- phpMyAdmin SQL Dump

-- Erstellungszeit: 15. Mrz 2013 um 18:21

-- Server-Version: 5.5.27

--

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

SET time_zone = "+00:00";

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

-- Database structure for WebsiteBaker core

--

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

--

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

--

-- Default Daten für Tabelle `mod_output_filter`

--

INSERT INTO `{TABLE_PREFIX}mod_output_filter` VALUES('0', '1', '1', '{at}', '{dot}');

-- EndOfFile

 * @copyright       2012, WebsiteBaker Org. e.V.

 * @link            http://www.websitebaker2.org/

 * @platform        WebsiteBaker 2.8.4

 * @filesource      $HeadURL$

$module_directory   = 'output_filter';

$module_name        = 'Frontend Output Filter';

$module_function    = 'tool';

$module_version     = '0.4.1';

$module_platform    = '2.8.4';

$module_author      = 'Christian Sommer(doc), WB-Project, Werner v.d. Decken(DarkViper)';

$module_license     = 'GNU General Public License';

 * @copyright       20096-2012, WebsiteBaker Org. e.V.

 * @link            http://www.websitebaker2.org/

 * @filesource      $HeadURL$

if(!defined('WB_PATH')) {

	require_once(dirname(dirname(dirname(__FILE__))).'/framework/globalExceptionHandler.php');

	throw new IllegalFileException();

} else {

	$sError = array();

// Create table

	if(!$database->SqlImport(dirname(__FILE__).'/sql/mod_output_filter.sql','',false)){

		$sError[] = $database->get_error();

	}

// Create table

	if(!$database->SqlImport(dirname(__FILE__).'/sql/data_output_filter.sql','',false)){

		$sError[] = $database->get_error();

	}

}

 * @copyright       2009-2012, WebsiteBaker Org. e.V.

 * @link            http://www.websitebaker2.org/

 * @filesource      $HeadURL$

// Must include code to stop this file being accessed directly

if(!defined('WB_URL')) {

	require_once(dirname(dirname(dirname(__FILE__))).'/framework/globalExceptionHandler.php');

	throw new IllegalFileException();

	function mod_output_filter_upgrade($bDebug=false) {

		global $OK ,$FAIL;

		$database=WbDatabase::getInstance();

		$msg = array();

		$callingScript = $_SERVER["SCRIPT_NAME"];

		// check if upgrade startet by upgrade-script to echo a message

		$tmp = 'upgrade-script.php';

		$globalStarted = substr_compare($callingScript, $tmp,(0-strlen($tmp)),strlen($tmp)) === 0;

// check for missing tables, if true stop the upgrade

		$aTable = array('mod_output_filter');

		$aPackage = UpgradeHelper::existsAllTables($aTable);

		if( sizeof($aPackage) > 0){

			$msg[] =  'TABLE '.implode(' missing! '.$FAIL.'<br />TABLE ',$aPackage).' missing! '.$FAIL;

			$msg[] = 'Output_filter upgrade failed'." $FAIL";

			if($globalStarted) {

				echo '<strong>'.implode('<br />',$msg).'</strong><br />';

			}

			return ( ($globalStarted==true ) ? $globalStarted : $msg);

		} else {

			for($x=0; $x<sizeof($aTable);$x++) {

				if(($sOldType = $database->getTableEngine($database->TablePrefix.$aTable[$x]))) {

					if(('myisam' != strtolower($sOldType))) {

						if(!$database->query('ALTER TABLE `'.$database->TablePrefix.$aTable[$x].'` Engine = \'MyISAM\' ')) {

							$msg[] = $database->get_error();

						} else{

							$msg[] = 'TABLE `'.$database->TablePrefix.$aTable[$x].'` changed to Engine = \'MyISAM\''." $OK";

						}

					} else {

						$msg[] = 'TABLE `'.$database->TablePrefix.$aTable[$x].'` has Engine = \'MyISAM\''." $OK";

					}

				} else {

					$msg[] = $database->get_error();

				}

			}

			$table_name = $database->TablePrefix.'mod_output_filter';

			$field_name = 'sys_rel';

			$description = 'INT(11) NOT NULL DEFAULT \'0\' FIRST';

			if(!$database->field_exists($table_name,$field_name)) {

				$database->field_add($table_name, $field_name, $description);

				$msg[] = 'Add field `sys_rel` FIRST'." $OK";

			} else {

				$msg[] = 'Field `sys_rel` already exists'." $OK";

			}

// change table structure

			$sTable = $database->TablePrefix.'mod_output_filter';

			$sDescription = 'int(11) NOT NULL DEFAULT \'0\'';

			$sFieldName = 'sys_rel';

			if(!$database->field_modify($sTable,$sFieldName,$sDescription)) {

				$msg[] = ''.$database->get_error();

			} else {

				$msg[] = 'Field ( `sys_rel` ) description has been changed successfully'." $OK";

			}

			$sDescription = 'int(11) NOT NULL DEFAULT \'1\'';

			$sFieldName = 'email_filter';

			if(!$database->field_modify($sTable,$sFieldName,$sDescription)) {

				$msg[] = ''.$database->get_error();

			} else {

				$msg[] = 'Field ( `email_filter` ) description has been changed successfully'." $OK";

			}

			$sFieldName = 'mailto_filter';

			if(!$database->field_modify($sTable,$sFieldName,$sDescription)) {

				$msg[] = ''.$database->get_error();

			} else {

				$msg[] = 'Field ( `mailto_filter` ) description has been changed successfully'." $OK";

			}

// only for upgrade-script

			if($globalStarted) {

				if($bDebug) {

					echo '<strong>'.implode('<br />',$msg).'</strong><br />';

				}

			}

		$msg[] = 'Output_filter upgrade successfull finished '." $OK";

		if($globalStarted) {

			echo "<strong>Output_filter upgrade successfull finished $OK</strong><br />";

		}

		return ( ($globalStarted==true ) ? $globalStarted : $msg);

// ------------------------------------

$bDebugModus = ((isset($bDebugModus)) ? $bDebugModus : false);

// Don't show the messages twice

if( is_array($msg = mod_output_filter_upgrade($bDebugModus)) ) {

	echo '<strong>'.implode('<br />',$msg).'</strong><br />';