Changeset 10607
- Timestamp:
- 11/22/10 19:35:53 (3 years ago)
- Files:
-
- freepbx/trunk/SQL/newinstall.sql (modified) (1 diff)
- freepbx/trunk/SQL/newinstall.sqlite3.sql (modified) (1 diff)
- freepbx/trunk/amp_conf/htdocs/admin/libraries/featurecodes.class.php (modified) (6 diffs)
- freepbx/trunk/upgrades/2.9.0alpha1/tables.php (added)
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
freepbx/trunk/SQL/newinstall.sql
r10580 r10607 129 129 `customcode` varchar(20) default NULL, 130 130 `enabled` tinyint(4) NOT NULL default '0', 131 `providedest` tinyint(4) NOT NULL default '0', 131 132 PRIMARY KEY (`modulename`,`featurename`), 132 133 KEY `enabled` (`enabled`) freepbx/trunk/SQL/newinstall.sqlite3.sql
r10580 r10607 46 46 `customcode` varchar(20) default NULL, 47 47 `enabled` tinyint(4) NOT NULL default '0', 48 `providedest` tinyint(4) NOT NULL default '0', 48 49 PRIMARY KEY (`modulename`,`featurename`) 49 50 -- KEY `enabled` (`enabled`) freepbx/trunk/amp_conf/htdocs/admin/libraries/featurecodes.class.php
r10244 r10607 8 8 var $_customcode; // Custom code 9 9 var $_enabled; // Enabled/Disabled (0=disabled; 1=enabled; -1=unknown) 10 var $_providedest; // 1=provide a featurecode destination for this code to modules 10 11 var $_loaded; // If this feature code was succesfully loaded from the DB 11 12 var $_overridecodes; // Overide defaults from featurecodes.conf … … 45 46 } 46 47 47 $s = "SELECT description, defaultcode, customcode, enabled ";48 $s = "SELECT description, defaultcode, customcode, enabled, providedest "; 48 49 $s .= "FROM featurecodes "; 49 50 $s .= "WHERE modulename = ".sql_formattext($this->_modulename)." AND featurename = ".sql_formattext($this->_featurename)." "; … … 64 65 $this->_customcode = $res[2]; 65 66 $this->_enabled = $res[3]; 67 $this->_providedest = $res[4]; 66 68 67 69 $this->_loaded = true; … … 91 93 'defaultcode = '.sql_formattext($this->_defaultcode).', '. 92 94 'customcode = '.sql_formattext($this->_customcode).', '. 93 'enabled = '.sql_formattext($this->_enabled).' '. 95 'enabled = '.sql_formattext($this->_enabled).', '. 96 'providedest = '.sql_formattext($this->_providedest).' '. 94 97 'WHERE modulename = '.sql_formattext($this->_modulename). 95 98 ' AND featurename = '.sql_formattext($this->_featurename); 96 99 } else { 97 $sql = 'INSERT INTO featurecodes (modulename, featurename, description, defaultcode, customcode, enabled ) '.98 'VALUES ('.sql_formattext($this->_modulename).', '.sql_formattext($this->_featurename).', '.sql_formattext($this->_description).', '.sql_formattext($this->_defaultcode).', '.sql_formattext($this->_customcode).', '.sql_formattext($this->_enabled).') ';100 $sql = 'INSERT INTO featurecodes (modulename, featurename, description, defaultcode, customcode, enabled, providedest) '. 101 'VALUES ('.sql_formattext($this->_modulename).', '.sql_formattext($this->_featurename).', '.sql_formattext($this->_description).', '.sql_formattext($this->_defaultcode).', '.sql_formattext($this->_customcode).', '.sql_formattext($this->_enabled).', '.sql_formattext($this->_providedest).') '; 99 102 } 100 103 … … 204 207 205 208 return ($this->_enabled == 1); 209 } 210 211 // SET to provide destinatinos 212 function setProvideDest($b = true) { 213 if (!$this->isReady()) 214 $this->init(1); 215 216 $this->_providedest = ($b ? 1 : 0); 217 } 218 219 // GET status if providing providedests 220 function isProvideDest() { 221 if (!$this->isReady()) 222 $this->init(1); 223 224 return ($this->_providedest == 1); 206 225 } 207 226 … … 246 265 } 247 266 $s = "SELECT featurecodes.modulename, featurecodes.featurename, featurecodes.description AS featuredescription, featurecodes.enabled AS featureenabled, featurecodes.defaultcode, featurecodes.customcode, "; 248 $s .= "modules.enabled AS moduleenabled ";267 $s .= "modules.enabled AS moduleenabled, featurecodes.providedest "; 249 268 $s .= "FROM featurecodes "; 250 269 $s .= "INNER JOIN modules ON modules.modulename = featurecodes.modulename ";
