/modules/endpointmanager-1.0/endpointman/install.php
PHP | 1041 lines | 859 code | 158 blank | 24 comment | 45 complexity | 8ab89b728d14b3b164a740134d8fd50e MD5 | raw file
- <?PHP
- ini_set('display_errors', 1);
- error_reporting(E_ALL);
- /*
- Endpoint Manager V2
- Copyright (C) 2009-2010 Ed Macri, John Mullinix and Andrew Nagy
- This program is free software; you can redistribute it and/or
- modify it under the terms of the GNU General Public License
- as published by the Free Software Foundation; either version 2
- of the License, or (at your option) any later version.
- This program is distributed in the hope that it will be useful,
- but WITHOUT ANY WARRANTY; without even the implied warranty of
- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
- GNU General Public License for more details.
- You should have received a copy of the GNU General Public License
- along with this program; if not, write to the Free Software
- Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
- http://www.gnu.org/licenses/old-licenses/gpl-2.0.html
- */
- if (! function_exists("out")) {
- function out($text) {
- echo $text."<br />";
- }
- }
- if (! function_exists("outn")) {
- function outn($text) {
- echo $text;
- }
- }
- function find_exec($exec) {
- $usr_bin = glob("/usr/bin/".$exec);
- $usr_sbin = glob("/usr/sbin/".$exec);
- $sbin = glob("/sbin/".$exec);
- $bin = glob("/bin/".$exec);
- $etc = glob("/etc/".$exec);
- if(isset($usr_bin[0])) {
- return("/usr/bin/".$exec);
- } elseif(isset($usr_sbin[0])) {
- return("/usr/sbin/".$exec);
- } elseif(isset($sbin[0])) {
- return("/sbin/".$exec);
- } elseif(isset($bin[0])) {
- return("/bin/".$exec);
- } elseif(isset($etc[0])) {
- return("/etc/".$exec);
- } else {
- return($exec);
- }
- }
- global $db;
- out("Endpoint Manager Installer");
- define("PHONE_MODULES_PATH", $amp_conf['AMPWEBROOT'].'/admin/modules/_ep_phone_modules/');
- define("LOCAL_PATH", $amp_conf['AMPWEBROOT'].'/admin/modules/endpointman/');
- if(!file_exists(PHONE_MODULES_PATH)) {
- mkdir(PHONE_MODULES_PATH, 0764);
- out("Creating Phone Modules Directory");
- }
- if(!file_exists(PHONE_MODULES_PATH."setup.php")) {
- copy(LOCAL_PATH."Install/setup.php",PHONE_MODULES_PATH."setup.php");
- out("Moving Auto Provisioner Class");
- }
- if(!file_exists(PHONE_MODULES_PATH."temp/")) {
- mkdir(PHONE_MODULES_PATH."temp/", 0764);
- out("Creating temp folder");
- }
- //Detect Version
- function ep_table_exists ($table) {
- global $db;
- $sql = "SHOW TABLES FROM asterisk";
- $result = $db->getAll($sql);
- foreach($result as $row) {
- if ($row[0] == $table) {
- return TRUE;
- }
- }
- return FALSE;
- }
- $version = "2.2.3";
- if(ep_table_exists("endpointman_global_vars")) {
- $global_cfg =& $db->getAssoc("SELECT var_name, value FROM endpointman_global_vars");
- } else {
- $global_cfg['version'] = '?';
- }
- $new_install = FALSE;
- if(!isset($global_cfg['version'])) {
- $ver = "1.0.3";
- } elseif($global_cfg['version'] == '2.0') {
- $ver = "1.9.0";
- } elseif($global_cfg['version'] == '1.9.1') {
- $ver = "1.9.1";
- } elseif($global_cfg['version'] == '1.9.2') {
- $ver = "1.9.2";
- } elseif($global_cfg['version'] == '1.9.3') {
- $ver = "1.9.3";
- } elseif($global_cfg['version'] == '1.9.4') {
- $ver = "1.9.4";
- } elseif($global_cfg['version'] == '1.9.5') {
- $ver = "1.9.5";
- } elseif($global_cfg['version'] == '1.9.6') {
- $ver = "1.9.6";
- } elseif($global_cfg['version'] == '1.9.7') {
- $ver = "1.9.7";
- } elseif($global_cfg['version'] == '1.9.8') {
- $ver = "1.9.8";
- } elseif($global_cfg['version'] == '1.9.9') {
- $ver = "1.9.9";
- } elseif($global_cfg['version'] == '2.0.0') {
- $ver = "2.0.0";
- } elseif($global_cfg['version'] == '2.2.0') {
- $ver = "2.2.0";
- } elseif($global_cfg['version'] == '2.2.1') {
- $ver = "2.2.1";
- } elseif($global_cfg['version'] == '2.2.2') {
- $ver = "2.2.2";
- } else {
- $ver = "1000";
- $new_install = TRUE;
- }
- $ver = (float) $ver;
- if($new_install) {
- out('New Installation Detected!');
- } else {
- out('Version Identified as '. $ver);
- }
- if(($ver < "1.9.0") AND ($ver > 0)) {
- out("Please Wait While we upgrade your old setup");
- //Expand the value option
- $sql = 'ALTER TABLE `endpointman_global_vars` CHANGE `value` `value` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT \'Data\'';
- $db->query($sql);
- out("Locating NMAP + ARP + ASTERISK Executables");
- $nmap = find_exec("nmap");
- $arp = find_exec("arp");
- $asterisk = find_exec("asterisk");
- out("Updating Global Variables table");
- //Add new Vars into database
- $sql_update_vars = "INSERT INTO `endpointman_global_vars` (`idnum`, `var_name`, `value`) VALUES
- (5, 'config_location', '/tftpboot/'),
- (6, 'update_server', 'http://www.provisioner.net/release/'),
- (7, 'version', '2.0.0'),
- (8, 'enable_ari', '0'),
- (9, 'debug', '0'),
- (10, 'arp_location', '".$arp."'),
- (11, 'nmap_location', '".$nmap."'),
- (12, 'asterisk_location', '".$asterisk."'),
- (13, 'language', ''),
- (14, 'check_updates', '1'),
- (15, 'disable_htaccess', ''),
- (16, 'endpoint_vers', '0')";
- $db->query($sql_update_vars);
- out("Updating Mac List table");
- $sql = 'ALTER TABLE `endpointman_mac_list` DROP `map`';
- $db->query($sql);
- $sql = 'ALTER TABLE `endpointman_mac_list` ADD `custom_cfg_template` INT(11) NOT NULL AFTER `description`';
- $db->query($sql);
- $sql = 'ALTER TABLE `endpointman_mac_list` ADD `custom_cfg_data` TEXT NOT NULL AFTER `custom_cfg_template`';
- $db->query($sql);
- $sql = 'ALTER TABLE `endpointman_mac_list` ADD `user_cfg_data` TEXT NOT NULL AFTER `custom_cfg_data`';
- $db->query($sql);
- $sql = 'ALTER TABLE `endpointman_mac_list` ADD `config_files_override` TEXT NOT NULL AFTER `user_cfg_data`';
- $db->query($sql);
- out("Updating Brands table");
- $sql = 'DROP TABLE endpointman_brand_list';
- $db->query($sql);
- $sql = "CREATE TABLE IF NOT EXISTS `endpointman_brand_list` (
- `id` int(11) NOT NULL auto_increment,
- `name` varchar(255) NOT NULL,
- `directory` varchar(255) NOT NULL,
- `cfg_ver` varchar(255) NOT NULL,
- `installed` int(1) NOT NULL default '0',
- `hidden` int(1) NOT NULL default '0',
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=22";
- $db->query($sql);
- out("Updating Models table");
- $sql = 'DROP TABLE endpointman_model_list';
- $db->query($sql);
- $sql = "CREATE TABLE IF NOT EXISTS `endpointman_model_list` (
- `id` int(11) NOT NULL auto_increment COMMENT 'Key ',
- `brand` int(11) NOT NULL COMMENT 'Brand',
- `model` varchar(25) NOT NULL COMMENT 'Model',
- `product_id` int(11) NOT NULL,
- `enabled` int(1) NOT NULL default '0',
- `hidden` int(1) NOT NULL default '0',
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=48";
- $db->query($sql);
- out("Updating OUI table");
- $sql = 'DROP TABLE endpointman_oui_list';
- $db->query($sql);
- $sql = "CREATE TABLE IF NOT EXISTS `endpointman_oui_list` (
- `id` int(30) NOT NULL auto_increment,
- `oui` varchar(30) default NULL,
- `brand` int(11) default NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=57";
- $db->query($sql);
- out("Updating Products table");
- $sql = 'DROP TABLE IF EXISTS endpointman_product_list';
- $db->query($sql);
- $sql = "CREATE TABLE IF NOT EXISTS `endpointman_product_list` (
- `id` int(11) NOT NULL auto_increment,
- `brand` int(11) NOT NULL,
- `long_name` varchar(255) NOT NULL,
- `cfg_dir` varchar(255) NOT NULL,
- `cfg_ver` varchar(255) NOT NULL,
- `xml_data` varchar(255) NOT NULL,
- `cfg_data` text NOT NULL,
- `installed` int(1) NOT NULL default '0',
- `hidden` int(1) NOT NULL default '0',
- `firmware_vers` varchar(255) NOT NULL,
- `firmware_files` text NOT NULL,
- `config_files` text,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8";
- $db->query($sql);
- out("Updating templates table");
- $sql = 'DROP TABLE IF EXISTS endpointman_template_list';
- $db->query($sql);
- $sql = "CREATE TABLE IF NOT EXISTS `endpointman_template_list` (
- `id` int(11) NOT NULL auto_increment,
- `product_id` int(11) NOT NULL,
- `name` varchar(255) NOT NULL,
- `custom_cfg_data` text,
- `config_files_override` text,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8";
- $db->query($sql);
- $sql = "CREATE TABLE IF NOT EXISTS `endpointman_custom_configs` (
- `id` int(11) NOT NULL auto_increment,
- `name` varchar(255) NOT NULL,
- `original_name` varchar(255) NOT NULL,
- `product_id` int(11) NOT NULL,
- `data` longtext NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11";
- $db->query($sql);
- $old_models = array(
- "57iCT" => array("brand" => 1, "model" => 2, "product" => 7),
- "57i" => array("brand" => 1, "model" => 3, "product" => 7),
- "330" => array("brand" => 4, "model" => 6, "product" => 4),
- "560" => array("brand" => 4, "model" => 7, "product" => 4),
- "300" => array("brand" => 6, "model" => 8, "product" => 8),
- "320" => array("brand" => 6, "model" => 9, "product" => 8),
- "360" => array("brand" => 6, "model" => 10, "product" => 8),
- "370" => array("brand" => 6, "model" => 11, "product" => 8),
- "820" => array("brand" => 6, "model" => 12, "product" => 8),
- "M3" => array("brand" => 6, "model" => 13, "product" => 8),
- "GXP-2000" => array("brand" => 2, "model" => 15, "product" => 1),
- "BT200_201" => array("brand" => 2, "model" => 27, "product" => 2),
- "spa941" => array("brand" => 0, "model" => 0, "product" => 0),
- "spa942" => array("brand" => 0, "model" => 0, "product" => 0),
- "spa962" => array("brand" => 0, "model" => 0, "product" => 0),
- "55i" => array("brand" => 1, "model" => 4, "product" => 7)
- );
- out("Migrating Old Devices");
- $sql = "SELECT * FROM endpointman_mac_list";
- $result = $db->query($sql);
- while($row =& $result->fetchRow(DB_FETCHMODE_ASSOC)) {
- $id = $row['model'];
- $new_model = $old_models[$id]['model'];
- $sql = "UPDATE endpointman_mac_list SET model = ".$new_model." WHERE id =" . $row['id'];
- $db->query($sql);
- }
- out("Old Devices Migrated, You must install the phone modules from within endpointmanager to see your old devices!");
- $sql = 'ALTER TABLE endpointman_mac_list CHANGE model model INT NOT NULL';
- $db->query($sql);
- $sql = "ALTER TABLE endpointman_mac_list CHANGE custom_cfg_data custom_cfg_data TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL";
- $db->query($sql);
- out("DONE! You can now use endpoint manager!");
- }
- if ($ver <= "1.9.0") {
- out("Locating NMAP + ARP + ASTERISK Executables");
- $nmap = find_exec("nmap");
- $arp = find_exec("arp");
- $asterisk = find_exec("asterisk");
- out("Updating Global Variables table");
- //Add new Vars into database
- $sql_update_vars = "INSERT INTO `endpointman_global_vars` (`idnum`, `var_name`, `value`) VALUES (8, 'enable_ari', '0')";
- $db->query($sql_update_vars);
- $sql_update_vars = "INSERT INTO `endpointman_global_vars` (`idnum`, `var_name`, `value`) VALUES (9, 'debug', '0')";
- $db->query($sql_update_vars);
- $sql_update_vars = "INSERT INTO `endpointman_global_vars` (`idnum`, `var_name`, `value`) VALUES (10, 'arp_location', '".$arp."')";
- $db->query($sql_update_vars);
- $sql_update_vars = "INSERT INTO `endpointman_global_vars` (`idnum`, `var_name`, `value`) VALUES (11, 'nmap_location', '".$nmap."')";
- $db->query($sql_update_vars);
- $sql_update_vars = "INSERT INTO `endpointman_global_vars` (`idnum`, `var_name`, `value`) VALUES (12, 'asterisk_location', '".$asterisk."')";
- $db->query($sql_update_vars);
- out("Updating Mac List Table");
- $sql = 'ALTER TABLE `endpointman_mac_list` ADD `user_cfg_data` TEXT NOT NULL AFTER `custom_cfg_data`';
- $db->query($sql);
- $sql = 'ALTER TABLE `endpointman_mac_list` ADD `config_files_override` TEXT NOT NULL AFTER `user_cfg_data`';
- $db->query($sql);
- out("Updating OUI Table");
- $sql = 'ALTER TABLE `endpointman_oui_list` DROP model';
- $db->query($sql);
- $sql = 'ALTER TABLE `endpointman_oui_list` CHANGE `brand` `brand` INT( 11 ) NULL DEFAULT NULL';
- $db->query($sql);
- out("Updating Product List");
- $sql = 'ALTER TABLE `endpointman_product_list` ADD `firmware_vers` TEXT NULL AFTER `hidden`';
- $db->query($sql);
- $sql = 'ALTER TABLE `endpointman_product_list` ADD `firmware_files` VARCHAR( 255 ) NOT NULL AFTER `firmware_vers`';
- $db->query($sql);
- $sql = 'ALTER TABLE `endpointman_product_list` ADD `config_files_override` TEXT NULL AFTER `firmware_files`';
- $db->query($sql);
- out("Updating Template List");
- $sql = 'ALTER TABLE `endpointman_template_list` ADD `config_files_override` TEXT NULL AFTER `custom_cfg_data`';
- out("Updating Version Number");
- $sql = "UPDATE endpointman_global_vars SET value = '2.0.0' WHERE var_name = 'version'";
- out("Creating Custom Configs Table");
- $sql = "CREATE TABLE IF NOT EXISTS `endpointman_custom_configs` (
- `id` int(11) NOT NULL auto_increment,
- `name` varchar(255) NOT NULL,
- `original_name` varchar(255) NOT NULL,
- `product_id` int(11) NOT NULL,
- `data` longtext NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11";
- $db->query($sql);
- out('Alter custom_cfg_data');
- $sql = "ALTER TABLE endpointman_mac_list CHANGE custom_cfg_data custom_cfg_data TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL";
- $db->query($sql);
- }
- if ($ver <= "1.9.1") {
- out("Create Custom Configs Table");
- $sql = "CREATE TABLE IF NOT EXISTS `endpointman_custom_configs` (
- `id` int(11) NOT NULL auto_increment,
- `name` varchar(255) NOT NULL,
- `original_name` varchar(255) NOT NULL,
- `product_id` int(11) NOT NULL,
- `data` longtext NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11";
- $db->query($sql);
- out("Locating NMAP + ARP + ASTERISK Executables");
- $nmap = find_exec("nmap");
- $arp = find_exec("arp");
- $asterisk = find_exec("asterisk");
- out('Updating Global Variables');
- $sql_update_vars = "INSERT INTO `endpointman_global_vars` (`idnum`, `var_name`, `value`) VALUES (8, 'enable_ari', '0')";
- $db->query($sql_update_vars);
- $sql_update_vars = "INSERT INTO `endpointman_global_vars` (`idnum`, `var_name`, `value`) VALUES (9, 'debug', '0')";
- $db->query($sql_update_vars);
- $sql_update_vars = "INSERT INTO `endpointman_global_vars` (`idnum`, `var_name`, `value`) VALUES (10, 'arp_location', '".$arp."')";
- $db->query($sql_update_vars);
- $sql_update_vars = "INSERT INTO `endpointman_global_vars` (`idnum`, `var_name`, `value`) VALUES (11, 'nmap_location', '".$nmap."')";
- $db->query($sql_update_vars);
- $sql_update_vars = "INSERT INTO `endpointman_global_vars` (`idnum`, `var_name`, `value`) VALUES (12, 'asterisk_location', '".$asterisk."')";
- $db->query($sql_update_vars);
- out("Update Mac List Table");
- $sql = 'ALTER TABLE `endpointman_mac_list` ADD `config_files_override` TEXT NOT NULL AFTER `user_cfg_data`';
- $db->query($sql);
- out("Update Product List Table");
- $sql = 'ALTER TABLE `endpointman_product_list` ADD `config_files` TEXT NOT NULL AFTER `firmware_files`';
- $db->query($sql);
- out("Update Template List Table");
- $sql = 'ALTER TABLE `endpointman_template_list` ADD `config_files_override` TEXT NOT NULL AFTER `custom_cfg_data`';
- $db->query($sql);
- out("Update Version Number");
- $sql = 'UPDATE endpointman_global_vars SET value = \'2.0.0\' WHERE var_name = "version"';
- $db->query($sql);
- out('Alter custom_cfg_data');
- $sql = "ALTER TABLE endpointman_mac_list CHANGE custom_cfg_data custom_cfg_data TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL";
- $db->query($sql);
- }
- if ($ver <= "1.9.2") {
- out('Updating Global Variables');
- }
- if ($ver <= "1.9.9") {
- out("Adding Custom Field to OUI List");
- $sql = 'ALTER TABLE `endpointman_oui_list` ADD `custom` INT(1) NOT NULL DEFAULT \'0\'';
- $db->query($sql);
- out("Increase value Size in global Variables Table");
- $sql = 'ALTER TABLE `endpointman_global_vars` CHANGE `value` `value` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT \'Data\'';
- $db->query($sql);
- out("Update global variables to include future language support");
- $sql = 'INSERT INTO `asterisk`.`endpointman_global_vars` (`idnum`, `var_name`, `value`) VALUES (\'13\', \'temp_amp\', \'\');';
- $db->query($sql);
- $sql = "UPDATE endpointman_global_vars SET var_name = 'language' WHERE var_name = 'temp_amp'";
- $db->query($sql);
- out("Changing all 'LONG TEXT' or 'TEXT' to 'BLOB'");
- $sql = 'ALTER TABLE `endpointman_product_list` CHANGE `cfg_data` `cfg_data` BLOB NOT NULL';
- $db->query($sql);
- $sql = 'ALTER TABLE `endpointman_template_list` CHANGE `custom_cfg_data` `custom_cfg_data` BLOB NULL DEFAULT NULL';
- $db->query($sql);
- $sql = 'ALTER TABLE `endpointman_mac_list` CHANGE `custom_cfg_data` `custom_cfg_data` BLOB NOT NULL, CHANGE `user_cfg_data` `user_cfg_data` BLOB NOT NULL';
- $db->query($sql);
- $sql = 'ALTER TABLE `endpointman_custom_configs` CHANGE `data` `data` BLOB NOT NULL';
- $db->query($sql);
- $sql = 'ALTER TABLE `endpointman_product_list` ADD `special_cfgs` BLOB NOT NULL;';
- $db->query($sql);
- out("Inserting Check for Updates Command");
- $sql = 'INSERT INTO `asterisk`.`endpointman_global_vars` (`idnum`, `var_name`, `value`) VALUES (\'14\', \'check_updates\', \'1\');';
- $db->query($sql);
- out("Inserting Disable .htaccess command");
- $sql = 'INSERT INTO `asterisk`.`endpointman_global_vars` (`idnum`, `var_name`, `value`) VALUES (\'15\', \'disable_htaccess\', \'0\');';
- $db->query($sql);
- out("Add Automatic Update Check [Can be Disabled]");
- $sql = "INSERT INTO cronmanager (module, id, time, freq, lasttime, command) VALUES ('endpointman', 'UPDATES', '23', '24', '0', 'php ".LOCAL_PATH. "includes/update_check.php')";
- $db->query($sql);
- }
- if($ver <= "2.0.0") {
- if(file_exists($amp_conf['AMPWEBROOT']."/recordings")) {
- out("Installing ARI Module");
- copy(LOCAL_PATH. "Install/phonesettings.module", $amp_conf['AMPWEBROOT']."/recordings/modules/phonesettings.module");
- copy(LOCAL_PATH. "templates/javascript/jquery.coda-slider-2.0.js", $amp_conf['AMPWEBROOT']."/recordings/theme/js/jquery.coda-slider-2.0.js");
- copy(LOCAL_PATH. "templates/javascript/jquery.easing.1.3.js", $amp_conf['AMPWEBROOT']."/recordings/theme/js/jquery.easing.1.3.js");
- copy(LOCAL_PATH. "templates/stylesheets/coda-slider-2.0a.css", $amp_conf['AMPWEBROOT']."/recordings/theme/coda-slider-2.0a.css");
- out("Fixing permissions on ARI module");
- chmod($amp_conf['AMPWEBROOT']."/recordings/modules/phonesettings.module", 0664);
- }
- out("Locating NMAP + ARP + ASTERISK Executables");
- $nmap = find_exec("nmap");
- $arp = find_exec("arp");
- $asterisk = find_exec("asterisk");
- $sql_update_vars = "INSERT INTO `endpointman_global_vars` (`idnum`, `var_name`, `value`) VALUES (11, 'nmap_location', '".$asterisk."')";
- $db->query($sql_update_vars);
- $sql_update_vars = "INSERT INTO `endpointman_global_vars` (`idnum`, `var_name`, `value`) VALUES (11, 'nmap_location', '".$nmap."')";
- $db->query($sql_update_vars);
- $sql_update_vars = "INSERT INTO `endpointman_global_vars` (`idnum`, `var_name`, `value`) VALUES (12, 'asterisk_location', '".$asterisk."')";
- $db->query($sql_update_vars);
- out("Add Unique to Global Variables Table");
- $sql = 'ALTER TABLE `endpointman_global_vars` ADD UNIQUE(`var_name`)';
- $db->query($sql);
- $sql = 'ALTER TABLE `endpointman_custom_configs` CHANGE `product_id` `product_id` VARCHAR(11) NOT NULL';
- $db->query($sql);
- $sql = 'ALTER TABLE `endpointman_mac_list` CHANGE `model` `model` VARCHAR(11) NOT NULL';
- $db->query($sql);
- $sql = 'ALTER TABLE `endpointman_model_list` ADD `template_list` TEXT NOT NULL AFTER `model`, ADD `template_data` BLOB NOT NULL AFTER `template_list`';
- $db->query($sql);
- $sql = 'ALTER TABLE `endpointman_model_list` CHANGE `product_id` `product_id` VARCHAR(11) NOT NULL';
- $db->query($sql);
- $sql = 'ALTER TABLE `endpointman_model_list` CHANGE `id` `id` VARCHAR(11) NOT NULL COMMENT \'Key \'';
- $db->query($sql);
- $sql = 'ALTER TABLE `endpointman_product_list` CHANGE `id` `id` VARCHAR(11) NOT NULL';
- $db->query($sql);
- $sql = 'ALTER TABLE `endpointman_product_list` ADD `short_name` VARCHAR(255) NOT NULL AFTER `long_name`';
- $db->query($sql);
- $sql = 'ALTER TABLE `endpointman_product_list` DROP `installed`';
- $db->query($sql);
- $sql = 'ALTER TABLE `endpointman_product_list` DROP `xml_data`';
- $db->query($sql);
- $sql = 'ALTER TABLE `endpointman_template_list` ADD `model_id` VARCHAR(10) NOT NULL AFTER `product_id`';
- $db->query($sql);
- $sql = 'ALTER TABLE `endpointman_template_list` CHANGE `product_id` `product_id` VARCHAR(11) NOT NULL';
- $db->query($sql);
- $sql = "UPDATE endpointman_brand_list SET cfg_ver = '0', installed = '0' WHERE installed = '1'";
- $db->query($sql);
- $sql = "TRUNCATE TABLE `endpointman_product_list`";
- $db->query($sql);
- $sql = "TRUNCATE TABLE `endpointman_oui_list`";
- $db->query($sql);
- $sql = "TRUNCATE TABLE `endpointman_brand_list`";
- $db->query($sql);
- $sql = "TRUNCATE TABLE `endpointman_model_list`";
- $db->query($sql);
- $data =& $db->getAll("SELECT * FROM `endpointman_mac_list",array(), DB_FETCHMODE_ASSOC);
- $new_model_list = array(
- "2" => "1-2-11",
- "3" => "1-2-10",
- "4" => "1-2-9",
- "6" => "",
- "7" => "",
- "8" => "6-1-1",
- "9" => "6-1-2",
- "10" => "6-1-3",
- "11" => "6-1-4",
- "12" => "6-1-5",
- "13" => "6-1-6",
- "15" => "2-1-3",
- "22" => "",
- "23" => "2-1-2",
- "24" => "2-1-1",
- "25" => "2-1-4",
- "26" => "2-1-5",
- "27" => "2-2-1",
- "28" => "2-2-2",
- "29" => "",
- "30" => "",
- "31" => "",
- "32" => "",
- "33" => "",
- "34" => "4-3-1",
- "35" => "4-3-2",
- "36" => "4-3-3",
- "37" => "4-3-4",
- "38" => "4-3-5",
- "39" => "4-3-6",
- "40" => "4-3-8",
- "41" => "4-3-9",
- "42" => "4-3-10",
- "43" => "4-3-11",
- "44" => "4-3-12",
- "45" => "",
- "46" => "",
- "47" => "1-2-1",
- "48" => "1-2-2",
- "49" => "1-1-1",
- "50" => "1-1-2",
- "51" => "1-2-3",
- "52" => "1-2-4",
- "53" => "1-2-5",
- "54" => "1-2-6",
- "55" => "1-2-7",
- "56" => "1-2-8",
- "57" => "",
- "58" => "",
- "59" => "",
- "60" => "7-1-1",
- "61" => "7-1-2",
- "62" => "8-1-1",
- "63" => "8-1-2",
- "64" => "8-1-3",
- "65" => "8-1-4",
- "67" => "7-2-1",
- "68" => "7-2-2",
- "69" => "7-2-3",
- "70" => "7-2-4",
- "71" => "7-2-5",
- "72" => "7-2-6"
- );
- foreach($data as $list) {
- $sql = "UPDATE endpointman_mac_list SET model = '".$new_model_list[$list['id']]."' WHERE id = ". $list['id'];
- $db->query($sql);
- }
- $new_product_list = array(
- "6" => array("product_id" => "1-1", "model_id" => "1-1-1"),
- "7" => array("product_id" => "1-2", "model_id" => "1-2-1"),
- "1" => array("product_id" => "2-1", "model_id" => "2-1-1"),
- "2" => array("product_id" => "2-2", "model_id" => "2-2-1"),
- "3" => array("product_id" => "", "model_id" => ""),
- "5" => array("product_id" => "", "model_id" => ""),
- "4" => array("product_id" => "4-3", "model_id" => "4-3-1"),
- "8" => array("product_id" => "6-1", "model_id" => "6-1-1"),
- "9" => array("product_id" => "7-1", "model_id" => "7-1-1"),
- "11" => array("product_id" => "7-2", "model_id" => "7-2-1"),
- "10" => array("product_id" => "8-1", "model_id" => "8-1-1")
- );
- $data = array();
- $data =& $db->getAll("SELECT * FROM endpointman_custom_configs",array(), DB_FETCHMODE_ASSOC);
- foreach($data as $list) {
- $sql = "UPDATE endpointman_custom_configs SET product_id = '".$new_product_list[$list['product_id']]['product_id']."' WHERE id = ". $list['id'];
- $db->query($sql);
- }
- $data = array();
- $data =& $db->getAll("SELECT * FROM endpointman_template_list",array(), DB_FETCHMODE_ASSOC);
- foreach($data as $list) {
- $sql = "UPDATE endpointman_template_list SET model_id = '".$new_product_list[$list['model_id']]['model_id']."', product_id = '".$new_product_list[$list['product_id']]['product_id']."' WHERE id = ". $list['id'];
- $db->query($sql);
- }
- $data = array();
- $data =& $db->getAll("SELECT * FROM endpointman_custom_configs",array(), DB_FETCHMODE_ASSOC);
- $variable_change = array(
- "{\$srvip}" => "{\$server.ip.1}",
- "{\$ext}" => "{\$ext.line.1}",
- "{\$pass}" => "{\$pass.line.1}",
- "{\$secret}" => "{\$pass.line.1}",
- "{\$displayname}" => "{\$displayname.line.1}"
- );
- foreach($data as $list) {
- foreach($variable_change as $key => $value) {
- $list['data'] = str_replace($key, $value, $list['data']);
- }
- $sql = "UPDATE endpointman_custom_configs SET data = '".addslashes($list['data'])."' WHERE id = ". $list['id'];
- $db->query($sql);
- }
- exec("rm -Rf ".PHONE_MODULES_PATH);
- if(!file_exists(PHONE_MODULES_PATH)) {
- mkdir(PHONE_MODULES_PATH, 0764);
- out("Creating Phone Modules Directory");
- }
- if(!file_exists(PHONE_MODULES_PATH."setup.php")) {
- copy(LOCAL_PATH."Install/setup.php",PHONE_MODULES_PATH."setup.php");
- out("Moving Auto Provisioner Class");
- }
- if(!file_exists(PHONE_MODULES_PATH."temp/")) {
- mkdir(PHONE_MODULES_PATH."temp/", 0764);
- out("Creating temp folder");
- }
- }
- if ($ver <= "2.2.1") {
- }
- if ($ver <= "2.2.2") {
- out("Remove all Dashes in IDs");
- $data = array();
- $data =& $db->getAll("SELECT * FROM `endpointman_model_list",array(), DB_FETCHMODE_ASSOC);
- foreach($data as $list) {
- $new_model_id = str_replace("-", "", $list['id']);
- $sql = "UPDATE endpointman_model_list SET id = '".$new_model_id."' WHERE id = ". $list['id'];
- $db->query($sql);
- }
- $data = array();
- $data =& $db->getAll("SELECT * FROM `endpointman_product_list",array(), DB_FETCHMODE_ASSOC);
- foreach($data as $list) {
- $new_product_id = str_replace("-", "", $list['id']);
- $sql = "UPDATE endpointman_product_list SET id = '".$new_product_id."' WHERE id = ". $list['id'];
- $db->query($sql);
- }
- $data = array();
- $data =& $db->getAll("SELECT * FROM `endpointman_mac_list",array(), DB_FETCHMODE_ASSOC);
- foreach($data as $list) {
- $new_model_id = str_replace("-", "", $list['model']);
- $sql = "UPDATE endpointman_mac_list SET model = '".$new_model_id."' WHERE id = ". $list['id'];
- $db->query($sql);
- }
- $data = array();
- $data =& $db->getAll("SELECT * FROM endpointman_template_list",array(), DB_FETCHMODE_ASSOC);
- foreach($data as $list) {
- $new_model_id = str_replace("-", "", $list['model_id']);
- $new_product_id = str_replace("-", "", $list['product_id']);
- $sql = "UPDATE endpointman_template_list SET model_id = '".$new_model_id."', product_id = '".$new_product_id."' WHERE id = ". $list['id'];
- $db->query($sql);
- }
- $data = array();
- $data =& $db->getAll("SELECT * FROM endpointman_custom_configs",array(), DB_FETCHMODE_ASSOC);
- foreach($data as $list) {
- $new_product_id = str_replace("-", "", $list['product_id']);
- $sql = "UPDATE endpointman_custom_configs SET product_id = '".$new_product_id."' WHERE id = ". $list['id'];
- $db->query($sql);
- }
- }
- if ($new_install) {
- out("Creating Brand List Table");
- $sql = "CREATE TABLE IF NOT EXISTS `endpointman_brand_list` (
- `id` varchar(11) NOT NULL,
- `name` varchar(255) NOT NULL,
- `directory` varchar(255) NOT NULL,
- `cfg_ver` varchar(255) NOT NULL,
- `installed` int(1) NOT NULL DEFAULT '0',
- `hidden` int(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1";
- $db->query($sql);
- out("Creating Global Variables Table");
- $sql = "CREATE TABLE IF NOT EXISTS `endpointman_global_vars` (
- `idnum` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Index',
- `var_name` varchar(25) NOT NULL COMMENT 'Variable Name',
- `value` text NOT NULL COMMENT 'Data',
- PRIMARY KEY (`idnum`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=17";
- $db->query($sql);
- out("Locating NMAP + ARP + ASTERISK Executables");
- $nmap = find_exec("nmap");
- $arp = find_exec("arp");
- $asterisk = find_exec("asterisk");
- out("Inserting data into the global vars Table");
- $sql = "INSERT INTO `endpointman_global_vars` (`idnum`, `var_name`, `value`) VALUES
- (1, 'srvip', ''),
- (2, 'tz', ''),
- (3, 'gmtoff', ''),
- (4, 'gmthr', ''),
- (5, 'config_location', '/tftpboot/'),
- (6, 'update_server', 'http://www.provisioner.net/release/'),
- (7, 'version', '".$version."'),
- (8, 'enable_ari', '1'),
- (9, 'debug', '1'),
- (10, 'arp_location', '".$arp."'),
- (11, 'nmap_location', '".$nmap."'),
- (12, 'asterisk_location', '".$asterisk."'),
- (13, 'language', ''),
- (14, 'check_updates', '1'),
- (15, 'disable_htaccess', ''),
- (16, 'endpoint_vers', '0')";
- $db->query($sql);
- out("Creating mac list Table");
- $sql = "CREATE TABLE IF NOT EXISTS `endpointman_mac_list` (
- `id` int(10) NOT NULL AUTO_INCREMENT,
- `mac` varchar(12) DEFAULT NULL,
- `model` varchar(11) NOT NULL,
- `ext` varchar(15) DEFAULT 'Not Assigned',
- `description` varchar(20) DEFAULT NULL,
- `custom_cfg_template` int(11) NOT NULL,
- `custom_cfg_data` blob NOT NULL,
- `user_cfg_data` blob NOT NULL,
- `config_files_override` text NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `mac` (`mac`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1";
- $db->query($sql);
- out("Creating model List Table");
- $sql = "CREATE TABLE IF NOT EXISTS `endpointman_model_list` (
- `id` varchar(11) NOT NULL COMMENT 'Key ',
- `brand` int(11) NOT NULL COMMENT 'Brand',
- `model` varchar(25) NOT NULL COMMENT 'Model',
- `template_list` text NOT NULL,
- `template_data` blob NOT NULL,
- `product_id` varchar(11) NOT NULL,
- `enabled` int(1) NOT NULL DEFAULT '0',
- `hidden` int(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1";
- $db->query($sql);
- out("Creating oui List Table");
- $sql = "CREATE TABLE IF NOT EXISTS `endpointman_oui_list` (
- `id` int(30) NOT NULL AUTO_INCREMENT,
- `oui` varchar(30) DEFAULT NULL,
- `brand` int(11) NOT NULL,
- `custom` int(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- UNIQUE KEY `oui` (`oui`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1";
- $db->query($sql);
- out("Creating product List Table");
- $sql = "CREATE TABLE IF NOT EXISTS `endpointman_product_list` (
- `id` varchar(11) NOT NULL,
- `brand` int(11) NOT NULL,
- `long_name` varchar(255) NOT NULL,
- `short_name` varchar(255) NOT NULL,
- `cfg_dir` varchar(255) NOT NULL,
- `cfg_ver` varchar(255) NOT NULL,
- `hidden` int(1) NOT NULL DEFAULT '0',
- `firmware_vers` varchar(255) NOT NULL,
- `firmware_files` text NOT NULL,
- `config_files` text,
- `special_cfgs` blob NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;";
- $db->query($sql);
- out("Creating Template List Table");
- $sql = "CREATE TABLE IF NOT EXISTS `endpointman_template_list` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `product_id` varchar(11) NOT NULL,
- `model_id` varchar(10) NOT NULL,
- `name` varchar(255) NOT NULL,
- `custom_cfg_data` blob,
- `config_files_override` text,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1";
- $db->query($sql);
- out("Creating Time Zone List Table");
- $sql = "CREATE TABLE IF NOT EXISTS `endpointman_time_zones` (
- `idnum` int(11) NOT NULL auto_increment COMMENT 'Record Number',
- `tz` varchar(10) NOT NULL COMMENT 'Time Zone',
- `gmtoff` varchar(10) NOT NULL COMMENT 'Offset in Seconds',
- `gmthr` varchar(10) NOT NULL,
- PRIMARY KEY (`idnum`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=116";
- $db->query($sql);
- out("Inserting Data into table Table");
- $sql = "INSERT INTO `endpointman_time_zones` (`idnum`, `tz`, `gmtoff`, `gmthr`) VALUES
- (1, 'USA-10', '-36000', 'GMT-10:00'),
- (2, 'USA-9', '-32400', 'GMT-09:00'),
- (3, 'CAN-8', '-28800', 'GMT-08:00'),
- (4, 'MEX-8', '-28800', 'GMT-08:00'),
- (5, 'USA-8', '-28800', 'GMT-08:00'),
- (6, 'CAN-7', '-25200', 'GMT-07:00'),
- (7, 'MEX-7', '-25200', 'GMT-07:00'),
- (8, 'USA2-7', '-25200', 'GMT-07:00'),
- (9, 'USA-7', '-25200', 'GMT-07:00'),
- (10, 'CAN-6', '-21600', 'GMT-06:00'),
- (11, 'CHL-6', '-21600', 'GMT-06:00'),
- (12, 'MEX-6', '-21600', 'GMT-06:00'),
- (13, 'USA-6', '-21600', 'GMT-06:00'),
- (14, 'BHS-5', '-18000', 'GMT-05:00'),
- (15, 'CAN-5', '-18000', 'GMT-05:00'),
- (16, 'CUB-5', '-18000', 'GMT-05:00'),
- (17, 'USA-5', '-18000', 'GMT-05:00'),
- (18, 'VEN-4.5', '-16200', 'GMT-04:00'),
- (19, 'CAN-4', '-14400', 'GMT-04:00'),
- (20, 'CHL-4', '-14400', 'GMT-04:00'),
- (21, 'PRY-4', '-14400', 'GMT-04:00'),
- (22, 'BMU-4', '-14400', 'GMT-04:00'),
- (23, 'FLK-4', '-14400', 'GMT-04:00'),
- (24, 'TTB-4', '-14400', 'GMT-04:00'),
- (25, 'CAN-3.5', '-12600', 'GMT-03:30'),
- (26, 'GRL-3', '-10800', 'GMT-03:00'),
- (27, 'ARG-3', '-10800', 'GMT-03:00'),
- (28, 'BRA2-3', '-10800', 'GMT-03:00'),
- (29, 'BRA1-3', '-10800', 'GMT-03:00'),
- (30, 'BRA-2', '-7200', 'GMT-02:00'),
- (31, 'PRT-1', '-3600', 'GMT-01:00'),
- (32, 'FRO-0', '0', 'GMT'),
- (33, 'IRL-0', '0', 'GMT'),
- (34, 'PRT-0', '0', 'GMT'),
- (35, 'ESP-0', '0', 'GMT'),
- (36, 'GBR-0', '0', 'GMT'),
- (37, 'ALB+1', '3600', 'GMT+01:00'),
- (38, 'AUT+1', '3600', 'GMT+01:00'),
- (39, 'BEL+1', '3600', 'GMT+01:00'),
- (40, 'CAI+1', '3600', 'GMT+01:00'),
- (41, 'CHA+1', '3600', 'GMT+01:00'),
- (42, 'HRV+1', '3600', 'GMT+01:00'),
- (43, 'CZE+1', '3600', 'GMT+01:00'),
- (44, 'DNK+1', '3600', 'GMT+01:00'),
- (45, 'FRA+1', '3600', 'GMT+01:00'),
- (46, 'GER+1', '3600', 'GMT+01:00'),
- (47, 'HUN+1', '3600', 'GMT+01:00'),
- (48, 'ITA+1', '3600', 'GMT+01:00'),
- (49, 'LUX+1', '3600', 'GMT+01:00'),
- (50, 'MAK+1', '3600', 'GMT+01:00'),
- (51, 'NLD+1', '3600', 'GMT+01:00'),
- (52, 'NAM+1', '3600', 'GMT+01:00'),
- (53, 'NOR+1', '3600', 'GMT+01:00'),
- (54, 'POL+1', '3600', 'GMT+01:00'),
- (55, 'SVK+1', '3600', 'GMT+01:00'),
- (56, 'ESP+1', '3600', 'GMT+01:00'),
- (57, 'SWE+1', '3600', 'GMT+01:00'),
- (58, 'CHE+1', '3600', 'GMT+01:00'),
- (59, 'GIB+1', '3600', 'GMT+01:00'),
- (60, 'YUG+1', '3600', 'GMT+01:00'),
- (61, 'WAT+1', '3600', 'GMT+01:00'),
- (62, 'BLR+2', '7200', 'GMT+02:00'),
- (63, 'BGR+2', '7200', 'GMT+02:00'),
- (64, 'CYP+2', '7200', 'GMT+02:00'),
- (65, 'CAT+2', '7200', 'GMT+02:00'),
- (66, 'EGY+2', '7200', 'GMT+02:00'),
- (67, 'EST+2', '7200', 'GMT+02:00'),
- (68, 'FIN+2', '7200', 'GMT+02:00'),
- (69, 'GAZ+2', '7200', 'GMT+02:00'),
- (70, 'GRC+2', '7200', 'GMT+02:00'),
- (71, 'ISR+2', '7200', 'GMT+02:00'),
- (72, 'JOR+2', '7200', 'GMT+02:00'),
- (73, 'LVA+2', '7200', 'GMT+02:00'),
- (74, 'LBN+2', '7200', 'GMT+02:00'),
- (75, 'MDA+2', '7200', 'GMT+02:00'),
- (76, 'RUS+2', '7200', 'GMT+02:00'),
- (77, 'ROU+2', '7200', 'GMT+02:00'),
- (78, 'SYR+2', '7200', 'GMT+02:00'),
- (79, 'TUR+2', '7200', 'GMT+02:00'),
- (80, 'UKR+2', '7200', 'GMT+02:00'),
- (81, 'EAT+3', '10800', 'GMT+03:00'),
- (82, 'IRQ+3', '10800', 'GMT+03:00'),
- (83, 'RUS+3', '10800', 'GMT+03:00'),
- (84, 'IRN+3.5', '12600', 'GMT+03:30'),
- (85, 'ARM+4', '14400', 'GMT+04:00'),
- (86, 'AZE+4', '14400', 'GMT+04:00'),
- (87, 'GEO+4', '14400', 'GMT+04:00'),
- (88, 'KAZ+4', '14400', 'GMT+04:00'),
- (89, 'RUS+4', '14400', 'GMT+04:00'),
- (90, 'KAZ+5', '18000', 'GMT+05:00'),
- (91, 'KGZ+5', '18000', 'GMT+05:00'),
- (92, 'PAK+5', '18000', 'GMT+05:00'),
- (93, 'RUS+5', '18000', 'GMT+05:00'),
- (94, 'IND+5.5', '19800', 'GMT+05:30'),
- (95, 'KAZ+6', '21600', 'GMT+06:00'),
- (96, 'RUS+6', '21600', 'GMT+06:00'),
- (97, 'RUS+7', '25200', 'GMT+07:00'),
- (98, 'THA+7', '25200', 'GMT+07:00'),
- (99, 'CHN+7', '25200', 'GMT+07:00'),
- (100, 'SGP+8', '28800', 'GMT+08:00'),
- (101, 'KOR+8', '28800', 'GMT+08:00'),
- (102, 'AUS+8', '28800', 'GMT+08:00'),
- (103, 'JPN+9', '32400', 'GMT+09:00'),
- (104, 'AUS+9.5', '34200', 'GMT+09:30'),
- (105, 'AUS2+9.5', '34200', 'GMT+09:30'),
- (106, 'AUS+10', '36000', 'GMT+10:00'),
- (107, 'AUS2+10', '36000', 'GMT+10:00'),
- (108, 'AUS3+10', '36000', 'GMT+10:00'),
- (109, 'RUS+10', '36000', 'GMT+10:00'),
- (110, 'AUS+10.5', '37800', 'GMT+10:30'),
- (111, 'NCL+11', '39600', 'GMT+11:00'),
- (112, 'NZL+12', '43200', 'GMT+12:00'),
- (113, 'RUS+12', '43200', 'GMT+12:00'),
- (114, 'NZL+12.75', '45900', 'GMT+12:00'),
- (115, 'TON+13', '46800', 'GMT+13:00')";
- $db->query($sql);
- out("Create Custom Configs Table");
- $sql = "CREATE TABLE IF NOT EXISTS `endpointman_custom_configs` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(255) NOT NULL,
- `original_name` varchar(255) NOT NULL,
- `product_id` varchar(11) NOT NULL,
- `data` blob NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1";
- $db->query($sql);
- if(file_exists($amp_conf['AMPWEBROOT']."/recordings")) {
- out("Installing ARI Module");
- copy(LOCAL_PATH. "Install/phonesettings.module", $amp_conf['AMPWEBROOT']."/recordings/modules/phonesettings.module");
- copy(LOCAL_PATH. "templates/javascript/jquery.coda-slider-2.0.js", $amp_conf['AMPWEBROOT']."/recordings/theme/js/jquery.coda-slider-2.0.js");
- copy(LOCAL_PATH. "templates/javascript/jquery.easing.1.3.js", $amp_conf['AMPWEBROOT']."/recordings/theme/js/jquery.easing.1.3.js");
- copy(LOCAL_PATH. "templates/stylesheets/coda-slider-2.0a.css", $amp_conf['AMPWEBROOT']."/recordings/theme/coda-slider-2.0a.css");
- out("Fixing permissions on ARI module");
- chmod($amp_conf['AMPWEBROOT']."/recordings/modules/phonesettings.module", 0664);
- }
- } else {
- out("Update Version Number");
- $sql = "UPDATE endpointman_global_vars SET value = '".$version."' WHERE var_name = 'version'";
- $db->query($sql);
- }