. * * upgrade.php * * @category Module * @package Module_form * @subpackage upgrade * @author Dietmar Wöllbrink * @author Werner v.d.Decken * @copyright Werner v.d.Decken * @license http://www.gnu.org/licenses/gpl.html GPL License * @version 0.0.1 * @revision $Revision: 2 $ * @link $HeadURL: svn://isteam.dynxs.de/wb/2.10.x/trunk/modules/form/upgrade.php $ * @lastmodified $Date: 2017-07-02 17:14:29 +0200 (Sun, 02 Jul 2017) $ * @since File available since 17.01.2013 * @description xyz * */ /* -------------------------------------------------------- */ // 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(); } /* -------------------------------------------------------- */ //if(!function_exists('mod_form_upgrade')){ function mod_form_upgrade($bDebug=false) { global $OK ,$FAIL, $callingScript, $globalStarted; $oDb = ( @$GLOBALS['database'] ?: null ); $msg = array(); if (is_writable(WB_PATH.'/temp/cache')) { Translate::getInstance()->clearCache(); } $getMissingTables = (function (array $aTablesList) use ( $oDb ) { $aTablesList = array_flip($aTablesList); $sPattern = $oDb->escapeString( TABLE_PREFIX, '%_' ); $sql = 'SHOW TABLES LIKE \''.$sPattern.'%\''; if (($oTables = $oDb->query( $sql ))) { while ($aTable = $oTables->fetchRow(MYSQLI_NUM)) { $sTable = preg_replace('/^'.preg_quote(TABLE_PREFIX, '/').'/s', '', $aTable[0]); if (isset($aTablesList[$sTable])) { unset($aTablesList[$sTable]); } } } return array_flip($aTablesList); }); // check for missing tables, if true stop the upgrade $aTable = array('mod_form_fields','mod_form_settings','mod_form_submissions'); $aPackage = $getMissingTables($aTable); if( sizeof($aPackage) > 0){ $msg[] = 'TABLE '.implode(' missing! '.$FAIL.'
TABLE ',$aPackage).' missing! '.$FAIL; $msg[] = 'Form upgrade failed'." $FAIL"; if(!$globalStarted) { // echo ''.implode('
',$msg).'
'; } return ( ($globalStarted==true ) ? $globalStarted : $msg); } else { for($x=0; $xgetTableEngine(TABLE_PREFIX.$aTable[$x]))) { if(('myisam' != strtolower($sOldType))) { if(!$oDb->query('ALTER TABLE `'.TABLE_PREFIX.$aTable[$x].'` Engine = \'MyISAM\' ')) { $msg[] = $oDb->get_error(); } else{ $msg[] = 'TABLE `'.TABLE_PREFIX.$aTable[$x].'` changed to Engine = \'MyISAM\''." $OK"; } } else { $msg[] = 'TABLE `'.TABLE_PREFIX.$aTable[$x].'` has Engine = \'MyISAM\''." $OK"; } } else { // $msg[] = $oDb->get_error(); } } $table_name = TABLE_PREFIX.'mod_form_settings'; $field_name = 'perpage_submissions'; $description = "INT NOT NULL DEFAULT '10' AFTER `max_submissions`"; if(!$oDb->field_exists($table_name,$field_name)) { $oDb->field_add($table_name, $field_name, $description); $msg[] = 'Add field `perpage_submissions` AFTER `max_submissions`'; } else { $msg[] = 'Field `perpage_submissions` already exists'." $OK"; } // only for upgrade-script if (!$globalStarted) { if($bDebug) { $msg[] = ''.implode('
',$msg).'
'; } } } $msg[] = 'Form upgrade successfull finished '; if(!$globalStarted) { $msg[] = "Form upgrade successfull finished $OK
"; } $msg = []; return ( ($globalStarted==true ) ? $globalStarted : $msg); } //} // ------------------------------------ $bDebugModus = ((isset($bDebugModus)) ? $bDebugModus : false); $callingScript = $_SERVER["SCRIPT_NAME"]; // check if upgrade startet by upgrade-script to echo a message $globalStarted = preg_match('/upgrade\-script\.php$/', $callingScript); /* $tmp = 'upgrade-script.php'; $globalStarted = substr_compare($callingScript, $tmp,(0-strlen($tmp)),strlen($tmp)) === 0; */ if( is_array($msg = mod_form_upgrade($bDebugModus))) { if (!$globalStarted) {print implode("\n", $msg)."\n";} // echo ''.implode('
',$msg).'
'; }