. */ /** * UpgradeHelper.php * * @category Core * @package Core_Upgrade * @copyright Werner v.d.Decken * @author Werner v.d.Decken * @license http://www.gnu.org/licenses/gpl.html GPL License * @version 0.0.1 * @revision $Revision: 2070 $ * @link $HeadURL: svn://isteam.dynxs.de/wb-archiv/branches/2.8.x/wb/framework/UpgradeHelper.php $ * @lastmodified $Date: 2014-01-03 02:21:42 +0100 (Fri, 03 Jan 2014) $ * @since File available since 17.03.2013 * @description some helper function for upgrade-script.php */ class UpgradeHelper { /** * Compare available tables against a list of tables * @param array list of needed table names without TablePrefix * @return array list of missing tables * @description this method is the replaement for self::existsAllTables() */ public static function getMissingTables(array $aTablesList) { $aTablesList = array_flip($aTablesList); $oDb = WbDatabase::getInstance(); $sPattern = addcslashes ( $oDb->TablePrefix, '%_' ); if (($oTables = $oDb->query( 'SHOW TABLES LIKE "'.$sPattern.'%"'))) { while ($aTable = $oTables->fetchRow(MYSQL_NUM)) { $sTable = preg_replace('/^'.preg_quote($oDb->TablePrefix, '/').'/s', '', $aTable[0]); if (isset($aTablesList[$sTable])) { unset($aTablesList[$sTable]); } } } return array_flip($aTablesList); } /** * Alias for self::getMissingTables() * @param array list of needed table names without TablePrefix * @return array list of missing tables */ public static function existsAllTables(array $aTablesList) { return self::getMissingTables($aTablesList); } /** * Sanitize and repair Pagetree links * @return boolean|int number of updated records or false on error */ public static function sanitizePagesTreeLinkStructure() { $oDb = WbDatabase::getInstance(); $iCounter = 0; $aPages = array(); try { $sql = 'SELECT `page_id`, `link`, `page_trail` ' . 'FROM `'.$oDb->TablePrefix.'pages` ' . 'ORDER BY `page_id`'; $oPages = $oDb->doQuery($sql); // read 'page_id', 'link' and 'page_trail' from all pages while ($aPage = $oPages->fetchRow(MYSQL_ASSOC)) { // extact filename only from complete link $aPages[$aPage['page_id']]['filename'] = preg_replace('/.*?\/([^\/]*$)/', '\1', $aPage['link']); $aPages[$aPage['page_id']]['page_trail'] = $aPage['page_trail']; $aPages[$aPage['page_id']]['link'] = $aPage['link']; } foreach ($aPages as $iKey=>$aRecord) { // iterate all pages $aTmp = array(); $aIds = explode(',', $aRecord['page_trail']); // rebuild link from filenames using page_trail foreach($aIds as $iId) { $aTmp[] = $aPages[$iId]['filename']; } $sLink = '/'.implode('/', $aTmp); if ($sLink != $aPages[$iKey]['link']) { // update page if old link is different to new generated link $sql = 'UPDATE `'.$oDb->TablePrefix.'pages` ' . 'SET `link`=\''.$sLink.'\' ' . 'WHERE `page_id`='.$iKey; $oDb->doQuery($sql); $iCounter++; } } } catch(WbDatabaseException $e) { return false; } return $iCounter; } /** * * @param string $sMsg Message to show */ public static function dieWithMessage($sMsg) { $sMsg = 'Fatal error occured during initial startup.

'.PHP_EOL.$sMsg . '
'.PHP_EOL.'Please correct these errors and then ' . 'klick here to restart the upgrade-script.
'.PHP_EOL; die($sMsg); } /** * * @param string $sAppPath path to the current installation * @return boolean */ public static function checkSetupFiles($sAppPath) { if (defined('DB_PASSWORD')) { // old config.php is active if (!is_writable($sAppPath.'config.php') || !is_writable($sAppPath.'config.php.new') || !is_writable($sAppPath.'setup.ini.php.new')) { // stop script if there's an error occured $sMsg = 'Following files must exist and be writable to run upgrade:
' . ''; self::dieWithMessage($sMsg); } else { // ok, let's change the files now! if (file_exists($sAppPath.'setup.ini.php')) { // if 'setup.ini.php' exists if (!is_writeable($sAppPath.'setup.ini.php')) { // but it's not writable $sMsg = 'The file \'setup.ini.php\' already exists but is not writeable!'; self::dieWithMessage($sMsg); } } else { // try to rename 'setup.ini.php.new' into 'setup.ini.php' if (!rename($sAppPath.'setup.ini.php.new', $sAppPath.'setup.ini.php')) { $sMsg = 'Can not rename \''.$sAppPath.'setup.ini.php.new\' into \''.$sAppPath.'setup.ini.php\' !!
' . 'Create an empty file \''.$sAppPath.'setup.ini.php\' and make it writeable for the server!'; self::dieWithMessage($sMsg); } } // now first read constants from old config.php $sContent = file_get_contents($sAppPath.'config.php'); $sPattern = '/^\s*define\s*\(\s*([\'\"])(.*?)\1\s*,.*;\s*$/m'; if (preg_match_all($sPattern, $sContent, $aMatches)) { // get all already defined consts $aAllConsts = get_defined_constants(true); $aSetupConsts = array(); // collect the needed values from defined consts foreach($aMatches[2] as $sConstName) { $aSetupConsts[$sConstName] = (isset($aAllConsts['user'][$sConstName]) ? $aAllConsts['user'][$sConstName] : ''); } // try to sanitize available values $aSetupConsts['DB_TYPE'] = ((isset($aSetupConsts['DB_TYPE']) && $aSetupConsts['DB_TYPE'] != '') ? $aSetupConsts['DB_TYPE'] : 'mysql'); $aSetupConsts['DB_PORT'] = ((isset($aSetupConsts['DB_PORT']) && $aSetupConsts['DB_PORT'] != '') ? $aSetupConsts['DB_PORT'] : '3306'); $aSetupConsts['DB_CHARSET'] = (isset($aSetupConsts['DB_CHARSET']) ? $aSetupConsts['DB_CHARSET'] : ''); $aSetupConsts['DB_CHARSET'] = preg_replace('/[^0-9a-z]*/i', '', $aSetupConsts['DB_CHARSET']); $aSetupConsts['TABLE_PREFIX'] = (isset($aSetupConsts['TABLE_PREFIX']) ? $aSetupConsts['TABLE_PREFIX'] : ''); $aSetupConsts['ADMIN_DIRECTORY'] = trim(str_replace('\\', '/', preg_replace('/^'.preg_quote(WB_PATH, '/').'/', '', ADMIN_PATH)), '/').'/'; $aSetupConsts['WB_URL'] = rtrim(str_replace('\\', '/', WB_URL), '/').'/'; // Try and write settings to config file if (self::writeSetupIni($sAppPath, $aSetupConsts)) { if (self::writeConfig($sAppPath)) { return true; } else { $sMsg ='Error writing \''.$sAppPath.'config.php\'!'; } } else { $sMsg ='Error writing \''.$sAppPath.'setup.ini.php\'!'; } } else { $sMsg = 'No valid content found in \''.$sAppPath.'config.php\'!'; } self::dieWithMessage($sMsg); } } else { $sFileContent = file_get_contents($sAppPath.'config.php'); if (preg_match('/\s*define\s*\(.*\)\s*;/i', $sFileContent)) { // if config.php does not contain any defines if (is_writable($sAppPath.'config.php')) { // overwrite config.php with default content for compatibility if (self::writeConfig($sAppPath.'config.php')) { return true; } else { $sMsg ='Error writing \''.$sAppPath.'config.php\'!'; } } else { $sMsg ='File is not writable \''.$sAppPath.'config.php\'!'; } self::dieWithMessage($sMsg); } } } /** * * @param string $sAppPath the path where setup.ini.php is located * @param array $aSetupValues * @return boolean */ public static function writeSetupIni($sAppPath, array $aSetupValues) { $sSetupContent = ";#####\n" .";################################################\n" ."; WebsiteBaker configuration file\n" ."; auto generated ".date('Y-m-d h:i:s A e ')."\n" .";################################################\n" ."[Constants]\n" ."DEBUG = false\n" ."AppUrl = \"".$aSetupValues['WB_URL']."\"\n" ."AcpDir = \"".$aSetupValues['ADMIN_DIRECTORY']."\"\n" .";##########\n" ."[DataBase]\n" ."type = \"".$aSetupValues['DB_TYPE']."\"\n" ."user = \"".$aSetupValues['DB_USERNAME']."\"\n" ."pass = \"".$aSetupValues['DB_PASSWORD']."\"\n" ."host = \"".$aSetupValues['DB_HOST']."\"\n" ."port = \"".$aSetupValues['DB_PORT']."\"\n" ."name = \"".$aSetupValues['DB_NAME']."\"\n" ."charset = \"".$aSetupValues['DB_CHARSET']."\"\n" ."table_prefix = \"".$aSetupValues['TABLE_PREFIX']."\"\n" .";\n" .";################################################\n"; $sSetupFile = $sAppPath.'setup.ini.php'; if (file_put_contents($sSetupFile, $sSetupContent)) { return true; } return false; } /** * * @param string $sAppPath the path where config.php is located * @return boolean */ public static function writeConfig($sAppPath) { $sConfigContent = "