| 
      1
     | 
    
      <?php
 
     | 
  
  
    | 
      2
     | 
    
      /**
 
     | 
  
  
    | 
      3
     | 
    
       *
 
     | 
  
  
    | 
      4
     | 
    
       * @category        modules
 
     | 
  
  
    | 
      5
     | 
    
       * @package         code
 
     | 
  
  
    | 
      6
     | 
    
       * @author          WebsiteBaker Project
 
     | 
  
  
    | 
      7
     | 
    
       * @copyright       2009-2013, WebsiteBaker Org. e.V.
 
     | 
  
  
    | 
      8
     | 
    
       * @link            http://www.websitebaker.org/
 
     | 
  
  
    | 
      9
     | 
    
       * @license         http://www.gnu.org/licenses/gpl.html
 
     | 
  
  
    | 
      10
     | 
    
       * @platform        WebsiteBaker 2.8.4
 
     | 
  
  
    | 
      11
     | 
    
       * @requirements    PHP 5.2.2 and higher
 
     | 
  
  
    | 
      12
     | 
    
       * @version         $Id: upgrade.php 1428 2011-02-07 04:55:31Z Luisehahne $
 
     | 
  
  
    | 
      13
     | 
    
       * @filesource      $HeadURL: http://svn.websitebaker2.org/branches/2.8.x/wb/modules/code/upgrade.php $
 
     | 
  
  
    | 
      14
     | 
    
       * @lastmodified    $Date: 2011-02-07 05:55:31 +0100 (Mo, 07. Feb 2011) $
 
     | 
  
  
    | 
      15
     | 
    
       *
 
     | 
  
  
    | 
      16
     | 
    
       */
 
     | 
  
  
    | 
      17
     | 
    
      // Must include code to stop this file being access directly
 
     | 
  
  
    | 
      18
     | 
    
      /* -------------------------------------------------------- */
 
     | 
  
  
    | 
      19
     | 
    
      // Must include code to stop this file being accessed directly
 
     | 
  
  
    | 
      20
     | 
    
      if(!defined('WB_URL')) {
     | 
  
  
    | 
      21
     | 
    
      	require_once(dirname(dirname(dirname(__FILE__))).'/framework/globalExceptionHandler.php');
 
     | 
  
  
    | 
      22
     | 
    
      	throw new IllegalFileException();
 
     | 
  
  
    | 
      23
     | 
    
      }
 
     | 
  
  
    | 
      24
     | 
    
      /* -------------------------------------------------------- */
 
     | 
  
  
    | 
      25
     | 
    
      
 
     | 
  
  
    | 
      26
     | 
    
      	function mod_code_upgrade($bDebug=false) {
     | 
  
  
    | 
      27
     | 
    
      		global $OK ,$FAIL;
 
     | 
  
  
    | 
      28
     | 
    
      		$database=WbDatabase::getInstance();
 
     | 
  
  
    | 
      29
     | 
    
      		$msg = array();
 
     | 
  
  
    | 
      30
     | 
    
      		$callingScript = $_SERVER["SCRIPT_NAME"];
 
     | 
  
  
    | 
      31
     | 
    
      		// check if upgrade startet by upgrade-script to echo a message
 
     | 
  
  
    | 
      32
     | 
    
      		$tmp = 'upgrade-script.php';
 
     | 
  
  
    | 
      33
     | 
    
      		$globalStarted = substr_compare($callingScript, $tmp,(0-strlen($tmp)),strlen($tmp)) === 0;
 
     | 
  
  
    | 
      34
     | 
    
      // check for missing tables, if true stop the upgrade
 
     | 
  
  
    | 
      35
     | 
    
      		$aTable = array('mod_code');
     | 
  
  
    | 
      36
     | 
    
      		$aPackage = UpgradeHelper::existsAllTables($aTable);
 
     | 
  
  
    | 
      37
     | 
    
      		if( sizeof($aPackage) > 0){
     | 
  
  
    | 
      38
     | 
    
      			$msg[] =  'TABLE '.implode(' missing! '.$FAIL.'<br />TABLE ',$aPackage).' missing! '.$FAIL;
     | 
  
  
    | 
      39
     | 
    
      			$msg[] = 'Code upgrade failed'." $FAIL";
 
     | 
  
  
    | 
      40
     | 
    
      			if($globalStarted) {
     | 
  
  
    | 
      41
     | 
    
      				echo '<strong>'.implode('<br />',$msg).'</strong><br />';
     | 
  
  
    | 
      42
     | 
    
      			}
 
     | 
  
  
    | 
      43
     | 
    
      			return ( ($globalStarted==true ) ? $globalStarted : $msg);
 
     | 
  
  
    | 
      44
     | 
    
      		} else {
     | 
  
  
    | 
      45
     | 
    
      			for($x=0; $x<sizeof($aTable);$x++) {
     | 
  
  
    | 
      46
     | 
    
      				if(($sOldType = $database->getTableEngine($database->TablePrefix.$aTable[$x]))) {
     | 
  
  
    | 
      47
     | 
    
      					if(('myisam' != strtolower($sOldType))) {
     | 
  
  
    | 
      48
     | 
    
      						if(!$database->query('ALTER TABLE `'.$database->TablePrefix.$aTable[$x].'` Engine = \'MyISAM\' ')) {
     | 
  
  
    | 
      49
     | 
    
      							$msg[] = $database->get_error();
 
     | 
  
  
    | 
      50
     | 
    
      						} else{
     | 
  
  
    | 
      51
     | 
    
      							$msg[] = 'TABLE `'.$database->TablePrefix.$aTable[$x].'` changed to Engine = \'MyISAM\''." $OK";
 
     | 
  
  
    | 
      52
     | 
    
      						}
 
     | 
  
  
    | 
      53
     | 
    
      					} else {
     | 
  
  
    | 
      54
     | 
    
      						$msg[] = 'TABLE `'.$database->TablePrefix.$aTable[$x].'` has Engine = \'MyISAM\''." $OK";
 
     | 
  
  
    | 
      55
     | 
    
      					}
 
     | 
  
  
    | 
      56
     | 
    
      				} else {
     | 
  
  
    | 
      57
     | 
    
      					$msg[] = $database->get_error();
 
     | 
  
  
    | 
      58
     | 
    
      				}
 
     | 
  
  
    | 
      59
     | 
    
      			}
 
     | 
  
  
    | 
      60
     | 
    
      // only for upgrade-script
 
     | 
  
  
    | 
      61
     | 
    
      			if($globalStarted) {
     | 
  
  
    | 
      62
     | 
    
      				if($bDebug) {
     | 
  
  
    | 
      63
     | 
    
      					echo '<strong>'.implode('<br />',$msg).'</strong><br />';
     | 
  
  
    | 
      64
     | 
    
      				}
 
     | 
  
  
    | 
      65
     | 
    
      			}
 
     | 
  
  
    | 
      66
     | 
    
      		}
 
     | 
  
  
    | 
      67
     | 
    
      		$msg[] = 'Code upgrade successfull finished '." $OK";
 
     | 
  
  
    | 
      68
     | 
    
      		if($globalStarted) {
     | 
  
  
    | 
      69
     | 
    
      			echo "<strong>Code upgrade successfull finished $OK</strong><br />";
 
     | 
  
  
    | 
      70
     | 
    
      		}
 
     | 
  
  
    | 
      71
     | 
    
      		return ( ($globalStarted==true ) ? $globalStarted : $msg);
 
     | 
  
  
    | 
      72
     | 
    
      	}
 
     | 
  
  
    | 
      73
     | 
    
      // ------------------------------------
 
     | 
  
  
    | 
      74
     | 
    
      
 
     | 
  
  
    | 
      75
     | 
    
      $bDebugModus = ((isset($bDebugModus)) ? $bDebugModus : false);
 
     | 
  
  
    | 
      76
     | 
    
      // Don't show the messages twice
 
     | 
  
  
    | 
      77
     | 
    
      if( is_array($msg = mod_code_upgrade($bDebugModus)) ) {
     | 
  
  
    | 
      78
     | 
    
      	echo '<strong>'.implode('<br />',$msg).'</strong><br />';
     | 
  
  
    | 
      79
     | 
    
      }
 
     |