1: <?php
  2: /**
  3:  * This file contains the upgrade job 2.
  4:  *
  5:  * @package Setup
  6:  * @subpackage UpgradeJob
  7:  * @version SVN Revision $Rev:$
  8:  *
  9:  * @author Murat Purc <murat@purc>
 10:  * @copyright four for business AG <www.4fb.de>
 11:  * @license http://www.contenido.org/license/LIZENZ.txt
 12:  * @link http://www.4fb.de
 13:  * @link http://www.contenido.org
 14:  */
 15: 
 16: defined('CON_FRAMEWORK') || die('Illegal call: Missing framework initialization - request aborted.');
 17: 
 18: global $cfg;
 19: checkAndInclude($cfg['path']['contenido'] . 'includes/functions.api.string.php');
 20: 
 21: /**
 22:  * Upgrade job 2.
 23:  * Runs the upgrade job to takeover new module concept.
 24:  *
 25:  * @package Setup
 26:  * @subpackage UpgradeJob
 27:  */
 28: class cUpgradeJob_0002 extends cUpgradeJobAbstract {
 29: 
 30:     public $maxVersion = "4.9.0-alpha1";
 31: 
 32:     /**
 33:      * This method will transfer the moduls from $cfg['tab']['mod'] to the
 34:      * file system.
 35:      * This Method will be called by setup
 36:      */
 37:     private function _convertModulesToFile($clientId) {
 38:         global $cfg;
 39: 
 40:         $db = getSetupMySQLDBConnection();
 41: 
 42:         $sql = sprintf("SELECT * FROM %s WHERE idclient='%s' ORDER BY idmod", $cfg['tab']['mod'], $clientId);
 43:         $db->query($sql);
 44: 
 45:         $moduleHandler = new cModuleHandler();
 46: 
 47:         while ($db->nextRecord()) {
 48:             // init the ModulHandler with all data of the modul
 49:             // inclusive client
 50:             $moduleHandler->initWithDatabaseRow($db);
 51: 
 52:             // make new module only if modul not exist in directory
 53:             if ($moduleHandler->modulePathExists() != true) {
 54:                 // we need no error handling here because module could still
 55:                 // exist from previous version
 56:                 if ($moduleHandler->createModule($db->f('input'), $db->f('output')) == true) {
 57:                     // save module translation
 58:                     $translations = new cModuleFileTranslation($db->f('idmod'));
 59:                     $translations->saveTranslations();
 60:                 }
 61:             }
 62:         }
 63: 
 64:         // update input and output fields
 65:         $sql = sprintf("UPDATE %s SET input = '', output = '' WHERE idclient='%s'", $cfg['tab']['mod'], $clientId);
 66:         $db->query($sql);
 67:     }
 68: 
 69:     public function _execute() {
 70:         global $cfg;
 71:         global $client, $lang, $cfgClient;
 72: 
 73:         if ($this->_setupType != 'upgrade') {
 74:             return;
 75:         }
 76: 
 77:         $sql = "SHOW COLUMNS FROM %s LIKE 'frontendpath'";
 78:         $sql = sprintf($sql, $cfg['tab']['clients']);
 79: 
 80:         $this->_oDb->query($sql);
 81:         if ($this->_oDb->numRows() != 0) {
 82:             $sql = "SELECT * FROM " . $cfg['tab']['clients'];
 83:             $this->_oDb->query($sql);
 84: 
 85:             while ($this->_oDb->nextRecord()) {
 86:                 updateClientCache($this->_oDb->f("idclient"), $this->_oDb->f("htmlpath"), $this->_oDb->f("frontendpath"));
 87:             }
 88: 
 89:             $sql = sprintf("ALTER TABLE %s DROP htmlpath", $cfg['tab']['clients']);
 90:             $this->_oDb->query($sql);
 91: 
 92:             $sql = sprintf("ALTER TABLE %s DROP frontendpath", $cfg['tab']['clients']);
 93:             $this->_oDb->query($sql);
 94:         }
 95: 
 96:         $cfgClient = updateClientCache();
 97: 
 98:         $clientBackup = $client;
 99:         $langBackup = $lang;
100: 
101:         $db2 = getSetupMySQLDBConnection();
102: 
103:         // Update module aliases
104:         $this->_oDb->query("SELECT * FROM `%s`", $cfg['tab']['mod']);
105:         while ($this->_oDb->nextRecord()) {
106:             $newName = strtolower(cModuleHandler::getCleanName($this->_oDb->f('name')));
107:             $sql = $db2->prepare("UPDATE `%s` SET `alias` = '%s' WHERE `idmod` = %d", $cfg['tab']['mod'], $newName, $this->_oDb->f('idmod'));
108:             $db2->query($sql);
109:         }
110: 
111:         // Update layout aliases
112:         $this->_oDb->query("SELECT * FROM `%s`", $cfg['tab']['lay']);
113:         while ($this->_oDb->nextRecord()) {
114:             $newName = cModuleHandler::getCleanName(strtolower($this->_oDb->f('name')));
115:             $sql = $db2->prepare("UPDATE `%s` SET `alias` = '%s' WHERE `idlay` = %d", $cfg['tab']['lay'], $newName, $this->_oDb->f('idlay'));
116:             $db2->query($sql);
117:         }
118: 
119:         // Makes the new concept of modules (save the modules to the file) save the translation
120:         foreach ($cfgClient as $iClient => $aClient) {
121:             if ((int) $iClient == 0) {
122:                 continue;
123:             }
124: 
125:             $client = $iClient; // this should work for all clients now
126: 
127:             // Save all modules from db-table to the filesystem if exists
128:             $this->_oDb->query("SHOW COLUMNS FROM `%s` LIKE 'output'", $cfg['tab']['mod']);
129:             if ($this->_oDb->numRows() > 0) {
130:                 $this->_convertModulesToFile($client);
131:             }
132: 
133:             // Save all layouts from db-table to the filesystem if exists
134:             $this->_oDb->query("SHOW COLUMNS FROM `%s` LIKE 'code'", $cfg['tab']['lay']);
135:             if ($this->_oDb->numRows() > 0) {
136:                 cLayoutHandler::upgrade($this->_oDb, $cfg, $client);
137:             }
138:         }
139: 
140:         $client = $clientBackup;
141:         $lang = $langBackup;
142:     }
143: }
144: