. */ /** * uprade.php * * @category Modules * @package Modules_MultiLingual * @author Werner v.d.Decken * @author Dietmar Wöllbrink * @copyright Werner v.d.Decken * @license http://www.gnu.org/licenses/gpl.html GPL License * @version 1.6.9 * @revision $Revision: 1977 $ * @link $HeadURL: svn://isteam.dynxs.de/wb-archiv/branches/2.8.x/wb/modules/MultiLingual/upgrade.php $ * @lastmodified $Date: 2013-10-06 00:19:38 +0200 (Sun, 06 Oct 2013) $ * @since File available since 09.01.2013 * @description provides a flexible posibility for changeing to a translated page */ /* -------------------------------------------------------- */ // 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_MultiLingual_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; // change table structure $sTable = $database->TablePrefix.'pages'; $sFieldName = 'page_code'; $sDescription = "INT NOT NULL DEFAULT '0' AFTER `language`"; if(!$database->field_add($sTable,$sFieldName,$sDescription)) { $msg[] = ''.$database->get_error(); } else { $msg[] = 'Field ( `page_code` ) description has been add successfully'." $OK"; } // Work-out if we should check old format for existing page_code $sql = 'DESCRIBE `'.$database->TablePrefix.'pages` `page_code`'; $field_sql = $database->query($sql); // $field_set = $field_sql->numRows(); $format = $field_sql->fetchRow(MYSQL_ASSOC) ; // upgrade only if old format if($format['Type'] == 'varchar(255)' ) { $sql = 'SELECT `page_code`,`page_id` FROM `'.$database->TablePrefix.'pages` ORDER BY `page_id`'; if($query_code = $database->query($sql)) { // extract page_id from old format $pattern = '/(?<=_)([0-9]{1,11})/s'; while( $page = $query_code->fetchRow(MYSQL_ASSOC)) { preg_match($pattern, $page['page_code'], $array); $page_code = $array[0]; $page_id = $page['page_id']; $sql = 'UPDATE `'.$database->TablePrefix.'pages` SET '; $sql .= ((empty($array[0])) ? '`page_code` = 0 ' : '`page_code` = '.$page_code.' '); $sql .= 'WHERE `page_id` = '.$page_id; $database->query($sql); } $field_set = $database->field_modify($sTable,$sFieldName,$sDescription); $msg[] = 'Field ( `page_code` ) description has been changed successfully'." $OK"; // only for upgrade-script if($globalStarted) { if($bDebug) { echo ''.implode('
',$msg).'
'; } } } else { $msg[] = ''.$database->get_error(); } } // $msg[] = 'MultiLingual upgrade successfull finished '; if($globalStarted) { echo "MultiLingual upgrade successfull finished $OK
"; } return ( ($globalStarted==true ) ? $globalStarted : $msg); } // ------------------------------------ //$directory = dirname(__FILE__).'/'.'info.php'; //// update entry in table addons to new version //load_module($directory, $install = false); $bDebugModus = ((isset($bDebugModus)) ? $bDebugModus : false); // Don't show the messages twice if( is_array($msg = mod_MultiLingual_upgrade($bDebugModus))) { echo ''.implode('
',$msg).'
'; } // ------------------------------------