1: <?php
 2: /**
 3:  * This file contains the upgrade job 8.
 4:  *
 5:  * @package    Setup
 6:  * @subpackage UpgradeJob
 7:  * @version    SVN Revision $Rev:$
 8:  *
 9:  * @author     Simon Sprankel
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: /**
19:  * Upgrade job 8.
20:  * Copies the content of the con_plugins."path" column to the "folder" column
21:  * and deletes the "path" column afterwards.
22:  *
23:  * @package Setup
24:  * @subpackage UpgradeJob
25:  */
26: class cUpgradeJob_0008 extends cUpgradeJobAbstract {
27: 
28:     public $maxVersion = "4.9.0-beta1";
29: 
30:     public function _execute() {
31:         global $cfg, $db;
32: 
33:         if ($this->_setupType == 'upgrade') {
34:             // check if the column "path" still exists
35:             $db->query('SHOW COLUMNS FROM `%s`;', $cfg['tab']['plugins']);
36: 
37:             $columns = array();
38:             while ($db->nextRecord()) {
39:                 $columns[] = $db->f('Field');
40:             }
41: 
42:             if (in_array('path', $columns)) {
43:                 // copy path to folder
44:                 $db->query('UPDATE `%s` SET folder = path;', $cfg['tab']['plugins']);
45:                 // drop column "path"
46:                 $db->query('ALTER TABLE `%s` DROP path;', $cfg['tab']['plugins']);
47:             }
48:         }
49:     }
50: 
51: }
52: