| 1 | <?php
 | 
  
    | 2 | /**
 | 
  
    | 3 |  *
 | 
  
    | 4 |  * @category        modules
 | 
  
    | 5 |  * @package         jsadmin
 | 
  
    | 6 |  * @author          WebsiteBaker Project
 | 
  
    | 7 |  * @copyright       2009-2013, WebsiteBaker Org. e.V.
 | 
  
    | 8 |  * @link            http://www.websitebaker2.org/
 | 
  
    | 9 |  * @license         http://www.gnu.org/licenses/gpl.html
 | 
  
    | 10 |  * @platform        WebsiteBaker 2.8.x
 | 
  
    | 11 |  * @requirements    PHP 5.2.2 and higher
 | 
  
    | 12 |  * @version         $Id: upgrade.php 1895 2013-03-20 01:14:23Z Luisehahne $
 | 
  
    | 13 |  * @filesource      $HeadURL: svn://isteam.dynxs.de/wb-archiv/branches/2.8.x/wb/modules/jsadmin/upgrade.php $
 | 
  
    | 14 |  * @lastmodified    $Date: 2013-03-20 02:14:23 +0100 (Wed, 20 Mar 2013) $
 | 
  
    | 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_jsadmin_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_jsadmin');
 | 
  
    | 36 | 		$aPackage = UpgradeHelper::existsAllTables($aTable);
 | 
  
    | 37 | 		if( sizeof($aPackage) > 0){
 | 
  
    | 38 | 			$msg[] =  'TABLE '.implode(' missing! '.$FAIL.'<br />TABLE ',$aPackage).' missing! '.$FAIL;
 | 
  
    | 39 | 			$msg[] = 'Jsadmin 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[] = 'Jsadmin upgrade successfull finished '." $OK";
 | 
  
    | 68 | 		if($globalStarted) {
 | 
  
    | 69 | 			echo "<strong>Jsadmin 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_jsadmin_upgrade($bDebugModus)) ) {
 | 
  
    | 78 | 	echo '<strong>'.implode('<br />',$msg).'</strong><br />';
 | 
  
    | 79 | }
 | 
  
    | 80 | // ------------------------------------
 |