1: <?php
 2: 
 3: /**
 4:  * This file contains the upgrade job 11.
 5:  *
 6:  * @package Setup
 7:  * @subpackage UpgradeJob
 8:  * @author marcus.gnass
 9:  * @copyright four for business AG <www.4fb.de>
10:  * @license http://www.contenido.org/license/LIZENZ.txt
11:  * @link http://www.4fb.de
12:  * @link http://www.contenido.org
13:  */
14: 
15: // assert CONTENIDO framework
16: defined('CON_FRAMEWORK') || die('Illegal call: Missing framework initialization - request aborted.');
17: 
18: /**
19:  * Upgrade job 11.
20:  *
21:  * Add column 'uri' in table con_pifa_form so that buttons of type image can
22:  * store an URI to their image.
23:  *
24:  * @package Setup
25:  * @subpackage UpgradeJob
26:  */
27: class cUpgradeJob_0011 extends cUpgradeJobAbstract {
28: 
29:     public $maxVersion = "4.9.3";
30: 
31:     public function _execute() {
32:         global $db, $cfg;
33: 
34:         if ($_SESSION['setuptype'] == 'upgrade' && $cfg['tab']['pifa_form'] != "") {
35:             $db->query('
36:                 ALTER TABLE
37:                     `' . $cfg['tab']['pifa_form'] . '`
38:                 ADD
39:                     `uri`
40:                     VARCHAR(1023)
41:                     DEFAULT NULL
42:                     COMMENT \'URI for image buttons\';');
43:         }
44:     }
45: }
46: